PREVIEW / stock_5min / 2020-04-17
file: by_date/stock_5min/2020/2020-04-17.parquet size: 6.4 MB rows: 406,262 symbols: 2,403
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-04-17 04:00:00 | AAPL | Stock | 72.1975 | 72.3375 | 72.0 | 72.1225 | 62376.0 |
| 2020-04-17 04:05:00 | AAPL | Stock | 72.2375 | 72.625 | 72.2375 | 72.475 | 23380.0 |
| 2020-04-17 04:10:00 | AAPL | Stock | 72.3875 | 72.4675 | 72.125 | 72.125 | 42180.0 |
| 2020-04-17 04:15:00 | AAPL | Stock | 72.125 | 72.275 | 72.0 | 72.275 | 27288.0 |
| 2020-04-17 04:20:00 | AAPL | Stock | 72.25 | 72.275 | 72.1875 | 72.1875 | 13888.0 |
| 2020-04-17 04:25:00 | AAPL | Stock | 72.1875 | 72.2 | 72.09 | 72.09 | 8264.0 |
| 2020-04-17 04:30:00 | AAPL | Stock | 72.0675 | 72.0675 | 71.75 | 71.94 | 24312.0 |
| 2020-04-17 04:35:00 | AAPL | Stock | 71.9425 | 72.06 | 71.9125 | 71.9125 | 12940.0 |
| 2020-04-17 04:40:00 | AAPL | Stock | 71.885 | 72.0 | 71.8825 | 72.0 | 8172.0 |
| 2020-04-17 04:45:00 | AAPL | Stock | 72.0125 | 72.175 | 72.0125 | 72.175 | 4792.0 |
| 2020-04-17 04:50:00 | AAPL | Stock | 72.125 | 72.125 | 71.9625 | 71.97 | 14620.0 |
| 2020-04-17 04:55:00 | AAPL | Stock | 71.9725 | 72.075 | 71.875 | 71.875 | 8212.0 |
| 2020-04-17 05:00:00 | AAPL | Stock | 71.85 | 71.975 | 71.85 | 71.9675 | 13032.0 |
| 2020-04-17 05:05:00 | AAPL | Stock | 71.995 | 72.0 | 71.92 | 71.92 | 8028.0 |
| 2020-04-17 05:10:00 | AAPL | Stock | 72.0 | 72.125 | 72.0 | 72.125 | 8656.0 |
| 2020-04-17 05:15:00 | AAPL | Stock | 72.12 | 72.12 | 72.0625 | 72.0625 | 1624.0 |
| 2020-04-17 05:20:00 | AAPL | Stock | 72.1175 | 72.1475 | 71.945 | 71.945 | 4104.0 |
| 2020-04-17 05:25:00 | AAPL | Stock | 72.025 | 72.125 | 71.9375 | 72.085 | 8408.0 |
| 2020-04-17 05:30:00 | AAPL | Stock | 72.085 | 72.11 | 72.015 | 72.035 | 22124.0 |
| 2020-04-17 05:35:00 | AAPL | Stock | 72.05 | 72.05 | 71.9525 | 72.02 | 5276.0 |
| 2020-04-17 05:40:00 | AAPL | Stock | 72.115 | 72.115 | 72.0 | 72.0675 | 6524.0 |
| 2020-04-17 05:45:00 | AAPL | Stock | 72.0625 | 72.0625 | 72.0 | 72.0 | 3600.0 |
| 2020-04-17 05:50:00 | AAPL | Stock | 72.0825 | 72.335 | 72.0825 | 72.335 | 13800.0 |
| 2020-04-17 05:55:00 | AAPL | Stock | 72.25 | 72.25 | 72.25 | 72.25 | 2440.0 |
| 2020-04-17 06:00:00 | AAPL | Stock | 72.25 | 72.25 | 72.25 | 72.25 | 2000.0 |
| 2020-04-17 06:05:00 | AAPL | Stock | 72.3 | 72.3 | 72.235 | 72.2775 | 3544.0 |
| 2020-04-17 06:10:00 | AAPL | Stock | 72.275 | 72.375 | 72.275 | 72.3625 | 20048.0 |
| 2020-04-17 06:15:00 | AAPL | Stock | 72.375 | 72.475 | 72.375 | 72.4725 | 9440.0 |
| 2020-04-17 06:20:00 | AAPL | Stock | 72.4975 | 72.4975 | 72.335 | 72.4475 | 11324.0 |
| 2020-04-17 06:25:00 | AAPL | Stock | 72.4125 | 72.4125 | 72.2975 | 72.3725 | 3732.0 |
| 2020-04-17 06:30:00 | AAPL | Stock | 72.2625 | 72.275 | 72.2125 | 72.275 | 8320.0 |
| 2020-04-17 06:35:00 | AAPL | Stock | 72.325 | 72.415 | 72.23 | 72.375 | 17056.0 |
| 2020-04-17 06:40:00 | AAPL | Stock | 72.3725 | 72.44 | 72.3575 | 72.4225 | 5776.0 |
| 2020-04-17 06:45:00 | AAPL | Stock | 72.375 | 72.375 | 72.2775 | 72.3375 | 9576.0 |
| 2020-04-17 06:50:00 | AAPL | Stock | 72.34 | 72.4875 | 72.3375 | 72.455 | 16676.0 |
| 2020-04-17 06:55:00 | AAPL | Stock | 72.445 | 72.5 | 72.4125 | 72.4825 | 25964.0 |
| 2020-04-17 07:00:00 | AAPL | Stock | 72.4425 | 72.7775 | 72.4375 | 72.7775 | 156920.0 |
| 2020-04-17 07:05:00 | AAPL | Stock | 72.755 | 72.8325 | 72.5825 | 72.5825 | 72384.0 |
| 2020-04-17 07:10:00 | AAPL | Stock | 72.5775 | 72.645 | 72.4175 | 72.4275 | 116896.0 |
| 2020-04-17 07:15:00 | AAPL | Stock | 72.425 | 72.425 | 72.155 | 72.2575 | 116380.0 |
| 2020-04-17 07:20:00 | AAPL | Stock | 72.2625 | 72.325 | 72.2425 | 72.25 | 146816.0 |
| 2020-04-17 07:25:00 | AAPL | Stock | 72.2675 | 72.2675 | 72.025 | 72.125 | 148380.0 |
| 2020-04-17 07:30:00 | AAPL | Stock | 72.1225 | 72.1375 | 71.92 | 71.92 | 124440.0 |
| 2020-04-17 07:35:00 | AAPL | Stock | 71.92 | 72.0725 | 71.875 | 71.935 | 93272.0 |
| 2020-04-17 07:40:00 | AAPL | Stock | 71.93 | 72.0 | 71.7875 | 71.89 | 119896.0 |
| 2020-04-17 07:45:00 | AAPL | Stock | 71.9375 | 71.98 | 71.75 | 71.75 | 126460.0 |
| 2020-04-17 07:50:00 | AAPL | Stock | 71.75 | 71.825 | 71.7025 | 71.76 | 193824.0 |
| 2020-04-17 07:55:00 | AAPL | Stock | 71.7675 | 71.8 | 71.7125 | 71.7125 | 87824.0 |
| 2020-04-17 08:00:00 | AAPL | Stock | 72.6575 | 72.8325 | 71.6075 | 71.6075 | 614504.0 |
| 2020-04-17 08:05:00 | AAPL | Stock | 71.625 | 71.7975 | 71.5 | 71.775 | 289564.0 |
> showing 50 of 406,262 rows — these rows as CSV