PREVIEW / etf_30min / 2006-03-01
file: by_date/etf_30min/2006/2006-03-01.parquet size: 61 KB rows: 2,180
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-03-01 06:30:00 | SPY | ETF | 128.64 | 128.64 | 128.64 | 128.64 | 100.0 |
| 2006-03-01 07:00:00 | SPY | ETF | 128.64 | 128.65 | 128.64 | 128.64 | 138800.0 |
| 2006-03-01 07:30:00 | SPY | ETF | 128.66 | 128.67 | 128.65 | 128.66 | 45100.0 |
| 2006-03-01 08:00:00 | SPY | ETF | 128.66 | 128.68 | 128.43 | 128.65 | 1006400.0 |
| 2006-03-01 08:30:00 | SPY | ETF | 128.63 | 128.7 | 128.23 | 128.65 | 269300.0 |
| 2006-03-01 09:00:00 | SPY | ETF | 128.63 | 128.65 | 128.23 | 128.6 | 287400.0 |
| 2006-03-01 09:30:00 | SPY | ETF | 128.6 | 128.83 | 128.6 | 128.77 | 7035600.0 |
| 2006-03-01 10:00:00 | SPY | ETF | 128.77 | 128.85 | 128.5 | 128.6 | 4984900.0 |
| 2006-03-01 10:30:00 | SPY | ETF | 128.61 | 128.9 | 128.6 | 128.82 | 3807700.0 |
| 2006-03-01 11:00:00 | SPY | ETF | 128.82 | 129.01 | 128.75 | 129.0 | 3818200.0 |
| 2006-03-01 11:30:00 | SPY | ETF | 128.99 | 129.22 | 128.99 | 129.2 | 4620300.0 |
| 2006-03-01 12:00:00 | SPY | ETF | 129.2 | 129.27 | 129.07 | 129.09 | 2001500.0 |
| 2006-03-01 12:30:00 | SPY | ETF | 129.09 | 129.23 | 129.04 | 129.15 | 2678900.0 |
| 2006-03-01 13:00:00 | SPY | ETF | 129.15 | 129.3 | 129.08 | 129.18 | 2388400.0 |
| 2006-03-01 13:30:00 | SPY | ETF | 129.18 | 129.26 | 129.13 | 129.25 | 1782900.0 |
| 2006-03-01 14:00:00 | SPY | ETF | 129.24 | 129.33 | 129.14 | 129.26 | 2283700.0 |
| 2006-03-01 14:30:00 | SPY | ETF | 129.26 | 129.36 | 129.18 | 129.26 | 2261300.0 |
| 2006-03-01 15:00:00 | SPY | ETF | 129.26 | 129.49 | 129.25 | 129.38 | 2091000.0 |
| 2006-03-01 15:30:00 | SPY | ETF | 129.38 | 129.49 | 129.29 | 129.39 | 3749400.0 |
| 2006-03-01 16:00:00 | SPY | ETF | 129.38 | 129.4 | 129.31 | 129.35 | 867900.0 |
| 2006-03-01 16:30:00 | SPY | ETF | 129.33 | 129.33 | 128.955 | 129.29 | 57800.0 |
| 2006-03-01 17:00:00 | SPY | ETF | 129.3 | 129.3 | 129.28 | 129.28 | 2500.0 |
| 2006-03-01 17:30:00 | SPY | ETF | 129.33 | 129.35 | 129.33 | 129.35 | 1600.0 |
| 2006-03-01 18:00:00 | SPY | ETF | 129.31 | 129.31 | 129.28 | 129.28 | 3900.0 |
| 2006-03-01 18:30:00 | SPY | ETF | 129.3 | 129.3 | 129.3 | 129.3 | 2900.0 |
| 2006-03-01 19:00:00 | SPY | ETF | 129.28 | 129.28 | 129.28 | 129.28 | 2400.0 |
| 2006-03-01 19:30:00 | SPY | ETF | 129.27 | 129.29 | 129.27 | 129.27 | 16200.0 |
| 2006-03-01 09:30:00 | QQQ | ETF | 41.21 | 41.33 | 41.19 | 41.3 | 10525100.0 |
| 2006-03-01 10:00:00 | QQQ | ETF | 41.29 | 41.32 | 41.15 | 41.28 | 8132400.0 |
| 2006-03-01 10:30:00 | QQQ | ETF | 41.28 | 41.44 | 41.25 | 41.38 | 8188600.0 |
| 2006-03-01 11:00:00 | QQQ | ETF | 41.38 | 41.54 | 41.36 | 41.52 | 6397200.0 |
| 2006-03-01 11:30:00 | QQQ | ETF | 41.52 | 41.62 | 41.51 | 41.61 | 5399400.0 |
| 2006-03-01 12:00:00 | QQQ | ETF | 41.61 | 41.67 | 41.56 | 41.58 | 3558000.0 |
| 2006-03-01 12:30:00 | QQQ | ETF | 41.58 | 41.63 | 41.57 | 41.61 | 2853800.0 |
| 2006-03-01 13:00:00 | QQQ | ETF | 41.6 | 41.64 | 41.55 | 41.58 | 4291500.0 |
| 2006-03-01 13:30:00 | QQQ | ETF | 41.58 | 41.62 | 41.55 | 41.61 | 4111100.0 |
| 2006-03-01 14:00:00 | QQQ | ETF | 41.61 | 41.67 | 41.57 | 41.65 | 6646500.0 |
| 2006-03-01 14:30:00 | QQQ | ETF | 41.65 | 41.73 | 41.63 | 41.69 | 3898100.0 |
| 2006-03-01 15:00:00 | QQQ | ETF | 41.7 | 41.77 | 41.68 | 41.72 | 4253700.0 |
| 2006-03-01 15:30:00 | QQQ | ETF | 41.72 | 41.75 | 41.64 | 41.66 | 8154300.0 |
| 2006-03-01 07:30:00 | IWM | ETF | 72.04 | 72.04 | 72.04 | 72.04 | 1000.0 |
| 2006-03-01 08:00:00 | IWM | ETF | 72.71 | 72.76 | 72.71 | 72.75 | 111900.0 |
| 2006-03-01 08:30:00 | IWM | ETF | 72.75 | 72.8 | 72.58 | 72.76 | 198600.0 |
| 2006-03-01 09:00:00 | IWM | ETF | 72.75 | 72.8 | 72.58 | 72.77 | 121200.0 |
| 2006-03-01 09:30:00 | IWM | ETF | 72.77 | 72.91 | 72.7 | 72.77 | 2479700.0 |
| 2006-03-01 10:00:00 | IWM | ETF | 72.76 | 72.85 | 72.62 | 72.74 | 1704900.0 |
| 2006-03-01 10:30:00 | IWM | ETF | 72.74 | 73.17 | 72.74 | 73.05 | 4186200.0 |
| 2006-03-01 11:00:00 | IWM | ETF | 73.06 | 73.27 | 73.06 | 73.27 | 2076500.0 |
| 2006-03-01 11:30:00 | IWM | ETF | 73.27 | 73.49 | 73.25 | 73.49 | 2285200.0 |
| 2006-03-01 12:00:00 | IWM | ETF | 73.49 | 73.52 | 73.38 | 73.41 | 994400.0 |
> showing 50 of 2,180 rows — these rows as CSV