PREVIEW / etf_5min / 2016-01-07
file: by_date/etf_5min/2016/2016-01-07.parquet size: 1.3 MB rows: 56,653
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-01-07 04:00:00 | SPY | ETF | 194.27 | 195.45 | 194.16 | 194.38 | 26390.0 |
| 2016-01-07 04:05:00 | SPY | ETF | 194.41 | 194.49 | 194.32 | 194.32 | 31737.0 |
| 2016-01-07 04:10:00 | SPY | ETF | 194.31 | 194.31 | 193.96 | 194.21 | 49060.0 |
| 2016-01-07 04:15:00 | SPY | ETF | 194.18 | 194.27 | 193.75 | 194.06 | 59382.0 |
| 2016-01-07 04:20:00 | SPY | ETF | 194.16 | 194.23 | 193.75 | 193.75 | 24751.0 |
| 2016-01-07 04:25:00 | SPY | ETF | 193.75 | 194.0 | 193.75 | 194.0 | 93843.0 |
| 2016-01-07 04:30:00 | SPY | ETF | 194.01 | 194.33 | 194.01 | 194.08 | 22062.0 |
| 2016-01-07 04:35:00 | SPY | ETF | 194.09 | 194.43 | 194.02 | 194.39 | 11656.0 |
| 2016-01-07 04:40:00 | SPY | ETF | 194.32 | 194.35 | 194.0 | 194.0 | 35131.0 |
| 2016-01-07 04:45:00 | SPY | ETF | 194.0 | 194.49 | 193.98 | 194.28 | 38461.0 |
| 2016-01-07 04:50:00 | SPY | ETF | 194.52 | 194.6 | 194.43 | 194.5 | 13975.0 |
| 2016-01-07 04:55:00 | SPY | ETF | 194.52 | 194.58 | 194.43 | 194.51 | 21122.0 |
| 2016-01-07 05:00:00 | SPY | ETF | 194.49 | 194.8 | 194.49 | 194.7 | 7223.0 |
| 2016-01-07 05:05:00 | SPY | ETF | 194.72 | 194.87 | 194.72 | 194.82 | 13436.0 |
| 2016-01-07 05:10:00 | SPY | ETF | 194.76 | 194.76 | 194.34 | 194.4 | 23496.0 |
| 2016-01-07 05:15:00 | SPY | ETF | 194.5 | 194.52 | 194.36 | 194.37 | 14600.0 |
| 2016-01-07 05:20:00 | SPY | ETF | 194.32 | 194.32 | 194.17 | 194.23 | 9103.0 |
| 2016-01-07 05:25:00 | SPY | ETF | 194.23 | 194.23 | 193.83 | 193.85 | 28146.0 |
| 2016-01-07 05:30:00 | SPY | ETF | 193.89 | 194.11 | 193.83 | 194.05 | 12972.0 |
| 2016-01-07 05:35:00 | SPY | ETF | 194.03 | 194.31 | 194.0 | 194.24 | 9850.0 |
| 2016-01-07 05:40:00 | SPY | ETF | 194.33 | 194.37 | 194.29 | 194.29 | 4800.0 |
| 2016-01-07 05:45:00 | SPY | ETF | 194.28 | 194.42 | 194.09 | 194.09 | 7946.0 |
| 2016-01-07 05:50:00 | SPY | ETF | 194.19 | 194.6 | 194.08 | 194.4 | 15759.0 |
| 2016-01-07 05:55:00 | SPY | ETF | 194.43 | 194.49 | 194.25 | 194.35 | 8120.0 |
| 2016-01-07 06:00:00 | SPY | ETF | 194.35 | 194.51 | 194.35 | 194.44 | 5080.0 |
| 2016-01-07 06:05:00 | SPY | ETF | 194.4 | 194.56 | 194.4 | 194.56 | 6522.0 |
| 2016-01-07 06:10:00 | SPY | ETF | 194.55 | 194.87 | 194.52 | 194.76 | 9824.0 |
| 2016-01-07 06:15:00 | SPY | ETF | 194.82 | 194.97 | 194.66 | 194.76 | 14538.0 |
| 2016-01-07 06:20:00 | SPY | ETF | 194.76 | 194.76 | 194.42 | 194.62 | 9415.0 |
| 2016-01-07 06:25:00 | SPY | ETF | 194.62 | 194.72 | 194.62 | 194.68 | 12300.0 |
| 2016-01-07 06:30:00 | SPY | ETF | 194.65 | 194.7 | 194.56 | 194.69 | 6000.0 |
| 2016-01-07 06:35:00 | SPY | ETF | 194.65 | 194.85 | 194.6 | 194.83 | 9251.0 |
| 2016-01-07 06:40:00 | SPY | ETF | 194.83 | 195.08 | 194.83 | 195.08 | 15906.0 |
| 2016-01-07 06:45:00 | SPY | ETF | 195.0 | 195.0 | 194.85 | 194.85 | 7100.0 |
| 2016-01-07 06:50:00 | SPY | ETF | 194.9 | 194.9 | 194.63 | 194.73 | 14005.0 |
| 2016-01-07 06:55:00 | SPY | ETF | 194.68 | 194.77 | 194.68 | 194.75 | 6503.0 |
| 2016-01-07 07:00:00 | SPY | ETF | 194.73 | 194.87 | 194.51 | 194.84 | 78001.0 |
| 2016-01-07 07:05:00 | SPY | ETF | 194.84 | 194.9 | 194.75 | 194.76 | 41143.0 |
| 2016-01-07 07:10:00 | SPY | ETF | 194.77 | 194.77 | 194.5 | 194.65 | 46273.0 |
| 2016-01-07 07:15:00 | SPY | ETF | 194.64 | 194.95 | 194.62 | 194.89 | 94696.0 |
| 2016-01-07 07:20:00 | SPY | ETF | 194.88 | 194.91 | 194.75 | 194.75 | 94483.0 |
| 2016-01-07 07:25:00 | SPY | ETF | 194.75 | 195.04 | 194.69 | 194.99 | 45284.0 |
| 2016-01-07 07:30:00 | SPY | ETF | 194.99 | 195.05 | 194.87 | 194.98 | 64839.0 |
| 2016-01-07 07:35:00 | SPY | ETF | 195.01 | 195.22 | 194.84 | 194.99 | 49900.0 |
| 2016-01-07 07:40:00 | SPY | ETF | 194.98 | 195.09 | 194.85 | 194.9 | 66841.0 |
| 2016-01-07 07:45:00 | SPY | ETF | 194.93 | 195.0 | 194.75 | 194.76 | 113695.0 |
| 2016-01-07 07:50:00 | SPY | ETF | 194.78 | 194.93 | 194.7 | 194.88 | 76429.0 |
| 2016-01-07 07:55:00 | SPY | ETF | 194.93 | 195.02 | 194.91 | 194.91 | 23008.0 |
| 2016-01-07 08:00:00 | SPY | ETF | 194.91 | 196.95 | 193.68 | 194.92 | 498972.0 |
| 2016-01-07 08:05:00 | SPY | ETF | 194.91 | 194.96 | 194.75 | 194.8 | 82156.0 |
> showing 50 of 56,653 rows — these rows as CSV