PREVIEW / etf_5min / 2024-10-30
file: by_date/etf_5min/2024/2024-10-30.parquet size: 2.4 MB rows: 118,252
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-30 04:00:00 | SPY | ETF | 582.89 | 583.16 | 582.89 | 583.16 | 1984.0 |
| 2024-10-30 04:05:00 | SPY | ETF | 582.97 | 582.97 | 582.82 | 582.85 | 3339.0 |
| 2024-10-30 04:10:00 | SPY | ETF | 582.71 | 582.95 | 582.5 | 582.81 | 2206.0 |
| 2024-10-30 04:15:00 | SPY | ETF | 582.93 | 582.99 | 582.93 | 582.99 | 1265.0 |
| 2024-10-30 04:20:00 | SPY | ETF | 583.05 | 583.23 | 583.05 | 583.2 | 629.0 |
| 2024-10-30 04:25:00 | SPY | ETF | 583.06 | 583.13 | 583.04 | 583.13 | 676.0 |
| 2024-10-30 04:30:00 | SPY | ETF | 583.05 | 583.05 | 583.05 | 583.05 | 100.0 |
| 2024-10-30 04:35:00 | SPY | ETF | 583.14 | 583.14 | 583.06 | 583.12 | 1292.0 |
| 2024-10-30 04:40:00 | SPY | ETF | 583.0 | 583.0 | 582.78 | 582.78 | 1149.0 |
| 2024-10-30 04:45:00 | SPY | ETF | 582.82 | 582.82 | 582.72 | 582.72 | 2473.0 |
| 2024-10-30 04:50:00 | SPY | ETF | 582.92 | 582.92 | 582.84 | 582.84 | 2241.0 |
| 2024-10-30 04:55:00 | SPY | ETF | 582.67 | 582.71 | 582.65 | 582.66 | 1492.0 |
| 2024-10-30 05:00:00 | SPY | ETF | 582.58 | 582.79 | 582.5 | 582.57 | 1796.0 |
| 2024-10-30 05:05:00 | SPY | ETF | 582.73 | 582.73 | 582.73 | 582.73 | 100.0 |
| 2024-10-30 05:10:00 | SPY | ETF | 582.71 | 582.87 | 582.67 | 582.87 | 1292.0 |
| 2024-10-30 05:15:00 | SPY | ETF | 582.93 | 582.94 | 582.93 | 582.94 | 489.0 |
| 2024-10-30 05:20:00 | SPY | ETF | 582.87 | 583.06 | 582.87 | 583.06 | 211.0 |
| 2024-10-30 05:25:00 | SPY | ETF | 583.07 | 583.09 | 582.93 | 583.06 | 1266.0 |
| 2024-10-30 05:30:00 | SPY | ETF | 583.13 | 583.13 | 583.1 | 583.13 | 653.0 |
| 2024-10-30 05:35:00 | SPY | ETF | 583.08 | 583.08 | 583.08 | 583.08 | 109.0 |
| 2024-10-30 05:40:00 | SPY | ETF | 583.0 | 583.0 | 582.89 | 582.89 | 938.0 |
| 2024-10-30 05:45:00 | SPY | ETF | 582.75 | 582.75 | 582.75 | 582.75 | 161.0 |
| 2024-10-30 05:50:00 | SPY | ETF | 582.94 | 582.94 | 582.94 | 582.94 | 336.0 |
| 2024-10-30 05:55:00 | SPY | ETF | 582.92 | 582.92 | 582.92 | 582.92 | 123.0 |
| 2024-10-30 06:00:00 | SPY | ETF | 582.95 | 582.98 | 582.9 | 582.94 | 29297.0 |
| 2024-10-30 06:05:00 | SPY | ETF | 582.98 | 582.98 | 582.7 | 582.73 | 13470.0 |
| 2024-10-30 06:10:00 | SPY | ETF | 582.66 | 582.89 | 582.65 | 582.89 | 10020.0 |
| 2024-10-30 06:15:00 | SPY | ETF | 582.83 | 582.96 | 582.83 | 582.92 | 1275.0 |
| 2024-10-30 06:20:00 | SPY | ETF | 583.04 | 583.04 | 582.96 | 582.96 | 527.0 |
| 2024-10-30 06:25:00 | SPY | ETF | 582.89 | 583.05 | 582.89 | 583.05 | 507.0 |
| 2024-10-30 06:30:00 | SPY | ETF | 583.02 | 583.02 | 582.55 | 582.58 | 5351.0 |
| 2024-10-30 06:35:00 | SPY | ETF | 582.65 | 582.65 | 582.58 | 582.6 | 1643.0 |
| 2024-10-30 06:40:00 | SPY | ETF | 582.73 | 582.73 | 582.63 | 582.73 | 833.0 |
| 2024-10-30 06:45:00 | SPY | ETF | 582.6 | 582.6 | 582.0 | 582.22 | 36137.0 |
| 2024-10-30 06:50:00 | SPY | ETF | 582.14 | 582.16 | 582.02 | 582.16 | 4244.0 |
| 2024-10-30 06:55:00 | SPY | ETF | 582.22 | 582.22 | 582.16 | 582.16 | 1774.0 |
| 2024-10-30 07:00:00 | SPY | ETF | 582.13 | 582.22 | 582.06 | 582.12 | 16790.0 |
| 2024-10-30 07:05:00 | SPY | ETF | 582.12 | 582.31 | 582.1 | 582.28 | 3436.0 |
| 2024-10-30 07:10:00 | SPY | ETF | 582.25 | 582.579 | 582.25 | 582.579 | 13858.0 |
| 2024-10-30 07:15:00 | SPY | ETF | 582.49 | 582.64 | 582.49 | 582.63 | 4393.0 |
| 2024-10-30 07:20:00 | SPY | ETF | 582.61 | 582.65 | 582.55 | 582.55 | 10925.0 |
| 2024-10-30 07:25:00 | SPY | ETF | 582.58 | 582.58 | 582.26 | 582.33 | 10870.0 |
| 2024-10-30 07:30:00 | SPY | ETF | 582.36 | 582.41 | 582.35 | 582.4 | 43091.0 |
| 2024-10-30 07:35:00 | SPY | ETF | 582.4 | 582.43 | 582.35 | 582.4 | 17474.0 |
| 2024-10-30 07:40:00 | SPY | ETF | 582.41 | 582.47 | 582.4 | 582.45 | 8160.0 |
| 2024-10-30 07:45:00 | SPY | ETF | 582.43 | 582.44 | 581.97 | 581.97 | 15013.0 |
| 2024-10-30 07:50:00 | SPY | ETF | 581.85 | 581.88 | 581.77 | 581.81 | 15958.0 |
| 2024-10-30 07:55:00 | SPY | ETF | 581.95 | 581.96 | 581.83 | 581.91 | 2568.0 |
| 2024-10-30 08:00:00 | SPY | ETF | 582.37 | 583.06 | 581.78 | 581.8916 | 28121.0 |
| 2024-10-30 08:05:00 | SPY | ETF | 581.8 | 581.83 | 581.69 | 581.79 | 20548.0 |
> showing 50 of 118,252 rows — these rows as CSV