PREVIEW / etf_5min / 2020-05-22
file: by_date/etf_5min/2020/2020-05-22.parquet size: 1.5 MB rows: 70,239
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 |
|---|---|---|---|---|---|---|---|
| 2020-05-22 04:00:00 | SPY | ETF | 291.45 | 291.45 | 291.2 | 291.42 | 22350.0 |
| 2020-05-22 04:05:00 | SPY | ETF | 291.4 | 291.41 | 291.24 | 291.33 | 6063.0 |
| 2020-05-22 04:10:00 | SPY | ETF | 291.4 | 291.61 | 291.31 | 291.61 | 8627.0 |
| 2020-05-22 04:15:00 | SPY | ETF | 291.66 | 291.84 | 291.64 | 291.7 | 9076.0 |
| 2020-05-22 04:20:00 | SPY | ETF | 291.74 | 291.78 | 291.6 | 291.6 | 4771.0 |
| 2020-05-22 04:25:00 | SPY | ETF | 291.64 | 291.64 | 291.5 | 291.52 | 903.0 |
| 2020-05-22 04:30:00 | SPY | ETF | 291.6 | 292.22 | 291.6 | 292.11 | 9208.0 |
| 2020-05-22 04:35:00 | SPY | ETF | 292.1 | 292.2 | 291.97 | 292.04 | 3829.0 |
| 2020-05-22 04:40:00 | SPY | ETF | 292.01 | 292.39 | 292.0 | 292.31 | 4154.0 |
| 2020-05-22 04:45:00 | SPY | ETF | 292.3 | 292.36 | 292.27 | 292.27 | 2687.0 |
| 2020-05-22 04:50:00 | SPY | ETF | 292.2 | 292.38 | 292.17 | 292.38 | 4348.0 |
| 2020-05-22 04:55:00 | SPY | ETF | 292.37 | 292.58 | 292.37 | 292.52 | 4093.0 |
| 2020-05-22 05:00:00 | SPY | ETF | 292.62 | 292.69 | 292.62 | 292.67 | 761.0 |
| 2020-05-22 05:05:00 | SPY | ETF | 292.5 | 292.64 | 292.5 | 292.56 | 1306.0 |
| 2020-05-22 05:10:00 | SPY | ETF | 292.57 | 292.73 | 292.57 | 292.72 | 9312.0 |
| 2020-05-22 05:15:00 | SPY | ETF | 292.73 | 293.0 | 292.73 | 293.0 | 2475.0 |
| 2020-05-22 05:20:00 | SPY | ETF | 293.04 | 293.04 | 292.85 | 292.99 | 1781.0 |
| 2020-05-22 05:25:00 | SPY | ETF | 292.81 | 292.9 | 292.72 | 292.79 | 3143.0 |
| 2020-05-22 05:30:00 | SPY | ETF | 292.87 | 292.87 | 292.58 | 292.58 | 3775.0 |
| 2020-05-22 05:35:00 | SPY | ETF | 292.64 | 292.67 | 292.54 | 292.66 | 5447.0 |
| 2020-05-22 05:40:00 | SPY | ETF | 292.56 | 292.75 | 292.56 | 292.6 | 5884.0 |
| 2020-05-22 05:45:00 | SPY | ETF | 292.56 | 292.61 | 292.5 | 292.61 | 26568.0 |
| 2020-05-22 05:50:00 | SPY | ETF | 292.61 | 292.61 | 292.33 | 292.35 | 13350.0 |
| 2020-05-22 05:55:00 | SPY | ETF | 292.28 | 292.42 | 292.28 | 292.33 | 15281.0 |
| 2020-05-22 06:00:00 | SPY | ETF | 292.38 | 292.73 | 292.37 | 292.71 | 7276.0 |
| 2020-05-22 06:05:00 | SPY | ETF | 292.73 | 292.98 | 292.73 | 292.85 | 16443.0 |
| 2020-05-22 06:10:00 | SPY | ETF | 292.86 | 293.12 | 292.86 | 293.12 | 59391.0 |
| 2020-05-22 06:15:00 | SPY | ETF | 293.2 | 293.25 | 293.04 | 293.04 | 3779.0 |
| 2020-05-22 06:20:00 | SPY | ETF | 293.05 | 293.13 | 293.0 | 293.04 | 7671.0 |
| 2020-05-22 06:25:00 | SPY | ETF | 293.02 | 293.12 | 292.93 | 293.02 | 10984.0 |
| 2020-05-22 06:30:00 | SPY | ETF | 292.98 | 293.16 | 292.98 | 293.1 | 11785.0 |
| 2020-05-22 06:35:00 | SPY | ETF | 293.01 | 293.15 | 292.94 | 293.15 | 23481.0 |
| 2020-05-22 06:40:00 | SPY | ETF | 293.21 | 293.21 | 293.0 | 293.03 | 2017.0 |
| 2020-05-22 06:45:00 | SPY | ETF | 293.05 | 293.19 | 293.0 | 293.19 | 15310.0 |
| 2020-05-22 06:50:00 | SPY | ETF | 293.17 | 293.17 | 292.85 | 292.85 | 6630.0 |
| 2020-05-22 06:55:00 | SPY | ETF | 292.88 | 293.04 | 292.84 | 293.04 | 7977.0 |
| 2020-05-22 07:00:00 | SPY | ETF | 293.03 | 293.18 | 293.01 | 293.05 | 26644.0 |
| 2020-05-22 07:05:00 | SPY | ETF | 293.08 | 293.59 | 293.08 | 293.57 | 142014.0 |
| 2020-05-22 07:10:00 | SPY | ETF | 293.5 | 293.71 | 293.5 | 293.5 | 47919.0 |
| 2020-05-22 07:15:00 | SPY | ETF | 293.51 | 293.55 | 293.34 | 293.34 | 21638.0 |
| 2020-05-22 07:20:00 | SPY | ETF | 293.36 | 293.5 | 293.3 | 293.35 | 21863.0 |
| 2020-05-22 07:25:00 | SPY | ETF | 293.32 | 293.43 | 293.21 | 293.25 | 16892.0 |
| 2020-05-22 07:30:00 | SPY | ETF | 293.23 | 293.4 | 293.2 | 293.2 | 16910.0 |
| 2020-05-22 07:35:00 | SPY | ETF | 293.18 | 293.31 | 293.15 | 293.24 | 17210.0 |
| 2020-05-22 07:40:00 | SPY | ETF | 293.28 | 293.63 | 293.28 | 293.55 | 32861.0 |
| 2020-05-22 07:45:00 | SPY | ETF | 293.6 | 294.29 | 293.56 | 294.24 | 87707.0 |
| 2020-05-22 07:50:00 | SPY | ETF | 294.23 | 294.64 | 294.18 | 294.4 | 153969.0 |
| 2020-05-22 07:55:00 | SPY | ETF | 294.38 | 294.64 | 294.34 | 294.45 | 68135.0 |
| 2020-05-22 08:00:00 | SPY | ETF | 294.5 | 294.87 | 291.0 | 294.61 | 199283.0 |
| 2020-05-22 08:05:00 | SPY | ETF | 294.62 | 294.67 | 294.43 | 294.5 | 64804.0 |
> showing 50 of 70,239 rows — these rows as CSV