PREVIEW / stock_1min / 2007-09-20
file: by_date/stock_1min/2007/2007-09-20.parquet size: 11.1 MB rows: 909,305 symbols: 2,553
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-09-20 09:30:00 | AAPL | Stock | 5.0054 | 5.0125 | 5.0029 | 5.0043 | 8869196.0 |
| 2007-09-20 09:31:00 | AAPL | Stock | 5.005 | 5.0064 | 4.9821 | 4.9854 | 4860436.0 |
| 2007-09-20 09:32:00 | AAPL | Stock | 4.9837 | 5.0 | 4.9837 | 5.0 | 2933644.0 |
| 2007-09-20 09:33:00 | AAPL | Stock | 5.0 | 5.0018 | 4.9889 | 4.991 | 5062932.0 |
| 2007-09-20 09:34:00 | AAPL | Stock | 4.9921 | 4.9986 | 4.9893 | 4.9954 | 3630788.0 |
| 2007-09-20 09:35:00 | AAPL | Stock | 4.995 | 5.0154 | 4.9943 | 5.014 | 4074000.0 |
| 2007-09-20 09:36:00 | AAPL | Stock | 5.0139 | 5.0143 | 5.0069 | 5.0107 | 2021292.0 |
| 2007-09-20 09:37:00 | AAPL | Stock | 5.01 | 5.0143 | 5.0057 | 5.0093 | 3090164.0 |
| 2007-09-20 09:38:00 | AAPL | Stock | 5.0094 | 5.0107 | 5.0039 | 5.0079 | 2030000.0 |
| 2007-09-20 09:39:00 | AAPL | Stock | 5.0079 | 5.0118 | 5.0036 | 5.0118 | 2929388.0 |
| 2007-09-20 09:40:00 | AAPL | Stock | 5.0111 | 5.0154 | 5.0104 | 5.0111 | 2779644.0 |
| 2007-09-20 09:41:00 | AAPL | Stock | 5.0129 | 5.0129 | 5.0018 | 5.0086 | 3126816.0 |
| 2007-09-20 09:42:00 | AAPL | Stock | 5.0079 | 5.0089 | 4.9993 | 5.0021 | 3538052.0 |
| 2007-09-20 09:43:00 | AAPL | Stock | 5.0021 | 5.0075 | 4.9939 | 4.9947 | 4598300.0 |
| 2007-09-20 09:44:00 | AAPL | Stock | 4.995 | 4.9989 | 4.9893 | 4.9957 | 2910908.0 |
| 2007-09-20 09:45:00 | AAPL | Stock | 4.9954 | 4.9954 | 4.9893 | 4.9929 | 2036440.0 |
| 2007-09-20 09:46:00 | AAPL | Stock | 4.9932 | 4.9982 | 4.9911 | 4.9925 | 2222724.0 |
| 2007-09-20 09:47:00 | AAPL | Stock | 4.9921 | 4.9957 | 4.9893 | 4.9896 | 2239468.0 |
| 2007-09-20 09:48:00 | AAPL | Stock | 4.991 | 4.9929 | 4.9786 | 4.9796 | 4195632.0 |
| 2007-09-20 09:49:00 | AAPL | Stock | 4.9796 | 4.9875 | 4.9757 | 4.9875 | 3967824.0 |
| 2007-09-20 09:50:00 | AAPL | Stock | 4.9875 | 4.9957 | 4.9875 | 4.9946 | 2793728.0 |
| 2007-09-20 09:51:00 | AAPL | Stock | 4.9943 | 4.9957 | 4.9882 | 4.9886 | 2361744.0 |
| 2007-09-20 09:52:00 | AAPL | Stock | 4.9889 | 4.9893 | 4.9843 | 4.9848 | 1626240.0 |
| 2007-09-20 09:53:00 | AAPL | Stock | 4.9843 | 4.9893 | 4.9821 | 4.9893 | 1709708.0 |
| 2007-09-20 09:54:00 | AAPL | Stock | 4.9893 | 4.9893 | 4.985 | 4.9879 | 1885548.0 |
| 2007-09-20 09:55:00 | AAPL | Stock | 4.9886 | 4.9889 | 4.9836 | 4.985 | 3664612.0 |
| 2007-09-20 09:56:00 | AAPL | Stock | 4.985 | 4.9871 | 4.9843 | 4.9854 | 1572284.0 |
| 2007-09-20 09:57:00 | AAPL | Stock | 4.985 | 4.9932 | 4.985 | 4.9915 | 2700404.0 |
| 2007-09-20 09:58:00 | AAPL | Stock | 4.9914 | 4.9914 | 4.9879 | 4.9907 | 1155308.0 |
| 2007-09-20 09:59:00 | AAPL | Stock | 4.9907 | 5.0 | 4.99 | 4.9939 | 3738700.0 |
| 2007-09-20 10:00:00 | AAPL | Stock | 4.9943 | 4.9954 | 4.9896 | 4.9904 | 2420740.0 |
| 2007-09-20 10:01:00 | AAPL | Stock | 4.9904 | 4.9979 | 4.99 | 4.9978 | 3426864.0 |
| 2007-09-20 10:02:00 | AAPL | Stock | 4.9975 | 4.9989 | 4.9929 | 4.9954 | 2446052.0 |
| 2007-09-20 10:03:00 | AAPL | Stock | 4.9954 | 5.0046 | 4.9929 | 5.0016 | 3284176.0 |
| 2007-09-20 10:04:00 | AAPL | Stock | 5.0 | 5.0064 | 4.9989 | 5.0061 | 3230640.0 |
| 2007-09-20 10:05:00 | AAPL | Stock | 5.0061 | 5.0089 | 5.0043 | 5.0069 | 2717260.0 |
| 2007-09-20 10:06:00 | AAPL | Stock | 5.0068 | 5.01 | 5.0046 | 5.0054 | 1960168.0 |
| 2007-09-20 10:07:00 | AAPL | Stock | 5.0054 | 5.015 | 5.0054 | 5.0146 | 2666188.0 |
| 2007-09-20 10:08:00 | AAPL | Stock | 5.0146 | 5.0179 | 5.0118 | 5.0171 | 4805668.0 |
| 2007-09-20 10:09:00 | AAPL | Stock | 5.0168 | 5.0193 | 5.0161 | 5.0164 | 2735936.0 |
| 2007-09-20 10:10:00 | AAPL | Stock | 5.0164 | 5.0239 | 5.015 | 5.0218 | 4114488.0 |
| 2007-09-20 10:11:00 | AAPL | Stock | 5.0221 | 5.0264 | 5.0196 | 5.0243 | 2656444.0 |
| 2007-09-20 10:12:00 | AAPL | Stock | 5.0239 | 5.025 | 5.0193 | 5.0229 | 4311440.0 |
| 2007-09-20 10:13:00 | AAPL | Stock | 5.0225 | 5.0268 | 5.0214 | 5.0267 | 2918776.0 |
| 2007-09-20 10:14:00 | AAPL | Stock | 5.0268 | 5.0339 | 5.0261 | 5.0325 | 6693764.0 |
| 2007-09-20 10:15:00 | AAPL | Stock | 5.0321 | 5.0339 | 5.0243 | 5.0261 | 4375056.0 |
| 2007-09-20 10:16:00 | AAPL | Stock | 5.0257 | 5.0321 | 5.025 | 5.0304 | 2094512.0 |
| 2007-09-20 10:17:00 | AAPL | Stock | 5.0304 | 5.0307 | 5.0246 | 5.025 | 1970052.0 |
| 2007-09-20 10:18:00 | AAPL | Stock | 5.0254 | 5.0257 | 5.0164 | 5.0182 | 3918404.0 |
| 2007-09-20 10:19:00 | AAPL | Stock | 5.0175 | 5.0218 | 5.0168 | 5.0175 | 1427244.0 |
> showing 50 of 909,305 rows — these rows as CSV