PREVIEW / stock_1min / 2004-04-26
file: by_date/stock_1min/2004/2004-04-26.parquet size: 5.8 MB rows: 481,600 symbols: 1,442
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-04-26 08:01:00 | AAPL | Stock | 0.4952 | 0.4952 | 0.4952 | 0.4952 | 11200.0 |
| 2004-04-26 08:13:00 | AAPL | Stock | 0.4946 | 0.4946 | 0.4946 | 0.4946 | 11200.0 |
| 2004-04-26 08:38:00 | AAPL | Stock | 0.4946 | 0.4946 | 0.4946 | 0.4946 | 5600.0 |
| 2004-04-26 08:40:00 | AAPL | Stock | 0.4955 | 0.4955 | 0.4955 | 0.4955 | 44800.0 |
| 2004-04-26 08:45:00 | AAPL | Stock | 0.4955 | 0.4955 | 0.4938 | 0.4938 | 92400.0 |
| 2004-04-26 09:14:00 | AAPL | Stock | 0.4945 | 0.4945 | 0.4945 | 0.4945 | 39200.0 |
| 2004-04-26 09:23:00 | AAPL | Stock | 0.4938 | 0.4938 | 0.4938 | 0.4938 | 78400.0 |
| 2004-04-26 09:24:00 | AAPL | Stock | 0.4938 | 0.4938 | 0.4938 | 0.4938 | 11200.0 |
| 2004-04-26 09:25:00 | AAPL | Stock | 0.4938 | 0.4938 | 0.4938 | 0.4938 | 11200.0 |
| 2004-04-26 09:29:00 | AAPL | Stock | 0.4938 | 0.4938 | 0.4927 | 0.4929 | 109704.0 |
| 2004-04-26 09:30:00 | AAPL | Stock | 0.4925 | 0.493 | 0.492 | 0.493 | 3743208.0 |
| 2004-04-26 09:31:00 | AAPL | Stock | 0.493 | 0.4935 | 0.4923 | 0.4925 | 3161592.0 |
| 2004-04-26 09:32:00 | AAPL | Stock | 0.4925 | 0.4929 | 0.4918 | 0.4921 | 3455704.0 |
| 2004-04-26 09:33:00 | AAPL | Stock | 0.4916 | 0.4918 | 0.4913 | 0.4918 | 644000.0 |
| 2004-04-26 09:34:00 | AAPL | Stock | 0.4918 | 0.4921 | 0.4914 | 0.4921 | 1030064.0 |
| 2004-04-26 09:35:00 | AAPL | Stock | 0.4921 | 0.4927 | 0.4921 | 0.4927 | 604800.0 |
| 2004-04-26 09:36:00 | AAPL | Stock | 0.4927 | 0.4927 | 0.4921 | 0.4921 | 425600.0 |
| 2004-04-26 09:37:00 | AAPL | Stock | 0.492 | 0.492 | 0.4914 | 0.4916 | 487200.0 |
| 2004-04-26 09:38:00 | AAPL | Stock | 0.4916 | 0.4918 | 0.4905 | 0.4905 | 394800.0 |
| 2004-04-26 09:39:00 | AAPL | Stock | 0.4902 | 0.4905 | 0.4896 | 0.4902 | 284480.0 |
| 2004-04-26 09:40:00 | AAPL | Stock | 0.49 | 0.4911 | 0.49 | 0.4911 | 755944.0 |
| 2004-04-26 09:41:00 | AAPL | Stock | 0.4911 | 0.4913 | 0.4902 | 0.4905 | 981288.0 |
| 2004-04-26 09:42:00 | AAPL | Stock | 0.4907 | 0.4927 | 0.4902 | 0.4925 | 1413384.0 |
| 2004-04-26 09:43:00 | AAPL | Stock | 0.4923 | 0.4927 | 0.4913 | 0.4921 | 1177344.0 |
| 2004-04-26 09:44:00 | AAPL | Stock | 0.4921 | 0.4927 | 0.4921 | 0.4925 | 1289736.0 |
| 2004-04-26 09:45:00 | AAPL | Stock | 0.4923 | 0.4929 | 0.4921 | 0.4925 | 912800.0 |
| 2004-04-26 09:46:00 | AAPL | Stock | 0.4927 | 0.4927 | 0.4925 | 0.4925 | 459200.0 |
| 2004-04-26 09:47:00 | AAPL | Stock | 0.4927 | 0.4927 | 0.4925 | 0.4925 | 84000.0 |
| 2004-04-26 09:48:00 | AAPL | Stock | 0.4925 | 0.4927 | 0.492 | 0.492 | 650496.0 |
| 2004-04-26 09:49:00 | AAPL | Stock | 0.492 | 0.4921 | 0.492 | 0.4921 | 100800.0 |
| 2004-04-26 09:50:00 | AAPL | Stock | 0.492 | 0.4921 | 0.4911 | 0.492 | 1584800.0 |
| 2004-04-26 09:51:00 | AAPL | Stock | 0.492 | 0.4925 | 0.4913 | 0.492 | 2486288.0 |
| 2004-04-26 09:52:00 | AAPL | Stock | 0.4914 | 0.492 | 0.4913 | 0.492 | 268800.0 |
| 2004-04-26 09:53:00 | AAPL | Stock | 0.4918 | 0.4921 | 0.4918 | 0.4921 | 433664.0 |
| 2004-04-26 09:54:00 | AAPL | Stock | 0.4923 | 0.4923 | 0.492 | 0.492 | 1002288.0 |
| 2004-04-26 09:55:00 | AAPL | Stock | 0.492 | 0.4927 | 0.492 | 0.4921 | 589680.0 |
| 2004-04-26 09:56:00 | AAPL | Stock | 0.4923 | 0.4929 | 0.4923 | 0.4929 | 173600.0 |
| 2004-04-26 09:57:00 | AAPL | Stock | 0.4927 | 0.4929 | 0.4921 | 0.4923 | 424312.0 |
| 2004-04-26 09:58:00 | AAPL | Stock | 0.4926 | 0.4926 | 0.492 | 0.492 | 142800.0 |
| 2004-04-26 09:59:00 | AAPL | Stock | 0.4923 | 0.4923 | 0.4922 | 0.4922 | 67200.0 |
| 2004-04-26 10:00:00 | AAPL | Stock | 0.4923 | 0.4923 | 0.4922 | 0.4922 | 218288.0 |
| 2004-04-26 10:01:00 | AAPL | Stock | 0.4922 | 0.4923 | 0.49 | 0.4904 | 1732304.0 |
| 2004-04-26 10:02:00 | AAPL | Stock | 0.4902 | 0.4904 | 0.4902 | 0.4902 | 249200.0 |
| 2004-04-26 10:03:00 | AAPL | Stock | 0.4904 | 0.4904 | 0.4902 | 0.4902 | 403200.0 |
| 2004-04-26 10:04:00 | AAPL | Stock | 0.49 | 0.4902 | 0.4898 | 0.4898 | 548800.0 |
| 2004-04-26 10:05:00 | AAPL | Stock | 0.49 | 0.49 | 0.4898 | 0.4898 | 505344.0 |
| 2004-04-26 10:06:00 | AAPL | Stock | 0.4898 | 0.4899 | 0.4893 | 0.4893 | 594888.0 |
| 2004-04-26 10:07:00 | AAPL | Stock | 0.4891 | 0.4904 | 0.4888 | 0.4904 | 443800.0 |
| 2004-04-26 10:08:00 | AAPL | Stock | 0.4902 | 0.4902 | 0.49 | 0.49 | 77840.0 |
| 2004-04-26 10:09:00 | AAPL | Stock | 0.4901 | 0.4903 | 0.49 | 0.4903 | 324800.0 |
> showing 50 of 481,600 rows — these rows as CSV