PREVIEW / etf_30min / 2006-03-08
file: by_date/etf_30min/2006/2006-03-08.parquet size: 62 KB rows: 2,166
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-08 05:00:00 | SPY | ETF | 128.02 | 128.02 | 127.97 | 127.97 | 2300.0 |
| 2006-03-08 06:30:00 | SPY | ETF | 127.63 | 127.68 | 127.62 | 127.68 | 27600.0 |
| 2006-03-08 07:00:00 | SPY | ETF | 127.68 | 127.72 | 127.66 | 127.72 | 41300.0 |
| 2006-03-08 07:30:00 | SPY | ETF | 127.71 | 127.71 | 127.65 | 127.68 | 8700.0 |
| 2006-03-08 08:00:00 | SPY | ETF | 127.68 | 127.78 | 127.59 | 127.59 | 645400.0 |
| 2006-03-08 08:30:00 | SPY | ETF | 127.62 | 128.16 | 127.54 | 127.65 | 643600.0 |
| 2006-03-08 09:00:00 | SPY | ETF | 127.64 | 127.72 | 127.64 | 127.71 | 92300.0 |
| 2006-03-08 09:30:00 | SPY | ETF | 127.7 | 128.0 | 127.49 | 127.99 | 5703200.0 |
| 2006-03-08 10:00:00 | SPY | ETF | 127.99 | 128.06 | 127.78 | 127.8 | 5986600.0 |
| 2006-03-08 10:30:00 | SPY | ETF | 127.81 | 128.03 | 127.68 | 127.81 | 3432900.0 |
| 2006-03-08 11:00:00 | SPY | ETF | 127.82 | 127.82 | 127.6 | 127.64 | 3310900.0 |
| 2006-03-08 11:30:00 | SPY | ETF | 127.64 | 127.64 | 127.18 | 127.32 | 5959100.0 |
| 2006-03-08 12:00:00 | SPY | ETF | 127.32 | 127.64 | 127.31 | 127.64 | 3892600.0 |
| 2006-03-08 12:30:00 | SPY | ETF | 127.63 | 127.96 | 127.57 | 127.84 | 5175500.0 |
| 2006-03-08 13:00:00 | SPY | ETF | 127.84 | 127.97 | 127.7 | 127.75 | 3936600.0 |
| 2006-03-08 13:30:00 | SPY | ETF | 127.78 | 127.8 | 127.58 | 127.69 | 1881200.0 |
| 2006-03-08 14:00:00 | SPY | ETF | 127.68 | 128.04 | 127.63 | 127.94 | 5771100.0 |
| 2006-03-08 14:30:00 | SPY | ETF | 127.97 | 128.44 | 127.94 | 128.3 | 7690700.0 |
| 2006-03-08 15:00:00 | SPY | ETF | 128.29 | 128.44 | 128.26 | 128.33 | 3323200.0 |
| 2006-03-08 15:30:00 | SPY | ETF | 128.33 | 128.41 | 128.17 | 128.17 | 4202900.0 |
| 2006-03-08 16:00:00 | SPY | ETF | 128.17 | 128.3 | 127.65 | 128.23 | 2296300.0 |
| 2006-03-08 16:30:00 | SPY | ETF | 128.22 | 128.26 | 128.21 | 128.23 | 147200.0 |
| 2006-03-08 17:00:00 | SPY | ETF | 128.23 | 128.24 | 128.2 | 128.24 | 75600.0 |
| 2006-03-08 17:30:00 | SPY | ETF | 128.22 | 128.24 | 128.2 | 128.24 | 1500.0 |
| 2006-03-08 18:00:00 | SPY | ETF | 128.24 | 128.24 | 128.22 | 128.22 | 12400.0 |
| 2006-03-08 18:30:00 | SPY | ETF | 128.22 | 128.22 | 128.22 | 128.22 | 200.0 |
| 2006-03-08 19:30:00 | SPY | ETF | 128.25 | 128.26 | 128.25 | 128.25 | 21700.0 |
| 2006-03-08 09:30:00 | QQQ | ETF | 40.77 | 40.94 | 40.69 | 40.92 | 9986700.0 |
| 2006-03-08 10:00:00 | QQQ | ETF | 40.92 | 40.97 | 40.76 | 40.78 | 9100800.0 |
| 2006-03-08 10:30:00 | QQQ | ETF | 40.78 | 40.87 | 40.66 | 40.74 | 13337800.0 |
| 2006-03-08 11:00:00 | QQQ | ETF | 40.74 | 40.77 | 40.65 | 40.72 | 4684800.0 |
| 2006-03-08 11:30:00 | QQQ | ETF | 40.71 | 40.76 | 40.5 | 40.57 | 11628700.0 |
| 2006-03-08 12:00:00 | QQQ | ETF | 40.58 | 40.72 | 40.57 | 40.7 | 3909700.0 |
| 2006-03-08 12:30:00 | QQQ | ETF | 40.71 | 40.86 | 40.69 | 40.79 | 7318800.0 |
| 2006-03-08 13:00:00 | QQQ | ETF | 40.79 | 40.85 | 40.72 | 40.79 | 3893000.0 |
| 2006-03-08 13:30:00 | QQQ | ETF | 40.78 | 40.8 | 40.69 | 40.73 | 3208000.0 |
| 2006-03-08 14:00:00 | QQQ | ETF | 40.73 | 40.92 | 40.71 | 40.87 | 6522600.0 |
| 2006-03-08 14:30:00 | QQQ | ETF | 40.87 | 42.02 | 40.86 | 41.0 | 9918000.0 |
| 2006-03-08 15:00:00 | QQQ | ETF | 41.0 | 41.03 | 40.96 | 41.01 | 4444400.0 |
| 2006-03-08 15:30:00 | QQQ | ETF | 41.02 | 41.02 | 40.85 | 40.85 | 6670200.0 |
| 2006-03-08 08:00:00 | IWM | ETF | 71.48 | 71.48 | 71.35 | 71.36 | 33100.0 |
| 2006-03-08 08:30:00 | IWM | ETF | 71.35 | 71.35 | 71.25 | 71.28 | 301500.0 |
| 2006-03-08 09:00:00 | IWM | ETF | 71.33 | 71.39 | 71.26 | 71.39 | 819500.0 |
| 2006-03-08 09:30:00 | IWM | ETF | 71.45 | 71.51 | 71.14 | 71.49 | 6328200.0 |
| 2006-03-08 10:00:00 | IWM | ETF | 71.49 | 71.57 | 71.19 | 71.25 | 6970100.0 |
| 2006-03-08 10:30:00 | IWM | ETF | 71.26 | 71.6 | 71.15 | 71.35 | 4612200.0 |
| 2006-03-08 11:00:00 | IWM | ETF | 71.35 | 71.51 | 71.15 | 71.17 | 2408700.0 |
| 2006-03-08 11:30:00 | IWM | ETF | 71.17 | 71.17 | 70.88 | 71.03 | 4504200.0 |
| 2006-03-08 12:00:00 | IWM | ETF | 71.02 | 71.2 | 71.01 | 71.19 | 1471000.0 |
| 2006-03-08 12:30:00 | IWM | ETF | 71.18 | 71.63 | 71.17 | 71.48 | 4205500.0 |
> showing 50 of 2,166 rows — these rows as CSV