PREVIEW / stock_5min / 2020-05-07
file: by_date/stock_5min/2020/2020-05-07.parquet size: 6.3 MB rows: 400,838 symbols: 2,358
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 |
|---|---|---|---|---|---|---|---|
| 2020-05-07 04:00:00 | AAPL | Stock | 75.7875 | 75.7875 | 75.7675 | 75.7875 | 7376.0 |
| 2020-05-07 04:05:00 | AAPL | Stock | 75.8 | 75.8 | 75.785 | 75.8 | 5016.0 |
| 2020-05-07 04:10:00 | AAPL | Stock | 75.84 | 75.84 | 75.8075 | 75.8075 | 3892.0 |
| 2020-05-07 04:15:00 | AAPL | Stock | 75.8075 | 75.8075 | 75.8075 | 75.8075 | 400.0 |
| 2020-05-07 04:20:00 | AAPL | Stock | 75.8125 | 75.8125 | 75.8125 | 75.8125 | 400.0 |
| 2020-05-07 04:25:00 | AAPL | Stock | 75.85 | 75.8625 | 75.85 | 75.8625 | 1600.0 |
| 2020-05-07 04:30:00 | AAPL | Stock | 75.86 | 75.86 | 75.86 | 75.86 | 400.0 |
| 2020-05-07 04:35:00 | AAPL | Stock | 75.9075 | 75.9075 | 75.9075 | 75.9075 | 800.0 |
| 2020-05-07 04:40:00 | AAPL | Stock | 75.9375 | 75.9375 | 75.9375 | 75.9375 | 1920.0 |
| 2020-05-07 04:45:00 | AAPL | Stock | 75.9375 | 75.9375 | 75.9375 | 75.9375 | 1280.0 |
| 2020-05-07 04:50:00 | AAPL | Stock | 75.98 | 75.98 | 75.98 | 75.98 | 1188.0 |
| 2020-05-07 04:55:00 | AAPL | Stock | 76.0 | 76.0 | 76.0 | 76.0 | 800.0 |
| 2020-05-07 05:10:00 | AAPL | Stock | 76.0 | 76.0 | 76.0 | 76.0 | 400.0 |
| 2020-05-07 05:20:00 | AAPL | Stock | 76.0 | 76.0325 | 76.0 | 76.02 | 11000.0 |
| 2020-05-07 05:30:00 | AAPL | Stock | 76.02 | 76.0325 | 76.02 | 76.0325 | 1036.0 |
| 2020-05-07 05:35:00 | AAPL | Stock | 76.125 | 76.125 | 76.125 | 76.125 | 464.0 |
| 2020-05-07 05:40:00 | AAPL | Stock | 76.1625 | 76.1625 | 76.1625 | 76.1625 | 400.0 |
| 2020-05-07 05:45:00 | AAPL | Stock | 76.175 | 76.175 | 76.175 | 76.175 | 400.0 |
| 2020-05-07 05:50:00 | AAPL | Stock | 76.125 | 76.125 | 76.125 | 76.125 | 1204.0 |
| 2020-05-07 05:55:00 | AAPL | Stock | 76.1675 | 76.1675 | 76.1675 | 76.1675 | 400.0 |
| 2020-05-07 06:00:00 | AAPL | Stock | 76.1075 | 76.1125 | 76.05 | 76.1125 | 14576.0 |
| 2020-05-07 06:05:00 | AAPL | Stock | 76.075 | 76.08 | 76.0525 | 76.0525 | 4112.0 |
| 2020-05-07 06:10:00 | AAPL | Stock | 76.1375 | 76.1625 | 76.125 | 76.1625 | 1480.0 |
| 2020-05-07 06:15:00 | AAPL | Stock | 76.1725 | 76.2 | 76.1475 | 76.1475 | 4276.0 |
| 2020-05-07 06:20:00 | AAPL | Stock | 76.15 | 76.15 | 76.0625 | 76.0625 | 5068.0 |
| 2020-05-07 06:25:00 | AAPL | Stock | 76.1425 | 76.1425 | 76.1425 | 76.1425 | 400.0 |
| 2020-05-07 06:30:00 | AAPL | Stock | 76.125 | 76.15 | 76.0875 | 76.0875 | 13328.0 |
| 2020-05-07 06:35:00 | AAPL | Stock | 76.0625 | 76.1225 | 76.0625 | 76.08 | 13152.0 |
| 2020-05-07 06:45:00 | AAPL | Stock | 76.0325 | 76.035 | 76.0125 | 76.0325 | 5728.0 |
| 2020-05-07 06:50:00 | AAPL | Stock | 76.01 | 76.01 | 75.9525 | 75.9525 | 8092.0 |
| 2020-05-07 06:55:00 | AAPL | Stock | 75.94 | 75.945 | 75.94 | 75.94 | 1200.0 |
| 2020-05-07 07:00:00 | AAPL | Stock | 75.94 | 75.94 | 75.6375 | 75.6375 | 178332.0 |
| 2020-05-07 07:05:00 | AAPL | Stock | 75.65 | 75.77 | 75.6375 | 75.7625 | 30888.0 |
| 2020-05-07 07:10:00 | AAPL | Stock | 75.7675 | 75.7725 | 75.7225 | 75.75 | 31564.0 |
| 2020-05-07 07:15:00 | AAPL | Stock | 75.75 | 75.7875 | 75.73 | 75.7725 | 32624.0 |
| 2020-05-07 07:20:00 | AAPL | Stock | 75.775 | 75.795 | 75.75 | 75.755 | 24352.0 |
| 2020-05-07 07:25:00 | AAPL | Stock | 75.7575 | 75.7625 | 75.725 | 75.725 | 32688.0 |
| 2020-05-07 07:30:00 | AAPL | Stock | 75.75 | 75.8 | 75.74 | 75.8 | 32304.0 |
| 2020-05-07 07:35:00 | AAPL | Stock | 75.8 | 75.875 | 75.785 | 75.8625 | 16280.0 |
| 2020-05-07 07:40:00 | AAPL | Stock | 75.85 | 75.85 | 75.8125 | 75.85 | 25128.0 |
| 2020-05-07 07:45:00 | AAPL | Stock | 75.85 | 75.875 | 75.85 | 75.87 | 14688.0 |
| 2020-05-07 07:50:00 | AAPL | Stock | 75.86 | 75.86 | 75.84 | 75.84 | 2860.0 |
| 2020-05-07 07:55:00 | AAPL | Stock | 75.855 | 75.925 | 75.855 | 75.8875 | 20172.0 |
| 2020-05-07 08:00:00 | AAPL | Stock | 75.8875 | 75.9225 | 75.645 | 75.815 | 119240.0 |
| 2020-05-07 08:05:00 | AAPL | Stock | 75.815 | 75.85 | 75.7875 | 75.8 | 19764.0 |
| 2020-05-07 08:10:00 | AAPL | Stock | 75.7875 | 75.7975 | 75.76 | 75.7975 | 15448.0 |
| 2020-05-07 08:15:00 | AAPL | Stock | 75.775 | 75.825 | 75.775 | 75.825 | 6108.0 |
| 2020-05-07 08:20:00 | AAPL | Stock | 75.8025 | 75.85 | 75.775 | 75.8175 | 16036.0 |
| 2020-05-07 08:25:00 | AAPL | Stock | 75.8 | 75.825 | 75.7875 | 75.79 | 8628.0 |
| 2020-05-07 08:30:00 | AAPL | Stock | 75.75 | 75.8725 | 75.705 | 75.725 | 48040.0 |
> showing 50 of 400,838 rows — these rows as CSV