PREVIEW / etf_30min / 2002-11-18
file: by_date/etf_30min/2002/2002-11-18.parquet size: 22 KB rows: 643
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-11-18 08:00:00 | SPY | ETF | 92.1 | 92.1 | 92.0 | 92.01 | 2600.0 |
| 2002-11-18 08:30:00 | SPY | ETF | 92.1 | 92.13 | 92.08 | 92.13 | 3400.0 |
| 2002-11-18 09:00:00 | SPY | ETF | 92.13 | 92.13 | 92.13 | 92.13 | 5000.0 |
| 2002-11-18 09:30:00 | SPY | ETF | 92.15 | 92.15 | 91.35 | 91.38 | 3977400.0 |
| 2002-11-18 10:00:00 | SPY | ETF | 91.44 | 91.78 | 91.3 | 91.55 | 2415700.0 |
| 2002-11-18 10:30:00 | SPY | ETF | 91.6 | 91.85 | 91.19 | 91.38 | 2234300.0 |
| 2002-11-18 11:00:00 | SPY | ETF | 91.4 | 91.45 | 91.12 | 91.15 | 1649200.0 |
| 2002-11-18 11:30:00 | SPY | ETF | 91.15 | 91.2 | 90.9 | 91.02 | 2551600.0 |
| 2002-11-18 12:00:00 | SPY | ETF | 91.03 | 91.22 | 90.85 | 91.2 | 1001800.0 |
| 2002-11-18 12:30:00 | SPY | ETF | 91.2 | 91.3 | 91.05 | 91.21 | 987200.0 |
| 2002-11-18 13:00:00 | SPY | ETF | 91.19 | 91.46 | 91.15 | 91.34 | 1330700.0 |
| 2002-11-18 13:30:00 | SPY | ETF | 91.3 | 91.59 | 91.29 | 91.5 | 1358000.0 |
| 2002-11-18 14:00:00 | SPY | ETF | 91.55 | 91.56 | 91.11 | 91.2 | 897700.0 |
| 2002-11-18 14:30:00 | SPY | ETF | 91.2 | 91.28 | 90.72 | 90.81 | 1192000.0 |
| 2002-11-18 15:00:00 | SPY | ETF | 90.84 | 90.84 | 90.51 | 90.52 | 1876000.0 |
| 2002-11-18 15:30:00 | SPY | ETF | 90.54 | 90.74 | 90.4 | 90.5 | 2919000.0 |
| 2002-11-18 16:00:00 | SPY | ETF | 90.5 | 90.55 | 90.4 | 90.47 | 1667200.0 |
| 2002-11-18 16:30:00 | SPY | ETF | 90.51 | 91.23 | 90.33 | 90.33 | 207000.0 |
| 2002-11-18 17:00:00 | SPY | ETF | 90.4 | 90.44 | 90.37 | 90.37 | 44900.0 |
| 2002-11-18 17:30:00 | SPY | ETF | 90.4 | 90.43 | 90.37 | 90.43 | 9100.0 |
| 2002-11-18 18:00:00 | SPY | ETF | 90.48 | 90.48 | 90.39 | 90.41 | 75000.0 |
| 2002-11-18 08:00:00 | QQQ | ETF | 26.68 | 26.73 | 26.65 | 26.7 | 40400.0 |
| 2002-11-18 08:30:00 | QQQ | ETF | 26.72 | 26.8 | 26.68 | 26.78 | 32000.0 |
| 2002-11-18 09:00:00 | QQQ | ETF | 26.78 | 26.78 | 26.7 | 26.71 | 6100.0 |
| 2002-11-18 09:30:00 | QQQ | ETF | 26.71 | 26.77 | 26.32 | 26.35 | 13410800.0 |
| 2002-11-18 10:00:00 | QQQ | ETF | 26.36 | 26.6 | 26.31 | 26.55 | 8113100.0 |
| 2002-11-18 10:30:00 | QQQ | ETF | 26.55 | 26.67 | 26.43 | 26.56 | 5326800.0 |
| 2002-11-18 11:00:00 | QQQ | ETF | 26.57 | 26.59 | 26.41 | 26.43 | 4526400.0 |
| 2002-11-18 11:30:00 | QQQ | ETF | 26.42 | 26.45 | 26.24 | 26.36 | 5620200.0 |
| 2002-11-18 12:00:00 | QQQ | ETF | 26.35 | 26.49 | 26.32 | 26.45 | 2293600.0 |
| 2002-11-18 12:30:00 | QQQ | ETF | 26.46 | 26.56 | 26.4 | 26.52 | 3356200.0 |
| 2002-11-18 13:00:00 | QQQ | ETF | 26.54 | 26.6 | 26.5 | 26.56 | 2466400.0 |
| 2002-11-18 13:30:00 | QQQ | ETF | 26.57 | 26.66 | 26.54 | 26.62 | 3761100.0 |
| 2002-11-18 14:00:00 | QQQ | ETF | 26.62 | 26.63 | 26.43 | 26.46 | 3021900.0 |
| 2002-11-18 14:30:00 | QQQ | ETF | 26.46 | 26.5 | 26.26 | 26.3 | 4361500.0 |
| 2002-11-18 15:00:00 | QQQ | ETF | 26.3 | 26.34 | 26.13 | 26.15 | 5514200.0 |
| 2002-11-18 15:30:00 | QQQ | ETF | 26.16 | 26.22 | 26.0 | 26.02 | 6955200.0 |
| 2002-11-18 16:00:00 | QQQ | ETF | 26.02 | 26.09 | 25.99 | 26.03 | 4051800.0 |
| 2002-11-18 16:30:00 | QQQ | ETF | 26.03 | 26.06 | 26.0 | 26.03 | 85600.0 |
| 2002-11-18 17:00:00 | QQQ | ETF | 26.02 | 26.06 | 26.01 | 26.04 | 41600.0 |
| 2002-11-18 17:30:00 | QQQ | ETF | 26.05 | 26.07 | 26.03 | 26.03 | 303200.0 |
| 2002-11-18 18:00:00 | QQQ | ETF | 26.04 | 26.04 | 25.98 | 26.04 | 406700.0 |
| 2002-11-18 18:30:00 | QQQ | ETF | 25.97 | 26.05 | 25.96 | 26.05 | 8200.0 |
| 2002-11-18 19:00:00 | QQQ | ETF | 26.03 | 26.03 | 26.03 | 26.03 | 500.0 |
| 2002-11-18 19:30:00 | QQQ | ETF | 26.03 | 26.05 | 26.03 | 26.05 | 2300.0 |
| 2002-11-18 09:30:00 | IWM | ETF | 38.875 | 38.875 | 38.505 | 38.505 | 311000.0 |
| 2002-11-18 10:00:00 | IWM | ETF | 38.495 | 38.62 | 38.385 | 38.575 | 171200.0 |
| 2002-11-18 10:30:00 | IWM | ETF | 38.585 | 38.645 | 38.42 | 38.48 | 175800.0 |
| 2002-11-18 11:00:00 | IWM | ETF | 38.485 | 38.49 | 38.325 | 38.345 | 47200.0 |
| 2002-11-18 11:30:00 | IWM | ETF | 38.305 | 38.32 | 38.045 | 38.08 | 206000.0 |
> showing 50 of 643 rows — these rows as CSV