PREVIEW / stock_5min / 2019-05-22
file: by_date/stock_5min/2019/2019-05-22.parquet size: 5.5 MB rows: 348,994 symbols: 2,601
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-05-22 04:15:00 | AAPL | Stock | 46.445 | 46.445 | 46.445 | 46.445 | 1200.0 |
| 2019-05-22 04:25:00 | AAPL | Stock | 46.4175 | 46.4175 | 46.4175 | 46.4175 | 6072.0 |
| 2019-05-22 04:30:00 | AAPL | Stock | 46.375 | 46.375 | 46.375 | 46.375 | 400.0 |
| 2019-05-22 04:40:00 | AAPL | Stock | 46.425 | 46.425 | 46.425 | 46.425 | 1700.0 |
| 2019-05-22 04:50:00 | AAPL | Stock | 46.375 | 46.375 | 46.375 | 46.375 | 400.0 |
| 2019-05-22 05:10:00 | AAPL | Stock | 46.34 | 46.34 | 46.3275 | 46.3275 | 1600.0 |
| 2019-05-22 05:15:00 | AAPL | Stock | 46.3675 | 46.375 | 46.3375 | 46.3375 | 9064.0 |
| 2019-05-22 05:20:00 | AAPL | Stock | 46.3375 | 46.3375 | 46.3 | 46.3 | 1764.0 |
| 2019-05-22 05:25:00 | AAPL | Stock | 46.3325 | 46.3375 | 46.3325 | 46.3375 | 4176.0 |
| 2019-05-22 05:30:00 | AAPL | Stock | 46.3125 | 46.3125 | 46.255 | 46.255 | 2848.0 |
| 2019-05-22 05:35:00 | AAPL | Stock | 46.25 | 46.25 | 46.1875 | 46.1875 | 1604.0 |
| 2019-05-22 05:45:00 | AAPL | Stock | 46.155 | 46.225 | 46.155 | 46.2075 | 10088.0 |
| 2019-05-22 05:55:00 | AAPL | Stock | 46.2125 | 46.225 | 46.2125 | 46.225 | 2052.0 |
| 2019-05-22 06:00:00 | AAPL | Stock | 46.225 | 46.2875 | 46.225 | 46.2875 | 4228.0 |
| 2019-05-22 06:05:00 | AAPL | Stock | 46.29 | 46.29 | 46.29 | 46.29 | 2000.0 |
| 2019-05-22 06:10:00 | AAPL | Stock | 46.29 | 46.325 | 46.29 | 46.325 | 2408.0 |
| 2019-05-22 06:15:00 | AAPL | Stock | 46.3375 | 46.36 | 46.3375 | 46.36 | 3320.0 |
| 2019-05-22 06:20:00 | AAPL | Stock | 46.375 | 46.3925 | 46.3625 | 46.375 | 4836.0 |
| 2019-05-22 06:25:00 | AAPL | Stock | 46.3625 | 46.3725 | 46.3625 | 46.37 | 1800.0 |
| 2019-05-22 06:30:00 | AAPL | Stock | 46.365 | 46.365 | 46.365 | 46.365 | 800.0 |
| 2019-05-22 06:35:00 | AAPL | Stock | 46.325 | 46.325 | 46.2575 | 46.3 | 5600.0 |
| 2019-05-22 06:40:00 | AAPL | Stock | 46.36 | 46.36 | 46.3225 | 46.325 | 1588.0 |
| 2019-05-22 06:45:00 | AAPL | Stock | 46.255 | 46.255 | 46.25 | 46.25 | 5308.0 |
| 2019-05-22 06:50:00 | AAPL | Stock | 46.25 | 46.25 | 46.25 | 46.25 | 1456.0 |
| 2019-05-22 06:55:00 | AAPL | Stock | 46.25 | 46.25 | 46.25 | 46.25 | 4416.0 |
| 2019-05-22 07:00:00 | AAPL | Stock | 46.275 | 46.315 | 46.2325 | 46.2325 | 48672.0 |
| 2019-05-22 07:05:00 | AAPL | Stock | 46.255 | 46.255 | 46.255 | 46.255 | 5100.0 |
| 2019-05-22 07:10:00 | AAPL | Stock | 46.2575 | 46.2575 | 46.175 | 46.175 | 31796.0 |
| 2019-05-22 07:15:00 | AAPL | Stock | 46.175 | 46.1875 | 46.15 | 46.15 | 7244.0 |
| 2019-05-22 07:20:00 | AAPL | Stock | 46.1775 | 46.18 | 46.155 | 46.1775 | 8748.0 |
| 2019-05-22 07:25:00 | AAPL | Stock | 46.1875 | 46.21 | 46.175 | 46.175 | 4180.0 |
| 2019-05-22 07:30:00 | AAPL | Stock | 46.2 | 46.2 | 46.1375 | 46.15 | 19372.0 |
| 2019-05-22 07:35:00 | AAPL | Stock | 46.15 | 46.19 | 46.1 | 46.1325 | 92600.0 |
| 2019-05-22 07:40:00 | AAPL | Stock | 46.0825 | 46.175 | 46.0825 | 46.175 | 13404.0 |
| 2019-05-22 07:45:00 | AAPL | Stock | 46.155 | 46.155 | 46.1325 | 46.1325 | 1600.0 |
| 2019-05-22 07:50:00 | AAPL | Stock | 46.1275 | 46.24 | 46.125 | 46.175 | 17512.0 |
| 2019-05-22 07:55:00 | AAPL | Stock | 46.1625 | 46.1625 | 46.0725 | 46.1 | 33144.0 |
| 2019-05-22 08:00:00 | AAPL | Stock | 46.1225 | 46.325 | 46.0725 | 46.1125 | 104008.0 |
| 2019-05-22 08:05:00 | AAPL | Stock | 46.1125 | 46.125 | 46.0775 | 46.0775 | 19860.0 |
| 2019-05-22 08:10:00 | AAPL | Stock | 46.0875 | 46.0875 | 45.975 | 45.9775 | 125628.0 |
| 2019-05-22 08:15:00 | AAPL | Stock | 45.9998 | 46.0 | 45.975 | 45.975 | 32172.0 |
| 2019-05-22 08:20:00 | AAPL | Stock | 45.9725 | 46.0 | 45.9575 | 45.985 | 71184.0 |
| 2019-05-22 08:25:00 | AAPL | Stock | 45.9575 | 45.975 | 45.8125 | 45.9 | 76632.0 |
| 2019-05-22 08:30:00 | AAPL | Stock | 45.9375 | 46.0 | 45.9375 | 45.962 | 41596.0 |
| 2019-05-22 08:35:00 | AAPL | Stock | 46.0225 | 46.025 | 45.9725 | 45.995 | 62024.0 |
| 2019-05-22 08:40:00 | AAPL | Stock | 45.97 | 45.9825 | 45.955 | 45.9575 | 36840.0 |
| 2019-05-22 08:45:00 | AAPL | Stock | 45.9875 | 46.0325 | 45.9875 | 46.0275 | 5784.0 |
| 2019-05-22 08:50:00 | AAPL | Stock | 46.015 | 46.1 | 46.015 | 46.0975 | 47504.0 |
| 2019-05-22 08:55:00 | AAPL | Stock | 46.1 | 46.1225 | 46.0575 | 46.065 | 42708.0 |
| 2019-05-22 09:00:00 | AAPL | Stock | 46.075 | 46.1225 | 46.075 | 46.1225 | 33700.0 |
> showing 50 of 348,994 rows — these rows as CSV