PREVIEW / stock_5min / 2005-07-19
file: by_date/stock_5min/2005/2005-07-19.parquet size: 2.7 MB rows: 198,603 symbols: 2,031
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 |
|---|---|---|---|---|---|---|---|
| 2005-07-19 07:40:00 | AAPL | Stock | 1.5014 | 1.5032 | 1.5014 | 1.5032 | 42000.0 |
| 2005-07-19 07:55:00 | AAPL | Stock | 1.4946 | 1.4946 | 1.4946 | 1.4946 | 8400.0 |
| 2005-07-19 08:00:00 | AAPL | Stock | 1.495 | 1.495 | 1.4907 | 1.4907 | 301588.0 |
| 2005-07-19 08:05:00 | AAPL | Stock | 1.4939 | 1.4946 | 1.4939 | 1.4946 | 30800.0 |
| 2005-07-19 08:10:00 | AAPL | Stock | 1.4939 | 1.4946 | 1.4939 | 1.4946 | 92400.0 |
| 2005-07-19 08:15:00 | AAPL | Stock | 1.4946 | 1.4946 | 1.4911 | 1.4911 | 67200.0 |
| 2005-07-19 08:20:00 | AAPL | Stock | 1.4911 | 1.4929 | 1.4911 | 1.4929 | 123200.0 |
| 2005-07-19 08:25:00 | AAPL | Stock | 1.4911 | 1.4929 | 1.4911 | 1.4914 | 124880.0 |
| 2005-07-19 08:30:00 | AAPL | Stock | 1.4914 | 1.4925 | 1.4857 | 1.4889 | 203280.0 |
| 2005-07-19 08:35:00 | AAPL | Stock | 1.4889 | 1.4889 | 1.4889 | 1.4889 | 44800.0 |
| 2005-07-19 08:40:00 | AAPL | Stock | 1.4882 | 1.4893 | 1.4882 | 1.4893 | 11200.0 |
| 2005-07-19 08:45:00 | AAPL | Stock | 1.4893 | 1.4893 | 1.4879 | 1.4879 | 101920.0 |
| 2005-07-19 08:50:00 | AAPL | Stock | 1.4904 | 1.4904 | 1.4904 | 1.4904 | 11200.0 |
| 2005-07-19 08:55:00 | AAPL | Stock | 1.4893 | 1.4904 | 1.4893 | 1.4904 | 16800.0 |
| 2005-07-19 09:00:00 | AAPL | Stock | 1.4904 | 1.4929 | 1.4904 | 1.4929 | 176400.0 |
| 2005-07-19 09:05:00 | AAPL | Stock | 1.4929 | 1.4929 | 1.4925 | 1.4925 | 263200.0 |
| 2005-07-19 09:10:00 | AAPL | Stock | 1.4929 | 1.4929 | 1.4918 | 1.4918 | 95900.0 |
| 2005-07-19 09:15:00 | AAPL | Stock | 1.4918 | 1.4932 | 1.4914 | 1.4914 | 354200.0 |
| 2005-07-19 09:20:00 | AAPL | Stock | 1.4914 | 1.4914 | 1.4911 | 1.4911 | 238000.0 |
| 2005-07-19 09:25:00 | AAPL | Stock | 1.4893 | 1.4907 | 1.4821 | 1.4829 | 1184400.0 |
| 2005-07-19 09:30:00 | AAPL | Stock | 1.4829 | 1.4971 | 1.4668 | 1.4943 | 23569448.0 |
| 2005-07-19 09:35:00 | AAPL | Stock | 1.495 | 1.4982 | 1.49 | 1.4932 | 15707664.0 |
| 2005-07-19 09:40:00 | AAPL | Stock | 1.4925 | 1.4936 | 1.4889 | 1.4889 | 11019036.0 |
| 2005-07-19 09:45:00 | AAPL | Stock | 1.4893 | 1.4936 | 1.4882 | 1.4936 | 5359172.0 |
| 2005-07-19 09:50:00 | AAPL | Stock | 1.4932 | 1.4932 | 1.4886 | 1.4914 | 4641392.0 |
| 2005-07-19 09:55:00 | AAPL | Stock | 1.4914 | 1.4921 | 1.4889 | 1.4911 | 5512892.0 |
| 2005-07-19 10:00:00 | AAPL | Stock | 1.4914 | 1.4961 | 1.49 | 1.4957 | 7298032.0 |
| 2005-07-19 10:05:00 | AAPL | Stock | 1.4961 | 1.4979 | 1.4946 | 1.4965 | 6409368.0 |
| 2005-07-19 10:10:00 | AAPL | Stock | 1.4964 | 1.505 | 1.495 | 1.505 | 17311980.0 |
| 2005-07-19 10:15:00 | AAPL | Stock | 1.505 | 1.5096 | 1.5018 | 1.5057 | 24711344.0 |
| 2005-07-19 10:20:00 | AAPL | Stock | 1.5054 | 1.5114 | 1.5039 | 1.5104 | 13329596.0 |
| 2005-07-19 10:25:00 | AAPL | Stock | 1.5104 | 1.5154 | 1.5086 | 1.5132 | 14260400.0 |
| 2005-07-19 10:30:00 | AAPL | Stock | 1.5132 | 1.5186 | 1.5114 | 1.5179 | 18077640.0 |
| 2005-07-19 10:35:00 | AAPL | Stock | 1.5171 | 1.5221 | 1.5157 | 1.5196 | 21056980.0 |
| 2005-07-19 10:40:00 | AAPL | Stock | 1.5196 | 1.5232 | 1.5161 | 1.5186 | 13846168.0 |
| 2005-07-19 10:45:00 | AAPL | Stock | 1.5186 | 1.5189 | 1.5143 | 1.5168 | 6645912.0 |
| 2005-07-19 10:50:00 | AAPL | Stock | 1.5168 | 1.5168 | 1.5125 | 1.5132 | 5721072.0 |
| 2005-07-19 10:55:00 | AAPL | Stock | 1.5129 | 1.5164 | 1.5125 | 1.5161 | 7366156.0 |
| 2005-07-19 11:00:00 | AAPL | Stock | 1.5157 | 1.5175 | 1.5143 | 1.5168 | 5862500.0 |
| 2005-07-19 11:05:00 | AAPL | Stock | 1.5168 | 1.5193 | 1.5164 | 1.5193 | 6553960.0 |
| 2005-07-19 11:10:00 | AAPL | Stock | 1.5193 | 1.5193 | 1.5136 | 1.5146 | 6248592.0 |
| 2005-07-19 11:15:00 | AAPL | Stock | 1.5146 | 1.5157 | 1.5125 | 1.5136 | 6484548.0 |
| 2005-07-19 11:20:00 | AAPL | Stock | 1.5139 | 1.5161 | 1.5136 | 1.5161 | 4223016.0 |
| 2005-07-19 11:25:00 | AAPL | Stock | 1.5157 | 1.5171 | 1.5136 | 1.5164 | 3899224.0 |
| 2005-07-19 11:30:00 | AAPL | Stock | 1.5161 | 1.5179 | 1.5157 | 1.5161 | 4364640.0 |
| 2005-07-19 11:35:00 | AAPL | Stock | 1.5164 | 1.5196 | 1.5161 | 1.5186 | 4257036.0 |
| 2005-07-19 11:40:00 | AAPL | Stock | 1.5189 | 1.5193 | 1.5175 | 1.5186 | 3050964.0 |
| 2005-07-19 11:45:00 | AAPL | Stock | 1.5182 | 1.5196 | 1.5179 | 1.5189 | 2906008.0 |
| 2005-07-19 11:50:00 | AAPL | Stock | 1.5186 | 1.5193 | 1.5139 | 1.5186 | 2563036.0 |
| 2005-07-19 11:55:00 | AAPL | Stock | 1.5189 | 1.5189 | 1.5161 | 1.5164 | 2692984.0 |
> showing 50 of 198,603 rows — these rows as CSV