PREVIEW / etf_30min / 2005-12-09
file: by_date/etf_30min/2005/2005-12-09.parquet size: 52 KB rows: 1,828
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 |
|---|---|---|---|---|---|---|---|
| 2005-12-09 06:30:00 | SPY | ETF | 126.06 | 126.06 | 126.06 | 126.06 | 100.0 |
| 2005-12-09 07:00:00 | SPY | ETF | 126.06 | 126.06 | 126.04 | 126.05 | 21900.0 |
| 2005-12-09 07:30:00 | SPY | ETF | 126.09 | 126.1 | 126.09 | 126.1 | 1900.0 |
| 2005-12-09 08:00:00 | SPY | ETF | 126.11 | 126.23 | 126.05 | 126.23 | 772800.0 |
| 2005-12-09 08:30:00 | SPY | ETF | 126.2 | 126.33 | 126.12 | 126.28 | 762700.0 |
| 2005-12-09 09:00:00 | SPY | ETF | 126.23 | 126.25 | 126.18 | 126.18 | 55500.0 |
| 2005-12-09 09:30:00 | SPY | ETF | 126.16 | 126.33 | 126.11 | 126.16 | 6197500.0 |
| 2005-12-09 10:00:00 | SPY | ETF | 126.16 | 126.22 | 125.84 | 125.9 | 5658500.0 |
| 2005-12-09 10:30:00 | SPY | ETF | 125.88 | 126.11 | 125.82 | 126.06 | 4293000.0 |
| 2005-12-09 11:00:00 | SPY | ETF | 126.06 | 126.36 | 126.05 | 126.1 | 3850200.0 |
| 2005-12-09 11:30:00 | SPY | ETF | 126.11 | 126.25 | 125.95 | 125.96 | 1624600.0 |
| 2005-12-09 12:00:00 | SPY | ETF | 125.96 | 126.23 | 125.92 | 126.1 | 2504700.0 |
| 2005-12-09 12:30:00 | SPY | ETF | 126.1 | 126.31 | 126.09 | 126.25 | 1694000.0 |
| 2005-12-09 13:00:00 | SPY | ETF | 126.25 | 126.37 | 125.99 | 126.28 | 1638400.0 |
| 2005-12-09 13:30:00 | SPY | ETF | 126.28 | 126.6 | 126.27 | 126.41 | 4690300.0 |
| 2005-12-09 14:00:00 | SPY | ETF | 126.4 | 126.76 | 126.39 | 126.74 | 3132400.0 |
| 2005-12-09 14:30:00 | SPY | ETF | 126.75 | 126.78 | 126.58 | 126.61 | 3386000.0 |
| 2005-12-09 15:00:00 | SPY | ETF | 126.61 | 126.65 | 126.42 | 126.61 | 3186800.0 |
| 2005-12-09 15:30:00 | SPY | ETF | 126.61 | 126.62 | 126.31 | 126.41 | 4443600.0 |
| 2005-12-09 16:00:00 | SPY | ETF | 126.41 | 126.44 | 126.26 | 126.31 | 1067400.0 |
| 2005-12-09 16:30:00 | SPY | ETF | 126.32 | 126.33 | 126.25 | 126.33 | 45000.0 |
| 2005-12-09 17:00:00 | SPY | ETF | 126.35 | 126.36 | 126.35 | 126.36 | 1000.0 |
| 2005-12-09 17:30:00 | SPY | ETF | 126.37 | 126.38 | 126.31 | 126.31 | 3300.0 |
| 2005-12-09 18:30:00 | SPY | ETF | 126.33 | 126.33 | 126.33 | 126.33 | 200.0 |
| 2005-12-09 19:00:00 | SPY | ETF | 126.33 | 126.36 | 126.33 | 126.36 | 1700.0 |
| 2005-12-09 19:30:00 | SPY | ETF | 126.35 | 126.36 | 126.35 | 126.36 | 1100.0 |
| 2005-12-09 09:30:00 | QQQ | ETF | 41.57 | 41.67 | 41.52 | 41.56 | 7577400.0 |
| 2005-12-09 10:00:00 | QQQ | ETF | 41.56 | 41.59 | 41.41 | 41.43 | 6836000.0 |
| 2005-12-09 10:30:00 | QQQ | ETF | 41.42 | 41.52 | 41.38 | 41.5 | 4997700.0 |
| 2005-12-09 11:00:00 | QQQ | ETF | 41.5 | 41.65 | 41.49 | 41.52 | 5082500.0 |
| 2005-12-09 11:30:00 | QQQ | ETF | 41.51 | 41.59 | 41.48 | 41.49 | 2002800.0 |
| 2005-12-09 12:00:00 | QQQ | ETF | 41.49 | 41.56 | 41.46 | 41.5 | 2339300.0 |
| 2005-12-09 12:30:00 | QQQ | ETF | 41.5 | 41.58 | 41.49 | 41.56 | 1385300.0 |
| 2005-12-09 13:00:00 | QQQ | ETF | 41.56 | 41.62 | 41.56 | 41.6 | 1712400.0 |
| 2005-12-09 13:30:00 | QQQ | ETF | 41.59 | 41.7 | 41.59 | 41.62 | 3891800.0 |
| 2005-12-09 14:00:00 | QQQ | ETF | 41.63 | 41.76 | 41.59 | 41.76 | 3625800.0 |
| 2005-12-09 14:30:00 | QQQ | ETF | 41.75 | 41.77 | 41.67 | 41.7 | 5515600.0 |
| 2005-12-09 15:00:00 | QQQ | ETF | 41.71 | 41.75 | 41.65 | 41.74 | 2554400.0 |
| 2005-12-09 15:30:00 | QQQ | ETF | 41.74 | 41.75 | 41.67 | 41.71 | 5997600.0 |
| 2005-12-09 08:00:00 | IWM | ETF | 68.36 | 68.4 | 68.36 | 68.4 | 13700.0 |
| 2005-12-09 08:30:00 | IWM | ETF | 68.46 | 68.46 | 68.3 | 68.3 | 131800.0 |
| 2005-12-09 09:00:00 | IWM | ETF | 68.34 | 68.34 | 68.34 | 68.34 | 200.0 |
| 2005-12-09 09:30:00 | IWM | ETF | 68.4 | 68.5 | 68.24 | 68.31 | 1844700.0 |
| 2005-12-09 10:00:00 | IWM | ETF | 68.31 | 68.35 | 67.98 | 68.01 | 2535200.0 |
| 2005-12-09 10:30:00 | IWM | ETF | 68.01 | 68.1888 | 67.95 | 68.18 | 926100.0 |
| 2005-12-09 11:00:00 | IWM | ETF | 68.19 | 68.45 | 68.15 | 68.28 | 2358700.0 |
| 2005-12-09 11:30:00 | IWM | ETF | 68.28 | 68.39 | 68.11 | 68.11 | 1081200.0 |
| 2005-12-09 12:00:00 | IWM | ETF | 68.11 | 68.29 | 68.08 | 68.23 | 1009500.0 |
| 2005-12-09 12:30:00 | IWM | ETF | 68.24 | 68.42 | 68.17 | 68.41 | 822800.0 |
| 2005-12-09 13:00:00 | IWM | ETF | 68.41 | 68.56 | 68.41 | 68.47 | 1382300.0 |
> showing 50 of 1,828 rows — these rows as CSV