PREVIEW / etf_30min / 2003-09-15
file: by_date/etf_30min/2003/2003-09-15.parquet size: 23 KB rows: 704
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-15 08:00:00 | SPY | ETF | 102.63 | 102.63 | 102.53 | 102.54 | 20500.0 |
| 2003-09-15 08:30:00 | SPY | ETF | 102.51 | 102.61 | 102.5 | 102.55 | 43600.0 |
| 2003-09-15 09:00:00 | SPY | ETF | 102.55 | 102.55 | 102.45 | 102.53 | 134100.0 |
| 2003-09-15 09:30:00 | SPY | ETF | 102.52 | 102.6 | 102.23 | 102.42 | 4230400.0 |
| 2003-09-15 10:00:00 | SPY | ETF | 102.41 | 102.63 | 102.28 | 102.47 | 1594200.0 |
| 2003-09-15 10:30:00 | SPY | ETF | 102.47 | 102.6 | 102.31 | 102.38 | 1096200.0 |
| 2003-09-15 11:00:00 | SPY | ETF | 102.35 | 102.41 | 102.05 | 102.19 | 2042400.0 |
| 2003-09-15 11:30:00 | SPY | ETF | 102.16 | 102.27 | 102.1 | 102.19 | 897600.0 |
| 2003-09-15 12:00:00 | SPY | ETF | 102.19 | 102.22 | 101.95 | 102.17 | 1391400.0 |
| 2003-09-15 12:30:00 | SPY | ETF | 102.19 | 102.26 | 102.15 | 102.18 | 325500.0 |
| 2003-09-15 13:00:00 | SPY | ETF | 102.188 | 102.38 | 102.13 | 102.26 | 794200.0 |
| 2003-09-15 13:30:00 | SPY | ETF | 102.26 | 102.29 | 102.09 | 102.16 | 503100.0 |
| 2003-09-15 14:00:00 | SPY | ETF | 102.17 | 102.34 | 102.11 | 102.27 | 840600.0 |
| 2003-09-15 14:30:00 | SPY | ETF | 102.3 | 102.38 | 102.1 | 102.18 | 1016600.0 |
| 2003-09-15 15:00:00 | SPY | ETF | 102.17 | 102.38 | 102.128 | 102.3 | 1141900.0 |
| 2003-09-15 15:30:00 | SPY | ETF | 102.294 | 102.32 | 102.01 | 102.12 | 1876500.0 |
| 2003-09-15 16:00:00 | SPY | ETF | 102.12 | 102.18 | 102.04 | 102.05 | 1364600.0 |
| 2003-09-15 16:30:00 | SPY | ETF | 102.04 | 102.11 | 102.0 | 102.08 | 48900.0 |
| 2003-09-15 17:00:00 | SPY | ETF | 102.08 | 102.1 | 102.08 | 102.1 | 3600.0 |
| 2003-09-15 17:30:00 | SPY | ETF | 102.1 | 102.1 | 102.05 | 102.05 | 7300.0 |
| 2003-09-15 18:00:00 | SPY | ETF | 102.06 | 102.06 | 102.02 | 102.02 | 1800.0 |
| 2003-09-15 08:00:00 | QQQ | ETF | 33.89 | 33.89 | 33.84 | 33.86 | 41600.0 |
| 2003-09-15 08:30:00 | QQQ | ETF | 33.86 | 33.88 | 33.84 | 33.86 | 25500.0 |
| 2003-09-15 09:00:00 | QQQ | ETF | 33.85 | 33.87 | 33.8 | 33.85 | 241200.0 |
| 2003-09-15 09:30:00 | QQQ | ETF | 33.84 | 33.91 | 33.664 | 33.75 | 9269600.0 |
| 2003-09-15 10:00:00 | QQQ | ETF | 33.75 | 33.86 | 33.65 | 33.71 | 5765500.0 |
| 2003-09-15 10:30:00 | QQQ | ETF | 33.7 | 33.8 | 33.63 | 33.65 | 3772700.0 |
| 2003-09-15 11:00:00 | QQQ | ETF | 33.66 | 33.68 | 33.53 | 33.59 | 4631000.0 |
| 2003-09-15 11:30:00 | QQQ | ETF | 33.59 | 33.66 | 33.56 | 33.61 | 2391000.0 |
| 2003-09-15 12:00:00 | QQQ | ETF | 33.61 | 33.67 | 33.52 | 33.64 | 2556900.0 |
| 2003-09-15 12:30:00 | QQQ | ETF | 33.63 | 33.69 | 33.62 | 33.63 | 1542800.0 |
| 2003-09-15 13:00:00 | QQQ | ETF | 33.63 | 33.7 | 33.59 | 33.65 | 2641900.0 |
| 2003-09-15 13:30:00 | QQQ | ETF | 33.66 | 33.67 | 33.56 | 33.6 | 1562100.0 |
| 2003-09-15 14:00:00 | QQQ | ETF | 33.61 | 33.63 | 33.51 | 33.55 | 2518900.0 |
| 2003-09-15 14:30:00 | QQQ | ETF | 33.54 | 33.62 | 33.47 | 33.51 | 2886200.0 |
| 2003-09-15 15:00:00 | QQQ | ETF | 33.5 | 33.63 | 33.48 | 33.57 | 2584100.0 |
| 2003-09-15 15:30:00 | QQQ | ETF | 33.61 | 33.62 | 33.444 | 33.481 | 4695300.0 |
| 2003-09-15 16:00:00 | QQQ | ETF | 33.49 | 33.7576 | 33.46 | 33.52 | 3390500.0 |
| 2003-09-15 16:30:00 | QQQ | ETF | 33.53 | 33.54 | 33.51 | 33.527 | 117700.0 |
| 2003-09-15 17:00:00 | QQQ | ETF | 33.53 | 33.54 | 33.51 | 33.53 | 35000.0 |
| 2003-09-15 17:30:00 | QQQ | ETF | 33.52 | 33.53 | 33.52 | 33.52 | 3900.0 |
| 2003-09-15 18:00:00 | QQQ | ETF | 33.511 | 33.539 | 33.499 | 33.51 | 26900.0 |
| 2003-09-15 18:30:00 | QQQ | ETF | 33.51 | 33.51 | 33.51 | 33.51 | 2100.0 |
| 2003-09-15 19:00:00 | QQQ | ETF | 33.51 | 33.51 | 33.51 | 33.51 | 1200.0 |
| 2003-09-15 19:30:00 | QQQ | ETF | 33.51 | 33.54 | 33.5 | 33.54 | 6900.0 |
| 2003-09-15 09:00:00 | IWM | ETF | 50.75 | 50.75 | 50.75 | 50.75 | 2000.0 |
| 2003-09-15 09:30:00 | IWM | ETF | 50.81 | 51.15 | 50.81 | 51.0 | 481000.0 |
| 2003-09-15 10:00:00 | IWM | ETF | 51.0 | 51.06 | 50.925 | 50.96 | 397600.0 |
| 2003-09-15 10:30:00 | IWM | ETF | 50.9995 | 51.1 | 50.955 | 50.985 | 299800.0 |
| 2003-09-15 11:00:00 | IWM | ETF | 50.985 | 50.985 | 50.8 | 50.85 | 349600.0 |
> showing 50 of 704 rows — these rows as CSV