PREVIEW / etf_30min / 2003-12-31
file: by_date/etf_30min/2003/2003-12-31.parquet size: 27 KB rows: 889
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-12-31 08:00:00 | SPY | ETF | 111.23 | 111.27 | 111.23 | 111.27 | 3600.0 |
| 2003-12-31 08:30:00 | SPY | ETF | 111.29 | 111.41 | 111.29 | 111.4 | 52800.0 |
| 2003-12-31 09:00:00 | SPY | ETF | 111.39 | 111.39 | 111.24 | 111.24 | 10900.0 |
| 2003-12-31 09:30:00 | SPY | ETF | 111.22 | 111.52 | 111.22 | 111.36 | 3472800.0 |
| 2003-12-31 10:00:00 | SPY | ETF | 111.37 | 111.45 | 111.06 | 111.16 | 2268400.0 |
| 2003-12-31 10:30:00 | SPY | ETF | 111.15 | 111.19 | 111.04 | 111.12 | 1286600.0 |
| 2003-12-31 11:00:00 | SPY | ETF | 111.12 | 111.21 | 111.01 | 111.07 | 1871500.0 |
| 2003-12-31 11:30:00 | SPY | ETF | 111.08 | 111.14 | 110.97 | 111.09 | 996600.0 |
| 2003-12-31 12:00:00 | SPY | ETF | 111.06 | 111.16 | 111.03 | 111.1 | 463600.0 |
| 2003-12-31 12:30:00 | SPY | ETF | 111.11 | 111.17 | 111.05 | 111.1 | 1096100.0 |
| 2003-12-31 13:00:00 | SPY | ETF | 111.1 | 111.2 | 111.03 | 111.19 | 1932200.0 |
| 2003-12-31 13:30:00 | SPY | ETF | 111.18 | 111.2 | 111.1 | 111.11 | 1010100.0 |
| 2003-12-31 14:00:00 | SPY | ETF | 111.07 | 111.13 | 110.89 | 110.91 | 1113100.0 |
| 2003-12-31 14:30:00 | SPY | ETF | 110.9 | 111.1 | 110.84 | 111.07 | 2311700.0 |
| 2003-12-31 15:00:00 | SPY | ETF | 111.08 | 111.45 | 111.07 | 111.33 | 2993500.0 |
| 2003-12-31 15:30:00 | SPY | ETF | 111.36 | 111.52 | 111.15 | 111.15 | 6014900.0 |
| 2003-12-31 16:00:00 | SPY | ETF | 111.19 | 111.44 | 111.02 | 111.3 | 3163000.0 |
| 2003-12-31 16:30:00 | SPY | ETF | 111.27 | 111.3 | 111.27 | 111.28 | 11600.0 |
| 2003-12-31 17:00:00 | SPY | ETF | 111.26 | 111.27 | 111.26 | 111.26 | 3000.0 |
| 2003-12-31 18:00:00 | SPY | ETF | 111.27 | 111.27 | 111.26 | 111.26 | 1600.0 |
| 2003-12-31 18:30:00 | SPY | ETF | 111.26 | 111.26 | 111.26 | 111.26 | 100.0 |
| 2003-12-31 19:30:00 | SPY | ETF | 111.27 | 111.32 | 111.27 | 111.32 | 2100.0 |
| 2003-12-31 08:00:00 | QQQ | ETF | 36.58 | 36.58 | 36.52 | 36.56 | 11000.0 |
| 2003-12-31 08:30:00 | QQQ | ETF | 36.56 | 36.67 | 36.56 | 36.64 | 115400.0 |
| 2003-12-31 09:00:00 | QQQ | ETF | 36.64 | 36.67 | 36.6 | 36.6 | 88800.0 |
| 2003-12-31 09:30:00 | QQQ | ETF | 36.62 | 36.64 | 36.489 | 36.56 | 5393600.0 |
| 2003-12-31 10:00:00 | QQQ | ETF | 36.56 | 36.58 | 36.37 | 36.42 | 5602000.0 |
| 2003-12-31 10:30:00 | QQQ | ETF | 36.42 | 36.45 | 36.33 | 36.36 | 3706900.0 |
| 2003-12-31 11:00:00 | QQQ | ETF | 36.36 | 36.39 | 36.3 | 36.33 | 4064100.0 |
| 2003-12-31 11:30:00 | QQQ | ETF | 36.33 | 36.36 | 36.25 | 36.29 | 5125300.0 |
| 2003-12-31 12:00:00 | QQQ | ETF | 36.29 | 36.34 | 36.28 | 36.32 | 1828600.0 |
| 2003-12-31 12:30:00 | QQQ | ETF | 36.3 | 36.35 | 36.28 | 36.33 | 1495500.0 |
| 2003-12-31 13:00:00 | QQQ | ETF | 36.328 | 36.4 | 36.31 | 36.39 | 4125300.0 |
| 2003-12-31 13:30:00 | QQQ | ETF | 36.39 | 36.44 | 36.37 | 36.4 | 2841700.0 |
| 2003-12-31 14:00:00 | QQQ | ETF | 36.395 | 36.43 | 36.3 | 36.31 | 2465400.0 |
| 2003-12-31 14:30:00 | QQQ | ETF | 36.31 | 36.42 | 36.28 | 36.4 | 4122000.0 |
| 2003-12-31 15:00:00 | QQQ | ETF | 36.409 | 36.59 | 36.38 | 36.52 | 6393900.0 |
| 2003-12-31 15:30:00 | QQQ | ETF | 36.52 | 36.59 | 36.32 | 36.37 | 6768200.0 |
| 2003-12-31 16:00:00 | QQQ | ETF | 36.35 | 36.47 | 36.31 | 36.43 | 3990200.0 |
| 2003-12-31 16:30:00 | QQQ | ETF | 36.42 | 36.47 | 36.41 | 36.44 | 78800.0 |
| 2003-12-31 17:00:00 | QQQ | ETF | 36.45 | 36.46 | 36.45 | 36.45 | 14200.0 |
| 2003-12-31 17:30:00 | QQQ | ETF | 36.44 | 36.44 | 36.4 | 36.41 | 20900.0 |
| 2003-12-31 18:00:00 | QQQ | ETF | 36.4 | 36.4 | 36.38 | 36.39 | 11100.0 |
| 2003-12-31 18:30:00 | QQQ | ETF | 36.4 | 36.4 | 36.4 | 36.4 | 1000.0 |
| 2003-12-31 19:30:00 | QQQ | ETF | 36.37 | 36.42 | 36.35 | 36.41 | 7900.0 |
| 2003-12-31 09:30:00 | IWM | ETF | 56.325 | 56.495 | 56.05 | 56.195 | 446200.0 |
| 2003-12-31 10:00:00 | IWM | ETF | 56.176 | 56.176 | 55.555 | 55.625 | 1012400.0 |
| 2003-12-31 10:30:00 | IWM | ETF | 55.625 | 55.725 | 55.585 | 55.635 | 635400.0 |
| 2003-12-31 11:00:00 | IWM | ETF | 55.635 | 55.75 | 55.575 | 55.62 | 325800.0 |
| 2003-12-31 11:30:00 | IWM | ETF | 55.65 | 55.73 | 55.63 | 55.725 | 406000.0 |
> showing 50 of 889 rows — these rows as CSV