PREVIEW / etf_5min / 2024-07-08
file: by_date/etf_5min/2024/2024-07-08.parquet size: 2.3 MB rows: 113,071
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-07-08 04:00:00 | SPY | ETF | 553.85 | 554.44 | 553.85 | 554.4 | 2049.0 |
| 2024-07-08 04:05:00 | SPY | ETF | 554.37 | 554.49 | 554.36 | 554.36 | 1900.0 |
| 2024-07-08 04:10:00 | SPY | ETF | 554.38 | 554.41 | 554.36 | 554.4 | 1381.0 |
| 2024-07-08 04:15:00 | SPY | ETF | 554.42 | 554.42 | 554.42 | 554.42 | 100.0 |
| 2024-07-08 04:25:00 | SPY | ETF | 554.43 | 554.52 | 554.43 | 554.43 | 1268.0 |
| 2024-07-08 04:30:00 | SPY | ETF | 554.45 | 554.65 | 554.41 | 554.65 | 643.0 |
| 2024-07-08 04:35:00 | SPY | ETF | 554.57 | 554.57 | 554.5 | 554.5 | 688.0 |
| 2024-07-08 04:50:00 | SPY | ETF | 554.58 | 554.58 | 554.58 | 554.58 | 200.0 |
| 2024-07-08 04:55:00 | SPY | ETF | 554.53 | 554.53 | 554.53 | 554.53 | 100.0 |
| 2024-07-08 05:05:00 | SPY | ETF | 554.46 | 554.46 | 554.44 | 554.44 | 934.0 |
| 2024-07-08 05:10:00 | SPY | ETF | 554.43 | 554.54 | 554.43 | 554.54 | 441.0 |
| 2024-07-08 05:15:00 | SPY | ETF | 554.55 | 554.55 | 554.55 | 554.55 | 399.0 |
| 2024-07-08 05:20:00 | SPY | ETF | 554.5 | 554.52 | 554.5 | 554.52 | 300.0 |
| 2024-07-08 05:25:00 | SPY | ETF | 554.54 | 554.54 | 554.52 | 554.54 | 718.0 |
| 2024-07-08 05:30:00 | SPY | ETF | 554.52 | 554.52 | 554.52 | 554.52 | 107.0 |
| 2024-07-08 05:35:00 | SPY | ETF | 554.5 | 554.5 | 554.47 | 554.47 | 211.0 |
| 2024-07-08 05:40:00 | SPY | ETF | 554.56 | 554.56 | 554.51 | 554.55 | 1100.0 |
| 2024-07-08 05:45:00 | SPY | ETF | 554.58 | 554.6 | 554.58 | 554.6 | 222.0 |
| 2024-07-08 05:50:00 | SPY | ETF | 554.63 | 554.65 | 554.58 | 554.65 | 577.0 |
| 2024-07-08 05:55:00 | SPY | ETF | 554.56 | 554.56 | 554.5 | 554.5 | 3374.0 |
| 2024-07-08 06:00:00 | SPY | ETF | 554.51 | 554.51 | 554.5 | 554.5 | 18242.0 |
| 2024-07-08 06:15:00 | SPY | ETF | 554.6 | 554.6 | 554.59 | 554.59 | 200.0 |
| 2024-07-08 06:20:00 | SPY | ETF | 554.57 | 554.57 | 554.57 | 554.57 | 200.0 |
| 2024-07-08 06:25:00 | SPY | ETF | 554.57 | 554.58 | 554.53 | 554.54 | 10981.0 |
| 2024-07-08 06:30:00 | SPY | ETF | 554.56 | 554.56 | 554.51 | 554.51 | 326.0 |
| 2024-07-08 06:35:00 | SPY | ETF | 554.58 | 554.6 | 554.58 | 554.58 | 1169.0 |
| 2024-07-08 06:40:00 | SPY | ETF | 554.54 | 554.54 | 554.52 | 554.52 | 383.0 |
| 2024-07-08 06:45:00 | SPY | ETF | 554.49 | 554.54 | 554.47 | 554.47 | 5072.0 |
| 2024-07-08 06:50:00 | SPY | ETF | 554.55 | 554.55 | 554.47 | 554.47 | 400.0 |
| 2024-07-08 06:55:00 | SPY | ETF | 554.47 | 554.49 | 554.44 | 554.49 | 549.0 |
| 2024-07-08 07:00:00 | SPY | ETF | 554.44 | 554.5 | 554.42 | 554.5 | 1796.0 |
| 2024-07-08 07:05:00 | SPY | ETF | 554.51 | 554.69 | 554.5 | 554.68 | 5116.0 |
| 2024-07-08 07:10:00 | SPY | ETF | 554.6 | 554.78 | 554.57 | 554.78 | 4800.0 |
| 2024-07-08 07:15:00 | SPY | ETF | 554.79 | 554.79 | 554.74 | 554.74 | 900.0 |
| 2024-07-08 07:20:00 | SPY | ETF | 554.75 | 554.77 | 554.75 | 554.77 | 920.0 |
| 2024-07-08 07:25:00 | SPY | ETF | 554.77 | 554.81 | 554.77 | 554.81 | 1050.0 |
| 2024-07-08 07:30:00 | SPY | ETF | 554.82 | 554.92 | 554.79 | 554.92 | 8393.0 |
| 2024-07-08 07:35:00 | SPY | ETF | 554.87 | 554.9 | 554.87 | 554.89 | 879.0 |
| 2024-07-08 07:40:00 | SPY | ETF | 554.9 | 554.9 | 554.84 | 554.84 | 940.0 |
| 2024-07-08 07:45:00 | SPY | ETF | 554.8 | 554.89 | 554.8 | 554.88 | 9744.0 |
| 2024-07-08 07:50:00 | SPY | ETF | 554.85 | 554.88 | 554.84 | 554.88 | 989.0 |
| 2024-07-08 07:55:00 | SPY | ETF | 554.87 | 554.92 | 554.87 | 554.89 | 3408.0 |
| 2024-07-08 08:00:00 | SPY | ETF | 554.5 | 554.89 | 553.75 | 553.95 | 27803.0 |
| 2024-07-08 08:05:00 | SPY | ETF | 553.9 | 554.98 | 553.9 | 554.95 | 22511.0 |
| 2024-07-08 08:10:00 | SPY | ETF | 554.9295 | 554.9295 | 554.9 | 554.9 | 10200.0 |
| 2024-07-08 08:15:00 | SPY | ETF | 554.931 | 555.0 | 554.92 | 554.9999 | 14025.0 |
| 2024-07-08 08:20:00 | SPY | ETF | 554.99 | 555.02 | 554.956 | 555.0 | 8526.0 |
| 2024-07-08 08:25:00 | SPY | ETF | 554.99 | 555.09 | 554.99 | 555.04 | 9625.0 |
| 2024-07-08 08:30:00 | SPY | ETF | 555.06 | 555.18 | 555.01 | 555.12 | 26097.0 |
| 2024-07-08 08:35:00 | SPY | ETF | 555.1 | 555.19 | 555.1 | 555.18 | 6634.0 |
> showing 50 of 113,071 rows — these rows as CSV