PREVIEW / stock_1min / 2019-08-09
file: by_date/stock_1min/2019/2019-08-09.parquet size: 15.4 MB rows: 1,089,324 symbols: 2,156
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-08-09 04:00:00 | AAPL | Stock | 50.375 | 50.375 | 50.375 | 50.375 | 440.0 |
| 2019-08-09 04:12:00 | AAPL | Stock | 50.3625 | 50.3625 | 50.3625 | 50.3625 | 2000.0 |
| 2019-08-09 04:13:00 | AAPL | Stock | 50.3625 | 50.3625 | 50.3625 | 50.3625 | 4000.0 |
| 2019-08-09 04:14:00 | AAPL | Stock | 50.3625 | 50.3625 | 50.3625 | 50.3625 | 4000.0 |
| 2019-08-09 04:15:00 | AAPL | Stock | 50.3625 | 50.3625 | 50.3625 | 50.3625 | 2400.0 |
| 2019-08-09 04:16:00 | AAPL | Stock | 50.27 | 50.27 | 50.27 | 50.27 | 400.0 |
| 2019-08-09 04:22:00 | AAPL | Stock | 50.2625 | 50.2625 | 50.25 | 50.25 | 4600.0 |
| 2019-08-09 04:26:00 | AAPL | Stock | 50.25 | 50.25 | 50.25 | 50.25 | 1600.0 |
| 2019-08-09 04:45:00 | AAPL | Stock | 50.25 | 50.25 | 50.25 | 50.25 | 400.0 |
| 2019-08-09 04:55:00 | AAPL | Stock | 50.2975 | 50.2975 | 50.2975 | 50.2975 | 400.0 |
| 2019-08-09 05:00:00 | AAPL | Stock | 50.2975 | 50.2975 | 50.2975 | 50.2975 | 400.0 |
| 2019-08-09 05:15:00 | AAPL | Stock | 50.3075 | 50.3075 | 50.3075 | 50.3075 | 1016.0 |
| 2019-08-09 05:17:00 | AAPL | Stock | 50.375 | 50.375 | 50.375 | 50.375 | 2360.0 |
| 2019-08-09 05:31:00 | AAPL | Stock | 50.2925 | 50.2925 | 50.2925 | 50.2925 | 400.0 |
| 2019-08-09 05:36:00 | AAPL | Stock | 50.25 | 50.25 | 50.25 | 50.25 | 400.0 |
| 2019-08-09 05:43:00 | AAPL | Stock | 50.25 | 50.2975 | 50.25 | 50.2975 | 1600.0 |
| 2019-08-09 05:49:00 | AAPL | Stock | 50.25 | 50.25 | 50.25 | 50.25 | 1480.0 |
| 2019-08-09 05:52:00 | AAPL | Stock | 50.2775 | 50.2775 | 50.2 | 50.2 | 5504.0 |
| 2019-08-09 05:53:00 | AAPL | Stock | 50.205 | 50.205 | 50.205 | 50.205 | 1200.0 |
| 2019-08-09 05:56:00 | AAPL | Stock | 50.205 | 50.2125 | 50.2 | 50.2125 | 2800.0 |
| 2019-08-09 06:02:00 | AAPL | Stock | 50.2275 | 50.2275 | 50.2275 | 50.2275 | 400.0 |
| 2019-08-09 06:05:00 | AAPL | Stock | 50.2525 | 50.27 | 50.2525 | 50.27 | 800.0 |
| 2019-08-09 06:06:00 | AAPL | Stock | 50.2525 | 50.2525 | 50.21 | 50.21 | 1200.0 |
| 2019-08-09 06:08:00 | AAPL | Stock | 50.1875 | 50.1875 | 50.1875 | 50.1875 | 400.0 |
| 2019-08-09 06:10:00 | AAPL | Stock | 50.2475 | 50.2475 | 50.2475 | 50.2475 | 400.0 |
| 2019-08-09 06:18:00 | AAPL | Stock | 50.275 | 50.275 | 50.275 | 50.275 | 400.0 |
| 2019-08-09 06:22:00 | AAPL | Stock | 50.275 | 50.275 | 50.275 | 50.275 | 400.0 |
| 2019-08-09 06:24:00 | AAPL | Stock | 50.25 | 50.25 | 50.25 | 50.25 | 416.0 |
| 2019-08-09 06:25:00 | AAPL | Stock | 50.2025 | 50.2025 | 50.185 | 50.185 | 3600.0 |
| 2019-08-09 06:26:00 | AAPL | Stock | 50.1825 | 50.1825 | 50.1825 | 50.1825 | 400.0 |
| 2019-08-09 06:40:00 | AAPL | Stock | 50.1825 | 50.1825 | 50.1825 | 50.1825 | 400.0 |
| 2019-08-09 06:45:00 | AAPL | Stock | 50.2 | 50.2 | 50.2 | 50.2 | 400.0 |
| 2019-08-09 06:49:00 | AAPL | Stock | 50.185 | 50.1975 | 50.185 | 50.1975 | 1200.0 |
| 2019-08-09 06:58:00 | AAPL | Stock | 50.1875 | 50.1875 | 50.1875 | 50.1875 | 800.0 |
| 2019-08-09 07:00:00 | AAPL | Stock | 50.25 | 50.325 | 50.25 | 50.25 | 17824.0 |
| 2019-08-09 07:01:00 | AAPL | Stock | 50.275 | 50.275 | 50.275 | 50.275 | 3596.0 |
| 2019-08-09 07:02:00 | AAPL | Stock | 50.2525 | 50.255 | 50.25 | 50.25 | 13604.0 |
| 2019-08-09 07:03:00 | AAPL | Stock | 50.2125 | 50.2525 | 50.1875 | 50.2525 | 7400.0 |
| 2019-08-09 07:04:00 | AAPL | Stock | 50.25 | 50.25 | 50.25 | 50.25 | 1960.0 |
| 2019-08-09 07:06:00 | AAPL | Stock | 50.2525 | 50.2525 | 50.2375 | 50.2375 | 10416.0 |
| 2019-08-09 07:07:00 | AAPL | Stock | 50.2025 | 50.2025 | 50.195 | 50.195 | 1940.0 |
| 2019-08-09 07:11:00 | AAPL | Stock | 50.1875 | 50.1875 | 50.1875 | 50.1875 | 1800.0 |
| 2019-08-09 07:12:00 | AAPL | Stock | 50.2 | 50.2 | 50.125 | 50.125 | 10000.0 |
| 2019-08-09 07:13:00 | AAPL | Stock | 50.125 | 50.15 | 50.125 | 50.15 | 1600.0 |
| 2019-08-09 07:15:00 | AAPL | Stock | 50.1575 | 50.1575 | 50.1575 | 50.1575 | 400.0 |
| 2019-08-09 07:16:00 | AAPL | Stock | 50.14 | 50.1625 | 50.125 | 50.1625 | 6180.0 |
| 2019-08-09 07:19:00 | AAPL | Stock | 50.1625 | 50.1625 | 50.1625 | 50.1625 | 2000.0 |
| 2019-08-09 07:20:00 | AAPL | Stock | 50.1625 | 50.1625 | 50.1625 | 50.1625 | 1200.0 |
| 2019-08-09 07:21:00 | AAPL | Stock | 50.1625 | 50.1625 | 50.1625 | 50.1625 | 800.0 |
| 2019-08-09 07:22:00 | AAPL | Stock | 50.14 | 50.14 | 50.125 | 50.125 | 7760.0 |
> showing 50 of 1,089,324 rows — these rows as CSV