PREVIEW / stock_5min / 2004-08-20
file: by_date/stock_5min/2004/2004-08-20.parquet size: 2.3 MB rows: 172,145 symbols: 1,813
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 |
|---|---|---|---|---|---|---|---|
| 2004-08-20 08:25:00 | AAPL | Stock | 0.547 | 0.5473 | 0.547 | 0.5473 | 61320.0 |
| 2004-08-20 08:45:00 | AAPL | Stock | 0.5482 | 0.5482 | 0.5482 | 0.5482 | 27720.0 |
| 2004-08-20 09:20:00 | AAPL | Stock | 0.5473 | 0.5473 | 0.547 | 0.547 | 33600.0 |
| 2004-08-20 09:25:00 | AAPL | Stock | 0.5468 | 0.548 | 0.5468 | 0.548 | 95536.0 |
| 2004-08-20 09:30:00 | AAPL | Stock | 0.5484 | 0.5489 | 0.5459 | 0.5482 | 10366608.0 |
| 2004-08-20 09:35:00 | AAPL | Stock | 0.5484 | 0.5486 | 0.5466 | 0.5473 | 4035136.0 |
| 2004-08-20 09:40:00 | AAPL | Stock | 0.5473 | 0.5482 | 0.5464 | 0.5477 | 5803728.0 |
| 2004-08-20 09:45:00 | AAPL | Stock | 0.548 | 0.5495 | 0.5471 | 0.5495 | 5397952.0 |
| 2004-08-20 09:50:00 | AAPL | Stock | 0.5495 | 0.5514 | 0.5482 | 0.5514 | 2611056.0 |
| 2004-08-20 09:55:00 | AAPL | Stock | 0.5514 | 0.5527 | 0.5493 | 0.5502 | 4829440.0 |
| 2004-08-20 10:00:00 | AAPL | Stock | 0.5502 | 0.5521 | 0.5495 | 0.55 | 4497808.0 |
| 2004-08-20 10:05:00 | AAPL | Stock | 0.5496 | 0.5513 | 0.5489 | 0.5498 | 4607176.0 |
| 2004-08-20 10:10:00 | AAPL | Stock | 0.5495 | 0.5502 | 0.5479 | 0.5479 | 3312568.0 |
| 2004-08-20 10:15:00 | AAPL | Stock | 0.5479 | 0.5484 | 0.547 | 0.547 | 3205328.0 |
| 2004-08-20 10:20:00 | AAPL | Stock | 0.547 | 0.548 | 0.5468 | 0.548 | 2141552.0 |
| 2004-08-20 10:25:00 | AAPL | Stock | 0.5479 | 0.5479 | 0.5445 | 0.5464 | 4247712.0 |
| 2004-08-20 10:30:00 | AAPL | Stock | 0.5464 | 0.547 | 0.5459 | 0.547 | 2366448.0 |
| 2004-08-20 10:35:00 | AAPL | Stock | 0.5468 | 0.55 | 0.5468 | 0.5496 | 4862480.0 |
| 2004-08-20 10:40:00 | AAPL | Stock | 0.5491 | 0.5509 | 0.5491 | 0.5493 | 3906056.0 |
| 2004-08-20 10:45:00 | AAPL | Stock | 0.5498 | 0.5498 | 0.5491 | 0.5495 | 1911840.0 |
| 2004-08-20 10:50:00 | AAPL | Stock | 0.5493 | 0.5496 | 0.5463 | 0.547 | 4883760.0 |
| 2004-08-20 10:55:00 | AAPL | Stock | 0.547 | 0.5473 | 0.5455 | 0.5459 | 7429800.0 |
| 2004-08-20 11:00:00 | AAPL | Stock | 0.5459 | 0.5473 | 0.5459 | 0.547 | 3450328.0 |
| 2004-08-20 11:05:00 | AAPL | Stock | 0.5468 | 0.547 | 0.5457 | 0.5466 | 4065600.0 |
| 2004-08-20 11:10:00 | AAPL | Stock | 0.5468 | 0.547 | 0.5466 | 0.547 | 3369184.0 |
| 2004-08-20 11:15:00 | AAPL | Stock | 0.5468 | 0.547 | 0.5466 | 0.5468 | 1863120.0 |
| 2004-08-20 11:20:00 | AAPL | Stock | 0.5468 | 0.5468 | 0.5464 | 0.5468 | 880320.0 |
| 2004-08-20 11:25:00 | AAPL | Stock | 0.5468 | 0.547 | 0.5468 | 0.547 | 546000.0 |
| 2004-08-20 11:30:00 | AAPL | Stock | 0.547 | 0.547 | 0.5459 | 0.5461 | 2095968.0 |
| 2004-08-20 11:35:00 | AAPL | Stock | 0.5459 | 0.547 | 0.5459 | 0.547 | 1006880.0 |
| 2004-08-20 11:40:00 | AAPL | Stock | 0.547 | 0.5471 | 0.5468 | 0.547 | 4630248.0 |
| 2004-08-20 11:45:00 | AAPL | Stock | 0.5471 | 0.5471 | 0.5464 | 0.5464 | 1953112.0 |
| 2004-08-20 11:50:00 | AAPL | Stock | 0.5463 | 0.5471 | 0.5463 | 0.5468 | 851704.0 |
| 2004-08-20 11:55:00 | AAPL | Stock | 0.5468 | 0.5468 | 0.5459 | 0.5464 | 2832368.0 |
| 2004-08-20 12:00:00 | AAPL | Stock | 0.5463 | 0.5466 | 0.5457 | 0.5463 | 1561784.0 |
| 2004-08-20 12:05:00 | AAPL | Stock | 0.5461 | 0.5468 | 0.5459 | 0.5464 | 3876096.0 |
| 2004-08-20 12:10:00 | AAPL | Stock | 0.5459 | 0.5464 | 0.5459 | 0.5464 | 2971024.0 |
| 2004-08-20 12:15:00 | AAPL | Stock | 0.5463 | 0.5464 | 0.5452 | 0.5461 | 5673136.0 |
| 2004-08-20 12:20:00 | AAPL | Stock | 0.5461 | 0.5463 | 0.5452 | 0.5461 | 1580320.0 |
| 2004-08-20 12:25:00 | AAPL | Stock | 0.5459 | 0.547 | 0.5457 | 0.5461 | 1091496.0 |
| 2004-08-20 12:30:00 | AAPL | Stock | 0.5461 | 0.5464 | 0.5455 | 0.5459 | 1089648.0 |
| 2004-08-20 12:35:00 | AAPL | Stock | 0.5457 | 0.5461 | 0.5452 | 0.5457 | 1137080.0 |
| 2004-08-20 12:40:00 | AAPL | Stock | 0.5457 | 0.5457 | 0.5455 | 0.5457 | 751800.0 |
| 2004-08-20 12:45:00 | AAPL | Stock | 0.5457 | 0.5463 | 0.5455 | 0.5459 | 773360.0 |
| 2004-08-20 12:50:00 | AAPL | Stock | 0.5463 | 0.5475 | 0.5459 | 0.5473 | 2317728.0 |
| 2004-08-20 12:55:00 | AAPL | Stock | 0.5473 | 0.5491 | 0.5473 | 0.5489 | 2860424.0 |
| 2004-08-20 13:00:00 | AAPL | Stock | 0.5489 | 0.5491 | 0.5486 | 0.5486 | 1794016.0 |
| 2004-08-20 13:05:00 | AAPL | Stock | 0.5486 | 0.5493 | 0.5486 | 0.5493 | 2901080.0 |
| 2004-08-20 13:10:00 | AAPL | Stock | 0.5489 | 0.5509 | 0.5489 | 0.5504 | 3360112.0 |
| 2004-08-20 13:15:00 | AAPL | Stock | 0.5502 | 0.5507 | 0.5498 | 0.55 | 2591512.0 |
> showing 50 of 172,145 rows — these rows as CSV