PREVIEW / etf_5min / 2022-11-18
file: by_date/etf_5min/2022/2022-11-18.parquet size: 1.9 MB rows: 93,471
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 |
|---|---|---|---|---|---|---|---|
| 2022-11-18 04:00:00 | SPY | ETF | 394.49 | 394.94 | 394.38 | 394.94 | 12255.0 |
| 2022-11-18 04:05:00 | SPY | ETF | 394.92 | 395.39 | 394.92 | 395.21 | 9178.0 |
| 2022-11-18 04:10:00 | SPY | ETF | 395.07 | 395.08 | 394.91 | 394.93 | 2363.0 |
| 2022-11-18 04:15:00 | SPY | ETF | 395.04 | 395.49 | 395.04 | 395.42 | 3233.0 |
| 2022-11-18 04:20:00 | SPY | ETF | 395.38 | 395.54 | 395.37 | 395.38 | 2146.0 |
| 2022-11-18 04:25:00 | SPY | ETF | 395.52 | 395.77 | 395.51 | 395.7 | 5226.0 |
| 2022-11-18 04:30:00 | SPY | ETF | 395.74 | 396.12 | 395.67 | 396.12 | 4798.0 |
| 2022-11-18 04:35:00 | SPY | ETF | 396.12 | 396.2 | 395.92 | 395.92 | 4160.0 |
| 2022-11-18 04:40:00 | SPY | ETF | 396.06 | 396.07 | 395.98 | 395.98 | 3599.0 |
| 2022-11-18 04:45:00 | SPY | ETF | 395.93 | 395.93 | 395.59 | 395.6 | 12811.0 |
| 2022-11-18 04:50:00 | SPY | ETF | 395.6 | 395.6 | 395.51 | 395.51 | 1221.0 |
| 2022-11-18 04:55:00 | SPY | ETF | 395.42 | 395.42 | 395.42 | 395.42 | 100.0 |
| 2022-11-18 05:00:00 | SPY | ETF | 395.36 | 395.36 | 395.22 | 395.24 | 2200.0 |
| 2022-11-18 05:05:00 | SPY | ETF | 395.24 | 395.62 | 395.24 | 395.62 | 5050.0 |
| 2022-11-18 05:10:00 | SPY | ETF | 395.63 | 395.65 | 395.63 | 395.65 | 1900.0 |
| 2022-11-18 05:15:00 | SPY | ETF | 395.87 | 396.09 | 395.87 | 396.0 | 10500.0 |
| 2022-11-18 05:20:00 | SPY | ETF | 395.86 | 395.93 | 395.82 | 395.87 | 2300.0 |
| 2022-11-18 05:25:00 | SPY | ETF | 395.81 | 395.81 | 395.81 | 395.81 | 900.0 |
| 2022-11-18 05:30:00 | SPY | ETF | 395.75 | 395.78 | 395.72 | 395.75 | 1641.0 |
| 2022-11-18 05:35:00 | SPY | ETF | 395.78 | 396.5 | 395.78 | 396.5 | 9160.0 |
| 2022-11-18 05:40:00 | SPY | ETF | 396.47 | 396.58 | 396.44 | 396.44 | 2227.0 |
| 2022-11-18 05:45:00 | SPY | ETF | 396.43 | 396.53 | 396.35 | 396.51 | 1480.0 |
| 2022-11-18 05:50:00 | SPY | ETF | 396.75 | 396.92 | 396.73 | 396.92 | 5329.0 |
| 2022-11-18 05:55:00 | SPY | ETF | 396.88 | 396.9 | 396.8 | 396.82 | 2724.0 |
| 2022-11-18 06:00:00 | SPY | ETF | 396.98 | 397.01 | 396.71 | 396.75 | 5627.0 |
| 2022-11-18 06:05:00 | SPY | ETF | 396.63 | 396.82 | 396.63 | 396.8 | 1164.0 |
| 2022-11-18 06:10:00 | SPY | ETF | 396.77 | 396.77 | 396.55 | 396.56 | 4204.0 |
| 2022-11-18 06:15:00 | SPY | ETF | 396.64 | 396.84 | 396.64 | 396.7 | 5726.0 |
| 2022-11-18 06:20:00 | SPY | ETF | 396.71 | 396.71 | 396.62 | 396.69 | 950.0 |
| 2022-11-18 06:25:00 | SPY | ETF | 396.52 | 396.52 | 396.47 | 396.52 | 35677.0 |
| 2022-11-18 06:30:00 | SPY | ETF | 396.8 | 396.83 | 396.79 | 396.83 | 2347.0 |
| 2022-11-18 06:35:00 | SPY | ETF | 396.7 | 396.81 | 396.61 | 396.62 | 38920.0 |
| 2022-11-18 06:40:00 | SPY | ETF | 396.76 | 396.76 | 396.42 | 396.42 | 2500.0 |
| 2022-11-18 06:45:00 | SPY | ETF | 396.44 | 396.62 | 396.44 | 396.62 | 4499.0 |
| 2022-11-18 06:50:00 | SPY | ETF | 396.58 | 396.85 | 396.54 | 396.76 | 12152.0 |
| 2022-11-18 06:55:00 | SPY | ETF | 396.72 | 396.76 | 396.67 | 396.72 | 3600.0 |
| 2022-11-18 07:00:00 | SPY | ETF | 396.64 | 397.35 | 396.59 | 397.32 | 55046.0 |
| 2022-11-18 07:05:00 | SPY | ETF | 397.23 | 397.41 | 397.07 | 397.27 | 40015.0 |
| 2022-11-18 07:10:00 | SPY | ETF | 397.28 | 397.3 | 397.13 | 397.22 | 14515.0 |
| 2022-11-18 07:15:00 | SPY | ETF | 397.33 | 397.52 | 397.29 | 397.36 | 27631.0 |
| 2022-11-18 07:20:00 | SPY | ETF | 397.37 | 397.39 | 397.18 | 397.18 | 19243.0 |
| 2022-11-18 07:25:00 | SPY | ETF | 397.11 | 397.24 | 397.1 | 397.23 | 10698.0 |
| 2022-11-18 07:30:00 | SPY | ETF | 397.25 | 397.26 | 397.07 | 397.08 | 19724.0 |
| 2022-11-18 07:35:00 | SPY | ETF | 397.05 | 397.1 | 396.91 | 397.1 | 14237.0 |
| 2022-11-18 07:40:00 | SPY | ETF | 397.04 | 397.05 | 396.94 | 396.97 | 26123.0 |
| 2022-11-18 07:45:00 | SPY | ETF | 397.0 | 397.1 | 396.92 | 397.08 | 14500.0 |
| 2022-11-18 07:50:00 | SPY | ETF | 397.1 | 397.16 | 396.98 | 396.98 | 36898.0 |
| 2022-11-18 07:55:00 | SPY | ETF | 396.97 | 397.0 | 396.83 | 396.95 | 10985.0 |
| 2022-11-18 08:00:00 | SPY | ETF | 397.32 | 397.52 | 393.3 | 397.39 | 80100.0 |
| 2022-11-18 08:05:00 | SPY | ETF | 397.45 | 397.84 | 397.38 | 397.58 | 80332.0 |
> showing 50 of 93,471 rows — these rows as CSV