PREVIEW / stock_1min / 2004-06-23
file: by_date/stock_1min/2004/2004-06-23.parquet size: 6.1 MB rows: 513,472 symbols: 1,474
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-06-23 08:16:00 | AAPL | Stock | 0.5875 | 0.5875 | 0.5875 | 0.5875 | 5600.0 |
| 2004-06-23 08:21:00 | AAPL | Stock | 0.5884 | 0.5884 | 0.5884 | 0.5884 | 33600.0 |
| 2004-06-23 08:23:00 | AAPL | Stock | 0.5884 | 0.5893 | 0.5884 | 0.5893 | 112000.0 |
| 2004-06-23 08:54:00 | AAPL | Stock | 0.5893 | 0.5893 | 0.5893 | 0.5893 | 5600.0 |
| 2004-06-23 09:08:00 | AAPL | Stock | 0.5848 | 0.5848 | 0.5848 | 0.5848 | 22400.0 |
| 2004-06-23 09:20:00 | AAPL | Stock | 0.5884 | 0.5884 | 0.5884 | 0.5884 | 5600.0 |
| 2004-06-23 09:29:00 | AAPL | Stock | 0.5891 | 0.5898 | 0.5891 | 0.5893 | 550368.0 |
| 2004-06-23 09:30:00 | AAPL | Stock | 0.5893 | 0.5896 | 0.5873 | 0.5882 | 5360544.0 |
| 2004-06-23 09:31:00 | AAPL | Stock | 0.5881 | 0.5884 | 0.5875 | 0.5879 | 1149848.0 |
| 2004-06-23 09:32:00 | AAPL | Stock | 0.5875 | 0.5884 | 0.5875 | 0.5884 | 1265264.0 |
| 2004-06-23 09:33:00 | AAPL | Stock | 0.5879 | 0.5893 | 0.5879 | 0.5893 | 5321512.0 |
| 2004-06-23 09:34:00 | AAPL | Stock | 0.5893 | 0.5893 | 0.5884 | 0.5886 | 1887200.0 |
| 2004-06-23 09:35:00 | AAPL | Stock | 0.5884 | 0.5884 | 0.5882 | 0.5884 | 541800.0 |
| 2004-06-23 09:36:00 | AAPL | Stock | 0.5884 | 0.5895 | 0.5884 | 0.5886 | 796768.0 |
| 2004-06-23 09:37:00 | AAPL | Stock | 0.5888 | 0.5891 | 0.5886 | 0.5891 | 1184400.0 |
| 2004-06-23 09:38:00 | AAPL | Stock | 0.5893 | 0.5893 | 0.5891 | 0.5891 | 1156512.0 |
| 2004-06-23 09:39:00 | AAPL | Stock | 0.5893 | 0.5898 | 0.5891 | 0.5895 | 2210992.0 |
| 2004-06-23 09:40:00 | AAPL | Stock | 0.5895 | 0.5898 | 0.5886 | 0.5891 | 4368112.0 |
| 2004-06-23 09:41:00 | AAPL | Stock | 0.5891 | 0.5893 | 0.588 | 0.588 | 874160.0 |
| 2004-06-23 09:42:00 | AAPL | Stock | 0.5884 | 0.5893 | 0.5884 | 0.5889 | 1523760.0 |
| 2004-06-23 09:43:00 | AAPL | Stock | 0.5891 | 0.5893 | 0.5889 | 0.5893 | 2004800.0 |
| 2004-06-23 09:44:00 | AAPL | Stock | 0.5893 | 0.5896 | 0.5875 | 0.5875 | 1784048.0 |
| 2004-06-23 09:45:00 | AAPL | Stock | 0.5875 | 0.5891 | 0.5875 | 0.5888 | 1495200.0 |
| 2004-06-23 09:46:00 | AAPL | Stock | 0.5888 | 0.5888 | 0.5875 | 0.5877 | 259560.0 |
| 2004-06-23 09:47:00 | AAPL | Stock | 0.5877 | 0.5882 | 0.5875 | 0.588 | 1091048.0 |
| 2004-06-23 09:48:00 | AAPL | Stock | 0.588 | 0.5891 | 0.5875 | 0.5891 | 1241800.0 |
| 2004-06-23 09:49:00 | AAPL | Stock | 0.5891 | 0.5891 | 0.588 | 0.588 | 869736.0 |
| 2004-06-23 09:50:00 | AAPL | Stock | 0.5882 | 0.5889 | 0.5879 | 0.588 | 628936.0 |
| 2004-06-23 09:51:00 | AAPL | Stock | 0.5879 | 0.5882 | 0.5877 | 0.588 | 623280.0 |
| 2004-06-23 09:52:00 | AAPL | Stock | 0.5879 | 0.5891 | 0.5879 | 0.5889 | 1270024.0 |
| 2004-06-23 09:53:00 | AAPL | Stock | 0.5889 | 0.5889 | 0.588 | 0.588 | 747544.0 |
| 2004-06-23 09:54:00 | AAPL | Stock | 0.588 | 0.588 | 0.5877 | 0.588 | 396424.0 |
| 2004-06-23 09:55:00 | AAPL | Stock | 0.588 | 0.5888 | 0.588 | 0.5888 | 709520.0 |
| 2004-06-23 09:56:00 | AAPL | Stock | 0.5884 | 0.5888 | 0.588 | 0.5882 | 529648.0 |
| 2004-06-23 09:57:00 | AAPL | Stock | 0.5882 | 0.5888 | 0.5882 | 0.5888 | 693224.0 |
| 2004-06-23 09:58:00 | AAPL | Stock | 0.5888 | 0.5891 | 0.5875 | 0.5879 | 1490888.0 |
| 2004-06-23 09:59:00 | AAPL | Stock | 0.5879 | 0.5884 | 0.5879 | 0.5882 | 1361472.0 |
| 2004-06-23 10:00:00 | AAPL | Stock | 0.5884 | 0.5889 | 0.5877 | 0.5889 | 562968.0 |
| 2004-06-23 10:01:00 | AAPL | Stock | 0.5889 | 0.5889 | 0.588 | 0.5882 | 201600.0 |
| 2004-06-23 10:02:00 | AAPL | Stock | 0.5884 | 0.5889 | 0.5884 | 0.5889 | 503104.0 |
| 2004-06-23 10:03:00 | AAPL | Stock | 0.5889 | 0.5889 | 0.5882 | 0.5888 | 142352.0 |
| 2004-06-23 10:04:00 | AAPL | Stock | 0.5886 | 0.5891 | 0.5886 | 0.5891 | 386400.0 |
| 2004-06-23 10:05:00 | AAPL | Stock | 0.5891 | 0.5891 | 0.5888 | 0.5889 | 247072.0 |
| 2004-06-23 10:06:00 | AAPL | Stock | 0.5891 | 0.5891 | 0.5888 | 0.5889 | 608720.0 |
| 2004-06-23 10:07:00 | AAPL | Stock | 0.5888 | 0.5889 | 0.5888 | 0.5888 | 302400.0 |
| 2004-06-23 10:08:00 | AAPL | Stock | 0.5888 | 0.5889 | 0.5888 | 0.5888 | 84000.0 |
| 2004-06-23 10:09:00 | AAPL | Stock | 0.5891 | 0.5891 | 0.5888 | 0.5888 | 224000.0 |
| 2004-06-23 10:10:00 | AAPL | Stock | 0.5889 | 0.5889 | 0.5888 | 0.5889 | 306600.0 |
| 2004-06-23 10:11:00 | AAPL | Stock | 0.5888 | 0.5893 | 0.5886 | 0.5893 | 655200.0 |
| 2004-06-23 10:12:00 | AAPL | Stock | 0.5891 | 0.5893 | 0.5886 | 0.5889 | 565600.0 |
> showing 50 of 513,472 rows — these rows as CSV