PREVIEW / etf_5min / 2017-11-30
file: by_date/etf_5min/2017/2017-11-30.parquet size: 1.4 MB rows: 59,721
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 |
|---|---|---|---|---|---|---|---|
| 2017-11-30 04:00:00 | SPY | ETF | 262.9 | 262.9 | 262.9 | 262.9 | 500.0 |
| 2017-11-30 04:05:00 | SPY | ETF | 263.1 | 263.1 | 263.08 | 263.08 | 4400.0 |
| 2017-11-30 04:10:00 | SPY | ETF | 263.18 | 263.18 | 263.18 | 263.18 | 3300.0 |
| 2017-11-30 04:15:00 | SPY | ETF | 263.15 | 263.15 | 263.15 | 263.15 | 100.0 |
| 2017-11-30 04:20:00 | SPY | ETF | 263.16 | 263.16 | 263.16 | 263.16 | 300.0 |
| 2017-11-30 04:25:00 | SPY | ETF | 263.17 | 263.19 | 263.17 | 263.19 | 2050.0 |
| 2017-11-30 04:40:00 | SPY | ETF | 263.06 | 263.21 | 263.06 | 263.21 | 4263.0 |
| 2017-11-30 04:50:00 | SPY | ETF | 263.06 | 263.06 | 263.06 | 263.06 | 600.0 |
| 2017-11-30 04:55:00 | SPY | ETF | 263.08 | 263.08 | 263.08 | 263.08 | 4200.0 |
| 2017-11-30 05:00:00 | SPY | ETF | 263.1 | 263.1 | 263.1 | 263.1 | 100.0 |
| 2017-11-30 05:05:00 | SPY | ETF | 263.13 | 263.13 | 263.06 | 263.11 | 1900.0 |
| 2017-11-30 05:15:00 | SPY | ETF | 263.13 | 263.18 | 263.13 | 263.18 | 600.0 |
| 2017-11-30 05:25:00 | SPY | ETF | 263.18 | 263.18 | 263.18 | 263.18 | 100.0 |
| 2017-11-30 05:30:00 | SPY | ETF | 263.22 | 263.24 | 263.18 | 263.24 | 4300.0 |
| 2017-11-30 05:35:00 | SPY | ETF | 263.25 | 263.25 | 263.23 | 263.23 | 1150.0 |
| 2017-11-30 05:40:00 | SPY | ETF | 263.3 | 263.31 | 263.3 | 263.31 | 3300.0 |
| 2017-11-30 05:45:00 | SPY | ETF | 263.34 | 263.37 | 263.34 | 263.37 | 11424.0 |
| 2017-11-30 05:50:00 | SPY | ETF | 263.45 | 263.5 | 263.45 | 263.48 | 7100.0 |
| 2017-11-30 05:55:00 | SPY | ETF | 263.5 | 263.5 | 263.45 | 263.45 | 1400.0 |
| 2017-11-30 06:00:00 | SPY | ETF | 263.48 | 263.55 | 263.48 | 263.5 | 33900.0 |
| 2017-11-30 06:05:00 | SPY | ETF | 263.47 | 263.47 | 263.47 | 263.47 | 100.0 |
| 2017-11-30 06:10:00 | SPY | ETF | 263.47 | 263.48 | 263.45 | 263.48 | 11300.0 |
| 2017-11-30 06:15:00 | SPY | ETF | 263.52 | 263.57 | 263.52 | 263.55 | 1100.0 |
| 2017-11-30 06:20:00 | SPY | ETF | 263.52 | 263.63 | 263.52 | 263.63 | 1730.0 |
| 2017-11-30 06:25:00 | SPY | ETF | 263.62 | 263.62 | 263.57 | 263.58 | 2600.0 |
| 2017-11-30 06:30:00 | SPY | ETF | 263.55 | 263.55 | 263.54 | 263.55 | 1560.0 |
| 2017-11-30 06:40:00 | SPY | ETF | 263.54 | 263.54 | 263.54 | 263.54 | 500.0 |
| 2017-11-30 06:45:00 | SPY | ETF | 263.53 | 263.53 | 263.53 | 263.53 | 501.0 |
| 2017-11-30 06:50:00 | SPY | ETF | 263.55 | 263.55 | 263.55 | 263.55 | 199.0 |
| 2017-11-30 06:55:00 | SPY | ETF | 263.55 | 263.55 | 263.55 | 263.55 | 1000.0 |
| 2017-11-30 07:00:00 | SPY | ETF | 263.54 | 263.54 | 263.46 | 263.46 | 5273.0 |
| 2017-11-30 07:05:00 | SPY | ETF | 263.45 | 263.46 | 263.41 | 263.43 | 5001.0 |
| 2017-11-30 07:10:00 | SPY | ETF | 263.42 | 263.42 | 263.37 | 263.41 | 23423.0 |
| 2017-11-30 07:15:00 | SPY | ETF | 263.44 | 263.44 | 263.34 | 263.37 | 14443.0 |
| 2017-11-30 07:20:00 | SPY | ETF | 263.42 | 263.44 | 263.42 | 263.44 | 1676.0 |
| 2017-11-30 07:25:00 | SPY | ETF | 263.44 | 263.45 | 263.44 | 263.44 | 969.0 |
| 2017-11-30 07:30:00 | SPY | ETF | 263.42 | 263.42 | 263.38 | 263.38 | 9396.0 |
| 2017-11-30 07:35:00 | SPY | ETF | 263.38 | 263.39 | 263.33 | 263.39 | 9376.0 |
| 2017-11-30 07:40:00 | SPY | ETF | 263.4 | 263.4 | 263.39 | 263.4 | 69411.0 |
| 2017-11-30 07:45:00 | SPY | ETF | 263.42 | 263.42 | 263.36 | 263.39 | 24043.0 |
| 2017-11-30 07:50:00 | SPY | ETF | 263.39 | 263.44 | 263.37 | 263.44 | 16582.0 |
| 2017-11-30 07:55:00 | SPY | ETF | 263.46 | 263.52 | 263.45 | 263.52 | 29232.0 |
| 2017-11-30 08:00:00 | SPY | ETF | 263.4 | 263.53 | 263.4 | 263.45 | 36632.0 |
| 2017-11-30 08:05:00 | SPY | ETF | 263.45 | 263.47 | 263.43 | 263.47 | 35230.0 |
| 2017-11-30 08:10:00 | SPY | ETF | 263.47 | 263.47 | 263.45 | 263.47 | 3791.0 |
| 2017-11-30 08:15:00 | SPY | ETF | 263.47 | 263.49 | 263.46 | 263.49 | 55221.0 |
| 2017-11-30 08:20:00 | SPY | ETF | 263.49 | 263.54 | 263.49 | 263.53 | 56504.0 |
| 2017-11-30 08:25:00 | SPY | ETF | 263.54 | 263.57 | 263.52 | 263.55 | 77042.0 |
| 2017-11-30 08:30:00 | SPY | ETF | 263.57 | 263.57 | 263.51 | 263.52 | 76656.0 |
| 2017-11-30 08:35:00 | SPY | ETF | 263.53 | 263.55 | 263.49 | 263.49 | 12405.0 |
> showing 50 of 59,721 rows — these rows as CSV