PREVIEW / etf_30min / 2004-12-30
file: by_date/etf_30min/2004/2004-12-30.parquet size: 36 KB rows: 1,324
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-30 08:00:00 | SPY | ETF | 121.33 | 121.37 | 121.33 | 121.37 | 5800.0 |
| 2004-12-30 08:30:00 | SPY | ETF | 121.41 | 121.49 | 121.41 | 121.44 | 12000.0 |
| 2004-12-30 09:00:00 | SPY | ETF | 121.44 | 121.44 | 121.35 | 121.39 | 9200.0 |
| 2004-12-30 09:30:00 | SPY | ETF | 121.4 | 121.49 | 121.29 | 121.36 | 2299600.0 |
| 2004-12-30 10:00:00 | SPY | ETF | 121.36 | 121.56 | 121.28 | 121.46 | 3112500.0 |
| 2004-12-30 10:30:00 | SPY | ETF | 121.46 | 121.49 | 121.36 | 121.4 | 904200.0 |
| 2004-12-30 11:00:00 | SPY | ETF | 121.41 | 121.41 | 121.29 | 121.37 | 1928400.0 |
| 2004-12-30 11:30:00 | SPY | ETF | 121.37 | 121.41 | 121.32 | 121.39 | 1284900.0 |
| 2004-12-30 12:00:00 | SPY | ETF | 121.39 | 121.4 | 121.33 | 121.37 | 448000.0 |
| 2004-12-30 12:30:00 | SPY | ETF | 121.36 | 121.43 | 121.36 | 121.4 | 829000.0 |
| 2004-12-30 13:00:00 | SPY | ETF | 121.4 | 121.51 | 121.37 | 121.48 | 822900.0 |
| 2004-12-30 13:30:00 | SPY | ETF | 121.49 | 121.55 | 121.43 | 121.51 | 927900.0 |
| 2004-12-30 14:00:00 | SPY | ETF | 121.51 | 121.57 | 121.47 | 121.49 | 878000.0 |
| 2004-12-30 14:30:00 | SPY | ETF | 121.48 | 121.57 | 121.48 | 121.53 | 590300.0 |
| 2004-12-30 15:00:00 | SPY | ETF | 121.53 | 121.55 | 121.44 | 121.45 | 1150000.0 |
| 2004-12-30 15:30:00 | SPY | ETF | 121.45 | 121.53 | 121.21 | 121.23 | 2393100.0 |
| 2004-12-30 16:00:00 | SPY | ETF | 121.24 | 121.48 | 121.04 | 121.19 | 1341600.0 |
| 2004-12-30 16:30:00 | SPY | ETF | 121.17 | 121.25 | 121.17 | 121.24 | 42700.0 |
| 2004-12-30 17:00:00 | SPY | ETF | 121.24 | 121.24 | 121.2 | 121.2 | 15800.0 |
| 2004-12-30 17:30:00 | SPY | ETF | 121.2 | 121.21 | 121.19 | 121.2 | 1500.0 |
| 2004-12-30 18:00:00 | SPY | ETF | 121.21 | 121.21 | 121.21 | 121.21 | 300.0 |
| 2004-12-30 18:30:00 | SPY | ETF | 121.22 | 121.22 | 121.19 | 121.2 | 2300.0 |
| 2004-12-30 19:00:00 | SPY | ETF | 121.23 | 121.23 | 121.23 | 121.23 | 400.0 |
| 2004-12-30 08:00:00 | QQQ | ETF | 40.06 | 40.11 | 40.05 | 40.1 | 147233.0 |
| 2004-12-30 08:30:00 | QQQ | ETF | 40.1 | 40.15 | 40.07 | 40.071 | 530355.0 |
| 2004-12-30 09:00:00 | QQQ | ETF | 40.09 | 40.1 | 40.05 | 40.07 | 41280.0 |
| 2004-12-30 09:30:00 | QQQ | ETF | 40.07 | 40.11 | 40.02 | 40.068 | 4082191.0 |
| 2004-12-30 10:00:00 | QQQ | ETF | 40.07 | 40.123 | 40.02 | 40.085 | 5349580.0 |
| 2004-12-30 10:30:00 | QQQ | ETF | 40.09 | 40.105 | 39.995 | 40.02 | 3818997.0 |
| 2004-12-30 11:00:00 | QQQ | ETF | 40.02 | 40.02 | 39.93 | 39.98 | 5328252.0 |
| 2004-12-30 11:30:00 | QQQ | ETF | 39.97 | 40.0001 | 39.97 | 39.997 | 1459271.0 |
| 2004-12-30 12:00:00 | QQQ | ETF | 39.996 | 40.0 | 39.97 | 39.98 | 745487.0 |
| 2004-12-30 12:30:00 | QQQ | ETF | 39.98 | 40.011 | 39.975 | 39.992 | 1771360.0 |
| 2004-12-30 13:00:00 | QQQ | ETF | 39.99 | 40.04 | 39.98 | 40.035 | 992045.0 |
| 2004-12-30 13:30:00 | QQQ | ETF | 40.04 | 40.09 | 40.02 | 40.077 | 1866222.0 |
| 2004-12-30 14:00:00 | QQQ | ETF | 40.071 | 40.085 | 40.03 | 40.05 | 1938982.0 |
| 2004-12-30 14:30:00 | QQQ | ETF | 40.05 | 40.08 | 40.04 | 40.07 | 2090021.0 |
| 2004-12-30 15:00:00 | QQQ | ETF | 40.07 | 40.08 | 40.03 | 40.03 | 3466416.0 |
| 2004-12-30 15:30:00 | QQQ | ETF | 40.03 | 40.08 | 39.95 | 39.95 | 4118729.0 |
| 2004-12-30 16:00:00 | QQQ | ETF | 39.97 | 39.99 | 39.882 | 39.94 | 2001962.0 |
| 2004-12-30 16:30:00 | QQQ | ETF | 39.937 | 40.05 | 39.937 | 40.02 | 152491.0 |
| 2004-12-30 17:00:00 | QQQ | ETF | 40.013 | 40.02 | 39.99 | 40.01 | 12700.0 |
| 2004-12-30 17:30:00 | QQQ | ETF | 40.0 | 40.0 | 39.99 | 39.99 | 7860.0 |
| 2004-12-30 18:00:00 | QQQ | ETF | 39.98 | 40.01 | 39.98 | 40.01 | 10700.0 |
| 2004-12-30 08:30:00 | IWM | ETF | 65.08 | 65.09 | 65.08 | 65.09 | 2400.0 |
| 2004-12-30 09:00:00 | IWM | ETF | 65.12 | 65.135 | 65.115 | 65.115 | 15000.0 |
| 2004-12-30 09:30:00 | IWM | ETF | 65.105 | 65.175 | 65.05 | 65.135 | 1033000.0 |
| 2004-12-30 10:00:00 | IWM | ETF | 65.135 | 65.2 | 65.05 | 65.15 | 482400.0 |
| 2004-12-30 10:30:00 | IWM | ETF | 65.145 | 65.175 | 65.08 | 65.11 | 172800.0 |
| 2004-12-30 11:00:00 | IWM | ETF | 65.105 | 65.105 | 65.01 | 65.06 | 808600.0 |
> showing 50 of 1,324 rows — these rows as CSV