PREVIEW / stock_5min / 2007-06-20
file: by_date/stock_5min/2007/2007-06-20.parquet size: 4.0 MB rows: 293,645 symbols: 3,022
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 |
|---|---|---|---|---|---|---|---|
| 2007-06-20 09:30:00 | AAPL | Stock | 4.4239 | 4.4521 | 4.4093 | 4.4143 | 31452176.0 |
| 2007-06-20 09:35:00 | AAPL | Stock | 4.4139 | 4.4357 | 4.4111 | 4.4275 | 21396032.0 |
| 2007-06-20 09:40:00 | AAPL | Stock | 4.4271 | 4.4379 | 4.4236 | 4.4275 | 18072572.0 |
| 2007-06-20 09:45:00 | AAPL | Stock | 4.4279 | 4.4286 | 4.3964 | 4.3996 | 22891232.0 |
| 2007-06-20 09:50:00 | AAPL | Stock | 4.4 | 4.4107 | 4.3971 | 4.4089 | 16167032.0 |
| 2007-06-20 09:55:00 | AAPL | Stock | 4.4089 | 4.4143 | 4.4018 | 4.4021 | 10108196.0 |
| 2007-06-20 10:00:00 | AAPL | Stock | 4.4021 | 4.4057 | 4.3964 | 4.4004 | 17594192.0 |
| 2007-06-20 10:05:00 | AAPL | Stock | 4.4007 | 4.4054 | 4.3871 | 4.3904 | 20852300.0 |
| 2007-06-20 10:10:00 | AAPL | Stock | 4.3904 | 4.3964 | 4.3821 | 4.3925 | 20965140.0 |
| 2007-06-20 10:15:00 | AAPL | Stock | 4.3921 | 4.3993 | 4.3829 | 4.3889 | 16112992.0 |
| 2007-06-20 10:20:00 | AAPL | Stock | 4.3893 | 4.3929 | 4.3696 | 4.375 | 20936636.0 |
| 2007-06-20 10:25:00 | AAPL | Stock | 4.3729 | 4.3786 | 4.3607 | 4.3764 | 22686300.0 |
| 2007-06-20 10:30:00 | AAPL | Stock | 4.3764 | 4.3964 | 4.375 | 4.3929 | 19794376.0 |
| 2007-06-20 10:35:00 | AAPL | Stock | 4.3936 | 4.4 | 4.3857 | 4.3964 | 13276452.0 |
| 2007-06-20 10:40:00 | AAPL | Stock | 4.3964 | 4.4082 | 4.3943 | 4.4029 | 11573800.0 |
| 2007-06-20 10:45:00 | AAPL | Stock | 4.4029 | 4.4039 | 4.3954 | 4.4025 | 11650996.0 |
| 2007-06-20 10:50:00 | AAPL | Stock | 4.4029 | 4.4036 | 4.3939 | 4.3995 | 7438368.0 |
| 2007-06-20 10:55:00 | AAPL | Stock | 4.3986 | 4.4036 | 4.3982 | 4.4011 | 5829012.0 |
| 2007-06-20 11:00:00 | AAPL | Stock | 4.4008 | 4.4025 | 4.3914 | 4.3918 | 8117312.0 |
| 2007-06-20 11:05:00 | AAPL | Stock | 4.3921 | 4.3929 | 4.3829 | 4.3869 | 11125604.0 |
| 2007-06-20 11:10:00 | AAPL | Stock | 4.3871 | 4.4014 | 4.3868 | 4.3925 | 9285808.0 |
| 2007-06-20 11:15:00 | AAPL | Stock | 4.3921 | 4.3961 | 4.385 | 4.3875 | 6832476.0 |
| 2007-06-20 11:20:00 | AAPL | Stock | 4.3875 | 4.3893 | 4.3714 | 4.3789 | 17502464.0 |
| 2007-06-20 11:25:00 | AAPL | Stock | 4.3796 | 4.3921 | 4.3768 | 4.3871 | 13470996.0 |
| 2007-06-20 11:30:00 | AAPL | Stock | 4.3871 | 4.3896 | 4.3829 | 4.3871 | 7867496.0 |
| 2007-06-20 11:35:00 | AAPL | Stock | 4.3879 | 4.39 | 4.3807 | 4.3868 | 9849056.0 |
| 2007-06-20 11:40:00 | AAPL | Stock | 4.3868 | 4.3957 | 4.385 | 4.3914 | 9068696.0 |
| 2007-06-20 11:45:00 | AAPL | Stock | 4.3911 | 4.3946 | 4.3864 | 4.3925 | 6395480.0 |
| 2007-06-20 11:50:00 | AAPL | Stock | 4.3925 | 4.3986 | 4.3879 | 4.3975 | 7505596.0 |
| 2007-06-20 11:55:00 | AAPL | Stock | 4.3975 | 4.3996 | 4.3889 | 4.3964 | 9454088.0 |
| 2007-06-20 12:00:00 | AAPL | Stock | 4.3964 | 4.3989 | 4.3839 | 4.3918 | 5828088.0 |
| 2007-06-20 12:05:00 | AAPL | Stock | 4.3921 | 4.4046 | 4.3839 | 4.4011 | 11987948.0 |
| 2007-06-20 12:10:00 | AAPL | Stock | 4.4007 | 4.4068 | 4.3846 | 4.4018 | 9289056.0 |
| 2007-06-20 12:15:00 | AAPL | Stock | 4.4018 | 4.4057 | 4.3975 | 4.4 | 5919760.0 |
| 2007-06-20 12:20:00 | AAPL | Stock | 4.4 | 4.4086 | 4.4 | 4.4021 | 7732760.0 |
| 2007-06-20 12:25:00 | AAPL | Stock | 4.4018 | 4.4054 | 4.3982 | 4.3996 | 4021388.0 |
| 2007-06-20 12:30:00 | AAPL | Stock | 4.3996 | 4.4064 | 4.3979 | 4.4054 | 4209492.0 |
| 2007-06-20 12:35:00 | AAPL | Stock | 4.4054 | 4.41 | 4.4036 | 4.4043 | 4367552.0 |
| 2007-06-20 12:40:00 | AAPL | Stock | 4.4039 | 4.4046 | 4.3932 | 4.3971 | 6710928.0 |
| 2007-06-20 12:45:00 | AAPL | Stock | 4.3975 | 4.3979 | 4.3939 | 4.3975 | 2945516.0 |
| 2007-06-20 12:50:00 | AAPL | Stock | 4.3971 | 4.3986 | 4.3911 | 4.3911 | 5546828.0 |
| 2007-06-20 12:55:00 | AAPL | Stock | 4.3911 | 4.3921 | 4.3886 | 4.3886 | 4644864.0 |
| 2007-06-20 13:00:00 | AAPL | Stock | 4.3882 | 4.39 | 4.3832 | 4.3882 | 5964952.0 |
| 2007-06-20 13:05:00 | AAPL | Stock | 4.3882 | 4.3882 | 4.3789 | 4.3789 | 5682264.0 |
| 2007-06-20 13:10:00 | AAPL | Stock | 4.3796 | 4.3814 | 4.3664 | 4.3689 | 14701372.0 |
| 2007-06-20 13:15:00 | AAPL | Stock | 4.3693 | 4.3739 | 4.3661 | 4.3689 | 10288012.0 |
| 2007-06-20 13:20:00 | AAPL | Stock | 4.3689 | 4.3718 | 4.3511 | 4.3543 | 17561124.0 |
| 2007-06-20 13:25:00 | AAPL | Stock | 4.3543 | 4.3711 | 4.3518 | 4.3711 | 16761808.0 |
| 2007-06-20 13:30:00 | AAPL | Stock | 4.3714 | 4.4061 | 4.3686 | 4.3707 | 11839772.0 |
| 2007-06-20 13:35:00 | AAPL | Stock | 4.3704 | 4.38 | 4.3671 | 4.3786 | 9374008.0 |
> showing 50 of 293,645 rows — these rows as CSV