PREVIEW / stock_5min / 2000-04-04
file: by_date/stock_5min/2000/2000-04-04.parquet size: 1.4 MB rows: 99,975 symbols: 1,150
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-04 09:30:00 | AAPL | Stock | 1.1842 | 1.1875 | 1.1786 | 1.1789 | 3035200.0 |
| 2000-04-04 09:35:00 | AAPL | Stock | 1.1789 | 1.1791 | 1.1607 | 1.1607 | 5779200.0 |
| 2000-04-04 09:40:00 | AAPL | Stock | 1.161 | 1.1613 | 1.1496 | 1.1496 | 5812800.0 |
| 2000-04-04 09:45:00 | AAPL | Stock | 1.1496 | 1.1501 | 1.1362 | 1.1367 | 5734400.0 |
| 2000-04-04 09:50:00 | AAPL | Stock | 1.1367 | 1.1557 | 1.135 | 1.1429 | 8456000.0 |
| 2000-04-04 09:55:00 | AAPL | Stock | 1.1431 | 1.1512 | 1.1317 | 1.1348 | 10080000.0 |
| 2000-04-04 10:00:00 | AAPL | Stock | 1.1373 | 1.1417 | 1.1345 | 1.1395 | 10192000.0 |
| 2000-04-04 10:05:00 | AAPL | Stock | 1.139 | 1.1574 | 1.135 | 1.1473 | 13507200.0 |
| 2000-04-04 10:10:00 | AAPL | Stock | 1.1462 | 1.1574 | 1.1417 | 1.144 | 7694400.0 |
| 2000-04-04 10:15:00 | AAPL | Stock | 1.144 | 1.1456 | 1.1362 | 1.1423 | 7392000.0 |
| 2000-04-04 10:20:00 | AAPL | Stock | 1.1429 | 1.144 | 1.1339 | 1.135 | 4603200.0 |
| 2000-04-04 10:25:00 | AAPL | Stock | 1.135 | 1.1373 | 1.1306 | 1.1317 | 6619200.0 |
| 2000-04-04 10:30:00 | AAPL | Stock | 1.1317 | 1.1317 | 1.1172 | 1.1183 | 8120000.0 |
| 2000-04-04 10:35:00 | AAPL | Stock | 1.1172 | 1.135 | 1.1166 | 1.1272 | 4580800.0 |
| 2000-04-04 10:40:00 | AAPL | Stock | 1.125 | 1.1339 | 1.1228 | 1.1228 | 2385600.0 |
| 2000-04-04 10:45:00 | AAPL | Stock | 1.125 | 1.1339 | 1.1233 | 1.125 | 3707200.0 |
| 2000-04-04 10:50:00 | AAPL | Stock | 1.1239 | 1.1283 | 1.1194 | 1.1272 | 6193600.0 |
| 2000-04-04 10:55:00 | AAPL | Stock | 1.1272 | 1.1334 | 1.1228 | 1.1311 | 5476800.0 |
| 2000-04-04 11:00:00 | AAPL | Stock | 1.1311 | 1.1451 | 1.125 | 1.1445 | 5353600.0 |
| 2000-04-04 11:05:00 | AAPL | Stock | 1.1468 | 1.1535 | 1.1417 | 1.144 | 4188800.0 |
| 2000-04-04 11:10:00 | AAPL | Stock | 1.1429 | 1.1462 | 1.1417 | 1.144 | 2979200.0 |
| 2000-04-04 11:15:00 | AAPL | Stock | 1.144 | 1.1518 | 1.1423 | 1.1423 | 3707200.0 |
| 2000-04-04 11:20:00 | AAPL | Stock | 1.1429 | 1.1429 | 1.1283 | 1.1328 | 6854400.0 |
| 2000-04-04 11:25:00 | AAPL | Stock | 1.1339 | 1.1339 | 1.1295 | 1.1317 | 6036800.0 |
| 2000-04-04 11:30:00 | AAPL | Stock | 1.1317 | 1.1317 | 1.1172 | 1.1172 | 5051200.0 |
| 2000-04-04 11:35:00 | AAPL | Stock | 1.1172 | 1.1183 | 1.1161 | 1.1161 | 10841600.0 |
| 2000-04-04 11:40:00 | AAPL | Stock | 1.1161 | 1.1166 | 1.1099 | 1.115 | 2912000.0 |
| 2000-04-04 11:45:00 | AAPL | Stock | 1.1144 | 1.1161 | 1.0893 | 1.0896 | 10763200.0 |
| 2000-04-04 11:50:00 | AAPL | Stock | 1.0893 | 1.0938 | 1.0798 | 1.0798 | 9811200.0 |
| 2000-04-04 11:55:00 | AAPL | Stock | 1.0798 | 1.082 | 1.0714 | 1.0717 | 9206400.0 |
| 2000-04-04 12:00:00 | AAPL | Stock | 1.072 | 1.0893 | 1.0714 | 1.0887 | 15052800.0 |
| 2000-04-04 12:05:00 | AAPL | Stock | 1.0887 | 1.1004 | 1.0871 | 1.0949 | 20832000.0 |
| 2000-04-04 12:10:00 | AAPL | Stock | 1.0932 | 1.0982 | 1.0737 | 1.0748 | 11849600.0 |
| 2000-04-04 12:15:00 | AAPL | Stock | 1.0759 | 1.0915 | 1.0731 | 1.0765 | 6171200.0 |
| 2000-04-04 12:20:00 | AAPL | Stock | 1.0759 | 1.0837 | 1.0692 | 1.0698 | 7560000.0 |
| 2000-04-04 12:25:00 | AAPL | Stock | 1.0686 | 1.0714 | 1.0642 | 1.0658 | 11032000.0 |
| 2000-04-04 12:30:00 | AAPL | Stock | 1.0653 | 1.0658 | 1.0564 | 1.0625 | 15523200.0 |
| 2000-04-04 12:35:00 | AAPL | Stock | 1.0622 | 1.0625 | 1.053 | 1.0536 | 7739200.0 |
| 2000-04-04 12:40:00 | AAPL | Stock | 1.0525 | 1.0552 | 1.0424 | 1.0441 | 9576000.0 |
| 2000-04-04 12:45:00 | AAPL | Stock | 1.0446 | 1.0703 | 1.0441 | 1.0698 | 9531200.0 |
| 2000-04-04 12:50:00 | AAPL | Stock | 1.07 | 1.0703 | 1.0603 | 1.0625 | 8702400.0 |
| 2000-04-04 12:55:00 | AAPL | Stock | 1.0625 | 1.0692 | 1.0536 | 1.067 | 8142400.0 |
| 2000-04-04 13:00:00 | AAPL | Stock | 1.0692 | 1.0714 | 1.0547 | 1.0547 | 5129600.0 |
| 2000-04-04 13:05:00 | AAPL | Stock | 1.0547 | 1.0619 | 1.048 | 1.048 | 4435200.0 |
| 2000-04-04 13:10:00 | AAPL | Stock | 1.0458 | 1.0519 | 1.0435 | 1.0508 | 4659200.0 |
| 2000-04-04 13:15:00 | AAPL | Stock | 1.0508 | 1.0592 | 1.048 | 1.0592 | 2867200.0 |
| 2000-04-04 13:20:00 | AAPL | Stock | 1.0603 | 1.0725 | 1.0536 | 1.0725 | 5790400.0 |
| 2000-04-04 13:25:00 | AAPL | Stock | 1.07 | 1.1027 | 1.07 | 1.1004 | 8612800.0 |
| 2000-04-04 13:30:00 | AAPL | Stock | 1.1021 | 1.1172 | 1.1021 | 1.1158 | 22041600.0 |
| 2000-04-04 13:35:00 | AAPL | Stock | 1.1158 | 1.1272 | 1.1105 | 1.1272 | 16329600.0 |
> showing 50 of 99,975 rows — these rows as CSV