PREVIEW / stock_5min / 2004-06-03
file: by_date/stock_5min/2004/2004-06-03.parquet size: 2.3 MB rows: 171,771 symbols: 1,774
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 |
|---|---|---|---|---|---|---|---|
| 2004-06-03 09:10:00 | AAPL | Stock | 0.5125 | 0.5125 | 0.5125 | 0.5125 | 28000.0 |
| 2004-06-03 09:25:00 | AAPL | Stock | 0.5143 | 0.5148 | 0.5132 | 0.5132 | 204064.0 |
| 2004-06-03 09:30:00 | AAPL | Stock | 0.5129 | 0.5132 | 0.508 | 0.5091 | 8270472.0 |
| 2004-06-03 09:35:00 | AAPL | Stock | 0.5091 | 0.5134 | 0.5086 | 0.5111 | 5932416.0 |
| 2004-06-03 09:40:00 | AAPL | Stock | 0.5107 | 0.513 | 0.5089 | 0.5118 | 3592512.0 |
| 2004-06-03 09:45:00 | AAPL | Stock | 0.5123 | 0.5138 | 0.5104 | 0.5134 | 4799760.0 |
| 2004-06-03 09:50:00 | AAPL | Stock | 0.5132 | 0.5164 | 0.5132 | 0.5141 | 5603696.0 |
| 2004-06-03 09:55:00 | AAPL | Stock | 0.5139 | 0.5177 | 0.5136 | 0.515 | 7678384.0 |
| 2004-06-03 10:00:00 | AAPL | Stock | 0.515 | 0.515 | 0.5068 | 0.5082 | 10549224.0 |
| 2004-06-03 10:05:00 | AAPL | Stock | 0.5077 | 0.5118 | 0.5075 | 0.5116 | 7038416.0 |
| 2004-06-03 10:10:00 | AAPL | Stock | 0.5118 | 0.5121 | 0.5095 | 0.5104 | 4016712.0 |
| 2004-06-03 10:15:00 | AAPL | Stock | 0.5104 | 0.5105 | 0.5095 | 0.5098 | 3858120.0 |
| 2004-06-03 10:20:00 | AAPL | Stock | 0.5096 | 0.5114 | 0.5095 | 0.5114 | 3066784.0 |
| 2004-06-03 10:25:00 | AAPL | Stock | 0.5116 | 0.5121 | 0.5095 | 0.5113 | 2635024.0 |
| 2004-06-03 10:30:00 | AAPL | Stock | 0.5111 | 0.5132 | 0.51 | 0.5132 | 2961896.0 |
| 2004-06-03 10:35:00 | AAPL | Stock | 0.5132 | 0.5138 | 0.5116 | 0.5116 | 2780008.0 |
| 2004-06-03 10:40:00 | AAPL | Stock | 0.5118 | 0.5118 | 0.5082 | 0.5093 | 3331440.0 |
| 2004-06-03 10:45:00 | AAPL | Stock | 0.5093 | 0.51 | 0.5089 | 0.5093 | 1116696.0 |
| 2004-06-03 10:50:00 | AAPL | Stock | 0.5093 | 0.5096 | 0.507 | 0.5071 | 2548896.0 |
| 2004-06-03 10:55:00 | AAPL | Stock | 0.5073 | 0.508 | 0.5054 | 0.5077 | 6781376.0 |
| 2004-06-03 11:00:00 | AAPL | Stock | 0.5077 | 0.5077 | 0.5052 | 0.5061 | 3047296.0 |
| 2004-06-03 11:05:00 | AAPL | Stock | 0.5063 | 0.5077 | 0.5061 | 0.5071 | 2089696.0 |
| 2004-06-03 11:10:00 | AAPL | Stock | 0.5071 | 0.5073 | 0.5064 | 0.5064 | 1199296.0 |
| 2004-06-03 11:15:00 | AAPL | Stock | 0.5064 | 0.508 | 0.5064 | 0.5075 | 1297520.0 |
| 2004-06-03 11:20:00 | AAPL | Stock | 0.5077 | 0.508 | 0.5073 | 0.5075 | 1574160.0 |
| 2004-06-03 11:25:00 | AAPL | Stock | 0.5075 | 0.5077 | 0.5071 | 0.5075 | 1743672.0 |
| 2004-06-03 11:30:00 | AAPL | Stock | 0.5077 | 0.5095 | 0.5073 | 0.5084 | 2042264.0 |
| 2004-06-03 11:35:00 | AAPL | Stock | 0.5084 | 0.5093 | 0.5077 | 0.5089 | 1662640.0 |
| 2004-06-03 11:40:00 | AAPL | Stock | 0.5088 | 0.5089 | 0.5077 | 0.5077 | 1361024.0 |
| 2004-06-03 11:45:00 | AAPL | Stock | 0.5079 | 0.5091 | 0.5079 | 0.508 | 1482432.0 |
| 2004-06-03 11:50:00 | AAPL | Stock | 0.508 | 0.508 | 0.5071 | 0.5079 | 1096256.0 |
| 2004-06-03 11:55:00 | AAPL | Stock | 0.5075 | 0.5088 | 0.5075 | 0.5082 | 623000.0 |
| 2004-06-03 12:00:00 | AAPL | Stock | 0.5084 | 0.5084 | 0.5073 | 0.5075 | 903672.0 |
| 2004-06-03 12:05:00 | AAPL | Stock | 0.5075 | 0.5086 | 0.5075 | 0.5077 | 412720.0 |
| 2004-06-03 12:10:00 | AAPL | Stock | 0.5079 | 0.5091 | 0.5071 | 0.5088 | 1563968.0 |
| 2004-06-03 12:15:00 | AAPL | Stock | 0.5089 | 0.5089 | 0.508 | 0.508 | 338800.0 |
| 2004-06-03 12:20:00 | AAPL | Stock | 0.5082 | 0.5093 | 0.5082 | 0.5089 | 751912.0 |
| 2004-06-03 12:25:00 | AAPL | Stock | 0.5089 | 0.5096 | 0.5086 | 0.5095 | 3393936.0 |
| 2004-06-03 12:30:00 | AAPL | Stock | 0.5095 | 0.5104 | 0.5088 | 0.5102 | 2228856.0 |
| 2004-06-03 12:35:00 | AAPL | Stock | 0.5102 | 0.5109 | 0.5098 | 0.5109 | 1719704.0 |
| 2004-06-03 12:40:00 | AAPL | Stock | 0.5109 | 0.5114 | 0.5106 | 0.5111 | 1382696.0 |
| 2004-06-03 12:45:00 | AAPL | Stock | 0.5111 | 0.5116 | 0.5104 | 0.5113 | 3271016.0 |
| 2004-06-03 12:50:00 | AAPL | Stock | 0.5111 | 0.5116 | 0.5105 | 0.5114 | 9227512.0 |
| 2004-06-03 12:55:00 | AAPL | Stock | 0.5114 | 0.512 | 0.5114 | 0.5116 | 592480.0 |
| 2004-06-03 13:00:00 | AAPL | Stock | 0.5118 | 0.5118 | 0.5114 | 0.5114 | 544432.0 |
| 2004-06-03 13:05:00 | AAPL | Stock | 0.5114 | 0.5123 | 0.5113 | 0.5121 | 985320.0 |
| 2004-06-03 13:10:00 | AAPL | Stock | 0.512 | 0.512 | 0.5113 | 0.512 | 1821288.0 |
| 2004-06-03 13:15:00 | AAPL | Stock | 0.5123 | 0.5134 | 0.5123 | 0.5129 | 1120000.0 |
| 2004-06-03 13:20:00 | AAPL | Stock | 0.5127 | 0.5136 | 0.5127 | 0.5129 | 3284400.0 |
| 2004-06-03 13:25:00 | AAPL | Stock | 0.5127 | 0.5129 | 0.5127 | 0.5129 | 704592.0 |
> showing 50 of 171,771 rows — these rows as CSV