PREVIEW / etf_30min / 2003-10-08
file: by_date/etf_30min/2003/2003-10-08.parquet size: 24 KB rows: 753
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-10-08 08:00:00 | SPY | ETF | 104.21 | 104.25 | 104.18 | 104.25 | 3100.0 |
| 2003-10-08 08:30:00 | SPY | ETF | 104.26 | 104.34 | 104.23 | 104.31 | 66100.0 |
| 2003-10-08 09:00:00 | SPY | ETF | 104.3 | 104.43 | 104.26 | 104.43 | 48800.0 |
| 2003-10-08 09:30:00 | SPY | ETF | 104.33 | 104.39 | 103.85 | 104.0 | 5861400.0 |
| 2003-10-08 10:00:00 | SPY | ETF | 104.0 | 104.29 | 103.85 | 103.95 | 2388700.0 |
| 2003-10-08 10:30:00 | SPY | ETF | 103.97 | 104.04 | 103.68 | 103.71 | 1925200.0 |
| 2003-10-08 11:00:00 | SPY | ETF | 103.717 | 103.84 | 103.61 | 103.79 | 1533300.0 |
| 2003-10-08 11:30:00 | SPY | ETF | 103.79 | 103.95 | 103.66 | 103.82 | 1322600.0 |
| 2003-10-08 12:00:00 | SPY | ETF | 103.81 | 103.9 | 103.68 | 103.82 | 797000.0 |
| 2003-10-08 12:30:00 | SPY | ETF | 103.79 | 104.03 | 103.78 | 103.953 | 1270400.0 |
| 2003-10-08 13:00:00 | SPY | ETF | 103.96 | 104.02 | 103.71 | 103.75 | 1099900.0 |
| 2003-10-08 13:30:00 | SPY | ETF | 103.73 | 103.94 | 103.66 | 103.78 | 937500.0 |
| 2003-10-08 14:00:00 | SPY | ETF | 103.77 | 103.8 | 103.41 | 103.6 | 2913600.0 |
| 2003-10-08 14:30:00 | SPY | ETF | 103.6 | 103.75 | 103.43 | 103.73 | 1645300.0 |
| 2003-10-08 15:00:00 | SPY | ETF | 103.7 | 103.91 | 103.63 | 103.7 | 1280400.0 |
| 2003-10-08 15:30:00 | SPY | ETF | 103.74 | 103.85 | 103.65 | 103.71 | 1890300.0 |
| 2003-10-08 16:00:00 | SPY | ETF | 103.72 | 104.02 | 103.69 | 103.9 | 878500.0 |
| 2003-10-08 16:30:00 | SPY | ETF | 103.97 | 104.13 | 103.9 | 103.91 | 357300.0 |
| 2003-10-08 17:00:00 | SPY | ETF | 103.9036 | 103.92 | 103.88 | 103.9 | 284200.0 |
| 2003-10-08 17:30:00 | SPY | ETF | 103.86 | 103.97 | 103.86 | 103.97 | 5300.0 |
| 2003-10-08 18:00:00 | SPY | ETF | 103.93 | 103.93 | 103.82 | 103.9 | 13600.0 |
| 2003-10-08 18:30:00 | SPY | ETF | 103.95 | 103.95 | 103.95 | 103.95 | 100.0 |
| 2003-10-08 19:00:00 | SPY | ETF | 103.91 | 103.91 | 103.91 | 103.91 | 500.0 |
| 2003-10-08 08:00:00 | QQQ | ETF | 34.63 | 34.63 | 34.59 | 34.61 | 22700.0 |
| 2003-10-08 08:30:00 | QQQ | ETF | 34.61 | 34.7 | 34.6 | 34.7 | 48900.0 |
| 2003-10-08 09:00:00 | QQQ | ETF | 34.7 | 34.84 | 34.63 | 34.82 | 227500.0 |
| 2003-10-08 09:30:00 | QQQ | ETF | 34.805 | 34.84 | 34.5 | 34.65 | 11386700.0 |
| 2003-10-08 10:00:00 | QQQ | ETF | 34.65 | 34.75 | 34.52 | 34.6 | 6420800.0 |
| 2003-10-08 10:30:00 | QQQ | ETF | 34.587 | 34.62 | 34.34 | 34.35 | 5411700.0 |
| 2003-10-08 11:00:00 | QQQ | ETF | 34.34 | 34.4 | 34.3 | 34.382 | 5193800.0 |
| 2003-10-08 11:30:00 | QQQ | ETF | 34.39 | 34.47 | 34.305 | 34.43 | 3995700.0 |
| 2003-10-08 12:00:00 | QQQ | ETF | 34.42 | 34.46 | 34.35 | 34.438 | 1824700.0 |
| 2003-10-08 12:30:00 | QQQ | ETF | 34.438 | 34.52 | 34.43 | 34.5 | 2200900.0 |
| 2003-10-08 13:00:00 | QQQ | ETF | 34.494 | 34.53 | 34.32 | 34.356 | 3235200.0 |
| 2003-10-08 13:30:00 | QQQ | ETF | 34.355 | 34.45 | 34.327 | 34.36 | 2830000.0 |
| 2003-10-08 14:00:00 | QQQ | ETF | 34.377 | 34.381 | 34.22 | 34.33 | 4571800.0 |
| 2003-10-08 14:30:00 | QQQ | ETF | 34.33 | 34.46 | 34.255 | 34.414 | 4320000.0 |
| 2003-10-08 15:00:00 | QQQ | ETF | 34.412 | 34.48 | 34.35 | 34.37 | 4383600.0 |
| 2003-10-08 15:30:00 | QQQ | ETF | 34.38 | 34.49 | 34.37 | 34.415 | 5026500.0 |
| 2003-10-08 16:00:00 | QQQ | ETF | 34.415 | 34.45 | 34.34 | 34.41 | 2454600.0 |
| 2003-10-08 16:30:00 | QQQ | ETF | 34.41 | 34.59 | 34.3 | 34.35 | 719000.0 |
| 2003-10-08 17:00:00 | QQQ | ETF | 34.33 | 34.408 | 34.306 | 34.37 | 85800.0 |
| 2003-10-08 17:30:00 | QQQ | ETF | 34.38 | 34.42 | 34.38 | 34.42 | 18500.0 |
| 2003-10-08 18:00:00 | QQQ | ETF | 34.41 | 34.41 | 34.35 | 34.41 | 18300.0 |
| 2003-10-08 19:00:00 | QQQ | ETF | 34.38 | 34.39 | 34.37 | 34.39 | 9900.0 |
| 2003-10-08 19:30:00 | QQQ | ETF | 34.4 | 34.41 | 34.4 | 34.41 | 6100.0 |
| 2003-10-08 09:30:00 | IWM | ETF | 51.93 | 52.1 | 51.74 | 51.81 | 441400.0 |
| 2003-10-08 10:00:00 | IWM | ETF | 51.78 | 51.93 | 51.655 | 51.73 | 323400.0 |
| 2003-10-08 10:30:00 | IWM | ETF | 51.715 | 51.825 | 51.36 | 51.385 | 296200.0 |
| 2003-10-08 11:00:00 | IWM | ETF | 51.385 | 51.395 | 51.25 | 51.355 | 519000.0 |
> showing 50 of 753 rows — these rows as CSV