PREVIEW / stock_5min / 2009-07-14
file: by_date/stock_5min/2009/2009-07-14.parquet size: 4.4 MB rows: 303,863 symbols: 3,344
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 |
|---|---|---|---|---|---|---|---|
| 2009-07-14 07:15:00 | AAPL | Stock | 5.125 | 5.125 | 5.0714 | 5.0714 | 22288.0 |
| 2009-07-14 07:40:00 | AAPL | Stock | 5.0893 | 5.0893 | 5.0893 | 5.0893 | 95200.0 |
| 2009-07-14 07:45:00 | AAPL | Stock | 5.0893 | 5.0893 | 5.0839 | 5.0893 | 75600.0 |
| 2009-07-14 08:00:00 | AAPL | Stock | 5.0875 | 5.0875 | 5.0821 | 5.0875 | 77700.0 |
| 2009-07-14 08:05:00 | AAPL | Stock | 5.0875 | 5.0893 | 5.0861 | 5.0861 | 66836.0 |
| 2009-07-14 08:10:00 | AAPL | Stock | 5.0857 | 5.0857 | 5.0804 | 5.085 | 74060.0 |
| 2009-07-14 08:15:00 | AAPL | Stock | 5.0786 | 5.0786 | 5.0775 | 5.0775 | 22400.0 |
| 2009-07-14 08:20:00 | AAPL | Stock | 5.0775 | 5.0857 | 5.0714 | 5.0718 | 99400.0 |
| 2009-07-14 08:25:00 | AAPL | Stock | 5.0786 | 5.0786 | 5.0768 | 5.0768 | 11900.0 |
| 2009-07-14 08:30:00 | AAPL | Stock | 5.0721 | 5.0804 | 5.0686 | 5.075 | 203784.0 |
| 2009-07-14 08:35:00 | AAPL | Stock | 5.0707 | 5.0714 | 5.0679 | 5.0714 | 107912.0 |
| 2009-07-14 08:40:00 | AAPL | Stock | 5.0696 | 5.075 | 5.0679 | 5.0707 | 103796.0 |
| 2009-07-14 08:45:00 | AAPL | Stock | 5.0707 | 5.0714 | 5.0707 | 5.0707 | 90412.0 |
| 2009-07-14 08:50:00 | AAPL | Stock | 5.0707 | 5.0714 | 5.0707 | 5.0714 | 313600.0 |
| 2009-07-14 08:55:00 | AAPL | Stock | 5.0714 | 5.0714 | 5.0696 | 5.0707 | 41860.0 |
| 2009-07-14 09:00:00 | AAPL | Stock | 5.0679 | 5.0714 | 5.0679 | 5.0714 | 125636.0 |
| 2009-07-14 09:05:00 | AAPL | Stock | 5.0714 | 5.0825 | 5.0714 | 5.0825 | 271348.0 |
| 2009-07-14 09:10:00 | AAPL | Stock | 5.0821 | 5.0832 | 5.0789 | 5.0793 | 84532.0 |
| 2009-07-14 09:15:00 | AAPL | Stock | 5.0793 | 5.0793 | 5.075 | 5.0786 | 53200.0 |
| 2009-07-14 09:20:00 | AAPL | Stock | 5.0793 | 5.0796 | 5.0768 | 5.0768 | 55076.0 |
| 2009-07-14 09:25:00 | AAPL | Stock | 5.0768 | 5.0768 | 5.0679 | 5.0714 | 70700.0 |
| 2009-07-14 09:30:00 | AAPL | Stock | 5.0671 | 5.1021 | 5.0536 | 5.0946 | 14562576.0 |
| 2009-07-14 09:35:00 | AAPL | Stock | 5.0946 | 5.1136 | 5.0811 | 5.0939 | 18478348.0 |
| 2009-07-14 09:40:00 | AAPL | Stock | 5.0957 | 5.0993 | 5.0571 | 5.0589 | 10704820.0 |
| 2009-07-14 09:45:00 | AAPL | Stock | 5.0596 | 5.0764 | 5.0571 | 5.0636 | 9482200.0 |
| 2009-07-14 09:50:00 | AAPL | Stock | 5.0621 | 5.0711 | 5.0415 | 5.05 | 12503092.0 |
| 2009-07-14 09:55:00 | AAPL | Stock | 5.05 | 5.0575 | 5.0432 | 5.0506 | 7574028.0 |
| 2009-07-14 10:00:00 | AAPL | Stock | 5.0518 | 5.0696 | 5.0486 | 5.0571 | 7525252.0 |
| 2009-07-14 10:05:00 | AAPL | Stock | 5.0554 | 5.085 | 5.0554 | 5.0846 | 8750700.0 |
| 2009-07-14 10:10:00 | AAPL | Stock | 5.0846 | 5.0864 | 5.0768 | 5.0786 | 5012448.0 |
| 2009-07-14 10:15:00 | AAPL | Stock | 5.0793 | 5.0864 | 5.0661 | 5.0707 | 4160548.0 |
| 2009-07-14 10:20:00 | AAPL | Stock | 5.0696 | 5.0704 | 5.0546 | 5.0661 | 5041064.0 |
| 2009-07-14 10:25:00 | AAPL | Stock | 5.0664 | 5.0716 | 5.0564 | 5.0646 | 4130168.0 |
| 2009-07-14 10:30:00 | AAPL | Stock | 5.0646 | 5.0666 | 5.0571 | 5.0571 | 2743300.0 |
| 2009-07-14 10:35:00 | AAPL | Stock | 5.0575 | 5.0589 | 5.0464 | 5.0564 | 5285896.0 |
| 2009-07-14 10:40:00 | AAPL | Stock | 5.0571 | 5.0596 | 5.0489 | 5.0521 | 5071024.0 |
| 2009-07-14 10:45:00 | AAPL | Stock | 5.0518 | 5.0714 | 5.0504 | 5.0707 | 6314280.0 |
| 2009-07-14 10:50:00 | AAPL | Stock | 5.0693 | 5.0717 | 5.065 | 5.0682 | 2918356.0 |
| 2009-07-14 10:55:00 | AAPL | Stock | 5.0689 | 5.0796 | 5.0679 | 5.0779 | 4986240.0 |
| 2009-07-14 11:00:00 | AAPL | Stock | 5.0779 | 5.0786 | 5.0743 | 5.0775 | 2551976.0 |
| 2009-07-14 11:05:00 | AAPL | Stock | 5.0775 | 5.0836 | 5.0771 | 5.0804 | 4003244.0 |
| 2009-07-14 11:10:00 | AAPL | Stock | 5.0807 | 5.0886 | 5.0807 | 5.0871 | 2902144.0 |
| 2009-07-14 11:15:00 | AAPL | Stock | 5.0871 | 5.1016 | 5.0864 | 5.0946 | 6528536.0 |
| 2009-07-14 11:20:00 | AAPL | Stock | 5.0946 | 5.0957 | 5.0893 | 5.0933 | 2720032.0 |
| 2009-07-14 11:25:00 | AAPL | Stock | 5.0928 | 5.1029 | 5.0893 | 5.0996 | 3484376.0 |
| 2009-07-14 11:30:00 | AAPL | Stock | 5.0993 | 5.1039 | 5.0918 | 5.1021 | 3039484.0 |
| 2009-07-14 11:35:00 | AAPL | Stock | 5.1025 | 5.1043 | 5.0946 | 5.0975 | 3666768.0 |
| 2009-07-14 11:40:00 | AAPL | Stock | 5.0986 | 5.1004 | 5.0893 | 5.0893 | 2901724.0 |
| 2009-07-14 11:45:00 | AAPL | Stock | 5.0896 | 5.0979 | 5.0879 | 5.0961 | 2927820.0 |
| 2009-07-14 11:50:00 | AAPL | Stock | 5.0968 | 5.0968 | 5.0864 | 5.0882 | 2923508.0 |
> showing 50 of 303,863 rows — these rows as CSV