PREVIEW / etf_30min / 2003-01-15
file: by_date/etf_30min/2003/2003-01-15.parquet size: 21 KB rows: 622
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-01-15 08:00:00 | SPY | ETF | 93.3 | 93.4 | 93.3 | 93.35 | 23500.0 |
| 2003-01-15 08:30:00 | SPY | ETF | 93.28 | 93.45 | 93.19 | 93.45 | 14200.0 |
| 2003-01-15 09:00:00 | SPY | ETF | 93.43 | 93.5 | 93.39 | 93.5 | 14700.0 |
| 2003-01-15 09:30:00 | SPY | ETF | 93.54 | 93.57 | 92.61 | 92.67 | 3800900.0 |
| 2003-01-15 10:00:00 | SPY | ETF | 92.66 | 92.7 | 92.24 | 92.37 | 4097200.0 |
| 2003-01-15 10:30:00 | SPY | ETF | 92.39 | 92.6 | 92.14 | 92.19 | 1596100.0 |
| 2003-01-15 11:00:00 | SPY | ETF | 92.17 | 92.33 | 92.06 | 92.28 | 1455100.0 |
| 2003-01-15 11:30:00 | SPY | ETF | 92.28 | 92.32 | 92.01 | 92.18 | 1325900.0 |
| 2003-01-15 12:00:00 | SPY | ETF | 92.18 | 92.2 | 91.91 | 92.1 | 2191700.0 |
| 2003-01-15 12:30:00 | SPY | ETF | 92.1 | 92.14 | 91.96 | 92.08 | 1250600.0 |
| 2003-01-15 13:00:00 | SPY | ETF | 92.07 | 92.2 | 91.96 | 92.12 | 1566800.0 |
| 2003-01-15 13:30:00 | SPY | ETF | 92.12 | 92.24 | 92.0 | 92.11 | 1224000.0 |
| 2003-01-15 14:00:00 | SPY | ETF | 92.08 | 92.4 | 91.95 | 92.29 | 2628100.0 |
| 2003-01-15 14:30:00 | SPY | ETF | 92.28 | 92.34 | 92.12 | 92.3 | 2235700.0 |
| 2003-01-15 15:00:00 | SPY | ETF | 92.29 | 92.52 | 92.15 | 92.3 | 1547000.0 |
| 2003-01-15 15:30:00 | SPY | ETF | 92.3 | 92.32 | 92.05 | 92.13 | 1609800.0 |
| 2003-01-15 16:00:00 | SPY | ETF | 92.13 | 92.48 | 92.11 | 92.35 | 750900.0 |
| 2003-01-15 16:30:00 | SPY | ETF | 92.38 | 92.38 | 92.12 | 92.26 | 139400.0 |
| 2003-01-15 17:00:00 | SPY | ETF | 92.32 | 92.35 | 92.26 | 92.31 | 15800.0 |
| 2003-01-15 17:30:00 | SPY | ETF | 92.28 | 92.31 | 92.28 | 92.31 | 25100.0 |
| 2003-01-15 18:00:00 | SPY | ETF | 92.27 | 92.31 | 92.23 | 92.25 | 1000.0 |
| 2003-01-15 18:30:00 | SPY | ETF | 92.3 | 92.3 | 92.3 | 92.3 | 100.0 |
| 2003-01-15 19:00:00 | SPY | ETF | 92.25 | 92.26 | 92.25 | 92.26 | 400.0 |
| 2003-01-15 19:30:00 | SPY | ETF | 92.28 | 92.28 | 92.24 | 92.24 | 500.0 |
| 2003-01-15 08:00:00 | QQQ | ETF | 27.11 | 27.24 | 27.11 | 27.2 | 17400.0 |
| 2003-01-15 08:30:00 | QQQ | ETF | 27.17 | 27.27 | 27.15 | 27.21 | 62100.0 |
| 2003-01-15 09:00:00 | QQQ | ETF | 27.21 | 27.26 | 27.2 | 27.26 | 11300.0 |
| 2003-01-15 09:30:00 | QQQ | ETF | 27.25 | 27.35 | 26.86 | 26.89 | 10822000.0 |
| 2003-01-15 10:00:00 | QQQ | ETF | 26.93 | 26.98 | 26.76 | 26.86 | 6274900.0 |
| 2003-01-15 10:30:00 | QQQ | ETF | 26.84 | 26.95 | 26.77 | 26.78 | 3345400.0 |
| 2003-01-15 11:00:00 | QQQ | ETF | 26.78 | 26.82 | 26.69 | 26.77 | 3457400.0 |
| 2003-01-15 11:30:00 | QQQ | ETF | 26.77 | 26.8 | 26.67 | 26.71 | 2504000.0 |
| 2003-01-15 12:00:00 | QQQ | ETF | 26.71 | 26.74 | 26.58 | 26.62 | 3410700.0 |
| 2003-01-15 12:30:00 | QQQ | ETF | 26.62 | 26.67 | 26.59 | 26.64 | 2204900.0 |
| 2003-01-15 13:00:00 | QQQ | ETF | 26.64 | 26.69 | 26.58 | 26.64 | 2112800.0 |
| 2003-01-15 13:30:00 | QQQ | ETF | 26.65 | 26.72 | 26.61 | 26.66 | 1654900.0 |
| 2003-01-15 14:00:00 | QQQ | ETF | 26.67 | 26.79 | 26.61 | 26.77 | 2889500.0 |
| 2003-01-15 14:30:00 | QQQ | ETF | 26.75 | 26.79 | 26.68 | 26.76 | 1979200.0 |
| 2003-01-15 15:00:00 | QQQ | ETF | 26.77 | 26.88 | 26.73 | 26.8 | 3866600.0 |
| 2003-01-15 15:30:00 | QQQ | ETF | 26.8 | 26.82 | 26.67 | 26.73 | 5049400.0 |
| 2003-01-15 16:00:00 | QQQ | ETF | 26.7 | 26.85 | 26.63 | 26.72 | 1841700.0 |
| 2003-01-15 16:30:00 | QQQ | ETF | 26.71 | 26.75 | 26.52 | 26.68 | 532300.0 |
| 2003-01-15 17:00:00 | QQQ | ETF | 26.67 | 26.72 | 26.64 | 26.65 | 271400.0 |
| 2003-01-15 17:30:00 | QQQ | ETF | 26.65 | 26.7 | 26.62 | 26.65 | 225700.0 |
| 2003-01-15 18:00:00 | QQQ | ETF | 26.65 | 26.66 | 26.62 | 26.63 | 39700.0 |
| 2003-01-15 18:30:00 | QQQ | ETF | 26.62 | 26.65 | 26.62 | 26.62 | 17300.0 |
| 2003-01-15 19:00:00 | QQQ | ETF | 26.63 | 26.63 | 26.61 | 26.63 | 4300.0 |
| 2003-01-15 19:30:00 | QQQ | ETF | 26.63 | 26.63 | 26.62 | 26.63 | 3000.0 |
| 2003-01-15 08:30:00 | IWM | ETF | 39.615 | 39.615 | 39.615 | 39.615 | 2000.0 |
| 2003-01-15 09:30:00 | IWM | ETF | 39.585 | 39.7 | 39.245 | 39.315 | 212800.0 |
> showing 50 of 622 rows — these rows as CSV