PREVIEW / stock_5min / 2007-05-23
file: by_date/stock_5min/2007/2007-05-23.parquet size: 4.0 MB rows: 294,465 symbols: 3,013
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-05-23 09:30:00 | AAPL | Stock | 4.0721 | 4.0836 | 4.0686 | 4.0793 | 22973944.0 |
| 2007-05-23 09:35:00 | AAPL | Stock | 4.0789 | 4.0836 | 4.0732 | 4.08 | 16133320.0 |
| 2007-05-23 09:40:00 | AAPL | Stock | 4.0793 | 4.0893 | 4.0768 | 4.088 | 13048280.0 |
| 2007-05-23 09:45:00 | AAPL | Stock | 4.0886 | 4.0954 | 4.085 | 4.0921 | 15157576.0 |
| 2007-05-23 09:50:00 | AAPL | Stock | 4.0918 | 4.1004 | 4.0886 | 4.0982 | 14647416.0 |
| 2007-05-23 09:55:00 | AAPL | Stock | 4.0979 | 4.1029 | 4.0946 | 4.095 | 15189804.0 |
| 2007-05-23 10:00:00 | AAPL | Stock | 4.095 | 4.1029 | 4.0946 | 4.0996 | 11666816.0 |
| 2007-05-23 10:05:00 | AAPL | Stock | 4.1 | 4.1025 | 4.0986 | 4.0996 | 13459516.0 |
| 2007-05-23 10:10:00 | AAPL | Stock | 4.1 | 4.102 | 4.09 | 4.0925 | 13336512.0 |
| 2007-05-23 10:15:00 | AAPL | Stock | 4.0925 | 4.0986 | 4.0921 | 4.0971 | 7823844.0 |
| 2007-05-23 10:20:00 | AAPL | Stock | 4.0971 | 4.0975 | 4.0879 | 4.0936 | 13652632.0 |
| 2007-05-23 10:25:00 | AAPL | Stock | 4.0936 | 4.1 | 4.0929 | 4.0971 | 8513960.0 |
| 2007-05-23 10:30:00 | AAPL | Stock | 4.0971 | 4.0971 | 4.0907 | 4.0911 | 9723896.0 |
| 2007-05-23 10:35:00 | AAPL | Stock | 4.0908 | 4.1043 | 4.0893 | 4.0982 | 12127248.0 |
| 2007-05-23 10:40:00 | AAPL | Stock | 4.0975 | 4.1004 | 4.0946 | 4.0971 | 6698020.0 |
| 2007-05-23 10:45:00 | AAPL | Stock | 4.0971 | 4.1007 | 4.0957 | 4.0989 | 5640712.0 |
| 2007-05-23 10:50:00 | AAPL | Stock | 4.0989 | 4.1064 | 4.0986 | 4.1021 | 13385904.0 |
| 2007-05-23 10:55:00 | AAPL | Stock | 4.1021 | 4.1071 | 4.1 | 4.1029 | 12418392.0 |
| 2007-05-23 11:00:00 | AAPL | Stock | 4.1032 | 4.1036 | 4.0889 | 4.0936 | 15100624.0 |
| 2007-05-23 11:05:00 | AAPL | Stock | 4.0936 | 4.0964 | 4.0875 | 4.0904 | 9092888.0 |
| 2007-05-23 11:10:00 | AAPL | Stock | 4.0904 | 4.0914 | 4.0836 | 4.0864 | 11170208.0 |
| 2007-05-23 11:15:00 | AAPL | Stock | 4.0867 | 4.0893 | 4.0843 | 4.0889 | 6193124.0 |
| 2007-05-23 11:20:00 | AAPL | Stock | 4.0886 | 4.0936 | 4.0864 | 4.0936 | 7167804.0 |
| 2007-05-23 11:25:00 | AAPL | Stock | 4.0939 | 4.097 | 4.09 | 4.0954 | 5653816.0 |
| 2007-05-23 11:30:00 | AAPL | Stock | 4.0957 | 4.0964 | 4.0893 | 4.0925 | 4684372.0 |
| 2007-05-23 11:35:00 | AAPL | Stock | 4.0921 | 4.0943 | 4.0907 | 4.0918 | 2527588.0 |
| 2007-05-23 11:40:00 | AAPL | Stock | 4.0918 | 4.0957 | 4.0907 | 4.0953 | 2657116.0 |
| 2007-05-23 11:45:00 | AAPL | Stock | 4.0953 | 4.1021 | 4.0953 | 4.1011 | 7442456.0 |
| 2007-05-23 11:50:00 | AAPL | Stock | 4.1011 | 4.1021 | 4.0982 | 4.1018 | 2828476.0 |
| 2007-05-23 11:55:00 | AAPL | Stock | 4.1013 | 4.1036 | 4.0968 | 4.0968 | 4395552.0 |
| 2007-05-23 12:00:00 | AAPL | Stock | 4.0968 | 4.1 | 4.0754 | 4.0754 | 23312128.0 |
| 2007-05-23 12:05:00 | AAPL | Stock | 4.075 | 4.0843 | 4.0704 | 4.0779 | 25489044.0 |
| 2007-05-23 12:10:00 | AAPL | Stock | 4.0782 | 4.0879 | 4.0775 | 4.08 | 10383156.0 |
| 2007-05-23 12:15:00 | AAPL | Stock | 4.08 | 4.0871 | 4.0796 | 4.0868 | 5776708.0 |
| 2007-05-23 12:20:00 | AAPL | Stock | 4.0871 | 4.0871 | 4.0779 | 4.0786 | 6040412.0 |
| 2007-05-23 12:25:00 | AAPL | Stock | 4.0786 | 4.085 | 4.0764 | 4.0843 | 6200936.0 |
| 2007-05-23 12:30:00 | AAPL | Stock | 4.0843 | 4.0889 | 4.0829 | 4.0886 | 6668424.0 |
| 2007-05-23 12:35:00 | AAPL | Stock | 4.0889 | 4.0946 | 4.085 | 4.0868 | 7875084.0 |
| 2007-05-23 12:40:00 | AAPL | Stock | 4.0868 | 4.0893 | 4.0821 | 4.0875 | 4984952.0 |
| 2007-05-23 12:45:00 | AAPL | Stock | 4.0875 | 4.0939 | 4.0875 | 4.0911 | 4580856.0 |
| 2007-05-23 12:50:00 | AAPL | Stock | 4.0911 | 4.0929 | 4.0875 | 4.0893 | 3573388.0 |
| 2007-05-23 12:55:00 | AAPL | Stock | 4.0896 | 4.0932 | 4.0886 | 4.0889 | 3041164.0 |
| 2007-05-23 13:00:00 | AAPL | Stock | 4.0893 | 4.0904 | 4.0861 | 4.0864 | 2968616.0 |
| 2007-05-23 13:05:00 | AAPL | Stock | 4.0864 | 4.0914 | 4.0829 | 4.0889 | 7059696.0 |
| 2007-05-23 13:10:00 | AAPL | Stock | 4.0889 | 4.0893 | 4.0829 | 4.0854 | 4221252.0 |
| 2007-05-23 13:15:00 | AAPL | Stock | 4.085 | 4.0857 | 4.0775 | 4.079 | 6281520.0 |
| 2007-05-23 13:20:00 | AAPL | Stock | 4.0801 | 4.0803 | 4.0782 | 4.0786 | 4835096.0 |
| 2007-05-23 13:25:00 | AAPL | Stock | 4.0786 | 4.0825 | 4.0714 | 4.0814 | 8095556.0 |
| 2007-05-23 13:30:00 | AAPL | Stock | 4.0811 | 4.0857 | 4.0764 | 4.0832 | 6236888.0 |
| 2007-05-23 13:35:00 | AAPL | Stock | 4.0832 | 4.0904 | 4.0821 | 4.0846 | 6004320.0 |
> showing 50 of 294,465 rows — these rows as CSV