PREVIEW / etf_1hour / 2000-04-12
file: by_date/etf_1hour/2000/2000-04-12.parquet size: 8 KB rows: 128
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-12 09:00:00 | SPY | ETF | 150.375 | 151.1562 | 150.2812 | 150.5938 | 1582700.0 |
| 2000-04-12 10:00:00 | SPY | ETF | 150.5 | 150.6875 | 149.1875 | 149.25 | 2238400.0 |
| 2000-04-12 11:00:00 | SPY | ETF | 149.1875 | 149.7188 | 148.4375 | 149.2812 | 1214800.0 |
| 2000-04-12 12:00:00 | SPY | ETF | 149.1875 | 150.1875 | 148.625 | 150.125 | 614200.0 |
| 2000-04-12 13:00:00 | SPY | ETF | 150.125 | 150.6562 | 149.8125 | 150.25 | 1173500.0 |
| 2000-04-12 14:00:00 | SPY | ETF | 150.2188 | 150.3125 | 149.375 | 149.9062 | 389500.0 |
| 2000-04-12 15:00:00 | SPY | ETF | 149.9688 | 149.9688 | 146.5625 | 146.625 | 2547500.0 |
| 2000-04-12 16:00:00 | SPY | ETF | 146.625 | 146.8125 | 146.1562 | 146.2812 | 797900.0 |
| 2000-04-12 09:00:00 | QQQ | ETF | 97.625 | 98.75 | 95.625 | 96.125 | 4360900.0 |
| 2000-04-12 10:00:00 | QQQ | ETF | 96.125 | 96.25 | 93.5 | 93.5625 | 5749200.0 |
| 2000-04-12 11:00:00 | QQQ | ETF | 93.5625 | 94.9375 | 92.5 | 93.375 | 5497600.0 |
| 2000-04-12 12:00:00 | QQQ | ETF | 93.5625 | 95.0 | 92.5625 | 94.6875 | 4226700.0 |
| 2000-04-12 13:00:00 | QQQ | ETF | 94.6875 | 95.4375 | 93.5625 | 94.7188 | 2755900.0 |
| 2000-04-12 14:00:00 | QQQ | ETF | 94.375 | 94.7188 | 93.0 | 93.5 | 3488300.0 |
| 2000-04-12 15:00:00 | QQQ | ETF | 93.75 | 93.875 | 90.5 | 90.75 | 7038000.0 |
| 2000-04-12 16:00:00 | QQQ | ETF | 90.75 | 93.0 | 90.25 | 91.5 | 1386600.0 |
| 2000-04-12 17:00:00 | QQQ | ETF | 91.5 | 92.5 | 91.1875 | 92.0 | 2500.0 |
| 2000-04-12 18:00:00 | QQQ | ETF | 92.25 | 93.0 | 91.5 | 92.375 | 5800.0 |
| 2000-04-12 09:00:00 | DIA | ETF | 113.875 | 114.1562 | 113.2812 | 114.1562 | 176900.0 |
| 2000-04-12 10:00:00 | DIA | ETF | 114.0 | 114.3125 | 113.1875 | 113.1875 | 439000.0 |
| 2000-04-12 11:00:00 | DIA | ETF | 113.1562 | 113.6875 | 112.6562 | 113.3125 | 519100.0 |
| 2000-04-12 12:00:00 | DIA | ETF | 113.4375 | 114.0 | 112.875 | 114.0 | 438700.0 |
| 2000-04-12 13:00:00 | DIA | ETF | 114.0 | 114.5312 | 113.75 | 114.25 | 350400.0 |
| 2000-04-12 14:00:00 | DIA | ETF | 114.2188 | 114.2188 | 113.625 | 113.75 | 186800.0 |
| 2000-04-12 15:00:00 | DIA | ETF | 113.8125 | 113.875 | 111.0 | 111.0 | 1194100.0 |
| 2000-04-12 16:00:00 | DIA | ETF | 111.0 | 111.125 | 110.5 | 110.5 | 308700.0 |
> showing 26 of 128 rows — these rows as CSV