PREVIEW / stock_1min / 2004-07-16
file: by_date/stock_1min/2004/2004-07-16.parquet size: 5.7 MB rows: 479,912 symbols: 1,473
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-07-16 08:01:00 | AAPL | Stock | 0.5893 | 0.5893 | 0.5857 | 0.5857 | 369600.0 |
| 2004-07-16 08:02:00 | AAPL | Stock | 0.588 | 0.588 | 0.588 | 0.588 | 56000.0 |
| 2004-07-16 08:03:00 | AAPL | Stock | 0.5875 | 0.5882 | 0.5873 | 0.5882 | 56000.0 |
| 2004-07-16 08:13:00 | AAPL | Stock | 0.5857 | 0.5863 | 0.5857 | 0.5863 | 44800.0 |
| 2004-07-16 08:19:00 | AAPL | Stock | 0.5863 | 0.5863 | 0.5863 | 0.5863 | 16800.0 |
| 2004-07-16 08:30:00 | AAPL | Stock | 0.5866 | 0.5866 | 0.5866 | 0.5866 | 11200.0 |
| 2004-07-16 08:32:00 | AAPL | Stock | 0.5871 | 0.5871 | 0.5871 | 0.5871 | 11200.0 |
| 2004-07-16 08:36:00 | AAPL | Stock | 0.5857 | 0.5857 | 0.5857 | 0.5857 | 5600.0 |
| 2004-07-16 08:38:00 | AAPL | Stock | 0.5857 | 0.5857 | 0.5857 | 0.5857 | 5600.0 |
| 2004-07-16 08:40:00 | AAPL | Stock | 0.5857 | 0.5857 | 0.5857 | 0.5857 | 5600.0 |
| 2004-07-16 09:01:00 | AAPL | Stock | 0.5857 | 0.5861 | 0.5857 | 0.5857 | 218400.0 |
| 2004-07-16 09:03:00 | AAPL | Stock | 0.5857 | 0.5857 | 0.5857 | 0.5857 | 16800.0 |
| 2004-07-16 09:06:00 | AAPL | Stock | 0.5857 | 0.5857 | 0.5857 | 0.5857 | 50400.0 |
| 2004-07-16 09:09:00 | AAPL | Stock | 0.5866 | 0.5866 | 0.5866 | 0.5866 | 112000.0 |
| 2004-07-16 09:14:00 | AAPL | Stock | 0.5866 | 0.5866 | 0.5866 | 0.5866 | 11200.0 |
| 2004-07-16 09:17:00 | AAPL | Stock | 0.5879 | 0.5879 | 0.5879 | 0.5879 | 16800.0 |
| 2004-07-16 09:18:00 | AAPL | Stock | 0.5879 | 0.5879 | 0.5879 | 0.5879 | 39200.0 |
| 2004-07-16 09:19:00 | AAPL | Stock | 0.5879 | 0.5879 | 0.5879 | 0.5879 | 5600.0 |
| 2004-07-16 09:25:00 | AAPL | Stock | 0.5868 | 0.5868 | 0.5866 | 0.5868 | 106400.0 |
| 2004-07-16 09:26:00 | AAPL | Stock | 0.5866 | 0.5866 | 0.5852 | 0.5852 | 71680.0 |
| 2004-07-16 09:27:00 | AAPL | Stock | 0.5857 | 0.5857 | 0.5857 | 0.5857 | 54880.0 |
| 2004-07-16 09:29:00 | AAPL | Stock | 0.5866 | 0.5871 | 0.5861 | 0.5861 | 470792.0 |
| 2004-07-16 09:30:00 | AAPL | Stock | 0.5879 | 0.5879 | 0.5823 | 0.5829 | 11935168.0 |
| 2004-07-16 09:31:00 | AAPL | Stock | 0.5829 | 0.5859 | 0.5823 | 0.5827 | 2434712.0 |
| 2004-07-16 09:32:00 | AAPL | Stock | 0.5829 | 0.5848 | 0.5827 | 0.5848 | 2070992.0 |
| 2004-07-16 09:33:00 | AAPL | Stock | 0.5846 | 0.5848 | 0.5839 | 0.5841 | 2768080.0 |
| 2004-07-16 09:34:00 | AAPL | Stock | 0.5841 | 0.5848 | 0.5841 | 0.5848 | 1741320.0 |
| 2004-07-16 09:35:00 | AAPL | Stock | 0.5846 | 0.5859 | 0.5846 | 0.5854 | 3041696.0 |
| 2004-07-16 09:36:00 | AAPL | Stock | 0.5855 | 0.5857 | 0.5846 | 0.5846 | 1731968.0 |
| 2004-07-16 09:37:00 | AAPL | Stock | 0.5846 | 0.5848 | 0.5846 | 0.5848 | 495600.0 |
| 2004-07-16 09:38:00 | AAPL | Stock | 0.5848 | 0.5855 | 0.5846 | 0.585 | 874160.0 |
| 2004-07-16 09:39:00 | AAPL | Stock | 0.585 | 0.5855 | 0.5838 | 0.5843 | 3261944.0 |
| 2004-07-16 09:40:00 | AAPL | Stock | 0.5843 | 0.5848 | 0.5838 | 0.5843 | 1687224.0 |
| 2004-07-16 09:41:00 | AAPL | Stock | 0.5838 | 0.5838 | 0.5804 | 0.5823 | 5386528.0 |
| 2004-07-16 09:42:00 | AAPL | Stock | 0.5823 | 0.5823 | 0.5814 | 0.5818 | 3219944.0 |
| 2004-07-16 09:43:00 | AAPL | Stock | 0.5818 | 0.5823 | 0.5816 | 0.5823 | 1682800.0 |
| 2004-07-16 09:44:00 | AAPL | Stock | 0.5823 | 0.5823 | 0.5807 | 0.5807 | 2232160.0 |
| 2004-07-16 09:45:00 | AAPL | Stock | 0.5807 | 0.5818 | 0.5798 | 0.5805 | 2856672.0 |
| 2004-07-16 09:46:00 | AAPL | Stock | 0.5804 | 0.582 | 0.5804 | 0.5818 | 2136064.0 |
| 2004-07-16 09:47:00 | AAPL | Stock | 0.5814 | 0.5837 | 0.5814 | 0.5829 | 1392104.0 |
| 2004-07-16 09:48:00 | AAPL | Stock | 0.583 | 0.5838 | 0.582 | 0.5821 | 2171960.0 |
| 2004-07-16 09:49:00 | AAPL | Stock | 0.5823 | 0.5829 | 0.5813 | 0.5816 | 2261504.0 |
| 2004-07-16 09:50:00 | AAPL | Stock | 0.582 | 0.5821 | 0.5813 | 0.582 | 2519552.0 |
| 2004-07-16 09:51:00 | AAPL | Stock | 0.582 | 0.5827 | 0.5816 | 0.5816 | 2054024.0 |
| 2004-07-16 09:52:00 | AAPL | Stock | 0.5818 | 0.5821 | 0.5804 | 0.5813 | 3637704.0 |
| 2004-07-16 09:53:00 | AAPL | Stock | 0.5805 | 0.5809 | 0.58 | 0.5804 | 1420888.0 |
| 2004-07-16 09:54:00 | AAPL | Stock | 0.5804 | 0.5813 | 0.5804 | 0.5809 | 1192408.0 |
| 2004-07-16 09:55:00 | AAPL | Stock | 0.5811 | 0.5821 | 0.5805 | 0.5818 | 790552.0 |
| 2004-07-16 09:56:00 | AAPL | Stock | 0.582 | 0.5823 | 0.5816 | 0.582 | 810600.0 |
| 2004-07-16 09:57:00 | AAPL | Stock | 0.5821 | 0.5821 | 0.5818 | 0.5818 | 878976.0 |
> showing 50 of 479,912 rows — these rows as CSV