PREVIEW / etf_30min / 2002-12-13
file: by_date/etf_30min/2002/2002-12-13.parquet size: 22 KB rows: 632
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-13 08:00:00 | SPY | ETF | 90.0 | 90.02 | 89.93 | 90.02 | 2800.0 |
| 2002-12-13 08:30:00 | SPY | ETF | 90.01 | 90.02 | 89.75 | 89.93 | 37700.0 |
| 2002-12-13 09:00:00 | SPY | ETF | 89.98 | 90.02 | 89.9 | 89.9 | 8000.0 |
| 2002-12-13 09:30:00 | SPY | ETF | 89.91 | 90.4 | 89.84 | 89.95 | 6039000.0 |
| 2002-12-13 10:00:00 | SPY | ETF | 89.94 | 89.99 | 89.36 | 89.68 | 5122500.0 |
| 2002-12-13 10:30:00 | SPY | ETF | 89.67 | 89.9 | 89.56 | 89.83 | 1441800.0 |
| 2002-12-13 11:00:00 | SPY | ETF | 89.87 | 90.0 | 89.61 | 89.94 | 1497700.0 |
| 2002-12-13 11:30:00 | SPY | ETF | 89.93 | 89.98 | 89.75 | 89.87 | 892800.0 |
| 2002-12-13 12:00:00 | SPY | ETF | 89.88 | 89.89 | 89.65 | 89.68 | 851000.0 |
| 2002-12-13 12:30:00 | SPY | ETF | 89.74 | 90.48 | 89.68 | 90.38 | 2764600.0 |
| 2002-12-13 13:00:00 | SPY | ETF | 90.4 | 90.45 | 90.07 | 90.07 | 1434000.0 |
| 2002-12-13 13:30:00 | SPY | ETF | 90.07 | 90.34 | 90.05 | 90.14 | 1223900.0 |
| 2002-12-13 14:00:00 | SPY | ETF | 90.17 | 90.19 | 89.87 | 89.94 | 1798800.0 |
| 2002-12-13 14:30:00 | SPY | ETF | 89.95 | 90.12 | 89.61 | 89.71 | 1250500.0 |
| 2002-12-13 15:00:00 | SPY | ETF | 89.7 | 89.91 | 89.6 | 89.65 | 1458000.0 |
| 2002-12-13 15:30:00 | SPY | ETF | 89.7 | 89.79 | 89.48 | 89.54 | 3224900.0 |
| 2002-12-13 16:00:00 | SPY | ETF | 89.48 | 89.57 | 89.27 | 89.53 | 3107600.0 |
| 2002-12-13 16:30:00 | SPY | ETF | 89.34 | 89.4 | 89.3 | 89.4 | 30900.0 |
| 2002-12-13 17:00:00 | SPY | ETF | 89.4 | 89.4 | 89.29 | 89.3 | 3900.0 |
| 2002-12-13 17:30:00 | SPY | ETF | 89.27 | 89.34 | 89.15 | 89.2 | 3800.0 |
| 2002-12-13 18:00:00 | SPY | ETF | 89.17 | 89.18 | 89.08 | 89.18 | 7300.0 |
| 2002-12-13 18:30:00 | SPY | ETF | 89.15 | 89.15 | 89.12 | 89.12 | 1500.0 |
| 2002-12-13 19:00:00 | SPY | ETF | 89.23 | 89.23 | 89.23 | 89.23 | 200.0 |
| 2002-12-13 19:30:00 | SPY | ETF | 89.3 | 89.32 | 89.09 | 89.09 | 2600.0 |
| 2002-12-13 08:00:00 | QQQ | ETF | 25.6 | 25.63 | 25.57 | 25.6 | 34300.0 |
| 2002-12-13 08:30:00 | QQQ | ETF | 25.6 | 25.6 | 25.48 | 25.56 | 36000.0 |
| 2002-12-13 09:00:00 | QQQ | ETF | 25.56 | 25.59 | 25.53 | 25.53 | 16900.0 |
| 2002-12-13 09:30:00 | QQQ | ETF | 25.52 | 25.57 | 25.27 | 25.31 | 13359700.0 |
| 2002-12-13 10:00:00 | QQQ | ETF | 25.32 | 25.33 | 25.1 | 25.17 | 10212700.0 |
| 2002-12-13 10:30:00 | QQQ | ETF | 25.17 | 25.25 | 25.11 | 25.23 | 6526900.0 |
| 2002-12-13 11:00:00 | QQQ | ETF | 25.23 | 25.3 | 25.12 | 25.25 | 4578800.0 |
| 2002-12-13 11:30:00 | QQQ | ETF | 25.26 | 25.3 | 25.13 | 25.25 | 3264000.0 |
| 2002-12-13 12:00:00 | QQQ | ETF | 25.25 | 25.26 | 25.16 | 25.18 | 1480200.0 |
| 2002-12-13 12:30:00 | QQQ | ETF | 25.18 | 25.39 | 25.17 | 25.36 | 2956400.0 |
| 2002-12-13 13:00:00 | QQQ | ETF | 25.36 | 25.41 | 25.2 | 25.22 | 4812000.0 |
| 2002-12-13 13:30:00 | QQQ | ETF | 25.23 | 25.32 | 25.21 | 25.26 | 2097500.0 |
| 2002-12-13 14:00:00 | QQQ | ETF | 25.25 | 25.28 | 25.16 | 25.19 | 1805100.0 |
| 2002-12-13 14:30:00 | QQQ | ETF | 25.19 | 25.25 | 25.06 | 25.09 | 3027400.0 |
| 2002-12-13 15:00:00 | QQQ | ETF | 25.09 | 25.2 | 25.07 | 25.11 | 4711800.0 |
| 2002-12-13 15:30:00 | QQQ | ETF | 25.11 | 25.17 | 25.03 | 25.05 | 6151100.0 |
| 2002-12-13 16:00:00 | QQQ | ETF | 25.05 | 25.09 | 24.97 | 24.99 | 3045800.0 |
| 2002-12-13 16:30:00 | QQQ | ETF | 24.98 | 25.02 | 24.97 | 25.0 | 73600.0 |
| 2002-12-13 17:00:00 | QQQ | ETF | 24.98 | 24.99 | 24.93 | 24.96 | 59400.0 |
| 2002-12-13 17:30:00 | QQQ | ETF | 24.93 | 24.98 | 24.9 | 24.94 | 44100.0 |
| 2002-12-13 18:00:00 | QQQ | ETF | 24.91 | 24.96 | 24.9 | 24.95 | 30000.0 |
| 2002-12-13 18:30:00 | QQQ | ETF | 24.93 | 24.96 | 24.9 | 24.95 | 14200.0 |
| 2002-12-13 19:00:00 | QQQ | ETF | 24.96 | 24.96 | 24.95 | 24.96 | 5600.0 |
| 2002-12-13 19:30:00 | QQQ | ETF | 24.96 | 24.97 | 24.9 | 24.95 | 9400.0 |
| 2002-12-13 08:30:00 | IWM | ETF | 39.21 | 39.21 | 39.01 | 39.01 | 5800.0 |
| 2002-12-13 09:00:00 | IWM | ETF | 39.02 | 39.11 | 39.02 | 39.035 | 18400.0 |
> showing 50 of 632 rows — these rows as CSV