PREVIEW / etf_1min / 2017-11-20
file: by_date/etf_1min/2017/2017-11-20.parquet size: 2.7 MB rows: 142,078
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-20 04:00:00 | SPY | ETF | 257.55 | 257.55 | 257.4 | 257.4 | 1276.0 |
| 2017-11-20 04:01:00 | SPY | ETF | 257.43 | 257.43 | 257.43 | 257.43 | 159.0 |
| 2017-11-20 04:05:00 | SPY | ETF | 257.43 | 257.43 | 257.43 | 257.43 | 316.0 |
| 2017-11-20 04:07:00 | SPY | ETF | 257.4 | 257.4 | 257.4 | 257.4 | 500.0 |
| 2017-11-20 04:14:00 | SPY | ETF | 257.44 | 257.44 | 257.44 | 257.44 | 800.0 |
| 2017-11-20 04:24:00 | SPY | ETF | 257.43 | 257.43 | 257.43 | 257.43 | 100.0 |
| 2017-11-20 04:25:00 | SPY | ETF | 257.43 | 257.43 | 257.41 | 257.41 | 300.0 |
| 2017-11-20 05:00:00 | SPY | ETF | 257.41 | 257.41 | 257.41 | 257.41 | 300.0 |
| 2017-11-20 05:37:00 | SPY | ETF | 257.6 | 257.6 | 257.6 | 257.6 | 400.0 |
| 2017-11-20 06:14:00 | SPY | ETF | 257.64 | 257.64 | 257.64 | 257.64 | 200.0 |
| 2017-11-20 06:18:00 | SPY | ETF | 257.65 | 257.7 | 257.65 | 257.7 | 1103.0 |
| 2017-11-20 06:21:00 | SPY | ETF | 257.58 | 257.58 | 257.58 | 257.58 | 3506.0 |
| 2017-11-20 06:25:00 | SPY | ETF | 257.64 | 257.64 | 257.63 | 257.63 | 1702.0 |
| 2017-11-20 06:28:00 | SPY | ETF | 257.58 | 257.58 | 257.58 | 257.58 | 600.0 |
| 2017-11-20 06:30:00 | SPY | ETF | 257.6 | 257.6 | 257.59 | 257.59 | 601.0 |
| 2017-11-20 06:31:00 | SPY | ETF | 257.59 | 257.59 | 257.59 | 257.59 | 550.0 |
| 2017-11-20 06:35:00 | SPY | ETF | 257.66 | 257.66 | 257.66 | 257.66 | 1002.0 |
| 2017-11-20 06:36:00 | SPY | ETF | 257.67 | 257.67 | 257.67 | 257.67 | 400.0 |
| 2017-11-20 06:38:00 | SPY | ETF | 257.7 | 257.75 | 257.7 | 257.75 | 313.0 |
| 2017-11-20 06:42:00 | SPY | ETF | 257.75 | 257.82 | 257.75 | 257.82 | 1106.0 |
| 2017-11-20 06:44:00 | SPY | ETF | 257.76 | 257.76 | 257.76 | 257.76 | 200.0 |
| 2017-11-20 06:46:00 | SPY | ETF | 257.74 | 257.74 | 257.7 | 257.7 | 803.0 |
| 2017-11-20 06:47:00 | SPY | ETF | 257.7 | 257.7 | 257.7 | 257.7 | 600.0 |
| 2017-11-20 06:48:00 | SPY | ETF | 257.73 | 257.73 | 257.73 | 257.73 | 300.0 |
| 2017-11-20 06:50:00 | SPY | ETF | 257.72 | 257.72 | 257.72 | 257.72 | 300.0 |
| 2017-11-20 06:51:00 | SPY | ETF | 257.72 | 257.72 | 257.72 | 257.72 | 300.0 |
| 2017-11-20 06:53:00 | SPY | ETF | 257.7 | 257.7 | 257.68 | 257.68 | 2144.0 |
| 2017-11-20 06:54:00 | SPY | ETF | 257.7 | 257.71 | 257.68 | 257.71 | 26200.0 |
| 2017-11-20 06:55:00 | SPY | ETF | 257.69 | 257.69 | 257.69 | 257.69 | 400.0 |
| 2017-11-20 06:57:00 | SPY | ETF | 257.68 | 257.68 | 257.68 | 257.68 | 300.0 |
| 2017-11-20 06:59:00 | SPY | ETF | 257.71 | 257.71 | 257.71 | 257.71 | 10001.0 |
| 2017-11-20 07:00:00 | SPY | ETF | 257.74 | 257.74 | 257.74 | 257.74 | 210.0 |
| 2017-11-20 07:01:00 | SPY | ETF | 257.74 | 257.74 | 257.74 | 257.74 | 1405.0 |
| 2017-11-20 07:03:00 | SPY | ETF | 257.76 | 257.76 | 257.75 | 257.75 | 1023.0 |
| 2017-11-20 07:06:00 | SPY | ETF | 257.75 | 257.75 | 257.75 | 257.75 | 100.0 |
| 2017-11-20 07:07:00 | SPY | ETF | 257.77 | 257.77 | 257.77 | 257.77 | 102.0 |
| 2017-11-20 07:09:00 | SPY | ETF | 257.71 | 257.71 | 257.71 | 257.71 | 1100.0 |
| 2017-11-20 07:12:00 | SPY | ETF | 257.7 | 257.7 | 257.67 | 257.67 | 53982.0 |
| 2017-11-20 07:14:00 | SPY | ETF | 257.71 | 257.71 | 257.71 | 257.71 | 6000.0 |
| 2017-11-20 07:18:00 | SPY | ETF | 257.72 | 257.72 | 257.72 | 257.72 | 100.0 |
| 2017-11-20 07:19:00 | SPY | ETF | 257.69 | 257.69 | 257.69 | 257.69 | 101.0 |
| 2017-11-20 07:20:00 | SPY | ETF | 257.69 | 257.7 | 257.69 | 257.7 | 21000.0 |
| 2017-11-20 07:21:00 | SPY | ETF | 257.68 | 257.68 | 257.63 | 257.68 | 56002.0 |
| 2017-11-20 07:22:00 | SPY | ETF | 257.68 | 257.69 | 257.68 | 257.69 | 902.0 |
| 2017-11-20 07:23:00 | SPY | ETF | 257.69 | 257.69 | 257.64 | 257.64 | 4147.0 |
| 2017-11-20 07:24:00 | SPY | ETF | 257.69 | 257.69 | 257.66 | 257.66 | 2504.0 |
| 2017-11-20 07:25:00 | SPY | ETF | 257.67 | 257.67 | 257.67 | 257.67 | 2000.0 |
| 2017-11-20 07:26:00 | SPY | ETF | 257.66 | 257.66 | 257.66 | 257.66 | 2001.0 |
| 2017-11-20 07:27:00 | SPY | ETF | 257.66 | 257.66 | 257.65 | 257.65 | 6007.0 |
| 2017-11-20 07:28:00 | SPY | ETF | 257.65 | 257.65 | 257.64 | 257.64 | 6000.0 |
> showing 50 of 142,078 rows — these rows as CSV