PREVIEW / etf_30min / 2006-01-05
file: by_date/etf_30min/2006/2006-01-05.parquet size: 55 KB rows: 2,090
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-05 06:00:00 | SPY | ETF | 127.14 | 127.14 | 127.14 | 127.14 | 500.0 |
| 2006-01-05 07:00:00 | SPY | ETF | 127.22 | 127.22 | 127.22 | 127.22 | 500.0 |
| 2006-01-05 07:30:00 | SPY | ETF | 127.27 | 127.27 | 127.14 | 127.14 | 14000.0 |
| 2006-01-05 08:00:00 | SPY | ETF | 127.23 | 127.25 | 127.09 | 127.14 | 705100.0 |
| 2006-01-05 08:30:00 | SPY | ETF | 127.15 | 127.2 | 127.12 | 127.2 | 160000.0 |
| 2006-01-05 09:00:00 | SPY | ETF | 127.19 | 127.21 | 127.16 | 127.18 | 210500.0 |
| 2006-01-05 09:30:00 | SPY | ETF | 127.17 | 127.49 | 127.15 | 127.25 | 5970200.0 |
| 2006-01-05 10:00:00 | SPY | ETF | 127.25 | 127.59 | 127.23 | 127.31 | 4331100.0 |
| 2006-01-05 10:30:00 | SPY | ETF | 127.31 | 127.38 | 126.9 | 127.08 | 5228700.0 |
| 2006-01-05 11:00:00 | SPY | ETF | 127.08 | 127.35 | 127.05 | 127.15 | 2948600.0 |
| 2006-01-05 11:30:00 | SPY | ETF | 127.18 | 127.4 | 127.16 | 127.37 | 4993600.0 |
| 2006-01-05 12:00:00 | SPY | ETF | 127.37 | 127.48 | 127.3 | 127.36 | 1863000.0 |
| 2006-01-05 12:30:00 | SPY | ETF | 127.37 | 127.44 | 127.06 | 127.1 | 2788500.0 |
| 2006-01-05 13:00:00 | SPY | ETF | 127.1 | 127.29 | 127.08 | 127.16 | 1594500.0 |
| 2006-01-05 13:30:00 | SPY | ETF | 127.17 | 127.29 | 127.13 | 127.2 | 1098700.0 |
| 2006-01-05 14:00:00 | SPY | ETF | 127.2 | 127.21 | 126.9 | 126.95 | 3137800.0 |
| 2006-01-05 14:30:00 | SPY | ETF | 126.96 | 127.11 | 126.88 | 127.11 | 2585600.0 |
| 2006-01-05 15:00:00 | SPY | ETF | 127.09 | 127.2 | 127.03 | 127.17 | 2272900.0 |
| 2006-01-05 15:30:00 | SPY | ETF | 127.17 | 127.25 | 127.09 | 127.23 | 5764300.0 |
| 2006-01-05 16:00:00 | SPY | ETF | 127.23 | 127.42 | 127.19 | 127.38 | 865600.0 |
| 2006-01-05 16:30:00 | SPY | ETF | 127.4 | 127.42 | 127.18 | 127.39 | 23500.0 |
| 2006-01-05 17:00:00 | SPY | ETF | 127.4 | 127.42 | 127.4 | 127.42 | 4000.0 |
| 2006-01-05 17:30:00 | SPY | ETF | 127.39 | 127.39 | 127.35 | 127.35 | 4000.0 |
| 2006-01-05 18:00:00 | SPY | ETF | 127.36 | 127.36 | 127.36 | 127.36 | 2000.0 |
| 2006-01-05 19:00:00 | SPY | ETF | 127.4 | 127.4 | 127.4 | 127.4 | 200.0 |
| 2006-01-05 19:30:00 | SPY | ETF | 127.41 | 127.41 | 127.4 | 127.41 | 3800.0 |
| 2006-01-05 09:30:00 | QQQ | ETF | 41.75 | 41.91 | 41.73 | 41.76 | 12844500.0 |
| 2006-01-05 10:00:00 | QQQ | ETF | 41.76 | 41.99 | 41.75 | 41.88 | 11696700.0 |
| 2006-01-05 10:30:00 | QQQ | ETF | 41.88 | 41.93 | 41.43 | 41.83 | 8135900.0 |
| 2006-01-05 11:00:00 | QQQ | ETF | 41.83 | 41.92 | 41.82 | 41.86 | 3866900.0 |
| 2006-01-05 11:30:00 | QQQ | ETF | 41.86 | 41.99 | 41.84 | 41.97 | 5013300.0 |
| 2006-01-05 12:00:00 | QQQ | ETF | 41.97 | 42.0 | 41.94 | 41.95 | 2887700.0 |
| 2006-01-05 12:30:00 | QQQ | ETF | 41.95 | 41.97 | 41.84 | 41.85 | 4396800.0 |
| 2006-01-05 13:00:00 | QQQ | ETF | 41.84 | 41.93 | 41.84 | 41.88 | 2439500.0 |
| 2006-01-05 13:30:00 | QQQ | ETF | 41.89 | 41.95 | 41.87 | 41.91 | 1958200.0 |
| 2006-01-05 14:00:00 | QQQ | ETF | 41.91 | 41.92 | 41.8 | 41.82 | 5056400.0 |
| 2006-01-05 14:30:00 | QQQ | ETF | 41.82 | 41.89 | 41.8 | 41.89 | 6308400.0 |
| 2006-01-05 15:00:00 | QQQ | ETF | 41.88 | 41.93 | 41.86 | 41.89 | 2658600.0 |
| 2006-01-05 15:30:00 | QQQ | ETF | 41.88 | 41.95 | 41.88 | 41.92 | 4838200.0 |
| 2006-01-05 08:00:00 | IWM | ETF | 68.35 | 68.4 | 68.29 | 68.38 | 578700.0 |
| 2006-01-05 08:30:00 | IWM | ETF | 68.36 | 68.4 | 68.36 | 68.4 | 43900.0 |
| 2006-01-05 09:00:00 | IWM | ETF | 68.4 | 68.43 | 68.4 | 68.42 | 15800.0 |
| 2006-01-05 09:30:00 | IWM | ETF | 68.43 | 68.6 | 68.37 | 68.4 | 2565900.0 |
| 2006-01-05 10:00:00 | IWM | ETF | 68.4 | 68.68 | 68.4 | 68.49 | 2480100.0 |
| 2006-01-05 10:30:00 | IWM | ETF | 68.5 | 68.54 | 68.25 | 68.36 | 3256500.0 |
| 2006-01-05 11:00:00 | IWM | ETF | 68.37 | 68.67 | 68.36 | 68.49 | 1905000.0 |
| 2006-01-05 11:30:00 | IWM | ETF | 68.49 | 68.67 | 68.46 | 68.64 | 1474000.0 |
| 2006-01-05 12:00:00 | IWM | ETF | 68.65 | 68.78 | 68.6 | 68.66 | 1326100.0 |
| 2006-01-05 12:30:00 | IWM | ETF | 68.65 | 68.74 | 68.51 | 68.51 | 1712200.0 |
| 2006-01-05 13:00:00 | IWM | ETF | 68.51 | 68.71 | 68.49 | 68.6 | 467200.0 |
> showing 50 of 2,090 rows — these rows as CSV