PREVIEW / etf_5min / 2024-02-07
file: by_date/etf_5min/2024/2024-02-07.parquet size: 2.3 MB rows: 111,122
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-02-07 04:00:00 | SPY | ETF | 493.98 | 494.02 | 493.96 | 493.96 | 744.0 |
| 2024-02-07 04:05:00 | SPY | ETF | 493.93 | 493.93 | 493.91 | 493.91 | 640.0 |
| 2024-02-07 04:10:00 | SPY | ETF | 493.89 | 493.89 | 493.89 | 493.89 | 500.0 |
| 2024-02-07 04:15:00 | SPY | ETF | 493.99 | 493.99 | 493.99 | 493.99 | 200.0 |
| 2024-02-07 04:20:00 | SPY | ETF | 494.09 | 494.12 | 494.06 | 494.07 | 959.0 |
| 2024-02-07 04:25:00 | SPY | ETF | 494.15 | 494.17 | 494.01 | 494.01 | 1100.0 |
| 2024-02-07 04:30:00 | SPY | ETF | 494.09 | 494.19 | 494.09 | 494.19 | 1513.0 |
| 2024-02-07 04:35:00 | SPY | ETF | 494.1 | 494.1 | 494.06 | 494.06 | 300.0 |
| 2024-02-07 04:40:00 | SPY | ETF | 494.02 | 494.02 | 494.02 | 494.02 | 750.0 |
| 2024-02-07 04:45:00 | SPY | ETF | 494.15 | 494.15 | 494.15 | 494.15 | 202.0 |
| 2024-02-07 04:50:00 | SPY | ETF | 494.04 | 494.08 | 494.04 | 494.08 | 600.0 |
| 2024-02-07 04:55:00 | SPY | ETF | 494.12 | 494.12 | 494.12 | 494.12 | 100.0 |
| 2024-02-07 05:05:00 | SPY | ETF | 494.07 | 494.18 | 494.07 | 494.17 | 3788.0 |
| 2024-02-07 05:10:00 | SPY | ETF | 494.13 | 494.17 | 494.1 | 494.1 | 1633.0 |
| 2024-02-07 05:15:00 | SPY | ETF | 494.11 | 494.11 | 494.03 | 494.1 | 1319.0 |
| 2024-02-07 05:20:00 | SPY | ETF | 494.1 | 494.18 | 494.1 | 494.18 | 1115.0 |
| 2024-02-07 05:25:00 | SPY | ETF | 494.1 | 494.1 | 494.1 | 494.1 | 500.0 |
| 2024-02-07 05:30:00 | SPY | ETF | 494.07 | 494.07 | 493.99 | 493.99 | 1060.0 |
| 2024-02-07 05:40:00 | SPY | ETF | 493.78 | 493.78 | 493.78 | 493.78 | 100.0 |
| 2024-02-07 05:45:00 | SPY | ETF | 493.75 | 493.81 | 493.7 | 493.7 | 2091.0 |
| 2024-02-07 05:50:00 | SPY | ETF | 493.56 | 493.66 | 493.5 | 493.66 | 31236.0 |
| 2024-02-07 05:55:00 | SPY | ETF | 493.74 | 493.78 | 493.71 | 493.71 | 842.0 |
| 2024-02-07 06:00:00 | SPY | ETF | 493.73 | 493.73 | 493.73 | 493.73 | 100.0 |
| 2024-02-07 06:05:00 | SPY | ETF | 493.81 | 493.81 | 493.73 | 493.8 | 3111.0 |
| 2024-02-07 06:15:00 | SPY | ETF | 493.75 | 493.75 | 493.75 | 493.75 | 10000.0 |
| 2024-02-07 06:20:00 | SPY | ETF | 493.94 | 493.94 | 493.94 | 493.94 | 202.0 |
| 2024-02-07 06:25:00 | SPY | ETF | 494.02 | 494.02 | 494.02 | 494.02 | 800.0 |
| 2024-02-07 06:30:00 | SPY | ETF | 493.98 | 494.07 | 493.95 | 494.06 | 20099.0 |
| 2024-02-07 06:35:00 | SPY | ETF | 494.09 | 494.09 | 494.02 | 494.07 | 1941.0 |
| 2024-02-07 06:40:00 | SPY | ETF | 493.97 | 494.01 | 493.97 | 494.01 | 2200.0 |
| 2024-02-07 06:45:00 | SPY | ETF | 493.99 | 493.99 | 493.99 | 493.99 | 250.0 |
| 2024-02-07 06:50:00 | SPY | ETF | 493.93 | 493.93 | 493.89 | 493.9 | 2618.0 |
| 2024-02-07 06:55:00 | SPY | ETF | 493.85 | 493.85 | 493.85 | 493.85 | 100.0 |
| 2024-02-07 07:00:00 | SPY | ETF | 494.0 | 494.0 | 493.73 | 493.78 | 2205.0 |
| 2024-02-07 07:05:00 | SPY | ETF | 493.81 | 493.82 | 493.8 | 493.81 | 3438.0 |
| 2024-02-07 07:10:00 | SPY | ETF | 493.91 | 493.95 | 493.85 | 493.88 | 3159.0 |
| 2024-02-07 07:15:00 | SPY | ETF | 493.86 | 493.87 | 493.74 | 493.83 | 6394.0 |
| 2024-02-07 07:20:00 | SPY | ETF | 493.81 | 493.84 | 493.72 | 493.72 | 6035.0 |
| 2024-02-07 07:25:00 | SPY | ETF | 493.81 | 494.06 | 493.81 | 494.06 | 13361.0 |
| 2024-02-07 07:30:00 | SPY | ETF | 494.06 | 494.271 | 494.06 | 494.271 | 14178.0 |
| 2024-02-07 07:35:00 | SPY | ETF | 494.27 | 494.44 | 494.27 | 494.36 | 1501.0 |
| 2024-02-07 07:40:00 | SPY | ETF | 494.43 | 494.64 | 494.43 | 494.64 | 3301.0 |
| 2024-02-07 07:45:00 | SPY | ETF | 494.69 | 494.75 | 494.68 | 494.71 | 10020.0 |
| 2024-02-07 07:50:00 | SPY | ETF | 494.79 | 494.88 | 494.79 | 494.84 | 14942.0 |
| 2024-02-07 07:55:00 | SPY | ETF | 494.85 | 494.94 | 494.78 | 494.86 | 8772.0 |
| 2024-02-07 08:00:00 | SPY | ETF | 493.82 | 495.25 | 493.7502 | 495.21 | 53464.0 |
| 2024-02-07 08:05:00 | SPY | ETF | 495.2414 | 495.33 | 495.16 | 495.33 | 24284.0 |
| 2024-02-07 08:10:00 | SPY | ETF | 495.32 | 495.39 | 495.29 | 495.35 | 24832.0 |
| 2024-02-07 08:15:00 | SPY | ETF | 495.35 | 495.51 | 495.35 | 495.41 | 40370.0 |
| 2024-02-07 08:20:00 | SPY | ETF | 495.41 | 495.41 | 495.23 | 495.23 | 31731.0 |
> showing 50 of 111,122 rows — these rows as CSV