PREVIEW / etf_5min / 2024-01-19
file: by_date/etf_5min/2024/2024-01-19.parquet size: 2.3 MB rows: 111,145
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 |
|---|---|---|---|---|---|---|---|
| 2024-01-19 04:00:00 | SPY | ETF | 477.84 | 478.09 | 477.2 | 478.05 | 24866.0 |
| 2024-01-19 04:05:00 | SPY | ETF | 477.95 | 478.08 | 477.95 | 478.08 | 3382.0 |
| 2024-01-19 04:10:00 | SPY | ETF | 478.1 | 478.4 | 478.03 | 478.4 | 9079.0 |
| 2024-01-19 04:15:00 | SPY | ETF | 478.4 | 478.45 | 478.35 | 478.4 | 3357.0 |
| 2024-01-19 04:20:00 | SPY | ETF | 478.39 | 478.56 | 478.39 | 478.56 | 4310.0 |
| 2024-01-19 04:25:00 | SPY | ETF | 478.57 | 478.58 | 478.5 | 478.55 | 4016.0 |
| 2024-01-19 04:30:00 | SPY | ETF | 478.48 | 478.48 | 478.23 | 478.23 | 1689.0 |
| 2024-01-19 04:35:00 | SPY | ETF | 478.19 | 478.19 | 477.98 | 477.98 | 6132.0 |
| 2024-01-19 04:40:00 | SPY | ETF | 477.93 | 477.95 | 477.85 | 477.85 | 7543.0 |
| 2024-01-19 04:45:00 | SPY | ETF | 477.97 | 478.0 | 477.97 | 478.0 | 992.0 |
| 2024-01-19 04:50:00 | SPY | ETF | 478.0 | 478.26 | 478.0 | 478.23 | 1422.0 |
| 2024-01-19 04:55:00 | SPY | ETF | 478.27 | 478.43 | 478.25 | 478.42 | 2602.0 |
| 2024-01-19 05:00:00 | SPY | ETF | 478.36 | 478.36 | 478.25 | 478.33 | 915.0 |
| 2024-01-19 05:05:00 | SPY | ETF | 478.42 | 478.44 | 478.4 | 478.44 | 700.0 |
| 2024-01-19 05:10:00 | SPY | ETF | 478.36 | 478.39 | 478.34 | 478.34 | 810.0 |
| 2024-01-19 05:15:00 | SPY | ETF | 478.38 | 478.38 | 478.2 | 478.2 | 569.0 |
| 2024-01-19 05:20:00 | SPY | ETF | 478.25 | 478.32 | 478.25 | 478.32 | 1500.0 |
| 2024-01-19 05:25:00 | SPY | ETF | 478.28 | 478.29 | 478.16 | 478.25 | 4400.0 |
| 2024-01-19 05:30:00 | SPY | ETF | 478.26 | 478.26 | 478.16 | 478.26 | 1816.0 |
| 2024-01-19 05:35:00 | SPY | ETF | 478.29 | 478.45 | 478.29 | 478.45 | 2000.0 |
| 2024-01-19 05:40:00 | SPY | ETF | 478.47 | 478.47 | 478.45 | 478.45 | 1408.0 |
| 2024-01-19 05:45:00 | SPY | ETF | 478.37 | 478.47 | 478.37 | 478.47 | 4400.0 |
| 2024-01-19 05:50:00 | SPY | ETF | 478.47 | 478.58 | 478.47 | 478.53 | 3247.0 |
| 2024-01-19 05:55:00 | SPY | ETF | 478.55 | 478.65 | 478.55 | 478.62 | 989.0 |
| 2024-01-19 06:00:00 | SPY | ETF | 478.5 | 478.54 | 478.46 | 478.54 | 590.0 |
| 2024-01-19 06:05:00 | SPY | ETF | 478.55 | 478.66 | 478.55 | 478.6 | 1709.0 |
| 2024-01-19 06:10:00 | SPY | ETF | 478.6 | 478.72 | 478.6 | 478.69 | 1037.0 |
| 2024-01-19 06:15:00 | SPY | ETF | 478.66 | 478.66 | 478.59 | 478.59 | 2685.0 |
| 2024-01-19 06:25:00 | SPY | ETF | 478.65 | 478.65 | 478.65 | 478.65 | 200.0 |
| 2024-01-19 06:30:00 | SPY | ETF | 478.67 | 478.95 | 478.67 | 478.93 | 5905.0 |
| 2024-01-19 06:35:00 | SPY | ETF | 478.96 | 478.98 | 478.88 | 478.94 | 2158.0 |
| 2024-01-19 06:40:00 | SPY | ETF | 478.93 | 478.99 | 478.89 | 478.99 | 6959.0 |
| 2024-01-19 06:45:00 | SPY | ETF | 478.92 | 478.98 | 478.92 | 478.98 | 5193.0 |
| 2024-01-19 06:50:00 | SPY | ETF | 478.95 | 478.97 | 478.82 | 478.83 | 3599.0 |
| 2024-01-19 06:55:00 | SPY | ETF | 478.74 | 478.89 | 478.74 | 478.83 | 4094.0 |
| 2024-01-19 07:00:00 | SPY | ETF | 478.88 | 478.9 | 477.92 | 478.82 | 98112.0 |
| 2024-01-19 07:05:00 | SPY | ETF | 478.83 | 478.85 | 478.76 | 478.76 | 8473.0 |
| 2024-01-19 07:10:00 | SPY | ETF | 478.75 | 478.76 | 478.65 | 478.72 | 29489.0 |
| 2024-01-19 07:15:00 | SPY | ETF | 478.69 | 478.69 | 478.6 | 478.6 | 4936.0 |
| 2024-01-19 07:20:00 | SPY | ETF | 478.61 | 478.61 | 478.48 | 478.55 | 43545.0 |
| 2024-01-19 07:25:00 | SPY | ETF | 478.57 | 478.61 | 478.5 | 478.55 | 31000.0 |
| 2024-01-19 07:30:00 | SPY | ETF | 478.5 | 478.58 | 478.48 | 478.57 | 22760.0 |
| 2024-01-19 07:35:00 | SPY | ETF | 478.56 | 478.59 | 478.49 | 478.59 | 13482.0 |
| 2024-01-19 07:40:00 | SPY | ETF | 478.59 | 478.59 | 478.36 | 478.4 | 37904.0 |
| 2024-01-19 07:45:00 | SPY | ETF | 478.39 | 478.47 | 478.36 | 478.46 | 11479.0 |
| 2024-01-19 07:50:00 | SPY | ETF | 478.48 | 478.72 | 478.48 | 478.72 | 31020.0 |
| 2024-01-19 07:55:00 | SPY | ETF | 478.73 | 478.97 | 478.73 | 478.91 | 63380.0 |
| 2024-01-19 08:00:00 | SPY | ETF | 478.8805 | 479.24 | 476.84 | 479.13 | 88715.0 |
| 2024-01-19 08:05:00 | SPY | ETF | 479.16 | 479.3701 | 479.1 | 479.33 | 31385.0 |
| 2024-01-19 08:10:00 | SPY | ETF | 479.33 | 479.45 | 479.26 | 479.44 | 25520.0 |
> showing 50 of 111,145 rows — these rows as CSV