PREVIEW / etf_30min / 2006-06-23
file: by_date/etf_30min/2006/2006-06-23.parquet size: 68 KB rows: 2,400
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-06-23 07:00:00 | SPY | ETF | 124.55 | 124.7 | 124.55 | 124.69 | 57300.0 |
| 2006-06-23 07:30:00 | SPY | ETF | 124.69 | 124.69 | 124.51 | 124.51 | 71100.0 |
| 2006-06-23 08:00:00 | SPY | ETF | 124.54 | 124.7 | 124.38 | 124.39 | 1425200.0 |
| 2006-06-23 08:30:00 | SPY | ETF | 124.41 | 124.66 | 124.24 | 124.32 | 924700.0 |
| 2006-06-23 09:00:00 | SPY | ETF | 124.31 | 124.35 | 124.2 | 124.32 | 758900.0 |
| 2006-06-23 09:30:00 | SPY | ETF | 124.33 | 124.45 | 124.03 | 124.3425 | 6264700.0 |
| 2006-06-23 10:00:00 | SPY | ETF | 124.34 | 124.71 | 124.25 | 124.55 | 5517300.0 |
| 2006-06-23 10:30:00 | SPY | ETF | 124.55 | 124.74 | 124.35 | 124.65 | 3562600.0 |
| 2006-06-23 11:00:00 | SPY | ETF | 124.65 | 124.7 | 124.33 | 124.47 | 3411600.0 |
| 2006-06-23 11:30:00 | SPY | ETF | 124.49 | 124.5 | 124.26 | 124.4 | 1867300.0 |
| 2006-06-23 12:00:00 | SPY | ETF | 124.4 | 125.3 | 124.36 | 125.08 | 8201600.0 |
| 2006-06-23 12:30:00 | SPY | ETF | 125.08 | 125.21 | 124.82 | 124.9 | 3687600.0 |
| 2006-06-23 13:00:00 | SPY | ETF | 124.9 | 125.08 | 124.85 | 124.94 | 1540100.0 |
| 2006-06-23 13:30:00 | SPY | ETF | 124.95 | 125.2 | 124.9 | 124.98 | 2777700.0 |
| 2006-06-23 14:00:00 | SPY | ETF | 124.97 | 124.97 | 124.75 | 124.86 | 1650200.0 |
| 2006-06-23 14:30:00 | SPY | ETF | 124.87 | 125.0 | 124.5 | 124.53 | 3719800.0 |
| 2006-06-23 15:00:00 | SPY | ETF | 124.53 | 124.68 | 124.35 | 124.54 | 3380500.0 |
| 2006-06-23 15:30:00 | SPY | ETF | 124.54 | 124.7 | 124.38 | 124.4 | 3649500.0 |
| 2006-06-23 16:00:00 | SPY | ETF | 124.38 | 124.46 | 124.34 | 124.37 | 609600.0 |
| 2006-06-23 16:30:00 | SPY | ETF | 124.43 | 124.43 | 124.27 | 124.27 | 47200.0 |
| 2006-06-23 17:00:00 | SPY | ETF | 124.31 | 124.37 | 124.31 | 124.37 | 1400.0 |
| 2006-06-23 17:30:00 | SPY | ETF | 124.3 | 124.36 | 124.3 | 124.34 | 3400.0 |
| 2006-06-23 18:00:00 | SPY | ETF | 124.34 | 124.4 | 124.34 | 124.4 | 1100.0 |
| 2006-06-23 09:30:00 | QQQ | ETF | 38.16 | 38.61 | 37.93 | 38.09 | 13938100.0 |
| 2006-06-23 10:00:00 | QQQ | ETF | 38.09 | 38.2 | 37.97 | 38.12 | 9679300.0 |
| 2006-06-23 10:30:00 | QQQ | ETF | 38.12 | 38.19 | 38.08 | 38.18 | 6504000.0 |
| 2006-06-23 11:00:00 | QQQ | ETF | 38.18 | 38.21 | 38.07 | 38.14 | 4227800.0 |
| 2006-06-23 11:30:00 | QQQ | ETF | 38.14 | 38.18 | 38.06 | 38.12 | 4278400.0 |
| 2006-06-23 12:00:00 | QQQ | ETF | 38.11 | 38.53 | 38.1 | 38.48 | 9744600.0 |
| 2006-06-23 12:30:00 | QQQ | ETF | 38.47 | 38.5 | 38.36 | 38.42 | 5106200.0 |
| 2006-06-23 13:00:00 | QQQ | ETF | 38.41 | 38.47 | 38.38 | 38.4 | 2261900.0 |
| 2006-06-23 13:30:00 | QQQ | ETF | 38.4 | 38.5 | 38.39 | 38.44 | 2654500.0 |
| 2006-06-23 14:00:00 | QQQ | ETF | 38.44 | 38.44 | 38.31 | 38.36 | 3474200.0 |
| 2006-06-23 14:30:00 | QQQ | ETF | 38.36 | 38.4 | 38.19 | 38.2 | 5518700.0 |
| 2006-06-23 15:00:00 | QQQ | ETF | 38.19 | 38.27 | 38.13 | 38.23 | 7496300.0 |
| 2006-06-23 15:30:00 | QQQ | ETF | 38.23 | 38.4 | 38.15 | 38.15 | 6114100.0 |
| 2006-06-23 08:00:00 | IWM | ETF | 68.34 | 68.45 | 68.21 | 68.22 | 157600.0 |
| 2006-06-23 08:30:00 | IWM | ETF | 68.17 | 68.29 | 68.12 | 68.17 | 149000.0 |
| 2006-06-23 09:00:00 | IWM | ETF | 68.13 | 68.22 | 68.04 | 68.22 | 180900.0 |
| 2006-06-23 09:30:00 | IWM | ETF | 68.23 | 68.25 | 67.72 | 68.12 | 6551700.0 |
| 2006-06-23 10:00:00 | IWM | ETF | 68.11 | 68.44 | 67.99 | 68.41 | 6035700.0 |
| 2006-06-23 10:30:00 | IWM | ETF | 68.38 | 68.58 | 68.32 | 68.49 | 5246600.0 |
| 2006-06-23 11:00:00 | IWM | ETF | 68.49 | 68.54 | 68.26 | 68.43 | 2352900.0 |
| 2006-06-23 11:30:00 | IWM | ETF | 68.43 | 68.44 | 68.27 | 68.32 | 1930800.0 |
| 2006-06-23 12:00:00 | IWM | ETF | 68.34 | 69.05 | 68.31 | 68.97 | 2884300.0 |
| 2006-06-23 12:30:00 | IWM | ETF | 68.97 | 69.05 | 68.81 | 68.86 | 2787000.0 |
| 2006-06-23 13:00:00 | IWM | ETF | 68.84 | 68.97 | 68.81 | 68.87 | 1406700.0 |
| 2006-06-23 13:30:00 | IWM | ETF | 68.87 | 68.99 | 68.77 | 68.83 | 1714500.0 |
| 2006-06-23 14:00:00 | IWM | ETF | 68.83 | 68.84 | 68.64 | 68.73 | 1702700.0 |
| 2006-06-23 14:30:00 | IWM | ETF | 68.73 | 68.86 | 68.4712 | 68.5 | 1878400.0 |
> showing 50 of 2,400 rows — these rows as CSV