PREVIEW / etf_5min / 2024-08-15
file: by_date/etf_5min/2024/2024-08-15.parquet size: 2.3 MB rows: 113,512
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-15 04:00:00 | SPY | ETF | 545.37 | 545.37 | 545.27 | 545.37 | 1786.0 |
| 2024-08-15 04:05:00 | SPY | ETF | 545.35 | 545.44 | 545.28 | 545.28 | 2716.0 |
| 2024-08-15 04:10:00 | SPY | ETF | 545.21 | 545.21 | 545.01 | 545.01 | 1998.0 |
| 2024-08-15 04:15:00 | SPY | ETF | 545.11 | 545.11 | 544.99 | 545.0 | 871.0 |
| 2024-08-15 04:20:00 | SPY | ETF | 545.04 | 545.04 | 544.76 | 544.76 | 1319.0 |
| 2024-08-15 04:25:00 | SPY | ETF | 544.81 | 544.81 | 544.61 | 544.61 | 5843.0 |
| 2024-08-15 04:30:00 | SPY | ETF | 544.4 | 544.4 | 544.4 | 544.4 | 100.0 |
| 2024-08-15 04:35:00 | SPY | ETF | 544.21 | 544.35 | 544.11 | 544.35 | 2221.0 |
| 2024-08-15 04:40:00 | SPY | ETF | 544.42 | 544.43 | 544.41 | 544.41 | 1268.0 |
| 2024-08-15 04:45:00 | SPY | ETF | 544.73 | 544.73 | 544.73 | 544.73 | 103.0 |
| 2024-08-15 04:50:00 | SPY | ETF | 544.54 | 544.64 | 544.54 | 544.64 | 342.0 |
| 2024-08-15 05:20:00 | SPY | ETF | 544.82 | 544.83 | 544.82 | 544.82 | 5021.0 |
| 2024-08-15 05:25:00 | SPY | ETF | 544.76 | 544.86 | 544.7 | 544.86 | 1936.0 |
| 2024-08-15 05:30:00 | SPY | ETF | 544.9 | 544.9 | 544.9 | 544.9 | 495.0 |
| 2024-08-15 05:35:00 | SPY | ETF | 544.95 | 544.95 | 544.84 | 544.84 | 875.0 |
| 2024-08-15 05:40:00 | SPY | ETF | 544.81 | 544.81 | 544.8 | 544.8 | 224.0 |
| 2024-08-15 05:45:00 | SPY | ETF | 544.69 | 544.69 | 544.69 | 544.69 | 100.0 |
| 2024-08-15 05:55:00 | SPY | ETF | 544.91 | 544.91 | 544.91 | 544.91 | 144.0 |
| 2024-08-15 06:00:00 | SPY | ETF | 544.99 | 545.05 | 544.99 | 545.05 | 1208.0 |
| 2024-08-15 06:05:00 | SPY | ETF | 544.92 | 544.92 | 544.9 | 544.9 | 399.0 |
| 2024-08-15 06:15:00 | SPY | ETF | 544.71 | 544.75 | 544.49 | 544.49 | 3909.0 |
| 2024-08-15 06:20:00 | SPY | ETF | 544.41 | 544.41 | 544.41 | 544.41 | 500.0 |
| 2024-08-15 06:25:00 | SPY | ETF | 544.4 | 544.44 | 544.38 | 544.4 | 1400.0 |
| 2024-08-15 06:30:00 | SPY | ETF | 544.3 | 544.45 | 544.28 | 544.45 | 6476.0 |
| 2024-08-15 06:40:00 | SPY | ETF | 544.23 | 544.24 | 544.19 | 544.24 | 2946.0 |
| 2024-08-15 06:45:00 | SPY | ETF | 544.32 | 544.32 | 544.32 | 544.32 | 103.0 |
| 2024-08-15 06:50:00 | SPY | ETF | 544.15 | 544.28 | 544.11 | 544.28 | 2246.0 |
| 2024-08-15 06:55:00 | SPY | ETF | 544.22 | 544.22 | 543.94 | 543.95 | 3728.0 |
| 2024-08-15 07:00:00 | SPY | ETF | 543.92 | 544.34 | 543.5 | 544.34 | 88481.0 |
| 2024-08-15 07:05:00 | SPY | ETF | 544.31 | 544.48 | 544.31 | 544.38 | 37661.0 |
| 2024-08-15 07:10:00 | SPY | ETF | 544.43 | 544.5 | 544.37 | 544.5 | 1710.0 |
| 2024-08-15 07:15:00 | SPY | ETF | 544.51 | 545.06 | 544.51 | 545.06 | 17428.0 |
| 2024-08-15 07:20:00 | SPY | ETF | 545.04 | 545.16 | 544.95 | 545.13 | 16995.0 |
| 2024-08-15 07:25:00 | SPY | ETF | 545.11 | 545.17 | 545.07 | 545.16 | 5277.0 |
| 2024-08-15 07:30:00 | SPY | ETF | 545.16 | 545.38 | 545.08 | 545.24 | 15975.0 |
| 2024-08-15 07:35:00 | SPY | ETF | 545.3 | 545.3 | 545.07 | 545.18 | 8674.0 |
| 2024-08-15 07:40:00 | SPY | ETF | 545.29 | 545.31 | 545.18 | 545.25 | 10696.0 |
| 2024-08-15 07:45:00 | SPY | ETF | 545.27 | 545.37 | 545.27 | 545.37 | 4783.0 |
| 2024-08-15 07:50:00 | SPY | ETF | 545.29 | 545.33 | 545.1 | 545.1 | 12720.0 |
| 2024-08-15 07:55:00 | SPY | ETF | 545.14 | 545.25 | 545.14 | 545.21 | 2667.0 |
| 2024-08-15 08:00:00 | SPY | ETF | 544.3 | 545.35 | 543.69 | 545.17 | 35500.0 |
| 2024-08-15 08:05:00 | SPY | ETF | 545.17 | 545.23 | 545.14 | 545.2 | 3212.0 |
| 2024-08-15 08:10:00 | SPY | ETF | 545.22 | 545.36 | 545.19 | 545.3 | 13630.0 |
| 2024-08-15 08:15:00 | SPY | ETF | 545.36 | 545.44 | 545.32 | 545.38 | 12759.0 |
| 2024-08-15 08:20:00 | SPY | ETF | 545.41 | 545.5 | 545.34 | 545.35 | 12756.0 |
| 2024-08-15 08:25:00 | SPY | ETF | 545.36 | 545.36 | 544.95 | 545.12 | 21344.0 |
| 2024-08-15 08:30:00 | SPY | ETF | 545.5 | 547.83 | 545.07 | 547.78 | 205004.0 |
| 2024-08-15 08:35:00 | SPY | ETF | 547.78 | 548.42 | 547.5 | 548.31 | 430795.0 |
| 2024-08-15 08:40:00 | SPY | ETF | 548.3308 | 548.36 | 548.04 | 548.2699 | 219969.0 |
| 2024-08-15 08:45:00 | SPY | ETF | 548.29 | 549.07 | 548.17 | 549.06 | 144106.0 |
> showing 50 of 113,512 rows — these rows as CSV