PREVIEW / stock_5min / 2020-07-29
file: by_date/stock_5min/2020/2020-07-29.parquet size: 6.6 MB rows: 414,517 symbols: 2,443
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-07-29 04:00:00 | AAPL | Stock | 93.85 | 93.85 | 93.85 | 93.85 | 1100.0 |
| 2020-07-29 04:15:00 | AAPL | Stock | 93.8025 | 93.8025 | 93.8025 | 93.8025 | 800.0 |
| 2020-07-29 04:20:00 | AAPL | Stock | 93.875 | 93.875 | 93.875 | 93.875 | 400.0 |
| 2020-07-29 04:25:00 | AAPL | Stock | 93.8875 | 93.9225 | 93.8875 | 93.9225 | 2280.0 |
| 2020-07-29 04:35:00 | AAPL | Stock | 93.8725 | 93.8725 | 93.8725 | 93.8725 | 612.0 |
| 2020-07-29 05:05:00 | AAPL | Stock | 93.75 | 93.75 | 93.75 | 93.75 | 1172.0 |
| 2020-07-29 05:10:00 | AAPL | Stock | 93.75 | 93.75 | 93.75 | 93.75 | 400.0 |
| 2020-07-29 05:35:00 | AAPL | Stock | 93.75 | 93.75 | 93.75 | 93.75 | 980.0 |
| 2020-07-29 06:10:00 | AAPL | Stock | 93.8925 | 93.8925 | 93.84 | 93.84 | 2000.0 |
| 2020-07-29 06:15:00 | AAPL | Stock | 93.79 | 93.79 | 93.7825 | 93.7825 | 876.0 |
| 2020-07-29 06:35:00 | AAPL | Stock | 93.8825 | 93.8825 | 93.8625 | 93.8825 | 1200.0 |
| 2020-07-29 06:40:00 | AAPL | Stock | 93.8925 | 93.905 | 93.8925 | 93.905 | 2824.0 |
| 2020-07-29 06:45:00 | AAPL | Stock | 93.925 | 93.925 | 93.925 | 93.925 | 980.0 |
| 2020-07-29 06:50:00 | AAPL | Stock | 93.925 | 93.925 | 93.925 | 93.925 | 4916.0 |
| 2020-07-29 06:55:00 | AAPL | Stock | 93.925 | 93.945 | 93.875 | 93.885 | 6568.0 |
| 2020-07-29 07:00:00 | AAPL | Stock | 93.925 | 93.95 | 93.855 | 93.925 | 22156.0 |
| 2020-07-29 07:05:00 | AAPL | Stock | 93.8875 | 93.925 | 93.8875 | 93.925 | 7612.0 |
| 2020-07-29 07:10:00 | AAPL | Stock | 93.975 | 94.03 | 93.9625 | 94.03 | 15656.0 |
| 2020-07-29 07:15:00 | AAPL | Stock | 93.9975 | 93.9975 | 93.875 | 93.9 | 33304.0 |
| 2020-07-29 07:20:00 | AAPL | Stock | 93.9125 | 94.0 | 93.9125 | 94.0 | 7396.0 |
| 2020-07-29 07:25:00 | AAPL | Stock | 94.0 | 94.0 | 93.9025 | 93.93 | 12144.0 |
| 2020-07-29 07:30:00 | AAPL | Stock | 93.8875 | 93.9375 | 93.8275 | 93.875 | 20860.0 |
| 2020-07-29 07:35:00 | AAPL | Stock | 93.8625 | 93.9225 | 93.8625 | 93.8925 | 5320.0 |
| 2020-07-29 07:40:00 | AAPL | Stock | 93.8875 | 93.8875 | 93.8825 | 93.8825 | 2216.0 |
| 2020-07-29 07:45:00 | AAPL | Stock | 93.885 | 94.0025 | 93.885 | 93.9725 | 14644.0 |
| 2020-07-29 07:50:00 | AAPL | Stock | 93.9375 | 93.95 | 93.9375 | 93.9498 | 3144.0 |
| 2020-07-29 07:55:00 | AAPL | Stock | 93.945 | 93.945 | 93.8975 | 93.8975 | 1396.0 |
| 2020-07-29 08:00:00 | AAPL | Stock | 93.9265 | 94.0375 | 93.825 | 93.8525 | 113720.0 |
| 2020-07-29 08:05:00 | AAPL | Stock | 93.845 | 93.9575 | 93.845 | 93.9575 | 50512.0 |
| 2020-07-29 08:10:00 | AAPL | Stock | 93.9625 | 94.12 | 93.95 | 94.075 | 19472.0 |
| 2020-07-29 08:15:00 | AAPL | Stock | 94.1175 | 94.125 | 94.0552 | 94.0625 | 24096.0 |
| 2020-07-29 08:20:00 | AAPL | Stock | 94.0625 | 94.1125 | 94.0488 | 94.1 | 18264.0 |
| 2020-07-29 08:25:00 | AAPL | Stock | 94.1225 | 94.1225 | 94.0215 | 94.1 | 5868.0 |
| 2020-07-29 08:30:00 | AAPL | Stock | 94.075 | 94.095 | 94.0 | 94.0 | 28652.0 |
| 2020-07-29 08:35:00 | AAPL | Stock | 93.95 | 93.9925 | 93.825 | 93.865 | 16200.0 |
| 2020-07-29 08:40:00 | AAPL | Stock | 93.8625 | 93.8875 | 93.85 | 93.8745 | 11868.0 |
| 2020-07-29 08:45:00 | AAPL | Stock | 93.8525 | 93.9075 | 93.83 | 93.875 | 15712.0 |
| 2020-07-29 08:50:00 | AAPL | Stock | 93.8575 | 93.875 | 93.83 | 93.8475 | 21376.0 |
| 2020-07-29 08:55:00 | AAPL | Stock | 93.85 | 93.905 | 93.7975 | 93.905 | 20596.0 |
| 2020-07-29 09:00:00 | AAPL | Stock | 93.9125 | 93.94 | 93.8875 | 93.94 | 4200.0 |
| 2020-07-29 09:05:00 | AAPL | Stock | 93.9375 | 93.9375 | 93.8292 | 93.8725 | 23408.0 |
| 2020-07-29 09:10:00 | AAPL | Stock | 93.875 | 93.9218 | 93.815 | 93.9218 | 17328.0 |
| 2020-07-29 09:15:00 | AAPL | Stock | 93.8625 | 93.915 | 93.2525 | 93.2525 | 710680.0 |
| 2020-07-29 09:20:00 | AAPL | Stock | 93.8525 | 93.855 | 93.75 | 93.8125 | 66256.0 |
| 2020-07-29 09:25:00 | AAPL | Stock | 93.8 | 93.86 | 93.7525 | 93.7525 | 22048.0 |
| 2020-07-29 09:30:00 | AAPL | Stock | 93.75 | 94.22 | 93.7125 | 94.16 | 3020560.0 |
| 2020-07-29 09:35:00 | AAPL | Stock | 94.1375 | 94.425 | 94.0075 | 94.1925 | 1815508.0 |
| 2020-07-29 09:40:00 | AAPL | Stock | 94.19 | 94.2825 | 93.905 | 93.9625 | 1398092.0 |
| 2020-07-29 09:45:00 | AAPL | Stock | 93.96 | 94.12 | 93.8625 | 93.925 | 1133568.0 |
| 2020-07-29 09:50:00 | AAPL | Stock | 93.9225 | 94.05 | 93.8125 | 93.9265 | 1145920.0 |
> showing 50 of 414,517 rows — these rows as CSV