PREVIEW / etf_5min / 2015-08-25
file: by_date/etf_5min/2015/2015-08-25.parquet size: 1.4 MB rows: 60,399
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 |
|---|---|---|---|---|---|---|---|
| 2015-08-25 04:00:00 | SPY | ETF | 193.34 | 193.7 | 193.34 | 193.6 | 7013.0 |
| 2015-08-25 04:05:00 | SPY | ETF | 193.59 | 193.59 | 193.33 | 193.33 | 12739.0 |
| 2015-08-25 04:10:00 | SPY | ETF | 193.21 | 193.42 | 193.15 | 193.24 | 28315.0 |
| 2015-08-25 04:15:00 | SPY | ETF | 193.23 | 193.58 | 193.23 | 193.5 | 14450.0 |
| 2015-08-25 04:20:00 | SPY | ETF | 193.5 | 193.86 | 193.5 | 193.85 | 27079.0 |
| 2015-08-25 04:25:00 | SPY | ETF | 193.99 | 194.27 | 193.9 | 193.9 | 29242.0 |
| 2015-08-25 04:30:00 | SPY | ETF | 194.1 | 194.44 | 194.1 | 194.44 | 8695.0 |
| 2015-08-25 04:35:00 | SPY | ETF | 194.39 | 194.45 | 194.24 | 194.41 | 19030.0 |
| 2015-08-25 04:40:00 | SPY | ETF | 194.2 | 194.2 | 193.72 | 193.78 | 15708.0 |
| 2015-08-25 04:45:00 | SPY | ETF | 193.65 | 194.07 | 193.38 | 193.4 | 16914.0 |
| 2015-08-25 04:50:00 | SPY | ETF | 193.32 | 193.61 | 193.19 | 193.55 | 18263.0 |
| 2015-08-25 04:55:00 | SPY | ETF | 193.69 | 193.77 | 193.59 | 193.59 | 10752.0 |
| 2015-08-25 05:00:00 | SPY | ETF | 193.45 | 193.76 | 193.42 | 193.76 | 4090.0 |
| 2015-08-25 05:05:00 | SPY | ETF | 193.55 | 193.72 | 193.3 | 193.5 | 24648.0 |
| 2015-08-25 05:10:00 | SPY | ETF | 193.35 | 193.4 | 193.1 | 193.2 | 14353.0 |
| 2015-08-25 05:15:00 | SPY | ETF | 193.15 | 193.36 | 193.15 | 193.25 | 8349.0 |
| 2015-08-25 05:20:00 | SPY | ETF | 193.17 | 193.77 | 193.17 | 193.75 | 10037.0 |
| 2015-08-25 05:25:00 | SPY | ETF | 193.77 | 193.9 | 193.68 | 193.76 | 13620.0 |
| 2015-08-25 05:30:00 | SPY | ETF | 193.72 | 194.4 | 193.72 | 194.2 | 30084.0 |
| 2015-08-25 05:35:00 | SPY | ETF | 194.27 | 194.27 | 193.8 | 193.86 | 6842.0 |
| 2015-08-25 05:40:00 | SPY | ETF | 193.8 | 194.2 | 193.8 | 194.14 | 21811.0 |
| 2015-08-25 05:45:00 | SPY | ETF | 194.14 | 194.16 | 193.98 | 193.98 | 1931.0 |
| 2015-08-25 05:50:00 | SPY | ETF | 194.01 | 194.07 | 193.76 | 193.76 | 69215.0 |
| 2015-08-25 05:55:00 | SPY | ETF | 193.7 | 194.01 | 193.58 | 193.93 | 28424.0 |
| 2015-08-25 06:00:00 | SPY | ETF | 194.07 | 194.08 | 193.83 | 193.89 | 54720.0 |
| 2015-08-25 06:05:00 | SPY | ETF | 193.81 | 193.81 | 193.36 | 193.41 | 83155.0 |
| 2015-08-25 06:10:00 | SPY | ETF | 193.36 | 193.38 | 193.0 | 193.01 | 29683.0 |
| 2015-08-25 06:15:00 | SPY | ETF | 192.96 | 194.9 | 192.94 | 194.75 | 470952.0 |
| 2015-08-25 06:20:00 | SPY | ETF | 194.69 | 195.62 | 194.69 | 195.22 | 322966.0 |
| 2015-08-25 06:25:00 | SPY | ETF | 195.22 | 195.22 | 193.63 | 194.49 | 139951.0 |
| 2015-08-25 06:30:00 | SPY | ETF | 194.55 | 195.03 | 194.34 | 194.84 | 83885.0 |
| 2015-08-25 06:35:00 | SPY | ETF | 194.8 | 195.39 | 194.5 | 194.95 | 173755.0 |
| 2015-08-25 06:40:00 | SPY | ETF | 194.98 | 195.02 | 194.72 | 194.98 | 144195.0 |
| 2015-08-25 06:45:00 | SPY | ETF | 194.98 | 195.21 | 194.73 | 195.01 | 118605.0 |
| 2015-08-25 06:50:00 | SPY | ETF | 195.07 | 195.16 | 194.44 | 194.5 | 87623.0 |
| 2015-08-25 06:55:00 | SPY | ETF | 194.5 | 194.5 | 193.77 | 194.13 | 172151.0 |
| 2015-08-25 07:00:00 | SPY | ETF | 194.06 | 194.23 | 193.74 | 193.91 | 119715.0 |
| 2015-08-25 07:05:00 | SPY | ETF | 193.93 | 194.35 | 193.9 | 194.31 | 101900.0 |
| 2015-08-25 07:10:00 | SPY | ETF | 194.21 | 194.29 | 194.09 | 194.15 | 83946.0 |
| 2015-08-25 07:15:00 | SPY | ETF | 194.16 | 194.55 | 194.09 | 194.55 | 122973.0 |
| 2015-08-25 07:20:00 | SPY | ETF | 194.53 | 194.9 | 194.29 | 194.88 | 267827.0 |
| 2015-08-25 07:25:00 | SPY | ETF | 194.88 | 195.45 | 194.88 | 195.0 | 300369.0 |
| 2015-08-25 07:30:00 | SPY | ETF | 195.0 | 195.02 | 194.52 | 194.79 | 230663.0 |
| 2015-08-25 07:35:00 | SPY | ETF | 194.82 | 195.3 | 194.78 | 195.3 | 243359.0 |
| 2015-08-25 07:40:00 | SPY | ETF | 195.31 | 195.37 | 195.12 | 195.13 | 220269.0 |
| 2015-08-25 07:45:00 | SPY | ETF | 195.16 | 195.3 | 194.99 | 195.21 | 341637.0 |
| 2015-08-25 07:50:00 | SPY | ETF | 195.24 | 195.36 | 195.08 | 195.29 | 222642.0 |
| 2015-08-25 07:55:00 | SPY | ETF | 195.34 | 195.5 | 195.1 | 195.11 | 282701.0 |
| 2015-08-25 08:00:00 | SPY | ETF | 195.11 | 195.48 | 194.4 | 195.48 | 1049334.0 |
| 2015-08-25 08:05:00 | SPY | ETF | 194.67 | 194.88 | 193.96 | 194.3 | 915550.0 |
> showing 50 of 60,399 rows — these rows as CSV