PREVIEW / etf_30min / 2001-03-28
file: by_date/etf_30min/2001/2001-03-28.parquet size: 14 KB rows: 345
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-03-28 09:30:00 | SPY | ETF | 116.9 | 116.95 | 115.88 | 116.08 | 2511300.0 |
| 2001-03-28 10:00:00 | SPY | ETF | 115.99 | 116.24 | 115.54 | 116.1 | 904000.0 |
| 2001-03-28 10:30:00 | SPY | ETF | 116.17 | 116.35 | 115.75 | 115.75 | 536600.0 |
| 2001-03-28 11:00:00 | SPY | ETF | 115.84 | 116.07 | 115.41 | 115.53 | 536000.0 |
| 2001-03-28 11:30:00 | SPY | ETF | 115.5 | 115.6 | 115.13 | 115.36 | 675400.0 |
| 2001-03-28 12:00:00 | SPY | ETF | 115.4 | 115.93 | 115.28 | 115.88 | 489000.0 |
| 2001-03-28 12:30:00 | SPY | ETF | 115.87 | 116.08 | 115.6 | 116.0 | 265200.0 |
| 2001-03-28 13:00:00 | SPY | ETF | 116.03 | 116.14 | 115.5 | 115.8 | 489000.0 |
| 2001-03-28 13:30:00 | SPY | ETF | 115.8 | 115.91 | 115.42 | 115.5 | 243000.0 |
| 2001-03-28 14:00:00 | SPY | ETF | 115.42 | 115.68 | 115.05 | 115.12 | 420100.0 |
| 2001-03-28 14:30:00 | SPY | ETF | 115.14 | 115.99 | 115.07 | 115.63 | 478500.0 |
| 2001-03-28 15:00:00 | SPY | ETF | 115.7 | 115.7 | 114.9 | 115.2 | 898400.0 |
| 2001-03-28 15:30:00 | SPY | ETF | 115.25 | 116.2 | 115.22 | 115.45 | 1214900.0 |
| 2001-03-28 16:00:00 | SPY | ETF | 115.35 | 116.53 | 115.01 | 115.03 | 675200.0 |
| 2001-03-28 16:30:00 | SPY | ETF | 114.43 | 115.25 | 114.14 | 115.25 | 2900.0 |
| 2001-03-28 17:00:00 | SPY | ETF | 115.0 | 115.27 | 115.0 | 115.27 | 10300.0 |
| 2001-03-28 09:30:00 | QQQ | ETF | 41.9 | 42.1 | 41.55 | 41.66 | 8787500.0 |
| 2001-03-28 10:00:00 | QQQ | ETF | 41.72 | 41.87 | 41.35 | 41.75 | 6102500.0 |
| 2001-03-28 10:30:00 | QQQ | ETF | 41.77 | 41.91 | 41.26 | 41.32 | 5508800.0 |
| 2001-03-28 11:00:00 | QQQ | ETF | 41.32 | 41.45 | 40.8 | 41.0 | 5092700.0 |
| 2001-03-28 11:30:00 | QQQ | ETF | 40.96 | 41.07 | 40.75 | 40.87 | 3446700.0 |
| 2001-03-28 12:00:00 | QQQ | ETF | 40.87 | 41.16 | 40.82 | 40.99 | 3409800.0 |
| 2001-03-28 12:30:00 | QQQ | ETF | 41.02 | 41.16 | 40.87 | 41.05 | 5288100.0 |
| 2001-03-28 13:00:00 | QQQ | ETF | 41.06 | 41.12 | 40.61 | 40.84 | 4571400.0 |
| 2001-03-28 13:30:00 | QQQ | ETF | 40.8 | 40.85 | 40.36 | 40.4 | 5275500.0 |
| 2001-03-28 14:00:00 | QQQ | ETF | 40.43 | 40.5 | 39.94 | 40.15 | 5917800.0 |
| 2001-03-28 14:30:00 | QQQ | ETF | 40.14 | 40.69 | 40.05 | 40.5 | 5683000.0 |
| 2001-03-28 15:00:00 | QQQ | ETF | 40.4 | 40.45 | 39.95 | 40.05 | 5232800.0 |
| 2001-03-28 15:30:00 | QQQ | ETF | 40.05 | 40.63 | 39.9 | 39.9 | 7060400.0 |
| 2001-03-28 16:00:00 | QQQ | ETF | 39.94 | 40.02 | 39.5 | 39.6 | 3042000.0 |
| 2001-03-28 16:30:00 | QQQ | ETF | 39.63 | 40.04 | 39.6 | 39.76 | 109200.0 |
| 2001-03-28 17:00:00 | QQQ | ETF | 39.71 | 39.78 | 39.69 | 39.72 | 24700.0 |
| 2001-03-28 17:30:00 | QQQ | ETF | 39.72 | 39.75 | 39.65 | 39.75 | 32600.0 |
| 2001-03-28 18:00:00 | QQQ | ETF | 39.75 | 39.8 | 39.5 | 39.75 | 19200.0 |
| 2001-03-28 09:30:00 | IWM | ETF | 44.45 | 44.5 | 44.15 | 44.15 | 560000.0 |
| 2001-03-28 10:00:00 | IWM | ETF | 44.2 | 44.3 | 44.03 | 44.3 | 108800.0 |
| 2001-03-28 10:30:00 | IWM | ETF | 44.3 | 44.36 | 44.24 | 44.325 | 11800.0 |
| 2001-03-28 11:00:00 | IWM | ETF | 44.29 | 44.29 | 44.1 | 44.1 | 53800.0 |
| 2001-03-28 11:30:00 | IWM | ETF | 44.195 | 44.25 | 43.95 | 44.0 | 71800.0 |
| 2001-03-28 12:00:00 | IWM | ETF | 44.0 | 44.25 | 43.975 | 44.15 | 80600.0 |
| 2001-03-28 12:30:00 | IWM | ETF | 44.22 | 44.22 | 44.15 | 44.15 | 800.0 |
| 2001-03-28 13:00:00 | IWM | ETF | 44.225 | 44.225 | 44.0 | 44.0 | 87600.0 |
| 2001-03-28 14:00:00 | IWM | ETF | 43.975 | 44.0 | 43.775 | 43.775 | 21800.0 |
| 2001-03-28 14:30:00 | IWM | ETF | 44.05 | 44.225 | 43.995 | 44.2 | 43000.0 |
| 2001-03-28 15:00:00 | IWM | ETF | 44.295 | 44.295 | 44.06 | 44.075 | 9800.0 |
| 2001-03-28 15:30:00 | IWM | ETF | 44.0 | 44.195 | 44.0 | 44.01 | 41600.0 |
| 2001-03-28 16:00:00 | IWM | ETF | 44.0 | 44.0 | 43.875 | 43.875 | 101200.0 |
| 2001-03-28 09:30:00 | DIA | ETF | 98.4 | 98.73 | 97.61 | 97.64 | 1157200.0 |
| 2001-03-28 10:00:00 | DIA | ETF | 97.63 | 97.8 | 97.25 | 97.65 | 869900.0 |
| 2001-03-28 10:30:00 | DIA | ETF | 97.65 | 97.9 | 97.26 | 97.35 | 426900.0 |
> showing 50 of 345 rows — these rows as CSV