PREVIEW / stock_5min / 2019-10-22
file: by_date/stock_5min/2019/2019-10-22.parquet size: 5.6 MB rows: 349,232 symbols: 2,493
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-10-22 04:00:00 | AAPL | Stock | 60.1275 | 60.1275 | 60.1275 | 60.1275 | 656.0 |
| 2019-10-22 04:05:00 | AAPL | Stock | 60.135 | 60.135 | 60.135 | 60.135 | 4000.0 |
| 2019-10-22 05:00:00 | AAPL | Stock | 60.095 | 60.11 | 60.095 | 60.11 | 2000.0 |
| 2019-10-22 05:15:00 | AAPL | Stock | 60.135 | 60.135 | 60.135 | 60.135 | 3688.0 |
| 2019-10-22 05:50:00 | AAPL | Stock | 60.1925 | 60.1925 | 60.1925 | 60.1925 | 1200.0 |
| 2019-10-22 05:55:00 | AAPL | Stock | 60.1975 | 60.1975 | 60.1975 | 60.1975 | 400.0 |
| 2019-10-22 06:05:00 | AAPL | Stock | 60.215 | 60.2175 | 60.215 | 60.2175 | 1296.0 |
| 2019-10-22 06:15:00 | AAPL | Stock | 60.1825 | 60.1825 | 60.1825 | 60.1825 | 800.0 |
| 2019-10-22 06:20:00 | AAPL | Stock | 60.1525 | 60.1525 | 60.1525 | 60.1525 | 4000.0 |
| 2019-10-22 06:30:00 | AAPL | Stock | 60.1725 | 60.1725 | 60.1725 | 60.1725 | 400.0 |
| 2019-10-22 06:40:00 | AAPL | Stock | 60.1725 | 60.1825 | 60.1725 | 60.1825 | 3200.0 |
| 2019-10-22 06:45:00 | AAPL | Stock | 60.1825 | 60.1825 | 60.1825 | 60.1825 | 2000.0 |
| 2019-10-22 07:00:00 | AAPL | Stock | 60.215 | 60.235 | 60.1825 | 60.2 | 11348.0 |
| 2019-10-22 07:05:00 | AAPL | Stock | 60.1875 | 60.2 | 60.1875 | 60.2 | 5424.0 |
| 2019-10-22 07:10:00 | AAPL | Stock | 60.1875 | 60.2 | 60.175 | 60.2 | 7540.0 |
| 2019-10-22 07:15:00 | AAPL | Stock | 60.2 | 60.2 | 60.195 | 60.195 | 800.0 |
| 2019-10-22 07:20:00 | AAPL | Stock | 60.2 | 60.2125 | 60.1875 | 60.1875 | 13800.0 |
| 2019-10-22 07:25:00 | AAPL | Stock | 60.1775 | 60.19 | 60.17 | 60.1875 | 12800.0 |
| 2019-10-22 07:30:00 | AAPL | Stock | 60.2125 | 60.2375 | 60.19 | 60.19 | 9448.0 |
| 2019-10-22 07:35:00 | AAPL | Stock | 60.21 | 60.255 | 60.21 | 60.2525 | 20728.0 |
| 2019-10-22 07:40:00 | AAPL | Stock | 60.25 | 60.3375 | 60.2425 | 60.3375 | 48560.0 |
| 2019-10-22 07:45:00 | AAPL | Stock | 60.325 | 60.335 | 60.265 | 60.3 | 29004.0 |
| 2019-10-22 07:50:00 | AAPL | Stock | 60.3125 | 60.3125 | 60.3 | 60.3 | 14800.0 |
| 2019-10-22 07:55:00 | AAPL | Stock | 60.3125 | 60.3125 | 60.2925 | 60.3 | 3252.0 |
| 2019-10-22 08:00:00 | AAPL | Stock | 60.2125 | 60.3375 | 60.175 | 60.305 | 147120.0 |
| 2019-10-22 08:05:00 | AAPL | Stock | 60.3 | 60.3 | 60.275 | 60.2875 | 31116.0 |
| 2019-10-22 08:10:00 | AAPL | Stock | 60.2875 | 60.3025 | 60.2875 | 60.3025 | 45660.0 |
| 2019-10-22 08:15:00 | AAPL | Stock | 60.325 | 60.325 | 60.3125 | 60.3125 | 19452.0 |
| 2019-10-22 08:20:00 | AAPL | Stock | 60.325 | 60.3575 | 60.32 | 60.3475 | 27544.0 |
| 2019-10-22 08:25:00 | AAPL | Stock | 60.355 | 60.3725 | 60.325 | 60.3375 | 40160.0 |
| 2019-10-22 08:30:00 | AAPL | Stock | 60.345 | 60.3525 | 60.3275 | 60.3475 | 13040.0 |
| 2019-10-22 08:35:00 | AAPL | Stock | 60.3375 | 60.3675 | 60.3375 | 60.3525 | 28940.0 |
| 2019-10-22 08:40:00 | AAPL | Stock | 60.3425 | 60.3425 | 60.2975 | 60.2975 | 39856.0 |
| 2019-10-22 08:45:00 | AAPL | Stock | 60.2975 | 60.3125 | 60.295 | 60.2975 | 6692.0 |
| 2019-10-22 08:50:00 | AAPL | Stock | 60.3 | 60.3125 | 60.3 | 60.3125 | 9484.0 |
| 2019-10-22 08:55:00 | AAPL | Stock | 60.31 | 60.3225 | 60.2975 | 60.2975 | 19948.0 |
| 2019-10-22 09:00:00 | AAPL | Stock | 60.295 | 60.31 | 60.295 | 60.3 | 12368.0 |
| 2019-10-22 09:05:00 | AAPL | Stock | 60.3 | 60.3 | 60.25 | 60.25 | 63724.0 |
| 2019-10-22 09:10:00 | AAPL | Stock | 60.25 | 60.2875 | 60.25 | 60.2775 | 9588.0 |
| 2019-10-22 09:15:00 | AAPL | Stock | 60.275 | 60.295 | 60.255 | 60.2675 | 13148.0 |
| 2019-10-22 09:20:00 | AAPL | Stock | 60.2575 | 60.2675 | 60.2325 | 60.235 | 67652.0 |
| 2019-10-22 09:25:00 | AAPL | Stock | 60.2475 | 60.32 | 60.2375 | 60.29 | 64372.0 |
| 2019-10-22 09:30:00 | AAPL | Stock | 60.28 | 60.3788 | 60.215 | 60.265 | 4151868.0 |
| 2019-10-22 09:35:00 | AAPL | Stock | 60.27 | 60.4 | 60.2025 | 60.3475 | 2209304.0 |
| 2019-10-22 09:40:00 | AAPL | Stock | 60.35 | 60.4875 | 60.345 | 60.38 | 2200708.0 |
| 2019-10-22 09:45:00 | AAPL | Stock | 60.385 | 60.4225 | 60.0825 | 60.1478 | 2295292.0 |
| 2019-10-22 09:50:00 | AAPL | Stock | 60.15 | 60.1925 | 60.075 | 60.1902 | 1376500.0 |
| 2019-10-22 09:55:00 | AAPL | Stock | 60.19 | 60.28 | 60.1822 | 60.2562 | 1143912.0 |
| 2019-10-22 10:00:00 | AAPL | Stock | 60.26 | 60.2775 | 60.175 | 60.2225 | 1036044.0 |
| 2019-10-22 10:05:00 | AAPL | Stock | 60.2118 | 60.2925 | 60.1925 | 60.25 | 709724.0 |
> showing 50 of 349,232 rows — these rows as CSV