PREVIEW / etf_5min / 2024-07-10
file: by_date/etf_5min/2024/2024-07-10.parquet size: 2.3 MB rows: 112,238
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-10 04:00:00 | SPY | ETF | 556.27 | 556.34 | 556.25 | 556.25 | 860.0 |
| 2024-07-10 04:05:00 | SPY | ETF | 556.32 | 556.35 | 556.29 | 556.3 | 737.0 |
| 2024-07-10 04:15:00 | SPY | ETF | 556.39 | 556.39 | 556.39 | 556.39 | 120.0 |
| 2024-07-10 04:20:00 | SPY | ETF | 556.34 | 556.38 | 556.34 | 556.38 | 400.0 |
| 2024-07-10 04:25:00 | SPY | ETF | 556.35 | 556.41 | 556.34 | 556.41 | 5549.0 |
| 2024-07-10 04:30:00 | SPY | ETF | 556.46 | 556.5 | 556.43 | 556.5 | 1093.0 |
| 2024-07-10 04:35:00 | SPY | ETF | 556.46 | 556.51 | 556.45 | 556.51 | 331.0 |
| 2024-07-10 04:40:00 | SPY | ETF | 556.42 | 556.42 | 556.42 | 556.42 | 130.0 |
| 2024-07-10 04:55:00 | SPY | ETF | 556.46 | 556.5 | 556.46 | 556.5 | 200.0 |
| 2024-07-10 05:00:00 | SPY | ETF | 556.54 | 556.54 | 556.54 | 556.54 | 100.0 |
| 2024-07-10 05:05:00 | SPY | ETF | 556.55 | 556.56 | 556.51 | 556.56 | 489.0 |
| 2024-07-10 05:10:00 | SPY | ETF | 556.5 | 556.65 | 556.5 | 556.6 | 1099.0 |
| 2024-07-10 05:15:00 | SPY | ETF | 556.63 | 556.67 | 556.61 | 556.62 | 1459.0 |
| 2024-07-10 05:20:00 | SPY | ETF | 556.65 | 556.66 | 556.62 | 556.62 | 441.0 |
| 2024-07-10 05:25:00 | SPY | ETF | 556.66 | 556.71 | 556.66 | 556.71 | 1800.0 |
| 2024-07-10 05:30:00 | SPY | ETF | 556.68 | 556.72 | 556.68 | 556.72 | 350.0 |
| 2024-07-10 05:35:00 | SPY | ETF | 556.72 | 556.72 | 556.71 | 556.71 | 606.0 |
| 2024-07-10 05:40:00 | SPY | ETF | 556.65 | 556.65 | 556.61 | 556.61 | 1280.0 |
| 2024-07-10 05:45:00 | SPY | ETF | 556.58 | 556.58 | 556.58 | 556.58 | 200.0 |
| 2024-07-10 05:50:00 | SPY | ETF | 556.68 | 556.68 | 556.63 | 556.63 | 1198.0 |
| 2024-07-10 05:55:00 | SPY | ETF | 556.72 | 556.72 | 556.72 | 556.72 | 386.0 |
| 2024-07-10 06:00:00 | SPY | ETF | 556.71 | 556.71 | 556.71 | 556.71 | 100.0 |
| 2024-07-10 06:05:00 | SPY | ETF | 556.71 | 556.71 | 556.71 | 556.71 | 300.0 |
| 2024-07-10 06:10:00 | SPY | ETF | 556.6 | 556.6 | 556.6 | 556.6 | 400.0 |
| 2024-07-10 06:15:00 | SPY | ETF | 556.71 | 556.74 | 556.71 | 556.74 | 423.0 |
| 2024-07-10 06:20:00 | SPY | ETF | 556.74 | 556.74 | 556.74 | 556.74 | 200.0 |
| 2024-07-10 06:30:00 | SPY | ETF | 556.74 | 556.74 | 556.72 | 556.72 | 869.0 |
| 2024-07-10 06:35:00 | SPY | ETF | 556.69 | 556.72 | 556.69 | 556.72 | 918.0 |
| 2024-07-10 06:40:00 | SPY | ETF | 556.77 | 556.77 | 556.77 | 556.77 | 400.0 |
| 2024-07-10 06:50:00 | SPY | ETF | 556.7 | 556.7 | 556.7 | 556.7 | 100.0 |
| 2024-07-10 07:00:00 | SPY | ETF | 556.67 | 556.7 | 556.56 | 556.6 | 11704.0 |
| 2024-07-10 07:05:00 | SPY | ETF | 556.62 | 556.76 | 556.61 | 556.72 | 4032.0 |
| 2024-07-10 07:10:00 | SPY | ETF | 556.73 | 556.73 | 556.73 | 556.73 | 492.0 |
| 2024-07-10 07:15:00 | SPY | ETF | 556.68 | 556.73 | 556.68 | 556.73 | 2049.0 |
| 2024-07-10 07:20:00 | SPY | ETF | 556.68 | 556.68 | 556.6 | 556.6 | 8380.0 |
| 2024-07-10 07:25:00 | SPY | ETF | 556.64 | 556.64 | 556.64 | 556.64 | 100.0 |
| 2024-07-10 07:30:00 | SPY | ETF | 556.69 | 556.76 | 556.69 | 556.76 | 1750.0 |
| 2024-07-10 07:35:00 | SPY | ETF | 556.76 | 556.92 | 556.76 | 556.9 | 2550.0 |
| 2024-07-10 07:40:00 | SPY | ETF | 556.92 | 557.0 | 556.92 | 557.0 | 6366.0 |
| 2024-07-10 07:45:00 | SPY | ETF | 557.09 | 557.18 | 557.05 | 557.05 | 32824.0 |
| 2024-07-10 07:50:00 | SPY | ETF | 557.09 | 557.14 | 557.05 | 557.05 | 24976.0 |
| 2024-07-10 07:55:00 | SPY | ETF | 557.14 | 557.14 | 557.07 | 557.07 | 1500.0 |
| 2024-07-10 08:00:00 | SPY | ETF | 556.6604 | 557.1786 | 555.95 | 557.0904 | 27763.0 |
| 2024-07-10 08:05:00 | SPY | ETF | 557.111 | 557.31 | 557.111 | 557.31 | 17738.0 |
| 2024-07-10 08:10:00 | SPY | ETF | 557.32 | 557.35 | 557.31 | 557.34 | 39465.0 |
| 2024-07-10 08:15:00 | SPY | ETF | 557.3202 | 557.3202 | 557.29 | 557.29 | 9556.0 |
| 2024-07-10 08:20:00 | SPY | ETF | 557.29 | 557.3 | 557.2 | 557.26 | 4153.0 |
| 2024-07-10 08:25:00 | SPY | ETF | 557.25 | 557.32 | 557.24 | 557.28 | 15978.0 |
| 2024-07-10 08:30:00 | SPY | ETF | 557.3 | 557.38 | 557.28 | 557.31 | 15663.0 |
| 2024-07-10 08:35:00 | SPY | ETF | 557.31 | 557.31 | 557.2 | 557.24 | 4323.0 |
> showing 50 of 112,238 rows — these rows as CSV