PREVIEW / etf_5min / 2022-06-27
file: by_date/etf_5min/2022/2022-06-27.parquet size: 1.9 MB rows: 94,370
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-06-27 04:00:00 | SPY | ETF | 392.57 | 392.83 | 391.02 | 392.53 | 17681.0 |
| 2022-06-27 04:05:00 | SPY | ETF | 392.63 | 392.94 | 392.56 | 392.56 | 5360.0 |
| 2022-06-27 04:10:00 | SPY | ETF | 392.51 | 392.63 | 392.5 | 392.57 | 10334.0 |
| 2022-06-27 04:15:00 | SPY | ETF | 392.83 | 392.83 | 392.83 | 392.83 | 2000.0 |
| 2022-06-27 04:20:00 | SPY | ETF | 392.82 | 392.82 | 392.56 | 392.56 | 2439.0 |
| 2022-06-27 04:25:00 | SPY | ETF | 392.6 | 392.71 | 392.53 | 392.57 | 2724.0 |
| 2022-06-27 04:30:00 | SPY | ETF | 392.67 | 392.68 | 392.45 | 392.45 | 8790.0 |
| 2022-06-27 04:35:00 | SPY | ETF | 392.5 | 392.5 | 392.0 | 392.0 | 6091.0 |
| 2022-06-27 04:40:00 | SPY | ETF | 391.91 | 392.08 | 391.9 | 392.0 | 2302.0 |
| 2022-06-27 04:45:00 | SPY | ETF | 392.09 | 392.09 | 391.87 | 392.0 | 3000.0 |
| 2022-06-27 04:50:00 | SPY | ETF | 392.0 | 392.01 | 391.7 | 391.7 | 1500.0 |
| 2022-06-27 04:55:00 | SPY | ETF | 391.6 | 391.77 | 391.6 | 391.71 | 2977.0 |
| 2022-06-27 05:00:00 | SPY | ETF | 391.74 | 391.82 | 391.7 | 391.72 | 2430.0 |
| 2022-06-27 05:05:00 | SPY | ETF | 391.7 | 391.7 | 391.35 | 391.39 | 1875.0 |
| 2022-06-27 05:10:00 | SPY | ETF | 391.47 | 391.81 | 391.47 | 391.61 | 3957.0 |
| 2022-06-27 05:15:00 | SPY | ETF | 391.64 | 391.75 | 391.64 | 391.75 | 5236.0 |
| 2022-06-27 05:20:00 | SPY | ETF | 391.75 | 391.9 | 391.75 | 391.75 | 1812.0 |
| 2022-06-27 05:25:00 | SPY | ETF | 391.81 | 391.9 | 391.65 | 391.9 | 3394.0 |
| 2022-06-27 05:30:00 | SPY | ETF | 391.85 | 391.99 | 391.71 | 391.71 | 6925.0 |
| 2022-06-27 05:35:00 | SPY | ETF | 391.73 | 391.79 | 391.5 | 391.5 | 1400.0 |
| 2022-06-27 05:40:00 | SPY | ETF | 391.58 | 391.58 | 391.5 | 391.58 | 20199.0 |
| 2022-06-27 05:45:00 | SPY | ETF | 391.83 | 391.88 | 391.82 | 391.82 | 401.0 |
| 2022-06-27 05:50:00 | SPY | ETF | 391.77 | 391.84 | 391.66 | 391.66 | 1755.0 |
| 2022-06-27 05:55:00 | SPY | ETF | 391.7 | 391.7 | 391.7 | 391.7 | 100.0 |
| 2022-06-27 06:00:00 | SPY | ETF | 391.67 | 391.67 | 391.44 | 391.61 | 2192.0 |
| 2022-06-27 06:05:00 | SPY | ETF | 391.39 | 391.39 | 391.39 | 391.39 | 199.0 |
| 2022-06-27 06:10:00 | SPY | ETF | 391.29 | 391.33 | 391.22 | 391.22 | 7079.0 |
| 2022-06-27 06:15:00 | SPY | ETF | 391.28 | 391.51 | 391.28 | 391.51 | 1150.0 |
| 2022-06-27 06:20:00 | SPY | ETF | 391.47 | 391.55 | 391.39 | 391.39 | 3108.0 |
| 2022-06-27 06:25:00 | SPY | ETF | 391.28 | 391.28 | 390.87 | 390.87 | 4782.0 |
| 2022-06-27 06:30:00 | SPY | ETF | 391.02 | 391.14 | 390.95 | 391.14 | 4096.0 |
| 2022-06-27 06:35:00 | SPY | ETF | 391.1 | 391.1 | 390.77 | 390.77 | 2478.0 |
| 2022-06-27 06:40:00 | SPY | ETF | 390.88 | 391.07 | 390.68 | 391.07 | 4175.0 |
| 2022-06-27 06:45:00 | SPY | ETF | 390.98 | 390.98 | 390.68 | 390.75 | 4699.0 |
| 2022-06-27 06:50:00 | SPY | ETF | 390.8 | 391.0 | 390.8 | 390.94 | 4493.0 |
| 2022-06-27 06:55:00 | SPY | ETF | 391.0 | 391.21 | 390.93 | 391.2 | 4709.0 |
| 2022-06-27 07:00:00 | SPY | ETF | 391.19 | 391.33 | 391.1 | 391.27 | 19810.0 |
| 2022-06-27 07:05:00 | SPY | ETF | 391.25 | 391.51 | 391.25 | 391.51 | 25053.0 |
| 2022-06-27 07:10:00 | SPY | ETF | 391.51 | 391.62 | 391.46 | 391.59 | 14562.0 |
| 2022-06-27 07:15:00 | SPY | ETF | 391.61 | 391.71 | 391.5 | 391.7 | 19907.0 |
| 2022-06-27 07:20:00 | SPY | ETF | 391.68 | 391.7 | 391.62 | 391.62 | 3280.0 |
| 2022-06-27 07:25:00 | SPY | ETF | 391.59 | 391.59 | 391.28 | 391.33 | 4541.0 |
| 2022-06-27 07:30:00 | SPY | ETF | 391.33 | 391.74 | 391.3 | 391.74 | 14629.0 |
| 2022-06-27 07:35:00 | SPY | ETF | 391.7 | 391.75 | 391.64 | 391.69 | 11076.0 |
| 2022-06-27 07:40:00 | SPY | ETF | 391.69 | 391.76 | 391.65 | 391.68 | 12104.0 |
| 2022-06-27 07:45:00 | SPY | ETF | 391.73 | 391.73 | 391.6 | 391.65 | 11511.0 |
| 2022-06-27 07:50:00 | SPY | ETF | 391.59 | 391.66 | 391.53 | 391.6 | 54318.0 |
| 2022-06-27 07:55:00 | SPY | ETF | 391.5 | 391.5 | 391.37 | 391.43 | 25985.0 |
| 2022-06-27 08:00:00 | SPY | ETF | 391.19 | 392.7196 | 389.71 | 391.45 | 82697.0 |
| 2022-06-27 08:05:00 | SPY | ETF | 391.4804 | 391.5 | 391.24 | 391.28 | 24326.0 |
> showing 50 of 94,370 rows — these rows as CSV