PREVIEW / etf_30min / 2006-10-10
file: by_date/etf_30min/2006/2006-10-10.parquet size: 82 KB rows: 2,925
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-10-10 07:00:00 | SPY | ETF | 135.15 | 135.15 | 135.15 | 135.15 | 10000.0 |
| 2006-10-10 07:30:00 | SPY | ETF | 135.08 | 135.23 | 135.07 | 135.22 | 86700.0 |
| 2006-10-10 08:00:00 | SPY | ETF | 135.2 | 135.24 | 135.1 | 135.15 | 176300.0 |
| 2006-10-10 08:30:00 | SPY | ETF | 135.16 | 135.18 | 135.07 | 135.15 | 139800.0 |
| 2006-10-10 09:00:00 | SPY | ETF | 135.17 | 135.23 | 135.1 | 135.11 | 179300.0 |
| 2006-10-10 09:30:00 | SPY | ETF | 135.11 | 135.25 | 134.94 | 134.95 | 7634100.0 |
| 2006-10-10 10:00:00 | SPY | ETF | 134.95 | 135.06 | 134.89 | 134.99 | 4115700.0 |
| 2006-10-10 10:30:00 | SPY | ETF | 134.99 | 135.24 | 134.99 | 135.19 | 4059400.0 |
| 2006-10-10 11:00:00 | SPY | ETF | 135.19 | 135.45 | 135.1 | 135.36 | 6289800.0 |
| 2006-10-10 11:30:00 | SPY | ETF | 135.35 | 135.38 | 135.17 | 135.28 | 4896800.0 |
| 2006-10-10 12:00:00 | SPY | ETF | 135.27 | 135.34 | 135.05 | 135.05 | 2814800.0 |
| 2006-10-10 12:30:00 | SPY | ETF | 135.05 | 135.08 | 134.95 | 135.06 | 2529700.0 |
| 2006-10-10 13:00:00 | SPY | ETF | 135.07 | 135.16 | 134.96 | 134.99 | 2168500.0 |
| 2006-10-10 13:30:00 | SPY | ETF | 135.0 | 135.05 | 134.84 | 134.95 | 5663200.0 |
| 2006-10-10 14:00:00 | SPY | ETF | 134.95 | 135.04 | 134.91 | 135.0 | 3434600.0 |
| 2006-10-10 14:30:00 | SPY | ETF | 135.01 | 135.24 | 135.01 | 135.17 | 3588000.0 |
| 2006-10-10 15:00:00 | SPY | ETF | 135.18 | 135.31 | 135.11 | 135.25 | 3185900.0 |
| 2006-10-10 15:30:00 | SPY | ETF | 135.26 | 135.36 | 135.18 | 135.33 | 3338700.0 |
| 2006-10-10 16:00:00 | SPY | ETF | 135.33 | 135.4 | 135.21 | 135.22 | 664300.0 |
| 2006-10-10 16:30:00 | SPY | ETF | 135.24 | 135.24 | 135.13 | 135.18 | 353200.0 |
| 2006-10-10 17:00:00 | SPY | ETF | 135.18 | 135.19 | 135.14 | 135.15 | 284900.0 |
| 2006-10-10 17:30:00 | SPY | ETF | 135.16 | 135.16 | 135.1 | 135.11 | 16400.0 |
| 2006-10-10 18:00:00 | SPY | ETF | 135.14 | 135.15 | 135.12 | 135.12 | 23200.0 |
| 2006-10-10 18:30:00 | SPY | ETF | 135.14 | 135.14 | 135.14 | 135.14 | 200.0 |
| 2006-10-10 19:00:00 | SPY | ETF | 135.14 | 135.14 | 135.14 | 135.14 | 4400.0 |
| 2006-10-10 19:30:00 | SPY | ETF | 135.08 | 135.12 | 135.04 | 135.12 | 8300.0 |
| 2006-10-10 09:30:00 | QQQ | ETF | 41.61 | 41.69 | 41.55 | 41.55 | 17648800.0 |
| 2006-10-10 10:00:00 | QQQ | ETF | 41.56 | 41.6 | 41.42 | 41.47 | 11414500.0 |
| 2006-10-10 10:30:00 | QQQ | ETF | 41.47 | 41.61 | 41.47 | 41.6 | 7328000.0 |
| 2006-10-10 11:00:00 | QQQ | ETF | 41.6 | 41.75 | 41.56 | 41.69 | 8460600.0 |
| 2006-10-10 11:30:00 | QQQ | ETF | 41.68 | 41.7 | 41.59 | 41.64 | 2730300.0 |
| 2006-10-10 12:00:00 | QQQ | ETF | 41.64 | 41.68 | 41.52 | 41.53 | 4274200.0 |
| 2006-10-10 12:30:00 | QQQ | ETF | 41.53 | 41.54 | 41.45 | 41.5 | 6026100.0 |
| 2006-10-10 13:00:00 | QQQ | ETF | 41.5 | 41.54 | 41.46 | 41.47 | 2335300.0 |
| 2006-10-10 13:30:00 | QQQ | ETF | 41.46 | 41.47 | 41.31 | 41.4 | 9344100.0 |
| 2006-10-10 14:00:00 | QQQ | ETF | 41.39 | 41.43 | 41.35 | 41.4 | 3583100.0 |
| 2006-10-10 14:30:00 | QQQ | ETF | 41.4 | 41.59 | 41.4 | 41.51 | 7523600.0 |
| 2006-10-10 15:00:00 | QQQ | ETF | 41.5 | 41.57 | 41.46 | 41.51 | 3425600.0 |
| 2006-10-10 15:30:00 | QQQ | ETF | 41.51 | 41.63 | 41.5 | 41.62 | 7419400.0 |
| 2006-10-10 08:00:00 | IWM | ETF | 74.15 | 74.19 | 74.15 | 74.19 | 9600.0 |
| 2006-10-10 08:30:00 | IWM | ETF | 74.1 | 74.1 | 74.08 | 74.08 | 26600.0 |
| 2006-10-10 09:00:00 | IWM | ETF | 74.1 | 74.15 | 74.06 | 74.12 | 66600.0 |
| 2006-10-10 09:30:00 | IWM | ETF | 74.1 | 74.15 | 73.67 | 73.69 | 5521500.0 |
| 2006-10-10 10:00:00 | IWM | ETF | 73.69 | 73.86 | 73.66 | 73.86 | 2812600.0 |
| 2006-10-10 10:30:00 | IWM | ETF | 73.83 | 74.15 | 73.83 | 74.06 | 2874300.0 |
| 2006-10-10 11:00:00 | IWM | ETF | 74.07 | 74.36 | 73.93 | 74.26 | 3303700.0 |
| 2006-10-10 11:30:00 | IWM | ETF | 74.26 | 74.28 | 74.11 | 74.19 | 1019100.0 |
| 2006-10-10 12:00:00 | IWM | ETF | 74.17 | 74.25 | 73.97 | 74.03 | 1798300.0 |
| 2006-10-10 12:30:00 | IWM | ETF | 74.03 | 74.03 | 73.84 | 73.96 | 1455400.0 |
| 2006-10-10 13:00:00 | IWM | ETF | 73.96 | 74.05 | 73.88 | 73.91 | 3594500.0 |
> showing 50 of 2,925 rows — these rows as CSV