PREVIEW / stock_1min / 2010-10-12
file: by_date/stock_1min/2010/2010-10-12.parquet size: 12.2 MB rows: 919,517 symbols: 2,826
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 |
|---|---|---|---|---|---|---|---|
| 2010-10-12 04:00:00 | AAPL | Stock | 10.5393 | 10.5393 | 10.5393 | 10.5393 | 2800.0 |
| 2010-10-12 04:06:00 | AAPL | Stock | 10.5271 | 10.5271 | 10.5271 | 10.5271 | 2800.0 |
| 2010-10-12 04:11:00 | AAPL | Stock | 10.4821 | 10.4821 | 10.4821 | 10.4821 | 2800.0 |
| 2010-10-12 05:05:00 | AAPL | Stock | 10.4286 | 10.4286 | 10.4286 | 10.4286 | 11200.0 |
| 2010-10-12 05:15:00 | AAPL | Stock | 10.4418 | 10.4418 | 10.4418 | 10.4418 | 14000.0 |
| 2010-10-12 05:19:00 | AAPL | Stock | 10.4464 | 10.4464 | 10.4464 | 10.4464 | 11200.0 |
| 2010-10-12 05:25:00 | AAPL | Stock | 10.4464 | 10.4464 | 10.4461 | 10.4461 | 11200.0 |
| 2010-10-12 05:33:00 | AAPL | Stock | 10.4818 | 10.4818 | 10.4818 | 10.4818 | 2800.0 |
| 2010-10-12 05:49:00 | AAPL | Stock | 10.4661 | 10.4661 | 10.4661 | 10.4661 | 3192.0 |
| 2010-10-12 05:53:00 | AAPL | Stock | 10.4689 | 10.4689 | 10.4689 | 10.4689 | 8960.0 |
| 2010-10-12 07:00:00 | AAPL | Stock | 10.4961 | 10.4964 | 10.4929 | 10.4929 | 41720.0 |
| 2010-10-12 07:01:00 | AAPL | Stock | 10.4693 | 10.4693 | 10.4693 | 10.4693 | 2800.0 |
| 2010-10-12 07:03:00 | AAPL | Stock | 10.4818 | 10.4818 | 10.4646 | 10.4646 | 12600.0 |
| 2010-10-12 07:04:00 | AAPL | Stock | 10.4786 | 10.4786 | 10.4786 | 10.4786 | 14000.0 |
| 2010-10-12 07:06:00 | AAPL | Stock | 10.4882 | 10.4882 | 10.4882 | 10.4882 | 8400.0 |
| 2010-10-12 07:09:00 | AAPL | Stock | 10.4879 | 10.4879 | 10.4879 | 10.4879 | 2800.0 |
| 2010-10-12 07:11:00 | AAPL | Stock | 10.4761 | 10.4761 | 10.4761 | 10.4761 | 2800.0 |
| 2010-10-12 07:13:00 | AAPL | Stock | 10.4754 | 10.4754 | 10.475 | 10.475 | 16800.0 |
| 2010-10-12 07:20:00 | AAPL | Stock | 10.4836 | 10.4882 | 10.4836 | 10.4839 | 17080.0 |
| 2010-10-12 07:26:00 | AAPL | Stock | 10.4982 | 10.4982 | 10.4982 | 10.4982 | 5600.0 |
| 2010-10-12 07:29:00 | AAPL | Stock | 10.4914 | 10.4914 | 10.4911 | 10.4911 | 23800.0 |
| 2010-10-12 07:30:00 | AAPL | Stock | 10.4911 | 10.4911 | 10.4911 | 10.4911 | 8400.0 |
| 2010-10-12 07:31:00 | AAPL | Stock | 10.4911 | 10.4911 | 10.4911 | 10.4911 | 2800.0 |
| 2010-10-12 07:34:00 | AAPL | Stock | 10.4893 | 10.4893 | 10.4893 | 10.4893 | 2800.0 |
| 2010-10-12 07:36:00 | AAPL | Stock | 10.4982 | 10.4982 | 10.4982 | 10.4982 | 2800.0 |
| 2010-10-12 07:39:00 | AAPL | Stock | 10.4996 | 10.5 | 10.4996 | 10.5 | 18200.0 |
| 2010-10-12 07:40:00 | AAPL | Stock | 10.4982 | 10.5057 | 10.4982 | 10.5057 | 10024.0 |
| 2010-10-12 07:41:00 | AAPL | Stock | 10.5071 | 10.5096 | 10.5071 | 10.5096 | 16800.0 |
| 2010-10-12 07:42:00 | AAPL | Stock | 10.5136 | 10.5136 | 10.5136 | 10.5136 | 2800.0 |
| 2010-10-12 07:43:00 | AAPL | Stock | 10.5179 | 10.5236 | 10.4982 | 10.5236 | 37604.0 |
| 2010-10-12 07:44:00 | AAPL | Stock | 10.52 | 10.525 | 10.52 | 10.525 | 8400.0 |
| 2010-10-12 07:45:00 | AAPL | Stock | 10.5304 | 10.5336 | 10.5304 | 10.5336 | 16800.0 |
| 2010-10-12 07:46:00 | AAPL | Stock | 10.535 | 10.5371 | 10.5232 | 10.5232 | 57540.0 |
| 2010-10-12 07:47:00 | AAPL | Stock | 10.5357 | 10.5357 | 10.5357 | 10.5357 | 28000.0 |
| 2010-10-12 07:48:00 | AAPL | Stock | 10.5289 | 10.5289 | 10.5289 | 10.5289 | 11200.0 |
| 2010-10-12 07:49:00 | AAPL | Stock | 10.5286 | 10.5286 | 10.5268 | 10.5268 | 28000.0 |
| 2010-10-12 07:51:00 | AAPL | Stock | 10.5268 | 10.5339 | 10.5268 | 10.5339 | 40600.0 |
| 2010-10-12 07:52:00 | AAPL | Stock | 10.5321 | 10.5354 | 10.5286 | 10.5354 | 40376.0 |
| 2010-10-12 07:53:00 | AAPL | Stock | 10.5304 | 10.5304 | 10.5289 | 10.5289 | 11200.0 |
| 2010-10-12 07:56:00 | AAPL | Stock | 10.5304 | 10.5357 | 10.5304 | 10.5357 | 19880.0 |
| 2010-10-12 07:57:00 | AAPL | Stock | 10.5357 | 10.5357 | 10.5357 | 10.5357 | 2800.0 |
| 2010-10-12 08:00:00 | AAPL | Stock | 10.5375 | 10.5411 | 10.5357 | 10.5364 | 49700.0 |
| 2010-10-12 08:01:00 | AAPL | Stock | 10.5411 | 10.5596 | 10.5368 | 10.5596 | 40180.0 |
| 2010-10-12 08:02:00 | AAPL | Stock | 10.5611 | 10.5611 | 10.5471 | 10.5507 | 152768.0 |
| 2010-10-12 08:03:00 | AAPL | Stock | 10.5521 | 10.5557 | 10.5471 | 10.5471 | 160020.0 |
| 2010-10-12 08:04:00 | AAPL | Stock | 10.5421 | 10.5457 | 10.5393 | 10.5411 | 117600.0 |
| 2010-10-12 08:05:00 | AAPL | Stock | 10.5429 | 10.5446 | 10.5414 | 10.5418 | 22400.0 |
| 2010-10-12 08:06:00 | AAPL | Stock | 10.5418 | 10.5418 | 10.5393 | 10.5393 | 83300.0 |
| 2010-10-12 08:07:00 | AAPL | Stock | 10.5407 | 10.5457 | 10.5407 | 10.5457 | 18144.0 |
| 2010-10-12 08:08:00 | AAPL | Stock | 10.5432 | 10.5454 | 10.5407 | 10.5407 | 35056.0 |
> showing 50 of 919,517 rows — these rows as CSV