PREVIEW / etf_5min / 2024-07-26
file: by_date/etf_5min/2024/2024-07-26.parquet size: 2.2 MB rows: 110,958
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-26 04:00:00 | SPY | ETF | 541.5 | 541.94 | 541.5 | 541.94 | 1939.0 |
| 2024-07-26 04:05:00 | SPY | ETF | 541.73 | 542.14 | 541.73 | 542.12 | 6702.0 |
| 2024-07-26 04:10:00 | SPY | ETF | 542.06 | 542.35 | 542.06 | 542.35 | 2450.0 |
| 2024-07-26 04:15:00 | SPY | ETF | 542.49 | 542.49 | 542.38 | 542.38 | 1522.0 |
| 2024-07-26 04:20:00 | SPY | ETF | 542.23 | 542.31 | 542.12 | 542.24 | 3221.0 |
| 2024-07-26 04:25:00 | SPY | ETF | 542.31 | 542.41 | 542.31 | 542.32 | 1384.0 |
| 2024-07-26 04:30:00 | SPY | ETF | 542.41 | 542.52 | 542.25 | 542.25 | 1313.0 |
| 2024-07-26 04:35:00 | SPY | ETF | 542.42 | 542.42 | 542.29 | 542.29 | 540.0 |
| 2024-07-26 04:40:00 | SPY | ETF | 542.49 | 542.54 | 542.48 | 542.54 | 315.0 |
| 2024-07-26 04:45:00 | SPY | ETF | 542.5 | 542.54 | 542.5 | 542.5 | 1517.0 |
| 2024-07-26 04:50:00 | SPY | ETF | 542.52 | 542.61 | 542.52 | 542.61 | 554.0 |
| 2024-07-26 04:55:00 | SPY | ETF | 543.0 | 543.15 | 543.0 | 543.15 | 31924.0 |
| 2024-07-26 05:00:00 | SPY | ETF | 543.09 | 543.09 | 542.8 | 542.82 | 12342.0 |
| 2024-07-26 05:05:00 | SPY | ETF | 542.66 | 542.79 | 542.66 | 542.73 | 2005.0 |
| 2024-07-26 05:10:00 | SPY | ETF | 542.72 | 543.1 | 542.72 | 543.1 | 2300.0 |
| 2024-07-26 05:15:00 | SPY | ETF | 542.99 | 543.1 | 542.94 | 542.94 | 2814.0 |
| 2024-07-26 05:20:00 | SPY | ETF | 542.86 | 542.86 | 542.63 | 542.65 | 1794.0 |
| 2024-07-26 05:25:00 | SPY | ETF | 542.71 | 542.71 | 542.67 | 542.67 | 1100.0 |
| 2024-07-26 05:30:00 | SPY | ETF | 542.65 | 542.65 | 542.65 | 542.65 | 200.0 |
| 2024-07-26 05:35:00 | SPY | ETF | 542.84 | 542.84 | 542.84 | 542.84 | 200.0 |
| 2024-07-26 05:40:00 | SPY | ETF | 542.64 | 542.69 | 542.54 | 542.59 | 3640.0 |
| 2024-07-26 05:45:00 | SPY | ETF | 542.55 | 542.64 | 542.55 | 542.64 | 300.0 |
| 2024-07-26 05:50:00 | SPY | ETF | 542.53 | 542.81 | 542.53 | 542.81 | 900.0 |
| 2024-07-26 05:55:00 | SPY | ETF | 542.68 | 542.71 | 542.61 | 542.61 | 3700.0 |
| 2024-07-26 06:00:00 | SPY | ETF | 542.63 | 542.71 | 542.5 | 542.5 | 1952.0 |
| 2024-07-26 06:05:00 | SPY | ETF | 542.64 | 542.7 | 542.58 | 542.7 | 1734.0 |
| 2024-07-26 06:10:00 | SPY | ETF | 542.75 | 542.75 | 542.56 | 542.56 | 5144.0 |
| 2024-07-26 06:15:00 | SPY | ETF | 542.6 | 542.71 | 542.58 | 542.71 | 2353.0 |
| 2024-07-26 06:20:00 | SPY | ETF | 542.52 | 542.52 | 542.4 | 542.43 | 3070.0 |
| 2024-07-26 06:25:00 | SPY | ETF | 542.45 | 542.71 | 542.45 | 542.55 | 1550.0 |
| 2024-07-26 06:30:00 | SPY | ETF | 542.64 | 543.0 | 542.64 | 542.91 | 13749.0 |
| 2024-07-26 06:35:00 | SPY | ETF | 542.95 | 542.95 | 542.76 | 542.77 | 13875.0 |
| 2024-07-26 06:40:00 | SPY | ETF | 542.77 | 542.88 | 542.7 | 542.7 | 12988.0 |
| 2024-07-26 06:45:00 | SPY | ETF | 542.62 | 542.69 | 542.62 | 542.63 | 12821.0 |
| 2024-07-26 06:50:00 | SPY | ETF | 542.7 | 542.7 | 542.61 | 542.61 | 753.0 |
| 2024-07-26 06:55:00 | SPY | ETF | 542.6 | 542.6 | 542.43 | 542.43 | 5232.0 |
| 2024-07-26 07:00:00 | SPY | ETF | 542.46 | 542.54 | 541.45 | 542.31 | 185519.0 |
| 2024-07-26 07:05:00 | SPY | ETF | 542.3 | 542.65 | 542.3 | 542.65 | 14755.0 |
| 2024-07-26 07:10:00 | SPY | ETF | 542.7 | 542.92 | 542.7 | 542.74 | 5061.0 |
| 2024-07-26 07:15:00 | SPY | ETF | 542.66 | 542.74 | 542.57 | 542.57 | 14017.0 |
| 2024-07-26 07:20:00 | SPY | ETF | 542.545 | 542.64 | 542.42 | 542.62 | 15894.0 |
| 2024-07-26 07:25:00 | SPY | ETF | 542.6 | 542.7 | 542.4 | 542.7 | 7501.0 |
| 2024-07-26 07:30:00 | SPY | ETF | 542.75 | 542.8 | 542.7 | 542.7 | 6512.0 |
| 2024-07-26 07:35:00 | SPY | ETF | 542.68 | 542.83 | 542.68 | 542.79 | 13204.0 |
| 2024-07-26 07:40:00 | SPY | ETF | 542.8 | 542.88 | 542.7 | 542.781 | 4731.0 |
| 2024-07-26 07:45:00 | SPY | ETF | 542.78 | 543.0 | 542.78 | 542.98 | 5832.0 |
| 2024-07-26 07:50:00 | SPY | ETF | 542.93 | 543.12 | 542.93 | 543.12 | 4549.0 |
| 2024-07-26 07:55:00 | SPY | ETF | 543.14 | 543.21 | 543.12 | 543.21 | 57588.0 |
| 2024-07-26 08:00:00 | SPY | ETF | 542.8 | 543.25 | 540.6 | 543.21 | 57201.0 |
| 2024-07-26 08:05:00 | SPY | ETF | 543.21 | 543.27 | 543.2 | 543.22 | 7486.0 |
> showing 50 of 110,958 rows — these rows as CSV