PREVIEW / etf_1hour / 2000-07-12
file: by_date/etf_1hour/2000/2000-07-12.parquet size: 9 KB rows: 158
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-12 09:00:00 | SPY | ETF | 149.2812 | 149.4688 | 148.7812 | 148.875 | 1058900.0 |
| 2000-07-12 10:00:00 | SPY | ETF | 148.75 | 149.5625 | 148.6875 | 148.9688 | 994400.0 |
| 2000-07-12 11:00:00 | SPY | ETF | 149.0 | 149.375 | 148.75 | 149.0312 | 688400.0 |
| 2000-07-12 12:00:00 | SPY | ETF | 149.0625 | 149.2188 | 148.75 | 149.125 | 548700.0 |
| 2000-07-12 13:00:00 | SPY | ETF | 149.1875 | 149.5625 | 149.0312 | 149.5 | 540500.0 |
| 2000-07-12 14:00:00 | SPY | ETF | 149.4375 | 150.125 | 149.4062 | 149.625 | 819300.0 |
| 2000-07-12 15:00:00 | SPY | ETF | 149.75 | 150.0 | 149.4062 | 149.5938 | 815700.0 |
| 2000-07-12 16:00:00 | SPY | ETF | 149.5 | 149.5938 | 149.125 | 149.125 | 396700.0 |
| 2000-07-12 09:00:00 | QQQ | ETF | 95.4375 | 95.5 | 94.625 | 94.75 | 3295300.0 |
| 2000-07-12 10:00:00 | QQQ | ETF | 94.625 | 95.875 | 94.625 | 95.4375 | 2352000.0 |
| 2000-07-12 11:00:00 | QQQ | ETF | 95.375 | 96.4375 | 95.3125 | 96.0938 | 2483300.0 |
| 2000-07-12 12:00:00 | QQQ | ETF | 96.125 | 96.5 | 95.875 | 96.4375 | 1130200.0 |
| 2000-07-12 13:00:00 | QQQ | ETF | 96.375 | 96.875 | 96.3125 | 96.8125 | 1187600.0 |
| 2000-07-12 14:00:00 | QQQ | ETF | 96.75 | 97.75 | 96.625 | 97.25 | 3599600.0 |
| 2000-07-12 15:00:00 | QQQ | ETF | 97.25 | 97.5 | 96.75 | 97.125 | 3366400.0 |
| 2000-07-12 16:00:00 | QQQ | ETF | 97.1875 | 97.625 | 96.875 | 97.625 | 891200.0 |
| 2000-07-12 17:00:00 | QQQ | ETF | 97.5 | 97.625 | 96.875 | 96.875 | 7600.0 |
| 2000-07-12 18:00:00 | QQQ | ETF | 97.0 | 97.375 | 96.875 | 97.25 | 1500.0 |
| 2000-07-12 09:00:00 | IWM | ETF | 53.3125 | 53.375 | 53.3125 | 53.375 | 11600.0 |
| 2000-07-12 10:00:00 | IWM | ETF | 53.25 | 53.5625 | 53.25 | 53.5625 | 9600.0 |
| 2000-07-12 11:00:00 | IWM | ETF | 53.5312 | 53.6875 | 53.5312 | 53.6719 | 4000.0 |
| 2000-07-12 12:00:00 | IWM | ETF | 53.6875 | 53.6875 | 53.6875 | 53.6875 | 800.0 |
| 2000-07-12 13:00:00 | IWM | ETF | 53.7031 | 53.7188 | 53.7031 | 53.7031 | 4000.0 |
| 2000-07-12 14:00:00 | IWM | ETF | 53.7188 | 53.9375 | 53.7188 | 53.875 | 2600.0 |
| 2000-07-12 15:00:00 | IWM | ETF | 53.875 | 53.9062 | 53.8281 | 53.9062 | 2000.0 |
| 2000-07-12 16:00:00 | IWM | ETF | 54.0938 | 54.0938 | 54.0938 | 54.0938 | 10600.0 |
| 2000-07-12 09:00:00 | DIA | ETF | 108.1562 | 108.1875 | 107.625 | 107.625 | 170100.0 |
| 2000-07-12 10:00:00 | DIA | ETF | 107.5625 | 108.2188 | 107.5312 | 107.75 | 96600.0 |
| 2000-07-12 11:00:00 | DIA | ETF | 107.875 | 107.9688 | 107.5625 | 107.6875 | 69300.0 |
| 2000-07-12 12:00:00 | DIA | ETF | 107.8125 | 108.0938 | 107.625 | 108.0 | 29600.0 |
| 2000-07-12 13:00:00 | DIA | ETF | 107.9375 | 108.125 | 107.7812 | 108.0625 | 72000.0 |
| 2000-07-12 14:00:00 | DIA | ETF | 108.0938 | 108.5938 | 107.9688 | 108.2812 | 465400.0 |
| 2000-07-12 15:00:00 | DIA | ETF | 108.25 | 108.4688 | 107.8125 | 108.0938 | 62600.0 |
| 2000-07-12 16:00:00 | DIA | ETF | 108.0 | 108.0 | 107.6875 | 107.6875 | 6400.0 |
> showing 34 of 158 rows — these rows as CSV