PREVIEW / etf_30min / 2004-12-06
file: by_date/etf_30min/2004/2004-12-06.parquet size: 39 KB rows: 1,334
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-06 08:00:00 | SPY | ETF | 119.23 | 119.23 | 119.09 | 119.12 | 8800.0 |
| 2004-12-06 08:30:00 | SPY | ETF | 119.2 | 119.23 | 119.19 | 119.19 | 10000.0 |
| 2004-12-06 09:00:00 | SPY | ETF | 119.19 | 119.22 | 119.15 | 119.21 | 105400.0 |
| 2004-12-06 09:30:00 | SPY | ETF | 119.21 | 119.27 | 118.89 | 119.09 | 5726600.0 |
| 2004-12-06 10:00:00 | SPY | ETF | 119.08 | 119.1 | 118.86 | 118.99 | 4311200.0 |
| 2004-12-06 10:30:00 | SPY | ETF | 118.99 | 119.23 | 118.99 | 119.06 | 2331300.0 |
| 2004-12-06 11:00:00 | SPY | ETF | 119.05 | 119.08 | 118.84 | 119.07 | 2339900.0 |
| 2004-12-06 11:30:00 | SPY | ETF | 119.07 | 119.09 | 118.97 | 119.08 | 1488500.0 |
| 2004-12-06 12:00:00 | SPY | ETF | 119.08 | 119.32 | 119.02 | 119.26 | 1551500.0 |
| 2004-12-06 12:30:00 | SPY | ETF | 119.27 | 119.43 | 119.18 | 119.24 | 1783900.0 |
| 2004-12-06 13:00:00 | SPY | ETF | 119.23 | 119.27 | 119.2 | 119.23 | 638500.0 |
| 2004-12-06 13:30:00 | SPY | ETF | 119.23 | 119.49 | 119.22 | 119.48 | 1440200.0 |
| 2004-12-06 14:00:00 | SPY | ETF | 119.48 | 119.58 | 119.42 | 119.57 | 1254000.0 |
| 2004-12-06 14:30:00 | SPY | ETF | 119.56 | 119.64 | 119.4 | 119.6 | 1644700.0 |
| 2004-12-06 15:00:00 | SPY | ETF | 119.61 | 119.62 | 119.36 | 119.37 | 2150800.0 |
| 2004-12-06 15:30:00 | SPY | ETF | 119.36 | 119.56 | 119.34 | 119.34 | 2094300.0 |
| 2004-12-06 16:00:00 | SPY | ETF | 119.33 | 119.38 | 119.16 | 119.25 | 1350800.0 |
| 2004-12-06 16:30:00 | SPY | ETF | 119.25 | 119.28 | 119.23 | 119.25 | 103500.0 |
| 2004-12-06 17:00:00 | SPY | ETF | 119.21 | 119.26 | 119.21 | 119.23 | 22800.0 |
| 2004-12-06 17:30:00 | SPY | ETF | 119.21 | 119.21 | 119.2 | 119.2 | 2500.0 |
| 2004-12-06 18:30:00 | SPY | ETF | 119.2 | 119.2 | 119.2 | 119.2 | 2100.0 |
| 2004-12-06 19:30:00 | SPY | ETF | 119.23 | 119.23 | 119.23 | 119.23 | 600.0 |
| 2004-12-06 08:00:00 | QQQ | ETF | 40.09 | 40.115 | 40.01 | 40.05 | 273913.0 |
| 2004-12-06 08:30:00 | QQQ | ETF | 40.05 | 40.083 | 40.04 | 40.079 | 54396.0 |
| 2004-12-06 09:00:00 | QQQ | ETF | 40.08 | 40.14 | 40.04 | 40.12 | 392536.0 |
| 2004-12-06 09:30:00 | QQQ | ETF | 40.12 | 40.15 | 39.98 | 40.05 | 11504462.0 |
| 2004-12-06 10:00:00 | QQQ | ETF | 40.055 | 40.11 | 39.91 | 40.01 | 9594989.0 |
| 2004-12-06 10:30:00 | QQQ | ETF | 40.01 | 40.175 | 40.01 | 40.06 | 6476014.0 |
| 2004-12-06 11:00:00 | QQQ | ETF | 40.06 | 40.125 | 39.96 | 40.1 | 5041541.0 |
| 2004-12-06 11:30:00 | QQQ | ETF | 40.099 | 40.125 | 40.06 | 40.122 | 2307481.0 |
| 2004-12-06 12:00:00 | QQQ | ETF | 40.13 | 40.27 | 40.09 | 40.23 | 4895375.0 |
| 2004-12-06 12:30:00 | QQQ | ETF | 40.23 | 40.31 | 40.22 | 40.23 | 3433968.0 |
| 2004-12-06 13:00:00 | QQQ | ETF | 40.24 | 40.27 | 40.21 | 40.24 | 1819830.0 |
| 2004-12-06 13:30:00 | QQQ | ETF | 40.23 | 40.35 | 40.23 | 40.34 | 3050786.0 |
| 2004-12-06 14:00:00 | QQQ | ETF | 40.34 | 40.375 | 40.289 | 40.36 | 3826959.0 |
| 2004-12-06 14:30:00 | QQQ | ETF | 40.36 | 40.426 | 40.33 | 40.411 | 3224514.0 |
| 2004-12-06 15:00:00 | QQQ | ETF | 40.41 | 40.42 | 40.28 | 40.28 | 4261506.0 |
| 2004-12-06 15:30:00 | QQQ | ETF | 40.28 | 40.4041 | 40.27 | 40.27 | 6716387.0 |
| 2004-12-06 16:00:00 | QQQ | ETF | 40.27 | 40.2935 | 40.17 | 40.22 | 2100919.0 |
| 2004-12-06 16:30:00 | QQQ | ETF | 40.22 | 40.25 | 40.22 | 40.24 | 212308.0 |
| 2004-12-06 17:00:00 | QQQ | ETF | 40.25 | 40.26 | 40.23 | 40.23 | 46921.0 |
| 2004-12-06 17:30:00 | QQQ | ETF | 40.24 | 40.29 | 40.23 | 40.29 | 41000.0 |
| 2004-12-06 18:00:00 | QQQ | ETF | 40.29 | 40.29 | 40.25 | 40.25 | 47470.0 |
| 2004-12-06 08:00:00 | IWM | ETF | 63.805 | 63.805 | 63.775 | 63.805 | 14600.0 |
| 2004-12-06 09:00:00 | IWM | ETF | 63.9 | 63.9 | 63.9 | 63.9 | 1000.0 |
| 2004-12-06 09:30:00 | IWM | ETF | 63.99 | 64.075 | 63.66 | 63.755 | 888600.0 |
| 2004-12-06 10:00:00 | IWM | ETF | 63.755 | 63.795 | 63.645 | 63.705 | 525800.0 |
| 2004-12-06 10:30:00 | IWM | ETF | 63.705 | 63.805 | 63.625 | 63.625 | 698400.0 |
| 2004-12-06 11:00:00 | IWM | ETF | 63.62 | 63.62 | 63.43 | 63.54 | 835600.0 |
| 2004-12-06 11:30:00 | IWM | ETF | 63.535 | 63.6 | 63.51 | 63.6 | 145000.0 |
> showing 50 of 1,334 rows — these rows as CSV