PREVIEW / etf_5min / 2024-09-03
file: by_date/etf_5min/2024/2024-09-03.parquet size: 2.3 MB rows: 120,757
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-03 04:00:00 | SPY | ETF | 563.5 | 564.22 | 563.5 | 564.22 | 1945.0 |
| 2024-09-03 04:05:00 | SPY | ETF | 563.97 | 564.19 | 563.9 | 563.9 | 625.0 |
| 2024-09-03 04:10:00 | SPY | ETF | 564.05 | 564.05 | 563.87 | 563.87 | 633.0 |
| 2024-09-03 04:15:00 | SPY | ETF | 563.86 | 563.96 | 563.8 | 563.96 | 300.0 |
| 2024-09-03 04:25:00 | SPY | ETF | 563.45 | 563.45 | 563.26 | 563.39 | 730.0 |
| 2024-09-03 04:30:00 | SPY | ETF | 563.15 | 563.15 | 562.97 | 562.99 | 1098.0 |
| 2024-09-03 04:35:00 | SPY | ETF | 562.88 | 562.9 | 562.75 | 562.9 | 1160.0 |
| 2024-09-03 04:40:00 | SPY | ETF | 562.76 | 562.94 | 562.76 | 562.94 | 404.0 |
| 2024-09-03 04:45:00 | SPY | ETF | 562.78 | 562.89 | 562.78 | 562.85 | 889.0 |
| 2024-09-03 04:50:00 | SPY | ETF | 562.74 | 562.74 | 562.35 | 562.35 | 440.0 |
| 2024-09-03 04:55:00 | SPY | ETF | 562.31 | 562.31 | 561.8 | 561.8 | 3281.0 |
| 2024-09-03 05:00:00 | SPY | ETF | 561.76 | 562.02 | 561.63 | 561.96 | 1359.0 |
| 2024-09-03 05:05:00 | SPY | ETF | 562.01 | 562.01 | 561.81 | 561.88 | 1499.0 |
| 2024-09-03 05:10:00 | SPY | ETF | 561.64 | 561.64 | 561.0 | 561.11 | 8560.0 |
| 2024-09-03 05:15:00 | SPY | ETF | 560.9 | 561.1 | 560.9 | 561.06 | 1912.0 |
| 2024-09-03 05:20:00 | SPY | ETF | 561.0 | 561.18 | 560.89 | 561.04 | 3074.0 |
| 2024-09-03 05:25:00 | SPY | ETF | 561.24 | 561.41 | 561.24 | 561.29 | 306.0 |
| 2024-09-03 05:30:00 | SPY | ETF | 561.14 | 561.3 | 560.7 | 561.3 | 3428.0 |
| 2024-09-03 05:35:00 | SPY | ETF | 561.27 | 561.45 | 561.27 | 561.4 | 18501.0 |
| 2024-09-03 05:40:00 | SPY | ETF | 561.35 | 561.35 | 561.19 | 561.21 | 6100.0 |
| 2024-09-03 05:45:00 | SPY | ETF | 561.11 | 561.21 | 561.1 | 561.14 | 4797.0 |
| 2024-09-03 05:50:00 | SPY | ETF | 561.18 | 561.25 | 561.05 | 561.08 | 3876.0 |
| 2024-09-03 05:55:00 | SPY | ETF | 561.08 | 561.08 | 560.81 | 560.81 | 1420.0 |
| 2024-09-03 06:00:00 | SPY | ETF | 560.75 | 561.08 | 560.5 | 560.91 | 6050.0 |
| 2024-09-03 06:05:00 | SPY | ETF | 560.92 | 560.92 | 560.56 | 560.61 | 8624.0 |
| 2024-09-03 06:10:00 | SPY | ETF | 560.6 | 561.03 | 560.55 | 561.03 | 71594.0 |
| 2024-09-03 06:15:00 | SPY | ETF | 561.0 | 561.0 | 560.86 | 560.95 | 5100.0 |
| 2024-09-03 06:20:00 | SPY | ETF | 561.0 | 561.06 | 560.91 | 560.91 | 3640.0 |
| 2024-09-03 06:25:00 | SPY | ETF | 560.95 | 561.19 | 560.95 | 561.19 | 1600.0 |
| 2024-09-03 06:30:00 | SPY | ETF | 561.21 | 561.35 | 561.1 | 561.18 | 8098.0 |
| 2024-09-03 06:35:00 | SPY | ETF | 561.08 | 561.08 | 560.75 | 560.96 | 20717.0 |
| 2024-09-03 06:40:00 | SPY | ETF | 561.07 | 561.13 | 561.03 | 561.04 | 1285.0 |
| 2024-09-03 06:45:00 | SPY | ETF | 561.0 | 561.14 | 560.92 | 561.14 | 6195.0 |
| 2024-09-03 06:50:00 | SPY | ETF | 561.17 | 561.41 | 561.17 | 561.36 | 2219.0 |
| 2024-09-03 06:55:00 | SPY | ETF | 561.26 | 561.34 | 561.26 | 561.29 | 500.0 |
| 2024-09-03 07:00:00 | SPY | ETF | 561.29 | 561.33 | 561.05 | 561.09 | 13928.0 |
| 2024-09-03 07:05:00 | SPY | ETF | 561.07 | 561.1 | 560.6 | 560.84 | 38166.0 |
| 2024-09-03 07:10:00 | SPY | ETF | 560.93 | 560.93 | 560.65 | 560.75 | 8000.0 |
| 2024-09-03 07:15:00 | SPY | ETF | 560.76 | 561.2 | 560.76 | 561.11 | 11530.0 |
| 2024-09-03 07:20:00 | SPY | ETF | 561.13 | 561.13 | 560.91 | 560.91 | 6780.0 |
| 2024-09-03 07:25:00 | SPY | ETF | 560.91 | 561.12 | 560.89 | 561.01 | 4405.0 |
| 2024-09-03 07:30:00 | SPY | ETF | 561.33 | 561.36 | 561.3 | 561.3 | 5396.0 |
| 2024-09-03 07:35:00 | SPY | ETF | 561.35 | 561.45 | 561.27 | 561.27 | 7729.0 |
| 2024-09-03 07:40:00 | SPY | ETF | 561.24 | 561.24 | 560.95 | 560.99 | 26958.0 |
| 2024-09-03 07:45:00 | SPY | ETF | 560.87 | 561.07 | 560.7 | 560.82 | 13539.0 |
| 2024-09-03 07:50:00 | SPY | ETF | 560.8 | 560.88 | 560.78 | 560.78 | 2150.0 |
| 2024-09-03 07:55:00 | SPY | ETF | 561.0 | 561.07 | 561.0 | 561.05 | 2881.0 |
| 2024-09-03 08:00:00 | SPY | ETF | 561.2884 | 564.0 | 560.6294 | 560.85 | 31852.0 |
| 2024-09-03 08:05:00 | SPY | ETF | 560.82 | 561.109 | 560.78 | 561.109 | 8155.0 |
| 2024-09-03 08:10:00 | SPY | ETF | 561.15 | 561.2 | 560.98 | 561.2 | 9959.0 |
> showing 50 of 120,757 rows — these rows as CSV