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 307549 in lives
id
Primary key.
INTEGER
live_id
191612
TEXT NOT NULL
title
市值前百种币82涨18跌
TEXT
content
【市值前百种币82涨18跌】金色财经行情显示，BTC今日价格在10193.44-9905.96美元之间波动，市场整体上行。市值前百币种82涨18跌，其中涨幅前三的币种分别为：UTK 涨幅27.09%，GNO 涨幅24.53%，MCO 涨幅17.27%；跌幅前三的币种为：UBT 跌幅-6.76%，MONA 跌幅-6.45%，BTS 跌幅-3.88%。
TEXT
content_prefix
市值前百种币82涨18跌
TEXT
published_date
2020-09-09
TEXT
link_name
TEXT
link
TEXT
grade
INTEGER
created_at
2020-09-09 19:05:28
TEXT
created_at_unix
INTEGER
created_at_zh
2020-09-09
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": "金色财经行情显示，市场整体上行。市值前百币种82涨18跌。", "bottom_text": "", "title": "市值前百种币82涨18跌", "coins": [{"name": "UTK", "price": "$0.15", "plate_name": "", "currency": "$", "direction": "up", "list": [{"name": "24H涨幅", "value": "27.09", "direction": "up"}, {"name": "成交量", "value": "3248.06", "direction": ""}, {"name": "最高价", "value": "$0.16", "direction": ""}, {"name": "最低价", "value": "$0.11", "direction": ""}], "slug": "utrust"}, {"name": "GNO", "price": "$62.81", "plate_name": "", "currency": "$", "direction": "up", "list": [{"name": "24H涨幅", "value": "24.53", "direction": "up"}, {"name": "成交量", "value": "2.36", "direction": ""}, {"name": "最高价", "value": "$63.06", "direction": ""}, {"name": "最低价", "value": "$48.23", "direction": ""}], "slug": "gnosis-gno"}, {"name": "MCO", "price": "$4.74", "plate_name": "", "currency": "$", "direction": "up", "list": [{"name": "24H涨幅", "value": "17.27", "direction": "up"}, {"name": "成交量", "value": "257.51", "direction": ""}, {"name": "最高价", "value": "$4.94", "direction": ""}, {"name": "最低价", "value": "$4", "direction": ""}], "slug": "monaco"}, {"name": "UBT", "price": "$0.34", "plate_name": "", "currency": "$", "direction": "down", "list": [{"name": "24H跌幅", "value": "6.76", "direction": "down"}, {"name": "成交量", "value": "255.95", "direction": ""}, {"name": "最高价", "value": "$0.37", "direction": ""}, {"name": "最低价", "value": "$0.3", "direction": ""}], "slug": "unibright"}, {"name": "MONA", "price": "$1.4", "plate_name": "", "currency": "$", "direction": "down", "list": [{"name": "24H跌幅", "value": "6.45", "direction": "down"}, {"name": "成交量", "value": "377.92", "direction": ""}, {"name": "最高价", "value": "$1.51", "direction": ""}, {"name": "最低价", "value": "$1.36", "direction": ""}], "slug": "monacoin"}, {"name": "BTS", "price": "$0.05", "plate_name": "", "currency": "$", "direction": "down", "list": [{"name": "24H跌幅", "value": "3.88", "direction": "down"}, {"name": "成交量", "value": "104575.61", "direction": ""}, {"name": "最高价", "value": "$0.05", "direction": ""}, {"name": "最低价", "value": "$0.04", "direction": ""}], "slug": "bitshares"}]}
TEXT
is_show_comment
INTEGER
is_forbid_comment
INTEGER
show_source_name
TEXT
vote_id
INTEGER
vote
{"vote_id": 294, "title": "今天上涨币种数量占绝对优势，行情是否能够企稳反转？", "is_limit_time": 1, "end_time": "2020-09-09 23:03:01", "is_multiple": 2, "state": 3, "created_at": "2020-09-09 19:05:21", "is_vote": false, "is_pk": 0, "option": [{"option_id": "1599649521416000", "vote_id": 294, "title": "抄底信号，买买买！", "is_vote": false, "count": 18, "total": "35%"}, {"option_id": "1599649521420000", "vote_id": 294, "title": "美股尚未企稳，还需观望", "is_vote": false, "count": 19, "total": "37%"}, {"option_id": "1599649521423000", "vote_id": 294, "title": "我才不买，下跌不言底！", "is_vote": false, "count": 14, "total": "27%"}]}
TEXT
zan_status
TEXT
readings
[]
TEXT
word_blocks
[]
TEXT
raw_data
{"id": 191612, "content": "【市值前百种币82涨18跌】金色财经行情显示，BTC今日价格在10193.44-9905.96美元之间波动，市场整体上行。市值前百币种82涨18跌，其中涨幅前三的币种分别为：UTK 涨幅27.09%，GNO 涨幅24.53%，MCO 涨幅17.27%；跌幅前三的币种为：UBT 跌幅-6.76%，MONA 跌幅-6.45%，BTS 跌幅-3.88%。", "content_prefix": "市值前百种币82涨18跌", "link_name": "", "link": "", "grade": 4, "sort": "", "category": 0, "highlight_color": "", "images": [], "created_at": 1599649528, "created_at_zh": "2020-09-09", "attribute": "", "up_counts": 207, "down_counts": 227, "zan_status": "", "readings": [], "extra_type": 1, "extra": {"head_text": "金色财经行情显示，市场整体上行。市值前百币种82涨18跌。", "bottom_text": "", "title": "市值前百种币82涨18跌", "coins": [{"name": "UTK", "price": "$0.15", "plate_name": "", "currency": "$", "direction": "up", "list": [{"name": "24H涨幅", "value": "27.09", "direction": "up"}, {"name": "成交量", "value": "3248.06", "direction": ""}, {"name": "最高价", "value": "$0.16", "direction": ""}, {"name": "最低价", "value": "$0.11", "direction": ""}], "slug": "utrust"}, {"name": "GNO", "price": "$62.81", "plate_name": "", "currency": "$", "direction": "up", "list": [{"name": "24H涨幅", "value": "24.53", "direction": "up"}, {"name": "成交量", "value": "2.36", "direction": ""}, {"name": "最高价", "value": "$63.06", "direction": ""}, {"name": "最低价", "value": "$48.23", "direction": ""}], "slug": "gnosis-gno"}, {"name": "MCO", "price": "$4.74", "plate_name": "", "currency": "$", "direction": "up", "list": [{"name": "24H涨幅", "value": "17.27", "direction": "up"}, {"name": "成交量", "value": "257.51", "direction": ""}, {"name": "最高价", "value": "$4.94", "direction": ""}, {"name": "最低价", "value": "$4", "direction": ""}], "slug": "monaco"}, {"name": "UBT", "price": "$0.34", "plate_name": "", "currency": "$", "direction": "down", "list": [{"name": "24H跌幅", "value": "6.76", "direction": "down"}, {"name": "成交量", "value": "255.95", "direction": ""}, {"name": "最高价", "value": "$0.37", "direction": ""}, {"name": "最低价", "value": "$0.3", "direction": ""}], "slug": "unibright"}, {"name": "MONA", "price": "$1.4", "plate_name": "", "currency": "$", "direction": "down", "list": [{"name": "24H跌幅", "value": "6.45", "direction": "down"}, {"name": "成交量", "value": "377.92", "direction": ""}, {"name": "最高价", "value": "$1.51", "direction": ""}, {"name": "最低价", "value": "$1.36", "direction": ""}], "slug": "monacoin"}, {"name": "BTS", "price": "$0.05", "plate_name": "", "currency": "$", "direction": "down", "list": [{"name": "24H跌幅", "value": "3.88", "direction": "down"}, {"name": "成交量", "value": "104575.61", "direction": ""}, {"name": "最高价", "value": "$0.05", "direction": ""}, {"name": "最低价", "value": "$0.04", "direction": ""}], "slug": "bitshares"}]}, "prev": null, "next": null, "word_blocks": [], "is_show_comment": 1, "is_forbid_comment": 0, "comment_count": 2, "analyst_user": null, "show_source_name": "", "vote_id": 294, "vote": {"vote_id": 294, "title": "今天上涨币种数量占绝对优势，行情是否能够企稳反转？", "is_limit_time": 1, "end_time": "2020-09-09 23:03:01", "is_multiple": 2, "state": 3, "created_at": "2020-09-09 19:05:21", "is_vote": false, "is_pk": 0, "option": [{"option_id": "1599649521416000", "vote_id": 294, "title": "抄底信号，买买买！", "is_vote": false, "count": 18, "total": "35%"}, {"option_id": "1599649521420000", "vote_id": 294, "title": "美股尚未企稳，还需观望", "is_vote": false, "count": 19, "total": "37%"}, {"option_id": "1599649521423000", "vote_id": 294, "title": "我才不买，下跌不言底！", "is_vote": false, "count": 14, "total": "27%"}]}, "date": "2020-09-09"}
TEXT
saved_at
TIMESTAMP (default CURRENT_TIMESTAMP
Update
Cancel