PREVIEW / stock_1min / 2009-12-28
file: by_date/stock_1min/2009/2009-12-28.parquet size: 11.7 MB rows: 872,521 symbols: 2,797
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-28 05:00:00 | AAPL | Stock | 7.4771 | 7.4771 | 7.4771 | 7.4771 | 7000.0 |
| 2009-12-28 07:02:00 | AAPL | Stock | 7.4996 | 7.4996 | 7.4996 | 7.4996 | 6440.0 |
| 2009-12-28 07:03:00 | AAPL | Stock | 7.5 | 7.5068 | 7.5 | 7.5 | 14840.0 |
| 2009-12-28 07:04:00 | AAPL | Stock | 7.5 | 7.5332 | 7.5 | 7.5107 | 39956.0 |
| 2009-12-28 07:05:00 | AAPL | Stock | 7.5107 | 7.5107 | 7.5107 | 7.5107 | 2800.0 |
| 2009-12-28 07:06:00 | AAPL | Stock | 7.5107 | 7.5107 | 7.5107 | 7.5107 | 5600.0 |
| 2009-12-28 07:07:00 | AAPL | Stock | 7.5179 | 7.5179 | 7.5179 | 7.5179 | 4900.0 |
| 2009-12-28 07:08:00 | AAPL | Stock | 7.5107 | 7.5107 | 7.5107 | 7.5107 | 5600.0 |
| 2009-12-28 07:09:00 | AAPL | Stock | 7.5004 | 7.5004 | 7.5004 | 7.5004 | 5600.0 |
| 2009-12-28 07:11:00 | AAPL | Stock | 7.5 | 7.5054 | 7.5 | 7.5054 | 39200.0 |
| 2009-12-28 07:20:00 | AAPL | Stock | 7.5086 | 7.5086 | 7.5086 | 7.5086 | 19600.0 |
| 2009-12-28 07:21:00 | AAPL | Stock | 7.5089 | 7.5089 | 7.5089 | 7.5089 | 28000.0 |
| 2009-12-28 07:23:00 | AAPL | Stock | 7.5107 | 7.5107 | 7.5107 | 7.5107 | 16800.0 |
| 2009-12-28 07:24:00 | AAPL | Stock | 7.5054 | 7.5054 | 7.5054 | 7.5054 | 7784.0 |
| 2009-12-28 07:26:00 | AAPL | Stock | 7.5071 | 7.5071 | 7.5071 | 7.5071 | 6748.0 |
| 2009-12-28 07:31:00 | AAPL | Stock | 7.5107 | 7.5107 | 7.5107 | 7.5107 | 2800.0 |
| 2009-12-28 07:39:00 | AAPL | Stock | 7.5093 | 7.5093 | 7.5071 | 7.5071 | 35560.0 |
| 2009-12-28 07:42:00 | AAPL | Stock | 7.5039 | 7.5039 | 7.5039 | 7.5039 | 2800.0 |
| 2009-12-28 07:43:00 | AAPL | Stock | 7.5039 | 7.5039 | 7.5039 | 7.5039 | 2800.0 |
| 2009-12-28 07:44:00 | AAPL | Stock | 7.5039 | 7.5039 | 7.4968 | 7.5029 | 36400.0 |
| 2009-12-28 07:45:00 | AAPL | Stock | 7.5036 | 7.5036 | 7.5036 | 7.5036 | 2800.0 |
| 2009-12-28 07:46:00 | AAPL | Stock | 7.5036 | 7.5036 | 7.5036 | 7.5036 | 14000.0 |
| 2009-12-28 07:50:00 | AAPL | Stock | 7.5036 | 7.5036 | 7.5036 | 7.5036 | 5600.0 |
| 2009-12-28 07:51:00 | AAPL | Stock | 7.4971 | 7.4971 | 7.4929 | 7.4929 | 77000.0 |
| 2009-12-28 07:52:00 | AAPL | Stock | 7.4929 | 7.4929 | 7.4929 | 7.4929 | 75600.0 |
| 2009-12-28 07:53:00 | AAPL | Stock | 7.4921 | 7.4929 | 7.4921 | 7.4929 | 30800.0 |
| 2009-12-28 07:55:00 | AAPL | Stock | 7.4929 | 7.4929 | 7.4929 | 7.4929 | 8400.0 |
| 2009-12-28 08:00:00 | AAPL | Stock | 7.4946 | 7.5 | 7.4821 | 7.4929 | 182336.0 |
| 2009-12-28 08:01:00 | AAPL | Stock | 7.4925 | 7.4979 | 7.4925 | 7.4979 | 48860.0 |
| 2009-12-28 08:02:00 | AAPL | Stock | 7.4982 | 7.5036 | 7.4957 | 7.5 | 254604.0 |
| 2009-12-28 08:03:00 | AAPL | Stock | 7.5 | 7.5004 | 7.4996 | 7.4996 | 72800.0 |
| 2009-12-28 08:04:00 | AAPL | Stock | 7.5 | 7.5036 | 7.5 | 7.5036 | 51520.0 |
| 2009-12-28 08:05:00 | AAPL | Stock | 7.5036 | 7.5036 | 7.4946 | 7.4946 | 134400.0 |
| 2009-12-28 08:06:00 | AAPL | Stock | 7.4979 | 7.5 | 7.4943 | 7.5 | 25200.0 |
| 2009-12-28 08:07:00 | AAPL | Stock | 7.4946 | 7.4996 | 7.4946 | 7.4964 | 19600.0 |
| 2009-12-28 08:08:00 | AAPL | Stock | 7.4986 | 7.4996 | 7.4979 | 7.4989 | 30800.0 |
| 2009-12-28 08:09:00 | AAPL | Stock | 7.5036 | 7.5036 | 7.5036 | 7.5036 | 22400.0 |
| 2009-12-28 08:10:00 | AAPL | Stock | 7.5039 | 7.5086 | 7.5039 | 7.5086 | 22120.0 |
| 2009-12-28 08:11:00 | AAPL | Stock | 7.5125 | 7.5179 | 7.5121 | 7.5171 | 93436.0 |
| 2009-12-28 08:12:00 | AAPL | Stock | 7.5168 | 7.5179 | 7.5132 | 7.5136 | 71008.0 |
| 2009-12-28 08:13:00 | AAPL | Stock | 7.5171 | 7.5261 | 7.5171 | 7.5261 | 98000.0 |
| 2009-12-28 08:14:00 | AAPL | Stock | 7.525 | 7.53 | 7.525 | 7.53 | 89964.0 |
| 2009-12-28 08:15:00 | AAPL | Stock | 7.5286 | 7.5314 | 7.5257 | 7.5271 | 180152.0 |
| 2009-12-28 08:16:00 | AAPL | Stock | 7.5304 | 7.5343 | 7.5286 | 7.5339 | 148512.0 |
| 2009-12-28 08:17:00 | AAPL | Stock | 7.5286 | 7.5314 | 7.5268 | 7.5304 | 178640.0 |
| 2009-12-28 08:18:00 | AAPL | Stock | 7.5336 | 7.5346 | 7.5321 | 7.5346 | 56896.0 |
| 2009-12-28 08:19:00 | AAPL | Stock | 7.5346 | 7.5464 | 7.5346 | 7.5446 | 474740.0 |
| 2009-12-28 08:20:00 | AAPL | Stock | 7.5429 | 7.5532 | 7.5429 | 7.5514 | 445620.0 |
| 2009-12-28 08:21:00 | AAPL | Stock | 7.5514 | 7.5593 | 7.55 | 7.5593 | 274988.0 |
| 2009-12-28 08:22:00 | AAPL | Stock | 7.5605 | 7.5618 | 7.5557 | 7.5557 | 299880.0 |
> showing 50 of 872,521 rows — these rows as CSV