PREVIEW / etf_30min / 2006-11-09
file: by_date/etf_30min/2006/2006-11-09.parquet size: 90 KB rows: 3,092
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-11-09 07:00:00 | SPY | ETF | 139.05 | 139.05 | 138.87 | 138.87 | 27100.0 |
| 2006-11-09 07:30:00 | SPY | ETF | 138.91 | 138.91 | 138.86 | 138.86 | 5400.0 |
| 2006-11-09 08:00:00 | SPY | ETF | 138.92 | 139.06 | 138.85 | 138.98 | 1087700.0 |
| 2006-11-09 08:30:00 | SPY | ETF | 138.99 | 139.1 | 138.94 | 139.03 | 868800.0 |
| 2006-11-09 09:00:00 | SPY | ETF | 139.03 | 139.09 | 138.96 | 139.01 | 648100.0 |
| 2006-11-09 09:30:00 | SPY | ETF | 139.01 | 139.14 | 138.8 | 138.97 | 7700600.0 |
| 2006-11-09 10:00:00 | SPY | ETF | 139.0 | 139.0 | 138.51 | 138.64 | 6837000.0 |
| 2006-11-09 10:30:00 | SPY | ETF | 138.64 | 138.88 | 138.61 | 138.86 | 4032900.0 |
| 2006-11-09 11:00:00 | SPY | ETF | 138.86 | 139.04 | 138.69 | 138.77 | 7117700.0 |
| 2006-11-09 11:30:00 | SPY | ETF | 138.77 | 138.93 | 138.63 | 138.73 | 9535200.0 |
| 2006-11-09 12:00:00 | SPY | ETF | 138.73 | 138.8 | 138.59 | 138.8 | 3103300.0 |
| 2006-11-09 12:30:00 | SPY | ETF | 138.8 | 138.84 | 138.65 | 138.79 | 2956600.0 |
| 2006-11-09 13:00:00 | SPY | ETF | 138.79 | 138.82 | 138.43 | 138.46 | 4283800.0 |
| 2006-11-09 13:30:00 | SPY | ETF | 138.44 | 138.65 | 138.43 | 138.49 | 3795400.0 |
| 2006-11-09 14:00:00 | SPY | ETF | 138.48 | 138.6 | 138.27 | 138.34 | 6446600.0 |
| 2006-11-09 14:30:00 | SPY | ETF | 138.33 | 138.36 | 138.04 | 138.24 | 21711600.0 |
| 2006-11-09 15:00:00 | SPY | ETF | 138.25 | 138.25 | 137.9 | 138.1 | 6058300.0 |
| 2006-11-09 15:30:00 | SPY | ETF | 138.11 | 138.17 | 137.92 | 138.1 | 7483200.0 |
| 2006-11-09 16:00:00 | SPY | ETF | 138.09 | 138.25 | 138.01 | 138.2 | 553800.0 |
| 2006-11-09 16:30:00 | SPY | ETF | 138.16 | 138.2 | 138.15 | 138.18 | 42000.0 |
| 2006-11-09 17:00:00 | SPY | ETF | 138.16 | 138.17 | 138.14 | 138.16 | 139500.0 |
| 2006-11-09 17:30:00 | SPY | ETF | 138.18 | 138.18 | 138.18 | 138.18 | 2200.0 |
| 2006-11-09 18:00:00 | SPY | ETF | 138.15 | 138.16 | 138.13 | 138.13 | 1400.0 |
| 2006-11-09 19:00:00 | SPY | ETF | 138.15 | 138.15 | 138.15 | 138.15 | 200.0 |
| 2006-11-09 19:30:00 | SPY | ETF | 138.13 | 138.15 | 138.13 | 138.15 | 2300.0 |
| 2006-11-09 09:30:00 | QQQ | ETF | 43.27 | 43.35 | 43.16 | 43.22 | 20645900.0 |
| 2006-11-09 10:00:00 | QQQ | ETF | 43.22 | 43.24 | 43.04 | 43.14 | 14896600.0 |
| 2006-11-09 10:30:00 | QQQ | ETF | 43.14 | 43.27 | 43.13 | 43.26 | 7209900.0 |
| 2006-11-09 11:00:00 | QQQ | ETF | 43.26 | 43.3 | 43.15 | 43.2 | 6299400.0 |
| 2006-11-09 11:30:00 | QQQ | ETF | 43.2 | 43.5 | 43.12 | 43.18 | 6559100.0 |
| 2006-11-09 12:00:00 | QQQ | ETF | 43.18 | 43.22 | 43.1 | 43.22 | 4308100.0 |
| 2006-11-09 12:30:00 | QQQ | ETF | 43.21 | 43.25 | 43.17 | 43.24 | 3127600.0 |
| 2006-11-09 13:00:00 | QQQ | ETF | 43.24 | 43.24 | 43.01 | 43.03 | 5561400.0 |
| 2006-11-09 13:30:00 | QQQ | ETF | 43.03 | 43.09 | 43.01 | 43.05 | 5362400.0 |
| 2006-11-09 14:00:00 | QQQ | ETF | 43.04 | 43.09 | 42.93 | 42.97 | 7161000.0 |
| 2006-11-09 14:30:00 | QQQ | ETF | 42.97 | 43.01 | 42.8 | 42.89 | 11978000.0 |
| 2006-11-09 15:00:00 | QQQ | ETF | 42.89 | 43.0 | 42.67 | 42.8 | 10088700.0 |
| 2006-11-09 15:30:00 | QQQ | ETF | 42.81 | 42.83 | 42.76 | 42.82 | 11290100.0 |
| 2006-11-09 07:00:00 | IWM | ETF | 76.65 | 76.65 | 76.65 | 76.65 | 100.0 |
| 2006-11-09 07:30:00 | IWM | ETF | 76.7 | 76.7 | 76.7 | 76.7 | 100.0 |
| 2006-11-09 08:00:00 | IWM | ETF | 76.63 | 76.8 | 76.6 | 76.8 | 20400.0 |
| 2006-11-09 08:30:00 | IWM | ETF | 76.8 | 76.82 | 76.75 | 76.75 | 66100.0 |
| 2006-11-09 09:00:00 | IWM | ETF | 76.74 | 76.76 | 76.69 | 76.76 | 255200.0 |
| 2006-11-09 09:30:00 | IWM | ETF | 76.74 | 76.8 | 76.31 | 76.44 | 5379400.0 |
| 2006-11-09 10:00:00 | IWM | ETF | 76.41 | 76.43 | 76.05 | 76.26 | 4064100.0 |
| 2006-11-09 10:30:00 | IWM | ETF | 76.26 | 76.5 | 76.18 | 76.49 | 2432700.0 |
| 2006-11-09 11:00:00 | IWM | ETF | 76.48 | 76.58 | 76.35 | 76.4 | 3405000.0 |
| 2006-11-09 11:30:00 | IWM | ETF | 76.4 | 76.52 | 76.28 | 76.31 | 2552500.0 |
| 2006-11-09 12:00:00 | IWM | ETF | 76.31 | 76.39 | 76.2 | 76.39 | 2461100.0 |
| 2006-11-09 12:30:00 | IWM | ETF | 76.39 | 76.46 | 76.29 | 76.45 | 1885000.0 |
> showing 50 of 3,092 rows — these rows as CSV