PREVIEW / etf_5min / 2024-10-21
file: by_date/etf_5min/2024/2024-10-21.parquet size: 2.4 MB rows: 118,836
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-10-21 04:00:00 | SPY | ETF | 584.28 | 584.59 | 584.28 | 584.5 | 6147.0 |
| 2024-10-21 04:05:00 | SPY | ETF | 584.55 | 584.55 | 584.49 | 584.49 | 5801.0 |
| 2024-10-21 04:10:00 | SPY | ETF | 584.47 | 584.47 | 584.23 | 584.23 | 2843.0 |
| 2024-10-21 04:15:00 | SPY | ETF | 584.23 | 584.31 | 584.22 | 584.31 | 3584.0 |
| 2024-10-21 04:20:00 | SPY | ETF | 584.33 | 584.33 | 584.33 | 584.33 | 200.0 |
| 2024-10-21 04:30:00 | SPY | ETF | 584.29 | 584.29 | 584.29 | 584.29 | 681.0 |
| 2024-10-21 04:40:00 | SPY | ETF | 584.42 | 584.43 | 584.37 | 584.37 | 588.0 |
| 2024-10-21 04:45:00 | SPY | ETF | 584.46 | 584.46 | 584.46 | 584.46 | 100.0 |
| 2024-10-21 05:00:00 | SPY | ETF | 584.46 | 584.46 | 584.37 | 584.37 | 661.0 |
| 2024-10-21 05:10:00 | SPY | ETF | 584.27 | 584.31 | 584.27 | 584.27 | 690.0 |
| 2024-10-21 05:15:00 | SPY | ETF | 584.22 | 584.22 | 584.17 | 584.17 | 1900.0 |
| 2024-10-21 05:20:00 | SPY | ETF | 584.17 | 584.17 | 584.08 | 584.08 | 2970.0 |
| 2024-10-21 05:25:00 | SPY | ETF | 583.88 | 583.88 | 583.63 | 583.63 | 5874.0 |
| 2024-10-21 05:30:00 | SPY | ETF | 583.68 | 583.68 | 583.27 | 583.54 | 3292.0 |
| 2024-10-21 05:35:00 | SPY | ETF | 583.57 | 583.79 | 583.57 | 583.79 | 1783.0 |
| 2024-10-21 05:40:00 | SPY | ETF | 583.87 | 583.88 | 583.87 | 583.88 | 2494.0 |
| 2024-10-21 05:55:00 | SPY | ETF | 583.89 | 583.89 | 583.81 | 583.81 | 202.0 |
| 2024-10-21 06:00:00 | SPY | ETF | 583.8 | 583.8 | 583.78 | 583.78 | 200.0 |
| 2024-10-21 06:05:00 | SPY | ETF | 583.71 | 583.71 | 583.71 | 583.71 | 150.0 |
| 2024-10-21 06:10:00 | SPY | ETF | 583.79 | 583.79 | 583.79 | 583.79 | 333.0 |
| 2024-10-21 06:25:00 | SPY | ETF | 583.67 | 583.77 | 583.67 | 583.77 | 250.0 |
| 2024-10-21 06:30:00 | SPY | ETF | 583.79 | 583.79 | 583.79 | 583.79 | 1474.0 |
| 2024-10-21 06:35:00 | SPY | ETF | 583.67 | 583.67 | 583.45 | 583.48 | 1860.0 |
| 2024-10-21 06:40:00 | SPY | ETF | 583.43 | 583.52 | 583.2 | 583.2 | 8482.0 |
| 2024-10-21 06:45:00 | SPY | ETF | 583.15 | 583.15 | 582.82 | 583.05 | 12921.0 |
| 2024-10-21 06:50:00 | SPY | ETF | 582.92 | 583.0 | 582.83 | 582.96 | 3208.0 |
| 2024-10-21 06:55:00 | SPY | ETF | 582.95 | 583.0 | 582.8 | 582.84 | 5835.0 |
| 2024-10-21 07:00:00 | SPY | ETF | 582.81 | 582.97 | 582.68 | 582.96 | 14643.0 |
| 2024-10-21 07:05:00 | SPY | ETF | 582.9 | 583.04 | 582.83 | 582.93 | 24659.0 |
| 2024-10-21 07:10:00 | SPY | ETF | 583.0 | 583.0 | 582.87 | 582.9 | 7212.0 |
| 2024-10-21 07:15:00 | SPY | ETF | 582.93 | 582.93 | 582.48 | 582.67 | 37181.0 |
| 2024-10-21 07:20:00 | SPY | ETF | 582.69 | 582.69 | 582.5 | 582.56 | 26413.0 |
| 2024-10-21 07:25:00 | SPY | ETF | 582.5 | 582.64 | 582.46 | 582.53 | 9374.0 |
| 2024-10-21 07:30:00 | SPY | ETF | 582.44 | 582.73 | 582.38 | 582.7 | 19376.0 |
| 2024-10-21 07:35:00 | SPY | ETF | 582.64 | 582.72 | 582.58 | 582.63 | 4376.0 |
| 2024-10-21 07:40:00 | SPY | ETF | 582.63 | 582.8 | 582.63 | 582.75 | 26913.0 |
| 2024-10-21 07:45:00 | SPY | ETF | 582.71 | 582.88 | 582.55 | 582.88 | 6416.0 |
| 2024-10-21 07:50:00 | SPY | ETF | 582.75 | 582.75 | 582.7 | 582.7 | 1600.0 |
| 2024-10-21 07:55:00 | SPY | ETF | 582.7 | 582.7 | 582.62 | 582.62 | 777.0 |
| 2024-10-21 08:00:00 | SPY | ETF | 582.91 | 584.75 | 582.4 | 582.62 | 18618.0 |
| 2024-10-21 08:05:00 | SPY | ETF | 582.59 | 582.75 | 582.59 | 582.67 | 3934.0 |
| 2024-10-21 08:10:00 | SPY | ETF | 582.7182 | 582.84 | 582.605 | 582.77 | 14891.0 |
| 2024-10-21 08:15:00 | SPY | ETF | 582.85 | 582.99 | 582.77 | 582.88 | 11892.0 |
| 2024-10-21 08:20:00 | SPY | ETF | 582.89 | 583.14 | 582.88 | 582.95 | 9603.0 |
| 2024-10-21 08:25:00 | SPY | ETF | 582.97 | 583.07 | 582.97 | 583.06 | 4418.0 |
| 2024-10-21 08:30:00 | SPY | ETF | 583.07 | 583.27 | 583.07 | 583.27 | 30531.0 |
| 2024-10-21 08:35:00 | SPY | ETF | 583.23 | 583.33 | 583.05 | 583.05 | 22430.0 |
| 2024-10-21 08:40:00 | SPY | ETF | 583.11 | 583.2 | 583.08 | 583.2 | 2878.0 |
| 2024-10-21 08:45:00 | SPY | ETF | 583.25 | 583.4 | 583.23 | 583.3678 | 11764.0 |
| 2024-10-21 08:50:00 | SPY | ETF | 583.33 | 583.34 | 583.25 | 583.34 | 23796.0 |
> showing 50 of 118,836 rows — these rows as CSV