PREVIEW / stock_5min / 2007-01-09
file: by_date/stock_5min/2007/2007-01-09.parquet size: 3.4 MB rows: 243,592 symbols: 2,492
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-09 04:25:00 | AAPL | Stock | 3.0714 | 3.0714 | 3.0714 | 3.0714 | 25200.0 |
| 2007-01-09 04:40:00 | AAPL | Stock | 3.0786 | 3.0786 | 3.0786 | 3.0786 | 5600.0 |
| 2007-01-09 05:10:00 | AAPL | Stock | 3.0782 | 3.0786 | 3.0782 | 3.0786 | 22400.0 |
| 2007-01-09 05:20:00 | AAPL | Stock | 3.0786 | 3.0786 | 3.0786 | 3.0786 | 2800.0 |
| 2007-01-09 05:25:00 | AAPL | Stock | 3.0786 | 3.0786 | 3.0786 | 3.0786 | 2800.0 |
| 2007-01-09 05:55:00 | AAPL | Stock | 3.0818 | 3.0818 | 3.0818 | 3.0818 | 2800.0 |
| 2007-01-09 06:00:00 | AAPL | Stock | 3.0818 | 3.0818 | 3.0818 | 3.0818 | 2800.0 |
| 2007-01-09 06:20:00 | AAPL | Stock | 3.0818 | 3.0818 | 3.0818 | 3.0818 | 5600.0 |
| 2007-01-09 07:00:00 | AAPL | Stock | 3.0854 | 3.09 | 3.0736 | 3.09 | 147924.0 |
| 2007-01-09 07:05:00 | AAPL | Stock | 3.0893 | 3.0946 | 3.0893 | 3.0946 | 98000.0 |
| 2007-01-09 07:10:00 | AAPL | Stock | 3.0846 | 3.09 | 3.0789 | 3.0893 | 736400.0 |
| 2007-01-09 07:15:00 | AAPL | Stock | 3.0854 | 3.0854 | 3.0832 | 3.0832 | 19600.0 |
| 2007-01-09 07:25:00 | AAPL | Stock | 3.0832 | 3.0832 | 3.0821 | 3.0821 | 91000.0 |
| 2007-01-09 07:30:00 | AAPL | Stock | 3.0818 | 3.0889 | 3.0818 | 3.0889 | 404880.0 |
| 2007-01-09 07:35:00 | AAPL | Stock | 3.0889 | 3.0893 | 3.0857 | 3.0857 | 224000.0 |
| 2007-01-09 07:40:00 | AAPL | Stock | 3.0821 | 3.0846 | 3.0821 | 3.0846 | 39200.0 |
| 2007-01-09 07:45:00 | AAPL | Stock | 3.0846 | 3.0875 | 3.0846 | 3.0875 | 568400.0 |
| 2007-01-09 07:50:00 | AAPL | Stock | 3.0875 | 3.0893 | 3.0875 | 3.0893 | 170800.0 |
| 2007-01-09 07:55:00 | AAPL | Stock | 3.0893 | 3.0893 | 3.0857 | 3.0857 | 228200.0 |
| 2007-01-09 08:00:00 | AAPL | Stock | 3.0857 | 3.0893 | 3.0796 | 3.0857 | 1278676.0 |
| 2007-01-09 08:05:00 | AAPL | Stock | 3.0871 | 3.0875 | 3.0804 | 3.0829 | 435708.0 |
| 2007-01-09 08:10:00 | AAPL | Stock | 3.0832 | 3.0832 | 3.0782 | 3.0821 | 1738072.0 |
| 2007-01-09 08:15:00 | AAPL | Stock | 3.0857 | 3.0857 | 3.0786 | 3.0814 | 345436.0 |
| 2007-01-09 08:20:00 | AAPL | Stock | 3.0814 | 3.0846 | 3.0804 | 3.0839 | 82320.0 |
| 2007-01-09 08:25:00 | AAPL | Stock | 3.0839 | 3.0857 | 3.0804 | 3.0857 | 232204.0 |
| 2007-01-09 08:30:00 | AAPL | Stock | 3.0839 | 3.0839 | 3.0796 | 3.0832 | 306208.0 |
| 2007-01-09 08:35:00 | AAPL | Stock | 3.0829 | 3.0839 | 3.0818 | 3.0821 | 154560.0 |
| 2007-01-09 08:40:00 | AAPL | Stock | 3.0821 | 3.0857 | 3.0818 | 3.0839 | 301868.0 |
| 2007-01-09 08:45:00 | AAPL | Stock | 3.0839 | 3.0839 | 3.0832 | 3.0832 | 148960.0 |
| 2007-01-09 08:50:00 | AAPL | Stock | 3.0839 | 3.0857 | 3.0839 | 3.0857 | 175364.0 |
| 2007-01-09 08:55:00 | AAPL | Stock | 3.0846 | 3.0857 | 3.0836 | 3.0839 | 157192.0 |
| 2007-01-09 09:00:00 | AAPL | Stock | 3.0829 | 3.085 | 3.0807 | 3.085 | 387520.0 |
| 2007-01-09 09:05:00 | AAPL | Stock | 3.0846 | 3.0875 | 3.0846 | 3.0857 | 1166396.0 |
| 2007-01-09 09:10:00 | AAPL | Stock | 3.0864 | 3.0864 | 3.0839 | 3.0839 | 515032.0 |
| 2007-01-09 09:15:00 | AAPL | Stock | 3.0836 | 3.0836 | 3.0771 | 3.0786 | 973000.0 |
| 2007-01-09 09:20:00 | AAPL | Stock | 3.0786 | 3.0818 | 3.0775 | 3.0807 | 779492.0 |
| 2007-01-09 09:25:00 | AAPL | Stock | 3.0811 | 3.0893 | 3.0807 | 3.0889 | 4622856.0 |
| 2007-01-09 09:30:00 | AAPL | Stock | 3.0875 | 3.0932 | 3.0775 | 3.0779 | 36262352.0 |
| 2007-01-09 09:35:00 | AAPL | Stock | 3.0782 | 3.0968 | 3.0732 | 3.0925 | 33712728.0 |
| 2007-01-09 09:40:00 | AAPL | Stock | 3.0921 | 3.0936 | 3.0821 | 3.0854 | 17371704.0 |
| 2007-01-09 09:45:00 | AAPL | Stock | 3.085 | 3.0886 | 3.0764 | 3.0843 | 16800308.0 |
| 2007-01-09 09:50:00 | AAPL | Stock | 3.0843 | 3.0929 | 3.0814 | 3.0886 | 20745088.0 |
| 2007-01-09 09:55:00 | AAPL | Stock | 3.0882 | 3.0911 | 3.0836 | 3.0879 | 13544860.0 |
| 2007-01-09 10:00:00 | AAPL | Stock | 3.0867 | 3.0904 | 3.0846 | 3.0861 | 16322572.0 |
| 2007-01-09 10:05:00 | AAPL | Stock | 3.0857 | 3.0911 | 3.0821 | 3.09 | 13805484.0 |
| 2007-01-09 10:10:00 | AAPL | Stock | 3.0896 | 3.1 | 3.0893 | 3.0964 | 31295712.0 |
| 2007-01-09 10:15:00 | AAPL | Stock | 3.0964 | 3.1029 | 3.0936 | 3.0971 | 19893860.0 |
| 2007-01-09 10:20:00 | AAPL | Stock | 3.097 | 3.1039 | 3.0936 | 3.1025 | 14822584.0 |
| 2007-01-09 10:25:00 | AAPL | Stock | 3.1025 | 3.1068 | 3.1018 | 3.1043 | 23009672.0 |
| 2007-01-09 10:30:00 | AAPL | Stock | 3.1046 | 3.11 | 3.1011 | 3.1082 | 21665840.0 |
> showing 50 of 243,592 rows — these rows as CSV