PREVIEW / stock_5min / 2004-01-05
file: by_date/stock_5min/2004/2004-01-05.parquet size: 2.4 MB rows: 175,461 symbols: 1,718
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-01-05 08:25:00 | AAPL | Stock | 0.3813 | 0.3841 | 0.3813 | 0.3841 | 67200.0 |
| 2004-01-05 08:35:00 | AAPL | Stock | 0.3848 | 0.3848 | 0.3848 | 0.3848 | 5600.0 |
| 2004-01-05 08:45:00 | AAPL | Stock | 0.3813 | 0.3813 | 0.3813 | 0.3813 | 21168.0 |
| 2004-01-05 08:55:00 | AAPL | Stock | 0.3839 | 0.3839 | 0.3839 | 0.3839 | 100800.0 |
| 2004-01-05 09:10:00 | AAPL | Stock | 0.3839 | 0.3839 | 0.3839 | 0.3839 | 151200.0 |
| 2004-01-05 09:15:00 | AAPL | Stock | 0.3866 | 0.3866 | 0.3866 | 0.3866 | 28000.0 |
| 2004-01-05 09:20:00 | AAPL | Stock | 0.3839 | 0.3839 | 0.38 | 0.3813 | 219632.0 |
| 2004-01-05 09:25:00 | AAPL | Stock | 0.383 | 0.3845 | 0.3818 | 0.3839 | 403200.0 |
| 2004-01-05 09:30:00 | AAPL | Stock | 0.3841 | 0.3871 | 0.3839 | 0.3848 | 9833432.0 |
| 2004-01-05 09:35:00 | AAPL | Stock | 0.3849 | 0.3868 | 0.3839 | 0.3856 | 5966072.0 |
| 2004-01-05 09:40:00 | AAPL | Stock | 0.3856 | 0.3866 | 0.3846 | 0.3846 | 2598624.0 |
| 2004-01-05 09:45:00 | AAPL | Stock | 0.3846 | 0.3864 | 0.3846 | 0.3863 | 2290960.0 |
| 2004-01-05 09:50:00 | AAPL | Stock | 0.3863 | 0.3868 | 0.3861 | 0.3868 | 2251088.0 |
| 2004-01-05 09:55:00 | AAPL | Stock | 0.3867 | 0.388 | 0.3866 | 0.3875 | 3964688.0 |
| 2004-01-05 10:00:00 | AAPL | Stock | 0.3875 | 0.388 | 0.3861 | 0.3877 | 2663976.0 |
| 2004-01-05 10:05:00 | AAPL | Stock | 0.3879 | 0.3879 | 0.3875 | 0.3875 | 2597336.0 |
| 2004-01-05 10:10:00 | AAPL | Stock | 0.387 | 0.388 | 0.3868 | 0.3877 | 4209464.0 |
| 2004-01-05 10:15:00 | AAPL | Stock | 0.3875 | 0.3893 | 0.3875 | 0.3882 | 3544688.0 |
| 2004-01-05 10:20:00 | AAPL | Stock | 0.3882 | 0.3886 | 0.3875 | 0.3882 | 2718184.0 |
| 2004-01-05 10:25:00 | AAPL | Stock | 0.3884 | 0.3891 | 0.3879 | 0.3888 | 2185512.0 |
| 2004-01-05 10:30:00 | AAPL | Stock | 0.3888 | 0.3888 | 0.3879 | 0.3882 | 1524768.0 |
| 2004-01-05 10:35:00 | AAPL | Stock | 0.3884 | 0.3898 | 0.3877 | 0.3896 | 6080032.0 |
| 2004-01-05 10:40:00 | AAPL | Stock | 0.3898 | 0.3929 | 0.3893 | 0.3927 | 10349472.0 |
| 2004-01-05 10:45:00 | AAPL | Stock | 0.3923 | 0.3927 | 0.3916 | 0.3921 | 2945264.0 |
| 2004-01-05 10:50:00 | AAPL | Stock | 0.3921 | 0.3927 | 0.3918 | 0.3923 | 3642520.0 |
| 2004-01-05 10:55:00 | AAPL | Stock | 0.3927 | 0.3929 | 0.3923 | 0.3929 | 7910672.0 |
| 2004-01-05 11:00:00 | AAPL | Stock | 0.3927 | 0.3938 | 0.3927 | 0.3936 | 6232688.0 |
| 2004-01-05 11:05:00 | AAPL | Stock | 0.3936 | 0.3939 | 0.3932 | 0.3932 | 6360144.0 |
| 2004-01-05 11:10:00 | AAPL | Stock | 0.3934 | 0.3938 | 0.3932 | 0.3934 | 2779336.0 |
| 2004-01-05 11:15:00 | AAPL | Stock | 0.3934 | 0.3936 | 0.3921 | 0.3921 | 6633984.0 |
| 2004-01-05 11:20:00 | AAPL | Stock | 0.392 | 0.3925 | 0.3918 | 0.3918 | 1760248.0 |
| 2004-01-05 11:25:00 | AAPL | Stock | 0.3918 | 0.3923 | 0.3918 | 0.3921 | 4669280.0 |
| 2004-01-05 11:30:00 | AAPL | Stock | 0.3921 | 0.3921 | 0.3916 | 0.392 | 1942808.0 |
| 2004-01-05 11:35:00 | AAPL | Stock | 0.392 | 0.392 | 0.3914 | 0.3918 | 1924776.0 |
| 2004-01-05 11:40:00 | AAPL | Stock | 0.3918 | 0.392 | 0.3918 | 0.392 | 518392.0 |
| 2004-01-05 11:45:00 | AAPL | Stock | 0.3918 | 0.3923 | 0.3916 | 0.3923 | 1601488.0 |
| 2004-01-05 11:50:00 | AAPL | Stock | 0.3923 | 0.3929 | 0.3921 | 0.3929 | 5009312.0 |
| 2004-01-05 11:55:00 | AAPL | Stock | 0.393 | 0.393 | 0.3923 | 0.3929 | 12798856.0 |
| 2004-01-05 12:00:00 | AAPL | Stock | 0.3929 | 0.3971 | 0.3929 | 0.3966 | 11974984.0 |
| 2004-01-05 12:05:00 | AAPL | Stock | 0.3963 | 0.397 | 0.3962 | 0.3968 | 5790120.0 |
| 2004-01-05 12:10:00 | AAPL | Stock | 0.3968 | 0.3971 | 0.3966 | 0.397 | 3445680.0 |
| 2004-01-05 12:15:00 | AAPL | Stock | 0.3968 | 0.3971 | 0.3968 | 0.3968 | 8618568.0 |
| 2004-01-05 12:20:00 | AAPL | Stock | 0.3968 | 0.3988 | 0.3966 | 0.3984 | 15974952.0 |
| 2004-01-05 12:25:00 | AAPL | Stock | 0.3984 | 0.3998 | 0.3984 | 0.3991 | 6294344.0 |
| 2004-01-05 12:30:00 | AAPL | Stock | 0.3993 | 0.3996 | 0.3982 | 0.3986 | 7027328.0 |
| 2004-01-05 12:35:00 | AAPL | Stock | 0.3988 | 0.3995 | 0.3984 | 0.3991 | 4179392.0 |
| 2004-01-05 12:40:00 | AAPL | Stock | 0.3989 | 0.3996 | 0.3986 | 0.3996 | 4942168.0 |
| 2004-01-05 12:45:00 | AAPL | Stock | 0.3993 | 0.3993 | 0.3984 | 0.3984 | 1093232.0 |
| 2004-01-05 12:50:00 | AAPL | Stock | 0.3986 | 0.3991 | 0.3984 | 0.3991 | 2019584.0 |
| 2004-01-05 12:55:00 | AAPL | Stock | 0.3991 | 0.3996 | 0.3991 | 0.3995 | 5834192.0 |
> showing 50 of 175,461 rows — these rows as CSV