PREVIEW / etf_30min / 2006-10-05
file: by_date/etf_30min/2006/2006-10-05.parquet size: 81 KB rows: 2,911
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-05 06:00:00 | SPY | ETF | 134.99 | 134.99 | 134.99 | 134.99 | 1000.0 |
| 2006-10-05 06:30:00 | SPY | ETF | 134.93 | 134.93 | 134.89 | 134.89 | 55000.0 |
| 2006-10-05 07:00:00 | SPY | ETF | 134.89 | 134.94 | 134.86 | 134.94 | 206800.0 |
| 2006-10-05 07:30:00 | SPY | ETF | 134.87 | 134.91 | 134.86 | 134.87 | 38600.0 |
| 2006-10-05 08:00:00 | SPY | ETF | 134.86 | 134.9 | 134.81 | 134.85 | 2300000.0 |
| 2006-10-05 08:30:00 | SPY | ETF | 134.83 | 134.96 | 134.81 | 134.95 | 655600.0 |
| 2006-10-05 09:00:00 | SPY | ETF | 134.94 | 134.97 | 134.89 | 134.9 | 725200.0 |
| 2006-10-05 09:30:00 | SPY | ETF | 134.92 | 135.1 | 134.85 | 135.05 | 9550200.0 |
| 2006-10-05 10:00:00 | SPY | ETF | 135.05 | 135.14 | 134.79 | 134.87 | 5140800.0 |
| 2006-10-05 10:30:00 | SPY | ETF | 134.87 | 135.04 | 134.77 | 135.0 | 3496200.0 |
| 2006-10-05 11:00:00 | SPY | ETF | 135.01 | 135.01 | 134.85 | 134.9 | 2777900.0 |
| 2006-10-05 11:30:00 | SPY | ETF | 134.89 | 135.19 | 134.89 | 135.01 | 4547800.0 |
| 2006-10-05 12:00:00 | SPY | ETF | 135.01 | 135.07 | 134.97 | 134.99 | 1050600.0 |
| 2006-10-05 12:30:00 | SPY | ETF | 134.98 | 135.01 | 134.75 | 134.91 | 4644200.0 |
| 2006-10-05 13:00:00 | SPY | ETF | 134.91 | 135.12 | 134.89 | 135.01 | 3225600.0 |
| 2006-10-05 13:30:00 | SPY | ETF | 135.01 | 135.15 | 134.94 | 135.0 | 1578000.0 |
| 2006-10-05 14:00:00 | SPY | ETF | 135.0 | 135.08 | 134.94 | 135.01 | 1091300.0 |
| 2006-10-05 14:30:00 | SPY | ETF | 135.03 | 135.18 | 135.01 | 135.15 | 1952000.0 |
| 2006-10-05 15:00:00 | SPY | ETF | 135.14 | 135.41 | 135.1 | 135.34 | 8887600.0 |
| 2006-10-05 15:30:00 | SPY | ETF | 135.33 | 135.37 | 135.21 | 135.3 | 4501700.0 |
| 2006-10-05 16:00:00 | SPY | ETF | 135.3 | 135.3 | 135.18 | 135.23 | 1188200.0 |
| 2006-10-05 16:30:00 | SPY | ETF | 135.21 | 135.27 | 135.17 | 135.24 | 388800.0 |
| 2006-10-05 17:00:00 | SPY | ETF | 135.24 | 135.27 | 135.2 | 135.24 | 136200.0 |
| 2006-10-05 17:30:00 | SPY | ETF | 135.22 | 135.29 | 135.22 | 135.29 | 51000.0 |
| 2006-10-05 18:00:00 | SPY | ETF | 135.24 | 135.24 | 135.18 | 135.18 | 89800.0 |
| 2006-10-05 18:30:00 | SPY | ETF | 135.17 | 135.17 | 135.17 | 135.17 | 500.0 |
| 2006-10-05 19:00:00 | SPY | ETF | 135.18 | 135.18 | 135.18 | 135.18 | 2900.0 |
| 2006-10-05 09:30:00 | QQQ | ETF | 41.29 | 41.4 | 41.2 | 41.37 | 12566400.0 |
| 2006-10-05 10:00:00 | QQQ | ETF | 41.38 | 41.42 | 41.18 | 41.25 | 10181500.0 |
| 2006-10-05 10:30:00 | QQQ | ETF | 41.25 | 41.42 | 41.2 | 41.39 | 8020200.0 |
| 2006-10-05 11:00:00 | QQQ | ETF | 41.38 | 41.4 | 41.28 | 41.32 | 4060300.0 |
| 2006-10-05 11:30:00 | QQQ | ETF | 41.31 | 41.49 | 41.31 | 41.39 | 6405900.0 |
| 2006-10-05 12:00:00 | QQQ | ETF | 41.39 | 41.41 | 41.33 | 41.33 | 2110500.0 |
| 2006-10-05 12:30:00 | QQQ | ETF | 41.34 | 41.35 | 41.22 | 41.32 | 4644800.0 |
| 2006-10-05 13:00:00 | QQQ | ETF | 41.32 | 41.48 | 41.31 | 41.45 | 7380300.0 |
| 2006-10-05 13:30:00 | QQQ | ETF | 41.44 | 41.47 | 41.39 | 41.4 | 4371700.0 |
| 2006-10-05 14:00:00 | QQQ | ETF | 41.4 | 41.43 | 41.34 | 41.37 | 3102200.0 |
| 2006-10-05 14:30:00 | QQQ | ETF | 41.38 | 41.47 | 41.37 | 41.45 | 3804600.0 |
| 2006-10-05 15:00:00 | QQQ | ETF | 41.45 | 41.56 | 41.4 | 41.51 | 7448300.0 |
| 2006-10-05 15:30:00 | QQQ | ETF | 41.51 | 41.52 | 41.46 | 41.49 | 8300400.0 |
| 2006-10-05 08:00:00 | IWM | ETF | 72.9 | 72.95 | 72.85 | 72.9 | 15600.0 |
| 2006-10-05 08:30:00 | IWM | ETF | 72.83 | 72.9 | 72.82 | 72.9 | 70800.0 |
| 2006-10-05 09:00:00 | IWM | ETF | 72.89 | 72.97 | 72.82 | 72.88 | 168700.0 |
| 2006-10-05 09:30:00 | IWM | ETF | 72.87 | 73.39 | 72.85 | 73.33 | 6157900.0 |
| 2006-10-05 10:00:00 | IWM | ETF | 73.33 | 73.39 | 72.98 | 73.07 | 4468200.0 |
| 2006-10-05 10:30:00 | IWM | ETF | 73.06 | 73.2 | 72.93 | 73.15 | 3084600.0 |
| 2006-10-05 11:00:00 | IWM | ETF | 73.14 | 73.2 | 73.01 | 73.05 | 2304600.0 |
| 2006-10-05 11:30:00 | IWM | ETF | 73.05 | 73.36 | 73.03 | 73.2 | 1949900.0 |
| 2006-10-05 12:00:00 | IWM | ETF | 73.21 | 73.25 | 73.14 | 73.16 | 689300.0 |
| 2006-10-05 12:30:00 | IWM | ETF | 73.16 | 73.18 | 72.97 | 73.1 | 2611100.0 |
> showing 50 of 2,911 rows — these rows as CSV