PREVIEW / stock_5min / 2008-06-04
file: by_date/stock_5min/2008/2008-06-04.parquet size: 4.5 MB rows: 322,836 symbols: 3,308
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-06-04 06:55:00 | AAPL | Stock | 6.6179 | 6.6179 | 6.6179 | 6.6179 | 2800.0 |
| 2008-06-04 07:35:00 | AAPL | Stock | 6.5929 | 6.5943 | 6.5929 | 6.5929 | 28700.0 |
| 2008-06-04 07:40:00 | AAPL | Stock | 6.5943 | 6.5943 | 6.5943 | 6.5943 | 36400.0 |
| 2008-06-04 07:50:00 | AAPL | Stock | 6.5786 | 6.5811 | 6.5786 | 6.5811 | 33600.0 |
| 2008-06-04 07:55:00 | AAPL | Stock | 6.5911 | 6.5929 | 6.5911 | 6.5929 | 11200.0 |
| 2008-06-04 08:00:00 | AAPL | Stock | 6.5929 | 6.6132 | 6.5911 | 6.6036 | 344540.0 |
| 2008-06-04 08:05:00 | AAPL | Stock | 6.6007 | 6.6007 | 6.5946 | 6.5982 | 104076.0 |
| 2008-06-04 08:10:00 | AAPL | Stock | 6.5982 | 6.5986 | 6.5929 | 6.5946 | 89348.0 |
| 2008-06-04 08:15:00 | AAPL | Stock | 6.5946 | 6.6125 | 6.5896 | 6.5971 | 549220.0 |
| 2008-06-04 08:20:00 | AAPL | Stock | 6.5964 | 6.5968 | 6.585 | 6.5857 | 140420.0 |
| 2008-06-04 08:25:00 | AAPL | Stock | 6.5857 | 6.5861 | 6.5729 | 6.58 | 325920.0 |
| 2008-06-04 08:30:00 | AAPL | Stock | 6.5771 | 6.5893 | 6.5771 | 6.5861 | 290948.0 |
| 2008-06-04 08:35:00 | AAPL | Stock | 6.5861 | 6.5882 | 6.5768 | 6.5768 | 198828.0 |
| 2008-06-04 08:40:00 | AAPL | Stock | 6.5804 | 6.5804 | 6.575 | 6.5804 | 112000.0 |
| 2008-06-04 08:45:00 | AAPL | Stock | 6.5804 | 6.59 | 6.5804 | 6.5857 | 331688.0 |
| 2008-06-04 08:50:00 | AAPL | Stock | 6.5875 | 6.5875 | 6.5821 | 6.5821 | 83860.0 |
| 2008-06-04 08:55:00 | AAPL | Stock | 6.5818 | 6.5832 | 6.5804 | 6.5804 | 71400.0 |
| 2008-06-04 09:00:00 | AAPL | Stock | 6.5804 | 6.5846 | 6.5804 | 6.5807 | 97552.0 |
| 2008-06-04 09:05:00 | AAPL | Stock | 6.5804 | 6.5804 | 6.5718 | 6.5739 | 203532.0 |
| 2008-06-04 09:10:00 | AAPL | Stock | 6.5757 | 6.5768 | 6.5646 | 6.5646 | 891940.0 |
| 2008-06-04 09:15:00 | AAPL | Stock | 6.5661 | 6.5911 | 6.5625 | 6.565 | 659568.0 |
| 2008-06-04 09:20:00 | AAPL | Stock | 6.5664 | 6.5732 | 6.5643 | 6.5732 | 847588.0 |
| 2008-06-04 09:25:00 | AAPL | Stock | 6.5732 | 6.5732 | 6.5693 | 6.5732 | 114240.0 |
| 2008-06-04 09:30:00 | AAPL | Stock | 6.5732 | 6.5936 | 6.5661 | 6.5911 | 17404268.0 |
| 2008-06-04 09:35:00 | AAPL | Stock | 6.5911 | 6.6096 | 6.5839 | 6.5961 | 15420692.0 |
| 2008-06-04 09:40:00 | AAPL | Stock | 6.5971 | 6.6107 | 6.5804 | 6.5982 | 13349728.0 |
| 2008-06-04 09:45:00 | AAPL | Stock | 6.5971 | 6.6007 | 6.5661 | 6.5982 | 15000748.0 |
| 2008-06-04 09:50:00 | AAPL | Stock | 6.5986 | 6.6071 | 6.5618 | 6.5743 | 14876680.0 |
| 2008-06-04 09:55:00 | AAPL | Stock | 6.5746 | 6.5809 | 6.5561 | 6.5621 | 16183132.0 |
| 2008-06-04 10:00:00 | AAPL | Stock | 6.5625 | 6.5775 | 6.5439 | 6.5696 | 16944424.0 |
| 2008-06-04 10:05:00 | AAPL | Stock | 6.5686 | 6.5886 | 6.5593 | 6.5832 | 11529140.0 |
| 2008-06-04 10:10:00 | AAPL | Stock | 6.5836 | 6.6071 | 6.5732 | 6.6069 | 15340472.0 |
| 2008-06-04 10:15:00 | AAPL | Stock | 6.6071 | 6.6175 | 6.5989 | 6.6079 | 13378568.0 |
| 2008-06-04 10:20:00 | AAPL | Stock | 6.6079 | 6.6289 | 6.5986 | 6.6221 | 11368084.0 |
| 2008-06-04 10:25:00 | AAPL | Stock | 6.6232 | 6.6371 | 6.6214 | 6.63 | 10201352.0 |
| 2008-06-04 10:30:00 | AAPL | Stock | 6.6296 | 6.6429 | 6.6289 | 6.6379 | 10469508.0 |
| 2008-06-04 10:35:00 | AAPL | Stock | 6.6379 | 6.6475 | 6.625 | 6.6346 | 12243952.0 |
| 2008-06-04 10:40:00 | AAPL | Stock | 6.6346 | 6.64 | 6.6254 | 6.6307 | 9180472.0 |
| 2008-06-04 10:45:00 | AAPL | Stock | 6.6312 | 6.6339 | 6.6204 | 6.6243 | 9073988.0 |
| 2008-06-04 10:50:00 | AAPL | Stock | 6.6239 | 6.6429 | 6.6168 | 6.6411 | 14545244.0 |
| 2008-06-04 10:55:00 | AAPL | Stock | 6.6407 | 6.6721 | 6.6404 | 6.665 | 18279156.0 |
| 2008-06-04 11:00:00 | AAPL | Stock | 6.6643 | 6.6689 | 6.6564 | 6.6596 | 10898636.0 |
| 2008-06-04 11:05:00 | AAPL | Stock | 6.6604 | 6.6786 | 6.65 | 6.6779 | 10080868.0 |
| 2008-06-04 11:10:00 | AAPL | Stock | 6.6779 | 6.6818 | 6.6668 | 6.6696 | 10451952.0 |
| 2008-06-04 11:15:00 | AAPL | Stock | 6.6689 | 6.6718 | 6.6571 | 6.6593 | 7352128.0 |
| 2008-06-04 11:20:00 | AAPL | Stock | 6.6593 | 6.6671 | 6.6582 | 6.6624 | 4088056.0 |
| 2008-06-04 11:25:00 | AAPL | Stock | 6.6621 | 6.6633 | 6.6454 | 6.6507 | 6984740.0 |
| 2008-06-04 11:30:00 | AAPL | Stock | 6.6504 | 6.6568 | 6.6475 | 6.6564 | 3774064.0 |
| 2008-06-04 11:35:00 | AAPL | Stock | 6.6564 | 6.6689 | 6.6468 | 6.6571 | 6736968.0 |
| 2008-06-04 11:40:00 | AAPL | Stock | 6.6575 | 6.665 | 6.65 | 6.6557 | 3929128.0 |
> showing 50 of 322,836 rows — these rows as CSV