PREVIEW / etf_30min / 2006-09-15
file: by_date/etf_30min/2006/2006-09-15.parquet size: 81 KB rows: 2,860
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-09-15 04:00:00 | SPY | ETF | 131.66 | 131.66 | 131.66 | 131.66 | 300.0 |
| 2006-09-15 04:30:00 | SPY | ETF | 131.67 | 131.68 | 131.67 | 131.68 | 1000.0 |
| 2006-09-15 07:00:00 | SPY | ETF | 131.57 | 131.57 | 131.57 | 131.57 | 1900.0 |
| 2006-09-15 07:30:00 | SPY | ETF | 131.6 | 131.72 | 131.6 | 131.66 | 17900.0 |
| 2006-09-15 08:00:00 | SPY | ETF | 131.67 | 131.85 | 131.56 | 131.79 | 1514700.0 |
| 2006-09-15 08:30:00 | SPY | ETF | 131.81 | 132.3 | 131.79 | 132.28 | 2909600.0 |
| 2006-09-15 09:00:00 | SPY | ETF | 132.27 | 132.39 | 132.23 | 132.31 | 1135000.0 |
| 2006-09-15 09:30:00 | SPY | ETF | 132.31 | 132.34 | 131.92 | 132.06 | 10145900.0 |
| 2006-09-15 10:00:00 | SPY | ETF | 132.07 | 132.39 | 132.0 | 132.28 | 6041200.0 |
| 2006-09-15 10:30:00 | SPY | ETF | 132.28 | 132.31 | 132.07 | 132.11 | 3341200.0 |
| 2006-09-15 11:00:00 | SPY | ETF | 132.1 | 132.18 | 131.86 | 131.9 | 4939700.0 |
| 2006-09-15 11:30:00 | SPY | ETF | 131.9 | 132.0 | 131.87 | 131.92 | 2338000.0 |
| 2006-09-15 12:00:00 | SPY | ETF | 131.91 | 131.97 | 131.77 | 131.89 | 4274700.0 |
| 2006-09-15 12:30:00 | SPY | ETF | 131.9 | 131.93 | 131.68 | 131.7 | 3737300.0 |
| 2006-09-15 13:00:00 | SPY | ETF | 131.71 | 131.96 | 131.68 | 131.82 | 3274600.0 |
| 2006-09-15 13:30:00 | SPY | ETF | 131.81 | 132.08 | 131.8 | 131.96 | 5749900.0 |
| 2006-09-15 14:00:00 | SPY | ETF | 131.96 | 132.14 | 131.92 | 132.0 | 2185400.0 |
| 2006-09-15 14:30:00 | SPY | ETF | 132.01 | 132.17 | 131.9 | 131.97 | 2382200.0 |
| 2006-09-15 15:00:00 | SPY | ETF | 131.97 | 132.1 | 131.95 | 132.05 | 3499000.0 |
| 2006-09-15 15:30:00 | SPY | ETF | 132.05 | 132.06 | 131.79 | 131.82 | 7235800.0 |
| 2006-09-15 16:00:00 | SPY | ETF | 131.83 | 132.34 | 131.82 | 131.94 | 1819800.0 |
| 2006-09-15 16:30:00 | SPY | ETF | 131.95 | 131.96 | 131.92 | 131.94 | 155500.0 |
| 2006-09-15 17:00:00 | SPY | ETF | 131.95 | 131.95 | 131.94 | 131.94 | 37800.0 |
| 2006-09-15 17:30:00 | SPY | ETF | 131.0802 | 131.94 | 131.0802 | 131.94 | 1953200.0 |
| 2006-09-15 18:30:00 | SPY | ETF | 131.97 | 131.98 | 131.86 | 131.86 | 11400.0 |
| 2006-09-15 19:30:00 | SPY | ETF | 131.9 | 131.9 | 131.9 | 131.9 | 100.0 |
| 2006-09-15 09:30:00 | QQQ | ETF | 40.34 | 40.38 | 40.17 | 40.24 | 25234100.0 |
| 2006-09-15 10:00:00 | QQQ | ETF | 40.25 | 40.46 | 40.19 | 40.37 | 12412400.0 |
| 2006-09-15 10:30:00 | QQQ | ETF | 40.37 | 40.4 | 40.23 | 40.26 | 7274400.0 |
| 2006-09-15 11:00:00 | QQQ | ETF | 40.26 | 40.3 | 40.12 | 40.15 | 9404700.0 |
| 2006-09-15 11:30:00 | QQQ | ETF | 40.15 | 40.21 | 40.14 | 40.16 | 4431400.0 |
| 2006-09-15 12:00:00 | QQQ | ETF | 40.16 | 40.21 | 40.1 | 40.16 | 4819500.0 |
| 2006-09-15 12:30:00 | QQQ | ETF | 40.16 | 40.16 | 40.0 | 40.01 | 9086600.0 |
| 2006-09-15 13:00:00 | QQQ | ETF | 40.01 | 40.15 | 40.01 | 40.07 | 5988100.0 |
| 2006-09-15 13:30:00 | QQQ | ETF | 40.07 | 40.19 | 40.06 | 40.13 | 4338900.0 |
| 2006-09-15 14:00:00 | QQQ | ETF | 40.13 | 40.2 | 40.11 | 40.18 | 3450800.0 |
| 2006-09-15 14:30:00 | QQQ | ETF | 40.18 | 40.25 | 40.12 | 40.15 | 4635600.0 |
| 2006-09-15 15:00:00 | QQQ | ETF | 40.16 | 40.21 | 40.13 | 40.19 | 6322600.0 |
| 2006-09-15 15:30:00 | QQQ | ETF | 40.19 | 40.2 | 40.09 | 40.1 | 12631700.0 |
| 2006-09-15 07:30:00 | IWM | ETF | 72.4 | 72.5 | 72.1 | 72.5 | 4300.0 |
| 2006-09-15 08:00:00 | IWM | ETF | 72.5 | 72.56 | 72.43 | 72.48 | 313400.0 |
| 2006-09-15 08:30:00 | IWM | ETF | 72.6 | 73.04 | 72.6 | 73.04 | 1429400.0 |
| 2006-09-15 09:00:00 | IWM | ETF | 73.04 | 73.07 | 72.99 | 73.02 | 467400.0 |
| 2006-09-15 09:30:00 | IWM | ETF | 73.0 | 73.02 | 72.54 | 72.59 | 5816900.0 |
| 2006-09-15 10:00:00 | IWM | ETF | 72.59 | 73.01 | 72.51 | 72.91 | 4411300.0 |
| 2006-09-15 10:30:00 | IWM | ETF | 72.91 | 72.96 | 72.58 | 72.67 | 2119200.0 |
| 2006-09-15 11:00:00 | IWM | ETF | 72.66 | 72.77 | 72.3 | 72.39 | 2850700.0 |
| 2006-09-15 11:30:00 | IWM | ETF | 72.38 | 72.57 | 72.36 | 72.49 | 898500.0 |
| 2006-09-15 12:00:00 | IWM | ETF | 72.5 | 72.65 | 72.38 | 72.48 | 3557400.0 |
| 2006-09-15 12:30:00 | IWM | ETF | 72.49 | 72.51 | 72.17 | 72.23 | 2239300.0 |
> showing 50 of 2,860 rows — these rows as CSV