PREVIEW / etf_5min / 2024-08-02
file: by_date/etf_5min/2024/2024-08-02.parquet size: 2.5 MB rows: 127,977
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-02 04:00:00 | SPY | ETF | 538.9 | 539.92 | 537.92 | 538.07 | 6221.0 |
| 2024-08-02 04:05:00 | SPY | ETF | 537.97 | 538.4 | 537.67 | 538.4 | 8303.0 |
| 2024-08-02 04:10:00 | SPY | ETF | 538.14 | 538.19 | 537.82 | 537.82 | 3037.0 |
| 2024-08-02 04:15:00 | SPY | ETF | 537.7 | 537.82 | 537.31 | 537.58 | 1791.0 |
| 2024-08-02 04:20:00 | SPY | ETF | 537.58 | 537.63 | 537.15 | 537.51 | 9296.0 |
| 2024-08-02 04:25:00 | SPY | ETF | 537.53 | 538.06 | 537.41 | 538.06 | 4436.0 |
| 2024-08-02 04:30:00 | SPY | ETF | 538.07 | 538.2 | 537.87 | 538.11 | 2287.0 |
| 2024-08-02 04:35:00 | SPY | ETF | 538.29 | 538.3 | 538.24 | 538.24 | 542.0 |
| 2024-08-02 04:40:00 | SPY | ETF | 538.05 | 538.05 | 537.8 | 538.05 | 800.0 |
| 2024-08-02 04:45:00 | SPY | ETF | 538.13 | 538.21 | 537.98 | 537.98 | 638.0 |
| 2024-08-02 04:50:00 | SPY | ETF | 537.88 | 538.21 | 537.84 | 538.21 | 5049.0 |
| 2024-08-02 04:55:00 | SPY | ETF | 538.4 | 538.49 | 538.35 | 538.49 | 1092.0 |
| 2024-08-02 05:00:00 | SPY | ETF | 538.4 | 538.4 | 538.23 | 538.33 | 953.0 |
| 2024-08-02 05:05:00 | SPY | ETF | 537.99 | 538.0 | 537.8 | 537.81 | 8256.0 |
| 2024-08-02 05:10:00 | SPY | ETF | 537.72 | 537.72 | 537.47 | 537.47 | 709.0 |
| 2024-08-02 05:15:00 | SPY | ETF | 537.43 | 537.48 | 537.34 | 537.36 | 1200.0 |
| 2024-08-02 05:20:00 | SPY | ETF | 537.33 | 537.35 | 537.13 | 537.19 | 2300.0 |
| 2024-08-02 05:25:00 | SPY | ETF | 537.01 | 537.01 | 536.9 | 536.98 | 4800.0 |
| 2024-08-02 05:30:00 | SPY | ETF | 536.99 | 537.1 | 536.94 | 536.94 | 4579.0 |
| 2024-08-02 05:35:00 | SPY | ETF | 536.98 | 537.43 | 536.96 | 537.34 | 1459.0 |
| 2024-08-02 05:40:00 | SPY | ETF | 537.38 | 537.38 | 537.06 | 537.21 | 2700.0 |
| 2024-08-02 05:45:00 | SPY | ETF | 537.23 | 537.23 | 536.97 | 536.98 | 1700.0 |
| 2024-08-02 05:50:00 | SPY | ETF | 537.04 | 537.15 | 536.98 | 537.09 | 1887.0 |
| 2024-08-02 05:55:00 | SPY | ETF | 537.1 | 537.18 | 537.0 | 537.0 | 1293.0 |
| 2024-08-02 06:00:00 | SPY | ETF | 537.02 | 537.21 | 536.7 | 536.7 | 2742.0 |
| 2024-08-02 06:05:00 | SPY | ETF | 536.61 | 536.72 | 536.29 | 536.3 | 7970.0 |
| 2024-08-02 06:10:00 | SPY | ETF | 536.61 | 536.7 | 536.53 | 536.69 | 1208.0 |
| 2024-08-02 06:15:00 | SPY | ETF | 536.63 | 536.73 | 536.6 | 536.7 | 2114.0 |
| 2024-08-02 06:20:00 | SPY | ETF | 536.69 | 537.4 | 536.63 | 537.25 | 3935.0 |
| 2024-08-02 06:25:00 | SPY | ETF | 537.01 | 537.49 | 537.01 | 537.03 | 5894.0 |
| 2024-08-02 06:30:00 | SPY | ETF | 537.02 | 537.02 | 536.39 | 536.39 | 2000.0 |
| 2024-08-02 06:35:00 | SPY | ETF | 536.4 | 536.7 | 536.4 | 536.64 | 15128.0 |
| 2024-08-02 06:40:00 | SPY | ETF | 536.73 | 537.35 | 536.73 | 537.24 | 8581.0 |
| 2024-08-02 06:45:00 | SPY | ETF | 537.34 | 537.34 | 537.13 | 537.13 | 1600.0 |
| 2024-08-02 06:50:00 | SPY | ETF | 537.44 | 537.48 | 537.4 | 537.44 | 6082.0 |
| 2024-08-02 06:55:00 | SPY | ETF | 537.68 | 537.83 | 537.12 | 537.25 | 6207.0 |
| 2024-08-02 07:00:00 | SPY | ETF | 537.24 | 537.5 | 537.15 | 537.5 | 18979.0 |
| 2024-08-02 07:05:00 | SPY | ETF | 537.67 | 537.7 | 537.06 | 537.15 | 15900.0 |
| 2024-08-02 07:10:00 | SPY | ETF | 537.15 | 537.22 | 536.93 | 536.94 | 45264.0 |
| 2024-08-02 07:15:00 | SPY | ETF | 536.91 | 537.11 | 536.7 | 537.11 | 58999.0 |
| 2024-08-02 07:20:00 | SPY | ETF | 537.05 | 537.3 | 536.781 | 536.9 | 35648.0 |
| 2024-08-02 07:25:00 | SPY | ETF | 536.93 | 536.96 | 536.84 | 536.92 | 68297.0 |
| 2024-08-02 07:30:00 | SPY | ETF | 536.77 | 537.48 | 536.77 | 537.48 | 65634.0 |
| 2024-08-02 07:35:00 | SPY | ETF | 537.43 | 537.43 | 536.97 | 537.09 | 33875.0 |
| 2024-08-02 07:40:00 | SPY | ETF | 537.1 | 537.2 | 536.96 | 537.06 | 29610.0 |
| 2024-08-02 07:45:00 | SPY | ETF | 537.1 | 537.12 | 536.79 | 536.86 | 23771.0 |
| 2024-08-02 07:50:00 | SPY | ETF | 536.84 | 537.11 | 536.83 | 537.1 | 24718.0 |
| 2024-08-02 07:55:00 | SPY | ETF | 537.0 | 537.08 | 536.83 | 536.975 | 31056.0 |
| 2024-08-02 08:00:00 | SPY | ETF | 537.21 | 539.55 | 536.68 | 537.36 | 58380.0 |
| 2024-08-02 08:05:00 | SPY | ETF | 537.39 | 537.67 | 537.36 | 537.65 | 25340.0 |
> showing 50 of 127,977 rows — these rows as CSV