PREVIEW / etf_5min / 2024-11-08
file: by_date/etf_5min/2024/2024-11-08.parquet size: 2.6 MB rows: 125,807
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-11-08 04:00:00 | SPY | ETF | 596.37 | 596.37 | 596.25 | 596.36 | 5584.0 |
| 2024-11-08 04:05:00 | SPY | ETF | 596.28 | 596.47 | 596.28 | 596.46 | 3184.0 |
| 2024-11-08 04:10:00 | SPY | ETF | 596.47 | 596.61 | 596.46 | 596.61 | 1988.0 |
| 2024-11-08 04:15:00 | SPY | ETF | 596.68 | 596.68 | 596.52 | 596.52 | 836.0 |
| 2024-11-08 04:20:00 | SPY | ETF | 596.6 | 596.63 | 596.51 | 596.55 | 492.0 |
| 2024-11-08 04:25:00 | SPY | ETF | 596.61 | 596.61 | 596.6 | 596.6 | 600.0 |
| 2024-11-08 04:30:00 | SPY | ETF | 596.57 | 596.63 | 596.56 | 596.56 | 1197.0 |
| 2024-11-08 04:35:00 | SPY | ETF | 596.57 | 596.63 | 596.57 | 596.6 | 1310.0 |
| 2024-11-08 04:40:00 | SPY | ETF | 596.67 | 596.67 | 596.67 | 596.67 | 373.0 |
| 2024-11-08 04:45:00 | SPY | ETF | 596.56 | 596.57 | 596.42 | 596.42 | 2037.0 |
| 2024-11-08 04:55:00 | SPY | ETF | 596.34 | 596.42 | 596.34 | 596.42 | 5278.0 |
| 2024-11-08 05:00:00 | SPY | ETF | 596.29 | 596.29 | 596.21 | 596.21 | 2517.0 |
| 2024-11-08 05:05:00 | SPY | ETF | 596.28 | 596.28 | 596.04 | 596.09 | 1719.0 |
| 2024-11-08 05:10:00 | SPY | ETF | 596.07 | 596.07 | 595.93 | 595.95 | 1544.0 |
| 2024-11-08 05:15:00 | SPY | ETF | 595.99 | 596.17 | 595.98 | 596.17 | 1256.0 |
| 2024-11-08 05:20:00 | SPY | ETF | 596.11 | 596.11 | 595.95 | 595.95 | 4073.0 |
| 2024-11-08 05:25:00 | SPY | ETF | 595.99 | 595.99 | 595.87 | 595.91 | 31015.0 |
| 2024-11-08 05:30:00 | SPY | ETF | 595.8 | 595.8 | 595.45 | 595.54 | 11017.0 |
| 2024-11-08 05:35:00 | SPY | ETF | 595.55 | 595.6 | 595.22 | 595.22 | 3049.0 |
| 2024-11-08 05:40:00 | SPY | ETF | 595.18 | 595.26 | 595.04 | 595.04 | 2996.0 |
| 2024-11-08 05:45:00 | SPY | ETF | 595.14 | 595.14 | 594.8 | 594.8 | 7260.0 |
| 2024-11-08 05:50:00 | SPY | ETF | 594.89 | 595.08 | 594.86 | 594.86 | 5734.0 |
| 2024-11-08 05:55:00 | SPY | ETF | 594.88 | 595.13 | 594.88 | 595.1 | 1695.0 |
| 2024-11-08 06:00:00 | SPY | ETF | 595.03 | 595.03 | 594.85 | 594.89 | 6682.0 |
| 2024-11-08 06:05:00 | SPY | ETF | 594.89 | 594.99 | 594.72 | 594.99 | 10127.0 |
| 2024-11-08 06:10:00 | SPY | ETF | 595.2 | 595.25 | 595.01 | 595.09 | 3810.0 |
| 2024-11-08 06:15:00 | SPY | ETF | 595.06 | 595.23 | 595.05 | 595.23 | 1187.0 |
| 2024-11-08 06:20:00 | SPY | ETF | 595.28 | 595.28 | 595.1 | 595.13 | 2005.0 |
| 2024-11-08 06:25:00 | SPY | ETF | 595.01 | 595.21 | 595.0 | 595.21 | 1900.0 |
| 2024-11-08 06:30:00 | SPY | ETF | 595.27 | 595.32 | 595.27 | 595.27 | 6644.0 |
| 2024-11-08 06:35:00 | SPY | ETF | 595.19 | 595.4 | 595.19 | 595.4 | 2528.0 |
| 2024-11-08 06:40:00 | SPY | ETF | 595.32 | 595.33 | 595.32 | 595.33 | 687.0 |
| 2024-11-08 06:45:00 | SPY | ETF | 595.37 | 595.38 | 595.29 | 595.35 | 2421.0 |
| 2024-11-08 06:50:00 | SPY | ETF | 595.41 | 595.41 | 595.41 | 595.41 | 100.0 |
| 2024-11-08 06:55:00 | SPY | ETF | 595.37 | 595.39 | 595.36 | 595.39 | 897.0 |
| 2024-11-08 07:00:00 | SPY | ETF | 595.35 | 595.49 | 595.31 | 595.47 | 6951.0 |
| 2024-11-08 07:05:00 | SPY | ETF | 595.45 | 595.5 | 595.35 | 595.44 | 6490.0 |
| 2024-11-08 07:10:00 | SPY | ETF | 595.44 | 595.75 | 595.3 | 595.36 | 38187.0 |
| 2024-11-08 07:15:00 | SPY | ETF | 595.38 | 595.47 | 595.38 | 595.47 | 7207.0 |
| 2024-11-08 07:20:00 | SPY | ETF | 595.48 | 595.48 | 595.48 | 595.48 | 152.0 |
| 2024-11-08 07:25:00 | SPY | ETF | 595.32 | 595.54 | 595.32 | 595.54 | 5380.0 |
| 2024-11-08 07:30:00 | SPY | ETF | 595.59 | 595.75 | 595.59 | 595.71 | 75100.0 |
| 2024-11-08 07:35:00 | SPY | ETF | 595.6 | 595.79 | 595.59 | 595.7 | 20025.0 |
| 2024-11-08 07:40:00 | SPY | ETF | 595.76 | 595.81 | 595.72 | 595.81 | 4520.0 |
| 2024-11-08 07:45:00 | SPY | ETF | 595.8 | 595.92 | 595.7 | 595.7 | 12314.0 |
| 2024-11-08 07:50:00 | SPY | ETF | 595.69 | 595.89 | 595.69 | 595.85 | 6493.0 |
| 2024-11-08 07:55:00 | SPY | ETF | 595.89 | 595.95 | 595.86 | 595.9 | 27975.0 |
| 2024-11-08 08:00:00 | SPY | ETF | 595.88 | 596.67 | 594.9596 | 596.01 | 41582.0 |
| 2024-11-08 08:05:00 | SPY | ETF | 596.0 | 596.06 | 595.9 | 595.91 | 31296.0 |
| 2024-11-08 08:10:00 | SPY | ETF | 595.88 | 595.89 | 595.66 | 595.73 | 17176.0 |
> showing 50 of 125,807 rows — these rows as CSV