PREVIEW / stock_5min / 2007-07-30
file: by_date/stock_5min/2007/2007-07-30.parquet size: 4.3 MB rows: 306,716 symbols: 3,110
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 |
|---|---|---|---|---|---|---|---|
| 2007-07-30 09:30:00 | AAPL | Stock | 5.1546 | 5.1946 | 5.1521 | 5.1825 | 40144664.0 |
| 2007-07-30 09:35:00 | AAPL | Stock | 5.1807 | 5.1839 | 5.1504 | 5.1607 | 21233268.0 |
| 2007-07-30 09:40:00 | AAPL | Stock | 5.1596 | 5.1693 | 5.1332 | 5.1615 | 23099888.0 |
| 2007-07-30 09:45:00 | AAPL | Stock | 5.1625 | 5.1879 | 5.1625 | 5.185 | 24410596.0 |
| 2007-07-30 09:50:00 | AAPL | Stock | 5.1836 | 5.1872 | 5.1625 | 5.1739 | 15630804.0 |
| 2007-07-30 09:55:00 | AAPL | Stock | 5.1739 | 5.1875 | 5.1661 | 5.1671 | 12974136.0 |
| 2007-07-30 10:00:00 | AAPL | Stock | 5.1671 | 5.1746 | 5.1429 | 5.1496 | 15710660.0 |
| 2007-07-30 10:05:00 | AAPL | Stock | 5.1486 | 5.1507 | 5.1286 | 5.1414 | 23955960.0 |
| 2007-07-30 10:10:00 | AAPL | Stock | 5.1414 | 5.1432 | 5.1075 | 5.1207 | 26760412.0 |
| 2007-07-30 10:15:00 | AAPL | Stock | 5.1196 | 5.1518 | 5.1154 | 5.1457 | 16384872.0 |
| 2007-07-30 10:20:00 | AAPL | Stock | 5.1457 | 5.1582 | 5.1439 | 5.1464 | 16919840.0 |
| 2007-07-30 10:25:00 | AAPL | Stock | 5.1464 | 5.1464 | 5.0961 | 5.0961 | 25826192.0 |
| 2007-07-30 10:30:00 | AAPL | Stock | 5.0975 | 5.1 | 5.0761 | 5.0893 | 28046480.0 |
| 2007-07-30 10:35:00 | AAPL | Stock | 5.0893 | 5.0943 | 5.01 | 5.0364 | 50229508.0 |
| 2007-07-30 10:40:00 | AAPL | Stock | 5.0336 | 5.0357 | 4.9846 | 5.0086 | 54706092.0 |
| 2007-07-30 10:45:00 | AAPL | Stock | 5.0093 | 5.0529 | 5.0075 | 5.0529 | 27173692.0 |
| 2007-07-30 10:50:00 | AAPL | Stock | 5.0518 | 5.0643 | 5.0432 | 5.0521 | 21078064.0 |
| 2007-07-30 10:55:00 | AAPL | Stock | 5.0525 | 5.0614 | 5.0421 | 5.0425 | 13442464.0 |
| 2007-07-30 11:00:00 | AAPL | Stock | 5.0429 | 5.0593 | 5.0389 | 5.0429 | 10441452.0 |
| 2007-07-30 11:05:00 | AAPL | Stock | 5.0425 | 5.0446 | 5.0143 | 5.0318 | 20925016.0 |
| 2007-07-30 11:10:00 | AAPL | Stock | 5.0329 | 5.0346 | 5.0079 | 5.0279 | 13317640.0 |
| 2007-07-30 11:15:00 | AAPL | Stock | 5.0275 | 5.0714 | 5.0049 | 5.0132 | 12684952.0 |
| 2007-07-30 11:20:00 | AAPL | Stock | 5.0136 | 5.0286 | 5.0036 | 5.0082 | 16054864.0 |
| 2007-07-30 11:25:00 | AAPL | Stock | 5.0079 | 5.0243 | 4.9968 | 5.0243 | 16521624.0 |
| 2007-07-30 11:30:00 | AAPL | Stock | 5.0236 | 5.025 | 5.0061 | 5.0082 | 9979116.0 |
| 2007-07-30 11:35:00 | AAPL | Stock | 5.0079 | 5.0229 | 5.0064 | 5.0089 | 8624980.0 |
| 2007-07-30 11:40:00 | AAPL | Stock | 5.0089 | 5.0129 | 4.9921 | 5.0018 | 15692600.0 |
| 2007-07-30 11:45:00 | AAPL | Stock | 5.0018 | 5.0225 | 4.9966 | 5.0207 | 12939668.0 |
| 2007-07-30 11:50:00 | AAPL | Stock | 5.0189 | 5.0321 | 5.0111 | 5.0318 | 11776128.0 |
| 2007-07-30 11:55:00 | AAPL | Stock | 5.0318 | 5.0386 | 5.0232 | 5.0307 | 10196564.0 |
| 2007-07-30 12:00:00 | AAPL | Stock | 5.0307 | 5.0329 | 5.015 | 5.0218 | 8241184.0 |
| 2007-07-30 12:05:00 | AAPL | Stock | 5.0225 | 5.0314 | 5.0 | 5.0296 | 5448856.0 |
| 2007-07-30 12:10:00 | AAPL | Stock | 5.0296 | 5.0429 | 5.0289 | 5.0379 | 12262012.0 |
| 2007-07-30 12:15:00 | AAPL | Stock | 5.0386 | 5.0414 | 5.0286 | 5.0334 | 8062348.0 |
| 2007-07-30 12:20:00 | AAPL | Stock | 5.0332 | 5.0336 | 5.02 | 5.0293 | 7610260.0 |
| 2007-07-30 12:25:00 | AAPL | Stock | 5.0293 | 5.0396 | 5.0261 | 5.0361 | 4798360.0 |
| 2007-07-30 12:30:00 | AAPL | Stock | 5.0371 | 5.0532 | 5.0371 | 5.0518 | 9545760.0 |
| 2007-07-30 12:35:00 | AAPL | Stock | 5.0518 | 5.0625 | 5.0518 | 5.0596 | 10693900.0 |
| 2007-07-30 12:40:00 | AAPL | Stock | 5.0596 | 5.0686 | 5.0482 | 5.0493 | 12374236.0 |
| 2007-07-30 12:45:00 | AAPL | Stock | 5.0493 | 5.0625 | 5.0475 | 5.0609 | 6901636.0 |
| 2007-07-30 12:50:00 | AAPL | Stock | 5.0614 | 5.0804 | 5.0571 | 5.0796 | 15650908.0 |
| 2007-07-30 12:55:00 | AAPL | Stock | 5.08 | 5.0893 | 5.0786 | 5.0857 | 15975036.0 |
| 2007-07-30 13:00:00 | AAPL | Stock | 5.0854 | 5.0939 | 5.0818 | 5.0854 | 9093028.0 |
| 2007-07-30 13:05:00 | AAPL | Stock | 5.085 | 5.1 | 5.0804 | 5.0968 | 11644024.0 |
| 2007-07-30 13:10:00 | AAPL | Stock | 5.0968 | 5.0979 | 5.0593 | 5.0639 | 12419204.0 |
| 2007-07-30 13:15:00 | AAPL | Stock | 5.0648 | 5.0754 | 5.062 | 5.0729 | 7543368.0 |
| 2007-07-30 13:20:00 | AAPL | Stock | 5.0725 | 5.0814 | 5.0657 | 5.0696 | 6631268.0 |
| 2007-07-30 13:25:00 | AAPL | Stock | 5.0696 | 5.0704 | 5.0564 | 5.0621 | 7609952.0 |
| 2007-07-30 13:30:00 | AAPL | Stock | 5.0625 | 5.0639 | 5.0404 | 5.0439 | 10839052.0 |
| 2007-07-30 13:35:00 | AAPL | Stock | 5.0432 | 5.0511 | 5.0418 | 5.045 | 7750148.0 |
> showing 50 of 306,716 rows — these rows as CSV