PREVIEW / etf_30min / 2000-04-19
file: by_date/etf_30min/2000/2000-04-19.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-04-19 09:30:00 | SPY | ETF | 144.5 | 144.5312 | 143.4062 | 143.625 | 684900.0 |
| 2000-04-19 10:00:00 | SPY | ETF | 143.5625 | 143.9688 | 142.9688 | 143.9688 | 514800.0 |
| 2000-04-19 10:30:00 | SPY | ETF | 144.2812 | 144.6875 | 143.5 | 144.625 | 118100.0 |
| 2000-04-19 11:00:00 | SPY | ETF | 144.6875 | 144.6875 | 144.0 | 144.1562 | 558900.0 |
| 2000-04-19 11:30:00 | SPY | ETF | 144.1875 | 145.0 | 144.0625 | 144.9688 | 751500.0 |
| 2000-04-19 12:00:00 | SPY | ETF | 145.0 | 145.125 | 144.2188 | 144.4688 | 470600.0 |
| 2000-04-19 12:30:00 | SPY | ETF | 144.4688 | 144.75 | 144.1562 | 144.25 | 339200.0 |
| 2000-04-19 13:00:00 | SPY | ETF | 144.2812 | 144.3438 | 143.7812 | 144.3438 | 405200.0 |
| 2000-04-19 13:30:00 | SPY | ETF | 144.125 | 144.4688 | 143.25 | 143.25 | 409800.0 |
| 2000-04-19 14:00:00 | SPY | ETF | 143.3125 | 144.0 | 143.25 | 143.7812 | 225900.0 |
| 2000-04-19 14:30:00 | SPY | ETF | 143.75 | 143.9062 | 142.9375 | 143.25 | 393200.0 |
| 2000-04-19 15:00:00 | SPY | ETF | 143.3125 | 143.5312 | 142.5312 | 142.7812 | 916900.0 |
| 2000-04-19 15:30:00 | SPY | ETF | 142.6562 | 143.5625 | 142.5625 | 143.0 | 412600.0 |
| 2000-04-19 16:00:00 | SPY | ETF | 142.875 | 143.2188 | 142.8438 | 143.125 | 318500.0 |
| 2000-04-19 09:30:00 | QQQ | ETF | 92.5 | 92.875 | 90.5 | 91.25 | 4811200.0 |
| 2000-04-19 10:00:00 | QQQ | ETF | 91.25 | 91.4688 | 90.0 | 91.0625 | 2975100.0 |
| 2000-04-19 10:30:00 | QQQ | ETF | 91.125 | 92.8438 | 90.6875 | 92.625 | 1951600.0 |
| 2000-04-19 11:00:00 | QQQ | ETF | 92.7188 | 92.875 | 92.0 | 92.0 | 2046600.0 |
| 2000-04-19 11:30:00 | QQQ | ETF | 92.0 | 93.5 | 91.8125 | 93.375 | 1926100.0 |
| 2000-04-19 12:00:00 | QQQ | ETF | 93.375 | 93.625 | 92.5 | 92.5625 | 1734400.0 |
| 2000-04-19 12:30:00 | QQQ | ETF | 92.5625 | 93.2188 | 92.3125 | 92.4375 | 968000.0 |
| 2000-04-19 13:00:00 | QQQ | ETF | 92.3125 | 92.5 | 91.5625 | 91.875 | 1749500.0 |
| 2000-04-19 13:30:00 | QQQ | ETF | 92.0 | 92.4375 | 91.0 | 91.0625 | 1747500.0 |
| 2000-04-19 14:00:00 | QQQ | ETF | 91.125 | 92.4375 | 91.0625 | 91.9062 | 1138100.0 |
| 2000-04-19 14:30:00 | QQQ | ETF | 91.9375 | 92.2188 | 90.0 | 90.5625 | 1523100.0 |
| 2000-04-19 15:00:00 | QQQ | ETF | 90.5625 | 91.375 | 89.375 | 89.5938 | 2518700.0 |
| 2000-04-19 15:30:00 | QQQ | ETF | 89.375 | 90.5 | 89.1875 | 89.6875 | 2335200.0 |
| 2000-04-19 16:00:00 | QQQ | ETF | 89.6875 | 89.9375 | 89.1875 | 89.1875 | 576600.0 |
| 2000-04-19 17:00:00 | QQQ | ETF | 89.0625 | 89.125 | 89.0625 | 89.125 | 3100.0 |
| 2000-04-19 17:30:00 | QQQ | ETF | 89.1875 | 89.25 | 89.0625 | 89.25 | 700.0 |
| 2000-04-19 18:00:00 | QQQ | ETF | 89.125 | 89.1875 | 89.125 | 89.1875 | 900.0 |
| 2000-04-19 09:30:00 | DIA | ETF | 107.4375 | 107.5312 | 106.8438 | 107.0625 | 136600.0 |
| 2000-04-19 10:00:00 | DIA | ETF | 107.0938 | 107.5 | 106.875 | 107.4688 | 52700.0 |
| 2000-04-19 10:30:00 | DIA | ETF | 107.5 | 107.8438 | 107.0312 | 107.8438 | 91900.0 |
| 2000-04-19 11:00:00 | DIA | ETF | 107.75 | 107.8438 | 107.3125 | 107.5 | 224500.0 |
| 2000-04-19 11:30:00 | DIA | ETF | 107.3125 | 108.0625 | 107.3125 | 108.0 | 328600.0 |
| 2000-04-19 12:00:00 | DIA | ETF | 107.75 | 108.0 | 107.375 | 107.4062 | 35100.0 |
| 2000-04-19 12:30:00 | DIA | ETF | 107.5625 | 107.6875 | 107.2812 | 107.2812 | 20000.0 |
| 2000-04-19 13:00:00 | DIA | ETF | 107.25 | 107.5 | 107.0312 | 107.1562 | 65200.0 |
| 2000-04-19 13:30:00 | DIA | ETF | 107.1875 | 107.375 | 106.875 | 107.1562 | 56500.0 |
| 2000-04-19 14:00:00 | DIA | ETF | 106.9375 | 107.3438 | 106.875 | 107.0625 | 33800.0 |
| 2000-04-19 14:30:00 | DIA | ETF | 107.25 | 107.25 | 106.7188 | 106.8125 | 77600.0 |
| 2000-04-19 15:00:00 | DIA | ETF | 107.0625 | 107.1562 | 106.3125 | 106.4688 | 175400.0 |
| 2000-04-19 15:30:00 | DIA | ETF | 106.5 | 107.0938 | 106.4062 | 106.8125 | 125100.0 |
| 2000-04-19 16:00:00 | DIA | ETF | 106.8125 | 106.8125 | 106.6875 | 106.8125 | 113500.0 |
> showing 45 of 206 rows — these rows as CSV