PREVIEW / etf_30min / 2001-10-12
file: by_date/etf_30min/2001/2001-10-12.parquet size: 17 KB rows: 431
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-10-12 09:30:00 | SPY | ETF | 109.15 | 109.89 | 108.75 | 109.05 | 6271200.0 |
| 2001-10-12 10:00:00 | SPY | ETF | 109.08 | 109.66 | 108.92 | 109.59 | 2559400.0 |
| 2001-10-12 10:30:00 | SPY | ETF | 109.65 | 109.7 | 108.95 | 109.18 | 1240700.0 |
| 2001-10-12 11:00:00 | SPY | ETF | 109.16 | 109.46 | 109.14 | 109.26 | 598000.0 |
| 2001-10-12 11:30:00 | SPY | ETF | 109.24 | 109.34 | 107.6 | 108.31 | 4046400.0 |
| 2001-10-12 12:00:00 | SPY | ETF | 108.42 | 108.5 | 107.61 | 108.05 | 2978300.0 |
| 2001-10-12 12:30:00 | SPY | ETF | 108.1 | 108.55 | 107.3 | 107.65 | 2507900.0 |
| 2001-10-12 13:00:00 | SPY | ETF | 107.72 | 107.89 | 107.5 | 107.8 | 968700.0 |
| 2001-10-12 13:30:00 | SPY | ETF | 107.81 | 108.05 | 107.6 | 107.9 | 612000.0 |
| 2001-10-12 14:00:00 | SPY | ETF | 107.94 | 108.38 | 107.76 | 108.19 | 934300.0 |
| 2001-10-12 14:30:00 | SPY | ETF | 108.2 | 108.79 | 108.07 | 108.7 | 1402600.0 |
| 2001-10-12 15:00:00 | SPY | ETF | 108.7 | 109.1 | 108.27 | 109.1 | 2071900.0 |
| 2001-10-12 15:30:00 | SPY | ETF | 109.07 | 109.55 | 108.88 | 109.52 | 2518700.0 |
| 2001-10-12 16:00:00 | SPY | ETF | 109.45 | 109.67 | 109.05 | 109.4 | 1094900.0 |
| 2001-10-12 16:30:00 | SPY | ETF | 109.45 | 109.49 | 109.3 | 109.49 | 5700.0 |
| 2001-10-12 17:00:00 | SPY | ETF | 109.2 | 109.3 | 108.95 | 109.1 | 4400.0 |
| 2001-10-12 17:30:00 | SPY | ETF | 109.1 | 109.1 | 109.0 | 109.0 | 500.0 |
| 2001-10-12 18:00:00 | SPY | ETF | 109.01 | 109.01 | 109.0 | 109.0 | 2000.0 |
| 2001-10-12 09:30:00 | QQQ | ETF | 34.33 | 34.75 | 33.91 | 34.28 | 24611400.0 |
| 2001-10-12 10:00:00 | QQQ | ETF | 34.31 | 34.75 | 34.25 | 34.7 | 9856300.0 |
| 2001-10-12 10:30:00 | QQQ | ETF | 34.7 | 34.79 | 34.33 | 34.45 | 6642600.0 |
| 2001-10-12 11:00:00 | QQQ | ETF | 34.48 | 34.58 | 34.26 | 34.33 | 4200100.0 |
| 2001-10-12 11:30:00 | QQQ | ETF | 34.33 | 34.38 | 33.35 | 33.7 | 13080900.0 |
| 2001-10-12 12:00:00 | QQQ | ETF | 33.7 | 33.9 | 33.43 | 33.59 | 8326200.0 |
| 2001-10-12 12:30:00 | QQQ | ETF | 33.64 | 33.9 | 33.14 | 33.31 | 6984600.0 |
| 2001-10-12 13:00:00 | QQQ | ETF | 33.31 | 33.61 | 33.26 | 33.6 | 3496400.0 |
| 2001-10-12 13:30:00 | QQQ | ETF | 33.6 | 33.66 | 33.34 | 33.54 | 2093500.0 |
| 2001-10-12 14:00:00 | QQQ | ETF | 33.55 | 33.85 | 33.49 | 33.8 | 3826200.0 |
| 2001-10-12 14:30:00 | QQQ | ETF | 33.79 | 34.15 | 33.68 | 34.12 | 6341000.0 |
| 2001-10-12 15:00:00 | QQQ | ETF | 34.14 | 34.45 | 33.86 | 34.4 | 5946900.0 |
| 2001-10-12 15:30:00 | QQQ | ETF | 34.4 | 34.76 | 34.3 | 34.71 | 8872500.0 |
| 2001-10-12 16:00:00 | QQQ | ETF | 34.71 | 34.74 | 33.97 | 34.46 | 3480600.0 |
| 2001-10-12 16:30:00 | QQQ | ETF | 34.46 | 34.55 | 34.45 | 34.54 | 39600.0 |
| 2001-10-12 17:00:00 | QQQ | ETF | 34.54 | 34.59 | 34.45 | 34.5 | 31400.0 |
| 2001-10-12 17:30:00 | QQQ | ETF | 34.5 | 34.5 | 34.46 | 34.46 | 2500.0 |
| 2001-10-12 18:00:00 | QQQ | ETF | 34.48 | 34.48 | 34.45 | 34.46 | 7100.0 |
| 2001-10-12 09:30:00 | IWM | ETF | 42.56 | 42.79 | 42.35 | 42.625 | 121200.0 |
| 2001-10-12 10:00:00 | IWM | ETF | 42.6 | 42.74 | 42.565 | 42.6 | 10400.0 |
| 2001-10-12 10:30:00 | IWM | ETF | 42.71 | 42.71 | 42.7 | 42.7 | 14400.0 |
| 2001-10-12 11:00:00 | IWM | ETF | 42.64 | 42.75 | 42.635 | 42.65 | 23000.0 |
| 2001-10-12 11:30:00 | IWM | ETF | 42.635 | 42.635 | 41.9 | 42.165 | 44400.0 |
| 2001-10-12 12:00:00 | IWM | ETF | 42.15 | 42.2 | 42.07 | 42.07 | 60800.0 |
| 2001-10-12 12:30:00 | IWM | ETF | 42.075 | 42.15 | 42.05 | 42.05 | 25800.0 |
| 2001-10-12 13:00:00 | IWM | ETF | 41.995 | 42.095 | 41.995 | 42.085 | 2200.0 |
| 2001-10-12 13:30:00 | IWM | ETF | 42.065 | 42.1 | 42.035 | 42.04 | 23800.0 |
| 2001-10-12 14:00:00 | IWM | ETF | 42.06 | 42.235 | 42.06 | 42.185 | 1200.0 |
| 2001-10-12 14:30:00 | IWM | ETF | 42.295 | 42.89 | 42.265 | 42.425 | 10800.0 |
| 2001-10-12 15:00:00 | IWM | ETF | 42.425 | 42.475 | 42.41 | 42.44 | 17200.0 |
| 2001-10-12 15:30:00 | IWM | ETF | 42.58 | 42.765 | 42.5 | 42.61 | 77400.0 |
| 2001-10-12 16:00:00 | IWM | ETF | 42.7 | 42.7 | 42.55 | 42.55 | 34000.0 |
> showing 50 of 431 rows — these rows as CSV