PREVIEW / etf_30min / 2002-12-18
file: by_date/etf_30min/2002/2002-12-18.parquet size: 21 KB rows: 638
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-12-18 08:00:00 | SPY | ETF | 90.52 | 90.54 | 90.42 | 90.42 | 2600.0 |
| 2002-12-18 08:30:00 | SPY | ETF | 90.5 | 90.5 | 90.42 | 90.45 | 15500.0 |
| 2002-12-18 09:00:00 | SPY | ETF | 90.45 | 90.49 | 90.38 | 90.38 | 43400.0 |
| 2002-12-18 09:30:00 | SPY | ETF | 90.32 | 90.4 | 90.02 | 90.18 | 3761000.0 |
| 2002-12-18 10:00:00 | SPY | ETF | 90.19 | 90.21 | 89.7 | 89.83 | 3737700.0 |
| 2002-12-18 10:30:00 | SPY | ETF | 89.82 | 89.88 | 89.42 | 89.45 | 2203300.0 |
| 2002-12-18 11:00:00 | SPY | ETF | 89.43 | 89.66 | 89.33 | 89.56 | 2361800.0 |
| 2002-12-18 11:30:00 | SPY | ETF | 89.55 | 89.8 | 89.51 | 89.78 | 1922400.0 |
| 2002-12-18 12:00:00 | SPY | ETF | 89.78 | 89.9 | 89.66 | 89.77 | 1200600.0 |
| 2002-12-18 12:30:00 | SPY | ETF | 89.77 | 90.0 | 89.7 | 89.9 | 1961000.0 |
| 2002-12-18 13:00:00 | SPY | ETF | 89.9 | 90.2 | 89.67 | 89.78 | 2374000.0 |
| 2002-12-18 13:30:00 | SPY | ETF | 89.76 | 89.82 | 89.55 | 89.65 | 1021400.0 |
| 2002-12-18 14:00:00 | SPY | ETF | 89.65 | 90.09 | 89.61 | 89.94 | 2106600.0 |
| 2002-12-18 14:30:00 | SPY | ETF | 89.96 | 89.99 | 89.46 | 89.47 | 1592500.0 |
| 2002-12-18 15:00:00 | SPY | ETF | 89.5 | 89.8 | 89.36 | 89.45 | 2436100.0 |
| 2002-12-18 15:30:00 | SPY | ETF | 89.45 | 89.85 | 89.4 | 89.65 | 1940400.0 |
| 2002-12-18 16:00:00 | SPY | ETF | 89.65 | 89.96 | 89.46 | 89.92 | 3046900.0 |
| 2002-12-18 16:30:00 | SPY | ETF | 89.92 | 89.95 | 89.86 | 89.88 | 64800.0 |
| 2002-12-18 17:00:00 | SPY | ETF | 89.9 | 89.9 | 89.87 | 89.87 | 4500.0 |
| 2002-12-18 17:30:00 | SPY | ETF | 89.8 | 89.8 | 89.67 | 89.68 | 9400.0 |
| 2002-12-18 18:00:00 | SPY | ETF | 89.71 | 89.73 | 89.69 | 89.71 | 17100.0 |
| 2002-12-18 18:30:00 | SPY | ETF | 89.74 | 89.75 | 89.71 | 89.75 | 6700.0 |
| 2002-12-18 19:30:00 | SPY | ETF | 89.72 | 89.72 | 89.69 | 89.7 | 1500.0 |
| 2002-12-18 08:00:00 | QQQ | ETF | 25.6 | 25.62 | 25.51 | 25.51 | 25300.0 |
| 2002-12-18 08:30:00 | QQQ | ETF | 25.51 | 25.58 | 25.5 | 25.56 | 65100.0 |
| 2002-12-18 09:00:00 | QQQ | ETF | 25.56 | 25.57 | 25.54 | 25.56 | 48500.0 |
| 2002-12-18 09:30:00 | QQQ | ETF | 25.55 | 25.6 | 25.42 | 25.49 | 8951800.0 |
| 2002-12-18 10:00:00 | QQQ | ETF | 25.52 | 25.52 | 25.23 | 25.4 | 8927900.0 |
| 2002-12-18 10:30:00 | QQQ | ETF | 25.4 | 25.42 | 25.07 | 25.07 | 4803700.0 |
| 2002-12-18 11:00:00 | QQQ | ETF | 25.1 | 25.22 | 25.05 | 25.19 | 4846400.0 |
| 2002-12-18 11:30:00 | QQQ | ETF | 25.19 | 25.25 | 25.12 | 25.2 | 3846400.0 |
| 2002-12-18 12:00:00 | QQQ | ETF | 25.2 | 25.28 | 25.17 | 25.24 | 1966000.0 |
| 2002-12-18 12:30:00 | QQQ | ETF | 25.25 | 25.29 | 25.15 | 25.23 | 2948100.0 |
| 2002-12-18 13:00:00 | QQQ | ETF | 25.24 | 25.33 | 25.15 | 25.18 | 3811600.0 |
| 2002-12-18 13:30:00 | QQQ | ETF | 25.18 | 25.21 | 25.1 | 25.15 | 1478200.0 |
| 2002-12-18 14:00:00 | QQQ | ETF | 25.17 | 25.32 | 25.14 | 25.24 | 2979300.0 |
| 2002-12-18 14:30:00 | QQQ | ETF | 25.24 | 25.26 | 25.1 | 25.11 | 2674400.0 |
| 2002-12-18 15:00:00 | QQQ | ETF | 25.11 | 25.24 | 25.06 | 25.08 | 3875900.0 |
| 2002-12-18 15:30:00 | QQQ | ETF | 25.09 | 25.25 | 25.06 | 25.19 | 6035300.0 |
| 2002-12-18 16:00:00 | QQQ | ETF | 25.2 | 25.41 | 25.17 | 25.39 | 3355200.0 |
| 2002-12-18 16:30:00 | QQQ | ETF | 25.4 | 25.42 | 25.24 | 25.37 | 943400.0 |
| 2002-12-18 17:00:00 | QQQ | ETF | 25.37 | 25.4 | 25.29 | 25.3 | 748100.0 |
| 2002-12-18 17:30:00 | QQQ | ETF | 25.3 | 25.34 | 25.26 | 25.3 | 305100.0 |
| 2002-12-18 18:00:00 | QQQ | ETF | 25.31 | 25.31 | 25.26 | 25.29 | 62300.0 |
| 2002-12-18 18:30:00 | QQQ | ETF | 25.3 | 25.34 | 25.29 | 25.32 | 15800.0 |
| 2002-12-18 19:00:00 | QQQ | ETF | 25.33 | 25.35 | 25.32 | 25.32 | 20900.0 |
| 2002-12-18 19:30:00 | QQQ | ETF | 25.33 | 25.35 | 25.32 | 25.35 | 15700.0 |
| 2002-12-18 20:00:00 | QQQ | ETF | 25.35 | 25.35 | 25.35 | 25.35 | 100.0 |
| 2002-12-18 09:30:00 | IWM | ETF | 38.75 | 38.75 | 38.575 | 38.585 | 258800.0 |
| 2002-12-18 10:00:00 | IWM | ETF | 38.56 | 38.575 | 38.41 | 38.465 | 160800.0 |
> showing 50 of 638 rows — these rows as CSV