PREVIEW / stock_1min / 2004-10-11
file: by_date/stock_1min/2004/2004-10-11.parquet size: 5.3 MB rows: 453,717 symbols: 1,495
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 |
|---|---|---|---|---|---|---|---|
| 2004-10-11 08:26:00 | AAPL | Stock | 0.6921 | 0.6921 | 0.6921 | 0.6921 | 5600.0 |
| 2004-10-11 08:38:00 | AAPL | Stock | 0.6929 | 0.6929 | 0.6929 | 0.6929 | 56000.0 |
| 2004-10-11 08:39:00 | AAPL | Stock | 0.6929 | 0.6929 | 0.6911 | 0.6911 | 120960.0 |
| 2004-10-11 08:41:00 | AAPL | Stock | 0.6911 | 0.6911 | 0.6911 | 0.6911 | 14560.0 |
| 2004-10-11 08:49:00 | AAPL | Stock | 0.692 | 0.692 | 0.692 | 0.692 | 5600.0 |
| 2004-10-11 09:00:00 | AAPL | Stock | 0.6929 | 0.6929 | 0.6929 | 0.6929 | 41440.0 |
| 2004-10-11 09:12:00 | AAPL | Stock | 0.692 | 0.692 | 0.692 | 0.692 | 134400.0 |
| 2004-10-11 09:14:00 | AAPL | Stock | 0.6929 | 0.6929 | 0.6929 | 0.6929 | 72800.0 |
| 2004-10-11 09:24:00 | AAPL | Stock | 0.6929 | 0.6929 | 0.6929 | 0.6929 | 28000.0 |
| 2004-10-11 09:25:00 | AAPL | Stock | 0.6929 | 0.6929 | 0.6929 | 0.6929 | 11200.0 |
| 2004-10-11 09:26:00 | AAPL | Stock | 0.6929 | 0.6929 | 0.6929 | 0.6929 | 28000.0 |
| 2004-10-11 09:27:00 | AAPL | Stock | 0.6929 | 0.6929 | 0.6929 | 0.6929 | 28000.0 |
| 2004-10-11 09:29:00 | AAPL | Stock | 0.6929 | 0.6932 | 0.6927 | 0.6929 | 128800.0 |
| 2004-10-11 09:30:00 | AAPL | Stock | 0.6929 | 0.6955 | 0.6927 | 0.6943 | 2622592.0 |
| 2004-10-11 09:31:00 | AAPL | Stock | 0.6934 | 0.6946 | 0.692 | 0.6932 | 1422176.0 |
| 2004-10-11 09:32:00 | AAPL | Stock | 0.6932 | 0.6943 | 0.692 | 0.6939 | 437528.0 |
| 2004-10-11 09:33:00 | AAPL | Stock | 0.6943 | 0.6943 | 0.6936 | 0.6939 | 1441776.0 |
| 2004-10-11 09:34:00 | AAPL | Stock | 0.6941 | 0.6946 | 0.693 | 0.6941 | 989184.0 |
| 2004-10-11 09:35:00 | AAPL | Stock | 0.6936 | 0.6938 | 0.6911 | 0.6921 | 3559528.0 |
| 2004-10-11 09:36:00 | AAPL | Stock | 0.6921 | 0.6941 | 0.6913 | 0.6939 | 1632288.0 |
| 2004-10-11 09:37:00 | AAPL | Stock | 0.6938 | 0.6945 | 0.6929 | 0.693 | 908712.0 |
| 2004-10-11 09:38:00 | AAPL | Stock | 0.6934 | 0.6938 | 0.6929 | 0.6929 | 1974280.0 |
| 2004-10-11 09:39:00 | AAPL | Stock | 0.6932 | 0.6932 | 0.6921 | 0.6921 | 649376.0 |
| 2004-10-11 09:40:00 | AAPL | Stock | 0.6921 | 0.6925 | 0.6909 | 0.6925 | 763840.0 |
| 2004-10-11 09:41:00 | AAPL | Stock | 0.6925 | 0.6929 | 0.6925 | 0.6929 | 344400.0 |
| 2004-10-11 09:42:00 | AAPL | Stock | 0.6929 | 0.6929 | 0.6925 | 0.6925 | 1132936.0 |
| 2004-10-11 09:43:00 | AAPL | Stock | 0.6929 | 0.6929 | 0.6923 | 0.6925 | 926408.0 |
| 2004-10-11 09:44:00 | AAPL | Stock | 0.6927 | 0.6927 | 0.6916 | 0.692 | 630112.0 |
| 2004-10-11 09:45:00 | AAPL | Stock | 0.6921 | 0.6921 | 0.6905 | 0.6905 | 1976128.0 |
| 2004-10-11 09:46:00 | AAPL | Stock | 0.6907 | 0.6925 | 0.6902 | 0.6902 | 1551200.0 |
| 2004-10-11 09:47:00 | AAPL | Stock | 0.69 | 0.692 | 0.6898 | 0.6905 | 2145360.0 |
| 2004-10-11 09:48:00 | AAPL | Stock | 0.6907 | 0.6907 | 0.69 | 0.6902 | 851200.0 |
| 2004-10-11 09:49:00 | AAPL | Stock | 0.6904 | 0.6904 | 0.6896 | 0.6896 | 851480.0 |
| 2004-10-11 09:50:00 | AAPL | Stock | 0.6898 | 0.6905 | 0.6884 | 0.6886 | 2596384.0 |
| 2004-10-11 09:51:00 | AAPL | Stock | 0.6886 | 0.6896 | 0.688 | 0.6882 | 2702560.0 |
| 2004-10-11 09:52:00 | AAPL | Stock | 0.6884 | 0.6893 | 0.6875 | 0.6875 | 2020144.0 |
| 2004-10-11 09:53:00 | AAPL | Stock | 0.6875 | 0.688 | 0.6848 | 0.6859 | 4177544.0 |
| 2004-10-11 09:54:00 | AAPL | Stock | 0.6861 | 0.6873 | 0.6846 | 0.6861 | 2689176.0 |
| 2004-10-11 09:55:00 | AAPL | Stock | 0.6863 | 0.6879 | 0.6854 | 0.6854 | 1631280.0 |
| 2004-10-11 09:56:00 | AAPL | Stock | 0.6855 | 0.6855 | 0.6821 | 0.6832 | 3066448.0 |
| 2004-10-11 09:57:00 | AAPL | Stock | 0.683 | 0.6843 | 0.6825 | 0.6832 | 3491936.0 |
| 2004-10-11 09:58:00 | AAPL | Stock | 0.6834 | 0.6836 | 0.6823 | 0.6827 | 1622992.0 |
| 2004-10-11 09:59:00 | AAPL | Stock | 0.6827 | 0.6841 | 0.6827 | 0.6839 | 4115832.0 |
| 2004-10-11 10:00:00 | AAPL | Stock | 0.6839 | 0.6846 | 0.6836 | 0.6846 | 2267888.0 |
| 2004-10-11 10:01:00 | AAPL | Stock | 0.6846 | 0.685 | 0.6841 | 0.6845 | 1378440.0 |
| 2004-10-11 10:02:00 | AAPL | Stock | 0.6845 | 0.6845 | 0.6827 | 0.6839 | 1961848.0 |
| 2004-10-11 10:03:00 | AAPL | Stock | 0.6841 | 0.685 | 0.6836 | 0.6843 | 2421160.0 |
| 2004-10-11 10:04:00 | AAPL | Stock | 0.6839 | 0.6844 | 0.6836 | 0.6838 | 1842400.0 |
| 2004-10-11 10:05:00 | AAPL | Stock | 0.6838 | 0.6845 | 0.6836 | 0.6838 | 2301656.0 |
| 2004-10-11 10:06:00 | AAPL | Stock | 0.6839 | 0.6848 | 0.6836 | 0.6846 | 2815848.0 |
> showing 50 of 453,717 rows — these rows as CSV