PREVIEW / stock_5min / 2019-07-19
file: by_date/stock_5min/2019/2019-07-19.parquet size: 5.5 MB rows: 350,842 symbols: 2,577
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 |
|---|---|---|---|---|---|---|---|
| 2019-07-19 04:00:00 | AAPL | Stock | 51.5875 | 51.5875 | 51.5875 | 51.5875 | 1868.0 |
| 2019-07-19 04:10:00 | AAPL | Stock | 51.5875 | 51.5875 | 51.5875 | 51.5875 | 2336.0 |
| 2019-07-19 04:15:00 | AAPL | Stock | 51.675 | 51.675 | 51.65 | 51.65 | 5748.0 |
| 2019-07-19 04:20:00 | AAPL | Stock | 51.59 | 51.59 | 51.59 | 51.59 | 400.0 |
| 2019-07-19 04:50:00 | AAPL | Stock | 51.5325 | 51.5325 | 51.5325 | 51.5325 | 472.0 |
| 2019-07-19 04:55:00 | AAPL | Stock | 51.5325 | 51.5325 | 51.5325 | 51.5325 | 832.0 |
| 2019-07-19 05:00:00 | AAPL | Stock | 51.525 | 51.525 | 51.525 | 51.525 | 400.0 |
| 2019-07-19 05:15:00 | AAPL | Stock | 51.5475 | 51.5475 | 51.545 | 51.545 | 800.0 |
| 2019-07-19 05:25:00 | AAPL | Stock | 51.5725 | 51.5725 | 51.5725 | 51.5725 | 7000.0 |
| 2019-07-19 05:30:00 | AAPL | Stock | 51.5375 | 51.575 | 51.5375 | 51.575 | 4336.0 |
| 2019-07-19 05:35:00 | AAPL | Stock | 51.545 | 51.545 | 51.5075 | 51.5075 | 6096.0 |
| 2019-07-19 05:40:00 | AAPL | Stock | 51.5075 | 51.5075 | 51.5075 | 51.5075 | 400.0 |
| 2019-07-19 05:45:00 | AAPL | Stock | 51.51 | 51.5475 | 51.5075 | 51.5475 | 9064.0 |
| 2019-07-19 05:50:00 | AAPL | Stock | 51.515 | 51.515 | 51.5075 | 51.5075 | 3160.0 |
| 2019-07-19 05:55:00 | AAPL | Stock | 51.505 | 51.505 | 51.505 | 51.505 | 800.0 |
| 2019-07-19 06:15:00 | AAPL | Stock | 51.4975 | 51.4975 | 51.4975 | 51.4975 | 400.0 |
| 2019-07-19 06:20:00 | AAPL | Stock | 51.475 | 51.475 | 51.475 | 51.475 | 400.0 |
| 2019-07-19 06:35:00 | AAPL | Stock | 51.4775 | 51.4775 | 51.4775 | 51.4775 | 996.0 |
| 2019-07-19 06:40:00 | AAPL | Stock | 51.4775 | 51.4875 | 51.4125 | 51.4125 | 13000.0 |
| 2019-07-19 06:45:00 | AAPL | Stock | 51.4125 | 51.4125 | 51.3 | 51.3475 | 2000.0 |
| 2019-07-19 06:50:00 | AAPL | Stock | 51.3525 | 51.3525 | 51.35 | 51.35 | 800.0 |
| 2019-07-19 06:55:00 | AAPL | Stock | 51.4125 | 51.4125 | 51.36 | 51.39 | 3200.0 |
| 2019-07-19 07:00:00 | AAPL | Stock | 51.4625 | 51.48 | 51.41 | 51.415 | 19552.0 |
| 2019-07-19 07:05:00 | AAPL | Stock | 51.415 | 51.4175 | 51.39 | 51.39 | 14736.0 |
| 2019-07-19 07:10:00 | AAPL | Stock | 51.4125 | 51.425 | 51.4075 | 51.4075 | 14116.0 |
| 2019-07-19 07:15:00 | AAPL | Stock | 51.4075 | 51.4275 | 51.4075 | 51.4275 | 2400.0 |
| 2019-07-19 07:20:00 | AAPL | Stock | 51.4275 | 51.43 | 51.4125 | 51.425 | 6068.0 |
| 2019-07-19 07:25:00 | AAPL | Stock | 51.4225 | 51.425 | 51.39 | 51.41 | 11120.0 |
| 2019-07-19 07:30:00 | AAPL | Stock | 51.39 | 51.4 | 51.39 | 51.4 | 2324.0 |
| 2019-07-19 07:35:00 | AAPL | Stock | 51.4125 | 51.4575 | 51.4125 | 51.44 | 11388.0 |
| 2019-07-19 07:40:00 | AAPL | Stock | 51.4625 | 51.4625 | 51.45 | 51.45 | 6648.0 |
| 2019-07-19 07:45:00 | AAPL | Stock | 51.4625 | 51.4625 | 51.45 | 51.45 | 4640.0 |
| 2019-07-19 07:50:00 | AAPL | Stock | 51.43 | 51.4375 | 51.415 | 51.415 | 6596.0 |
| 2019-07-19 07:55:00 | AAPL | Stock | 51.425 | 51.44 | 51.4 | 51.4 | 8172.0 |
| 2019-07-19 08:00:00 | AAPL | Stock | 51.4275 | 51.46 | 51.39 | 51.4 | 72408.0 |
| 2019-07-19 08:05:00 | AAPL | Stock | 51.4 | 51.4375 | 51.4 | 51.4375 | 2600.0 |
| 2019-07-19 08:10:00 | AAPL | Stock | 51.435 | 51.4375 | 51.435 | 51.4375 | 800.0 |
| 2019-07-19 08:15:00 | AAPL | Stock | 51.4475 | 51.4525 | 51.425 | 51.425 | 11000.0 |
| 2019-07-19 08:20:00 | AAPL | Stock | 51.47 | 51.485 | 51.4625 | 51.4625 | 6616.0 |
| 2019-07-19 08:25:00 | AAPL | Stock | 51.4475 | 51.4625 | 51.43 | 51.4625 | 9184.0 |
| 2019-07-19 08:30:00 | AAPL | Stock | 51.4625 | 51.4975 | 51.4375 | 51.4825 | 15976.0 |
| 2019-07-19 08:35:00 | AAPL | Stock | 51.475 | 51.5025 | 51.4675 | 51.4825 | 32204.0 |
| 2019-07-19 08:40:00 | AAPL | Stock | 51.4825 | 51.5 | 51.455 | 51.475 | 7072.0 |
| 2019-07-19 08:45:00 | AAPL | Stock | 51.475 | 51.5 | 51.475 | 51.4975 | 16400.0 |
| 2019-07-19 08:50:00 | AAPL | Stock | 51.4875 | 51.4875 | 51.4775 | 51.4775 | 6720.0 |
| 2019-07-19 08:55:00 | AAPL | Stock | 51.4775 | 51.5175 | 51.475 | 51.5175 | 14088.0 |
| 2019-07-19 09:00:00 | AAPL | Stock | 51.4975 | 51.5225 | 51.495 | 51.5125 | 15680.0 |
| 2019-07-19 09:05:00 | AAPL | Stock | 51.5 | 51.525 | 51.5 | 51.525 | 8052.0 |
| 2019-07-19 09:10:00 | AAPL | Stock | 51.5425 | 51.55 | 51.5175 | 51.55 | 14620.0 |
| 2019-07-19 09:15:00 | AAPL | Stock | 51.5475 | 51.575 | 51.545 | 51.575 | 21592.0 |
> showing 50 of 350,842 rows — these rows as CSV