PREVIEW / stock_1min / 2004-01-08
file: by_date/stock_1min/2004/2004-01-08.parquet size: 6.0 MB rows: 492,656 symbols: 1,409
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-01-08 08:33:00 | AAPL | Stock | 0.4054 | 0.4054 | 0.4054 | 0.4054 | 280000.0 |
| 2004-01-08 08:35:00 | AAPL | Stock | 0.4054 | 0.4054 | 0.4054 | 0.4054 | 28000.0 |
| 2004-01-08 08:53:00 | AAPL | Stock | 0.4054 | 0.4054 | 0.4054 | 0.4054 | 140000.0 |
| 2004-01-08 08:54:00 | AAPL | Stock | 0.4054 | 0.4054 | 0.4054 | 0.4054 | 56000.0 |
| 2004-01-08 08:57:00 | AAPL | Stock | 0.4055 | 0.4055 | 0.4054 | 0.4054 | 56000.0 |
| 2004-01-08 09:03:00 | AAPL | Stock | 0.4054 | 0.4054 | 0.4054 | 0.4054 | 28000.0 |
| 2004-01-08 09:07:00 | AAPL | Stock | 0.4054 | 0.4054 | 0.4054 | 0.4054 | 16800.0 |
| 2004-01-08 09:19:00 | AAPL | Stock | 0.4052 | 0.4054 | 0.4052 | 0.4054 | 196000.0 |
| 2004-01-08 09:23:00 | AAPL | Stock | 0.4057 | 0.4057 | 0.4057 | 0.4057 | 112000.0 |
| 2004-01-08 09:24:00 | AAPL | Stock | 0.4059 | 0.4059 | 0.4059 | 0.4059 | 112000.0 |
| 2004-01-08 09:26:00 | AAPL | Stock | 0.4063 | 0.4063 | 0.4063 | 0.4063 | 67200.0 |
| 2004-01-08 09:27:00 | AAPL | Stock | 0.4071 | 0.4071 | 0.4071 | 0.4071 | 84000.0 |
| 2004-01-08 09:28:00 | AAPL | Stock | 0.4063 | 0.4064 | 0.4063 | 0.4063 | 554400.0 |
| 2004-01-08 09:29:00 | AAPL | Stock | 0.4063 | 0.4073 | 0.4063 | 0.4073 | 700000.0 |
| 2004-01-08 09:30:00 | AAPL | Stock | 0.4075 | 0.4077 | 0.4061 | 0.4077 | 7107296.0 |
| 2004-01-08 09:31:00 | AAPL | Stock | 0.4077 | 0.4077 | 0.4061 | 0.407 | 2589384.0 |
| 2004-01-08 09:32:00 | AAPL | Stock | 0.4064 | 0.4068 | 0.4061 | 0.4061 | 2066120.0 |
| 2004-01-08 09:33:00 | AAPL | Stock | 0.4061 | 0.4063 | 0.4055 | 0.4055 | 1271928.0 |
| 2004-01-08 09:34:00 | AAPL | Stock | 0.4055 | 0.4064 | 0.4055 | 0.4061 | 2299360.0 |
| 2004-01-08 09:35:00 | AAPL | Stock | 0.4061 | 0.4063 | 0.4059 | 0.4063 | 1452920.0 |
| 2004-01-08 09:36:00 | AAPL | Stock | 0.4063 | 0.4066 | 0.4059 | 0.4066 | 879200.0 |
| 2004-01-08 09:37:00 | AAPL | Stock | 0.4064 | 0.408 | 0.4064 | 0.408 | 2699592.0 |
| 2004-01-08 09:38:00 | AAPL | Stock | 0.408 | 0.4095 | 0.408 | 0.4093 | 2017904.0 |
| 2004-01-08 09:39:00 | AAPL | Stock | 0.4089 | 0.4098 | 0.4079 | 0.4092 | 1706320.0 |
| 2004-01-08 09:40:00 | AAPL | Stock | 0.4096 | 0.4107 | 0.4089 | 0.4107 | 4850104.0 |
| 2004-01-08 09:41:00 | AAPL | Stock | 0.4105 | 0.4107 | 0.4096 | 0.4105 | 3261664.0 |
| 2004-01-08 09:42:00 | AAPL | Stock | 0.4105 | 0.4117 | 0.4105 | 0.4111 | 7495040.0 |
| 2004-01-08 09:43:00 | AAPL | Stock | 0.4114 | 0.413 | 0.4107 | 0.4123 | 3154816.0 |
| 2004-01-08 09:44:00 | AAPL | Stock | 0.4123 | 0.4134 | 0.4121 | 0.4123 | 3451056.0 |
| 2004-01-08 09:45:00 | AAPL | Stock | 0.4125 | 0.413 | 0.4121 | 0.4123 | 3276504.0 |
| 2004-01-08 09:46:00 | AAPL | Stock | 0.4121 | 0.4132 | 0.4114 | 0.413 | 3080000.0 |
| 2004-01-08 09:47:00 | AAPL | Stock | 0.4132 | 0.4132 | 0.4116 | 0.4116 | 954800.0 |
| 2004-01-08 09:48:00 | AAPL | Stock | 0.4116 | 0.412 | 0.4116 | 0.4116 | 408800.0 |
| 2004-01-08 09:49:00 | AAPL | Stock | 0.4116 | 0.4129 | 0.4114 | 0.4127 | 1217216.0 |
| 2004-01-08 09:50:00 | AAPL | Stock | 0.4127 | 0.4127 | 0.4116 | 0.4116 | 1159200.0 |
| 2004-01-08 09:51:00 | AAPL | Stock | 0.4116 | 0.4116 | 0.4107 | 0.4109 | 1108072.0 |
| 2004-01-08 09:52:00 | AAPL | Stock | 0.4107 | 0.4113 | 0.4107 | 0.4107 | 1593200.0 |
| 2004-01-08 09:53:00 | AAPL | Stock | 0.4107 | 0.4111 | 0.4107 | 0.4109 | 1049776.0 |
| 2004-01-08 09:54:00 | AAPL | Stock | 0.4109 | 0.412 | 0.4107 | 0.4118 | 1184120.0 |
| 2004-01-08 09:55:00 | AAPL | Stock | 0.4118 | 0.4121 | 0.4118 | 0.412 | 1853600.0 |
| 2004-01-08 09:56:00 | AAPL | Stock | 0.412 | 0.4121 | 0.412 | 0.4121 | 1101072.0 |
| 2004-01-08 09:57:00 | AAPL | Stock | 0.412 | 0.4125 | 0.412 | 0.4125 | 781256.0 |
| 2004-01-08 09:58:00 | AAPL | Stock | 0.4127 | 0.4134 | 0.4127 | 0.4134 | 1917944.0 |
| 2004-01-08 09:59:00 | AAPL | Stock | 0.4134 | 0.4143 | 0.4132 | 0.4134 | 5603864.0 |
| 2004-01-08 10:00:00 | AAPL | Stock | 0.4132 | 0.4134 | 0.4132 | 0.4132 | 504000.0 |
| 2004-01-08 10:01:00 | AAPL | Stock | 0.4134 | 0.4134 | 0.4131 | 0.4132 | 984200.0 |
| 2004-01-08 10:02:00 | AAPL | Stock | 0.4132 | 0.4139 | 0.4132 | 0.4134 | 862400.0 |
| 2004-01-08 10:03:00 | AAPL | Stock | 0.4134 | 0.4138 | 0.4134 | 0.4134 | 268800.0 |
| 2004-01-08 10:04:00 | AAPL | Stock | 0.4138 | 0.4138 | 0.4136 | 0.4136 | 668304.0 |
| 2004-01-08 10:05:00 | AAPL | Stock | 0.4136 | 0.4141 | 0.4136 | 0.4141 | 1030400.0 |
> showing 50 of 492,656 rows — these rows as CSV