PREVIEW / etf_30min / 2003-09-08
file: by_date/etf_30min/2003/2003-09-08.parquet size: 24 KB rows: 733
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-09-08 08:00:00 | SPY | ETF | 102.84 | 102.84 | 102.81 | 102.82 | 16900.0 |
| 2003-09-08 08:30:00 | SPY | ETF | 102.87 | 102.97 | 102.85 | 102.97 | 8500.0 |
| 2003-09-08 09:00:00 | SPY | ETF | 103.0 | 103.04 | 102.96 | 103.04 | 21600.0 |
| 2003-09-08 09:30:00 | SPY | ETF | 103.04 | 103.7 | 102.93 | 103.596 | 6904700.0 |
| 2003-09-08 10:00:00 | SPY | ETF | 103.58 | 103.78 | 103.37 | 103.63 | 3137300.0 |
| 2003-09-08 10:30:00 | SPY | ETF | 103.65 | 103.69 | 103.41 | 103.49 | 1678700.0 |
| 2003-09-08 11:00:00 | SPY | ETF | 103.52 | 103.79 | 103.48 | 103.7 | 1828200.0 |
| 2003-09-08 11:30:00 | SPY | ETF | 103.697 | 103.75 | 103.5 | 103.543 | 1988500.0 |
| 2003-09-08 12:00:00 | SPY | ETF | 103.55 | 103.61 | 103.44 | 103.58 | 1245300.0 |
| 2003-09-08 12:30:00 | SPY | ETF | 103.57 | 103.59 | 103.46 | 103.5 | 438200.0 |
| 2003-09-08 13:00:00 | SPY | ETF | 103.51 | 103.7 | 103.46 | 103.68 | 719000.0 |
| 2003-09-08 13:30:00 | SPY | ETF | 103.68 | 103.88 | 103.65 | 103.78 | 1839200.0 |
| 2003-09-08 14:00:00 | SPY | ETF | 103.78 | 103.818 | 103.65 | 103.73 | 2163100.0 |
| 2003-09-08 14:30:00 | SPY | ETF | 103.727 | 103.83 | 103.57 | 103.62 | 1931200.0 |
| 2003-09-08 15:00:00 | SPY | ETF | 103.62 | 103.73 | 103.44 | 103.68 | 1954000.0 |
| 2003-09-08 15:30:00 | SPY | ETF | 103.66 | 103.82 | 103.58 | 103.8 | 2257400.0 |
| 2003-09-08 16:00:00 | SPY | ETF | 103.8 | 103.82 | 103.63 | 103.68 | 2152500.0 |
| 2003-09-08 16:30:00 | SPY | ETF | 103.65 | 103.69 | 103.65 | 103.69 | 13900.0 |
| 2003-09-08 17:00:00 | SPY | ETF | 103.73 | 103.74 | 103.68 | 103.68 | 9500.0 |
| 2003-09-08 17:30:00 | SPY | ETF | 103.72 | 103.72 | 103.69 | 103.69 | 3500.0 |
| 2003-09-08 18:00:00 | SPY | ETF | 103.725 | 103.73 | 103.7 | 103.7 | 10900.0 |
| 2003-09-08 19:00:00 | SPY | ETF | 103.74 | 103.74 | 103.7 | 103.72 | 10600.0 |
| 2003-09-08 19:30:00 | SPY | ETF | 103.65 | 103.72 | 103.65 | 103.72 | 300.0 |
| 2003-09-08 08:00:00 | QQQ | ETF | 33.95 | 33.95 | 33.89 | 33.94 | 26700.0 |
| 2003-09-08 08:30:00 | QQQ | ETF | 33.95 | 34.0 | 33.93 | 34.0 | 24500.0 |
| 2003-09-08 09:00:00 | QQQ | ETF | 33.99 | 34.02 | 33.99 | 34.0 | 126500.0 |
| 2003-09-08 09:30:00 | QQQ | ETF | 34.0 | 34.25 | 33.95 | 34.24 | 9157100.0 |
| 2003-09-08 10:00:00 | QQQ | ETF | 34.24 | 34.44 | 34.13 | 34.37 | 10548500.0 |
| 2003-09-08 10:30:00 | QQQ | ETF | 34.37 | 34.4 | 34.28 | 34.32 | 4624900.0 |
| 2003-09-08 11:00:00 | QQQ | ETF | 34.34 | 34.51 | 34.32 | 34.482 | 5265400.0 |
| 2003-09-08 11:30:00 | QQQ | ETF | 34.48 | 34.49 | 34.34 | 34.372 | 3442100.0 |
| 2003-09-08 12:00:00 | QQQ | ETF | 34.38 | 34.41 | 34.3 | 34.36 | 3251000.0 |
| 2003-09-08 12:30:00 | QQQ | ETF | 34.359 | 34.38 | 34.27 | 34.33 | 3080900.0 |
| 2003-09-08 13:00:00 | QQQ | ETF | 34.332 | 34.44 | 34.3 | 34.4 | 1992900.0 |
| 2003-09-08 13:30:00 | QQQ | ETF | 34.41 | 34.5 | 34.39 | 34.42 | 3030900.0 |
| 2003-09-08 14:00:00 | QQQ | ETF | 34.41 | 34.45 | 34.34 | 34.42 | 1825400.0 |
| 2003-09-08 14:30:00 | QQQ | ETF | 34.42 | 34.476 | 34.32 | 34.351 | 2888800.0 |
| 2003-09-08 15:00:00 | QQQ | ETF | 34.351 | 34.4 | 34.27 | 34.38 | 4908200.0 |
| 2003-09-08 15:30:00 | QQQ | ETF | 34.38 | 34.47 | 34.29 | 34.459 | 5881300.0 |
| 2003-09-08 16:00:00 | QQQ | ETF | 34.45 | 34.54 | 34.45 | 34.54 | 2510900.0 |
| 2003-09-08 16:30:00 | QQQ | ETF | 34.53 | 34.55 | 34.51 | 34.53 | 456800.0 |
| 2003-09-08 17:00:00 | QQQ | ETF | 34.53 | 34.542 | 34.51 | 34.52 | 64800.0 |
| 2003-09-08 17:30:00 | QQQ | ETF | 34.53 | 34.54 | 34.51 | 34.51 | 26000.0 |
| 2003-09-08 18:00:00 | QQQ | ETF | 34.52 | 34.532 | 34.5 | 34.51 | 24000.0 |
| 2003-09-08 18:30:00 | QQQ | ETF | 34.51 | 34.54 | 34.51 | 34.51 | 1400.0 |
| 2003-09-08 19:00:00 | QQQ | ETF | 34.54 | 34.54 | 34.53 | 34.53 | 2900.0 |
| 2003-09-08 19:30:00 | QQQ | ETF | 34.54 | 34.54 | 34.53 | 34.53 | 19400.0 |
| 2003-09-08 09:30:00 | IWM | ETF | 51.075 | 51.58 | 50.985 | 51.58 | 651800.0 |
| 2003-09-08 10:00:00 | IWM | ETF | 51.59 | 51.65 | 51.41 | 51.55 | 524000.0 |
| 2003-09-08 10:30:00 | IWM | ETF | 51.55 | 51.575 | 51.5 | 51.525 | 128600.0 |
> showing 50 of 733 rows — these rows as CSV