PREVIEW / etf_1hour / 2000-01-10
file: by_date/etf_1hour/2000/2000-01-10.parquet size: 8 KB rows: 141
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-10 09:00:00 | SPY | ETF | 146.25 | 146.9062 | 146.125 | 146.5 | 1935600.0 |
| 2000-01-10 10:00:00 | SPY | ETF | 146.625 | 146.75 | 145.3125 | 145.375 | 804400.0 |
| 2000-01-10 11:00:00 | SPY | ETF | 145.4062 | 145.9375 | 145.0312 | 145.9375 | 537500.0 |
| 2000-01-10 12:00:00 | SPY | ETF | 145.9375 | 146.0625 | 145.5312 | 145.8125 | 217900.0 |
| 2000-01-10 13:00:00 | SPY | ETF | 145.9375 | 146.0 | 145.4062 | 145.4688 | 515300.0 |
| 2000-01-10 14:00:00 | SPY | ETF | 145.4375 | 146.3125 | 145.4062 | 146.2188 | 404100.0 |
| 2000-01-10 15:00:00 | SPY | ETF | 146.3125 | 146.7812 | 145.5312 | 145.8125 | 963200.0 |
| 2000-01-10 16:00:00 | SPY | ETF | 145.8125 | 146.375 | 145.6562 | 146.375 | 324800.0 |
| 2000-01-10 17:00:00 | SPY | ETF | 146.25 | 146.25 | 146.25 | 146.25 | 500.0 |
| 2000-01-10 09:00:00 | QQQ | ETF | 91.0 | 92.0 | 90.75 | 91.5 | 6010000.0 |
| 2000-01-10 10:00:00 | QQQ | ETF | 91.5156 | 91.75 | 90.75 | 90.8281 | 4016000.0 |
| 2000-01-10 11:00:00 | QQQ | ETF | 90.6875 | 91.4844 | 89.9375 | 91.4375 | 3114200.0 |
| 2000-01-10 12:00:00 | QQQ | ETF | 91.4375 | 91.9375 | 91.1094 | 91.6875 | 2208400.0 |
| 2000-01-10 13:00:00 | QQQ | ETF | 91.6875 | 92.125 | 91.25 | 91.75 | 2903400.0 |
| 2000-01-10 14:00:00 | QQQ | ETF | 91.8438 | 93.0 | 91.7812 | 92.9688 | 3031600.0 |
| 2000-01-10 15:00:00 | QQQ | ETF | 92.9688 | 93.9375 | 92.25 | 92.4688 | 7581800.0 |
| 2000-01-10 16:00:00 | QQQ | ETF | 92.6875 | 93.2812 | 92.375 | 93.125 | 410200.0 |
| 2000-01-10 17:00:00 | QQQ | ETF | 92.375 | 92.6875 | 91.5 | 92.6875 | 4800.0 |
| 2000-01-10 18:00:00 | QQQ | ETF | 92.75 | 92.75 | 92.5 | 92.5 | 400.0 |
| 2000-01-10 09:00:00 | DIA | ETF | 116.8125 | 116.8125 | 116.3125 | 116.4062 | 317200.0 |
| 2000-01-10 10:00:00 | DIA | ETF | 116.25 | 116.5625 | 115.6562 | 115.8438 | 153200.0 |
| 2000-01-10 11:00:00 | DIA | ETF | 115.6875 | 116.1562 | 115.5625 | 115.9375 | 103600.0 |
| 2000-01-10 12:00:00 | DIA | ETF | 116.125 | 116.2188 | 115.875 | 116.0312 | 32200.0 |
| 2000-01-10 13:00:00 | DIA | ETF | 116.125 | 116.125 | 115.4375 | 115.5625 | 44800.0 |
| 2000-01-10 14:00:00 | DIA | ETF | 115.4375 | 116.0 | 115.4375 | 116.0 | 32400.0 |
| 2000-01-10 15:00:00 | DIA | ETF | 116.2188 | 116.375 | 115.75 | 115.9375 | 58000.0 |
| 2000-01-10 16:00:00 | DIA | ETF | 115.75 | 116.0 | 115.75 | 116.0 | 15800.0 |
> showing 27 of 141 rows — these rows as CSV