PREVIEW / etf_30min / 2006-10-26
file: by_date/etf_30min/2006/2006-10-26.parquet size: 87 KB rows: 3,002
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-26 06:00:00 | SPY | ETF | 138.75 | 138.75 | 138.75 | 138.75 | 2000.0 |
| 2006-10-26 06:30:00 | SPY | ETF | 138.74 | 138.74 | 138.74 | 138.74 | 7200.0 |
| 2006-10-26 07:00:00 | SPY | ETF | 138.72 | 138.72 | 138.66 | 138.66 | 13900.0 |
| 2006-10-26 07:30:00 | SPY | ETF | 138.66 | 138.71 | 138.66 | 138.7 | 31400.0 |
| 2006-10-26 08:00:00 | SPY | ETF | 138.71 | 138.78 | 138.67 | 138.74 | 289800.0 |
| 2006-10-26 08:30:00 | SPY | ETF | 138.71 | 138.79 | 138.63 | 138.69 | 844100.0 |
| 2006-10-26 09:00:00 | SPY | ETF | 138.69 | 138.75 | 138.67 | 138.67 | 110800.0 |
| 2006-10-26 09:30:00 | SPY | ETF | 138.66 | 138.73 | 138.5 | 138.57 | 5472300.0 |
| 2006-10-26 10:00:00 | SPY | ETF | 138.56 | 138.63 | 138.1 | 138.11 | 7852400.0 |
| 2006-10-26 10:30:00 | SPY | ETF | 138.12 | 138.25 | 137.98 | 138.13 | 5233800.0 |
| 2006-10-26 11:00:00 | SPY | ETF | 138.12 | 138.23 | 138.0 | 138.21 | 3396100.0 |
| 2006-10-26 11:30:00 | SPY | ETF | 138.2 | 138.29 | 138.16 | 138.26 | 2598500.0 |
| 2006-10-26 12:00:00 | SPY | ETF | 138.27 | 138.54 | 138.21 | 138.46 | 6250700.0 |
| 2006-10-26 12:30:00 | SPY | ETF | 138.45 | 138.59 | 138.36 | 138.53 | 2952300.0 |
| 2006-10-26 13:00:00 | SPY | ETF | 138.53 | 138.62 | 138.45 | 138.53 | 1873400.0 |
| 2006-10-26 13:30:00 | SPY | ETF | 138.53 | 138.75 | 138.5 | 138.65 | 4439700.0 |
| 2006-10-26 14:00:00 | SPY | ETF | 138.63 | 138.9 | 138.63 | 138.88 | 6084100.0 |
| 2006-10-26 14:30:00 | SPY | ETF | 138.89 | 138.97 | 138.75 | 138.96 | 6852100.0 |
| 2006-10-26 15:00:00 | SPY | ETF | 138.95 | 138.96 | 138.7 | 138.86 | 3477800.0 |
| 2006-10-26 15:30:00 | SPY | ETF | 138.86 | 139.0 | 138.82 | 138.86 | 5682400.0 |
| 2006-10-26 16:00:00 | SPY | ETF | 138.86 | 138.95 | 138.7 | 138.76 | 1635300.0 |
| 2006-10-26 16:30:00 | SPY | ETF | 138.76 | 138.78 | 138.71 | 138.71 | 806200.0 |
| 2006-10-26 17:00:00 | SPY | ETF | 138.74 | 138.82 | 138.74 | 138.8 | 99700.0 |
| 2006-10-26 17:30:00 | SPY | ETF | 138.82 | 138.84 | 138.76 | 138.82 | 6900.0 |
| 2006-10-26 18:00:00 | SPY | ETF | 138.81 | 138.81 | 138.8 | 138.81 | 4700.0 |
| 2006-10-26 18:30:00 | SPY | ETF | 138.79 | 138.79 | 138.79 | 138.79 | 100.0 |
| 2006-10-26 19:00:00 | SPY | ETF | 138.79 | 138.79 | 138.77 | 138.77 | 300.0 |
| 2006-10-26 19:30:00 | SPY | ETF | 138.75 | 138.75 | 138.75 | 138.75 | 100.0 |
| 2006-10-26 09:30:00 | QQQ | ETF | 42.57 | 42.58 | 42.41 | 42.47 | 9579200.0 |
| 2006-10-26 10:00:00 | QQQ | ETF | 42.48 | 42.56 | 42.26 | 42.28 | 12222900.0 |
| 2006-10-26 10:30:00 | QQQ | ETF | 42.28 | 42.4 | 42.22 | 42.31 | 9827400.0 |
| 2006-10-26 11:00:00 | QQQ | ETF | 42.32 | 42.4 | 42.25 | 42.39 | 4328200.0 |
| 2006-10-26 11:30:00 | QQQ | ETF | 42.39 | 42.49 | 42.39 | 42.47 | 6124400.0 |
| 2006-10-26 12:00:00 | QQQ | ETF | 42.47 | 42.61 | 42.43 | 42.58 | 9061000.0 |
| 2006-10-26 12:30:00 | QQQ | ETF | 42.59 | 42.63 | 42.5 | 42.59 | 4294800.0 |
| 2006-10-26 13:00:00 | QQQ | ETF | 42.59 | 42.65 | 42.55 | 42.6 | 4464600.0 |
| 2006-10-26 13:30:00 | QQQ | ETF | 42.6 | 42.74 | 42.59 | 42.71 | 7360200.0 |
| 2006-10-26 14:00:00 | QQQ | ETF | 42.73 | 42.88 | 42.7 | 42.87 | 12194000.0 |
| 2006-10-26 14:30:00 | QQQ | ETF | 42.88 | 42.92 | 42.78 | 42.88 | 8911700.0 |
| 2006-10-26 15:00:00 | QQQ | ETF | 42.89 | 42.89 | 42.76 | 42.82 | 6183300.0 |
| 2006-10-26 15:30:00 | QQQ | ETF | 42.82 | 42.91 | 42.78 | 42.82 | 10147000.0 |
| 2006-10-26 08:00:00 | IWM | ETF | 76.6 | 76.68 | 76.5 | 76.66 | 192400.0 |
| 2006-10-26 08:30:00 | IWM | ETF | 76.65 | 76.76 | 76.45 | 76.72 | 76300.0 |
| 2006-10-26 09:00:00 | IWM | ETF | 76.72 | 76.74 | 76.62 | 76.64 | 45600.0 |
| 2006-10-26 09:30:00 | IWM | ETF | 76.64 | 76.7 | 76.46 | 76.55 | 6513300.0 |
| 2006-10-26 10:00:00 | IWM | ETF | 76.55 | 76.67 | 76.03 | 76.04 | 6173100.0 |
| 2006-10-26 10:30:00 | IWM | ETF | 76.04 | 76.11 | 75.87 | 76.1 | 3638800.0 |
| 2006-10-26 11:00:00 | IWM | ETF | 76.1 | 76.15 | 75.95 | 76.13 | 2161400.0 |
| 2006-10-26 11:30:00 | IWM | ETF | 76.13 | 76.2794 | 76.13 | 76.26 | 2625700.0 |
| 2006-10-26 12:00:00 | IWM | ETF | 76.26 | 76.39 | 76.2 | 76.32 | 2556000.0 |
> showing 50 of 3,002 rows — these rows as CSV