PREVIEW / etf_30min / 2004-12-03
file: by_date/etf_30min/2004/2004-12-03.parquet size: 40 KB rows: 1,365
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-03 08:00:00 | SPY | ETF | 119.88 | 119.95 | 119.63 | 119.63 | 138600.0 |
| 2004-12-03 08:30:00 | SPY | ETF | 119.61 | 119.61 | 118.91 | 119.33 | 881900.0 |
| 2004-12-03 09:00:00 | SPY | ETF | 119.34 | 119.49 | 119.27 | 119.35 | 235500.0 |
| 2004-12-03 09:30:00 | SPY | ETF | 119.31 | 119.83 | 119.18 | 119.79 | 6583200.0 |
| 2004-12-03 10:00:00 | SPY | ETF | 119.8 | 120.14 | 119.31 | 119.44 | 9209500.0 |
| 2004-12-03 10:30:00 | SPY | ETF | 119.44 | 119.62 | 119.25 | 119.53 | 4636800.0 |
| 2004-12-03 11:00:00 | SPY | ETF | 119.52 | 119.78 | 119.52 | 119.63 | 2556200.0 |
| 2004-12-03 11:30:00 | SPY | ETF | 119.66 | 119.81 | 119.6 | 119.72 | 2136600.0 |
| 2004-12-03 12:00:00 | SPY | ETF | 119.73 | 119.82 | 119.64 | 119.73 | 1397200.0 |
| 2004-12-03 12:30:00 | SPY | ETF | 119.74 | 119.74 | 119.35 | 119.35 | 2448400.0 |
| 2004-12-03 13:00:00 | SPY | ETF | 119.35 | 119.46 | 119.09 | 119.39 | 3296500.0 |
| 2004-12-03 13:30:00 | SPY | ETF | 119.38 | 119.41 | 119.26 | 119.3 | 1263600.0 |
| 2004-12-03 14:00:00 | SPY | ETF | 119.31 | 119.49 | 119.2 | 119.41 | 1951800.0 |
| 2004-12-03 14:30:00 | SPY | ETF | 119.41 | 119.45 | 119.22 | 119.34 | 1724200.0 |
| 2004-12-03 15:00:00 | SPY | ETF | 119.34 | 119.55 | 119.33 | 119.5 | 2245400.0 |
| 2004-12-03 15:30:00 | SPY | ETF | 119.5 | 119.63 | 119.4 | 119.43 | 4187800.0 |
| 2004-12-03 16:00:00 | SPY | ETF | 119.45 | 119.55 | 119.18 | 119.35 | 2253700.0 |
| 2004-12-03 16:30:00 | SPY | ETF | 119.34 | 119.35 | 119.2 | 119.22 | 63800.0 |
| 2004-12-03 17:00:00 | SPY | ETF | 119.22 | 119.22 | 119.2 | 119.2 | 600.0 |
| 2004-12-03 17:30:00 | SPY | ETF | 119.28 | 119.33 | 119.19 | 119.33 | 4200.0 |
| 2004-12-03 18:00:00 | SPY | ETF | 119.25 | 119.25 | 119.24 | 119.24 | 1000.0 |
| 2004-12-03 19:30:00 | SPY | ETF | 119.25 | 119.25 | 119.25 | 119.25 | 4500.0 |
| 2004-12-03 08:00:00 | QQQ | ETF | 40.41 | 40.52 | 40.4 | 40.43 | 2409270.0 |
| 2004-12-03 08:30:00 | QQQ | ETF | 40.4 | 40.49 | 40.22 | 40.29 | 2812616.0 |
| 2004-12-03 09:00:00 | QQQ | ETF | 40.29 | 40.37 | 40.2 | 40.307 | 1001555.0 |
| 2004-12-03 09:30:00 | QQQ | ETF | 40.31 | 40.48 | 40.209 | 40.46 | 15285783.0 |
| 2004-12-03 10:00:00 | QQQ | ETF | 40.456 | 40.59 | 40.176 | 40.24 | 18622500.0 |
| 2004-12-03 10:30:00 | QQQ | ETF | 40.24 | 40.29 | 40.08 | 40.21 | 12027492.0 |
| 2004-12-03 11:00:00 | QQQ | ETF | 40.209 | 40.38 | 40.2 | 40.285 | 10523557.0 |
| 2004-12-03 11:30:00 | QQQ | ETF | 40.29 | 40.39 | 40.28 | 40.33 | 3645271.0 |
| 2004-12-03 12:00:00 | QQQ | ETF | 40.33 | 40.38 | 40.298 | 40.311 | 3539181.0 |
| 2004-12-03 12:30:00 | QQQ | ETF | 40.317 | 40.34 | 40.198 | 40.2 | 4419081.0 |
| 2004-12-03 13:00:00 | QQQ | ETF | 40.202 | 40.3 | 40.13 | 40.244 | 6627318.0 |
| 2004-12-03 13:30:00 | QQQ | ETF | 40.244 | 40.25 | 40.17 | 40.18 | 3434536.0 |
| 2004-12-03 14:00:00 | QQQ | ETF | 40.18 | 40.28 | 40.13 | 40.24 | 4534978.0 |
| 2004-12-03 14:30:00 | QQQ | ETF | 40.242 | 40.26 | 40.15 | 40.173 | 4498473.0 |
| 2004-12-03 15:00:00 | QQQ | ETF | 40.18 | 40.26 | 40.17 | 40.25 | 3628159.0 |
| 2004-12-03 15:30:00 | QQQ | ETF | 40.254 | 40.294 | 40.121 | 40.14 | 8252693.0 |
| 2004-12-03 16:00:00 | QQQ | ETF | 40.13 | 40.224 | 40.0075 | 40.03 | 3386647.0 |
| 2004-12-03 16:30:00 | QQQ | ETF | 40.03 | 40.1411 | 40.03 | 40.051 | 1600393.0 |
| 2004-12-03 17:00:00 | QQQ | ETF | 40.06 | 40.08 | 40.06 | 40.08 | 13170.0 |
| 2004-12-03 17:30:00 | QQQ | ETF | 40.08 | 40.08 | 40.07 | 40.08 | 14645.0 |
| 2004-12-03 18:00:00 | QQQ | ETF | 40.08 | 40.11 | 40.07 | 40.1 | 27784.0 |
| 2004-12-03 08:30:00 | IWM | ETF | 64.205 | 64.205 | 63.9 | 63.93 | 63800.0 |
| 2004-12-03 09:00:00 | IWM | ETF | 63.93 | 63.995 | 63.9 | 63.995 | 57200.0 |
| 2004-12-03 09:30:00 | IWM | ETF | 63.955 | 64.195 | 63.845 | 64.195 | 2929400.0 |
| 2004-12-03 10:00:00 | IWM | ETF | 64.195 | 64.41 | 63.96 | 64.065 | 2602200.0 |
| 2004-12-03 10:30:00 | IWM | ETF | 64.015 | 64.115 | 63.94 | 64.04 | 994800.0 |
| 2004-12-03 11:00:00 | IWM | ETF | 64.055 | 64.185 | 64.02 | 64.105 | 308400.0 |
| 2004-12-03 11:30:00 | IWM | ETF | 64.09 | 64.22 | 64.09 | 64.12 | 307800.0 |
> showing 50 of 1,365 rows — these rows as CSV