PREVIEW / stock_5min / 2007-01-30
file: by_date/stock_5min/2007/2007-01-30.parquet size: 3.3 MB rows: 241,789 symbols: 2,518
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 |
|---|---|---|---|---|---|---|---|
| 2007-01-30 07:15:00 | AAPL | Stock | 3.0893 | 3.0893 | 3.0893 | 3.0893 | 14000.0 |
| 2007-01-30 07:20:00 | AAPL | Stock | 3.0804 | 3.0804 | 3.0804 | 3.0804 | 2800.0 |
| 2007-01-30 07:25:00 | AAPL | Stock | 3.0911 | 3.1 | 3.0911 | 3.1 | 118524.0 |
| 2007-01-30 07:35:00 | AAPL | Stock | 3.0911 | 3.0911 | 3.0911 | 3.0911 | 8400.0 |
| 2007-01-30 07:40:00 | AAPL | Stock | 3.095 | 3.0961 | 3.0946 | 3.0946 | 56000.0 |
| 2007-01-30 07:45:00 | AAPL | Stock | 3.0904 | 3.0964 | 3.0893 | 3.0964 | 72100.0 |
| 2007-01-30 07:50:00 | AAPL | Stock | 3.0957 | 3.0957 | 3.0954 | 3.0957 | 275660.0 |
| 2007-01-30 07:55:00 | AAPL | Stock | 3.095 | 3.095 | 3.095 | 3.095 | 25200.0 |
| 2007-01-30 08:00:00 | AAPL | Stock | 3.0936 | 3.0982 | 3.0918 | 3.0957 | 897484.0 |
| 2007-01-30 08:05:00 | AAPL | Stock | 3.0918 | 3.0964 | 3.0918 | 3.0932 | 117348.0 |
| 2007-01-30 08:10:00 | AAPL | Stock | 3.0939 | 3.0982 | 3.0939 | 3.0964 | 418600.0 |
| 2007-01-30 08:15:00 | AAPL | Stock | 3.0954 | 3.0982 | 3.0946 | 3.0946 | 255500.0 |
| 2007-01-30 08:20:00 | AAPL | Stock | 3.0946 | 3.0982 | 3.0946 | 3.0946 | 201600.0 |
| 2007-01-30 08:25:00 | AAPL | Stock | 3.0946 | 3.0975 | 3.0946 | 3.0964 | 337960.0 |
| 2007-01-30 08:30:00 | AAPL | Stock | 3.0961 | 3.0961 | 3.0911 | 3.095 | 149240.0 |
| 2007-01-30 08:35:00 | AAPL | Stock | 3.0946 | 3.0946 | 3.0929 | 3.0929 | 77000.0 |
| 2007-01-30 08:40:00 | AAPL | Stock | 3.0925 | 3.0925 | 3.0893 | 3.0907 | 250180.0 |
| 2007-01-30 08:45:00 | AAPL | Stock | 3.0918 | 3.0918 | 3.09 | 3.0918 | 104104.0 |
| 2007-01-30 08:50:00 | AAPL | Stock | 3.0918 | 3.0929 | 3.0911 | 3.0921 | 60200.0 |
| 2007-01-30 08:55:00 | AAPL | Stock | 3.0921 | 3.0939 | 3.0911 | 3.0939 | 175000.0 |
| 2007-01-30 09:00:00 | AAPL | Stock | 3.0936 | 3.0943 | 3.0918 | 3.0918 | 192360.0 |
| 2007-01-30 09:05:00 | AAPL | Stock | 3.0911 | 3.0911 | 3.0868 | 3.0893 | 447020.0 |
| 2007-01-30 09:10:00 | AAPL | Stock | 3.0893 | 3.09 | 3.0864 | 3.0896 | 301700.0 |
| 2007-01-30 09:15:00 | AAPL | Stock | 3.0893 | 3.0907 | 3.0893 | 3.0896 | 106400.0 |
| 2007-01-30 09:20:00 | AAPL | Stock | 3.0875 | 3.09 | 3.0875 | 3.09 | 1121344.0 |
| 2007-01-30 09:25:00 | AAPL | Stock | 3.0879 | 3.0893 | 3.0864 | 3.0875 | 383600.0 |
| 2007-01-30 09:30:00 | AAPL | Stock | 3.0868 | 3.0889 | 3.0725 | 3.0804 | 24712632.0 |
| 2007-01-30 09:35:00 | AAPL | Stock | 3.0803 | 3.0889 | 3.07 | 3.0736 | 22181432.0 |
| 2007-01-30 09:40:00 | AAPL | Stock | 3.0732 | 3.0746 | 3.0667 | 3.0682 | 18351340.0 |
| 2007-01-30 09:45:00 | AAPL | Stock | 3.0682 | 3.0746 | 3.0679 | 3.0707 | 11164972.0 |
| 2007-01-30 09:50:00 | AAPL | Stock | 3.0711 | 3.0711 | 3.0607 | 3.0621 | 15482880.0 |
| 2007-01-30 09:55:00 | AAPL | Stock | 3.0621 | 3.0661 | 3.0557 | 3.065 | 16425416.0 |
| 2007-01-30 10:00:00 | AAPL | Stock | 3.0646 | 3.0693 | 3.0629 | 3.0682 | 15233596.0 |
| 2007-01-30 10:05:00 | AAPL | Stock | 3.0686 | 3.0714 | 3.065 | 3.0668 | 10690428.0 |
| 2007-01-30 10:10:00 | AAPL | Stock | 3.0664 | 3.0671 | 3.0625 | 3.0643 | 5683552.0 |
| 2007-01-30 10:15:00 | AAPL | Stock | 3.0643 | 3.0707 | 3.0632 | 3.07 | 9771916.0 |
| 2007-01-30 10:20:00 | AAPL | Stock | 3.0704 | 3.0714 | 3.065 | 3.0661 | 11437104.0 |
| 2007-01-30 10:25:00 | AAPL | Stock | 3.0661 | 3.0661 | 3.0629 | 3.0654 | 5884844.0 |
| 2007-01-30 10:30:00 | AAPL | Stock | 3.0654 | 3.0696 | 3.0643 | 3.0657 | 14461104.0 |
| 2007-01-30 10:35:00 | AAPL | Stock | 3.0657 | 3.0668 | 3.0593 | 3.0632 | 10761156.0 |
| 2007-01-30 10:40:00 | AAPL | Stock | 3.0632 | 3.0632 | 3.0568 | 3.0586 | 11047372.0 |
| 2007-01-30 10:45:00 | AAPL | Stock | 3.0586 | 3.0589 | 3.0543 | 3.0561 | 12999028.0 |
| 2007-01-30 10:50:00 | AAPL | Stock | 3.0557 | 3.0582 | 3.0504 | 3.0571 | 14214452.0 |
| 2007-01-30 10:55:00 | AAPL | Stock | 3.0571 | 3.0621 | 3.0557 | 3.0614 | 8413580.0 |
| 2007-01-30 11:00:00 | AAPL | Stock | 3.0614 | 3.0629 | 3.0571 | 3.06 | 6670832.0 |
| 2007-01-30 11:05:00 | AAPL | Stock | 3.0604 | 3.0611 | 3.0561 | 3.0586 | 4588332.0 |
| 2007-01-30 11:10:00 | AAPL | Stock | 3.0586 | 3.0646 | 3.0586 | 3.0643 | 8322328.0 |
| 2007-01-30 11:15:00 | AAPL | Stock | 3.0643 | 3.0711 | 3.0643 | 3.0707 | 15876700.0 |
| 2007-01-30 11:20:00 | AAPL | Stock | 3.0707 | 3.0711 | 3.0661 | 3.0668 | 6934788.0 |
| 2007-01-30 11:25:00 | AAPL | Stock | 3.0664 | 3.0679 | 3.0636 | 3.0636 | 4420752.0 |
> showing 50 of 241,789 rows — these rows as CSV