PREVIEW / etf_5min / 2024-01-18
file: by_date/etf_5min/2024/2024-01-18.parquet size: 2.3 MB rows: 109,405
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-18 04:00:00 | SPY | ETF | 472.64 | 472.71 | 472.62 | 472.71 | 800.0 |
| 2024-01-18 04:05:00 | SPY | ETF | 472.82 | 472.82 | 472.65 | 472.65 | 1400.0 |
| 2024-01-18 04:10:00 | SPY | ETF | 472.79 | 473.01 | 472.79 | 472.9 | 5554.0 |
| 2024-01-18 04:15:00 | SPY | ETF | 472.82 | 472.82 | 472.76 | 472.76 | 802.0 |
| 2024-01-18 04:20:00 | SPY | ETF | 472.9 | 472.9 | 472.85 | 472.85 | 1552.0 |
| 2024-01-18 04:25:00 | SPY | ETF | 472.95 | 472.95 | 472.91 | 472.91 | 450.0 |
| 2024-01-18 04:30:00 | SPY | ETF | 472.87 | 472.99 | 472.87 | 472.92 | 1735.0 |
| 2024-01-18 04:35:00 | SPY | ETF | 472.88 | 473.0 | 472.85 | 472.95 | 3334.0 |
| 2024-01-18 04:40:00 | SPY | ETF | 472.96 | 473.14 | 472.85 | 472.86 | 1764.0 |
| 2024-01-18 04:45:00 | SPY | ETF | 472.81 | 472.87 | 472.8 | 472.87 | 600.0 |
| 2024-01-18 04:50:00 | SPY | ETF | 472.88 | 472.92 | 472.88 | 472.92 | 279.0 |
| 2024-01-18 04:55:00 | SPY | ETF | 472.79 | 472.85 | 472.79 | 472.85 | 670.0 |
| 2024-01-18 05:00:00 | SPY | ETF | 472.83 | 472.87 | 472.82 | 472.84 | 918.0 |
| 2024-01-18 05:05:00 | SPY | ETF | 472.86 | 472.86 | 472.86 | 472.86 | 170.0 |
| 2024-01-18 05:10:00 | SPY | ETF | 472.8 | 472.8 | 472.62 | 472.66 | 1000.0 |
| 2024-01-18 05:15:00 | SPY | ETF | 472.77 | 472.82 | 472.77 | 472.81 | 2506.0 |
| 2024-01-18 05:20:00 | SPY | ETF | 472.82 | 472.83 | 472.8 | 472.83 | 8410.0 |
| 2024-01-18 05:25:00 | SPY | ETF | 472.7 | 472.78 | 472.7 | 472.78 | 1205.0 |
| 2024-01-18 05:30:00 | SPY | ETF | 472.77 | 472.77 | 472.77 | 472.77 | 177.0 |
| 2024-01-18 05:35:00 | SPY | ETF | 472.84 | 472.84 | 472.84 | 472.84 | 130.0 |
| 2024-01-18 05:40:00 | SPY | ETF | 472.86 | 472.86 | 472.86 | 472.86 | 691.0 |
| 2024-01-18 05:50:00 | SPY | ETF | 472.87 | 473.24 | 472.87 | 473.24 | 2438.0 |
| 2024-01-18 05:55:00 | SPY | ETF | 473.25 | 473.46 | 473.25 | 473.43 | 2335.0 |
| 2024-01-18 06:00:00 | SPY | ETF | 473.5 | 473.67 | 473.5 | 473.67 | 1899.0 |
| 2024-01-18 06:05:00 | SPY | ETF | 473.66 | 473.74 | 473.62 | 473.7 | 3779.0 |
| 2024-01-18 06:10:00 | SPY | ETF | 473.75 | 473.88 | 473.75 | 473.88 | 13495.0 |
| 2024-01-18 06:15:00 | SPY | ETF | 473.85 | 473.85 | 473.72 | 473.76 | 1595.0 |
| 2024-01-18 06:20:00 | SPY | ETF | 473.8 | 473.9 | 473.79 | 473.9 | 2749.0 |
| 2024-01-18 06:25:00 | SPY | ETF | 473.9 | 473.9 | 473.9 | 473.9 | 100.0 |
| 2024-01-18 06:30:00 | SPY | ETF | 473.86 | 473.99 | 473.73 | 473.81 | 101499.0 |
| 2024-01-18 06:35:00 | SPY | ETF | 473.9 | 473.99 | 473.9 | 473.95 | 1783.0 |
| 2024-01-18 06:40:00 | SPY | ETF | 473.95 | 474.17 | 473.95 | 474.16 | 18575.0 |
| 2024-01-18 06:45:00 | SPY | ETF | 474.17 | 474.18 | 474.09 | 474.09 | 2958.0 |
| 2024-01-18 06:50:00 | SPY | ETF | 474.1 | 474.19 | 474.02 | 474.07 | 4545.0 |
| 2024-01-18 06:55:00 | SPY | ETF | 474.06 | 474.21 | 474.01 | 474.15 | 4503.0 |
| 2024-01-18 07:00:00 | SPY | ETF | 474.13 | 474.43 | 474.12 | 474.27 | 28363.0 |
| 2024-01-18 07:05:00 | SPY | ETF | 474.28 | 474.41 | 474.0 | 474.35 | 17390.0 |
| 2024-01-18 07:10:00 | SPY | ETF | 474.31 | 474.49 | 474.29 | 474.37 | 17048.0 |
| 2024-01-18 07:15:00 | SPY | ETF | 474.31 | 474.38 | 474.31 | 474.36 | 3575.0 |
| 2024-01-18 07:20:00 | SPY | ETF | 474.42 | 474.51 | 474.4 | 474.51 | 6915.0 |
| 2024-01-18 07:25:00 | SPY | ETF | 474.53 | 474.59 | 474.4 | 474.4 | 11394.0 |
| 2024-01-18 07:30:00 | SPY | ETF | 474.42 | 474.56 | 474.4 | 474.44 | 18876.0 |
| 2024-01-18 07:35:00 | SPY | ETF | 474.45 | 474.67 | 474.43 | 474.59 | 12792.0 |
| 2024-01-18 07:40:00 | SPY | ETF | 474.57 | 474.59 | 474.42 | 474.51 | 23793.0 |
| 2024-01-18 07:45:00 | SPY | ETF | 474.53 | 474.62 | 474.42 | 474.44 | 6291.0 |
| 2024-01-18 07:50:00 | SPY | ETF | 474.46 | 474.53 | 474.44 | 474.52 | 37452.0 |
| 2024-01-18 07:55:00 | SPY | ETF | 474.46 | 474.46 | 474.3 | 474.34 | 17597.0 |
| 2024-01-18 08:00:00 | SPY | ETF | 474.34 | 474.63 | 472.04 | 474.42 | 94409.0 |
| 2024-01-18 08:05:00 | SPY | ETF | 474.43 | 474.53 | 474.42 | 474.48 | 14326.0 |
| 2024-01-18 08:10:00 | SPY | ETF | 474.45 | 474.52 | 474.42 | 474.47 | 21732.0 |
> showing 50 of 109,405 rows — these rows as CSV