PREVIEW / stock_5min / 2004-08-23
file: by_date/stock_5min/2004/2004-08-23.parquet size: 2.3 MB rows: 173,916 symbols: 1,823
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-23 09:25:00 | AAPL | Stock | 0.5509 | 0.5518 | 0.5505 | 0.5518 | 266560.0 |
| 2004-08-23 09:30:00 | AAPL | Stock | 0.5511 | 0.5518 | 0.5464 | 0.5491 | 8667624.0 |
| 2004-08-23 09:35:00 | AAPL | Stock | 0.5493 | 0.5498 | 0.548 | 0.5493 | 4151952.0 |
| 2004-08-23 09:40:00 | AAPL | Stock | 0.5493 | 0.5504 | 0.5488 | 0.5495 | 3099208.0 |
| 2004-08-23 09:45:00 | AAPL | Stock | 0.5495 | 0.5504 | 0.5491 | 0.5498 | 3968216.0 |
| 2004-08-23 09:50:00 | AAPL | Stock | 0.55 | 0.55 | 0.5482 | 0.5491 | 2981944.0 |
| 2004-08-23 09:55:00 | AAPL | Stock | 0.5491 | 0.55 | 0.5482 | 0.5496 | 2885344.0 |
| 2004-08-23 10:00:00 | AAPL | Stock | 0.5493 | 0.5504 | 0.5488 | 0.5498 | 3589768.0 |
| 2004-08-23 10:05:00 | AAPL | Stock | 0.5498 | 0.5502 | 0.5491 | 0.5496 | 1887704.0 |
| 2004-08-23 10:10:00 | AAPL | Stock | 0.5496 | 0.5504 | 0.5491 | 0.5504 | 2111536.0 |
| 2004-08-23 10:15:00 | AAPL | Stock | 0.5504 | 0.5513 | 0.5491 | 0.5513 | 3244304.0 |
| 2004-08-23 10:20:00 | AAPL | Stock | 0.5513 | 0.5539 | 0.5513 | 0.5536 | 4328016.0 |
| 2004-08-23 10:25:00 | AAPL | Stock | 0.5536 | 0.5563 | 0.553 | 0.5563 | 4263504.0 |
| 2004-08-23 10:30:00 | AAPL | Stock | 0.5563 | 0.558 | 0.5561 | 0.5575 | 6676992.0 |
| 2004-08-23 10:35:00 | AAPL | Stock | 0.5571 | 0.5575 | 0.5564 | 0.5571 | 1963360.0 |
| 2004-08-23 10:40:00 | AAPL | Stock | 0.5571 | 0.5584 | 0.5571 | 0.558 | 4390680.0 |
| 2004-08-23 10:45:00 | AAPL | Stock | 0.558 | 0.558 | 0.5563 | 0.5563 | 2568832.0 |
| 2004-08-23 10:50:00 | AAPL | Stock | 0.5564 | 0.5573 | 0.5563 | 0.5564 | 2644824.0 |
| 2004-08-23 10:55:00 | AAPL | Stock | 0.5566 | 0.557 | 0.5554 | 0.5561 | 3256680.0 |
| 2004-08-23 11:00:00 | AAPL | Stock | 0.5559 | 0.5564 | 0.5539 | 0.555 | 6250160.0 |
| 2004-08-23 11:05:00 | AAPL | Stock | 0.5546 | 0.5546 | 0.5534 | 0.5534 | 1887536.0 |
| 2004-08-23 11:10:00 | AAPL | Stock | 0.5534 | 0.5539 | 0.5527 | 0.5532 | 2572248.0 |
| 2004-08-23 11:15:00 | AAPL | Stock | 0.5532 | 0.5539 | 0.552 | 0.5536 | 1991304.0 |
| 2004-08-23 11:20:00 | AAPL | Stock | 0.5538 | 0.5548 | 0.5538 | 0.5541 | 3368176.0 |
| 2004-08-23 11:25:00 | AAPL | Stock | 0.5541 | 0.5543 | 0.5523 | 0.5527 | 4994472.0 |
| 2004-08-23 11:30:00 | AAPL | Stock | 0.5529 | 0.5536 | 0.5527 | 0.553 | 1831816.0 |
| 2004-08-23 11:35:00 | AAPL | Stock | 0.553 | 0.5538 | 0.5529 | 0.5529 | 2649976.0 |
| 2004-08-23 11:40:00 | AAPL | Stock | 0.553 | 0.5538 | 0.5521 | 0.5521 | 3055696.0 |
| 2004-08-23 11:45:00 | AAPL | Stock | 0.5525 | 0.5532 | 0.5521 | 0.553 | 2118200.0 |
| 2004-08-23 11:50:00 | AAPL | Stock | 0.553 | 0.553 | 0.5521 | 0.5525 | 1479296.0 |
| 2004-08-23 11:55:00 | AAPL | Stock | 0.5529 | 0.553 | 0.552 | 0.5521 | 1595272.0 |
| 2004-08-23 12:00:00 | AAPL | Stock | 0.5521 | 0.5536 | 0.5516 | 0.553 | 3734696.0 |
| 2004-08-23 12:05:00 | AAPL | Stock | 0.553 | 0.553 | 0.5527 | 0.5529 | 910000.0 |
| 2004-08-23 12:10:00 | AAPL | Stock | 0.5525 | 0.5527 | 0.5518 | 0.5518 | 1223600.0 |
| 2004-08-23 12:15:00 | AAPL | Stock | 0.5516 | 0.5518 | 0.5507 | 0.5507 | 1268512.0 |
| 2004-08-23 12:20:00 | AAPL | Stock | 0.5505 | 0.5516 | 0.5505 | 0.5514 | 956816.0 |
| 2004-08-23 12:25:00 | AAPL | Stock | 0.5514 | 0.5516 | 0.5504 | 0.5505 | 2772336.0 |
| 2004-08-23 12:30:00 | AAPL | Stock | 0.5505 | 0.5518 | 0.5491 | 0.5496 | 3661616.0 |
| 2004-08-23 12:35:00 | AAPL | Stock | 0.5495 | 0.5507 | 0.5495 | 0.5504 | 1521520.0 |
| 2004-08-23 12:40:00 | AAPL | Stock | 0.5502 | 0.5511 | 0.5502 | 0.5507 | 3215856.0 |
| 2004-08-23 12:45:00 | AAPL | Stock | 0.55 | 0.5513 | 0.55 | 0.5509 | 1743840.0 |
| 2004-08-23 12:50:00 | AAPL | Stock | 0.5507 | 0.5511 | 0.5504 | 0.5505 | 1218560.0 |
| 2004-08-23 12:55:00 | AAPL | Stock | 0.5505 | 0.5514 | 0.5505 | 0.5509 | 1925672.0 |
| 2004-08-23 13:00:00 | AAPL | Stock | 0.5509 | 0.5511 | 0.5509 | 0.5511 | 349552.0 |
| 2004-08-23 13:05:00 | AAPL | Stock | 0.5511 | 0.5513 | 0.5509 | 0.5511 | 612136.0 |
| 2004-08-23 13:10:00 | AAPL | Stock | 0.5511 | 0.5514 | 0.5509 | 0.5513 | 6385400.0 |
| 2004-08-23 13:15:00 | AAPL | Stock | 0.5513 | 0.5516 | 0.5505 | 0.5513 | 2984016.0 |
| 2004-08-23 13:20:00 | AAPL | Stock | 0.5513 | 0.553 | 0.5513 | 0.5527 | 2821448.0 |
| 2004-08-23 13:25:00 | AAPL | Stock | 0.5525 | 0.5532 | 0.5523 | 0.5527 | 3279136.0 |
| 2004-08-23 13:30:00 | AAPL | Stock | 0.5527 | 0.5539 | 0.5527 | 0.5536 | 2223592.0 |
> showing 50 of 173,916 rows — these rows as CSV