PREVIEW / stock_5min / 2018-09-07
file: by_date/stock_5min/2018/2018-09-07.parquet size: 5.5 MB rows: 352,073 symbols: 2,783
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-09-07 04:35:00 | AAPL | Stock | 55.885 | 55.885 | 55.885 | 55.885 | 400.0 |
| 2018-09-07 04:55:00 | AAPL | Stock | 55.825 | 55.825 | 55.825 | 55.825 | 400.0 |
| 2018-09-07 05:15:00 | AAPL | Stock | 55.875 | 55.875 | 55.875 | 55.875 | 480.0 |
| 2018-09-07 05:20:00 | AAPL | Stock | 55.875 | 55.875 | 55.875 | 55.875 | 400.0 |
| 2018-09-07 05:25:00 | AAPL | Stock | 55.875 | 55.875 | 55.875 | 55.875 | 1200.0 |
| 2018-09-07 05:35:00 | AAPL | Stock | 55.93 | 55.9625 | 55.93 | 55.9625 | 27704.0 |
| 2018-09-07 05:45:00 | AAPL | Stock | 55.9125 | 55.9125 | 55.9125 | 55.9125 | 4932.0 |
| 2018-09-07 05:50:00 | AAPL | Stock | 55.8875 | 55.8875 | 55.88 | 55.88 | 1212.0 |
| 2018-09-07 06:00:00 | AAPL | Stock | 55.8525 | 55.8525 | 55.85 | 55.85 | 4800.0 |
| 2018-09-07 06:05:00 | AAPL | Stock | 55.88 | 55.88 | 55.875 | 55.875 | 3920.0 |
| 2018-09-07 06:10:00 | AAPL | Stock | 55.93 | 55.93 | 55.93 | 55.93 | 1612.0 |
| 2018-09-07 06:20:00 | AAPL | Stock | 55.8975 | 55.8975 | 55.8975 | 55.8975 | 2808.0 |
| 2018-09-07 06:25:00 | AAPL | Stock | 55.92 | 55.9425 | 55.92 | 55.9425 | 2064.0 |
| 2018-09-07 06:30:00 | AAPL | Stock | 55.95 | 55.95 | 55.95 | 55.95 | 3600.0 |
| 2018-09-07 06:40:00 | AAPL | Stock | 55.9325 | 55.9325 | 55.925 | 55.925 | 2000.0 |
| 2018-09-07 06:45:00 | AAPL | Stock | 55.925 | 55.925 | 55.925 | 55.925 | 2432.0 |
| 2018-09-07 06:55:00 | AAPL | Stock | 55.95 | 55.95 | 55.95 | 55.95 | 400.0 |
| 2018-09-07 07:00:00 | AAPL | Stock | 55.895 | 55.9475 | 55.875 | 55.9375 | 38876.0 |
| 2018-09-07 07:05:00 | AAPL | Stock | 55.92 | 55.9575 | 55.85 | 55.875 | 29168.0 |
| 2018-09-07 07:10:00 | AAPL | Stock | 55.8575 | 55.875 | 55.855 | 55.8625 | 11220.0 |
| 2018-09-07 07:15:00 | AAPL | Stock | 55.875 | 55.875 | 55.8675 | 55.8725 | 5400.0 |
| 2018-09-07 07:20:00 | AAPL | Stock | 55.84 | 55.8625 | 55.84 | 55.845 | 7428.0 |
| 2018-09-07 07:25:00 | AAPL | Stock | 55.845 | 55.845 | 55.8375 | 55.8375 | 21792.0 |
| 2018-09-07 07:30:00 | AAPL | Stock | 55.8325 | 55.8375 | 55.8125 | 55.8125 | 15384.0 |
| 2018-09-07 07:35:00 | AAPL | Stock | 55.8375 | 55.8375 | 55.8325 | 55.835 | 2016.0 |
| 2018-09-07 07:40:00 | AAPL | Stock | 55.83 | 55.835 | 55.8175 | 55.8175 | 4816.0 |
| 2018-09-07 07:45:00 | AAPL | Stock | 55.83 | 55.8375 | 55.825 | 55.8375 | 12516.0 |
| 2018-09-07 07:50:00 | AAPL | Stock | 55.8375 | 55.8375 | 55.8375 | 55.8375 | 2000.0 |
| 2018-09-07 07:55:00 | AAPL | Stock | 55.8375 | 55.8375 | 55.78 | 55.78 | 21568.0 |
| 2018-09-07 08:00:00 | AAPL | Stock | 55.8875 | 55.9625 | 55.725 | 55.7375 | 101380.0 |
| 2018-09-07 08:05:00 | AAPL | Stock | 55.75 | 55.75 | 55.7325 | 55.7325 | 5264.0 |
| 2018-09-07 08:10:00 | AAPL | Stock | 55.735 | 55.755 | 55.715 | 55.755 | 7520.0 |
| 2018-09-07 08:15:00 | AAPL | Stock | 55.7525 | 55.8075 | 55.7525 | 55.765 | 21568.0 |
| 2018-09-07 08:20:00 | AAPL | Stock | 55.76 | 55.8125 | 55.75 | 55.765 | 12108.0 |
| 2018-09-07 08:25:00 | AAPL | Stock | 55.765 | 55.825 | 55.765 | 55.8 | 19748.0 |
| 2018-09-07 08:30:00 | AAPL | Stock | 55.7825 | 55.7825 | 55.62 | 55.62 | 47176.0 |
| 2018-09-07 08:35:00 | AAPL | Stock | 55.62 | 55.6375 | 55.5825 | 55.59 | 40900.0 |
| 2018-09-07 08:40:00 | AAPL | Stock | 55.59 | 55.6375 | 55.5875 | 55.6275 | 58448.0 |
| 2018-09-07 08:45:00 | AAPL | Stock | 55.6325 | 55.6575 | 55.5625 | 55.575 | 153604.0 |
| 2018-09-07 08:50:00 | AAPL | Stock | 55.5775 | 55.65 | 55.5775 | 55.6225 | 57896.0 |
| 2018-09-07 08:55:00 | AAPL | Stock | 55.62 | 55.625 | 55.5875 | 55.595 | 39276.0 |
| 2018-09-07 09:00:00 | AAPL | Stock | 55.59 | 55.59 | 55.4475 | 55.4525 | 143048.0 |
| 2018-09-07 09:05:00 | AAPL | Stock | 55.465 | 55.465 | 55.385 | 55.4225 | 96912.0 |
| 2018-09-07 09:10:00 | AAPL | Stock | 55.4375 | 55.5375 | 55.4225 | 55.5375 | 102304.0 |
| 2018-09-07 09:15:00 | AAPL | Stock | 55.5225 | 55.5475 | 55.4975 | 55.5475 | 25388.0 |
| 2018-09-07 09:20:00 | AAPL | Stock | 55.5375 | 55.545 | 55.5125 | 55.5425 | 15124.0 |
| 2018-09-07 09:25:00 | AAPL | Stock | 55.5025 | 55.5325 | 55.4525 | 55.5 | 48112.0 |
| 2018-09-07 09:30:00 | AAPL | Stock | 55.4625 | 55.91 | 55.385 | 55.8835 | 4548236.0 |
| 2018-09-07 09:35:00 | AAPL | Stock | 55.885 | 55.9 | 55.6275 | 55.7675 | 2611192.0 |
| 2018-09-07 09:40:00 | AAPL | Stock | 55.7675 | 55.845 | 55.7125 | 55.7625 | 2590952.0 |
> showing 50 of 352,073 rows — these rows as CSV