PREVIEW / etf_30min / 2006-11-27
file: by_date/etf_30min/2006/2006-11-27.parquet size: 94 KB rows: 3,203
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-27 04:00:00 | SPY | ETF | 140.6 | 140.6 | 140.6 | 140.6 | 200.0 |
| 2006-11-27 07:00:00 | SPY | ETF | 140.35 | 140.36 | 140.28 | 140.28 | 34400.0 |
| 2006-11-27 07:30:00 | SPY | ETF | 140.25 | 140.25 | 140.16 | 140.2 | 251700.0 |
| 2006-11-27 08:00:00 | SPY | ETF | 140.21 | 140.52 | 140.17 | 140.3 | 566200.0 |
| 2006-11-27 08:30:00 | SPY | ETF | 140.29 | 140.31 | 140.2 | 140.2 | 344000.0 |
| 2006-11-27 09:00:00 | SPY | ETF | 140.22 | 140.3 | 140.21 | 140.29 | 390900.0 |
| 2006-11-27 09:30:00 | SPY | ETF | 140.28 | 140.35 | 139.78 | 139.78 | 9430600.0 |
| 2006-11-27 10:00:00 | SPY | ETF | 139.79 | 139.81 | 139.34 | 139.48 | 9486300.0 |
| 2006-11-27 10:30:00 | SPY | ETF | 139.48 | 139.54 | 139.3 | 139.53 | 3937800.0 |
| 2006-11-27 11:00:00 | SPY | ETF | 139.53 | 139.54 | 138.84 | 138.91 | 7488900.0 |
| 2006-11-27 11:30:00 | SPY | ETF | 138.91 | 139.98 | 138.9 | 138.97 | 4402200.0 |
| 2006-11-27 12:00:00 | SPY | ETF | 138.96 | 139.12 | 138.86 | 139.03 | 3688200.0 |
| 2006-11-27 12:30:00 | SPY | ETF | 139.03 | 139.1 | 138.73 | 138.75 | 5221800.0 |
| 2006-11-27 13:00:00 | SPY | ETF | 138.75 | 138.89 | 138.62 | 138.89 | 5256900.0 |
| 2006-11-27 13:30:00 | SPY | ETF | 138.89 | 138.94 | 138.7 | 138.84 | 3492300.0 |
| 2006-11-27 14:00:00 | SPY | ETF | 138.85 | 138.87 | 138.49 | 138.61 | 8517700.0 |
| 2006-11-27 14:30:00 | SPY | ETF | 138.61 | 138.75 | 138.46 | 138.51 | 4735400.0 |
| 2006-11-27 15:00:00 | SPY | ETF | 138.51 | 138.62 | 138.44 | 138.55 | 4153200.0 |
| 2006-11-27 15:30:00 | SPY | ETF | 138.56 | 138.7 | 138.49 | 138.49 | 6757600.0 |
| 2006-11-27 16:00:00 | SPY | ETF | 138.49 | 138.5 | 138.38 | 138.42 | 1139900.0 |
| 2006-11-27 16:30:00 | SPY | ETF | 138.45 | 138.47 | 138.41 | 138.43 | 1815100.0 |
| 2006-11-27 17:00:00 | SPY | ETF | 138.41 | 138.43 | 137.1918 | 138.37 | 836800.0 |
| 2006-11-27 17:30:00 | SPY | ETF | 138.4 | 138.43 | 138.4 | 138.42 | 2500.0 |
| 2006-11-27 18:00:00 | SPY | ETF | 138.42 | 138.45 | 138.4 | 138.44 | 2300.0 |
| 2006-11-27 18:30:00 | SPY | ETF | 138.43 | 138.47 | 138.43 | 138.47 | 700.0 |
| 2006-11-27 19:00:00 | SPY | ETF | 138.45 | 138.45 | 138.45 | 138.45 | 2000.0 |
| 2006-11-27 19:30:00 | SPY | ETF | 138.47 | 138.47 | 138.44 | 138.44 | 1300.0 |
| 2006-11-27 09:30:00 | QQQ | ETF | 44.52 | 44.61 | 44.36 | 44.36 | 15864000.0 |
| 2006-11-27 10:00:00 | QQQ | ETF | 44.37 | 44.38 | 44.18 | 44.22 | 16614400.0 |
| 2006-11-27 10:30:00 | QQQ | ETF | 44.21 | 44.25 | 44.07 | 44.17 | 14970200.0 |
| 2006-11-27 11:00:00 | QQQ | ETF | 44.17 | 44.18 | 43.82 | 43.85 | 16281900.0 |
| 2006-11-27 11:30:00 | QQQ | ETF | 43.85 | 43.99 | 43.84 | 43.87 | 10268200.0 |
| 2006-11-27 12:00:00 | QQQ | ETF | 43.87 | 43.93 | 43.82 | 43.88 | 4049900.0 |
| 2006-11-27 12:30:00 | QQQ | ETF | 43.88 | 43.88 | 43.7 | 43.7 | 12742500.0 |
| 2006-11-27 13:00:00 | QQQ | ETF | 43.7 | 43.83 | 43.65 | 43.83 | 7811500.0 |
| 2006-11-27 13:30:00 | QQQ | ETF | 43.83 | 43.84 | 43.72 | 43.77 | 4924000.0 |
| 2006-11-27 14:00:00 | QQQ | ETF | 43.77 | 43.97 | 43.65 | 43.75 | 6609700.0 |
| 2006-11-27 14:30:00 | QQQ | ETF | 43.74 | 43.85 | 42.77 | 43.73 | 12072400.0 |
| 2006-11-27 15:00:00 | QQQ | ETF | 43.73 | 43.77 | 43.65 | 43.69 | 5863300.0 |
| 2006-11-27 15:30:00 | QQQ | ETF | 43.7 | 43.75 | 43.66 | 43.66 | 12925000.0 |
| 2006-11-27 07:30:00 | IWM | ETF | 78.4 | 78.4 | 78.4 | 78.4 | 100.0 |
| 2006-11-27 08:00:00 | IWM | ETF | 78.43 | 78.5 | 78.43 | 78.47 | 5500.0 |
| 2006-11-27 08:30:00 | IWM | ETF | 78.44 | 78.47 | 78.4 | 78.4 | 12200.0 |
| 2006-11-27 09:00:00 | IWM | ETF | 78.45 | 78.54 | 78.45 | 78.51 | 71900.0 |
| 2006-11-27 09:30:00 | IWM | ETF | 78.51 | 78.54 | 77.94 | 77.96 | 7255500.0 |
| 2006-11-27 10:00:00 | IWM | ETF | 77.96 | 77.97 | 77.38 | 77.45 | 10158000.0 |
| 2006-11-27 10:30:00 | IWM | ETF | 77.45 | 77.62 | 77.36 | 77.61 | 4857800.0 |
| 2006-11-27 11:00:00 | IWM | ETF | 77.61 | 77.63 | 77.11 | 77.16 | 6824700.0 |
| 2006-11-27 11:30:00 | IWM | ETF | 77.16 | 77.36 | 77.16 | 77.2 | 3737900.0 |
| 2006-11-27 12:00:00 | IWM | ETF | 77.2 | 77.32 | 77.16 | 77.18 | 2881100.0 |
> showing 50 of 3,203 rows — these rows as CSV