PREVIEW / etf_30min / 2002-03-07
file: by_date/etf_30min/2002/2002-03-07.parquet size: 19 KB rows: 513
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 |
|---|---|---|---|---|---|---|---|
| 2002-03-07 09:30:00 | SPY | ETF | 117.36 | 117.5 | 116.54 | 116.55 | 2846700.0 |
| 2002-03-07 10:00:00 | SPY | ETF | 116.54 | 117.21 | 116.5 | 116.76 | 3252300.0 |
| 2002-03-07 10:30:00 | SPY | ETF | 116.81 | 116.85 | 116.02 | 116.42 | 2215000.0 |
| 2002-03-07 11:00:00 | SPY | ETF | 116.32 | 116.64 | 116.21 | 116.46 | 1070200.0 |
| 2002-03-07 11:30:00 | SPY | ETF | 116.5 | 116.54 | 116.21 | 116.35 | 414000.0 |
| 2002-03-07 12:00:00 | SPY | ETF | 116.37 | 116.4 | 116.08 | 116.3 | 423500.0 |
| 2002-03-07 12:30:00 | SPY | ETF | 116.3 | 116.55 | 116.2 | 116.27 | 640600.0 |
| 2002-03-07 13:00:00 | SPY | ETF | 116.28 | 116.42 | 116.23 | 116.33 | 552800.0 |
| 2002-03-07 13:30:00 | SPY | ETF | 116.35 | 116.37 | 115.69 | 115.78 | 1186400.0 |
| 2002-03-07 14:00:00 | SPY | ETF | 115.72 | 115.9 | 115.61 | 115.82 | 823800.0 |
| 2002-03-07 14:30:00 | SPY | ETF | 115.78 | 116.11 | 115.57 | 115.89 | 894700.0 |
| 2002-03-07 15:00:00 | SPY | ETF | 115.86 | 116.33 | 115.7 | 116.13 | 1113200.0 |
| 2002-03-07 15:30:00 | SPY | ETF | 116.19 | 116.36 | 115.9 | 116.33 | 1719300.0 |
| 2002-03-07 16:00:00 | SPY | ETF | 116.38 | 116.59 | 116.0 | 116.3 | 937200.0 |
| 2002-03-07 16:30:00 | SPY | ETF | 116.35 | 116.56 | 116.35 | 116.54 | 22900.0 |
| 2002-03-07 17:00:00 | SPY | ETF | 116.5 | 116.59 | 116.5 | 116.59 | 5600.0 |
| 2002-03-07 17:30:00 | SPY | ETF | 116.51 | 116.51 | 116.51 | 116.51 | 500.0 |
| 2002-03-07 18:00:00 | SPY | ETF | 116.51 | 116.51 | 116.48 | 116.48 | 600.0 |
| 2002-03-07 09:30:00 | QQQ | ETF | 38.12 | 38.33 | 37.66 | 37.68 | 15606300.0 |
| 2002-03-07 10:00:00 | QQQ | ETF | 37.68 | 38.17 | 37.65 | 37.9 | 13508600.0 |
| 2002-03-07 10:30:00 | QQQ | ETF | 37.88 | 37.95 | 37.51 | 37.61 | 6875000.0 |
| 2002-03-07 11:00:00 | QQQ | ETF | 37.6 | 37.98 | 37.58 | 37.84 | 3100100.0 |
| 2002-03-07 11:30:00 | QQQ | ETF | 37.84 | 37.9 | 37.7 | 37.77 | 3302500.0 |
| 2002-03-07 12:00:00 | QQQ | ETF | 37.76 | 37.85 | 37.62 | 37.76 | 3083000.0 |
| 2002-03-07 12:30:00 | QQQ | ETF | 37.77 | 37.95 | 37.71 | 37.79 | 3075500.0 |
| 2002-03-07 13:00:00 | QQQ | ETF | 37.81 | 37.86 | 37.7 | 37.74 | 1441100.0 |
| 2002-03-07 13:30:00 | QQQ | ETF | 37.74 | 37.78 | 37.11 | 37.11 | 8272400.0 |
| 2002-03-07 14:00:00 | QQQ | ETF | 37.11 | 37.35 | 37.07 | 37.24 | 7092400.0 |
| 2002-03-07 14:30:00 | QQQ | ETF | 37.24 | 37.39 | 37.01 | 37.26 | 5468200.0 |
| 2002-03-07 15:00:00 | QQQ | ETF | 37.28 | 37.59 | 37.16 | 37.45 | 4405200.0 |
| 2002-03-07 15:30:00 | QQQ | ETF | 37.47 | 37.55 | 37.22 | 37.51 | 4558600.0 |
| 2002-03-07 16:00:00 | QQQ | ETF | 37.51 | 37.7 | 37.33 | 37.41 | 2161800.0 |
| 2002-03-07 16:30:00 | QQQ | ETF | 37.42 | 37.7 | 37.3 | 37.65 | 379600.0 |
| 2002-03-07 17:00:00 | QQQ | ETF | 37.65 | 37.76 | 37.65 | 37.74 | 120300.0 |
| 2002-03-07 17:30:00 | QQQ | ETF | 37.73 | 37.74 | 37.62 | 37.62 | 52200.0 |
| 2002-03-07 18:00:00 | QQQ | ETF | 37.62 | 37.69 | 37.6 | 37.67 | 20400.0 |
| 2002-03-07 09:30:00 | IWM | ETF | 49.55 | 49.65 | 49.325 | 49.415 | 79800.0 |
| 2002-03-07 10:00:00 | IWM | ETF | 49.395 | 49.5 | 49.335 | 49.445 | 161000.0 |
| 2002-03-07 10:30:00 | IWM | ETF | 49.445 | 49.445 | 49.15 | 49.285 | 27200.0 |
| 2002-03-07 11:00:00 | IWM | ETF | 49.305 | 49.395 | 49.29 | 49.39 | 13400.0 |
| 2002-03-07 11:30:00 | IWM | ETF | 49.395 | 49.395 | 49.36 | 49.375 | 19000.0 |
| 2002-03-07 12:00:00 | IWM | ETF | 49.365 | 49.39 | 49.315 | 49.37 | 35000.0 |
| 2002-03-07 12:30:00 | IWM | ETF | 49.365 | 49.445 | 49.365 | 49.425 | 66200.0 |
| 2002-03-07 13:00:00 | IWM | ETF | 49.435 | 49.435 | 49.4 | 49.405 | 22800.0 |
| 2002-03-07 13:30:00 | IWM | ETF | 49.45 | 49.45 | 49.2 | 49.28 | 40000.0 |
| 2002-03-07 14:00:00 | IWM | ETF | 49.195 | 49.24 | 49.15 | 49.225 | 54800.0 |
| 2002-03-07 14:30:00 | IWM | ETF | 49.155 | 49.24 | 49.075 | 49.175 | 87400.0 |
| 2002-03-07 15:00:00 | IWM | ETF | 49.175 | 49.3 | 49.125 | 49.3 | 131000.0 |
| 2002-03-07 15:30:00 | IWM | ETF | 49.25 | 49.31 | 49.225 | 49.28 | 33600.0 |
| 2002-03-07 16:00:00 | IWM | ETF | 49.31 | 49.375 | 49.25 | 49.25 | 362600.0 |
> showing 50 of 513 rows — these rows as CSV