PREVIEW / stock_1min / 2004-07-21
file: by_date/stock_1min/2004/2004-07-21.parquet size: 6.3 MB rows: 515,627 symbols: 1,482
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-21 08:01:00 | AAPL | Stock | 0.5782 | 0.5804 | 0.5782 | 0.5804 | 11200.0 |
| 2004-07-21 08:02:00 | AAPL | Stock | 0.5782 | 0.5786 | 0.5782 | 0.5786 | 11200.0 |
| 2004-07-21 08:22:00 | AAPL | Stock | 0.5804 | 0.5804 | 0.5804 | 0.5804 | 98224.0 |
| 2004-07-21 08:26:00 | AAPL | Stock | 0.5804 | 0.5804 | 0.5804 | 0.5804 | 22400.0 |
| 2004-07-21 08:30:00 | AAPL | Stock | 0.5804 | 0.5804 | 0.5804 | 0.5804 | 24976.0 |
| 2004-07-21 08:37:00 | AAPL | Stock | 0.5804 | 0.5804 | 0.5786 | 0.5786 | 224000.0 |
| 2004-07-21 09:14:00 | AAPL | Stock | 0.5795 | 0.5795 | 0.5795 | 0.5795 | 15624.0 |
| 2004-07-21 09:21:00 | AAPL | Stock | 0.5795 | 0.5795 | 0.5795 | 0.5795 | 28000.0 |
| 2004-07-21 09:23:00 | AAPL | Stock | 0.5795 | 0.5795 | 0.5795 | 0.5795 | 179200.0 |
| 2004-07-21 09:25:00 | AAPL | Stock | 0.5795 | 0.5795 | 0.5795 | 0.5795 | 28000.0 |
| 2004-07-21 09:29:00 | AAPL | Stock | 0.578 | 0.5786 | 0.5777 | 0.5777 | 86800.0 |
| 2004-07-21 09:30:00 | AAPL | Stock | 0.5768 | 0.5789 | 0.575 | 0.5789 | 3398080.0 |
| 2004-07-21 09:31:00 | AAPL | Stock | 0.5789 | 0.5802 | 0.5768 | 0.58 | 1120168.0 |
| 2004-07-21 09:32:00 | AAPL | Stock | 0.58 | 0.5804 | 0.5795 | 0.5796 | 1642592.0 |
| 2004-07-21 09:33:00 | AAPL | Stock | 0.5798 | 0.58 | 0.5796 | 0.58 | 824376.0 |
| 2004-07-21 09:34:00 | AAPL | Stock | 0.5798 | 0.58 | 0.5795 | 0.5798 | 511616.0 |
| 2004-07-21 09:35:00 | AAPL | Stock | 0.5796 | 0.58 | 0.5795 | 0.5795 | 720496.0 |
| 2004-07-21 09:36:00 | AAPL | Stock | 0.5796 | 0.58 | 0.5795 | 0.58 | 1242976.0 |
| 2004-07-21 09:37:00 | AAPL | Stock | 0.5796 | 0.5814 | 0.5795 | 0.5813 | 2324504.0 |
| 2004-07-21 09:38:00 | AAPL | Stock | 0.5814 | 0.583 | 0.5813 | 0.5823 | 1525832.0 |
| 2004-07-21 09:39:00 | AAPL | Stock | 0.5823 | 0.5825 | 0.5814 | 0.5823 | 951888.0 |
| 2004-07-21 09:40:00 | AAPL | Stock | 0.5823 | 0.5838 | 0.582 | 0.5836 | 2268896.0 |
| 2004-07-21 09:41:00 | AAPL | Stock | 0.5836 | 0.5839 | 0.5829 | 0.5838 | 1166144.0 |
| 2004-07-21 09:42:00 | AAPL | Stock | 0.5836 | 0.5839 | 0.5825 | 0.5827 | 881272.0 |
| 2004-07-21 09:43:00 | AAPL | Stock | 0.583 | 0.5839 | 0.5825 | 0.5838 | 1482264.0 |
| 2004-07-21 09:44:00 | AAPL | Stock | 0.5839 | 0.5841 | 0.5825 | 0.583 | 1121064.0 |
| 2004-07-21 09:45:00 | AAPL | Stock | 0.5827 | 0.5834 | 0.5816 | 0.582 | 993496.0 |
| 2004-07-21 09:46:00 | AAPL | Stock | 0.582 | 0.5838 | 0.5814 | 0.5832 | 2253832.0 |
| 2004-07-21 09:47:00 | AAPL | Stock | 0.5832 | 0.5834 | 0.5827 | 0.583 | 711200.0 |
| 2004-07-21 09:48:00 | AAPL | Stock | 0.5829 | 0.5832 | 0.5814 | 0.5816 | 2243248.0 |
| 2004-07-21 09:49:00 | AAPL | Stock | 0.5814 | 0.5825 | 0.5813 | 0.5816 | 1556240.0 |
| 2004-07-21 09:50:00 | AAPL | Stock | 0.5813 | 0.5821 | 0.5813 | 0.582 | 1340752.0 |
| 2004-07-21 09:51:00 | AAPL | Stock | 0.5816 | 0.5816 | 0.5802 | 0.5811 | 1954624.0 |
| 2004-07-21 09:52:00 | AAPL | Stock | 0.5805 | 0.5805 | 0.58 | 0.58 | 1102976.0 |
| 2004-07-21 09:53:00 | AAPL | Stock | 0.5802 | 0.5816 | 0.5796 | 0.5816 | 1005872.0 |
| 2004-07-21 09:54:00 | AAPL | Stock | 0.582 | 0.582 | 0.5807 | 0.5811 | 1442784.0 |
| 2004-07-21 09:55:00 | AAPL | Stock | 0.5813 | 0.5814 | 0.58 | 0.58 | 4029928.0 |
| 2004-07-21 09:56:00 | AAPL | Stock | 0.58 | 0.5814 | 0.5798 | 0.5814 | 2684360.0 |
| 2004-07-21 09:57:00 | AAPL | Stock | 0.5814 | 0.5818 | 0.5807 | 0.5807 | 1472800.0 |
| 2004-07-21 09:58:00 | AAPL | Stock | 0.5807 | 0.5811 | 0.5807 | 0.5807 | 585200.0 |
| 2004-07-21 09:59:00 | AAPL | Stock | 0.5805 | 0.5807 | 0.5804 | 0.5805 | 1019816.0 |
| 2004-07-21 10:00:00 | AAPL | Stock | 0.5804 | 0.5813 | 0.5804 | 0.5807 | 1292704.0 |
| 2004-07-21 10:01:00 | AAPL | Stock | 0.5807 | 0.5807 | 0.5804 | 0.5805 | 1904000.0 |
| 2004-07-21 10:02:00 | AAPL | Stock | 0.5807 | 0.5809 | 0.5805 | 0.5807 | 277200.0 |
| 2004-07-21 10:03:00 | AAPL | Stock | 0.5807 | 0.5811 | 0.5807 | 0.5811 | 560392.0 |
| 2004-07-21 10:04:00 | AAPL | Stock | 0.5811 | 0.5821 | 0.5811 | 0.5821 | 924000.0 |
| 2004-07-21 10:05:00 | AAPL | Stock | 0.5818 | 0.5827 | 0.5818 | 0.582 | 1824256.0 |
| 2004-07-21 10:06:00 | AAPL | Stock | 0.582 | 0.5821 | 0.5813 | 0.5814 | 610400.0 |
| 2004-07-21 10:07:00 | AAPL | Stock | 0.5813 | 0.5813 | 0.5811 | 0.5813 | 380800.0 |
| 2004-07-21 10:08:00 | AAPL | Stock | 0.5814 | 0.5821 | 0.5814 | 0.5821 | 830424.0 |
> showing 50 of 515,627 rows — these rows as CSV