PREVIEW / etf_30min / 2006-02-08
file: by_date/etf_30min/2006/2006-02-08.parquet size: 60 KB rows: 2,170
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-02-08 06:00:00 | SPY | ETF | 125.79 | 125.79 | 125.79 | 125.79 | 100.0 |
| 2006-02-08 06:30:00 | SPY | ETF | 125.89 | 125.89 | 125.89 | 125.89 | 100.0 |
| 2006-02-08 07:00:00 | SPY | ETF | 125.8 | 125.93 | 125.8 | 125.92 | 62800.0 |
| 2006-02-08 07:30:00 | SPY | ETF | 125.9 | 125.91 | 125.85 | 125.85 | 18800.0 |
| 2006-02-08 08:00:00 | SPY | ETF | 125.82 | 125.93 | 125.56 | 125.91 | 1200000.0 |
| 2006-02-08 08:30:00 | SPY | ETF | 125.88 | 125.88 | 125.82 | 125.85 | 92700.0 |
| 2006-02-08 09:00:00 | SPY | ETF | 125.87 | 125.93 | 125.86 | 125.9 | 263700.0 |
| 2006-02-08 09:30:00 | SPY | ETF | 125.88 | 125.96 | 125.63 | 125.68 | 6594400.0 |
| 2006-02-08 10:00:00 | SPY | ETF | 125.69 | 126.04 | 125.6 | 126.0 | 6531800.0 |
| 2006-02-08 10:30:00 | SPY | ETF | 126.02 | 126.07 | 125.71 | 125.77 | 5157600.0 |
| 2006-02-08 11:00:00 | SPY | ETF | 125.77 | 125.94 | 125.68 | 125.88 | 4009100.0 |
| 2006-02-08 11:30:00 | SPY | ETF | 125.872 | 125.96 | 125.8 | 125.92 | 2190500.0 |
| 2006-02-08 12:00:00 | SPY | ETF | 125.92 | 126.24 | 125.9 | 126.15 | 4102600.0 |
| 2006-02-08 12:30:00 | SPY | ETF | 126.15 | 126.37 | 126.12 | 126.27 | 3813500.0 |
| 2006-02-08 13:00:00 | SPY | ETF | 126.27 | 126.28 | 126.07 | 126.1 | 3471900.0 |
| 2006-02-08 13:30:00 | SPY | ETF | 126.09 | 126.21 | 126.02 | 126.14 | 2227200.0 |
| 2006-02-08 14:00:00 | SPY | ETF | 126.14 | 128.1 | 125.96 | 126.06 | 2262500.0 |
| 2006-02-08 14:30:00 | SPY | ETF | 126.07 | 126.27 | 126.05 | 126.21 | 1478200.0 |
| 2006-02-08 15:00:00 | SPY | ETF | 126.22 | 126.65 | 126.11 | 126.59 | 4874900.0 |
| 2006-02-08 15:30:00 | SPY | ETF | 126.6 | 126.78 | 126.48 | 126.63 | 5054800.0 |
| 2006-02-08 16:00:00 | SPY | ETF | 126.62 | 126.71 | 126.59 | 126.61 | 611600.0 |
| 2006-02-08 16:30:00 | SPY | ETF | 126.61 | 126.67 | 126.6 | 126.67 | 1068500.0 |
| 2006-02-08 17:00:00 | SPY | ETF | 126.65 | 126.65 | 126.61 | 126.63 | 113300.0 |
| 2006-02-08 17:30:00 | SPY | ETF | 126.6 | 126.6 | 126.59 | 126.6 | 9900.0 |
| 2006-02-08 18:00:00 | SPY | ETF | 126.63 | 126.65 | 126.63 | 126.65 | 1800.0 |
| 2006-02-08 19:00:00 | SPY | ETF | 126.62 | 126.62 | 126.62 | 126.62 | 300.0 |
| 2006-02-08 19:30:00 | SPY | ETF | 126.6 | 126.6 | 126.6 | 126.6 | 1000.0 |
| 2006-02-08 09:30:00 | QQQ | ETF | 40.92 | 40.93 | 40.72 | 40.76 | 11789500.0 |
| 2006-02-08 10:00:00 | QQQ | ETF | 40.75 | 40.88 | 40.69 | 40.87 | 8653300.0 |
| 2006-02-08 10:30:00 | QQQ | ETF | 40.87 | 40.89 | 40.73 | 40.75 | 6913400.0 |
| 2006-02-08 11:00:00 | QQQ | ETF | 40.76 | 40.81 | 40.69 | 40.8 | 6635200.0 |
| 2006-02-08 11:30:00 | QQQ | ETF | 40.8 | 40.9 | 40.8 | 40.88 | 5200200.0 |
| 2006-02-08 12:00:00 | QQQ | ETF | 40.88 | 40.99 | 40.88 | 40.93 | 5486000.0 |
| 2006-02-08 12:30:00 | QQQ | ETF | 40.93 | 41.11 | 40.92 | 41.01 | 6565700.0 |
| 2006-02-08 13:00:00 | QQQ | ETF | 41.01 | 41.02 | 40.94 | 40.96 | 2880000.0 |
| 2006-02-08 13:30:00 | QQQ | ETF | 40.97 | 41.0 | 40.89 | 40.95 | 3260600.0 |
| 2006-02-08 14:00:00 | QQQ | ETF | 40.94 | 40.98 | 40.83 | 40.91 | 3668600.0 |
| 2006-02-08 14:30:00 | QQQ | ETF | 40.9 | 40.98 | 40.87 | 40.95 | 2942800.0 |
| 2006-02-08 15:00:00 | QQQ | ETF | 40.94 | 41.1 | 40.91 | 41.08 | 5329500.0 |
| 2006-02-08 15:30:00 | QQQ | ETF | 41.07 | 41.15 | 41.04 | 41.1 | 7167900.0 |
| 2006-02-08 07:30:00 | IWM | ETF | 71.42 | 71.42 | 71.42 | 71.42 | 300.0 |
| 2006-02-08 08:00:00 | IWM | ETF | 71.44 | 71.46 | 71.4 | 71.46 | 352000.0 |
| 2006-02-08 08:30:00 | IWM | ETF | 71.44 | 71.44 | 71.4 | 71.41 | 60700.0 |
| 2006-02-08 09:00:00 | IWM | ETF | 71.4 | 71.45 | 71.4 | 71.44 | 95200.0 |
| 2006-02-08 09:30:00 | IWM | ETF | 71.44 | 71.47 | 71.05 | 71.1 | 2542100.0 |
| 2006-02-08 10:00:00 | IWM | ETF | 71.09 | 71.27 | 70.97 | 71.26 | 4090400.0 |
| 2006-02-08 10:30:00 | IWM | ETF | 71.25 | 71.35 | 71.04 | 71.09 | 2972400.0 |
| 2006-02-08 11:00:00 | IWM | ETF | 71.08 | 71.12 | 70.88 | 71.1 | 2375200.0 |
| 2006-02-08 11:30:00 | IWM | ETF | 71.09 | 71.14 | 71.0 | 71.06 | 2889300.0 |
| 2006-02-08 12:00:00 | IWM | ETF | 71.06 | 71.31 | 71.05 | 71.24 | 2929900.0 |
> showing 50 of 2,170 rows — these rows as CSV