PREVIEW / stock_5min / 2019-04-08
file: by_date/stock_5min/2019/2019-04-08.parquet size: 5.6 MB rows: 355,635 symbols: 2,651
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-04-08 04:10:00 | AAPL | Stock | 49.0875 | 49.0875 | 49.0675 | 49.0875 | 2980.0 |
| 2019-04-08 04:25:00 | AAPL | Stock | 49.0875 | 49.0875 | 49.0875 | 49.0875 | 400.0 |
| 2019-04-08 04:30:00 | AAPL | Stock | 49.075 | 49.075 | 49.0675 | 49.0675 | 1164.0 |
| 2019-04-08 04:40:00 | AAPL | Stock | 49.1225 | 49.1225 | 49.1225 | 49.1225 | 400.0 |
| 2019-04-08 04:45:00 | AAPL | Stock | 49.15 | 49.15 | 49.15 | 49.15 | 1076.0 |
| 2019-04-08 05:00:00 | AAPL | Stock | 49.15 | 49.15 | 49.15 | 49.15 | 400.0 |
| 2019-04-08 05:30:00 | AAPL | Stock | 49.1625 | 49.18 | 49.1625 | 49.18 | 2800.0 |
| 2019-04-08 05:45:00 | AAPL | Stock | 49.0825 | 49.0825 | 49.075 | 49.075 | 4000.0 |
| 2019-04-08 06:15:00 | AAPL | Stock | 49.095 | 49.095 | 49.095 | 49.095 | 800.0 |
| 2019-04-08 06:20:00 | AAPL | Stock | 49.12 | 49.125 | 49.1 | 49.1 | 6072.0 |
| 2019-04-08 06:30:00 | AAPL | Stock | 49.13 | 49.13 | 49.13 | 49.13 | 924.0 |
| 2019-04-08 06:40:00 | AAPL | Stock | 49.13 | 49.13 | 49.1 | 49.1 | 4276.0 |
| 2019-04-08 07:00:00 | AAPL | Stock | 49.16 | 49.16 | 49.1 | 49.125 | 3988.0 |
| 2019-04-08 07:05:00 | AAPL | Stock | 49.1125 | 49.1125 | 49.1125 | 49.1125 | 1080.0 |
| 2019-04-08 07:10:00 | AAPL | Stock | 49.1 | 49.1 | 49.1 | 49.1 | 4036.0 |
| 2019-04-08 07:15:00 | AAPL | Stock | 49.11 | 49.1125 | 49.0875 | 49.0875 | 3288.0 |
| 2019-04-08 07:20:00 | AAPL | Stock | 49.05 | 49.07 | 49.05 | 49.0625 | 3892.0 |
| 2019-04-08 07:25:00 | AAPL | Stock | 49.0775 | 49.085 | 49.0575 | 49.0725 | 2800.0 |
| 2019-04-08 07:30:00 | AAPL | Stock | 49.0775 | 49.115 | 49.075 | 49.1125 | 14828.0 |
| 2019-04-08 07:40:00 | AAPL | Stock | 49.095 | 49.11 | 49.095 | 49.11 | 1664.0 |
| 2019-04-08 07:45:00 | AAPL | Stock | 49.1 | 49.11 | 49.1 | 49.11 | 2000.0 |
| 2019-04-08 07:50:00 | AAPL | Stock | 49.1025 | 49.1275 | 49.1025 | 49.1275 | 5204.0 |
| 2019-04-08 08:00:00 | AAPL | Stock | 49.145 | 49.3725 | 49.075 | 49.1725 | 28672.0 |
| 2019-04-08 08:05:00 | AAPL | Stock | 49.15 | 49.15 | 49.12 | 49.12 | 16652.0 |
| 2019-04-08 08:10:00 | AAPL | Stock | 49.125 | 49.1425 | 49.12 | 49.12 | 8800.0 |
| 2019-04-08 08:15:00 | AAPL | Stock | 49.12 | 49.12 | 49.0625 | 49.063 | 10544.0 |
| 2019-04-08 08:20:00 | AAPL | Stock | 49.065 | 49.075 | 49.0625 | 49.075 | 3200.0 |
| 2019-04-08 08:25:00 | AAPL | Stock | 49.07 | 49.0725 | 49.0325 | 49.0325 | 11964.0 |
| 2019-04-08 08:30:00 | AAPL | Stock | 49.04 | 49.04 | 49.04 | 49.04 | 4908.0 |
| 2019-04-08 08:35:00 | AAPL | Stock | 49.04 | 49.0875 | 49.04 | 49.0848 | 7080.0 |
| 2019-04-08 08:40:00 | AAPL | Stock | 49.0425 | 49.0625 | 49.04 | 49.0625 | 8488.0 |
| 2019-04-08 08:45:00 | AAPL | Stock | 49.0625 | 49.0835 | 49.0625 | 49.0625 | 10340.0 |
| 2019-04-08 08:50:00 | AAPL | Stock | 49.065 | 49.075 | 49.0375 | 49.04 | 19916.0 |
| 2019-04-08 08:55:00 | AAPL | Stock | 49.0725 | 49.0725 | 49.0375 | 49.0475 | 9484.0 |
| 2019-04-08 09:00:00 | AAPL | Stock | 49.045 | 49.05 | 49.0325 | 49.05 | 9864.0 |
| 2019-04-08 09:05:00 | AAPL | Stock | 49.07 | 49.0875 | 49.0625 | 49.075 | 10776.0 |
| 2019-04-08 09:10:00 | AAPL | Stock | 49.075 | 49.1 | 49.0575 | 49.08 | 16820.0 |
| 2019-04-08 09:15:00 | AAPL | Stock | 49.0775 | 49.1025 | 49.075 | 49.0975 | 11916.0 |
| 2019-04-08 09:20:00 | AAPL | Stock | 49.1225 | 49.1225 | 49.075 | 49.1 | 8196.0 |
| 2019-04-08 09:25:00 | AAPL | Stock | 49.075 | 49.1325 | 49.075 | 49.13 | 20284.0 |
| 2019-04-08 09:30:00 | AAPL | Stock | 49.105 | 49.3558 | 49.085 | 49.215 | 3804892.0 |
| 2019-04-08 09:35:00 | AAPL | Stock | 49.2218 | 49.4125 | 49.2218 | 49.3875 | 2354788.0 |
| 2019-04-08 09:40:00 | AAPL | Stock | 49.3925 | 49.47 | 49.3595 | 49.4208 | 1909404.0 |
| 2019-04-08 09:45:00 | AAPL | Stock | 49.4175 | 49.4625 | 49.34 | 49.45 | 1632720.0 |
| 2019-04-08 09:50:00 | AAPL | Stock | 49.45 | 49.4525 | 49.3225 | 49.3525 | 1178944.0 |
| 2019-04-08 09:55:00 | AAPL | Stock | 49.3575 | 49.4768 | 49.355 | 49.4475 | 1342696.0 |
| 2019-04-08 10:00:00 | AAPL | Stock | 49.4475 | 49.4475 | 49.34 | 49.35 | 1146492.0 |
| 2019-04-08 10:05:00 | AAPL | Stock | 49.3508 | 49.3775 | 49.2975 | 49.325 | 1470228.0 |
| 2019-04-08 10:10:00 | AAPL | Stock | 49.32 | 49.4 | 49.3075 | 49.3875 | 1027000.0 |
| 2019-04-08 10:15:00 | AAPL | Stock | 49.39 | 49.422 | 49.3725 | 49.4018 | 782544.0 |
> showing 50 of 355,635 rows — these rows as CSV