PREVIEW / etf_30min / 2001-10-11
file: by_date/etf_30min/2001/2001-10-11.parquet size: 17 KB rows: 445
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-10-11 09:30:00 | SPY | ETF | 108.95 | 110.25 | 108.95 | 109.89 | 6614800.0 |
| 2001-10-11 10:00:00 | SPY | ETF | 109.88 | 110.3 | 109.5 | 109.52 | 2930800.0 |
| 2001-10-11 10:30:00 | SPY | ETF | 109.63 | 109.96 | 109.45 | 109.75 | 1463000.0 |
| 2001-10-11 11:00:00 | SPY | ETF | 109.75 | 110.15 | 109.5 | 110.03 | 926400.0 |
| 2001-10-11 11:30:00 | SPY | ETF | 110.07 | 110.15 | 109.53 | 109.66 | 913800.0 |
| 2001-10-11 12:00:00 | SPY | ETF | 109.67 | 109.8 | 109.51 | 109.73 | 689900.0 |
| 2001-10-11 12:30:00 | SPY | ETF | 109.73 | 109.9 | 109.6 | 109.87 | 582300.0 |
| 2001-10-11 13:00:00 | SPY | ETF | 109.84 | 110.16 | 109.8 | 110.1 | 660800.0 |
| 2001-10-11 13:30:00 | SPY | ETF | 110.0 | 110.07 | 109.66 | 109.71 | 899100.0 |
| 2001-10-11 14:00:00 | SPY | ETF | 109.71 | 109.85 | 109.45 | 109.65 | 729900.0 |
| 2001-10-11 14:30:00 | SPY | ETF | 109.61 | 109.61 | 109.18 | 109.38 | 1652100.0 |
| 2001-10-11 15:00:00 | SPY | ETF | 109.37 | 109.75 | 109.15 | 109.7 | 1288400.0 |
| 2001-10-11 15:30:00 | SPY | ETF | 109.74 | 110.05 | 109.7 | 110.01 | 2120600.0 |
| 2001-10-11 16:00:00 | SPY | ETF | 110.02 | 110.3 | 109.81 | 110.1 | 992800.0 |
| 2001-10-11 16:30:00 | SPY | ETF | 110.1 | 110.46 | 110.1 | 110.39 | 27200.0 |
| 2001-10-11 17:00:00 | SPY | ETF | 110.27 | 110.48 | 109.0 | 109.0 | 10800.0 |
| 2001-10-11 17:30:00 | SPY | ETF | 110.6 | 110.6 | 110.48 | 110.6 | 1000.0 |
| 2001-10-11 18:00:00 | SPY | ETF | 110.6 | 110.74 | 110.48 | 110.48 | 4400.0 |
| 2001-10-11 09:30:00 | QQQ | ETF | 33.19 | 34.05 | 33.14 | 33.91 | 24047600.0 |
| 2001-10-11 10:00:00 | QQQ | ETF | 33.88 | 34.26 | 33.73 | 33.77 | 14873000.0 |
| 2001-10-11 10:30:00 | QQQ | ETF | 33.76 | 34.0 | 33.71 | 33.81 | 7437800.0 |
| 2001-10-11 11:00:00 | QQQ | ETF | 33.86 | 34.14 | 33.77 | 34.07 | 5817000.0 |
| 2001-10-11 11:30:00 | QQQ | ETF | 34.08 | 34.14 | 33.76 | 33.9 | 6131700.0 |
| 2001-10-11 12:00:00 | QQQ | ETF | 33.88 | 34.08 | 33.86 | 34.0 | 3303400.0 |
| 2001-10-11 12:30:00 | QQQ | ETF | 34.02 | 34.36 | 34.0 | 34.32 | 3927400.0 |
| 2001-10-11 13:00:00 | QQQ | ETF | 34.34 | 34.59 | 34.25 | 34.55 | 7088600.0 |
| 2001-10-11 13:30:00 | QQQ | ETF | 34.55 | 34.58 | 34.27 | 34.29 | 5600800.0 |
| 2001-10-11 14:00:00 | QQQ | ETF | 34.32 | 34.34 | 34.0 | 34.11 | 7421200.0 |
| 2001-10-11 14:30:00 | QQQ | ETF | 34.12 | 34.13 | 33.8 | 33.97 | 7278600.0 |
| 2001-10-11 15:00:00 | QQQ | ETF | 34.0 | 34.3 | 33.83 | 34.22 | 7285400.0 |
| 2001-10-11 15:30:00 | QQQ | ETF | 34.22 | 34.64 | 34.2 | 34.6 | 9769200.0 |
| 2001-10-11 16:00:00 | QQQ | ETF | 34.61 | 35.0 | 34.06 | 35.0 | 2481000.0 |
| 2001-10-11 16:30:00 | QQQ | ETF | 34.95 | 35.35 | 34.63 | 35.25 | 1126500.0 |
| 2001-10-11 17:00:00 | QQQ | ETF | 35.15 | 35.31 | 34.78 | 35.17 | 611400.0 |
| 2001-10-11 17:30:00 | QQQ | ETF | 35.2 | 35.32 | 34.78 | 35.25 | 321300.0 |
| 2001-10-11 18:00:00 | QQQ | ETF | 35.25 | 35.4 | 35.17 | 35.2 | 73000.0 |
| 2001-10-11 09:30:00 | IWM | ETF | 42.5 | 42.925 | 42.5 | 42.715 | 114400.0 |
| 2001-10-11 10:00:00 | IWM | ETF | 42.7 | 42.975 | 42.675 | 42.715 | 25400.0 |
| 2001-10-11 10:30:00 | IWM | ETF | 42.695 | 42.835 | 42.64 | 42.82 | 369000.0 |
| 2001-10-11 11:00:00 | IWM | ETF | 42.825 | 43.035 | 42.71 | 42.95 | 107600.0 |
| 2001-10-11 11:30:00 | IWM | ETF | 43.035 | 43.035 | 42.825 | 42.835 | 91800.0 |
| 2001-10-11 12:00:00 | IWM | ETF | 42.92 | 42.965 | 42.86 | 42.95 | 5000.0 |
| 2001-10-11 12:30:00 | IWM | ETF | 42.98 | 43.015 | 42.825 | 43.015 | 59000.0 |
| 2001-10-11 13:00:00 | IWM | ETF | 43.005 | 43.095 | 42.9 | 43.095 | 25000.0 |
| 2001-10-11 13:30:00 | IWM | ETF | 43.15 | 43.2 | 43.075 | 43.09 | 24200.0 |
| 2001-10-11 14:00:00 | IWM | ETF | 43.07 | 43.07 | 42.9 | 42.97 | 8000.0 |
| 2001-10-11 14:30:00 | IWM | ETF | 42.915 | 42.915 | 42.7 | 42.785 | 248400.0 |
| 2001-10-11 15:00:00 | IWM | ETF | 42.755 | 42.825 | 42.675 | 42.76 | 38200.0 |
| 2001-10-11 15:30:00 | IWM | ETF | 42.785 | 42.91 | 42.775 | 42.875 | 140600.0 |
| 2001-10-11 16:00:00 | IWM | ETF | 42.675 | 42.675 | 42.64 | 42.675 | 140000.0 |
> showing 50 of 445 rows — these rows as CSV