PREVIEW / etf_30min / 2001-11-19
file: by_date/etf_30min/2001/2001-11-19.parquet size: 17 KB rows: 467
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-11-19 09:30:00 | SPY | ETF | 114.92 | 115.43 | 114.64 | 115.35 | 2023400.0 |
| 2001-11-19 10:00:00 | SPY | ETF | 115.34 | 115.57 | 115.12 | 115.13 | 1750900.0 |
| 2001-11-19 10:30:00 | SPY | ETF | 115.12 | 115.37 | 115.04 | 115.29 | 842100.0 |
| 2001-11-19 11:00:00 | SPY | ETF | 115.25 | 115.48 | 115.03 | 115.15 | 1080400.0 |
| 2001-11-19 11:30:00 | SPY | ETF | 115.17 | 115.24 | 114.67 | 114.79 | 1045800.0 |
| 2001-11-19 12:00:00 | SPY | ETF | 114.76 | 114.88 | 114.6 | 114.83 | 572100.0 |
| 2001-11-19 12:30:00 | SPY | ETF | 114.83 | 114.97 | 114.7 | 114.87 | 318000.0 |
| 2001-11-19 13:00:00 | SPY | ETF | 114.81 | 114.84 | 114.58 | 114.7 | 340700.0 |
| 2001-11-19 13:30:00 | SPY | ETF | 114.68 | 114.73 | 114.45 | 114.72 | 759900.0 |
| 2001-11-19 14:00:00 | SPY | ETF | 114.7 | 114.99 | 114.69 | 114.76 | 961400.0 |
| 2001-11-19 14:30:00 | SPY | ETF | 114.74 | 115.1 | 114.67 | 115.0 | 856800.0 |
| 2001-11-19 15:00:00 | SPY | ETF | 115.01 | 115.25 | 114.95 | 115.13 | 701100.0 |
| 2001-11-19 15:30:00 | SPY | ETF | 115.2 | 115.57 | 115.12 | 115.53 | 1164000.0 |
| 2001-11-19 16:00:00 | SPY | ETF | 115.56 | 116.75 | 115.11 | 115.8 | 1186200.0 |
| 2001-11-19 16:30:00 | SPY | ETF | 115.8 | 115.86 | 115.8 | 115.86 | 7000.0 |
| 2001-11-19 17:00:00 | SPY | ETF | 115.78 | 115.88 | 115.75 | 115.82 | 51800.0 |
| 2001-11-19 17:30:00 | SPY | ETF | 115.82 | 115.95 | 115.81 | 115.9 | 1400.0 |
| 2001-11-19 18:00:00 | SPY | ETF | 115.9 | 116.0 | 115.6 | 116.0 | 5300.0 |
| 2001-11-19 09:30:00 | QQQ | ETF | 39.79 | 40.12 | 39.65 | 40.11 | 9532800.0 |
| 2001-11-19 10:00:00 | QQQ | ETF | 40.1 | 40.28 | 39.88 | 39.88 | 11444100.0 |
| 2001-11-19 10:30:00 | QQQ | ETF | 39.9 | 40.09 | 39.86 | 40.07 | 5956300.0 |
| 2001-11-19 11:00:00 | QQQ | ETF | 40.04 | 40.17 | 39.83 | 39.92 | 4780200.0 |
| 2001-11-19 11:30:00 | QQQ | ETF | 39.93 | 39.99 | 39.7 | 39.8 | 3967300.0 |
| 2001-11-19 12:00:00 | QQQ | ETF | 39.79 | 39.89 | 39.62 | 39.79 | 2501400.0 |
| 2001-11-19 12:30:00 | QQQ | ETF | 39.8 | 39.93 | 39.74 | 39.83 | 2441700.0 |
| 2001-11-19 13:00:00 | QQQ | ETF | 39.82 | 39.83 | 39.58 | 39.72 | 2997400.0 |
| 2001-11-19 13:30:00 | QQQ | ETF | 39.67 | 39.73 | 39.49 | 39.68 | 4088300.0 |
| 2001-11-19 14:00:00 | QQQ | ETF | 39.72 | 39.88 | 39.63 | 39.66 | 3274900.0 |
| 2001-11-19 14:30:00 | QQQ | ETF | 39.63 | 39.88 | 39.57 | 39.8 | 3882900.0 |
| 2001-11-19 15:00:00 | QQQ | ETF | 39.8 | 40.06 | 39.79 | 40.0 | 3984000.0 |
| 2001-11-19 15:30:00 | QQQ | ETF | 40.0 | 40.34 | 39.96 | 40.32 | 6353700.0 |
| 2001-11-19 16:00:00 | QQQ | ETF | 40.28 | 40.5 | 40.24 | 40.4 | 3285800.0 |
| 2001-11-19 16:30:00 | QQQ | ETF | 40.49 | 40.57 | 40.35 | 40.52 | 85300.0 |
| 2001-11-19 17:00:00 | QQQ | ETF | 40.51 | 40.58 | 40.47 | 40.51 | 166400.0 |
| 2001-11-19 17:30:00 | QQQ | ETF | 40.51 | 40.61 | 40.51 | 40.59 | 32600.0 |
| 2001-11-19 18:00:00 | QQQ | ETF | 40.61 | 40.65 | 40.52 | 40.61 | 32000.0 |
| 2001-11-19 09:30:00 | IWM | ETF | 45.075 | 45.275 | 45.005 | 45.275 | 35000.0 |
| 2001-11-19 10:00:00 | IWM | ETF | 45.29 | 45.375 | 45.25 | 45.25 | 37200.0 |
| 2001-11-19 10:30:00 | IWM | ETF | 45.255 | 45.29 | 45.2 | 45.2 | 16200.0 |
| 2001-11-19 11:00:00 | IWM | ETF | 45.25 | 45.32 | 45.2 | 45.275 | 10200.0 |
| 2001-11-19 11:30:00 | IWM | ETF | 45.295 | 45.295 | 45.175 | 45.225 | 13800.0 |
| 2001-11-19 12:00:00 | IWM | ETF | 45.25 | 45.25 | 45.12 | 45.12 | 13400.0 |
| 2001-11-19 12:30:00 | IWM | ETF | 45.2 | 45.275 | 45.125 | 45.13 | 9600.0 |
| 2001-11-19 13:00:00 | IWM | ETF | 45.25 | 45.275 | 45.125 | 45.25 | 16400.0 |
| 2001-11-19 13:30:00 | IWM | ETF | 45.15 | 45.25 | 45.06 | 45.185 | 16000.0 |
| 2001-11-19 14:00:00 | IWM | ETF | 45.205 | 45.205 | 45.085 | 45.085 | 28800.0 |
| 2001-11-19 14:30:00 | IWM | ETF | 45.05 | 45.275 | 45.05 | 45.18 | 59400.0 |
| 2001-11-19 15:00:00 | IWM | ETF | 45.275 | 45.395 | 45.16 | 45.2 | 16800.0 |
| 2001-11-19 15:30:00 | IWM | ETF | 45.39 | 45.55 | 45.225 | 45.55 | 26200.0 |
| 2001-11-19 16:00:00 | IWM | ETF | 45.625 | 45.69 | 45.5 | 45.5 | 4800.0 |
> showing 50 of 467 rows — these rows as CSV