PREVIEW / etf_30min / 2005-11-29
file: by_date/etf_30min/2005/2005-11-29.parquet size: 53 KB rows: 1,863
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-11-29 06:00:00 | SPY | ETF | 126.52 | 126.53 | 126.52 | 126.53 | 35000.0 |
| 2005-11-29 06:30:00 | SPY | ETF | 126.53 | 126.53 | 126.53 | 126.53 | 15000.0 |
| 2005-11-29 07:00:00 | SPY | ETF | 126.48 | 126.55 | 126.48 | 126.53 | 14100.0 |
| 2005-11-29 07:30:00 | SPY | ETF | 126.53 | 126.63 | 126.53 | 126.63 | 229900.0 |
| 2005-11-29 08:00:00 | SPY | ETF | 126.62 | 126.75 | 126.48 | 126.71 | 877800.0 |
| 2005-11-29 08:30:00 | SPY | ETF | 126.71 | 126.74 | 126.37 | 126.65 | 280200.0 |
| 2005-11-29 09:00:00 | SPY | ETF | 126.65 | 126.68 | 126.06 | 126.64 | 313900.0 |
| 2005-11-29 09:30:00 | SPY | ETF | 126.65 | 126.81 | 126.58 | 126.77 | 5286300.0 |
| 2005-11-29 10:00:00 | SPY | ETF | 126.78 | 126.98 | 126.62 | 126.72 | 6845900.0 |
| 2005-11-29 10:30:00 | SPY | ETF | 126.74 | 126.79 | 126.45 | 126.54 | 4994900.0 |
| 2005-11-29 11:00:00 | SPY | ETF | 126.53 | 126.67 | 126.41 | 126.59 | 3177100.0 |
| 2005-11-29 11:30:00 | SPY | ETF | 126.58 | 126.72 | 126.58 | 126.7 | 2345900.0 |
| 2005-11-29 12:00:00 | SPY | ETF | 126.68 | 126.72 | 126.5 | 126.51 | 1759400.0 |
| 2005-11-29 12:30:00 | SPY | ETF | 126.53 | 126.63 | 126.42 | 126.43 | 1874100.0 |
| 2005-11-29 13:00:00 | SPY | ETF | 126.43 | 126.75 | 126.32 | 126.36 | 1612600.0 |
| 2005-11-29 13:30:00 | SPY | ETF | 126.34 | 126.36 | 126.14 | 126.32 | 5513600.0 |
| 2005-11-29 14:00:00 | SPY | ETF | 126.32 | 126.43 | 126.13 | 126.14 | 4642300.0 |
| 2005-11-29 14:30:00 | SPY | ETF | 126.14 | 126.61 | 126.11 | 126.48 | 3318100.0 |
| 2005-11-29 15:00:00 | SPY | ETF | 126.47 | 126.5 | 126.25 | 126.41 | 1816300.0 |
| 2005-11-29 15:30:00 | SPY | ETF | 126.37 | 126.39 | 126.09 | 126.12 | 3797400.0 |
| 2005-11-29 16:00:00 | SPY | ETF | 126.09 | 126.21 | 126.07 | 126.12 | 871000.0 |
| 2005-11-29 16:30:00 | SPY | ETF | 126.12 | 126.2 | 126.09 | 126.2 | 1011500.0 |
| 2005-11-29 17:00:00 | SPY | ETF | 126.19 | 126.2 | 126.19 | 126.19 | 125400.0 |
| 2005-11-29 17:30:00 | SPY | ETF | 126.18 | 126.18 | 126.11 | 126.11 | 500.0 |
| 2005-11-29 18:00:00 | SPY | ETF | 126.15 | 126.15 | 126.12 | 126.15 | 10400.0 |
| 2005-11-29 18:30:00 | SPY | ETF | 126.16 | 126.16 | 126.16 | 126.16 | 200.0 |
| 2005-11-29 19:00:00 | SPY | ETF | 126.19 | 126.22 | 126.19 | 126.22 | 2100.0 |
| 2005-11-29 19:30:00 | SPY | ETF | 126.24 | 126.24 | 126.22 | 126.22 | 2500.0 |
| 2005-11-29 09:30:00 | QQQ | ETF | 41.76 | 41.77 | 41.66 | 41.75 | 8093000.0 |
| 2005-11-29 10:00:00 | QQQ | ETF | 41.74 | 41.85 | 41.64 | 41.68 | 13852300.0 |
| 2005-11-29 10:30:00 | QQQ | ETF | 41.68 | 41.69 | 41.53 | 41.57 | 6850700.0 |
| 2005-11-29 11:00:00 | QQQ | ETF | 41.58 | 41.65 | 41.53 | 41.63 | 4908500.0 |
| 2005-11-29 11:30:00 | QQQ | ETF | 41.63 | 41.79 | 41.62 | 41.67 | 5472200.0 |
| 2005-11-29 12:00:00 | QQQ | ETF | 41.67 | 41.69 | 41.57 | 41.58 | 1766700.0 |
| 2005-11-29 12:30:00 | QQQ | ETF | 41.58 | 41.63 | 41.52 | 41.52 | 1833700.0 |
| 2005-11-29 13:00:00 | QQQ | ETF | 41.52 | 41.58 | 41.44 | 41.45 | 4645000.0 |
| 2005-11-29 13:30:00 | QQQ | ETF | 41.46 | 41.46 | 41.34 | 41.45 | 5930800.0 |
| 2005-11-29 14:00:00 | QQQ | ETF | 41.45 | 41.49 | 41.36 | 41.36 | 4288800.0 |
| 2005-11-29 14:30:00 | QQQ | ETF | 41.37 | 41.54 | 41.36 | 41.49 | 4574300.0 |
| 2005-11-29 15:00:00 | QQQ | ETF | 41.48 | 41.5 | 41.41 | 41.48 | 2485600.0 |
| 2005-11-29 15:30:00 | QQQ | ETF | 41.47 | 41.49 | 41.34 | 41.35 | 6879300.0 |
| 2005-11-29 08:00:00 | IWM | ETF | 67.09 | 67.22 | 67.03 | 67.22 | 296100.0 |
| 2005-11-29 08:30:00 | IWM | ETF | 67.2 | 67.23 | 67.17 | 67.19 | 29000.0 |
| 2005-11-29 09:00:00 | IWM | ETF | 67.17 | 67.17 | 67.14 | 67.16 | 31500.0 |
| 2005-11-29 09:30:00 | IWM | ETF | 67.1 | 67.32 | 67.06 | 67.31 | 2752800.0 |
| 2005-11-29 10:00:00 | IWM | ETF | 67.29 | 67.57 | 67.23 | 67.32 | 2346900.0 |
| 2005-11-29 10:30:00 | IWM | ETF | 67.32 | 67.35 | 67.05 | 67.1 | 2034300.0 |
| 2005-11-29 11:00:00 | IWM | ETF | 67.1 | 67.25 | 67.03 | 67.22 | 1289800.0 |
| 2005-11-29 11:30:00 | IWM | ETF | 67.23 | 67.37 | 67.21 | 67.33 | 1271100.0 |
| 2005-11-29 12:00:00 | IWM | ETF | 67.33 | 67.37 | 67.17 | 67.2 | 1503100.0 |
> showing 50 of 1,863 rows — these rows as CSV