PREVIEW / stock_5min / 2020-08-03
file: by_date/stock_5min/2020/2020-08-03.parquet size: 6.7 MB rows: 423,114 symbols: 2,452
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-03 04:00:00 | AAPL | Stock | 106.86 | 107.325 | 106.86 | 107.325 | 16252.0 |
| 2020-08-03 04:05:00 | AAPL | Stock | 107.3 | 107.3175 | 107.1575 | 107.2225 | 9580.0 |
| 2020-08-03 04:10:00 | AAPL | Stock | 107.2075 | 107.25 | 107.2075 | 107.2325 | 7004.0 |
| 2020-08-03 04:15:00 | AAPL | Stock | 107.2475 | 107.275 | 107.0 | 107.1 | 10500.0 |
| 2020-08-03 04:20:00 | AAPL | Stock | 107.0375 | 107.0375 | 107.005 | 107.005 | 2664.0 |
| 2020-08-03 04:25:00 | AAPL | Stock | 107.0125 | 107.025 | 106.9925 | 107.0 | 12356.0 |
| 2020-08-03 04:30:00 | AAPL | Stock | 107.0 | 107.0 | 106.8275 | 106.8275 | 7160.0 |
| 2020-08-03 04:35:00 | AAPL | Stock | 106.865 | 106.9 | 106.865 | 106.9 | 3200.0 |
| 2020-08-03 04:40:00 | AAPL | Stock | 106.83 | 106.845 | 106.825 | 106.84 | 10400.0 |
| 2020-08-03 04:45:00 | AAPL | Stock | 106.845 | 106.8575 | 106.84 | 106.8575 | 3200.0 |
| 2020-08-03 04:50:00 | AAPL | Stock | 106.8475 | 106.87 | 106.8475 | 106.87 | 6608.0 |
| 2020-08-03 05:00:00 | AAPL | Stock | 106.9925 | 107.0 | 106.9775 | 107.0 | 6592.0 |
| 2020-08-03 05:05:00 | AAPL | Stock | 106.925 | 106.925 | 106.925 | 106.925 | 400.0 |
| 2020-08-03 05:15:00 | AAPL | Stock | 106.875 | 106.875 | 106.875 | 106.875 | 3412.0 |
| 2020-08-03 05:20:00 | AAPL | Stock | 106.88 | 106.8925 | 106.88 | 106.8925 | 800.0 |
| 2020-08-03 05:25:00 | AAPL | Stock | 106.9925 | 106.9975 | 106.99 | 106.9975 | 2764.0 |
| 2020-08-03 05:30:00 | AAPL | Stock | 106.945 | 106.945 | 106.945 | 106.945 | 404.0 |
| 2020-08-03 05:35:00 | AAPL | Stock | 106.88 | 106.8875 | 106.875 | 106.8775 | 3364.0 |
| 2020-08-03 05:40:00 | AAPL | Stock | 106.8875 | 106.8875 | 106.795 | 106.7975 | 7368.0 |
| 2020-08-03 05:55:00 | AAPL | Stock | 106.7875 | 106.7875 | 106.765 | 106.765 | 2712.0 |
| 2020-08-03 06:00:00 | AAPL | Stock | 106.765 | 106.795 | 106.765 | 106.795 | 1632.0 |
| 2020-08-03 06:05:00 | AAPL | Stock | 106.8725 | 106.9 | 106.8725 | 106.9 | 5200.0 |
| 2020-08-03 06:10:00 | AAPL | Stock | 106.875 | 106.95 | 106.875 | 106.95 | 12428.0 |
| 2020-08-03 06:15:00 | AAPL | Stock | 106.925 | 106.925 | 106.9075 | 106.925 | 5272.0 |
| 2020-08-03 06:20:00 | AAPL | Stock | 106.9225 | 107.0925 | 106.9225 | 107.0475 | 19060.0 |
| 2020-08-03 06:25:00 | AAPL | Stock | 107.045 | 107.12 | 107.015 | 107.1125 | 15680.0 |
| 2020-08-03 06:30:00 | AAPL | Stock | 107.11 | 107.1325 | 107.1025 | 107.125 | 23536.0 |
| 2020-08-03 06:35:00 | AAPL | Stock | 107.035 | 107.195 | 107.0325 | 107.175 | 4888.0 |
| 2020-08-03 06:40:00 | AAPL | Stock | 107.2 | 107.225 | 107.2 | 107.225 | 1208.0 |
| 2020-08-03 06:45:00 | AAPL | Stock | 107.2 | 107.25 | 107.175 | 107.25 | 7984.0 |
| 2020-08-03 06:50:00 | AAPL | Stock | 107.2875 | 107.37 | 107.275 | 107.3225 | 47864.0 |
| 2020-08-03 06:55:00 | AAPL | Stock | 107.35 | 107.35 | 107.2925 | 107.3 | 15952.0 |
| 2020-08-03 07:00:00 | AAPL | Stock | 107.3 | 107.9125 | 107.3 | 107.8125 | 339180.0 |
| 2020-08-03 07:05:00 | AAPL | Stock | 107.8125 | 107.9 | 107.645 | 107.71 | 131628.0 |
| 2020-08-03 07:10:00 | AAPL | Stock | 107.6975 | 107.975 | 107.6975 | 107.8725 | 188820.0 |
| 2020-08-03 07:15:00 | AAPL | Stock | 107.8375 | 107.9375 | 107.75 | 107.91 | 115556.0 |
| 2020-08-03 07:20:00 | AAPL | Stock | 107.8875 | 108.07 | 107.875 | 107.925 | 101376.0 |
| 2020-08-03 07:25:00 | AAPL | Stock | 107.935 | 107.9375 | 107.78 | 107.875 | 73556.0 |
| 2020-08-03 07:30:00 | AAPL | Stock | 107.905 | 108.185 | 107.905 | 108.1 | 121612.0 |
| 2020-08-03 07:35:00 | AAPL | Stock | 108.1225 | 108.2925 | 108.0925 | 108.2175 | 176560.0 |
| 2020-08-03 07:40:00 | AAPL | Stock | 108.225 | 108.225 | 108.0025 | 108.1475 | 70672.0 |
| 2020-08-03 07:45:00 | AAPL | Stock | 108.15 | 108.15 | 108.0025 | 108.0025 | 52032.0 |
| 2020-08-03 07:50:00 | AAPL | Stock | 108.025 | 108.1075 | 108.0025 | 108.0025 | 79420.0 |
| 2020-08-03 07:55:00 | AAPL | Stock | 108.0025 | 108.0025 | 107.815 | 107.875 | 119784.0 |
| 2020-08-03 08:00:00 | AAPL | Stock | 107.82 | 108.295 | 107.375 | 107.7975 | 698756.0 |
| 2020-08-03 08:05:00 | AAPL | Stock | 107.7925 | 107.9925 | 107.75 | 107.868 | 149596.0 |
| 2020-08-03 08:10:00 | AAPL | Stock | 107.8625 | 107.995 | 107.7475 | 107.995 | 98820.0 |
| 2020-08-03 08:15:00 | AAPL | Stock | 108.0 | 108.0875 | 107.9525 | 108.0375 | 148872.0 |
| 2020-08-03 08:20:00 | AAPL | Stock | 108.0175 | 108.0475 | 107.902 | 108.025 | 65944.0 |
| 2020-08-03 08:25:00 | AAPL | Stock | 108.025 | 108.0625 | 107.975 | 107.98 | 95404.0 |
> showing 50 of 423,114 rows — these rows as CSV