PREVIEW / etf_5min / 2018-10-31
file: by_date/etf_5min/2018/2018-10-31.parquet size: 1.5 MB rows: 63,674
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-10-31 04:00:00 | SPY | ETF | 269.1 | 269.4 | 269.0 | 269.4 | 3388.0 |
| 2018-10-31 04:05:00 | SPY | ETF | 269.36 | 269.36 | 269.25 | 269.25 | 235.0 |
| 2018-10-31 04:10:00 | SPY | ETF | 269.32 | 269.32 | 269.19 | 269.19 | 300.0 |
| 2018-10-31 04:15:00 | SPY | ETF | 269.29 | 269.34 | 269.29 | 269.34 | 1100.0 |
| 2018-10-31 04:20:00 | SPY | ETF | 269.45 | 269.65 | 269.45 | 269.65 | 17722.0 |
| 2018-10-31 04:25:00 | SPY | ETF | 269.67 | 269.75 | 269.63 | 269.69 | 4241.0 |
| 2018-10-31 04:30:00 | SPY | ETF | 269.7 | 269.7 | 269.59 | 269.59 | 894.0 |
| 2018-10-31 04:35:00 | SPY | ETF | 269.72 | 269.82 | 269.7 | 269.75 | 4102.0 |
| 2018-10-31 04:40:00 | SPY | ETF | 269.79 | 269.94 | 269.79 | 269.86 | 10801.0 |
| 2018-10-31 04:45:00 | SPY | ETF | 269.87 | 269.9 | 269.78 | 269.78 | 7050.0 |
| 2018-10-31 04:50:00 | SPY | ETF | 269.77 | 269.85 | 269.76 | 269.76 | 2700.0 |
| 2018-10-31 04:55:00 | SPY | ETF | 269.81 | 269.87 | 269.81 | 269.86 | 1528.0 |
| 2018-10-31 05:00:00 | SPY | ETF | 269.89 | 269.89 | 269.87 | 269.89 | 4081.0 |
| 2018-10-31 05:05:00 | SPY | ETF | 269.81 | 269.81 | 269.65 | 269.68 | 9321.0 |
| 2018-10-31 05:10:00 | SPY | ETF | 269.65 | 269.68 | 269.61 | 269.61 | 9269.0 |
| 2018-10-31 05:15:00 | SPY | ETF | 269.62 | 269.62 | 269.62 | 269.62 | 231.0 |
| 2018-10-31 05:20:00 | SPY | ETF | 269.53 | 269.58 | 269.5 | 269.55 | 6869.0 |
| 2018-10-31 05:25:00 | SPY | ETF | 269.51 | 269.63 | 269.47 | 269.61 | 11758.0 |
| 2018-10-31 05:30:00 | SPY | ETF | 269.63 | 269.63 | 269.58 | 269.63 | 6125.0 |
| 2018-10-31 05:35:00 | SPY | ETF | 269.65 | 269.65 | 269.52 | 269.6 | 8370.0 |
| 2018-10-31 05:40:00 | SPY | ETF | 269.62 | 269.64 | 269.31 | 269.31 | 16504.0 |
| 2018-10-31 05:45:00 | SPY | ETF | 269.31 | 269.36 | 269.24 | 269.25 | 21912.0 |
| 2018-10-31 05:50:00 | SPY | ETF | 269.33 | 269.33 | 269.18 | 269.18 | 10069.0 |
| 2018-10-31 05:55:00 | SPY | ETF | 269.17 | 269.25 | 269.12 | 269.25 | 23195.0 |
| 2018-10-31 06:00:00 | SPY | ETF | 269.25 | 269.36 | 269.25 | 269.36 | 1367.0 |
| 2018-10-31 06:05:00 | SPY | ETF | 269.39 | 269.44 | 269.31 | 269.39 | 18837.0 |
| 2018-10-31 06:10:00 | SPY | ETF | 269.34 | 269.44 | 269.31 | 269.44 | 12899.0 |
| 2018-10-31 06:15:00 | SPY | ETF | 269.39 | 269.56 | 269.39 | 269.54 | 6089.0 |
| 2018-10-31 06:20:00 | SPY | ETF | 269.54 | 269.58 | 269.39 | 269.49 | 16850.0 |
| 2018-10-31 06:25:00 | SPY | ETF | 269.49 | 269.5 | 269.37 | 269.49 | 22879.0 |
| 2018-10-31 06:30:00 | SPY | ETF | 269.55 | 269.63 | 269.5 | 269.51 | 9769.0 |
| 2018-10-31 06:35:00 | SPY | ETF | 269.51 | 269.7 | 269.51 | 269.69 | 9069.0 |
| 2018-10-31 06:40:00 | SPY | ETF | 269.67 | 269.89 | 269.67 | 269.89 | 9005.0 |
| 2018-10-31 06:45:00 | SPY | ETF | 269.96 | 269.96 | 269.92 | 269.94 | 1250.0 |
| 2018-10-31 06:50:00 | SPY | ETF | 269.94 | 269.94 | 269.84 | 269.84 | 15057.0 |
| 2018-10-31 06:55:00 | SPY | ETF | 269.82 | 269.85 | 269.8 | 269.8 | 3324.0 |
| 2018-10-31 07:00:00 | SPY | ETF | 269.76 | 269.95 | 269.72 | 269.86 | 23889.0 |
| 2018-10-31 07:05:00 | SPY | ETF | 269.93 | 270.13 | 269.93 | 270.07 | 17862.0 |
| 2018-10-31 07:10:00 | SPY | ETF | 270.1 | 270.16 | 269.94 | 269.98 | 15166.0 |
| 2018-10-31 07:15:00 | SPY | ETF | 269.96 | 270.06 | 269.85 | 269.85 | 45801.0 |
| 2018-10-31 07:20:00 | SPY | ETF | 269.87 | 269.92 | 269.78 | 269.92 | 21688.0 |
| 2018-10-31 07:25:00 | SPY | ETF | 269.88 | 269.97 | 269.71 | 269.84 | 6966.0 |
| 2018-10-31 07:30:00 | SPY | ETF | 269.84 | 269.93 | 269.8 | 269.83 | 41926.0 |
| 2018-10-31 07:35:00 | SPY | ETF | 269.81 | 269.96 | 269.79 | 269.96 | 39680.0 |
| 2018-10-31 07:40:00 | SPY | ETF | 269.94 | 270.2 | 269.94 | 270.17 | 54506.0 |
| 2018-10-31 07:45:00 | SPY | ETF | 270.15 | 270.15 | 269.96 | 270.04 | 37091.0 |
| 2018-10-31 07:50:00 | SPY | ETF | 270.0 | 270.22 | 270.0 | 270.22 | 18262.0 |
| 2018-10-31 07:55:00 | SPY | ETF | 270.19 | 270.26 | 270.11 | 270.11 | 28354.0 |
| 2018-10-31 08:00:00 | SPY | ETF | 269.89 | 270.24 | 268.38 | 270.15 | 43584.0 |
| 2018-10-31 08:05:00 | SPY | ETF | 270.15 | 270.19 | 270.05 | 270.19 | 31819.0 |
> showing 50 of 63,674 rows — these rows as CSV