PREVIEW / stock_5min / 2019-04-11
file: by_date/stock_5min/2019/2019-04-11.parquet size: 5.5 MB rows: 348,916 symbols: 2,625
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-04-11 04:20:00 | AAPL | Stock | 50.0975 | 50.0975 | 50.0975 | 50.0975 | 408.0 |
| 2019-04-11 04:30:00 | AAPL | Stock | 50.1225 | 50.125 | 50.1225 | 50.125 | 4012.0 |
| 2019-04-11 05:00:00 | AAPL | Stock | 50.125 | 50.125 | 50.125 | 50.125 | 2072.0 |
| 2019-04-11 05:20:00 | AAPL | Stock | 50.15 | 50.15 | 50.15 | 50.15 | 1996.0 |
| 2019-04-11 05:30:00 | AAPL | Stock | 50.125 | 50.125 | 50.125 | 50.125 | 800.0 |
| 2019-04-11 05:35:00 | AAPL | Stock | 50.1 | 50.1 | 50.1 | 50.1 | 10004.0 |
| 2019-04-11 05:45:00 | AAPL | Stock | 50.09 | 50.09 | 50.09 | 50.09 | 2000.0 |
| 2019-04-11 06:05:00 | AAPL | Stock | 50.1525 | 50.175 | 50.1525 | 50.175 | 1212.0 |
| 2019-04-11 06:20:00 | AAPL | Stock | 50.175 | 50.175 | 50.175 | 50.175 | 800.0 |
| 2019-04-11 06:40:00 | AAPL | Stock | 50.15 | 50.15 | 50.15 | 50.15 | 400.0 |
| 2019-04-11 06:45:00 | AAPL | Stock | 50.17 | 50.175 | 50.17 | 50.175 | 3184.0 |
| 2019-04-11 06:50:00 | AAPL | Stock | 50.175 | 50.175 | 50.175 | 50.175 | 400.0 |
| 2019-04-11 06:55:00 | AAPL | Stock | 50.125 | 50.125 | 50.125 | 50.125 | 480.0 |
| 2019-04-11 07:00:00 | AAPL | Stock | 50.1875 | 50.25 | 50.155 | 50.225 | 45720.0 |
| 2019-04-11 07:05:00 | AAPL | Stock | 50.235 | 50.235 | 50.235 | 50.235 | 2000.0 |
| 2019-04-11 07:10:00 | AAPL | Stock | 50.22 | 50.22 | 50.2125 | 50.22 | 5060.0 |
| 2019-04-11 07:15:00 | AAPL | Stock | 50.2025 | 50.225 | 50.2025 | 50.225 | 4076.0 |
| 2019-04-11 07:20:00 | AAPL | Stock | 50.2125 | 50.275 | 50.2125 | 50.24 | 27224.0 |
| 2019-04-11 07:25:00 | AAPL | Stock | 50.25 | 50.2875 | 50.25 | 50.25 | 11592.0 |
| 2019-04-11 07:30:00 | AAPL | Stock | 50.3 | 50.31 | 50.27 | 50.27 | 18800.0 |
| 2019-04-11 07:35:00 | AAPL | Stock | 50.2925 | 50.2925 | 50.265 | 50.275 | 21144.0 |
| 2019-04-11 07:40:00 | AAPL | Stock | 50.265 | 50.275 | 50.2375 | 50.2725 | 40236.0 |
| 2019-04-11 07:45:00 | AAPL | Stock | 50.27 | 50.32 | 50.27 | 50.32 | 4200.0 |
| 2019-04-11 07:50:00 | AAPL | Stock | 50.32 | 50.32 | 50.2875 | 50.2875 | 6196.0 |
| 2019-04-11 07:55:00 | AAPL | Stock | 50.2875 | 50.2875 | 50.25 | 50.25 | 22668.0 |
| 2019-04-11 08:00:00 | AAPL | Stock | 50.2242 | 50.32 | 50.1475 | 50.2175 | 87408.0 |
| 2019-04-11 08:05:00 | AAPL | Stock | 50.25 | 50.25 | 50.2125 | 50.235 | 17040.0 |
| 2019-04-11 08:10:00 | AAPL | Stock | 50.2125 | 50.2125 | 50.2125 | 50.2125 | 996.0 |
| 2019-04-11 08:15:00 | AAPL | Stock | 50.2225 | 50.23 | 50.2 | 50.2 | 17860.0 |
| 2019-04-11 08:20:00 | AAPL | Stock | 50.195 | 50.25 | 50.195 | 50.25 | 6996.0 |
| 2019-04-11 08:25:00 | AAPL | Stock | 50.25 | 50.25 | 50.2475 | 50.25 | 6444.0 |
| 2019-04-11 08:30:00 | AAPL | Stock | 50.2775 | 50.2775 | 50.21 | 50.275 | 54388.0 |
| 2019-04-11 08:35:00 | AAPL | Stock | 50.2725 | 50.275 | 50.25 | 50.2725 | 10340.0 |
| 2019-04-11 08:40:00 | AAPL | Stock | 50.2575 | 50.2575 | 50.225 | 50.2275 | 11680.0 |
| 2019-04-11 08:45:00 | AAPL | Stock | 50.25 | 50.2725 | 50.25 | 50.2725 | 6732.0 |
| 2019-04-11 08:50:00 | AAPL | Stock | 50.255 | 50.2575 | 50.255 | 50.2575 | 1376.0 |
| 2019-04-11 08:55:00 | AAPL | Stock | 50.2575 | 50.2575 | 50.2 | 50.2075 | 30740.0 |
| 2019-04-11 09:00:00 | AAPL | Stock | 50.2125 | 50.245 | 50.2125 | 50.2425 | 7800.0 |
| 2019-04-11 09:05:00 | AAPL | Stock | 50.245 | 50.2875 | 50.2425 | 50.2675 | 26988.0 |
| 2019-04-11 09:10:00 | AAPL | Stock | 50.265 | 50.2875 | 50.2475 | 50.25 | 14980.0 |
| 2019-04-11 09:15:00 | AAPL | Stock | 50.2525 | 50.28 | 50.2475 | 50.265 | 11980.0 |
| 2019-04-11 09:20:00 | AAPL | Stock | 50.2675 | 50.2675 | 50.2175 | 50.225 | 45184.0 |
| 2019-04-11 09:25:00 | AAPL | Stock | 50.2075 | 50.225 | 50.165 | 50.195 | 33188.0 |
| 2019-04-11 09:30:00 | AAPL | Stock | 50.2125 | 50.25 | 49.9725 | 50.0995 | 4700584.0 |
| 2019-04-11 09:35:00 | AAPL | Stock | 50.1015 | 50.1075 | 49.94 | 49.9798 | 2318804.0 |
| 2019-04-11 09:40:00 | AAPL | Stock | 49.9775 | 50.045 | 49.94 | 50.0 | 1933096.0 |
| 2019-04-11 09:45:00 | AAPL | Stock | 49.9958 | 50.1175 | 49.94 | 50.101 | 1598204.0 |
| 2019-04-11 09:50:00 | AAPL | Stock | 50.1025 | 50.15 | 50.055 | 50.0975 | 1722116.0 |
| 2019-04-11 09:55:00 | AAPL | Stock | 50.0975 | 50.155 | 50.07 | 50.12 | 1043292.0 |
| 2019-04-11 10:00:00 | AAPL | Stock | 50.125 | 50.14 | 50.0075 | 50.0825 | 957240.0 |
> showing 50 of 348,916 rows — these rows as CSV