PREVIEW / etf_5min / 2024-01-11
file: by_date/etf_5min/2024/2024-01-11.parquet size: 2.3 MB rows: 110,450
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-01-11 04:00:00 | SPY | ETF | 478.46 | 478.47 | 477.5 | 478.29 | 6680.0 |
| 2024-01-11 04:05:00 | SPY | ETF | 478.3 | 478.31 | 478.19 | 478.19 | 1500.0 |
| 2024-01-11 04:10:00 | SPY | ETF | 478.06 | 478.06 | 478.04 | 478.04 | 1657.0 |
| 2024-01-11 04:15:00 | SPY | ETF | 478.06 | 478.06 | 477.94 | 477.98 | 3900.0 |
| 2024-01-11 04:20:00 | SPY | ETF | 478.01 | 478.04 | 477.98 | 478.04 | 3310.0 |
| 2024-01-11 04:25:00 | SPY | ETF | 477.92 | 477.98 | 477.92 | 477.96 | 2180.0 |
| 2024-01-11 04:30:00 | SPY | ETF | 477.94 | 477.94 | 477.67 | 477.68 | 5708.0 |
| 2024-01-11 04:35:00 | SPY | ETF | 477.7 | 477.74 | 477.64 | 477.68 | 704.0 |
| 2024-01-11 04:40:00 | SPY | ETF | 477.59 | 477.6 | 477.55 | 477.55 | 1504.0 |
| 2024-01-11 04:45:00 | SPY | ETF | 477.59 | 477.59 | 477.59 | 477.59 | 100.0 |
| 2024-01-11 04:50:00 | SPY | ETF | 477.63 | 477.72 | 477.63 | 477.72 | 509.0 |
| 2024-01-11 05:00:00 | SPY | ETF | 477.61 | 477.7 | 477.61 | 477.7 | 500.0 |
| 2024-01-11 05:05:00 | SPY | ETF | 477.6 | 477.62 | 477.6 | 477.61 | 750.0 |
| 2024-01-11 05:10:00 | SPY | ETF | 477.59 | 477.59 | 477.52 | 477.52 | 200.0 |
| 2024-01-11 05:15:00 | SPY | ETF | 477.57 | 477.59 | 477.57 | 477.59 | 200.0 |
| 2024-01-11 05:20:00 | SPY | ETF | 477.6 | 477.63 | 477.51 | 477.51 | 10701.0 |
| 2024-01-11 05:25:00 | SPY | ETF | 477.63 | 477.63 | 477.63 | 477.63 | 100.0 |
| 2024-01-11 05:30:00 | SPY | ETF | 477.58 | 477.58 | 477.49 | 477.51 | 3400.0 |
| 2024-01-11 05:35:00 | SPY | ETF | 477.47 | 477.47 | 477.43 | 477.45 | 1100.0 |
| 2024-01-11 05:40:00 | SPY | ETF | 477.31 | 477.32 | 477.31 | 477.32 | 200.0 |
| 2024-01-11 05:45:00 | SPY | ETF | 477.32 | 477.32 | 477.24 | 477.24 | 1024.0 |
| 2024-01-11 05:50:00 | SPY | ETF | 477.24 | 477.25 | 477.24 | 477.25 | 200.0 |
| 2024-01-11 06:05:00 | SPY | ETF | 477.53 | 477.6 | 477.53 | 477.6 | 700.0 |
| 2024-01-11 06:10:00 | SPY | ETF | 477.59 | 477.59 | 477.59 | 477.59 | 922.0 |
| 2024-01-11 06:15:00 | SPY | ETF | 477.66 | 477.67 | 477.66 | 477.67 | 295.0 |
| 2024-01-11 06:20:00 | SPY | ETF | 477.71 | 477.71 | 477.55 | 477.55 | 300.0 |
| 2024-01-11 06:25:00 | SPY | ETF | 477.5 | 477.56 | 477.49 | 477.49 | 54900.0 |
| 2024-01-11 06:30:00 | SPY | ETF | 477.53 | 477.53 | 477.53 | 477.53 | 700.0 |
| 2024-01-11 06:40:00 | SPY | ETF | 477.58 | 477.58 | 477.45 | 477.45 | 300.0 |
| 2024-01-11 06:45:00 | SPY | ETF | 477.49 | 477.49 | 477.3 | 477.37 | 1670.0 |
| 2024-01-11 06:50:00 | SPY | ETF | 477.42 | 477.44 | 477.42 | 477.44 | 420.0 |
| 2024-01-11 06:55:00 | SPY | ETF | 477.45 | 477.49 | 477.45 | 477.45 | 1500.0 |
| 2024-01-11 07:00:00 | SPY | ETF | 477.47 | 477.59 | 477.04 | 477.32 | 118598.0 |
| 2024-01-11 07:05:00 | SPY | ETF | 477.32 | 477.44 | 477.24 | 477.43 | 2418.0 |
| 2024-01-11 07:10:00 | SPY | ETF | 477.37 | 477.37 | 477.26 | 477.3 | 5462.0 |
| 2024-01-11 07:15:00 | SPY | ETF | 477.35 | 477.44 | 477.33 | 477.44 | 5729.0 |
| 2024-01-11 07:20:00 | SPY | ETF | 477.44 | 477.56 | 477.43 | 477.56 | 7280.0 |
| 2024-01-11 07:25:00 | SPY | ETF | 477.56 | 477.71 | 477.55 | 477.62 | 17174.0 |
| 2024-01-11 07:30:00 | SPY | ETF | 477.66 | 477.66 | 477.57 | 477.63 | 2848.0 |
| 2024-01-11 07:35:00 | SPY | ETF | 477.7 | 477.75 | 477.67 | 477.68 | 3502.0 |
| 2024-01-11 07:40:00 | SPY | ETF | 477.65 | 477.73 | 477.64 | 477.68 | 2011.0 |
| 2024-01-11 07:45:00 | SPY | ETF | 477.73 | 477.77 | 477.64 | 477.64 | 5354.0 |
| 2024-01-11 07:50:00 | SPY | ETF | 477.62 | 477.7 | 477.6 | 477.65 | 7708.0 |
| 2024-01-11 07:55:00 | SPY | ETF | 477.57 | 477.59 | 477.47 | 477.47 | 8435.0 |
| 2024-01-11 08:00:00 | SPY | ETF | 477.5199 | 478.38 | 477.27 | 477.54 | 43514.0 |
| 2024-01-11 08:05:00 | SPY | ETF | 477.64 | 477.7 | 477.57 | 477.59 | 18366.0 |
| 2024-01-11 08:10:00 | SPY | ETF | 477.64 | 477.73 | 477.61 | 477.73 | 12172.0 |
| 2024-01-11 08:15:00 | SPY | ETF | 477.67 | 477.7464 | 477.63 | 477.7464 | 47924.0 |
| 2024-01-11 08:20:00 | SPY | ETF | 477.71 | 477.77 | 477.63 | 477.73 | 21188.0 |
| 2024-01-11 08:25:00 | SPY | ETF | 477.76 | 478.02 | 477.71 | 477.8 | 40720.0 |
> showing 50 of 110,450 rows — these rows as CSV