PREVIEW / etf_5min / 2023-11-24
file: by_date/etf_5min/2023/2023-11-24.parquet size: 1.1 MB rows: 54,442
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-24 04:00:00 | SPY | ETF | 455.18 | 455.36 | 454.87 | 455.36 | 1772.0 |
| 2023-11-24 04:05:00 | SPY | ETF | 455.39 | 455.51 | 455.39 | 455.51 | 2904.0 |
| 2023-11-24 04:10:00 | SPY | ETF | 455.52 | 455.56 | 455.48 | 455.56 | 4950.0 |
| 2023-11-24 04:15:00 | SPY | ETF | 455.56 | 455.6 | 455.56 | 455.6 | 550.0 |
| 2023-11-24 04:20:00 | SPY | ETF | 455.62 | 455.62 | 455.61 | 455.61 | 200.0 |
| 2023-11-24 04:30:00 | SPY | ETF | 455.62 | 455.64 | 455.62 | 455.64 | 1125.0 |
| 2023-11-24 04:35:00 | SPY | ETF | 455.63 | 455.75 | 455.61 | 455.75 | 1200.0 |
| 2023-11-24 04:40:00 | SPY | ETF | 455.69 | 455.69 | 455.67 | 455.68 | 1200.0 |
| 2023-11-24 04:45:00 | SPY | ETF | 455.76 | 455.76 | 455.76 | 455.76 | 1990.0 |
| 2023-11-24 04:50:00 | SPY | ETF | 455.65 | 455.66 | 455.56 | 455.66 | 1145.0 |
| 2023-11-24 04:55:00 | SPY | ETF | 455.58 | 455.58 | 455.58 | 455.58 | 400.0 |
| 2023-11-24 05:00:00 | SPY | ETF | 455.58 | 455.61 | 455.52 | 455.61 | 700.0 |
| 2023-11-24 05:10:00 | SPY | ETF | 455.62 | 455.62 | 455.58 | 455.6 | 310.0 |
| 2023-11-24 05:25:00 | SPY | ETF | 455.62 | 455.62 | 455.55 | 455.55 | 1405.0 |
| 2023-11-24 05:30:00 | SPY | ETF | 455.53 | 455.53 | 455.49 | 455.49 | 373.0 |
| 2023-11-24 05:35:00 | SPY | ETF | 455.44 | 455.44 | 455.4 | 455.4 | 1197.0 |
| 2023-11-24 05:40:00 | SPY | ETF | 455.44 | 455.44 | 455.44 | 455.44 | 101.0 |
| 2023-11-24 05:45:00 | SPY | ETF | 455.55 | 455.75 | 455.54 | 455.75 | 1480.0 |
| 2023-11-24 06:00:00 | SPY | ETF | 455.69 | 455.69 | 455.67 | 455.67 | 1655.0 |
| 2023-11-24 06:05:00 | SPY | ETF | 455.53 | 455.53 | 455.53 | 455.53 | 200.0 |
| 2023-11-24 06:10:00 | SPY | ETF | 455.41 | 455.41 | 455.41 | 455.41 | 186.0 |
| 2023-11-24 06:20:00 | SPY | ETF | 455.54 | 455.54 | 455.54 | 455.54 | 600.0 |
| 2023-11-24 06:25:00 | SPY | ETF | 455.49 | 455.5 | 455.43 | 455.43 | 600.0 |
| 2023-11-24 06:35:00 | SPY | ETF | 455.45 | 455.5 | 455.45 | 455.5 | 425.0 |
| 2023-11-24 06:50:00 | SPY | ETF | 455.41 | 455.46 | 455.4 | 455.46 | 533.0 |
| 2023-11-24 06:55:00 | SPY | ETF | 455.47 | 455.56 | 455.47 | 455.56 | 900.0 |
| 2023-11-24 07:00:00 | SPY | ETF | 455.57 | 455.66 | 455.57 | 455.6 | 2745.0 |
| 2023-11-24 07:05:00 | SPY | ETF | 455.59 | 455.77 | 455.59 | 455.77 | 2066.0 |
| 2023-11-24 07:10:00 | SPY | ETF | 455.71 | 455.74 | 455.7 | 455.74 | 4204.0 |
| 2023-11-24 07:15:00 | SPY | ETF | 455.76 | 455.79 | 455.74 | 455.74 | 1150.0 |
| 2023-11-24 07:20:00 | SPY | ETF | 455.7 | 455.7 | 455.68 | 455.68 | 400.0 |
| 2023-11-24 07:25:00 | SPY | ETF | 455.69 | 455.7 | 455.69 | 455.7 | 200.0 |
| 2023-11-24 07:30:00 | SPY | ETF | 455.69 | 455.69 | 455.67 | 455.69 | 600.0 |
| 2023-11-24 07:35:00 | SPY | ETF | 455.71 | 455.71 | 455.71 | 455.71 | 2200.0 |
| 2023-11-24 07:40:00 | SPY | ETF | 455.73 | 455.75 | 455.67 | 455.67 | 1413.0 |
| 2023-11-24 07:45:00 | SPY | ETF | 455.64 | 455.64 | 455.53 | 455.56 | 6262.0 |
| 2023-11-24 07:50:00 | SPY | ETF | 455.58 | 455.61 | 455.58 | 455.61 | 645.0 |
| 2023-11-24 07:55:00 | SPY | ETF | 455.6 | 455.62 | 455.6 | 455.62 | 1760.0 |
| 2023-11-24 08:00:00 | SPY | ETF | 455.63 | 455.78 | 455.37 | 455.41 | 27859.0 |
| 2023-11-24 08:05:00 | SPY | ETF | 455.05 | 455.49 | 455.05 | 455.46 | 10108.0 |
| 2023-11-24 08:10:00 | SPY | ETF | 455.57 | 455.57 | 455.57 | 455.57 | 300.0 |
| 2023-11-24 08:15:00 | SPY | ETF | 455.37 | 455.42 | 455.37 | 455.3804 | 1977.0 |
| 2023-11-24 08:20:00 | SPY | ETF | 455.38 | 455.38 | 455.3 | 455.3 | 8810.0 |
| 2023-11-24 08:25:00 | SPY | ETF | 455.3 | 455.3 | 455.22 | 455.26 | 16628.0 |
| 2023-11-24 08:30:00 | SPY | ETF | 455.25 | 455.25 | 455.12 | 455.17 | 14682.0 |
| 2023-11-24 08:35:00 | SPY | ETF | 455.23 | 455.29 | 455.2 | 455.21 | 9663.0 |
| 2023-11-24 08:40:00 | SPY | ETF | 455.2199 | 455.36 | 455.19 | 455.36 | 26006.0 |
| 2023-11-24 08:45:00 | SPY | ETF | 455.38 | 455.42 | 455.29 | 455.39 | 7508.0 |
| 2023-11-24 08:50:00 | SPY | ETF | 455.36 | 455.45 | 455.36 | 455.43 | 5078.0 |
| 2023-11-24 08:55:00 | SPY | ETF | 455.46 | 455.48 | 455.4 | 455.4 | 5096.0 |
> showing 50 of 54,442 rows — these rows as CSV