PREVIEW / stock_5min / 2018-02-21
file: by_date/stock_5min/2018/2018-02-21.parquet size: 5.6 MB rows: 358,640 symbols: 2,876
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 |
|---|---|---|---|---|---|---|---|
| 2018-02-21 04:00:00 | AAPL | Stock | 42.975 | 42.975 | 42.975 | 42.975 | 800.0 |
| 2018-02-21 04:10:00 | AAPL | Stock | 42.925 | 42.925 | 42.925 | 42.925 | 3972.0 |
| 2018-02-21 04:20:00 | AAPL | Stock | 42.9475 | 42.9475 | 42.9475 | 42.9475 | 800.0 |
| 2018-02-21 04:25:00 | AAPL | Stock | 42.955 | 42.975 | 42.955 | 42.975 | 8400.0 |
| 2018-02-21 04:40:00 | AAPL | Stock | 42.975 | 42.975 | 42.975 | 42.975 | 400.0 |
| 2018-02-21 04:50:00 | AAPL | Stock | 42.97 | 42.97 | 42.94 | 42.94 | 2096.0 |
| 2018-02-21 04:55:00 | AAPL | Stock | 42.935 | 42.935 | 42.9025 | 42.9025 | 4392.0 |
| 2018-02-21 05:00:00 | AAPL | Stock | 42.955 | 43.045 | 42.955 | 43.045 | 4736.0 |
| 2018-02-21 05:05:00 | AAPL | Stock | 42.9875 | 42.9875 | 42.9875 | 42.9875 | 1200.0 |
| 2018-02-21 05:10:00 | AAPL | Stock | 42.9875 | 42.9875 | 42.9875 | 42.9875 | 800.0 |
| 2018-02-21 05:15:00 | AAPL | Stock | 43.02 | 43.02 | 43.02 | 43.02 | 1800.0 |
| 2018-02-21 05:30:00 | AAPL | Stock | 42.995 | 42.995 | 42.995 | 42.995 | 704.0 |
| 2018-02-21 05:35:00 | AAPL | Stock | 42.995 | 43.0 | 42.995 | 43.0 | 6880.0 |
| 2018-02-21 05:40:00 | AAPL | Stock | 43.0225 | 43.0575 | 43.0225 | 43.045 | 15456.0 |
| 2018-02-21 06:00:00 | AAPL | Stock | 43.0525 | 43.0525 | 43.03 | 43.045 | 9268.0 |
| 2018-02-21 06:05:00 | AAPL | Stock | 43.045 | 43.045 | 43.045 | 43.045 | 2000.0 |
| 2018-02-21 06:10:00 | AAPL | Stock | 43.03 | 43.03 | 43.0225 | 43.0225 | 3776.0 |
| 2018-02-21 06:15:00 | AAPL | Stock | 43.0025 | 43.0025 | 43.0025 | 43.0025 | 2400.0 |
| 2018-02-21 06:20:00 | AAPL | Stock | 43.0175 | 43.0175 | 43.0175 | 43.0175 | 400.0 |
| 2018-02-21 06:25:00 | AAPL | Stock | 43.0175 | 43.0175 | 43.0175 | 43.0175 | 1200.0 |
| 2018-02-21 06:30:00 | AAPL | Stock | 43.0 | 43.0 | 43.0 | 43.0 | 3200.0 |
| 2018-02-21 06:40:00 | AAPL | Stock | 43.0 | 43.0 | 43.0 | 43.0 | 1200.0 |
| 2018-02-21 06:45:00 | AAPL | Stock | 43.0 | 43.0 | 42.9675 | 42.9675 | 5604.0 |
| 2018-02-21 06:50:00 | AAPL | Stock | 43.0 | 43.025 | 42.995 | 43.025 | 29296.0 |
| 2018-02-21 06:55:00 | AAPL | Stock | 43.025 | 43.0625 | 43.025 | 43.0625 | 6140.0 |
| 2018-02-21 07:00:00 | AAPL | Stock | 43.03 | 43.065 | 43.0275 | 43.0575 | 26368.0 |
| 2018-02-21 07:05:00 | AAPL | Stock | 43.0725 | 43.1175 | 43.0625 | 43.1075 | 28912.0 |
| 2018-02-21 07:10:00 | AAPL | Stock | 43.11 | 43.11 | 43.0875 | 43.0875 | 10036.0 |
| 2018-02-21 07:15:00 | AAPL | Stock | 43.11 | 43.15 | 43.11 | 43.15 | 27124.0 |
| 2018-02-21 07:20:00 | AAPL | Stock | 43.1275 | 43.15 | 43.125 | 43.1425 | 60784.0 |
| 2018-02-21 07:25:00 | AAPL | Stock | 43.1425 | 43.1425 | 43.1 | 43.1225 | 12304.0 |
| 2018-02-21 07:30:00 | AAPL | Stock | 43.1 | 43.1475 | 43.1 | 43.125 | 4000.0 |
| 2018-02-21 07:35:00 | AAPL | Stock | 43.1225 | 43.125 | 43.08 | 43.1 | 6300.0 |
| 2018-02-21 07:40:00 | AAPL | Stock | 43.1075 | 43.1125 | 43.1075 | 43.1125 | 2952.0 |
| 2018-02-21 07:45:00 | AAPL | Stock | 43.1 | 43.1125 | 43.0775 | 43.0775 | 15080.0 |
| 2018-02-21 07:50:00 | AAPL | Stock | 43.1 | 43.1 | 43.1 | 43.1 | 800.0 |
| 2018-02-21 07:55:00 | AAPL | Stock | 43.11 | 43.125 | 43.11 | 43.1225 | 2400.0 |
| 2018-02-21 08:00:00 | AAPL | Stock | 43.125 | 43.1475 | 43.025 | 43.1375 | 110116.0 |
| 2018-02-21 08:05:00 | AAPL | Stock | 43.1375 | 43.1475 | 43.12 | 43.1475 | 29688.0 |
| 2018-02-21 08:10:00 | AAPL | Stock | 43.1425 | 43.1875 | 43.1425 | 43.18 | 33408.0 |
| 2018-02-21 08:15:00 | AAPL | Stock | 43.1975 | 43.2625 | 43.1975 | 43.25 | 49856.0 |
| 2018-02-21 08:20:00 | AAPL | Stock | 43.225 | 43.2475 | 43.2125 | 43.2375 | 15776.0 |
| 2018-02-21 08:25:00 | AAPL | Stock | 43.25 | 43.2775 | 43.25 | 43.2625 | 15140.0 |
| 2018-02-21 08:30:00 | AAPL | Stock | 43.275 | 43.3 | 43.265 | 43.3 | 21456.0 |
| 2018-02-21 08:35:00 | AAPL | Stock | 43.3025 | 43.335 | 43.275 | 43.335 | 55564.0 |
| 2018-02-21 08:40:00 | AAPL | Stock | 43.3 | 43.32 | 43.2525 | 43.28 | 27948.0 |
| 2018-02-21 08:45:00 | AAPL | Stock | 43.2625 | 43.275 | 43.2625 | 43.2625 | 3200.0 |
| 2018-02-21 08:50:00 | AAPL | Stock | 43.265 | 43.27 | 43.23 | 43.2625 | 122980.0 |
| 2018-02-21 08:55:00 | AAPL | Stock | 43.275 | 43.275 | 43.225 | 43.275 | 28736.0 |
| 2018-02-21 09:00:00 | AAPL | Stock | 43.26 | 43.31 | 43.2525 | 43.2975 | 40840.0 |
> showing 50 of 358,640 rows — these rows as CSV