PREVIEW / stock_5min / 2007-10-26
file: by_date/stock_5min/2007/2007-10-26.parquet size: 4.3 MB rows: 310,798 symbols: 3,152
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-10-26 05:20:00 | AAPL | Stock | 6.6071 | 6.6071 | 6.6071 | 6.6071 | 2800.0 |
| 2007-10-26 05:30:00 | AAPL | Stock | 6.6071 | 6.6071 | 6.6071 | 6.6071 | 2800.0 |
| 2007-10-26 06:00:00 | AAPL | Stock | 6.6018 | 6.6018 | 6.6018 | 6.6018 | 14000.0 |
| 2007-10-26 06:55:00 | AAPL | Stock | 6.6061 | 6.6061 | 6.6061 | 6.6061 | 31472.0 |
| 2007-10-26 07:00:00 | AAPL | Stock | 6.6071 | 6.6143 | 6.6071 | 6.6143 | 8400.0 |
| 2007-10-26 07:05:00 | AAPL | Stock | 6.6146 | 6.6146 | 6.5964 | 6.5964 | 58100.0 |
| 2007-10-26 07:10:00 | AAPL | Stock | 6.5936 | 6.5964 | 6.5932 | 6.5964 | 16800.0 |
| 2007-10-26 07:15:00 | AAPL | Stock | 6.5929 | 6.5936 | 6.5918 | 6.5936 | 39956.0 |
| 2007-10-26 07:20:00 | AAPL | Stock | 6.6071 | 6.6071 | 6.6071 | 6.6071 | 28000.0 |
| 2007-10-26 07:25:00 | AAPL | Stock | 6.6068 | 6.6071 | 6.6068 | 6.6071 | 45080.0 |
| 2007-10-26 07:30:00 | AAPL | Stock | 6.6004 | 6.6071 | 6.6 | 6.6071 | 88200.0 |
| 2007-10-26 07:35:00 | AAPL | Stock | 6.6043 | 6.6057 | 6.5936 | 6.5964 | 130200.0 |
| 2007-10-26 07:45:00 | AAPL | Stock | 6.5936 | 6.5936 | 6.5721 | 6.5771 | 738724.0 |
| 2007-10-26 07:50:00 | AAPL | Stock | 6.5871 | 6.5875 | 6.5786 | 6.5786 | 30800.0 |
| 2007-10-26 07:55:00 | AAPL | Stock | 6.5786 | 6.5786 | 6.5714 | 6.5714 | 141176.0 |
| 2007-10-26 08:00:00 | AAPL | Stock | 6.5786 | 6.5864 | 6.5639 | 6.5757 | 952308.0 |
| 2007-10-26 08:05:00 | AAPL | Stock | 6.5714 | 6.575 | 6.5679 | 6.5714 | 157500.0 |
| 2007-10-26 08:10:00 | AAPL | Stock | 6.5682 | 6.5714 | 6.5475 | 6.5546 | 414960.0 |
| 2007-10-26 08:15:00 | AAPL | Stock | 6.5525 | 6.5646 | 6.5443 | 6.5646 | 403284.0 |
| 2007-10-26 08:20:00 | AAPL | Stock | 6.5657 | 6.5786 | 6.5643 | 6.5786 | 283304.0 |
| 2007-10-26 08:25:00 | AAPL | Stock | 6.5786 | 6.5943 | 6.575 | 6.5821 | 432040.0 |
| 2007-10-26 08:30:00 | AAPL | Stock | 6.5821 | 6.5871 | 6.5804 | 6.5857 | 152460.0 |
| 2007-10-26 08:35:00 | AAPL | Stock | 6.5832 | 6.5946 | 6.5804 | 6.5911 | 1037820.0 |
| 2007-10-26 08:40:00 | AAPL | Stock | 6.5929 | 6.5996 | 6.5886 | 6.5929 | 401716.0 |
| 2007-10-26 08:45:00 | AAPL | Stock | 6.5861 | 6.5936 | 6.5857 | 6.5932 | 109592.0 |
| 2007-10-26 08:50:00 | AAPL | Stock | 6.5921 | 6.5929 | 6.5857 | 6.5893 | 103348.0 |
| 2007-10-26 08:55:00 | AAPL | Stock | 6.5893 | 6.5946 | 6.5889 | 6.5893 | 252280.0 |
| 2007-10-26 09:00:00 | AAPL | Stock | 6.5925 | 6.6064 | 6.5893 | 6.6043 | 394800.0 |
| 2007-10-26 09:05:00 | AAPL | Stock | 6.6061 | 6.6071 | 6.5943 | 6.5961 | 859040.0 |
| 2007-10-26 09:10:00 | AAPL | Stock | 6.5964 | 6.6036 | 6.5964 | 6.6029 | 428736.0 |
| 2007-10-26 09:15:00 | AAPL | Stock | 6.6036 | 6.6196 | 6.6036 | 6.6196 | 1052660.0 |
| 2007-10-26 09:20:00 | AAPL | Stock | 6.6182 | 6.6189 | 6.5968 | 6.5989 | 323400.0 |
| 2007-10-26 09:25:00 | AAPL | Stock | 6.5961 | 6.6161 | 6.595 | 6.6143 | 715372.0 |
| 2007-10-26 09:30:00 | AAPL | Stock | 6.6175 | 6.6204 | 6.5839 | 6.5871 | 27899508.0 |
| 2007-10-26 09:35:00 | AAPL | Stock | 6.5871 | 6.5964 | 6.5725 | 6.5725 | 17897320.0 |
| 2007-10-26 09:40:00 | AAPL | Stock | 6.5729 | 6.5832 | 6.5543 | 6.5642 | 20893712.0 |
| 2007-10-26 09:45:00 | AAPL | Stock | 6.565 | 6.565 | 6.5357 | 6.5589 | 18844896.0 |
| 2007-10-26 09:50:00 | AAPL | Stock | 6.5593 | 6.5796 | 6.5536 | 6.5575 | 12363960.0 |
| 2007-10-26 09:55:00 | AAPL | Stock | 6.5575 | 6.56 | 6.5314 | 6.5504 | 14038668.0 |
| 2007-10-26 10:00:00 | AAPL | Stock | 6.5482 | 6.5664 | 6.5357 | 6.5582 | 11933124.0 |
| 2007-10-26 10:05:00 | AAPL | Stock | 6.5589 | 6.5711 | 6.5475 | 6.5661 | 11263588.0 |
| 2007-10-26 10:10:00 | AAPL | Stock | 6.5661 | 6.5786 | 6.5575 | 6.5754 | 10305260.0 |
| 2007-10-26 10:15:00 | AAPL | Stock | 6.5739 | 6.5846 | 6.565 | 6.57 | 10112480.0 |
| 2007-10-26 10:20:00 | AAPL | Stock | 6.5704 | 6.5854 | 6.5571 | 6.5821 | 8983184.0 |
| 2007-10-26 10:25:00 | AAPL | Stock | 6.5814 | 6.5911 | 6.5696 | 6.5807 | 15205568.0 |
| 2007-10-26 10:30:00 | AAPL | Stock | 6.5796 | 6.5893 | 6.5729 | 6.5829 | 8024044.0 |
| 2007-10-26 10:35:00 | AAPL | Stock | 6.5825 | 6.5975 | 6.58 | 6.5875 | 10599400.0 |
| 2007-10-26 10:40:00 | AAPL | Stock | 6.5882 | 6.5889 | 6.5689 | 6.5707 | 10564232.0 |
| 2007-10-26 10:45:00 | AAPL | Stock | 6.5711 | 6.5846 | 6.5661 | 6.5835 | 9807868.0 |
| 2007-10-26 10:50:00 | AAPL | Stock | 6.5839 | 6.5893 | 6.5714 | 6.5789 | 9858800.0 |
> showing 50 of 310,798 rows — these rows as CSV