PREVIEW / etf_30min / 2001-03-29
file: by_date/etf_30min/2001/2001-03-29.parquet size: 13 KB rows: 291
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-29 10:00:00 | SPY | ETF | 114.63 | 115.85 | 114.44 | 115.57 | 954900.0 |
| 2001-03-29 10:30:00 | SPY | ETF | 115.56 | 116.5 | 115.28 | 116.16 | 1365300.0 |
| 2001-03-29 11:00:00 | SPY | ETF | 116.26 | 116.28 | 115.43 | 115.56 | 858500.0 |
| 2001-03-29 11:30:00 | SPY | ETF | 115.7 | 115.95 | 115.3 | 115.5 | 285000.0 |
| 2001-03-29 12:00:00 | SPY | ETF | 115.46 | 116.12 | 115.41 | 116.12 | 238200.0 |
| 2001-03-29 12:30:00 | SPY | ETF | 116.0 | 116.2 | 115.75 | 115.9 | 412500.0 |
| 2001-03-29 13:00:00 | SPY | ETF | 115.89 | 116.08 | 115.55 | 115.65 | 308300.0 |
| 2001-03-29 13:30:00 | SPY | ETF | 115.65 | 115.8 | 115.4 | 115.5 | 158200.0 |
| 2001-03-29 14:00:00 | SPY | ETF | 115.45 | 115.62 | 115.0 | 115.06 | 757300.0 |
| 2001-03-29 14:30:00 | SPY | ETF | 115.11 | 115.34 | 114.0 | 114.0 | 969100.0 |
| 2001-03-29 15:00:00 | SPY | ETF | 114.13 | 114.5 | 113.7 | 114.33 | 1119000.0 |
| 2001-03-29 15:30:00 | SPY | ETF | 114.29 | 115.18 | 114.2 | 114.98 | 1014600.0 |
| 2001-03-29 16:00:00 | SPY | ETF | 115.06 | 115.59 | 114.44 | 115.48 | 712100.0 |
| 2001-03-29 16:30:00 | SPY | ETF | 115.48 | 115.56 | 115.38 | 115.39 | 2200.0 |
| 2001-03-29 17:00:00 | SPY | ETF | 115.39 | 115.39 | 115.39 | 115.39 | 300.0 |
| 2001-03-29 18:00:00 | SPY | ETF | 115.45 | 115.45 | 115.45 | 115.45 | 200.0 |
| 2001-03-29 10:00:00 | QQQ | ETF | 39.22 | 40.21 | 39.1 | 40.03 | 5970100.0 |
| 2001-03-29 10:30:00 | QQQ | ETF | 40.08 | 40.61 | 39.79 | 40.47 | 11821500.0 |
| 2001-03-29 11:00:00 | QQQ | ETF | 40.5 | 40.5 | 39.7 | 39.89 | 5973900.0 |
| 2001-03-29 11:30:00 | QQQ | ETF | 39.88 | 40.13 | 39.46 | 39.67 | 2768300.0 |
| 2001-03-29 12:00:00 | QQQ | ETF | 39.67 | 40.01 | 39.52 | 39.99 | 2234500.0 |
| 2001-03-29 12:30:00 | QQQ | ETF | 39.98 | 40.1 | 39.69 | 39.82 | 1663100.0 |
| 2001-03-29 13:00:00 | QQQ | ETF | 39.7 | 39.89 | 39.56 | 39.65 | 1204000.0 |
| 2001-03-29 13:30:00 | QQQ | ETF | 39.65 | 39.68 | 39.2 | 39.29 | 2389600.0 |
| 2001-03-29 14:00:00 | QQQ | ETF | 39.28 | 39.39 | 38.99 | 39.08 | 3926300.0 |
| 2001-03-29 14:30:00 | QQQ | ETF | 39.08 | 39.32 | 38.5 | 38.57 | 5909400.0 |
| 2001-03-29 15:00:00 | QQQ | ETF | 38.57 | 38.9 | 38.45 | 38.57 | 7927300.0 |
| 2001-03-29 15:30:00 | QQQ | ETF | 38.58 | 39.06 | 38.56 | 38.97 | 7842900.0 |
| 2001-03-29 16:00:00 | QQQ | ETF | 38.99 | 39.06 | 38.87 | 38.95 | 1166100.0 |
| 2001-03-29 16:30:00 | QQQ | ETF | 38.98 | 39.09 | 38.75 | 39.0 | 38000.0 |
| 2001-03-29 17:00:00 | QQQ | ETF | 39.09 | 39.13 | 38.97 | 39.09 | 71100.0 |
| 2001-03-29 17:30:00 | QQQ | ETF | 39.09 | 39.2 | 39.0 | 39.18 | 25400.0 |
| 2001-03-29 18:00:00 | QQQ | ETF | 39.19 | 39.4 | 39.1 | 39.4 | 23600.0 |
| 2001-03-29 10:00:00 | IWM | ETF | 43.9 | 43.905 | 43.9 | 43.9 | 6400.0 |
| 2001-03-29 10:30:00 | IWM | ETF | 44.35 | 44.7 | 44.35 | 44.7 | 51000.0 |
| 2001-03-29 11:00:00 | IWM | ETF | 44.65 | 44.65 | 44.25 | 44.25 | 172400.0 |
| 2001-03-29 11:30:00 | IWM | ETF | 44.25 | 44.25 | 44.25 | 44.25 | 8800.0 |
| 2001-03-29 12:00:00 | IWM | ETF | 44.385 | 44.4 | 44.385 | 44.4 | 54000.0 |
| 2001-03-29 12:30:00 | IWM | ETF | 44.5 | 44.5 | 44.5 | 44.5 | 20000.0 |
| 2001-03-29 13:00:00 | IWM | ETF | 44.5 | 44.5 | 44.5 | 44.5 | 600.0 |
| 2001-03-29 13:30:00 | IWM | ETF | 44.5 | 44.5 | 44.375 | 44.475 | 88000.0 |
| 2001-03-29 14:00:00 | IWM | ETF | 44.205 | 44.4 | 44.2 | 44.25 | 45200.0 |
| 2001-03-29 14:30:00 | IWM | ETF | 44.34 | 44.34 | 43.9 | 43.9 | 30200.0 |
| 2001-03-29 15:00:00 | IWM | ETF | 43.775 | 43.925 | 43.75 | 43.85 | 51600.0 |
| 2001-03-29 15:30:00 | IWM | ETF | 43.825 | 44.0 | 43.755 | 43.95 | 39600.0 |
| 2001-03-29 10:00:00 | DIA | ETF | 97.05 | 98.6 | 97.03 | 98.35 | 485500.0 |
| 2001-03-29 10:30:00 | DIA | ETF | 98.3 | 98.97 | 98.05 | 98.8 | 808500.0 |
| 2001-03-29 11:00:00 | DIA | ETF | 98.86 | 98.89 | 98.05 | 98.22 | 316100.0 |
| 2001-03-29 11:30:00 | DIA | ETF | 98.33 | 98.58 | 97.96 | 98.21 | 112500.0 |
| 2001-03-29 12:00:00 | DIA | ETF | 98.19 | 98.63 | 98.1 | 98.6 | 83600.0 |
> showing 50 of 291 rows — these rows as CSV