PREVIEW / etf_5min / 2023-10-12
file: by_date/etf_5min/2023/2023-10-12.parquet size: 2.0 MB rows: 98,013
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 |
|---|---|---|---|---|---|---|---|
| 2023-10-12 04:00:00 | SPY | ETF | 437.5 | 437.59 | 437.45 | 437.46 | 5825.0 |
| 2023-10-12 04:05:00 | SPY | ETF | 437.55 | 437.61 | 437.53 | 437.53 | 3339.0 |
| 2023-10-12 04:10:00 | SPY | ETF | 437.58 | 437.61 | 437.48 | 437.6 | 5013.0 |
| 2023-10-12 04:15:00 | SPY | ETF | 437.52 | 437.78 | 437.51 | 437.78 | 1153.0 |
| 2023-10-12 04:20:00 | SPY | ETF | 437.78 | 437.78 | 437.65 | 437.73 | 2308.0 |
| 2023-10-12 04:25:00 | SPY | ETF | 437.74 | 437.75 | 437.7 | 437.7 | 5335.0 |
| 2023-10-12 04:35:00 | SPY | ETF | 437.76 | 437.76 | 437.62 | 437.62 | 300.0 |
| 2023-10-12 04:40:00 | SPY | ETF | 437.75 | 437.75 | 437.75 | 437.75 | 418.0 |
| 2023-10-12 04:45:00 | SPY | ETF | 437.8 | 437.9 | 437.7 | 437.7 | 1468.0 |
| 2023-10-12 04:50:00 | SPY | ETF | 437.91 | 437.94 | 437.91 | 437.94 | 1175.0 |
| 2023-10-12 04:55:00 | SPY | ETF | 437.96 | 438.0 | 437.96 | 438.0 | 3011.0 |
| 2023-10-12 05:00:00 | SPY | ETF | 438.06 | 438.07 | 438.04 | 438.07 | 7000.0 |
| 2023-10-12 05:05:00 | SPY | ETF | 438.12 | 438.12 | 438.12 | 438.12 | 100.0 |
| 2023-10-12 05:10:00 | SPY | ETF | 438.15 | 438.15 | 438.03 | 438.03 | 600.0 |
| 2023-10-12 05:15:00 | SPY | ETF | 438.07 | 438.1 | 438.07 | 438.1 | 790.0 |
| 2023-10-12 05:20:00 | SPY | ETF | 438.12 | 438.13 | 438.1 | 438.13 | 700.0 |
| 2023-10-12 05:25:00 | SPY | ETF | 438.13 | 438.15 | 438.1 | 438.1 | 1016.0 |
| 2023-10-12 05:30:00 | SPY | ETF | 438.05 | 438.16 | 438.05 | 438.16 | 900.0 |
| 2023-10-12 05:35:00 | SPY | ETF | 438.14 | 438.15 | 438.12 | 438.15 | 1700.0 |
| 2023-10-12 05:40:00 | SPY | ETF | 438.13 | 438.26 | 438.13 | 438.2 | 2673.0 |
| 2023-10-12 05:45:00 | SPY | ETF | 438.29 | 438.29 | 438.29 | 438.29 | 800.0 |
| 2023-10-12 05:50:00 | SPY | ETF | 438.3 | 438.3 | 438.19 | 438.28 | 4990.0 |
| 2023-10-12 05:55:00 | SPY | ETF | 438.25 | 438.25 | 438.25 | 438.25 | 300.0 |
| 2023-10-12 06:00:00 | SPY | ETF | 438.23 | 438.23 | 438.23 | 438.23 | 400.0 |
| 2023-10-12 06:05:00 | SPY | ETF | 438.33 | 438.4 | 438.25 | 438.25 | 6241.0 |
| 2023-10-12 06:10:00 | SPY | ETF | 438.35 | 438.38 | 438.35 | 438.37 | 1447.0 |
| 2023-10-12 06:15:00 | SPY | ETF | 438.37 | 438.54 | 438.37 | 438.45 | 2431.0 |
| 2023-10-12 06:20:00 | SPY | ETF | 438.42 | 438.44 | 438.41 | 438.44 | 2597.0 |
| 2023-10-12 06:25:00 | SPY | ETF | 438.4 | 438.4 | 438.31 | 438.31 | 7168.0 |
| 2023-10-12 06:30:00 | SPY | ETF | 438.33 | 438.44 | 438.31 | 438.44 | 2527.0 |
| 2023-10-12 06:35:00 | SPY | ETF | 438.51 | 438.53 | 438.37 | 438.41 | 7889.0 |
| 2023-10-12 06:40:00 | SPY | ETF | 438.4 | 438.45 | 438.37 | 438.45 | 10502.0 |
| 2023-10-12 06:45:00 | SPY | ETF | 438.44 | 438.47 | 438.32 | 438.32 | 2560.0 |
| 2023-10-12 06:50:00 | SPY | ETF | 438.31 | 438.31 | 438.26 | 438.27 | 823.0 |
| 2023-10-12 06:55:00 | SPY | ETF | 438.23 | 438.28 | 438.23 | 438.28 | 1300.0 |
| 2023-10-12 07:00:00 | SPY | ETF | 438.24 | 438.26 | 438.15 | 438.26 | 8630.0 |
| 2023-10-12 07:05:00 | SPY | ETF | 438.26 | 438.27 | 438.16 | 438.18 | 6734.0 |
| 2023-10-12 07:10:00 | SPY | ETF | 438.19 | 438.28 | 438.19 | 438.25 | 1913.0 |
| 2023-10-12 07:15:00 | SPY | ETF | 438.26 | 438.34 | 438.26 | 438.29 | 3892.0 |
| 2023-10-12 07:20:00 | SPY | ETF | 438.2 | 438.2 | 438.1 | 438.1 | 4976.0 |
| 2023-10-12 07:25:00 | SPY | ETF | 438.1 | 438.16 | 438.04 | 438.09 | 6700.0 |
| 2023-10-12 07:30:00 | SPY | ETF | 438.07 | 438.11 | 438.03 | 438.05 | 14010.0 |
| 2023-10-12 07:35:00 | SPY | ETF | 438.07 | 438.18 | 438.07 | 438.1 | 3835.0 |
| 2023-10-12 07:40:00 | SPY | ETF | 438.17 | 438.25 | 438.09 | 438.09 | 11217.0 |
| 2023-10-12 07:45:00 | SPY | ETF | 438.11 | 438.28 | 438.05 | 438.07 | 14768.0 |
| 2023-10-12 07:50:00 | SPY | ETF | 438.04 | 438.18 | 438.04 | 438.089 | 4583.0 |
| 2023-10-12 07:55:00 | SPY | ETF | 438.11 | 438.3 | 438.11 | 438.23 | 20003.0 |
| 2023-10-12 08:00:00 | SPY | ETF | 438.21 | 438.4004 | 437.5496 | 437.85 | 82978.0 |
| 2023-10-12 08:05:00 | SPY | ETF | 438.31 | 438.43 | 438.26 | 438.43 | 27825.0 |
| 2023-10-12 08:10:00 | SPY | ETF | 438.43 | 438.6 | 438.37 | 438.4 | 73491.0 |
> showing 50 of 98,013 rows — these rows as CSV