PREVIEW / etf_30min / 2001-12-19
file: by_date/etf_30min/2001/2001-12-19.parquet size: 18 KB rows: 472
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-19 09:30:00 | SPY | ETF | 114.09 | 114.39 | 114.0 | 114.33 | 3166500.0 |
| 2001-12-19 10:00:00 | SPY | ETF | 114.35 | 114.9 | 114.28 | 114.6 | 3178600.0 |
| 2001-12-19 10:30:00 | SPY | ETF | 114.58 | 115.07 | 114.5 | 115.05 | 1281700.0 |
| 2001-12-19 11:00:00 | SPY | ETF | 115.0 | 115.63 | 114.97 | 115.4 | 2103900.0 |
| 2001-12-19 11:30:00 | SPY | ETF | 115.4 | 115.88 | 115.4 | 115.57 | 1260900.0 |
| 2001-12-19 12:00:00 | SPY | ETF | 115.55 | 115.76 | 115.54 | 115.63 | 981200.0 |
| 2001-12-19 12:30:00 | SPY | ETF | 115.64 | 115.7 | 115.28 | 115.35 | 1734400.0 |
| 2001-12-19 13:00:00 | SPY | ETF | 115.36 | 115.43 | 115.11 | 115.22 | 719600.0 |
| 2001-12-19 13:30:00 | SPY | ETF | 115.22 | 115.67 | 115.21 | 115.67 | 424400.0 |
| 2001-12-19 14:00:00 | SPY | ETF | 115.69 | 115.78 | 115.55 | 115.62 | 621800.0 |
| 2001-12-19 14:30:00 | SPY | ETF | 115.6 | 115.92 | 115.56 | 115.82 | 1151400.0 |
| 2001-12-19 15:00:00 | SPY | ETF | 115.83 | 115.88 | 115.42 | 115.64 | 763100.0 |
| 2001-12-19 15:30:00 | SPY | ETF | 115.65 | 115.91 | 115.5 | 115.5 | 1339900.0 |
| 2001-12-19 16:00:00 | SPY | ETF | 115.5 | 116.08 | 115.47 | 115.65 | 957900.0 |
| 2001-12-19 16:30:00 | SPY | ETF | 115.65 | 115.7 | 115.3 | 115.7 | 7000.0 |
| 2001-12-19 17:00:00 | SPY | ETF | 115.73 | 115.73 | 115.73 | 115.73 | 200.0 |
| 2001-12-19 17:30:00 | SPY | ETF | 115.52 | 115.71 | 115.52 | 115.71 | 3600.0 |
| 2001-12-19 18:00:00 | SPY | ETF | 115.75 | 115.75 | 115.75 | 115.75 | 1000.0 |
| 2001-12-19 09:30:00 | QQQ | ETF | 40.56 | 40.6 | 40.32 | 40.56 | 11279400.0 |
| 2001-12-19 10:00:00 | QQQ | ETF | 40.56 | 40.94 | 40.46 | 40.57 | 12611100.0 |
| 2001-12-19 10:30:00 | QQQ | ETF | 40.53 | 40.83 | 40.48 | 40.78 | 4103300.0 |
| 2001-12-19 11:00:00 | QQQ | ETF | 40.81 | 41.22 | 40.74 | 41.0 | 8248600.0 |
| 2001-12-19 11:30:00 | QQQ | ETF | 41.01 | 41.32 | 40.98 | 41.12 | 6870200.0 |
| 2001-12-19 12:00:00 | QQQ | ETF | 41.12 | 41.25 | 41.04 | 41.15 | 2471200.0 |
| 2001-12-19 12:30:00 | QQQ | ETF | 41.14 | 41.15 | 40.89 | 40.92 | 5213700.0 |
| 2001-12-19 13:00:00 | QQQ | ETF | 40.93 | 41.0 | 40.61 | 40.73 | 5311800.0 |
| 2001-12-19 13:30:00 | QQQ | ETF | 40.75 | 41.04 | 40.68 | 41.04 | 2863200.0 |
| 2001-12-19 14:00:00 | QQQ | ETF | 41.04 | 41.1 | 40.75 | 40.82 | 3102400.0 |
| 2001-12-19 14:30:00 | QQQ | ETF | 40.84 | 41.0 | 40.76 | 40.9 | 2781300.0 |
| 2001-12-19 15:00:00 | QQQ | ETF | 40.91 | 40.93 | 40.53 | 40.65 | 4493000.0 |
| 2001-12-19 15:30:00 | QQQ | ETF | 40.65 | 40.83 | 40.54 | 40.55 | 6283600.0 |
| 2001-12-19 16:00:00 | QQQ | ETF | 40.56 | 40.65 | 40.45 | 40.45 | 2887800.0 |
| 2001-12-19 16:30:00 | QQQ | ETF | 40.45 | 40.6 | 40.45 | 40.47 | 44200.0 |
| 2001-12-19 17:00:00 | QQQ | ETF | 40.47 | 40.51 | 40.41 | 40.47 | 115500.0 |
| 2001-12-19 17:30:00 | QQQ | ETF | 40.5 | 40.53 | 40.46 | 40.53 | 19700.0 |
| 2001-12-19 18:00:00 | QQQ | ETF | 40.53 | 40.6 | 40.41 | 40.55 | 16900.0 |
| 2001-12-19 09:30:00 | IWM | ETF | 47.875 | 47.895 | 47.565 | 47.82 | 90800.0 |
| 2001-12-19 10:00:00 | IWM | ETF | 47.825 | 48.05 | 47.815 | 47.88 | 43000.0 |
| 2001-12-19 10:30:00 | IWM | ETF | 47.785 | 47.96 | 47.785 | 47.94 | 16200.0 |
| 2001-12-19 11:00:00 | IWM | ETF | 48.065 | 48.19 | 48.0 | 48.17 | 38400.0 |
| 2001-12-19 11:30:00 | IWM | ETF | 48.115 | 48.17 | 48.035 | 48.17 | 15800.0 |
| 2001-12-19 12:00:00 | IWM | ETF | 48.125 | 48.145 | 47.95 | 48.02 | 66000.0 |
| 2001-12-19 12:30:00 | IWM | ETF | 48.02 | 48.045 | 47.94 | 48.02 | 4800.0 |
| 2001-12-19 13:00:00 | IWM | ETF | 48.02 | 48.025 | 47.875 | 47.995 | 117400.0 |
| 2001-12-19 13:30:00 | IWM | ETF | 47.925 | 48.03 | 47.925 | 48.03 | 56000.0 |
| 2001-12-19 14:00:00 | IWM | ETF | 48.05 | 48.17 | 47.92 | 48.12 | 517600.0 |
| 2001-12-19 14:30:00 | IWM | ETF | 48.1 | 48.165 | 47.94 | 48.13 | 17200.0 |
| 2001-12-19 15:00:00 | IWM | ETF | 48.01 | 48.145 | 48.0 | 48.075 | 50200.0 |
| 2001-12-19 15:30:00 | IWM | ETF | 48.075 | 48.145 | 47.835 | 47.835 | 164400.0 |
| 2001-12-19 16:00:00 | IWM | ETF | 47.95 | 47.95 | 47.75 | 47.9 | 353800.0 |
> showing 50 of 472 rows — these rows as CSV