PREVIEW / stock_5min / 2018-06-19
file: by_date/stock_5min/2018/2018-06-19.parquet size: 5.7 MB rows: 368,222 symbols: 2,829
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-06-19 04:00:00 | AAPL | Stock | 46.75 | 46.75 | 46.5025 | 46.5775 | 24964.0 |
| 2018-06-19 04:05:00 | AAPL | Stock | 46.5825 | 46.5825 | 46.5825 | 46.5825 | 516.0 |
| 2018-06-19 04:15:00 | AAPL | Stock | 46.6025 | 46.6025 | 46.6025 | 46.6025 | 1200.0 |
| 2018-06-19 04:25:00 | AAPL | Stock | 46.58 | 46.58 | 46.525 | 46.525 | 12516.0 |
| 2018-06-19 04:30:00 | AAPL | Stock | 46.5 | 46.65 | 46.5 | 46.5825 | 27148.0 |
| 2018-06-19 04:40:00 | AAPL | Stock | 46.5825 | 46.5825 | 46.5825 | 46.5825 | 440.0 |
| 2018-06-19 04:45:00 | AAPL | Stock | 46.625 | 46.625 | 46.5275 | 46.5625 | 10800.0 |
| 2018-06-19 04:50:00 | AAPL | Stock | 46.575 | 46.62 | 46.575 | 46.575 | 2000.0 |
| 2018-06-19 04:55:00 | AAPL | Stock | 46.6275 | 46.65 | 46.6275 | 46.65 | 6680.0 |
| 2018-06-19 05:05:00 | AAPL | Stock | 46.6875 | 46.7225 | 46.68 | 46.68 | 2800.0 |
| 2018-06-19 05:10:00 | AAPL | Stock | 46.6875 | 46.6875 | 46.675 | 46.675 | 4884.0 |
| 2018-06-19 05:15:00 | AAPL | Stock | 46.7 | 46.7 | 46.7 | 46.7 | 2100.0 |
| 2018-06-19 05:25:00 | AAPL | Stock | 46.675 | 46.675 | 46.675 | 46.675 | 4000.0 |
| 2018-06-19 05:30:00 | AAPL | Stock | 46.74 | 46.74 | 46.74 | 46.74 | 3792.0 |
| 2018-06-19 05:35:00 | AAPL | Stock | 46.6875 | 46.6875 | 46.6875 | 46.6875 | 3960.0 |
| 2018-06-19 05:45:00 | AAPL | Stock | 46.7075 | 46.7075 | 46.6875 | 46.6975 | 1200.0 |
| 2018-06-19 05:50:00 | AAPL | Stock | 46.7025 | 46.7025 | 46.7025 | 46.7025 | 400.0 |
| 2018-06-19 05:55:00 | AAPL | Stock | 46.7075 | 46.7075 | 46.675 | 46.675 | 2404.0 |
| 2018-06-19 06:00:00 | AAPL | Stock | 46.7025 | 46.7075 | 46.7 | 46.705 | 3456.0 |
| 2018-06-19 06:15:00 | AAPL | Stock | 46.75 | 46.75 | 46.75 | 46.75 | 1816.0 |
| 2018-06-19 06:20:00 | AAPL | Stock | 46.75 | 46.7525 | 46.75 | 46.7525 | 2728.0 |
| 2018-06-19 06:30:00 | AAPL | Stock | 46.795 | 46.8 | 46.755 | 46.755 | 6200.0 |
| 2018-06-19 06:35:00 | AAPL | Stock | 46.7875 | 46.795 | 46.7525 | 46.795 | 4800.0 |
| 2018-06-19 06:40:00 | AAPL | Stock | 46.7775 | 46.7775 | 46.7125 | 46.725 | 9132.0 |
| 2018-06-19 07:00:00 | AAPL | Stock | 46.7 | 46.7825 | 46.6925 | 46.7625 | 24220.0 |
| 2018-06-19 07:05:00 | AAPL | Stock | 46.79 | 46.825 | 46.79 | 46.8225 | 20980.0 |
| 2018-06-19 07:10:00 | AAPL | Stock | 46.8225 | 46.825 | 46.7875 | 46.8125 | 7540.0 |
| 2018-06-19 07:15:00 | AAPL | Stock | 46.78 | 46.7975 | 46.775 | 46.795 | 21344.0 |
| 2018-06-19 07:20:00 | AAPL | Stock | 46.775 | 46.7775 | 46.725 | 46.725 | 23808.0 |
| 2018-06-19 07:25:00 | AAPL | Stock | 46.725 | 46.725 | 46.635 | 46.635 | 34744.0 |
| 2018-06-19 07:30:00 | AAPL | Stock | 46.635 | 46.6775 | 46.6275 | 46.6775 | 13980.0 |
| 2018-06-19 07:35:00 | AAPL | Stock | 46.64 | 46.6625 | 46.6125 | 46.635 | 35796.0 |
| 2018-06-19 07:40:00 | AAPL | Stock | 46.65 | 46.65 | 46.6375 | 46.6425 | 14060.0 |
| 2018-06-19 07:45:00 | AAPL | Stock | 46.6375 | 46.65 | 46.625 | 46.65 | 57308.0 |
| 2018-06-19 07:50:00 | AAPL | Stock | 46.6625 | 46.725 | 46.6625 | 46.725 | 39424.0 |
| 2018-06-19 07:55:00 | AAPL | Stock | 46.715 | 46.7425 | 46.7125 | 46.725 | 6700.0 |
| 2018-06-19 08:00:00 | AAPL | Stock | 46.75 | 46.8225 | 46.6175 | 46.6175 | 98020.0 |
| 2018-06-19 08:05:00 | AAPL | Stock | 46.615 | 46.6625 | 46.5752 | 46.6525 | 106804.0 |
| 2018-06-19 08:10:00 | AAPL | Stock | 46.6575 | 46.66 | 46.6 | 46.6025 | 84112.0 |
| 2018-06-19 08:15:00 | AAPL | Stock | 46.6025 | 46.6025 | 46.55 | 46.5725 | 63884.0 |
| 2018-06-19 08:20:00 | AAPL | Stock | 46.5725 | 46.5725 | 46.5275 | 46.55 | 62688.0 |
| 2018-06-19 08:25:00 | AAPL | Stock | 46.5525 | 46.555 | 46.5175 | 46.5375 | 88776.0 |
| 2018-06-19 08:30:00 | AAPL | Stock | 46.5275 | 46.5375 | 46.475 | 46.5 | 129004.0 |
| 2018-06-19 08:35:00 | AAPL | Stock | 46.5 | 46.545 | 46.4875 | 46.5 | 39880.0 |
| 2018-06-19 08:40:00 | AAPL | Stock | 46.475 | 46.5125 | 46.4375 | 46.485 | 110104.0 |
| 2018-06-19 08:45:00 | AAPL | Stock | 46.5 | 46.5225 | 46.4875 | 46.5 | 33368.0 |
| 2018-06-19 08:50:00 | AAPL | Stock | 46.4975 | 46.5475 | 46.4825 | 46.5475 | 85204.0 |
| 2018-06-19 08:55:00 | AAPL | Stock | 46.545 | 46.595 | 46.49 | 46.5 | 136328.0 |
| 2018-06-19 09:00:00 | AAPL | Stock | 46.505 | 46.6075 | 46.505 | 46.5925 | 72504.0 |
| 2018-06-19 09:05:00 | AAPL | Stock | 46.6025 | 46.6475 | 46.5725 | 46.5875 | 56068.0 |
> showing 50 of 368,222 rows — these rows as CSV