PREVIEW / etf_1hour / 2000-09-25
file: by_date/etf_1hour/2000/2000-09-25.parquet size: 9 KB rows: 174
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-09-25 09:00:00 | SPY | ETF | 145.93 | 146.06 | 145.34 | 145.34 | 867500.0 |
| 2000-09-25 10:00:00 | SPY | ETF | 145.46 | 145.71 | 145.18 | 145.62 | 772000.0 |
| 2000-09-25 11:00:00 | SPY | ETF | 145.62 | 145.96 | 145.18 | 145.37 | 2684100.0 |
| 2000-09-25 12:00:00 | SPY | ETF | 145.31 | 145.37 | 144.9 | 145.18 | 815600.0 |
| 2000-09-25 13:00:00 | SPY | ETF | 145.21 | 145.4 | 144.71 | 144.96 | 213300.0 |
| 2000-09-25 14:00:00 | SPY | ETF | 144.87 | 144.96 | 144.43 | 144.68 | 171800.0 |
| 2000-09-25 15:00:00 | SPY | ETF | 144.62 | 144.9 | 143.71 | 144.12 | 1489500.0 |
| 2000-09-25 16:00:00 | SPY | ETF | 144.12 | 144.37 | 144.06 | 144.25 | 211400.0 |
| 2000-09-25 09:00:00 | QQQ | ETF | 93.625 | 94.25 | 93.25 | 93.4688 | 3176100.0 |
| 2000-09-25 10:00:00 | QQQ | ETF | 93.4375 | 93.9688 | 93.25 | 93.6875 | 3241100.0 |
| 2000-09-25 11:00:00 | QQQ | ETF | 93.7188 | 94.0938 | 92.75 | 92.875 | 2037900.0 |
| 2000-09-25 12:00:00 | QQQ | ETF | 92.9062 | 93.0938 | 92.375 | 92.8125 | 1805000.0 |
| 2000-09-25 13:00:00 | QQQ | ETF | 92.875 | 93.125 | 92.125 | 92.5625 | 1454200.0 |
| 2000-09-25 14:00:00 | QQQ | ETF | 92.5312 | 92.625 | 91.4062 | 91.75 | 3390400.0 |
| 2000-09-25 15:00:00 | QQQ | ETF | 91.8125 | 92.25 | 90.0625 | 90.4688 | 4593300.0 |
| 2000-09-25 16:00:00 | QQQ | ETF | 90.5 | 90.625 | 90.0938 | 90.5625 | 772400.0 |
| 2000-09-25 17:00:00 | QQQ | ETF | 90.375 | 90.5625 | 90.375 | 90.375 | 5300.0 |
| 2000-09-25 18:00:00 | QQQ | ETF | 90.1875 | 90.75 | 90.1875 | 90.4688 | 1600.0 |
| 2000-09-25 09:00:00 | IWM | ETF | 52.1719 | 52.1719 | 52.0 | 52.0 | 16400.0 |
| 2000-09-25 10:00:00 | IWM | ETF | 52.0469 | 52.0938 | 52.0312 | 52.0625 | 17800.0 |
| 2000-09-25 11:00:00 | IWM | ETF | 52.0 | 52.125 | 51.9688 | 52.0312 | 15800.0 |
| 2000-09-25 12:00:00 | IWM | ETF | 52.0 | 52.0 | 51.8125 | 51.875 | 31200.0 |
| 2000-09-25 13:00:00 | IWM | ETF | 51.875 | 52.0312 | 51.875 | 51.875 | 5800.0 |
| 2000-09-25 14:00:00 | IWM | ETF | 52.0312 | 52.0312 | 51.7188 | 51.75 | 26200.0 |
| 2000-09-25 15:00:00 | IWM | ETF | 51.625 | 51.6562 | 51.625 | 51.6562 | 400.0 |
| 2000-09-25 09:00:00 | DIA | ETF | 108.625 | 108.9688 | 108.5 | 108.5 | 88700.0 |
| 2000-09-25 10:00:00 | DIA | ETF | 108.5 | 108.7812 | 108.2812 | 108.5 | 90400.0 |
| 2000-09-25 11:00:00 | DIA | ETF | 108.5938 | 108.875 | 108.5312 | 108.625 | 66000.0 |
| 2000-09-25 12:00:00 | DIA | ETF | 108.625 | 108.6875 | 108.2812 | 108.5 | 59200.0 |
| 2000-09-25 13:00:00 | DIA | ETF | 108.5 | 108.7188 | 108.2812 | 108.5 | 20600.0 |
| 2000-09-25 14:00:00 | DIA | ETF | 108.375 | 108.4688 | 108.0938 | 108.2812 | 70100.0 |
| 2000-09-25 15:00:00 | DIA | ETF | 108.3438 | 108.375 | 107.7812 | 108.1562 | 137500.0 |
| 2000-09-25 16:00:00 | DIA | ETF | 108.1875 | 108.25 | 108.0938 | 108.0938 | 14600.0 |
> showing 33 of 174 rows — these rows as CSV