PREVIEW / etf_30min / 2004-11-24
file: by_date/etf_30min/2004/2004-11-24.parquet size: 37 KB rows: 1,321
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-11-24 08:00:00 | SPY | ETF | 118.44 | 118.48 | 118.43 | 118.45 | 55300.0 |
| 2004-11-24 08:30:00 | SPY | ETF | 118.4 | 118.43 | 118.3 | 118.32 | 57300.0 |
| 2004-11-24 09:00:00 | SPY | ETF | 118.31 | 118.31 | 118.26 | 118.27 | 70600.0 |
| 2004-11-24 09:30:00 | SPY | ETF | 118.27 | 118.59 | 118.18 | 118.18 | 4997700.0 |
| 2004-11-24 10:00:00 | SPY | ETF | 118.22 | 118.42 | 118.19 | 118.26 | 2165500.0 |
| 2004-11-24 10:30:00 | SPY | ETF | 118.26 | 118.39 | 118.07 | 118.32 | 2555800.0 |
| 2004-11-24 11:00:00 | SPY | ETF | 118.32 | 118.4 | 118.15 | 118.38 | 2440900.0 |
| 2004-11-24 11:30:00 | SPY | ETF | 118.4 | 118.44 | 118.34 | 118.37 | 2411500.0 |
| 2004-11-24 12:00:00 | SPY | ETF | 118.38 | 118.42 | 118.28 | 118.33 | 995800.0 |
| 2004-11-24 12:30:00 | SPY | ETF | 118.3315 | 118.35 | 118.23 | 118.27 | 1169100.0 |
| 2004-11-24 13:00:00 | SPY | ETF | 118.27 | 118.37 | 118.16 | 118.35 | 1882500.0 |
| 2004-11-24 13:30:00 | SPY | ETF | 118.35 | 118.42 | 118.15 | 118.2 | 1048000.0 |
| 2004-11-24 14:00:00 | SPY | ETF | 118.2 | 118.34 | 118.16 | 118.31 | 1087300.0 |
| 2004-11-24 14:30:00 | SPY | ETF | 118.31 | 118.44 | 118.27 | 118.35 | 666900.0 |
| 2004-11-24 15:00:00 | SPY | ETF | 118.3362 | 118.53 | 118.29 | 118.48 | 1307700.0 |
| 2004-11-24 15:30:00 | SPY | ETF | 118.48 | 118.55 | 118.3 | 118.54 | 3664800.0 |
| 2004-11-24 16:00:00 | SPY | ETF | 118.54 | 118.55 | 118.352 | 118.44 | 1615800.0 |
| 2004-11-24 16:30:00 | SPY | ETF | 118.44 | 118.44 | 118.38 | 118.39 | 41000.0 |
| 2004-11-24 17:00:00 | SPY | ETF | 118.39 | 118.39 | 118.37 | 118.37 | 3000.0 |
| 2004-11-24 17:30:00 | SPY | ETF | 118.4 | 118.4 | 118.4 | 118.4 | 900.0 |
| 2004-11-24 18:00:00 | SPY | ETF | 118.39 | 118.39 | 118.34 | 118.36 | 4700.0 |
| 2004-11-24 18:30:00 | SPY | ETF | 118.37 | 118.37 | 118.36 | 118.36 | 1000.0 |
| 2004-11-24 19:00:00 | SPY | ETF | 118.45 | 118.45 | 118.41 | 118.41 | 800.0 |
| 2004-11-24 19:30:00 | SPY | ETF | 118.41 | 118.41 | 118.41 | 118.41 | 400.0 |
| 2004-11-24 08:00:00 | QQQ | ETF | 39.17 | 39.17 | 39.15 | 39.16 | 38500.0 |
| 2004-11-24 08:30:00 | QQQ | ETF | 39.16 | 39.17 | 39.1 | 39.1 | 215400.0 |
| 2004-11-24 09:00:00 | QQQ | ETF | 39.1 | 39.11 | 39.09 | 39.09 | 51700.0 |
| 2004-11-24 09:30:00 | QQQ | ETF | 39.1 | 39.27 | 39.09 | 39.11 | 16107900.0 |
| 2004-11-24 10:00:00 | QQQ | ETF | 39.11 | 39.2 | 39.09 | 39.16 | 5762400.0 |
| 2004-11-24 10:30:00 | QQQ | ETF | 39.16 | 39.22 | 39.07 | 39.177 | 7230300.0 |
| 2004-11-24 11:00:00 | QQQ | ETF | 39.18 | 39.3 | 39.15 | 39.29 | 4747900.0 |
| 2004-11-24 11:30:00 | QQQ | ETF | 39.29 | 39.34 | 39.27 | 39.28 | 4915300.0 |
| 2004-11-24 12:00:00 | QQQ | ETF | 39.28 | 39.3 | 39.24 | 39.25 | 2580300.0 |
| 2004-11-24 12:30:00 | QQQ | ETF | 39.26 | 39.261 | 39.21 | 39.23 | 3413100.0 |
| 2004-11-24 13:00:00 | QQQ | ETF | 39.23 | 39.29 | 39.17 | 39.29 | 3511700.0 |
| 2004-11-24 13:30:00 | QQQ | ETF | 39.281 | 39.31 | 39.2 | 39.219 | 1888100.0 |
| 2004-11-24 14:00:00 | QQQ | ETF | 39.22 | 39.27 | 39.19 | 39.25 | 2329700.0 |
| 2004-11-24 14:30:00 | QQQ | ETF | 39.25 | 39.32 | 39.24 | 39.28 | 3158600.0 |
| 2004-11-24 15:00:00 | QQQ | ETF | 39.278 | 39.38 | 39.25 | 39.38 | 4966600.0 |
| 2004-11-24 15:30:00 | QQQ | ETF | 39.369 | 39.39 | 39.28 | 39.36 | 7723600.0 |
| 2004-11-24 16:00:00 | QQQ | ETF | 39.36 | 39.37 | 39.2479 | 39.3 | 2313100.0 |
| 2004-11-24 16:30:00 | QQQ | ETF | 39.29 | 39.3 | 39.27 | 39.28 | 326800.0 |
| 2004-11-24 17:00:00 | QQQ | ETF | 39.28 | 39.29 | 39.27 | 39.28 | 10300.0 |
| 2004-11-24 17:30:00 | QQQ | ETF | 39.28 | 39.3 | 39.28 | 39.29 | 9300.0 |
| 2004-11-24 18:00:00 | QQQ | ETF | 39.3 | 39.301 | 39.29 | 39.3 | 17200.0 |
| 2004-11-24 18:30:00 | QQQ | ETF | 39.3 | 39.32 | 39.3 | 39.32 | 15300.0 |
| 2004-11-24 19:30:00 | QQQ | ETF | 39.31 | 39.31 | 39.31 | 39.31 | 700.0 |
| 2004-11-24 08:00:00 | IWM | ETF | 62.535 | 62.535 | 62.525 | 62.525 | 4000.0 |
| 2004-11-24 08:30:00 | IWM | ETF | 62.505 | 62.565 | 62.47 | 62.48 | 14400.0 |
| 2004-11-24 09:00:00 | IWM | ETF | 62.53 | 62.53 | 62.5 | 62.5 | 4200.0 |
> showing 50 of 1,321 rows — these rows as CSV