PREVIEW / stock_5min / 2003-09-22
file: by_date/stock_5min/2003/2003-09-22.parquet size: 2.1 MB rows: 156,117 symbols: 1,618
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 |
|---|---|---|---|---|---|---|---|
| 2003-09-22 08:00:00 | AAPL | Stock | 0.4016 | 0.4016 | 0.4005 | 0.4005 | 33600.0 |
| 2003-09-22 08:35:00 | AAPL | Stock | 0.3973 | 0.3973 | 0.3973 | 0.3973 | 67200.0 |
| 2003-09-22 09:05:00 | AAPL | Stock | 0.3973 | 0.3973 | 0.3973 | 0.3973 | 218400.0 |
| 2003-09-22 09:25:00 | AAPL | Stock | 0.4005 | 0.4005 | 0.3963 | 0.3963 | 1175944.0 |
| 2003-09-22 09:30:00 | AAPL | Stock | 0.3961 | 0.3965 | 0.393 | 0.3961 | 5205648.0 |
| 2003-09-22 09:35:00 | AAPL | Stock | 0.3963 | 0.3989 | 0.3954 | 0.3979 | 2725352.0 |
| 2003-09-22 09:40:00 | AAPL | Stock | 0.3979 | 0.3988 | 0.3966 | 0.3966 | 2267888.0 |
| 2003-09-22 09:45:00 | AAPL | Stock | 0.3964 | 0.3973 | 0.3945 | 0.3948 | 5538400.0 |
| 2003-09-22 09:50:00 | AAPL | Stock | 0.3946 | 0.3948 | 0.3934 | 0.3938 | 3231312.0 |
| 2003-09-22 09:55:00 | AAPL | Stock | 0.3938 | 0.3954 | 0.3936 | 0.3939 | 1540000.0 |
| 2003-09-22 10:00:00 | AAPL | Stock | 0.3938 | 0.3943 | 0.3927 | 0.3943 | 2881200.0 |
| 2003-09-22 10:05:00 | AAPL | Stock | 0.3943 | 0.3945 | 0.3934 | 0.3945 | 1583792.0 |
| 2003-09-22 10:10:00 | AAPL | Stock | 0.3945 | 0.3961 | 0.3941 | 0.3943 | 2777600.0 |
| 2003-09-22 10:15:00 | AAPL | Stock | 0.3943 | 0.395 | 0.3941 | 0.3948 | 688688.0 |
| 2003-09-22 10:20:00 | AAPL | Stock | 0.3948 | 0.395 | 0.3938 | 0.3938 | 2032352.0 |
| 2003-09-22 10:25:00 | AAPL | Stock | 0.3939 | 0.3952 | 0.3938 | 0.3948 | 4546416.0 |
| 2003-09-22 10:30:00 | AAPL | Stock | 0.3948 | 0.3975 | 0.3939 | 0.3973 | 3974488.0 |
| 2003-09-22 10:35:00 | AAPL | Stock | 0.3973 | 0.3977 | 0.397 | 0.3975 | 1142400.0 |
| 2003-09-22 10:40:00 | AAPL | Stock | 0.3973 | 0.3975 | 0.3968 | 0.3968 | 869400.0 |
| 2003-09-22 10:45:00 | AAPL | Stock | 0.3968 | 0.3975 | 0.3959 | 0.3975 | 1062600.0 |
| 2003-09-22 10:50:00 | AAPL | Stock | 0.3973 | 0.398 | 0.3973 | 0.3973 | 1073520.0 |
| 2003-09-22 10:55:00 | AAPL | Stock | 0.3973 | 0.3979 | 0.3969 | 0.3971 | 988064.0 |
| 2003-09-22 11:00:00 | AAPL | Stock | 0.3971 | 0.3973 | 0.3968 | 0.3968 | 514192.0 |
| 2003-09-22 11:05:00 | AAPL | Stock | 0.3971 | 0.3979 | 0.3971 | 0.3977 | 554400.0 |
| 2003-09-22 11:10:00 | AAPL | Stock | 0.3979 | 0.3984 | 0.3975 | 0.3984 | 1271424.0 |
| 2003-09-22 11:15:00 | AAPL | Stock | 0.3984 | 0.4009 | 0.3982 | 0.4004 | 2556288.0 |
| 2003-09-22 11:20:00 | AAPL | Stock | 0.4002 | 0.4018 | 0.3996 | 0.4018 | 5780992.0 |
| 2003-09-22 11:25:00 | AAPL | Stock | 0.4013 | 0.4018 | 0.4004 | 0.4011 | 1517600.0 |
| 2003-09-22 11:30:00 | AAPL | Stock | 0.4011 | 0.4018 | 0.4004 | 0.4004 | 2605232.0 |
| 2003-09-22 11:35:00 | AAPL | Stock | 0.4004 | 0.4016 | 0.4004 | 0.4014 | 532000.0 |
| 2003-09-22 11:40:00 | AAPL | Stock | 0.4014 | 0.4016 | 0.4002 | 0.4013 | 1321600.0 |
| 2003-09-22 11:45:00 | AAPL | Stock | 0.4013 | 0.4013 | 0.4002 | 0.4005 | 6624800.0 |
| 2003-09-22 11:50:00 | AAPL | Stock | 0.4005 | 0.4009 | 0.3986 | 0.3986 | 1377600.0 |
| 2003-09-22 11:55:00 | AAPL | Stock | 0.3986 | 0.3993 | 0.3984 | 0.3989 | 547960.0 |
| 2003-09-22 12:00:00 | AAPL | Stock | 0.3988 | 0.3993 | 0.3982 | 0.3989 | 1014944.0 |
| 2003-09-22 12:05:00 | AAPL | Stock | 0.3989 | 0.3998 | 0.3988 | 0.3988 | 2156000.0 |
| 2003-09-22 12:10:00 | AAPL | Stock | 0.3988 | 0.3995 | 0.3982 | 0.3984 | 1489600.0 |
| 2003-09-22 12:15:00 | AAPL | Stock | 0.3986 | 0.3995 | 0.398 | 0.3988 | 730576.0 |
| 2003-09-22 12:20:00 | AAPL | Stock | 0.3986 | 0.3989 | 0.3975 | 0.3982 | 761600.0 |
| 2003-09-22 12:25:00 | AAPL | Stock | 0.3984 | 0.3986 | 0.398 | 0.3986 | 372344.0 |
| 2003-09-22 12:30:00 | AAPL | Stock | 0.3982 | 0.3989 | 0.398 | 0.3984 | 563136.0 |
| 2003-09-22 12:35:00 | AAPL | Stock | 0.3984 | 0.3993 | 0.3977 | 0.3977 | 882224.0 |
| 2003-09-22 12:40:00 | AAPL | Stock | 0.398 | 0.3989 | 0.3977 | 0.3988 | 732872.0 |
| 2003-09-22 12:45:00 | AAPL | Stock | 0.3988 | 0.3988 | 0.3973 | 0.3975 | 778288.0 |
| 2003-09-22 12:50:00 | AAPL | Stock | 0.3975 | 0.398 | 0.3971 | 0.398 | 548800.0 |
| 2003-09-22 12:55:00 | AAPL | Stock | 0.3977 | 0.3977 | 0.3971 | 0.3975 | 240800.0 |
| 2003-09-22 13:00:00 | AAPL | Stock | 0.3977 | 0.3979 | 0.3973 | 0.3973 | 212408.0 |
| 2003-09-22 13:05:00 | AAPL | Stock | 0.3973 | 0.3982 | 0.3973 | 0.3977 | 605360.0 |
| 2003-09-22 13:10:00 | AAPL | Stock | 0.3975 | 0.398 | 0.3973 | 0.3979 | 2212000.0 |
| 2003-09-22 13:15:00 | AAPL | Stock | 0.3977 | 0.398 | 0.3973 | 0.3975 | 386400.0 |
> showing 50 of 156,117 rows — these rows as CSV