PREVIEW / etf_30min / 2002-09-05
file: by_date/etf_30min/2002/2002-09-05.parquet size: 19 KB rows: 539
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-09-05 09:30:00 | SPY | ETF | 88.49 | 88.6 | 88.05 | 88.2 | 5509700.0 |
| 2002-09-05 10:00:00 | SPY | ETF | 88.25 | 88.5 | 87.5 | 87.78 | 9028700.0 |
| 2002-09-05 10:30:00 | SPY | ETF | 87.79 | 88.35 | 87.65 | 88.3 | 3974500.0 |
| 2002-09-05 11:00:00 | SPY | ETF | 88.24 | 89.03 | 88.23 | 88.94 | 3821300.0 |
| 2002-09-05 11:30:00 | SPY | ETF | 88.96 | 89.43 | 88.76 | 88.8 | 3900100.0 |
| 2002-09-05 12:00:00 | SPY | ETF | 88.76 | 88.93 | 88.42 | 88.72 | 2744500.0 |
| 2002-09-05 12:30:00 | SPY | ETF | 88.7 | 88.9 | 88.35 | 88.87 | 1154000.0 |
| 2002-09-05 13:00:00 | SPY | ETF | 88.87 | 89.2 | 88.7 | 88.96 | 1171900.0 |
| 2002-09-05 13:30:00 | SPY | ETF | 88.95 | 89.35 | 88.67 | 88.71 | 2289700.0 |
| 2002-09-05 14:00:00 | SPY | ETF | 88.73 | 89.09 | 88.53 | 88.55 | 1970600.0 |
| 2002-09-05 14:30:00 | SPY | ETF | 88.53 | 88.62 | 88.1 | 88.39 | 5074700.0 |
| 2002-09-05 15:00:00 | SPY | ETF | 88.41 | 88.73 | 88.31 | 88.42 | 2426700.0 |
| 2002-09-05 15:30:00 | SPY | ETF | 88.44 | 88.66 | 88.22 | 88.46 | 3937100.0 |
| 2002-09-05 16:00:00 | SPY | ETF | 88.47 | 88.88 | 88.43 | 88.78 | 1207800.0 |
| 2002-09-05 09:30:00 | QQQ | ETF | 22.4 | 22.42 | 22.2 | 22.22 | 9208300.0 |
| 2002-09-05 10:00:00 | QQQ | ETF | 22.25 | 22.36 | 21.96 | 22.09 | 13867200.0 |
| 2002-09-05 10:30:00 | QQQ | ETF | 22.1 | 22.17 | 22.03 | 22.12 | 5917500.0 |
| 2002-09-05 11:00:00 | QQQ | ETF | 22.12 | 22.3 | 22.1 | 22.22 | 7160800.0 |
| 2002-09-05 11:30:00 | QQQ | ETF | 22.23 | 22.36 | 22.15 | 22.17 | 5802000.0 |
| 2002-09-05 12:00:00 | QQQ | ETF | 22.15 | 22.22 | 22.03 | 22.15 | 3012300.0 |
| 2002-09-05 12:30:00 | QQQ | ETF | 22.15 | 22.17 | 22.02 | 22.15 | 2638300.0 |
| 2002-09-05 13:00:00 | QQQ | ETF | 22.15 | 22.29 | 22.11 | 22.16 | 3137000.0 |
| 2002-09-05 13:30:00 | QQQ | ETF | 22.16 | 22.28 | 22.04 | 22.04 | 4102300.0 |
| 2002-09-05 14:00:00 | QQQ | ETF | 22.06 | 22.19 | 22.02 | 22.08 | 2971400.0 |
| 2002-09-05 14:30:00 | QQQ | ETF | 22.05 | 22.1 | 21.93 | 22.01 | 5657600.0 |
| 2002-09-05 15:00:00 | QQQ | ETF | 22.01 | 22.1 | 21.96 | 22.05 | 9608800.0 |
| 2002-09-05 15:30:00 | QQQ | ETF | 22.05 | 22.1 | 21.96 | 21.99 | 7406400.0 |
| 2002-09-05 16:00:00 | QQQ | ETF | 21.99 | 22.19 | 21.96 | 22.17 | 1107100.0 |
| 2002-09-05 09:30:00 | IWM | ETF | 38.125 | 38.43 | 38.0 | 38.28 | 129200.0 |
| 2002-09-05 10:00:00 | IWM | ETF | 38.28 | 38.335 | 38.08 | 38.21 | 146200.0 |
| 2002-09-05 10:30:00 | IWM | ETF | 38.21 | 38.355 | 38.18 | 38.355 | 183400.0 |
| 2002-09-05 11:00:00 | IWM | ETF | 38.345 | 38.435 | 38.34 | 38.4 | 191600.0 |
| 2002-09-05 11:30:00 | IWM | ETF | 38.445 | 38.555 | 38.4 | 38.4 | 150800.0 |
| 2002-09-05 12:00:00 | IWM | ETF | 38.4 | 38.5 | 38.34 | 38.5 | 89400.0 |
| 2002-09-05 12:30:00 | IWM | ETF | 38.445 | 38.445 | 38.35 | 38.405 | 20600.0 |
| 2002-09-05 13:00:00 | IWM | ETF | 38.37 | 38.48 | 38.37 | 38.475 | 35000.0 |
| 2002-09-05 13:30:00 | IWM | ETF | 38.47 | 38.5 | 38.3 | 38.305 | 98600.0 |
| 2002-09-05 14:00:00 | IWM | ETF | 38.305 | 38.37 | 38.16 | 38.2 | 97000.0 |
| 2002-09-05 14:30:00 | IWM | ETF | 38.2 | 38.3 | 38.015 | 38.04 | 146200.0 |
| 2002-09-05 15:00:00 | IWM | ETF | 38.015 | 38.15 | 38.015 | 38.065 | 40000.0 |
| 2002-09-05 15:30:00 | IWM | ETF | 38.11 | 38.2 | 38.025 | 38.025 | 132000.0 |
| 2002-09-05 16:00:00 | IWM | ETF | 38.0 | 38.0 | 37.9 | 37.9 | 14200.0 |
| 2002-09-05 09:30:00 | DIA | ETF | 83.13 | 83.25 | 82.75 | 83.05 | 1545400.0 |
| 2002-09-05 10:00:00 | DIA | ETF | 83.05 | 83.22 | 82.26 | 82.43 | 1818500.0 |
| 2002-09-05 10:30:00 | DIA | ETF | 82.46 | 82.95 | 82.36 | 82.95 | 1166300.0 |
| 2002-09-05 11:00:00 | DIA | ETF | 82.88 | 83.65 | 82.88 | 83.48 | 1549500.0 |
| 2002-09-05 11:30:00 | DIA | ETF | 83.48 | 83.92 | 83.38 | 83.38 | 1160400.0 |
| 2002-09-05 12:00:00 | DIA | ETF | 83.38 | 83.58 | 83.18 | 83.43 | 345400.0 |
| 2002-09-05 12:30:00 | DIA | ETF | 83.4 | 83.54 | 83.05 | 83.49 | 511000.0 |
| 2002-09-05 13:00:00 | DIA | ETF | 83.5 | 83.85 | 83.38 | 83.63 | 827000.0 |
> showing 50 of 539 rows — these rows as CSV