PREVIEW / etf_5min / 2024-08-05
file: by_date/etf_5min/2024/2024-08-05.parquet size: 2.7 MB rows: 143,582
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-05 04:00:00 | SPY | ETF | 523.78 | 523.99 | 519.65 | 520.46 | 132597.0 |
| 2024-08-05 04:05:00 | SPY | ETF | 520.39 | 522.59 | 520.39 | 522.54 | 37899.0 |
| 2024-08-05 04:10:00 | SPY | ETF | 522.55 | 522.86 | 521.36 | 521.7 | 56916.0 |
| 2024-08-05 04:15:00 | SPY | ETF | 521.6 | 523.21 | 521.59 | 523.19 | 38777.0 |
| 2024-08-05 04:20:00 | SPY | ETF | 523.16 | 523.27 | 521.86 | 521.88 | 28282.0 |
| 2024-08-05 04:25:00 | SPY | ETF | 521.65 | 522.19 | 521.36 | 521.54 | 10705.0 |
| 2024-08-05 04:30:00 | SPY | ETF | 521.74 | 522.23 | 520.96 | 521.22 | 14594.0 |
| 2024-08-05 04:35:00 | SPY | ETF | 521.36 | 521.88 | 521.26 | 521.39 | 7732.0 |
| 2024-08-05 04:40:00 | SPY | ETF | 521.16 | 521.48 | 520.69 | 521.12 | 15510.0 |
| 2024-08-05 04:45:00 | SPY | ETF | 521.01 | 521.35 | 520.58 | 520.96 | 19756.0 |
| 2024-08-05 04:50:00 | SPY | ETF | 521.01 | 521.14 | 520.0 | 520.07 | 54367.0 |
| 2024-08-05 04:55:00 | SPY | ETF | 520.07 | 520.31 | 519.7 | 519.94 | 24226.0 |
| 2024-08-05 05:00:00 | SPY | ETF | 519.99 | 521.0 | 519.99 | 520.26 | 23109.0 |
| 2024-08-05 05:05:00 | SPY | ETF | 520.1 | 520.3 | 519.3 | 519.44 | 12771.0 |
| 2024-08-05 05:10:00 | SPY | ETF | 519.4 | 519.86 | 519.0 | 519.85 | 14564.0 |
| 2024-08-05 05:15:00 | SPY | ETF | 519.56 | 519.93 | 519.43 | 519.7 | 11753.0 |
| 2024-08-05 05:20:00 | SPY | ETF | 519.64 | 519.87 | 519.0 | 519.0 | 6608.0 |
| 2024-08-05 05:25:00 | SPY | ETF | 519.0 | 520.03 | 518.94 | 520.0 | 20696.0 |
| 2024-08-05 05:30:00 | SPY | ETF | 519.8 | 520.41 | 519.55 | 519.69 | 22544.0 |
| 2024-08-05 05:35:00 | SPY | ETF | 519.68 | 519.8 | 518.0 | 518.49 | 43241.0 |
| 2024-08-05 05:40:00 | SPY | ETF | 518.36 | 518.98 | 517.49 | 517.6 | 16715.0 |
| 2024-08-05 05:45:00 | SPY | ETF | 517.56 | 518.42 | 517.54 | 518.18 | 22182.0 |
| 2024-08-05 05:50:00 | SPY | ETF | 518.26 | 519.46 | 518.16 | 519.07 | 28887.0 |
| 2024-08-05 05:55:00 | SPY | ETF | 518.87 | 520.25 | 518.87 | 520.01 | 24047.0 |
| 2024-08-05 06:00:00 | SPY | ETF | 519.94 | 520.03 | 518.99 | 519.01 | 21280.0 |
| 2024-08-05 06:05:00 | SPY | ETF | 519.02 | 519.18 | 518.73 | 518.95 | 25438.0 |
| 2024-08-05 06:10:00 | SPY | ETF | 518.83 | 519.33 | 518.3 | 518.51 | 22908.0 |
| 2024-08-05 06:15:00 | SPY | ETF | 518.55 | 518.89 | 517.84 | 518.87 | 43323.0 |
| 2024-08-05 06:20:00 | SPY | ETF | 518.81 | 518.95 | 518.21 | 518.21 | 36959.0 |
| 2024-08-05 06:25:00 | SPY | ETF | 518.05 | 518.05 | 516.85 | 517.77 | 98382.0 |
| 2024-08-05 06:30:00 | SPY | ETF | 518.22 | 518.27 | 517.47 | 517.54 | 27728.0 |
| 2024-08-05 06:35:00 | SPY | ETF | 517.45 | 517.56 | 516.62 | 516.8 | 47143.0 |
| 2024-08-05 06:40:00 | SPY | ETF | 516.72 | 517.33 | 516.13 | 517.26 | 48400.0 |
| 2024-08-05 06:45:00 | SPY | ETF | 517.34 | 517.92 | 516.73 | 517.6 | 78315.0 |
| 2024-08-05 06:50:00 | SPY | ETF | 517.52 | 517.8 | 516.74 | 517.21 | 69088.0 |
| 2024-08-05 06:55:00 | SPY | ETF | 517.25 | 518.43 | 517.0 | 518.25 | 81495.0 |
| 2024-08-05 07:00:00 | SPY | ETF | 518.36 | 519.0 | 517.69 | 517.94 | 151816.0 |
| 2024-08-05 07:05:00 | SPY | ETF | 517.87 | 517.87 | 517.13 | 517.19 | 73515.0 |
| 2024-08-05 07:10:00 | SPY | ETF | 517.11 | 518.45 | 516.94 | 518.34 | 115023.0 |
| 2024-08-05 07:15:00 | SPY | ETF | 518.39 | 518.5 | 517.89 | 518.45 | 153185.0 |
| 2024-08-05 07:20:00 | SPY | ETF | 518.43 | 518.58 | 518.13 | 518.35 | 67429.0 |
| 2024-08-05 07:25:00 | SPY | ETF | 518.091 | 518.15 | 516.76 | 516.84 | 102747.0 |
| 2024-08-05 07:30:00 | SPY | ETF | 517.0 | 517.1 | 515.82 | 516.87 | 155696.0 |
| 2024-08-05 07:35:00 | SPY | ETF | 516.92 | 517.62 | 516.07 | 516.18 | 119002.0 |
| 2024-08-05 07:40:00 | SPY | ETF | 516.19 | 516.9 | 516.05 | 516.89 | 84376.0 |
| 2024-08-05 07:45:00 | SPY | ETF | 516.69 | 516.93 | 515.5 | 515.78 | 75328.0 |
| 2024-08-05 07:50:00 | SPY | ETF | 515.78 | 516.33 | 514.97 | 515.14 | 140829.0 |
| 2024-08-05 07:55:00 | SPY | ETF | 515.06 | 515.4 | 514.24 | 515.28 | 311163.0 |
| 2024-08-05 08:00:00 | SPY | ETF | 518.53 | 524.5 | 512.71 | 515.06 | 360759.0 |
| 2024-08-05 08:05:00 | SPY | ETF | 515.09 | 515.18 | 514.17 | 514.27 | 290434.0 |
> showing 50 of 143,582 rows — these rows as CSV