PREVIEW / etf_30min / 2002-10-01
file: by_date/etf_30min/2002/2002-10-01.parquet size: 22 KB rows: 625
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-01 08:00:00 | SPY | ETF | 82.38 | 82.44 | 82.38 | 82.38 | 4700.0 |
| 2002-10-01 08:30:00 | SPY | ETF | 82.6 | 82.6 | 82.45 | 82.45 | 300.0 |
| 2002-10-01 09:00:00 | SPY | ETF | 82.45 | 82.5 | 82.4 | 82.4 | 1900.0 |
| 2002-10-01 09:30:00 | SPY | ETF | 82.43 | 82.72 | 81.99 | 82.14 | 4378200.0 |
| 2002-10-01 10:00:00 | SPY | ETF | 82.13 | 82.7 | 81.47 | 81.77 | 8094800.0 |
| 2002-10-01 10:30:00 | SPY | ETF | 81.73 | 82.5 | 81.71 | 82.11 | 4842100.0 |
| 2002-10-01 11:00:00 | SPY | ETF | 82.08 | 82.27 | 81.74 | 81.9 | 2177500.0 |
| 2002-10-01 11:30:00 | SPY | ETF | 81.93 | 82.24 | 81.82 | 81.97 | 1865800.0 |
| 2002-10-01 12:00:00 | SPY | ETF | 81.96 | 82.36 | 81.8 | 82.23 | 852700.0 |
| 2002-10-01 12:30:00 | SPY | ETF | 82.26 | 83.05 | 82.19 | 82.9 | 3984200.0 |
| 2002-10-01 13:00:00 | SPY | ETF | 82.9 | 83.72 | 82.79 | 83.61 | 6003700.0 |
| 2002-10-01 13:30:00 | SPY | ETF | 83.63 | 83.7 | 83.22 | 83.35 | 5069700.0 |
| 2002-10-01 14:00:00 | SPY | ETF | 83.32 | 84.01 | 83.13 | 83.88 | 4264900.0 |
| 2002-10-01 14:30:00 | SPY | ETF | 83.9 | 84.28 | 83.8 | 83.8 | 4410800.0 |
| 2002-10-01 15:00:00 | SPY | ETF | 83.8 | 84.9 | 83.78 | 84.87 | 6713000.0 |
| 2002-10-01 15:30:00 | SPY | ETF | 84.87 | 85.1 | 84.65 | 85.0 | 5223900.0 |
| 2002-10-01 16:00:00 | SPY | ETF | 85.06 | 85.83 | 84.68 | 85.8 | 4520700.0 |
| 2002-10-01 16:30:00 | SPY | ETF | 85.79 | 85.87 | 84.43 | 85.62 | 1983400.0 |
| 2002-10-01 17:00:00 | SPY | ETF | 85.65 | 85.67 | 85.5 | 85.55 | 17300.0 |
| 2002-10-01 17:30:00 | SPY | ETF | 85.57 | 85.63 | 83.51 | 85.63 | 77800.0 |
| 2002-10-01 18:00:00 | SPY | ETF | 85.6 | 85.72 | 85.6 | 85.72 | 3400.0 |
| 2002-10-01 19:00:00 | SPY | ETF | 85.72 | 85.73 | 85.72 | 85.73 | 300.0 |
| 2002-10-01 08:00:00 | QQQ | ETF | 21.0 | 21.0 | 20.89 | 20.92 | 4300.0 |
| 2002-10-01 08:30:00 | QQQ | ETF | 20.92 | 20.92 | 20.9 | 20.9 | 5100.0 |
| 2002-10-01 09:00:00 | QQQ | ETF | 20.88 | 20.94 | 20.88 | 20.9 | 15000.0 |
| 2002-10-01 09:30:00 | QQQ | ETF | 20.91 | 21.07 | 20.69 | 20.77 | 8339200.0 |
| 2002-10-01 10:00:00 | QQQ | ETF | 20.76 | 20.87 | 20.47 | 20.56 | 13176100.0 |
| 2002-10-01 10:30:00 | QQQ | ETF | 20.53 | 20.78 | 20.52 | 20.66 | 7709300.0 |
| 2002-10-01 11:00:00 | QQQ | ETF | 20.67 | 20.74 | 20.52 | 20.62 | 4695600.0 |
| 2002-10-01 11:30:00 | QQQ | ETF | 20.6 | 20.77 | 20.56 | 20.68 | 2754600.0 |
| 2002-10-01 12:00:00 | QQQ | ETF | 20.68 | 20.8 | 20.62 | 20.72 | 3008800.0 |
| 2002-10-01 12:30:00 | QQQ | ETF | 20.72 | 21.0 | 20.72 | 20.92 | 5110200.0 |
| 2002-10-01 13:00:00 | QQQ | ETF | 20.91 | 21.13 | 20.85 | 21.09 | 9081700.0 |
| 2002-10-01 13:30:00 | QQQ | ETF | 21.08 | 21.15 | 20.96 | 20.98 | 7203100.0 |
| 2002-10-01 14:00:00 | QQQ | ETF | 20.99 | 21.25 | 20.91 | 21.17 | 5596100.0 |
| 2002-10-01 14:30:00 | QQQ | ETF | 21.17 | 21.35 | 21.14 | 21.19 | 6912300.0 |
| 2002-10-01 15:00:00 | QQQ | ETF | 21.2 | 21.57 | 21.15 | 21.55 | 9315000.0 |
| 2002-10-01 15:30:00 | QQQ | ETF | 21.55 | 21.64 | 21.45 | 21.62 | 9674800.0 |
| 2002-10-01 16:00:00 | QQQ | ETF | 21.61 | 22.03 | 21.55 | 22.0 | 7246100.0 |
| 2002-10-01 16:30:00 | QQQ | ETF | 22.0 | 22.02 | 21.03 | 21.99 | 536600.0 |
| 2002-10-01 17:00:00 | QQQ | ETF | 21.98 | 21.98 | 21.93 | 21.97 | 120000.0 |
| 2002-10-01 17:30:00 | QQQ | ETF | 21.97 | 22.03 | 21.94 | 21.97 | 94800.0 |
| 2002-10-01 18:00:00 | QQQ | ETF | 21.96 | 21.98 | 21.94 | 21.97 | 40500.0 |
| 2002-10-01 18:30:00 | QQQ | ETF | 21.98 | 21.98 | 21.98 | 21.98 | 200.0 |
| 2002-10-01 19:00:00 | QQQ | ETF | 22.0 | 22.01 | 22.0 | 22.01 | 300.0 |
| 2002-10-01 19:30:00 | QQQ | ETF | 22.02 | 22.04 | 22.02 | 22.04 | 200.0 |
| 2002-10-01 09:30:00 | IWM | ETF | 36.25 | 36.275 | 35.625 | 35.72 | 343600.0 |
| 2002-10-01 10:00:00 | IWM | ETF | 35.725 | 35.83 | 35.475 | 35.6 | 178000.0 |
| 2002-10-01 10:30:00 | IWM | ETF | 35.58 | 35.975 | 35.575 | 35.775 | 237000.0 |
| 2002-10-01 11:00:00 | IWM | ETF | 35.755 | 35.79 | 35.67 | 35.67 | 62200.0 |
> showing 50 of 625 rows — these rows as CSV