PREVIEW / etf_5min / 2021-06-01
file: by_date/etf_5min/2021/2021-06-01.parquet size: 1.8 MB rows: 85,952
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 |
|---|---|---|---|---|---|---|---|
| 2021-06-01 04:00:00 | SPY | ETF | 421.48 | 421.7 | 421.48 | 421.66 | 10953.0 |
| 2021-06-01 04:05:00 | SPY | ETF | 421.6 | 421.6 | 421.48 | 421.48 | 300.0 |
| 2021-06-01 04:10:00 | SPY | ETF | 421.45 | 421.45 | 421.31 | 421.31 | 700.0 |
| 2021-06-01 04:15:00 | SPY | ETF | 421.34 | 421.36 | 421.34 | 421.36 | 200.0 |
| 2021-06-01 04:20:00 | SPY | ETF | 421.28 | 421.44 | 421.2 | 421.44 | 4714.0 |
| 2021-06-01 04:25:00 | SPY | ETF | 421.31 | 421.31 | 421.28 | 421.28 | 287.0 |
| 2021-06-01 04:30:00 | SPY | ETF | 421.24 | 421.24 | 421.23 | 421.23 | 200.0 |
| 2021-06-01 04:35:00 | SPY | ETF | 421.21 | 421.21 | 421.14 | 421.14 | 1100.0 |
| 2021-06-01 04:40:00 | SPY | ETF | 421.15 | 421.2 | 421.15 | 421.2 | 300.0 |
| 2021-06-01 04:45:00 | SPY | ETF | 421.25 | 421.25 | 421.25 | 421.25 | 100.0 |
| 2021-06-01 04:50:00 | SPY | ETF | 421.43 | 421.43 | 421.43 | 421.43 | 500.0 |
| 2021-06-01 04:55:00 | SPY | ETF | 421.49 | 421.7 | 421.49 | 421.63 | 7266.0 |
| 2021-06-01 05:00:00 | SPY | ETF | 421.65 | 421.65 | 421.63 | 421.65 | 2471.0 |
| 2021-06-01 05:05:00 | SPY | ETF | 421.6 | 421.61 | 421.55 | 421.6 | 1188.0 |
| 2021-06-01 05:10:00 | SPY | ETF | 421.55 | 421.55 | 421.55 | 421.55 | 300.0 |
| 2021-06-01 05:15:00 | SPY | ETF | 421.68 | 421.92 | 421.68 | 421.81 | 7016.0 |
| 2021-06-01 05:20:00 | SPY | ETF | 421.8 | 421.83 | 421.8 | 421.83 | 700.0 |
| 2021-06-01 05:25:00 | SPY | ETF | 421.73 | 421.75 | 421.73 | 421.75 | 2149.0 |
| 2021-06-01 05:30:00 | SPY | ETF | 421.75 | 421.87 | 421.74 | 421.87 | 6438.0 |
| 2021-06-01 05:35:00 | SPY | ETF | 421.81 | 421.81 | 421.81 | 421.81 | 100.0 |
| 2021-06-01 05:40:00 | SPY | ETF | 421.81 | 421.81 | 421.74 | 421.81 | 5158.0 |
| 2021-06-01 05:45:00 | SPY | ETF | 421.83 | 421.88 | 421.8 | 421.8 | 7476.0 |
| 2021-06-01 05:50:00 | SPY | ETF | 421.8 | 421.8 | 421.68 | 421.73 | 1498.0 |
| 2021-06-01 05:55:00 | SPY | ETF | 421.7 | 421.7 | 421.7 | 421.7 | 100.0 |
| 2021-06-01 06:00:00 | SPY | ETF | 421.73 | 421.77 | 421.73 | 421.77 | 498.0 |
| 2021-06-01 06:05:00 | SPY | ETF | 421.78 | 421.79 | 421.78 | 421.79 | 398.0 |
| 2021-06-01 06:10:00 | SPY | ETF | 421.88 | 421.88 | 421.79 | 421.79 | 988.0 |
| 2021-06-01 06:15:00 | SPY | ETF | 421.84 | 421.84 | 421.84 | 421.84 | 600.0 |
| 2021-06-01 06:20:00 | SPY | ETF | 421.88 | 421.91 | 421.88 | 421.91 | 798.0 |
| 2021-06-01 06:35:00 | SPY | ETF | 421.8 | 421.8 | 421.71 | 421.78 | 994.0 |
| 2021-06-01 06:40:00 | SPY | ETF | 421.8 | 421.85 | 421.8 | 421.82 | 29425.0 |
| 2021-06-01 06:45:00 | SPY | ETF | 421.81 | 421.82 | 421.79 | 421.79 | 20200.0 |
| 2021-06-01 06:50:00 | SPY | ETF | 421.86 | 421.86 | 421.81 | 421.81 | 2781.0 |
| 2021-06-01 06:55:00 | SPY | ETF | 421.82 | 421.87 | 421.82 | 421.87 | 200.0 |
| 2021-06-01 07:00:00 | SPY | ETF | 421.84 | 421.9 | 421.83 | 421.9 | 13088.0 |
| 2021-06-01 07:05:00 | SPY | ETF | 421.9 | 422.02 | 421.9 | 422.02 | 4062.0 |
| 2021-06-01 07:10:00 | SPY | ETF | 422.05 | 422.098 | 422.03 | 422.098 | 11799.0 |
| 2021-06-01 07:15:00 | SPY | ETF | 422.11 | 422.19 | 422.11 | 422.17 | 10152.0 |
| 2021-06-01 07:20:00 | SPY | ETF | 422.16 | 422.49 | 422.15 | 422.45 | 41832.0 |
| 2021-06-01 07:25:00 | SPY | ETF | 422.42 | 422.45 | 422.26 | 422.29 | 20313.0 |
| 2021-06-01 07:30:00 | SPY | ETF | 422.27 | 422.27 | 422.13 | 422.18 | 38675.0 |
| 2021-06-01 07:35:00 | SPY | ETF | 422.19 | 422.19 | 422.12 | 422.15 | 9359.0 |
| 2021-06-01 07:40:00 | SPY | ETF | 422.15 | 422.24 | 422.15 | 422.18 | 13149.0 |
| 2021-06-01 07:45:00 | SPY | ETF | 422.2 | 422.2 | 422.09 | 422.09 | 4884.0 |
| 2021-06-01 07:50:00 | SPY | ETF | 422.14 | 422.17 | 422.09 | 422.17 | 11548.0 |
| 2021-06-01 07:55:00 | SPY | ETF | 422.17 | 422.21 | 422.12 | 422.2 | 42147.0 |
| 2021-06-01 08:00:00 | SPY | ETF | 421.8999 | 422.49 | 419.6 | 419.6 | 51798.0 |
| 2021-06-01 08:05:00 | SPY | ETF | 422.24 | 422.26 | 422.16 | 422.25 | 12624.0 |
| 2021-06-01 08:10:00 | SPY | ETF | 422.23 | 422.24 | 422.14 | 422.17 | 28563.0 |
| 2021-06-01 08:15:00 | SPY | ETF | 422.15 | 422.24 | 422.11 | 422.22 | 10510.0 |
> showing 50 of 85,952 rows — these rows as CSV