PREVIEW / stock_5min / 2009-07-20
file: by_date/stock_5min/2009/2009-07-20.parquet size: 4.5 MB rows: 311,608 symbols: 3,358
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-20 05:05:00 | AAPL | Stock | 5.4536 | 5.4536 | 5.4536 | 5.4536 | 7700.0 |
| 2009-07-20 07:00:00 | AAPL | Stock | 5.4536 | 5.4536 | 5.4536 | 5.4536 | 5180.0 |
| 2009-07-20 07:10:00 | AAPL | Stock | 5.4729 | 5.4768 | 5.4729 | 5.4768 | 54600.0 |
| 2009-07-20 07:15:00 | AAPL | Stock | 5.4643 | 5.4643 | 5.4571 | 5.4575 | 44800.0 |
| 2009-07-20 07:30:00 | AAPL | Stock | 5.4589 | 5.4589 | 5.4571 | 5.4589 | 39200.0 |
| 2009-07-20 07:35:00 | AAPL | Stock | 5.46 | 5.46 | 5.46 | 5.46 | 11200.0 |
| 2009-07-20 07:40:00 | AAPL | Stock | 5.4586 | 5.4643 | 5.4582 | 5.4643 | 60816.0 |
| 2009-07-20 07:45:00 | AAPL | Stock | 5.4764 | 5.4975 | 5.4714 | 5.4886 | 418712.0 |
| 2009-07-20 07:50:00 | AAPL | Stock | 5.4911 | 5.4911 | 5.4846 | 5.4893 | 106400.0 |
| 2009-07-20 07:55:00 | AAPL | Stock | 5.4918 | 5.5029 | 5.4918 | 5.5018 | 157808.0 |
| 2009-07-20 08:00:00 | AAPL | Stock | 5.4893 | 5.5007 | 5.48 | 5.4875 | 978880.0 |
| 2009-07-20 08:05:00 | AAPL | Stock | 5.4875 | 5.4893 | 5.4839 | 5.4893 | 278040.0 |
| 2009-07-20 08:10:00 | AAPL | Stock | 5.4893 | 5.4946 | 5.4886 | 5.4893 | 465696.0 |
| 2009-07-20 08:15:00 | AAPL | Stock | 5.4889 | 5.4896 | 5.4861 | 5.4896 | 194796.0 |
| 2009-07-20 08:20:00 | AAPL | Stock | 5.4896 | 5.49 | 5.485 | 5.485 | 125748.0 |
| 2009-07-20 08:25:00 | AAPL | Stock | 5.4857 | 5.4857 | 5.4761 | 5.4804 | 179480.0 |
| 2009-07-20 08:30:00 | AAPL | Stock | 5.48 | 5.4854 | 5.4686 | 5.4732 | 294896.0 |
| 2009-07-20 08:35:00 | AAPL | Stock | 5.4732 | 5.4911 | 5.4714 | 5.4718 | 380380.0 |
| 2009-07-20 08:40:00 | AAPL | Stock | 5.4796 | 5.4879 | 5.4718 | 5.4718 | 108108.0 |
| 2009-07-20 08:45:00 | AAPL | Stock | 5.4775 | 5.4864 | 5.4775 | 5.4857 | 83944.0 |
| 2009-07-20 08:50:00 | AAPL | Stock | 5.4857 | 5.4871 | 5.4643 | 5.4646 | 720160.0 |
| 2009-07-20 08:55:00 | AAPL | Stock | 5.4643 | 5.4729 | 5.4643 | 5.4725 | 235032.0 |
| 2009-07-20 09:00:00 | AAPL | Stock | 5.4725 | 5.4771 | 5.47 | 5.4771 | 106036.0 |
| 2009-07-20 09:05:00 | AAPL | Stock | 5.4764 | 5.4893 | 5.47 | 5.4832 | 251888.0 |
| 2009-07-20 09:10:00 | AAPL | Stock | 5.4821 | 5.4868 | 5.4793 | 5.4821 | 161700.0 |
| 2009-07-20 09:15:00 | AAPL | Stock | 5.4818 | 5.49 | 5.4818 | 5.4893 | 405580.0 |
| 2009-07-20 09:20:00 | AAPL | Stock | 5.4896 | 5.4896 | 5.4807 | 5.485 | 298032.0 |
| 2009-07-20 09:25:00 | AAPL | Stock | 5.4825 | 5.4879 | 5.4661 | 5.4736 | 923188.0 |
| 2009-07-20 09:30:00 | AAPL | Stock | 5.4736 | 5.4893 | 5.4546 | 5.4864 | 25998588.0 |
| 2009-07-20 09:35:00 | AAPL | Stock | 5.4871 | 5.4989 | 5.4821 | 5.4954 | 14396788.0 |
| 2009-07-20 09:40:00 | AAPL | Stock | 5.4989 | 5.4993 | 5.4698 | 5.4764 | 13432860.0 |
| 2009-07-20 09:45:00 | AAPL | Stock | 5.4771 | 5.5093 | 5.475 | 5.4989 | 16532852.0 |
| 2009-07-20 09:50:00 | AAPL | Stock | 5.4989 | 5.5182 | 5.4982 | 5.5111 | 10807692.0 |
| 2009-07-20 09:55:00 | AAPL | Stock | 5.5107 | 5.5257 | 5.5086 | 5.5243 | 8738996.0 |
| 2009-07-20 10:00:00 | AAPL | Stock | 5.525 | 5.53 | 5.5179 | 5.5254 | 11535076.0 |
| 2009-07-20 10:05:00 | AAPL | Stock | 5.5246 | 5.5314 | 5.5139 | 5.5159 | 13681668.0 |
| 2009-07-20 10:10:00 | AAPL | Stock | 5.5161 | 5.5179 | 5.4946 | 5.4961 | 18102504.0 |
| 2009-07-20 10:15:00 | AAPL | Stock | 5.4955 | 5.5029 | 5.4921 | 5.4968 | 9922640.0 |
| 2009-07-20 10:20:00 | AAPL | Stock | 5.4971 | 5.4996 | 5.4846 | 5.4954 | 9002168.0 |
| 2009-07-20 10:25:00 | AAPL | Stock | 5.4954 | 5.5 | 5.4882 | 5.4968 | 5286036.0 |
| 2009-07-20 10:30:00 | AAPL | Stock | 5.4971 | 5.5 | 5.4796 | 5.4857 | 8588496.0 |
| 2009-07-20 10:35:00 | AAPL | Stock | 5.4856 | 5.4979 | 5.4856 | 5.4928 | 5401844.0 |
| 2009-07-20 10:40:00 | AAPL | Stock | 5.4928 | 5.4928 | 5.4854 | 5.4879 | 6994260.0 |
| 2009-07-20 10:45:00 | AAPL | Stock | 5.4886 | 5.4936 | 5.4839 | 5.4857 | 4677288.0 |
| 2009-07-20 10:50:00 | AAPL | Stock | 5.4854 | 5.4918 | 5.4821 | 5.4914 | 7863016.0 |
| 2009-07-20 10:55:00 | AAPL | Stock | 5.4908 | 5.5089 | 5.4864 | 5.5017 | 8652924.0 |
| 2009-07-20 11:00:00 | AAPL | Stock | 5.5018 | 5.5214 | 5.5018 | 5.5171 | 7543536.0 |
| 2009-07-20 11:05:00 | AAPL | Stock | 5.5164 | 5.5171 | 5.5093 | 5.5114 | 3541132.0 |
| 2009-07-20 11:10:00 | AAPL | Stock | 5.5121 | 5.5171 | 5.5082 | 5.5161 | 5256384.0 |
| 2009-07-20 11:15:00 | AAPL | Stock | 5.5161 | 5.5218 | 5.5136 | 5.5184 | 5114088.0 |
> showing 50 of 311,608 rows — these rows as CSV