PREVIEW / stock_5min / 2007-01-04
file: by_date/stock_5min/2007/2007-01-04.parquet size: 3.4 MB rows: 246,466 symbols: 2,486
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-01-04 06:50:00 | AAPL | Stock | 2.9989 | 2.9989 | 2.9989 | 2.9989 | 11200.0 |
| 2007-01-04 07:25:00 | AAPL | Stock | 2.9993 | 2.9993 | 2.9993 | 2.9993 | 14000.0 |
| 2007-01-04 07:35:00 | AAPL | Stock | 2.9943 | 2.9943 | 2.9943 | 2.9943 | 5600.0 |
| 2007-01-04 07:40:00 | AAPL | Stock | 2.9925 | 2.9925 | 2.9925 | 2.9925 | 5600.0 |
| 2007-01-04 07:45:00 | AAPL | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 26600.0 |
| 2007-01-04 08:00:00 | AAPL | Stock | 3.0032 | 3.0032 | 2.9929 | 2.9946 | 122556.0 |
| 2007-01-04 08:05:00 | AAPL | Stock | 2.9946 | 2.9946 | 2.9875 | 2.9875 | 116200.0 |
| 2007-01-04 08:10:00 | AAPL | Stock | 2.9875 | 2.9875 | 2.9821 | 2.985 | 410200.0 |
| 2007-01-04 08:15:00 | AAPL | Stock | 2.9857 | 2.9857 | 2.9818 | 2.9825 | 333060.0 |
| 2007-01-04 08:20:00 | AAPL | Stock | 2.9821 | 2.985 | 2.9821 | 2.985 | 42000.0 |
| 2007-01-04 08:25:00 | AAPL | Stock | 2.985 | 2.9904 | 2.985 | 2.9871 | 292460.0 |
| 2007-01-04 08:30:00 | AAPL | Stock | 2.9857 | 2.9879 | 2.9804 | 2.9807 | 201600.0 |
| 2007-01-04 08:35:00 | AAPL | Stock | 2.9839 | 2.9864 | 2.9811 | 2.985 | 230104.0 |
| 2007-01-04 08:40:00 | AAPL | Stock | 2.9857 | 2.9864 | 2.985 | 2.9864 | 166152.0 |
| 2007-01-04 08:45:00 | AAPL | Stock | 2.9861 | 2.9929 | 2.9857 | 2.9925 | 142856.0 |
| 2007-01-04 08:50:00 | AAPL | Stock | 2.9868 | 2.9911 | 2.985 | 2.9911 | 105224.0 |
| 2007-01-04 08:55:00 | AAPL | Stock | 2.9911 | 2.9911 | 2.9868 | 2.9893 | 137200.0 |
| 2007-01-04 09:00:00 | AAPL | Stock | 2.9893 | 2.9893 | 2.9875 | 2.9893 | 23968.0 |
| 2007-01-04 09:05:00 | AAPL | Stock | 2.9879 | 2.9907 | 2.9879 | 2.9889 | 204484.0 |
| 2007-01-04 09:10:00 | AAPL | Stock | 2.9875 | 2.9875 | 2.9839 | 2.9857 | 242704.0 |
| 2007-01-04 09:15:00 | AAPL | Stock | 2.9829 | 2.9879 | 2.9825 | 2.9879 | 106400.0 |
| 2007-01-04 09:20:00 | AAPL | Stock | 2.9861 | 2.9875 | 2.9861 | 2.9875 | 76916.0 |
| 2007-01-04 09:25:00 | AAPL | Stock | 2.9882 | 3.0054 | 2.9875 | 3.0018 | 1678208.0 |
| 2007-01-04 09:30:00 | AAPL | Stock | 3.0018 | 3.0171 | 3.0007 | 3.0029 | 26395348.0 |
| 2007-01-04 09:35:00 | AAPL | Stock | 3.0029 | 3.0129 | 2.9936 | 3.0096 | 23944116.0 |
| 2007-01-04 09:40:00 | AAPL | Stock | 3.0096 | 3.0193 | 3.0043 | 3.0132 | 18250176.0 |
| 2007-01-04 09:45:00 | AAPL | Stock | 3.0132 | 3.03 | 3.0104 | 3.0279 | 28984536.0 |
| 2007-01-04 09:50:00 | AAPL | Stock | 3.0271 | 3.035 | 3.0232 | 3.0275 | 19988164.0 |
| 2007-01-04 09:55:00 | AAPL | Stock | 3.0259 | 3.0311 | 3.0221 | 3.0243 | 13016528.0 |
| 2007-01-04 10:00:00 | AAPL | Stock | 3.0239 | 3.0296 | 3.0068 | 3.0143 | 22722308.0 |
| 2007-01-04 10:05:00 | AAPL | Stock | 3.0104 | 3.0275 | 3.0039 | 3.0254 | 22801604.0 |
| 2007-01-04 10:10:00 | AAPL | Stock | 3.0254 | 3.0275 | 3.0082 | 3.0107 | 12028324.0 |
| 2007-01-04 10:15:00 | AAPL | Stock | 3.0104 | 3.0268 | 3.0064 | 3.0154 | 13207628.0 |
| 2007-01-04 10:20:00 | AAPL | Stock | 3.0154 | 3.0179 | 3.0093 | 3.0143 | 9392320.0 |
| 2007-01-04 10:25:00 | AAPL | Stock | 3.0139 | 3.0171 | 3.0079 | 3.0161 | 11471740.0 |
| 2007-01-04 10:30:00 | AAPL | Stock | 3.0164 | 3.0296 | 3.0161 | 3.0257 | 14845852.0 |
| 2007-01-04 10:35:00 | AAPL | Stock | 3.0254 | 3.0296 | 3.0175 | 3.0179 | 8594964.0 |
| 2007-01-04 10:40:00 | AAPL | Stock | 3.0182 | 3.0446 | 3.0179 | 3.0414 | 24525284.0 |
| 2007-01-04 10:45:00 | AAPL | Stock | 3.0418 | 3.0496 | 3.0364 | 3.0436 | 22940764.0 |
| 2007-01-04 10:50:00 | AAPL | Stock | 3.0436 | 3.0636 | 3.0429 | 3.0596 | 22779848.0 |
| 2007-01-04 10:55:00 | AAPL | Stock | 3.0596 | 3.0639 | 3.0536 | 3.0589 | 14807380.0 |
| 2007-01-04 11:00:00 | AAPL | Stock | 3.0589 | 3.0679 | 3.0557 | 3.0618 | 18074840.0 |
| 2007-01-04 11:05:00 | AAPL | Stock | 3.0621 | 3.0668 | 3.0546 | 3.0557 | 12152476.0 |
| 2007-01-04 11:10:00 | AAPL | Stock | 3.0557 | 3.0679 | 3.0432 | 3.0461 | 15574972.0 |
| 2007-01-04 11:15:00 | AAPL | Stock | 3.0461 | 3.0593 | 3.0446 | 3.0479 | 7631988.0 |
| 2007-01-04 11:20:00 | AAPL | Stock | 3.0475 | 3.0586 | 3.0471 | 3.055 | 11077136.0 |
| 2007-01-04 11:25:00 | AAPL | Stock | 3.055 | 3.0579 | 3.0468 | 3.0479 | 7858396.0 |
| 2007-01-04 11:30:00 | AAPL | Stock | 3.0479 | 3.0518 | 3.0464 | 3.0496 | 6877668.0 |
| 2007-01-04 11:35:00 | AAPL | Stock | 3.0496 | 3.0564 | 3.0489 | 3.055 | 8317288.0 |
| 2007-01-04 11:40:00 | AAPL | Stock | 3.0548 | 3.0639 | 3.0546 | 3.0611 | 13012832.0 |
> showing 50 of 246,466 rows — these rows as CSV