PREVIEW / etf_30min / 2002-10-08
file: by_date/etf_30min/2002/2002-10-08.parquet size: 22 KB rows: 618
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-08 08:00:00 | SPY | ETF | 79.64 | 79.72 | 79.64 | 79.72 | 600.0 |
| 2002-10-08 08:30:00 | SPY | ETF | 79.8 | 79.98 | 79.8 | 79.98 | 1600.0 |
| 2002-10-08 09:00:00 | SPY | ETF | 80.01 | 80.03 | 79.8 | 79.8 | 5600.0 |
| 2002-10-08 09:30:00 | SPY | ETF | 79.81 | 80.17 | 79.51 | 79.56 | 6655400.0 |
| 2002-10-08 10:00:00 | SPY | ETF | 79.55 | 80.18 | 79.4 | 79.84 | 3854100.0 |
| 2002-10-08 10:30:00 | SPY | ETF | 79.74 | 79.87 | 79.2 | 79.4 | 4100400.0 |
| 2002-10-08 11:00:00 | SPY | ETF | 79.35 | 79.43 | 78.44 | 78.69 | 4921400.0 |
| 2002-10-08 11:30:00 | SPY | ETF | 78.65 | 78.87 | 78.2 | 78.33 | 3294300.0 |
| 2002-10-08 12:00:00 | SPY | ETF | 78.26 | 79.07 | 78.2 | 78.82 | 3340400.0 |
| 2002-10-08 12:30:00 | SPY | ETF | 78.8 | 79.69 | 78.6 | 79.6 | 5144700.0 |
| 2002-10-08 13:00:00 | SPY | ETF | 79.62 | 79.78 | 79.06 | 79.1 | 3779400.0 |
| 2002-10-08 13:30:00 | SPY | ETF | 79.1 | 80.46 | 78.94 | 80.32 | 6449800.0 |
| 2002-10-08 14:00:00 | SPY | ETF | 80.34 | 80.85 | 80.1 | 80.54 | 7678900.0 |
| 2002-10-08 14:30:00 | SPY | ETF | 80.53 | 81.31 | 80.32 | 80.94 | 6776500.0 |
| 2002-10-08 15:00:00 | SPY | ETF | 80.93 | 81.2 | 80.2 | 80.21 | 6398000.0 |
| 2002-10-08 15:30:00 | SPY | ETF | 80.24 | 80.7 | 79.83 | 80.11 | 7344100.0 |
| 2002-10-08 16:00:00 | SPY | ETF | 80.17 | 80.48 | 79.85 | 80.4 | 2179900.0 |
| 2002-10-08 16:30:00 | SPY | ETF | 80.38 | 80.58 | 80.29 | 80.46 | 78900.0 |
| 2002-10-08 17:00:00 | SPY | ETF | 80.49 | 81.17 | 78.27 | 80.4 | 424700.0 |
| 2002-10-08 17:30:00 | SPY | ETF | 80.4 | 80.45 | 80.38 | 80.44 | 16800.0 |
| 2002-10-08 18:00:00 | SPY | ETF | 80.45 | 80.51 | 80.45 | 80.49 | 3500.0 |
| 2002-10-08 18:30:00 | SPY | ETF | 80.52 | 80.52 | 80.52 | 80.52 | 200.0 |
| 2002-10-08 19:00:00 | SPY | ETF | 80.51 | 80.51 | 80.51 | 80.51 | 200.0 |
| 2002-10-08 08:00:00 | QQQ | ETF | 20.2 | 20.2 | 20.2 | 20.2 | 300.0 |
| 2002-10-08 08:30:00 | QQQ | ETF | 20.33 | 20.35 | 20.32 | 20.35 | 6500.0 |
| 2002-10-08 09:00:00 | QQQ | ETF | 20.35 | 20.35 | 20.28 | 20.28 | 9700.0 |
| 2002-10-08 09:30:00 | QQQ | ETF | 20.28 | 20.42 | 20.05 | 20.06 | 11845500.0 |
| 2002-10-08 10:00:00 | QQQ | ETF | 20.09 | 20.32 | 20.03 | 20.22 | 6705900.0 |
| 2002-10-08 10:30:00 | QQQ | ETF | 20.22 | 20.27 | 20.0 | 20.04 | 5689100.0 |
| 2002-10-08 11:00:00 | QQQ | ETF | 20.04 | 20.05 | 19.8 | 19.89 | 6833500.0 |
| 2002-10-08 11:30:00 | QQQ | ETF | 19.89 | 19.97 | 19.77 | 19.78 | 3950500.0 |
| 2002-10-08 12:00:00 | QQQ | ETF | 19.78 | 19.99 | 19.76 | 19.91 | 4892700.0 |
| 2002-10-08 12:30:00 | QQQ | ETF | 19.91 | 20.19 | 19.81 | 20.12 | 4465100.0 |
| 2002-10-08 13:00:00 | QQQ | ETF | 20.15 | 20.23 | 19.95 | 19.97 | 5644900.0 |
| 2002-10-08 13:30:00 | QQQ | ETF | 19.97 | 20.35 | 19.93 | 20.29 | 5235900.0 |
| 2002-10-08 14:00:00 | QQQ | ETF | 20.3 | 20.46 | 20.15 | 20.3 | 7631000.0 |
| 2002-10-08 14:30:00 | QQQ | ETF | 20.3 | 20.61 | 20.2 | 20.46 | 10924900.0 |
| 2002-10-08 15:00:00 | QQQ | ETF | 20.46 | 20.58 | 20.21 | 20.21 | 7933600.0 |
| 2002-10-08 15:30:00 | QQQ | ETF | 20.21 | 20.41 | 20.12 | 20.16 | 5722200.0 |
| 2002-10-08 16:00:00 | QQQ | ETF | 20.18 | 20.22 | 20.11 | 20.19 | 1534800.0 |
| 2002-10-08 16:30:00 | QQQ | ETF | 20.2 | 20.25 | 20.15 | 20.18 | 446500.0 |
| 2002-10-08 17:00:00 | QQQ | ETF | 20.19 | 20.22 | 20.15 | 20.16 | 56400.0 |
| 2002-10-08 17:30:00 | QQQ | ETF | 20.16 | 20.21 | 20.15 | 20.18 | 11600.0 |
| 2002-10-08 18:00:00 | QQQ | ETF | 20.18 | 20.22 | 20.17 | 20.2 | 16100.0 |
| 2002-10-08 19:00:00 | QQQ | ETF | 20.22 | 20.22 | 20.22 | 20.22 | 100.0 |
| 2002-10-08 19:30:00 | QQQ | ETF | 20.23 | 20.24 | 20.23 | 20.24 | 2000.0 |
| 2002-10-08 09:30:00 | IWM | ETF | 34.255 | 34.255 | 33.755 | 33.82 | 93800.0 |
| 2002-10-08 10:00:00 | IWM | ETF | 33.83 | 33.93 | 33.755 | 33.91 | 320200.0 |
| 2002-10-08 10:30:00 | IWM | ETF | 33.825 | 33.85 | 33.6 | 33.66 | 69400.0 |
| 2002-10-08 11:00:00 | IWM | ETF | 33.66 | 33.66 | 33.385 | 33.42 | 229600.0 |
> showing 50 of 618 rows — these rows as CSV