PREVIEW / stock_1min / 2009-03-18
file: by_date/stock_1min/2009/2009-03-18.parquet size: 12.6 MB rows: 960,821 symbols: 2,711
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-03-18 05:31:00 | AAPL | Stock | 3.55 | 3.55 | 3.55 | 3.55 | 5600.0 |
| 2009-03-18 06:57:00 | AAPL | Stock | 3.5525 | 3.5525 | 3.5525 | 3.5525 | 5600.0 |
| 2009-03-18 07:33:00 | AAPL | Stock | 3.5496 | 3.5496 | 3.5493 | 3.5493 | 5600.0 |
| 2009-03-18 07:37:00 | AAPL | Stock | 3.5486 | 3.5486 | 3.5486 | 3.5486 | 5040.0 |
| 2009-03-18 07:41:00 | AAPL | Stock | 3.5604 | 3.5604 | 3.5604 | 3.5604 | 2800.0 |
| 2009-03-18 07:42:00 | AAPL | Stock | 3.5625 | 3.5625 | 3.5625 | 3.5625 | 4956.0 |
| 2009-03-18 08:01:00 | AAPL | Stock | 3.545 | 3.545 | 3.545 | 3.545 | 9100.0 |
| 2009-03-18 08:02:00 | AAPL | Stock | 3.5379 | 3.5379 | 3.5311 | 3.5311 | 147000.0 |
| 2009-03-18 08:03:00 | AAPL | Stock | 3.5304 | 3.5304 | 3.5268 | 3.5268 | 22400.0 |
| 2009-03-18 08:04:00 | AAPL | Stock | 3.5268 | 3.5286 | 3.5268 | 3.5286 | 8400.0 |
| 2009-03-18 08:07:00 | AAPL | Stock | 3.5286 | 3.5357 | 3.5286 | 3.5357 | 15400.0 |
| 2009-03-18 08:09:00 | AAPL | Stock | 3.5289 | 3.5357 | 3.5289 | 3.5357 | 6020.0 |
| 2009-03-18 08:13:00 | AAPL | Stock | 3.5286 | 3.5286 | 3.5286 | 3.5286 | 2800.0 |
| 2009-03-18 08:14:00 | AAPL | Stock | 3.5329 | 3.5357 | 3.5329 | 3.5357 | 68180.0 |
| 2009-03-18 08:15:00 | AAPL | Stock | 3.5339 | 3.5339 | 3.5296 | 3.5304 | 14980.0 |
| 2009-03-18 08:17:00 | AAPL | Stock | 3.5418 | 3.5425 | 3.5418 | 3.5418 | 22400.0 |
| 2009-03-18 08:19:00 | AAPL | Stock | 3.5357 | 3.5357 | 3.5357 | 3.5357 | 18340.0 |
| 2009-03-18 08:21:00 | AAPL | Stock | 3.5364 | 3.5364 | 3.5364 | 3.5364 | 5600.0 |
| 2009-03-18 08:22:00 | AAPL | Stock | 3.5379 | 3.5379 | 3.5379 | 3.5379 | 14000.0 |
| 2009-03-18 08:24:00 | AAPL | Stock | 3.5357 | 3.5357 | 3.5357 | 3.5357 | 2800.0 |
| 2009-03-18 08:25:00 | AAPL | Stock | 3.5357 | 3.5357 | 3.5329 | 3.5329 | 86520.0 |
| 2009-03-18 08:32:00 | AAPL | Stock | 3.5339 | 3.5339 | 3.5321 | 3.5321 | 16324.0 |
| 2009-03-18 08:33:00 | AAPL | Stock | 3.5321 | 3.5321 | 3.5321 | 3.5321 | 8400.0 |
| 2009-03-18 08:34:00 | AAPL | Stock | 3.5332 | 3.5332 | 3.5311 | 3.5311 | 74564.0 |
| 2009-03-18 08:35:00 | AAPL | Stock | 3.5321 | 3.5321 | 3.5321 | 3.5321 | 6636.0 |
| 2009-03-18 08:36:00 | AAPL | Stock | 3.5339 | 3.5339 | 3.5339 | 3.5339 | 2800.0 |
| 2009-03-18 08:37:00 | AAPL | Stock | 3.5425 | 3.5436 | 3.5425 | 3.5436 | 28000.0 |
| 2009-03-18 08:39:00 | AAPL | Stock | 3.5339 | 3.5339 | 3.5339 | 3.5339 | 2800.0 |
| 2009-03-18 08:40:00 | AAPL | Stock | 3.5357 | 3.5357 | 3.5357 | 3.5357 | 2800.0 |
| 2009-03-18 08:41:00 | AAPL | Stock | 3.5357 | 3.5357 | 3.5357 | 3.5357 | 5600.0 |
| 2009-03-18 08:43:00 | AAPL | Stock | 3.5393 | 3.5393 | 3.5393 | 3.5393 | 5600.0 |
| 2009-03-18 08:49:00 | AAPL | Stock | 3.5357 | 3.5479 | 3.5357 | 3.5479 | 46200.0 |
| 2009-03-18 08:50:00 | AAPL | Stock | 3.5482 | 3.5536 | 3.5482 | 3.5536 | 53200.0 |
| 2009-03-18 08:51:00 | AAPL | Stock | 3.5536 | 3.5536 | 3.5536 | 3.5536 | 23800.0 |
| 2009-03-18 08:52:00 | AAPL | Stock | 3.5536 | 3.5657 | 3.5536 | 3.5657 | 179200.0 |
| 2009-03-18 08:53:00 | AAPL | Stock | 3.5643 | 3.5707 | 3.5643 | 3.5643 | 142800.0 |
| 2009-03-18 08:54:00 | AAPL | Stock | 3.5625 | 3.5643 | 3.5557 | 3.5557 | 61656.0 |
| 2009-03-18 08:55:00 | AAPL | Stock | 3.5575 | 3.5643 | 3.5571 | 3.5643 | 55944.0 |
| 2009-03-18 08:56:00 | AAPL | Stock | 3.5643 | 3.5714 | 3.5643 | 3.5693 | 414652.0 |
| 2009-03-18 08:57:00 | AAPL | Stock | 3.5693 | 3.5832 | 3.5693 | 3.5821 | 567308.0 |
| 2009-03-18 08:58:00 | AAPL | Stock | 3.5832 | 3.5864 | 3.5789 | 3.5839 | 614712.0 |
| 2009-03-18 08:59:00 | AAPL | Stock | 3.5789 | 3.5821 | 3.5786 | 3.5786 | 173600.0 |
| 2009-03-18 09:00:00 | AAPL | Stock | 3.5757 | 3.5804 | 3.5718 | 3.5754 | 44800.0 |
| 2009-03-18 09:01:00 | AAPL | Stock | 3.575 | 3.575 | 3.5729 | 3.5729 | 22400.0 |
| 2009-03-18 09:02:00 | AAPL | Stock | 3.5729 | 3.5729 | 3.5721 | 3.5721 | 15680.0 |
| 2009-03-18 09:03:00 | AAPL | Stock | 3.5714 | 3.5732 | 3.5671 | 3.5714 | 155904.0 |
| 2009-03-18 09:04:00 | AAPL | Stock | 3.5682 | 3.5696 | 3.565 | 3.5661 | 48272.0 |
| 2009-03-18 09:05:00 | AAPL | Stock | 3.5679 | 3.5696 | 3.5679 | 3.5696 | 196000.0 |
| 2009-03-18 09:06:00 | AAPL | Stock | 3.5661 | 3.5661 | 3.5661 | 3.5661 | 2800.0 |
| 2009-03-18 09:08:00 | AAPL | Stock | 3.5671 | 3.5671 | 3.5614 | 3.5625 | 38640.0 |
> showing 50 of 960,821 rows — these rows as CSV