PREVIEW / stock_5min / 2004-01-06
file: by_date/stock_5min/2004/2004-01-06.parquet size: 2.4 MB rows: 171,295 symbols: 1,707
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-06 08:00:00 | AAPL | Stock | 0.3961 | 0.3961 | 0.3961 | 0.3961 | 44800.0 |
| 2004-01-06 08:10:00 | AAPL | Stock | 0.395 | 0.395 | 0.3943 | 0.3943 | 50400.0 |
| 2004-01-06 08:15:00 | AAPL | Stock | 0.3943 | 0.3964 | 0.3943 | 0.3964 | 106400.0 |
| 2004-01-06 08:20:00 | AAPL | Stock | 0.3954 | 0.3954 | 0.3954 | 0.3954 | 5600.0 |
| 2004-01-06 08:25:00 | AAPL | Stock | 0.3955 | 0.3955 | 0.3952 | 0.3952 | 56000.0 |
| 2004-01-06 08:40:00 | AAPL | Stock | 0.3959 | 0.3959 | 0.3959 | 0.3959 | 5600.0 |
| 2004-01-06 08:45:00 | AAPL | Stock | 0.3961 | 0.3961 | 0.3961 | 0.3961 | 128800.0 |
| 2004-01-06 08:50:00 | AAPL | Stock | 0.3959 | 0.3959 | 0.3959 | 0.3959 | 5600.0 |
| 2004-01-06 08:55:00 | AAPL | Stock | 0.3963 | 0.3973 | 0.3959 | 0.3973 | 274400.0 |
| 2004-01-06 09:00:00 | AAPL | Stock | 0.3964 | 0.3973 | 0.3964 | 0.3973 | 308000.0 |
| 2004-01-06 09:05:00 | AAPL | Stock | 0.3964 | 0.3973 | 0.3964 | 0.3973 | 112000.0 |
| 2004-01-06 09:10:00 | AAPL | Stock | 0.3966 | 0.3973 | 0.3963 | 0.3963 | 1366400.0 |
| 2004-01-06 09:20:00 | AAPL | Stock | 0.3973 | 0.3973 | 0.397 | 0.397 | 2912000.0 |
| 2004-01-06 09:25:00 | AAPL | Stock | 0.3968 | 0.3973 | 0.3964 | 0.397 | 1252944.0 |
| 2004-01-06 09:30:00 | AAPL | Stock | 0.3973 | 0.3991 | 0.3964 | 0.3968 | 18643408.0 |
| 2004-01-06 09:35:00 | AAPL | Stock | 0.397 | 0.397 | 0.393 | 0.393 | 11034520.0 |
| 2004-01-06 09:40:00 | AAPL | Stock | 0.393 | 0.3938 | 0.3889 | 0.3929 | 15173424.0 |
| 2004-01-06 09:45:00 | AAPL | Stock | 0.3929 | 0.393 | 0.3909 | 0.392 | 10756872.0 |
| 2004-01-06 09:50:00 | AAPL | Stock | 0.392 | 0.392 | 0.3911 | 0.3911 | 5693800.0 |
| 2004-01-06 09:55:00 | AAPL | Stock | 0.3911 | 0.3923 | 0.3905 | 0.3921 | 3638992.0 |
| 2004-01-06 10:00:00 | AAPL | Stock | 0.392 | 0.393 | 0.3913 | 0.3923 | 6049512.0 |
| 2004-01-06 10:05:00 | AAPL | Stock | 0.3923 | 0.3923 | 0.3877 | 0.3893 | 11251576.0 |
| 2004-01-06 10:10:00 | AAPL | Stock | 0.3893 | 0.3898 | 0.3888 | 0.3893 | 3637088.0 |
| 2004-01-06 10:15:00 | AAPL | Stock | 0.3889 | 0.3904 | 0.3889 | 0.3896 | 8525048.0 |
| 2004-01-06 10:20:00 | AAPL | Stock | 0.3898 | 0.3909 | 0.3898 | 0.3907 | 2864400.0 |
| 2004-01-06 10:25:00 | AAPL | Stock | 0.3909 | 0.3914 | 0.3905 | 0.3907 | 2523472.0 |
| 2004-01-06 10:30:00 | AAPL | Stock | 0.3909 | 0.3911 | 0.3905 | 0.3907 | 1747984.0 |
| 2004-01-06 10:35:00 | AAPL | Stock | 0.3907 | 0.3923 | 0.3907 | 0.392 | 2945096.0 |
| 2004-01-06 10:40:00 | AAPL | Stock | 0.392 | 0.3925 | 0.3909 | 0.3914 | 3454584.0 |
| 2004-01-06 10:45:00 | AAPL | Stock | 0.3914 | 0.3921 | 0.3913 | 0.392 | 923384.0 |
| 2004-01-06 10:50:00 | AAPL | Stock | 0.392 | 0.3925 | 0.3914 | 0.392 | 1903720.0 |
| 2004-01-06 10:55:00 | AAPL | Stock | 0.3921 | 0.3925 | 0.3916 | 0.392 | 3347120.0 |
| 2004-01-06 11:00:00 | AAPL | Stock | 0.392 | 0.3925 | 0.3918 | 0.3925 | 1726032.0 |
| 2004-01-06 11:05:00 | AAPL | Stock | 0.3923 | 0.3925 | 0.3923 | 0.3923 | 1508136.0 |
| 2004-01-06 11:10:00 | AAPL | Stock | 0.3923 | 0.3925 | 0.3921 | 0.3923 | 5530168.0 |
| 2004-01-06 11:15:00 | AAPL | Stock | 0.3925 | 0.395 | 0.3923 | 0.3948 | 16645384.0 |
| 2004-01-06 11:20:00 | AAPL | Stock | 0.3952 | 0.397 | 0.3946 | 0.3961 | 23386888.0 |
| 2004-01-06 11:25:00 | AAPL | Stock | 0.3964 | 0.3964 | 0.3957 | 0.3964 | 8633128.0 |
| 2004-01-06 11:30:00 | AAPL | Stock | 0.3964 | 0.3975 | 0.3963 | 0.3973 | 4832184.0 |
| 2004-01-06 11:35:00 | AAPL | Stock | 0.3971 | 0.3973 | 0.3964 | 0.3964 | 4642120.0 |
| 2004-01-06 11:40:00 | AAPL | Stock | 0.3966 | 0.3973 | 0.3961 | 0.3964 | 5250616.0 |
| 2004-01-06 11:45:00 | AAPL | Stock | 0.3966 | 0.3975 | 0.3964 | 0.3975 | 4555152.0 |
| 2004-01-06 11:50:00 | AAPL | Stock | 0.3975 | 0.3982 | 0.3971 | 0.3975 | 5404504.0 |
| 2004-01-06 11:55:00 | AAPL | Stock | 0.3973 | 0.3977 | 0.3968 | 0.3973 | 4356016.0 |
| 2004-01-06 12:00:00 | AAPL | Stock | 0.397 | 0.3979 | 0.397 | 0.3978 | 2508912.0 |
| 2004-01-06 12:05:00 | AAPL | Stock | 0.3978 | 0.3979 | 0.3972 | 0.3979 | 2770320.0 |
| 2004-01-06 12:10:00 | AAPL | Stock | 0.3979 | 0.3988 | 0.3975 | 0.3982 | 7386904.0 |
| 2004-01-06 12:15:00 | AAPL | Stock | 0.3982 | 0.4002 | 0.3979 | 0.4 | 5834528.0 |
| 2004-01-06 12:20:00 | AAPL | Stock | 0.4 | 0.4004 | 0.3986 | 0.3993 | 4396000.0 |
| 2004-01-06 12:25:00 | AAPL | Stock | 0.3995 | 0.3995 | 0.3982 | 0.3988 | 4672080.0 |
> showing 50 of 171,295 rows — these rows as CSV