PREVIEW / etf_30min / 2001-04-11
file: by_date/etf_30min/2001/2001-04-11.parquet size: 15 KB rows: 381
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-04-11 09:30:00 | SPY | ETF | 118.78 | 118.99 | 117.3 | 117.47 | 3248300.0 |
| 2001-04-11 10:00:00 | SPY | ETF | 117.35 | 117.75 | 117.03 | 117.49 | 1326200.0 |
| 2001-04-11 10:30:00 | SPY | ETF | 117.6 | 118.0 | 117.22 | 117.3 | 699300.0 |
| 2001-04-11 11:00:00 | SPY | ETF | 117.35 | 117.55 | 117.11 | 117.28 | 632800.0 |
| 2001-04-11 11:30:00 | SPY | ETF | 117.26 | 117.4 | 116.4 | 116.72 | 1105100.0 |
| 2001-04-11 12:00:00 | SPY | ETF | 116.88 | 117.04 | 116.35 | 116.75 | 602800.0 |
| 2001-04-11 12:30:00 | SPY | ETF | 116.82 | 117.07 | 116.61 | 116.8 | 491000.0 |
| 2001-04-11 13:00:00 | SPY | ETF | 116.9 | 117.34 | 116.8 | 117.2 | 335600.0 |
| 2001-04-11 13:30:00 | SPY | ETF | 117.23 | 117.43 | 116.84 | 116.92 | 545300.0 |
| 2001-04-11 14:00:00 | SPY | ETF | 116.96 | 117.37 | 116.7 | 116.74 | 709200.0 |
| 2001-04-11 14:30:00 | SPY | ETF | 116.95 | 117.05 | 116.54 | 116.54 | 586300.0 |
| 2001-04-11 15:00:00 | SPY | ETF | 116.57 | 116.67 | 116.14 | 116.3 | 862600.0 |
| 2001-04-11 15:30:00 | SPY | ETF | 116.44 | 116.96 | 116.22 | 116.96 | 1018200.0 |
| 2001-04-11 16:00:00 | SPY | ETF | 116.96 | 117.07 | 116.42 | 116.42 | 348800.0 |
| 2001-04-11 16:30:00 | SPY | ETF | 116.59 | 116.99 | 116.59 | 116.85 | 6800.0 |
| 2001-04-11 17:00:00 | SPY | ETF | 116.77 | 116.9 | 116.7 | 116.7 | 104100.0 |
| 2001-04-11 17:30:00 | SPY | ETF | 116.5 | 116.5 | 116.5 | 116.5 | 5000.0 |
| 2001-04-11 18:00:00 | SPY | ETF | 116.7 | 116.75 | 116.7 | 116.7 | 12800.0 |
| 2001-04-11 09:30:00 | QQQ | ETF | 42.16 | 42.5 | 41.6 | 41.68 | 18259700.0 |
| 2001-04-11 10:00:00 | QQQ | ETF | 41.66 | 41.94 | 41.3 | 41.85 | 11721000.0 |
| 2001-04-11 10:30:00 | QQQ | ETF | 41.8 | 42.22 | 41.64 | 41.72 | 6169400.0 |
| 2001-04-11 11:00:00 | QQQ | ETF | 41.7 | 41.8 | 41.45 | 41.51 | 6006100.0 |
| 2001-04-11 11:30:00 | QQQ | ETF | 41.5 | 41.5 | 40.65 | 40.9 | 7771100.0 |
| 2001-04-11 12:00:00 | QQQ | ETF | 40.89 | 41.05 | 40.45 | 40.75 | 4840500.0 |
| 2001-04-11 12:30:00 | QQQ | ETF | 40.76 | 41.0 | 40.7 | 40.85 | 3978300.0 |
| 2001-04-11 13:00:00 | QQQ | ETF | 40.88 | 41.54 | 40.85 | 41.45 | 4376300.0 |
| 2001-04-11 13:30:00 | QQQ | ETF | 41.49 | 41.7 | 41.15 | 41.19 | 4726000.0 |
| 2001-04-11 14:00:00 | QQQ | ETF | 41.26 | 41.64 | 41.15 | 41.33 | 3383500.0 |
| 2001-04-11 14:30:00 | QQQ | ETF | 41.34 | 41.4 | 40.85 | 40.96 | 4401400.0 |
| 2001-04-11 15:00:00 | QQQ | ETF | 40.96 | 41.0 | 40.5 | 40.64 | 7452900.0 |
| 2001-04-11 15:30:00 | QQQ | ETF | 40.63 | 41.2 | 40.6 | 41.15 | 5775500.0 |
| 2001-04-11 16:00:00 | QQQ | ETF | 41.15 | 41.6 | 40.73 | 40.96 | 958300.0 |
| 2001-04-11 16:30:00 | QQQ | ETF | 40.91 | 41.5 | 40.91 | 41.05 | 281500.0 |
| 2001-04-11 17:00:00 | QQQ | ETF | 41.12 | 41.15 | 41.0 | 41.04 | 241700.0 |
| 2001-04-11 17:30:00 | QQQ | ETF | 41.01 | 41.15 | 41.01 | 41.13 | 27600.0 |
| 2001-04-11 18:00:00 | QQQ | ETF | 41.12 | 41.5 | 41.1 | 41.5 | 56100.0 |
| 2001-04-11 09:30:00 | IWM | ETF | 45.9 | 45.9 | 45.475 | 45.5 | 82400.0 |
| 2001-04-11 10:00:00 | IWM | ETF | 45.45 | 45.5 | 45.45 | 45.5 | 20400.0 |
| 2001-04-11 10:30:00 | IWM | ETF | 45.375 | 45.525 | 45.375 | 45.375 | 120000.0 |
| 2001-04-11 11:00:00 | IWM | ETF | 45.26 | 45.325 | 45.26 | 45.325 | 7400.0 |
| 2001-04-11 11:30:00 | IWM | ETF | 45.3 | 45.3 | 44.655 | 44.675 | 183400.0 |
| 2001-04-11 12:00:00 | IWM | ETF | 44.925 | 44.925 | 44.82 | 44.82 | 1400.0 |
| 2001-04-11 12:30:00 | IWM | ETF | 44.83 | 45.0 | 44.825 | 44.825 | 5400.0 |
| 2001-04-11 13:00:00 | IWM | ETF | 44.77 | 44.975 | 44.7 | 44.92 | 15600.0 |
| 2001-04-11 13:30:00 | IWM | ETF | 45.05 | 45.05 | 44.855 | 44.855 | 16400.0 |
| 2001-04-11 14:00:00 | IWM | ETF | 44.975 | 45.025 | 44.975 | 44.975 | 16200.0 |
| 2001-04-11 14:30:00 | IWM | ETF | 44.75 | 44.895 | 44.75 | 44.82 | 5800.0 |
| 2001-04-11 15:00:00 | IWM | ETF | 44.8 | 44.8 | 44.605 | 44.625 | 16400.0 |
| 2001-04-11 15:30:00 | IWM | ETF | 44.675 | 44.9 | 44.56 | 44.9 | 33600.0 |
| 2001-04-11 09:30:00 | DIA | ETF | 102.49 | 102.5 | 100.6 | 100.65 | 1115800.0 |
> showing 50 of 381 rows — these rows as CSV