PREVIEW / etf_5min / 2023-07-12
file: by_date/etf_5min/2023/2023-07-12.parquet size: 2.1 MB rows: 102,391
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-07-12 04:00:00 | SPY | ETF | 443.12 | 443.19 | 443.0 | 443.155 | 3554.0 |
| 2023-07-12 04:05:00 | SPY | ETF | 443.2 | 443.2 | 443.15 | 443.2 | 1700.0 |
| 2023-07-12 04:10:00 | SPY | ETF | 443.25 | 443.25 | 443.18 | 443.21 | 6492.0 |
| 2023-07-12 04:15:00 | SPY | ETF | 443.3 | 443.34 | 443.3 | 443.34 | 2300.0 |
| 2023-07-12 04:20:00 | SPY | ETF | 443.21 | 443.21 | 443.05 | 443.05 | 2308.0 |
| 2023-07-12 04:25:00 | SPY | ETF | 443.18 | 443.21 | 443.18 | 443.21 | 1950.0 |
| 2023-07-12 04:40:00 | SPY | ETF | 443.26 | 443.27 | 443.26 | 443.27 | 499.0 |
| 2023-07-12 04:45:00 | SPY | ETF | 443.24 | 443.25 | 443.24 | 443.24 | 1550.0 |
| 2023-07-12 04:50:00 | SPY | ETF | 443.21 | 443.21 | 443.21 | 443.21 | 300.0 |
| 2023-07-12 04:55:00 | SPY | ETF | 443.29 | 443.29 | 443.29 | 443.29 | 102.0 |
| 2023-07-12 05:00:00 | SPY | ETF | 443.32 | 443.36 | 443.32 | 443.36 | 1149.0 |
| 2023-07-12 05:05:00 | SPY | ETF | 443.4 | 443.4 | 443.39 | 443.39 | 200.0 |
| 2023-07-12 05:10:00 | SPY | ETF | 443.42 | 443.48 | 443.42 | 443.48 | 1028.0 |
| 2023-07-12 05:15:00 | SPY | ETF | 443.55 | 443.55 | 443.36 | 443.41 | 712.0 |
| 2023-07-12 05:20:00 | SPY | ETF | 443.4 | 443.42 | 443.4 | 443.42 | 497.0 |
| 2023-07-12 05:25:00 | SPY | ETF | 443.42 | 443.45 | 443.42 | 443.45 | 1120.0 |
| 2023-07-12 05:30:00 | SPY | ETF | 443.47 | 443.51 | 443.44 | 443.46 | 2281.0 |
| 2023-07-12 05:35:00 | SPY | ETF | 443.56 | 443.56 | 443.56 | 443.56 | 476.0 |
| 2023-07-12 05:40:00 | SPY | ETF | 443.55 | 443.57 | 443.53 | 443.57 | 712.0 |
| 2023-07-12 05:45:00 | SPY | ETF | 443.44 | 443.49 | 443.44 | 443.49 | 3200.0 |
| 2023-07-12 05:50:00 | SPY | ETF | 443.5 | 443.52 | 443.4 | 443.44 | 1632.0 |
| 2023-07-12 05:55:00 | SPY | ETF | 443.48 | 443.48 | 443.46 | 443.46 | 300.0 |
| 2023-07-12 06:00:00 | SPY | ETF | 443.45 | 443.45 | 443.31 | 443.31 | 450.0 |
| 2023-07-12 06:05:00 | SPY | ETF | 443.34 | 443.35 | 443.28 | 443.28 | 2790.0 |
| 2023-07-12 06:10:00 | SPY | ETF | 443.28 | 443.3 | 443.24 | 443.25 | 4600.0 |
| 2023-07-12 06:15:00 | SPY | ETF | 443.31 | 443.35 | 443.3 | 443.34 | 1999.0 |
| 2023-07-12 06:25:00 | SPY | ETF | 443.3 | 443.33 | 443.3 | 443.33 | 400.0 |
| 2023-07-12 06:30:00 | SPY | ETF | 443.32 | 443.32 | 443.29 | 443.29 | 300.0 |
| 2023-07-12 06:35:00 | SPY | ETF | 443.26 | 443.26 | 443.25 | 443.25 | 1196.0 |
| 2023-07-12 06:40:00 | SPY | ETF | 443.32 | 443.37 | 443.29 | 443.37 | 1853.0 |
| 2023-07-12 06:45:00 | SPY | ETF | 443.4 | 443.4 | 443.35 | 443.35 | 710.0 |
| 2023-07-12 06:50:00 | SPY | ETF | 443.32 | 443.32 | 443.3 | 443.3 | 600.0 |
| 2023-07-12 07:00:00 | SPY | ETF | 443.22 | 443.35 | 443.21 | 443.33 | 4863.0 |
| 2023-07-12 07:05:00 | SPY | ETF | 443.28 | 443.29 | 443.21 | 443.25 | 2339.0 |
| 2023-07-12 07:10:00 | SPY | ETF | 443.26 | 443.49 | 443.26 | 443.49 | 8934.0 |
| 2023-07-12 07:15:00 | SPY | ETF | 443.43 | 443.64 | 443.43 | 443.64 | 10716.0 |
| 2023-07-12 07:20:00 | SPY | ETF | 443.66 | 443.69 | 443.59 | 443.6 | 10503.0 |
| 2023-07-12 07:25:00 | SPY | ETF | 443.6 | 443.71 | 443.56 | 443.71 | 34232.0 |
| 2023-07-12 07:30:00 | SPY | ETF | 443.67 | 443.78 | 443.67 | 443.78 | 2306.0 |
| 2023-07-12 07:35:00 | SPY | ETF | 443.8 | 443.83 | 443.71 | 443.77 | 7987.0 |
| 2023-07-12 07:40:00 | SPY | ETF | 443.8 | 443.8 | 443.74 | 443.77 | 7271.0 |
| 2023-07-12 07:45:00 | SPY | ETF | 443.76 | 443.78 | 443.72 | 443.74 | 7505.0 |
| 2023-07-12 07:50:00 | SPY | ETF | 443.74 | 443.745 | 443.67 | 443.74 | 14014.0 |
| 2023-07-12 07:55:00 | SPY | ETF | 443.72 | 443.73 | 443.69 | 443.69 | 3967.0 |
| 2023-07-12 08:00:00 | SPY | ETF | 443.2501 | 443.86 | 442.78 | 443.7 | 54099.0 |
| 2023-07-12 08:05:00 | SPY | ETF | 443.7 | 443.77 | 443.67 | 443.74 | 8298.0 |
| 2023-07-12 08:10:00 | SPY | ETF | 443.75 | 443.79 | 443.64 | 443.76 | 19828.0 |
| 2023-07-12 08:15:00 | SPY | ETF | 443.71 | 443.79 | 443.58 | 443.59 | 101962.0 |
| 2023-07-12 08:20:00 | SPY | ETF | 443.59 | 443.59 | 443.49 | 443.5 | 76206.0 |
| 2023-07-12 08:25:00 | SPY | ETF | 443.49 | 444.0 | 443.42 | 443.64 | 89857.0 |
> showing 50 of 102,391 rows — these rows as CSV