PREVIEW / etf_30min / 2002-12-26
file: by_date/etf_30min/2002/2002-12-26.parquet size: 21 KB rows: 603
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-26 08:00:00 | SPY | ETF | 89.5 | 89.5 | 89.5 | 89.5 | 500.0 |
| 2002-12-26 08:30:00 | SPY | ETF | 89.77 | 90.0 | 89.77 | 89.93 | 18600.0 |
| 2002-12-26 09:00:00 | SPY | ETF | 89.91 | 89.95 | 89.9 | 89.9 | 4800.0 |
| 2002-12-26 09:30:00 | SPY | ETF | 89.7 | 90.18 | 89.64 | 90.03 | 1666700.0 |
| 2002-12-26 10:00:00 | SPY | ETF | 90.06 | 90.5 | 90.05 | 90.28 | 1907300.0 |
| 2002-12-26 10:30:00 | SPY | ETF | 90.28 | 90.61 | 90.26 | 90.45 | 1063500.0 |
| 2002-12-26 11:00:00 | SPY | ETF | 90.46 | 90.54 | 90.29 | 90.37 | 407200.0 |
| 2002-12-26 11:30:00 | SPY | ETF | 90.36 | 90.41 | 90.11 | 90.14 | 797600.0 |
| 2002-12-26 12:00:00 | SPY | ETF | 90.13 | 90.34 | 90.1 | 90.19 | 562700.0 |
| 2002-12-26 12:30:00 | SPY | ETF | 90.2 | 90.32 | 90.15 | 90.19 | 451200.0 |
| 2002-12-26 13:00:00 | SPY | ETF | 90.19 | 90.32 | 90.18 | 90.21 | 454100.0 |
| 2002-12-26 13:30:00 | SPY | ETF | 90.22 | 90.24 | 90.0 | 90.06 | 651400.0 |
| 2002-12-26 14:00:00 | SPY | ETF | 90.0 | 90.13 | 89.64 | 89.76 | 1395300.0 |
| 2002-12-26 14:30:00 | SPY | ETF | 89.72 | 89.88 | 89.23 | 89.4 | 1121300.0 |
| 2002-12-26 15:00:00 | SPY | ETF | 89.42 | 89.56 | 89.0 | 89.03 | 1433800.0 |
| 2002-12-26 15:30:00 | SPY | ETF | 89.04 | 89.12 | 88.84 | 89.04 | 2017800.0 |
| 2002-12-26 16:00:00 | SPY | ETF | 89.03 | 89.4 | 88.97 | 89.3 | 1276800.0 |
| 2002-12-26 16:30:00 | SPY | ETF | 89.3 | 89.34 | 89.3 | 89.3 | 3100.0 |
| 2002-12-26 17:00:00 | SPY | ETF | 89.32 | 89.33 | 89.3 | 89.32 | 5500.0 |
| 2002-12-26 17:30:00 | SPY | ETF | 89.31 | 89.31 | 89.3 | 89.3 | 600.0 |
| 2002-12-26 18:00:00 | SPY | ETF | 89.26 | 89.26 | 89.26 | 89.26 | 3000.0 |
| 2002-12-26 19:00:00 | SPY | ETF | 89.35 | 89.35 | 89.35 | 89.35 | 300.0 |
| 2002-12-26 19:30:00 | SPY | ETF | 89.26 | 89.29 | 89.26 | 89.29 | 500.0 |
| 2002-12-26 08:00:00 | QQQ | ETF | 25.5 | 25.5 | 25.48 | 25.5 | 6000.0 |
| 2002-12-26 08:30:00 | QQQ | ETF | 25.5 | 25.67 | 25.5 | 25.63 | 76000.0 |
| 2002-12-26 09:00:00 | QQQ | ETF | 25.64 | 25.64 | 25.56 | 25.56 | 6300.0 |
| 2002-12-26 09:30:00 | QQQ | ETF | 25.53 | 25.81 | 25.5 | 25.74 | 5007300.0 |
| 2002-12-26 10:00:00 | QQQ | ETF | 25.74 | 25.86 | 25.73 | 25.75 | 3466300.0 |
| 2002-12-26 10:30:00 | QQQ | ETF | 25.75 | 25.91 | 25.75 | 25.86 | 3198200.0 |
| 2002-12-26 11:00:00 | QQQ | ETF | 25.83 | 25.86 | 25.76 | 25.82 | 1609200.0 |
| 2002-12-26 11:30:00 | QQQ | ETF | 25.82 | 25.83 | 25.69 | 25.71 | 1250000.0 |
| 2002-12-26 12:00:00 | QQQ | ETF | 25.71 | 25.8 | 25.7 | 25.72 | 791900.0 |
| 2002-12-26 12:30:00 | QQQ | ETF | 25.73 | 25.77 | 25.7 | 25.72 | 652100.0 |
| 2002-12-26 13:00:00 | QQQ | ETF | 25.72 | 25.76 | 25.7 | 25.72 | 556800.0 |
| 2002-12-26 13:30:00 | QQQ | ETF | 25.71 | 25.72 | 25.58 | 25.6 | 1049000.0 |
| 2002-12-26 14:00:00 | QQQ | ETF | 25.6 | 25.65 | 25.35 | 25.46 | 3789800.0 |
| 2002-12-26 14:30:00 | QQQ | ETF | 25.45 | 25.5 | 25.26 | 25.36 | 2248800.0 |
| 2002-12-26 15:00:00 | QQQ | ETF | 25.36 | 25.42 | 25.26 | 25.28 | 2528100.0 |
| 2002-12-26 15:30:00 | QQQ | ETF | 25.27 | 25.34 | 25.17 | 25.26 | 3430800.0 |
| 2002-12-26 16:00:00 | QQQ | ETF | 25.23 | 25.34 | 25.23 | 25.3 | 443200.0 |
| 2002-12-26 16:30:00 | QQQ | ETF | 25.28 | 25.31 | 25.26 | 25.29 | 79400.0 |
| 2002-12-26 17:00:00 | QQQ | ETF | 25.29 | 25.3 | 25.28 | 25.28 | 28000.0 |
| 2002-12-26 17:30:00 | QQQ | ETF | 25.28 | 25.3 | 25.28 | 25.3 | 24400.0 |
| 2002-12-26 18:00:00 | QQQ | ETF | 25.28 | 25.3 | 25.27 | 25.3 | 6500.0 |
| 2002-12-26 18:30:00 | QQQ | ETF | 25.3 | 25.31 | 25.3 | 25.31 | 1100.0 |
| 2002-12-26 19:00:00 | QQQ | ETF | 25.31 | 25.31 | 25.31 | 25.31 | 2600.0 |
| 2002-12-26 09:30:00 | IWM | ETF | 38.75 | 38.875 | 38.71 | 38.82 | 112800.0 |
| 2002-12-26 10:00:00 | IWM | ETF | 38.82 | 38.935 | 38.82 | 38.865 | 73200.0 |
| 2002-12-26 10:30:00 | IWM | ETF | 38.92 | 39.07 | 38.92 | 39.035 | 80800.0 |
| 2002-12-26 11:00:00 | IWM | ETF | 39.0 | 39.04 | 38.945 | 38.95 | 32200.0 |
> showing 50 of 603 rows — these rows as CSV