PREVIEW / stock_5min / 2018-08-21
file: by_date/stock_5min/2018/2018-08-21.parquet size: 5.6 MB rows: 353,377 symbols: 2,797
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-08-21 04:20:00 | AAPL | Stock | 54.025 | 54.025 | 54.025 | 54.025 | 600.0 |
| 2018-08-21 04:30:00 | AAPL | Stock | 54.0 | 54.0 | 54.0 | 54.0 | 5896.0 |
| 2018-08-21 05:30:00 | AAPL | Stock | 54.1025 | 54.16 | 54.1025 | 54.16 | 2360.0 |
| 2018-08-21 05:40:00 | AAPL | Stock | 54.185 | 54.1925 | 54.15 | 54.165 | 43128.0 |
| 2018-08-21 05:45:00 | AAPL | Stock | 54.175 | 54.185 | 54.175 | 54.185 | 4000.0 |
| 2018-08-21 05:50:00 | AAPL | Stock | 54.1825 | 54.1825 | 54.15 | 54.175 | 11200.0 |
| 2018-08-21 05:55:00 | AAPL | Stock | 54.1725 | 54.1725 | 54.1725 | 54.1725 | 1288.0 |
| 2018-08-21 06:00:00 | AAPL | Stock | 54.22 | 54.225 | 54.22 | 54.225 | 2588.0 |
| 2018-08-21 06:05:00 | AAPL | Stock | 54.245 | 54.245 | 54.2175 | 54.22 | 5128.0 |
| 2018-08-21 06:10:00 | AAPL | Stock | 54.2025 | 54.2025 | 54.175 | 54.175 | 5196.0 |
| 2018-08-21 06:15:00 | AAPL | Stock | 54.1925 | 54.1925 | 54.175 | 54.175 | 1600.0 |
| 2018-08-21 06:20:00 | AAPL | Stock | 54.2075 | 54.25 | 54.2075 | 54.25 | 14360.0 |
| 2018-08-21 06:25:00 | AAPL | Stock | 54.25 | 54.25 | 54.2275 | 54.2275 | 6056.0 |
| 2018-08-21 06:50:00 | AAPL | Stock | 54.2125 | 54.2125 | 54.2025 | 54.2025 | 8000.0 |
| 2018-08-21 06:55:00 | AAPL | Stock | 54.1875 | 54.1875 | 54.1875 | 54.1875 | 1744.0 |
| 2018-08-21 07:00:00 | AAPL | Stock | 54.155 | 54.21 | 54.155 | 54.17 | 18120.0 |
| 2018-08-21 07:05:00 | AAPL | Stock | 54.165 | 54.165 | 54.15 | 54.1525 | 19484.0 |
| 2018-08-21 07:10:00 | AAPL | Stock | 54.15 | 54.15 | 54.09 | 54.09 | 27860.0 |
| 2018-08-21 07:15:00 | AAPL | Stock | 54.1225 | 54.1325 | 54.1225 | 54.1275 | 12236.0 |
| 2018-08-21 07:20:00 | AAPL | Stock | 54.1275 | 54.1275 | 54.105 | 54.105 | 8480.0 |
| 2018-08-21 07:25:00 | AAPL | Stock | 54.1125 | 54.125 | 54.1125 | 54.125 | 7880.0 |
| 2018-08-21 07:30:00 | AAPL | Stock | 54.1275 | 54.1275 | 54.1125 | 54.1125 | 19196.0 |
| 2018-08-21 07:35:00 | AAPL | Stock | 54.1125 | 54.135 | 54.1125 | 54.135 | 9084.0 |
| 2018-08-21 07:40:00 | AAPL | Stock | 54.135 | 54.14 | 54.1125 | 54.1125 | 15524.0 |
| 2018-08-21 07:45:00 | AAPL | Stock | 54.1025 | 54.1125 | 54.1025 | 54.1125 | 5516.0 |
| 2018-08-21 07:50:00 | AAPL | Stock | 54.105 | 54.105 | 54.1025 | 54.1025 | 5276.0 |
| 2018-08-21 07:55:00 | AAPL | Stock | 54.12 | 54.12 | 54.1125 | 54.1125 | 4600.0 |
| 2018-08-21 08:00:00 | AAPL | Stock | 54.1985 | 54.205 | 54.0825 | 54.085 | 59452.0 |
| 2018-08-21 08:05:00 | AAPL | Stock | 54.0525 | 54.1125 | 54.0525 | 54.09 | 11724.0 |
| 2018-08-21 08:10:00 | AAPL | Stock | 54.1 | 54.1175 | 54.0875 | 54.1175 | 18816.0 |
| 2018-08-21 08:15:00 | AAPL | Stock | 54.1125 | 54.1125 | 54.075 | 54.095 | 18492.0 |
| 2018-08-21 08:20:00 | AAPL | Stock | 54.105 | 54.1125 | 54.0825 | 54.1075 | 20296.0 |
| 2018-08-21 08:25:00 | AAPL | Stock | 54.1125 | 54.135 | 54.1125 | 54.135 | 16620.0 |
| 2018-08-21 08:30:00 | AAPL | Stock | 54.135 | 54.15 | 54.125 | 54.125 | 32828.0 |
| 2018-08-21 08:35:00 | AAPL | Stock | 54.125 | 54.1452 | 54.0975 | 54.1 | 29136.0 |
| 2018-08-21 08:40:00 | AAPL | Stock | 54.1 | 54.1175 | 54.0975 | 54.1175 | 21980.0 |
| 2018-08-21 08:45:00 | AAPL | Stock | 54.12 | 54.125 | 54.1125 | 54.125 | 6792.0 |
| 2018-08-21 08:50:00 | AAPL | Stock | 54.125 | 54.125 | 54.1125 | 54.125 | 11300.0 |
| 2018-08-21 08:55:00 | AAPL | Stock | 54.125 | 54.125 | 54.1 | 54.1 | 20028.0 |
| 2018-08-21 09:00:00 | AAPL | Stock | 54.1 | 54.1125 | 54.0975 | 54.1075 | 23852.0 |
| 2018-08-21 09:05:00 | AAPL | Stock | 54.11 | 54.125 | 54.0975 | 54.125 | 11900.0 |
| 2018-08-21 09:10:00 | AAPL | Stock | 54.125 | 54.1425 | 54.1225 | 54.13 | 13200.0 |
| 2018-08-21 09:15:00 | AAPL | Stock | 54.1275 | 54.1625 | 54.1125 | 54.1125 | 51272.0 |
| 2018-08-21 09:20:00 | AAPL | Stock | 54.13 | 54.2075 | 54.13 | 54.19 | 88860.0 |
| 2018-08-21 09:25:00 | AAPL | Stock | 54.1925 | 54.2425 | 54.15 | 54.1675 | 96236.0 |
| 2018-08-21 09:30:00 | AAPL | Stock | 54.2 | 54.2075 | 53.975 | 54.0525 | 4545952.0 |
| 2018-08-21 09:35:00 | AAPL | Stock | 54.0575 | 54.085 | 53.9775 | 54.015 | 2119560.0 |
| 2018-08-21 09:40:00 | AAPL | Stock | 54.01 | 54.0475 | 53.92 | 54.0232 | 1763184.0 |
| 2018-08-21 09:45:00 | AAPL | Stock | 54.025 | 54.06 | 53.945 | 53.9625 | 1428332.0 |
| 2018-08-21 09:50:00 | AAPL | Stock | 53.9625 | 54.005 | 53.92 | 53.995 | 1608840.0 |
> showing 50 of 353,377 rows — these rows as CSV