PREVIEW / etf_1hour / 2000-04-27
file: by_date/etf_1hour/2000/2000-04-27.parquet size: 8 KB rows: 121
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-27 09:00:00 | SPY | ETF | 143.0 | 145.0 | 143.0 | 144.5938 | 1713500.0 |
| 2000-04-27 10:00:00 | SPY | ETF | 144.375 | 146.25 | 144.1875 | 145.0 | 4778100.0 |
| 2000-04-27 11:00:00 | SPY | ETF | 144.9375 | 145.625 | 144.0625 | 145.0625 | 2970200.0 |
| 2000-04-27 12:00:00 | SPY | ETF | 145.25 | 146.2188 | 145.25 | 145.75 | 1058300.0 |
| 2000-04-27 13:00:00 | SPY | ETF | 145.5625 | 146.125 | 144.9375 | 145.9688 | 693100.0 |
| 2000-04-27 14:00:00 | SPY | ETF | 145.8125 | 147.125 | 145.75 | 146.5 | 2097100.0 |
| 2000-04-27 15:00:00 | SPY | ETF | 146.625 | 147.3438 | 145.8125 | 146.5 | 1897700.0 |
| 2000-04-27 16:00:00 | SPY | ETF | 146.4688 | 146.625 | 145.75 | 145.75 | 347600.0 |
| 2000-04-27 17:00:00 | SPY | ETF | 145.75 | 146.0 | 145.75 | 146.0 | 1000.0 |
| 2000-04-27 09:00:00 | QQQ | ETF | 83.5 | 86.875 | 83.5 | 86.25 | 5942000.0 |
| 2000-04-27 10:00:00 | QQQ | ETF | 86.25 | 89.125 | 86.0 | 88.5 | 8223400.0 |
| 2000-04-27 11:00:00 | QQQ | ETF | 88.5 | 89.625 | 87.25 | 89.1875 | 4497500.0 |
| 2000-04-27 12:00:00 | QQQ | ETF | 89.125 | 90.625 | 89.0 | 89.6875 | 3564400.0 |
| 2000-04-27 13:00:00 | QQQ | ETF | 89.6875 | 90.75 | 88.875 | 90.75 | 2336800.0 |
| 2000-04-27 14:00:00 | QQQ | ETF | 90.625 | 92.375 | 90.1875 | 91.375 | 6293800.0 |
| 2000-04-27 15:00:00 | QQQ | ETF | 91.5 | 92.4688 | 90.5 | 92.25 | 5249100.0 |
| 2000-04-27 16:00:00 | QQQ | ETF | 92.0 | 92.25 | 91.25 | 91.375 | 765300.0 |
| 2000-04-27 17:00:00 | QQQ | ETF | 91.375 | 91.5 | 91.25 | 91.3125 | 3200.0 |
| 2000-04-27 18:00:00 | QQQ | ETF | 91.3125 | 91.375 | 91.25 | 91.25 | 700.0 |
| 2000-04-27 09:00:00 | DIA | ETF | 107.0938 | 108.25 | 107.0938 | 107.875 | 300100.0 |
| 2000-04-27 10:00:00 | DIA | ETF | 107.9688 | 108.7188 | 107.75 | 108.2188 | 272600.0 |
| 2000-04-27 11:00:00 | DIA | ETF | 108.0625 | 108.3125 | 107.3125 | 107.9375 | 313200.0 |
| 2000-04-27 12:00:00 | DIA | ETF | 107.9062 | 108.625 | 107.9062 | 108.1562 | 110700.0 |
| 2000-04-27 13:00:00 | DIA | ETF | 108.1875 | 108.7812 | 107.875 | 108.5625 | 63900.0 |
| 2000-04-27 14:00:00 | DIA | ETF | 108.4688 | 109.5 | 108.2812 | 109.0312 | 152200.0 |
| 2000-04-27 15:00:00 | DIA | ETF | 109.25 | 109.5 | 108.3125 | 108.6875 | 406900.0 |
| 2000-04-27 16:00:00 | DIA | ETF | 108.875 | 108.875 | 108.25 | 108.375 | 18400.0 |
> showing 27 of 121 rows — these rows as CSV