PREVIEW / etf_30min / 2005-11-30
file: by_date/etf_30min/2005/2005-11-30.parquet size: 57 KB rows: 2,032
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-30 06:30:00 | SPY | ETF | 126.11 | 126.11 | 126.06 | 126.06 | 25500.0 |
| 2005-11-30 07:00:00 | SPY | ETF | 126.05 | 126.1 | 126.03 | 126.03 | 1100.0 |
| 2005-11-30 07:30:00 | SPY | ETF | 126.02 | 126.04 | 126.02 | 126.03 | 3600.0 |
| 2005-11-30 08:00:00 | SPY | ETF | 126.02 | 126.18 | 126.0 | 126.13 | 151700.0 |
| 2005-11-30 08:30:00 | SPY | ETF | 126.14 | 126.27 | 126.08 | 126.17 | 433400.0 |
| 2005-11-30 09:00:00 | SPY | ETF | 126.17 | 126.2 | 126.15 | 126.17 | 76300.0 |
| 2005-11-30 09:30:00 | SPY | ETF | 126.16 | 126.44 | 126.09 | 126.32 | 4934000.0 |
| 2005-11-30 10:00:00 | SPY | ETF | 126.32 | 126.52 | 126.0 | 126.36 | 6380700.0 |
| 2005-11-30 10:30:00 | SPY | ETF | 126.36 | 126.44 | 126.14 | 126.29 | 3853400.0 |
| 2005-11-30 11:00:00 | SPY | ETF | 126.29 | 126.39 | 126.19 | 126.3 | 1644500.0 |
| 2005-11-30 11:30:00 | SPY | ETF | 126.29 | 126.32 | 125.89 | 126.01 | 2934700.0 |
| 2005-11-30 12:00:00 | SPY | ETF | 126.0 | 126.07 | 125.82 | 125.91 | 1817900.0 |
| 2005-11-30 12:30:00 | SPY | ETF | 125.91 | 126.08 | 125.87 | 126.04 | 1954600.0 |
| 2005-11-30 13:00:00 | SPY | ETF | 126.03 | 126.15 | 125.89 | 125.93 | 1940500.0 |
| 2005-11-30 13:30:00 | SPY | ETF | 125.93 | 125.99 | 125.65 | 125.69 | 2594500.0 |
| 2005-11-30 14:00:00 | SPY | ETF | 125.69 | 126.04 | 125.65 | 125.84 | 3623400.0 |
| 2005-11-30 14:30:00 | SPY | ETF | 125.83 | 125.93 | 125.62 | 125.79 | 3539900.0 |
| 2005-11-30 15:00:00 | SPY | ETF | 125.78 | 125.9 | 125.59 | 125.66 | 3552700.0 |
| 2005-11-30 15:30:00 | SPY | ETF | 125.67 | 125.78 | 125.29 | 125.33 | 7260500.0 |
| 2005-11-30 16:00:00 | SPY | ETF | 125.33 | 125.49 | 125.28 | 125.46 | 2041000.0 |
| 2005-11-30 16:30:00 | SPY | ETF | 125.46 | 125.49 | 125.3 | 125.4 | 642800.0 |
| 2005-11-30 17:00:00 | SPY | ETF | 125.43 | 126.138 | 125.4 | 125.49 | 852500.0 |
| 2005-11-30 17:30:00 | SPY | ETF | 125.45 | 125.5 | 125.45 | 125.5 | 900.0 |
| 2005-11-30 18:00:00 | SPY | ETF | 125.48 | 126.1383 | 125.48 | 125.55 | 3969500.0 |
| 2005-11-30 18:30:00 | SPY | ETF | 125.58 | 125.58 | 125.58 | 125.58 | 600.0 |
| 2005-11-30 19:00:00 | SPY | ETF | 125.58 | 125.63 | 125.58 | 125.61 | 2900.0 |
| 2005-11-30 09:30:00 | QQQ | ETF | 41.29 | 41.46 | 41.28 | 41.38 | 12079200.0 |
| 2005-11-30 10:00:00 | QQQ | ETF | 41.38 | 41.49 | 41.26 | 41.42 | 11446000.0 |
| 2005-11-30 10:30:00 | QQQ | ETF | 41.42 | 41.47 | 41.31 | 41.4 | 6428400.0 |
| 2005-11-30 11:00:00 | QQQ | ETF | 41.41 | 41.43 | 41.34 | 41.4 | 4195300.0 |
| 2005-11-30 11:30:00 | QQQ | ETF | 41.4 | 41.43 | 41.24 | 41.32 | 6703400.0 |
| 2005-11-30 12:00:00 | QQQ | ETF | 41.32 | 41.38 | 41.28 | 41.34 | 4035200.0 |
| 2005-11-30 12:30:00 | QQQ | ETF | 41.34 | 41.44 | 41.32 | 41.42 | 3386000.0 |
| 2005-11-30 13:00:00 | QQQ | ETF | 41.41 | 41.48 | 41.39 | 41.41 | 4017600.0 |
| 2005-11-30 13:30:00 | QQQ | ETF | 41.41 | 41.42 | 41.23 | 41.25 | 7346600.0 |
| 2005-11-30 14:00:00 | QQQ | ETF | 41.24 | 41.36 | 41.23 | 41.3 | 4345100.0 |
| 2005-11-30 14:30:00 | QQQ | ETF | 41.3 | 41.33 | 41.22 | 41.32 | 4303700.0 |
| 2005-11-30 15:00:00 | QQQ | ETF | 41.32 | 41.34 | 41.27 | 41.31 | 3657400.0 |
| 2005-11-30 15:30:00 | QQQ | ETF | 41.31 | 41.32 | 41.19 | 41.24 | 7803700.0 |
| 2005-11-30 08:00:00 | IWM | ETF | 67.18 | 67.18 | 67.18 | 67.18 | 600.0 |
| 2005-11-30 08:30:00 | IWM | ETF | 67.15 | 67.15 | 67.15 | 67.15 | 1000.0 |
| 2005-11-30 09:00:00 | IWM | ETF | 67.12 | 67.16 | 67.09 | 67.11 | 32100.0 |
| 2005-11-30 09:30:00 | IWM | ETF | 67.13 | 67.49 | 67.08 | 67.37 | 4441800.0 |
| 2005-11-30 10:00:00 | IWM | ETF | 67.37 | 67.52 | 67.07 | 67.43 | 3394500.0 |
| 2005-11-30 10:30:00 | IWM | ETF | 67.42 | 67.7 | 67.4 | 67.67 | 2292800.0 |
| 2005-11-30 11:00:00 | IWM | ETF | 67.6792 | 67.75 | 67.57 | 67.75 | 1040100.0 |
| 2005-11-30 11:30:00 | IWM | ETF | 67.75 | 67.78 | 67.35 | 67.44 | 4645800.0 |
| 2005-11-30 12:00:00 | IWM | ETF | 67.43 | 67.53 | 67.31 | 67.36 | 1385100.0 |
| 2005-11-30 12:30:00 | IWM | ETF | 67.37 | 67.63 | 67.35 | 67.56 | 925500.0 |
| 2005-11-30 13:00:00 | IWM | ETF | 67.56 | 67.67 | 67.52 | 67.55 | 1249900.0 |
> showing 50 of 2,032 rows — these rows as CSV