PREVIEW / stock_5min / 2003-09-11
file: by_date/stock_5min/2003/2003-09-11.parquet size: 2.1 MB rows: 151,782 symbols: 1,609
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-11 08:00:00 | AAPL | Stock | 0.3978 | 0.3978 | 0.3978 | 0.3978 | 543200.0 |
| 2003-09-11 09:25:00 | AAPL | Stock | 0.3984 | 0.3989 | 0.3973 | 0.3973 | 134400.0 |
| 2003-09-11 09:30:00 | AAPL | Stock | 0.3973 | 0.4013 | 0.3966 | 0.397 | 4859232.0 |
| 2003-09-11 09:35:00 | AAPL | Stock | 0.4002 | 0.402 | 0.3975 | 0.3986 | 8989064.0 |
| 2003-09-11 09:40:00 | AAPL | Stock | 0.3991 | 0.4004 | 0.3982 | 0.3984 | 965216.0 |
| 2003-09-11 09:45:00 | AAPL | Stock | 0.3982 | 0.3988 | 0.3975 | 0.3982 | 980000.0 |
| 2003-09-11 09:50:00 | AAPL | Stock | 0.3982 | 0.3998 | 0.398 | 0.3996 | 1126048.0 |
| 2003-09-11 09:55:00 | AAPL | Stock | 0.3996 | 0.4005 | 0.3977 | 0.398 | 2540216.0 |
| 2003-09-11 10:00:00 | AAPL | Stock | 0.398 | 0.4002 | 0.3977 | 0.3988 | 1297016.0 |
| 2003-09-11 10:05:00 | AAPL | Stock | 0.3991 | 0.3995 | 0.3984 | 0.3988 | 1327928.0 |
| 2003-09-11 10:10:00 | AAPL | Stock | 0.3988 | 0.4 | 0.398 | 0.3986 | 1665664.0 |
| 2003-09-11 10:15:00 | AAPL | Stock | 0.3986 | 0.3993 | 0.3973 | 0.3973 | 1602944.0 |
| 2003-09-11 10:20:00 | AAPL | Stock | 0.3975 | 0.3977 | 0.3946 | 0.3961 | 4242616.0 |
| 2003-09-11 10:25:00 | AAPL | Stock | 0.3961 | 0.397 | 0.3959 | 0.3959 | 1122856.0 |
| 2003-09-11 10:30:00 | AAPL | Stock | 0.3961 | 0.397 | 0.3957 | 0.397 | 1909600.0 |
| 2003-09-11 10:35:00 | AAPL | Stock | 0.3971 | 0.3981 | 0.3971 | 0.3975 | 2307200.0 |
| 2003-09-11 10:40:00 | AAPL | Stock | 0.3973 | 0.3975 | 0.3964 | 0.3964 | 1383200.0 |
| 2003-09-11 10:45:00 | AAPL | Stock | 0.3966 | 0.3973 | 0.3964 | 0.3973 | 2276120.0 |
| 2003-09-11 10:50:00 | AAPL | Stock | 0.3973 | 0.3979 | 0.3963 | 0.3966 | 3662400.0 |
| 2003-09-11 10:55:00 | AAPL | Stock | 0.3964 | 0.3971 | 0.3963 | 0.3971 | 1220800.0 |
| 2003-09-11 11:00:00 | AAPL | Stock | 0.3966 | 0.3971 | 0.3963 | 0.3964 | 1754760.0 |
| 2003-09-11 11:05:00 | AAPL | Stock | 0.3963 | 0.3964 | 0.3961 | 0.3963 | 1080800.0 |
| 2003-09-11 11:10:00 | AAPL | Stock | 0.3961 | 0.3961 | 0.3957 | 0.3957 | 1187200.0 |
| 2003-09-11 11:15:00 | AAPL | Stock | 0.3957 | 0.3963 | 0.3954 | 0.3955 | 2481472.0 |
| 2003-09-11 11:20:00 | AAPL | Stock | 0.3955 | 0.3959 | 0.395 | 0.3957 | 1423240.0 |
| 2003-09-11 11:25:00 | AAPL | Stock | 0.3957 | 0.3977 | 0.3957 | 0.3973 | 1281840.0 |
| 2003-09-11 11:30:00 | AAPL | Stock | 0.3979 | 0.3991 | 0.3975 | 0.3991 | 2044392.0 |
| 2003-09-11 11:35:00 | AAPL | Stock | 0.3991 | 0.4027 | 0.3991 | 0.4018 | 5562088.0 |
| 2003-09-11 11:40:00 | AAPL | Stock | 0.4021 | 0.4021 | 0.4011 | 0.4011 | 1372000.0 |
| 2003-09-11 11:45:00 | AAPL | Stock | 0.4011 | 0.4029 | 0.4011 | 0.4025 | 6433336.0 |
| 2003-09-11 11:50:00 | AAPL | Stock | 0.4025 | 0.403 | 0.4021 | 0.4023 | 6062392.0 |
| 2003-09-11 11:55:00 | AAPL | Stock | 0.4023 | 0.4036 | 0.402 | 0.4034 | 3226552.0 |
| 2003-09-11 12:00:00 | AAPL | Stock | 0.4032 | 0.4034 | 0.4025 | 0.4027 | 3174696.0 |
| 2003-09-11 12:05:00 | AAPL | Stock | 0.4029 | 0.4032 | 0.4016 | 0.4027 | 1562400.0 |
| 2003-09-11 12:10:00 | AAPL | Stock | 0.4027 | 0.403 | 0.402 | 0.4021 | 1803200.0 |
| 2003-09-11 12:15:00 | AAPL | Stock | 0.402 | 0.4023 | 0.4011 | 0.4011 | 1519392.0 |
| 2003-09-11 12:20:00 | AAPL | Stock | 0.4013 | 0.402 | 0.4013 | 0.402 | 1360856.0 |
| 2003-09-11 12:25:00 | AAPL | Stock | 0.402 | 0.4023 | 0.4013 | 0.4013 | 1446928.0 |
| 2003-09-11 12:30:00 | AAPL | Stock | 0.4013 | 0.4016 | 0.4011 | 0.4013 | 1305136.0 |
| 2003-09-11 12:35:00 | AAPL | Stock | 0.4011 | 0.4013 | 0.4004 | 0.4005 | 1590400.0 |
| 2003-09-11 12:40:00 | AAPL | Stock | 0.4005 | 0.4005 | 0.4 | 0.4005 | 1032080.0 |
| 2003-09-11 12:45:00 | AAPL | Stock | 0.4005 | 0.4013 | 0.4005 | 0.4007 | 1204000.0 |
| 2003-09-11 12:50:00 | AAPL | Stock | 0.4005 | 0.4013 | 0.4005 | 0.4011 | 1288448.0 |
| 2003-09-11 12:55:00 | AAPL | Stock | 0.4011 | 0.402 | 0.4007 | 0.4018 | 1636544.0 |
| 2003-09-11 13:00:00 | AAPL | Stock | 0.4018 | 0.4034 | 0.4014 | 0.4032 | 3999464.0 |
| 2003-09-11 13:05:00 | AAPL | Stock | 0.4032 | 0.4055 | 0.4032 | 0.4052 | 4144896.0 |
| 2003-09-11 13:10:00 | AAPL | Stock | 0.4054 | 0.4055 | 0.4029 | 0.4029 | 1355200.0 |
| 2003-09-11 13:15:00 | AAPL | Stock | 0.403 | 0.403 | 0.4018 | 0.402 | 1939784.0 |
| 2003-09-11 13:20:00 | AAPL | Stock | 0.4021 | 0.4046 | 0.4021 | 0.4034 | 775600.0 |
| 2003-09-11 13:25:00 | AAPL | Stock | 0.4034 | 0.4036 | 0.4023 | 0.4023 | 1864800.0 |
> showing 50 of 151,782 rows — these rows as CSV