PREVIEW / stock_5min / 2003-11-14
file: by_date/stock_5min/2003/2003-11-14.parquet size: 2.2 MB rows: 161,468 symbols: 1,663
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-11-14 08:00:00 | AAPL | Stock | 0.375 | 0.375 | 0.375 | 0.375 | 14896.0 |
| 2003-11-14 08:35:00 | AAPL | Stock | 0.3975 | 0.3975 | 0.3975 | 0.3975 | 5600.0 |
| 2003-11-14 08:50:00 | AAPL | Stock | 0.4004 | 0.4004 | 0.4004 | 0.4004 | 22400.0 |
| 2003-11-14 09:00:00 | AAPL | Stock | 0.4004 | 0.4004 | 0.3966 | 0.3966 | 145600.0 |
| 2003-11-14 09:05:00 | AAPL | Stock | 0.3932 | 0.3932 | 0.3932 | 0.3932 | 11200.0 |
| 2003-11-14 09:25:00 | AAPL | Stock | 0.3973 | 0.4018 | 0.3973 | 0.4018 | 425600.0 |
| 2003-11-14 09:30:00 | AAPL | Stock | 0.4016 | 0.4038 | 0.4016 | 0.4023 | 4906496.0 |
| 2003-11-14 09:35:00 | AAPL | Stock | 0.4025 | 0.4036 | 0.402 | 0.4027 | 2176160.0 |
| 2003-11-14 09:40:00 | AAPL | Stock | 0.4025 | 0.4029 | 0.4018 | 0.4018 | 1920856.0 |
| 2003-11-14 09:45:00 | AAPL | Stock | 0.402 | 0.4025 | 0.4013 | 0.4023 | 2142896.0 |
| 2003-11-14 09:50:00 | AAPL | Stock | 0.4021 | 0.4029 | 0.3997 | 0.4009 | 3168872.0 |
| 2003-11-14 09:55:00 | AAPL | Stock | 0.4025 | 0.4025 | 0.3996 | 0.4011 | 1416464.0 |
| 2003-11-14 10:00:00 | AAPL | Stock | 0.4013 | 0.4029 | 0.4002 | 0.4002 | 3615696.0 |
| 2003-11-14 10:05:00 | AAPL | Stock | 0.4004 | 0.4005 | 0.3957 | 0.3971 | 5440568.0 |
| 2003-11-14 10:10:00 | AAPL | Stock | 0.3973 | 0.3973 | 0.3938 | 0.3959 | 4113928.0 |
| 2003-11-14 10:15:00 | AAPL | Stock | 0.3964 | 0.3964 | 0.3941 | 0.3954 | 3536344.0 |
| 2003-11-14 10:20:00 | AAPL | Stock | 0.3955 | 0.3973 | 0.3954 | 0.3973 | 4645088.0 |
| 2003-11-14 10:25:00 | AAPL | Stock | 0.3973 | 0.3975 | 0.3946 | 0.3954 | 2292080.0 |
| 2003-11-14 10:30:00 | AAPL | Stock | 0.3954 | 0.3955 | 0.3946 | 0.3954 | 3795512.0 |
| 2003-11-14 10:35:00 | AAPL | Stock | 0.3957 | 0.3959 | 0.3945 | 0.3948 | 920192.0 |
| 2003-11-14 10:40:00 | AAPL | Stock | 0.395 | 0.3963 | 0.3946 | 0.3957 | 2312128.0 |
| 2003-11-14 10:45:00 | AAPL | Stock | 0.3957 | 0.3959 | 0.3946 | 0.3948 | 3074232.0 |
| 2003-11-14 10:50:00 | AAPL | Stock | 0.3948 | 0.3955 | 0.3943 | 0.3946 | 5200496.0 |
| 2003-11-14 10:55:00 | AAPL | Stock | 0.3946 | 0.3959 | 0.3946 | 0.3948 | 2387896.0 |
| 2003-11-14 11:00:00 | AAPL | Stock | 0.395 | 0.3961 | 0.3946 | 0.3955 | 1921416.0 |
| 2003-11-14 11:05:00 | AAPL | Stock | 0.3955 | 0.3966 | 0.3954 | 0.3964 | 1901648.0 |
| 2003-11-14 11:10:00 | AAPL | Stock | 0.3966 | 0.3968 | 0.3957 | 0.3959 | 947128.0 |
| 2003-11-14 11:15:00 | AAPL | Stock | 0.3959 | 0.3975 | 0.3959 | 0.3973 | 1468768.0 |
| 2003-11-14 11:20:00 | AAPL | Stock | 0.3971 | 0.3971 | 0.3963 | 0.3963 | 1247848.0 |
| 2003-11-14 11:25:00 | AAPL | Stock | 0.3964 | 0.3975 | 0.3957 | 0.396 | 1042776.0 |
| 2003-11-14 11:30:00 | AAPL | Stock | 0.3961 | 0.3977 | 0.3957 | 0.3975 | 1389752.0 |
| 2003-11-14 11:35:00 | AAPL | Stock | 0.3971 | 0.3979 | 0.3961 | 0.3979 | 1121176.0 |
| 2003-11-14 11:40:00 | AAPL | Stock | 0.3978 | 0.3979 | 0.3966 | 0.3968 | 2273096.0 |
| 2003-11-14 11:45:00 | AAPL | Stock | 0.397 | 0.397 | 0.3968 | 0.397 | 362712.0 |
| 2003-11-14 11:50:00 | AAPL | Stock | 0.3968 | 0.397 | 0.3961 | 0.3961 | 1438640.0 |
| 2003-11-14 11:55:00 | AAPL | Stock | 0.3961 | 0.3961 | 0.3952 | 0.3952 | 1134112.0 |
| 2003-11-14 12:00:00 | AAPL | Stock | 0.3952 | 0.397 | 0.3952 | 0.3966 | 1158752.0 |
| 2003-11-14 12:05:00 | AAPL | Stock | 0.3964 | 0.3965 | 0.3955 | 0.3955 | 768880.0 |
| 2003-11-14 12:10:00 | AAPL | Stock | 0.3959 | 0.3966 | 0.3959 | 0.3964 | 887936.0 |
| 2003-11-14 12:15:00 | AAPL | Stock | 0.3963 | 0.3964 | 0.3961 | 0.3961 | 280000.0 |
| 2003-11-14 12:20:00 | AAPL | Stock | 0.3961 | 0.3961 | 0.3948 | 0.395 | 1495256.0 |
| 2003-11-14 12:25:00 | AAPL | Stock | 0.395 | 0.3957 | 0.395 | 0.3952 | 1094352.0 |
| 2003-11-14 12:30:00 | AAPL | Stock | 0.3952 | 0.3955 | 0.3952 | 0.3955 | 1018976.0 |
| 2003-11-14 12:35:00 | AAPL | Stock | 0.3954 | 0.3955 | 0.395 | 0.3952 | 763560.0 |
| 2003-11-14 12:40:00 | AAPL | Stock | 0.3952 | 0.3954 | 0.395 | 0.395 | 960288.0 |
| 2003-11-14 12:45:00 | AAPL | Stock | 0.395 | 0.3952 | 0.3948 | 0.395 | 990136.0 |
| 2003-11-14 12:50:00 | AAPL | Stock | 0.3948 | 0.3952 | 0.3948 | 0.3948 | 474936.0 |
| 2003-11-14 12:55:00 | AAPL | Stock | 0.3948 | 0.3954 | 0.3948 | 0.3948 | 536032.0 |
| 2003-11-14 13:00:00 | AAPL | Stock | 0.3948 | 0.395 | 0.3946 | 0.3946 | 2294600.0 |
| 2003-11-14 13:05:00 | AAPL | Stock | 0.3948 | 0.3954 | 0.3948 | 0.3952 | 1580544.0 |
> showing 50 of 161,468 rows — these rows as CSV