PREVIEW / stock_5min / 2006-12-27
file: by_date/stock_5min/2006/2006-12-27.parquet size: 3.2 MB rows: 239,631 symbols: 2,493
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-12-27 06:15:00 | AAPL | Stock | 2.9061 | 2.9107 | 2.9004 | 2.9004 | 64400.0 |
| 2006-12-27 06:20:00 | AAPL | Stock | 2.8964 | 2.9064 | 2.8929 | 2.8939 | 39200.0 |
| 2006-12-27 06:40:00 | AAPL | Stock | 2.8914 | 2.8929 | 2.8907 | 2.8929 | 16800.0 |
| 2006-12-27 07:00:00 | AAPL | Stock | 2.9071 | 2.9071 | 2.9 | 2.9 | 112000.0 |
| 2006-12-27 07:05:00 | AAPL | Stock | 2.8929 | 2.8929 | 2.8929 | 2.8929 | 70000.0 |
| 2006-12-27 07:10:00 | AAPL | Stock | 2.8929 | 2.8929 | 2.8929 | 2.8929 | 14000.0 |
| 2006-12-27 07:15:00 | AAPL | Stock | 2.8907 | 2.8929 | 2.8857 | 2.8857 | 74480.0 |
| 2006-12-27 07:20:00 | AAPL | Stock | 2.8857 | 2.8857 | 2.8786 | 2.8786 | 112000.0 |
| 2006-12-27 07:40:00 | AAPL | Stock | 2.875 | 2.875 | 2.8571 | 2.8643 | 460040.0 |
| 2006-12-27 07:45:00 | AAPL | Stock | 2.8607 | 2.8711 | 2.8607 | 2.8707 | 319200.0 |
| 2006-12-27 07:50:00 | AAPL | Stock | 2.8707 | 2.875 | 2.8707 | 2.8718 | 146720.0 |
| 2006-12-27 07:55:00 | AAPL | Stock | 2.8714 | 2.8754 | 2.8696 | 2.8696 | 327600.0 |
| 2006-12-27 08:00:00 | AAPL | Stock | 2.8711 | 2.8796 | 2.85 | 2.8561 | 3612532.0 |
| 2006-12-27 08:05:00 | AAPL | Stock | 2.8536 | 2.8618 | 2.8518 | 2.8607 | 1377264.0 |
| 2006-12-27 08:10:00 | AAPL | Stock | 2.8607 | 2.8618 | 2.8561 | 2.8582 | 776160.0 |
| 2006-12-27 08:15:00 | AAPL | Stock | 2.8582 | 2.8586 | 2.8436 | 2.8436 | 2277996.0 |
| 2006-12-27 08:20:00 | AAPL | Stock | 2.8439 | 2.8439 | 2.8182 | 2.8214 | 6267492.0 |
| 2006-12-27 08:25:00 | AAPL | Stock | 2.8211 | 2.8311 | 2.8036 | 2.8043 | 6388088.0 |
| 2006-12-27 08:30:00 | AAPL | Stock | 2.805 | 2.8111 | 2.8021 | 2.8107 | 5551868.0 |
| 2006-12-27 08:35:00 | AAPL | Stock | 2.8114 | 2.8118 | 2.7911 | 2.7911 | 5507152.0 |
| 2006-12-27 08:40:00 | AAPL | Stock | 2.7911 | 2.7982 | 2.7846 | 2.79 | 6988884.0 |
| 2006-12-27 08:45:00 | AAPL | Stock | 2.7886 | 2.7921 | 2.7814 | 2.7814 | 6756176.0 |
| 2006-12-27 08:50:00 | AAPL | Stock | 2.7821 | 2.7925 | 2.7807 | 2.7918 | 7067732.0 |
| 2006-12-27 08:55:00 | AAPL | Stock | 2.7925 | 2.8 | 2.7925 | 2.7996 | 4325048.0 |
| 2006-12-27 09:00:00 | AAPL | Stock | 2.7979 | 2.8032 | 2.7893 | 2.7911 | 4435004.0 |
| 2006-12-27 09:05:00 | AAPL | Stock | 2.7911 | 2.7929 | 2.7861 | 2.7879 | 6798764.0 |
| 2006-12-27 09:10:00 | AAPL | Stock | 2.7882 | 2.7939 | 2.7875 | 2.7932 | 6730976.0 |
| 2006-12-27 09:15:00 | AAPL | Stock | 2.7936 | 2.7946 | 2.7839 | 2.7857 | 7893536.0 |
| 2006-12-27 09:20:00 | AAPL | Stock | 2.7854 | 2.7857 | 2.7786 | 2.7789 | 3646496.0 |
| 2006-12-27 09:25:00 | AAPL | Stock | 2.7786 | 2.7929 | 2.7739 | 2.7907 | 10816288.0 |
| 2006-12-27 09:30:00 | AAPL | Stock | 2.7911 | 2.7921 | 2.7418 | 2.7475 | 105895580.0 |
| 2006-12-27 09:35:00 | AAPL | Stock | 2.7479 | 2.7761 | 2.7421 | 2.7654 | 83062952.0 |
| 2006-12-27 09:40:00 | AAPL | Stock | 2.7654 | 2.7764 | 2.7604 | 2.7754 | 59451224.0 |
| 2006-12-27 09:45:00 | AAPL | Stock | 2.7754 | 2.7889 | 2.7747 | 2.7879 | 77960540.0 |
| 2006-12-27 09:50:00 | AAPL | Stock | 2.7875 | 2.8068 | 2.7868 | 2.8039 | 73556924.0 |
| 2006-12-27 09:55:00 | AAPL | Stock | 2.8039 | 2.8061 | 2.7832 | 2.7836 | 53000556.0 |
| 2006-12-27 10:00:00 | AAPL | Stock | 2.7832 | 2.7893 | 2.7821 | 2.7832 | 40054448.0 |
| 2006-12-27 10:05:00 | AAPL | Stock | 2.7829 | 2.7861 | 2.78 | 2.7814 | 25514524.0 |
| 2006-12-27 10:10:00 | AAPL | Stock | 2.7811 | 2.7889 | 2.7736 | 2.7884 | 33510456.0 |
| 2006-12-27 10:15:00 | AAPL | Stock | 2.7886 | 2.7943 | 2.7882 | 2.7921 | 27616764.0 |
| 2006-12-27 10:20:00 | AAPL | Stock | 2.7921 | 2.7929 | 2.7839 | 2.7904 | 19802916.0 |
| 2006-12-27 10:25:00 | AAPL | Stock | 2.7904 | 2.7911 | 2.7832 | 2.7879 | 14827316.0 |
| 2006-12-27 10:30:00 | AAPL | Stock | 2.7875 | 2.7893 | 2.7768 | 2.7779 | 19276488.0 |
| 2006-12-27 10:35:00 | AAPL | Stock | 2.7775 | 2.7825 | 2.7771 | 2.7771 | 14728868.0 |
| 2006-12-27 10:40:00 | AAPL | Stock | 2.7768 | 2.7911 | 2.7768 | 2.7911 | 20201104.0 |
| 2006-12-27 10:45:00 | AAPL | Stock | 2.7907 | 2.7946 | 2.7846 | 2.7904 | 21238868.0 |
| 2006-12-27 10:50:00 | AAPL | Stock | 2.7904 | 2.7972 | 2.7886 | 2.7946 | 22533812.0 |
| 2006-12-27 10:55:00 | AAPL | Stock | 2.7946 | 2.7957 | 2.7896 | 2.7921 | 13531924.0 |
| 2006-12-27 11:00:00 | AAPL | Stock | 2.7929 | 2.7964 | 2.7918 | 2.7936 | 14325696.0 |
| 2006-12-27 11:05:00 | AAPL | Stock | 2.7939 | 2.7993 | 2.7918 | 2.7993 | 22482376.0 |
> showing 50 of 239,631 rows — these rows as CSV