PREVIEW / stock_5min / 2019-12-23
file: by_date/stock_5min/2019/2019-12-23.parquet size: 5.9 MB rows: 367,628 symbols: 2,463
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-12-23 04:00:00 | AAPL | Stock | 69.955 | 70.05 | 69.955 | 70.05 | 4804.0 |
| 2019-12-23 04:05:00 | AAPL | Stock | 70.05 | 70.05 | 70.05 | 70.05 | 400.0 |
| 2019-12-23 04:15:00 | AAPL | Stock | 70.075 | 70.075 | 70.075 | 70.075 | 400.0 |
| 2019-12-23 04:40:00 | AAPL | Stock | 70.075 | 70.075 | 70.075 | 70.075 | 400.0 |
| 2019-12-23 04:50:00 | AAPL | Stock | 70.0625 | 70.0625 | 70.0625 | 70.0625 | 400.0 |
| 2019-12-23 05:05:00 | AAPL | Stock | 70.0625 | 70.065 | 70.0625 | 70.0625 | 4112.0 |
| 2019-12-23 05:35:00 | AAPL | Stock | 70.0625 | 70.07 | 70.0625 | 70.0625 | 5600.0 |
| 2019-12-23 06:00:00 | AAPL | Stock | 70.06 | 70.1125 | 70.06 | 70.11 | 8608.0 |
| 2019-12-23 06:05:00 | AAPL | Stock | 70.125 | 70.1325 | 70.125 | 70.1325 | 1200.0 |
| 2019-12-23 06:10:00 | AAPL | Stock | 70.125 | 70.125 | 70.125 | 70.125 | 1600.0 |
| 2019-12-23 06:20:00 | AAPL | Stock | 70.125 | 70.125 | 70.125 | 70.125 | 2240.0 |
| 2019-12-23 06:45:00 | AAPL | Stock | 70.06 | 70.06 | 70.06 | 70.06 | 400.0 |
| 2019-12-23 06:55:00 | AAPL | Stock | 70.0675 | 70.0675 | 70.06 | 70.0625 | 9192.0 |
| 2019-12-23 07:00:00 | AAPL | Stock | 70.0675 | 70.11 | 70.05 | 70.0625 | 44916.0 |
| 2019-12-23 07:05:00 | AAPL | Stock | 70.05 | 70.15 | 70.03 | 70.125 | 27196.0 |
| 2019-12-23 07:10:00 | AAPL | Stock | 70.14 | 70.14 | 70.1 | 70.1125 | 13752.0 |
| 2019-12-23 07:15:00 | AAPL | Stock | 70.1225 | 70.1225 | 70.0775 | 70.0875 | 7980.0 |
| 2019-12-23 07:20:00 | AAPL | Stock | 70.1 | 70.1175 | 70.0875 | 70.1175 | 8524.0 |
| 2019-12-23 07:25:00 | AAPL | Stock | 70.1125 | 70.1175 | 70.1125 | 70.1125 | 20328.0 |
| 2019-12-23 07:30:00 | AAPL | Stock | 70.11 | 70.1125 | 70.1 | 70.11 | 12664.0 |
| 2019-12-23 07:35:00 | AAPL | Stock | 70.1 | 70.1 | 70.07 | 70.07 | 6940.0 |
| 2019-12-23 07:40:00 | AAPL | Stock | 70.075 | 70.075 | 70.0625 | 70.0725 | 9140.0 |
| 2019-12-23 07:45:00 | AAPL | Stock | 70.075 | 70.075 | 70.0725 | 70.075 | 9060.0 |
| 2019-12-23 07:50:00 | AAPL | Stock | 70.075 | 70.0825 | 70.0625 | 70.0825 | 9248.0 |
| 2019-12-23 07:55:00 | AAPL | Stock | 70.0825 | 70.095 | 70.075 | 70.075 | 2784.0 |
| 2019-12-23 08:00:00 | AAPL | Stock | 70.05 | 70.15 | 70.0375 | 70.07 | 60116.0 |
| 2019-12-23 08:05:00 | AAPL | Stock | 70.075 | 70.085 | 70.07 | 70.0775 | 21556.0 |
| 2019-12-23 08:10:00 | AAPL | Stock | 70.0675 | 70.0725 | 70.06 | 70.07 | 13048.0 |
| 2019-12-23 08:15:00 | AAPL | Stock | 70.0575 | 70.0575 | 70.025 | 70.025 | 18068.0 |
| 2019-12-23 08:20:00 | AAPL | Stock | 70.0425 | 70.0775 | 70.0425 | 70.0775 | 51844.0 |
| 2019-12-23 08:25:00 | AAPL | Stock | 70.0875 | 70.1125 | 70.0825 | 70.1125 | 47112.0 |
| 2019-12-23 08:30:00 | AAPL | Stock | 70.1175 | 70.1225 | 70.0875 | 70.1 | 13156.0 |
| 2019-12-23 08:35:00 | AAPL | Stock | 70.1 | 70.175 | 70.0975 | 70.15 | 68040.0 |
| 2019-12-23 08:40:00 | AAPL | Stock | 70.1725 | 70.2425 | 70.1225 | 70.225 | 109160.0 |
| 2019-12-23 08:45:00 | AAPL | Stock | 70.2125 | 70.235 | 70.17 | 70.2 | 55112.0 |
| 2019-12-23 08:50:00 | AAPL | Stock | 70.21 | 70.2175 | 70.175 | 70.2 | 21480.0 |
| 2019-12-23 08:55:00 | AAPL | Stock | 70.175 | 70.195 | 70.15 | 70.1725 | 68696.0 |
| 2019-12-23 09:00:00 | AAPL | Stock | 70.1725 | 70.175 | 70.125 | 70.125 | 42132.0 |
| 2019-12-23 09:05:00 | AAPL | Stock | 70.125 | 70.14 | 70.0275 | 70.095 | 60712.0 |
| 2019-12-23 09:10:00 | AAPL | Stock | 70.07 | 70.0825 | 70.005 | 70.0375 | 56864.0 |
| 2019-12-23 09:15:00 | AAPL | Stock | 70.0225 | 70.0725 | 70.0225 | 70.0675 | 67692.0 |
| 2019-12-23 09:20:00 | AAPL | Stock | 70.0675 | 70.0975 | 69.86 | 70.09 | 69976.0 |
| 2019-12-23 09:25:00 | AAPL | Stock | 70.095 | 70.2375 | 70.075 | 70.16 | 78848.0 |
| 2019-12-23 09:30:00 | AAPL | Stock | 70.145 | 70.37 | 70.0935 | 70.3395 | 4391648.0 |
| 2019-12-23 09:35:00 | AAPL | Stock | 70.342 | 70.4425 | 70.33 | 70.415 | 1987804.0 |
| 2019-12-23 09:40:00 | AAPL | Stock | 70.4175 | 70.455 | 70.3625 | 70.4375 | 1836536.0 |
| 2019-12-23 09:45:00 | AAPL | Stock | 70.435 | 70.5975 | 70.4325 | 70.58 | 2845276.0 |
| 2019-12-23 09:50:00 | AAPL | Stock | 70.585 | 70.595 | 70.4775 | 70.575 | 1756408.0 |
| 2019-12-23 09:55:00 | AAPL | Stock | 70.5725 | 70.605 | 70.47 | 70.5025 | 1775592.0 |
| 2019-12-23 10:00:00 | AAPL | Stock | 70.5075 | 70.5585 | 70.45 | 70.544 | 1304664.0 |
> showing 50 of 367,628 rows — these rows as CSV