PREVIEW / stock_5min / 2010-12-31
file: by_date/stock_5min/2010/2010-12-31.parquet size: 4.5 MB rows: 312,594 symbols: 3,541
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-31 08:00:00 | AAPL | Stock | 11.5571 | 11.5571 | 11.5464 | 11.5464 | 29708.0 |
| 2010-12-31 08:15:00 | AAPL | Stock | 11.5486 | 11.5486 | 11.5432 | 11.5432 | 14756.0 |
| 2010-12-31 08:20:00 | AAPL | Stock | 11.5432 | 11.5464 | 11.5429 | 11.5429 | 17976.0 |
| 2010-12-31 08:25:00 | AAPL | Stock | 11.5393 | 11.5393 | 11.5386 | 11.5386 | 28756.0 |
| 2010-12-31 08:30:00 | AAPL | Stock | 11.5382 | 11.5393 | 11.5382 | 11.5393 | 8400.0 |
| 2010-12-31 08:35:00 | AAPL | Stock | 11.5461 | 11.5479 | 11.5414 | 11.5446 | 18200.0 |
| 2010-12-31 08:40:00 | AAPL | Stock | 11.5457 | 11.5457 | 11.5457 | 11.5457 | 5600.0 |
| 2010-12-31 08:45:00 | AAPL | Stock | 11.5454 | 11.5461 | 11.5454 | 11.5461 | 12600.0 |
| 2010-12-31 08:55:00 | AAPL | Stock | 11.545 | 11.545 | 11.5418 | 11.5418 | 36400.0 |
| 2010-12-31 09:00:00 | AAPL | Stock | 11.5386 | 11.5464 | 11.5386 | 11.5464 | 57568.0 |
| 2010-12-31 09:05:00 | AAPL | Stock | 11.5446 | 11.5529 | 11.5446 | 11.5529 | 81424.0 |
| 2010-12-31 09:10:00 | AAPL | Stock | 11.55 | 11.55 | 11.5493 | 11.5493 | 16520.0 |
| 2010-12-31 09:15:00 | AAPL | Stock | 11.5482 | 11.5482 | 11.5482 | 11.5482 | 14000.0 |
| 2010-12-31 09:25:00 | AAPL | Stock | 11.5446 | 11.5471 | 11.5318 | 11.5343 | 171556.0 |
| 2010-12-31 09:30:00 | AAPL | Stock | 11.5343 | 11.5529 | 11.5289 | 11.5319 | 4691652.0 |
| 2010-12-31 09:35:00 | AAPL | Stock | 11.5319 | 11.5443 | 11.5236 | 11.5246 | 2878512.0 |
| 2010-12-31 09:40:00 | AAPL | Stock | 11.5236 | 11.5366 | 11.4793 | 11.5047 | 9316104.0 |
| 2010-12-31 09:45:00 | AAPL | Stock | 11.5018 | 11.505 | 11.4832 | 11.49 | 4436460.0 |
| 2010-12-31 09:50:00 | AAPL | Stock | 11.4909 | 11.5046 | 11.4857 | 11.5 | 3630452.0 |
| 2010-12-31 09:55:00 | AAPL | Stock | 11.4993 | 11.5032 | 11.4964 | 11.5004 | 2064608.0 |
| 2010-12-31 10:00:00 | AAPL | Stock | 11.4989 | 11.4993 | 11.4839 | 11.4857 | 4771312.0 |
| 2010-12-31 10:05:00 | AAPL | Stock | 11.4857 | 11.4868 | 11.4804 | 11.485 | 4158280.0 |
| 2010-12-31 10:10:00 | AAPL | Stock | 11.4843 | 11.5018 | 11.4829 | 11.4992 | 3228456.0 |
| 2010-12-31 10:15:00 | AAPL | Stock | 11.4975 | 11.5089 | 11.4957 | 11.4993 | 2533384.0 |
| 2010-12-31 10:20:00 | AAPL | Stock | 11.4989 | 11.5071 | 11.4989 | 11.5054 | 1872388.0 |
| 2010-12-31 10:25:00 | AAPL | Stock | 11.505 | 11.5129 | 11.4993 | 11.51 | 1885604.0 |
| 2010-12-31 10:30:00 | AAPL | Stock | 11.5096 | 11.5207 | 11.5025 | 11.5107 | 3603208.0 |
| 2010-12-31 10:35:00 | AAPL | Stock | 11.5107 | 11.5107 | 11.5007 | 11.5054 | 2305100.0 |
| 2010-12-31 10:40:00 | AAPL | Stock | 11.5061 | 11.5067 | 11.5007 | 11.5029 | 2088744.0 |
| 2010-12-31 10:45:00 | AAPL | Stock | 11.5029 | 11.5061 | 11.4957 | 11.4971 | 2961588.0 |
| 2010-12-31 10:50:00 | AAPL | Stock | 11.4989 | 11.5061 | 11.4957 | 11.4957 | 1759100.0 |
| 2010-12-31 10:55:00 | AAPL | Stock | 11.4957 | 11.4993 | 11.4946 | 11.4957 | 1371636.0 |
| 2010-12-31 11:00:00 | AAPL | Stock | 11.4954 | 11.4986 | 11.4921 | 11.4972 | 2739128.0 |
| 2010-12-31 11:05:00 | AAPL | Stock | 11.4961 | 11.4968 | 11.4843 | 11.4868 | 2975532.0 |
| 2010-12-31 11:10:00 | AAPL | Stock | 11.4868 | 11.4868 | 11.4768 | 11.4796 | 3766784.0 |
| 2010-12-31 11:15:00 | AAPL | Stock | 11.4796 | 11.4889 | 11.4761 | 11.4868 | 2419396.0 |
| 2010-12-31 11:20:00 | AAPL | Stock | 11.4859 | 11.4886 | 11.4793 | 11.4886 | 1727096.0 |
| 2010-12-31 11:25:00 | AAPL | Stock | 11.4886 | 11.4957 | 11.4861 | 11.4914 | 2011268.0 |
| 2010-12-31 11:30:00 | AAPL | Stock | 11.4921 | 11.4943 | 11.4914 | 11.4939 | 986776.0 |
| 2010-12-31 11:35:00 | AAPL | Stock | 11.4932 | 11.4971 | 11.4911 | 11.4936 | 1825264.0 |
| 2010-12-31 11:40:00 | AAPL | Stock | 11.4932 | 11.4982 | 11.4911 | 11.4979 | 1850632.0 |
| 2010-12-31 11:45:00 | AAPL | Stock | 11.4979 | 11.4982 | 11.49 | 11.4939 | 1630076.0 |
| 2010-12-31 11:50:00 | AAPL | Stock | 11.4943 | 11.4968 | 11.4921 | 11.4935 | 929404.0 |
| 2010-12-31 11:55:00 | AAPL | Stock | 11.4929 | 11.4971 | 11.4921 | 11.4926 | 1063804.0 |
| 2010-12-31 12:00:00 | AAPL | Stock | 11.4929 | 11.4971 | 11.4925 | 11.4964 | 895384.0 |
| 2010-12-31 12:05:00 | AAPL | Stock | 11.4971 | 11.5057 | 11.4964 | 11.5046 | 2333464.0 |
| 2010-12-31 12:10:00 | AAPL | Stock | 11.5043 | 11.5057 | 11.5021 | 11.5043 | 1229060.0 |
| 2010-12-31 12:15:00 | AAPL | Stock | 11.5036 | 11.5054 | 11.4989 | 11.5046 | 1611260.0 |
| 2010-12-31 12:20:00 | AAPL | Stock | 11.5036 | 11.5046 | 11.495 | 11.5018 | 1170960.0 |
| 2010-12-31 12:25:00 | AAPL | Stock | 11.5018 | 11.5046 | 11.5014 | 11.5043 | 869484.0 |
> showing 50 of 312,594 rows — these rows as CSV