PREVIEW / etf_5min / 2024-03-08
file: by_date/etf_5min/2024/2024-03-08.parquet size: 2.3 MB rows: 114,903
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-03-08 04:00:00 | SPY | ETF | 515.75 | 515.87 | 515.57 | 515.83 | 5892.0 |
| 2024-03-08 04:05:00 | SPY | ETF | 515.8 | 515.8 | 515.7 | 515.74 | 1450.0 |
| 2024-03-08 04:10:00 | SPY | ETF | 515.82 | 515.82 | 515.8 | 515.8 | 711.0 |
| 2024-03-08 04:15:00 | SPY | ETF | 515.69 | 515.7 | 515.59 | 515.7 | 857.0 |
| 2024-03-08 04:20:00 | SPY | ETF | 515.77 | 515.87 | 515.77 | 515.86 | 874.0 |
| 2024-03-08 04:25:00 | SPY | ETF | 515.78 | 515.81 | 515.78 | 515.8 | 650.0 |
| 2024-03-08 04:30:00 | SPY | ETF | 515.75 | 515.75 | 515.7 | 515.7 | 550.0 |
| 2024-03-08 04:40:00 | SPY | ETF | 515.74 | 515.74 | 515.74 | 515.74 | 100.0 |
| 2024-03-08 04:45:00 | SPY | ETF | 515.83 | 515.83 | 515.74 | 515.74 | 350.0 |
| 2024-03-08 04:50:00 | SPY | ETF | 515.8 | 515.83 | 515.8 | 515.83 | 609.0 |
| 2024-03-08 04:55:00 | SPY | ETF | 515.7 | 515.7 | 515.7 | 515.7 | 194.0 |
| 2024-03-08 05:00:00 | SPY | ETF | 515.69 | 515.69 | 515.63 | 515.63 | 4700.0 |
| 2024-03-08 05:05:00 | SPY | ETF | 515.64 | 515.64 | 515.54 | 515.54 | 493.0 |
| 2024-03-08 05:10:00 | SPY | ETF | 515.67 | 515.67 | 515.64 | 515.64 | 1389.0 |
| 2024-03-08 05:20:00 | SPY | ETF | 515.59 | 515.59 | 515.59 | 515.59 | 300.0 |
| 2024-03-08 05:25:00 | SPY | ETF | 515.62 | 515.62 | 515.5 | 515.5 | 600.0 |
| 2024-03-08 05:30:00 | SPY | ETF | 515.55 | 515.55 | 515.51 | 515.51 | 900.0 |
| 2024-03-08 05:35:00 | SPY | ETF | 515.5 | 515.52 | 515.5 | 515.52 | 300.0 |
| 2024-03-08 05:40:00 | SPY | ETF | 515.58 | 515.6 | 515.58 | 515.6 | 600.0 |
| 2024-03-08 05:45:00 | SPY | ETF | 515.54 | 515.62 | 515.54 | 515.62 | 600.0 |
| 2024-03-08 05:50:00 | SPY | ETF | 515.54 | 515.54 | 515.54 | 515.54 | 500.0 |
| 2024-03-08 05:55:00 | SPY | ETF | 515.63 | 515.63 | 515.59 | 515.61 | 5100.0 |
| 2024-03-08 06:00:00 | SPY | ETF | 515.59 | 515.59 | 515.57 | 515.57 | 300.0 |
| 2024-03-08 06:05:00 | SPY | ETF | 515.54 | 515.54 | 515.54 | 515.54 | 400.0 |
| 2024-03-08 06:10:00 | SPY | ETF | 515.53 | 515.56 | 515.52 | 515.56 | 300.0 |
| 2024-03-08 06:15:00 | SPY | ETF | 515.65 | 515.65 | 515.65 | 515.65 | 500.0 |
| 2024-03-08 06:25:00 | SPY | ETF | 515.48 | 515.48 | 515.45 | 515.45 | 1172.0 |
| 2024-03-08 06:30:00 | SPY | ETF | 515.39 | 515.4 | 515.36 | 515.4 | 1466.0 |
| 2024-03-08 06:35:00 | SPY | ETF | 515.34 | 515.34 | 515.24 | 515.27 | 3020.0 |
| 2024-03-08 06:40:00 | SPY | ETF | 515.2 | 515.2 | 515.08 | 515.15 | 1375.0 |
| 2024-03-08 06:45:00 | SPY | ETF | 515.07 | 515.07 | 514.84 | 514.84 | 2143.0 |
| 2024-03-08 06:50:00 | SPY | ETF | 514.81 | 514.86 | 514.77 | 514.83 | 1789.0 |
| 2024-03-08 06:55:00 | SPY | ETF | 514.85 | 514.92 | 514.85 | 514.91 | 1660.0 |
| 2024-03-08 07:00:00 | SPY | ETF | 514.88 | 514.92 | 514.75 | 514.88 | 4154.0 |
| 2024-03-08 07:05:00 | SPY | ETF | 514.85 | 514.85 | 514.68 | 514.73 | 14278.0 |
| 2024-03-08 07:10:00 | SPY | ETF | 514.72 | 514.9 | 514.72 | 514.84 | 2906.0 |
| 2024-03-08 07:15:00 | SPY | ETF | 514.82 | 514.82 | 514.55 | 514.55 | 8690.0 |
| 2024-03-08 07:20:00 | SPY | ETF | 514.42 | 514.42 | 514.11 | 514.391 | 11140.0 |
| 2024-03-08 07:25:00 | SPY | ETF | 514.45 | 514.45 | 514.3 | 514.3 | 10630.0 |
| 2024-03-08 07:30:00 | SPY | ETF | 514.31 | 514.42 | 514.25 | 514.3 | 16167.0 |
| 2024-03-08 07:35:00 | SPY | ETF | 514.27 | 514.36 | 514.14 | 514.22 | 47333.0 |
| 2024-03-08 07:40:00 | SPY | ETF | 514.26 | 514.42 | 514.15 | 514.15 | 11900.0 |
| 2024-03-08 07:45:00 | SPY | ETF | 514.15 | 514.33 | 514.04 | 514.23 | 27171.0 |
| 2024-03-08 07:50:00 | SPY | ETF | 514.23 | 514.23 | 514.02 | 514.19 | 8693.0 |
| 2024-03-08 07:55:00 | SPY | ETF | 514.19 | 514.3 | 514.18 | 514.3 | 5397.0 |
| 2024-03-08 08:00:00 | SPY | ETF | 514.31 | 516.27 | 514.05 | 515.19 | 65165.0 |
| 2024-03-08 08:05:00 | SPY | ETF | 514.49 | 515.89 | 514.4 | 514.4 | 12049.0 |
| 2024-03-08 08:10:00 | SPY | ETF | 514.42 | 514.49 | 514.41 | 514.49 | 6285.0 |
| 2024-03-08 08:15:00 | SPY | ETF | 514.53 | 514.69 | 514.53 | 514.55 | 7839.0 |
| 2024-03-08 08:20:00 | SPY | ETF | 514.55 | 514.87 | 514.36 | 514.87 | 28021.0 |
> showing 50 of 114,903 rows — these rows as CSV