PREVIEW / etf_1hour / 2000-04-11
file: by_date/etf_1hour/2000/2000-04-11.parquet size: 8 KB rows: 129
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-11 09:00:00 | SPY | ETF | 148.5938 | 150.0625 | 148.375 | 149.875 | 247800.0 |
| 2000-04-11 10:00:00 | SPY | ETF | 150.0938 | 150.3125 | 149.0 | 149.8125 | 1370400.0 |
| 2000-04-11 11:00:00 | SPY | ETF | 149.9375 | 151.125 | 149.5625 | 151.0625 | 743500.0 |
| 2000-04-11 12:00:00 | SPY | ETF | 151.0938 | 151.0938 | 150.3125 | 150.7812 | 1737000.0 |
| 2000-04-11 13:00:00 | SPY | ETF | 150.9062 | 151.625 | 150.8125 | 150.8125 | 1850500.0 |
| 2000-04-11 14:00:00 | SPY | ETF | 150.75 | 151.0938 | 149.9375 | 150.875 | 399400.0 |
| 2000-04-11 15:00:00 | SPY | ETF | 150.75 | 150.7812 | 149.4688 | 150.0625 | 1048100.0 |
| 2000-04-11 16:00:00 | SPY | ETF | 150.25 | 150.6562 | 150.25 | 150.4062 | 298400.0 |
| 2000-04-11 09:00:00 | QQQ | ETF | 96.25 | 99.0 | 95.75 | 98.625 | 5064800.0 |
| 2000-04-11 10:00:00 | QQQ | ETF | 98.6875 | 98.9375 | 95.875 | 97.0 | 6701800.0 |
| 2000-04-11 11:00:00 | QQQ | ETF | 97.0625 | 100.0625 | 96.25 | 99.5 | 4783200.0 |
| 2000-04-11 12:00:00 | QQQ | ETF | 99.75 | 99.75 | 98.1562 | 99.625 | 3037700.0 |
| 2000-04-11 13:00:00 | QQQ | ETF | 99.5 | 101.5 | 99.5 | 99.875 | 3161600.0 |
| 2000-04-11 14:00:00 | QQQ | ETF | 99.875 | 100.125 | 97.0312 | 99.0 | 2904000.0 |
| 2000-04-11 15:00:00 | QQQ | ETF | 98.75 | 99.25 | 96.1562 | 97.5 | 4076200.0 |
| 2000-04-11 16:00:00 | QQQ | ETF | 97.5 | 97.9375 | 97.1875 | 97.7188 | 813100.0 |
| 2000-04-11 17:00:00 | QQQ | ETF | 97.6875 | 97.75 | 97.6875 | 97.75 | 500.0 |
| 2000-04-11 18:00:00 | QQQ | ETF | 97.75 | 97.75 | 97.75 | 97.75 | 1100.0 |
| 2000-04-11 09:00:00 | DIA | ETF | 112.25 | 112.4062 | 110.8438 | 112.1562 | 230100.0 |
| 2000-04-11 10:00:00 | DIA | ETF | 112.0 | 112.75 | 111.6562 | 112.6562 | 743000.0 |
| 2000-04-11 11:00:00 | DIA | ETF | 112.6875 | 113.3438 | 112.25 | 113.0 | 384500.0 |
| 2000-04-11 12:00:00 | DIA | ETF | 112.9375 | 113.25 | 112.5938 | 113.125 | 433300.0 |
| 2000-04-11 13:00:00 | DIA | ETF | 113.25 | 113.7188 | 113.0312 | 113.25 | 620800.0 |
| 2000-04-11 14:00:00 | DIA | ETF | 113.3125 | 113.4375 | 112.75 | 113.4062 | 376100.0 |
| 2000-04-11 15:00:00 | DIA | ETF | 113.25 | 113.3438 | 112.625 | 112.9062 | 752700.0 |
| 2000-04-11 16:00:00 | DIA | ETF | 112.7188 | 113.2812 | 112.7188 | 113.25 | 29300.0 |
> showing 26 of 129 rows — these rows as CSV