flip_raw

99,824 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: side, coin, duration, threshold, reached, flipped

Next page

CREATE TABLE flip_raw (
            slug       TEXT NOT NULL,
            side       TEXT NOT NULL,
            coin       TEXT NOT NULL,
            duration   TEXT NOT NULL,
            market_end INTEGER NOT NULL,
            threshold  REAL NOT NULL,
            reached    INTEGER NOT NULL,
            flipped    INTEGER NOT NULL,
            PRIMARY KEY (slug, side, threshold)
        );
CREATE INDEX idx_flip_raw_lookup
        ON flip_raw(coin, duration, market_end)
    ;