PREVIEW / etf_30min / 2002-10-17
file: by_date/etf_30min/2002/2002-10-17.parquet size: 21 KB rows: 655
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-10-17 08:00:00 | SPY | ETF | 88.59 | 88.84 | 88.45 | 88.76 | 5900.0 |
| 2002-10-17 08:30:00 | SPY | ETF | 88.7 | 88.84 | 88.5 | 88.69 | 5200.0 |
| 2002-10-17 09:00:00 | SPY | ETF | 88.99 | 89.05 | 88.87 | 88.87 | 120200.0 |
| 2002-10-17 09:30:00 | SPY | ETF | 88.87 | 89.23 | 88.28 | 88.42 | 10457800.0 |
| 2002-10-17 10:00:00 | SPY | ETF | 88.44 | 88.59 | 87.91 | 88.38 | 6661100.0 |
| 2002-10-17 10:30:00 | SPY | ETF | 88.4 | 88.46 | 87.95 | 88.23 | 3873900.0 |
| 2002-10-17 11:00:00 | SPY | ETF | 88.19 | 88.44 | 88.0 | 88.26 | 2906100.0 |
| 2002-10-17 11:30:00 | SPY | ETF | 88.27 | 88.56 | 88.16 | 88.32 | 2971800.0 |
| 2002-10-17 12:00:00 | SPY | ETF | 88.35 | 88.39 | 87.85 | 88.25 | 4694000.0 |
| 2002-10-17 12:30:00 | SPY | ETF | 88.23 | 88.44 | 88.09 | 88.15 | 2664200.0 |
| 2002-10-17 13:00:00 | SPY | ETF | 88.14 | 88.35 | 88.02 | 88.27 | 1959800.0 |
| 2002-10-17 13:30:00 | SPY | ETF | 88.27 | 88.54 | 88.12 | 88.36 | 2023800.0 |
| 2002-10-17 14:00:00 | SPY | ETF | 88.36 | 88.62 | 88.25 | 88.25 | 3711700.0 |
| 2002-10-17 14:30:00 | SPY | ETF | 88.23 | 88.47 | 87.85 | 88.03 | 4192100.0 |
| 2002-10-17 15:00:00 | SPY | ETF | 88.05 | 88.19 | 87.93 | 88.12 | 2650700.0 |
| 2002-10-17 15:30:00 | SPY | ETF | 88.14 | 88.33 | 88.0 | 88.17 | 4724600.0 |
| 2002-10-17 16:00:00 | SPY | ETF | 88.17 | 89.75 | 88.0 | 89.2 | 6454100.0 |
| 2002-10-17 16:30:00 | SPY | ETF | 89.2 | 89.5 | 88.01 | 88.97 | 2146900.0 |
| 2002-10-17 17:00:00 | SPY | ETF | 89.0 | 89.18 | 88.84 | 89.05 | 289700.0 |
| 2002-10-17 17:30:00 | SPY | ETF | 89.1 | 89.2 | 88.9 | 88.98 | 60500.0 |
| 2002-10-17 18:00:00 | SPY | ETF | 88.98 | 89.12 | 88.95 | 88.96 | 34000.0 |
| 2002-10-17 18:30:00 | SPY | ETF | 89.19 | 89.19 | 89.19 | 89.19 | 100.0 |
| 2002-10-17 19:00:00 | SPY | ETF | 89.09 | 89.09 | 89.09 | 89.09 | 100.0 |
| 2002-10-17 19:30:00 | SPY | ETF | 89.19 | 89.19 | 89.17 | 89.17 | 500.0 |
| 2002-10-17 08:00:00 | QQQ | ETF | 23.46 | 23.48 | 23.46 | 23.46 | 4100.0 |
| 2002-10-17 08:30:00 | QQQ | ETF | 23.43 | 23.52 | 23.41 | 23.49 | 62600.0 |
| 2002-10-17 09:00:00 | QQQ | ETF | 23.47 | 23.61 | 23.47 | 23.61 | 100200.0 |
| 2002-10-17 09:30:00 | QQQ | ETF | 23.6 | 23.81 | 23.45 | 23.48 | 18287600.0 |
| 2002-10-17 10:00:00 | QQQ | ETF | 23.47 | 23.55 | 23.3 | 23.49 | 11093800.0 |
| 2002-10-17 10:30:00 | QQQ | ETF | 23.5 | 23.52 | 23.37 | 23.44 | 5669000.0 |
| 2002-10-17 11:00:00 | QQQ | ETF | 23.42 | 23.49 | 23.37 | 23.45 | 6526900.0 |
| 2002-10-17 11:30:00 | QQQ | ETF | 23.47 | 23.6 | 23.44 | 23.5 | 4701400.0 |
| 2002-10-17 12:00:00 | QQQ | ETF | 23.48 | 23.55 | 23.31 | 23.51 | 6232400.0 |
| 2002-10-17 12:30:00 | QQQ | ETF | 23.5 | 23.64 | 23.5 | 23.54 | 3268900.0 |
| 2002-10-17 13:00:00 | QQQ | ETF | 23.54 | 23.6 | 23.51 | 23.6 | 1911000.0 |
| 2002-10-17 13:30:00 | QQQ | ETF | 23.6 | 23.73 | 23.56 | 23.6 | 3762200.0 |
| 2002-10-17 14:00:00 | QQQ | ETF | 23.6 | 23.69 | 23.53 | 23.53 | 3236500.0 |
| 2002-10-17 14:30:00 | QQQ | ETF | 23.52 | 23.59 | 23.35 | 23.42 | 6023900.0 |
| 2002-10-17 15:00:00 | QQQ | ETF | 23.42 | 23.5 | 23.38 | 23.45 | 3667300.0 |
| 2002-10-17 15:30:00 | QQQ | ETF | 23.46 | 23.54 | 23.3 | 23.46 | 8793300.0 |
| 2002-10-17 16:00:00 | QQQ | ETF | 23.45 | 24.2 | 23.35 | 24.04 | 6691700.0 |
| 2002-10-17 16:30:00 | QQQ | ETF | 24.05 | 24.1 | 23.08 | 23.9 | 2496100.0 |
| 2002-10-17 17:00:00 | QQQ | ETF | 23.92 | 23.99 | 23.79 | 23.93 | 1147600.0 |
| 2002-10-17 17:30:00 | QQQ | ETF | 23.94 | 23.98 | 23.85 | 23.89 | 669700.0 |
| 2002-10-17 18:00:00 | QQQ | ETF | 23.85 | 23.94 | 23.76 | 23.82 | 379700.0 |
| 2002-10-17 18:30:00 | QQQ | ETF | 23.85 | 23.91 | 23.83 | 23.9 | 9100.0 |
| 2002-10-17 19:00:00 | QQQ | ETF | 23.9 | 23.91 | 23.85 | 23.86 | 22700.0 |
| 2002-10-17 19:30:00 | QQQ | ETF | 23.9 | 23.93 | 23.88 | 23.9 | 8800.0 |
| 2002-10-17 09:00:00 | IWM | ETF | 35.785 | 35.785 | 35.7 | 35.7 | 3000.0 |
| 2002-10-17 09:30:00 | IWM | ETF | 35.935 | 36.195 | 35.77 | 35.8 | 521600.0 |
> showing 50 of 655 rows — these rows as CSV