PREVIEW / stock_5min / 2019-10-18
file: by_date/stock_5min/2019/2019-10-18.parquet size: 5.5 MB rows: 349,387 symbols: 2,488
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-10-18 04:00:00 | AAPL | Stock | 58.84 | 58.84 | 58.7625 | 58.7625 | 1072.0 |
| 2019-10-18 04:20:00 | AAPL | Stock | 58.7275 | 58.7275 | 58.7275 | 58.7275 | 716.0 |
| 2019-10-18 04:35:00 | AAPL | Stock | 58.7275 | 58.7275 | 58.7275 | 58.7275 | 664.0 |
| 2019-10-18 06:15:00 | AAPL | Stock | 58.75 | 58.75 | 58.75 | 58.75 | 600.0 |
| 2019-10-18 06:40:00 | AAPL | Stock | 58.8125 | 58.8125 | 58.75 | 58.75 | 2400.0 |
| 2019-10-18 07:00:00 | AAPL | Stock | 58.7925 | 58.825 | 58.7875 | 58.825 | 17032.0 |
| 2019-10-18 07:05:00 | AAPL | Stock | 58.83 | 58.8375 | 58.82 | 58.835 | 17828.0 |
| 2019-10-18 07:10:00 | AAPL | Stock | 58.8225 | 58.8625 | 58.8225 | 58.8625 | 5184.0 |
| 2019-10-18 07:15:00 | AAPL | Stock | 58.85 | 58.85 | 58.85 | 58.85 | 2000.0 |
| 2019-10-18 07:25:00 | AAPL | Stock | 58.835 | 58.835 | 58.835 | 58.835 | 400.0 |
| 2019-10-18 07:30:00 | AAPL | Stock | 58.8375 | 58.8375 | 58.8375 | 58.8375 | 2000.0 |
| 2019-10-18 07:35:00 | AAPL | Stock | 58.8425 | 58.8425 | 58.8375 | 58.8375 | 1356.0 |
| 2019-10-18 07:40:00 | AAPL | Stock | 58.8375 | 58.8375 | 58.8375 | 58.8375 | 1184.0 |
| 2019-10-18 07:50:00 | AAPL | Stock | 58.8425 | 58.8475 | 58.8425 | 58.8475 | 1296.0 |
| 2019-10-18 07:55:00 | AAPL | Stock | 58.85 | 58.855 | 58.85 | 58.855 | 1600.0 |
| 2019-10-18 08:00:00 | AAPL | Stock | 58.865 | 58.865 | 58.7875 | 58.855 | 34772.0 |
| 2019-10-18 08:05:00 | AAPL | Stock | 58.845 | 58.85 | 58.845 | 58.85 | 960.0 |
| 2019-10-18 08:10:00 | AAPL | Stock | 58.845 | 58.86 | 58.845 | 58.8452 | 10800.0 |
| 2019-10-18 08:20:00 | AAPL | Stock | 58.8375 | 58.8375 | 58.8375 | 58.8375 | 400.0 |
| 2019-10-18 08:25:00 | AAPL | Stock | 58.8575 | 58.8625 | 58.855 | 58.8625 | 4376.0 |
| 2019-10-18 08:30:00 | AAPL | Stock | 58.8525 | 58.865 | 58.84 | 58.865 | 17800.0 |
| 2019-10-18 08:35:00 | AAPL | Stock | 58.865 | 58.865 | 58.8375 | 58.8475 | 10416.0 |
| 2019-10-18 08:40:00 | AAPL | Stock | 58.85 | 58.85 | 58.84 | 58.84 | 1600.0 |
| 2019-10-18 08:45:00 | AAPL | Stock | 58.84 | 58.85 | 58.755 | 58.7875 | 39508.0 |
| 2019-10-18 08:50:00 | AAPL | Stock | 58.7925 | 58.8 | 58.7925 | 58.8 | 3100.0 |
| 2019-10-18 08:55:00 | AAPL | Stock | 58.775 | 58.7975 | 58.775 | 58.7875 | 2484.0 |
| 2019-10-18 09:00:00 | AAPL | Stock | 58.7875 | 58.7875 | 58.755 | 58.765 | 11260.0 |
| 2019-10-18 09:05:00 | AAPL | Stock | 58.755 | 58.7625 | 58.755 | 58.755 | 7740.0 |
| 2019-10-18 09:10:00 | AAPL | Stock | 58.7525 | 58.76 | 58.7525 | 58.7575 | 3400.0 |
| 2019-10-18 09:15:00 | AAPL | Stock | 58.7675 | 58.7675 | 58.76 | 58.76 | 4800.0 |
| 2019-10-18 09:20:00 | AAPL | Stock | 58.76 | 58.76 | 58.7 | 58.7 | 18224.0 |
| 2019-10-18 09:25:00 | AAPL | Stock | 58.7 | 58.77 | 58.59 | 58.59 | 163280.0 |
| 2019-10-18 09:30:00 | AAPL | Stock | 58.59 | 58.7725 | 58.59 | 58.7575 | 8599120.0 |
| 2019-10-18 09:35:00 | AAPL | Stock | 58.765 | 58.825 | 58.7075 | 58.82 | 961600.0 |
| 2019-10-18 09:40:00 | AAPL | Stock | 58.8175 | 58.835 | 58.725 | 58.7945 | 964612.0 |
| 2019-10-18 09:45:00 | AAPL | Stock | 58.7975 | 58.9425 | 58.7875 | 58.8925 | 1201408.0 |
| 2019-10-18 09:50:00 | AAPL | Stock | 58.895 | 58.9575 | 58.86 | 58.9455 | 992840.0 |
| 2019-10-18 09:55:00 | AAPL | Stock | 58.9475 | 59.005 | 58.9038 | 58.98 | 1671856.0 |
| 2019-10-18 10:00:00 | AAPL | Stock | 58.9775 | 59.0025 | 58.9075 | 58.945 | 1146132.0 |
| 2019-10-18 10:05:00 | AAPL | Stock | 58.94 | 59.0225 | 58.915 | 59.01 | 1034568.0 |
| 2019-10-18 10:10:00 | AAPL | Stock | 59.01 | 59.0705 | 58.9225 | 58.9475 | 1489232.0 |
| 2019-10-18 10:15:00 | AAPL | Stock | 58.945 | 58.975 | 58.92 | 58.9375 | 893732.0 |
| 2019-10-18 10:20:00 | AAPL | Stock | 58.9348 | 58.9348 | 58.8775 | 58.905 | 787756.0 |
| 2019-10-18 10:25:00 | AAPL | Stock | 58.91 | 58.935 | 58.8525 | 58.905 | 1156432.0 |
| 2019-10-18 10:30:00 | AAPL | Stock | 58.91 | 58.9125 | 58.86 | 58.8652 | 798912.0 |
| 2019-10-18 10:35:00 | AAPL | Stock | 58.865 | 58.9325 | 58.8525 | 58.9125 | 821860.0 |
| 2019-10-18 10:40:00 | AAPL | Stock | 58.9125 | 58.9125 | 58.74 | 58.7875 | 1193496.0 |
| 2019-10-18 10:45:00 | AAPL | Stock | 58.785 | 58.849 | 58.7675 | 58.835 | 754812.0 |
| 2019-10-18 10:50:00 | AAPL | Stock | 58.8388 | 58.9025 | 58.83 | 58.895 | 681120.0 |
| 2019-10-18 10:55:00 | AAPL | Stock | 58.9 | 58.915 | 58.86 | 58.8838 | 346220.0 |
> showing 50 of 349,387 rows — these rows as CSV