PREVIEW / stock_5min / 2020-06-25
file: by_date/stock_5min/2020/2020-06-25.parquet size: 6.6 MB rows: 420,549 symbols: 2,432
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-25 04:00:00 | AAPL | Stock | 89.3875 | 89.3875 | 89.35 | 89.3775 | 6352.0 |
| 2020-06-25 04:05:00 | AAPL | Stock | 89.495 | 89.6 | 89.495 | 89.6 | 3120.0 |
| 2020-06-25 04:10:00 | AAPL | Stock | 89.6575 | 89.6575 | 89.65 | 89.65 | 3600.0 |
| 2020-06-25 04:15:00 | AAPL | Stock | 89.6525 | 89.7525 | 89.6525 | 89.7525 | 2776.0 |
| 2020-06-25 04:20:00 | AAPL | Stock | 89.9625 | 90.0375 | 89.9625 | 89.9625 | 1600.0 |
| 2020-06-25 04:25:00 | AAPL | Stock | 89.9475 | 89.9475 | 89.9475 | 89.9475 | 400.0 |
| 2020-06-25 04:35:00 | AAPL | Stock | 89.8125 | 89.8125 | 89.8125 | 89.8125 | 400.0 |
| 2020-06-25 04:40:00 | AAPL | Stock | 90.1125 | 90.1525 | 90.1125 | 90.1525 | 1200.0 |
| 2020-06-25 04:50:00 | AAPL | Stock | 90.175 | 90.175 | 90.175 | 90.175 | 656.0 |
| 2020-06-25 04:55:00 | AAPL | Stock | 90.145 | 90.175 | 90.145 | 90.175 | 800.0 |
| 2020-06-25 05:00:00 | AAPL | Stock | 90.1675 | 90.1675 | 90.1275 | 90.15 | 1300.0 |
| 2020-06-25 05:05:00 | AAPL | Stock | 90.32 | 90.32 | 90.25 | 90.265 | 4368.0 |
| 2020-06-25 05:10:00 | AAPL | Stock | 90.25 | 90.25 | 90.25 | 90.25 | 400.0 |
| 2020-06-25 05:20:00 | AAPL | Stock | 90.2775 | 90.2775 | 90.2775 | 90.2775 | 400.0 |
| 2020-06-25 05:25:00 | AAPL | Stock | 90.355 | 90.3625 | 90.355 | 90.3625 | 1600.0 |
| 2020-06-25 05:35:00 | AAPL | Stock | 90.4725 | 90.4725 | 90.4725 | 90.4725 | 1200.0 |
| 2020-06-25 05:40:00 | AAPL | Stock | 90.405 | 90.405 | 90.15 | 90.15 | 2000.0 |
| 2020-06-25 05:45:00 | AAPL | Stock | 90.1475 | 90.1475 | 90.0875 | 90.0875 | 800.0 |
| 2020-06-25 06:10:00 | AAPL | Stock | 90.16 | 90.16 | 90.075 | 90.0825 | 2424.0 |
| 2020-06-25 06:15:00 | AAPL | Stock | 90.09 | 90.1475 | 90.075 | 90.075 | 2272.0 |
| 2020-06-25 06:35:00 | AAPL | Stock | 90.25 | 90.25 | 90.25 | 90.25 | 400.0 |
| 2020-06-25 06:40:00 | AAPL | Stock | 90.24 | 90.25 | 90.15 | 90.15 | 5756.0 |
| 2020-06-25 06:45:00 | AAPL | Stock | 90.2175 | 90.3725 | 90.2175 | 90.36 | 4380.0 |
| 2020-06-25 06:50:00 | AAPL | Stock | 90.4875 | 90.6 | 90.3825 | 90.5925 | 9636.0 |
| 2020-06-25 06:55:00 | AAPL | Stock | 90.505 | 90.53 | 90.505 | 90.53 | 1796.0 |
| 2020-06-25 07:00:00 | AAPL | Stock | 90.53 | 90.645 | 90.505 | 90.5375 | 76920.0 |
| 2020-06-25 07:05:00 | AAPL | Stock | 90.5375 | 90.555 | 90.505 | 90.5375 | 8836.0 |
| 2020-06-25 07:10:00 | AAPL | Stock | 90.545 | 90.7 | 90.545 | 90.645 | 42120.0 |
| 2020-06-25 07:15:00 | AAPL | Stock | 90.6125 | 90.6325 | 90.325 | 90.345 | 39872.0 |
| 2020-06-25 07:20:00 | AAPL | Stock | 90.405 | 90.405 | 90.2 | 90.2 | 45524.0 |
| 2020-06-25 07:25:00 | AAPL | Stock | 90.2 | 90.325 | 90.175 | 90.325 | 25472.0 |
| 2020-06-25 07:30:00 | AAPL | Stock | 90.3675 | 90.3925 | 90.25 | 90.345 | 10244.0 |
| 2020-06-25 07:35:00 | AAPL | Stock | 90.3375 | 90.3675 | 90.3225 | 90.325 | 11724.0 |
| 2020-06-25 07:40:00 | AAPL | Stock | 90.285 | 90.285 | 90.025 | 90.025 | 28376.0 |
| 2020-06-25 07:45:00 | AAPL | Stock | 90.05 | 90.1 | 90.0 | 90.1 | 17884.0 |
| 2020-06-25 07:50:00 | AAPL | Stock | 90.1 | 90.1 | 90.075 | 90.085 | 13028.0 |
| 2020-06-25 07:55:00 | AAPL | Stock | 90.1225 | 90.1225 | 89.9775 | 89.9775 | 24716.0 |
| 2020-06-25 08:00:00 | AAPL | Stock | 90.525 | 90.745 | 89.95 | 90.035 | 228912.0 |
| 2020-06-25 08:05:00 | AAPL | Stock | 90.0975 | 90.125 | 89.8775 | 89.9875 | 40500.0 |
| 2020-06-25 08:10:00 | AAPL | Stock | 89.9988 | 90.1525 | 89.9525 | 90.1525 | 26516.0 |
| 2020-06-25 08:15:00 | AAPL | Stock | 90.1275 | 90.1775 | 90.0625 | 90.0625 | 48680.0 |
| 2020-06-25 08:20:00 | AAPL | Stock | 90.0875 | 90.18 | 90.0875 | 90.18 | 12004.0 |
| 2020-06-25 08:25:00 | AAPL | Stock | 90.22 | 90.275 | 90.18 | 90.18 | 30260.0 |
| 2020-06-25 08:30:00 | AAPL | Stock | 90.18 | 90.18 | 89.9618 | 89.9875 | 76492.0 |
| 2020-06-25 08:35:00 | AAPL | Stock | 90.025 | 90.365 | 90.0 | 90.2885 | 88908.0 |
| 2020-06-25 08:40:00 | AAPL | Stock | 90.3075 | 90.33 | 90.1625 | 90.2765 | 79108.0 |
| 2020-06-25 08:45:00 | AAPL | Stock | 90.2375 | 90.35 | 90.1625 | 90.335 | 37512.0 |
| 2020-06-25 08:50:00 | AAPL | Stock | 90.3 | 90.44 | 90.28 | 90.4125 | 77628.0 |
| 2020-06-25 08:55:00 | AAPL | Stock | 90.4325 | 90.5 | 90.375 | 90.475 | 92524.0 |
| 2020-06-25 09:00:00 | AAPL | Stock | 90.45 | 90.465 | 90.1963 | 90.3258 | 155304.0 |
> showing 50 of 420,549 rows — these rows as CSV