PREVIEW / etf_30min / 2004-09-09
file: by_date/etf_30min/2004/2004-09-09.parquet size: 35 KB rows: 1,134
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-09-09 08:00:00 | SPY | ETF | 112.25 | 112.56 | 112.25 | 112.5 | 111800.0 |
| 2004-09-09 08:30:00 | SPY | ETF | 112.53 | 112.61 | 112.46 | 112.61 | 30400.0 |
| 2004-09-09 09:00:00 | SPY | ETF | 112.59 | 112.64 | 112.54 | 112.56 | 49900.0 |
| 2004-09-09 09:30:00 | SPY | ETF | 112.57 | 112.78 | 112.48 | 112.53 | 5107000.0 |
| 2004-09-09 10:00:00 | SPY | ETF | 112.54 | 112.54 | 112.35 | 112.45 | 3493700.0 |
| 2004-09-09 10:30:00 | SPY | ETF | 112.45 | 112.55 | 112.24 | 112.4 | 2611400.0 |
| 2004-09-09 11:00:00 | SPY | ETF | 112.4 | 112.43 | 112.1 | 112.14 | 2506900.0 |
| 2004-09-09 11:30:00 | SPY | ETF | 112.14 | 112.16 | 112.03 | 112.13 | 2175100.0 |
| 2004-09-09 12:00:00 | SPY | ETF | 112.13 | 112.29 | 112.07 | 112.2 | 1791900.0 |
| 2004-09-09 12:30:00 | SPY | ETF | 112.21 | 112.4 | 112.08 | 112.4 | 1566900.0 |
| 2004-09-09 13:00:00 | SPY | ETF | 112.4 | 112.68 | 112.31 | 112.57 | 2334000.0 |
| 2004-09-09 13:30:00 | SPY | ETF | 112.57 | 112.68 | 112.42 | 112.5 | 1769600.0 |
| 2004-09-09 14:00:00 | SPY | ETF | 112.51 | 112.65 | 112.4 | 112.58 | 1194000.0 |
| 2004-09-09 14:30:00 | SPY | ETF | 112.57 | 112.88 | 112.45 | 112.84 | 2551900.0 |
| 2004-09-09 15:00:00 | SPY | ETF | 112.87 | 112.87 | 112.58 | 112.59 | 2252700.0 |
| 2004-09-09 15:30:00 | SPY | ETF | 112.6 | 112.66 | 112.43 | 112.5 | 2148600.0 |
| 2004-09-09 16:00:00 | SPY | ETF | 112.5 | 112.53 | 112.4 | 112.45 | 1553400.0 |
| 2004-09-09 16:30:00 | SPY | ETF | 112.44 | 112.47 | 112.4 | 112.43 | 134800.0 |
| 2004-09-09 17:00:00 | SPY | ETF | 112.43 | 112.45 | 112.4 | 112.4 | 19500.0 |
| 2004-09-09 17:30:00 | SPY | ETF | 112.39 | 112.39 | 112.35 | 112.38 | 1800.0 |
| 2004-09-09 18:00:00 | SPY | ETF | 112.45 | 112.45 | 112.45 | 112.45 | 1000.0 |
| 2004-09-09 19:00:00 | SPY | ETF | 112.43 | 112.43 | 112.43 | 112.43 | 1000.0 |
| 2004-09-09 19:30:00 | SPY | ETF | 112.44 | 112.44 | 112.43 | 112.43 | 2000.0 |
| 2004-09-09 08:00:00 | QQQ | ETF | 34.18 | 34.39 | 34.18 | 34.39 | 224200.0 |
| 2004-09-09 08:30:00 | QQQ | ETF | 34.41 | 34.48 | 34.38 | 34.47 | 392500.0 |
| 2004-09-09 09:00:00 | QQQ | ETF | 34.47 | 34.48 | 34.44 | 34.44 | 313600.0 |
| 2004-09-09 09:30:00 | QQQ | ETF | 34.45 | 34.58 | 34.4 | 34.434 | 11639900.0 |
| 2004-09-09 10:00:00 | QQQ | ETF | 34.431 | 34.47 | 34.35 | 34.436 | 7485300.0 |
| 2004-09-09 10:30:00 | QQQ | ETF | 34.438 | 34.47 | 34.311 | 34.37 | 6391900.0 |
| 2004-09-09 11:00:00 | QQQ | ETF | 34.369 | 34.38 | 34.23 | 34.258 | 5495900.0 |
| 2004-09-09 11:30:00 | QQQ | ETF | 34.258 | 34.28 | 34.2 | 34.26 | 5481400.0 |
| 2004-09-09 12:00:00 | QQQ | ETF | 34.25 | 34.35 | 34.14 | 34.162 | 7547300.0 |
| 2004-09-09 12:30:00 | QQQ | ETF | 34.161 | 34.35 | 34.14 | 34.34 | 5823600.0 |
| 2004-09-09 13:00:00 | QQQ | ETF | 34.34 | 34.6 | 34.32 | 34.56 | 10442200.0 |
| 2004-09-09 13:30:00 | QQQ | ETF | 34.55 | 34.62 | 34.47 | 34.5 | 7809900.0 |
| 2004-09-09 14:00:00 | QQQ | ETF | 34.49 | 34.59 | 34.47 | 34.58 | 5183000.0 |
| 2004-09-09 14:30:00 | QQQ | ETF | 34.58 | 34.75 | 34.508 | 34.724 | 9828800.0 |
| 2004-09-09 15:00:00 | QQQ | ETF | 34.725 | 34.75 | 34.61 | 34.62 | 6044900.0 |
| 2004-09-09 15:30:00 | QQQ | ETF | 34.61 | 34.66 | 34.53 | 34.57 | 9061800.0 |
| 2004-09-09 16:00:00 | QQQ | ETF | 34.578 | 34.62 | 34.55 | 34.58 | 1688200.0 |
| 2004-09-09 16:30:00 | QQQ | ETF | 34.58 | 34.59 | 34.57 | 34.58 | 45900.0 |
| 2004-09-09 17:00:00 | QQQ | ETF | 34.59 | 34.59 | 34.54 | 34.54 | 120200.0 |
| 2004-09-09 17:30:00 | QQQ | ETF | 34.57 | 34.6 | 34.56 | 34.6 | 36300.0 |
| 2004-09-09 18:00:00 | QQQ | ETF | 34.6 | 34.6 | 34.575 | 34.58 | 49000.0 |
| 2004-09-09 18:30:00 | QQQ | ETF | 34.6 | 34.6 | 34.6 | 34.6 | 10100.0 |
| 2004-09-09 19:00:00 | QQQ | ETF | 34.58 | 34.58 | 34.58 | 34.58 | 3400.0 |
| 2004-09-09 19:30:00 | QQQ | ETF | 34.6 | 34.6 | 34.59 | 34.59 | 900.0 |
| 2004-09-09 08:30:00 | IWM | ETF | 55.89 | 55.89 | 55.89 | 55.89 | 3000.0 |
| 2004-09-09 09:00:00 | IWM | ETF | 55.94 | 55.94 | 55.835 | 55.835 | 17000.0 |
| 2004-09-09 09:30:00 | IWM | ETF | 55.86 | 56.11 | 55.85 | 56.02 | 1280000.0 |
> showing 50 of 1,134 rows — these rows as CSV