PREVIEW / etf_30min / 2003-01-06
file: by_date/etf_30min/2003/2003-01-06.parquet size: 24 KB rows: 686
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-01-06 08:00:00 | SPY | ETF | 91.0 | 91.1 | 91.0 | 91.06 | 14600.0 |
| 2003-01-06 08:30:00 | SPY | ETF | 91.07 | 91.4 | 91.07 | 91.3 | 43900.0 |
| 2003-01-06 09:00:00 | SPY | ETF | 91.27 | 91.29 | 91.2 | 91.2 | 5200.0 |
| 2003-01-06 09:30:00 | SPY | ETF | 91.24 | 91.87 | 91.17 | 91.79 | 4487800.0 |
| 2003-01-06 10:00:00 | SPY | ETF | 91.8 | 92.35 | 91.5 | 92.16 | 6091400.0 |
| 2003-01-06 10:30:00 | SPY | ETF | 92.18 | 92.58 | 92.15 | 92.43 | 2778900.0 |
| 2003-01-06 11:00:00 | SPY | ETF | 92.43 | 92.58 | 92.34 | 92.44 | 1849500.0 |
| 2003-01-06 11:30:00 | SPY | ETF | 92.46 | 92.68 | 92.44 | 92.59 | 1377000.0 |
| 2003-01-06 12:00:00 | SPY | ETF | 92.6 | 92.83 | 92.59 | 92.65 | 1573500.0 |
| 2003-01-06 12:30:00 | SPY | ETF | 92.65 | 92.87 | 92.63 | 92.83 | 1015300.0 |
| 2003-01-06 13:00:00 | SPY | ETF | 92.86 | 93.13 | 92.75 | 93.07 | 1922700.0 |
| 2003-01-06 13:30:00 | SPY | ETF | 93.04 | 93.1 | 92.82 | 92.91 | 2933400.0 |
| 2003-01-06 14:00:00 | SPY | ETF | 92.9 | 93.25 | 92.87 | 93.21 | 1970700.0 |
| 2003-01-06 14:30:00 | SPY | ETF | 93.2 | 93.45 | 93.16 | 93.38 | 2117600.0 |
| 2003-01-06 15:00:00 | SPY | ETF | 93.39 | 93.48 | 93.23 | 93.46 | 2275000.0 |
| 2003-01-06 15:30:00 | SPY | ETF | 93.45 | 93.49 | 93.02 | 93.12 | 3583200.0 |
| 2003-01-06 16:00:00 | SPY | ETF | 93.09 | 93.26 | 92.82 | 92.93 | 2654900.0 |
| 2003-01-06 16:30:00 | SPY | ETF | 92.99 | 93.09 | 92.96 | 93.06 | 38000.0 |
| 2003-01-06 17:00:00 | SPY | ETF | 92.98 | 93.01 | 92.95 | 92.96 | 7300.0 |
| 2003-01-06 17:30:00 | SPY | ETF | 92.96 | 93.03 | 92.96 | 92.96 | 4600.0 |
| 2003-01-06 18:00:00 | SPY | ETF | 92.96 | 93.01 | 92.95 | 93.01 | 10800.0 |
| 2003-01-06 18:30:00 | SPY | ETF | 92.97 | 93.0 | 92.97 | 93.0 | 1200.0 |
| 2003-01-06 19:00:00 | SPY | ETF | 93.0 | 93.0 | 93.0 | 93.0 | 600.0 |
| 2003-01-06 19:30:00 | SPY | ETF | 92.96 | 92.99 | 92.96 | 92.96 | 2200.0 |
| 2003-01-06 08:00:00 | QQQ | ETF | 25.65 | 25.68 | 25.65 | 25.66 | 16000.0 |
| 2003-01-06 08:30:00 | QQQ | ETF | 25.67 | 25.83 | 25.67 | 25.8 | 48700.0 |
| 2003-01-06 09:00:00 | QQQ | ETF | 25.78 | 25.82 | 25.75 | 25.75 | 50300.0 |
| 2003-01-06 09:30:00 | QQQ | ETF | 25.73 | 25.99 | 25.7 | 25.96 | 8331300.0 |
| 2003-01-06 10:00:00 | QQQ | ETF | 25.96 | 26.15 | 25.85 | 26.05 | 8956300.0 |
| 2003-01-06 10:30:00 | QQQ | ETF | 26.08 | 26.22 | 26.04 | 26.19 | 3579300.0 |
| 2003-01-06 11:00:00 | QQQ | ETF | 26.19 | 26.24 | 26.11 | 26.18 | 3103400.0 |
| 2003-01-06 11:30:00 | QQQ | ETF | 26.18 | 26.26 | 26.15 | 26.24 | 3870600.0 |
| 2003-01-06 12:00:00 | QQQ | ETF | 26.25 | 26.32 | 26.21 | 26.27 | 3139300.0 |
| 2003-01-06 12:30:00 | QQQ | ETF | 26.25 | 26.31 | 26.21 | 26.3 | 1530500.0 |
| 2003-01-06 13:00:00 | QQQ | ETF | 26.29 | 26.4 | 26.25 | 26.37 | 2202800.0 |
| 2003-01-06 13:30:00 | QQQ | ETF | 26.37 | 26.43 | 26.31 | 26.36 | 2559400.0 |
| 2003-01-06 14:00:00 | QQQ | ETF | 26.35 | 26.46 | 26.33 | 26.45 | 2267400.0 |
| 2003-01-06 14:30:00 | QQQ | ETF | 26.45 | 26.58 | 26.42 | 26.56 | 5575800.0 |
| 2003-01-06 15:00:00 | QQQ | ETF | 26.56 | 26.59 | 26.45 | 26.56 | 3776500.0 |
| 2003-01-06 15:30:00 | QQQ | ETF | 26.56 | 26.58 | 26.35 | 26.4 | 6616300.0 |
| 2003-01-06 16:00:00 | QQQ | ETF | 26.36 | 26.48 | 26.24 | 26.44 | 6312000.0 |
| 2003-01-06 16:30:00 | QQQ | ETF | 26.44 | 26.5 | 26.36 | 26.41 | 232300.0 |
| 2003-01-06 17:00:00 | QQQ | ETF | 26.38 | 26.41 | 26.34 | 26.4 | 630700.0 |
| 2003-01-06 17:30:00 | QQQ | ETF | 26.39 | 26.4 | 26.36 | 26.38 | 47500.0 |
| 2003-01-06 18:00:00 | QQQ | ETF | 26.39 | 26.42 | 26.38 | 26.42 | 18700.0 |
| 2003-01-06 18:30:00 | QQQ | ETF | 26.43 | 26.45 | 26.42 | 26.44 | 14100.0 |
| 2003-01-06 19:00:00 | QQQ | ETF | 26.44 | 26.44 | 26.35 | 26.36 | 26300.0 |
| 2003-01-06 19:30:00 | QQQ | ETF | 26.38 | 26.39 | 26.34 | 26.38 | 26600.0 |
| 2003-01-06 20:00:00 | QQQ | ETF | 26.38 | 26.38 | 26.38 | 26.38 | 300.0 |
| 2003-01-06 09:30:00 | IWM | ETF | 38.885 | 39.225 | 38.885 | 39.1 | 180400.0 |
> showing 50 of 686 rows — these rows as CSV