PREVIEW / etf_5min / 2024-08-26
file: by_date/etf_5min/2024/2024-08-26.parquet size: 2.3 MB rows: 113,011
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-08-26 04:00:00 | SPY | ETF | 562.13 | 563.0 | 562.13 | 563.0 | 2315.0 |
| 2024-08-26 04:05:00 | SPY | ETF | 562.97 | 563.25 | 562.9 | 563.25 | 1697.0 |
| 2024-08-26 04:10:00 | SPY | ETF | 563.29 | 563.3 | 563.2 | 563.3 | 2575.0 |
| 2024-08-26 04:15:00 | SPY | ETF | 563.35 | 563.35 | 563.3 | 563.3 | 318.0 |
| 2024-08-26 04:20:00 | SPY | ETF | 563.39 | 563.39 | 563.1 | 563.11 | 411.0 |
| 2024-08-26 04:25:00 | SPY | ETF | 563.11 | 563.11 | 563.11 | 563.11 | 100.0 |
| 2024-08-26 04:30:00 | SPY | ETF | 563.28 | 563.3 | 563.25 | 563.25 | 600.0 |
| 2024-08-26 04:35:00 | SPY | ETF | 563.17 | 563.17 | 563.17 | 563.17 | 572.0 |
| 2024-08-26 04:40:00 | SPY | ETF | 563.16 | 563.16 | 563.16 | 563.16 | 119.0 |
| 2024-08-26 04:45:00 | SPY | ETF | 563.25 | 563.25 | 563.18 | 563.18 | 600.0 |
| 2024-08-26 04:50:00 | SPY | ETF | 563.18 | 563.18 | 563.18 | 563.18 | 100.0 |
| 2024-08-26 04:55:00 | SPY | ETF | 563.37 | 563.39 | 563.37 | 563.39 | 1403.0 |
| 2024-08-26 05:00:00 | SPY | ETF | 563.4 | 563.4 | 563.18 | 563.18 | 392.0 |
| 2024-08-26 05:05:00 | SPY | ETF | 563.12 | 563.12 | 563.09 | 563.09 | 600.0 |
| 2024-08-26 05:15:00 | SPY | ETF | 563.1 | 563.1 | 563.09 | 563.09 | 399.0 |
| 2024-08-26 05:20:00 | SPY | ETF | 563.23 | 563.23 | 563.23 | 563.23 | 100.0 |
| 2024-08-26 05:25:00 | SPY | ETF | 563.19 | 563.19 | 563.19 | 563.19 | 400.0 |
| 2024-08-26 05:30:00 | SPY | ETF | 563.23 | 563.23 | 563.11 | 563.11 | 200.0 |
| 2024-08-26 05:35:00 | SPY | ETF | 563.07 | 563.24 | 563.07 | 563.24 | 500.0 |
| 2024-08-26 05:40:00 | SPY | ETF | 563.26 | 563.26 | 563.19 | 563.21 | 400.0 |
| 2024-08-26 05:50:00 | SPY | ETF | 563.13 | 563.13 | 563.13 | 563.13 | 100.0 |
| 2024-08-26 05:55:00 | SPY | ETF | 563.25 | 563.25 | 563.24 | 563.24 | 200.0 |
| 2024-08-26 06:00:00 | SPY | ETF | 563.2 | 563.2 | 563.2 | 563.2 | 100.0 |
| 2024-08-26 06:05:00 | SPY | ETF | 563.2 | 563.23 | 563.2 | 563.23 | 550.0 |
| 2024-08-26 06:10:00 | SPY | ETF | 563.28 | 563.28 | 563.28 | 563.28 | 500.0 |
| 2024-08-26 06:15:00 | SPY | ETF | 563.35 | 563.35 | 563.35 | 563.35 | 100.0 |
| 2024-08-26 06:20:00 | SPY | ETF | 563.32 | 563.34 | 563.3 | 563.3 | 500.0 |
| 2024-08-26 06:30:00 | SPY | ETF | 563.33 | 563.33 | 563.26 | 563.28 | 2268.0 |
| 2024-08-26 06:35:00 | SPY | ETF | 563.13 | 563.14 | 563.07 | 563.14 | 2026.0 |
| 2024-08-26 06:40:00 | SPY | ETF | 562.99 | 562.99 | 562.9 | 562.9 | 400.0 |
| 2024-08-26 06:45:00 | SPY | ETF | 562.97 | 563.24 | 562.97 | 563.24 | 2749.0 |
| 2024-08-26 06:50:00 | SPY | ETF | 563.16 | 563.18 | 563.14 | 563.17 | 550.0 |
| 2024-08-26 06:55:00 | SPY | ETF | 563.14 | 563.24 | 563.13 | 563.24 | 2000.0 |
| 2024-08-26 07:00:00 | SPY | ETF | 563.22 | 563.4 | 563.18 | 563.33 | 16930.0 |
| 2024-08-26 07:05:00 | SPY | ETF | 563.31 | 563.31 | 563.16 | 563.16 | 1890.0 |
| 2024-08-26 07:10:00 | SPY | ETF | 563.08 | 563.21 | 563.05 | 563.14 | 4506.0 |
| 2024-08-26 07:15:00 | SPY | ETF | 563.14 | 563.28 | 563.1 | 563.18 | 8448.0 |
| 2024-08-26 07:20:00 | SPY | ETF | 563.17 | 563.22 | 563.17 | 563.18 | 9243.0 |
| 2024-08-26 07:25:00 | SPY | ETF | 563.15 | 563.16 | 563.01 | 563.01 | 10076.0 |
| 2024-08-26 07:30:00 | SPY | ETF | 563.02 | 563.2 | 563.0 | 563.18 | 4328.0 |
| 2024-08-26 07:35:00 | SPY | ETF | 563.15 | 563.15 | 562.95 | 562.97 | 16741.0 |
| 2024-08-26 07:40:00 | SPY | ETF | 562.95 | 562.97 | 562.6 | 562.6 | 14244.0 |
| 2024-08-26 07:45:00 | SPY | ETF | 562.5 | 562.62 | 562.34 | 562.62 | 15399.0 |
| 2024-08-26 07:50:00 | SPY | ETF | 562.6 | 562.85 | 562.6 | 562.85 | 5600.0 |
| 2024-08-26 07:55:00 | SPY | ETF | 562.92 | 563.0 | 562.89 | 562.95 | 16851.0 |
| 2024-08-26 08:00:00 | SPY | ETF | 563.37 | 563.41 | 561.81 | 562.94 | 29546.0 |
| 2024-08-26 08:05:00 | SPY | ETF | 562.92 | 563.01 | 562.84 | 562.93 | 14924.0 |
| 2024-08-26 08:10:00 | SPY | ETF | 562.92 | 563.19 | 562.92 | 563.14 | 7946.0 |
| 2024-08-26 08:15:00 | SPY | ETF | 563.18 | 563.25 | 563.17 | 563.19 | 7575.0 |
| 2024-08-26 08:20:00 | SPY | ETF | 563.17 | 563.2 | 563.08 | 563.1 | 16622.0 |
> showing 50 of 113,011 rows — these rows as CSV