PREVIEW / stock_1min / 2009-05-22
file: by_date/stock_1min/2009/2009-05-22.parquet size: 11.9 MB rows: 917,869 symbols: 2,703
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-05-22 04:19:00 | AAPL | Stock | 4.4496 | 4.4496 | 4.4496 | 4.4496 | 2800.0 |
| 2009-05-22 04:21:00 | AAPL | Stock | 4.4529 | 4.4529 | 4.4529 | 4.4529 | 2800.0 |
| 2009-05-22 06:24:00 | AAPL | Stock | 4.4768 | 4.4768 | 4.4768 | 4.4768 | 2800.0 |
| 2009-05-22 06:30:00 | AAPL | Stock | 4.4821 | 4.4821 | 4.4821 | 4.4821 | 2800.0 |
| 2009-05-22 06:34:00 | AAPL | Stock | 4.4871 | 4.4871 | 4.4871 | 4.4871 | 2800.0 |
| 2009-05-22 07:03:00 | AAPL | Stock | 4.4714 | 4.4714 | 4.4714 | 4.4714 | 2800.0 |
| 2009-05-22 07:04:00 | AAPL | Stock | 4.4714 | 4.4714 | 4.4714 | 4.4714 | 28364.0 |
| 2009-05-22 07:05:00 | AAPL | Stock | 4.4286 | 4.4286 | 4.4286 | 4.4286 | 2800.0 |
| 2009-05-22 07:07:00 | AAPL | Stock | 4.4321 | 4.4321 | 4.4321 | 4.4321 | 2800.0 |
| 2009-05-22 07:08:00 | AAPL | Stock | 4.4732 | 4.4732 | 4.4732 | 4.4732 | 2800.0 |
| 2009-05-22 07:23:00 | AAPL | Stock | 4.4464 | 4.4464 | 4.4464 | 4.4464 | 2800.0 |
| 2009-05-22 07:26:00 | AAPL | Stock | 4.4321 | 4.4321 | 4.4321 | 4.4321 | 2800.0 |
| 2009-05-22 07:30:00 | AAPL | Stock | 4.4464 | 4.4464 | 4.4464 | 4.4464 | 8400.0 |
| 2009-05-22 07:31:00 | AAPL | Stock | 4.4464 | 4.4464 | 4.4464 | 4.4464 | 2800.0 |
| 2009-05-22 07:35:00 | AAPL | Stock | 4.4536 | 4.4536 | 4.4536 | 4.4536 | 3276.0 |
| 2009-05-22 07:36:00 | AAPL | Stock | 4.4536 | 4.4536 | 4.4536 | 4.4536 | 5600.0 |
| 2009-05-22 07:44:00 | AAPL | Stock | 4.4571 | 4.4571 | 4.4571 | 4.4571 | 2800.0 |
| 2009-05-22 08:02:00 | AAPL | Stock | 4.4525 | 4.4525 | 4.4482 | 4.4482 | 9800.0 |
| 2009-05-22 08:03:00 | AAPL | Stock | 4.4482 | 4.4482 | 4.4482 | 4.4482 | 9492.0 |
| 2009-05-22 08:04:00 | AAPL | Stock | 4.4482 | 4.4482 | 4.4482 | 4.4482 | 18900.0 |
| 2009-05-22 08:05:00 | AAPL | Stock | 4.4482 | 4.4482 | 4.4482 | 4.4482 | 2800.0 |
| 2009-05-22 08:06:00 | AAPL | Stock | 4.4525 | 4.4543 | 4.4471 | 4.4471 | 92400.0 |
| 2009-05-22 08:09:00 | AAPL | Stock | 4.4468 | 4.4468 | 4.4464 | 4.4464 | 142520.0 |
| 2009-05-22 08:12:00 | AAPL | Stock | 4.45 | 4.45 | 4.45 | 4.45 | 8400.0 |
| 2009-05-22 08:16:00 | AAPL | Stock | 4.45 | 4.45 | 4.45 | 4.45 | 11200.0 |
| 2009-05-22 08:17:00 | AAPL | Stock | 4.45 | 4.45 | 4.45 | 4.45 | 42000.0 |
| 2009-05-22 08:18:00 | AAPL | Stock | 4.4496 | 4.45 | 4.4496 | 4.45 | 14700.0 |
| 2009-05-22 08:19:00 | AAPL | Stock | 4.45 | 4.45 | 4.45 | 4.45 | 5600.0 |
| 2009-05-22 08:20:00 | AAPL | Stock | 4.4471 | 4.4471 | 4.4464 | 4.4464 | 10640.0 |
| 2009-05-22 08:21:00 | AAPL | Stock | 4.4496 | 4.4496 | 4.4496 | 4.4496 | 14000.0 |
| 2009-05-22 08:24:00 | AAPL | Stock | 4.45 | 4.45 | 4.45 | 4.45 | 8400.0 |
| 2009-05-22 08:25:00 | AAPL | Stock | 4.4482 | 4.4482 | 4.4464 | 4.4464 | 11200.0 |
| 2009-05-22 08:27:00 | AAPL | Stock | 4.4496 | 4.4496 | 4.4496 | 4.4496 | 10500.0 |
| 2009-05-22 08:32:00 | AAPL | Stock | 4.4486 | 4.4486 | 4.4486 | 4.4486 | 2800.0 |
| 2009-05-22 08:37:00 | AAPL | Stock | 4.4486 | 4.4486 | 4.4486 | 4.4486 | 28000.0 |
| 2009-05-22 08:39:00 | AAPL | Stock | 4.45 | 4.45 | 4.45 | 4.45 | 11312.0 |
| 2009-05-22 08:40:00 | AAPL | Stock | 4.4482 | 4.4482 | 4.4464 | 4.4464 | 11900.0 |
| 2009-05-22 08:46:00 | AAPL | Stock | 4.4496 | 4.4496 | 4.4496 | 4.4496 | 2800.0 |
| 2009-05-22 08:47:00 | AAPL | Stock | 4.45 | 4.4511 | 4.45 | 4.4511 | 76104.0 |
| 2009-05-22 08:48:00 | AAPL | Stock | 4.4536 | 4.4536 | 4.4536 | 4.4536 | 5124.0 |
| 2009-05-22 08:49:00 | AAPL | Stock | 4.4504 | 4.4504 | 4.4504 | 4.4504 | 33600.0 |
| 2009-05-22 08:50:00 | AAPL | Stock | 4.4511 | 4.4511 | 4.4511 | 4.4511 | 2800.0 |
| 2009-05-22 08:51:00 | AAPL | Stock | 4.4511 | 4.4511 | 4.4511 | 4.4511 | 14420.0 |
| 2009-05-22 08:52:00 | AAPL | Stock | 4.4511 | 4.4511 | 4.4511 | 4.4511 | 17220.0 |
| 2009-05-22 08:58:00 | AAPL | Stock | 4.4518 | 4.4536 | 4.4518 | 4.4536 | 5600.0 |
| 2009-05-22 08:59:00 | AAPL | Stock | 4.4536 | 4.4536 | 4.4536 | 4.4536 | 8260.0 |
| 2009-05-22 09:00:00 | AAPL | Stock | 4.4539 | 4.4539 | 4.4518 | 4.4518 | 26180.0 |
| 2009-05-22 09:03:00 | AAPL | Stock | 4.4511 | 4.4511 | 4.4511 | 4.4511 | 15092.0 |
| 2009-05-22 09:04:00 | AAPL | Stock | 4.4511 | 4.4511 | 4.4511 | 4.4511 | 12348.0 |
| 2009-05-22 09:06:00 | AAPL | Stock | 4.4518 | 4.4518 | 4.4518 | 4.4518 | 14000.0 |
> showing 50 of 917,869 rows — these rows as CSV