PREVIEW / stock_5min / 2018-08-15
file: by_date/stock_5min/2018/2018-08-15.parquet size: 5.6 MB rows: 354,066 symbols: 2,796
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-15 04:00:00 | AAPL | Stock | 52.5 | 52.5 | 52.5 | 52.5 | 2400.0 |
| 2018-08-15 04:05:00 | AAPL | Stock | 52.5 | 52.525 | 52.5 | 52.525 | 4272.0 |
| 2018-08-15 04:25:00 | AAPL | Stock | 52.5575 | 52.5625 | 52.5575 | 52.5625 | 1700.0 |
| 2018-08-15 04:35:00 | AAPL | Stock | 52.61 | 52.61 | 52.61 | 52.61 | 780.0 |
| 2018-08-15 04:40:00 | AAPL | Stock | 52.625 | 52.635 | 52.625 | 52.625 | 3372.0 |
| 2018-08-15 04:45:00 | AAPL | Stock | 52.625 | 52.625 | 52.62 | 52.62 | 2800.0 |
| 2018-08-15 05:00:00 | AAPL | Stock | 52.6225 | 52.6225 | 52.5625 | 52.5625 | 1144.0 |
| 2018-08-15 05:05:00 | AAPL | Stock | 52.5625 | 52.5625 | 52.5625 | 52.5625 | 2056.0 |
| 2018-08-15 05:10:00 | AAPL | Stock | 52.615 | 52.615 | 52.615 | 52.615 | 1668.0 |
| 2018-08-15 05:15:00 | AAPL | Stock | 52.61 | 52.61 | 52.6075 | 52.6075 | 2052.0 |
| 2018-08-15 05:20:00 | AAPL | Stock | 52.605 | 52.605 | 52.605 | 52.605 | 400.0 |
| 2018-08-15 05:30:00 | AAPL | Stock | 52.595 | 52.595 | 52.595 | 52.595 | 400.0 |
| 2018-08-15 05:35:00 | AAPL | Stock | 52.595 | 52.595 | 52.595 | 52.595 | 1032.0 |
| 2018-08-15 05:50:00 | AAPL | Stock | 52.55 | 52.55 | 52.5475 | 52.5475 | 1948.0 |
| 2018-08-15 05:55:00 | AAPL | Stock | 52.515 | 52.515 | 52.5 | 52.5 | 2560.0 |
| 2018-08-15 06:00:00 | AAPL | Stock | 52.55 | 52.5825 | 52.55 | 52.5825 | 1164.0 |
| 2018-08-15 06:05:00 | AAPL | Stock | 52.5125 | 52.55 | 52.5125 | 52.515 | 4320.0 |
| 2018-08-15 06:10:00 | AAPL | Stock | 52.525 | 52.525 | 52.525 | 52.525 | 1600.0 |
| 2018-08-15 06:15:00 | AAPL | Stock | 52.525 | 52.525 | 52.465 | 52.4925 | 9124.0 |
| 2018-08-15 06:20:00 | AAPL | Stock | 52.475 | 52.4875 | 52.4625 | 52.4625 | 10476.0 |
| 2018-08-15 06:25:00 | AAPL | Stock | 52.48 | 52.48 | 52.48 | 52.48 | 400.0 |
| 2018-08-15 06:30:00 | AAPL | Stock | 52.4375 | 52.4375 | 52.3775 | 52.4225 | 2200.0 |
| 2018-08-15 06:35:00 | AAPL | Stock | 52.385 | 52.385 | 52.3775 | 52.3775 | 11176.0 |
| 2018-08-15 06:45:00 | AAPL | Stock | 52.3325 | 52.3325 | 52.3325 | 52.3325 | 640.0 |
| 2018-08-15 06:50:00 | AAPL | Stock | 52.27 | 52.3125 | 52.255 | 52.31 | 21268.0 |
| 2018-08-15 06:55:00 | AAPL | Stock | 52.2875 | 52.2875 | 52.27 | 52.27 | 7276.0 |
| 2018-08-15 07:00:00 | AAPL | Stock | 52.3075 | 52.3125 | 52.25 | 52.2975 | 54916.0 |
| 2018-08-15 07:05:00 | AAPL | Stock | 52.3175 | 52.3175 | 52.2775 | 52.3 | 9364.0 |
| 2018-08-15 07:10:00 | AAPL | Stock | 52.29 | 52.3175 | 52.1875 | 52.22 | 125284.0 |
| 2018-08-15 07:15:00 | AAPL | Stock | 52.215 | 52.2375 | 52.215 | 52.2175 | 11580.0 |
| 2018-08-15 07:20:00 | AAPL | Stock | 52.2125 | 52.225 | 52.14 | 52.14 | 22136.0 |
| 2018-08-15 07:25:00 | AAPL | Stock | 52.14 | 52.15 | 52.0925 | 52.095 | 129640.0 |
| 2018-08-15 07:30:00 | AAPL | Stock | 52.1 | 52.1 | 52.0375 | 52.0675 | 35364.0 |
| 2018-08-15 07:35:00 | AAPL | Stock | 52.0575 | 52.085 | 52.05 | 52.0825 | 14128.0 |
| 2018-08-15 07:40:00 | AAPL | Stock | 52.0825 | 52.0825 | 52.0275 | 52.0425 | 16052.0 |
| 2018-08-15 07:45:00 | AAPL | Stock | 52.0425 | 52.095 | 52.025 | 52.08 | 155408.0 |
| 2018-08-15 07:50:00 | AAPL | Stock | 52.0775 | 52.085 | 52.0 | 52.05 | 67040.0 |
| 2018-08-15 07:55:00 | AAPL | Stock | 52.05 | 52.05 | 52.0 | 52.0475 | 147600.0 |
| 2018-08-15 08:00:00 | AAPL | Stock | 52.275 | 52.3125 | 52.0175 | 52.085 | 109936.0 |
| 2018-08-15 08:05:00 | AAPL | Stock | 52.0825 | 52.15 | 52.075 | 52.125 | 89108.0 |
| 2018-08-15 08:10:00 | AAPL | Stock | 52.1375 | 52.1375 | 52.1 | 52.1 | 14852.0 |
| 2018-08-15 08:15:00 | AAPL | Stock | 52.1125 | 52.1125 | 52.0875 | 52.0975 | 15432.0 |
| 2018-08-15 08:20:00 | AAPL | Stock | 52.0975 | 52.1225 | 52.0975 | 52.12 | 42784.0 |
| 2018-08-15 08:25:00 | AAPL | Stock | 52.1225 | 52.15 | 52.1225 | 52.1475 | 34556.0 |
| 2018-08-15 08:30:00 | AAPL | Stock | 52.145 | 52.1475 | 52.11 | 52.1125 | 61488.0 |
| 2018-08-15 08:35:00 | AAPL | Stock | 52.1125 | 52.125 | 52.075 | 52.1225 | 20844.0 |
| 2018-08-15 08:40:00 | AAPL | Stock | 52.1225 | 52.1225 | 52.075 | 52.1075 | 7984.0 |
| 2018-08-15 08:45:00 | AAPL | Stock | 52.075 | 52.105 | 52.075 | 52.0875 | 18796.0 |
| 2018-08-15 08:50:00 | AAPL | Stock | 52.075 | 52.075 | 52.05 | 52.0675 | 26920.0 |
| 2018-08-15 08:55:00 | AAPL | Stock | 52.0775 | 52.11 | 52.075 | 52.11 | 16024.0 |
> showing 50 of 354,066 rows — these rows as CSV