PREVIEW / etf_30min / 2002-02-01
file: by_date/etf_30min/2002/2002-02-01.parquet size: 17 KB rows: 448
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 |
|---|---|---|---|---|---|---|---|
| 2002-02-01 08:00:00 | SPY | ETF | 112.755 | 112.8256 | 112.2791 | 112.6493 | 9190.0 |
| 2002-02-01 08:30:00 | SPY | ETF | 112.6493 | 113.2663 | 112.6493 | 113.1253 | 133610.0 |
| 2002-02-01 09:00:00 | SPY | ETF | 113.0019 | 113.1781 | 112.3143 | 113.1253 | 194480.0 |
| 2002-02-01 09:30:00 | SPY | ETF | 113.09 | 113.4315 | 112.1802 | 113.101 | 2594940.0 |
| 2002-02-01 10:00:00 | SPY | ETF | 113.0929 | 113.3075 | 112.5263 | 112.8054 | 1679390.0 |
| 2002-02-01 10:30:00 | SPY | ETF | 112.8481 | 113.059 | 112.4228 | 112.5383 | 1214570.0 |
| 2002-02-01 11:00:00 | SPY | ETF | 112.5282 | 112.888 | 112.0511 | 112.1115 | 958940.0 |
| 2002-02-01 11:30:00 | SPY | ETF | 112.119 | 112.4437 | 111.7523 | 112.2846 | 962130.0 |
| 2002-02-01 12:00:00 | SPY | ETF | 112.2921 | 112.3805 | 111.2202 | 111.679 | 1467570.0 |
| 2002-02-01 12:30:00 | SPY | ETF | 111.6866 | 111.7562 | 111.0405 | 111.6217 | 941040.0 |
| 2002-02-01 13:00:00 | SPY | ETF | 111.6648 | 112.0019 | 111.1607 | 111.7068 | 772070.0 |
| 2002-02-01 13:30:00 | SPY | ETF | 111.7144 | 112.0855 | 111.5721 | 111.7035 | 695790.0 |
| 2002-02-01 14:00:00 | SPY | ETF | 111.7111 | 112.72 | 111.5863 | 112.59 | 537820.0 |
| 2002-02-01 14:30:00 | SPY | ETF | 112.61 | 112.8 | 112.3 | 112.4 | 476500.0 |
| 2002-02-01 15:00:00 | SPY | ETF | 112.41 | 112.6 | 112.36 | 112.5 | 789200.0 |
| 2002-02-01 15:30:00 | SPY | ETF | 112.55 | 112.64 | 112.32 | 112.6 | 1617600.0 |
| 2002-02-01 16:00:00 | SPY | ETF | 112.55 | 113.8006 | 112.5421 | 112.9916 | 953780.0 |
| 2002-02-01 16:30:00 | SPY | ETF | 112.6 | 113.9085 | 112.2185 | 112.2185 | 7520.0 |
| 2002-02-01 17:00:00 | SPY | ETF | 112.5961 | 112.632 | 112.5601 | 112.614 | 1280.0 |
| 2002-02-01 17:30:00 | SPY | ETF | 112.5601 | 112.632 | 112.5601 | 112.632 | 390.0 |
| 2002-02-01 09:30:00 | QQQ | ETF | 38.4 | 38.68 | 38.3 | 38.61 | 6203800.0 |
| 2002-02-01 10:00:00 | QQQ | ETF | 38.58 | 38.88 | 38.41 | 38.67 | 8303000.0 |
| 2002-02-01 10:30:00 | QQQ | ETF | 38.65 | 38.74 | 38.35 | 38.39 | 4517000.0 |
| 2002-02-01 11:00:00 | QQQ | ETF | 38.37 | 38.51 | 38.22 | 38.27 | 5172800.0 |
| 2002-02-01 11:30:00 | QQQ | ETF | 38.27 | 38.39 | 38.04 | 38.06 | 6094000.0 |
| 2002-02-01 12:00:00 | QQQ | ETF | 38.13 | 38.3 | 37.79 | 37.87 | 5147800.0 |
| 2002-02-01 12:30:00 | QQQ | ETF | 37.87 | 37.95 | 37.7 | 37.91 | 4090500.0 |
| 2002-02-01 13:00:00 | QQQ | ETF | 37.92 | 38.07 | 37.87 | 38.04 | 2333200.0 |
| 2002-02-01 13:30:00 | QQQ | ETF | 38.02 | 38.13 | 37.93 | 37.98 | 2276600.0 |
| 2002-02-01 14:00:00 | QQQ | ETF | 37.97 | 38.21 | 37.93 | 38.15 | 2963500.0 |
| 2002-02-01 14:30:00 | QQQ | ETF | 38.13 | 38.35 | 38.03 | 38.05 | 4622500.0 |
| 2002-02-01 15:00:00 | QQQ | ETF | 38.08 | 38.24 | 38.01 | 38.18 | 2461600.0 |
| 2002-02-01 15:30:00 | QQQ | ETF | 38.17 | 38.25 | 38.01 | 38.06 | 4442600.0 |
| 2002-02-01 16:00:00 | QQQ | ETF | 38.06 | 38.18 | 38.03 | 38.12 | 2257200.0 |
| 2002-02-01 16:30:00 | QQQ | ETF | 38.07 | 38.85 | 38.0 | 38.07 | 65900.0 |
| 2002-02-01 17:00:00 | QQQ | ETF | 38.08 | 38.16 | 38.08 | 38.12 | 7500.0 |
| 2002-02-01 17:30:00 | QQQ | ETF | 38.16 | 38.16 | 38.07 | 38.07 | 3500.0 |
| 2002-02-01 18:00:00 | QQQ | ETF | 38.14 | 38.14 | 38.08 | 38.08 | 4900.0 |
| 2002-02-01 09:30:00 | IWM | ETF | 47.75 | 48.075 | 47.735 | 48.075 | 45200.0 |
| 2002-02-01 10:00:00 | IWM | ETF | 47.9 | 48.185 | 47.84 | 48.175 | 21200.0 |
| 2002-02-01 10:30:00 | IWM | ETF | 48.175 | 48.175 | 47.98 | 47.98 | 10200.0 |
| 2002-02-01 11:00:00 | IWM | ETF | 48.035 | 48.035 | 47.855 | 47.855 | 38400.0 |
| 2002-02-01 11:30:00 | IWM | ETF | 47.855 | 47.955 | 47.81 | 47.815 | 44400.0 |
| 2002-02-01 12:00:00 | IWM | ETF | 47.815 | 47.815 | 47.645 | 47.7 | 67000.0 |
| 2002-02-01 12:30:00 | IWM | ETF | 47.715 | 47.735 | 47.615 | 47.735 | 43600.0 |
| 2002-02-01 13:00:00 | IWM | ETF | 47.7 | 47.795 | 47.655 | 47.78 | 29600.0 |
| 2002-02-01 13:30:00 | IWM | ETF | 47.865 | 47.895 | 47.795 | 47.8 | 2400.0 |
| 2002-02-01 14:00:00 | IWM | ETF | 47.86 | 47.935 | 47.785 | 47.935 | 7400.0 |
| 2002-02-01 14:30:00 | IWM | ETF | 47.955 | 47.975 | 47.835 | 47.835 | 9600.0 |
| 2002-02-01 15:00:00 | IWM | ETF | 47.885 | 47.945 | 47.835 | 47.865 | 8600.0 |
> showing 50 of 448 rows — these rows as CSV