PREVIEW / etf_1hour / 2000-03-10
file: by_date/etf_1hour/2000/2000-03-10.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-03-10 09:00:00 | SPY | ETF | 140.1875 | 141.5 | 140.125 | 141.375 | 2172400.0 |
| 2000-03-10 10:00:00 | SPY | ETF | 141.5 | 142.0 | 140.9375 | 141.3438 | 866500.0 |
| 2000-03-10 11:00:00 | SPY | ETF | 141.4375 | 141.5938 | 140.0 | 140.125 | 2101900.0 |
| 2000-03-10 12:00:00 | SPY | ETF | 140.3125 | 140.7188 | 139.8125 | 140.4688 | 274700.0 |
| 2000-03-10 13:00:00 | SPY | ETF | 140.5312 | 141.125 | 140.25 | 141.0 | 296800.0 |
| 2000-03-10 14:00:00 | SPY | ETF | 140.9688 | 141.1875 | 140.1562 | 140.1562 | 367300.0 |
| 2000-03-10 15:00:00 | SPY | ETF | 140.125 | 141.0312 | 139.5312 | 140.0 | 1437600.0 |
| 2000-03-10 16:00:00 | SPY | ETF | 139.8125 | 140.25 | 139.8125 | 140.1875 | 385100.0 |
| 2000-03-10 17:00:00 | SPY | ETF | 140.125 | 140.125 | 140.125 | 140.125 | 100.0 |
| 2000-03-10 09:00:00 | QQQ | ETF | 114.875 | 116.25 | 114.5 | 115.9375 | 5963000.0 |
| 2000-03-10 10:00:00 | QQQ | ETF | 115.9375 | 116.4062 | 115.3125 | 115.9688 | 3059800.0 |
| 2000-03-10 11:00:00 | QQQ | ETF | 115.9375 | 116.125 | 113.5156 | 114.3438 | 5024800.0 |
| 2000-03-10 12:00:00 | QQQ | ETF | 114.0312 | 115.25 | 113.6875 | 114.9375 | 3815400.0 |
| 2000-03-10 13:00:00 | QQQ | ETF | 114.9688 | 115.625 | 114.375 | 115.5312 | 2757000.0 |
| 2000-03-10 14:00:00 | QQQ | ETF | 115.625 | 116.2812 | 115.1875 | 115.25 | 3001200.0 |
| 2000-03-10 15:00:00 | QQQ | ETF | 115.3125 | 116.4375 | 114.1875 | 114.625 | 5334000.0 |
| 2000-03-10 16:00:00 | QQQ | ETF | 114.5 | 114.75 | 114.5 | 114.6875 | 653400.0 |
| 2000-03-10 17:00:00 | QQQ | ETF | 114.5 | 114.5312 | 114.5 | 114.5 | 1000.0 |
| 2000-03-10 09:00:00 | DIA | ETF | 99.9062 | 100.5 | 99.6875 | 100.5 | 185900.0 |
| 2000-03-10 10:00:00 | DIA | ETF | 100.4688 | 101.0625 | 100.1875 | 100.6875 | 164200.0 |
| 2000-03-10 11:00:00 | DIA | ETF | 100.625 | 100.9688 | 99.4375 | 99.8125 | 478600.0 |
| 2000-03-10 12:00:00 | DIA | ETF | 99.875 | 100.25 | 99.5625 | 100.125 | 66300.0 |
| 2000-03-10 13:00:00 | DIA | ETF | 100.1875 | 100.5938 | 99.9375 | 100.4688 | 84500.0 |
| 2000-03-10 14:00:00 | DIA | ETF | 100.4062 | 100.5938 | 99.6875 | 99.7188 | 71700.0 |
| 2000-03-10 15:00:00 | DIA | ETF | 99.75 | 100.375 | 98.9688 | 99.375 | 256700.0 |
| 2000-03-10 16:00:00 | DIA | ETF | 99.25 | 99.5625 | 99.2188 | 99.5625 | 44400.0 |
> showing 26 of 135 rows — these rows as CSV