PREVIEW / stock_5min / 2020-06-10
file: by_date/stock_5min/2020/2020-06-10.parquet size: 6.9 MB rows: 434,569 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-10 04:00:00 | AAPL | Stock | 86.505 | 86.82 | 86.505 | 86.75 | 16184.0 |
| 2020-06-10 04:05:00 | AAPL | Stock | 86.6775 | 86.6775 | 86.6 | 86.625 | 14560.0 |
| 2020-06-10 04:10:00 | AAPL | Stock | 86.6575 | 86.665 | 86.6 | 86.62 | 6880.0 |
| 2020-06-10 04:15:00 | AAPL | Stock | 86.63 | 86.63 | 86.63 | 86.63 | 400.0 |
| 2020-06-10 04:25:00 | AAPL | Stock | 86.7 | 86.7 | 86.7 | 86.7 | 400.0 |
| 2020-06-10 04:30:00 | AAPL | Stock | 86.7375 | 86.7375 | 86.7375 | 86.7375 | 400.0 |
| 2020-06-10 04:35:00 | AAPL | Stock | 86.68 | 86.7125 | 86.675 | 86.675 | 1200.0 |
| 2020-06-10 04:45:00 | AAPL | Stock | 86.6475 | 86.6475 | 86.63 | 86.63 | 2396.0 |
| 2020-06-10 04:50:00 | AAPL | Stock | 86.635 | 86.635 | 86.635 | 86.635 | 1600.0 |
| 2020-06-10 04:55:00 | AAPL | Stock | 86.6 | 86.6 | 86.6 | 86.6 | 400.0 |
| 2020-06-10 05:00:00 | AAPL | Stock | 86.505 | 86.505 | 86.375 | 86.375 | 6448.0 |
| 2020-06-10 05:05:00 | AAPL | Stock | 86.45 | 86.45 | 86.425 | 86.425 | 2140.0 |
| 2020-06-10 05:15:00 | AAPL | Stock | 86.4675 | 86.4675 | 86.4675 | 86.4675 | 800.0 |
| 2020-06-10 05:30:00 | AAPL | Stock | 86.495 | 86.495 | 86.495 | 86.495 | 400.0 |
| 2020-06-10 05:35:00 | AAPL | Stock | 86.415 | 86.415 | 86.415 | 86.415 | 888.0 |
| 2020-06-10 05:50:00 | AAPL | Stock | 86.415 | 86.415 | 86.4125 | 86.4125 | 1172.0 |
| 2020-06-10 06:00:00 | AAPL | Stock | 86.375 | 86.375 | 86.375 | 86.375 | 2436.0 |
| 2020-06-10 06:15:00 | AAPL | Stock | 86.0575 | 86.0825 | 86.0575 | 86.08 | 3776.0 |
| 2020-06-10 06:20:00 | AAPL | Stock | 86.1575 | 86.1575 | 86.1575 | 86.1575 | 2000.0 |
| 2020-06-10 06:25:00 | AAPL | Stock | 86.25 | 86.26 | 86.25 | 86.26 | 1884.0 |
| 2020-06-10 06:30:00 | AAPL | Stock | 86.1525 | 86.1525 | 86.135 | 86.135 | 10720.0 |
| 2020-06-10 06:35:00 | AAPL | Stock | 86.1375 | 86.1425 | 86.135 | 86.135 | 5848.0 |
| 2020-06-10 06:45:00 | AAPL | Stock | 86.24 | 86.24 | 86.24 | 86.24 | 1668.0 |
| 2020-06-10 06:50:00 | AAPL | Stock | 86.24 | 86.2625 | 86.24 | 86.2625 | 4000.0 |
| 2020-06-10 07:00:00 | AAPL | Stock | 86.36 | 86.6225 | 86.33 | 86.6225 | 42356.0 |
| 2020-06-10 07:05:00 | AAPL | Stock | 86.5775 | 86.83 | 86.5725 | 86.8 | 58560.0 |
| 2020-06-10 07:10:00 | AAPL | Stock | 86.78 | 86.85 | 86.75 | 86.8325 | 28888.0 |
| 2020-06-10 07:15:00 | AAPL | Stock | 86.805 | 86.8725 | 86.75 | 86.755 | 33620.0 |
| 2020-06-10 07:20:00 | AAPL | Stock | 86.8 | 86.8525 | 86.7875 | 86.8175 | 36300.0 |
| 2020-06-10 07:25:00 | AAPL | Stock | 86.775 | 86.7775 | 86.6975 | 86.775 | 27572.0 |
| 2020-06-10 07:30:00 | AAPL | Stock | 86.775 | 86.8475 | 86.75 | 86.8375 | 31456.0 |
| 2020-06-10 07:35:00 | AAPL | Stock | 86.8475 | 87.1975 | 86.8475 | 87.125 | 61868.0 |
| 2020-06-10 07:40:00 | AAPL | Stock | 87.175 | 87.275 | 87.1425 | 87.165 | 111680.0 |
| 2020-06-10 07:45:00 | AAPL | Stock | 87.1275 | 87.1825 | 87.0875 | 87.0875 | 24280.0 |
| 2020-06-10 07:50:00 | AAPL | Stock | 87.0925 | 87.105 | 87.02 | 87.0275 | 12692.0 |
| 2020-06-10 07:55:00 | AAPL | Stock | 87.0375 | 87.2175 | 87.0375 | 87.175 | 79320.0 |
| 2020-06-10 08:00:00 | AAPL | Stock | 86.7992 | 87.25 | 86.35 | 87.125 | 316332.0 |
| 2020-06-10 08:05:00 | AAPL | Stock | 87.15 | 87.1875 | 87.1275 | 87.14 | 50128.0 |
| 2020-06-10 08:10:00 | AAPL | Stock | 87.1075 | 87.1875 | 87.07 | 87.17 | 45688.0 |
| 2020-06-10 08:15:00 | AAPL | Stock | 87.1625 | 87.1875 | 87.055 | 87.0775 | 27248.0 |
| 2020-06-10 08:20:00 | AAPL | Stock | 87.0775 | 87.1 | 87.0025 | 87.0225 | 28244.0 |
| 2020-06-10 08:25:00 | AAPL | Stock | 87.0025 | 87.05 | 86.9525 | 87.0 | 69776.0 |
| 2020-06-10 08:30:00 | AAPL | Stock | 87.025 | 87.075 | 87.0 | 87.0075 | 38680.0 |
| 2020-06-10 08:35:00 | AAPL | Stock | 87.0075 | 87.05 | 87.0 | 87.0375 | 20652.0 |
| 2020-06-10 08:40:00 | AAPL | Stock | 87.025 | 87.0575 | 87.0225 | 87.05 | 19072.0 |
| 2020-06-10 08:45:00 | AAPL | Stock | 87.06 | 87.175 | 87.05 | 87.175 | 32196.0 |
| 2020-06-10 08:50:00 | AAPL | Stock | 87.175 | 87.235 | 87.1 | 87.1025 | 59264.0 |
| 2020-06-10 08:55:00 | AAPL | Stock | 87.1 | 87.13 | 87.05 | 87.1225 | 32780.0 |
| 2020-06-10 09:00:00 | AAPL | Stock | 87.125 | 87.175 | 87.06 | 87.1 | 70712.0 |
| 2020-06-10 09:05:00 | AAPL | Stock | 87.1 | 87.125 | 87.1 | 87.1225 | 13924.0 |
> showing 50 of 434,569 rows — these rows as CSV