PREVIEW / etf_5min / 2020-05-27
file: by_date/etf_5min/2020/2020-05-27.parquet size: 1.7 MB rows: 77,869
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-27 04:00:00 | SPY | ETF | 301.86 | 302.09 | 301.86 | 302.09 | 13788.0 |
| 2020-05-27 04:05:00 | SPY | ETF | 302.13 | 302.17 | 302.06 | 302.1 | 4615.0 |
| 2020-05-27 04:10:00 | SPY | ETF | 301.99 | 302.16 | 301.98 | 302.12 | 10346.0 |
| 2020-05-27 04:15:00 | SPY | ETF | 302.02 | 302.24 | 302.02 | 302.19 | 5170.0 |
| 2020-05-27 04:20:00 | SPY | ETF | 302.12 | 302.24 | 302.12 | 302.17 | 3095.0 |
| 2020-05-27 04:25:00 | SPY | ETF | 302.1 | 302.14 | 301.79 | 301.9 | 6599.0 |
| 2020-05-27 04:30:00 | SPY | ETF | 301.99 | 302.2 | 301.99 | 302.07 | 4934.0 |
| 2020-05-27 04:35:00 | SPY | ETF | 302.2 | 302.6 | 302.2 | 302.52 | 20468.0 |
| 2020-05-27 04:40:00 | SPY | ETF | 302.42 | 302.59 | 302.42 | 302.54 | 4021.0 |
| 2020-05-27 04:45:00 | SPY | ETF | 302.53 | 302.67 | 302.5 | 302.67 | 18926.0 |
| 2020-05-27 04:50:00 | SPY | ETF | 302.69 | 302.69 | 302.57 | 302.59 | 3191.0 |
| 2020-05-27 04:55:00 | SPY | ETF | 302.6 | 302.71 | 302.6 | 302.64 | 4335.0 |
| 2020-05-27 05:00:00 | SPY | ETF | 302.71 | 302.71 | 302.65 | 302.71 | 8358.0 |
| 2020-05-27 05:05:00 | SPY | ETF | 302.64 | 302.64 | 302.42 | 302.47 | 5422.0 |
| 2020-05-27 05:10:00 | SPY | ETF | 302.64 | 302.7 | 302.6 | 302.7 | 2965.0 |
| 2020-05-27 05:15:00 | SPY | ETF | 302.74 | 303.04 | 302.65 | 303.0 | 5473.0 |
| 2020-05-27 05:20:00 | SPY | ETF | 302.95 | 303.22 | 302.95 | 303.16 | 12948.0 |
| 2020-05-27 05:25:00 | SPY | ETF | 303.21 | 303.78 | 303.19 | 303.46 | 24514.0 |
| 2020-05-27 05:30:00 | SPY | ETF | 303.44 | 303.49 | 303.34 | 303.39 | 15095.0 |
| 2020-05-27 05:35:00 | SPY | ETF | 303.3 | 303.54 | 303.21 | 303.54 | 10418.0 |
| 2020-05-27 05:40:00 | SPY | ETF | 303.51 | 303.6 | 303.39 | 303.44 | 18691.0 |
| 2020-05-27 05:45:00 | SPY | ETF | 303.6 | 303.6 | 303.52 | 303.52 | 3174.0 |
| 2020-05-27 05:50:00 | SPY | ETF | 303.53 | 303.64 | 303.5 | 303.64 | 8420.0 |
| 2020-05-27 05:55:00 | SPY | ETF | 303.67 | 303.86 | 303.67 | 303.69 | 9410.0 |
| 2020-05-27 06:00:00 | SPY | ETF | 303.68 | 303.75 | 303.56 | 303.56 | 12774.0 |
| 2020-05-27 06:05:00 | SPY | ETF | 303.54 | 303.6 | 303.31 | 303.34 | 21484.0 |
| 2020-05-27 06:10:00 | SPY | ETF | 303.36 | 303.4 | 303.3 | 303.34 | 7510.0 |
| 2020-05-27 06:15:00 | SPY | ETF | 303.48 | 303.57 | 303.21 | 303.23 | 14870.0 |
| 2020-05-27 06:20:00 | SPY | ETF | 303.3 | 303.34 | 303.19 | 303.34 | 4770.0 |
| 2020-05-27 06:25:00 | SPY | ETF | 303.34 | 303.37 | 303.24 | 303.37 | 10124.0 |
| 2020-05-27 06:30:00 | SPY | ETF | 303.39 | 303.47 | 303.29 | 303.47 | 6277.0 |
| 2020-05-27 06:35:00 | SPY | ETF | 303.47 | 303.47 | 303.33 | 303.34 | 2094.0 |
| 2020-05-27 06:40:00 | SPY | ETF | 303.26 | 303.4 | 303.11 | 303.4 | 3327.0 |
| 2020-05-27 06:45:00 | SPY | ETF | 303.39 | 303.39 | 303.21 | 303.21 | 3615.0 |
| 2020-05-27 06:50:00 | SPY | ETF | 303.16 | 303.25 | 303.01 | 303.12 | 14212.0 |
| 2020-05-27 06:55:00 | SPY | ETF | 303.19 | 303.3 | 303.05 | 303.3 | 10832.0 |
| 2020-05-27 07:00:00 | SPY | ETF | 303.26 | 303.34 | 303.05 | 303.34 | 61209.0 |
| 2020-05-27 07:05:00 | SPY | ETF | 303.35 | 303.49 | 303.3 | 303.39 | 65520.0 |
| 2020-05-27 07:10:00 | SPY | ETF | 303.41 | 303.44 | 302.98 | 303.0 | 40748.0 |
| 2020-05-27 07:15:00 | SPY | ETF | 303.0 | 303.13 | 302.98 | 303.05 | 26875.0 |
| 2020-05-27 07:20:00 | SPY | ETF | 303.03 | 303.34 | 303.02 | 303.24 | 51416.0 |
| 2020-05-27 07:25:00 | SPY | ETF | 303.26 | 303.3 | 303.09 | 303.19 | 25570.0 |
| 2020-05-27 07:30:00 | SPY | ETF | 303.19 | 303.2 | 302.9 | 303.0 | 60473.0 |
| 2020-05-27 07:35:00 | SPY | ETF | 303.1 | 303.2 | 303.06 | 303.09 | 55601.0 |
| 2020-05-27 07:40:00 | SPY | ETF | 303.1 | 303.19 | 302.75 | 302.85 | 51691.0 |
| 2020-05-27 07:45:00 | SPY | ETF | 302.9 | 302.95 | 302.78 | 302.83 | 35506.0 |
| 2020-05-27 07:50:00 | SPY | ETF | 302.82 | 302.96 | 302.75 | 302.79 | 29739.0 |
| 2020-05-27 07:55:00 | SPY | ETF | 302.78 | 302.81 | 302.71 | 302.8 | 50325.0 |
| 2020-05-27 08:00:00 | SPY | ETF | 302.7201 | 303.5 | 301.19 | 302.72 | 131807.0 |
| 2020-05-27 08:05:00 | SPY | ETF | 300.0 | 302.91 | 300.0 | 302.9 | 161521.0 |
> showing 50 of 77,869 rows — these rows as CSV