PREVIEW / etf_5min / 2024-04-19
file: by_date/etf_5min/2024/2024-04-19.parquet size: 2.2 MB rows: 111,940
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-04-19 04:00:00 | SPY | ETF | 497.0 | 497.54 | 494.97 | 497.44 | 20512.0 |
| 2024-04-19 04:05:00 | SPY | ETF | 497.42 | 497.49 | 496.92 | 497.3 | 11243.0 |
| 2024-04-19 04:10:00 | SPY | ETF | 497.06 | 497.06 | 496.68 | 496.94 | 7637.0 |
| 2024-04-19 04:15:00 | SPY | ETF | 496.97 | 497.78 | 496.97 | 497.73 | 5751.0 |
| 2024-04-19 04:20:00 | SPY | ETF | 497.74 | 497.74 | 497.45 | 497.5 | 1573.0 |
| 2024-04-19 04:25:00 | SPY | ETF | 497.65 | 497.88 | 497.62 | 497.62 | 6683.0 |
| 2024-04-19 04:30:00 | SPY | ETF | 497.65 | 497.65 | 497.25 | 497.29 | 2767.0 |
| 2024-04-19 04:35:00 | SPY | ETF | 497.07 | 497.2 | 497.04 | 497.2 | 3356.0 |
| 2024-04-19 04:40:00 | SPY | ETF | 497.12 | 497.12 | 496.77 | 496.77 | 3300.0 |
| 2024-04-19 04:45:00 | SPY | ETF | 497.0 | 497.08 | 496.9 | 497.08 | 4099.0 |
| 2024-04-19 04:50:00 | SPY | ETF | 497.15 | 497.3 | 497.15 | 497.19 | 3343.0 |
| 2024-04-19 04:55:00 | SPY | ETF | 497.19 | 497.19 | 497.19 | 497.19 | 158.0 |
| 2024-04-19 05:00:00 | SPY | ETF | 497.11 | 497.62 | 497.11 | 497.62 | 656.0 |
| 2024-04-19 05:10:00 | SPY | ETF | 497.22 | 497.23 | 497.1 | 497.1 | 1000.0 |
| 2024-04-19 05:15:00 | SPY | ETF | 497.52 | 497.52 | 497.4 | 497.4 | 600.0 |
| 2024-04-19 05:20:00 | SPY | ETF | 497.4 | 497.67 | 497.4 | 497.51 | 1206.0 |
| 2024-04-19 05:25:00 | SPY | ETF | 497.54 | 497.77 | 497.5 | 497.71 | 54873.0 |
| 2024-04-19 05:30:00 | SPY | ETF | 497.86 | 498.13 | 497.86 | 498.13 | 6021.0 |
| 2024-04-19 05:35:00 | SPY | ETF | 498.12 | 498.17 | 498.09 | 498.09 | 4498.0 |
| 2024-04-19 05:40:00 | SPY | ETF | 497.89 | 497.89 | 497.8 | 497.85 | 1650.0 |
| 2024-04-19 05:45:00 | SPY | ETF | 497.78 | 497.96 | 497.78 | 497.84 | 55961.0 |
| 2024-04-19 05:50:00 | SPY | ETF | 497.96 | 497.96 | 497.74 | 497.83 | 999.0 |
| 2024-04-19 05:55:00 | SPY | ETF | 497.9 | 497.93 | 497.63 | 497.63 | 4700.0 |
| 2024-04-19 06:00:00 | SPY | ETF | 497.63 | 497.94 | 497.61 | 497.78 | 6595.0 |
| 2024-04-19 06:05:00 | SPY | ETF | 497.87 | 498.36 | 497.86 | 498.15 | 7968.0 |
| 2024-04-19 06:10:00 | SPY | ETF | 498.25 | 498.25 | 497.78 | 497.87 | 102603.0 |
| 2024-04-19 06:15:00 | SPY | ETF | 497.83 | 497.83 | 497.57 | 497.57 | 4225.0 |
| 2024-04-19 06:20:00 | SPY | ETF | 497.52 | 497.54 | 497.25 | 497.25 | 12460.0 |
| 2024-04-19 06:25:00 | SPY | ETF | 497.25 | 497.51 | 497.25 | 497.5 | 9425.0 |
| 2024-04-19 06:30:00 | SPY | ETF | 497.56 | 497.56 | 497.46 | 497.46 | 4898.0 |
| 2024-04-19 06:35:00 | SPY | ETF | 497.51 | 497.56 | 497.29 | 497.3 | 22670.0 |
| 2024-04-19 06:40:00 | SPY | ETF | 497.18 | 497.39 | 497.04 | 497.04 | 7970.0 |
| 2024-04-19 06:45:00 | SPY | ETF | 497.23 | 497.4 | 497.22 | 497.4 | 5651.0 |
| 2024-04-19 06:50:00 | SPY | ETF | 497.37 | 497.37 | 497.0 | 497.14 | 16074.0 |
| 2024-04-19 06:55:00 | SPY | ETF | 497.28 | 497.91 | 497.28 | 497.77 | 70826.0 |
| 2024-04-19 07:00:00 | SPY | ETF | 497.78 | 498.05 | 497.6 | 497.75 | 90696.0 |
| 2024-04-19 07:05:00 | SPY | ETF | 497.68 | 497.72 | 497.5 | 497.6 | 11659.0 |
| 2024-04-19 07:10:00 | SPY | ETF | 497.59 | 497.8 | 497.38 | 497.5 | 30000.0 |
| 2024-04-19 07:15:00 | SPY | ETF | 497.5 | 498.27 | 497.5 | 498.06 | 22916.0 |
| 2024-04-19 07:20:00 | SPY | ETF | 498.07 | 498.39 | 497.9 | 498.35 | 51146.0 |
| 2024-04-19 07:25:00 | SPY | ETF | 498.35 | 498.66 | 498.35 | 498.49 | 45305.0 |
| 2024-04-19 07:30:00 | SPY | ETF | 498.55 | 498.93 | 498.55 | 498.77 | 70464.0 |
| 2024-04-19 07:35:00 | SPY | ETF | 498.8 | 498.95 | 498.71 | 498.92 | 36425.0 |
| 2024-04-19 07:40:00 | SPY | ETF | 499.0 | 499.5 | 499.0 | 499.26 | 280673.0 |
| 2024-04-19 07:45:00 | SPY | ETF | 499.19 | 499.19 | 498.64 | 498.66 | 28685.0 |
| 2024-04-19 07:50:00 | SPY | ETF | 498.69 | 498.71 | 498.45 | 498.7 | 62986.0 |
| 2024-04-19 07:55:00 | SPY | ETF | 498.74 | 499.16 | 498.74 | 499.15 | 21592.0 |
| 2024-04-19 08:00:00 | SPY | ETF | 497.73 | 499.47 | 495.0 | 498.8 | 124077.0 |
| 2024-04-19 08:05:00 | SPY | ETF | 498.8 | 498.82 | 498.56 | 498.81 | 20181.0 |
| 2024-04-19 08:10:00 | SPY | ETF | 498.7813 | 499.39 | 498.7813 | 499.39 | 44518.0 |
> showing 50 of 111,940 rows — these rows as CSV