PREVIEW / stock_5min / 2003-09-10
file: by_date/stock_5min/2003/2003-09-10.parquet size: 2.2 MB rows: 157,207 symbols: 1,616
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-10 08:00:00 | AAPL | Stock | 0.3994 | 0.3994 | 0.3994 | 0.3994 | 5600.0 |
| 2003-09-10 08:50:00 | AAPL | Stock | 0.3982 | 0.3982 | 0.3982 | 0.3982 | 22400.0 |
| 2003-09-10 09:10:00 | AAPL | Stock | 0.3977 | 0.3977 | 0.3977 | 0.3977 | 67200.0 |
| 2003-09-10 09:25:00 | AAPL | Stock | 0.3973 | 0.3982 | 0.397 | 0.397 | 151200.0 |
| 2003-09-10 09:30:00 | AAPL | Stock | 0.3973 | 0.4007 | 0.3948 | 0.4004 | 5431552.0 |
| 2003-09-10 09:35:00 | AAPL | Stock | 0.4005 | 0.4014 | 0.3977 | 0.3977 | 5862360.0 |
| 2003-09-10 09:40:00 | AAPL | Stock | 0.3975 | 0.3991 | 0.3971 | 0.3989 | 1945384.0 |
| 2003-09-10 09:45:00 | AAPL | Stock | 0.3989 | 0.3996 | 0.3986 | 0.3995 | 3024672.0 |
| 2003-09-10 09:50:00 | AAPL | Stock | 0.3995 | 0.4025 | 0.3988 | 0.402 | 3074456.0 |
| 2003-09-10 09:55:00 | AAPL | Stock | 0.402 | 0.4038 | 0.4016 | 0.403 | 4085088.0 |
| 2003-09-10 10:00:00 | AAPL | Stock | 0.4029 | 0.4029 | 0.3988 | 0.3989 | 2028936.0 |
| 2003-09-10 10:05:00 | AAPL | Stock | 0.3991 | 0.4016 | 0.3991 | 0.4005 | 1187200.0 |
| 2003-09-10 10:10:00 | AAPL | Stock | 0.4007 | 0.4007 | 0.3984 | 0.3991 | 1968568.0 |
| 2003-09-10 10:15:00 | AAPL | Stock | 0.3991 | 0.3991 | 0.3984 | 0.3989 | 6913760.0 |
| 2003-09-10 10:20:00 | AAPL | Stock | 0.3991 | 0.3995 | 0.3982 | 0.3991 | 1857352.0 |
| 2003-09-10 10:25:00 | AAPL | Stock | 0.3991 | 0.3996 | 0.3991 | 0.3996 | 1271200.0 |
| 2003-09-10 10:30:00 | AAPL | Stock | 0.3996 | 0.4013 | 0.3995 | 0.4002 | 1756048.0 |
| 2003-09-10 10:35:00 | AAPL | Stock | 0.4002 | 0.4014 | 0.3996 | 0.4014 | 3773000.0 |
| 2003-09-10 10:40:00 | AAPL | Stock | 0.4013 | 0.4016 | 0.4007 | 0.4014 | 1403080.0 |
| 2003-09-10 10:45:00 | AAPL | Stock | 0.4013 | 0.4013 | 0.4007 | 0.4013 | 1192800.0 |
| 2003-09-10 10:50:00 | AAPL | Stock | 0.4013 | 0.4029 | 0.4009 | 0.4013 | 991088.0 |
| 2003-09-10 10:55:00 | AAPL | Stock | 0.4013 | 0.402 | 0.4007 | 0.4018 | 772800.0 |
| 2003-09-10 11:00:00 | AAPL | Stock | 0.4014 | 0.4029 | 0.4014 | 0.4016 | 2787624.0 |
| 2003-09-10 11:05:00 | AAPL | Stock | 0.4014 | 0.4016 | 0.4005 | 0.4014 | 901544.0 |
| 2003-09-10 11:10:00 | AAPL | Stock | 0.4013 | 0.4023 | 0.4007 | 0.4023 | 1804880.0 |
| 2003-09-10 11:15:00 | AAPL | Stock | 0.4023 | 0.4027 | 0.4023 | 0.4027 | 547512.0 |
| 2003-09-10 11:20:00 | AAPL | Stock | 0.4021 | 0.4025 | 0.4021 | 0.4025 | 545888.0 |
| 2003-09-10 11:25:00 | AAPL | Stock | 0.4023 | 0.4025 | 0.4014 | 0.4014 | 1368416.0 |
| 2003-09-10 11:30:00 | AAPL | Stock | 0.4014 | 0.4016 | 0.3995 | 0.3996 | 4623976.0 |
| 2003-09-10 11:35:00 | AAPL | Stock | 0.4 | 0.4002 | 0.3995 | 0.4002 | 716800.0 |
| 2003-09-10 11:40:00 | AAPL | Stock | 0.4004 | 0.4005 | 0.3997 | 0.3997 | 1159200.0 |
| 2003-09-10 11:45:00 | AAPL | Stock | 0.4002 | 0.4002 | 0.3993 | 0.3993 | 352800.0 |
| 2003-09-10 11:50:00 | AAPL | Stock | 0.3993 | 0.3996 | 0.3986 | 0.3989 | 1898400.0 |
| 2003-09-10 11:55:00 | AAPL | Stock | 0.3988 | 0.4007 | 0.3988 | 0.4007 | 1127672.0 |
| 2003-09-10 12:00:00 | AAPL | Stock | 0.4005 | 0.4007 | 0.4 | 0.4002 | 1301440.0 |
| 2003-09-10 12:05:00 | AAPL | Stock | 0.4002 | 0.402 | 0.4002 | 0.4014 | 1692096.0 |
| 2003-09-10 12:10:00 | AAPL | Stock | 0.4014 | 0.402 | 0.4014 | 0.4018 | 929824.0 |
| 2003-09-10 12:15:00 | AAPL | Stock | 0.402 | 0.402 | 0.4014 | 0.4016 | 1136800.0 |
| 2003-09-10 12:20:00 | AAPL | Stock | 0.4016 | 0.4016 | 0.4005 | 0.4014 | 1960000.0 |
| 2003-09-10 12:25:00 | AAPL | Stock | 0.4014 | 0.4016 | 0.4011 | 0.4011 | 196000.0 |
| 2003-09-10 12:30:00 | AAPL | Stock | 0.4011 | 0.4011 | 0.4005 | 0.4005 | 582400.0 |
| 2003-09-10 12:35:00 | AAPL | Stock | 0.4007 | 0.4025 | 0.4005 | 0.4023 | 1506400.0 |
| 2003-09-10 12:40:00 | AAPL | Stock | 0.4021 | 0.4021 | 0.4013 | 0.402 | 1080016.0 |
| 2003-09-10 12:45:00 | AAPL | Stock | 0.4021 | 0.4021 | 0.4016 | 0.4016 | 1092000.0 |
| 2003-09-10 12:50:00 | AAPL | Stock | 0.4016 | 0.4016 | 0.4013 | 0.4013 | 112000.0 |
| 2003-09-10 12:55:00 | AAPL | Stock | 0.4013 | 0.4014 | 0.4007 | 0.4013 | 828800.0 |
| 2003-09-10 13:00:00 | AAPL | Stock | 0.4013 | 0.4025 | 0.4013 | 0.4025 | 787360.0 |
| 2003-09-10 13:05:00 | AAPL | Stock | 0.4025 | 0.4029 | 0.4021 | 0.4025 | 324800.0 |
| 2003-09-10 13:10:00 | AAPL | Stock | 0.4021 | 0.4025 | 0.4021 | 0.4023 | 297528.0 |
| 2003-09-10 13:15:00 | AAPL | Stock | 0.4023 | 0.4023 | 0.4016 | 0.4018 | 1226400.0 |
> showing 50 of 157,207 rows — these rows as CSV