PREVIEW / etf_30min / 2002-08-21
file: by_date/etf_30min/2002/2002-08-21.parquet size: 20 KB rows: 584
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-21 09:30:00 | SPY | ETF | 95.06 | 95.48 | 94.82 | 94.89 | 4790400.0 |
| 2002-08-21 10:00:00 | SPY | ETF | 94.94 | 94.96 | 93.95 | 94.0 | 2999900.0 |
| 2002-08-21 10:30:00 | SPY | ETF | 94.01 | 94.18 | 93.75 | 93.85 | 3934200.0 |
| 2002-08-21 11:00:00 | SPY | ETF | 93.81 | 94.38 | 93.57 | 94.21 | 2344200.0 |
| 2002-08-21 11:30:00 | SPY | ETF | 94.21 | 94.5 | 94.09 | 94.46 | 1871900.0 |
| 2002-08-21 12:00:00 | SPY | ETF | 94.46 | 94.97 | 94.43 | 94.94 | 2665200.0 |
| 2002-08-21 12:30:00 | SPY | ETF | 94.95 | 95.2 | 94.7 | 95.07 | 2109800.0 |
| 2002-08-21 13:00:00 | SPY | ETF | 95.07 | 95.28 | 94.85 | 94.95 | 1413300.0 |
| 2002-08-21 13:30:00 | SPY | ETF | 94.92 | 95.4 | 94.78 | 95.24 | 1445500.0 |
| 2002-08-21 14:00:00 | SPY | ETF | 95.24 | 95.75 | 95.17 | 95.25 | 3557300.0 |
| 2002-08-21 14:30:00 | SPY | ETF | 95.22 | 95.32 | 94.18 | 94.47 | 3722100.0 |
| 2002-08-21 15:00:00 | SPY | ETF | 94.46 | 94.95 | 94.25 | 94.43 | 2200200.0 |
| 2002-08-21 15:30:00 | SPY | ETF | 94.43 | 95.55 | 94.34 | 95.5 | 3618900.0 |
| 2002-08-21 16:00:00 | SPY | ETF | 95.4 | 95.78 | 95.28 | 95.75 | 963400.0 |
| 2002-08-21 09:30:00 | QQQ | ETF | 25.39 | 25.63 | 25.35 | 25.46 | 14037800.0 |
| 2002-08-21 10:00:00 | QQQ | ETF | 25.46 | 25.5 | 25.1 | 25.16 | 10485600.0 |
| 2002-08-21 10:30:00 | QQQ | ETF | 25.17 | 25.24 | 25.05 | 25.1 | 6059600.0 |
| 2002-08-21 11:00:00 | QQQ | ETF | 25.1 | 25.29 | 25.0 | 25.24 | 5397100.0 |
| 2002-08-21 11:30:00 | QQQ | ETF | 25.24 | 25.4 | 25.19 | 25.3 | 3555800.0 |
| 2002-08-21 12:00:00 | QQQ | ETF | 25.29 | 25.52 | 25.28 | 25.48 | 4500700.0 |
| 2002-08-21 12:30:00 | QQQ | ETF | 25.44 | 25.59 | 25.43 | 25.55 | 5224600.0 |
| 2002-08-21 13:00:00 | QQQ | ETF | 25.56 | 25.59 | 25.46 | 25.52 | 2851200.0 |
| 2002-08-21 13:30:00 | QQQ | ETF | 25.51 | 25.77 | 25.44 | 25.7 | 6836900.0 |
| 2002-08-21 14:00:00 | QQQ | ETF | 25.7 | 25.85 | 25.66 | 25.66 | 8726200.0 |
| 2002-08-21 14:30:00 | QQQ | ETF | 25.68 | 25.69 | 25.25 | 25.38 | 10147100.0 |
| 2002-08-21 15:00:00 | QQQ | ETF | 25.38 | 25.56 | 25.32 | 25.37 | 6903200.0 |
| 2002-08-21 15:30:00 | QQQ | ETF | 25.35 | 25.76 | 25.32 | 25.7 | 11479000.0 |
| 2002-08-21 16:00:00 | QQQ | ETF | 25.68 | 25.78 | 25.66 | 25.75 | 923300.0 |
| 2002-08-21 09:30:00 | IWM | ETF | 39.945 | 40.225 | 39.945 | 40.1 | 283000.0 |
| 2002-08-21 10:00:00 | IWM | ETF | 40.075 | 40.075 | 39.785 | 39.785 | 263400.0 |
| 2002-08-21 10:30:00 | IWM | ETF | 39.765 | 39.825 | 39.685 | 39.8 | 103200.0 |
| 2002-08-21 11:00:00 | IWM | ETF | 39.745 | 39.88 | 39.7 | 39.88 | 185000.0 |
| 2002-08-21 11:30:00 | IWM | ETF | 39.88 | 39.895 | 39.77 | 39.785 | 71200.0 |
| 2002-08-21 12:00:00 | IWM | ETF | 39.865 | 40.075 | 39.865 | 40.075 | 148200.0 |
| 2002-08-21 12:30:00 | IWM | ETF | 40.19 | 40.305 | 40.085 | 40.305 | 463800.0 |
| 2002-08-21 13:00:00 | IWM | ETF | 40.305 | 40.315 | 40.235 | 40.285 | 10200.0 |
| 2002-08-21 13:30:00 | IWM | ETF | 40.275 | 40.345 | 40.215 | 40.345 | 23800.0 |
| 2002-08-21 14:00:00 | IWM | ETF | 40.375 | 40.48 | 40.325 | 40.34 | 110200.0 |
| 2002-08-21 14:30:00 | IWM | ETF | 40.335 | 40.335 | 39.94 | 39.995 | 323200.0 |
| 2002-08-21 15:00:00 | IWM | ETF | 39.975 | 40.205 | 39.91 | 40.165 | 133400.0 |
| 2002-08-21 15:30:00 | IWM | ETF | 40.14 | 40.65 | 40.1 | 40.64 | 193000.0 |
| 2002-08-21 09:30:00 | DIA | ETF | 89.45 | 89.9 | 89.31 | 89.5 | 1614100.0 |
| 2002-08-21 10:00:00 | DIA | ETF | 89.52 | 89.55 | 88.51 | 88.59 | 1121200.0 |
| 2002-08-21 10:30:00 | DIA | ETF | 88.61 | 88.8 | 88.25 | 88.37 | 1145800.0 |
| 2002-08-21 11:00:00 | DIA | ETF | 88.3 | 88.85 | 88.06 | 88.61 | 895700.0 |
| 2002-08-21 11:30:00 | DIA | ETF | 88.61 | 88.93 | 88.53 | 88.85 | 420300.0 |
| 2002-08-21 12:00:00 | DIA | ETF | 88.87 | 89.31 | 88.83 | 89.31 | 568100.0 |
| 2002-08-21 12:30:00 | DIA | ETF | 89.32 | 89.6 | 89.01 | 89.48 | 482200.0 |
| 2002-08-21 13:00:00 | DIA | ETF | 89.48 | 89.63 | 89.3 | 89.35 | 519300.0 |
| 2002-08-21 13:30:00 | DIA | ETF | 89.35 | 89.7 | 89.16 | 89.52 | 486400.0 |
> showing 50 of 584 rows — these rows as CSV