PREVIEW / etf_1hour / 2000-04-19
file: by_date/etf_1hour/2000/2000-04-19.parquet size: 8 KB rows: 126
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:00:00 | SPY | ETF | 144.5 | 144.5312 | 143.4062 | 143.625 | 684900.0 |
| 2000-04-19 10:00:00 | SPY | ETF | 143.5625 | 144.6875 | 142.9688 | 144.625 | 632900.0 |
| 2000-04-19 11:00:00 | SPY | ETF | 144.6875 | 145.0 | 144.0 | 144.9688 | 1310400.0 |
| 2000-04-19 12:00:00 | SPY | ETF | 145.0 | 145.125 | 144.1562 | 144.25 | 809800.0 |
| 2000-04-19 13:00:00 | SPY | ETF | 144.2812 | 144.4688 | 143.25 | 143.25 | 815000.0 |
| 2000-04-19 14:00:00 | SPY | ETF | 143.3125 | 144.0 | 142.9375 | 143.25 | 619100.0 |
| 2000-04-19 15:00:00 | SPY | ETF | 143.3125 | 143.5625 | 142.5312 | 143.0 | 1329500.0 |
| 2000-04-19 16:00:00 | SPY | ETF | 142.875 | 143.2188 | 142.8438 | 143.125 | 318500.0 |
| 2000-04-19 09:00:00 | QQQ | ETF | 92.5 | 92.875 | 90.5 | 91.25 | 4811200.0 |
| 2000-04-19 10:00:00 | QQQ | ETF | 91.25 | 92.8438 | 90.0 | 92.625 | 4926700.0 |
| 2000-04-19 11:00:00 | QQQ | ETF | 92.7188 | 93.5 | 91.8125 | 93.375 | 3972700.0 |
| 2000-04-19 12:00:00 | QQQ | ETF | 93.375 | 93.625 | 92.3125 | 92.4375 | 2702400.0 |
| 2000-04-19 13:00:00 | QQQ | ETF | 92.3125 | 92.5 | 91.0 | 91.0625 | 3497000.0 |
| 2000-04-19 14:00:00 | QQQ | ETF | 91.125 | 92.4375 | 90.0 | 90.5625 | 2661200.0 |
| 2000-04-19 15:00:00 | QQQ | ETF | 90.5625 | 91.375 | 89.1875 | 89.6875 | 4853900.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.25 | 89.0625 | 89.25 | 3800.0 |
| 2000-04-19 18:00:00 | QQQ | ETF | 89.125 | 89.1875 | 89.125 | 89.1875 | 900.0 |
| 2000-04-19 09:00:00 | DIA | ETF | 107.4375 | 107.5312 | 106.8438 | 107.0625 | 136600.0 |
| 2000-04-19 10:00:00 | DIA | ETF | 107.0938 | 107.8438 | 106.875 | 107.8438 | 144600.0 |
| 2000-04-19 11:00:00 | DIA | ETF | 107.75 | 108.0625 | 107.3125 | 108.0 | 553100.0 |
| 2000-04-19 12:00:00 | DIA | ETF | 107.75 | 108.0 | 107.2812 | 107.2812 | 55100.0 |
| 2000-04-19 13:00:00 | DIA | ETF | 107.25 | 107.5 | 106.875 | 107.1562 | 121700.0 |
| 2000-04-19 14:00:00 | DIA | ETF | 106.9375 | 107.3438 | 106.7188 | 106.8125 | 111400.0 |
| 2000-04-19 15:00:00 | DIA | ETF | 107.0625 | 107.1562 | 106.3125 | 106.8125 | 300500.0 |
| 2000-04-19 16:00:00 | DIA | ETF | 106.8125 | 106.8125 | 106.6875 | 106.8125 | 113500.0 |
> showing 26 of 126 rows — these rows as CSV