sqlite-web 0.7.2
jinse.db
lives
Create
Query
lives
sqlite_sequence
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Update row 293853 in lives
id
Primary key.
INTEGER
live_id
205745
TEXT NOT NULL
title
市值前百种币80涨20跌
TEXT
content
【市值前百种币80涨20跌】金色财经行情显示，BTC今日价格在16879.38-16241.22美元之间波动，市场整体上行。市值前百币种80涨20跌，其中涨幅前三的币种分别为：BNT涨幅21.99%，KAVA涨幅11.59%，YFI涨幅10.73%；跌幅前三的币种为：UNI跌幅-8.01%，SEELE跌幅-6.31%，UTK跌幅-5.36%。
TEXT
content_prefix
市值前百种币80涨20跌
TEXT
published_date
2020-11-17
TEXT
link_name
TEXT
link
TEXT
grade
INTEGER
created_at
2020-11-17 19:00:36
TEXT
created_at_unix
INTEGER
created_at_zh
2020-11-17
TEXT
updated_at
TEXT
source
TEXT
category
INTEGER
reading
INTEGER (default 0
flag
TEXT
attribute
TEXT
up_counts
INTEGER
down_counts
INTEGER
comment_count
INTEGER
highlight_color
TEXT
images
[]
TEXT
extra_type
INTEGER
extra
{"head_text": "金色财经行情显示，市场整体上行。市值前百币种80涨20跌。", "bottom_text": "", "title": "市值前百种币80涨20跌", "coins": [{"name": "BNT", "price": "$0.9", "plate_name": "", "currency": "$", "direction": "up", "list": [{"name": "24H涨幅", "value": "21.99", "direction": "up"}, {"name": "成交量", "value": "10141.84", "direction": ""}, {"name": "最高价", "value": "$0.91", "direction": ""}, {"name": "最低价", "value": "$0.72", "direction": ""}], "slug": "bancor"}, {"name": "KAVA", "price": "$1.9", "plate_name": "", "currency": "$", "direction": "up", "list": [{"name": "24H涨幅", "value": "11.59", "direction": "up"}, {"name": "成交量", "value": "2297.08", "direction": ""}, {"name": "最高价", "value": "$1.99", "direction": ""}, {"name": "最低价", "value": "$1.63", "direction": ""}], "slug": "kava"}, {"name": "YFI", "price": "$20111.63", "plate_name": "", "currency": "$", "direction": "up", "list": [{"name": "24H涨幅", "value": "10.73", "direction": "up"}, {"name": "成交量", "value": "4.54", "direction": ""}, {"name": "最高价", "value": "$20660.55", "direction": ""}, {"name": "最低价", "value": "$17818.43", "direction": ""}], "slug": "yearnfinance"}, {"name": "UNI", "price": "$3.59", "plate_name": "", "currency": "$", "direction": "down", "list": [{"name": "24H跌幅", "value": "8.01", "direction": "down"}, {"name": "成交量", "value": "31033.32", "direction": ""}, {"name": "最高价", "value": "$3.9", "direction": ""}, {"name": "最低价", "value": "$3.46", "direction": ""}], "slug": "uniswap"}, {"name": "SEELE", "price": "$0.01", "plate_name": "", "currency": "$", "direction": "down", "list": [{"name": "24H跌幅", "value": "6.31", "direction": "down"}, {"name": "成交量", "value": "139789.33", "direction": ""}, {"name": "最高价", "value": "$0.02", "direction": ""}, {"name": "最低价", "value": "$0.01", "direction": ""}], "slug": "seele"}, {"name": "UTK", "price": "$0.13", "plate_name": "", "currency": "$", "direction": "down", "list": [{"name": "24H跌幅", "value": "5.36", "direction": "down"}, {"name": "成交量", "value": "1865.17", "direction": ""}, {"name": "最高价", "value": "$0.14", "direction": ""}, {"name": "最低价", "value": "$0.13", "direction": ""}], "slug": "utrust"}]}
TEXT
is_show_comment
INTEGER
is_forbid_comment
INTEGER
show_source_name
TEXT
vote_id
INTEGER
vote
{"vote_id": 820, "title": "行情再度进入极度强势格局，能追涨吗？", "is_limit_time": 1, "end_time": "2020-11-17 23:25:11", "is_multiple": 1, "state": 3, "created_at": "2020-11-17 19:25:57", "is_vote": false, "is_pk": 0, "option": [{"option_id": "1605612358028000", "vote_id": 820, "title": "能，市场没有见顶信号，不能错过。", "is_vote": false, "count": 22, "total": "49%"}, {"option_id": "1605612358032000", "vote_id": 820, "title": "调整再介入，追涨不具备价格优势。", "is_vote": false, "count": 3, "total": "7%"}, {"option_id": "1605612358035000", "vote_id": 820, "title": "诱多行情，不能再追涨了。", "is_vote": false, "count": 13, "total": "29%"}, {"option_id": "1605612358039000", "vote_id": 820, "title": "加速上涨行情更适合做空。", "is_vote": false, "count": 6, "total": "13%"}, {"option_id": "1605612358042000", "vote_id": 820, "title": "其他。", "is_vote": false, "count": 1, "total": "2%"}]}
TEXT
zan_status
TEXT
readings
[]
TEXT
word_blocks
[]
TEXT
raw_data
{"id": 205745, "content": "【市值前百种币80涨20跌】金色财经行情显示，BTC今日价格在16879.38-16241.22美元之间波动，市场整体上行。市值前百币种80涨20跌，其中涨幅前三的币种分别为：BNT涨幅21.99%，KAVA涨幅11.59%，YFI涨幅10.73%；跌幅前三的币种为：UNI跌幅-8.01%，SEELE跌幅-6.31%，UTK跌幅-5.36%。", "content_prefix": "市值前百种币80涨20跌", "link_name": "", "link": "", "grade": 4, "sort": "", "category": 0, "highlight_color": "", "images": [], "created_at": 1605610836, "created_at_zh": "2020-11-17", "attribute": "", "up_counts": 151, "down_counts": 233, "zan_status": "", "readings": [], "extra_type": 1, "extra": {"head_text": "金色财经行情显示，市场整体上行。市值前百币种80涨20跌。", "bottom_text": "", "title": "市值前百种币80涨20跌", "coins": [{"name": "BNT", "price": "$0.9", "plate_name": "", "currency": "$", "direction": "up", "list": [{"name": "24H涨幅", "value": "21.99", "direction": "up"}, {"name": "成交量", "value": "10141.84", "direction": ""}, {"name": "最高价", "value": "$0.91", "direction": ""}, {"name": "最低价", "value": "$0.72", "direction": ""}], "slug": "bancor"}, {"name": "KAVA", "price": "$1.9", "plate_name": "", "currency": "$", "direction": "up", "list": [{"name": "24H涨幅", "value": "11.59", "direction": "up"}, {"name": "成交量", "value": "2297.08", "direction": ""}, {"name": "最高价", "value": "$1.99", "direction": ""}, {"name": "最低价", "value": "$1.63", "direction": ""}], "slug": "kava"}, {"name": "YFI", "price": "$20111.63", "plate_name": "", "currency": "$", "direction": "up", "list": [{"name": "24H涨幅", "value": "10.73", "direction": "up"}, {"name": "成交量", "value": "4.54", "direction": ""}, {"name": "最高价", "value": "$20660.55", "direction": ""}, {"name": "最低价", "value": "$17818.43", "direction": ""}], "slug": "yearnfinance"}, {"name": "UNI", "price": "$3.59", "plate_name": "", "currency": "$", "direction": "down", "list": [{"name": "24H跌幅", "value": "8.01", "direction": "down"}, {"name": "成交量", "value": "31033.32", "direction": ""}, {"name": "最高价", "value": "$3.9", "direction": ""}, {"name": "最低价", "value": "$3.46", "direction": ""}], "slug": "uniswap"}, {"name": "SEELE", "price": "$0.01", "plate_name": "", "currency": "$", "direction": "down", "list": [{"name": "24H跌幅", "value": "6.31", "direction": "down"}, {"name": "成交量", "value": "139789.33", "direction": ""}, {"name": "最高价", "value": "$0.02", "direction": ""}, {"name": "最低价", "value": "$0.01", "direction": ""}], "slug": "seele"}, {"name": "UTK", "price": "$0.13", "plate_name": "", "currency": "$", "direction": "down", "list": [{"name": "24H跌幅", "value": "5.36", "direction": "down"}, {"name": "成交量", "value": "1865.17", "direction": ""}, {"name": "最高价", "value": "$0.14", "direction": ""}, {"name": "最低价", "value": "$0.13", "direction": ""}], "slug": "utrust"}]}, "prev": null, "next": null, "word_blocks": [], "is_show_comment": 1, "is_forbid_comment": 0, "comment_count": 3, "analyst_user": null, "show_source_name": "", "vote_id": 820, "vote": {"vote_id": 820, "title": "行情再度进入极度强势格局，能追涨吗？", "is_limit_time": 1, "end_time": "2020-11-17 23:25:11", "is_multiple": 1, "state": 3, "created_at": "2020-11-17 19:25:57", "is_vote": false, "is_pk": 0, "option": [{"option_id": "1605612358028000", "vote_id": 820, "title": "能，市场没有见顶信号，不能错过。", "is_vote": false, "count": 22, "total": "49%"}, {"option_id": "1605612358032000", "vote_id": 820, "title": "调整再介入，追涨不具备价格优势。", "is_vote": false, "count": 3, "total": "7%"}, {"option_id": "1605612358035000", "vote_id": 820, "title": "诱多行情，不能再追涨了。", "is_vote": false, "count": 13, "total": "29%"}, {"option_id": "1605612358039000", "vote_id": 820, "title": "加速上涨行情更适合做空。", "is_vote": false, "count": 6, "total": "13%"}, {"option_id": "1605612358042000", "vote_id": 820, "title": "其他。", "is_vote": false, "count": 1, "total": "2%"}]}, "date": "2020-11-17"}
TEXT
saved_at
TIMESTAMP (default CURRENT_TIMESTAMP
Update
Cancel