PREVIEW / etf_30min / 2002-08-01
file: by_date/etf_30min/2002/2002-08-01.parquet size: 20 KB rows: 568
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-01 09:30:00 | SPY | ETF | 90.88 | 91.25 | 90.8 | 91.24 | 3213900.0 |
| 2002-08-01 10:00:00 | SPY | ETF | 91.25 | 91.25 | 89.5 | 90.0 | 7868000.0 |
| 2002-08-01 10:30:00 | SPY | ETF | 89.99 | 90.06 | 89.51 | 89.77 | 2726700.0 |
| 2002-08-01 11:00:00 | SPY | ETF | 89.71 | 89.89 | 88.79 | 89.06 | 4857300.0 |
| 2002-08-01 11:30:00 | SPY | ETF | 89.0 | 89.59 | 88.91 | 89.35 | 3593000.0 |
| 2002-08-01 12:00:00 | SPY | ETF | 89.38 | 89.48 | 89.0 | 89.02 | 2238200.0 |
| 2002-08-01 12:30:00 | SPY | ETF | 89.05 | 89.61 | 88.91 | 89.59 | 2119100.0 |
| 2002-08-01 13:00:00 | SPY | ETF | 89.56 | 89.75 | 89.26 | 89.45 | 1951700.0 |
| 2002-08-01 13:30:00 | SPY | ETF | 89.44 | 90.04 | 89.25 | 89.9 | 4141800.0 |
| 2002-08-01 14:00:00 | SPY | ETF | 89.9 | 89.97 | 89.23 | 89.35 | 2799300.0 |
| 2002-08-01 14:30:00 | SPY | ETF | 89.39 | 89.74 | 89.05 | 89.31 | 3710900.0 |
| 2002-08-01 15:00:00 | SPY | ETF | 89.4 | 89.97 | 89.25 | 89.26 | 5395300.0 |
| 2002-08-01 15:30:00 | SPY | ETF | 89.3 | 89.4 | 88.46 | 88.64 | 9922100.0 |
| 2002-08-01 16:00:00 | SPY | ETF | 88.59 | 88.78 | 88.33 | 88.78 | 2354000.0 |
| 2002-08-01 09:30:00 | QQQ | ETF | 23.74 | 23.9 | 23.66 | 23.85 | 9169900.0 |
| 2002-08-01 10:00:00 | QQQ | ETF | 23.86 | 23.87 | 23.3 | 23.42 | 11941000.0 |
| 2002-08-01 10:30:00 | QQQ | ETF | 23.42 | 23.47 | 23.17 | 23.23 | 8204800.0 |
| 2002-08-01 11:00:00 | QQQ | ETF | 23.22 | 23.28 | 22.95 | 23.0 | 7670300.0 |
| 2002-08-01 11:30:00 | QQQ | ETF | 23.0 | 23.18 | 22.98 | 23.13 | 4380400.0 |
| 2002-08-01 12:00:00 | QQQ | ETF | 23.14 | 23.15 | 23.0 | 23.0 | 3525000.0 |
| 2002-08-01 12:30:00 | QQQ | ETF | 23.0 | 23.22 | 22.97 | 23.15 | 3375100.0 |
| 2002-08-01 13:00:00 | QQQ | ETF | 23.13 | 23.21 | 23.01 | 23.05 | 2028700.0 |
| 2002-08-01 13:30:00 | QQQ | ETF | 23.05 | 23.22 | 23.0 | 23.17 | 3594500.0 |
| 2002-08-01 14:00:00 | QQQ | ETF | 23.16 | 23.18 | 22.95 | 23.02 | 3192300.0 |
| 2002-08-01 14:30:00 | QQQ | ETF | 23.02 | 23.11 | 22.88 | 22.99 | 5227200.0 |
| 2002-08-01 15:00:00 | QQQ | ETF | 22.99 | 23.16 | 22.92 | 22.98 | 4462300.0 |
| 2002-08-01 15:30:00 | QQQ | ETF | 22.95 | 22.97 | 22.66 | 22.7 | 11886200.0 |
| 2002-08-01 16:00:00 | QQQ | ETF | 22.71 | 22.79 | 22.67 | 22.73 | 1733200.0 |
| 2002-08-01 09:30:00 | IWM | ETF | 39.15 | 39.375 | 39.115 | 39.3 | 322000.0 |
| 2002-08-01 10:00:00 | IWM | ETF | 39.25 | 39.305 | 38.9 | 39.02 | 94600.0 |
| 2002-08-01 10:30:00 | IWM | ETF | 39.03 | 39.03 | 38.885 | 38.965 | 46800.0 |
| 2002-08-01 11:00:00 | IWM | ETF | 38.99 | 39.0 | 38.5 | 38.62 | 471800.0 |
| 2002-08-01 11:30:00 | IWM | ETF | 38.595 | 38.765 | 38.565 | 38.685 | 130600.0 |
| 2002-08-01 12:00:00 | IWM | ETF | 38.705 | 38.76 | 38.67 | 38.67 | 9800.0 |
| 2002-08-01 12:30:00 | IWM | ETF | 38.665 | 38.775 | 38.615 | 38.775 | 18400.0 |
| 2002-08-01 13:00:00 | IWM | ETF | 38.81 | 38.85 | 38.715 | 38.715 | 65600.0 |
| 2002-08-01 13:30:00 | IWM | ETF | 38.77 | 38.9 | 38.735 | 38.9 | 51600.0 |
| 2002-08-01 14:00:00 | IWM | ETF | 38.875 | 38.875 | 38.7 | 38.745 | 109200.0 |
| 2002-08-01 14:30:00 | IWM | ETF | 38.745 | 38.88 | 38.7 | 38.795 | 85200.0 |
| 2002-08-01 15:00:00 | IWM | ETF | 38.775 | 39.125 | 38.775 | 38.905 | 255800.0 |
| 2002-08-01 15:30:00 | IWM | ETF | 38.93 | 38.93 | 38.6 | 38.675 | 301200.0 |
| 2002-08-01 16:00:00 | IWM | ETF | 38.7 | 38.75 | 38.7 | 38.7 | 43600.0 |
| 2002-08-01 09:30:00 | DIA | ETF | 86.86 | 87.27 | 86.7 | 87.19 | 867100.0 |
| 2002-08-01 10:00:00 | DIA | ETF | 87.19 | 87.21 | 85.67 | 86.14 | 1890300.0 |
| 2002-08-01 10:30:00 | DIA | ETF | 86.06 | 86.21 | 85.7 | 85.97 | 844900.0 |
| 2002-08-01 11:00:00 | DIA | ETF | 85.99 | 86.1 | 85.1 | 85.39 | 899300.0 |
| 2002-08-01 11:30:00 | DIA | ETF | 85.42 | 85.85 | 85.2 | 85.68 | 1180600.0 |
| 2002-08-01 12:00:00 | DIA | ETF | 85.69 | 85.72 | 85.21 | 85.25 | 437700.0 |
| 2002-08-01 12:30:00 | DIA | ETF | 85.25 | 85.85 | 85.23 | 85.85 | 537600.0 |
| 2002-08-01 13:00:00 | DIA | ETF | 85.82 | 85.97 | 85.47 | 85.55 | 503300.0 |
> showing 50 of 568 rows — these rows as CSV