PREVIEW / stock_1min / 2004-02-05
file: by_date/stock_1min/2004/2004-02-05.parquet size: 6.1 MB rows: 496,444 symbols: 1,408
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-02-05 08:28:00 | AAPL | Stock | 0.3893 | 0.3904 | 0.3893 | 0.3904 | 56000.0 |
| 2004-02-05 08:30:00 | AAPL | Stock | 0.3893 | 0.3893 | 0.3893 | 0.3893 | 16800.0 |
| 2004-02-05 09:29:00 | AAPL | Stock | 0.3904 | 0.3904 | 0.3896 | 0.3896 | 61600.0 |
| 2004-02-05 09:30:00 | AAPL | Stock | 0.3896 | 0.3902 | 0.3895 | 0.3898 | 3135440.0 |
| 2004-02-05 09:31:00 | AAPL | Stock | 0.3898 | 0.3909 | 0.3895 | 0.3909 | 1252552.0 |
| 2004-02-05 09:32:00 | AAPL | Stock | 0.3902 | 0.3914 | 0.3896 | 0.3914 | 771904.0 |
| 2004-02-05 09:33:00 | AAPL | Stock | 0.3916 | 0.3932 | 0.3916 | 0.3929 | 2240504.0 |
| 2004-02-05 09:34:00 | AAPL | Stock | 0.393 | 0.3955 | 0.3929 | 0.395 | 2037224.0 |
| 2004-02-05 09:35:00 | AAPL | Stock | 0.395 | 0.3961 | 0.3946 | 0.3955 | 1569960.0 |
| 2004-02-05 09:36:00 | AAPL | Stock | 0.3952 | 0.3959 | 0.3946 | 0.3955 | 1432256.0 |
| 2004-02-05 09:37:00 | AAPL | Stock | 0.395 | 0.3955 | 0.3936 | 0.3943 | 3615024.0 |
| 2004-02-05 09:38:00 | AAPL | Stock | 0.3946 | 0.3946 | 0.3936 | 0.3936 | 1646400.0 |
| 2004-02-05 09:39:00 | AAPL | Stock | 0.3936 | 0.3941 | 0.3929 | 0.3929 | 1058400.0 |
| 2004-02-05 09:40:00 | AAPL | Stock | 0.3929 | 0.393 | 0.3923 | 0.3923 | 1293600.0 |
| 2004-02-05 09:41:00 | AAPL | Stock | 0.3923 | 0.3927 | 0.3923 | 0.3927 | 162400.0 |
| 2004-02-05 09:42:00 | AAPL | Stock | 0.3925 | 0.393 | 0.3925 | 0.393 | 1134280.0 |
| 2004-02-05 09:43:00 | AAPL | Stock | 0.3934 | 0.3938 | 0.3934 | 0.3938 | 201992.0 |
| 2004-02-05 09:44:00 | AAPL | Stock | 0.3938 | 0.3938 | 0.3936 | 0.3936 | 140000.0 |
| 2004-02-05 09:45:00 | AAPL | Stock | 0.3934 | 0.3938 | 0.3932 | 0.3932 | 285600.0 |
| 2004-02-05 09:46:00 | AAPL | Stock | 0.3929 | 0.3929 | 0.3929 | 0.3929 | 1105216.0 |
| 2004-02-05 09:47:00 | AAPL | Stock | 0.3929 | 0.3929 | 0.3929 | 0.3929 | 1803200.0 |
| 2004-02-05 09:48:00 | AAPL | Stock | 0.3929 | 0.3929 | 0.3927 | 0.3929 | 369600.0 |
| 2004-02-05 09:49:00 | AAPL | Stock | 0.3927 | 0.393 | 0.3925 | 0.3929 | 510664.0 |
| 2004-02-05 09:50:00 | AAPL | Stock | 0.3927 | 0.3936 | 0.3918 | 0.3936 | 1180536.0 |
| 2004-02-05 09:51:00 | AAPL | Stock | 0.3936 | 0.395 | 0.3936 | 0.3945 | 1054592.0 |
| 2004-02-05 09:52:00 | AAPL | Stock | 0.3941 | 0.3941 | 0.3934 | 0.3934 | 134960.0 |
| 2004-02-05 09:53:00 | AAPL | Stock | 0.3934 | 0.3934 | 0.3929 | 0.3929 | 274400.0 |
| 2004-02-05 09:54:00 | AAPL | Stock | 0.393 | 0.393 | 0.3923 | 0.3925 | 697760.0 |
| 2004-02-05 09:55:00 | AAPL | Stock | 0.3925 | 0.3927 | 0.392 | 0.3926 | 1485512.0 |
| 2004-02-05 09:56:00 | AAPL | Stock | 0.3923 | 0.393 | 0.3923 | 0.3925 | 481600.0 |
| 2004-02-05 09:57:00 | AAPL | Stock | 0.3925 | 0.3932 | 0.3925 | 0.3932 | 1150800.0 |
| 2004-02-05 09:58:00 | AAPL | Stock | 0.393 | 0.3932 | 0.393 | 0.393 | 526400.0 |
| 2004-02-05 09:59:00 | AAPL | Stock | 0.393 | 0.3934 | 0.393 | 0.3934 | 339360.0 |
| 2004-02-05 10:00:00 | AAPL | Stock | 0.3932 | 0.3938 | 0.3932 | 0.3936 | 365960.0 |
| 2004-02-05 10:01:00 | AAPL | Stock | 0.3936 | 0.3938 | 0.393 | 0.3938 | 731416.0 |
| 2004-02-05 10:02:00 | AAPL | Stock | 0.3938 | 0.3946 | 0.3934 | 0.3934 | 1318632.0 |
| 2004-02-05 10:03:00 | AAPL | Stock | 0.3936 | 0.3936 | 0.3934 | 0.3934 | 134400.0 |
| 2004-02-05 10:04:00 | AAPL | Stock | 0.3932 | 0.3932 | 0.3929 | 0.3929 | 875728.0 |
| 2004-02-05 10:05:00 | AAPL | Stock | 0.3929 | 0.3929 | 0.3929 | 0.3929 | 397600.0 |
| 2004-02-05 10:06:00 | AAPL | Stock | 0.3929 | 0.3938 | 0.3929 | 0.3934 | 362600.0 |
| 2004-02-05 10:07:00 | AAPL | Stock | 0.3934 | 0.3936 | 0.3929 | 0.3929 | 319200.0 |
| 2004-02-05 10:08:00 | AAPL | Stock | 0.3929 | 0.3932 | 0.3929 | 0.3929 | 375200.0 |
| 2004-02-05 10:09:00 | AAPL | Stock | 0.3929 | 0.3932 | 0.3929 | 0.3932 | 439040.0 |
| 2004-02-05 10:10:00 | AAPL | Stock | 0.3932 | 0.3936 | 0.393 | 0.3934 | 930776.0 |
| 2004-02-05 10:11:00 | AAPL | Stock | 0.393 | 0.3932 | 0.393 | 0.3932 | 1009176.0 |
| 2004-02-05 10:12:00 | AAPL | Stock | 0.3932 | 0.3936 | 0.393 | 0.3934 | 720104.0 |
| 2004-02-05 10:13:00 | AAPL | Stock | 0.3936 | 0.3936 | 0.3934 | 0.3934 | 190400.0 |
| 2004-02-05 10:14:00 | AAPL | Stock | 0.3936 | 0.3938 | 0.3936 | 0.3938 | 964992.0 |
| 2004-02-05 10:15:00 | AAPL | Stock | 0.3943 | 0.3943 | 0.3937 | 0.3938 | 459200.0 |
| 2004-02-05 10:16:00 | AAPL | Stock | 0.3937 | 0.3945 | 0.3937 | 0.3945 | 280336.0 |
> showing 50 of 496,444 rows — these rows as CSV