PREVIEW / stock_5min / 2008-09-19
file: by_date/stock_5min/2008/2008-09-19.parquet size: 5.0 MB rows: 347,236 symbols: 3,379
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 |
|---|---|---|---|---|---|---|---|
| 2008-09-19 07:00:00 | AAPL | Stock | 4.9464 | 4.9464 | 4.9325 | 4.9464 | 64400.0 |
| 2008-09-19 07:05:00 | AAPL | Stock | 4.9818 | 5.0107 | 4.9571 | 4.9821 | 216412.0 |
| 2008-09-19 07:10:00 | AAPL | Stock | 5.0 | 5.0357 | 4.9821 | 5.0357 | 211680.0 |
| 2008-09-19 07:15:00 | AAPL | Stock | 5.0179 | 5.0357 | 4.9289 | 4.9289 | 219380.0 |
| 2008-09-19 07:20:00 | AAPL | Stock | 4.9464 | 4.9989 | 4.9439 | 4.9989 | 58800.0 |
| 2008-09-19 07:25:00 | AAPL | Stock | 4.9989 | 4.9989 | 4.9989 | 4.9989 | 2800.0 |
| 2008-09-19 07:30:00 | AAPL | Stock | 4.9761 | 4.9989 | 4.9643 | 4.9857 | 36400.0 |
| 2008-09-19 07:35:00 | AAPL | Stock | 5.0 | 5.0536 | 5.0 | 5.0179 | 239120.0 |
| 2008-09-19 07:40:00 | AAPL | Stock | 5.0357 | 5.0357 | 5.0179 | 5.0354 | 41440.0 |
| 2008-09-19 07:45:00 | AAPL | Stock | 5.0179 | 5.0357 | 5.0179 | 5.0246 | 72100.0 |
| 2008-09-19 07:50:00 | AAPL | Stock | 5.0154 | 5.0161 | 4.9821 | 4.9893 | 162680.0 |
| 2008-09-19 07:55:00 | AAPL | Stock | 4.9996 | 5.0357 | 4.9996 | 5.0139 | 218400.0 |
| 2008-09-19 08:00:00 | AAPL | Stock | 5.0139 | 5.0536 | 4.9821 | 5.05 | 1387792.0 |
| 2008-09-19 08:05:00 | AAPL | Stock | 5.0475 | 5.0679 | 5.0354 | 5.0679 | 937748.0 |
| 2008-09-19 08:10:00 | AAPL | Stock | 5.0679 | 5.0825 | 5.0618 | 5.0704 | 1420776.0 |
| 2008-09-19 08:15:00 | AAPL | Stock | 5.0707 | 5.1036 | 5.0707 | 5.1032 | 771148.0 |
| 2008-09-19 08:20:00 | AAPL | Stock | 5.1036 | 5.1143 | 5.05 | 5.105 | 1677984.0 |
| 2008-09-19 08:25:00 | AAPL | Stock | 5.1039 | 5.1071 | 5.0707 | 5.1068 | 784504.0 |
| 2008-09-19 08:30:00 | AAPL | Stock | 5.1068 | 5.1371 | 5.0921 | 5.1214 | 1060220.0 |
| 2008-09-19 08:35:00 | AAPL | Stock | 5.1232 | 5.1304 | 5.1182 | 5.1232 | 812560.0 |
| 2008-09-19 08:40:00 | AAPL | Stock | 5.125 | 5.1304 | 5.1071 | 5.1286 | 624260.0 |
| 2008-09-19 08:45:00 | AAPL | Stock | 5.1261 | 5.1321 | 5.1161 | 5.125 | 1349180.0 |
| 2008-09-19 08:50:00 | AAPL | Stock | 5.1271 | 5.1411 | 5.1111 | 5.1179 | 1151808.0 |
| 2008-09-19 08:55:00 | AAPL | Stock | 5.1121 | 5.125 | 5.0893 | 5.1125 | 999516.0 |
| 2008-09-19 09:00:00 | AAPL | Stock | 5.1143 | 5.125 | 5.0779 | 5.1114 | 1946448.0 |
| 2008-09-19 09:05:00 | AAPL | Stock | 5.1154 | 5.1164 | 5.0968 | 5.0968 | 384440.0 |
| 2008-09-19 09:10:00 | AAPL | Stock | 5.0968 | 5.1068 | 5.0779 | 5.1004 | 843584.0 |
| 2008-09-19 09:15:00 | AAPL | Stock | 5.1018 | 5.1232 | 5.0896 | 5.1229 | 983360.0 |
| 2008-09-19 09:20:00 | AAPL | Stock | 5.1221 | 5.1707 | 5.1111 | 5.1664 | 2682484.0 |
| 2008-09-19 09:25:00 | AAPL | Stock | 5.1693 | 5.2143 | 5.0875 | 5.0979 | 8412208.0 |
| 2008-09-19 09:30:00 | AAPL | Stock | 5.0979 | 5.1136 | 4.8929 | 5.0971 | 193910808.0 |
| 2008-09-19 09:35:00 | AAPL | Stock | 5.0961 | 5.0975 | 5.0357 | 5.0454 | 36067080.0 |
| 2008-09-19 09:40:00 | AAPL | Stock | 5.0454 | 5.0914 | 5.0186 | 5.0757 | 43759464.0 |
| 2008-09-19 09:45:00 | AAPL | Stock | 5.0754 | 5.08 | 5.0 | 5.0025 | 33560212.0 |
| 2008-09-19 09:50:00 | AAPL | Stock | 5.0032 | 5.0346 | 4.9514 | 5.0168 | 25482884.0 |
| 2008-09-19 09:55:00 | AAPL | Stock | 5.0179 | 5.0625 | 4.9746 | 5.0157 | 27748532.0 |
| 2008-09-19 10:00:00 | AAPL | Stock | 5.015 | 5.0289 | 4.9764 | 4.9864 | 26291076.0 |
| 2008-09-19 10:05:00 | AAPL | Stock | 4.9864 | 5.0071 | 4.9425 | 4.96 | 26616716.0 |
| 2008-09-19 10:10:00 | AAPL | Stock | 4.9604 | 5.0 | 4.9425 | 4.9784 | 17981740.0 |
| 2008-09-19 10:15:00 | AAPL | Stock | 4.9779 | 5.0232 | 4.9775 | 5.0007 | 23804480.0 |
| 2008-09-19 10:20:00 | AAPL | Stock | 5.0011 | 5.0229 | 4.9893 | 5.0086 | 17160920.0 |
| 2008-09-19 10:25:00 | AAPL | Stock | 5.0089 | 5.0439 | 4.9975 | 5.0221 | 14949312.0 |
| 2008-09-19 10:30:00 | AAPL | Stock | 5.0218 | 5.0439 | 4.9971 | 5.0143 | 17095512.0 |
| 2008-09-19 10:35:00 | AAPL | Stock | 5.0143 | 5.0357 | 5.0046 | 5.0107 | 13326236.0 |
| 2008-09-19 10:40:00 | AAPL | Stock | 5.0107 | 5.0218 | 4.9975 | 5.0 | 12437488.0 |
| 2008-09-19 10:45:00 | AAPL | Stock | 5.0 | 5.0136 | 4.9739 | 4.9954 | 14878612.0 |
| 2008-09-19 10:50:00 | AAPL | Stock | 4.9957 | 5.0079 | 4.9886 | 4.9975 | 11049976.0 |
| 2008-09-19 10:55:00 | AAPL | Stock | 4.9971 | 5.0021 | 4.9679 | 4.9887 | 13706588.0 |
| 2008-09-19 11:00:00 | AAPL | Stock | 4.9889 | 5.0446 | 4.9843 | 5.0336 | 18971652.0 |
| 2008-09-19 11:05:00 | AAPL | Stock | 5.0357 | 5.065 | 5.0282 | 5.0621 | 18008396.0 |
> showing 50 of 347,236 rows — these rows as CSV