PREVIEW / etf_30min / 2001-12-28
file: by_date/etf_30min/2001/2001-12-28.parquet size: 17 KB rows: 470
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-12-28 09:30:00 | SPY | ETF | 116.29 | 116.5 | 116.2 | 116.36 | 882400.0 |
| 2001-12-28 10:00:00 | SPY | ETF | 116.35 | 116.75 | 116.35 | 116.66 | 1560400.0 |
| 2001-12-28 10:30:00 | SPY | ETF | 116.66 | 116.72 | 116.49 | 116.57 | 720000.0 |
| 2001-12-28 11:00:00 | SPY | ETF | 116.57 | 116.64 | 116.3 | 116.31 | 577300.0 |
| 2001-12-28 11:30:00 | SPY | ETF | 116.32 | 116.32 | 115.95 | 116.06 | 851600.0 |
| 2001-12-28 12:00:00 | SPY | ETF | 116.09 | 116.3 | 116.05 | 116.25 | 853400.0 |
| 2001-12-28 12:30:00 | SPY | ETF | 116.25 | 116.44 | 116.21 | 116.41 | 893500.0 |
| 2001-12-28 13:00:00 | SPY | ETF | 116.37 | 116.42 | 116.2 | 116.31 | 808400.0 |
| 2001-12-28 13:30:00 | SPY | ETF | 116.3 | 116.42 | 116.25 | 116.37 | 193800.0 |
| 2001-12-28 14:00:00 | SPY | ETF | 116.4 | 116.4 | 116.11 | 116.13 | 357800.0 |
| 2001-12-28 14:30:00 | SPY | ETF | 116.11 | 116.34 | 116.08 | 116.11 | 268200.0 |
| 2001-12-28 15:00:00 | SPY | ETF | 116.06 | 116.39 | 116.0 | 116.33 | 412300.0 |
| 2001-12-28 15:30:00 | SPY | ETF | 116.35 | 116.38 | 116.16 | 116.21 | 790900.0 |
| 2001-12-28 16:00:00 | SPY | ETF | 116.17 | 116.23 | 115.92 | 116.03 | 1202800.0 |
| 2001-12-28 16:30:00 | SPY | ETF | 116.0 | 116.0 | 116.0 | 116.0 | 1000.0 |
| 2001-12-28 17:00:00 | SPY | ETF | 116.0 | 116.0 | 116.0 | 116.0 | 1700.0 |
| 2001-12-28 09:30:00 | QQQ | ETF | 40.29 | 40.64 | 40.26 | 40.53 | 6565300.0 |
| 2001-12-28 10:00:00 | QQQ | ETF | 40.46 | 40.8 | 40.45 | 40.66 | 5490000.0 |
| 2001-12-28 10:30:00 | QQQ | ETF | 40.66 | 40.7 | 40.48 | 40.56 | 4643900.0 |
| 2001-12-28 11:00:00 | QQQ | ETF | 40.54 | 40.62 | 40.4 | 40.49 | 2360900.0 |
| 2001-12-28 11:30:00 | QQQ | ETF | 40.48 | 40.5 | 40.23 | 40.29 | 2930500.0 |
| 2001-12-28 12:00:00 | QQQ | ETF | 40.28 | 40.46 | 40.25 | 40.45 | 1647800.0 |
| 2001-12-28 12:30:00 | QQQ | ETF | 40.44 | 40.49 | 40.34 | 40.47 | 1218600.0 |
| 2001-12-28 13:00:00 | QQQ | ETF | 40.47 | 40.48 | 40.33 | 40.39 | 872400.0 |
| 2001-12-28 13:30:00 | QQQ | ETF | 40.37 | 40.47 | 40.34 | 40.45 | 977400.0 |
| 2001-12-28 14:00:00 | QQQ | ETF | 40.4 | 40.45 | 40.25 | 40.29 | 1519100.0 |
| 2001-12-28 14:30:00 | QQQ | ETF | 40.27 | 40.38 | 40.25 | 40.28 | 1821700.0 |
| 2001-12-28 15:00:00 | QQQ | ETF | 40.28 | 40.47 | 40.25 | 40.42 | 2598700.0 |
| 2001-12-28 15:30:00 | QQQ | ETF | 40.42 | 40.45 | 40.3 | 40.34 | 4094800.0 |
| 2001-12-28 16:00:00 | QQQ | ETF | 40.34 | 40.38 | 40.24 | 40.31 | 1222800.0 |
| 2001-12-28 16:30:00 | QQQ | ETF | 40.3 | 40.34 | 40.3 | 40.34 | 5600.0 |
| 2001-12-28 17:00:00 | QQQ | ETF | 40.34 | 40.35 | 40.3 | 40.35 | 8500.0 |
| 2001-12-28 17:30:00 | QQQ | ETF | 40.32 | 40.34 | 40.3 | 40.34 | 5300.0 |
| 2001-12-28 18:00:00 | QQQ | ETF | 40.3 | 40.4 | 40.3 | 40.35 | 11100.0 |
| 2001-12-28 09:30:00 | IWM | ETF | 49.15 | 49.15 | 49.0 | 49.125 | 141600.0 |
| 2001-12-28 10:00:00 | IWM | ETF | 49.2 | 49.265 | 49.09 | 49.16 | 62200.0 |
| 2001-12-28 10:30:00 | IWM | ETF | 49.12 | 49.12 | 49.09 | 49.09 | 31400.0 |
| 2001-12-28 11:00:00 | IWM | ETF | 49.09 | 49.175 | 49.04 | 49.175 | 795600.0 |
| 2001-12-28 11:30:00 | IWM | ETF | 49.175 | 49.175 | 49.045 | 49.06 | 62800.0 |
| 2001-12-28 12:00:00 | IWM | ETF | 49.03 | 49.095 | 49.0 | 49.09 | 46800.0 |
| 2001-12-28 12:30:00 | IWM | ETF | 49.09 | 49.19 | 49.09 | 49.15 | 23400.0 |
| 2001-12-28 13:00:00 | IWM | ETF | 49.19 | 49.19 | 49.15 | 49.19 | 14600.0 |
| 2001-12-28 13:30:00 | IWM | ETF | 49.19 | 49.195 | 49.09 | 49.165 | 44000.0 |
| 2001-12-28 14:00:00 | IWM | ETF | 49.175 | 49.175 | 49.085 | 49.12 | 30600.0 |
| 2001-12-28 14:30:00 | IWM | ETF | 49.115 | 49.15 | 49.06 | 49.06 | 393400.0 |
| 2001-12-28 15:00:00 | IWM | ETF | 49.05 | 49.165 | 49.0 | 49.165 | 42800.0 |
| 2001-12-28 15:30:00 | IWM | ETF | 49.19 | 49.19 | 49.0 | 49.05 | 75200.0 |
| 2001-12-28 16:00:00 | IWM | ETF | 48.985 | 49.0 | 48.875 | 49.0 | 34200.0 |
| 2001-12-28 09:30:00 | DIA | ETF | 101.7 | 101.72 | 101.5 | 101.62 | 229900.0 |
| 2001-12-28 10:00:00 | DIA | ETF | 101.62 | 101.94 | 101.62 | 101.93 | 375000.0 |
> showing 50 of 470 rows — these rows as CSV