PREVIEW / stock_5min / 2004-02-24
file: by_date/stock_5min/2004/2004-02-24.parquet size: 2.5 MB rows: 177,585 symbols: 1,728
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 |
|---|---|---|---|---|---|---|---|
| 2004-02-24 08:00:00 | AAPL | Stock | 0.3963 | 0.3963 | 0.3946 | 0.3946 | 44800.0 |
| 2004-02-24 08:15:00 | AAPL | Stock | 0.3957 | 0.3957 | 0.3957 | 0.3957 | 28000.0 |
| 2004-02-24 09:00:00 | AAPL | Stock | 0.3955 | 0.3955 | 0.3946 | 0.3946 | 36680.0 |
| 2004-02-24 09:10:00 | AAPL | Stock | 0.3955 | 0.3955 | 0.3946 | 0.3946 | 490280.0 |
| 2004-02-24 09:25:00 | AAPL | Stock | 0.3932 | 0.3957 | 0.393 | 0.395 | 699384.0 |
| 2004-02-24 09:30:00 | AAPL | Stock | 0.3954 | 0.3995 | 0.3945 | 0.3963 | 6453272.0 |
| 2004-02-24 09:35:00 | AAPL | Stock | 0.3961 | 0.3961 | 0.3941 | 0.3948 | 3992072.0 |
| 2004-02-24 09:40:00 | AAPL | Stock | 0.395 | 0.3973 | 0.3946 | 0.3953 | 3488464.0 |
| 2004-02-24 09:45:00 | AAPL | Stock | 0.3953 | 0.3975 | 0.3948 | 0.3973 | 1639400.0 |
| 2004-02-24 09:50:00 | AAPL | Stock | 0.3979 | 0.3993 | 0.3955 | 0.3973 | 4281536.0 |
| 2004-02-24 09:55:00 | AAPL | Stock | 0.3973 | 0.3982 | 0.3973 | 0.398 | 2413096.0 |
| 2004-02-24 10:00:00 | AAPL | Stock | 0.3979 | 0.3979 | 0.3943 | 0.3954 | 4941048.0 |
| 2004-02-24 10:05:00 | AAPL | Stock | 0.3952 | 0.3952 | 0.3929 | 0.3931 | 2104872.0 |
| 2004-02-24 10:10:00 | AAPL | Stock | 0.393 | 0.395 | 0.3929 | 0.395 | 1673896.0 |
| 2004-02-24 10:15:00 | AAPL | Stock | 0.395 | 0.3959 | 0.3948 | 0.395 | 2327472.0 |
| 2004-02-24 10:20:00 | AAPL | Stock | 0.395 | 0.3975 | 0.3946 | 0.397 | 8134112.0 |
| 2004-02-24 10:25:00 | AAPL | Stock | 0.3969 | 0.3984 | 0.3963 | 0.3982 | 3044832.0 |
| 2004-02-24 10:30:00 | AAPL | Stock | 0.3982 | 0.4002 | 0.3982 | 0.4 | 3318896.0 |
| 2004-02-24 10:35:00 | AAPL | Stock | 0.4 | 0.4002 | 0.3993 | 0.3995 | 1965600.0 |
| 2004-02-24 10:40:00 | AAPL | Stock | 0.3995 | 0.4012 | 0.3995 | 0.4007 | 2721880.0 |
| 2004-02-24 10:45:00 | AAPL | Stock | 0.4009 | 0.4029 | 0.4009 | 0.4021 | 3420312.0 |
| 2004-02-24 10:50:00 | AAPL | Stock | 0.402 | 0.402 | 0.4011 | 0.4018 | 4903248.0 |
| 2004-02-24 10:55:00 | AAPL | Stock | 0.4016 | 0.4025 | 0.4011 | 0.4018 | 3936912.0 |
| 2004-02-24 11:00:00 | AAPL | Stock | 0.4018 | 0.4025 | 0.4013 | 0.4018 | 5293736.0 |
| 2004-02-24 11:05:00 | AAPL | Stock | 0.4018 | 0.402 | 0.4016 | 0.4018 | 1654072.0 |
| 2004-02-24 11:10:00 | AAPL | Stock | 0.402 | 0.402 | 0.4004 | 0.4011 | 7404488.0 |
| 2004-02-24 11:15:00 | AAPL | Stock | 0.4011 | 0.4011 | 0.3996 | 0.4007 | 3240104.0 |
| 2004-02-24 11:20:00 | AAPL | Stock | 0.4007 | 0.4014 | 0.4005 | 0.4013 | 1281896.0 |
| 2004-02-24 11:25:00 | AAPL | Stock | 0.4011 | 0.4013 | 0.4007 | 0.4009 | 1199240.0 |
| 2004-02-24 11:30:00 | AAPL | Stock | 0.4009 | 0.4013 | 0.4007 | 0.4011 | 813400.0 |
| 2004-02-24 11:35:00 | AAPL | Stock | 0.4011 | 0.4013 | 0.4004 | 0.4012 | 712992.0 |
| 2004-02-24 11:40:00 | AAPL | Stock | 0.4013 | 0.4013 | 0.4005 | 0.4009 | 1008840.0 |
| 2004-02-24 11:45:00 | AAPL | Stock | 0.4007 | 0.4011 | 0.4004 | 0.4007 | 1135120.0 |
| 2004-02-24 11:50:00 | AAPL | Stock | 0.4006 | 0.4011 | 0.4006 | 0.4009 | 301168.0 |
| 2004-02-24 11:55:00 | AAPL | Stock | 0.4011 | 0.4018 | 0.4005 | 0.4018 | 2115456.0 |
| 2004-02-24 12:00:00 | AAPL | Stock | 0.4014 | 0.4021 | 0.4011 | 0.4018 | 957264.0 |
| 2004-02-24 12:05:00 | AAPL | Stock | 0.4018 | 0.402 | 0.4016 | 0.4016 | 1566376.0 |
| 2004-02-24 12:10:00 | AAPL | Stock | 0.4016 | 0.4023 | 0.4016 | 0.4023 | 1002344.0 |
| 2004-02-24 12:15:00 | AAPL | Stock | 0.4023 | 0.4027 | 0.4021 | 0.4023 | 1508248.0 |
| 2004-02-24 12:20:00 | AAPL | Stock | 0.4021 | 0.4029 | 0.4018 | 0.4027 | 1633520.0 |
| 2004-02-24 12:25:00 | AAPL | Stock | 0.4025 | 0.403 | 0.4025 | 0.4027 | 1342992.0 |
| 2004-02-24 12:30:00 | AAPL | Stock | 0.4027 | 0.4027 | 0.4021 | 0.4023 | 330400.0 |
| 2004-02-24 12:35:00 | AAPL | Stock | 0.4023 | 0.4025 | 0.4021 | 0.4023 | 201600.0 |
| 2004-02-24 12:40:00 | AAPL | Stock | 0.4023 | 0.4027 | 0.4023 | 0.4027 | 357336.0 |
| 2004-02-24 12:45:00 | AAPL | Stock | 0.4027 | 0.4036 | 0.4025 | 0.4036 | 2398200.0 |
| 2004-02-24 12:50:00 | AAPL | Stock | 0.4034 | 0.4048 | 0.4029 | 0.4045 | 2991296.0 |
| 2004-02-24 12:55:00 | AAPL | Stock | 0.4045 | 0.4059 | 0.4045 | 0.405 | 3117240.0 |
| 2004-02-24 13:00:00 | AAPL | Stock | 0.4048 | 0.405 | 0.4029 | 0.4029 | 1310400.0 |
| 2004-02-24 13:05:00 | AAPL | Stock | 0.4029 | 0.4045 | 0.4025 | 0.4041 | 1595776.0 |
| 2004-02-24 13:10:00 | AAPL | Stock | 0.4043 | 0.4045 | 0.4041 | 0.4041 | 858984.0 |
> showing 50 of 177,585 rows — these rows as CSV