PREVIEW / stock_5min / 2006-08-04
file: by_date/stock_5min/2006/2006-08-04.parquet size: 3.1 MB rows: 227,248 symbols: 2,311
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 |
|---|---|---|---|---|---|---|---|
| 2006-08-04 04:05:00 | AAPL | Stock | 2.3018 | 2.3018 | 2.3 | 2.3 | 47600.0 |
| 2006-08-04 04:15:00 | AAPL | Stock | 2.2968 | 2.3214 | 2.2968 | 2.3179 | 179228.0 |
| 2006-08-04 04:20:00 | AAPL | Stock | 2.3211 | 2.3214 | 2.3107 | 2.3107 | 183456.0 |
| 2006-08-04 04:25:00 | AAPL | Stock | 2.3107 | 2.3107 | 2.3107 | 2.3107 | 95200.0 |
| 2006-08-04 04:30:00 | AAPL | Stock | 2.3036 | 2.3036 | 2.3036 | 2.3036 | 30800.0 |
| 2006-08-04 04:35:00 | AAPL | Stock | 2.3036 | 2.3036 | 2.3036 | 2.3036 | 28000.0 |
| 2006-08-04 04:40:00 | AAPL | Stock | 2.3104 | 2.3104 | 2.3036 | 2.3036 | 79856.0 |
| 2006-08-04 04:45:00 | AAPL | Stock | 2.3011 | 2.3011 | 2.3011 | 2.3011 | 30800.0 |
| 2006-08-04 04:55:00 | AAPL | Stock | 2.2964 | 2.2964 | 2.2964 | 2.2964 | 28000.0 |
| 2006-08-04 05:00:00 | AAPL | Stock | 2.2929 | 2.2929 | 2.2882 | 2.2893 | 84000.0 |
| 2006-08-04 05:20:00 | AAPL | Stock | 2.2946 | 2.2946 | 2.2946 | 2.2946 | 8400.0 |
| 2006-08-04 05:25:00 | AAPL | Stock | 2.2964 | 2.2964 | 2.2964 | 2.2964 | 18172.0 |
| 2006-08-04 05:35:00 | AAPL | Stock | 2.2982 | 2.3 | 2.2982 | 2.3 | 13804.0 |
| 2006-08-04 05:45:00 | AAPL | Stock | 2.2993 | 2.2993 | 2.2993 | 2.2993 | 29428.0 |
| 2006-08-04 05:50:00 | AAPL | Stock | 2.3 | 2.3018 | 2.3 | 2.3018 | 16800.0 |
| 2006-08-04 05:55:00 | AAPL | Stock | 2.3089 | 2.3143 | 2.3089 | 2.3125 | 33600.0 |
| 2006-08-04 06:30:00 | AAPL | Stock | 2.3089 | 2.3089 | 2.3036 | 2.3036 | 14000.0 |
| 2006-08-04 06:40:00 | AAPL | Stock | 2.3071 | 2.3071 | 2.3071 | 2.3071 | 14000.0 |
| 2006-08-04 06:45:00 | AAPL | Stock | 2.3071 | 2.3161 | 2.3071 | 2.3161 | 16800.0 |
| 2006-08-04 06:50:00 | AAPL | Stock | 2.3071 | 2.3071 | 2.3071 | 2.3071 | 11200.0 |
| 2006-08-04 06:55:00 | AAPL | Stock | 2.3071 | 2.3125 | 2.3036 | 2.3036 | 60144.0 |
| 2006-08-04 07:00:00 | AAPL | Stock | 2.3036 | 2.3536 | 2.3036 | 2.3464 | 560532.0 |
| 2006-08-04 07:05:00 | AAPL | Stock | 2.3464 | 2.3664 | 2.3411 | 2.3661 | 622468.0 |
| 2006-08-04 07:10:00 | AAPL | Stock | 2.3696 | 2.3857 | 2.3575 | 2.3589 | 501900.0 |
| 2006-08-04 07:15:00 | AAPL | Stock | 2.3543 | 2.3643 | 2.35 | 2.3575 | 589120.0 |
| 2006-08-04 07:20:00 | AAPL | Stock | 2.3643 | 2.3696 | 2.3607 | 2.3675 | 360640.0 |
| 2006-08-04 07:25:00 | AAPL | Stock | 2.365 | 2.3836 | 2.365 | 2.3764 | 259672.0 |
| 2006-08-04 07:30:00 | AAPL | Stock | 2.3764 | 2.3789 | 2.375 | 2.3764 | 160720.0 |
| 2006-08-04 07:35:00 | AAPL | Stock | 2.3811 | 2.3857 | 2.3764 | 2.3764 | 208600.0 |
| 2006-08-04 07:40:00 | AAPL | Stock | 2.3814 | 2.3814 | 2.3779 | 2.3779 | 19600.0 |
| 2006-08-04 07:45:00 | AAPL | Stock | 2.3804 | 2.3839 | 2.3786 | 2.3814 | 828800.0 |
| 2006-08-04 07:50:00 | AAPL | Stock | 2.3814 | 2.3964 | 2.3786 | 2.3964 | 1584240.0 |
| 2006-08-04 07:55:00 | AAPL | Stock | 2.3986 | 2.4071 | 2.3929 | 2.3964 | 909720.0 |
| 2006-08-04 08:00:00 | AAPL | Stock | 2.3982 | 2.4036 | 2.3839 | 2.3975 | 13155912.0 |
| 2006-08-04 08:05:00 | AAPL | Stock | 2.3975 | 2.3975 | 2.3804 | 2.385 | 3611692.0 |
| 2006-08-04 08:10:00 | AAPL | Stock | 2.3843 | 2.3929 | 2.3818 | 2.3857 | 3448312.0 |
| 2006-08-04 08:15:00 | AAPL | Stock | 2.3857 | 2.3954 | 2.3846 | 2.3939 | 2991016.0 |
| 2006-08-04 08:20:00 | AAPL | Stock | 2.3939 | 2.4036 | 2.3936 | 2.4036 | 4764788.0 |
| 2006-08-04 08:25:00 | AAPL | Stock | 2.4036 | 2.4071 | 2.3968 | 2.4004 | 6394948.0 |
| 2006-08-04 08:30:00 | AAPL | Stock | 2.4004 | 2.4032 | 2.3911 | 2.3996 | 9665572.0 |
| 2006-08-04 08:35:00 | AAPL | Stock | 2.4 | 2.4036 | 2.3971 | 2.4018 | 4970980.0 |
| 2006-08-04 08:40:00 | AAPL | Stock | 2.4014 | 2.4136 | 2.4011 | 2.41 | 9286424.0 |
| 2006-08-04 08:45:00 | AAPL | Stock | 2.4089 | 2.4114 | 2.4018 | 2.4054 | 4517912.0 |
| 2006-08-04 08:50:00 | AAPL | Stock | 2.4054 | 2.4086 | 2.4021 | 2.4046 | 3299156.0 |
| 2006-08-04 08:55:00 | AAPL | Stock | 2.4039 | 2.4118 | 2.4032 | 2.4107 | 3972164.0 |
| 2006-08-04 09:00:00 | AAPL | Stock | 2.4107 | 2.4107 | 2.4036 | 2.4036 | 3309964.0 |
| 2006-08-04 09:05:00 | AAPL | Stock | 2.4036 | 2.4064 | 2.4021 | 2.4021 | 5704468.0 |
| 2006-08-04 09:10:00 | AAPL | Stock | 2.4032 | 2.4036 | 2.3961 | 2.3979 | 6019720.0 |
| 2006-08-04 09:15:00 | AAPL | Stock | 2.3971 | 2.4 | 2.3939 | 2.3946 | 11901092.0 |
| 2006-08-04 09:20:00 | AAPL | Stock | 2.3943 | 2.3961 | 2.3893 | 2.3946 | 7499576.0 |
> showing 50 of 227,248 rows — these rows as CSV