PREVIEW / etf_30min / 2006-01-03
file: by_date/etf_30min/2006/2006-01-03.parquet size: 64 KB rows: 2,205
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 |
|---|---|---|---|---|---|---|---|
| 2006-01-03 04:00:00 | SPY | ETF | 125.3 | 125.3 | 125.3 | 125.3 | 100.0 |
| 2006-01-03 05:00:00 | SPY | ETF | 125.44 | 125.49 | 125.44 | 125.49 | 1600.0 |
| 2006-01-03 05:30:00 | SPY | ETF | 125.46 | 125.46 | 125.46 | 125.46 | 500.0 |
| 2006-01-03 06:00:00 | SPY | ETF | 125.36 | 125.4 | 125.35 | 125.4 | 4200.0 |
| 2006-01-03 07:00:00 | SPY | ETF | 125.34 | 125.37 | 125.32 | 125.36 | 62800.0 |
| 2006-01-03 07:30:00 | SPY | ETF | 125.36 | 125.39 | 125.27 | 125.35 | 54100.0 |
| 2006-01-03 08:00:00 | SPY | ETF | 125.33 | 125.38 | 124.51 | 125.2 | 557700.0 |
| 2006-01-03 08:30:00 | SPY | ETF | 125.2 | 125.32 | 124.51 | 125.27 | 730400.0 |
| 2006-01-03 09:00:00 | SPY | ETF | 125.26 | 125.33 | 125.11 | 125.11 | 342100.0 |
| 2006-01-03 09:30:00 | SPY | ETF | 125.1 | 125.3 | 124.98 | 125.13 | 7231200.0 |
| 2006-01-03 10:00:00 | SPY | ETF | 125.13 | 125.28 | 124.56 | 124.6299 | 6149900.0 |
| 2006-01-03 10:30:00 | SPY | ETF | 124.63 | 124.73 | 124.39 | 124.67 | 5774800.0 |
| 2006-01-03 11:00:00 | SPY | ETF | 124.68 | 124.85 | 124.6 | 124.76 | 1681100.0 |
| 2006-01-03 11:30:00 | SPY | ETF | 124.77 | 125.0 | 124.74 | 124.99 | 2771100.0 |
| 2006-01-03 12:00:00 | SPY | ETF | 124.95 | 125.07 | 124.88 | 124.9 | 2161600.0 |
| 2006-01-03 12:30:00 | SPY | ETF | 124.9 | 125.05 | 124.77 | 124.97 | 1585700.0 |
| 2006-01-03 13:00:00 | SPY | ETF | 124.98 | 125.02 | 124.83 | 124.93 | 1321900.0 |
| 2006-01-03 13:30:00 | SPY | ETF | 124.91 | 125.12 | 124.81 | 124.96 | 2032200.0 |
| 2006-01-03 14:00:00 | SPY | ETF | 124.96 | 125.82 | 124.96 | 125.71 | 11129700.0 |
| 2006-01-03 14:30:00 | SPY | ETF | 125.71 | 126.19 | 125.7 | 126.16 | 5986300.0 |
| 2006-01-03 15:00:00 | SPY | ETF | 126.16 | 126.73 | 126.132 | 126.64 | 7055900.0 |
| 2006-01-03 15:30:00 | SPY | ETF | 126.64 | 127.0 | 126.6 | 126.75 | 8917000.0 |
| 2006-01-03 16:00:00 | SPY | ETF | 126.79 | 126.86 | 125.6 | 126.68 | 2304800.0 |
| 2006-01-03 16:30:00 | SPY | ETF | 126.68 | 126.73 | 126.64 | 126.69 | 131100.0 |
| 2006-01-03 17:00:00 | SPY | ETF | 126.74 | 126.79 | 126.7 | 126.7 | 108800.0 |
| 2006-01-03 17:30:00 | SPY | ETF | 126.8 | 126.8 | 126.79 | 126.79 | 1400.0 |
| 2006-01-03 18:00:00 | SPY | ETF | 126.8 | 126.8 | 126.73 | 126.74 | 131400.0 |
| 2006-01-03 18:30:00 | SPY | ETF | 126.72 | 126.72 | 126.69 | 126.69 | 5600.0 |
| 2006-01-03 19:00:00 | SPY | ETF | 126.7 | 126.71 | 126.68 | 126.68 | 3900.0 |
| 2006-01-03 19:30:00 | SPY | ETF | 126.68 | 126.68 | 126.67 | 126.67 | 1000.0 |
| 2006-01-03 09:30:00 | QQQ | ETF | 40.65 | 40.68 | 40.5 | 40.59 | 10533500.0 |
| 2006-01-03 10:00:00 | QQQ | ETF | 40.58 | 40.63 | 40.23 | 40.27 | 9855300.0 |
| 2006-01-03 10:30:00 | QQQ | ETF | 40.27 | 40.37 | 40.1 | 40.34 | 7740200.0 |
| 2006-01-03 11:00:00 | QQQ | ETF | 40.35 | 40.42 | 40.32 | 40.38 | 5250700.0 |
| 2006-01-03 11:30:00 | QQQ | ETF | 40.38 | 40.55 | 40.38 | 40.54 | 5351300.0 |
| 2006-01-03 12:00:00 | QQQ | ETF | 40.55 | 40.62 | 40.52 | 40.56 | 4279500.0 |
| 2006-01-03 12:30:00 | QQQ | ETF | 40.55 | 40.6 | 40.5 | 40.55 | 2359400.0 |
| 2006-01-03 13:00:00 | QQQ | ETF | 40.56 | 40.59 | 40.48 | 40.52 | 1657800.0 |
| 2006-01-03 13:30:00 | QQQ | ETF | 40.52 | 40.6 | 40.46 | 40.54 | 1943100.0 |
| 2006-01-03 14:00:00 | QQQ | ETF | 40.53 | 40.98 | 40.46 | 40.95 | 18923200.0 |
| 2006-01-03 14:30:00 | QQQ | ETF | 40.95 | 41.16 | 40.95 | 41.12 | 8461500.0 |
| 2006-01-03 15:00:00 | QQQ | ETF | 41.11 | 41.42 | 41.11 | 41.39 | 12264400.0 |
| 2006-01-03 15:30:00 | QQQ | ETF | 41.39 | 41.49 | 41.28 | 41.31 | 13072300.0 |
| 2006-01-03 04:30:00 | IWM | ETF | 66.89 | 66.89 | 66.89 | 66.89 | 100.0 |
| 2006-01-03 05:00:00 | IWM | ETF | 66.89 | 66.89 | 66.89 | 66.89 | 100.0 |
| 2006-01-03 06:30:00 | IWM | ETF | 66.89 | 66.89 | 66.89 | 66.89 | 200.0 |
| 2006-01-03 07:00:00 | IWM | ETF | 66.89 | 67.89 | 66.89 | 67.89 | 27400.0 |
| 2006-01-03 07:30:00 | IWM | ETF | 67.42 | 67.45 | 67.34 | 67.43 | 85500.0 |
| 2006-01-03 08:00:00 | IWM | ETF | 66.69 | 67.89 | 66.69 | 67.27 | 449600.0 |
| 2006-01-03 08:30:00 | IWM | ETF | 67.27 | 67.27 | 66.69 | 67.27 | 275700.0 |
> showing 50 of 2,205 rows — these rows as CSV