PREVIEW / etf_30min / 2002-08-08
file: by_date/etf_30min/2002/2002-08-08.parquet size: 20 KB rows: 557
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-08-08 09:30:00 | SPY | ETF | 88.42 | 89.15 | 87.82 | 88.71 | 8374200.0 |
| 2002-08-08 10:00:00 | SPY | ETF | 88.71 | 88.92 | 87.8 | 88.19 | 4501200.0 |
| 2002-08-08 10:30:00 | SPY | ETF | 88.19 | 88.5 | 87.92 | 88.25 | 2914600.0 |
| 2002-08-08 11:00:00 | SPY | ETF | 88.21 | 89.09 | 88.21 | 88.97 | 3105400.0 |
| 2002-08-08 11:30:00 | SPY | ETF | 88.99 | 89.29 | 88.7 | 89.03 | 2120100.0 |
| 2002-08-08 12:00:00 | SPY | ETF | 89.02 | 89.29 | 88.88 | 89.12 | 1615800.0 |
| 2002-08-08 12:30:00 | SPY | ETF | 89.15 | 89.3 | 88.85 | 89.01 | 1401300.0 |
| 2002-08-08 13:00:00 | SPY | ETF | 88.97 | 90.0 | 88.93 | 89.85 | 2032300.0 |
| 2002-08-08 13:30:00 | SPY | ETF | 89.84 | 90.03 | 89.63 | 89.75 | 2226000.0 |
| 2002-08-08 14:00:00 | SPY | ETF | 89.76 | 90.25 | 89.55 | 90.22 | 2660600.0 |
| 2002-08-08 14:30:00 | SPY | ETF | 90.25 | 90.7 | 90.1 | 90.7 | 4801000.0 |
| 2002-08-08 15:00:00 | SPY | ETF | 90.7 | 90.99 | 90.37 | 90.75 | 4435000.0 |
| 2002-08-08 15:30:00 | SPY | ETF | 90.72 | 91.1 | 90.71 | 90.98 | 4098300.0 |
| 2002-08-08 16:00:00 | SPY | ETF | 91.0 | 91.08 | 90.85 | 90.95 | 1347400.0 |
| 2002-08-08 09:30:00 | QQQ | ETF | 22.75 | 22.9 | 22.5 | 22.65 | 19019600.0 |
| 2002-08-08 10:00:00 | QQQ | ETF | 22.65 | 22.72 | 22.33 | 22.44 | 12269100.0 |
| 2002-08-08 10:30:00 | QQQ | ETF | 22.47 | 22.59 | 22.39 | 22.51 | 5543000.0 |
| 2002-08-08 11:00:00 | QQQ | ETF | 22.5 | 22.9 | 22.49 | 22.85 | 6815100.0 |
| 2002-08-08 11:30:00 | QQQ | ETF | 22.88 | 23.01 | 22.72 | 22.83 | 7579400.0 |
| 2002-08-08 12:00:00 | QQQ | ETF | 22.84 | 22.9 | 22.73 | 22.84 | 2815300.0 |
| 2002-08-08 12:30:00 | QQQ | ETF | 22.85 | 22.9 | 22.64 | 22.71 | 3009100.0 |
| 2002-08-08 13:00:00 | QQQ | ETF | 22.74 | 23.14 | 22.7 | 23.08 | 5505800.0 |
| 2002-08-08 13:30:00 | QQQ | ETF | 23.08 | 23.26 | 23.05 | 23.11 | 6018400.0 |
| 2002-08-08 14:00:00 | QQQ | ETF | 23.13 | 23.32 | 23.05 | 23.3 | 8661500.0 |
| 2002-08-08 14:30:00 | QQQ | ETF | 23.3 | 23.48 | 23.23 | 23.42 | 12207800.0 |
| 2002-08-08 15:00:00 | QQQ | ETF | 23.45 | 23.54 | 23.33 | 23.47 | 9188500.0 |
| 2002-08-08 15:30:00 | QQQ | ETF | 23.49 | 23.6 | 23.4 | 23.53 | 7899500.0 |
| 2002-08-08 16:00:00 | QQQ | ETF | 23.52 | 23.57 | 23.5 | 23.57 | 558400.0 |
| 2002-08-08 09:30:00 | IWM | ETF | 38.22 | 38.42 | 37.85 | 38.265 | 54000.0 |
| 2002-08-08 10:00:00 | IWM | ETF | 38.25 | 38.255 | 38.0 | 38.075 | 146600.0 |
| 2002-08-08 10:30:00 | IWM | ETF | 38.005 | 38.095 | 37.955 | 38.05 | 86400.0 |
| 2002-08-08 11:00:00 | IWM | ETF | 38.075 | 38.195 | 38.075 | 38.195 | 46800.0 |
| 2002-08-08 11:30:00 | IWM | ETF | 38.2 | 38.275 | 38.13 | 38.21 | 157800.0 |
| 2002-08-08 12:00:00 | IWM | ETF | 38.2 | 38.225 | 38.15 | 38.155 | 65800.0 |
| 2002-08-08 12:30:00 | IWM | ETF | 38.195 | 38.225 | 38.125 | 38.125 | 18400.0 |
| 2002-08-08 13:00:00 | IWM | ETF | 38.15 | 38.295 | 38.15 | 38.295 | 219600.0 |
| 2002-08-08 13:30:00 | IWM | ETF | 38.305 | 38.5 | 38.305 | 38.38 | 145800.0 |
| 2002-08-08 14:00:00 | IWM | ETF | 38.37 | 38.535 | 38.345 | 38.52 | 195000.0 |
| 2002-08-08 14:30:00 | IWM | ETF | 38.535 | 38.875 | 38.5 | 38.805 | 517000.0 |
| 2002-08-08 15:00:00 | IWM | ETF | 38.81 | 38.895 | 38.645 | 38.72 | 309000.0 |
| 2002-08-08 15:30:00 | IWM | ETF | 38.765 | 38.895 | 38.725 | 38.85 | 134400.0 |
| 2002-08-08 16:00:00 | IWM | ETF | 38.895 | 38.895 | 38.835 | 38.835 | 20400.0 |
| 2002-08-08 09:30:00 | DIA | ETF | 85.08 | 85.66 | 84.34 | 85.2 | 2330000.0 |
| 2002-08-08 10:00:00 | DIA | ETF | 85.2 | 85.39 | 84.35 | 84.7 | 1171900.0 |
| 2002-08-08 10:30:00 | DIA | ETF | 84.7 | 84.99 | 84.42 | 84.66 | 922300.0 |
| 2002-08-08 11:00:00 | DIA | ETF | 84.65 | 85.46 | 84.63 | 85.36 | 938100.0 |
| 2002-08-08 11:30:00 | DIA | ETF | 85.35 | 85.61 | 85.0 | 85.34 | 699100.0 |
| 2002-08-08 12:00:00 | DIA | ETF | 85.35 | 85.59 | 85.17 | 85.41 | 500000.0 |
| 2002-08-08 12:30:00 | DIA | ETF | 85.47 | 85.66 | 85.14 | 85.27 | 832700.0 |
| 2002-08-08 13:00:00 | DIA | ETF | 85.27 | 86.1 | 85.23 | 85.97 | 622400.0 |
> showing 50 of 557 rows — these rows as CSV