PREVIEW / etf_30min / 2002-07-30
file: by_date/etf_30min/2002/2002-07-30.parquet size: 21 KB rows: 585
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-07-30 09:30:00 | SPY | ETF | 89.32 | 89.6 | 89.0 | 89.27 | 4743600.0 |
| 2002-07-30 10:00:00 | SPY | ETF | 89.26 | 89.83 | 88.72 | 89.52 | 5667200.0 |
| 2002-07-30 10:30:00 | SPY | ETF | 89.51 | 89.75 | 88.95 | 89.37 | 2101100.0 |
| 2002-07-30 11:00:00 | SPY | ETF | 89.37 | 89.41 | 88.77 | 89.24 | 2842000.0 |
| 2002-07-30 11:30:00 | SPY | ETF | 89.2 | 89.53 | 89.1 | 89.42 | 1437500.0 |
| 2002-07-30 12:00:00 | SPY | ETF | 89.44 | 90.2 | 89.38 | 90.18 | 2160600.0 |
| 2002-07-30 12:30:00 | SPY | ETF | 90.15 | 90.57 | 90.03 | 90.12 | 3443500.0 |
| 2002-07-30 13:00:00 | SPY | ETF | 90.15 | 91.3 | 90.01 | 91.18 | 4090600.0 |
| 2002-07-30 13:30:00 | SPY | ETF | 91.15 | 91.4 | 90.72 | 91.27 | 3285800.0 |
| 2002-07-30 14:00:00 | SPY | ETF | 91.33 | 91.34 | 90.3 | 90.37 | 3739200.0 |
| 2002-07-30 14:30:00 | SPY | ETF | 90.36 | 90.59 | 89.66 | 89.73 | 3458500.0 |
| 2002-07-30 15:00:00 | SPY | ETF | 89.7 | 90.68 | 89.59 | 90.5 | 3445600.0 |
| 2002-07-30 15:30:00 | SPY | ETF | 90.56 | 90.76 | 89.9 | 90.63 | 3421000.0 |
| 2002-07-30 16:00:00 | SPY | ETF | 90.7 | 90.94 | 90.55 | 90.94 | 1558100.0 |
| 2002-07-30 09:30:00 | QQQ | ETF | 23.73 | 23.9 | 23.61 | 23.82 | 15353100.0 |
| 2002-07-30 10:00:00 | QQQ | ETF | 23.82 | 24.05 | 23.59 | 24.0 | 15518300.0 |
| 2002-07-30 10:30:00 | QQQ | ETF | 24.0 | 24.05 | 23.77 | 23.95 | 7970700.0 |
| 2002-07-30 11:00:00 | QQQ | ETF | 23.98 | 23.99 | 23.82 | 23.99 | 4547100.0 |
| 2002-07-30 11:30:00 | QQQ | ETF | 23.99 | 24.05 | 23.91 | 23.99 | 3655100.0 |
| 2002-07-30 12:00:00 | QQQ | ETF | 24.0 | 24.22 | 23.97 | 24.19 | 6893400.0 |
| 2002-07-30 12:30:00 | QQQ | ETF | 24.19 | 24.34 | 24.16 | 24.28 | 7201000.0 |
| 2002-07-30 13:00:00 | QQQ | ETF | 24.28 | 24.69 | 24.21 | 24.63 | 11635700.0 |
| 2002-07-30 13:30:00 | QQQ | ETF | 24.63 | 24.68 | 24.42 | 24.61 | 7865400.0 |
| 2002-07-30 14:00:00 | QQQ | ETF | 24.61 | 24.66 | 24.28 | 24.35 | 6841600.0 |
| 2002-07-30 14:30:00 | QQQ | ETF | 24.35 | 24.48 | 24.07 | 24.1 | 9489900.0 |
| 2002-07-30 15:00:00 | QQQ | ETF | 24.12 | 24.39 | 24.06 | 24.34 | 6968100.0 |
| 2002-07-30 15:30:00 | QQQ | ETF | 24.35 | 24.4 | 24.15 | 24.34 | 9153700.0 |
| 2002-07-30 16:00:00 | QQQ | ETF | 24.36 | 24.36 | 24.28 | 24.31 | 815900.0 |
| 2002-07-30 09:30:00 | IWM | ETF | 39.85 | 39.85 | 39.5 | 39.725 | 822200.0 |
| 2002-07-30 10:00:00 | IWM | ETF | 39.6 | 39.7 | 39.25 | 39.35 | 380000.0 |
| 2002-07-30 10:30:00 | IWM | ETF | 39.415 | 39.435 | 39.005 | 39.155 | 202800.0 |
| 2002-07-30 11:00:00 | IWM | ETF | 39.1 | 39.125 | 38.76 | 38.98 | 105000.0 |
| 2002-07-30 11:30:00 | IWM | ETF | 39.005 | 39.125 | 38.975 | 39.035 | 61800.0 |
| 2002-07-30 12:00:00 | IWM | ETF | 38.99 | 39.58 | 38.99 | 39.58 | 152000.0 |
| 2002-07-30 12:30:00 | IWM | ETF | 39.6 | 39.95 | 39.595 | 39.78 | 168200.0 |
| 2002-07-30 13:00:00 | IWM | ETF | 39.765 | 40.185 | 39.765 | 40.185 | 87800.0 |
| 2002-07-30 13:30:00 | IWM | ETF | 40.1 | 40.2 | 39.925 | 40.185 | 252400.0 |
| 2002-07-30 14:00:00 | IWM | ETF | 40.195 | 40.215 | 39.9 | 39.9 | 53200.0 |
| 2002-07-30 14:30:00 | IWM | ETF | 39.92 | 40.1 | 39.62 | 39.62 | 381800.0 |
| 2002-07-30 15:00:00 | IWM | ETF | 39.61 | 39.95 | 39.55 | 39.86 | 431000.0 |
| 2002-07-30 15:30:00 | IWM | ETF | 39.83 | 40.0 | 39.655 | 40.0 | 218600.0 |
| 2002-07-30 16:00:00 | IWM | ETF | 40.1 | 40.1 | 39.895 | 39.895 | 20200.0 |
| 2002-07-30 09:30:00 | DIA | ETF | 86.35 | 86.6 | 86.02 | 86.36 | 2024300.0 |
| 2002-07-30 10:00:00 | DIA | ETF | 86.28 | 86.75 | 85.65 | 86.36 | 2098100.0 |
| 2002-07-30 10:30:00 | DIA | ETF | 86.34 | 86.5 | 85.8 | 86.1 | 859600.0 |
| 2002-07-30 11:00:00 | DIA | ETF | 86.1 | 86.14 | 85.41 | 85.9 | 932500.0 |
| 2002-07-30 11:30:00 | DIA | ETF | 85.92 | 86.3 | 85.78 | 86.17 | 545000.0 |
| 2002-07-30 12:00:00 | DIA | ETF | 86.2 | 86.75 | 86.16 | 86.67 | 648400.0 |
| 2002-07-30 12:30:00 | DIA | ETF | 86.7 | 87.15 | 86.5 | 86.62 | 903500.0 |
| 2002-07-30 13:00:00 | DIA | ETF | 86.69 | 87.66 | 86.47 | 87.46 | 1029800.0 |
> showing 50 of 585 rows — these rows as CSV