PREVIEW / etf_30min / 2006-10-24
file: by_date/etf_30min/2006/2006-10-24.parquet size: 82 KB rows: 2,969
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-24 06:00:00 | SPY | ETF | 137.32 | 137.35 | 137.3 | 137.35 | 15000.0 |
| 2006-10-24 06:30:00 | SPY | ETF | 137.35 | 137.35 | 137.35 | 137.35 | 5000.0 |
| 2006-10-24 07:00:00 | SPY | ETF | 137.25 | 137.32 | 137.25 | 137.28 | 30800.0 |
| 2006-10-24 07:30:00 | SPY | ETF | 137.34 | 137.35 | 137.3 | 137.35 | 55500.0 |
| 2006-10-24 08:00:00 | SPY | ETF | 137.18 | 137.35 | 137.18 | 137.29 | 101800.0 |
| 2006-10-24 08:30:00 | SPY | ETF | 137.28 | 137.35 | 137.26 | 137.35 | 303700.0 |
| 2006-10-24 09:00:00 | SPY | ETF | 137.35 | 137.42 | 137.3 | 137.3 | 329600.0 |
| 2006-10-24 09:30:00 | SPY | ETF | 137.28 | 137.68 | 137.22 | 137.55 | 7838700.0 |
| 2006-10-24 10:00:00 | SPY | ETF | 137.53 | 137.55 | 137.3 | 137.53 | 4680500.0 |
| 2006-10-24 10:30:00 | SPY | ETF | 137.53 | 137.53 | 137.31 | 137.52 | 4110500.0 |
| 2006-10-24 11:00:00 | SPY | ETF | 137.52 | 137.62 | 137.44 | 137.592 | 3059400.0 |
| 2006-10-24 11:30:00 | SPY | ETF | 137.6 | 137.67 | 137.52 | 137.6 | 1706000.0 |
| 2006-10-24 12:00:00 | SPY | ETF | 137.59 | 137.65 | 137.51 | 137.54 | 2168500.0 |
| 2006-10-24 12:30:00 | SPY | ETF | 137.53 | 137.56 | 137.26 | 137.3 | 3231300.0 |
| 2006-10-24 13:00:00 | SPY | ETF | 137.3 | 137.63 | 137.29 | 137.42 | 4700100.0 |
| 2006-10-24 13:30:00 | SPY | ETF | 137.43 | 137.58 | 137.31 | 137.38 | 2913300.0 |
| 2006-10-24 14:00:00 | SPY | ETF | 137.38 | 137.64 | 137.34 | 137.59 | 4069600.0 |
| 2006-10-24 14:30:00 | SPY | ETF | 137.59 | 137.6 | 137.44 | 137.54 | 1615400.0 |
| 2006-10-24 15:00:00 | SPY | ETF | 137.54 | 137.75 | 137.53 | 137.59 | 3044000.0 |
| 2006-10-24 15:30:00 | SPY | ETF | 137.59 | 137.83 | 137.57 | 137.79 | 4554100.0 |
| 2006-10-24 16:00:00 | SPY | ETF | 137.79 | 137.94 | 137.5 | 137.85 | 1742900.0 |
| 2006-10-24 16:30:00 | SPY | ETF | 137.84 | 137.86 | 137.7 | 137.74 | 644900.0 |
| 2006-10-24 17:00:00 | SPY | ETF | 137.74 | 137.78 | 137.73 | 137.76 | 63100.0 |
| 2006-10-24 17:30:00 | SPY | ETF | 137.79 | 137.79 | 137.79 | 137.79 | 800.0 |
| 2006-10-24 18:00:00 | SPY | ETF | 137.77 | 137.81 | 137.76 | 137.81 | 120500.0 |
| 2006-10-24 18:30:00 | SPY | ETF | 137.79 | 137.79 | 137.79 | 137.79 | 800.0 |
| 2006-10-24 19:30:00 | SPY | ETF | 137.78 | 137.78 | 137.77 | 137.77 | 1100.0 |
| 2006-10-24 09:30:00 | QQQ | ETF | 42.29 | 42.45 | 42.25 | 42.32 | 10767900.0 |
| 2006-10-24 10:00:00 | QQQ | ETF | 42.32 | 42.36 | 42.18 | 42.28 | 8864300.0 |
| 2006-10-24 10:30:00 | QQQ | ETF | 42.27 | 42.28 | 42.1 | 42.18 | 10458600.0 |
| 2006-10-24 11:00:00 | QQQ | ETF | 42.19 | 42.22 | 42.14 | 42.22 | 4504500.0 |
| 2006-10-24 11:30:00 | QQQ | ETF | 42.22 | 42.26 | 42.16 | 42.19 | 4827200.0 |
| 2006-10-24 12:00:00 | QQQ | ETF | 42.19 | 42.21 | 42.13 | 42.14 | 2159900.0 |
| 2006-10-24 12:30:00 | QQQ | ETF | 42.15 | 42.15 | 41.92 | 41.95 | 7555700.0 |
| 2006-10-24 13:00:00 | QQQ | ETF | 41.95 | 42.04 | 41.94 | 42.03 | 4038200.0 |
| 2006-10-24 13:30:00 | QQQ | ETF | 42.04 | 42.13 | 42.01 | 42.05 | 5243900.0 |
| 2006-10-24 14:00:00 | QQQ | ETF | 42.06 | 42.18 | 42.03 | 42.16 | 5249700.0 |
| 2006-10-24 14:30:00 | QQQ | ETF | 42.16 | 42.17 | 42.08 | 42.11 | 2618100.0 |
| 2006-10-24 15:00:00 | QQQ | ETF | 42.12 | 42.17 | 42.08 | 42.12 | 3780500.0 |
| 2006-10-24 15:30:00 | QQQ | ETF | 42.12 | 42.22 | 42.1 | 42.12 | 6658000.0 |
| 2006-10-24 07:00:00 | IWM | ETF | 75.48 | 75.48 | 75.48 | 75.48 | 200.0 |
| 2006-10-24 08:00:00 | IWM | ETF | 75.65 | 75.65 | 75.6 | 75.6 | 300.0 |
| 2006-10-24 08:30:00 | IWM | ETF | 75.58 | 75.65 | 75.57 | 75.64 | 7100.0 |
| 2006-10-24 09:00:00 | IWM | ETF | 75.65 | 75.65 | 75.58 | 75.58 | 18400.0 |
| 2006-10-24 09:30:00 | IWM | ETF | 75.51 | 75.95 | 75.43 | 75.76 | 2988800.0 |
| 2006-10-24 10:00:00 | IWM | ETF | 75.74 | 75.82 | 75.56 | 75.77 | 3466100.0 |
| 2006-10-24 10:30:00 | IWM | ETF | 75.77 | 75.77 | 75.47 | 75.65 | 2525000.0 |
| 2006-10-24 11:00:00 | IWM | ETF | 75.65 | 75.75 | 75.59 | 75.74 | 2781600.0 |
| 2006-10-24 11:30:00 | IWM | ETF | 75.75 | 75.8 | 75.64 | 75.76 | 1135700.0 |
| 2006-10-24 12:00:00 | IWM | ETF | 75.77 | 75.78 | 75.6 | 75.61 | 933000.0 |
> showing 50 of 2,969 rows — these rows as CSV