PREVIEW / etf_30min / 2000-05-08
file: by_date/etf_30min/2000/2000-05-08.parquet size: 9 KB rows: 203
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-08 09:30:00 | SPY | ETF | 142.75 | 142.9375 | 142.0312 | 142.875 | 1077100.0 |
| 2000-05-08 10:00:00 | SPY | ETF | 142.9375 | 142.9375 | 142.25 | 142.625 | 327200.0 |
| 2000-05-08 10:30:00 | SPY | ETF | 142.6875 | 143.3438 | 142.3125 | 143.1875 | 684900.0 |
| 2000-05-08 11:00:00 | SPY | ETF | 143.3125 | 143.375 | 142.8125 | 143.0 | 154400.0 |
| 2000-05-08 11:30:00 | SPY | ETF | 143.0 | 143.2188 | 142.7188 | 142.875 | 86300.0 |
| 2000-05-08 12:00:00 | SPY | ETF | 142.7188 | 142.875 | 142.5625 | 142.625 | 131300.0 |
| 2000-05-08 12:30:00 | SPY | ETF | 142.8438 | 143.0 | 142.5625 | 142.8438 | 188800.0 |
| 2000-05-08 13:00:00 | SPY | ETF | 142.875 | 142.875 | 142.0938 | 142.3125 | 338300.0 |
| 2000-05-08 13:30:00 | SPY | ETF | 142.2812 | 142.7188 | 142.2812 | 142.7188 | 44700.0 |
| 2000-05-08 14:00:00 | SPY | ETF | 142.75 | 142.75 | 142.0 | 142.0 | 269000.0 |
| 2000-05-08 14:30:00 | SPY | ETF | 142.125 | 142.375 | 141.8438 | 142.1875 | 533500.0 |
| 2000-05-08 15:00:00 | SPY | ETF | 142.0 | 142.875 | 142.0 | 142.625 | 282600.0 |
| 2000-05-08 15:30:00 | SPY | ETF | 142.6562 | 143.2188 | 142.4375 | 142.5312 | 378600.0 |
| 2000-05-08 16:00:00 | SPY | ETF | 142.5312 | 142.625 | 142.25 | 142.4375 | 534000.0 |
| 2000-05-08 16:30:00 | SPY | ETF | 142.4375 | 142.4375 | 142.4375 | 142.4375 | 100.0 |
| 2000-05-08 09:30:00 | QQQ | ETF | 90.5 | 90.75 | 89.0625 | 90.0625 | 2041900.0 |
| 2000-05-08 10:00:00 | QQQ | ETF | 90.0 | 90.0938 | 89.0 | 89.3125 | 1420700.0 |
| 2000-05-08 10:30:00 | QQQ | ETF | 89.25 | 90.125 | 88.875 | 90.0625 | 1202200.0 |
| 2000-05-08 11:00:00 | QQQ | ETF | 90.0 | 90.4375 | 89.625 | 89.875 | 830800.0 |
| 2000-05-08 11:30:00 | QQQ | ETF | 89.8125 | 89.9062 | 89.4375 | 89.5 | 362100.0 |
| 2000-05-08 12:00:00 | QQQ | ETF | 89.5 | 89.625 | 89.125 | 89.1875 | 330700.0 |
| 2000-05-08 12:30:00 | QQQ | ETF | 89.1875 | 89.625 | 89.125 | 89.4375 | 413600.0 |
| 2000-05-08 13:00:00 | QQQ | ETF | 89.4375 | 89.75 | 88.6875 | 89.125 | 752900.0 |
| 2000-05-08 13:30:00 | QQQ | ETF | 89.0 | 89.25 | 88.75 | 89.25 | 621400.0 |
| 2000-05-08 14:00:00 | QQQ | ETF | 89.25 | 89.375 | 88.125 | 88.125 | 814600.0 |
| 2000-05-08 14:30:00 | QQQ | ETF | 88.125 | 88.75 | 88.125 | 88.1875 | 739900.0 |
| 2000-05-08 15:00:00 | QQQ | ETF | 88.125 | 89.5 | 88.0625 | 88.9375 | 1577300.0 |
| 2000-05-08 15:30:00 | QQQ | ETF | 89.0 | 89.625 | 88.0625 | 88.0625 | 1847300.0 |
| 2000-05-08 16:00:00 | QQQ | ETF | 88.0625 | 88.1875 | 87.75 | 88.0625 | 830700.0 |
| 2000-05-08 16:30:00 | QQQ | ETF | 88.0 | 88.25 | 88.0 | 88.25 | 2500.0 |
| 2000-05-08 17:30:00 | QQQ | ETF | 88.0 | 88.0 | 87.75 | 87.75 | 1500.0 |
| 2000-05-08 18:00:00 | QQQ | ETF | 87.875 | 87.875 | 87.875 | 87.875 | 400.0 |
| 2000-05-08 09:30:00 | DIA | ETF | 105.25 | 105.875 | 105.0 | 105.7188 | 109300.0 |
| 2000-05-08 10:00:00 | DIA | ETF | 105.5312 | 105.8438 | 105.2188 | 105.4688 | 45600.0 |
| 2000-05-08 10:30:00 | DIA | ETF | 105.5938 | 106.375 | 105.5312 | 106.1562 | 61400.0 |
| 2000-05-08 11:00:00 | DIA | ETF | 106.3125 | 106.3125 | 105.875 | 105.9375 | 37400.0 |
| 2000-05-08 11:30:00 | DIA | ETF | 106.0 | 106.0625 | 105.75 | 105.9375 | 19500.0 |
| 2000-05-08 12:00:00 | DIA | ETF | 105.6562 | 105.75 | 105.5 | 105.6875 | 6800.0 |
| 2000-05-08 12:30:00 | DIA | ETF | 105.5625 | 105.7812 | 105.5 | 105.7812 | 3700.0 |
| 2000-05-08 13:00:00 | DIA | ETF | 105.75 | 105.75 | 105.0625 | 105.1562 | 215500.0 |
| 2000-05-08 13:30:00 | DIA | ETF | 105.4062 | 105.6875 | 105.2188 | 105.6875 | 10800.0 |
| 2000-05-08 14:00:00 | DIA | ETF | 105.875 | 105.875 | 105.375 | 105.5 | 7200.0 |
| 2000-05-08 14:30:00 | DIA | ETF | 105.6875 | 105.6875 | 105.2812 | 105.5312 | 16100.0 |
| 2000-05-08 15:00:00 | DIA | ETF | 105.5 | 105.9688 | 105.375 | 105.7188 | 25400.0 |
| 2000-05-08 15:30:00 | DIA | ETF | 105.8438 | 106.125 | 105.5625 | 105.875 | 90600.0 |
| 2000-05-08 16:00:00 | DIA | ETF | 105.9688 | 105.9688 | 105.7812 | 105.8125 | 15800.0 |
| 2000-05-08 16:30:00 | DIA | ETF | 105.9375 | 105.9375 | 105.9375 | 105.9375 | 300.0 |
> showing 47 of 203 rows — these rows as CSV