PREVIEW / stock_5min / 2007-05-09
file: by_date/stock_5min/2007/2007-05-09.parquet size: 3.8 MB rows: 277,104 symbols: 2,734
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-05-09 09:30:00 | AAPL | Stock | 3.7468 | 3.7657 | 3.7461 | 3.755 | 25644248.0 |
| 2007-05-09 09:35:00 | AAPL | Stock | 3.7543 | 3.755 | 3.7464 | 3.7489 | 12872496.0 |
| 2007-05-09 09:40:00 | AAPL | Stock | 3.7486 | 3.7721 | 3.7471 | 3.7604 | 21899192.0 |
| 2007-05-09 09:45:00 | AAPL | Stock | 3.7604 | 3.7754 | 3.7596 | 3.7668 | 14912828.0 |
| 2007-05-09 09:50:00 | AAPL | Stock | 3.7668 | 3.7739 | 3.765 | 3.7675 | 11221336.0 |
| 2007-05-09 09:55:00 | AAPL | Stock | 3.7689 | 3.7779 | 3.7682 | 3.7714 | 11542748.0 |
| 2007-05-09 10:00:00 | AAPL | Stock | 3.7714 | 3.7943 | 3.7696 | 3.7911 | 19021940.0 |
| 2007-05-09 10:05:00 | AAPL | Stock | 3.7911 | 3.7921 | 3.7832 | 3.7889 | 12849592.0 |
| 2007-05-09 10:10:00 | AAPL | Stock | 3.7889 | 3.7889 | 3.7796 | 3.7836 | 13895672.0 |
| 2007-05-09 10:15:00 | AAPL | Stock | 3.7836 | 3.7918 | 3.7818 | 3.7861 | 9447648.0 |
| 2007-05-09 10:20:00 | AAPL | Stock | 3.7864 | 3.7904 | 3.7832 | 3.785 | 8356040.0 |
| 2007-05-09 10:25:00 | AAPL | Stock | 3.785 | 3.7875 | 3.7811 | 3.7821 | 7753228.0 |
| 2007-05-09 10:30:00 | AAPL | Stock | 3.7825 | 3.7825 | 3.7771 | 3.7782 | 11863964.0 |
| 2007-05-09 10:35:00 | AAPL | Stock | 3.7782 | 3.7804 | 3.7732 | 3.7786 | 13480124.0 |
| 2007-05-09 10:40:00 | AAPL | Stock | 3.7786 | 3.7786 | 3.7743 | 3.7764 | 8262660.0 |
| 2007-05-09 10:45:00 | AAPL | Stock | 3.7764 | 3.7793 | 3.7704 | 3.7739 | 7544992.0 |
| 2007-05-09 10:50:00 | AAPL | Stock | 3.7736 | 3.78 | 3.7736 | 3.7782 | 4453400.0 |
| 2007-05-09 10:55:00 | AAPL | Stock | 3.7781 | 3.78 | 3.7768 | 3.78 | 3654840.0 |
| 2007-05-09 11:00:00 | AAPL | Stock | 3.78 | 3.7846 | 3.7796 | 3.7832 | 6483008.0 |
| 2007-05-09 11:05:00 | AAPL | Stock | 3.7832 | 3.7843 | 3.7807 | 3.7821 | 4504276.0 |
| 2007-05-09 11:10:00 | AAPL | Stock | 3.7825 | 3.7857 | 3.7818 | 3.7832 | 6235404.0 |
| 2007-05-09 11:15:00 | AAPL | Stock | 3.7832 | 3.7846 | 3.7811 | 3.7811 | 3414460.0 |
| 2007-05-09 11:20:00 | AAPL | Stock | 3.7814 | 3.7832 | 3.7768 | 3.7771 | 5852560.0 |
| 2007-05-09 11:25:00 | AAPL | Stock | 3.7775 | 3.7796 | 3.7704 | 3.7736 | 7572712.0 |
| 2007-05-09 11:30:00 | AAPL | Stock | 3.7736 | 3.7743 | 3.7682 | 3.7718 | 6607076.0 |
| 2007-05-09 11:35:00 | AAPL | Stock | 3.7714 | 3.7718 | 3.7657 | 3.7693 | 7228816.0 |
| 2007-05-09 11:40:00 | AAPL | Stock | 3.7693 | 3.775 | 3.7689 | 3.7725 | 3541328.0 |
| 2007-05-09 11:45:00 | AAPL | Stock | 3.7725 | 3.7743 | 3.7704 | 3.7707 | 3353364.0 |
| 2007-05-09 11:50:00 | AAPL | Stock | 3.7705 | 3.7718 | 3.7664 | 3.7668 | 5023816.0 |
| 2007-05-09 11:55:00 | AAPL | Stock | 3.7668 | 3.7693 | 3.7614 | 3.7621 | 5692764.0 |
| 2007-05-09 12:00:00 | AAPL | Stock | 3.7621 | 3.7657 | 3.7607 | 3.7636 | 5860652.0 |
| 2007-05-09 12:05:00 | AAPL | Stock | 3.7639 | 3.7664 | 3.7639 | 3.7654 | 3096744.0 |
| 2007-05-09 12:10:00 | AAPL | Stock | 3.765 | 3.7671 | 3.7618 | 3.7621 | 3796576.0 |
| 2007-05-09 12:15:00 | AAPL | Stock | 3.7618 | 3.7639 | 3.7604 | 3.7629 | 4628820.0 |
| 2007-05-09 12:20:00 | AAPL | Stock | 3.7632 | 3.77 | 3.7625 | 3.765 | 3563028.0 |
| 2007-05-09 12:25:00 | AAPL | Stock | 3.765 | 3.7682 | 3.7621 | 3.7679 | 3266116.0 |
| 2007-05-09 12:30:00 | AAPL | Stock | 3.7675 | 3.7682 | 3.7625 | 3.7646 | 2621976.0 |
| 2007-05-09 12:35:00 | AAPL | Stock | 3.7643 | 3.7775 | 3.7639 | 3.7768 | 4063864.0 |
| 2007-05-09 12:40:00 | AAPL | Stock | 3.7771 | 3.7779 | 3.7739 | 3.7757 | 4420444.0 |
| 2007-05-09 12:45:00 | AAPL | Stock | 3.7757 | 3.7779 | 3.775 | 3.7757 | 4530764.0 |
| 2007-05-09 12:50:00 | AAPL | Stock | 3.7754 | 3.7771 | 3.7732 | 3.7732 | 2246356.0 |
| 2007-05-09 12:55:00 | AAPL | Stock | 3.7732 | 3.775 | 3.7721 | 3.7732 | 2427852.0 |
| 2007-05-09 13:00:00 | AAPL | Stock | 3.7732 | 3.7743 | 3.7707 | 3.7739 | 2616936.0 |
| 2007-05-09 13:05:00 | AAPL | Stock | 3.7739 | 3.7762 | 3.7714 | 3.7732 | 2466548.0 |
| 2007-05-09 13:10:00 | AAPL | Stock | 3.7732 | 3.775 | 3.7718 | 3.7718 | 1766828.0 |
| 2007-05-09 13:15:00 | AAPL | Stock | 3.7721 | 3.7757 | 3.7718 | 3.7732 | 2014404.0 |
| 2007-05-09 13:20:00 | AAPL | Stock | 3.7735 | 3.7757 | 3.7721 | 3.7739 | 2279704.0 |
| 2007-05-09 13:25:00 | AAPL | Stock | 3.7739 | 3.7743 | 3.7714 | 3.7714 | 1937852.0 |
| 2007-05-09 13:30:00 | AAPL | Stock | 3.7718 | 3.7725 | 3.7696 | 3.7711 | 3047268.0 |
| 2007-05-09 13:35:00 | AAPL | Stock | 3.7707 | 3.7732 | 3.7671 | 3.7689 | 4235476.0 |
> showing 50 of 277,104 rows — these rows as CSV