PREVIEW / etf_5min / 2024-08-07
file: by_date/etf_5min/2024/2024-08-07.parquet size: 2.4 MB rows: 121,956
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-08-07 04:00:00 | SPY | ETF | 524.05 | 525.94 | 524.05 | 525.24 | 19326.0 |
| 2024-08-07 04:05:00 | SPY | ETF | 525.17 | 525.84 | 525.17 | 525.84 | 14702.0 |
| 2024-08-07 04:10:00 | SPY | ETF | 525.95 | 526.7 | 525.8 | 526.5 | 8491.0 |
| 2024-08-07 04:15:00 | SPY | ETF | 526.5 | 526.89 | 526.34 | 526.47 | 9977.0 |
| 2024-08-07 04:20:00 | SPY | ETF | 526.55 | 526.58 | 526.22 | 526.32 | 4863.0 |
| 2024-08-07 04:25:00 | SPY | ETF | 526.53 | 526.71 | 526.29 | 526.71 | 1221.0 |
| 2024-08-07 04:30:00 | SPY | ETF | 526.55 | 526.74 | 526.3 | 526.3 | 1299.0 |
| 2024-08-07 04:35:00 | SPY | ETF | 526.36 | 526.73 | 526.2 | 526.73 | 3259.0 |
| 2024-08-07 04:40:00 | SPY | ETF | 526.54 | 526.54 | 526.25 | 526.3 | 493.0 |
| 2024-08-07 04:45:00 | SPY | ETF | 526.45 | 527.19 | 526.44 | 527.19 | 4961.0 |
| 2024-08-07 04:50:00 | SPY | ETF | 527.2 | 527.23 | 527.03 | 527.15 | 12189.0 |
| 2024-08-07 04:55:00 | SPY | ETF | 527.26 | 527.38 | 527.22 | 527.38 | 1939.0 |
| 2024-08-07 05:00:00 | SPY | ETF | 527.51 | 527.56 | 527.14 | 527.25 | 7661.0 |
| 2024-08-07 05:05:00 | SPY | ETF | 527.35 | 527.75 | 527.32 | 527.34 | 2099.0 |
| 2024-08-07 05:10:00 | SPY | ETF | 527.3 | 527.93 | 527.3 | 527.7 | 15917.0 |
| 2024-08-07 05:15:00 | SPY | ETF | 527.54 | 527.6 | 527.25 | 527.37 | 1811.0 |
| 2024-08-07 05:20:00 | SPY | ETF | 527.28 | 527.61 | 527.28 | 527.61 | 4155.0 |
| 2024-08-07 05:25:00 | SPY | ETF | 527.75 | 528.29 | 527.75 | 528.29 | 8096.0 |
| 2024-08-07 05:30:00 | SPY | ETF | 528.12 | 528.4 | 527.91 | 528.1 | 12798.0 |
| 2024-08-07 05:35:00 | SPY | ETF | 528.0 | 528.41 | 528.0 | 528.28 | 34708.0 |
| 2024-08-07 05:40:00 | SPY | ETF | 528.32 | 528.33 | 527.6 | 527.6 | 9105.0 |
| 2024-08-07 05:45:00 | SPY | ETF | 527.43 | 527.54 | 527.36 | 527.36 | 1600.0 |
| 2024-08-07 05:50:00 | SPY | ETF | 527.47 | 527.91 | 527.47 | 527.84 | 18702.0 |
| 2024-08-07 05:55:00 | SPY | ETF | 527.77 | 528.08 | 527.62 | 528.08 | 5584.0 |
| 2024-08-07 06:00:00 | SPY | ETF | 528.08 | 528.2 | 528.0 | 528.0 | 3490.0 |
| 2024-08-07 06:05:00 | SPY | ETF | 527.87 | 528.07 | 527.84 | 528.07 | 7041.0 |
| 2024-08-07 06:10:00 | SPY | ETF | 528.27 | 528.4 | 528.13 | 528.4 | 20977.0 |
| 2024-08-07 06:15:00 | SPY | ETF | 528.46 | 528.46 | 528.17 | 528.22 | 1325.0 |
| 2024-08-07 06:20:00 | SPY | ETF | 528.15 | 528.16 | 527.94 | 527.96 | 2330.0 |
| 2024-08-07 06:25:00 | SPY | ETF | 528.1 | 528.43 | 528.05 | 528.28 | 4438.0 |
| 2024-08-07 06:30:00 | SPY | ETF | 528.44 | 528.55 | 528.3 | 528.53 | 10021.0 |
| 2024-08-07 06:35:00 | SPY | ETF | 528.4 | 528.59 | 528.4 | 528.52 | 11058.0 |
| 2024-08-07 06:40:00 | SPY | ETF | 528.59 | 528.59 | 528.4 | 528.4 | 4034.0 |
| 2024-08-07 06:45:00 | SPY | ETF | 528.4 | 528.62 | 528.4 | 528.62 | 3249.0 |
| 2024-08-07 06:50:00 | SPY | ETF | 528.65 | 528.7 | 528.46 | 528.7 | 10973.0 |
| 2024-08-07 06:55:00 | SPY | ETF | 528.73 | 528.85 | 528.66 | 528.71 | 17507.0 |
| 2024-08-07 07:00:00 | SPY | ETF | 528.6 | 528.85 | 528.31 | 528.65 | 165042.0 |
| 2024-08-07 07:05:00 | SPY | ETF | 528.65 | 528.85 | 528.53 | 528.83 | 33062.0 |
| 2024-08-07 07:10:00 | SPY | ETF | 528.78 | 528.86 | 528.57 | 528.57 | 32319.0 |
| 2024-08-07 07:15:00 | SPY | ETF | 528.57 | 529.05 | 528.5 | 529.05 | 22098.0 |
| 2024-08-07 07:20:00 | SPY | ETF | 528.9 | 529.03 | 528.89 | 528.9 | 6458.0 |
| 2024-08-07 07:25:00 | SPY | ETF | 528.94 | 528.99 | 528.55 | 528.55 | 43641.0 |
| 2024-08-07 07:30:00 | SPY | ETF | 528.56 | 528.6 | 528.0 | 528.48 | 34878.0 |
| 2024-08-07 07:35:00 | SPY | ETF | 528.43 | 528.47 | 528.15 | 528.35 | 17499.0 |
| 2024-08-07 07:40:00 | SPY | ETF | 528.32 | 528.43 | 528.01 | 528.4 | 21109.0 |
| 2024-08-07 07:45:00 | SPY | ETF | 528.41 | 528.5 | 527.91 | 528.04 | 28857.0 |
| 2024-08-07 07:50:00 | SPY | ETF | 528.04 | 528.21 | 527.93 | 527.94 | 27057.0 |
| 2024-08-07 07:55:00 | SPY | ETF | 528.05 | 528.09 | 527.6 | 527.7 | 38192.0 |
| 2024-08-07 08:00:00 | SPY | ETF | 528.64 | 529.03 | 521.25 | 527.65 | 110089.0 |
| 2024-08-07 08:05:00 | SPY | ETF | 527.59 | 527.88 | 527.4 | 527.8 | 30110.0 |
> showing 50 of 121,956 rows — these rows as CSV