PREVIEW / stock_5min / 2003-09-23
file: by_date/stock_5min/2003/2003-09-23.parquet size: 2.1 MB rows: 154,379 symbols: 1,613
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-23 09:05:00 | AAPL | Stock | 0.393 | 0.393 | 0.393 | 0.393 | 72800.0 |
| 2003-09-23 09:10:00 | AAPL | Stock | 0.3939 | 0.3939 | 0.3939 | 0.3939 | 5600.0 |
| 2003-09-23 09:25:00 | AAPL | Stock | 0.3939 | 0.3939 | 0.3938 | 0.3938 | 128800.0 |
| 2003-09-23 09:30:00 | AAPL | Stock | 0.3932 | 0.3946 | 0.3907 | 0.3938 | 5174008.0 |
| 2003-09-23 09:35:00 | AAPL | Stock | 0.3939 | 0.3963 | 0.393 | 0.3931 | 2452856.0 |
| 2003-09-23 09:40:00 | AAPL | Stock | 0.3932 | 0.3948 | 0.3932 | 0.3948 | 1209600.0 |
| 2003-09-23 09:45:00 | AAPL | Stock | 0.395 | 0.3966 | 0.3945 | 0.3966 | 1009680.0 |
| 2003-09-23 09:50:00 | AAPL | Stock | 0.3966 | 0.4011 | 0.3966 | 0.4011 | 16692928.0 |
| 2003-09-23 09:55:00 | AAPL | Stock | 0.4011 | 0.4011 | 0.3993 | 0.3993 | 6687464.0 |
| 2003-09-23 10:00:00 | AAPL | Stock | 0.3995 | 0.3996 | 0.3982 | 0.3993 | 1002176.0 |
| 2003-09-23 10:05:00 | AAPL | Stock | 0.3995 | 0.3995 | 0.397 | 0.3971 | 2162720.0 |
| 2003-09-23 10:10:00 | AAPL | Stock | 0.3971 | 0.3977 | 0.3963 | 0.3966 | 2342368.0 |
| 2003-09-23 10:15:00 | AAPL | Stock | 0.3966 | 0.3966 | 0.395 | 0.395 | 1740088.0 |
| 2003-09-23 10:20:00 | AAPL | Stock | 0.3952 | 0.3954 | 0.3943 | 0.395 | 2350768.0 |
| 2003-09-23 10:25:00 | AAPL | Stock | 0.3952 | 0.398 | 0.3952 | 0.3977 | 1238552.0 |
| 2003-09-23 10:30:00 | AAPL | Stock | 0.3977 | 0.398 | 0.3973 | 0.3975 | 1550696.0 |
| 2003-09-23 10:35:00 | AAPL | Stock | 0.3973 | 0.3975 | 0.3966 | 0.3966 | 756000.0 |
| 2003-09-23 10:40:00 | AAPL | Stock | 0.3968 | 0.3973 | 0.3959 | 0.3961 | 1682464.0 |
| 2003-09-23 10:45:00 | AAPL | Stock | 0.3961 | 0.397 | 0.3955 | 0.3968 | 1057112.0 |
| 2003-09-23 10:50:00 | AAPL | Stock | 0.3968 | 0.3973 | 0.3964 | 0.3971 | 4216800.0 |
| 2003-09-23 10:55:00 | AAPL | Stock | 0.3971 | 0.3971 | 0.3963 | 0.3963 | 1332800.0 |
| 2003-09-23 11:00:00 | AAPL | Stock | 0.3963 | 0.3964 | 0.3952 | 0.3955 | 2083536.0 |
| 2003-09-23 11:05:00 | AAPL | Stock | 0.3957 | 0.3961 | 0.3957 | 0.3957 | 397600.0 |
| 2003-09-23 11:10:00 | AAPL | Stock | 0.3957 | 0.3959 | 0.3957 | 0.3957 | 420000.0 |
| 2003-09-23 11:15:00 | AAPL | Stock | 0.3957 | 0.3961 | 0.3955 | 0.3961 | 358400.0 |
| 2003-09-23 11:20:00 | AAPL | Stock | 0.3963 | 0.397 | 0.3961 | 0.397 | 1044288.0 |
| 2003-09-23 11:25:00 | AAPL | Stock | 0.3968 | 0.3971 | 0.3968 | 0.3968 | 445872.0 |
| 2003-09-23 11:30:00 | AAPL | Stock | 0.3968 | 0.3971 | 0.3966 | 0.3966 | 446768.0 |
| 2003-09-23 11:35:00 | AAPL | Stock | 0.3964 | 0.3966 | 0.3961 | 0.3964 | 252000.0 |
| 2003-09-23 11:40:00 | AAPL | Stock | 0.3964 | 0.397 | 0.3963 | 0.3963 | 669368.0 |
| 2003-09-23 11:45:00 | AAPL | Stock | 0.3964 | 0.3964 | 0.3946 | 0.3952 | 1006096.0 |
| 2003-09-23 11:50:00 | AAPL | Stock | 0.3952 | 0.3964 | 0.3952 | 0.3964 | 409080.0 |
| 2003-09-23 11:55:00 | AAPL | Stock | 0.3966 | 0.3968 | 0.3963 | 0.3968 | 459200.0 |
| 2003-09-23 12:00:00 | AAPL | Stock | 0.397 | 0.3971 | 0.3968 | 0.397 | 302400.0 |
| 2003-09-23 12:05:00 | AAPL | Stock | 0.3971 | 0.3973 | 0.397 | 0.3973 | 455840.0 |
| 2003-09-23 12:10:00 | AAPL | Stock | 0.3973 | 0.398 | 0.3973 | 0.3977 | 498176.0 |
| 2003-09-23 12:15:00 | AAPL | Stock | 0.3977 | 0.3991 | 0.3977 | 0.3991 | 817600.0 |
| 2003-09-23 12:20:00 | AAPL | Stock | 0.3989 | 0.3989 | 0.3975 | 0.3975 | 1199688.0 |
| 2003-09-23 12:25:00 | AAPL | Stock | 0.3975 | 0.3979 | 0.397 | 0.3971 | 740600.0 |
| 2003-09-23 12:30:00 | AAPL | Stock | 0.3971 | 0.3971 | 0.3954 | 0.3961 | 3366944.0 |
| 2003-09-23 12:35:00 | AAPL | Stock | 0.3963 | 0.3971 | 0.3961 | 0.3968 | 1937600.0 |
| 2003-09-23 12:40:00 | AAPL | Stock | 0.397 | 0.3971 | 0.3969 | 0.397 | 380800.0 |
| 2003-09-23 12:45:00 | AAPL | Stock | 0.397 | 0.3971 | 0.3968 | 0.3971 | 224000.0 |
| 2003-09-23 12:50:00 | AAPL | Stock | 0.3971 | 0.3977 | 0.3971 | 0.3973 | 313600.0 |
| 2003-09-23 12:55:00 | AAPL | Stock | 0.3973 | 0.3975 | 0.3971 | 0.3973 | 296800.0 |
| 2003-09-23 13:00:00 | AAPL | Stock | 0.3971 | 0.3977 | 0.3966 | 0.3971 | 1030400.0 |
| 2003-09-23 13:05:00 | AAPL | Stock | 0.3971 | 0.3971 | 0.3968 | 0.397 | 95200.0 |
| 2003-09-23 13:10:00 | AAPL | Stock | 0.397 | 0.3975 | 0.397 | 0.3973 | 308000.0 |
| 2003-09-23 13:15:00 | AAPL | Stock | 0.3975 | 0.3975 | 0.3964 | 0.3964 | 509600.0 |
| 2003-09-23 13:20:00 | AAPL | Stock | 0.3966 | 0.3975 | 0.3961 | 0.3973 | 296800.0 |
> showing 50 of 154,379 rows — these rows as CSV