PREVIEW / etf_5min / 2024-02-14
file: by_date/etf_5min/2024/2024-02-14.parquet size: 2.3 MB rows: 110,639
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-14 04:00:00 | SPY | ETF | 495.0 | 495.64 | 495.0 | 495.63 | 3355.0 |
| 2024-02-14 04:05:00 | SPY | ETF | 495.63 | 495.71 | 495.62 | 495.71 | 3070.0 |
| 2024-02-14 04:10:00 | SPY | ETF | 495.69 | 495.79 | 495.69 | 495.79 | 2241.0 |
| 2024-02-14 04:15:00 | SPY | ETF | 495.93 | 495.96 | 495.88 | 495.96 | 2490.0 |
| 2024-02-14 04:20:00 | SPY | ETF | 495.74 | 495.78 | 495.74 | 495.78 | 270.0 |
| 2024-02-14 04:25:00 | SPY | ETF | 495.85 | 495.93 | 495.81 | 495.93 | 1445.0 |
| 2024-02-14 04:30:00 | SPY | ETF | 495.93 | 495.93 | 495.82 | 495.86 | 600.0 |
| 2024-02-14 04:35:00 | SPY | ETF | 495.95 | 496.01 | 495.95 | 496.01 | 425.0 |
| 2024-02-14 04:40:00 | SPY | ETF | 496.0 | 496.0 | 496.0 | 496.0 | 1290.0 |
| 2024-02-14 04:45:00 | SPY | ETF | 496.19 | 496.33 | 496.19 | 496.33 | 3481.0 |
| 2024-02-14 04:50:00 | SPY | ETF | 496.33 | 496.39 | 496.32 | 496.39 | 948.0 |
| 2024-02-14 04:55:00 | SPY | ETF | 496.41 | 496.57 | 496.41 | 496.51 | 700.0 |
| 2024-02-14 05:00:00 | SPY | ETF | 496.5 | 496.5 | 496.33 | 496.38 | 890.0 |
| 2024-02-14 05:05:00 | SPY | ETF | 496.28 | 496.31 | 496.25 | 496.27 | 800.0 |
| 2024-02-14 05:10:00 | SPY | ETF | 496.16 | 496.16 | 496.14 | 496.14 | 300.0 |
| 2024-02-14 05:15:00 | SPY | ETF | 496.21 | 496.21 | 496.2 | 496.2 | 300.0 |
| 2024-02-14 05:20:00 | SPY | ETF | 496.16 | 496.23 | 496.14 | 496.16 | 7401.0 |
| 2024-02-14 05:25:00 | SPY | ETF | 496.15 | 496.15 | 496.15 | 496.15 | 100.0 |
| 2024-02-14 05:30:00 | SPY | ETF | 496.09 | 496.09 | 496.07 | 496.07 | 700.0 |
| 2024-02-14 05:35:00 | SPY | ETF | 496.24 | 496.24 | 496.2 | 496.2 | 8100.0 |
| 2024-02-14 05:40:00 | SPY | ETF | 496.15 | 496.15 | 496.12 | 496.12 | 8300.0 |
| 2024-02-14 05:45:00 | SPY | ETF | 496.12 | 496.2 | 496.12 | 496.2 | 1984.0 |
| 2024-02-14 05:50:00 | SPY | ETF | 496.29 | 496.29 | 496.27 | 496.27 | 488.0 |
| 2024-02-14 05:55:00 | SPY | ETF | 496.25 | 496.42 | 496.25 | 496.37 | 13768.0 |
| 2024-02-14 06:00:00 | SPY | ETF | 496.18 | 496.18 | 496.0 | 496.09 | 2416.0 |
| 2024-02-14 06:05:00 | SPY | ETF | 496.06 | 496.06 | 495.95 | 496.03 | 1462.0 |
| 2024-02-14 06:10:00 | SPY | ETF | 496.04 | 496.09 | 495.96 | 496.0 | 1378.0 |
| 2024-02-14 06:15:00 | SPY | ETF | 496.04 | 496.04 | 495.97 | 495.98 | 2886.0 |
| 2024-02-14 06:20:00 | SPY | ETF | 496.01 | 496.01 | 496.01 | 496.01 | 100.0 |
| 2024-02-14 06:25:00 | SPY | ETF | 496.01 | 496.03 | 496.01 | 496.03 | 600.0 |
| 2024-02-14 06:30:00 | SPY | ETF | 496.01 | 496.01 | 495.94 | 495.96 | 2236.0 |
| 2024-02-14 06:35:00 | SPY | ETF | 495.92 | 495.92 | 495.71 | 495.83 | 1718.0 |
| 2024-02-14 06:40:00 | SPY | ETF | 495.81 | 495.81 | 495.77 | 495.77 | 800.0 |
| 2024-02-14 06:45:00 | SPY | ETF | 496.05 | 496.05 | 496.05 | 496.05 | 100.0 |
| 2024-02-14 06:50:00 | SPY | ETF | 496.04 | 496.3 | 496.04 | 496.15 | 2382.0 |
| 2024-02-14 06:55:00 | SPY | ETF | 496.3 | 496.53 | 496.3 | 496.52 | 9589.0 |
| 2024-02-14 07:00:00 | SPY | ETF | 496.49 | 496.73 | 496.48 | 496.66 | 25943.0 |
| 2024-02-14 07:05:00 | SPY | ETF | 496.69 | 496.84 | 496.69 | 496.84 | 68727.0 |
| 2024-02-14 07:10:00 | SPY | ETF | 496.79 | 496.8 | 496.63 | 496.63 | 11565.0 |
| 2024-02-14 07:15:00 | SPY | ETF | 496.63 | 496.64 | 496.52 | 496.57 | 13114.0 |
| 2024-02-14 07:20:00 | SPY | ETF | 496.58 | 496.68 | 496.58 | 496.68 | 13289.0 |
| 2024-02-14 07:25:00 | SPY | ETF | 496.68 | 496.73 | 496.52 | 496.551 | 13890.0 |
| 2024-02-14 07:30:00 | SPY | ETF | 496.53 | 496.65 | 496.53 | 496.6 | 17747.0 |
| 2024-02-14 07:35:00 | SPY | ETF | 496.59 | 496.6 | 496.36 | 496.36 | 32609.0 |
| 2024-02-14 07:40:00 | SPY | ETF | 496.34 | 496.56 | 496.31 | 496.5 | 15574.0 |
| 2024-02-14 07:45:00 | SPY | ETF | 496.55 | 496.63 | 496.54 | 496.58 | 39426.0 |
| 2024-02-14 07:50:00 | SPY | ETF | 496.58 | 496.58 | 496.5 | 496.5 | 2400.0 |
| 2024-02-14 07:55:00 | SPY | ETF | 496.49 | 496.5 | 496.39 | 496.44 | 9876.0 |
| 2024-02-14 08:00:00 | SPY | ETF | 496.55 | 496.9 | 494.37 | 494.46 | 88348.0 |
| 2024-02-14 08:05:00 | SPY | ETF | 496.85 | 497.01 | 496.82 | 496.96 | 51989.0 |
> showing 50 of 110,639 rows — these rows as CSV