PREVIEW / stock_5min / 2020-03-06
file: by_date/stock_5min/2020/2020-03-06.parquet size: 6.5 MB rows: 399,657 symbols: 2,420
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-03-06 04:00:00 | AAPL | Stock | 72.25 | 72.25 | 72.005 | 72.25 | 10764.0 |
| 2020-03-06 04:05:00 | AAPL | Stock | 72.2 | 72.25 | 72.2 | 72.25 | 1236.0 |
| 2020-03-06 04:10:00 | AAPL | Stock | 72.075 | 72.075 | 72.0 | 72.035 | 3364.0 |
| 2020-03-06 04:15:00 | AAPL | Stock | 72.075 | 72.075 | 72.0 | 72.0 | 2444.0 |
| 2020-03-06 04:20:00 | AAPL | Stock | 72.06 | 72.0625 | 71.9 | 71.9 | 4540.0 |
| 2020-03-06 04:25:00 | AAPL | Stock | 71.9775 | 71.9775 | 71.9025 | 71.9025 | 1196.0 |
| 2020-03-06 04:30:00 | AAPL | Stock | 71.9925 | 71.9925 | 71.9475 | 71.9475 | 3756.0 |
| 2020-03-06 04:35:00 | AAPL | Stock | 71.8875 | 71.8875 | 71.75 | 71.75 | 9324.0 |
| 2020-03-06 04:40:00 | AAPL | Stock | 71.785 | 71.8075 | 71.64 | 71.64 | 13416.0 |
| 2020-03-06 04:45:00 | AAPL | Stock | 71.64 | 71.64 | 71.5 | 71.5 | 7180.0 |
| 2020-03-06 04:50:00 | AAPL | Stock | 71.49 | 71.7 | 71.49 | 71.5475 | 19236.0 |
| 2020-03-06 04:55:00 | AAPL | Stock | 71.49 | 71.5975 | 71.44 | 71.575 | 6740.0 |
| 2020-03-06 05:05:00 | AAPL | Stock | 71.4025 | 71.4025 | 71.3125 | 71.3125 | 1060.0 |
| 2020-03-06 05:10:00 | AAPL | Stock | 71.255 | 71.33 | 71.2375 | 71.25 | 17876.0 |
| 2020-03-06 05:15:00 | AAPL | Stock | 71.1325 | 71.1325 | 71.1325 | 71.1325 | 644.0 |
| 2020-03-06 05:20:00 | AAPL | Stock | 71.0275 | 71.0525 | 71.0025 | 71.0525 | 6596.0 |
| 2020-03-06 05:25:00 | AAPL | Stock | 71.05 | 71.125 | 71.0025 | 71.0075 | 7380.0 |
| 2020-03-06 05:30:00 | AAPL | Stock | 71.0025 | 71.0025 | 70.9625 | 71.0 | 12232.0 |
| 2020-03-06 05:35:00 | AAPL | Stock | 70.9625 | 70.9625 | 70.7025 | 70.7025 | 2412.0 |
| 2020-03-06 05:40:00 | AAPL | Stock | 70.63 | 70.7025 | 70.275 | 70.275 | 28804.0 |
| 2020-03-06 05:45:00 | AAPL | Stock | 70.3675 | 70.525 | 70.2625 | 70.4975 | 31584.0 |
| 2020-03-06 05:50:00 | AAPL | Stock | 70.4975 | 70.615 | 70.4975 | 70.615 | 6000.0 |
| 2020-03-06 05:55:00 | AAPL | Stock | 70.6125 | 70.8 | 70.605 | 70.75 | 11628.0 |
| 2020-03-06 06:00:00 | AAPL | Stock | 70.755 | 70.825 | 70.6575 | 70.825 | 6636.0 |
| 2020-03-06 06:05:00 | AAPL | Stock | 70.9375 | 70.995 | 70.75 | 70.75 | 8984.0 |
| 2020-03-06 06:10:00 | AAPL | Stock | 70.6125 | 70.665 | 70.5275 | 70.5825 | 14724.0 |
| 2020-03-06 06:15:00 | AAPL | Stock | 70.5875 | 70.76 | 70.5875 | 70.75 | 4400.0 |
| 2020-03-06 06:20:00 | AAPL | Stock | 70.9375 | 70.975 | 70.9125 | 70.9125 | 15212.0 |
| 2020-03-06 06:25:00 | AAPL | Stock | 70.975 | 71.0 | 70.7825 | 70.7825 | 8792.0 |
| 2020-03-06 06:30:00 | AAPL | Stock | 70.925 | 70.95 | 70.8125 | 70.8125 | 2800.0 |
| 2020-03-06 06:35:00 | AAPL | Stock | 70.8125 | 70.875 | 70.785 | 70.875 | 18868.0 |
| 2020-03-06 06:40:00 | AAPL | Stock | 70.8925 | 70.93 | 70.8925 | 70.93 | 1008.0 |
| 2020-03-06 06:45:00 | AAPL | Stock | 71.04 | 71.1225 | 71.025 | 71.085 | 4624.0 |
| 2020-03-06 06:50:00 | AAPL | Stock | 71.125 | 71.1325 | 71.0375 | 71.1325 | 2400.0 |
| 2020-03-06 06:55:00 | AAPL | Stock | 71.01 | 71.01 | 70.8775 | 70.8775 | 23960.0 |
| 2020-03-06 07:00:00 | AAPL | Stock | 70.925 | 71.2475 | 70.825 | 71.2 | 182272.0 |
| 2020-03-06 07:05:00 | AAPL | Stock | 71.215 | 71.265 | 71.025 | 71.1075 | 76404.0 |
| 2020-03-06 07:10:00 | AAPL | Stock | 71.125 | 71.125 | 70.9125 | 70.925 | 66916.0 |
| 2020-03-06 07:15:00 | AAPL | Stock | 70.925 | 70.975 | 70.83 | 70.975 | 41016.0 |
| 2020-03-06 07:20:00 | AAPL | Stock | 70.9575 | 70.9575 | 70.6675 | 70.6675 | 200760.0 |
| 2020-03-06 07:25:00 | AAPL | Stock | 70.64 | 70.64 | 70.345 | 70.4 | 84576.0 |
| 2020-03-06 07:30:00 | AAPL | Stock | 70.4 | 70.65 | 70.375 | 70.525 | 47068.0 |
| 2020-03-06 07:35:00 | AAPL | Stock | 70.5825 | 70.6675 | 70.5825 | 70.6675 | 26352.0 |
| 2020-03-06 07:40:00 | AAPL | Stock | 70.5475 | 70.5475 | 70.33 | 70.4025 | 50216.0 |
| 2020-03-06 07:45:00 | AAPL | Stock | 70.355 | 70.6125 | 70.325 | 70.325 | 163808.0 |
| 2020-03-06 07:50:00 | AAPL | Stock | 70.325 | 70.41 | 70.075 | 70.41 | 151916.0 |
| 2020-03-06 07:55:00 | AAPL | Stock | 70.415 | 70.5625 | 70.275 | 70.56 | 49592.0 |
| 2020-03-06 08:00:00 | AAPL | Stock | 70.55 | 71.26 | 70.06 | 70.3875 | 401056.0 |
| 2020-03-06 08:05:00 | AAPL | Stock | 70.3875 | 70.4975 | 70.3 | 70.345 | 89372.0 |
| 2020-03-06 08:10:00 | AAPL | Stock | 70.2625 | 70.3725 | 70.23 | 70.25 | 41944.0 |
> showing 50 of 399,657 rows — these rows as CSV