PREVIEW / stock_5min / 2003-09-18
file: by_date/stock_5min/2003/2003-09-18.parquet size: 2.1 MB rows: 154,878 symbols: 1,608
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-18 09:20:00 | AAPL | Stock | 0.3946 | 0.3946 | 0.3946 | 0.3946 | 11200.0 |
| 2003-09-18 09:25:00 | AAPL | Stock | 0.3946 | 0.395 | 0.3939 | 0.3939 | 198800.0 |
| 2003-09-18 09:30:00 | AAPL | Stock | 0.3946 | 0.397 | 0.3929 | 0.3954 | 5899320.0 |
| 2003-09-18 09:35:00 | AAPL | Stock | 0.3952 | 0.3959 | 0.393 | 0.3955 | 2260104.0 |
| 2003-09-18 09:40:00 | AAPL | Stock | 0.3955 | 0.3959 | 0.393 | 0.393 | 2320864.0 |
| 2003-09-18 09:45:00 | AAPL | Stock | 0.393 | 0.3946 | 0.392 | 0.3936 | 3665200.0 |
| 2003-09-18 09:50:00 | AAPL | Stock | 0.3938 | 0.395 | 0.3936 | 0.3938 | 2646000.0 |
| 2003-09-18 09:55:00 | AAPL | Stock | 0.3938 | 0.397 | 0.3934 | 0.3964 | 4430776.0 |
| 2003-09-18 10:00:00 | AAPL | Stock | 0.3963 | 0.3982 | 0.3954 | 0.3982 | 3160024.0 |
| 2003-09-18 10:05:00 | AAPL | Stock | 0.3982 | 0.3988 | 0.3977 | 0.3977 | 2802184.0 |
| 2003-09-18 10:10:00 | AAPL | Stock | 0.398 | 0.3988 | 0.3964 | 0.397 | 1948800.0 |
| 2003-09-18 10:15:00 | AAPL | Stock | 0.3973 | 0.3982 | 0.3966 | 0.3977 | 2700208.0 |
| 2003-09-18 10:20:00 | AAPL | Stock | 0.3979 | 0.4 | 0.3977 | 0.3998 | 1408400.0 |
| 2003-09-18 10:25:00 | AAPL | Stock | 0.3996 | 0.4 | 0.3996 | 0.4 | 1316000.0 |
| 2003-09-18 10:30:00 | AAPL | Stock | 0.4 | 0.4 | 0.3993 | 0.4 | 769720.0 |
| 2003-09-18 10:35:00 | AAPL | Stock | 0.3996 | 0.4005 | 0.3996 | 0.3996 | 1306200.0 |
| 2003-09-18 10:40:00 | AAPL | Stock | 0.3998 | 0.4 | 0.3996 | 0.3996 | 1233568.0 |
| 2003-09-18 10:45:00 | AAPL | Stock | 0.3996 | 0.4007 | 0.3995 | 0.4004 | 3807104.0 |
| 2003-09-18 10:50:00 | AAPL | Stock | 0.4007 | 0.4016 | 0.4002 | 0.4016 | 9051112.0 |
| 2003-09-18 10:55:00 | AAPL | Stock | 0.4016 | 0.4039 | 0.4014 | 0.4039 | 7896840.0 |
| 2003-09-18 11:00:00 | AAPL | Stock | 0.4039 | 0.4048 | 0.4037 | 0.4039 | 3646328.0 |
| 2003-09-18 11:05:00 | AAPL | Stock | 0.4039 | 0.4045 | 0.403 | 0.4039 | 4071872.0 |
| 2003-09-18 11:10:00 | AAPL | Stock | 0.4039 | 0.4045 | 0.4032 | 0.4039 | 3370192.0 |
| 2003-09-18 11:15:00 | AAPL | Stock | 0.4041 | 0.4066 | 0.4039 | 0.4054 | 6356000.0 |
| 2003-09-18 11:20:00 | AAPL | Stock | 0.4054 | 0.4066 | 0.4054 | 0.4064 | 1515024.0 |
| 2003-09-18 11:25:00 | AAPL | Stock | 0.4068 | 0.4068 | 0.4054 | 0.4055 | 2449608.0 |
| 2003-09-18 11:30:00 | AAPL | Stock | 0.4057 | 0.4088 | 0.4057 | 0.4079 | 3615080.0 |
| 2003-09-18 11:35:00 | AAPL | Stock | 0.4079 | 0.4089 | 0.4079 | 0.4089 | 4156432.0 |
| 2003-09-18 11:40:00 | AAPL | Stock | 0.4089 | 0.4089 | 0.4073 | 0.4073 | 5519416.0 |
| 2003-09-18 11:45:00 | AAPL | Stock | 0.4073 | 0.4086 | 0.4064 | 0.4084 | 2108624.0 |
| 2003-09-18 11:50:00 | AAPL | Stock | 0.4084 | 0.4084 | 0.4068 | 0.4068 | 862288.0 |
| 2003-09-18 11:55:00 | AAPL | Stock | 0.407 | 0.4074 | 0.4066 | 0.407 | 1758400.0 |
| 2003-09-18 12:00:00 | AAPL | Stock | 0.4071 | 0.4071 | 0.4055 | 0.4064 | 3132808.0 |
| 2003-09-18 12:05:00 | AAPL | Stock | 0.4068 | 0.407 | 0.405 | 0.4066 | 2237144.0 |
| 2003-09-18 12:10:00 | AAPL | Stock | 0.4066 | 0.4086 | 0.4066 | 0.4084 | 3260208.0 |
| 2003-09-18 12:15:00 | AAPL | Stock | 0.408 | 0.4098 | 0.408 | 0.4098 | 3080000.0 |
| 2003-09-18 12:20:00 | AAPL | Stock | 0.4096 | 0.4098 | 0.4088 | 0.4091 | 8535408.0 |
| 2003-09-18 12:25:00 | AAPL | Stock | 0.4091 | 0.4098 | 0.4088 | 0.4096 | 1629152.0 |
| 2003-09-18 12:30:00 | AAPL | Stock | 0.4096 | 0.4096 | 0.4088 | 0.4093 | 2167200.0 |
| 2003-09-18 12:35:00 | AAPL | Stock | 0.4095 | 0.4096 | 0.4091 | 0.4095 | 1024800.0 |
| 2003-09-18 12:40:00 | AAPL | Stock | 0.4096 | 0.4098 | 0.4093 | 0.4095 | 2234400.0 |
| 2003-09-18 12:45:00 | AAPL | Stock | 0.4096 | 0.4096 | 0.4093 | 0.4093 | 1736000.0 |
| 2003-09-18 12:50:00 | AAPL | Stock | 0.4093 | 0.41 | 0.4093 | 0.41 | 2284800.0 |
| 2003-09-18 12:55:00 | AAPL | Stock | 0.41 | 0.4105 | 0.4098 | 0.4105 | 2095576.0 |
| 2003-09-18 13:00:00 | AAPL | Stock | 0.4104 | 0.4105 | 0.4091 | 0.4098 | 3809680.0 |
| 2003-09-18 13:05:00 | AAPL | Stock | 0.4091 | 0.4093 | 0.4082 | 0.4084 | 2003680.0 |
| 2003-09-18 13:10:00 | AAPL | Stock | 0.4084 | 0.4084 | 0.4071 | 0.4071 | 1355200.0 |
| 2003-09-18 13:15:00 | AAPL | Stock | 0.4073 | 0.4084 | 0.4071 | 0.4079 | 431200.0 |
| 2003-09-18 13:20:00 | AAPL | Stock | 0.4082 | 0.4082 | 0.4075 | 0.4075 | 1187200.0 |
| 2003-09-18 13:25:00 | AAPL | Stock | 0.4075 | 0.4082 | 0.4075 | 0.4079 | 1631000.0 |
> showing 50 of 154,878 rows — these rows as CSV