PREVIEW / etf_5min / 2024-07-11
file: by_date/etf_5min/2024/2024-07-11.parquet size: 2.4 MB rows: 118,237
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-11 04:00:00 | SPY | ETF | 561.1 | 561.28 | 561.1 | 561.28 | 2520.0 |
| 2024-07-11 04:05:00 | SPY | ETF | 561.3 | 561.35 | 561.21 | 561.21 | 1007.0 |
| 2024-07-11 04:10:00 | SPY | ETF | 561.27 | 561.27 | 561.24 | 561.24 | 983.0 |
| 2024-07-11 04:15:00 | SPY | ETF | 561.33 | 561.36 | 561.27 | 561.27 | 600.0 |
| 2024-07-11 04:25:00 | SPY | ETF | 561.19 | 561.24 | 561.19 | 561.24 | 623.0 |
| 2024-07-11 04:30:00 | SPY | ETF | 561.36 | 561.36 | 561.21 | 561.21 | 744.0 |
| 2024-07-11 04:35:00 | SPY | ETF | 561.22 | 561.3 | 561.22 | 561.25 | 835.0 |
| 2024-07-11 04:40:00 | SPY | ETF | 561.23 | 561.23 | 561.14 | 561.14 | 858.0 |
| 2024-07-11 04:45:00 | SPY | ETF | 561.22 | 561.22 | 561.16 | 561.16 | 715.0 |
| 2024-07-11 04:55:00 | SPY | ETF | 561.13 | 561.13 | 561.13 | 561.13 | 100.0 |
| 2024-07-11 05:00:00 | SPY | ETF | 561.03 | 561.03 | 561.03 | 561.03 | 117.0 |
| 2024-07-11 05:05:00 | SPY | ETF | 561.02 | 561.06 | 561.01 | 561.06 | 1294.0 |
| 2024-07-11 05:10:00 | SPY | ETF | 561.02 | 561.02 | 561.0 | 561.01 | 2400.0 |
| 2024-07-11 05:15:00 | SPY | ETF | 561.02 | 561.02 | 561.02 | 561.02 | 100.0 |
| 2024-07-11 05:20:00 | SPY | ETF | 561.08 | 561.08 | 561.08 | 561.08 | 300.0 |
| 2024-07-11 05:25:00 | SPY | ETF | 561.01 | 561.03 | 561.01 | 561.03 | 1056.0 |
| 2024-07-11 05:40:00 | SPY | ETF | 561.03 | 561.03 | 561.03 | 561.03 | 500.0 |
| 2024-07-11 05:45:00 | SPY | ETF | 561.04 | 561.09 | 561.04 | 561.05 | 700.0 |
| 2024-07-11 05:50:00 | SPY | ETF | 561.08 | 561.08 | 561.08 | 561.08 | 100.0 |
| 2024-07-11 06:00:00 | SPY | ETF | 561.06 | 561.06 | 561.06 | 561.06 | 178.0 |
| 2024-07-11 06:10:00 | SPY | ETF | 561.03 | 561.03 | 560.97 | 561.01 | 1218.0 |
| 2024-07-11 06:15:00 | SPY | ETF | 560.96 | 560.96 | 560.95 | 560.95 | 1497.0 |
| 2024-07-11 06:20:00 | SPY | ETF | 561.01 | 561.01 | 561.01 | 561.01 | 100.0 |
| 2024-07-11 06:25:00 | SPY | ETF | 560.98 | 560.98 | 560.97 | 560.98 | 1000.0 |
| 2024-07-11 06:30:00 | SPY | ETF | 560.95 | 560.95 | 560.95 | 560.95 | 100.0 |
| 2024-07-11 06:35:00 | SPY | ETF | 560.87 | 560.87 | 560.85 | 560.85 | 205.0 |
| 2024-07-11 06:40:00 | SPY | ETF | 560.83 | 560.83 | 560.77 | 560.81 | 4790.0 |
| 2024-07-11 06:45:00 | SPY | ETF | 560.85 | 560.85 | 560.85 | 560.85 | 100.0 |
| 2024-07-11 06:50:00 | SPY | ETF | 560.91 | 560.91 | 560.8 | 560.8 | 579.0 |
| 2024-07-11 06:55:00 | SPY | ETF | 560.85 | 560.94 | 560.85 | 560.94 | 1188.0 |
| 2024-07-11 07:00:00 | SPY | ETF | 560.93 | 560.99 | 560.91 | 560.99 | 70293.0 |
| 2024-07-11 07:05:00 | SPY | ETF | 560.98 | 561.0 | 560.98 | 561.0 | 15784.0 |
| 2024-07-11 07:10:00 | SPY | ETF | 561.01 | 561.02 | 560.92 | 560.92 | 6579.0 |
| 2024-07-11 07:15:00 | SPY | ETF | 560.92 | 560.97 | 560.89 | 560.94 | 12876.0 |
| 2024-07-11 07:20:00 | SPY | ETF | 560.95 | 560.95 | 560.88 | 560.88 | 35435.0 |
| 2024-07-11 07:25:00 | SPY | ETF | 560.88 | 560.91 | 560.86 | 560.91 | 26458.0 |
| 2024-07-11 07:30:00 | SPY | ETF | 560.95 | 560.95 | 560.9 | 560.9 | 5712.0 |
| 2024-07-11 07:35:00 | SPY | ETF | 560.9 | 560.93 | 560.89 | 560.93 | 586.0 |
| 2024-07-11 07:40:00 | SPY | ETF | 560.89 | 560.94 | 560.89 | 560.94 | 1839.0 |
| 2024-07-11 07:45:00 | SPY | ETF | 560.9 | 560.9 | 560.85 | 560.85 | 12151.0 |
| 2024-07-11 07:50:00 | SPY | ETF | 560.84 | 560.84 | 560.8 | 560.81 | 5367.0 |
| 2024-07-11 07:55:00 | SPY | ETF | 560.8 | 560.83 | 560.78 | 560.79 | 6030.0 |
| 2024-07-11 08:00:00 | SPY | ETF | 560.9298 | 561.48 | 560.76 | 560.78 | 96889.0 |
| 2024-07-11 08:05:00 | SPY | ETF | 560.78 | 560.82 | 560.75 | 560.8 | 55190.0 |
| 2024-07-11 08:10:00 | SPY | ETF | 560.81 | 560.81 | 560.7503 | 560.76 | 17571.0 |
| 2024-07-11 08:15:00 | SPY | ETF | 560.76 | 560.76 | 560.58 | 560.58 | 47620.0 |
| 2024-07-11 08:20:00 | SPY | ETF | 560.56 | 560.6 | 560.52 | 560.6 | 21820.0 |
| 2024-07-11 08:25:00 | SPY | ETF | 560.65 | 561.02 | 560.65 | 561.02 | 25346.0 |
| 2024-07-11 08:30:00 | SPY | ETF | 561.97 | 563.52 | 561.0 | 563.15 | 648357.0 |
| 2024-07-11 08:35:00 | SPY | ETF | 563.13 | 563.21 | 562.09 | 563.11 | 265273.0 |
> showing 50 of 118,237 rows — these rows as CSV