PREVIEW / etf_5min / 2016-10-25
file: by_date/etf_5min/2016/2016-10-25.parquet size: 1.1 MB rows: 49,125
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-10-25 04:05:00 | SPY | ETF | 215.16 | 215.16 | 215.16 | 215.16 | 900.0 |
| 2016-10-25 04:10:00 | SPY | ETF | 215.19 | 215.25 | 215.19 | 215.25 | 3492.0 |
| 2016-10-25 04:15:00 | SPY | ETF | 215.24 | 215.24 | 215.24 | 215.24 | 400.0 |
| 2016-10-25 04:20:00 | SPY | ETF | 215.21 | 215.21 | 215.19 | 215.19 | 1213.0 |
| 2016-10-25 04:25:00 | SPY | ETF | 215.19 | 215.19 | 215.19 | 215.19 | 1901.0 |
| 2016-10-25 04:30:00 | SPY | ETF | 215.24 | 215.24 | 215.24 | 215.24 | 199.0 |
| 2016-10-25 04:35:00 | SPY | ETF | 215.22 | 215.22 | 215.22 | 215.22 | 100.0 |
| 2016-10-25 04:45:00 | SPY | ETF | 215.29 | 215.29 | 215.26 | 215.26 | 682.0 |
| 2016-10-25 04:50:00 | SPY | ETF | 215.35 | 215.35 | 215.31 | 215.31 | 2902.0 |
| 2016-10-25 04:55:00 | SPY | ETF | 215.35 | 215.35 | 215.35 | 215.35 | 601.0 |
| 2016-10-25 05:00:00 | SPY | ETF | 215.31 | 215.31 | 215.31 | 215.31 | 302.0 |
| 2016-10-25 05:05:00 | SPY | ETF | 215.31 | 215.31 | 215.31 | 215.31 | 2400.0 |
| 2016-10-25 05:10:00 | SPY | ETF | 215.31 | 215.31 | 215.29 | 215.29 | 707.0 |
| 2016-10-25 05:15:00 | SPY | ETF | 215.26 | 215.28 | 215.24 | 215.24 | 1520.0 |
| 2016-10-25 05:25:00 | SPY | ETF | 215.22 | 215.22 | 215.22 | 215.22 | 900.0 |
| 2016-10-25 05:30:00 | SPY | ETF | 215.22 | 215.24 | 215.22 | 215.24 | 500.0 |
| 2016-10-25 05:35:00 | SPY | ETF | 215.24 | 215.24 | 215.19 | 215.19 | 962.0 |
| 2016-10-25 05:45:00 | SPY | ETF | 215.14 | 215.15 | 215.14 | 215.15 | 506.0 |
| 2016-10-25 05:50:00 | SPY | ETF | 215.17 | 215.17 | 215.14 | 215.14 | 2400.0 |
| 2016-10-25 05:55:00 | SPY | ETF | 215.14 | 215.14 | 215.11 | 215.11 | 1005.0 |
| 2016-10-25 06:05:00 | SPY | ETF | 215.11 | 215.12 | 215.11 | 215.12 | 1502.0 |
| 2016-10-25 06:10:00 | SPY | ETF | 215.14 | 215.16 | 215.14 | 215.16 | 801.0 |
| 2016-10-25 06:15:00 | SPY | ETF | 215.16 | 215.16 | 215.16 | 215.16 | 5200.0 |
| 2016-10-25 06:20:00 | SPY | ETF | 215.2 | 215.2 | 215.2 | 215.2 | 1000.0 |
| 2016-10-25 06:30:00 | SPY | ETF | 215.16 | 215.16 | 215.16 | 215.16 | 300.0 |
| 2016-10-25 06:35:00 | SPY | ETF | 215.17 | 215.17 | 215.17 | 215.17 | 300.0 |
| 2016-10-25 06:45:00 | SPY | ETF | 215.12 | 215.12 | 215.08 | 215.08 | 1972.0 |
| 2016-10-25 06:50:00 | SPY | ETF | 215.07 | 215.07 | 214.95 | 214.97 | 2003.0 |
| 2016-10-25 07:00:00 | SPY | ETF | 214.89 | 214.9 | 214.84 | 214.9 | 20611.0 |
| 2016-10-25 07:10:00 | SPY | ETF | 214.86 | 214.91 | 214.86 | 214.91 | 704.0 |
| 2016-10-25 07:15:00 | SPY | ETF | 214.94 | 214.96 | 214.94 | 214.95 | 9965.0 |
| 2016-10-25 07:20:00 | SPY | ETF | 214.98 | 214.98 | 214.98 | 214.98 | 200.0 |
| 2016-10-25 07:25:00 | SPY | ETF | 214.99 | 215.01 | 214.97 | 215.01 | 12811.0 |
| 2016-10-25 07:30:00 | SPY | ETF | 215.0 | 215.0 | 214.94 | 214.94 | 15019.0 |
| 2016-10-25 07:35:00 | SPY | ETF | 214.96 | 215.02 | 214.96 | 215.02 | 4941.0 |
| 2016-10-25 07:40:00 | SPY | ETF | 215.05 | 215.07 | 215.05 | 215.07 | 14662.0 |
| 2016-10-25 07:45:00 | SPY | ETF | 215.02 | 215.03 | 215.02 | 215.03 | 2993.0 |
| 2016-10-25 07:50:00 | SPY | ETF | 215.05 | 215.07 | 215.03 | 215.05 | 11862.0 |
| 2016-10-25 07:55:00 | SPY | ETF | 215.02 | 215.02 | 214.97 | 215.0 | 2258.0 |
| 2016-10-25 08:00:00 | SPY | ETF | 215.0 | 215.07 | 214.97 | 215.07 | 7226.0 |
| 2016-10-25 08:05:00 | SPY | ETF | 215.081 | 215.081 | 215.05 | 215.05 | 35949.0 |
| 2016-10-25 08:10:00 | SPY | ETF | 215.08 | 215.1 | 215.08 | 215.09 | 14914.0 |
| 2016-10-25 08:15:00 | SPY | ETF | 215.1 | 215.14 | 215.07 | 215.07 | 7973.0 |
| 2016-10-25 08:20:00 | SPY | ETF | 215.08 | 215.12 | 215.06 | 215.08 | 38877.0 |
| 2016-10-25 08:25:00 | SPY | ETF | 215.07 | 215.09 | 215.07 | 215.09 | 1634.0 |
| 2016-10-25 08:30:00 | SPY | ETF | 215.09 | 215.13 | 215.09 | 215.11 | 10991.0 |
| 2016-10-25 08:35:00 | SPY | ETF | 215.1 | 215.13 | 215.09 | 215.13 | 51017.0 |
| 2016-10-25 08:40:00 | SPY | ETF | 215.14 | 215.14 | 215.1 | 215.1 | 31210.0 |
| 2016-10-25 08:45:00 | SPY | ETF | 215.1 | 215.12 | 215.08 | 215.09 | 13540.0 |
| 2016-10-25 08:50:00 | SPY | ETF | 215.07 | 215.08 | 215.01 | 215.04 | 36280.0 |
> showing 50 of 49,125 rows — these rows as CSV