PREVIEW / etf_30min / 2001-10-30
file: by_date/etf_30min/2001/2001-10-30.parquet size: 16 KB rows: 413
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 |
|---|---|---|---|---|---|---|---|
| 2001-10-30 09:30:00 | SPY | ETF | 107.35 | 107.35 | 106.7 | 106.78 | 3728900.0 |
| 2001-10-30 10:00:00 | SPY | ETF | 106.8 | 106.8 | 105.9 | 106.15 | 4518900.0 |
| 2001-10-30 10:30:00 | SPY | ETF | 106.16 | 106.16 | 105.56 | 106.0 | 1500400.0 |
| 2001-10-30 11:00:00 | SPY | ETF | 106.0 | 106.55 | 105.96 | 106.4 | 2364600.0 |
| 2001-10-30 11:30:00 | SPY | ETF | 106.45 | 106.75 | 106.23 | 106.65 | 2351400.0 |
| 2001-10-30 12:00:00 | SPY | ETF | 106.64 | 106.73 | 106.3 | 106.53 | 712100.0 |
| 2001-10-30 12:30:00 | SPY | ETF | 106.55 | 106.62 | 106.32 | 106.5 | 601000.0 |
| 2001-10-30 13:00:00 | SPY | ETF | 106.51 | 106.68 | 106.32 | 106.46 | 496600.0 |
| 2001-10-30 13:30:00 | SPY | ETF | 106.55 | 107.2 | 106.52 | 107.04 | 2439400.0 |
| 2001-10-30 14:00:00 | SPY | ETF | 107.1 | 107.13 | 106.63 | 106.63 | 925600.0 |
| 2001-10-30 14:30:00 | SPY | ETF | 106.64 | 106.8 | 106.39 | 106.62 | 1030700.0 |
| 2001-10-30 15:00:00 | SPY | ETF | 106.56 | 106.78 | 106.26 | 106.37 | 1263900.0 |
| 2001-10-30 15:30:00 | SPY | ETF | 106.31 | 106.5 | 106.0 | 106.2 | 2403900.0 |
| 2001-10-30 16:00:00 | SPY | ETF | 106.2 | 106.26 | 106.12 | 106.16 | 1008200.0 |
| 2001-10-30 16:30:00 | SPY | ETF | 106.23 | 106.23 | 106.08 | 106.11 | 19200.0 |
| 2001-10-30 17:00:00 | SPY | ETF | 106.2 | 106.21 | 105.94 | 105.95 | 1500.0 |
| 2001-10-30 17:30:00 | SPY | ETF | 106.0 | 106.0 | 106.0 | 106.0 | 100.0 |
| 2001-10-30 18:00:00 | SPY | ETF | 105.96 | 105.96 | 105.9 | 105.91 | 6500.0 |
| 2001-10-30 09:30:00 | QQQ | ETF | 33.71 | 33.85 | 33.45 | 33.55 | 12224500.0 |
| 2001-10-30 10:00:00 | QQQ | ETF | 33.54 | 33.55 | 33.01 | 33.18 | 16080100.0 |
| 2001-10-30 10:30:00 | QQQ | ETF | 33.18 | 33.24 | 32.84 | 33.22 | 7951300.0 |
| 2001-10-30 11:00:00 | QQQ | ETF | 33.22 | 33.64 | 33.13 | 33.55 | 6927600.0 |
| 2001-10-30 11:30:00 | QQQ | ETF | 33.57 | 33.77 | 33.36 | 33.66 | 5506100.0 |
| 2001-10-30 12:00:00 | QQQ | ETF | 33.68 | 33.72 | 33.36 | 33.5 | 4230800.0 |
| 2001-10-30 12:30:00 | QQQ | ETF | 33.52 | 33.59 | 33.27 | 33.47 | 2644300.0 |
| 2001-10-30 13:00:00 | QQQ | ETF | 33.47 | 33.64 | 33.3 | 33.45 | 3735600.0 |
| 2001-10-30 13:30:00 | QQQ | ETF | 33.45 | 34.09 | 33.44 | 34.01 | 8225100.0 |
| 2001-10-30 14:00:00 | QQQ | ETF | 34.02 | 34.05 | 33.66 | 33.69 | 5511100.0 |
| 2001-10-30 14:30:00 | QQQ | ETF | 33.71 | 33.89 | 33.48 | 33.66 | 4120300.0 |
| 2001-10-30 15:00:00 | QQQ | ETF | 33.66 | 33.85 | 33.38 | 33.45 | 5084500.0 |
| 2001-10-30 15:30:00 | QQQ | ETF | 33.45 | 33.56 | 33.23 | 33.4 | 7715000.0 |
| 2001-10-30 16:00:00 | QQQ | ETF | 33.42 | 33.45 | 33.3 | 33.38 | 5229900.0 |
| 2001-10-30 16:30:00 | QQQ | ETF | 33.33 | 33.36 | 33.19 | 33.22 | 222600.0 |
| 2001-10-30 17:00:00 | QQQ | ETF | 33.25 | 33.35 | 33.22 | 33.25 | 92000.0 |
| 2001-10-30 17:30:00 | QQQ | ETF | 33.24 | 33.38 | 33.22 | 33.29 | 38200.0 |
| 2001-10-30 18:00:00 | QQQ | ETF | 33.3 | 33.3 | 33.23 | 33.27 | 25700.0 |
| 2001-10-30 09:30:00 | IWM | ETF | 42.4 | 42.4 | 42.185 | 42.225 | 130200.0 |
| 2001-10-30 10:00:00 | IWM | ETF | 42.21 | 42.21 | 41.875 | 41.95 | 523200.0 |
| 2001-10-30 10:30:00 | IWM | ETF | 41.975 | 41.975 | 41.675 | 41.865 | 10600.0 |
| 2001-10-30 11:00:00 | IWM | ETF | 41.865 | 42.035 | 41.855 | 42.035 | 77400.0 |
| 2001-10-30 11:30:00 | IWM | ETF | 42.015 | 42.05 | 41.99 | 42.05 | 5000.0 |
| 2001-10-30 12:00:00 | IWM | ETF | 42.095 | 42.13 | 42.08 | 42.13 | 7000.0 |
| 2001-10-30 12:30:00 | IWM | ETF | 42.13 | 42.13 | 42.13 | 42.13 | 400.0 |
| 2001-10-30 13:00:00 | IWM | ETF | 42.085 | 42.1 | 42.055 | 42.1 | 18800.0 |
| 2001-10-30 13:30:00 | IWM | ETF | 42.085 | 42.26 | 42.075 | 42.23 | 30000.0 |
| 2001-10-30 14:00:00 | IWM | ETF | 42.26 | 42.26 | 42.215 | 42.215 | 18200.0 |
| 2001-10-30 14:30:00 | IWM | ETF | 42.245 | 42.245 | 42.1 | 42.14 | 17000.0 |
| 2001-10-30 15:00:00 | IWM | ETF | 42.14 | 42.14 | 42.1 | 42.1 | 4600.0 |
| 2001-10-30 15:30:00 | IWM | ETF | 42.1 | 42.125 | 41.935 | 42.0 | 39400.0 |
| 2001-10-30 16:00:00 | IWM | ETF | 42.06 | 42.06 | 41.85 | 41.85 | 4600.0 |
> showing 50 of 413 rows — these rows as CSV