PREVIEW / etf_5min / 2018-12-17
file: by_date/etf_5min/2018/2018-12-17.parquet size: 1.7 MB rows: 70,344
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-17 04:00:00 | SPY | ETF | 260.99 | 260.99 | 260.81 | 260.85 | 3276.0 |
| 2018-12-17 04:05:00 | SPY | ETF | 260.85 | 260.9 | 260.81 | 260.86 | 3321.0 |
| 2018-12-17 04:10:00 | SPY | ETF | 260.86 | 260.92 | 260.86 | 260.9 | 2500.0 |
| 2018-12-17 04:15:00 | SPY | ETF | 260.87 | 260.96 | 260.8 | 260.95 | 3000.0 |
| 2018-12-17 04:20:00 | SPY | ETF | 260.9 | 260.9 | 260.74 | 260.74 | 2940.0 |
| 2018-12-17 04:25:00 | SPY | ETF | 260.66 | 260.69 | 260.64 | 260.69 | 1901.0 |
| 2018-12-17 04:30:00 | SPY | ETF | 260.75 | 260.75 | 260.67 | 260.67 | 680.0 |
| 2018-12-17 04:40:00 | SPY | ETF | 260.62 | 260.62 | 260.57 | 260.57 | 846.0 |
| 2018-12-17 04:45:00 | SPY | ETF | 260.64 | 260.69 | 260.63 | 260.69 | 1200.0 |
| 2018-12-17 04:50:00 | SPY | ETF | 260.77 | 260.78 | 260.74 | 260.78 | 676.0 |
| 2018-12-17 04:55:00 | SPY | ETF | 260.7 | 260.78 | 260.7 | 260.78 | 801.0 |
| 2018-12-17 05:00:00 | SPY | ETF | 260.82 | 261.0 | 260.82 | 260.99 | 3112.0 |
| 2018-12-17 05:05:00 | SPY | ETF | 260.92 | 261.0 | 260.92 | 261.0 | 1196.0 |
| 2018-12-17 05:10:00 | SPY | ETF | 261.0 | 261.03 | 261.0 | 261.03 | 1252.0 |
| 2018-12-17 05:15:00 | SPY | ETF | 261.02 | 261.11 | 260.94 | 261.11 | 1854.0 |
| 2018-12-17 05:20:00 | SPY | ETF | 261.05 | 261.2 | 261.05 | 261.2 | 3582.0 |
| 2018-12-17 05:25:00 | SPY | ETF | 261.23 | 261.25 | 261.23 | 261.24 | 4370.0 |
| 2018-12-17 05:30:00 | SPY | ETF | 261.28 | 261.28 | 261.22 | 261.22 | 877.0 |
| 2018-12-17 05:35:00 | SPY | ETF | 261.18 | 261.18 | 261.05 | 261.11 | 1794.0 |
| 2018-12-17 05:40:00 | SPY | ETF | 261.05 | 261.05 | 260.96 | 260.96 | 3345.0 |
| 2018-12-17 05:45:00 | SPY | ETF | 261.0 | 261.03 | 260.92 | 260.96 | 5355.0 |
| 2018-12-17 05:50:00 | SPY | ETF | 260.92 | 260.92 | 260.86 | 260.9 | 3438.0 |
| 2018-12-17 05:55:00 | SPY | ETF | 260.82 | 260.82 | 260.71 | 260.72 | 7036.0 |
| 2018-12-17 06:00:00 | SPY | ETF | 260.73 | 260.76 | 260.67 | 260.67 | 3348.0 |
| 2018-12-17 06:05:00 | SPY | ETF | 260.65 | 260.65 | 260.65 | 260.65 | 650.0 |
| 2018-12-17 06:10:00 | SPY | ETF | 260.7 | 260.78 | 260.65 | 260.65 | 1400.0 |
| 2018-12-17 06:15:00 | SPY | ETF | 260.6 | 260.6 | 260.46 | 260.47 | 4498.0 |
| 2018-12-17 06:20:00 | SPY | ETF | 260.51 | 260.53 | 260.47 | 260.47 | 5025.0 |
| 2018-12-17 06:25:00 | SPY | ETF | 260.45 | 260.45 | 260.33 | 260.37 | 4439.0 |
| 2018-12-17 06:30:00 | SPY | ETF | 260.31 | 260.44 | 260.31 | 260.44 | 5085.0 |
| 2018-12-17 06:35:00 | SPY | ETF | 260.46 | 260.54 | 260.32 | 260.32 | 5050.0 |
| 2018-12-17 06:40:00 | SPY | ETF | 260.3 | 260.31 | 260.19 | 260.19 | 6249.0 |
| 2018-12-17 06:45:00 | SPY | ETF | 260.2 | 260.29 | 260.17 | 260.29 | 9057.0 |
| 2018-12-17 06:50:00 | SPY | ETF | 260.31 | 260.34 | 260.28 | 260.34 | 2858.0 |
| 2018-12-17 06:55:00 | SPY | ETF | 260.28 | 260.46 | 260.28 | 260.44 | 4200.0 |
| 2018-12-17 07:00:00 | SPY | ETF | 260.4 | 260.53 | 260.35 | 260.47 | 16110.0 |
| 2018-12-17 07:05:00 | SPY | ETF | 260.45 | 260.53 | 260.42 | 260.53 | 6691.0 |
| 2018-12-17 07:10:00 | SPY | ETF | 260.47 | 260.53 | 260.45 | 260.45 | 5288.0 |
| 2018-12-17 07:15:00 | SPY | ETF | 260.49 | 260.58 | 260.41 | 260.41 | 21012.0 |
| 2018-12-17 07:20:00 | SPY | ETF | 260.45 | 260.45 | 260.13 | 260.13 | 18902.0 |
| 2018-12-17 07:25:00 | SPY | ETF | 260.2 | 260.37 | 260.2 | 260.35 | 8932.0 |
| 2018-12-17 07:30:00 | SPY | ETF | 260.37 | 260.38 | 260.3 | 260.3 | 7437.0 |
| 2018-12-17 07:35:00 | SPY | ETF | 260.3 | 260.35 | 260.21 | 260.33 | 8788.0 |
| 2018-12-17 07:40:00 | SPY | ETF | 260.34 | 260.46 | 260.26 | 260.26 | 30338.0 |
| 2018-12-17 07:45:00 | SPY | ETF | 260.25 | 260.25 | 260.1 | 260.21 | 8989.0 |
| 2018-12-17 07:50:00 | SPY | ETF | 260.29 | 260.31 | 260.27 | 260.28 | 14839.0 |
| 2018-12-17 07:55:00 | SPY | ETF | 260.25 | 260.25 | 259.88 | 259.98 | 49113.0 |
| 2018-12-17 08:00:00 | SPY | ETF | 260.0 | 261.58 | 259.9 | 260.03 | 32360.0 |
| 2018-12-17 08:05:00 | SPY | ETF | 260.02 | 260.13 | 259.85 | 259.87 | 25119.0 |
| 2018-12-17 08:10:00 | SPY | ETF | 259.87 | 259.97 | 259.85 | 259.96 | 19970.0 |
> showing 50 of 70,344 rows — these rows as CSV