PREVIEW / etf_30min / 2000-05-02
file: by_date/etf_30min/2000/2000-05-02.parquet size: 10 KB rows: 206
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2000-05-02 09:30:00 | SPY | ETF | 145.5 | 146.4688 | 145.5 | 146.375 | 901800.0 |
| 2000-05-02 10:00:00 | SPY | ETF | 146.25 | 146.625 | 145.75 | 146.2188 | 566000.0 |
| 2000-05-02 10:30:00 | SPY | ETF | 146.0 | 146.4375 | 145.875 | 145.9688 | 179800.0 |
| 2000-05-02 11:00:00 | SPY | ETF | 146.0938 | 146.5938 | 146.0625 | 146.25 | 96100.0 |
| 2000-05-02 11:30:00 | SPY | ETF | 146.2188 | 146.625 | 145.875 | 146.4375 | 405100.0 |
| 2000-05-02 12:00:00 | SPY | ETF | 146.4688 | 146.6875 | 146.2188 | 146.5625 | 127800.0 |
| 2000-05-02 12:30:00 | SPY | ETF | 146.6562 | 147.125 | 146.4688 | 146.5625 | 1363100.0 |
| 2000-05-02 13:00:00 | SPY | ETF | 146.4688 | 146.8125 | 146.4062 | 146.6875 | 608500.0 |
| 2000-05-02 13:30:00 | SPY | ETF | 146.6875 | 146.8438 | 146.1875 | 146.3125 | 291300.0 |
| 2000-05-02 14:00:00 | SPY | ETF | 146.125 | 146.2188 | 145.5 | 145.5 | 1096100.0 |
| 2000-05-02 14:30:00 | SPY | ETF | 145.5 | 145.8125 | 145.25 | 145.25 | 477100.0 |
| 2000-05-02 15:00:00 | SPY | ETF | 145.4375 | 145.9375 | 145.2188 | 145.375 | 881100.0 |
| 2000-05-02 15:30:00 | SPY | ETF | 145.3125 | 145.6875 | 144.5 | 144.625 | 1292800.0 |
| 2000-05-02 16:00:00 | SPY | ETF | 144.5625 | 144.6875 | 144.125 | 144.1562 | 783700.0 |
| 2000-05-02 17:00:00 | SPY | ETF | 144.125 | 144.125 | 144.125 | 144.125 | 700.0 |
| 2000-05-02 09:30:00 | QQQ | ETF | 94.875 | 95.25 | 94.0312 | 95.0 | 2800600.0 |
| 2000-05-02 10:00:00 | QQQ | ETF | 95.1875 | 95.375 | 94.25 | 94.4375 | 1774100.0 |
| 2000-05-02 10:30:00 | QQQ | ETF | 94.5625 | 94.8125 | 94.1875 | 94.625 | 996600.0 |
| 2000-05-02 11:00:00 | QQQ | ETF | 94.5625 | 95.125 | 94.4062 | 94.5 | 478000.0 |
| 2000-05-02 11:30:00 | QQQ | ETF | 94.5 | 94.9375 | 94.25 | 94.7812 | 888200.0 |
| 2000-05-02 12:00:00 | QQQ | ETF | 94.75 | 95.1875 | 94.5625 | 95.1875 | 1431700.0 |
| 2000-05-02 12:30:00 | QQQ | ETF | 95.125 | 95.625 | 95.0 | 95.0625 | 1202800.0 |
| 2000-05-02 13:00:00 | QQQ | ETF | 95.0625 | 95.25 | 94.625 | 95.0 | 490600.0 |
| 2000-05-02 13:30:00 | QQQ | ETF | 95.0 | 95.125 | 94.5625 | 94.5625 | 721100.0 |
| 2000-05-02 14:00:00 | QQQ | ETF | 94.5625 | 94.6875 | 93.625 | 93.625 | 1273500.0 |
| 2000-05-02 14:30:00 | QQQ | ETF | 93.625 | 93.9375 | 92.6875 | 92.75 | 1982700.0 |
| 2000-05-02 15:00:00 | QQQ | ETF | 92.75 | 93.6875 | 92.4375 | 92.6875 | 2196700.0 |
| 2000-05-02 15:30:00 | QQQ | ETF | 92.875 | 92.875 | 90.5 | 90.5 | 3307000.0 |
| 2000-05-02 16:00:00 | QQQ | ETF | 90.625 | 90.75 | 90.0 | 90.0 | 687500.0 |
| 2000-05-02 16:30:00 | QQQ | ETF | 90.0625 | 90.25 | 90.0 | 90.0 | 2000.0 |
| 2000-05-02 17:00:00 | QQQ | ETF | 90.0 | 90.0 | 89.75 | 89.75 | 1500.0 |
| 2000-05-02 17:30:00 | QQQ | ETF | 90.0 | 90.25 | 90.0 | 90.0 | 1500.0 |
| 2000-05-02 18:00:00 | QQQ | ETF | 90.5 | 90.5 | 90.0 | 90.125 | 1500.0 |
| 2000-05-02 09:30:00 | DIA | ETF | 107.5 | 107.625 | 106.8125 | 107.625 | 121200.0 |
| 2000-05-02 10:00:00 | DIA | ETF | 107.5 | 107.75 | 107.1562 | 107.3125 | 55400.0 |
| 2000-05-02 10:30:00 | DIA | ETF | 107.4062 | 107.6875 | 107.2188 | 107.375 | 41800.0 |
| 2000-05-02 11:00:00 | DIA | ETF | 107.5938 | 107.8438 | 107.4688 | 107.5938 | 22700.0 |
| 2000-05-02 11:30:00 | DIA | ETF | 107.5 | 107.8125 | 107.4375 | 107.625 | 25200.0 |
| 2000-05-02 12:00:00 | DIA | ETF | 107.625 | 107.9062 | 107.625 | 107.9062 | 53100.0 |
| 2000-05-02 12:30:00 | DIA | ETF | 107.9688 | 108.2188 | 107.7812 | 108.0312 | 49300.0 |
| 2000-05-02 13:00:00 | DIA | ETF | 108.0 | 108.125 | 107.8125 | 108.0 | 25800.0 |
| 2000-05-02 13:30:00 | DIA | ETF | 107.875 | 108.0625 | 107.5625 | 107.5625 | 7200.0 |
| 2000-05-02 14:00:00 | DIA | ETF | 107.5 | 107.6562 | 107.25 | 107.25 | 21700.0 |
| 2000-05-02 14:30:00 | DIA | ETF | 107.25 | 107.5625 | 107.0625 | 107.3125 | 45100.0 |
| 2000-05-02 15:00:00 | DIA | ETF | 107.3125 | 107.6562 | 107.0625 | 107.3438 | 39600.0 |
| 2000-05-02 15:30:00 | DIA | ETF | 107.2812 | 107.5938 | 107.1562 | 107.25 | 71200.0 |
| 2000-05-02 16:00:00 | DIA | ETF | 107.3438 | 107.3438 | 106.9375 | 107.0625 | 80500.0 |
> showing 47 of 206 rows — these rows as CSV