PREVIEW / etf_30min / 2001-12-10
file: by_date/etf_30min/2001/2001-12-10.parquet size: 17 KB rows: 450
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-10 09:30:00 | SPY | ETF | 115.85 | 116.11 | 115.72 | 115.9 | 1849900.0 |
| 2001-12-10 10:00:00 | SPY | ETF | 115.88 | 116.39 | 115.84 | 116.18 | 1342500.0 |
| 2001-12-10 10:30:00 | SPY | ETF | 116.18 | 116.27 | 115.68 | 115.78 | 1428000.0 |
| 2001-12-10 11:00:00 | SPY | ETF | 115.79 | 115.91 | 115.57 | 115.76 | 1086300.0 |
| 2001-12-10 11:30:00 | SPY | ETF | 115.72 | 115.76 | 115.37 | 115.48 | 696400.0 |
| 2001-12-10 12:00:00 | SPY | ETF | 115.48 | 115.54 | 115.09 | 115.23 | 1058600.0 |
| 2001-12-10 12:30:00 | SPY | ETF | 115.23 | 115.34 | 115.16 | 115.24 | 457400.0 |
| 2001-12-10 13:00:00 | SPY | ETF | 115.24 | 115.27 | 114.88 | 115.0 | 841800.0 |
| 2001-12-10 13:30:00 | SPY | ETF | 114.99 | 115.12 | 114.94 | 115.0 | 365700.0 |
| 2001-12-10 14:00:00 | SPY | ETF | 114.95 | 115.29 | 114.91 | 114.97 | 900200.0 |
| 2001-12-10 14:30:00 | SPY | ETF | 114.93 | 115.14 | 114.81 | 115.02 | 405300.0 |
| 2001-12-10 15:00:00 | SPY | ETF | 115.0 | 115.09 | 114.61 | 114.62 | 901100.0 |
| 2001-12-10 15:30:00 | SPY | ETF | 114.66 | 114.68 | 114.46 | 114.46 | 1671100.0 |
| 2001-12-10 16:00:00 | SPY | ETF | 114.46 | 114.57 | 114.2 | 114.2 | 766000.0 |
| 2001-12-10 16:30:00 | SPY | ETF | 114.48 | 114.48 | 114.43 | 114.43 | 400.0 |
| 2001-12-10 17:00:00 | SPY | ETF | 114.38 | 114.4 | 114.32 | 114.4 | 1900.0 |
| 2001-12-10 17:30:00 | SPY | ETF | 114.36 | 114.36 | 114.36 | 114.36 | 100.0 |
| 2001-12-10 09:30:00 | QQQ | ETF | 41.32 | 41.75 | 41.26 | 41.6 | 7452100.0 |
| 2001-12-10 10:00:00 | QQQ | ETF | 41.59 | 42.23 | 41.56 | 42.09 | 9732700.0 |
| 2001-12-10 10:30:00 | QQQ | ETF | 42.04 | 42.1 | 41.7 | 41.85 | 5776400.0 |
| 2001-12-10 11:00:00 | QQQ | ETF | 41.85 | 41.93 | 41.62 | 41.75 | 4155300.0 |
| 2001-12-10 11:30:00 | QQQ | ETF | 41.76 | 41.78 | 41.43 | 41.48 | 5801600.0 |
| 2001-12-10 12:00:00 | QQQ | ETF | 41.49 | 41.64 | 41.31 | 41.46 | 2957300.0 |
| 2001-12-10 12:30:00 | QQQ | ETF | 41.47 | 41.63 | 41.41 | 41.5 | 2177500.0 |
| 2001-12-10 13:00:00 | QQQ | ETF | 41.51 | 41.52 | 41.16 | 41.27 | 3858300.0 |
| 2001-12-10 13:30:00 | QQQ | ETF | 41.26 | 41.42 | 41.17 | 41.32 | 3538800.0 |
| 2001-12-10 14:00:00 | QQQ | ETF | 41.32 | 41.53 | 41.24 | 41.27 | 3781000.0 |
| 2001-12-10 14:30:00 | QQQ | ETF | 41.29 | 41.44 | 41.16 | 41.3 | 4030500.0 |
| 2001-12-10 15:00:00 | QQQ | ETF | 41.3 | 41.39 | 41.02 | 41.05 | 4763100.0 |
| 2001-12-10 15:30:00 | QQQ | ETF | 41.05 | 41.1 | 40.88 | 40.97 | 8544200.0 |
| 2001-12-10 16:00:00 | QQQ | ETF | 40.99 | 41.05 | 40.93 | 41.01 | 1571100.0 |
| 2001-12-10 16:30:00 | QQQ | ETF | 40.99 | 41.01 | 40.93 | 40.98 | 42800.0 |
| 2001-12-10 17:00:00 | QQQ | ETF | 40.98 | 41.0 | 40.95 | 40.97 | 20500.0 |
| 2001-12-10 17:30:00 | QQQ | ETF | 40.93 | 41.0 | 40.9 | 40.98 | 18200.0 |
| 2001-12-10 18:00:00 | QQQ | ETF | 40.98 | 41.0 | 40.92 | 41.0 | 4200.0 |
| 2001-12-10 09:30:00 | IWM | ETF | 47.875 | 47.9 | 47.63 | 47.8 | 44400.0 |
| 2001-12-10 10:00:00 | IWM | ETF | 47.65 | 48.09 | 47.65 | 48.09 | 40400.0 |
| 2001-12-10 10:30:00 | IWM | ETF | 48.005 | 48.03 | 47.825 | 47.85 | 15600.0 |
| 2001-12-10 11:00:00 | IWM | ETF | 47.85 | 47.85 | 47.74 | 47.74 | 19000.0 |
| 2001-12-10 11:30:00 | IWM | ETF | 47.81 | 47.81 | 47.585 | 47.585 | 8000.0 |
| 2001-12-10 12:00:00 | IWM | ETF | 47.7 | 47.7 | 47.5 | 47.5 | 17000.0 |
| 2001-12-10 12:30:00 | IWM | ETF | 47.455 | 47.6 | 47.455 | 47.535 | 21400.0 |
| 2001-12-10 13:00:00 | IWM | ETF | 47.56 | 47.59 | 47.375 | 47.425 | 39600.0 |
| 2001-12-10 13:30:00 | IWM | ETF | 47.375 | 47.475 | 47.35 | 47.46 | 11000.0 |
| 2001-12-10 14:00:00 | IWM | ETF | 47.41 | 47.6 | 47.41 | 47.57 | 73400.0 |
| 2001-12-10 14:30:00 | IWM | ETF | 47.485 | 47.55 | 47.375 | 47.395 | 14400.0 |
| 2001-12-10 15:00:00 | IWM | ETF | 47.545 | 47.545 | 47.265 | 47.3 | 20800.0 |
| 2001-12-10 15:30:00 | IWM | ETF | 47.25 | 47.265 | 47.0 | 47.18 | 48600.0 |
| 2001-12-10 16:00:00 | IWM | ETF | 47.25 | 47.25 | 46.98 | 46.98 | 296200.0 |
| 2001-12-10 09:30:00 | DIA | ETF | 100.35 | 100.6 | 100.22 | 100.53 | 421100.0 |
> showing 50 of 450 rows — these rows as CSV