PREVIEW / etf_5min / 2023-11-14
file: by_date/etf_5min/2023/2023-11-14.parquet size: 2.2 MB rows: 109,172
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-11-14 04:00:00 | SPY | ETF | 440.5 | 440.97 | 440.5 | 440.95 | 3813.0 |
| 2023-11-14 04:05:00 | SPY | ETF | 441.02 | 441.11 | 440.93 | 441.11 | 7752.0 |
| 2023-11-14 04:10:00 | SPY | ETF | 441.16 | 441.27 | 441.12 | 441.23 | 6929.0 |
| 2023-11-14 04:15:00 | SPY | ETF | 441.23 | 441.36 | 441.23 | 441.36 | 5881.0 |
| 2023-11-14 04:20:00 | SPY | ETF | 441.36 | 441.39 | 441.23 | 441.23 | 3833.0 |
| 2023-11-14 04:25:00 | SPY | ETF | 441.26 | 441.27 | 441.14 | 441.27 | 6205.0 |
| 2023-11-14 04:30:00 | SPY | ETF | 441.19 | 441.19 | 441.05 | 441.08 | 4727.0 |
| 2023-11-14 04:35:00 | SPY | ETF | 441.02 | 441.2 | 440.97 | 441.1 | 4042.0 |
| 2023-11-14 04:45:00 | SPY | ETF | 441.08 | 441.08 | 441.08 | 441.08 | 119.0 |
| 2023-11-14 04:50:00 | SPY | ETF | 441.24 | 441.24 | 441.24 | 441.24 | 376.0 |
| 2023-11-14 04:55:00 | SPY | ETF | 441.13 | 441.13 | 441.08 | 441.08 | 400.0 |
| 2023-11-14 05:00:00 | SPY | ETF | 441.2 | 441.21 | 441.04 | 441.04 | 1027.0 |
| 2023-11-14 05:05:00 | SPY | ETF | 441.0 | 441.0 | 441.0 | 441.0 | 250.0 |
| 2023-11-14 05:10:00 | SPY | ETF | 440.98 | 440.98 | 440.95 | 440.95 | 4900.0 |
| 2023-11-14 05:15:00 | SPY | ETF | 441.04 | 441.08 | 441.04 | 441.08 | 700.0 |
| 2023-11-14 05:20:00 | SPY | ETF | 441.16 | 441.22 | 441.16 | 441.22 | 1497.0 |
| 2023-11-14 05:25:00 | SPY | ETF | 441.28 | 441.29 | 441.28 | 441.29 | 5324.0 |
| 2023-11-14 05:30:00 | SPY | ETF | 441.29 | 441.29 | 441.06 | 441.07 | 509.0 |
| 2023-11-14 05:35:00 | SPY | ETF | 441.05 | 441.05 | 441.0 | 441.02 | 726.0 |
| 2023-11-14 05:40:00 | SPY | ETF | 441.0 | 441.0 | 441.0 | 441.0 | 4502.0 |
| 2023-11-14 05:45:00 | SPY | ETF | 440.73 | 440.73 | 440.7 | 440.7 | 1200.0 |
| 2023-11-14 05:50:00 | SPY | ETF | 440.58 | 440.67 | 440.58 | 440.67 | 445.0 |
| 2023-11-14 05:55:00 | SPY | ETF | 440.72 | 440.72 | 440.66 | 440.66 | 600.0 |
| 2023-11-14 06:00:00 | SPY | ETF | 440.73 | 440.75 | 440.73 | 440.75 | 1129.0 |
| 2023-11-14 06:05:00 | SPY | ETF | 440.51 | 440.58 | 440.34 | 440.37 | 727.0 |
| 2023-11-14 06:10:00 | SPY | ETF | 440.4 | 440.5 | 440.4 | 440.4 | 1686.0 |
| 2023-11-14 06:15:00 | SPY | ETF | 440.5 | 440.5 | 440.5 | 440.5 | 100.0 |
| 2023-11-14 06:25:00 | SPY | ETF | 440.52 | 440.52 | 440.45 | 440.45 | 37446.0 |
| 2023-11-14 06:30:00 | SPY | ETF | 440.43 | 440.52 | 440.43 | 440.52 | 37352.0 |
| 2023-11-14 06:35:00 | SPY | ETF | 440.56 | 440.63 | 440.56 | 440.63 | 900.0 |
| 2023-11-14 06:40:00 | SPY | ETF | 440.46 | 440.48 | 440.46 | 440.48 | 1120.0 |
| 2023-11-14 06:45:00 | SPY | ETF | 440.55 | 440.55 | 440.5 | 440.5 | 687.0 |
| 2023-11-14 06:50:00 | SPY | ETF | 440.5 | 440.63 | 440.5 | 440.63 | 1050.0 |
| 2023-11-14 06:55:00 | SPY | ETF | 440.67 | 440.75 | 440.67 | 440.75 | 710.0 |
| 2023-11-14 07:00:00 | SPY | ETF | 440.68 | 440.75 | 440.68 | 440.7 | 808.0 |
| 2023-11-14 07:05:00 | SPY | ETF | 440.68 | 440.75 | 440.59 | 440.68 | 3204.0 |
| 2023-11-14 07:10:00 | SPY | ETF | 440.6 | 440.69 | 440.6 | 440.68 | 1790.0 |
| 2023-11-14 07:15:00 | SPY | ETF | 440.68 | 440.72 | 440.63 | 440.65 | 7925.0 |
| 2023-11-14 07:20:00 | SPY | ETF | 440.61 | 440.61 | 440.5 | 440.52 | 3086.0 |
| 2023-11-14 07:25:00 | SPY | ETF | 440.5 | 440.58 | 440.46 | 440.57 | 3290.0 |
| 2023-11-14 07:30:00 | SPY | ETF | 440.47 | 440.55 | 440.43 | 440.55 | 9631.0 |
| 2023-11-14 07:35:00 | SPY | ETF | 440.54 | 440.6 | 440.49 | 440.58 | 7124.0 |
| 2023-11-14 07:40:00 | SPY | ETF | 440.54 | 440.58 | 440.34 | 440.37 | 20732.0 |
| 2023-11-14 07:45:00 | SPY | ETF | 440.36 | 440.38 | 440.23 | 440.24 | 6175.0 |
| 2023-11-14 07:50:00 | SPY | ETF | 440.28 | 440.4 | 440.27 | 440.37 | 2386.0 |
| 2023-11-14 07:55:00 | SPY | ETF | 440.36 | 440.61 | 440.36 | 440.61 | 11483.0 |
| 2023-11-14 08:00:00 | SPY | ETF | 440.7003 | 441.2196 | 440.2893 | 440.6395 | 29209.0 |
| 2023-11-14 08:05:00 | SPY | ETF | 440.6 | 440.72 | 440.48 | 440.72 | 10049.0 |
| 2023-11-14 08:10:00 | SPY | ETF | 440.73 | 440.83 | 440.7 | 440.7 | 20216.0 |
| 2023-11-14 08:15:00 | SPY | ETF | 440.75 | 440.95 | 440.73 | 440.88 | 14429.0 |
> showing 50 of 109,172 rows — these rows as CSV