PREVIEW / stock_1min / 2005-06-06
file: by_date/stock_1min/2005/2005-06-06.parquet size: 6.6 MB rows: 548,279 symbols: 1,629
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 |
|---|---|---|---|---|---|---|---|
| 2005-06-06 07:00:00 | AAPL | Stock | 1.3689 | 1.3689 | 1.3689 | 1.3689 | 2800.0 |
| 2005-06-06 07:04:00 | AAPL | Stock | 1.3818 | 1.3821 | 1.3818 | 1.3821 | 30800.0 |
| 2005-06-06 07:06:00 | AAPL | Stock | 1.3925 | 1.3925 | 1.3925 | 1.3925 | 22400.0 |
| 2005-06-06 07:07:00 | AAPL | Stock | 1.3857 | 1.3857 | 1.3857 | 1.3857 | 28000.0 |
| 2005-06-06 07:09:00 | AAPL | Stock | 1.3893 | 1.3929 | 1.3893 | 1.3929 | 56000.0 |
| 2005-06-06 07:11:00 | AAPL | Stock | 1.4 | 1.4 | 1.4 | 1.4 | 28000.0 |
| 2005-06-06 07:19:00 | AAPL | Stock | 1.3982 | 1.4 | 1.3982 | 1.4 | 36400.0 |
| 2005-06-06 07:20:00 | AAPL | Stock | 1.4 | 1.4 | 1.4 | 1.4 | 14000.0 |
| 2005-06-06 07:36:00 | AAPL | Stock | 1.3929 | 1.3929 | 1.3929 | 1.3929 | 30800.0 |
| 2005-06-06 07:42:00 | AAPL | Stock | 1.3946 | 1.3946 | 1.3946 | 1.3946 | 5600.0 |
| 2005-06-06 07:44:00 | AAPL | Stock | 1.3929 | 1.3929 | 1.3929 | 1.3929 | 14000.0 |
| 2005-06-06 07:45:00 | AAPL | Stock | 1.3946 | 1.3946 | 1.3946 | 1.3946 | 25200.0 |
| 2005-06-06 07:49:00 | AAPL | Stock | 1.3946 | 1.3946 | 1.3946 | 1.3946 | 28000.0 |
| 2005-06-06 07:53:00 | AAPL | Stock | 1.3946 | 1.3946 | 1.3946 | 1.3946 | 14000.0 |
| 2005-06-06 07:56:00 | AAPL | Stock | 1.3929 | 1.3929 | 1.3929 | 1.3929 | 64820.0 |
| 2005-06-06 07:59:00 | AAPL | Stock | 1.3921 | 1.3921 | 1.3921 | 1.3921 | 8400.0 |
| 2005-06-06 08:00:00 | AAPL | Stock | 1.3921 | 1.3946 | 1.3814 | 1.3929 | 137200.0 |
| 2005-06-06 08:01:00 | AAPL | Stock | 1.3921 | 1.3946 | 1.3911 | 1.3932 | 1305024.0 |
| 2005-06-06 08:02:00 | AAPL | Stock | 1.3932 | 1.3939 | 1.3925 | 1.3929 | 254800.0 |
| 2005-06-06 08:03:00 | AAPL | Stock | 1.3929 | 1.3936 | 1.3896 | 1.3921 | 238056.0 |
| 2005-06-06 08:04:00 | AAPL | Stock | 1.3921 | 1.3921 | 1.3893 | 1.3893 | 105000.0 |
| 2005-06-06 08:05:00 | AAPL | Stock | 1.3921 | 1.3921 | 1.3893 | 1.3893 | 60900.0 |
| 2005-06-06 08:06:00 | AAPL | Stock | 1.3893 | 1.3893 | 1.3875 | 1.3889 | 182952.0 |
| 2005-06-06 08:07:00 | AAPL | Stock | 1.3879 | 1.3929 | 1.3879 | 1.3879 | 145600.0 |
| 2005-06-06 08:08:00 | AAPL | Stock | 1.3875 | 1.3886 | 1.3861 | 1.3861 | 165228.0 |
| 2005-06-06 08:09:00 | AAPL | Stock | 1.3871 | 1.3871 | 1.3839 | 1.3839 | 151200.0 |
| 2005-06-06 08:10:00 | AAPL | Stock | 1.3825 | 1.3843 | 1.3821 | 1.3839 | 84000.0 |
| 2005-06-06 08:11:00 | AAPL | Stock | 1.3843 | 1.385 | 1.3843 | 1.3843 | 25200.0 |
| 2005-06-06 08:13:00 | AAPL | Stock | 1.3832 | 1.3839 | 1.3832 | 1.3839 | 39200.0 |
| 2005-06-06 08:14:00 | AAPL | Stock | 1.3839 | 1.3846 | 1.3839 | 1.3846 | 27328.0 |
| 2005-06-06 08:15:00 | AAPL | Stock | 1.3839 | 1.3839 | 1.3829 | 1.3829 | 65240.0 |
| 2005-06-06 08:16:00 | AAPL | Stock | 1.3839 | 1.3839 | 1.3832 | 1.3839 | 49448.0 |
| 2005-06-06 08:17:00 | AAPL | Stock | 1.3832 | 1.3832 | 1.3829 | 1.3829 | 21560.0 |
| 2005-06-06 08:18:00 | AAPL | Stock | 1.3832 | 1.3868 | 1.3832 | 1.3868 | 108752.0 |
| 2005-06-06 08:19:00 | AAPL | Stock | 1.3857 | 1.3861 | 1.3832 | 1.3832 | 200060.0 |
| 2005-06-06 08:22:00 | AAPL | Stock | 1.3832 | 1.3832 | 1.3829 | 1.3829 | 19600.0 |
| 2005-06-06 08:23:00 | AAPL | Stock | 1.3821 | 1.3825 | 1.3814 | 1.3814 | 481600.0 |
| 2005-06-06 08:24:00 | AAPL | Stock | 1.3807 | 1.3807 | 1.3807 | 1.3807 | 5600.0 |
| 2005-06-06 08:25:00 | AAPL | Stock | 1.3786 | 1.3793 | 1.3782 | 1.3793 | 36400.0 |
| 2005-06-06 08:26:00 | AAPL | Stock | 1.3807 | 1.3811 | 1.38 | 1.38 | 81200.0 |
| 2005-06-06 08:27:00 | AAPL | Stock | 1.38 | 1.38 | 1.3786 | 1.3786 | 78400.0 |
| 2005-06-06 08:28:00 | AAPL | Stock | 1.3789 | 1.3804 | 1.3789 | 1.3804 | 183960.0 |
| 2005-06-06 08:29:00 | AAPL | Stock | 1.3793 | 1.3804 | 1.3789 | 1.38 | 39200.0 |
| 2005-06-06 08:30:00 | AAPL | Stock | 1.3807 | 1.3807 | 1.3807 | 1.3807 | 2800.0 |
| 2005-06-06 08:31:00 | AAPL | Stock | 1.3807 | 1.3821 | 1.3807 | 1.3821 | 56000.0 |
| 2005-06-06 08:32:00 | AAPL | Stock | 1.3821 | 1.385 | 1.3821 | 1.3846 | 98392.0 |
| 2005-06-06 08:33:00 | AAPL | Stock | 1.385 | 1.385 | 1.3821 | 1.3832 | 203000.0 |
| 2005-06-06 08:34:00 | AAPL | Stock | 1.3839 | 1.3843 | 1.3839 | 1.3843 | 25200.0 |
| 2005-06-06 08:35:00 | AAPL | Stock | 1.3829 | 1.3839 | 1.3821 | 1.3821 | 170800.0 |
| 2005-06-06 08:36:00 | AAPL | Stock | 1.3818 | 1.3818 | 1.3807 | 1.3814 | 81200.0 |
> showing 50 of 548,279 rows — these rows as CSV