PREVIEW / stock_5min / 2020-06-26
file: by_date/stock_5min/2020/2020-06-26.parquet size: 6.7 MB rows: 427,178 symbols: 2,444
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-06-26 04:00:00 | AAPL | Stock | 90.965 | 91.0 | 90.7525 | 90.9075 | 4824.0 |
| 2020-06-26 04:05:00 | AAPL | Stock | 90.755 | 90.755 | 90.75 | 90.75 | 6304.0 |
| 2020-06-26 04:15:00 | AAPL | Stock | 90.75 | 90.75 | 90.75 | 90.75 | 400.0 |
| 2020-06-26 04:20:00 | AAPL | Stock | 90.8175 | 90.8725 | 90.8175 | 90.8725 | 2204.0 |
| 2020-06-26 04:30:00 | AAPL | Stock | 90.7775 | 90.7875 | 90.7775 | 90.7875 | 880.0 |
| 2020-06-26 04:35:00 | AAPL | Stock | 90.8 | 90.855 | 90.8 | 90.855 | 1404.0 |
| 2020-06-26 04:40:00 | AAPL | Stock | 90.8625 | 90.8825 | 90.8625 | 90.8825 | 3200.0 |
| 2020-06-26 04:45:00 | AAPL | Stock | 90.95 | 90.95 | 90.95 | 90.95 | 2220.0 |
| 2020-06-26 04:55:00 | AAPL | Stock | 91.0 | 91.0 | 91.0 | 91.0 | 1200.0 |
| 2020-06-26 05:00:00 | AAPL | Stock | 91.05 | 91.05 | 91.025 | 91.025 | 5380.0 |
| 2020-06-26 05:15:00 | AAPL | Stock | 91.145 | 91.145 | 91.145 | 91.145 | 400.0 |
| 2020-06-26 05:50:00 | AAPL | Stock | 91.125 | 91.125 | 91.125 | 91.125 | 2560.0 |
| 2020-06-26 05:55:00 | AAPL | Stock | 91.15 | 91.15 | 91.15 | 91.15 | 1200.0 |
| 2020-06-26 06:00:00 | AAPL | Stock | 91.15 | 91.21 | 91.15 | 91.21 | 3800.0 |
| 2020-06-26 06:30:00 | AAPL | Stock | 91.255 | 91.255 | 91.23 | 91.23 | 1292.0 |
| 2020-06-26 06:50:00 | AAPL | Stock | 91.2575 | 91.2575 | 91.205 | 91.205 | 8556.0 |
| 2020-06-26 07:00:00 | AAPL | Stock | 91.295 | 91.4 | 91.25 | 91.4 | 34476.0 |
| 2020-06-26 07:05:00 | AAPL | Stock | 91.4 | 91.48 | 91.4 | 91.4625 | 23620.0 |
| 2020-06-26 07:10:00 | AAPL | Stock | 91.4625 | 91.48 | 91.415 | 91.415 | 11152.0 |
| 2020-06-26 07:15:00 | AAPL | Stock | 91.435 | 91.435 | 91.3775 | 91.3825 | 2896.0 |
| 2020-06-26 07:20:00 | AAPL | Stock | 91.375 | 91.375 | 91.3475 | 91.3475 | 4092.0 |
| 2020-06-26 07:25:00 | AAPL | Stock | 91.34 | 91.3675 | 91.25 | 91.25 | 14104.0 |
| 2020-06-26 07:30:00 | AAPL | Stock | 91.2725 | 91.32 | 91.2525 | 91.2725 | 11632.0 |
| 2020-06-26 07:35:00 | AAPL | Stock | 91.285 | 91.3025 | 91.285 | 91.3 | 2648.0 |
| 2020-06-26 07:40:00 | AAPL | Stock | 91.3125 | 91.355 | 91.3125 | 91.355 | 3820.0 |
| 2020-06-26 07:45:00 | AAPL | Stock | 91.3475 | 91.3475 | 91.275 | 91.275 | 5320.0 |
| 2020-06-26 07:50:00 | AAPL | Stock | 91.2625 | 91.275 | 91.25 | 91.25 | 7160.0 |
| 2020-06-26 07:55:00 | AAPL | Stock | 91.25 | 91.2625 | 91.2325 | 91.2325 | 9124.0 |
| 2020-06-26 08:00:00 | AAPL | Stock | 91.3758 | 91.465 | 91.225 | 91.24 | 82568.0 |
| 2020-06-26 08:05:00 | AAPL | Stock | 91.23 | 91.24 | 91.1525 | 91.225 | 16016.0 |
| 2020-06-26 08:10:00 | AAPL | Stock | 91.1525 | 91.1525 | 91.075 | 91.075 | 14624.0 |
| 2020-06-26 08:15:00 | AAPL | Stock | 91.075 | 91.125 | 91.0375 | 91.1125 | 51244.0 |
| 2020-06-26 08:20:00 | AAPL | Stock | 91.1125 | 91.2075 | 91.095 | 91.15 | 15240.0 |
| 2020-06-26 08:25:00 | AAPL | Stock | 91.115 | 91.1875 | 91.115 | 91.1875 | 8224.0 |
| 2020-06-26 08:30:00 | AAPL | Stock | 91.175 | 91.215 | 91.125 | 91.185 | 12892.0 |
| 2020-06-26 08:35:00 | AAPL | Stock | 91.175 | 91.175 | 91.0775 | 91.0775 | 16632.0 |
| 2020-06-26 08:40:00 | AAPL | Stock | 91.105 | 91.1275 | 91.0975 | 91.1002 | 6892.0 |
| 2020-06-26 08:45:00 | AAPL | Stock | 91.1325 | 91.1825 | 91.11 | 91.12 | 26532.0 |
| 2020-06-26 08:50:00 | AAPL | Stock | 91.125 | 91.1438 | 91.0375 | 91.0375 | 33312.0 |
| 2020-06-26 08:55:00 | AAPL | Stock | 91.0375 | 91.12 | 90.9825 | 91.0725 | 63728.0 |
| 2020-06-26 09:00:00 | AAPL | Stock | 91.02 | 91.21 | 91.0 | 91.0575 | 418480.0 |
| 2020-06-26 09:05:00 | AAPL | Stock | 91.075 | 91.125 | 91.0 | 91.071 | 21660.0 |
| 2020-06-26 09:10:00 | AAPL | Stock | 91.037 | 91.21 | 91.0 | 91.21 | 17536.0 |
| 2020-06-26 09:15:00 | AAPL | Stock | 91.0 | 91.0225 | 90.9575 | 91.0125 | 10488.0 |
| 2020-06-26 09:20:00 | AAPL | Stock | 91.025 | 91.125 | 91.0125 | 91.08 | 31976.0 |
| 2020-06-26 09:25:00 | AAPL | Stock | 91.0275 | 91.125 | 90.975 | 91.09 | 19096.0 |
| 2020-06-26 09:30:00 | AAPL | Stock | 91.1125 | 91.33 | 90.8425 | 90.9375 | 3161596.0 |
| 2020-06-26 09:35:00 | AAPL | Stock | 90.9425 | 91.0975 | 90.6825 | 90.7925 | 1958884.0 |
| 2020-06-26 09:40:00 | AAPL | Stock | 90.7925 | 90.8025 | 90.45 | 90.47 | 2253888.0 |
| 2020-06-26 09:45:00 | AAPL | Stock | 90.47 | 90.72 | 90.3825 | 90.5625 | 1845484.0 |
> showing 50 of 427,178 rows — these rows as CSV