PREVIEW / etf_1hour / 2000-07-13
file: by_date/etf_1hour/2000/2000-07-13.parquet size: 9 KB rows: 172
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-07-13 09:00:00 | SPY | ETF | 149.9688 | 149.9688 | 149.4062 | 149.5312 | 520000.0 |
| 2000-07-13 10:00:00 | SPY | ETF | 149.375 | 149.9688 | 149.1875 | 149.75 | 702600.0 |
| 2000-07-13 11:00:00 | SPY | ETF | 149.8438 | 149.8438 | 149.4375 | 149.625 | 468100.0 |
| 2000-07-13 12:00:00 | SPY | ETF | 149.625 | 149.9688 | 149.5625 | 149.5625 | 478100.0 |
| 2000-07-13 13:00:00 | SPY | ETF | 149.5625 | 150.2188 | 149.5625 | 150.0625 | 394400.0 |
| 2000-07-13 14:00:00 | SPY | ETF | 150.0625 | 150.375 | 149.8125 | 149.875 | 876400.0 |
| 2000-07-13 15:00:00 | SPY | ETF | 149.875 | 150.0625 | 149.4375 | 149.875 | 1649800.0 |
| 2000-07-13 16:00:00 | SPY | ETF | 149.875 | 149.9688 | 149.625 | 149.7812 | 249800.0 |
| 2000-07-13 09:00:00 | QQQ | ETF | 97.9375 | 98.375 | 97.75 | 97.8125 | 2972100.0 |
| 2000-07-13 10:00:00 | QQQ | ETF | 97.8125 | 98.8125 | 97.125 | 98.8125 | 4202500.0 |
| 2000-07-13 11:00:00 | QQQ | ETF | 98.8125 | 98.875 | 98.125 | 98.625 | 1562700.0 |
| 2000-07-13 12:00:00 | QQQ | ETF | 98.625 | 99.0625 | 98.25 | 98.375 | 1587500.0 |
| 2000-07-13 13:00:00 | QQQ | ETF | 98.375 | 99.1562 | 98.3125 | 99.1562 | 1529300.0 |
| 2000-07-13 14:00:00 | QQQ | ETF | 99.125 | 99.75 | 98.75 | 98.75 | 3518600.0 |
| 2000-07-13 15:00:00 | QQQ | ETF | 98.8125 | 99.0625 | 98.0625 | 98.75 | 3568500.0 |
| 2000-07-13 16:00:00 | QQQ | ETF | 98.5 | 99.375 | 98.4375 | 99.125 | 554000.0 |
| 2000-07-13 17:00:00 | QQQ | ETF | 99.0 | 99.25 | 98.5 | 99.0 | 5400.0 |
| 2000-07-13 18:00:00 | QQQ | ETF | 99.0 | 99.0 | 98.5 | 98.5 | 800.0 |
| 2000-07-13 09:00:00 | IWM | ETF | 54.1406 | 54.25 | 54.1406 | 54.25 | 3800.0 |
| 2000-07-13 10:00:00 | IWM | ETF | 54.1562 | 54.2188 | 54.1562 | 54.2031 | 1400.0 |
| 2000-07-13 11:00:00 | IWM | ETF | 54.2188 | 54.2344 | 54.125 | 54.1406 | 43600.0 |
| 2000-07-13 12:00:00 | IWM | ETF | 54.1875 | 54.1875 | 54.0625 | 54.1094 | 21400.0 |
| 2000-07-13 13:00:00 | IWM | ETF | 54.1094 | 54.125 | 54.0 | 54.0 | 10400.0 |
| 2000-07-13 14:00:00 | IWM | ETF | 54.25 | 54.25 | 54.25 | 54.25 | 1200.0 |
| 2000-07-13 15:00:00 | IWM | ETF | 54.2188 | 54.2656 | 54.1094 | 54.2656 | 20800.0 |
| 2000-07-13 09:00:00 | DIA | ETF | 108.5312 | 108.6875 | 108.0312 | 108.2188 | 273700.0 |
| 2000-07-13 10:00:00 | DIA | ETF | 108.0 | 108.25 | 107.625 | 108.1875 | 146300.0 |
| 2000-07-13 11:00:00 | DIA | ETF | 108.1875 | 108.1875 | 107.6875 | 108.0 | 238500.0 |
| 2000-07-13 12:00:00 | DIA | ETF | 107.9375 | 108.25 | 107.7812 | 107.8125 | 93100.0 |
| 2000-07-13 13:00:00 | DIA | ETF | 107.8125 | 108.375 | 107.8125 | 108.3125 | 66900.0 |
| 2000-07-13 14:00:00 | DIA | ETF | 108.25 | 108.375 | 107.875 | 108.125 | 189400.0 |
| 2000-07-13 15:00:00 | DIA | ETF | 108.125 | 108.3125 | 107.8125 | 108.0 | 161800.0 |
| 2000-07-13 16:00:00 | DIA | ETF | 108.0 | 108.0 | 107.7812 | 108.0 | 5500.0 |
> showing 33 of 172 rows — these rows as CSV