PREVIEW / etf_30min / 2005-10-10
file: by_date/etf_30min/2005/2005-10-10.parquet size: 48 KB rows: 1,687
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 |
|---|---|---|---|---|---|---|---|
| 2005-10-10 05:30:00 | SPY | ETF | 119.88 | 119.88 | 119.88 | 119.88 | 200.0 |
| 2005-10-10 06:00:00 | SPY | ETF | 119.9 | 119.9 | 119.86 | 119.86 | 7700.0 |
| 2005-10-10 06:30:00 | SPY | ETF | 119.84 | 119.84 | 119.84 | 119.84 | 2700.0 |
| 2005-10-10 07:00:00 | SPY | ETF | 119.9 | 120.0 | 119.9 | 120.0 | 3400.0 |
| 2005-10-10 07:30:00 | SPY | ETF | 120.0 | 120.0 | 119.96 | 119.96 | 7400.0 |
| 2005-10-10 08:00:00 | SPY | ETF | 119.94 | 120.01 | 119.9 | 119.97 | 700700.0 |
| 2005-10-10 08:30:00 | SPY | ETF | 119.95 | 120.0 | 119.76 | 119.87 | 212600.0 |
| 2005-10-10 09:00:00 | SPY | ETF | 119.7 | 119.88 | 119.6 | 119.68 | 700000.0 |
| 2005-10-10 09:30:00 | SPY | ETF | 119.68 | 119.71 | 119.17 | 119.24 | 5993400.0 |
| 2005-10-10 10:00:00 | SPY | ETF | 119.24 | 119.68 | 118.85 | 119.12 | 6840400.0 |
| 2005-10-10 10:30:00 | SPY | ETF | 119.11 | 119.33 | 118.98 | 119.17 | 5561900.0 |
| 2005-10-10 11:00:00 | SPY | ETF | 119.16 | 119.43 | 119.12 | 119.29 | 3425700.0 |
| 2005-10-10 11:30:00 | SPY | ETF | 119.3 | 119.36 | 118.96 | 119.12 | 2543900.0 |
| 2005-10-10 12:00:00 | SPY | ETF | 119.11 | 119.35 | 119.11 | 119.28 | 2036400.0 |
| 2005-10-10 12:30:00 | SPY | ETF | 119.28 | 119.65 | 119.21 | 119.51 | 2764700.0 |
| 2005-10-10 13:00:00 | SPY | ETF | 119.51 | 119.6 | 119.3 | 119.37 | 1595200.0 |
| 2005-10-10 13:30:00 | SPY | ETF | 119.36 | 119.51 | 119.16 | 119.18 | 1772200.0 |
| 2005-10-10 14:00:00 | SPY | ETF | 119.2 | 119.22 | 118.72 | 118.84 | 4349300.0 |
| 2005-10-10 14:30:00 | SPY | ETF | 118.84 | 119.01 | 118.61 | 118.85 | 4624100.0 |
| 2005-10-10 15:00:00 | SPY | ETF | 118.84 | 119.68 | 118.75 | 118.84 | 3386800.0 |
| 2005-10-10 15:30:00 | SPY | ETF | 118.84 | 119.12 | 118.69 | 118.77 | 3951700.0 |
| 2005-10-10 16:00:00 | SPY | ETF | 118.75 | 118.77 | 118.57 | 118.66 | 310000.0 |
| 2005-10-10 16:30:00 | SPY | ETF | 118.62 | 118.67 | 118.61 | 118.61 | 77600.0 |
| 2005-10-10 17:00:00 | SPY | ETF | 118.62 | 118.67 | 118.62 | 118.65 | 30000.0 |
| 2005-10-10 17:30:00 | SPY | ETF | 118.68 | 118.68 | 118.68 | 118.68 | 3400.0 |
| 2005-10-10 18:00:00 | SPY | ETF | 118.66 | 118.66 | 118.65 | 118.66 | 1000.0 |
| 2005-10-10 19:00:00 | SPY | ETF | 118.65 | 118.65 | 118.64 | 118.64 | 200.0 |
| 2005-10-10 19:30:00 | SPY | ETF | 118.64 | 118.64 | 118.63 | 118.63 | 1600.0 |
| 2005-10-10 09:30:00 | QQQ | ETF | 38.29 | 38.37 | 38.19 | 38.22 | 9278300.0 |
| 2005-10-10 10:00:00 | QQQ | ETF | 38.23 | 38.25 | 38.08 | 38.17 | 8563700.0 |
| 2005-10-10 10:30:00 | QQQ | ETF | 38.18 | 38.3 | 38.06 | 38.26 | 4185400.0 |
| 2005-10-10 11:00:00 | QQQ | ETF | 38.25 | 38.36 | 38.24 | 38.27 | 4524900.0 |
| 2005-10-10 11:30:00 | QQQ | ETF | 38.27 | 38.29 | 38.18 | 38.28 | 3060800.0 |
| 2005-10-10 12:00:00 | QQQ | ETF | 38.28 | 38.34 | 38.27 | 38.31 | 2928000.0 |
| 2005-10-10 12:30:00 | QQQ | ETF | 38.31 | 38.46 | 38.28 | 38.41 | 3240400.0 |
| 2005-10-10 13:00:00 | QQQ | ETF | 38.4 | 38.4 | 38.32 | 38.35 | 1859500.0 |
| 2005-10-10 13:30:00 | QQQ | ETF | 38.35 | 38.39 | 38.24 | 38.28 | 2454000.0 |
| 2005-10-10 14:00:00 | QQQ | ETF | 38.28 | 38.29 | 38.1 | 38.15 | 5433000.0 |
| 2005-10-10 14:30:00 | QQQ | ETF | 38.16 | 38.23 | 38.08 | 38.18 | 5898100.0 |
| 2005-10-10 15:00:00 | QQQ | ETF | 38.18 | 38.22 | 38.13 | 38.14 | 2437700.0 |
| 2005-10-10 15:30:00 | QQQ | ETF | 38.13 | 38.26 | 38.11 | 38.12 | 5511100.0 |
| 2005-10-10 07:30:00 | IWM | ETF | 64.36 | 64.36 | 64.36 | 64.36 | 100.0 |
| 2005-10-10 08:00:00 | IWM | ETF | 64.33 | 64.37 | 64.33 | 64.36 | 20500.0 |
| 2005-10-10 08:30:00 | IWM | ETF | 64.37 | 64.37 | 64.35 | 64.36 | 1700.0 |
| 2005-10-10 09:00:00 | IWM | ETF | 64.28 | 64.28 | 64.24 | 64.24 | 5300.0 |
| 2005-10-10 09:30:00 | IWM | ETF | 64.245 | 64.28 | 63.67 | 63.72 | 2274300.0 |
| 2005-10-10 10:00:00 | IWM | ETF | 63.7 | 64.21 | 63.44 | 63.64 | 2769600.0 |
| 2005-10-10 10:30:00 | IWM | ETF | 63.64 | 63.74 | 63.54 | 63.65 | 826600.0 |
| 2005-10-10 11:00:00 | IWM | ETF | 63.65 | 63.86 | 63.63 | 63.79 | 1213600.0 |
| 2005-10-10 11:30:00 | IWM | ETF | 63.79 | 64.21 | 63.57 | 63.69 | 699300.0 |
> showing 50 of 1,687 rows — these rows as CSV