PREVIEW / stock_5min / 2020-05-13
file: by_date/stock_5min/2020/2020-05-13.parquet size: 6.6 MB rows: 415,848 symbols: 2,388
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-05-13 04:00:00 | AAPL | Stock | 77.7525 | 77.8075 | 77.6875 | 77.7475 | 8084.0 |
| 2020-05-13 04:05:00 | AAPL | Stock | 77.775 | 77.87 | 77.775 | 77.87 | 8256.0 |
| 2020-05-13 04:10:00 | AAPL | Stock | 77.87 | 77.975 | 77.87 | 77.975 | 4540.0 |
| 2020-05-13 04:15:00 | AAPL | Stock | 77.975 | 78.09 | 77.975 | 78.075 | 7444.0 |
| 2020-05-13 04:20:00 | AAPL | Stock | 78.075 | 78.075 | 78.075 | 78.075 | 800.0 |
| 2020-05-13 04:25:00 | AAPL | Stock | 78.075 | 78.075 | 78.075 | 78.075 | 1420.0 |
| 2020-05-13 04:30:00 | AAPL | Stock | 78.115 | 78.16 | 78.115 | 78.16 | 1000.0 |
| 2020-05-13 04:35:00 | AAPL | Stock | 78.24 | 78.2475 | 78.24 | 78.2475 | 2032.0 |
| 2020-05-13 04:40:00 | AAPL | Stock | 78.1675 | 78.1675 | 78.15 | 78.15 | 4900.0 |
| 2020-05-13 04:45:00 | AAPL | Stock | 78.1 | 78.1 | 78.0475 | 78.0475 | 5600.0 |
| 2020-05-13 04:50:00 | AAPL | Stock | 78.045 | 78.05 | 78.015 | 78.045 | 5196.0 |
| 2020-05-13 04:55:00 | AAPL | Stock | 77.92 | 77.975 | 77.9 | 77.975 | 3260.0 |
| 2020-05-13 05:05:00 | AAPL | Stock | 78.025 | 78.025 | 77.9775 | 77.9775 | 1980.0 |
| 2020-05-13 05:15:00 | AAPL | Stock | 77.9975 | 78.1 | 77.9975 | 78.1 | 3520.0 |
| 2020-05-13 05:20:00 | AAPL | Stock | 78.0 | 78.0125 | 78.0 | 78.0 | 6000.0 |
| 2020-05-13 05:25:00 | AAPL | Stock | 78.0 | 78.075 | 77.9975 | 78.075 | 3228.0 |
| 2020-05-13 05:35:00 | AAPL | Stock | 78.095 | 78.095 | 78.095 | 78.095 | 400.0 |
| 2020-05-13 05:45:00 | AAPL | Stock | 78.1 | 78.1 | 78.095 | 78.1 | 5060.0 |
| 2020-05-13 05:50:00 | AAPL | Stock | 78.2225 | 78.25 | 78.2225 | 78.25 | 8824.0 |
| 2020-05-13 05:55:00 | AAPL | Stock | 78.27 | 78.27 | 78.27 | 78.27 | 908.0 |
| 2020-05-13 06:00:00 | AAPL | Stock | 78.21 | 78.27 | 78.21 | 78.27 | 17452.0 |
| 2020-05-13 06:05:00 | AAPL | Stock | 78.25 | 78.25 | 78.25 | 78.25 | 1200.0 |
| 2020-05-13 06:10:00 | AAPL | Stock | 78.25 | 78.25 | 78.245 | 78.245 | 3428.0 |
| 2020-05-13 06:15:00 | AAPL | Stock | 78.205 | 78.205 | 78.205 | 78.205 | 400.0 |
| 2020-05-13 06:20:00 | AAPL | Stock | 78.2375 | 78.285 | 78.2375 | 78.285 | 1760.0 |
| 2020-05-13 06:25:00 | AAPL | Stock | 78.25 | 78.25 | 78.25 | 78.25 | 5148.0 |
| 2020-05-13 06:35:00 | AAPL | Stock | 78.1825 | 78.1825 | 78.1825 | 78.1825 | 508.0 |
| 2020-05-13 06:40:00 | AAPL | Stock | 78.1825 | 78.1825 | 78.1825 | 78.1825 | 512.0 |
| 2020-05-13 06:45:00 | AAPL | Stock | 78.1625 | 78.215 | 78.1475 | 78.1975 | 13400.0 |
| 2020-05-13 06:50:00 | AAPL | Stock | 78.205 | 78.2125 | 78.1675 | 78.2125 | 2000.0 |
| 2020-05-13 06:55:00 | AAPL | Stock | 78.2125 | 78.2975 | 78.21 | 78.2475 | 4316.0 |
| 2020-05-13 07:00:00 | AAPL | Stock | 78.165 | 78.22 | 78.14 | 78.1425 | 69424.0 |
| 2020-05-13 07:05:00 | AAPL | Stock | 78.145 | 78.145 | 78.0175 | 78.02 | 28280.0 |
| 2020-05-13 07:10:00 | AAPL | Stock | 78.045 | 78.1125 | 78.045 | 78.1125 | 8908.0 |
| 2020-05-13 07:15:00 | AAPL | Stock | 78.1175 | 78.155 | 78.1175 | 78.155 | 14316.0 |
| 2020-05-13 07:20:00 | AAPL | Stock | 78.1625 | 78.255 | 78.1625 | 78.25 | 23752.0 |
| 2020-05-13 07:25:00 | AAPL | Stock | 78.26 | 78.3625 | 78.26 | 78.33 | 24736.0 |
| 2020-05-13 07:30:00 | AAPL | Stock | 78.35 | 78.3625 | 78.255 | 78.3475 | 32076.0 |
| 2020-05-13 07:35:00 | AAPL | Stock | 78.3475 | 78.35 | 78.2875 | 78.305 | 38100.0 |
| 2020-05-13 07:40:00 | AAPL | Stock | 78.2675 | 78.3625 | 78.2675 | 78.35 | 24180.0 |
| 2020-05-13 07:45:00 | AAPL | Stock | 78.3625 | 78.495 | 78.3625 | 78.49 | 51580.0 |
| 2020-05-13 07:50:00 | AAPL | Stock | 78.495 | 78.5 | 78.405 | 78.4125 | 33016.0 |
| 2020-05-13 07:55:00 | AAPL | Stock | 78.415 | 78.4975 | 78.4125 | 78.45 | 31440.0 |
| 2020-05-13 08:00:00 | AAPL | Stock | 78.125 | 78.5 | 78.005 | 78.4325 | 307420.0 |
| 2020-05-13 08:05:00 | AAPL | Stock | 78.425 | 78.425 | 78.315 | 78.315 | 71408.0 |
| 2020-05-13 08:10:00 | AAPL | Stock | 78.325 | 78.4 | 78.15 | 78.3225 | 61096.0 |
| 2020-05-13 08:15:00 | AAPL | Stock | 78.3625 | 78.4 | 78.3375 | 78.4 | 21600.0 |
| 2020-05-13 08:20:00 | AAPL | Stock | 78.4125 | 78.4125 | 78.365 | 78.3875 | 16040.0 |
| 2020-05-13 08:25:00 | AAPL | Stock | 78.3975 | 78.4375 | 78.3788 | 78.4375 | 25564.0 |
| 2020-05-13 08:30:00 | AAPL | Stock | 78.425 | 78.4375 | 78.325 | 78.325 | 83172.0 |
> showing 50 of 415,848 rows — these rows as CSV