PREVIEW / stock_1min / 2008-02-15
file: by_date/stock_1min/2008/2008-02-15.parquet size: 12.0 MB rows: 986,984 symbols: 2,664
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 |
|---|---|---|---|---|---|---|---|
| 2008-02-15 07:07:00 | AAPL | Stock | 4.5386 | 4.5386 | 4.5386 | 4.5386 | 28000.0 |
| 2008-02-15 07:18:00 | AAPL | Stock | 4.5482 | 4.5482 | 4.5357 | 4.5357 | 36400.0 |
| 2008-02-15 07:19:00 | AAPL | Stock | 4.5357 | 4.5357 | 4.5357 | 4.5357 | 33600.0 |
| 2008-02-15 07:39:00 | AAPL | Stock | 4.5429 | 4.5429 | 4.5375 | 4.5375 | 16800.0 |
| 2008-02-15 07:44:00 | AAPL | Stock | 4.5375 | 4.5375 | 4.5375 | 4.5375 | 5600.0 |
| 2008-02-15 07:53:00 | AAPL | Stock | 4.5375 | 4.5375 | 4.5375 | 4.5375 | 2800.0 |
| 2008-02-15 07:55:00 | AAPL | Stock | 4.5375 | 4.5375 | 4.5375 | 4.5375 | 5600.0 |
| 2008-02-15 07:56:00 | AAPL | Stock | 4.5375 | 4.5375 | 4.5375 | 4.5375 | 11480.0 |
| 2008-02-15 07:59:00 | AAPL | Stock | 4.5264 | 4.5264 | 4.52 | 4.52 | 28000.0 |
| 2008-02-15 08:00:00 | AAPL | Stock | 4.5336 | 4.5336 | 4.5179 | 4.5179 | 144368.0 |
| 2008-02-15 08:01:00 | AAPL | Stock | 4.5221 | 4.5286 | 4.5111 | 4.5189 | 59248.0 |
| 2008-02-15 08:02:00 | AAPL | Stock | 4.5189 | 4.5189 | 4.5125 | 4.5125 | 47600.0 |
| 2008-02-15 08:03:00 | AAPL | Stock | 4.5186 | 4.5189 | 4.5125 | 4.5164 | 30800.0 |
| 2008-02-15 08:04:00 | AAPL | Stock | 4.5118 | 4.5118 | 4.5089 | 4.5089 | 122780.0 |
| 2008-02-15 08:05:00 | AAPL | Stock | 4.5089 | 4.5089 | 4.5036 | 4.5039 | 95200.0 |
| 2008-02-15 08:06:00 | AAPL | Stock | 4.5039 | 4.5179 | 4.5 | 4.5086 | 154336.0 |
| 2008-02-15 08:07:00 | AAPL | Stock | 4.5089 | 4.5089 | 4.5089 | 4.5089 | 16800.0 |
| 2008-02-15 08:08:00 | AAPL | Stock | 4.5089 | 4.5089 | 4.5054 | 4.5054 | 23156.0 |
| 2008-02-15 08:09:00 | AAPL | Stock | 4.5064 | 4.5064 | 4.5064 | 4.5064 | 2800.0 |
| 2008-02-15 08:10:00 | AAPL | Stock | 4.5071 | 4.5107 | 4.5071 | 4.5075 | 32200.0 |
| 2008-02-15 08:11:00 | AAPL | Stock | 4.5071 | 4.5071 | 4.5071 | 4.5071 | 4200.0 |
| 2008-02-15 08:12:00 | AAPL | Stock | 4.5104 | 4.5104 | 4.5104 | 4.5104 | 2800.0 |
| 2008-02-15 08:13:00 | AAPL | Stock | 4.5071 | 4.5071 | 4.5071 | 4.5071 | 28700.0 |
| 2008-02-15 08:14:00 | AAPL | Stock | 4.5107 | 4.5107 | 4.5107 | 4.5107 | 5600.0 |
| 2008-02-15 08:15:00 | AAPL | Stock | 4.5107 | 4.5107 | 4.5107 | 4.5107 | 14784.0 |
| 2008-02-15 08:17:00 | AAPL | Stock | 4.5143 | 4.5143 | 4.5125 | 4.5143 | 32480.0 |
| 2008-02-15 08:18:00 | AAPL | Stock | 4.5157 | 4.5179 | 4.5157 | 4.5179 | 19656.0 |
| 2008-02-15 08:19:00 | AAPL | Stock | 4.5161 | 4.5161 | 4.5157 | 4.5157 | 16800.0 |
| 2008-02-15 08:20:00 | AAPL | Stock | 4.5171 | 4.5179 | 4.5157 | 4.5157 | 58800.0 |
| 2008-02-15 08:22:00 | AAPL | Stock | 4.5171 | 4.5171 | 4.5171 | 4.5171 | 2800.0 |
| 2008-02-15 08:23:00 | AAPL | Stock | 4.5179 | 4.5179 | 4.515 | 4.515 | 28000.0 |
| 2008-02-15 08:24:00 | AAPL | Stock | 4.5146 | 4.5146 | 4.5146 | 4.5146 | 11200.0 |
| 2008-02-15 08:25:00 | AAPL | Stock | 4.5161 | 4.5161 | 4.5161 | 4.5161 | 2800.0 |
| 2008-02-15 08:26:00 | AAPL | Stock | 4.5171 | 4.5171 | 4.5171 | 4.5171 | 6300.0 |
| 2008-02-15 08:27:00 | AAPL | Stock | 4.5171 | 4.5179 | 4.5171 | 4.5179 | 35700.0 |
| 2008-02-15 08:28:00 | AAPL | Stock | 4.5179 | 4.5179 | 4.5168 | 4.5168 | 32228.0 |
| 2008-02-15 08:29:00 | AAPL | Stock | 4.5161 | 4.5161 | 4.5146 | 4.5146 | 63700.0 |
| 2008-02-15 08:30:00 | AAPL | Stock | 4.5146 | 4.5146 | 4.4943 | 4.4943 | 475636.0 |
| 2008-02-15 08:31:00 | AAPL | Stock | 4.4968 | 4.4982 | 4.4907 | 4.4921 | 153720.0 |
| 2008-02-15 08:32:00 | AAPL | Stock | 4.4936 | 4.4975 | 4.4936 | 4.4975 | 34160.0 |
| 2008-02-15 08:33:00 | AAPL | Stock | 4.5 | 4.505 | 4.4975 | 4.5004 | 60200.0 |
| 2008-02-15 08:34:00 | AAPL | Stock | 4.5007 | 4.5007 | 4.5 | 4.5 | 204372.0 |
| 2008-02-15 08:35:00 | AAPL | Stock | 4.5007 | 4.5029 | 4.5 | 4.5 | 210000.0 |
| 2008-02-15 08:36:00 | AAPL | Stock | 4.5 | 4.5 | 4.5 | 4.5 | 39200.0 |
| 2008-02-15 08:37:00 | AAPL | Stock | 4.5 | 4.5004 | 4.5 | 4.5004 | 48860.0 |
| 2008-02-15 08:38:00 | AAPL | Stock | 4.5011 | 4.5011 | 4.5 | 4.5 | 42000.0 |
| 2008-02-15 08:39:00 | AAPL | Stock | 4.5032 | 4.505 | 4.5 | 4.505 | 99344.0 |
| 2008-02-15 08:40:00 | AAPL | Stock | 4.5004 | 4.5004 | 4.5004 | 4.5004 | 7000.0 |
| 2008-02-15 08:41:00 | AAPL | Stock | 4.5004 | 4.5004 | 4.5 | 4.5004 | 13804.0 |
| 2008-02-15 08:42:00 | AAPL | Stock | 4.5036 | 4.5036 | 4.5036 | 4.5036 | 5432.0 |
> showing 50 of 986,984 rows — these rows as CSV