PREVIEW / etf_30min / 2002-03-22
file: by_date/etf_30min/2002/2002-03-22.parquet size: 17 KB rows: 453
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-03-22 09:30:00 | SPY | ETF | 115.5 | 115.5 | 114.89 | 115.05 | 1894200.0 |
| 2002-03-22 10:00:00 | SPY | ETF | 115.07 | 115.23 | 114.7 | 114.87 | 1112600.0 |
| 2002-03-22 10:30:00 | SPY | ETF | 114.88 | 115.32 | 114.83 | 115.27 | 1176700.0 |
| 2002-03-22 11:00:00 | SPY | ETF | 115.29 | 115.46 | 115.08 | 115.35 | 1061200.0 |
| 2002-03-22 11:30:00 | SPY | ETF | 115.4 | 115.55 | 115.25 | 115.3 | 955000.0 |
| 2002-03-22 12:00:00 | SPY | ETF | 115.3 | 115.75 | 115.28 | 115.66 | 587300.0 |
| 2002-03-22 12:30:00 | SPY | ETF | 115.67 | 115.94 | 115.62 | 115.72 | 1349000.0 |
| 2002-03-22 13:00:00 | SPY | ETF | 115.74 | 115.82 | 115.45 | 115.56 | 593400.0 |
| 2002-03-22 13:30:00 | SPY | ETF | 115.55 | 115.61 | 115.42 | 115.46 | 927800.0 |
| 2002-03-22 14:00:00 | SPY | ETF | 115.5 | 115.5 | 115.03 | 115.18 | 1099500.0 |
| 2002-03-22 14:30:00 | SPY | ETF | 115.22 | 115.33 | 115.1 | 115.22 | 738800.0 |
| 2002-03-22 15:00:00 | SPY | ETF | 115.22 | 115.25 | 114.87 | 115.17 | 1045100.0 |
| 2002-03-22 15:30:00 | SPY | ETF | 115.2 | 115.24 | 114.98 | 115.09 | 994000.0 |
| 2002-03-22 16:00:00 | SPY | ETF | 115.12 | 115.37 | 114.98 | 115.03 | 1102200.0 |
| 2002-03-22 17:00:00 | SPY | ETF | 115.0 | 115.0 | 115.0 | 115.0 | 400.0 |
| 2002-03-22 09:30:00 | QQQ | ETF | 36.94 | 37.02 | 36.68 | 36.79 | 7786300.0 |
| 2002-03-22 10:00:00 | QQQ | ETF | 36.8 | 36.87 | 36.47 | 36.62 | 7439700.0 |
| 2002-03-22 10:30:00 | QQQ | ETF | 36.62 | 36.85 | 36.55 | 36.85 | 5860000.0 |
| 2002-03-22 11:00:00 | QQQ | ETF | 36.85 | 36.88 | 36.68 | 36.82 | 3063000.0 |
| 2002-03-22 11:30:00 | QQQ | ETF | 36.82 | 37.0 | 36.8 | 36.86 | 4113900.0 |
| 2002-03-22 12:00:00 | QQQ | ETF | 36.85 | 37.05 | 36.83 | 36.95 | 2704100.0 |
| 2002-03-22 12:30:00 | QQQ | ETF | 36.97 | 37.14 | 36.92 | 36.92 | 3764400.0 |
| 2002-03-22 13:00:00 | QQQ | ETF | 36.93 | 37.0 | 36.79 | 36.87 | 3381400.0 |
| 2002-03-22 13:30:00 | QQQ | ETF | 36.87 | 36.95 | 36.79 | 36.89 | 2432400.0 |
| 2002-03-22 14:00:00 | QQQ | ETF | 36.88 | 36.9 | 36.61 | 36.74 | 4755100.0 |
| 2002-03-22 14:30:00 | QQQ | ETF | 36.71 | 36.83 | 36.66 | 36.8 | 2891700.0 |
| 2002-03-22 15:00:00 | QQQ | ETF | 36.77 | 36.8 | 36.53 | 36.68 | 3699300.0 |
| 2002-03-22 15:30:00 | QQQ | ETF | 36.67 | 36.75 | 36.58 | 36.62 | 3323200.0 |
| 2002-03-22 16:00:00 | QQQ | ETF | 36.62 | 36.71 | 36.58 | 36.7 | 925200.0 |
| 2002-03-22 16:30:00 | QQQ | ETF | 36.7 | 36.81 | 36.65 | 36.7 | 132500.0 |
| 2002-03-22 17:00:00 | QQQ | ETF | 36.66 | 36.67 | 36.62 | 36.62 | 9400.0 |
| 2002-03-22 17:30:00 | QQQ | ETF | 36.62 | 36.63 | 36.61 | 36.63 | 7000.0 |
| 2002-03-22 18:00:00 | QQQ | ETF | 36.62 | 36.65 | 36.62 | 36.65 | 1100.0 |
| 2002-03-22 09:30:00 | IWM | ETF | 50.275 | 50.275 | 50.06 | 50.13 | 45200.0 |
| 2002-03-22 10:00:00 | IWM | ETF | 50.075 | 50.13 | 49.945 | 49.945 | 12200.0 |
| 2002-03-22 10:30:00 | IWM | ETF | 49.995 | 50.24 | 49.995 | 50.205 | 75800.0 |
| 2002-03-22 11:00:00 | IWM | ETF | 50.19 | 50.34 | 50.19 | 50.34 | 32400.0 |
| 2002-03-22 11:30:00 | IWM | ETF | 50.34 | 50.45 | 50.27 | 50.335 | 69800.0 |
| 2002-03-22 12:00:00 | IWM | ETF | 50.33 | 50.495 | 50.3 | 50.495 | 38200.0 |
| 2002-03-22 12:30:00 | IWM | ETF | 50.44 | 50.555 | 50.44 | 50.545 | 40200.0 |
| 2002-03-22 13:00:00 | IWM | ETF | 50.405 | 50.47 | 50.335 | 50.38 | 17600.0 |
| 2002-03-22 13:30:00 | IWM | ETF | 50.375 | 50.375 | 50.265 | 50.265 | 25000.0 |
| 2002-03-22 14:00:00 | IWM | ETF | 50.265 | 50.29 | 50.135 | 50.135 | 56600.0 |
| 2002-03-22 14:30:00 | IWM | ETF | 50.15 | 50.23 | 50.135 | 50.15 | 18800.0 |
| 2002-03-22 15:00:00 | IWM | ETF | 50.16 | 50.21 | 50.045 | 50.14 | 31800.0 |
| 2002-03-22 15:30:00 | IWM | ETF | 50.14 | 50.14 | 49.905 | 49.905 | 462400.0 |
| 2002-03-22 16:00:00 | IWM | ETF | 49.88 | 49.95 | 49.88 | 49.9 | 40400.0 |
| 2002-03-22 09:30:00 | DIA | ETF | 104.76 | 104.76 | 104.16 | 104.28 | 205000.0 |
| 2002-03-22 10:00:00 | DIA | ETF | 104.31 | 104.4 | 103.96 | 104.07 | 338700.0 |
| 2002-03-22 10:30:00 | DIA | ETF | 104.08 | 104.45 | 104.08 | 104.36 | 394300.0 |
> showing 50 of 453 rows — these rows as CSV