PREVIEW / etf_5min / 2023-10-16
file: by_date/etf_5min/2023/2023-10-16.parquet size: 2.0 MB rows: 97,017
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 |
|---|---|---|---|---|---|---|---|
| 2023-10-16 04:00:00 | SPY | ETF | 432.09 | 432.09 | 431.6 | 431.68 | 5891.0 |
| 2023-10-16 04:05:00 | SPY | ETF | 431.68 | 431.68 | 431.48 | 431.48 | 2746.0 |
| 2023-10-16 04:10:00 | SPY | ETF | 431.49 | 431.52 | 431.35 | 431.51 | 2723.0 |
| 2023-10-16 04:15:00 | SPY | ETF | 431.37 | 431.45 | 431.3 | 431.42 | 2325.0 |
| 2023-10-16 04:20:00 | SPY | ETF | 431.5 | 431.71 | 431.5 | 431.71 | 4249.0 |
| 2023-10-16 04:25:00 | SPY | ETF | 431.71 | 432.14 | 431.71 | 432.1 | 2861.0 |
| 2023-10-16 04:30:00 | SPY | ETF | 432.1 | 432.21 | 432.1 | 432.21 | 2100.0 |
| 2023-10-16 04:35:00 | SPY | ETF | 432.16 | 432.36 | 432.11 | 432.27 | 2401.0 |
| 2023-10-16 04:40:00 | SPY | ETF | 432.28 | 432.28 | 432.18 | 432.28 | 989.0 |
| 2023-10-16 04:45:00 | SPY | ETF | 432.26 | 432.56 | 432.26 | 432.56 | 3582.0 |
| 2023-10-16 04:50:00 | SPY | ETF | 432.65 | 432.65 | 432.36 | 432.36 | 10477.0 |
| 2023-10-16 04:55:00 | SPY | ETF | 432.41 | 432.46 | 432.34 | 432.34 | 1850.0 |
| 2023-10-16 05:00:00 | SPY | ETF | 432.29 | 432.29 | 432.29 | 432.29 | 118.0 |
| 2023-10-16 05:05:00 | SPY | ETF | 432.5 | 432.5 | 432.21 | 432.21 | 745.0 |
| 2023-10-16 05:10:00 | SPY | ETF | 432.33 | 432.33 | 432.18 | 432.27 | 509.0 |
| 2023-10-16 05:15:00 | SPY | ETF | 432.28 | 432.36 | 432.28 | 432.36 | 600.0 |
| 2023-10-16 05:20:00 | SPY | ETF | 432.38 | 432.38 | 432.23 | 432.31 | 1182.0 |
| 2023-10-16 05:25:00 | SPY | ETF | 432.26 | 432.26 | 432.19 | 432.19 | 209.0 |
| 2023-10-16 05:30:00 | SPY | ETF | 432.3 | 432.3 | 432.3 | 432.3 | 118.0 |
| 2023-10-16 05:35:00 | SPY | ETF | 432.51 | 432.53 | 432.51 | 432.53 | 465.0 |
| 2023-10-16 05:45:00 | SPY | ETF | 432.51 | 432.51 | 432.39 | 432.41 | 1485.0 |
| 2023-10-16 05:50:00 | SPY | ETF | 432.35 | 432.45 | 432.35 | 432.45 | 550.0 |
| 2023-10-16 06:00:00 | SPY | ETF | 432.33 | 432.33 | 431.96 | 431.96 | 7254.0 |
| 2023-10-16 06:05:00 | SPY | ETF | 431.93 | 432.03 | 431.89 | 431.89 | 2320.0 |
| 2023-10-16 06:10:00 | SPY | ETF | 432.05 | 432.05 | 432.05 | 432.05 | 100.0 |
| 2023-10-16 06:15:00 | SPY | ETF | 432.27 | 432.28 | 432.26 | 432.28 | 3211.0 |
| 2023-10-16 06:20:00 | SPY | ETF | 432.36 | 432.38 | 432.25 | 432.25 | 1700.0 |
| 2023-10-16 06:25:00 | SPY | ETF | 432.33 | 432.33 | 432.2 | 432.2 | 3400.0 |
| 2023-10-16 06:30:00 | SPY | ETF | 432.24 | 432.42 | 432.24 | 432.35 | 2500.0 |
| 2023-10-16 06:35:00 | SPY | ETF | 432.28 | 432.28 | 432.28 | 432.28 | 376.0 |
| 2023-10-16 06:40:00 | SPY | ETF | 432.45 | 432.51 | 432.45 | 432.49 | 2374.0 |
| 2023-10-16 06:45:00 | SPY | ETF | 432.45 | 432.55 | 432.45 | 432.55 | 7378.0 |
| 2023-10-16 06:50:00 | SPY | ETF | 432.61 | 432.65 | 432.6 | 432.65 | 5358.0 |
| 2023-10-16 06:55:00 | SPY | ETF | 432.61 | 432.73 | 432.6 | 432.73 | 9334.0 |
| 2023-10-16 07:00:00 | SPY | ETF | 432.73 | 432.74 | 432.56 | 432.57 | 42009.0 |
| 2023-10-16 07:05:00 | SPY | ETF | 432.52 | 432.58 | 432.37 | 432.43 | 11027.0 |
| 2023-10-16 07:10:00 | SPY | ETF | 432.4 | 432.53 | 432.35 | 432.53 | 30783.0 |
| 2023-10-16 07:15:00 | SPY | ETF | 432.55 | 432.66 | 432.55 | 432.64 | 12195.0 |
| 2023-10-16 07:20:00 | SPY | ETF | 432.69 | 432.73 | 432.61 | 432.7 | 9354.0 |
| 2023-10-16 07:25:00 | SPY | ETF | 432.7 | 432.8 | 432.67 | 432.72 | 16789.0 |
| 2023-10-16 07:30:00 | SPY | ETF | 432.75 | 432.82 | 432.6 | 432.6 | 17683.0 |
| 2023-10-16 07:35:00 | SPY | ETF | 432.66 | 433.1 | 432.65 | 433.1 | 21677.0 |
| 2023-10-16 07:40:00 | SPY | ETF | 433.09 | 433.38 | 432.93 | 433.31 | 82795.0 |
| 2023-10-16 07:45:00 | SPY | ETF | 433.31 | 433.36 | 433.14 | 433.16 | 30594.0 |
| 2023-10-16 07:50:00 | SPY | ETF | 433.17 | 433.28 | 433.09 | 433.09 | 15149.0 |
| 2023-10-16 07:55:00 | SPY | ETF | 433.07 | 433.16 | 433.0 | 433.0 | 7058.0 |
| 2023-10-16 08:00:00 | SPY | ETF | 432.59 | 433.34 | 431.95 | 433.04 | 87880.0 |
| 2023-10-16 08:05:00 | SPY | ETF | 433.03 | 433.04 | 432.56 | 432.65 | 42362.0 |
| 2023-10-16 08:10:00 | SPY | ETF | 432.64 | 432.72 | 432.5 | 432.59 | 30061.0 |
| 2023-10-16 08:15:00 | SPY | ETF | 432.6 | 432.73 | 432.59 | 432.69 | 20973.0 |
> showing 50 of 97,017 rows — these rows as CSV