PREVIEW / stock_5min / 2003-11-13
file: by_date/stock_5min/2003/2003-11-13.parquet size: 2.2 MB rows: 161,827 symbols: 1,659
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-13 08:00:00 | AAPL | Stock | 0.3998 | 0.3998 | 0.3998 | 0.3998 | 61600.0 |
| 2003-11-13 08:35:00 | AAPL | Stock | 0.3975 | 0.3975 | 0.3975 | 0.3975 | 56000.0 |
| 2003-11-13 08:40:00 | AAPL | Stock | 0.3973 | 0.3973 | 0.3973 | 0.3973 | 11200.0 |
| 2003-11-13 08:45:00 | AAPL | Stock | 0.3977 | 0.3977 | 0.3977 | 0.3977 | 5600.0 |
| 2003-11-13 08:55:00 | AAPL | Stock | 0.3971 | 0.3971 | 0.3966 | 0.3966 | 28000.0 |
| 2003-11-13 09:00:00 | AAPL | Stock | 0.3964 | 0.3964 | 0.3964 | 0.3964 | 28000.0 |
| 2003-11-13 09:05:00 | AAPL | Stock | 0.3966 | 0.3966 | 0.3964 | 0.3964 | 117600.0 |
| 2003-11-13 09:15:00 | AAPL | Stock | 0.3964 | 0.3964 | 0.3964 | 0.3964 | 78400.0 |
| 2003-11-13 09:25:00 | AAPL | Stock | 0.3964 | 0.3996 | 0.3943 | 0.3945 | 800800.0 |
| 2003-11-13 09:30:00 | AAPL | Stock | 0.3941 | 0.3957 | 0.3938 | 0.3946 | 3536064.0 |
| 2003-11-13 09:35:00 | AAPL | Stock | 0.3943 | 0.3952 | 0.392 | 0.392 | 3232712.0 |
| 2003-11-13 09:40:00 | AAPL | Stock | 0.392 | 0.3943 | 0.3914 | 0.3939 | 3520664.0 |
| 2003-11-13 09:45:00 | AAPL | Stock | 0.3939 | 0.3944 | 0.3936 | 0.3938 | 2140880.0 |
| 2003-11-13 09:50:00 | AAPL | Stock | 0.3941 | 0.3968 | 0.3938 | 0.3964 | 7998144.0 |
| 2003-11-13 09:55:00 | AAPL | Stock | 0.3968 | 0.3989 | 0.3968 | 0.3982 | 3195528.0 |
| 2003-11-13 10:00:00 | AAPL | Stock | 0.3982 | 0.4002 | 0.3982 | 0.4002 | 5375944.0 |
| 2003-11-13 10:05:00 | AAPL | Stock | 0.4 | 0.4016 | 0.3993 | 0.4013 | 6230000.0 |
| 2003-11-13 10:10:00 | AAPL | Stock | 0.4011 | 0.4029 | 0.4009 | 0.4013 | 8054200.0 |
| 2003-11-13 10:15:00 | AAPL | Stock | 0.4013 | 0.4014 | 0.3984 | 0.3988 | 4802280.0 |
| 2003-11-13 10:20:00 | AAPL | Stock | 0.3987 | 0.3993 | 0.398 | 0.3986 | 1220576.0 |
| 2003-11-13 10:25:00 | AAPL | Stock | 0.3984 | 0.3993 | 0.3979 | 0.3986 | 2233168.0 |
| 2003-11-13 10:30:00 | AAPL | Stock | 0.3986 | 0.3996 | 0.3982 | 0.3984 | 3275104.0 |
| 2003-11-13 10:35:00 | AAPL | Stock | 0.3984 | 0.3989 | 0.3977 | 0.3977 | 3923920.0 |
| 2003-11-13 10:40:00 | AAPL | Stock | 0.3977 | 0.3982 | 0.395 | 0.395 | 3516576.0 |
| 2003-11-13 10:45:00 | AAPL | Stock | 0.3957 | 0.3964 | 0.3946 | 0.3963 | 2013480.0 |
| 2003-11-13 10:50:00 | AAPL | Stock | 0.3966 | 0.3986 | 0.3966 | 0.398 | 1915200.0 |
| 2003-11-13 10:55:00 | AAPL | Stock | 0.398 | 0.3993 | 0.398 | 0.3993 | 4852904.0 |
| 2003-11-13 11:00:00 | AAPL | Stock | 0.3993 | 0.3995 | 0.3986 | 0.3986 | 1250480.0 |
| 2003-11-13 11:05:00 | AAPL | Stock | 0.3989 | 0.3989 | 0.3984 | 0.3984 | 1147440.0 |
| 2003-11-13 11:10:00 | AAPL | Stock | 0.3984 | 0.3986 | 0.398 | 0.398 | 970536.0 |
| 2003-11-13 11:15:00 | AAPL | Stock | 0.3982 | 0.3982 | 0.3968 | 0.397 | 1039976.0 |
| 2003-11-13 11:20:00 | AAPL | Stock | 0.397 | 0.397 | 0.3964 | 0.3964 | 1688848.0 |
| 2003-11-13 11:25:00 | AAPL | Stock | 0.3966 | 0.3966 | 0.3955 | 0.3957 | 1891848.0 |
| 2003-11-13 11:30:00 | AAPL | Stock | 0.3954 | 0.3963 | 0.3954 | 0.3957 | 1066800.0 |
| 2003-11-13 11:35:00 | AAPL | Stock | 0.3963 | 0.3964 | 0.3958 | 0.3963 | 392000.0 |
| 2003-11-13 11:40:00 | AAPL | Stock | 0.3964 | 0.3964 | 0.3961 | 0.3964 | 438760.0 |
| 2003-11-13 11:45:00 | AAPL | Stock | 0.3964 | 0.3973 | 0.3964 | 0.3973 | 953512.0 |
| 2003-11-13 11:50:00 | AAPL | Stock | 0.3973 | 0.3986 | 0.3971 | 0.3986 | 2329040.0 |
| 2003-11-13 11:55:00 | AAPL | Stock | 0.3984 | 0.3988 | 0.3982 | 0.3988 | 2240560.0 |
| 2003-11-13 12:00:00 | AAPL | Stock | 0.3986 | 0.3995 | 0.3984 | 0.399 | 8875216.0 |
| 2003-11-13 12:05:00 | AAPL | Stock | 0.3989 | 0.3991 | 0.3988 | 0.3988 | 661808.0 |
| 2003-11-13 12:10:00 | AAPL | Stock | 0.3988 | 0.3989 | 0.3984 | 0.3984 | 992712.0 |
| 2003-11-13 12:15:00 | AAPL | Stock | 0.3984 | 0.3988 | 0.397 | 0.3975 | 2222752.0 |
| 2003-11-13 12:20:00 | AAPL | Stock | 0.3971 | 0.3979 | 0.3971 | 0.3979 | 650384.0 |
| 2003-11-13 12:25:00 | AAPL | Stock | 0.398 | 0.3988 | 0.398 | 0.3984 | 1299592.0 |
| 2003-11-13 12:30:00 | AAPL | Stock | 0.3984 | 0.3993 | 0.3984 | 0.3993 | 1107680.0 |
| 2003-11-13 12:35:00 | AAPL | Stock | 0.3991 | 0.4 | 0.3991 | 0.3995 | 1847664.0 |
| 2003-11-13 12:40:00 | AAPL | Stock | 0.3995 | 0.3998 | 0.3991 | 0.3993 | 932400.0 |
| 2003-11-13 12:45:00 | AAPL | Stock | 0.3991 | 0.3992 | 0.3986 | 0.3986 | 966448.0 |
| 2003-11-13 12:50:00 | AAPL | Stock | 0.3986 | 0.3988 | 0.3984 | 0.3984 | 652960.0 |
> showing 50 of 161,827 rows — these rows as CSV