PREVIEW / stock_5min / 2007-04-30
file: by_date/stock_5min/2007/2007-04-30.parquet size: 3.8 MB rows: 269,010 symbols: 2,654
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-04-30 09:30:00 | AAPL | Stock | 3.5746 | 3.5768 | 3.5654 | 3.5732 | 29977108.0 |
| 2007-04-30 09:35:00 | AAPL | Stock | 3.5732 | 3.5786 | 3.5679 | 3.5696 | 21410116.0 |
| 2007-04-30 09:40:00 | AAPL | Stock | 3.57 | 3.5732 | 3.5671 | 3.5732 | 15260728.0 |
| 2007-04-30 09:45:00 | AAPL | Stock | 3.5736 | 3.58 | 3.5714 | 3.5782 | 21570052.0 |
| 2007-04-30 09:50:00 | AAPL | Stock | 3.5782 | 3.5807 | 3.5664 | 3.574 | 18702152.0 |
| 2007-04-30 09:55:00 | AAPL | Stock | 3.5743 | 3.5807 | 3.5721 | 3.5725 | 8953532.0 |
| 2007-04-30 10:00:00 | AAPL | Stock | 3.5721 | 3.5786 | 3.5718 | 3.5775 | 6451032.0 |
| 2007-04-30 10:05:00 | AAPL | Stock | 3.5771 | 3.5786 | 3.5729 | 3.5768 | 6646864.0 |
| 2007-04-30 10:10:00 | AAPL | Stock | 3.5768 | 3.6004 | 3.575 | 3.5957 | 22452556.0 |
| 2007-04-30 10:15:00 | AAPL | Stock | 3.5964 | 3.6029 | 3.5804 | 3.6004 | 20226920.0 |
| 2007-04-30 10:20:00 | AAPL | Stock | 3.6004 | 3.6064 | 3.5964 | 3.6043 | 16596048.0 |
| 2007-04-30 10:25:00 | AAPL | Stock | 3.6043 | 3.6046 | 3.5954 | 3.5971 | 11158420.0 |
| 2007-04-30 10:30:00 | AAPL | Stock | 3.5971 | 3.5971 | 3.5893 | 3.5918 | 10808700.0 |
| 2007-04-30 10:35:00 | AAPL | Stock | 3.5918 | 3.5996 | 3.5908 | 3.5993 | 8345400.0 |
| 2007-04-30 10:40:00 | AAPL | Stock | 3.5993 | 3.6043 | 3.5954 | 3.6 | 7635488.0 |
| 2007-04-30 10:45:00 | AAPL | Stock | 3.6 | 3.6043 | 3.5964 | 3.5964 | 5446532.0 |
| 2007-04-30 10:50:00 | AAPL | Stock | 3.5964 | 3.5982 | 3.5929 | 3.5968 | 5589388.0 |
| 2007-04-30 10:55:00 | AAPL | Stock | 3.5971 | 3.605 | 3.5964 | 3.6007 | 8339156.0 |
| 2007-04-30 11:00:00 | AAPL | Stock | 3.6004 | 3.6018 | 3.5982 | 3.5996 | 5992532.0 |
| 2007-04-30 11:05:00 | AAPL | Stock | 3.5996 | 3.6011 | 3.5975 | 3.5989 | 3478776.0 |
| 2007-04-30 11:10:00 | AAPL | Stock | 3.5989 | 3.6043 | 3.5986 | 3.6004 | 5093424.0 |
| 2007-04-30 11:15:00 | AAPL | Stock | 3.6007 | 3.6029 | 3.5982 | 3.6029 | 4999792.0 |
| 2007-04-30 11:20:00 | AAPL | Stock | 3.6029 | 3.6071 | 3.5989 | 3.6011 | 8887788.0 |
| 2007-04-30 11:25:00 | AAPL | Stock | 3.6011 | 3.6032 | 3.5964 | 3.6021 | 4533452.0 |
| 2007-04-30 11:30:00 | AAPL | Stock | 3.6021 | 3.6022 | 3.5986 | 3.5996 | 2712528.0 |
| 2007-04-30 11:35:00 | AAPL | Stock | 3.5996 | 3.6 | 3.5907 | 3.5907 | 5958344.0 |
| 2007-04-30 11:40:00 | AAPL | Stock | 3.5907 | 3.5936 | 3.5879 | 3.5882 | 8749216.0 |
| 2007-04-30 11:45:00 | AAPL | Stock | 3.5889 | 3.5943 | 3.5889 | 3.5929 | 4184012.0 |
| 2007-04-30 11:50:00 | AAPL | Stock | 3.5932 | 3.5986 | 3.5921 | 3.5964 | 3617180.0 |
| 2007-04-30 11:55:00 | AAPL | Stock | 3.5961 | 3.5971 | 3.5932 | 3.5936 | 2816408.0 |
| 2007-04-30 12:00:00 | AAPL | Stock | 3.5936 | 3.5957 | 3.5932 | 3.5939 | 2240728.0 |
| 2007-04-30 12:05:00 | AAPL | Stock | 3.5936 | 3.6 | 3.5936 | 3.5982 | 4052300.0 |
| 2007-04-30 12:10:00 | AAPL | Stock | 3.5982 | 3.6007 | 3.5968 | 3.6004 | 3025932.0 |
| 2007-04-30 12:15:00 | AAPL | Stock | 3.6001 | 3.6007 | 3.5982 | 3.5986 | 2618588.0 |
| 2007-04-30 12:20:00 | AAPL | Stock | 3.5989 | 3.5989 | 3.5946 | 3.5982 | 3139276.0 |
| 2007-04-30 12:25:00 | AAPL | Stock | 3.5979 | 3.6 | 3.5971 | 3.6 | 1802892.0 |
| 2007-04-30 12:30:00 | AAPL | Stock | 3.5996 | 3.6018 | 3.5993 | 3.6007 | 2477972.0 |
| 2007-04-30 12:35:00 | AAPL | Stock | 3.6004 | 3.6018 | 3.5993 | 3.6003 | 2311736.0 |
| 2007-04-30 12:40:00 | AAPL | Stock | 3.6004 | 3.6021 | 3.5996 | 3.6015 | 2188144.0 |
| 2007-04-30 12:45:00 | AAPL | Stock | 3.6014 | 3.6021 | 3.6007 | 3.6014 | 1794352.0 |
| 2007-04-30 12:50:00 | AAPL | Stock | 3.6014 | 3.6014 | 3.6 | 3.6007 | 1636740.0 |
| 2007-04-30 12:55:00 | AAPL | Stock | 3.6011 | 3.6014 | 3.5971 | 3.5972 | 3193176.0 |
| 2007-04-30 13:00:00 | AAPL | Stock | 3.5971 | 3.6004 | 3.5968 | 3.5993 | 2096304.0 |
| 2007-04-30 13:05:00 | AAPL | Stock | 3.5989 | 3.6007 | 3.5986 | 3.5986 | 2842392.0 |
| 2007-04-30 13:10:00 | AAPL | Stock | 3.5986 | 3.6007 | 3.5986 | 3.6 | 1829884.0 |
| 2007-04-30 13:15:00 | AAPL | Stock | 3.5996 | 3.6014 | 3.5993 | 3.6004 | 2282700.0 |
| 2007-04-30 13:20:00 | AAPL | Stock | 3.6004 | 3.6021 | 3.5996 | 3.6014 | 2650760.0 |
| 2007-04-30 13:25:00 | AAPL | Stock | 3.6014 | 3.6018 | 3.5975 | 3.5989 | 4257064.0 |
| 2007-04-30 13:30:00 | AAPL | Stock | 3.5993 | 3.5996 | 3.5979 | 3.5993 | 1757868.0 |
| 2007-04-30 13:35:00 | AAPL | Stock | 3.599 | 3.6 | 3.5971 | 3.5986 | 2490320.0 |
> showing 50 of 269,010 rows — these rows as CSV