PREVIEW / stock_5min / 2007-05-04
file: by_date/stock_5min/2007/2007-05-04.parquet size: 3.7 MB rows: 274,265 symbols: 2,702
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-05-04 09:30:00 | AAPL | Stock | 3.6 | 3.6071 | 3.5893 | 3.5918 | 14331520.0 |
| 2007-05-04 09:35:00 | AAPL | Stock | 3.5936 | 3.5996 | 3.5911 | 3.5996 | 10103576.0 |
| 2007-05-04 09:40:00 | AAPL | Stock | 3.5996 | 3.6111 | 3.5964 | 3.6036 | 12431104.0 |
| 2007-05-04 09:45:00 | AAPL | Stock | 3.6036 | 3.6054 | 3.5964 | 3.5986 | 5818008.0 |
| 2007-05-04 09:50:00 | AAPL | Stock | 3.5993 | 3.6029 | 3.5961 | 3.5989 | 6906424.0 |
| 2007-05-04 09:55:00 | AAPL | Stock | 3.5993 | 3.6021 | 3.5971 | 3.5986 | 3402196.0 |
| 2007-05-04 10:00:00 | AAPL | Stock | 3.5989 | 3.6057 | 3.5954 | 3.6025 | 9880080.0 |
| 2007-05-04 10:05:00 | AAPL | Stock | 3.6025 | 3.6054 | 3.6017 | 3.6036 | 4217920.0 |
| 2007-05-04 10:10:00 | AAPL | Stock | 3.6032 | 3.6107 | 3.6032 | 3.6104 | 7998704.0 |
| 2007-05-04 10:15:00 | AAPL | Stock | 3.6107 | 3.6161 | 3.6079 | 3.615 | 9009532.0 |
| 2007-05-04 10:20:00 | AAPL | Stock | 3.6154 | 3.6186 | 3.6107 | 3.6175 | 10249456.0 |
| 2007-05-04 10:25:00 | AAPL | Stock | 3.6179 | 3.6214 | 3.615 | 3.6157 | 8868888.0 |
| 2007-05-04 10:30:00 | AAPL | Stock | 3.6157 | 3.6164 | 3.61 | 3.6107 | 6691216.0 |
| 2007-05-04 10:35:00 | AAPL | Stock | 3.6107 | 3.6139 | 3.6089 | 3.6107 | 4694284.0 |
| 2007-05-04 10:40:00 | AAPL | Stock | 3.6104 | 3.6143 | 3.61 | 3.6139 | 4811408.0 |
| 2007-05-04 10:45:00 | AAPL | Stock | 3.6143 | 3.6168 | 3.6129 | 3.6164 | 4292540.0 |
| 2007-05-04 10:50:00 | AAPL | Stock | 3.6167 | 3.6175 | 3.6089 | 3.61 | 7662592.0 |
| 2007-05-04 10:55:00 | AAPL | Stock | 3.61 | 3.6286 | 3.6054 | 3.6054 | 6715464.0 |
| 2007-05-04 11:00:00 | AAPL | Stock | 3.6057 | 3.61 | 3.605 | 3.6082 | 5485004.0 |
| 2007-05-04 11:05:00 | AAPL | Stock | 3.6086 | 3.6089 | 3.6018 | 3.605 | 4530904.0 |
| 2007-05-04 11:10:00 | AAPL | Stock | 3.6054 | 3.6064 | 3.6024 | 3.6043 | 3167360.0 |
| 2007-05-04 11:15:00 | AAPL | Stock | 3.6046 | 3.6071 | 3.6036 | 3.6057 | 1897784.0 |
| 2007-05-04 11:20:00 | AAPL | Stock | 3.606 | 3.6086 | 3.6007 | 3.6085 | 3715180.0 |
| 2007-05-04 11:25:00 | AAPL | Stock | 3.6082 | 3.6096 | 3.6071 | 3.6082 | 3834432.0 |
| 2007-05-04 11:30:00 | AAPL | Stock | 3.6082 | 3.6082 | 3.6021 | 3.605 | 6796944.0 |
| 2007-05-04 11:35:00 | AAPL | Stock | 3.6046 | 3.6068 | 3.6004 | 3.6043 | 4567668.0 |
| 2007-05-04 11:40:00 | AAPL | Stock | 3.6036 | 3.6089 | 3.6036 | 3.6054 | 3719044.0 |
| 2007-05-04 11:45:00 | AAPL | Stock | 3.6061 | 3.6093 | 3.6057 | 3.6086 | 2693768.0 |
| 2007-05-04 11:50:00 | AAPL | Stock | 3.6093 | 3.6104 | 3.6064 | 3.6093 | 2387476.0 |
| 2007-05-04 11:55:00 | AAPL | Stock | 3.609 | 3.61 | 3.6054 | 3.6057 | 1606472.0 |
| 2007-05-04 12:00:00 | AAPL | Stock | 3.6061 | 3.6096 | 3.6057 | 3.6057 | 2426816.0 |
| 2007-05-04 12:05:00 | AAPL | Stock | 3.6054 | 3.6071 | 3.6046 | 3.6046 | 2216872.0 |
| 2007-05-04 12:10:00 | AAPL | Stock | 3.6054 | 3.6057 | 3.6001 | 3.6043 | 3298680.0 |
| 2007-05-04 12:15:00 | AAPL | Stock | 3.6046 | 3.6068 | 3.6018 | 3.6054 | 7975212.0 |
| 2007-05-04 12:20:00 | AAPL | Stock | 3.6054 | 3.6061 | 3.5961 | 3.5971 | 7716548.0 |
| 2007-05-04 12:25:00 | AAPL | Stock | 3.5968 | 3.5982 | 3.5918 | 3.5921 | 12571412.0 |
| 2007-05-04 12:30:00 | AAPL | Stock | 3.5916 | 3.5954 | 3.5914 | 3.5939 | 6094844.0 |
| 2007-05-04 12:35:00 | AAPL | Stock | 3.5943 | 3.5975 | 3.5921 | 3.5964 | 5037592.0 |
| 2007-05-04 12:40:00 | AAPL | Stock | 3.5961 | 3.5961 | 3.5929 | 3.5954 | 3601248.0 |
| 2007-05-04 12:45:00 | AAPL | Stock | 3.595 | 3.5979 | 3.5925 | 3.5954 | 3518564.0 |
| 2007-05-04 12:50:00 | AAPL | Stock | 3.595 | 3.5957 | 3.5929 | 3.5932 | 3739204.0 |
| 2007-05-04 12:55:00 | AAPL | Stock | 3.5932 | 3.5946 | 3.5929 | 3.5936 | 3533124.0 |
| 2007-05-04 13:00:00 | AAPL | Stock | 3.5939 | 3.6 | 3.5939 | 3.5986 | 3823568.0 |
| 2007-05-04 13:05:00 | AAPL | Stock | 3.5979 | 3.5996 | 3.5932 | 3.5996 | 4454436.0 |
| 2007-05-04 13:10:00 | AAPL | Stock | 3.5986 | 3.6 | 3.5985 | 3.5986 | 3126312.0 |
| 2007-05-04 13:15:00 | AAPL | Stock | 3.5987 | 3.5996 | 3.5968 | 3.5971 | 3628688.0 |
| 2007-05-04 13:20:00 | AAPL | Stock | 3.5971 | 3.5993 | 3.595 | 3.5986 | 3523296.0 |
| 2007-05-04 13:25:00 | AAPL | Stock | 3.5986 | 3.6014 | 3.5975 | 3.5986 | 3853556.0 |
| 2007-05-04 13:30:00 | AAPL | Stock | 3.5986 | 3.6011 | 3.5986 | 3.6 | 2705416.0 |
| 2007-05-04 13:35:00 | AAPL | Stock | 3.5996 | 3.6 | 3.5982 | 3.5989 | 2178064.0 |
> showing 50 of 274,265 rows — these rows as CSV