PREVIEW / etf_1hour / 2001-06-12
file: by_date/etf_1hour/2001/2001-06-12.parquet size: 11 KB rows: 225
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 |
|---|---|---|---|---|---|---|---|
| 2001-06-12 09:00:00 | SPY | ETF | 124.86 | 125.07 | 124.75 | 124.92 | 1305000.0 |
| 2001-06-12 10:00:00 | SPY | ETF | 124.92 | 124.92 | 124.04 | 124.25 | 1583200.0 |
| 2001-06-12 11:00:00 | SPY | ETF | 124.3 | 124.54 | 124.11 | 124.52 | 1068500.0 |
| 2001-06-12 12:00:00 | SPY | ETF | 124.53 | 124.54 | 124.24 | 124.27 | 439200.0 |
| 2001-06-12 13:00:00 | SPY | ETF | 124.34 | 125.2 | 124.25 | 125.03 | 826200.0 |
| 2001-06-12 14:00:00 | SPY | ETF | 125.01 | 125.78 | 124.95 | 125.78 | 1076900.0 |
| 2001-06-12 15:00:00 | SPY | ETF | 125.79 | 126.74 | 125.7 | 126.13 | 2438700.0 |
| 2001-06-12 16:00:00 | SPY | ETF | 126.13 | 126.16 | 124.56 | 125.8 | 305700.0 |
| 2001-06-12 17:00:00 | SPY | ETF | 125.78 | 125.8 | 125.74 | 125.8 | 4200.0 |
| 2001-06-12 18:00:00 | SPY | ETF | 125.98 | 125.98 | 125.98 | 125.98 | 700.0 |
| 2001-06-12 09:00:00 | QQQ | ETF | 44.87 | 45.0 | 44.55 | 44.95 | 11516600.0 |
| 2001-06-12 10:00:00 | QQQ | ETF | 44.96 | 45.02 | 44.23 | 44.54 | 11388200.0 |
| 2001-06-12 11:00:00 | QQQ | ETF | 44.56 | 44.89 | 44.38 | 44.85 | 6847600.0 |
| 2001-06-12 12:00:00 | QQQ | ETF | 44.84 | 44.86 | 44.5 | 44.61 | 3985500.0 |
| 2001-06-12 13:00:00 | QQQ | ETF | 44.61 | 45.49 | 44.58 | 45.32 | 9006800.0 |
| 2001-06-12 14:00:00 | QQQ | ETF | 45.29 | 46.1 | 45.28 | 46.1 | 12885200.0 |
| 2001-06-12 15:00:00 | QQQ | ETF | 46.09 | 46.7 | 45.9 | 46.17 | 19093700.0 |
| 2001-06-12 16:00:00 | QQQ | ETF | 46.16 | 46.19 | 45.25 | 45.85 | 1211600.0 |
| 2001-06-12 17:00:00 | QQQ | ETF | 46.0 | 46.0 | 45.0 | 45.9 | 23000.0 |
| 2001-06-12 18:00:00 | QQQ | ETF | 45.91 | 46.0 | 45.91 | 45.99 | 6100.0 |
| 2001-06-12 09:00:00 | IWM | ETF | 50.0 | 50.1 | 50.0 | 50.015 | 38000.0 |
| 2001-06-12 10:00:00 | IWM | ETF | 50.175 | 50.175 | 49.73 | 49.85 | 90800.0 |
| 2001-06-12 11:00:00 | IWM | ETF | 49.94 | 50.075 | 49.825 | 50.0 | 161400.0 |
| 2001-06-12 12:00:00 | IWM | ETF | 50.04 | 50.075 | 49.85 | 49.875 | 90600.0 |
| 2001-06-12 13:00:00 | IWM | ETF | 49.805 | 50.055 | 49.805 | 50.005 | 21200.0 |
| 2001-06-12 14:00:00 | IWM | ETF | 50.085 | 50.285 | 50.085 | 50.285 | 45000.0 |
| 2001-06-12 15:00:00 | IWM | ETF | 50.35 | 50.75 | 50.35 | 50.435 | 229200.0 |
| 2001-06-12 16:00:00 | IWM | ETF | 50.575 | 50.575 | 50.4 | 50.4 | 8800.0 |
| 2001-06-12 09:00:00 | DIA | ETF | 108.69 | 108.9 | 108.56 | 108.6 | 350400.0 |
| 2001-06-12 10:00:00 | DIA | ETF | 108.6 | 108.65 | 107.95 | 108.17 | 434100.0 |
| 2001-06-12 11:00:00 | DIA | ETF | 108.23 | 108.39 | 108.05 | 108.39 | 167500.0 |
| 2001-06-12 12:00:00 | DIA | ETF | 108.38 | 108.4 | 108.11 | 108.15 | 74000.0 |
| 2001-06-12 13:00:00 | DIA | ETF | 108.19 | 108.89 | 108.19 | 108.69 | 238900.0 |
| 2001-06-12 14:00:00 | DIA | ETF | 108.72 | 109.15 | 108.52 | 109.11 | 268400.0 |
| 2001-06-12 15:00:00 | DIA | ETF | 109.23 | 110.0 | 109.13 | 109.7 | 704100.0 |
| 2001-06-12 16:00:00 | DIA | ETF | 109.68 | 109.8 | 108.37 | 108.37 | 81100.0 |
> showing 36 of 225 rows — these rows as CSV