PREVIEW / etf_30min / 2003-07-30
file: by_date/etf_30min/2003/2003-07-30.parquet size: 22 KB rows: 667
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 |
|---|---|---|---|---|---|---|---|
| 2003-07-30 08:00:00 | SPY | ETF | 99.58 | 99.58 | 99.45 | 99.45 | 33700.0 |
| 2003-07-30 08:30:00 | SPY | ETF | 99.47 | 99.78 | 99.47 | 99.78 | 29200.0 |
| 2003-07-30 09:00:00 | SPY | ETF | 99.77 | 99.8 | 99.61 | 99.65 | 46600.0 |
| 2003-07-30 09:30:00 | SPY | ETF | 99.6 | 99.79 | 99.15 | 99.19 | 3033900.0 |
| 2003-07-30 10:00:00 | SPY | ETF | 99.2 | 99.44 | 99.06 | 99.4 | 2396300.0 |
| 2003-07-30 10:30:00 | SPY | ETF | 99.39 | 99.61 | 99.07 | 99.48 | 2313800.0 |
| 2003-07-30 11:00:00 | SPY | ETF | 99.49 | 99.64 | 99.05 | 99.09 | 2285000.0 |
| 2003-07-30 11:30:00 | SPY | ETF | 99.09 | 99.31 | 98.93 | 99.2 | 1569200.0 |
| 2003-07-30 12:00:00 | SPY | ETF | 99.19 | 99.43 | 99.17 | 99.22 | 817300.0 |
| 2003-07-30 12:30:00 | SPY | ETF | 99.23 | 99.48 | 99.19 | 99.36 | 1540600.0 |
| 2003-07-30 13:00:00 | SPY | ETF | 99.37 | 99.52 | 99.178 | 99.29 | 1047400.0 |
| 2003-07-30 13:30:00 | SPY | ETF | 99.3 | 99.39 | 99.17 | 99.27 | 1109800.0 |
| 2003-07-30 14:00:00 | SPY | ETF | 99.27 | 99.48 | 98.95 | 99.11 | 2994100.0 |
| 2003-07-30 14:30:00 | SPY | ETF | 99.09 | 99.26 | 99.01 | 99.12 | 788600.0 |
| 2003-07-30 15:00:00 | SPY | ETF | 99.11 | 99.28 | 99.0 | 99.19 | 1483500.0 |
| 2003-07-30 15:30:00 | SPY | ETF | 99.17 | 99.25 | 99.05 | 99.11 | 2351100.0 |
| 2003-07-30 16:00:00 | SPY | ETF | 99.094 | 99.19 | 99.05 | 99.1 | 1706300.0 |
| 2003-07-30 16:30:00 | SPY | ETF | 99.1 | 99.16 | 99.07 | 99.13 | 20800.0 |
| 2003-07-30 17:00:00 | SPY | ETF | 99.14 | 99.15 | 99.13 | 99.13 | 1200.0 |
| 2003-07-30 17:30:00 | SPY | ETF | 99.15 | 99.15 | 99.15 | 99.15 | 500.0 |
| 2003-07-30 18:00:00 | SPY | ETF | 99.16 | 99.18 | 99.13 | 99.15 | 52500.0 |
| 2003-07-30 18:30:00 | SPY | ETF | 99.18 | 99.18 | 99.16 | 99.16 | 10400.0 |
| 2003-07-30 19:30:00 | SPY | ETF | 99.15 | 99.15 | 99.15 | 99.15 | 1000.0 |
| 2003-07-30 08:00:00 | QQQ | ETF | 31.71 | 31.71 | 31.65 | 31.67 | 26200.0 |
| 2003-07-30 08:30:00 | QQQ | ETF | 31.64 | 31.78 | 31.64 | 31.78 | 78000.0 |
| 2003-07-30 09:00:00 | QQQ | ETF | 31.78 | 31.79 | 31.7 | 31.7 | 101800.0 |
| 2003-07-30 09:30:00 | QQQ | ETF | 31.71 | 31.74 | 31.45 | 31.49 | 8202100.0 |
| 2003-07-30 10:00:00 | QQQ | ETF | 31.49 | 31.57 | 31.37 | 31.54 | 9255400.0 |
| 2003-07-30 10:30:00 | QQQ | ETF | 31.55 | 31.64 | 31.425 | 31.569 | 3649800.0 |
| 2003-07-30 11:00:00 | QQQ | ETF | 31.54 | 31.62 | 31.42 | 31.44 | 3093200.0 |
| 2003-07-30 11:30:00 | QQQ | ETF | 31.434 | 31.52 | 31.35 | 31.47 | 2680800.0 |
| 2003-07-30 12:00:00 | QQQ | ETF | 31.48 | 31.53 | 31.45 | 31.5 | 1467700.0 |
| 2003-07-30 12:30:00 | QQQ | ETF | 31.48 | 31.58 | 31.46 | 31.52 | 1765900.0 |
| 2003-07-30 13:00:00 | QQQ | ETF | 31.52 | 31.57 | 31.46 | 31.51 | 2309700.0 |
| 2003-07-30 13:30:00 | QQQ | ETF | 31.51 | 31.55 | 31.44 | 31.46 | 1616700.0 |
| 2003-07-30 14:00:00 | QQQ | ETF | 31.46 | 31.58 | 31.38 | 31.44 | 3939200.0 |
| 2003-07-30 14:30:00 | QQQ | ETF | 31.44 | 31.5 | 31.4 | 31.41 | 2471400.0 |
| 2003-07-30 15:00:00 | QQQ | ETF | 31.41 | 31.5 | 31.33 | 31.44 | 3333000.0 |
| 2003-07-30 15:30:00 | QQQ | ETF | 31.43 | 31.451 | 31.38 | 31.41 | 3620800.0 |
| 2003-07-30 16:00:00 | QQQ | ETF | 31.41 | 31.7009 | 31.39 | 31.42 | 2933400.0 |
| 2003-07-30 16:30:00 | QQQ | ETF | 31.43 | 31.43 | 31.4 | 31.42 | 65900.0 |
| 2003-07-30 17:00:00 | QQQ | ETF | 31.41 | 31.43 | 31.4 | 31.43 | 13300.0 |
| 2003-07-30 17:30:00 | QQQ | ETF | 31.44 | 31.45 | 31.43 | 31.45 | 17900.0 |
| 2003-07-30 18:00:00 | QQQ | ETF | 31.42 | 31.436 | 31.42 | 31.42 | 7100.0 |
| 2003-07-30 18:30:00 | QQQ | ETF | 31.43 | 31.45 | 31.43 | 31.45 | 8500.0 |
| 2003-07-30 19:00:00 | QQQ | ETF | 31.45 | 31.46 | 31.43 | 31.43 | 4100.0 |
| 2003-07-30 19:30:00 | QQQ | ETF | 31.45 | 31.45 | 31.4 | 31.4 | 8100.0 |
| 2003-07-30 09:30:00 | IWM | ETF | 47.475 | 47.475 | 47.19 | 47.2 | 191800.0 |
| 2003-07-30 10:00:00 | IWM | ETF | 47.21 | 47.295 | 47.15 | 47.285 | 191200.0 |
| 2003-07-30 10:30:00 | IWM | ETF | 47.275 | 47.325 | 47.135 | 47.135 | 316800.0 |
> showing 50 of 667 rows — these rows as CSV