PREVIEW / etf_30min / 2004-03-15
file: by_date/etf_30min/2004/2004-03-15.parquet size: 38 KB rows: 1,241
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 |
|---|---|---|---|---|---|---|---|
| 2004-03-15 08:00:00 | SPY | ETF | 112.22 | 112.38 | 112.19 | 112.24 | 64200.0 |
| 2004-03-15 08:30:00 | SPY | ETF | 112.2 | 112.26 | 112.12 | 112.16 | 55700.0 |
| 2004-03-15 09:00:00 | SPY | ETF | 112.19 | 112.31 | 112.14 | 112.24 | 82000.0 |
| 2004-03-15 09:30:00 | SPY | ETF | 112.27 | 112.35 | 112.04 | 112.07 | 5384000.0 |
| 2004-03-15 10:00:00 | SPY | ETF | 112.07 | 112.19 | 111.86 | 112.05 | 4452500.0 |
| 2004-03-15 10:30:00 | SPY | ETF | 112.0 | 112.05 | 111.42 | 111.45 | 4917000.0 |
| 2004-03-15 11:00:00 | SPY | ETF | 111.46 | 111.69 | 111.41 | 111.66 | 3149600.0 |
| 2004-03-15 11:30:00 | SPY | ETF | 111.65 | 111.68 | 111.13 | 111.2 | 4396300.0 |
| 2004-03-15 12:00:00 | SPY | ETF | 111.2 | 111.43 | 111.1 | 111.37 | 4248700.0 |
| 2004-03-15 12:30:00 | SPY | ETF | 111.39 | 111.73 | 111.17 | 111.7 | 3129700.0 |
| 2004-03-15 13:00:00 | SPY | ETF | 111.7 | 111.7 | 111.25 | 111.3 | 2706400.0 |
| 2004-03-15 13:30:00 | SPY | ETF | 111.27 | 111.53 | 111.15 | 111.52 | 2496600.0 |
| 2004-03-15 14:00:00 | SPY | ETF | 111.52 | 111.76 | 111.28 | 111.38 | 3787400.0 |
| 2004-03-15 14:30:00 | SPY | ETF | 111.38 | 111.57 | 111.22 | 111.35 | 2372200.0 |
| 2004-03-15 15:00:00 | SPY | ETF | 111.35 | 111.62 | 111.24 | 111.3 | 2943100.0 |
| 2004-03-15 15:30:00 | SPY | ETF | 111.27 | 111.31 | 110.9 | 111.03 | 6794200.0 |
| 2004-03-15 16:00:00 | SPY | ETF | 111.08 | 111.28 | 111.02 | 111.2 | 1779900.0 |
| 2004-03-15 16:30:00 | SPY | ETF | 111.2 | 111.35 | 111.2 | 111.31 | 103900.0 |
| 2004-03-15 17:00:00 | SPY | ETF | 111.28 | 111.28 | 111.21 | 111.25 | 28800.0 |
| 2004-03-15 17:30:00 | SPY | ETF | 111.26 | 111.26 | 111.25 | 111.25 | 500.0 |
| 2004-03-15 18:00:00 | SPY | ETF | 111.25 | 111.28 | 111.22 | 111.25 | 8600.0 |
| 2004-03-15 18:30:00 | SPY | ETF | 111.24 | 111.28 | 111.22 | 111.28 | 1200.0 |
| 2004-03-15 19:00:00 | SPY | ETF | 111.25 | 111.28 | 111.22 | 111.28 | 7100.0 |
| 2004-03-15 19:30:00 | SPY | ETF | 111.26 | 111.29 | 111.26 | 111.28 | 6700.0 |
| 2004-03-15 08:00:00 | QQQ | ETF | 35.3 | 35.4 | 35.3 | 35.37 | 56100.0 |
| 2004-03-15 08:30:00 | QQQ | ETF | 35.36 | 35.38 | 35.32 | 35.35 | 152800.0 |
| 2004-03-15 09:00:00 | QQQ | ETF | 35.36 | 35.38 | 35.33 | 35.37 | 122600.0 |
| 2004-03-15 09:30:00 | QQQ | ETF | 35.36 | 35.4 | 35.22 | 35.26 | 14091000.0 |
| 2004-03-15 10:00:00 | QQQ | ETF | 35.26 | 35.4 | 35.19 | 35.3 | 10445900.0 |
| 2004-03-15 10:30:00 | QQQ | ETF | 35.31 | 35.35 | 35.07 | 35.089 | 10839900.0 |
| 2004-03-15 11:00:00 | QQQ | ETF | 35.07 | 35.16 | 35.02 | 35.12 | 8827700.0 |
| 2004-03-15 11:30:00 | QQQ | ETF | 35.12 | 35.13 | 34.949 | 34.974 | 6322100.0 |
| 2004-03-15 12:00:00 | QQQ | ETF | 34.97 | 35.06 | 34.92 | 35.009 | 8070200.0 |
| 2004-03-15 12:30:00 | QQQ | ETF | 35.008 | 35.09 | 34.9 | 35.06 | 7052200.0 |
| 2004-03-15 13:00:00 | QQQ | ETF | 35.06 | 35.08 | 34.9 | 34.92 | 4050500.0 |
| 2004-03-15 13:30:00 | QQQ | ETF | 34.921 | 35.01 | 34.9 | 34.978 | 5054200.0 |
| 2004-03-15 14:00:00 | QQQ | ETF | 34.98 | 35.115 | 34.933 | 34.97 | 7891700.0 |
| 2004-03-15 14:30:00 | QQQ | ETF | 34.97 | 35.065 | 34.89 | 34.979 | 5218200.0 |
| 2004-03-15 15:00:00 | QQQ | ETF | 34.977 | 35.051 | 34.92 | 34.93 | 6267100.0 |
| 2004-03-15 15:30:00 | QQQ | ETF | 34.95 | 34.96 | 34.81 | 34.83 | 15323000.0 |
| 2004-03-15 16:00:00 | QQQ | ETF | 34.83 | 34.945 | 34.82 | 34.88 | 2096500.0 |
| 2004-03-15 16:30:00 | QQQ | ETF | 34.89 | 34.918 | 34.88 | 34.905 | 157200.0 |
| 2004-03-15 17:00:00 | QQQ | ETF | 34.899 | 34.9 | 34.867 | 34.876 | 52900.0 |
| 2004-03-15 17:30:00 | QQQ | ETF | 34.871 | 34.91 | 34.87 | 34.88 | 42300.0 |
| 2004-03-15 18:00:00 | QQQ | ETF | 34.883 | 34.93 | 34.88 | 34.93 | 24900.0 |
| 2004-03-15 18:30:00 | QQQ | ETF | 34.93 | 34.93 | 34.89 | 34.92 | 3500.0 |
| 2004-03-15 19:00:00 | QQQ | ETF | 34.92 | 34.94 | 34.9 | 34.94 | 12800.0 |
| 2004-03-15 19:30:00 | QQQ | ETF | 34.92 | 34.92 | 34.91 | 34.91 | 700.0 |
| 2004-03-15 08:00:00 | IWM | ETF | 57.83 | 57.83 | 57.8 | 57.8 | 10000.0 |
| 2004-03-15 08:30:00 | IWM | ETF | 57.875 | 57.875 | 57.875 | 57.875 | 3000.0 |
> showing 50 of 1,241 rows — these rows as CSV