PREVIEW / etf_5min / 2024-04-01
file: by_date/etf_5min/2024/2024-04-01.parquet size: 2.3 MB rows: 115,584
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-04-01 04:00:00 | SPY | ETF | 525.57 | 525.59 | 525.12 | 525.35 | 5593.0 |
| 2024-04-01 04:05:00 | SPY | ETF | 525.28 | 525.33 | 525.27 | 525.29 | 6494.0 |
| 2024-04-01 04:10:00 | SPY | ETF | 525.28 | 525.3 | 525.16 | 525.3 | 3086.0 |
| 2024-04-01 04:15:00 | SPY | ETF | 525.23 | 525.29 | 525.23 | 525.28 | 649.0 |
| 2024-04-01 04:20:00 | SPY | ETF | 525.33 | 525.4 | 525.33 | 525.4 | 730.0 |
| 2024-04-01 04:25:00 | SPY | ETF | 525.4 | 525.4 | 525.4 | 525.4 | 464.0 |
| 2024-04-01 04:30:00 | SPY | ETF | 525.45 | 525.45 | 525.41 | 525.41 | 766.0 |
| 2024-04-01 04:35:00 | SPY | ETF | 525.41 | 525.41 | 525.41 | 525.41 | 197.0 |
| 2024-04-01 04:45:00 | SPY | ETF | 525.38 | 525.38 | 525.38 | 525.38 | 124.0 |
| 2024-04-01 04:50:00 | SPY | ETF | 525.46 | 525.46 | 525.46 | 525.46 | 200.0 |
| 2024-04-01 04:55:00 | SPY | ETF | 525.49 | 525.54 | 525.49 | 525.5 | 590.0 |
| 2024-04-01 05:00:00 | SPY | ETF | 525.54 | 525.54 | 525.54 | 525.54 | 100.0 |
| 2024-04-01 05:10:00 | SPY | ETF | 525.43 | 525.43 | 525.43 | 525.43 | 400.0 |
| 2024-04-01 05:15:00 | SPY | ETF | 525.33 | 525.33 | 525.32 | 525.32 | 700.0 |
| 2024-04-01 05:20:00 | SPY | ETF | 525.33 | 525.33 | 525.33 | 525.33 | 100.0 |
| 2024-04-01 05:25:00 | SPY | ETF | 525.31 | 525.32 | 525.3 | 525.32 | 400.0 |
| 2024-04-01 05:30:00 | SPY | ETF | 525.26 | 525.28 | 525.26 | 525.28 | 1562.0 |
| 2024-04-01 05:35:00 | SPY | ETF | 525.26 | 525.26 | 525.25 | 525.25 | 300.0 |
| 2024-04-01 05:40:00 | SPY | ETF | 525.25 | 525.25 | 525.25 | 525.25 | 400.0 |
| 2024-04-01 05:50:00 | SPY | ETF | 525.31 | 525.31 | 525.31 | 525.31 | 200.0 |
| 2024-04-01 06:00:00 | SPY | ETF | 525.41 | 525.49 | 525.4 | 525.4 | 3425.0 |
| 2024-04-01 06:05:00 | SPY | ETF | 525.35 | 525.37 | 525.35 | 525.37 | 500.0 |
| 2024-04-01 06:10:00 | SPY | ETF | 525.35 | 525.35 | 525.35 | 525.35 | 416.0 |
| 2024-04-01 06:15:00 | SPY | ETF | 525.4 | 525.5 | 525.4 | 525.5 | 50300.0 |
| 2024-04-01 06:20:00 | SPY | ETF | 525.46 | 525.51 | 525.46 | 525.51 | 545.0 |
| 2024-04-01 06:25:00 | SPY | ETF | 525.5 | 525.52 | 525.49 | 525.51 | 1004.0 |
| 2024-04-01 06:30:00 | SPY | ETF | 525.53 | 525.54 | 525.48 | 525.48 | 3372.0 |
| 2024-04-01 06:35:00 | SPY | ETF | 525.55 | 525.55 | 525.5 | 525.5 | 1996.0 |
| 2024-04-01 06:40:00 | SPY | ETF | 525.5 | 525.5 | 525.48 | 525.48 | 1886.0 |
| 2024-04-01 06:45:00 | SPY | ETF | 525.48 | 525.48 | 525.46 | 525.46 | 1200.0 |
| 2024-04-01 06:50:00 | SPY | ETF | 525.45 | 525.46 | 525.43 | 525.46 | 973.0 |
| 2024-04-01 07:00:00 | SPY | ETF | 525.48 | 525.48 | 524.34 | 525.23 | 90896.0 |
| 2024-04-01 07:05:00 | SPY | ETF | 525.22 | 525.25 | 525.17 | 525.25 | 3210.0 |
| 2024-04-01 07:10:00 | SPY | ETF | 525.25 | 525.26 | 525.25 | 525.26 | 391.0 |
| 2024-04-01 07:15:00 | SPY | ETF | 525.181 | 525.21 | 525.01 | 525.01 | 3701.0 |
| 2024-04-01 07:20:00 | SPY | ETF | 525.06 | 525.06 | 524.97 | 524.97 | 11814.0 |
| 2024-04-01 07:25:00 | SPY | ETF | 524.97 | 524.97 | 524.79 | 524.91 | 20004.0 |
| 2024-04-01 07:30:00 | SPY | ETF | 524.85 | 524.85 | 524.73 | 524.78 | 12242.0 |
| 2024-04-01 07:35:00 | SPY | ETF | 524.82 | 524.95 | 524.82 | 524.95 | 2060.0 |
| 2024-04-01 07:40:00 | SPY | ETF | 524.97 | 524.97 | 524.93 | 524.95 | 1180.0 |
| 2024-04-01 07:45:00 | SPY | ETF | 524.95 | 524.96 | 524.91 | 524.96 | 880.0 |
| 2024-04-01 07:50:00 | SPY | ETF | 524.95 | 524.97 | 524.85 | 524.91 | 11624.0 |
| 2024-04-01 07:55:00 | SPY | ETF | 524.92 | 524.93 | 524.88 | 524.92 | 4686.0 |
| 2024-04-01 08:00:00 | SPY | ETF | 525.19 | 525.6 | 524.8 | 524.86 | 19954.0 |
| 2024-04-01 08:05:00 | SPY | ETF | 524.8 | 526.09 | 524.15 | 524.25 | 123106.0 |
| 2024-04-01 08:10:00 | SPY | ETF | 524.31 | 524.31 | 524.14 | 524.26 | 13665.0 |
| 2024-04-01 08:15:00 | SPY | ETF | 524.21 | 524.21 | 524.07 | 524.18 | 8160.0 |
| 2024-04-01 08:20:00 | SPY | ETF | 524.18 | 524.18 | 523.9 | 524.0 | 24232.0 |
| 2024-04-01 08:25:00 | SPY | ETF | 524.02 | 524.15 | 524.0 | 524.08 | 8721.0 |
| 2024-04-01 08:30:00 | SPY | ETF | 524.01 | 524.03 | 523.72 | 523.8 | 9039.0 |
> showing 50 of 115,584 rows — these rows as CSV