PREVIEW / etf_5min / 2022-05-19
file: by_date/etf_5min/2022/2022-05-19.parquet size: 2.1 MB rows: 101,650
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-05-19 04:00:00 | SPY | ETF | 388.77 | 389.02 | 388.09 | 388.16 | 13242.0 |
| 2022-05-19 04:05:00 | SPY | ETF | 388.0 | 388.33 | 387.67 | 388.33 | 6851.0 |
| 2022-05-19 04:10:00 | SPY | ETF | 388.36 | 388.73 | 388.01 | 388.68 | 6548.0 |
| 2022-05-19 04:15:00 | SPY | ETF | 388.6 | 388.78 | 387.85 | 387.91 | 6247.0 |
| 2022-05-19 04:20:00 | SPY | ETF | 387.87 | 388.07 | 387.8 | 387.98 | 3199.0 |
| 2022-05-19 04:25:00 | SPY | ETF | 388.1 | 388.38 | 387.67 | 387.67 | 6420.0 |
| 2022-05-19 04:30:00 | SPY | ETF | 387.79 | 387.79 | 387.26 | 387.26 | 1700.0 |
| 2022-05-19 04:35:00 | SPY | ETF | 387.36 | 387.58 | 387.26 | 387.26 | 29764.0 |
| 2022-05-19 04:40:00 | SPY | ETF | 387.39 | 387.4 | 387.05 | 387.3 | 22168.0 |
| 2022-05-19 04:45:00 | SPY | ETF | 387.3 | 387.51 | 387.12 | 387.17 | 7079.0 |
| 2022-05-19 04:50:00 | SPY | ETF | 387.38 | 387.61 | 387.16 | 387.53 | 6952.0 |
| 2022-05-19 04:55:00 | SPY | ETF | 387.13 | 387.15 | 386.4 | 386.4 | 30827.0 |
| 2022-05-19 05:00:00 | SPY | ETF | 386.36 | 386.36 | 386.07 | 386.23 | 58861.0 |
| 2022-05-19 05:05:00 | SPY | ETF | 386.24 | 386.85 | 386.24 | 386.85 | 13001.0 |
| 2022-05-19 05:10:00 | SPY | ETF | 386.76 | 386.76 | 386.0 | 386.07 | 7487.0 |
| 2022-05-19 05:15:00 | SPY | ETF | 386.03 | 386.24 | 385.98 | 386.02 | 18368.0 |
| 2022-05-19 05:20:00 | SPY | ETF | 386.04 | 386.36 | 385.99 | 385.99 | 7447.0 |
| 2022-05-19 05:25:00 | SPY | ETF | 386.15 | 386.32 | 385.94 | 386.27 | 5215.0 |
| 2022-05-19 05:30:00 | SPY | ETF | 386.3 | 386.3 | 385.82 | 386.12 | 8619.0 |
| 2022-05-19 05:35:00 | SPY | ETF | 386.11 | 386.11 | 385.45 | 385.45 | 9961.0 |
| 2022-05-19 05:40:00 | SPY | ETF | 385.49 | 385.74 | 385.41 | 385.54 | 19072.0 |
| 2022-05-19 05:45:00 | SPY | ETF | 385.53 | 386.21 | 385.45 | 386.13 | 11542.0 |
| 2022-05-19 05:50:00 | SPY | ETF | 385.82 | 386.3 | 385.82 | 386.25 | 7028.0 |
| 2022-05-19 05:55:00 | SPY | ETF | 386.13 | 386.13 | 385.56 | 385.8 | 6478.0 |
| 2022-05-19 06:00:00 | SPY | ETF | 385.7 | 386.44 | 385.7 | 386.21 | 3650.0 |
| 2022-05-19 06:05:00 | SPY | ETF | 386.33 | 386.6 | 386.25 | 386.54 | 15338.0 |
| 2022-05-19 06:10:00 | SPY | ETF | 386.6 | 386.86 | 386.57 | 386.57 | 15327.0 |
| 2022-05-19 06:15:00 | SPY | ETF | 386.62 | 386.66 | 386.25 | 386.51 | 16900.0 |
| 2022-05-19 06:20:00 | SPY | ETF | 386.48 | 386.78 | 386.47 | 386.78 | 3199.0 |
| 2022-05-19 06:25:00 | SPY | ETF | 386.78 | 386.85 | 386.51 | 386.53 | 5929.0 |
| 2022-05-19 06:30:00 | SPY | ETF | 386.52 | 386.59 | 386.06 | 386.06 | 13285.0 |
| 2022-05-19 06:35:00 | SPY | ETF | 386.3 | 386.74 | 386.19 | 386.74 | 4869.0 |
| 2022-05-19 06:40:00 | SPY | ETF | 386.7 | 387.16 | 386.7 | 387.09 | 5978.0 |
| 2022-05-19 06:45:00 | SPY | ETF | 387.26 | 387.73 | 387.26 | 387.57 | 41570.0 |
| 2022-05-19 06:50:00 | SPY | ETF | 387.66 | 387.71 | 387.31 | 387.71 | 37145.0 |
| 2022-05-19 06:55:00 | SPY | ETF | 387.8 | 388.15 | 387.73 | 387.84 | 228929.0 |
| 2022-05-19 07:00:00 | SPY | ETF | 388.08 | 388.34 | 387.7 | 387.8 | 63164.0 |
| 2022-05-19 07:05:00 | SPY | ETF | 387.73 | 387.73 | 387.22 | 387.4 | 25829.0 |
| 2022-05-19 07:10:00 | SPY | ETF | 387.35 | 387.62 | 387.09 | 387.62 | 18307.0 |
| 2022-05-19 07:15:00 | SPY | ETF | 387.6 | 387.75 | 387.44 | 387.56 | 132007.0 |
| 2022-05-19 07:20:00 | SPY | ETF | 387.58 | 388.55 | 387.5 | 388.4 | 59048.0 |
| 2022-05-19 07:25:00 | SPY | ETF | 388.39 | 389.36 | 388.31 | 389.1 | 87856.0 |
| 2022-05-19 07:30:00 | SPY | ETF | 389.07 | 389.07 | 388.36 | 388.36 | 26802.0 |
| 2022-05-19 07:35:00 | SPY | ETF | 388.45 | 388.73 | 388.41 | 388.57 | 63735.0 |
| 2022-05-19 07:40:00 | SPY | ETF | 388.54 | 389.31 | 388.4 | 389.03 | 121961.0 |
| 2022-05-19 07:45:00 | SPY | ETF | 389.07 | 389.07 | 388.32 | 388.5 | 34966.0 |
| 2022-05-19 07:50:00 | SPY | ETF | 388.41 | 388.62 | 388.3 | 388.62 | 23623.0 |
| 2022-05-19 07:55:00 | SPY | ETF | 388.67 | 389.56 | 388.67 | 389.05 | 88867.0 |
| 2022-05-19 08:00:00 | SPY | ETF | 388.0009 | 392.6 | 385.4204 | 388.68 | 95784.0 |
| 2022-05-19 08:05:00 | SPY | ETF | 388.68 | 388.84 | 388.59 | 388.63 | 21384.0 |
> showing 50 of 101,650 rows — these rows as CSV