PREVIEW / etf_5min / 2018-12-20
file: by_date/etf_5min/2018/2018-12-20.parquet size: 1.8 MB rows: 76,685
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 |
|---|---|---|---|---|---|---|---|
| 2018-12-20 04:00:00 | SPY | ETF | 250.0 | 250.0 | 249.48 | 249.57 | 4902.0 |
| 2018-12-20 04:05:00 | SPY | ETF | 249.7 | 249.7 | 249.54 | 249.69 | 8937.0 |
| 2018-12-20 04:10:00 | SPY | ETF | 249.79 | 249.98 | 249.79 | 249.98 | 2521.0 |
| 2018-12-20 04:15:00 | SPY | ETF | 250.05 | 250.07 | 250.0 | 250.02 | 2059.0 |
| 2018-12-20 04:20:00 | SPY | ETF | 250.08 | 250.25 | 250.08 | 250.25 | 3106.0 |
| 2018-12-20 04:25:00 | SPY | ETF | 250.3 | 250.37 | 250.28 | 250.28 | 10970.0 |
| 2018-12-20 04:30:00 | SPY | ETF | 250.23 | 250.25 | 250.23 | 250.25 | 338.0 |
| 2018-12-20 04:35:00 | SPY | ETF | 250.35 | 250.55 | 250.35 | 250.55 | 2912.0 |
| 2018-12-20 04:40:00 | SPY | ETF | 250.48 | 250.6 | 250.4 | 250.56 | 10278.0 |
| 2018-12-20 04:45:00 | SPY | ETF | 250.56 | 250.56 | 250.35 | 250.35 | 4776.0 |
| 2018-12-20 04:50:00 | SPY | ETF | 250.3 | 250.34 | 250.25 | 250.34 | 588.0 |
| 2018-12-20 04:55:00 | SPY | ETF | 250.43 | 250.58 | 250.43 | 250.58 | 2891.0 |
| 2018-12-20 05:00:00 | SPY | ETF | 250.64 | 250.64 | 250.4 | 250.4 | 450.0 |
| 2018-12-20 05:05:00 | SPY | ETF | 250.4 | 250.45 | 250.35 | 250.35 | 2900.0 |
| 2018-12-20 05:10:00 | SPY | ETF | 250.55 | 250.8 | 250.5 | 250.8 | 9675.0 |
| 2018-12-20 05:15:00 | SPY | ETF | 250.8 | 250.88 | 250.8 | 250.85 | 5075.0 |
| 2018-12-20 05:20:00 | SPY | ETF | 250.83 | 251.0 | 250.83 | 250.93 | 4776.0 |
| 2018-12-20 05:25:00 | SPY | ETF | 250.93 | 251.01 | 250.77 | 250.77 | 17376.0 |
| 2018-12-20 05:30:00 | SPY | ETF | 250.97 | 250.97 | 250.78 | 250.78 | 6610.0 |
| 2018-12-20 05:35:00 | SPY | ETF | 250.76 | 250.86 | 250.59 | 250.59 | 4360.0 |
| 2018-12-20 05:40:00 | SPY | ETF | 250.54 | 250.54 | 250.34 | 250.39 | 7463.0 |
| 2018-12-20 05:45:00 | SPY | ETF | 250.39 | 250.53 | 250.34 | 250.34 | 2800.0 |
| 2018-12-20 05:50:00 | SPY | ETF | 250.35 | 250.44 | 250.19 | 250.44 | 5976.0 |
| 2018-12-20 05:55:00 | SPY | ETF | 250.48 | 250.59 | 250.46 | 250.59 | 4875.0 |
| 2018-12-20 06:00:00 | SPY | ETF | 250.68 | 250.76 | 250.68 | 250.76 | 1175.0 |
| 2018-12-20 06:05:00 | SPY | ETF | 250.82 | 250.88 | 250.79 | 250.88 | 2850.0 |
| 2018-12-20 06:10:00 | SPY | ETF | 250.88 | 251.02 | 250.88 | 251.02 | 700.0 |
| 2018-12-20 06:15:00 | SPY | ETF | 250.94 | 250.99 | 250.94 | 250.99 | 1205.0 |
| 2018-12-20 06:20:00 | SPY | ETF | 250.99 | 251.28 | 250.99 | 251.2 | 6190.0 |
| 2018-12-20 06:25:00 | SPY | ETF | 251.28 | 251.28 | 251.16 | 251.28 | 7040.0 |
| 2018-12-20 06:30:00 | SPY | ETF | 251.35 | 251.45 | 251.24 | 251.45 | 12541.0 |
| 2018-12-20 06:35:00 | SPY | ETF | 251.42 | 251.48 | 251.33 | 251.48 | 10433.0 |
| 2018-12-20 06:40:00 | SPY | ETF | 251.48 | 251.67 | 251.48 | 251.63 | 20173.0 |
| 2018-12-20 06:45:00 | SPY | ETF | 251.48 | 251.48 | 251.38 | 251.38 | 4875.0 |
| 2018-12-20 06:50:00 | SPY | ETF | 251.36 | 251.36 | 251.31 | 251.32 | 3954.0 |
| 2018-12-20 06:55:00 | SPY | ETF | 251.31 | 251.6 | 251.25 | 251.6 | 3796.0 |
| 2018-12-20 07:00:00 | SPY | ETF | 251.57 | 252.26 | 251.57 | 251.8 | 25707.0 |
| 2018-12-20 07:05:00 | SPY | ETF | 251.75 | 251.75 | 251.51 | 251.64 | 13631.0 |
| 2018-12-20 07:10:00 | SPY | ETF | 251.7 | 251.88 | 251.69 | 251.74 | 39372.0 |
| 2018-12-20 07:15:00 | SPY | ETF | 251.76 | 251.76 | 251.46 | 251.46 | 20272.0 |
| 2018-12-20 07:20:00 | SPY | ETF | 251.46 | 251.5 | 251.32 | 251.37 | 16831.0 |
| 2018-12-20 07:25:00 | SPY | ETF | 251.33 | 251.4 | 251.26 | 251.4 | 38782.0 |
| 2018-12-20 07:30:00 | SPY | ETF | 251.35 | 251.42 | 251.25 | 251.28 | 32536.0 |
| 2018-12-20 07:35:00 | SPY | ETF | 251.27 | 251.4 | 251.15 | 251.31 | 25594.0 |
| 2018-12-20 07:40:00 | SPY | ETF | 251.38 | 251.49 | 251.36 | 251.36 | 26988.0 |
| 2018-12-20 07:45:00 | SPY | ETF | 251.32 | 251.81 | 251.28 | 251.67 | 65213.0 |
| 2018-12-20 07:50:00 | SPY | ETF | 251.63 | 251.85 | 251.63 | 251.85 | 87319.0 |
| 2018-12-20 07:55:00 | SPY | ETF | 251.85 | 251.85 | 251.61 | 251.61 | 31089.0 |
| 2018-12-20 08:00:00 | SPY | ETF | 251.6 | 251.96 | 248.42 | 251.37 | 79166.0 |
| 2018-12-20 08:05:00 | SPY | ETF | 251.35 | 251.35 | 249.5 | 251.04 | 317851.0 |
> showing 50 of 76,685 rows — these rows as CSV