PREVIEW / stock_5min / 2019-08-16
file: by_date/stock_5min/2019/2019-08-16.parquet size: 5.6 MB rows: 355,522 symbols: 2,567
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-08-16 04:00:00 | AAPL | Stock | 50.825 | 50.825 | 50.825 | 50.825 | 468.0 |
| 2019-08-16 04:05:00 | AAPL | Stock | 50.9275 | 51.0575 | 50.9275 | 51.0575 | 1600.0 |
| 2019-08-16 04:10:00 | AAPL | Stock | 51.15 | 51.15 | 51.1225 | 51.1225 | 3948.0 |
| 2019-08-16 04:30:00 | AAPL | Stock | 51.1125 | 51.1125 | 51.1125 | 51.1125 | 4000.0 |
| 2019-08-16 04:35:00 | AAPL | Stock | 51.025 | 51.025 | 51.025 | 51.025 | 400.0 |
| 2019-08-16 04:40:00 | AAPL | Stock | 51.165 | 51.165 | 51.165 | 51.165 | 1232.0 |
| 2019-08-16 04:45:00 | AAPL | Stock | 51.1825 | 51.1825 | 51.175 | 51.175 | 1476.0 |
| 2019-08-16 05:10:00 | AAPL | Stock | 51.1475 | 51.1475 | 51.1475 | 51.1475 | 400.0 |
| 2019-08-16 05:20:00 | AAPL | Stock | 51.1475 | 51.165 | 51.1475 | 51.165 | 2036.0 |
| 2019-08-16 05:25:00 | AAPL | Stock | 51.15 | 51.15 | 51.15 | 51.15 | 400.0 |
| 2019-08-16 05:40:00 | AAPL | Stock | 51.125 | 51.125 | 51.1075 | 51.1075 | 20280.0 |
| 2019-08-16 05:45:00 | AAPL | Stock | 51.1 | 51.1 | 51.0925 | 51.0925 | 1200.0 |
| 2019-08-16 05:50:00 | AAPL | Stock | 51.15 | 51.15 | 51.15 | 51.15 | 2000.0 |
| 2019-08-16 05:55:00 | AAPL | Stock | 51.155 | 51.155 | 51.155 | 51.155 | 2584.0 |
| 2019-08-16 06:00:00 | AAPL | Stock | 51.155 | 51.155 | 51.155 | 51.155 | 664.0 |
| 2019-08-16 06:20:00 | AAPL | Stock | 51.15 | 51.15 | 51.15 | 51.15 | 1220.0 |
| 2019-08-16 06:40:00 | AAPL | Stock | 51.1475 | 51.1475 | 51.1475 | 51.1475 | 2256.0 |
| 2019-08-16 06:45:00 | AAPL | Stock | 51.145 | 51.155 | 51.145 | 51.155 | 1152.0 |
| 2019-08-16 06:55:00 | AAPL | Stock | 51.0875 | 51.0875 | 51.0875 | 51.0875 | 400.0 |
| 2019-08-16 07:00:00 | AAPL | Stock | 51.125 | 51.17 | 51.0725 | 51.13 | 22484.0 |
| 2019-08-16 07:05:00 | AAPL | Stock | 51.155 | 51.175 | 51.1525 | 51.1625 | 13072.0 |
| 2019-08-16 07:10:00 | AAPL | Stock | 51.1475 | 51.1625 | 51.1175 | 51.1175 | 10104.0 |
| 2019-08-16 07:15:00 | AAPL | Stock | 51.1175 | 51.145 | 51.115 | 51.145 | 3200.0 |
| 2019-08-16 07:20:00 | AAPL | Stock | 51.125 | 51.125 | 51.0875 | 51.0875 | 8620.0 |
| 2019-08-16 07:25:00 | AAPL | Stock | 51.1225 | 51.16 | 51.1225 | 51.125 | 7372.0 |
| 2019-08-16 07:30:00 | AAPL | Stock | 51.1025 | 51.1225 | 51.0875 | 51.0875 | 8604.0 |
| 2019-08-16 07:35:00 | AAPL | Stock | 51.0875 | 51.115 | 51.0875 | 51.1 | 6832.0 |
| 2019-08-16 07:40:00 | AAPL | Stock | 51.1025 | 51.1625 | 51.1025 | 51.1625 | 13960.0 |
| 2019-08-16 07:45:00 | AAPL | Stock | 51.125 | 51.1625 | 51.125 | 51.1575 | 6772.0 |
| 2019-08-16 07:50:00 | AAPL | Stock | 51.1575 | 51.1575 | 51.095 | 51.11 | 7412.0 |
| 2019-08-16 07:55:00 | AAPL | Stock | 51.11 | 51.11 | 51.065 | 51.0725 | 12800.0 |
| 2019-08-16 08:00:00 | AAPL | Stock | 51.125 | 51.175 | 51.0625 | 51.0625 | 153764.0 |
| 2019-08-16 08:05:00 | AAPL | Stock | 51.0432 | 51.1 | 51.0432 | 51.1 | 29936.0 |
| 2019-08-16 08:10:00 | AAPL | Stock | 51.075 | 51.0875 | 51.0525 | 51.085 | 9600.0 |
| 2019-08-16 08:15:00 | AAPL | Stock | 51.0525 | 51.0875 | 51.035 | 51.0675 | 12400.0 |
| 2019-08-16 08:20:00 | AAPL | Stock | 51.08 | 51.1075 | 51.0625 | 51.1075 | 8392.0 |
| 2019-08-16 08:25:00 | AAPL | Stock | 51.0625 | 51.1 | 51.0625 | 51.0625 | 7600.0 |
| 2019-08-16 08:30:00 | AAPL | Stock | 51.1 | 51.1 | 51.0675 | 51.075 | 44776.0 |
| 2019-08-16 08:35:00 | AAPL | Stock | 51.0725 | 51.095 | 51.0425 | 51.05 | 29420.0 |
| 2019-08-16 08:40:00 | AAPL | Stock | 51.0475 | 51.05 | 50.98 | 50.98 | 66084.0 |
| 2019-08-16 08:45:00 | AAPL | Stock | 50.975 | 51.01 | 50.975 | 51.0 | 13664.0 |
| 2019-08-16 08:50:00 | AAPL | Stock | 51.0 | 51.0825 | 51.0 | 51.08 | 30536.0 |
| 2019-08-16 08:55:00 | AAPL | Stock | 51.07 | 51.08 | 51.0125 | 51.0125 | 15324.0 |
| 2019-08-16 09:00:00 | AAPL | Stock | 51.0125 | 51.0588 | 50.9525 | 50.9525 | 19072.0 |
| 2019-08-16 09:05:00 | AAPL | Stock | 50.9525 | 51.0 | 50.9175 | 50.95 | 22616.0 |
| 2019-08-16 09:10:00 | AAPL | Stock | 50.94 | 50.975 | 50.86 | 50.86 | 72548.0 |
| 2019-08-16 09:15:00 | AAPL | Stock | 50.8925 | 50.96 | 50.8625 | 50.9575 | 65432.0 |
| 2019-08-16 09:20:00 | AAPL | Stock | 50.9325 | 50.96 | 50.8425 | 50.8475 | 51280.0 |
| 2019-08-16 09:25:00 | AAPL | Stock | 50.8525 | 51.1 | 50.8325 | 50.94 | 274388.0 |
| 2019-08-16 09:30:00 | AAPL | Stock | 51.07 | 51.2125 | 51.0022 | 51.05 | 7374844.0 |
> showing 50 of 355,522 rows — these rows as CSV