PREVIEW / stock_5min / 2018-01-29
file: by_date/stock_5min/2018/2018-01-29.parquet size: 5.9 MB rows: 374,640 symbols: 2,913
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-01-29 04:00:00 | AAPL | Stock | 42.8725 | 43.0 | 42.8725 | 42.8875 | 4768.0 |
| 2018-01-29 04:05:00 | AAPL | Stock | 42.8875 | 42.925 | 42.8875 | 42.925 | 8496.0 |
| 2018-01-29 04:10:00 | AAPL | Stock | 43.0 | 43.0 | 43.0 | 43.0 | 4400.0 |
| 2018-01-29 04:15:00 | AAPL | Stock | 43.0 | 43.0025 | 43.0 | 43.0025 | 1000.0 |
| 2018-01-29 04:20:00 | AAPL | Stock | 43.0125 | 43.1 | 43.0125 | 43.065 | 13528.0 |
| 2018-01-29 04:25:00 | AAPL | Stock | 43.115 | 43.1225 | 43.115 | 43.1225 | 5056.0 |
| 2018-01-29 04:30:00 | AAPL | Stock | 43.1275 | 43.15 | 43.1275 | 43.14 | 22532.0 |
| 2018-01-29 04:35:00 | AAPL | Stock | 43.135 | 43.14 | 43.0625 | 43.0625 | 20312.0 |
| 2018-01-29 04:40:00 | AAPL | Stock | 43.0025 | 43.0025 | 43.0025 | 43.0025 | 3996.0 |
| 2018-01-29 04:50:00 | AAPL | Stock | 43.0025 | 43.0025 | 42.95 | 42.95 | 13208.0 |
| 2018-01-29 04:55:00 | AAPL | Stock | 42.9975 | 42.9975 | 42.9975 | 42.9975 | 800.0 |
| 2018-01-29 05:00:00 | AAPL | Stock | 42.9525 | 42.9525 | 42.95 | 42.95 | 14728.0 |
| 2018-01-29 05:05:00 | AAPL | Stock | 43.045 | 43.05 | 42.895 | 42.92 | 45032.0 |
| 2018-01-29 05:10:00 | AAPL | Stock | 42.92 | 42.9475 | 42.7525 | 42.765 | 21860.0 |
| 2018-01-29 05:15:00 | AAPL | Stock | 42.775 | 42.775 | 42.75 | 42.775 | 19228.0 |
| 2018-01-29 05:20:00 | AAPL | Stock | 42.8 | 42.8 | 42.8 | 42.8 | 532.0 |
| 2018-01-29 05:40:00 | AAPL | Stock | 42.795 | 42.795 | 42.705 | 42.705 | 13256.0 |
| 2018-01-29 05:45:00 | AAPL | Stock | 42.7075 | 42.7075 | 42.7075 | 42.7075 | 4000.0 |
| 2018-01-29 05:50:00 | AAPL | Stock | 42.7075 | 42.7525 | 42.7075 | 42.7525 | 7160.0 |
| 2018-01-29 05:55:00 | AAPL | Stock | 42.7275 | 42.7325 | 42.7275 | 42.7275 | 8172.0 |
| 2018-01-29 06:00:00 | AAPL | Stock | 42.7125 | 42.7125 | 42.695 | 42.695 | 3000.0 |
| 2018-01-29 06:10:00 | AAPL | Stock | 42.695 | 42.695 | 42.6825 | 42.685 | 18560.0 |
| 2018-01-29 06:15:00 | AAPL | Stock | 42.655 | 42.655 | 42.62 | 42.62 | 9500.0 |
| 2018-01-29 06:20:00 | AAPL | Stock | 42.63 | 42.6375 | 42.63 | 42.6375 | 7800.0 |
| 2018-01-29 06:25:00 | AAPL | Stock | 42.64 | 42.7 | 42.615 | 42.625 | 22916.0 |
| 2018-01-29 06:30:00 | AAPL | Stock | 42.6625 | 42.675 | 42.63 | 42.645 | 7592.0 |
| 2018-01-29 06:35:00 | AAPL | Stock | 42.675 | 42.6825 | 42.675 | 42.6825 | 6400.0 |
| 2018-01-29 06:40:00 | AAPL | Stock | 42.6625 | 42.7 | 42.6625 | 42.7 | 5600.0 |
| 2018-01-29 06:45:00 | AAPL | Stock | 42.6675 | 42.6675 | 42.6675 | 42.6675 | 400.0 |
| 2018-01-29 06:50:00 | AAPL | Stock | 42.675 | 42.68 | 42.6725 | 42.68 | 4000.0 |
| 2018-01-29 06:55:00 | AAPL | Stock | 42.725 | 42.7275 | 42.725 | 42.7275 | 2984.0 |
| 2018-01-29 07:00:00 | AAPL | Stock | 42.73 | 42.7375 | 42.6875 | 42.695 | 52432.0 |
| 2018-01-29 07:05:00 | AAPL | Stock | 42.69 | 42.7075 | 42.6875 | 42.6875 | 17356.0 |
| 2018-01-29 07:10:00 | AAPL | Stock | 42.6875 | 42.7125 | 42.6825 | 42.695 | 53236.0 |
| 2018-01-29 07:15:00 | AAPL | Stock | 42.7025 | 42.7025 | 42.6625 | 42.6625 | 60452.0 |
| 2018-01-29 07:20:00 | AAPL | Stock | 42.6675 | 42.6975 | 42.6675 | 42.685 | 17776.0 |
| 2018-01-29 07:25:00 | AAPL | Stock | 42.675 | 42.7125 | 42.6675 | 42.675 | 44240.0 |
| 2018-01-29 07:30:00 | AAPL | Stock | 42.675 | 42.675 | 42.6525 | 42.6725 | 41976.0 |
| 2018-01-29 07:35:00 | AAPL | Stock | 42.6475 | 42.67 | 42.645 | 42.6475 | 24928.0 |
| 2018-01-29 07:40:00 | AAPL | Stock | 42.6475 | 42.6525 | 42.6375 | 42.65 | 43020.0 |
| 2018-01-29 07:45:00 | AAPL | Stock | 42.6475 | 42.65 | 42.63 | 42.6375 | 6160.0 |
| 2018-01-29 07:50:00 | AAPL | Stock | 42.65 | 42.675 | 42.65 | 42.675 | 15580.0 |
| 2018-01-29 07:55:00 | AAPL | Stock | 42.675 | 42.7 | 42.6725 | 42.685 | 42668.0 |
| 2018-01-29 08:00:00 | AAPL | Stock | 42.665 | 42.7375 | 42.63 | 42.66 | 146264.0 |
| 2018-01-29 08:05:00 | AAPL | Stock | 42.65 | 42.655 | 42.6375 | 42.64 | 26200.0 |
| 2018-01-29 08:10:00 | AAPL | Stock | 42.65 | 42.6625 | 42.63 | 42.6425 | 56012.0 |
| 2018-01-29 08:15:00 | AAPL | Stock | 42.64 | 42.65 | 42.625 | 42.6375 | 111452.0 |
| 2018-01-29 08:20:00 | AAPL | Stock | 42.64 | 42.645 | 42.6 | 42.605 | 34068.0 |
| 2018-01-29 08:25:00 | AAPL | Stock | 42.6 | 42.6125 | 42.575 | 42.575 | 91904.0 |
| 2018-01-29 08:30:00 | AAPL | Stock | 42.575 | 42.5975 | 42.55 | 42.55 | 99396.0 |
> showing 50 of 374,640 rows — these rows as CSV