PREVIEW / etf_30min / 2003-08-29
file: by_date/etf_30min/2003/2003-08-29.parquet size: 23 KB rows: 693
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-08-29 08:00:00 | SPY | ETF | 100.65 | 100.65 | 100.49 | 100.54 | 10500.0 |
| 2003-08-29 08:30:00 | SPY | ETF | 100.52 | 100.64 | 100.5 | 100.57 | 29700.0 |
| 2003-08-29 09:00:00 | SPY | ETF | 100.57 | 100.64 | 100.53 | 100.64 | 38800.0 |
| 2003-08-29 09:30:00 | SPY | ETF | 100.61 | 101.05 | 100.48 | 101.0 | 3363000.0 |
| 2003-08-29 10:00:00 | SPY | ETF | 101.0 | 101.15 | 100.65 | 101.1 | 3510300.0 |
| 2003-08-29 10:30:00 | SPY | ETF | 101.11 | 101.11 | 100.85 | 100.86 | 1081200.0 |
| 2003-08-29 11:00:00 | SPY | ETF | 100.86 | 101.02 | 100.84 | 100.97 | 781100.0 |
| 2003-08-29 11:30:00 | SPY | ETF | 100.96 | 100.99 | 100.67 | 100.71 | 1290100.0 |
| 2003-08-29 12:00:00 | SPY | ETF | 100.7 | 100.82 | 100.67 | 100.77 | 742900.0 |
| 2003-08-29 12:30:00 | SPY | ETF | 100.77 | 100.85 | 100.62 | 100.71 | 882900.0 |
| 2003-08-29 13:00:00 | SPY | ETF | 100.71 | 100.92 | 100.69 | 100.88 | 2046100.0 |
| 2003-08-29 13:30:00 | SPY | ETF | 100.89 | 100.97 | 100.84 | 100.95 | 890500.0 |
| 2003-08-29 14:00:00 | SPY | ETF | 100.95 | 101.1 | 100.91 | 101.06 | 919900.0 |
| 2003-08-29 14:30:00 | SPY | ETF | 101.05 | 101.23 | 100.97 | 101.18 | 1624300.0 |
| 2003-08-29 15:00:00 | SPY | ETF | 101.18 | 101.38 | 101.1 | 101.29 | 2730300.0 |
| 2003-08-29 15:30:00 | SPY | ETF | 101.29 | 101.46 | 101.09 | 101.37 | 2277900.0 |
| 2003-08-29 16:00:00 | SPY | ETF | 101.37 | 101.49 | 101.25 | 101.44 | 3101800.0 |
| 2003-08-29 16:30:00 | SPY | ETF | 101.4 | 101.44 | 101.35 | 101.38 | 997600.0 |
| 2003-08-29 17:00:00 | SPY | ETF | 101.39 | 101.44 | 101.38 | 101.4 | 8800.0 |
| 2003-08-29 17:30:00 | SPY | ETF | 101.4 | 101.45 | 101.4 | 101.45 | 2000.0 |
| 2003-08-29 18:00:00 | SPY | ETF | 101.45 | 101.5 | 101.45 | 101.47 | 3500.0 |
| 2003-08-29 18:30:00 | SPY | ETF | 101.38 | 101.38 | 101.38 | 101.38 | 300.0 |
| 2003-08-29 19:00:00 | SPY | ETF | 101.47 | 101.47 | 101.47 | 101.47 | 500.0 |
| 2003-08-29 19:30:00 | SPY | ETF | 101.44 | 101.48 | 101.44 | 101.48 | 200.0 |
| 2003-08-29 08:00:00 | QQQ | ETF | 33.0 | 33.0 | 32.99 | 33.0 | 8500.0 |
| 2003-08-29 08:30:00 | QQQ | ETF | 32.98 | 33.03 | 32.98 | 33.02 | 27700.0 |
| 2003-08-29 09:00:00 | QQQ | ETF | 33.02 | 33.04 | 33.02 | 33.03 | 47700.0 |
| 2003-08-29 09:30:00 | QQQ | ETF | 33.04 | 33.26 | 32.98 | 33.24 | 6409100.0 |
| 2003-08-29 10:00:00 | QQQ | ETF | 33.24 | 33.297 | 33.07 | 33.28 | 6822300.0 |
| 2003-08-29 10:30:00 | QQQ | ETF | 33.262 | 33.28 | 33.15 | 33.16 | 2661500.0 |
| 2003-08-29 11:00:00 | QQQ | ETF | 33.16 | 33.25 | 33.15 | 33.22 | 1658900.0 |
| 2003-08-29 11:30:00 | QQQ | ETF | 33.22 | 33.23 | 33.11 | 33.13 | 1695800.0 |
| 2003-08-29 12:00:00 | QQQ | ETF | 33.12 | 33.18 | 33.09 | 33.155 | 1423100.0 |
| 2003-08-29 12:30:00 | QQQ | ETF | 33.155 | 33.18 | 33.05 | 33.11 | 1935400.0 |
| 2003-08-29 13:00:00 | QQQ | ETF | 33.12 | 33.2 | 33.1 | 33.18 | 1892800.0 |
| 2003-08-29 13:30:00 | QQQ | ETF | 33.18 | 33.25 | 33.16 | 33.23 | 1577500.0 |
| 2003-08-29 14:00:00 | QQQ | ETF | 33.24 | 33.29 | 33.21 | 33.29 | 2513100.0 |
| 2003-08-29 14:30:00 | QQQ | ETF | 33.28 | 33.32 | 33.24 | 33.32 | 2330100.0 |
| 2003-08-29 15:00:00 | QQQ | ETF | 33.31 | 33.43 | 33.28 | 33.38 | 7285800.0 |
| 2003-08-29 15:30:00 | QQQ | ETF | 33.38 | 33.45 | 33.23 | 33.31 | 7514800.0 |
| 2003-08-29 16:00:00 | QQQ | ETF | 33.31 | 33.4 | 33.12 | 33.38 | 4307000.0 |
| 2003-08-29 16:30:00 | QQQ | ETF | 33.39 | 33.44 | 33.37 | 33.43 | 45200.0 |
| 2003-08-29 17:00:00 | QQQ | ETF | 33.44 | 33.45 | 33.37 | 33.37 | 106300.0 |
| 2003-08-29 17:30:00 | QQQ | ETF | 33.39 | 33.43 | 33.39 | 33.43 | 27000.0 |
| 2003-08-29 18:00:00 | QQQ | ETF | 33.43 | 33.43 | 33.38 | 33.4 | 17300.0 |
| 2003-08-29 18:30:00 | QQQ | ETF | 33.43 | 33.43 | 33.37 | 33.4 | 5300.0 |
| 2003-08-29 19:30:00 | QQQ | ETF | 33.39 | 33.45 | 33.39 | 33.45 | 3500.0 |
| 2003-08-29 09:30:00 | IWM | ETF | 49.445 | 49.515 | 49.335 | 49.515 | 174200.0 |
| 2003-08-29 10:00:00 | IWM | ETF | 49.515 | 49.625 | 49.445 | 49.625 | 575000.0 |
| 2003-08-29 10:30:00 | IWM | ETF | 49.62 | 49.63 | 49.55 | 49.575 | 206600.0 |
> showing 50 of 693 rows — these rows as CSV