PREVIEW / etf_30min / 2001-12-20
file: by_date/etf_30min/2001/2001-12-20.parquet size: 18 KB rows: 482
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-12-20 09:30:00 | SPY | ETF | 115.5 | 115.73 | 115.33 | 115.72 | 2803500.0 |
| 2001-12-20 10:00:00 | SPY | ETF | 115.72 | 115.8 | 115.28 | 115.28 | 1106700.0 |
| 2001-12-20 10:30:00 | SPY | ETF | 115.28 | 115.42 | 115.08 | 115.17 | 1608400.0 |
| 2001-12-20 11:00:00 | SPY | ETF | 115.15 | 115.39 | 115.0 | 115.1 | 987900.0 |
| 2001-12-20 11:30:00 | SPY | ETF | 115.14 | 115.36 | 115.03 | 115.29 | 488500.0 |
| 2001-12-20 12:00:00 | SPY | ETF | 115.31 | 115.6 | 115.14 | 115.23 | 1065600.0 |
| 2001-12-20 12:30:00 | SPY | ETF | 115.25 | 115.28 | 115.01 | 115.12 | 623800.0 |
| 2001-12-20 13:00:00 | SPY | ETF | 115.11 | 115.25 | 115.02 | 115.03 | 407700.0 |
| 2001-12-20 13:30:00 | SPY | ETF | 115.01 | 115.39 | 114.97 | 115.02 | 478000.0 |
| 2001-12-20 14:00:00 | SPY | ETF | 115.05 | 115.26 | 114.95 | 115.11 | 1218500.0 |
| 2001-12-20 14:30:00 | SPY | ETF | 115.13 | 115.16 | 114.76 | 114.76 | 891600.0 |
| 2001-12-20 15:00:00 | SPY | ETF | 114.77 | 114.94 | 114.63 | 114.81 | 765500.0 |
| 2001-12-20 15:30:00 | SPY | ETF | 114.82 | 114.95 | 114.63 | 114.69 | 1089800.0 |
| 2001-12-20 16:00:00 | SPY | ETF | 114.69 | 114.9 | 114.55 | 114.73 | 1275000.0 |
| 2001-12-20 16:30:00 | SPY | ETF | 114.72 | 114.79 | 114.55 | 114.66 | 22500.0 |
| 2001-12-20 17:00:00 | SPY | ETF | 114.58 | 114.58 | 114.58 | 114.58 | 100.0 |
| 2001-12-20 17:30:00 | SPY | ETF | 114.55 | 114.55 | 114.54 | 114.54 | 2500.0 |
| 2001-12-20 18:00:00 | SPY | ETF | 114.74 | 114.9 | 114.74 | 114.9 | 1500.0 |
| 2001-12-20 09:30:00 | QQQ | ETF | 40.1 | 40.3 | 40.0 | 40.14 | 8557500.0 |
| 2001-12-20 10:00:00 | QQQ | ETF | 40.13 | 40.22 | 39.67 | 39.67 | 11831000.0 |
| 2001-12-20 10:30:00 | QQQ | ETF | 39.68 | 39.8 | 39.39 | 39.42 | 8582200.0 |
| 2001-12-20 11:00:00 | QQQ | ETF | 39.42 | 39.53 | 39.2 | 39.36 | 6121300.0 |
| 2001-12-20 11:30:00 | QQQ | ETF | 39.36 | 39.51 | 39.27 | 39.47 | 4510600.0 |
| 2001-12-20 12:00:00 | QQQ | ETF | 39.49 | 39.69 | 39.33 | 39.45 | 5674300.0 |
| 2001-12-20 12:30:00 | QQQ | ETF | 39.48 | 39.48 | 39.24 | 39.31 | 2535200.0 |
| 2001-12-20 13:00:00 | QQQ | ETF | 39.29 | 39.45 | 39.24 | 39.26 | 1810700.0 |
| 2001-12-20 13:30:00 | QQQ | ETF | 39.27 | 39.57 | 39.17 | 39.2 | 5766600.0 |
| 2001-12-20 14:00:00 | QQQ | ETF | 39.2 | 39.47 | 39.07 | 39.32 | 5911900.0 |
| 2001-12-20 14:30:00 | QQQ | ETF | 39.3 | 39.3 | 38.98 | 39.0 | 4542200.0 |
| 2001-12-20 15:00:00 | QQQ | ETF | 39.0 | 39.06 | 38.84 | 38.97 | 5177900.0 |
| 2001-12-20 15:30:00 | QQQ | ETF | 38.95 | 39.1 | 38.8 | 38.81 | 7500200.0 |
| 2001-12-20 16:00:00 | QQQ | ETF | 38.8 | 38.86 | 38.67 | 38.74 | 2794500.0 |
| 2001-12-20 16:30:00 | QQQ | ETF | 38.85 | 38.85 | 38.7 | 38.79 | 71800.0 |
| 2001-12-20 17:00:00 | QQQ | ETF | 38.8 | 38.82 | 38.72 | 38.79 | 32900.0 |
| 2001-12-20 17:30:00 | QQQ | ETF | 38.77 | 38.81 | 38.77 | 38.81 | 11200.0 |
| 2001-12-20 18:00:00 | QQQ | ETF | 38.81 | 38.81 | 38.7 | 38.74 | 24900.0 |
| 2001-12-20 09:30:00 | IWM | ETF | 47.9 | 47.9 | 47.65 | 47.845 | 25000.0 |
| 2001-12-20 10:00:00 | IWM | ETF | 47.835 | 47.915 | 47.505 | 47.505 | 105400.0 |
| 2001-12-20 10:30:00 | IWM | ETF | 47.5 | 47.5 | 47.25 | 47.37 | 69000.0 |
| 2001-12-20 11:00:00 | IWM | ETF | 47.35 | 47.39 | 47.3 | 47.365 | 42000.0 |
| 2001-12-20 11:30:00 | IWM | ETF | 47.355 | 47.49 | 47.34 | 47.49 | 24200.0 |
| 2001-12-20 12:00:00 | IWM | ETF | 47.485 | 47.54 | 47.35 | 47.35 | 62400.0 |
| 2001-12-20 12:30:00 | IWM | ETF | 47.325 | 47.49 | 47.31 | 47.47 | 54600.0 |
| 2001-12-20 13:00:00 | IWM | ETF | 47.4 | 47.49 | 47.38 | 47.44 | 29000.0 |
| 2001-12-20 13:30:00 | IWM | ETF | 47.355 | 47.55 | 47.335 | 47.4 | 84800.0 |
| 2001-12-20 14:00:00 | IWM | ETF | 47.38 | 47.575 | 47.38 | 47.4 | 186800.0 |
| 2001-12-20 14:30:00 | IWM | ETF | 47.385 | 47.51 | 47.31 | 47.32 | 143800.0 |
| 2001-12-20 15:00:00 | IWM | ETF | 47.305 | 47.39 | 47.24 | 47.25 | 133400.0 |
| 2001-12-20 15:30:00 | IWM | ETF | 47.205 | 47.42 | 46.975 | 46.975 | 281800.0 |
| 2001-12-20 16:00:00 | IWM | ETF | 46.975 | 47.15 | 46.975 | 47.15 | 37800.0 |
> showing 50 of 482 rows — these rows as CSV