PREVIEW / stock_5min / 2006-02-03
file: by_date/stock_5min/2006/2006-02-03.parquet size: 3.0 MB rows: 217,813 symbols: 2,180
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 |
|---|---|---|---|---|---|---|---|
| 2006-02-03 07:35:00 | AAPL | Stock | 2.5779 | 2.5779 | 2.5768 | 2.5768 | 54684.0 |
| 2006-02-03 08:00:00 | AAPL | Stock | 2.5714 | 2.5818 | 2.5714 | 2.5818 | 395080.0 |
| 2006-02-03 08:05:00 | AAPL | Stock | 2.5821 | 2.5857 | 2.5814 | 2.5857 | 470512.0 |
| 2006-02-03 08:10:00 | AAPL | Stock | 2.5857 | 2.5875 | 2.5857 | 2.5861 | 170184.0 |
| 2006-02-03 08:15:00 | AAPL | Stock | 2.5879 | 2.5879 | 2.5861 | 2.5861 | 318640.0 |
| 2006-02-03 08:20:00 | AAPL | Stock | 2.5871 | 2.5871 | 2.5857 | 2.5857 | 29820.0 |
| 2006-02-03 08:25:00 | AAPL | Stock | 2.5839 | 2.5871 | 2.5839 | 2.5846 | 235284.0 |
| 2006-02-03 08:30:00 | AAPL | Stock | 2.5839 | 2.5911 | 2.5839 | 2.5893 | 531384.0 |
| 2006-02-03 08:35:00 | AAPL | Stock | 2.5879 | 2.5921 | 2.5832 | 2.5843 | 1072120.0 |
| 2006-02-03 08:40:00 | AAPL | Stock | 2.5871 | 2.5896 | 2.5857 | 2.5896 | 201460.0 |
| 2006-02-03 08:45:00 | AAPL | Stock | 2.5896 | 2.5896 | 2.5857 | 2.5864 | 117432.0 |
| 2006-02-03 08:50:00 | AAPL | Stock | 2.5864 | 2.5875 | 2.5861 | 2.5875 | 33740.0 |
| 2006-02-03 08:55:00 | AAPL | Stock | 2.5861 | 2.5861 | 2.5821 | 2.5857 | 808080.0 |
| 2006-02-03 09:00:00 | AAPL | Stock | 2.5829 | 2.5829 | 2.5757 | 2.5768 | 936320.0 |
| 2006-02-03 09:05:00 | AAPL | Stock | 2.5786 | 2.5821 | 2.5761 | 2.5818 | 347368.0 |
| 2006-02-03 09:10:00 | AAPL | Stock | 2.5804 | 2.5804 | 2.5779 | 2.5804 | 196756.0 |
| 2006-02-03 09:15:00 | AAPL | Stock | 2.5779 | 2.58 | 2.5714 | 2.575 | 458276.0 |
| 2006-02-03 09:20:00 | AAPL | Stock | 2.575 | 2.5786 | 2.5732 | 2.5768 | 191968.0 |
| 2006-02-03 09:25:00 | AAPL | Stock | 2.5739 | 2.5818 | 2.5575 | 2.5818 | 1254400.0 |
| 2006-02-03 09:30:00 | AAPL | Stock | 2.58 | 2.5818 | 2.5375 | 2.54 | 34339200.0 |
| 2006-02-03 09:35:00 | AAPL | Stock | 2.5396 | 2.5716 | 2.5393 | 2.5607 | 17291036.0 |
| 2006-02-03 09:40:00 | AAPL | Stock | 2.5607 | 2.5704 | 2.5568 | 2.5661 | 13473180.0 |
| 2006-02-03 09:45:00 | AAPL | Stock | 2.5661 | 2.5668 | 2.5457 | 2.5536 | 11123224.0 |
| 2006-02-03 09:50:00 | AAPL | Stock | 2.5536 | 2.5586 | 2.5439 | 2.5454 | 9192512.0 |
| 2006-02-03 09:55:00 | AAPL | Stock | 2.5457 | 2.5639 | 2.5439 | 2.5604 | 11481484.0 |
| 2006-02-03 10:00:00 | AAPL | Stock | 2.5604 | 2.5886 | 2.5589 | 2.5792 | 26926116.0 |
| 2006-02-03 10:05:00 | AAPL | Stock | 2.5786 | 2.5986 | 2.5782 | 2.5857 | 26444572.0 |
| 2006-02-03 10:10:00 | AAPL | Stock | 2.5857 | 2.5993 | 2.5821 | 2.5843 | 15372588.0 |
| 2006-02-03 10:15:00 | AAPL | Stock | 2.5829 | 2.5996 | 2.5804 | 2.5936 | 11679976.0 |
| 2006-02-03 10:20:00 | AAPL | Stock | 2.5918 | 2.5957 | 2.58 | 2.5929 | 12285280.0 |
| 2006-02-03 10:25:00 | AAPL | Stock | 2.5929 | 2.5957 | 2.5861 | 2.5904 | 7126560.0 |
| 2006-02-03 10:30:00 | AAPL | Stock | 2.5907 | 2.5929 | 2.5768 | 2.5775 | 9216172.0 |
| 2006-02-03 10:35:00 | AAPL | Stock | 2.5775 | 2.5786 | 2.5625 | 2.5682 | 13643000.0 |
| 2006-02-03 10:40:00 | AAPL | Stock | 2.5686 | 2.5686 | 2.5571 | 2.5611 | 8968092.0 |
| 2006-02-03 10:45:00 | AAPL | Stock | 2.5614 | 2.5775 | 2.5607 | 2.5736 | 12111120.0 |
| 2006-02-03 10:50:00 | AAPL | Stock | 2.5736 | 2.5889 | 2.5707 | 2.5882 | 10138268.0 |
| 2006-02-03 10:55:00 | AAPL | Stock | 2.5879 | 2.5925 | 2.5811 | 2.5896 | 11554396.0 |
| 2006-02-03 11:00:00 | AAPL | Stock | 2.5875 | 2.5911 | 2.5825 | 2.5832 | 8847860.0 |
| 2006-02-03 11:05:00 | AAPL | Stock | 2.5825 | 2.5868 | 2.5804 | 2.5868 | 6891080.0 |
| 2006-02-03 11:10:00 | AAPL | Stock | 2.5868 | 2.5907 | 2.5825 | 2.5868 | 6529152.0 |
| 2006-02-03 11:15:00 | AAPL | Stock | 2.5864 | 2.5868 | 2.5796 | 2.585 | 4683896.0 |
| 2006-02-03 11:20:00 | AAPL | Stock | 2.5854 | 2.5911 | 2.5837 | 2.5882 | 4933068.0 |
| 2006-02-03 11:25:00 | AAPL | Stock | 2.5882 | 2.5954 | 2.5882 | 2.5943 | 8876588.0 |
| 2006-02-03 11:30:00 | AAPL | Stock | 2.5943 | 2.5946 | 2.5829 | 2.5872 | 8155168.0 |
| 2006-02-03 11:35:00 | AAPL | Stock | 2.5857 | 2.5925 | 2.5857 | 2.5879 | 4225200.0 |
| 2006-02-03 11:40:00 | AAPL | Stock | 2.5879 | 2.5964 | 2.5868 | 2.5954 | 15514772.0 |
| 2006-02-03 11:45:00 | AAPL | Stock | 2.5954 | 2.5954 | 2.5871 | 2.591 | 5765620.0 |
| 2006-02-03 11:50:00 | AAPL | Stock | 2.5904 | 2.5918 | 2.575 | 2.5786 | 6274968.0 |
| 2006-02-03 11:55:00 | AAPL | Stock | 2.5782 | 2.585 | 2.5771 | 2.5843 | 4925340.0 |
| 2006-02-03 12:00:00 | AAPL | Stock | 2.5839 | 2.5857 | 2.5782 | 2.5804 | 3797416.0 |
> showing 50 of 217,813 rows — these rows as CSV