PREVIEW / stock_5min / 2005-09-16
file: by_date/stock_5min/2005/2005-09-16.parquet size: 2.8 MB rows: 207,596 symbols: 2,068
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 |
|---|---|---|---|---|---|---|---|
| 2005-09-16 07:40:00 | AAPL | Stock | 1.7861 | 1.7861 | 1.7861 | 1.7861 | 2800.0 |
| 2005-09-16 07:45:00 | AAPL | Stock | 1.7932 | 1.7932 | 1.7932 | 1.7932 | 15120.0 |
| 2005-09-16 07:55:00 | AAPL | Stock | 1.7932 | 1.7932 | 1.7932 | 1.7932 | 28000.0 |
| 2005-09-16 08:00:00 | AAPL | Stock | 1.7932 | 1.7939 | 1.7932 | 1.7932 | 55832.0 |
| 2005-09-16 08:05:00 | AAPL | Stock | 1.7911 | 1.7939 | 1.7911 | 1.7929 | 109844.0 |
| 2005-09-16 08:10:00 | AAPL | Stock | 1.7929 | 1.7929 | 1.7929 | 1.7929 | 2800.0 |
| 2005-09-16 08:20:00 | AAPL | Stock | 1.7929 | 1.7939 | 1.7929 | 1.7939 | 43960.0 |
| 2005-09-16 08:25:00 | AAPL | Stock | 1.7929 | 1.7946 | 1.7929 | 1.7946 | 134512.0 |
| 2005-09-16 08:30:00 | AAPL | Stock | 1.7921 | 1.7954 | 1.7921 | 1.7954 | 32144.0 |
| 2005-09-16 08:35:00 | AAPL | Stock | 1.7957 | 1.7964 | 1.7954 | 1.7964 | 67200.0 |
| 2005-09-16 08:40:00 | AAPL | Stock | 1.7979 | 1.8036 | 1.7979 | 1.8018 | 450240.0 |
| 2005-09-16 08:45:00 | AAPL | Stock | 1.8018 | 1.8043 | 1.8 | 1.8036 | 383600.0 |
| 2005-09-16 08:50:00 | AAPL | Stock | 1.8018 | 1.8021 | 1.8004 | 1.8004 | 74200.0 |
| 2005-09-16 08:55:00 | AAPL | Stock | 1.7996 | 1.8 | 1.7989 | 1.7996 | 69300.0 |
| 2005-09-16 09:00:00 | AAPL | Stock | 1.8 | 1.8007 | 1.7996 | 1.7996 | 72800.0 |
| 2005-09-16 09:05:00 | AAPL | Stock | 1.8014 | 1.8014 | 1.7996 | 1.7996 | 120400.0 |
| 2005-09-16 09:10:00 | AAPL | Stock | 1.7996 | 1.8 | 1.7979 | 1.8 | 215600.0 |
| 2005-09-16 09:15:00 | AAPL | Stock | 1.8 | 1.8 | 1.7993 | 1.8 | 48916.0 |
| 2005-09-16 09:20:00 | AAPL | Stock | 1.8 | 1.8 | 1.7982 | 1.7982 | 19600.0 |
| 2005-09-16 09:25:00 | AAPL | Stock | 1.7954 | 1.7989 | 1.7936 | 1.7936 | 872564.0 |
| 2005-09-16 09:30:00 | AAPL | Stock | 1.7939 | 1.7982 | 1.7929 | 1.7957 | 87211460.0 |
| 2005-09-16 09:35:00 | AAPL | Stock | 1.7957 | 1.7979 | 1.7936 | 1.7936 | 10521728.0 |
| 2005-09-16 09:40:00 | AAPL | Stock | 1.7936 | 1.8025 | 1.7936 | 1.8007 | 12130468.0 |
| 2005-09-16 09:45:00 | AAPL | Stock | 1.8007 | 1.8036 | 1.7936 | 1.7943 | 13500060.0 |
| 2005-09-16 09:50:00 | AAPL | Stock | 1.7939 | 1.7939 | 1.7864 | 1.7896 | 12452860.0 |
| 2005-09-16 09:55:00 | AAPL | Stock | 1.7893 | 1.7971 | 1.7889 | 1.7932 | 6942208.0 |
| 2005-09-16 10:00:00 | AAPL | Stock | 1.7932 | 1.7957 | 1.7914 | 1.7914 | 5651548.0 |
| 2005-09-16 10:05:00 | AAPL | Stock | 1.7914 | 1.7982 | 1.7896 | 1.7946 | 9200408.0 |
| 2005-09-16 10:10:00 | AAPL | Stock | 1.7946 | 1.7986 | 1.7946 | 1.7975 | 5995780.0 |
| 2005-09-16 10:15:00 | AAPL | Stock | 1.7979 | 1.7979 | 1.7936 | 1.7954 | 5249020.0 |
| 2005-09-16 10:20:00 | AAPL | Stock | 1.795 | 1.7957 | 1.7925 | 1.7929 | 3410064.0 |
| 2005-09-16 10:25:00 | AAPL | Stock | 1.7932 | 1.7936 | 1.7914 | 1.7918 | 5016844.0 |
| 2005-09-16 10:30:00 | AAPL | Stock | 1.7914 | 1.7936 | 1.7857 | 1.7864 | 8164940.0 |
| 2005-09-16 10:35:00 | AAPL | Stock | 1.7861 | 1.7925 | 1.7854 | 1.7907 | 6818504.0 |
| 2005-09-16 10:40:00 | AAPL | Stock | 1.7907 | 1.7911 | 1.7879 | 1.79 | 3709440.0 |
| 2005-09-16 10:45:00 | AAPL | Stock | 1.79 | 1.7907 | 1.7886 | 1.79 | 1941464.0 |
| 2005-09-16 10:50:00 | AAPL | Stock | 1.7896 | 1.7929 | 1.7896 | 1.7904 | 2599828.0 |
| 2005-09-16 10:55:00 | AAPL | Stock | 1.7904 | 1.7914 | 1.7882 | 1.79 | 4290972.0 |
| 2005-09-16 11:00:00 | AAPL | Stock | 1.79 | 1.7911 | 1.7843 | 1.7846 | 5045404.0 |
| 2005-09-16 11:05:00 | AAPL | Stock | 1.7843 | 1.7918 | 1.7839 | 1.7889 | 7788452.0 |
| 2005-09-16 11:10:00 | AAPL | Stock | 1.7893 | 1.7907 | 1.7854 | 1.7896 | 4367860.0 |
| 2005-09-16 11:15:00 | AAPL | Stock | 1.7893 | 1.7932 | 1.7886 | 1.7918 | 6483960.0 |
| 2005-09-16 11:20:00 | AAPL | Stock | 1.7921 | 1.7946 | 1.7914 | 1.7946 | 6967464.0 |
| 2005-09-16 11:25:00 | AAPL | Stock | 1.7946 | 1.7946 | 1.7932 | 1.7932 | 2199176.0 |
| 2005-09-16 11:30:00 | AAPL | Stock | 1.7932 | 1.7932 | 1.7907 | 1.7907 | 2105796.0 |
| 2005-09-16 11:35:00 | AAPL | Stock | 1.7911 | 1.7932 | 1.7896 | 1.7929 | 4085032.0 |
| 2005-09-16 11:40:00 | AAPL | Stock | 1.7929 | 1.7957 | 1.7928 | 1.7943 | 2928212.0 |
| 2005-09-16 11:45:00 | AAPL | Stock | 1.7939 | 1.7957 | 1.7925 | 1.7954 | 2712192.0 |
| 2005-09-16 11:50:00 | AAPL | Stock | 1.7954 | 1.7975 | 1.7939 | 1.795 | 4414592.0 |
| 2005-09-16 11:55:00 | AAPL | Stock | 1.795 | 1.7957 | 1.7911 | 1.7918 | 2789668.0 |
> showing 50 of 207,596 rows — these rows as CSV