PREVIEW / etf_5min / 2024-07-29
file: by_date/etf_5min/2024/2024-07-29.parquet size: 2.2 MB rows: 111,926
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-07-29 04:00:00 | SPY | ETF | 545.24 | 545.51 | 545.11 | 545.48 | 3556.0 |
| 2024-07-29 04:05:00 | SPY | ETF | 545.39 | 545.72 | 545.39 | 545.72 | 1944.0 |
| 2024-07-29 04:10:00 | SPY | ETF | 545.98 | 546.01 | 545.9 | 546.01 | 2191.0 |
| 2024-07-29 04:20:00 | SPY | ETF | 546.09 | 546.09 | 545.96 | 545.96 | 715.0 |
| 2024-07-29 04:25:00 | SPY | ETF | 545.82 | 545.87 | 545.79 | 545.87 | 600.0 |
| 2024-07-29 04:30:00 | SPY | ETF | 545.77 | 545.86 | 545.77 | 545.86 | 400.0 |
| 2024-07-29 04:35:00 | SPY | ETF | 545.84 | 545.84 | 545.4 | 545.4 | 600.0 |
| 2024-07-29 04:40:00 | SPY | ETF | 545.21 | 545.3 | 545.21 | 545.3 | 222.0 |
| 2024-07-29 04:45:00 | SPY | ETF | 545.61 | 545.61 | 545.61 | 545.61 | 1000.0 |
| 2024-07-29 04:50:00 | SPY | ETF | 545.7 | 545.7 | 545.7 | 545.7 | 459.0 |
| 2024-07-29 04:55:00 | SPY | ETF | 545.6 | 545.64 | 545.6 | 545.64 | 300.0 |
| 2024-07-29 05:00:00 | SPY | ETF | 545.62 | 545.62 | 545.54 | 545.57 | 700.0 |
| 2024-07-29 05:20:00 | SPY | ETF | 545.42 | 545.42 | 545.42 | 545.42 | 950.0 |
| 2024-07-29 05:25:00 | SPY | ETF | 545.76 | 545.76 | 545.76 | 545.76 | 200.0 |
| 2024-07-29 05:35:00 | SPY | ETF | 545.87 | 545.9 | 545.87 | 545.9 | 2200.0 |
| 2024-07-29 05:45:00 | SPY | ETF | 546.02 | 546.02 | 546.02 | 546.02 | 100.0 |
| 2024-07-29 06:00:00 | SPY | ETF | 546.33 | 546.35 | 546.32 | 546.35 | 1149.0 |
| 2024-07-29 06:05:00 | SPY | ETF | 546.47 | 546.47 | 546.47 | 546.47 | 300.0 |
| 2024-07-29 06:10:00 | SPY | ETF | 546.5 | 546.5 | 546.3 | 546.3 | 200.0 |
| 2024-07-29 06:15:00 | SPY | ETF | 546.47 | 546.47 | 546.42 | 546.42 | 200.0 |
| 2024-07-29 06:20:00 | SPY | ETF | 546.63 | 546.63 | 546.63 | 546.63 | 100.0 |
| 2024-07-29 06:25:00 | SPY | ETF | 546.65 | 546.66 | 546.65 | 546.66 | 300.0 |
| 2024-07-29 06:30:00 | SPY | ETF | 546.73 | 546.8 | 546.72 | 546.8 | 3739.0 |
| 2024-07-29 06:40:00 | SPY | ETF | 546.6 | 546.65 | 546.6 | 546.65 | 900.0 |
| 2024-07-29 06:45:00 | SPY | ETF | 546.65 | 546.69 | 546.65 | 546.65 | 2797.0 |
| 2024-07-29 06:50:00 | SPY | ETF | 546.59 | 546.59 | 546.59 | 546.59 | 365.0 |
| 2024-07-29 06:55:00 | SPY | ETF | 546.63 | 546.73 | 546.63 | 546.64 | 4161.0 |
| 2024-07-29 07:00:00 | SPY | ETF | 546.46 | 546.57 | 545.8 | 546.39 | 197057.0 |
| 2024-07-29 07:05:00 | SPY | ETF | 546.38 | 546.51 | 546.38 | 546.48 | 3531.0 |
| 2024-07-29 07:10:00 | SPY | ETF | 546.47 | 546.58 | 546.45 | 546.45 | 3154.0 |
| 2024-07-29 07:15:00 | SPY | ETF | 546.45 | 546.555 | 546.35 | 546.55 | 9013.0 |
| 2024-07-29 07:20:00 | SPY | ETF | 546.59 | 546.73 | 546.47 | 546.66 | 9534.0 |
| 2024-07-29 07:25:00 | SPY | ETF | 546.62 | 546.83 | 546.62 | 546.8 | 4541.0 |
| 2024-07-29 07:30:00 | SPY | ETF | 546.85 | 546.95 | 546.8 | 546.88 | 5158.0 |
| 2024-07-29 07:35:00 | SPY | ETF | 546.92 | 547.06 | 546.9 | 547.0 | 7684.0 |
| 2024-07-29 07:40:00 | SPY | ETF | 546.96 | 546.96 | 546.7 | 546.7 | 2046.0 |
| 2024-07-29 07:45:00 | SPY | ETF | 546.77 | 546.85 | 546.74 | 546.77 | 5207.0 |
| 2024-07-29 07:50:00 | SPY | ETF | 546.78 | 546.86 | 546.66 | 546.86 | 3007.0 |
| 2024-07-29 07:55:00 | SPY | ETF | 546.83 | 546.86 | 546.79 | 546.82 | 5900.0 |
| 2024-07-29 08:00:00 | SPY | ETF | 546.45 | 547.03 | 545.32 | 546.6 | 46604.0 |
| 2024-07-29 08:05:00 | SPY | ETF | 546.61 | 546.75 | 546.53 | 546.68 | 27119.0 |
| 2024-07-29 08:10:00 | SPY | ETF | 546.57 | 546.72 | 546.55 | 546.61 | 6729.0 |
| 2024-07-29 08:15:00 | SPY | ETF | 546.62 | 546.8202 | 546.58 | 546.8202 | 4462.0 |
| 2024-07-29 08:20:00 | SPY | ETF | 546.83 | 546.95 | 546.78 | 546.94 | 7154.0 |
| 2024-07-29 08:25:00 | SPY | ETF | 546.95 | 547.11 | 546.95 | 547.07 | 13867.0 |
| 2024-07-29 08:30:00 | SPY | ETF | 547.16 | 547.7 | 547.16 | 547.59 | 23394.0 |
| 2024-07-29 08:35:00 | SPY | ETF | 547.6 | 547.91 | 547.55 | 547.64 | 23995.0 |
| 2024-07-29 08:40:00 | SPY | ETF | 547.66 | 547.69 | 547.46 | 547.53 | 16267.0 |
| 2024-07-29 08:45:00 | SPY | ETF | 547.54 | 547.57 | 547.36 | 547.36 | 7387.0 |
| 2024-07-29 08:50:00 | SPY | ETF | 547.26 | 547.26 | 547.0 | 547.1 | 13853.0 |
> showing 50 of 111,926 rows — these rows as CSV