PREVIEW / stock_5min / 2019-07-30
file: by_date/stock_5min/2019/2019-07-30.parquet size: 5.7 MB rows: 365,884 symbols: 2,570
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-07-30 04:00:00 | AAPL | Stock | 52.35 | 52.3725 | 52.35 | 52.3625 | 3560.0 |
| 2019-07-30 04:05:00 | AAPL | Stock | 52.3625 | 52.3625 | 52.35 | 52.35 | 2400.0 |
| 2019-07-30 04:10:00 | AAPL | Stock | 52.375 | 52.3775 | 52.3725 | 52.3775 | 3780.0 |
| 2019-07-30 04:15:00 | AAPL | Stock | 52.4 | 52.4 | 52.4 | 52.4 | 2000.0 |
| 2019-07-30 04:20:00 | AAPL | Stock | 52.345 | 52.345 | 52.295 | 52.295 | 8276.0 |
| 2019-07-30 04:30:00 | AAPL | Stock | 52.27 | 52.27 | 52.27 | 52.27 | 412.0 |
| 2019-07-30 04:35:00 | AAPL | Stock | 52.25 | 52.25 | 52.205 | 52.2275 | 3600.0 |
| 2019-07-30 04:50:00 | AAPL | Stock | 52.18 | 52.18 | 52.18 | 52.18 | 3416.0 |
| 2019-07-30 04:55:00 | AAPL | Stock | 52.1925 | 52.195 | 52.18 | 52.195 | 4016.0 |
| 2019-07-30 05:00:00 | AAPL | Stock | 52.195 | 52.1975 | 52.195 | 52.1975 | 3184.0 |
| 2019-07-30 05:10:00 | AAPL | Stock | 52.1975 | 52.2 | 52.1975 | 52.2 | 1200.0 |
| 2019-07-30 05:20:00 | AAPL | Stock | 52.15 | 52.15 | 52.15 | 52.15 | 400.0 |
| 2019-07-30 05:25:00 | AAPL | Stock | 52.1375 | 52.1375 | 52.1375 | 52.1375 | 400.0 |
| 2019-07-30 05:30:00 | AAPL | Stock | 52.16 | 52.165 | 52.16 | 52.165 | 2000.0 |
| 2019-07-30 05:35:00 | AAPL | Stock | 52.1275 | 52.14 | 52.1275 | 52.14 | 1320.0 |
| 2019-07-30 06:05:00 | AAPL | Stock | 52.13 | 52.1375 | 52.1275 | 52.1375 | 13740.0 |
| 2019-07-30 06:10:00 | AAPL | Stock | 52.17 | 52.175 | 52.17 | 52.175 | 2260.0 |
| 2019-07-30 06:15:00 | AAPL | Stock | 52.125 | 52.125 | 52.1 | 52.1 | 4132.0 |
| 2019-07-30 06:20:00 | AAPL | Stock | 52.0825 | 52.0825 | 52.0825 | 52.0825 | 412.0 |
| 2019-07-30 06:50:00 | AAPL | Stock | 52.2225 | 52.225 | 52.2225 | 52.225 | 6088.0 |
| 2019-07-30 07:00:00 | AAPL | Stock | 52.22 | 52.275 | 52.22 | 52.22 | 21820.0 |
| 2019-07-30 07:05:00 | AAPL | Stock | 52.225 | 52.245 | 52.205 | 52.245 | 13352.0 |
| 2019-07-30 07:10:00 | AAPL | Stock | 52.2075 | 52.225 | 52.1375 | 52.15 | 42224.0 |
| 2019-07-30 07:15:00 | AAPL | Stock | 52.15 | 52.15 | 52.1075 | 52.1075 | 23632.0 |
| 2019-07-30 07:20:00 | AAPL | Stock | 52.08 | 52.13 | 52.08 | 52.0875 | 19608.0 |
| 2019-07-30 07:25:00 | AAPL | Stock | 52.1 | 52.13 | 52.085 | 52.085 | 9752.0 |
| 2019-07-30 07:30:00 | AAPL | Stock | 52.08 | 52.0825 | 52.0 | 52.0025 | 82596.0 |
| 2019-07-30 07:35:00 | AAPL | Stock | 52.025 | 52.025 | 51.97 | 52.0 | 22192.0 |
| 2019-07-30 07:40:00 | AAPL | Stock | 52.0 | 52.0625 | 52.0 | 52.0575 | 26572.0 |
| 2019-07-30 07:45:00 | AAPL | Stock | 52.05 | 52.05 | 52.0 | 52.0375 | 20800.0 |
| 2019-07-30 07:50:00 | AAPL | Stock | 51.9975 | 52.0025 | 51.985 | 52.0 | 20260.0 |
| 2019-07-30 07:55:00 | AAPL | Stock | 52.0 | 52.0 | 51.995 | 51.9975 | 4936.0 |
| 2019-07-30 08:00:00 | AAPL | Stock | 51.985 | 52.2875 | 51.9725 | 51.9725 | 93112.0 |
| 2019-07-30 08:05:00 | AAPL | Stock | 51.9725 | 52.0025 | 51.9725 | 52.0025 | 3920.0 |
| 2019-07-30 08:10:00 | AAPL | Stock | 52.0325 | 52.05 | 52.025 | 52.03 | 11344.0 |
| 2019-07-30 08:15:00 | AAPL | Stock | 52.045 | 52.09 | 52.0275 | 52.09 | 21816.0 |
| 2019-07-30 08:20:00 | AAPL | Stock | 52.0925 | 52.0925 | 52.0375 | 52.0375 | 6400.0 |
| 2019-07-30 08:25:00 | AAPL | Stock | 52.0275 | 52.08 | 52.0 | 52.08 | 48448.0 |
| 2019-07-30 08:30:00 | AAPL | Stock | 52.0625 | 52.075 | 52.0225 | 52.0225 | 23180.0 |
| 2019-07-30 08:35:00 | AAPL | Stock | 52.0225 | 52.05 | 51.975 | 51.975 | 37268.0 |
| 2019-07-30 08:40:00 | AAPL | Stock | 51.9925 | 52.0 | 51.9625 | 51.9625 | 11460.0 |
| 2019-07-30 08:45:00 | AAPL | Stock | 51.965 | 52.0 | 51.9375 | 51.9375 | 33104.0 |
| 2019-07-30 08:50:00 | AAPL | Stock | 51.95 | 51.9675 | 51.94 | 51.9525 | 29760.0 |
| 2019-07-30 08:55:00 | AAPL | Stock | 51.9525 | 51.97 | 51.905 | 51.9375 | 25948.0 |
| 2019-07-30 09:00:00 | AAPL | Stock | 51.95 | 52.025 | 51.9375 | 51.9925 | 44516.0 |
| 2019-07-30 09:05:00 | AAPL | Stock | 51.995 | 52.0 | 51.9625 | 51.9825 | 11024.0 |
| 2019-07-30 09:10:00 | AAPL | Stock | 51.985 | 52.025 | 51.975 | 52.0 | 18088.0 |
| 2019-07-30 09:15:00 | AAPL | Stock | 52.0375 | 52.0375 | 51.975 | 51.9975 | 13380.0 |
| 2019-07-30 09:20:00 | AAPL | Stock | 51.98 | 52.0 | 51.955 | 51.9975 | 45028.0 |
| 2019-07-30 09:25:00 | AAPL | Stock | 51.955 | 52.2 | 51.95 | 52.18 | 83028.0 |
> showing 50 of 365,884 rows — these rows as CSV