PREVIEW / etf_30min / 2004-12-31
file: by_date/etf_30min/2004/2004-12-31.parquet size: 37 KB rows: 1,339
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-12-31 08:00:00 | SPY | ETF | 121.32 | 121.38 | 121.32 | 121.37 | 31600.0 |
| 2004-12-31 08:30:00 | SPY | ETF | 121.38 | 121.38 | 121.28 | 121.29 | 13500.0 |
| 2004-12-31 09:00:00 | SPY | ETF | 121.29 | 121.37 | 121.28 | 121.31 | 134300.0 |
| 2004-12-31 09:30:00 | SPY | ETF | 121.3 | 121.44 | 121.2 | 121.3 | 2229600.0 |
| 2004-12-31 10:00:00 | SPY | ETF | 121.3 | 121.37 | 121.25 | 121.36 | 1321400.0 |
| 2004-12-31 10:30:00 | SPY | ETF | 121.36 | 121.4 | 121.32 | 121.36 | 966600.0 |
| 2004-12-31 11:00:00 | SPY | ETF | 121.36 | 121.38 | 121.28 | 121.3 | 845500.0 |
| 2004-12-31 11:30:00 | SPY | ETF | 121.29 | 121.37 | 121.27 | 121.33 | 949700.0 |
| 2004-12-31 12:00:00 | SPY | ETF | 121.34 | 121.36 | 121.23 | 121.24 | 916600.0 |
| 2004-12-31 12:30:00 | SPY | ETF | 121.24 | 121.25 | 121.16 | 121.18 | 951400.0 |
| 2004-12-31 13:00:00 | SPY | ETF | 121.18 | 121.29 | 121.17 | 121.28 | 793900.0 |
| 2004-12-31 13:30:00 | SPY | ETF | 121.27 | 121.32 | 121.27 | 121.29 | 810000.0 |
| 2004-12-31 14:00:00 | SPY | ETF | 121.3 | 121.5 | 121.29 | 121.45 | 1729000.0 |
| 2004-12-31 14:30:00 | SPY | ETF | 121.45 | 121.66 | 121.42 | 121.48 | 2405900.0 |
| 2004-12-31 15:00:00 | SPY | ETF | 121.48 | 121.54 | 121.45 | 121.47 | 1447200.0 |
| 2004-12-31 15:30:00 | SPY | ETF | 121.47 | 121.49 | 121.03 | 121.04 | 4458700.0 |
| 2004-12-31 16:00:00 | SPY | ETF | 121.04 | 121.11 | 120.77 | 120.83 | 3248900.0 |
| 2004-12-31 16:30:00 | SPY | ETF | 120.85 | 120.93 | 120.85 | 120.85 | 10500.0 |
| 2004-12-31 17:00:00 | SPY | ETF | 120.84 | 120.85 | 120.82 | 120.82 | 7200.0 |
| 2004-12-31 17:30:00 | SPY | ETF | 120.88 | 120.88 | 120.86 | 120.86 | 500.0 |
| 2004-12-31 08:00:00 | QQQ | ETF | 40.037 | 40.05 | 40.02 | 40.04 | 46364.0 |
| 2004-12-31 08:30:00 | QQQ | ETF | 40.03 | 40.05 | 40.025 | 40.03 | 37749.0 |
| 2004-12-31 09:00:00 | QQQ | ETF | 40.03 | 40.05 | 40.02 | 40.04 | 91980.0 |
| 2004-12-31 09:30:00 | QQQ | ETF | 40.03 | 40.11 | 40.0 | 40.0701 | 5752902.0 |
| 2004-12-31 10:00:00 | QQQ | ETF | 40.07 | 40.081 | 40.04 | 40.077 | 2945132.0 |
| 2004-12-31 10:30:00 | QQQ | ETF | 40.07 | 40.121 | 40.06 | 40.08 | 2445253.0 |
| 2004-12-31 11:00:00 | QQQ | ETF | 40.07 | 40.09 | 40.019 | 40.02 | 1677737.0 |
| 2004-12-31 11:30:00 | QQQ | ETF | 40.025 | 40.04 | 40.01 | 40.033 | 1871537.0 |
| 2004-12-31 12:00:00 | QQQ | ETF | 40.04 | 40.07 | 40.01 | 40.013 | 1205232.0 |
| 2004-12-31 12:30:00 | QQQ | ETF | 40.011 | 40.02 | 39.94 | 39.963 | 3035922.0 |
| 2004-12-31 13:00:00 | QQQ | ETF | 39.963 | 40.03 | 39.963 | 40.02 | 1583952.0 |
| 2004-12-31 13:30:00 | QQQ | ETF | 40.02 | 40.06 | 40.019 | 40.041 | 2576544.0 |
| 2004-12-31 14:00:00 | QQQ | ETF | 40.05 | 40.09 | 40.04 | 40.08 | 2130675.0 |
| 2004-12-31 14:30:00 | QQQ | ETF | 40.08 | 40.121 | 40.03 | 40.05 | 3273373.0 |
| 2004-12-31 15:00:00 | QQQ | ETF | 40.05 | 40.075 | 40.026 | 40.055 | 3689415.0 |
| 2004-12-31 15:30:00 | QQQ | ETF | 40.055 | 40.07 | 39.9 | 39.92 | 8328019.0 |
| 2004-12-31 16:00:00 | QQQ | ETF | 39.919 | 39.93 | 39.76 | 39.86 | 1627191.0 |
| 2004-12-31 16:30:00 | QQQ | ETF | 39.86 | 39.92 | 39.86 | 39.91 | 60350.0 |
| 2004-12-31 17:00:00 | QQQ | ETF | 39.91 | 39.91 | 39.84 | 39.87 | 50485.0 |
| 2004-12-31 17:30:00 | QQQ | ETF | 39.87 | 39.88 | 39.84 | 39.85 | 12275.0 |
| 2004-12-31 18:00:00 | QQQ | ETF | 39.87 | 39.89 | 39.86 | 39.89 | 7400.0 |
| 2004-12-31 08:30:00 | IWM | ETF | 64.965 | 64.965 | 64.965 | 64.965 | 1000.0 |
| 2004-12-31 09:00:00 | IWM | ETF | 64.99 | 65.0 | 64.99 | 64.995 | 44200.0 |
| 2004-12-31 09:30:00 | IWM | ETF | 64.94 | 64.975 | 64.745 | 64.815 | 2074600.0 |
| 2004-12-31 10:00:00 | IWM | ETF | 64.81 | 64.87 | 64.8 | 64.86 | 755800.0 |
| 2004-12-31 10:30:00 | IWM | ETF | 64.855 | 64.915 | 64.845 | 64.89 | 598000.0 |
| 2004-12-31 11:00:00 | IWM | ETF | 64.895 | 64.98 | 64.885 | 64.925 | 253600.0 |
| 2004-12-31 11:30:00 | IWM | ETF | 64.92 | 64.995 | 64.915 | 64.975 | 365000.0 |
| 2004-12-31 12:00:00 | IWM | ETF | 64.975 | 65.02 | 64.955 | 65.0 | 676400.0 |
| 2004-12-31 12:30:00 | IWM | ETF | 65.0 | 65.015 | 64.94 | 64.955 | 733200.0 |
> showing 50 of 1,339 rows — these rows as CSV