PREVIEW / etf_5min / 2024-05-08
file: by_date/etf_5min/2024/2024-05-08.parquet size: 2.1 MB rows: 105,495
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-05-08 04:00:00 | SPY | ETF | 517.37 | 517.39 | 517.37 | 517.39 | 300.0 |
| 2024-05-08 04:05:00 | SPY | ETF | 517.33 | 517.33 | 517.31 | 517.31 | 995.0 |
| 2024-05-08 04:10:00 | SPY | ETF | 517.31 | 517.31 | 517.31 | 517.31 | 1200.0 |
| 2024-05-08 04:15:00 | SPY | ETF | 517.41 | 517.41 | 517.41 | 517.41 | 100.0 |
| 2024-05-08 04:20:00 | SPY | ETF | 517.4 | 517.4 | 517.4 | 517.4 | 200.0 |
| 2024-05-08 04:25:00 | SPY | ETF | 517.59 | 517.63 | 517.59 | 517.63 | 1000.0 |
| 2024-05-08 04:30:00 | SPY | ETF | 517.54 | 517.54 | 517.44 | 517.44 | 714.0 |
| 2024-05-08 04:35:00 | SPY | ETF | 517.4 | 517.4 | 517.26 | 517.26 | 2150.0 |
| 2024-05-08 04:45:00 | SPY | ETF | 517.32 | 517.32 | 517.25 | 517.25 | 899.0 |
| 2024-05-08 04:50:00 | SPY | ETF | 517.27 | 517.27 | 517.27 | 517.27 | 100.0 |
| 2024-05-08 04:55:00 | SPY | ETF | 517.22 | 517.22 | 517.18 | 517.18 | 920.0 |
| 2024-05-08 05:00:00 | SPY | ETF | 517.16 | 517.16 | 517.15 | 517.15 | 363.0 |
| 2024-05-08 05:05:00 | SPY | ETF | 517.27 | 517.35 | 517.27 | 517.33 | 3609.0 |
| 2024-05-08 05:10:00 | SPY | ETF | 517.31 | 517.31 | 517.3 | 517.3 | 425.0 |
| 2024-05-08 05:20:00 | SPY | ETF | 517.16 | 517.17 | 517.16 | 517.16 | 923.0 |
| 2024-05-08 05:25:00 | SPY | ETF | 517.22 | 517.27 | 517.22 | 517.27 | 450.0 |
| 2024-05-08 05:30:00 | SPY | ETF | 517.19 | 517.27 | 517.19 | 517.27 | 2100.0 |
| 2024-05-08 05:35:00 | SPY | ETF | 517.35 | 517.35 | 517.35 | 517.35 | 190.0 |
| 2024-05-08 05:40:00 | SPY | ETF | 517.35 | 517.35 | 517.35 | 517.35 | 100.0 |
| 2024-05-08 05:45:00 | SPY | ETF | 517.45 | 517.52 | 517.45 | 517.52 | 700.0 |
| 2024-05-08 05:50:00 | SPY | ETF | 517.46 | 517.52 | 517.46 | 517.46 | 345.0 |
| 2024-05-08 05:55:00 | SPY | ETF | 517.35 | 517.35 | 517.35 | 517.35 | 100.0 |
| 2024-05-08 06:00:00 | SPY | ETF | 517.3 | 517.31 | 517.08 | 517.31 | 5131.0 |
| 2024-05-08 06:05:00 | SPY | ETF | 517.43 | 517.43 | 517.43 | 517.43 | 500.0 |
| 2024-05-08 06:10:00 | SPY | ETF | 517.22 | 517.22 | 517.22 | 517.22 | 100.0 |
| 2024-05-08 06:15:00 | SPY | ETF | 517.12 | 517.27 | 517.12 | 517.27 | 1280.0 |
| 2024-05-08 06:30:00 | SPY | ETF | 517.32 | 517.32 | 517.32 | 517.32 | 100.0 |
| 2024-05-08 06:35:00 | SPY | ETF | 517.04 | 517.1 | 516.95 | 517.07 | 13824.0 |
| 2024-05-08 06:40:00 | SPY | ETF | 517.17 | 517.17 | 517.17 | 517.17 | 100.0 |
| 2024-05-08 06:45:00 | SPY | ETF | 517.12 | 517.31 | 517.12 | 517.31 | 3200.0 |
| 2024-05-08 06:55:00 | SPY | ETF | 516.99 | 517.0 | 516.96 | 516.98 | 1250.0 |
| 2024-05-08 07:00:00 | SPY | ETF | 516.84 | 516.85 | 516.71 | 516.8 | 11570.0 |
| 2024-05-08 07:05:00 | SPY | ETF | 516.87 | 516.87 | 516.52 | 516.71 | 10768.0 |
| 2024-05-08 07:10:00 | SPY | ETF | 516.74 | 516.78 | 516.47 | 516.67 | 9900.0 |
| 2024-05-08 07:15:00 | SPY | ETF | 516.64 | 516.7 | 516.49 | 516.49 | 5789.0 |
| 2024-05-08 07:20:00 | SPY | ETF | 516.6 | 516.64 | 516.5 | 516.5 | 6949.0 |
| 2024-05-08 07:25:00 | SPY | ETF | 516.52 | 516.54 | 516.45 | 516.49 | 17685.0 |
| 2024-05-08 07:30:00 | SPY | ETF | 516.42 | 516.53 | 516.4 | 516.5 | 7560.0 |
| 2024-05-08 07:35:00 | SPY | ETF | 516.5 | 516.53 | 516.29 | 516.4 | 46751.0 |
| 2024-05-08 07:40:00 | SPY | ETF | 516.39 | 516.56 | 516.39 | 516.56 | 49044.0 |
| 2024-05-08 07:45:00 | SPY | ETF | 516.6 | 516.64 | 516.54 | 516.59 | 34683.0 |
| 2024-05-08 07:50:00 | SPY | ETF | 516.58 | 516.621 | 516.48 | 516.49 | 11675.0 |
| 2024-05-08 07:55:00 | SPY | ETF | 516.46 | 516.51 | 516.41 | 516.47 | 6372.0 |
| 2024-05-08 08:00:00 | SPY | ETF | 516.59 | 517.37 | 516.29 | 516.47 | 75591.0 |
| 2024-05-08 08:05:00 | SPY | ETF | 516.44 | 516.44 | 516.25 | 516.2802 | 14292.0 |
| 2024-05-08 08:10:00 | SPY | ETF | 516.2796 | 516.2796 | 515.84 | 515.84 | 42153.0 |
| 2024-05-08 08:15:00 | SPY | ETF | 515.77 | 515.79 | 515.54 | 515.621 | 68156.0 |
| 2024-05-08 08:20:00 | SPY | ETF | 515.63 | 515.75 | 515.46 | 515.63 | 29362.0 |
| 2024-05-08 08:25:00 | SPY | ETF | 515.65 | 515.67 | 515.37 | 515.42 | 29111.0 |
| 2024-05-08 08:30:00 | SPY | ETF | 515.52 | 515.6 | 515.47 | 515.5 | 17408.0 |
> showing 50 of 105,495 rows — these rows as CSV