PREVIEW / etf_5min / 2024-09-09
file: by_date/etf_5min/2024/2024-09-09.parquet size: 2.2 MB rows: 112,050
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-09-09 04:00:00 | SPY | ETF | 542.72 | 543.82 | 542.22 | 543.7 | 24596.0 |
| 2024-09-09 04:05:00 | SPY | ETF | 543.65 | 543.84 | 543.5 | 543.5 | 8347.0 |
| 2024-09-09 04:10:00 | SPY | ETF | 543.56 | 543.71 | 543.56 | 543.59 | 1976.0 |
| 2024-09-09 04:15:00 | SPY | ETF | 543.47 | 543.5 | 543.35 | 543.44 | 2686.0 |
| 2024-09-09 04:20:00 | SPY | ETF | 543.28 | 543.33 | 543.15 | 543.33 | 900.0 |
| 2024-09-09 04:25:00 | SPY | ETF | 543.42 | 543.42 | 543.42 | 543.42 | 243.0 |
| 2024-09-09 04:30:00 | SPY | ETF | 543.41 | 543.51 | 543.38 | 543.38 | 1006.0 |
| 2024-09-09 04:40:00 | SPY | ETF | 543.28 | 543.28 | 543.14 | 543.14 | 3399.0 |
| 2024-09-09 04:45:00 | SPY | ETF | 543.25 | 543.59 | 543.2 | 543.59 | 1476.0 |
| 2024-09-09 04:50:00 | SPY | ETF | 543.64 | 543.64 | 543.62 | 543.62 | 400.0 |
| 2024-09-09 04:55:00 | SPY | ETF | 543.61 | 543.61 | 543.57 | 543.57 | 2530.0 |
| 2024-09-09 05:00:00 | SPY | ETF | 543.57 | 543.57 | 543.52 | 543.57 | 1359.0 |
| 2024-09-09 05:05:00 | SPY | ETF | 543.75 | 543.85 | 543.75 | 543.85 | 400.0 |
| 2024-09-09 05:10:00 | SPY | ETF | 543.89 | 544.02 | 543.88 | 544.02 | 3953.0 |
| 2024-09-09 05:15:00 | SPY | ETF | 544.07 | 544.17 | 543.86 | 544.03 | 1199.0 |
| 2024-09-09 05:20:00 | SPY | ETF | 544.08 | 544.29 | 544.06 | 544.29 | 4108.0 |
| 2024-09-09 05:25:00 | SPY | ETF | 544.26 | 544.29 | 544.26 | 544.29 | 1100.0 |
| 2024-09-09 05:30:00 | SPY | ETF | 544.35 | 544.35 | 544.16 | 544.2 | 500.0 |
| 2024-09-09 05:35:00 | SPY | ETF | 544.14 | 544.14 | 544.0 | 544.0 | 798.0 |
| 2024-09-09 05:40:00 | SPY | ETF | 544.03 | 544.09 | 544.0 | 544.0 | 736.0 |
| 2024-09-09 05:45:00 | SPY | ETF | 544.15 | 544.15 | 544.13 | 544.13 | 286.0 |
| 2024-09-09 05:50:00 | SPY | ETF | 544.18 | 544.18 | 543.94 | 543.98 | 385.0 |
| 2024-09-09 05:55:00 | SPY | ETF | 544.0 | 544.33 | 544.0 | 544.33 | 1884.0 |
| 2024-09-09 06:00:00 | SPY | ETF | 544.26 | 544.48 | 544.22 | 544.48 | 2292.0 |
| 2024-09-09 06:05:00 | SPY | ETF | 544.55 | 544.65 | 544.43 | 544.65 | 3055.0 |
| 2024-09-09 06:10:00 | SPY | ETF | 544.61 | 544.7 | 544.56 | 544.66 | 3494.0 |
| 2024-09-09 06:15:00 | SPY | ETF | 544.75 | 544.76 | 544.46 | 544.46 | 1683.0 |
| 2024-09-09 06:20:00 | SPY | ETF | 544.45 | 544.59 | 544.29 | 544.47 | 7110.0 |
| 2024-09-09 06:25:00 | SPY | ETF | 544.38 | 544.51 | 544.38 | 544.51 | 491.0 |
| 2024-09-09 06:30:00 | SPY | ETF | 544.5 | 544.52 | 544.31 | 544.31 | 5390.0 |
| 2024-09-09 06:35:00 | SPY | ETF | 544.27 | 544.35 | 544.21 | 544.21 | 1361.0 |
| 2024-09-09 06:40:00 | SPY | ETF | 544.21 | 544.28 | 543.98 | 544.1 | 4133.0 |
| 2024-09-09 06:45:00 | SPY | ETF | 544.1 | 544.28 | 544.1 | 544.2 | 878.0 |
| 2024-09-09 06:50:00 | SPY | ETF | 543.98 | 544.11 | 543.98 | 544.1 | 1973.0 |
| 2024-09-09 06:55:00 | SPY | ETF | 544.09 | 544.09 | 543.94 | 543.98 | 4082.0 |
| 2024-09-09 07:00:00 | SPY | ETF | 544.1 | 544.39 | 543.6 | 544.15 | 267854.0 |
| 2024-09-09 07:05:00 | SPY | ETF | 544.18 | 544.28 | 544.02 | 544.19 | 19979.0 |
| 2024-09-09 07:10:00 | SPY | ETF | 544.3 | 544.48 | 544.25 | 544.43 | 10794.0 |
| 2024-09-09 07:15:00 | SPY | ETF | 544.49 | 544.55 | 544.41 | 544.411 | 20584.0 |
| 2024-09-09 07:20:00 | SPY | ETF | 544.44 | 544.47 | 544.44 | 544.45 | 3613.0 |
| 2024-09-09 07:25:00 | SPY | ETF | 544.42 | 544.81 | 544.42 | 544.76 | 17518.0 |
| 2024-09-09 07:30:00 | SPY | ETF | 544.71 | 544.72 | 544.1 | 544.17 | 30699.0 |
| 2024-09-09 07:35:00 | SPY | ETF | 544.11 | 544.14 | 543.92 | 544.07 | 9604.0 |
| 2024-09-09 07:40:00 | SPY | ETF | 544.1 | 544.34 | 543.96 | 544.01 | 68139.0 |
| 2024-09-09 07:45:00 | SPY | ETF | 543.96 | 544.07 | 543.81 | 544.04 | 16623.0 |
| 2024-09-09 07:50:00 | SPY | ETF | 543.98 | 543.99 | 543.8 | 543.83 | 22257.0 |
| 2024-09-09 07:55:00 | SPY | ETF | 543.87 | 544.08 | 543.86 | 543.97 | 12410.0 |
| 2024-09-09 08:00:00 | SPY | ETF | 544.07 | 544.7 | 541.97 | 543.74 | 97779.0 |
| 2024-09-09 08:05:00 | SPY | ETF | 543.74 | 543.82 | 543.66 | 543.74 | 10792.0 |
| 2024-09-09 08:10:00 | SPY | ETF | 543.6916 | 543.74 | 543.4 | 543.43 | 12746.0 |
> showing 50 of 112,050 rows — these rows as CSV