PREVIEW / stock_5min / 2020-01-30
file: by_date/stock_5min/2020/2020-01-30.parquet size: 6.0 MB rows: 371,464 symbols: 2,448
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-01-30 04:00:00 | AAPL | Stock | 80.25 | 80.3075 | 80.2 | 80.245 | 18668.0 |
| 2020-01-30 04:05:00 | AAPL | Stock | 80.2 | 80.34 | 80.2 | 80.34 | 21272.0 |
| 2020-01-30 04:10:00 | AAPL | Stock | 80.34 | 80.3875 | 80.325 | 80.385 | 21912.0 |
| 2020-01-30 04:15:00 | AAPL | Stock | 80.3875 | 80.3875 | 80.3375 | 80.3375 | 1600.0 |
| 2020-01-30 04:20:00 | AAPL | Stock | 80.425 | 80.5 | 80.425 | 80.5 | 9200.0 |
| 2020-01-30 04:25:00 | AAPL | Stock | 80.495 | 80.6025 | 80.48 | 80.48 | 4976.0 |
| 2020-01-30 04:30:00 | AAPL | Stock | 80.5625 | 80.57 | 80.4675 | 80.4675 | 7560.0 |
| 2020-01-30 04:35:00 | AAPL | Stock | 80.485 | 80.485 | 80.375 | 80.375 | 8960.0 |
| 2020-01-30 04:40:00 | AAPL | Stock | 80.375 | 80.375 | 80.2625 | 80.2625 | 5596.0 |
| 2020-01-30 04:45:00 | AAPL | Stock | 80.2875 | 80.3875 | 80.2875 | 80.31 | 13364.0 |
| 2020-01-30 04:50:00 | AAPL | Stock | 80.305 | 80.3625 | 80.3 | 80.345 | 14740.0 |
| 2020-01-30 04:55:00 | AAPL | Stock | 80.345 | 80.375 | 80.345 | 80.3525 | 13944.0 |
| 2020-01-30 05:00:00 | AAPL | Stock | 80.32 | 80.32 | 80.275 | 80.275 | 6756.0 |
| 2020-01-30 05:05:00 | AAPL | Stock | 80.2775 | 80.35 | 80.25 | 80.35 | 2196.0 |
| 2020-01-30 05:10:00 | AAPL | Stock | 80.3 | 80.3 | 80.2875 | 80.2875 | 1776.0 |
| 2020-01-30 05:15:00 | AAPL | Stock | 80.2625 | 80.2625 | 80.195 | 80.195 | 11176.0 |
| 2020-01-30 05:20:00 | AAPL | Stock | 80.225 | 80.2525 | 80.225 | 80.25 | 10256.0 |
| 2020-01-30 05:25:00 | AAPL | Stock | 80.255 | 80.255 | 80.255 | 80.255 | 800.0 |
| 2020-01-30 05:30:00 | AAPL | Stock | 80.2575 | 80.275 | 80.25 | 80.2525 | 17200.0 |
| 2020-01-30 05:35:00 | AAPL | Stock | 80.2675 | 80.3 | 80.25 | 80.25 | 6420.0 |
| 2020-01-30 05:45:00 | AAPL | Stock | 80.2875 | 80.2875 | 80.2875 | 80.2875 | 6196.0 |
| 2020-01-30 05:50:00 | AAPL | Stock | 80.3 | 80.3475 | 80.3 | 80.3475 | 3372.0 |
| 2020-01-30 06:00:00 | AAPL | Stock | 80.255 | 80.255 | 80.255 | 80.255 | 400.0 |
| 2020-01-30 06:05:00 | AAPL | Stock | 80.2125 | 80.2125 | 80.15 | 80.15 | 1444.0 |
| 2020-01-30 06:10:00 | AAPL | Stock | 80.15 | 80.15 | 80.15 | 80.15 | 2396.0 |
| 2020-01-30 06:15:00 | AAPL | Stock | 80.15 | 80.175 | 80.15 | 80.1625 | 15544.0 |
| 2020-01-30 06:20:00 | AAPL | Stock | 80.1625 | 80.1625 | 80.1175 | 80.125 | 24640.0 |
| 2020-01-30 06:25:00 | AAPL | Stock | 80.04 | 80.15 | 80.04 | 80.15 | 6876.0 |
| 2020-01-30 06:30:00 | AAPL | Stock | 80.175 | 80.2075 | 80.175 | 80.2 | 3640.0 |
| 2020-01-30 06:35:00 | AAPL | Stock | 80.1875 | 80.2075 | 80.1875 | 80.2075 | 2420.0 |
| 2020-01-30 06:40:00 | AAPL | Stock | 80.2075 | 80.275 | 80.205 | 80.225 | 8648.0 |
| 2020-01-30 06:45:00 | AAPL | Stock | 80.275 | 80.275 | 80.275 | 80.275 | 400.0 |
| 2020-01-30 06:50:00 | AAPL | Stock | 80.275 | 80.275 | 80.1625 | 80.1625 | 19060.0 |
| 2020-01-30 06:55:00 | AAPL | Stock | 80.125 | 80.2125 | 80.125 | 80.2125 | 5928.0 |
| 2020-01-30 07:00:00 | AAPL | Stock | 80.25 | 80.375 | 80.2025 | 80.35 | 94000.0 |
| 2020-01-30 07:05:00 | AAPL | Stock | 80.3075 | 80.3725 | 80.25 | 80.3375 | 54276.0 |
| 2020-01-30 07:10:00 | AAPL | Stock | 80.3375 | 80.35 | 80.2875 | 80.2875 | 24028.0 |
| 2020-01-30 07:15:00 | AAPL | Stock | 80.31 | 80.3375 | 80.31 | 80.3375 | 10456.0 |
| 2020-01-30 07:20:00 | AAPL | Stock | 80.3575 | 80.3575 | 80.21 | 80.21 | 25428.0 |
| 2020-01-30 07:25:00 | AAPL | Stock | 80.2125 | 80.275 | 80.2 | 80.2625 | 25404.0 |
| 2020-01-30 07:30:00 | AAPL | Stock | 80.24 | 80.24 | 80.16 | 80.225 | 37804.0 |
| 2020-01-30 07:35:00 | AAPL | Stock | 80.19 | 80.25 | 80.125 | 80.25 | 46088.0 |
| 2020-01-30 07:40:00 | AAPL | Stock | 80.2475 | 80.25 | 80.2125 | 80.245 | 18256.0 |
| 2020-01-30 07:45:00 | AAPL | Stock | 80.22 | 80.225 | 80.145 | 80.175 | 22376.0 |
| 2020-01-30 07:50:00 | AAPL | Stock | 80.1525 | 80.1525 | 80.0625 | 80.0875 | 61364.0 |
| 2020-01-30 07:55:00 | AAPL | Stock | 80.0675 | 80.105 | 80.025 | 80.045 | 19692.0 |
| 2020-01-30 08:00:00 | AAPL | Stock | 80.2625 | 80.3625 | 79.9125 | 79.9625 | 192984.0 |
| 2020-01-30 08:05:00 | AAPL | Stock | 79.9675 | 80.0225 | 79.925 | 79.925 | 67320.0 |
| 2020-01-30 08:10:00 | AAPL | Stock | 79.92 | 79.975 | 79.8125 | 79.975 | 71816.0 |
| 2020-01-30 08:15:00 | AAPL | Stock | 79.94 | 80.03 | 79.9375 | 79.9375 | 95060.0 |
> showing 50 of 371,464 rows — these rows as CSV