PREVIEW / stock_5min / 2003-10-24
file: by_date/stock_5min/2003/2003-10-24.parquet size: 2.2 MB rows: 156,459 symbols: 1,635
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-10-24 09:00:00 | AAPL | Stock | 0.4105 | 0.4105 | 0.4105 | 0.4105 | 89600.0 |
| 2003-10-24 09:20:00 | AAPL | Stock | 0.4038 | 0.4038 | 0.4038 | 0.4038 | 11200.0 |
| 2003-10-24 09:25:00 | AAPL | Stock | 0.4055 | 0.4055 | 0.4027 | 0.4027 | 498400.0 |
| 2003-10-24 09:30:00 | AAPL | Stock | 0.4023 | 0.4029 | 0.3988 | 0.4005 | 11422432.0 |
| 2003-10-24 09:35:00 | AAPL | Stock | 0.4007 | 0.4018 | 0.3996 | 0.4009 | 5113136.0 |
| 2003-10-24 09:40:00 | AAPL | Stock | 0.4009 | 0.4045 | 0.4009 | 0.4039 | 3540264.0 |
| 2003-10-24 09:45:00 | AAPL | Stock | 0.4039 | 0.4054 | 0.4034 | 0.4054 | 3805200.0 |
| 2003-10-24 09:50:00 | AAPL | Stock | 0.4054 | 0.408 | 0.4052 | 0.4066 | 2179968.0 |
| 2003-10-24 09:55:00 | AAPL | Stock | 0.4068 | 0.407 | 0.4059 | 0.4063 | 2318400.0 |
| 2003-10-24 10:00:00 | AAPL | Stock | 0.4064 | 0.4066 | 0.4046 | 0.4047 | 1313648.0 |
| 2003-10-24 10:05:00 | AAPL | Stock | 0.405 | 0.405 | 0.4045 | 0.4046 | 2391200.0 |
| 2003-10-24 10:10:00 | AAPL | Stock | 0.4045 | 0.4045 | 0.4029 | 0.4032 | 2796640.0 |
| 2003-10-24 10:15:00 | AAPL | Stock | 0.4032 | 0.4045 | 0.4019 | 0.4025 | 3567200.0 |
| 2003-10-24 10:20:00 | AAPL | Stock | 0.4027 | 0.4036 | 0.4021 | 0.4023 | 2038400.0 |
| 2003-10-24 10:25:00 | AAPL | Stock | 0.4023 | 0.4025 | 0.4018 | 0.4023 | 2172800.0 |
| 2003-10-24 10:30:00 | AAPL | Stock | 0.4021 | 0.4021 | 0.4005 | 0.4007 | 2984072.0 |
| 2003-10-24 10:35:00 | AAPL | Stock | 0.4007 | 0.4021 | 0.4007 | 0.4021 | 1450400.0 |
| 2003-10-24 10:40:00 | AAPL | Stock | 0.4023 | 0.4025 | 0.4009 | 0.4013 | 2358104.0 |
| 2003-10-24 10:45:00 | AAPL | Stock | 0.4013 | 0.4018 | 0.4002 | 0.4004 | 2329264.0 |
| 2003-10-24 10:50:00 | AAPL | Stock | 0.4002 | 0.402 | 0.4002 | 0.402 | 1393952.0 |
| 2003-10-24 10:55:00 | AAPL | Stock | 0.4018 | 0.4025 | 0.4009 | 0.4025 | 3539200.0 |
| 2003-10-24 11:00:00 | AAPL | Stock | 0.4025 | 0.4032 | 0.4023 | 0.4032 | 2052792.0 |
| 2003-10-24 11:05:00 | AAPL | Stock | 0.4032 | 0.4034 | 0.4026 | 0.4027 | 987336.0 |
| 2003-10-24 11:10:00 | AAPL | Stock | 0.4027 | 0.4027 | 0.4016 | 0.4021 | 917728.0 |
| 2003-10-24 11:15:00 | AAPL | Stock | 0.4021 | 0.4021 | 0.4011 | 0.4016 | 417704.0 |
| 2003-10-24 11:20:00 | AAPL | Stock | 0.4016 | 0.4016 | 0.4007 | 0.4009 | 873600.0 |
| 2003-10-24 11:25:00 | AAPL | Stock | 0.4011 | 0.402 | 0.4007 | 0.4009 | 2284800.0 |
| 2003-10-24 11:30:00 | AAPL | Stock | 0.4007 | 0.4009 | 0.3991 | 0.3993 | 3670296.0 |
| 2003-10-24 11:35:00 | AAPL | Stock | 0.3993 | 0.3995 | 0.3987 | 0.3993 | 2822400.0 |
| 2003-10-24 11:40:00 | AAPL | Stock | 0.3993 | 0.4 | 0.3991 | 0.4 | 1246000.0 |
| 2003-10-24 11:45:00 | AAPL | Stock | 0.3998 | 0.4 | 0.3988 | 0.3991 | 1482040.0 |
| 2003-10-24 11:50:00 | AAPL | Stock | 0.3989 | 0.3989 | 0.3979 | 0.3984 | 4922400.0 |
| 2003-10-24 11:55:00 | AAPL | Stock | 0.3984 | 0.3991 | 0.3984 | 0.3991 | 918400.0 |
| 2003-10-24 12:00:00 | AAPL | Stock | 0.399 | 0.3993 | 0.3989 | 0.3993 | 1383200.0 |
| 2003-10-24 12:05:00 | AAPL | Stock | 0.3993 | 0.3996 | 0.3989 | 0.3995 | 803600.0 |
| 2003-10-24 12:10:00 | AAPL | Stock | 0.3991 | 0.3991 | 0.3988 | 0.3991 | 537152.0 |
| 2003-10-24 12:15:00 | AAPL | Stock | 0.3991 | 0.3991 | 0.3986 | 0.3986 | 1492064.0 |
| 2003-10-24 12:20:00 | AAPL | Stock | 0.3986 | 0.3995 | 0.3984 | 0.3995 | 1315384.0 |
| 2003-10-24 12:25:00 | AAPL | Stock | 0.3991 | 0.3991 | 0.3984 | 0.3991 | 711200.0 |
| 2003-10-24 12:30:00 | AAPL | Stock | 0.3988 | 0.3993 | 0.3982 | 0.3993 | 2726080.0 |
| 2003-10-24 12:35:00 | AAPL | Stock | 0.3995 | 0.3995 | 0.3978 | 0.3979 | 2528960.0 |
| 2003-10-24 12:40:00 | AAPL | Stock | 0.398 | 0.3996 | 0.398 | 0.3986 | 2788632.0 |
| 2003-10-24 12:45:00 | AAPL | Stock | 0.3986 | 0.3991 | 0.3979 | 0.3984 | 2230480.0 |
| 2003-10-24 12:50:00 | AAPL | Stock | 0.3984 | 0.3988 | 0.3982 | 0.3988 | 792680.0 |
| 2003-10-24 12:55:00 | AAPL | Stock | 0.3988 | 0.3991 | 0.3988 | 0.3989 | 1640800.0 |
| 2003-10-24 13:00:00 | AAPL | Stock | 0.3991 | 0.3991 | 0.3988 | 0.3989 | 1064000.0 |
| 2003-10-24 13:05:00 | AAPL | Stock | 0.3989 | 0.3995 | 0.3989 | 0.3993 | 1880256.0 |
| 2003-10-24 13:10:00 | AAPL | Stock | 0.3995 | 0.4 | 0.3986 | 0.3988 | 941976.0 |
| 2003-10-24 13:15:00 | AAPL | Stock | 0.3988 | 0.3996 | 0.3986 | 0.3993 | 730576.0 |
| 2003-10-24 13:20:00 | AAPL | Stock | 0.3995 | 0.3996 | 0.3994 | 0.3996 | 666288.0 |
> showing 50 of 156,459 rows — these rows as CSV