PREVIEW / stock_5min / 2008-05-12
file: by_date/stock_5min/2008/2008-05-12.parquet size: 4.4 MB rows: 318,361 symbols: 3,287
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 |
|---|---|---|---|---|---|---|---|
| 2008-05-12 06:50:00 | AAPL | Stock | 6.5611 | 6.5611 | 6.5611 | 6.5611 | 2800.0 |
| 2008-05-12 07:05:00 | AAPL | Stock | 6.5821 | 6.5821 | 6.5821 | 6.5821 | 14000.0 |
| 2008-05-12 07:15:00 | AAPL | Stock | 6.575 | 6.5821 | 6.5714 | 6.5821 | 8400.0 |
| 2008-05-12 07:20:00 | AAPL | Stock | 6.5821 | 6.5821 | 6.5821 | 6.5821 | 11200.0 |
| 2008-05-12 07:25:00 | AAPL | Stock | 6.5875 | 6.595 | 6.5875 | 6.595 | 11200.0 |
| 2008-05-12 07:30:00 | AAPL | Stock | 6.5761 | 6.5893 | 6.5761 | 6.5893 | 11200.0 |
| 2008-05-12 07:40:00 | AAPL | Stock | 6.5893 | 6.5929 | 6.5893 | 6.5929 | 14000.0 |
| 2008-05-12 07:45:00 | AAPL | Stock | 6.5893 | 6.5929 | 6.5829 | 6.5829 | 33600.0 |
| 2008-05-12 07:50:00 | AAPL | Stock | 6.5929 | 6.5929 | 6.5679 | 6.5857 | 161280.0 |
| 2008-05-12 07:55:00 | AAPL | Stock | 6.5793 | 6.5793 | 6.5793 | 6.5793 | 5600.0 |
| 2008-05-12 08:00:00 | AAPL | Stock | 6.5782 | 6.5857 | 6.565 | 6.5796 | 440748.0 |
| 2008-05-12 08:05:00 | AAPL | Stock | 6.5721 | 6.5893 | 6.5721 | 6.5811 | 290136.0 |
| 2008-05-12 08:10:00 | AAPL | Stock | 6.5839 | 6.5889 | 6.5814 | 6.5875 | 185080.0 |
| 2008-05-12 08:15:00 | AAPL | Stock | 6.5875 | 6.5893 | 6.5861 | 6.5882 | 398216.0 |
| 2008-05-12 08:20:00 | AAPL | Stock | 6.5875 | 6.5982 | 6.5875 | 6.5961 | 562464.0 |
| 2008-05-12 08:25:00 | AAPL | Stock | 6.5961 | 6.5996 | 6.5893 | 6.5911 | 479472.0 |
| 2008-05-12 08:30:00 | AAPL | Stock | 6.5911 | 6.5911 | 6.5857 | 6.5886 | 106540.0 |
| 2008-05-12 08:35:00 | AAPL | Stock | 6.5907 | 6.6043 | 6.5893 | 6.6043 | 314916.0 |
| 2008-05-12 08:40:00 | AAPL | Stock | 6.6046 | 6.6161 | 6.6043 | 6.6118 | 859208.0 |
| 2008-05-12 08:45:00 | AAPL | Stock | 6.6089 | 6.6104 | 6.5964 | 6.6054 | 662200.0 |
| 2008-05-12 08:50:00 | AAPL | Stock | 6.6032 | 6.6118 | 6.5989 | 6.6075 | 282940.0 |
| 2008-05-12 08:55:00 | AAPL | Stock | 6.6071 | 6.6214 | 6.6071 | 6.6139 | 834932.0 |
| 2008-05-12 09:00:00 | AAPL | Stock | 6.6139 | 6.6154 | 6.6007 | 6.6014 | 412748.0 |
| 2008-05-12 09:05:00 | AAPL | Stock | 6.6046 | 6.6104 | 6.6021 | 6.6021 | 227640.0 |
| 2008-05-12 09:10:00 | AAPL | Stock | 6.6032 | 6.6071 | 6.6018 | 6.605 | 286440.0 |
| 2008-05-12 09:15:00 | AAPL | Stock | 6.6064 | 6.6071 | 6.5946 | 6.5954 | 274596.0 |
| 2008-05-12 09:20:00 | AAPL | Stock | 6.5971 | 6.6196 | 6.5946 | 6.6179 | 660128.0 |
| 2008-05-12 09:25:00 | AAPL | Stock | 6.6196 | 6.6214 | 6.61 | 6.6132 | 885080.0 |
| 2008-05-12 09:30:00 | AAPL | Stock | 6.6132 | 6.6207 | 6.5921 | 6.5993 | 17034416.0 |
| 2008-05-12 09:35:00 | AAPL | Stock | 6.5996 | 6.6318 | 6.5975 | 6.6089 | 16314760.0 |
| 2008-05-12 09:40:00 | AAPL | Stock | 6.6082 | 6.611 | 6.5714 | 6.5764 | 17061520.0 |
| 2008-05-12 09:45:00 | AAPL | Stock | 6.5771 | 6.6054 | 6.5679 | 6.6039 | 15439564.0 |
| 2008-05-12 09:50:00 | AAPL | Stock | 6.6036 | 6.6125 | 6.5921 | 6.5983 | 11946368.0 |
| 2008-05-12 09:55:00 | AAPL | Stock | 6.5982 | 6.6032 | 6.5804 | 6.5932 | 7956564.0 |
| 2008-05-12 10:00:00 | AAPL | Stock | 6.5929 | 6.5943 | 6.5525 | 6.5696 | 18657940.0 |
| 2008-05-12 10:05:00 | AAPL | Stock | 6.5693 | 6.5707 | 6.5304 | 6.5343 | 13904016.0 |
| 2008-05-12 10:10:00 | AAPL | Stock | 6.5339 | 6.55 | 6.5321 | 6.5375 | 8649424.0 |
| 2008-05-12 10:15:00 | AAPL | Stock | 6.5382 | 6.5618 | 6.5379 | 6.56 | 8858696.0 |
| 2008-05-12 10:20:00 | AAPL | Stock | 6.5611 | 6.5857 | 6.5543 | 6.5839 | 9570820.0 |
| 2008-05-12 10:25:00 | AAPL | Stock | 6.5836 | 6.5993 | 6.5832 | 6.5943 | 12304740.0 |
| 2008-05-12 10:30:00 | AAPL | Stock | 6.5954 | 6.5954 | 6.58 | 6.5857 | 7380968.0 |
| 2008-05-12 10:35:00 | AAPL | Stock | 6.5854 | 6.6154 | 6.5839 | 6.6129 | 12826828.0 |
| 2008-05-12 10:40:00 | AAPL | Stock | 6.6129 | 6.6243 | 6.6107 | 6.6193 | 12740700.0 |
| 2008-05-12 10:45:00 | AAPL | Stock | 6.62 | 6.6286 | 6.6132 | 6.6139 | 12586112.0 |
| 2008-05-12 10:50:00 | AAPL | Stock | 6.6139 | 6.6236 | 6.6104 | 6.6146 | 7424032.0 |
| 2008-05-12 10:55:00 | AAPL | Stock | 6.6143 | 6.62 | 6.6057 | 6.6175 | 7173656.0 |
| 2008-05-12 11:00:00 | AAPL | Stock | 6.6179 | 6.6232 | 6.6143 | 6.6161 | 8122632.0 |
| 2008-05-12 11:05:00 | AAPL | Stock | 6.6154 | 6.6179 | 6.6071 | 6.6139 | 5759376.0 |
| 2008-05-12 11:10:00 | AAPL | Stock | 6.6139 | 6.6207 | 6.6054 | 6.6171 | 5583704.0 |
| 2008-05-12 11:15:00 | AAPL | Stock | 6.6171 | 6.6189 | 6.6071 | 6.6089 | 5758984.0 |
> showing 50 of 318,361 rows — these rows as CSV