PREVIEW / etf_5min / 2016-02-29
file: by_date/etf_5min/2016/2016-02-29.parquet size: 1.1 MB rows: 49,261
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 |
|---|---|---|---|---|---|---|---|
| 2016-02-29 04:00:00 | SPY | ETF | 193.91 | 193.91 | 193.45 | 193.68 | 9117.0 |
| 2016-02-29 04:05:00 | SPY | ETF | 193.65 | 193.8 | 193.65 | 193.77 | 23865.0 |
| 2016-02-29 04:10:00 | SPY | ETF | 193.94 | 193.94 | 193.92 | 193.92 | 600.0 |
| 2016-02-29 04:15:00 | SPY | ETF | 193.77 | 193.82 | 193.77 | 193.79 | 950.0 |
| 2016-02-29 04:20:00 | SPY | ETF | 193.75 | 193.82 | 193.75 | 193.82 | 1850.0 |
| 2016-02-29 04:25:00 | SPY | ETF | 193.74 | 193.77 | 193.55 | 193.57 | 4880.0 |
| 2016-02-29 04:30:00 | SPY | ETF | 193.54 | 193.64 | 193.54 | 193.58 | 4000.0 |
| 2016-02-29 04:35:00 | SPY | ETF | 193.55 | 193.7 | 193.55 | 193.7 | 2825.0 |
| 2016-02-29 04:40:00 | SPY | ETF | 193.6 | 193.6 | 193.57 | 193.58 | 1609.0 |
| 2016-02-29 04:45:00 | SPY | ETF | 193.62 | 193.65 | 193.62 | 193.65 | 555.0 |
| 2016-02-29 04:50:00 | SPY | ETF | 193.64 | 193.7 | 193.6 | 193.7 | 3014.0 |
| 2016-02-29 04:55:00 | SPY | ETF | 193.7 | 193.72 | 193.53 | 193.6 | 4611.0 |
| 2016-02-29 05:00:00 | SPY | ETF | 193.75 | 194.55 | 193.75 | 194.4 | 29145.0 |
| 2016-02-29 05:05:00 | SPY | ETF | 194.48 | 194.64 | 194.43 | 194.43 | 6663.0 |
| 2016-02-29 05:10:00 | SPY | ETF | 194.36 | 194.4 | 194.2 | 194.27 | 2605.0 |
| 2016-02-29 05:15:00 | SPY | ETF | 194.32 | 194.35 | 194.28 | 194.32 | 1848.0 |
| 2016-02-29 05:20:00 | SPY | ETF | 194.3 | 194.38 | 194.18 | 194.28 | 3528.0 |
| 2016-02-29 05:25:00 | SPY | ETF | 194.17 | 194.21 | 194.1 | 194.1 | 2447.0 |
| 2016-02-29 05:30:00 | SPY | ETF | 194.13 | 194.13 | 193.95 | 194.1 | 5113.0 |
| 2016-02-29 05:35:00 | SPY | ETF | 194.13 | 194.13 | 193.95 | 194.05 | 2842.0 |
| 2016-02-29 05:40:00 | SPY | ETF | 194.12 | 194.21 | 193.96 | 193.96 | 2013.0 |
| 2016-02-29 05:45:00 | SPY | ETF | 194.12 | 194.12 | 194.12 | 194.12 | 103.0 |
| 2016-02-29 05:50:00 | SPY | ETF | 194.08 | 194.16 | 194.08 | 194.16 | 703.0 |
| 2016-02-29 05:55:00 | SPY | ETF | 194.0 | 194.0 | 193.97 | 193.97 | 1306.0 |
| 2016-02-29 06:00:00 | SPY | ETF | 193.97 | 194.14 | 193.97 | 194.05 | 11030.0 |
| 2016-02-29 06:05:00 | SPY | ETF | 194.05 | 194.05 | 193.93 | 193.93 | 1868.0 |
| 2016-02-29 06:10:00 | SPY | ETF | 193.93 | 193.93 | 193.78 | 193.9 | 11228.0 |
| 2016-02-29 06:15:00 | SPY | ETF | 193.9 | 194.13 | 193.9 | 194.13 | 9367.0 |
| 2016-02-29 06:20:00 | SPY | ETF | 194.0 | 194.1 | 194.0 | 194.02 | 913.0 |
| 2016-02-29 06:25:00 | SPY | ETF | 193.97 | 194.05 | 193.92 | 193.97 | 30610.0 |
| 2016-02-29 06:30:00 | SPY | ETF | 194.0 | 194.2 | 194.0 | 194.2 | 28891.0 |
| 2016-02-29 06:35:00 | SPY | ETF | 194.24 | 194.34 | 194.2 | 194.3 | 1812.0 |
| 2016-02-29 06:40:00 | SPY | ETF | 194.32 | 194.46 | 194.32 | 194.44 | 19875.0 |
| 2016-02-29 06:45:00 | SPY | ETF | 194.45 | 194.46 | 194.35 | 194.43 | 9335.0 |
| 2016-02-29 06:50:00 | SPY | ETF | 194.46 | 194.46 | 194.39 | 194.43 | 25207.0 |
| 2016-02-29 06:55:00 | SPY | ETF | 194.47 | 194.66 | 194.47 | 194.53 | 20408.0 |
| 2016-02-29 07:00:00 | SPY | ETF | 194.51 | 194.55 | 194.4 | 194.4 | 7669.0 |
| 2016-02-29 07:05:00 | SPY | ETF | 194.38 | 194.55 | 194.35 | 194.55 | 9483.0 |
| 2016-02-29 07:10:00 | SPY | ETF | 194.56 | 194.56 | 194.4 | 194.4 | 5623.0 |
| 2016-02-29 07:15:00 | SPY | ETF | 194.4 | 194.46 | 194.38 | 194.46 | 30325.0 |
| 2016-02-29 07:20:00 | SPY | ETF | 194.45 | 194.51 | 194.4 | 194.51 | 6312.0 |
| 2016-02-29 07:25:00 | SPY | ETF | 194.51 | 194.64 | 194.45 | 194.64 | 8346.0 |
| 2016-02-29 07:30:00 | SPY | ETF | 194.62 | 194.83 | 194.56 | 194.8 | 18940.0 |
| 2016-02-29 07:35:00 | SPY | ETF | 194.8 | 194.91 | 194.73 | 194.73 | 18707.0 |
| 2016-02-29 07:40:00 | SPY | ETF | 194.7 | 194.75 | 194.7 | 194.7 | 5736.0 |
| 2016-02-29 07:45:00 | SPY | ETF | 194.7 | 194.85 | 194.69 | 194.74 | 37804.0 |
| 2016-02-29 07:50:00 | SPY | ETF | 194.73 | 194.73 | 194.53 | 194.62 | 38200.0 |
| 2016-02-29 07:55:00 | SPY | ETF | 194.63 | 194.63 | 194.5 | 194.58 | 6765.0 |
| 2016-02-29 08:00:00 | SPY | ETF | 194.53 | 194.75 | 194.51 | 194.61 | 167839.0 |
| 2016-02-29 08:05:00 | SPY | ETF | 194.61 | 194.63 | 193.9989 | 194.54 | 128024.0 |
> showing 50 of 49,261 rows — these rows as CSV