PREVIEW / stock_5min / 2004-07-23
file: by_date/stock_5min/2004/2004-07-23.parquet size: 2.4 MB rows: 174,311 symbols: 1,789
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-07-23 08:50:00 | AAPL | Stock | 0.5634 | 0.5634 | 0.5634 | 0.5634 | 33600.0 |
| 2004-07-23 09:25:00 | AAPL | Stock | 0.5639 | 0.5654 | 0.563 | 0.5643 | 410368.0 |
| 2004-07-23 09:30:00 | AAPL | Stock | 0.5661 | 0.567 | 0.5618 | 0.5636 | 7621040.0 |
| 2004-07-23 09:35:00 | AAPL | Stock | 0.5636 | 0.5636 | 0.5605 | 0.5619 | 2315768.0 |
| 2004-07-23 09:40:00 | AAPL | Stock | 0.5613 | 0.5613 | 0.5598 | 0.5598 | 1814960.0 |
| 2004-07-23 09:45:00 | AAPL | Stock | 0.5598 | 0.5607 | 0.5596 | 0.5596 | 1596224.0 |
| 2004-07-23 09:50:00 | AAPL | Stock | 0.5598 | 0.5598 | 0.5575 | 0.5582 | 2625616.0 |
| 2004-07-23 09:55:00 | AAPL | Stock | 0.558 | 0.5591 | 0.5559 | 0.5566 | 2869216.0 |
| 2004-07-23 10:00:00 | AAPL | Stock | 0.5564 | 0.5571 | 0.5543 | 0.5543 | 4456984.0 |
| 2004-07-23 10:05:00 | AAPL | Stock | 0.5541 | 0.5555 | 0.5527 | 0.5527 | 8874712.0 |
| 2004-07-23 10:10:00 | AAPL | Stock | 0.5527 | 0.5561 | 0.5521 | 0.5559 | 5595520.0 |
| 2004-07-23 10:15:00 | AAPL | Stock | 0.5559 | 0.56 | 0.5555 | 0.5575 | 5281136.0 |
| 2004-07-23 10:20:00 | AAPL | Stock | 0.5575 | 0.5584 | 0.5557 | 0.5563 | 1910832.0 |
| 2004-07-23 10:25:00 | AAPL | Stock | 0.5561 | 0.557 | 0.555 | 0.5554 | 3832136.0 |
| 2004-07-23 10:30:00 | AAPL | Stock | 0.5554 | 0.5596 | 0.5548 | 0.5588 | 5911472.0 |
| 2004-07-23 10:35:00 | AAPL | Stock | 0.5588 | 0.5609 | 0.5588 | 0.5602 | 6369944.0 |
| 2004-07-23 10:40:00 | AAPL | Stock | 0.5602 | 0.562 | 0.5602 | 0.5618 | 6032152.0 |
| 2004-07-23 10:45:00 | AAPL | Stock | 0.5614 | 0.5625 | 0.5598 | 0.56 | 2942856.0 |
| 2004-07-23 10:50:00 | AAPL | Stock | 0.56 | 0.5616 | 0.5598 | 0.5605 | 1453312.0 |
| 2004-07-23 10:55:00 | AAPL | Stock | 0.5602 | 0.5618 | 0.5602 | 0.5616 | 590744.0 |
| 2004-07-23 11:00:00 | AAPL | Stock | 0.5616 | 0.562 | 0.5613 | 0.562 | 1865416.0 |
| 2004-07-23 11:05:00 | AAPL | Stock | 0.5621 | 0.5621 | 0.5602 | 0.5611 | 2791712.0 |
| 2004-07-23 11:10:00 | AAPL | Stock | 0.5607 | 0.5609 | 0.5596 | 0.56 | 1436904.0 |
| 2004-07-23 11:15:00 | AAPL | Stock | 0.5598 | 0.5602 | 0.5589 | 0.5593 | 2076032.0 |
| 2004-07-23 11:20:00 | AAPL | Stock | 0.5593 | 0.56 | 0.5589 | 0.56 | 1223488.0 |
| 2004-07-23 11:25:00 | AAPL | Stock | 0.5598 | 0.5604 | 0.5589 | 0.5589 | 1652840.0 |
| 2004-07-23 11:30:00 | AAPL | Stock | 0.5589 | 0.5591 | 0.558 | 0.5586 | 839776.0 |
| 2004-07-23 11:35:00 | AAPL | Stock | 0.5588 | 0.5588 | 0.5566 | 0.5566 | 2389184.0 |
| 2004-07-23 11:40:00 | AAPL | Stock | 0.5566 | 0.5566 | 0.5518 | 0.5523 | 10965304.0 |
| 2004-07-23 11:45:00 | AAPL | Stock | 0.5523 | 0.5536 | 0.552 | 0.553 | 5375496.0 |
| 2004-07-23 11:50:00 | AAPL | Stock | 0.553 | 0.5554 | 0.5527 | 0.5548 | 2726920.0 |
| 2004-07-23 11:55:00 | AAPL | Stock | 0.555 | 0.5559 | 0.5548 | 0.5559 | 386400.0 |
| 2004-07-23 12:00:00 | AAPL | Stock | 0.5557 | 0.5557 | 0.553 | 0.5536 | 1487640.0 |
| 2004-07-23 12:05:00 | AAPL | Stock | 0.5536 | 0.5536 | 0.552 | 0.5523 | 4215904.0 |
| 2004-07-23 12:10:00 | AAPL | Stock | 0.5523 | 0.5536 | 0.5518 | 0.5525 | 3437560.0 |
| 2004-07-23 12:15:00 | AAPL | Stock | 0.5527 | 0.5527 | 0.5518 | 0.5521 | 2355248.0 |
| 2004-07-23 12:20:00 | AAPL | Stock | 0.5518 | 0.5525 | 0.5518 | 0.5518 | 1013208.0 |
| 2004-07-23 12:25:00 | AAPL | Stock | 0.5518 | 0.5527 | 0.5518 | 0.5523 | 3065664.0 |
| 2004-07-23 12:30:00 | AAPL | Stock | 0.552 | 0.5523 | 0.5509 | 0.552 | 2080008.0 |
| 2004-07-23 12:35:00 | AAPL | Stock | 0.552 | 0.553 | 0.552 | 0.553 | 563752.0 |
| 2004-07-23 12:40:00 | AAPL | Stock | 0.5529 | 0.553 | 0.5516 | 0.5518 | 613928.0 |
| 2004-07-23 12:45:00 | AAPL | Stock | 0.5518 | 0.5536 | 0.5518 | 0.5532 | 1184456.0 |
| 2004-07-23 12:50:00 | AAPL | Stock | 0.5532 | 0.5545 | 0.553 | 0.5538 | 2224768.0 |
| 2004-07-23 12:55:00 | AAPL | Stock | 0.5534 | 0.5559 | 0.5534 | 0.5546 | 2023448.0 |
| 2004-07-23 13:00:00 | AAPL | Stock | 0.5543 | 0.5563 | 0.5541 | 0.5559 | 1098440.0 |
| 2004-07-23 13:05:00 | AAPL | Stock | 0.5559 | 0.5571 | 0.5559 | 0.557 | 943320.0 |
| 2004-07-23 13:10:00 | AAPL | Stock | 0.557 | 0.557 | 0.5561 | 0.5568 | 953848.0 |
| 2004-07-23 13:15:00 | AAPL | Stock | 0.5564 | 0.558 | 0.5564 | 0.5575 | 1837472.0 |
| 2004-07-23 13:20:00 | AAPL | Stock | 0.5573 | 0.5573 | 0.5559 | 0.5564 | 584136.0 |
| 2004-07-23 13:25:00 | AAPL | Stock | 0.5559 | 0.5561 | 0.5536 | 0.5536 | 1392272.0 |
> showing 50 of 174,311 rows — these rows as CSV