PREVIEW / stock_5min / 2020-08-19
file: by_date/stock_5min/2020/2020-08-19.parquet size: 6.5 MB rows: 408,241 symbols: 2,463
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 |
|---|---|---|---|---|---|---|---|
| 2020-08-19 04:00:00 | AAPL | Stock | 115.97 | 115.97 | 115.97 | 115.97 | 800.0 |
| 2020-08-19 04:10:00 | AAPL | Stock | 115.8825 | 115.8825 | 115.8675 | 115.8675 | 3668.0 |
| 2020-08-19 04:20:00 | AAPL | Stock | 115.9825 | 115.9825 | 115.8675 | 115.8675 | 1312.0 |
| 2020-08-19 04:35:00 | AAPL | Stock | 115.9625 | 116.005 | 115.9625 | 116.005 | 1948.0 |
| 2020-08-19 04:45:00 | AAPL | Stock | 116.0175 | 116.0175 | 116.0125 | 116.0125 | 2232.0 |
| 2020-08-19 04:50:00 | AAPL | Stock | 115.9775 | 115.9775 | 115.9775 | 115.9775 | 800.0 |
| 2020-08-19 04:55:00 | AAPL | Stock | 116.0275 | 116.0275 | 116.025 | 116.025 | 800.0 |
| 2020-08-19 05:00:00 | AAPL | Stock | 116.07 | 116.07 | 116.07 | 116.07 | 400.0 |
| 2020-08-19 05:05:00 | AAPL | Stock | 116.125 | 116.125 | 116.125 | 116.125 | 400.0 |
| 2020-08-19 05:30:00 | AAPL | Stock | 116.095 | 116.1 | 116.095 | 116.1 | 1760.0 |
| 2020-08-19 05:40:00 | AAPL | Stock | 116.05 | 116.05 | 116.05 | 116.05 | 576.0 |
| 2020-08-19 06:00:00 | AAPL | Stock | 116.0325 | 116.0625 | 116.0225 | 116.0625 | 10244.0 |
| 2020-08-19 06:05:00 | AAPL | Stock | 116.0475 | 116.05 | 116.0 | 116.0 | 4656.0 |
| 2020-08-19 06:10:00 | AAPL | Stock | 115.9525 | 115.9575 | 115.9525 | 115.9575 | 1040.0 |
| 2020-08-19 06:20:00 | AAPL | Stock | 116.0 | 116.0 | 116.0 | 116.0 | 3536.0 |
| 2020-08-19 06:25:00 | AAPL | Stock | 116.0 | 116.0 | 116.0 | 116.0 | 1220.0 |
| 2020-08-19 06:30:00 | AAPL | Stock | 116.0575 | 116.06 | 116.0575 | 116.0575 | 4664.0 |
| 2020-08-19 06:45:00 | AAPL | Stock | 116.055 | 116.0575 | 116.055 | 116.0575 | 1200.0 |
| 2020-08-19 07:00:00 | AAPL | Stock | 116.04 | 116.0575 | 115.78 | 115.9 | 44580.0 |
| 2020-08-19 07:05:00 | AAPL | Stock | 115.9675 | 116.075 | 115.94 | 116.0 | 34336.0 |
| 2020-08-19 07:10:00 | AAPL | Stock | 116.0125 | 116.0125 | 115.875 | 115.875 | 10492.0 |
| 2020-08-19 07:15:00 | AAPL | Stock | 115.9225 | 115.9225 | 115.7725 | 115.7725 | 9864.0 |
| 2020-08-19 07:20:00 | AAPL | Stock | 115.76 | 115.815 | 115.6775 | 115.695 | 51976.0 |
| 2020-08-19 07:25:00 | AAPL | Stock | 115.725 | 115.725 | 115.5625 | 115.6375 | 24372.0 |
| 2020-08-19 07:30:00 | AAPL | Stock | 115.625 | 115.6375 | 115.575 | 115.6375 | 15456.0 |
| 2020-08-19 07:35:00 | AAPL | Stock | 115.625 | 115.6875 | 115.625 | 115.6625 | 11544.0 |
| 2020-08-19 07:40:00 | AAPL | Stock | 115.6625 | 115.69 | 115.6125 | 115.65 | 7276.0 |
| 2020-08-19 07:45:00 | AAPL | Stock | 115.645 | 115.735 | 115.645 | 115.735 | 8004.0 |
| 2020-08-19 07:50:00 | AAPL | Stock | 115.71 | 115.7125 | 115.71 | 115.71 | 4472.0 |
| 2020-08-19 07:55:00 | AAPL | Stock | 115.7 | 115.795 | 115.7 | 115.795 | 11040.0 |
| 2020-08-19 08:00:00 | AAPL | Stock | 115.9 | 116.0625 | 115.5632 | 115.8 | 101500.0 |
| 2020-08-19 08:05:00 | AAPL | Stock | 115.825 | 115.825 | 115.5625 | 115.65 | 27456.0 |
| 2020-08-19 08:10:00 | AAPL | Stock | 115.675 | 115.7175 | 115.5625 | 115.5775 | 26764.0 |
| 2020-08-19 08:15:00 | AAPL | Stock | 115.5982 | 115.5982 | 115.4648 | 115.4648 | 65000.0 |
| 2020-08-19 08:20:00 | AAPL | Stock | 115.485 | 115.5675 | 115.4625 | 115.5025 | 14644.0 |
| 2020-08-19 08:25:00 | AAPL | Stock | 115.5 | 115.56 | 115.475 | 115.5 | 20256.0 |
| 2020-08-19 08:30:00 | AAPL | Stock | 115.525 | 115.6 | 115.505 | 115.515 | 22760.0 |
| 2020-08-19 08:35:00 | AAPL | Stock | 115.53 | 115.59 | 115.5 | 115.5 | 39900.0 |
| 2020-08-19 08:40:00 | AAPL | Stock | 115.5125 | 115.57 | 115.475 | 115.5002 | 34292.0 |
| 2020-08-19 08:45:00 | AAPL | Stock | 115.4725 | 115.625 | 115.4525 | 115.5875 | 23168.0 |
| 2020-08-19 08:50:00 | AAPL | Stock | 115.575 | 115.6125 | 115.5425 | 115.575 | 8540.0 |
| 2020-08-19 08:55:00 | AAPL | Stock | 115.5825 | 115.6425 | 115.5 | 115.625 | 36432.0 |
| 2020-08-19 09:00:00 | AAPL | Stock | 115.6225 | 115.655 | 115.5625 | 115.6125 | 15744.0 |
| 2020-08-19 09:05:00 | AAPL | Stock | 115.6 | 115.745 | 115.6 | 115.745 | 14444.0 |
| 2020-08-19 09:10:00 | AAPL | Stock | 115.725 | 115.85 | 115.725 | 115.765 | 86244.0 |
| 2020-08-19 09:15:00 | AAPL | Stock | 115.7925 | 115.805 | 115.725 | 115.775 | 34884.0 |
| 2020-08-19 09:20:00 | AAPL | Stock | 115.7925 | 115.7925 | 115.625 | 115.625 | 31648.0 |
| 2020-08-19 09:25:00 | AAPL | Stock | 115.726 | 116.0 | 115.6788 | 115.9525 | 142828.0 |
| 2020-08-19 09:30:00 | AAPL | Stock | 115.99 | 116.265 | 115.6175 | 116.1805 | 5149356.0 |
| 2020-08-19 09:35:00 | AAPL | Stock | 116.19 | 116.594 | 116.1475 | 116.415 | 3476896.0 |
> showing 50 of 408,241 rows — these rows as CSV