PREVIEW / etf_5min / 2022-07-26
file: by_date/etf_5min/2022/2022-07-26.parquet size: 1.8 MB rows: 86,271
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-07-26 04:00:00 | SPY | ETF | 394.88 | 394.88 | 394.63 | 394.63 | 8942.0 |
| 2022-07-26 04:05:00 | SPY | ETF | 394.54 | 394.62 | 394.42 | 394.48 | 7703.0 |
| 2022-07-26 04:10:00 | SPY | ETF | 394.5 | 394.5 | 394.3 | 394.31 | 3302.0 |
| 2022-07-26 04:15:00 | SPY | ETF | 394.25 | 394.43 | 394.21 | 394.43 | 7314.0 |
| 2022-07-26 04:20:00 | SPY | ETF | 394.41 | 394.49 | 394.41 | 394.49 | 2200.0 |
| 2022-07-26 04:25:00 | SPY | ETF | 394.44 | 394.54 | 394.44 | 394.5 | 2600.0 |
| 2022-07-26 04:30:00 | SPY | ETF | 394.5 | 394.71 | 394.5 | 394.71 | 3230.0 |
| 2022-07-26 04:35:00 | SPY | ETF | 394.53 | 394.53 | 394.53 | 394.53 | 100.0 |
| 2022-07-26 04:50:00 | SPY | ETF | 394.58 | 394.63 | 394.58 | 394.63 | 1500.0 |
| 2022-07-26 04:55:00 | SPY | ETF | 394.67 | 394.72 | 394.61 | 394.62 | 2377.0 |
| 2022-07-26 05:00:00 | SPY | ETF | 394.63 | 394.88 | 394.63 | 394.88 | 7225.0 |
| 2022-07-26 05:05:00 | SPY | ETF | 394.9 | 395.0 | 394.8 | 394.8 | 6974.0 |
| 2022-07-26 05:10:00 | SPY | ETF | 394.78 | 394.78 | 394.68 | 394.68 | 2093.0 |
| 2022-07-26 05:15:00 | SPY | ETF | 394.68 | 394.68 | 394.56 | 394.64 | 12880.0 |
| 2022-07-26 05:20:00 | SPY | ETF | 394.66 | 394.66 | 394.51 | 394.62 | 2450.0 |
| 2022-07-26 05:25:00 | SPY | ETF | 394.53 | 394.53 | 394.41 | 394.41 | 4435.0 |
| 2022-07-26 05:30:00 | SPY | ETF | 394.38 | 394.43 | 394.32 | 394.32 | 10590.0 |
| 2022-07-26 05:35:00 | SPY | ETF | 394.34 | 394.47 | 394.2 | 394.47 | 7250.0 |
| 2022-07-26 05:40:00 | SPY | ETF | 394.41 | 394.53 | 394.41 | 394.53 | 1200.0 |
| 2022-07-26 05:45:00 | SPY | ETF | 394.51 | 394.8 | 394.51 | 394.69 | 22865.0 |
| 2022-07-26 05:50:00 | SPY | ETF | 394.65 | 394.7 | 394.65 | 394.7 | 5250.0 |
| 2022-07-26 05:55:00 | SPY | ETF | 394.74 | 394.74 | 394.74 | 394.74 | 100.0 |
| 2022-07-26 06:00:00 | SPY | ETF | 394.65 | 394.72 | 394.65 | 394.72 | 5200.0 |
| 2022-07-26 06:05:00 | SPY | ETF | 394.77 | 394.86 | 394.51 | 394.55 | 20617.0 |
| 2022-07-26 06:10:00 | SPY | ETF | 394.74 | 394.74 | 394.47 | 394.47 | 9600.0 |
| 2022-07-26 06:15:00 | SPY | ETF | 394.45 | 394.45 | 394.22 | 394.27 | 23114.0 |
| 2022-07-26 06:20:00 | SPY | ETF | 394.22 | 394.22 | 393.85 | 393.87 | 50954.0 |
| 2022-07-26 06:25:00 | SPY | ETF | 393.84 | 394.0 | 393.73 | 394.0 | 18912.0 |
| 2022-07-26 06:30:00 | SPY | ETF | 393.95 | 394.1 | 393.78 | 393.78 | 15467.0 |
| 2022-07-26 06:35:00 | SPY | ETF | 393.83 | 393.83 | 393.65 | 393.77 | 21220.0 |
| 2022-07-26 06:40:00 | SPY | ETF | 393.83 | 393.95 | 393.7 | 393.95 | 7020.0 |
| 2022-07-26 06:45:00 | SPY | ETF | 394.02 | 394.12 | 394.01 | 394.1 | 3749.0 |
| 2022-07-26 06:50:00 | SPY | ETF | 394.09 | 394.27 | 393.96 | 394.27 | 27674.0 |
| 2022-07-26 06:55:00 | SPY | ETF | 394.25 | 394.25 | 394.06 | 394.09 | 13250.0 |
| 2022-07-26 07:00:00 | SPY | ETF | 394.1 | 394.31 | 393.83 | 394.24 | 25218.0 |
| 2022-07-26 07:05:00 | SPY | ETF | 394.2 | 394.3 | 394.1 | 394.1 | 8410.0 |
| 2022-07-26 07:10:00 | SPY | ETF | 394.13 | 394.13 | 393.78 | 393.92 | 15692.0 |
| 2022-07-26 07:15:00 | SPY | ETF | 393.94 | 394.08 | 393.8 | 393.8 | 56172.0 |
| 2022-07-26 07:20:00 | SPY | ETF | 393.83 | 394.0 | 393.83 | 393.92 | 51366.0 |
| 2022-07-26 07:25:00 | SPY | ETF | 393.95 | 394.25 | 393.95 | 394.25 | 1755.0 |
| 2022-07-26 07:30:00 | SPY | ETF | 394.19 | 394.31 | 394.19 | 394.24 | 5264.0 |
| 2022-07-26 07:35:00 | SPY | ETF | 394.26 | 394.29 | 394.18 | 394.28 | 5305.0 |
| 2022-07-26 07:40:00 | SPY | ETF | 394.26 | 394.26 | 394.08 | 394.15 | 30923.0 |
| 2022-07-26 07:45:00 | SPY | ETF | 394.15 | 394.28 | 394.15 | 394.28 | 26295.0 |
| 2022-07-26 07:50:00 | SPY | ETF | 394.32 | 394.41 | 394.21 | 394.21 | 16329.0 |
| 2022-07-26 07:55:00 | SPY | ETF | 394.24 | 394.24 | 394.0 | 394.0 | 10547.0 |
| 2022-07-26 08:00:00 | SPY | ETF | 394.2 | 394.54 | 393.6904 | 394.1 | 19653.0 |
| 2022-07-26 08:05:00 | SPY | ETF | 394.14 | 394.27 | 394.14 | 394.2 | 10778.0 |
| 2022-07-26 08:10:00 | SPY | ETF | 394.21 | 394.3 | 394.19 | 394.19 | 9922.0 |
| 2022-07-26 08:15:00 | SPY | ETF | 394.18 | 394.18 | 393.83 | 393.9 | 24509.0 |
> showing 50 of 86,271 rows — these rows as CSV