PREVIEW / etf_30min / 2005-12-29
file: by_date/etf_30min/2005/2005-12-29.parquet size: 55 KB rows: 2,030
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-29 07:30:00 | SPY | ETF | 125.74 | 125.74 | 125.74 | 125.74 | 500.0 |
| 2005-12-29 08:00:00 | SPY | ETF | 125.74 | 125.76 | 125.64 | 125.66 | 64000.0 |
| 2005-12-29 08:30:00 | SPY | ETF | 125.66 | 125.72 | 125.64 | 125.72 | 33900.0 |
| 2005-12-29 09:00:00 | SPY | ETF | 125.72 | 125.73 | 125.69 | 125.72 | 243700.0 |
| 2005-12-29 09:30:00 | SPY | ETF | 125.72 | 125.96 | 125.71 | 125.77 | 2699900.0 |
| 2005-12-29 10:00:00 | SPY | ETF | 125.77 | 125.82 | 125.64 | 125.69 | 2854700.0 |
| 2005-12-29 10:30:00 | SPY | ETF | 125.68 | 125.82 | 125.56 | 125.68 | 2868200.0 |
| 2005-12-29 11:00:00 | SPY | ETF | 125.68 | 125.89 | 125.66 | 125.85 | 1867500.0 |
| 2005-12-29 11:30:00 | SPY | ETF | 125.84 | 125.86 | 125.77 | 125.77 | 1374200.0 |
| 2005-12-29 12:00:00 | SPY | ETF | 125.78 | 125.82 | 125.67 | 125.69 | 1338200.0 |
| 2005-12-29 12:30:00 | SPY | ETF | 125.71 | 125.85 | 125.66 | 125.85 | 976000.0 |
| 2005-12-29 13:00:00 | SPY | ETF | 125.85 | 125.89 | 125.74 | 125.76 | 1232700.0 |
| 2005-12-29 13:30:00 | SPY | ETF | 125.76 | 125.78 | 125.7 | 125.71 | 888800.0 |
| 2005-12-29 14:00:00 | SPY | ETF | 125.71 | 125.87 | 125.7 | 125.8 | 1641300.0 |
| 2005-12-29 14:30:00 | SPY | ETF | 125.8 | 125.85 | 125.73 | 125.75 | 1024200.0 |
| 2005-12-29 15:00:00 | SPY | ETF | 125.75 | 125.78 | 125.25 | 125.36 | 6621200.0 |
| 2005-12-29 15:30:00 | SPY | ETF | 125.36 | 125.43 | 125.25 | 125.31 | 4688200.0 |
| 2005-12-29 16:00:00 | SPY | ETF | 125.3 | 125.3 | 125.06 | 125.21 | 651800.0 |
| 2005-12-29 16:30:00 | SPY | ETF | 125.2 | 125.27 | 125.14 | 125.27 | 49400.0 |
| 2005-12-29 17:00:00 | SPY | ETF | 125.22 | 125.6904 | 125.2 | 125.2 | 635000.0 |
| 2005-12-29 17:30:00 | SPY | ETF | 125.23 | 125.23 | 125.22 | 125.22 | 1200.0 |
| 2005-12-29 18:00:00 | SPY | ETF | 125.25 | 125.25 | 125.21 | 125.21 | 244700.0 |
| 2005-12-29 19:00:00 | SPY | ETF | 125.24 | 125.24 | 125.24 | 125.24 | 300.0 |
| 2005-12-29 19:30:00 | SPY | ETF | 125.27 | 125.27 | 125.24 | 125.24 | 1100.0 |
| 2005-12-29 09:30:00 | QQQ | ETF | 41.03 | 41.12 | 40.98 | 41.02 | 5029900.0 |
| 2005-12-29 10:00:00 | QQQ | ETF | 41.02 | 41.05 | 40.96 | 41.02 | 3024200.0 |
| 2005-12-29 10:30:00 | QQQ | ETF | 41.01 | 41.04 | 40.94 | 41.0 | 3423800.0 |
| 2005-12-29 11:00:00 | QQQ | ETF | 40.99 | 41.07 | 40.98 | 41.02 | 3137500.0 |
| 2005-12-29 11:30:00 | QQQ | ETF | 41.01 | 41.02 | 40.96 | 40.96 | 2349000.0 |
| 2005-12-29 12:00:00 | QQQ | ETF | 40.97 | 40.98 | 40.89 | 40.89 | 2645200.0 |
| 2005-12-29 12:30:00 | QQQ | ETF | 40.9 | 40.97 | 40.88 | 40.96 | 2073200.0 |
| 2005-12-29 13:00:00 | QQQ | ETF | 40.96 | 40.99 | 40.92 | 40.93 | 1449600.0 |
| 2005-12-29 13:30:00 | QQQ | ETF | 40.94 | 40.95 | 40.91 | 40.92 | 944500.0 |
| 2005-12-29 14:00:00 | QQQ | ETF | 40.91 | 40.97 | 40.91 | 40.94 | 1328000.0 |
| 2005-12-29 14:30:00 | QQQ | ETF | 40.94 | 40.95 | 40.91 | 40.91 | 1021500.0 |
| 2005-12-29 15:00:00 | QQQ | ETF | 40.92 | 40.93 | 40.69 | 40.74 | 9764600.0 |
| 2005-12-29 15:30:00 | QQQ | ETF | 40.74 | 40.74 | 40.65 | 40.72 | 7235400.0 |
| 2005-12-29 08:00:00 | IWM | ETF | 67.48 | 67.48 | 67.4 | 67.45 | 123600.0 |
| 2005-12-29 08:30:00 | IWM | ETF | 67.48 | 67.51 | 67.48 | 67.5 | 178000.0 |
| 2005-12-29 09:00:00 | IWM | ETF | 67.48 | 67.54 | 67.47 | 67.5 | 53500.0 |
| 2005-12-29 09:30:00 | IWM | ETF | 67.5 | 67.57 | 67.27 | 67.34 | 2175400.0 |
| 2005-12-29 10:00:00 | IWM | ETF | 67.34 | 67.44 | 67.24 | 67.44 | 2283100.0 |
| 2005-12-29 10:30:00 | IWM | ETF | 67.44 | 67.5 | 67.28 | 67.43 | 1336200.0 |
| 2005-12-29 11:00:00 | IWM | ETF | 67.43 | 67.61 | 67.42 | 67.53 | 1964700.0 |
| 2005-12-29 11:30:00 | IWM | ETF | 67.53 | 67.6 | 67.46 | 67.49 | 836600.0 |
| 2005-12-29 12:00:00 | IWM | ETF | 67.49 | 67.49 | 67.41 | 67.45 | 1484000.0 |
| 2005-12-29 12:30:00 | IWM | ETF | 67.44 | 67.65 | 67.43 | 67.65 | 925400.0 |
| 2005-12-29 13:00:00 | IWM | ETF | 67.65 | 67.7 | 67.58 | 67.6 | 374200.0 |
| 2005-12-29 13:30:00 | IWM | ETF | 67.6 | 67.63 | 67.56 | 67.58 | 450700.0 |
| 2005-12-29 14:00:00 | IWM | ETF | 67.58 | 67.72 | 67.57 | 67.7 | 1322800.0 |
> showing 50 of 2,030 rows — these rows as CSV