PREVIEW / stock_5min / 2000-04-13
file: by_date/stock_5min/2000/2000-04-13.parquet size: 1.2 MB rows: 86,495 symbols: 1,165
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 |
|---|---|---|---|---|---|---|---|
| 2000-04-13 09:30:00 | AAPL | Stock | 0.9955 | 0.9978 | 0.9821 | 0.9821 | 14795200.0 |
| 2000-04-13 09:35:00 | AAPL | Stock | 0.9821 | 0.9961 | 0.9754 | 0.9855 | 17651200.0 |
| 2000-04-13 09:40:00 | AAPL | Stock | 0.9799 | 0.9872 | 0.971 | 0.9735 | 16520000.0 |
| 2000-04-13 09:45:00 | AAPL | Stock | 0.9721 | 0.981 | 0.9688 | 0.9799 | 12219200.0 |
| 2000-04-13 09:50:00 | AAPL | Stock | 0.9777 | 1.0078 | 0.9777 | 1.0073 | 9004800.0 |
| 2000-04-13 09:55:00 | AAPL | Stock | 1.0067 | 1.0458 | 1.0064 | 1.0446 | 8982400.0 |
| 2000-04-13 10:00:00 | AAPL | Stock | 1.0446 | 1.0491 | 1.0346 | 1.0469 | 14257600.0 |
| 2000-04-13 10:05:00 | AAPL | Stock | 1.0424 | 1.0513 | 1.0391 | 1.048 | 7179200.0 |
| 2000-04-13 10:10:00 | AAPL | Stock | 1.0497 | 1.0625 | 1.0441 | 1.053 | 7974400.0 |
| 2000-04-13 10:15:00 | AAPL | Stock | 1.0533 | 1.058 | 1.0513 | 1.0513 | 7974400.0 |
| 2000-04-13 10:20:00 | AAPL | Stock | 1.0536 | 1.0558 | 1.0446 | 1.0558 | 7840000.0 |
| 2000-04-13 10:25:00 | AAPL | Stock | 1.0558 | 1.0558 | 1.0357 | 1.0357 | 10169600.0 |
| 2000-04-13 10:30:00 | AAPL | Stock | 1.0357 | 1.0502 | 1.029 | 1.029 | 8960000.0 |
| 2000-04-13 10:35:00 | AAPL | Stock | 1.029 | 1.0491 | 1.0268 | 1.0446 | 11827200.0 |
| 2000-04-13 10:40:00 | AAPL | Stock | 1.0446 | 1.0469 | 1.0357 | 1.0357 | 7078400.0 |
| 2000-04-13 10:45:00 | AAPL | Stock | 1.0374 | 1.0374 | 1.0246 | 1.0246 | 9889600.0 |
| 2000-04-13 10:50:00 | AAPL | Stock | 1.0234 | 1.0273 | 1.0145 | 1.0162 | 15848000.0 |
| 2000-04-13 10:55:00 | AAPL | Stock | 1.0156 | 1.0391 | 1.0153 | 1.034 | 7448000.0 |
| 2000-04-13 11:00:00 | AAPL | Stock | 1.0313 | 1.0469 | 1.0307 | 1.0424 | 6283200.0 |
| 2000-04-13 11:05:00 | AAPL | Stock | 1.0446 | 1.0446 | 1.0379 | 1.0405 | 3920000.0 |
| 2000-04-13 11:10:00 | AAPL | Stock | 1.0402 | 1.0441 | 1.0368 | 1.0391 | 1747200.0 |
| 2000-04-13 11:15:00 | AAPL | Stock | 1.0413 | 1.0446 | 1.0374 | 1.0424 | 2150400.0 |
| 2000-04-13 11:20:00 | AAPL | Stock | 1.0424 | 1.0513 | 1.0424 | 1.048 | 8534400.0 |
| 2000-04-13 11:25:00 | AAPL | Stock | 1.0474 | 1.0536 | 1.0446 | 1.0513 | 3752000.0 |
| 2000-04-13 11:30:00 | AAPL | Stock | 1.0508 | 1.0592 | 1.0485 | 1.0592 | 5779200.0 |
| 2000-04-13 11:35:00 | AAPL | Stock | 1.0592 | 1.0608 | 1.0485 | 1.0569 | 4401600.0 |
| 2000-04-13 11:40:00 | AAPL | Stock | 1.0552 | 1.0614 | 1.0536 | 1.0547 | 3102400.0 |
| 2000-04-13 11:45:00 | AAPL | Stock | 1.0541 | 1.0619 | 1.0536 | 1.0619 | 3180800.0 |
| 2000-04-13 11:50:00 | AAPL | Stock | 1.0597 | 1.0692 | 1.058 | 1.0653 | 5208000.0 |
| 2000-04-13 11:55:00 | AAPL | Stock | 1.0636 | 1.0658 | 1.0603 | 1.0614 | 8086400.0 |
| 2000-04-13 12:00:00 | AAPL | Stock | 1.0614 | 1.0614 | 1.0547 | 1.0575 | 10024000.0 |
| 2000-04-13 12:05:00 | AAPL | Stock | 1.058 | 1.0603 | 1.0502 | 1.0502 | 7716800.0 |
| 2000-04-13 12:10:00 | AAPL | Stock | 1.0513 | 1.0513 | 1.0419 | 1.0446 | 7201600.0 |
| 2000-04-13 12:15:00 | AAPL | Stock | 1.0446 | 1.0474 | 1.0424 | 1.0469 | 8243200.0 |
| 2000-04-13 12:20:00 | AAPL | Stock | 1.0474 | 1.0536 | 1.0469 | 1.0536 | 3483200.0 |
| 2000-04-13 12:25:00 | AAPL | Stock | 1.0536 | 1.0558 | 1.0491 | 1.0547 | 4782400.0 |
| 2000-04-13 12:30:00 | AAPL | Stock | 1.0539 | 1.0636 | 1.053 | 1.0631 | 3841600.0 |
| 2000-04-13 12:35:00 | AAPL | Stock | 1.0631 | 1.0681 | 1.0614 | 1.0617 | 4625600.0 |
| 2000-04-13 12:40:00 | AAPL | Stock | 1.0614 | 1.0647 | 1.0592 | 1.0592 | 1736000.0 |
| 2000-04-13 12:45:00 | AAPL | Stock | 1.0608 | 1.0608 | 1.0569 | 1.0586 | 7851200.0 |
| 2000-04-13 12:50:00 | AAPL | Stock | 1.0586 | 1.0608 | 1.0536 | 1.0536 | 8299200.0 |
| 2000-04-13 12:55:00 | AAPL | Stock | 1.0536 | 1.0541 | 1.0525 | 1.0536 | 3416000.0 |
| 2000-04-13 13:00:00 | AAPL | Stock | 1.0525 | 1.0536 | 1.0491 | 1.0513 | 3091200.0 |
| 2000-04-13 13:05:00 | AAPL | Stock | 1.0513 | 1.0558 | 1.0502 | 1.0555 | 1041600.0 |
| 2000-04-13 13:10:00 | AAPL | Stock | 1.0558 | 1.067 | 1.0519 | 1.0658 | 2576000.0 |
| 2000-04-13 13:15:00 | AAPL | Stock | 1.0658 | 1.0714 | 1.0653 | 1.067 | 2945600.0 |
| 2000-04-13 13:20:00 | AAPL | Stock | 1.067 | 1.067 | 1.0636 | 1.0642 | 1064000.0 |
| 2000-04-13 13:25:00 | AAPL | Stock | 1.0636 | 1.0653 | 1.0491 | 1.0541 | 2004800.0 |
| 2000-04-13 13:30:00 | AAPL | Stock | 1.0519 | 1.0569 | 1.0513 | 1.055 | 1736000.0 |
| 2000-04-13 13:35:00 | AAPL | Stock | 1.0541 | 1.0597 | 1.0541 | 1.058 | 1601600.0 |
> showing 50 of 86,495 rows — these rows as CSV