PREVIEW / etf_5min / 2022-05-16
file: by_date/etf_5min/2022/2022-05-16.parquet size: 2.0 MB rows: 96,104
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-16 04:00:00 | SPY | ETF | 399.98 | 401.6 | 399.34 | 399.6 | 21481.0 |
| 2022-05-16 04:05:00 | SPY | ETF | 399.71 | 399.76 | 399.53 | 399.71 | 3150.0 |
| 2022-05-16 04:10:00 | SPY | ETF | 399.9 | 400.05 | 399.85 | 400.05 | 3947.0 |
| 2022-05-16 04:15:00 | SPY | ETF | 400.0 | 400.59 | 400.0 | 400.45 | 1943.0 |
| 2022-05-16 04:20:00 | SPY | ETF | 400.53 | 400.66 | 400.51 | 400.6 | 1300.0 |
| 2022-05-16 04:25:00 | SPY | ETF | 400.51 | 400.51 | 400.28 | 400.3 | 1148.0 |
| 2022-05-16 04:30:00 | SPY | ETF | 400.2 | 400.61 | 400.2 | 400.6 | 4432.0 |
| 2022-05-16 04:35:00 | SPY | ETF | 400.45 | 400.45 | 400.45 | 400.45 | 300.0 |
| 2022-05-16 04:40:00 | SPY | ETF | 400.19 | 400.31 | 399.98 | 400.31 | 970.0 |
| 2022-05-16 04:45:00 | SPY | ETF | 400.35 | 400.48 | 400.35 | 400.48 | 799.0 |
| 2022-05-16 04:50:00 | SPY | ETF | 400.42 | 400.8 | 400.42 | 400.8 | 3399.0 |
| 2022-05-16 04:55:00 | SPY | ETF | 400.85 | 401.13 | 400.85 | 401.13 | 1987.0 |
| 2022-05-16 05:00:00 | SPY | ETF | 401.08 | 401.21 | 401.08 | 401.2 | 5209.0 |
| 2022-05-16 05:05:00 | SPY | ETF | 401.17 | 401.17 | 400.83 | 400.9 | 19098.0 |
| 2022-05-16 05:10:00 | SPY | ETF | 400.88 | 401.03 | 400.88 | 400.93 | 469.0 |
| 2022-05-16 05:15:00 | SPY | ETF | 400.88 | 400.95 | 400.8 | 400.95 | 11495.0 |
| 2022-05-16 05:20:00 | SPY | ETF | 400.8 | 400.85 | 400.5 | 400.5 | 6624.0 |
| 2022-05-16 05:25:00 | SPY | ETF | 400.52 | 400.55 | 400.28 | 400.28 | 3558.0 |
| 2022-05-16 05:30:00 | SPY | ETF | 400.24 | 400.24 | 400.24 | 400.24 | 108.0 |
| 2022-05-16 05:35:00 | SPY | ETF | 400.35 | 400.35 | 400.19 | 400.19 | 420.0 |
| 2022-05-16 05:40:00 | SPY | ETF | 400.1 | 400.14 | 400.02 | 400.14 | 950.0 |
| 2022-05-16 05:45:00 | SPY | ETF | 400.19 | 400.25 | 400.19 | 400.25 | 500.0 |
| 2022-05-16 05:50:00 | SPY | ETF | 400.3 | 400.3 | 400.04 | 400.12 | 1067.0 |
| 2022-05-16 05:55:00 | SPY | ETF | 400.06 | 400.06 | 399.7 | 399.72 | 4020.0 |
| 2022-05-16 06:00:00 | SPY | ETF | 399.8 | 400.14 | 399.8 | 400.14 | 1346.0 |
| 2022-05-16 06:05:00 | SPY | ETF | 400.01 | 400.02 | 399.93 | 399.93 | 800.0 |
| 2022-05-16 06:10:00 | SPY | ETF | 400.0 | 400.26 | 400.0 | 400.2 | 2439.0 |
| 2022-05-16 06:15:00 | SPY | ETF | 400.3 | 400.3 | 400.2 | 400.28 | 1010.0 |
| 2022-05-16 06:20:00 | SPY | ETF | 400.02 | 400.02 | 399.95 | 400.01 | 2227.0 |
| 2022-05-16 06:25:00 | SPY | ETF | 400.04 | 400.5 | 400.04 | 400.4 | 14592.0 |
| 2022-05-16 06:30:00 | SPY | ETF | 400.09 | 400.14 | 400.07 | 400.14 | 1100.0 |
| 2022-05-16 06:35:00 | SPY | ETF | 400.29 | 400.39 | 400.25 | 400.39 | 2188.0 |
| 2022-05-16 06:40:00 | SPY | ETF | 400.51 | 400.57 | 400.34 | 400.34 | 510.0 |
| 2022-05-16 06:45:00 | SPY | ETF | 400.37 | 400.5 | 400.36 | 400.4 | 10953.0 |
| 2022-05-16 06:50:00 | SPY | ETF | 400.31 | 400.37 | 400.1 | 400.14 | 16048.0 |
| 2022-05-16 06:55:00 | SPY | ETF | 400.19 | 400.3 | 400.14 | 400.23 | 1404.0 |
| 2022-05-16 07:00:00 | SPY | ETF | 400.19 | 400.37 | 400.16 | 400.181 | 5975.0 |
| 2022-05-16 07:05:00 | SPY | ETF | 400.2 | 400.73 | 400.2 | 400.65 | 10598.0 |
| 2022-05-16 07:10:00 | SPY | ETF | 400.58 | 400.62 | 400.53 | 400.58 | 4659.0 |
| 2022-05-16 07:15:00 | SPY | ETF | 400.55 | 400.61 | 400.44 | 400.48 | 24299.0 |
| 2022-05-16 07:20:00 | SPY | ETF | 400.55 | 400.73 | 400.31 | 400.7 | 23207.0 |
| 2022-05-16 07:25:00 | SPY | ETF | 400.62 | 400.66 | 400.16 | 400.25 | 13898.0 |
| 2022-05-16 07:30:00 | SPY | ETF | 400.28 | 400.3 | 400.01 | 400.02 | 28275.0 |
| 2022-05-16 07:35:00 | SPY | ETF | 400.02 | 400.17 | 400.0 | 400.13 | 7527.0 |
| 2022-05-16 07:40:00 | SPY | ETF | 400.1 | 400.39 | 400.1 | 400.35 | 5900.0 |
| 2022-05-16 07:45:00 | SPY | ETF | 400.35 | 400.5 | 400.29 | 400.5 | 20150.0 |
| 2022-05-16 07:50:00 | SPY | ETF | 400.3 | 400.75 | 400.3 | 400.62 | 6721.0 |
| 2022-05-16 07:55:00 | SPY | ETF | 400.57 | 400.62 | 400.37 | 400.52 | 22190.0 |
| 2022-05-16 08:00:00 | SPY | ETF | 400.25 | 400.97 | 398.75 | 400.46 | 59486.0 |
| 2022-05-16 08:05:00 | SPY | ETF | 400.5 | 400.51 | 398.41 | 400.43 | 32057.0 |
> showing 50 of 96,104 rows — these rows as CSV