PREVIEW / etf_5min / 2024-09-06
file: by_date/etf_5min/2024/2024-09-06.parquet size: 2.3 MB rows: 117,693
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-09-06 04:00:00 | SPY | ETF | 547.0 | 547.0 | 546.2 | 546.53 | 4265.0 |
| 2024-09-06 04:05:00 | SPY | ETF | 546.53 | 546.61 | 546.37 | 546.45 | 465.0 |
| 2024-09-06 04:10:00 | SPY | ETF | 546.4 | 546.56 | 546.37 | 546.56 | 1493.0 |
| 2024-09-06 04:15:00 | SPY | ETF | 546.6 | 546.6 | 546.2 | 546.2 | 350.0 |
| 2024-09-06 04:20:00 | SPY | ETF | 546.2 | 546.2 | 546.2 | 546.2 | 200.0 |
| 2024-09-06 04:25:00 | SPY | ETF | 546.27 | 546.46 | 546.27 | 546.44 | 400.0 |
| 2024-09-06 04:30:00 | SPY | ETF | 546.5 | 546.5 | 546.41 | 546.41 | 515.0 |
| 2024-09-06 04:35:00 | SPY | ETF | 546.46 | 546.46 | 546.03 | 546.03 | 4718.0 |
| 2024-09-06 04:40:00 | SPY | ETF | 545.92 | 546.01 | 545.91 | 545.93 | 2676.0 |
| 2024-09-06 04:45:00 | SPY | ETF | 545.8 | 545.8 | 545.64 | 545.68 | 600.0 |
| 2024-09-06 04:50:00 | SPY | ETF | 545.65 | 545.73 | 545.45 | 545.53 | 1882.0 |
| 2024-09-06 04:55:00 | SPY | ETF | 545.57 | 545.81 | 545.57 | 545.81 | 2942.0 |
| 2024-09-06 05:00:00 | SPY | ETF | 545.77 | 545.77 | 545.7 | 545.7 | 434.0 |
| 2024-09-06 05:05:00 | SPY | ETF | 545.74 | 545.86 | 545.65 | 545.65 | 1093.0 |
| 2024-09-06 05:10:00 | SPY | ETF | 545.62 | 545.72 | 545.62 | 545.72 | 249.0 |
| 2024-09-06 05:15:00 | SPY | ETF | 545.49 | 545.68 | 545.37 | 545.68 | 1439.0 |
| 2024-09-06 05:20:00 | SPY | ETF | 545.59 | 545.89 | 545.59 | 545.89 | 2008.0 |
| 2024-09-06 05:25:00 | SPY | ETF | 546.0 | 546.0 | 545.94 | 545.94 | 650.0 |
| 2024-09-06 05:30:00 | SPY | ETF | 546.02 | 546.16 | 546.02 | 546.16 | 204.0 |
| 2024-09-06 05:40:00 | SPY | ETF | 545.96 | 545.96 | 545.67 | 545.79 | 70948.0 |
| 2024-09-06 05:45:00 | SPY | ETF | 545.76 | 546.14 | 545.76 | 546.14 | 58800.0 |
| 2024-09-06 05:50:00 | SPY | ETF | 546.05 | 546.41 | 546.05 | 546.37 | 1120.0 |
| 2024-09-06 05:55:00 | SPY | ETF | 546.08 | 546.08 | 546.08 | 546.08 | 100.0 |
| 2024-09-06 06:00:00 | SPY | ETF | 546.08 | 546.08 | 546.08 | 546.08 | 100.0 |
| 2024-09-06 06:05:00 | SPY | ETF | 546.12 | 546.3 | 546.11 | 546.29 | 1742.0 |
| 2024-09-06 06:10:00 | SPY | ETF | 546.18 | 546.24 | 546.18 | 546.24 | 201.0 |
| 2024-09-06 06:15:00 | SPY | ETF | 546.19 | 546.19 | 546.07 | 546.13 | 5108.0 |
| 2024-09-06 06:20:00 | SPY | ETF | 546.16 | 546.16 | 546.05 | 546.05 | 900.0 |
| 2024-09-06 06:25:00 | SPY | ETF | 546.26 | 546.31 | 546.25 | 546.31 | 1012.0 |
| 2024-09-06 06:30:00 | SPY | ETF | 546.2 | 546.3 | 546.19 | 546.2 | 10928.0 |
| 2024-09-06 06:35:00 | SPY | ETF | 546.19 | 546.24 | 545.97 | 545.97 | 1746.0 |
| 2024-09-06 06:40:00 | SPY | ETF | 546.05 | 546.09 | 545.66 | 545.84 | 22706.0 |
| 2024-09-06 06:45:00 | SPY | ETF | 545.88 | 545.92 | 545.88 | 545.92 | 293.0 |
| 2024-09-06 06:55:00 | SPY | ETF | 545.87 | 546.0 | 545.87 | 545.95 | 300.0 |
| 2024-09-06 07:00:00 | SPY | ETF | 545.95 | 546.18 | 545.89 | 546.12 | 20047.0 |
| 2024-09-06 07:05:00 | SPY | ETF | 546.08 | 546.22 | 546.08 | 546.21 | 4965.0 |
| 2024-09-06 07:10:00 | SPY | ETF | 546.27 | 546.31 | 546.09 | 546.09 | 3143.0 |
| 2024-09-06 07:15:00 | SPY | ETF | 546.23 | 546.35 | 546.17 | 546.27 | 11855.0 |
| 2024-09-06 07:20:00 | SPY | ETF | 546.26 | 546.38 | 546.25 | 546.32 | 2400.0 |
| 2024-09-06 07:25:00 | SPY | ETF | 546.39 | 546.42 | 546.11 | 546.12 | 20117.0 |
| 2024-09-06 07:30:00 | SPY | ETF | 546.17 | 546.43 | 546.1 | 546.43 | 8027.0 |
| 2024-09-06 07:35:00 | SPY | ETF | 546.43 | 546.43 | 546.18 | 546.32 | 6732.0 |
| 2024-09-06 07:40:00 | SPY | ETF | 546.37 | 546.38 | 546.23 | 546.31 | 4168.0 |
| 2024-09-06 07:45:00 | SPY | ETF | 546.32 | 546.56 | 546.25 | 546.56 | 5557.0 |
| 2024-09-06 07:50:00 | SPY | ETF | 546.59 | 546.77 | 546.55 | 546.77 | 21350.0 |
| 2024-09-06 07:55:00 | SPY | ETF | 546.77 | 546.82 | 546.73 | 546.79 | 33929.0 |
| 2024-09-06 08:00:00 | SPY | ETF | 546.05 | 549.06 | 545.55 | 547.06 | 86584.0 |
| 2024-09-06 08:05:00 | SPY | ETF | 547.03 | 547.1 | 546.68 | 546.68 | 19115.0 |
| 2024-09-06 08:10:00 | SPY | ETF | 546.6 | 546.6005 | 546.43 | 546.44 | 12968.0 |
| 2024-09-06 08:15:00 | SPY | ETF | 546.3817 | 546.93 | 546.36 | 546.8 | 38337.0 |
> showing 50 of 117,693 rows — these rows as CSV