PREVIEW / etf_5min / 2024-11-18
file: by_date/etf_5min/2024/2024-11-18.parquet size: 2.6 MB rows: 127,387
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-11-18 04:00:00 | SPY | ETF | 587.66 | 587.66 | 586.23 | 586.38 | 8895.0 |
| 2024-11-18 04:05:00 | SPY | ETF | 586.2 | 586.31 | 586.09 | 586.27 | 36407.0 |
| 2024-11-18 04:10:00 | SPY | ETF | 586.38 | 586.38 | 586.23 | 586.23 | 2112.0 |
| 2024-11-18 04:15:00 | SPY | ETF | 586.09 | 586.09 | 585.78 | 585.84 | 2746.0 |
| 2024-11-18 04:20:00 | SPY | ETF | 585.89 | 586.16 | 585.89 | 586.16 | 848.0 |
| 2024-11-18 04:25:00 | SPY | ETF | 586.13 | 586.25 | 586.07 | 586.25 | 4527.0 |
| 2024-11-18 04:30:00 | SPY | ETF | 586.05 | 586.26 | 585.98 | 585.98 | 1581.0 |
| 2024-11-18 04:35:00 | SPY | ETF | 585.96 | 585.96 | 585.89 | 585.89 | 619.0 |
| 2024-11-18 04:40:00 | SPY | ETF | 585.84 | 586.05 | 585.71 | 586.04 | 2003.0 |
| 2024-11-18 04:45:00 | SPY | ETF | 586.05 | 586.06 | 585.97 | 585.97 | 2310.0 |
| 2024-11-18 04:50:00 | SPY | ETF | 585.93 | 585.96 | 585.86 | 585.96 | 1071.0 |
| 2024-11-18 04:55:00 | SPY | ETF | 585.76 | 585.96 | 585.76 | 585.96 | 528.0 |
| 2024-11-18 05:00:00 | SPY | ETF | 586.03 | 586.03 | 585.86 | 585.86 | 216.0 |
| 2024-11-18 05:05:00 | SPY | ETF | 586.06 | 586.08 | 585.99 | 585.99 | 813.0 |
| 2024-11-18 05:10:00 | SPY | ETF | 585.93 | 586.05 | 585.93 | 585.97 | 679.0 |
| 2024-11-18 05:15:00 | SPY | ETF | 585.99 | 585.99 | 585.99 | 585.99 | 485.0 |
| 2024-11-18 05:20:00 | SPY | ETF | 586.04 | 586.04 | 585.99 | 585.99 | 343.0 |
| 2024-11-18 05:25:00 | SPY | ETF | 586.07 | 586.07 | 586.07 | 586.07 | 174.0 |
| 2024-11-18 05:30:00 | SPY | ETF | 586.07 | 586.07 | 586.01 | 586.01 | 830.0 |
| 2024-11-18 05:35:00 | SPY | ETF | 586.13 | 586.34 | 586.13 | 586.34 | 244.0 |
| 2024-11-18 05:40:00 | SPY | ETF | 586.37 | 586.37 | 586.35 | 586.35 | 555.0 |
| 2024-11-18 05:45:00 | SPY | ETF | 586.49 | 586.53 | 586.41 | 586.5 | 2830.0 |
| 2024-11-18 05:55:00 | SPY | ETF | 586.46 | 586.58 | 586.4 | 586.58 | 1745.0 |
| 2024-11-18 06:00:00 | SPY | ETF | 586.58 | 586.58 | 586.4 | 586.41 | 702.0 |
| 2024-11-18 06:05:00 | SPY | ETF | 586.53 | 586.55 | 586.53 | 586.55 | 903.0 |
| 2024-11-18 06:15:00 | SPY | ETF | 586.39 | 586.39 | 586.29 | 586.33 | 3325.0 |
| 2024-11-18 06:20:00 | SPY | ETF | 586.33 | 586.37 | 586.3 | 586.3 | 2520.0 |
| 2024-11-18 06:25:00 | SPY | ETF | 586.24 | 586.24 | 586.16 | 586.2 | 1073.0 |
| 2024-11-18 06:30:00 | SPY | ETF | 586.31 | 586.31 | 586.16 | 586.16 | 420.0 |
| 2024-11-18 06:35:00 | SPY | ETF | 585.98 | 585.98 | 585.81 | 585.81 | 1703.0 |
| 2024-11-18 06:40:00 | SPY | ETF | 585.87 | 585.89 | 585.84 | 585.89 | 1500.0 |
| 2024-11-18 06:45:00 | SPY | ETF | 585.96 | 586.17 | 585.94 | 586.03 | 11309.0 |
| 2024-11-18 06:50:00 | SPY | ETF | 585.88 | 586.1 | 585.88 | 586.1 | 2318.0 |
| 2024-11-18 06:55:00 | SPY | ETF | 586.01 | 586.06 | 586.0 | 586.04 | 9682.0 |
| 2024-11-18 07:00:00 | SPY | ETF | 586.15 | 586.34 | 586.15 | 586.3 | 2656.0 |
| 2024-11-18 07:05:00 | SPY | ETF | 586.39 | 586.39 | 586.2 | 586.22 | 2563.0 |
| 2024-11-18 07:10:00 | SPY | ETF | 586.26 | 586.26 | 585.94 | 586.01 | 3161.0 |
| 2024-11-18 07:15:00 | SPY | ETF | 586.19 | 586.24 | 586.19 | 586.24 | 1435.0 |
| 2024-11-18 07:20:00 | SPY | ETF | 586.18 | 586.33 | 586.12 | 586.22 | 2462.0 |
| 2024-11-18 07:25:00 | SPY | ETF | 586.12 | 586.21 | 586.12 | 586.21 | 4798.0 |
| 2024-11-18 07:30:00 | SPY | ETF | 586.26 | 586.26 | 585.99 | 586.02 | 56206.0 |
| 2024-11-18 07:35:00 | SPY | ETF | 586.15 | 586.34 | 586.15 | 586.34 | 4465.0 |
| 2024-11-18 07:40:00 | SPY | ETF | 586.54 | 586.54 | 586.35 | 586.43 | 16505.0 |
| 2024-11-18 07:45:00 | SPY | ETF | 586.54 | 586.55 | 586.32 | 586.33 | 2174.0 |
| 2024-11-18 07:50:00 | SPY | ETF | 586.31 | 586.331 | 586.24 | 586.31 | 2123.0 |
| 2024-11-18 07:55:00 | SPY | ETF | 586.29 | 586.371 | 586.24 | 586.27 | 13862.0 |
| 2024-11-18 08:00:00 | SPY | ETF | 586.1483 | 587.75 | 585.91 | 585.91 | 36406.0 |
| 2024-11-18 08:05:00 | SPY | ETF | 585.89 | 585.9 | 585.76 | 585.9 | 10165.0 |
| 2024-11-18 08:10:00 | SPY | ETF | 585.9 | 585.96 | 585.48 | 585.51 | 13667.0 |
| 2024-11-18 08:15:00 | SPY | ETF | 585.57 | 585.68 | 585.39 | 585.46 | 22907.0 |
> showing 50 of 127,387 rows — these rows as CSV