SQLite Web: jinse.db

id

Primary key. INTEGER

live_id

TEXT NOT NULL

title

TEXT

content

TEXT

content_prefix

TEXT

published_date

TEXT

link_name

TEXT

link

TEXT

grade

INTEGER

created_at

TEXT

created_at_unix

INTEGER

created_at_zh

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

TEXT

is_show_comment

INTEGER

is_forbid_comment

INTEGER

show_source_name

TEXT

vote_id

INTEGER

vote

TEXT

zan_status

TEXT

readings

TEXT

word_blocks

TEXT

raw_data

{"id": 99798, "content": "【分析 | Coinbase非BTC下跌真凶 Bitfinex连续大额卖单导演此次瀑布】BTC价格早间从$8500下挫至$7900左右，市场对此有较多解读，其中呼声较高的是来自Coinbase的砸盘。TokenGazer基于严谨的数据分析，得到一些有意思的数据：在BTC下跌期间（UTC 3日22点—4日2点），Bitfinex交易所中的卖单数量（20624）远超买单数量（15465），Coinbase的卖单数量（20698）少于买单数量（23896）；Bitfinex的交易量（13443.42BTC）逼近Coinbase（14235.12BTC），而据TokenGazer往期观察，Coinbase成交量约为Bitfinex的1.5倍；在这个时间点Bitfinex最大抛盘为393.246BTC，Coinbase为41.6454BTC，Bitfinex的抛盘数额较大且较为密集，详细图表分析可查阅TokenGazer官网；基于以上数据支撑，TokenGazer认为：此次BTC的下跌，大概率是Bitfinex导致，而非Coinbase。", "content_prefix": "分析 | Coinbase非BTC下跌真凶 Bitfinex连续大额卖单导演此次瀑布", "link_name": "", "link": "", "grade": 4, "sort": "分析", "category": 0, "highlight_color": "", "images": [], "created_at": 1559643044, "created_at_zh": "2019-06-04", "attribute": "精选", "up_counts": 404, "down_counts": 129, "zan_status": "", "readings": [], "extra_type": 0, "extra": null, "prev": null, "next": null, "word_blocks": [], "is_show_comment": 0, "is_forbid_comment": 1, "comment_count": 0, "analyst_user": null, "show_source_name": "", "vote_id": 0, "vote": null, "date": "2019-06-04"}

TEXT

saved_at

TIMESTAMP (default CURRENT_TIMESTAMP

Update row 385102 in lives