PREVIEW / etf_1hour / 2000-01-31
file: by_date/etf_1hour/2000/2000-01-31.parquet size: 8 KB rows: 135
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-01-31 09:00:00 | SPY | ETF | 135.8125 | 136.3125 | 135.5 | 136.0625 | 822900.0 |
| 2000-01-31 10:00:00 | SPY | ETF | 136.1875 | 136.8438 | 135.0938 | 135.5938 | 1772900.0 |
| 2000-01-31 11:00:00 | SPY | ETF | 135.5 | 136.1875 | 135.25 | 135.3125 | 859000.0 |
| 2000-01-31 12:00:00 | SPY | ETF | 135.25 | 136.4375 | 135.0 | 136.3125 | 1353800.0 |
| 2000-01-31 13:00:00 | SPY | ETF | 136.375 | 136.625 | 136.1875 | 136.2188 | 710100.0 |
| 2000-01-31 14:00:00 | SPY | ETF | 136.1562 | 137.75 | 135.8125 | 137.75 | 1839300.0 |
| 2000-01-31 15:00:00 | SPY | ETF | 137.875 | 139.4375 | 137.5625 | 139.4375 | 2665500.0 |
| 2000-01-31 16:00:00 | SPY | ETF | 139.3125 | 139.6562 | 139.1562 | 139.5625 | 594600.0 |
| 2000-01-31 09:00:00 | QQQ | ETF | 85.875 | 86.1875 | 85.125 | 85.6875 | 3794800.0 |
| 2000-01-31 10:00:00 | QQQ | ETF | 85.625 | 87.2188 | 84.5625 | 85.25 | 6711200.0 |
| 2000-01-31 11:00:00 | QQQ | ETF | 84.875 | 85.875 | 83.75 | 83.875 | 4403200.0 |
| 2000-01-31 12:00:00 | QQQ | ETF | 83.875 | 85.875 | 83.5 | 85.875 | 5427400.0 |
| 2000-01-31 13:00:00 | QQQ | ETF | 85.75 | 86.3125 | 85.0312 | 85.0312 | 2044800.0 |
| 2000-01-31 14:00:00 | QQQ | ETF | 85.0 | 87.1875 | 84.4375 | 87.0625 | 4507200.0 |
| 2000-01-31 15:00:00 | QQQ | ETF | 87.0625 | 89.125 | 86.875 | 89.0 | 7983600.0 |
| 2000-01-31 16:00:00 | QQQ | ETF | 89.0 | 90.0 | 88.875 | 89.75 | 737200.0 |
| 2000-01-31 17:00:00 | QQQ | ETF | 89.875 | 90.0 | 89.5 | 89.9375 | 41600.0 |
| 2000-01-31 18:00:00 | QQQ | ETF | 89.75 | 89.75 | 89.6875 | 89.6875 | 1000.0 |
| 2000-01-31 09:00:00 | DIA | ETF | 107.125 | 107.9062 | 107.0312 | 107.9062 | 159100.0 |
| 2000-01-31 10:00:00 | DIA | ETF | 107.9062 | 108.3438 | 107.0312 | 107.4375 | 248700.0 |
| 2000-01-31 11:00:00 | DIA | ETF | 107.5625 | 107.875 | 107.25 | 107.5312 | 121000.0 |
| 2000-01-31 12:00:00 | DIA | ETF | 107.5 | 108.25 | 107.3438 | 107.8438 | 65500.0 |
| 2000-01-31 13:00:00 | DIA | ETF | 108.0938 | 108.25 | 107.8438 | 108.0312 | 68700.0 |
| 2000-01-31 14:00:00 | DIA | ETF | 108.0312 | 108.7812 | 107.8438 | 108.7812 | 131600.0 |
| 2000-01-31 15:00:00 | DIA | ETF | 108.875 | 109.5625 | 108.5938 | 109.1875 | 136200.0 |
| 2000-01-31 16:00:00 | DIA | ETF | 109.25 | 109.625 | 109.1875 | 109.5 | 60200.0 |
> showing 26 of 135 rows — these rows as CSV