PREVIEW / stock_1min / 2019-09-27
file: by_date/stock_1min/2019/2019-09-27.parquet size: 15.2 MB rows: 1,085,288 symbols: 2,146
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 |
|---|---|---|---|---|---|---|---|
| 2019-09-27 04:17:00 | AAPL | Stock | 54.975 | 54.975 | 54.975 | 54.975 | 400.0 |
| 2019-09-27 04:23:00 | AAPL | Stock | 55.0125 | 55.0125 | 55.0125 | 55.0125 | 400.0 |
| 2019-09-27 04:24:00 | AAPL | Stock | 55.0125 | 55.0125 | 55.0125 | 55.0125 | 1600.0 |
| 2019-09-27 04:25:00 | AAPL | Stock | 55.025 | 55.025 | 55.025 | 55.025 | 400.0 |
| 2019-09-27 05:31:00 | AAPL | Stock | 55.0975 | 55.1 | 55.0975 | 55.1 | 3200.0 |
| 2019-09-27 05:33:00 | AAPL | Stock | 55.075 | 55.075 | 55.075 | 55.075 | 2000.0 |
| 2019-09-27 05:49:00 | AAPL | Stock | 55.0725 | 55.0725 | 55.0725 | 55.0725 | 1200.0 |
| 2019-09-27 06:12:00 | AAPL | Stock | 55.0725 | 55.075 | 55.0725 | 55.075 | 10152.0 |
| 2019-09-27 06:17:00 | AAPL | Stock | 55.16 | 55.16 | 55.16 | 55.16 | 800.0 |
| 2019-09-27 07:00:00 | AAPL | Stock | 55.1025 | 55.145 | 55.1025 | 55.145 | 2484.0 |
| 2019-09-27 07:01:00 | AAPL | Stock | 55.15 | 55.15 | 55.15 | 55.15 | 896.0 |
| 2019-09-27 07:02:00 | AAPL | Stock | 55.145 | 55.145 | 55.125 | 55.125 | 2000.0 |
| 2019-09-27 07:04:00 | AAPL | Stock | 55.125 | 55.125 | 55.125 | 55.125 | 2420.0 |
| 2019-09-27 07:08:00 | AAPL | Stock | 55.15 | 55.15 | 55.15 | 55.15 | 600.0 |
| 2019-09-27 07:10:00 | AAPL | Stock | 55.145 | 55.145 | 55.145 | 55.145 | 1000.0 |
| 2019-09-27 07:11:00 | AAPL | Stock | 55.145 | 55.145 | 55.145 | 55.145 | 800.0 |
| 2019-09-27 07:13:00 | AAPL | Stock | 55.135 | 55.135 | 55.13 | 55.13 | 6800.0 |
| 2019-09-27 07:20:00 | AAPL | Stock | 55.13 | 55.13 | 55.13 | 55.13 | 400.0 |
| 2019-09-27 07:22:00 | AAPL | Stock | 55.125 | 55.125 | 55.125 | 55.125 | 400.0 |
| 2019-09-27 07:24:00 | AAPL | Stock | 55.125 | 55.125 | 55.125 | 55.125 | 800.0 |
| 2019-09-27 07:28:00 | AAPL | Stock | 55.075 | 55.1125 | 55.075 | 55.1125 | 2172.0 |
| 2019-09-27 07:30:00 | AAPL | Stock | 55.11 | 55.11 | 55.11 | 55.11 | 2000.0 |
| 2019-09-27 07:31:00 | AAPL | Stock | 55.095 | 55.095 | 55.09 | 55.09 | 1200.0 |
| 2019-09-27 07:32:00 | AAPL | Stock | 55.1125 | 55.12 | 55.1125 | 55.12 | 1104.0 |
| 2019-09-27 07:35:00 | AAPL | Stock | 55.1125 | 55.1125 | 55.1125 | 55.1125 | 1232.0 |
| 2019-09-27 07:37:00 | AAPL | Stock | 55.1175 | 55.1175 | 55.1175 | 55.1175 | 760.0 |
| 2019-09-27 07:39:00 | AAPL | Stock | 55.11 | 55.11 | 55.11 | 55.11 | 400.0 |
| 2019-09-27 07:43:00 | AAPL | Stock | 55.12 | 55.12 | 55.12 | 55.12 | 2444.0 |
| 2019-09-27 07:44:00 | AAPL | Stock | 55.125 | 55.125 | 55.125 | 55.125 | 1856.0 |
| 2019-09-27 07:51:00 | AAPL | Stock | 55.1125 | 55.1125 | 55.1125 | 55.1125 | 800.0 |
| 2019-09-27 07:53:00 | AAPL | Stock | 55.11 | 55.11 | 55.11 | 55.11 | 800.0 |
| 2019-09-27 07:54:00 | AAPL | Stock | 55.12 | 55.145 | 55.12 | 55.145 | 4200.0 |
| 2019-09-27 08:00:00 | AAPL | Stock | 55.15 | 55.195 | 55.11 | 55.11 | 23176.0 |
| 2019-09-27 08:01:00 | AAPL | Stock | 55.1275 | 55.1275 | 55.1275 | 55.1275 | 1200.0 |
| 2019-09-27 08:02:00 | AAPL | Stock | 55.1275 | 55.1275 | 55.1275 | 55.1275 | 600.0 |
| 2019-09-27 08:04:00 | AAPL | Stock | 55.1325 | 55.1325 | 55.1275 | 55.1275 | 5988.0 |
| 2019-09-27 08:05:00 | AAPL | Stock | 55.1405 | 55.1405 | 55.13 | 55.13 | 900.0 |
| 2019-09-27 08:06:00 | AAPL | Stock | 55.1375 | 55.15 | 55.1375 | 55.15 | 26712.0 |
| 2019-09-27 08:07:00 | AAPL | Stock | 55.15 | 55.15 | 55.15 | 55.15 | 400.0 |
| 2019-09-27 08:08:00 | AAPL | Stock | 55.1575 | 55.16 | 55.1375 | 55.1375 | 2800.0 |
| 2019-09-27 08:10:00 | AAPL | Stock | 55.1375 | 55.1375 | 55.1375 | 55.1375 | 440.0 |
| 2019-09-27 08:11:00 | AAPL | Stock | 55.14 | 55.14 | 55.14 | 55.14 | 6096.0 |
| 2019-09-27 08:12:00 | AAPL | Stock | 55.125 | 55.125 | 55.1125 | 55.1125 | 2600.0 |
| 2019-09-27 08:14:00 | AAPL | Stock | 55.12 | 55.12 | 55.12 | 55.12 | 400.0 |
| 2019-09-27 08:16:00 | AAPL | Stock | 55.1125 | 55.1125 | 55.1125 | 55.1125 | 1600.0 |
| 2019-09-27 08:17:00 | AAPL | Stock | 55.09 | 55.09 | 55.09 | 55.09 | 400.0 |
| 2019-09-27 08:18:00 | AAPL | Stock | 55.08 | 55.08 | 55.08 | 55.08 | 800.0 |
| 2019-09-27 08:19:00 | AAPL | Stock | 55.0925 | 55.0925 | 55.0925 | 55.0925 | 1620.0 |
| 2019-09-27 08:20:00 | AAPL | Stock | 55.08 | 55.08 | 55.0725 | 55.0725 | 1596.0 |
| 2019-09-27 08:21:00 | AAPL | Stock | 55.08 | 55.08 | 55.08 | 55.08 | 400.0 |
> showing 50 of 1,085,288 rows — these rows as CSV