PREVIEW / etf_5min / 2023-09-26
file: by_date/etf_5min/2023/2023-09-26.parquet size: 2.0 MB rows: 98,078
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-09-26 04:00:00 | SPY | ETF | 430.21 | 430.21 | 429.77 | 429.96 | 4025.0 |
| 2023-09-26 04:05:00 | SPY | ETF | 430.13 | 430.2 | 429.86 | 430.02 | 9254.0 |
| 2023-09-26 04:10:00 | SPY | ETF | 430.12 | 430.39 | 429.99 | 430.37 | 3400.0 |
| 2023-09-26 04:15:00 | SPY | ETF | 430.46 | 430.62 | 430.46 | 430.59 | 8100.0 |
| 2023-09-26 04:20:00 | SPY | ETF | 430.59 | 430.82 | 430.59 | 430.82 | 3690.0 |
| 2023-09-26 04:25:00 | SPY | ETF | 430.62 | 430.65 | 430.56 | 430.62 | 1965.0 |
| 2023-09-26 04:30:00 | SPY | ETF | 430.51 | 430.51 | 430.4 | 430.4 | 1199.0 |
| 2023-09-26 04:35:00 | SPY | ETF | 430.52 | 430.52 | 430.42 | 430.45 | 1087.0 |
| 2023-09-26 04:40:00 | SPY | ETF | 430.35 | 430.43 | 430.22 | 430.22 | 1800.0 |
| 2023-09-26 04:45:00 | SPY | ETF | 430.15 | 430.29 | 430.15 | 430.28 | 2341.0 |
| 2023-09-26 04:50:00 | SPY | ETF | 430.37 | 430.37 | 430.35 | 430.35 | 1029.0 |
| 2023-09-26 04:55:00 | SPY | ETF | 430.25 | 430.3 | 430.25 | 430.3 | 740.0 |
| 2023-09-26 05:00:00 | SPY | ETF | 430.31 | 430.32 | 430.17 | 430.26 | 10700.0 |
| 2023-09-26 05:05:00 | SPY | ETF | 430.15 | 430.15 | 429.86 | 429.86 | 2450.0 |
| 2023-09-26 05:10:00 | SPY | ETF | 429.9 | 430.24 | 429.8 | 430.23 | 2550.0 |
| 2023-09-26 05:15:00 | SPY | ETF | 430.29 | 430.29 | 430.08 | 430.08 | 500.0 |
| 2023-09-26 05:20:00 | SPY | ETF | 429.98 | 430.09 | 429.98 | 430.09 | 949.0 |
| 2023-09-26 05:25:00 | SPY | ETF | 430.13 | 430.13 | 430.08 | 430.08 | 400.0 |
| 2023-09-26 05:30:00 | SPY | ETF | 430.33 | 430.46 | 430.33 | 430.42 | 7918.0 |
| 2023-09-26 05:35:00 | SPY | ETF | 430.43 | 430.5 | 430.39 | 430.45 | 6601.0 |
| 2023-09-26 05:40:00 | SPY | ETF | 430.31 | 430.31 | 430.31 | 430.31 | 423.0 |
| 2023-09-26 05:50:00 | SPY | ETF | 430.13 | 430.14 | 429.91 | 429.95 | 2368.0 |
| 2023-09-26 05:55:00 | SPY | ETF | 429.89 | 429.89 | 429.72 | 429.73 | 2713.0 |
| 2023-09-26 06:00:00 | SPY | ETF | 429.87 | 430.07 | 429.87 | 430.06 | 2300.0 |
| 2023-09-26 06:05:00 | SPY | ETF | 430.0 | 430.09 | 429.99 | 430.09 | 12427.0 |
| 2023-09-26 06:10:00 | SPY | ETF | 429.96 | 429.98 | 429.89 | 429.98 | 2311.0 |
| 2023-09-26 06:15:00 | SPY | ETF | 430.03 | 430.19 | 430.03 | 430.15 | 19728.0 |
| 2023-09-26 06:20:00 | SPY | ETF | 430.19 | 430.19 | 429.95 | 430.08 | 33602.0 |
| 2023-09-26 06:25:00 | SPY | ETF | 430.18 | 430.18 | 430.15 | 430.15 | 500.0 |
| 2023-09-26 06:30:00 | SPY | ETF | 430.16 | 430.23 | 430.13 | 430.13 | 2675.0 |
| 2023-09-26 06:35:00 | SPY | ETF | 430.18 | 430.33 | 430.15 | 430.33 | 5200.0 |
| 2023-09-26 06:40:00 | SPY | ETF | 430.36 | 430.36 | 430.16 | 430.2 | 4489.0 |
| 2023-09-26 06:45:00 | SPY | ETF | 430.25 | 430.25 | 430.21 | 430.21 | 950.0 |
| 2023-09-26 06:50:00 | SPY | ETF | 430.1 | 430.3 | 430.09 | 430.3 | 900.0 |
| 2023-09-26 06:55:00 | SPY | ETF | 430.31 | 430.58 | 430.31 | 430.58 | 1800.0 |
| 2023-09-26 07:00:00 | SPY | ETF | 430.56 | 430.58 | 430.3 | 430.3 | 10470.0 |
| 2023-09-26 07:05:00 | SPY | ETF | 430.26 | 430.26 | 429.9 | 429.94 | 10325.0 |
| 2023-09-26 07:10:00 | SPY | ETF | 429.94 | 429.99 | 429.87 | 429.989 | 9299.0 |
| 2023-09-26 07:15:00 | SPY | ETF | 430.04 | 430.33 | 430.01 | 430.33 | 8434.0 |
| 2023-09-26 07:20:00 | SPY | ETF | 430.32 | 430.46 | 430.3 | 430.41 | 5490.0 |
| 2023-09-26 07:25:00 | SPY | ETF | 430.43 | 430.71 | 430.39 | 430.66 | 16606.0 |
| 2023-09-26 07:30:00 | SPY | ETF | 430.62 | 430.69 | 430.54 | 430.65 | 5714.0 |
| 2023-09-26 07:35:00 | SPY | ETF | 430.63 | 430.91 | 430.63 | 430.77 | 30824.0 |
| 2023-09-26 07:40:00 | SPY | ETF | 430.79 | 430.83 | 430.72 | 430.81 | 5300.0 |
| 2023-09-26 07:45:00 | SPY | ETF | 430.72 | 430.75 | 430.46 | 430.46 | 46537.0 |
| 2023-09-26 07:50:00 | SPY | ETF | 430.44 | 430.5 | 430.38 | 430.5 | 15854.0 |
| 2023-09-26 07:55:00 | SPY | ETF | 430.48 | 430.56 | 430.48 | 430.56 | 10172.0 |
| 2023-09-26 08:00:00 | SPY | ETF | 430.58 | 430.91 | 428.91 | 430.88 | 142736.0 |
| 2023-09-26 08:05:00 | SPY | ETF | 430.86 | 431.03 | 430.69 | 430.98 | 28789.0 |
| 2023-09-26 08:10:00 | SPY | ETF | 430.95 | 430.98 | 430.7 | 430.7 | 13696.0 |
> showing 50 of 98,078 rows — these rows as CSV