PREVIEW / etf_30min / 2003-12-22
file: by_date/etf_30min/2003/2003-12-22.parquet size: 27 KB rows: 887
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 |
|---|---|---|---|---|---|---|---|
| 2003-12-22 08:00:00 | SPY | ETF | 108.67 | 108.72 | 108.67 | 108.71 | 16300.0 |
| 2003-12-22 08:30:00 | SPY | ETF | 108.72 | 108.78 | 108.72 | 108.74 | 15100.0 |
| 2003-12-22 09:00:00 | SPY | ETF | 108.74 | 108.82 | 108.73 | 108.74 | 15900.0 |
| 2003-12-22 09:30:00 | SPY | ETF | 108.8 | 109.4 | 108.78 | 109.29 | 4806000.0 |
| 2003-12-22 10:00:00 | SPY | ETF | 109.29 | 109.35 | 109.13 | 109.17 | 3093700.0 |
| 2003-12-22 10:30:00 | SPY | ETF | 109.17 | 109.22 | 109.08 | 109.19 | 2456800.0 |
| 2003-12-22 11:00:00 | SPY | ETF | 109.19 | 109.23 | 108.87 | 108.97 | 1681400.0 |
| 2003-12-22 11:30:00 | SPY | ETF | 108.95 | 109.08 | 108.93 | 109.03 | 1646900.0 |
| 2003-12-22 12:00:00 | SPY | ETF | 109.05 | 109.05 | 108.88 | 108.91 | 2151800.0 |
| 2003-12-22 12:30:00 | SPY | ETF | 108.91 | 109.09 | 108.88 | 109.01 | 875900.0 |
| 2003-12-22 13:00:00 | SPY | ETF | 109.01 | 109.08 | 108.93 | 108.99 | 425300.0 |
| 2003-12-22 13:30:00 | SPY | ETF | 108.98 | 109.15 | 108.98 | 109.15 | 907100.0 |
| 2003-12-22 14:00:00 | SPY | ETF | 109.15 | 109.27 | 109.08 | 109.12 | 1867400.0 |
| 2003-12-22 14:30:00 | SPY | ETF | 109.12 | 109.16 | 109.02 | 109.13 | 625000.0 |
| 2003-12-22 15:00:00 | SPY | ETF | 109.17 | 109.33 | 109.11 | 109.3 | 1130200.0 |
| 2003-12-22 15:30:00 | SPY | ETF | 109.31 | 109.47 | 109.18 | 109.46 | 1869300.0 |
| 2003-12-22 16:00:00 | SPY | ETF | 109.47 | 109.68 | 109.43 | 109.64 | 954800.0 |
| 2003-12-22 16:30:00 | SPY | ETF | 109.64 | 109.64 | 109.56 | 109.62 | 49500.0 |
| 2003-12-22 17:00:00 | SPY | ETF | 109.64 | 109.66 | 109.421 | 109.59 | 204800.0 |
| 2003-12-22 17:30:00 | SPY | ETF | 109.58 | 109.59 | 109.52 | 109.55 | 12500.0 |
| 2003-12-22 18:00:00 | SPY | ETF | 109.54 | 109.56 | 109.54 | 109.56 | 1800.0 |
| 2003-12-22 19:00:00 | SPY | ETF | 109.59 | 109.59 | 109.56 | 109.56 | 1100.0 |
| 2003-12-22 19:30:00 | SPY | ETF | 109.58 | 109.65 | 109.58 | 109.6 | 2900.0 |
| 2003-12-22 08:00:00 | QQQ | ETF | 35.25 | 35.33 | 35.25 | 35.32 | 27900.0 |
| 2003-12-22 08:30:00 | QQQ | ETF | 35.34 | 35.35 | 35.33 | 35.35 | 36500.0 |
| 2003-12-22 09:00:00 | QQQ | ETF | 35.35 | 35.37 | 35.35 | 35.37 | 72900.0 |
| 2003-12-22 09:30:00 | QQQ | ETF | 35.35 | 35.68 | 35.33 | 35.58 | 12439300.0 |
| 2003-12-22 10:00:00 | QQQ | ETF | 35.588 | 35.64 | 35.5 | 35.55 | 9360300.0 |
| 2003-12-22 10:30:00 | QQQ | ETF | 35.56 | 35.57 | 35.41 | 35.487 | 3273300.0 |
| 2003-12-22 11:00:00 | QQQ | ETF | 35.486 | 35.51 | 35.32 | 35.403 | 3700100.0 |
| 2003-12-22 11:30:00 | QQQ | ETF | 35.403 | 35.47 | 35.38 | 35.44 | 2386600.0 |
| 2003-12-22 12:00:00 | QQQ | ETF | 35.44 | 35.46 | 35.29 | 35.31 | 3636200.0 |
| 2003-12-22 12:30:00 | QQQ | ETF | 35.32 | 35.41 | 35.3 | 35.377 | 1659400.0 |
| 2003-12-22 13:00:00 | QQQ | ETF | 35.373 | 35.43 | 35.35 | 35.37 | 1899300.0 |
| 2003-12-22 13:30:00 | QQQ | ETF | 35.38 | 35.48 | 35.37 | 35.47 | 2257700.0 |
| 2003-12-22 14:00:00 | QQQ | ETF | 35.48 | 35.5 | 35.38 | 35.407 | 2485900.0 |
| 2003-12-22 14:30:00 | QQQ | ETF | 35.41 | 35.44 | 35.33 | 35.43 | 1978700.0 |
| 2003-12-22 15:00:00 | QQQ | ETF | 35.42 | 35.52 | 35.4 | 35.48 | 3697300.0 |
| 2003-12-22 15:30:00 | QQQ | ETF | 35.5 | 35.59 | 35.43 | 35.58 | 4545200.0 |
| 2003-12-22 16:00:00 | QQQ | ETF | 35.576 | 35.607 | 35.52 | 35.52 | 1638300.0 |
| 2003-12-22 16:30:00 | QQQ | ETF | 35.55 | 35.6 | 35.532 | 35.6 | 125700.0 |
| 2003-12-22 17:00:00 | QQQ | ETF | 35.58 | 35.61 | 35.58 | 35.581 | 52500.0 |
| 2003-12-22 17:30:00 | QQQ | ETF | 35.57 | 35.597 | 35.57 | 35.58 | 16500.0 |
| 2003-12-22 18:00:00 | QQQ | ETF | 35.58 | 35.6 | 35.57 | 35.6 | 15300.0 |
| 2003-12-22 19:00:00 | QQQ | ETF | 35.59 | 35.6 | 35.59 | 35.6 | 4000.0 |
| 2003-12-22 19:30:00 | QQQ | ETF | 35.6 | 35.6 | 35.6 | 35.6 | 500.0 |
| 2003-12-22 20:00:00 | QQQ | ETF | 35.61 | 35.61 | 35.61 | 35.61 | 1200.0 |
| 2003-12-22 08:30:00 | IWM | ETF | 54.035 | 54.035 | 54.035 | 54.035 | 7200.0 |
| 2003-12-22 09:30:00 | IWM | ETF | 54.125 | 54.6 | 54.03 | 54.51 | 1028200.0 |
| 2003-12-22 10:00:00 | IWM | ETF | 54.545 | 54.575 | 54.415 | 54.495 | 697400.0 |
> showing 50 of 887 rows — these rows as CSV