PREVIEW / stock_5min / 2000-04-12
file: by_date/stock_5min/2000/2000-04-12.parquet size: 1.2 MB rows: 88,956 symbols: 1,158
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 |
|---|---|---|---|---|---|---|---|
| 2000-04-12 09:30:00 | AAPL | Stock | 1.0625 | 1.0625 | 1.0536 | 1.0558 | 10304000.0 |
| 2000-04-12 09:35:00 | AAPL | Stock | 1.0552 | 1.0558 | 1.0402 | 1.0407 | 10696000.0 |
| 2000-04-12 09:40:00 | AAPL | Stock | 1.0413 | 1.0419 | 1.0313 | 1.0313 | 21000000.0 |
| 2000-04-12 09:45:00 | AAPL | Stock | 1.0313 | 1.034 | 1.0201 | 1.0268 | 15097600.0 |
| 2000-04-12 09:50:00 | AAPL | Stock | 1.0268 | 1.0324 | 1.0173 | 1.0173 | 19555200.0 |
| 2000-04-12 09:55:00 | AAPL | Stock | 1.0173 | 1.0212 | 1.0045 | 1.0167 | 30004800.0 |
| 2000-04-12 10:00:00 | AAPL | Stock | 1.0156 | 1.0179 | 1.0089 | 1.0089 | 24192000.0 |
| 2000-04-12 10:05:00 | AAPL | Stock | 1.0089 | 1.0145 | 1.0056 | 1.0123 | 18267200.0 |
| 2000-04-12 10:10:00 | AAPL | Stock | 1.0112 | 1.0145 | 1.0112 | 1.0117 | 12476800.0 |
| 2000-04-12 10:15:00 | AAPL | Stock | 1.0112 | 1.0223 | 1.01 | 1.0212 | 27720000.0 |
| 2000-04-12 10:20:00 | AAPL | Stock | 1.0206 | 1.0223 | 1.0145 | 1.0201 | 12062400.0 |
| 2000-04-12 10:25:00 | AAPL | Stock | 1.0201 | 1.0268 | 1.0179 | 1.0246 | 15176000.0 |
| 2000-04-12 10:30:00 | AAPL | Stock | 1.0246 | 1.0279 | 1.0195 | 1.0262 | 19476800.0 |
| 2000-04-12 10:35:00 | AAPL | Stock | 1.0257 | 1.0301 | 1.0212 | 1.0268 | 10819200.0 |
| 2000-04-12 10:40:00 | AAPL | Stock | 1.0268 | 1.029 | 1.0201 | 1.0212 | 7784000.0 |
| 2000-04-12 10:45:00 | AAPL | Stock | 1.0212 | 1.0218 | 1.0089 | 1.0089 | 12734400.0 |
| 2000-04-12 10:50:00 | AAPL | Stock | 1.0123 | 1.0128 | 1.0 | 1.0003 | 14896000.0 |
| 2000-04-12 10:55:00 | AAPL | Stock | 1.0 | 1.0008 | 0.9911 | 0.9944 | 15097600.0 |
| 2000-04-12 11:00:00 | AAPL | Stock | 0.9944 | 0.9969 | 0.9866 | 0.9883 | 10908800.0 |
| 2000-04-12 11:05:00 | AAPL | Stock | 0.9888 | 0.9933 | 0.9821 | 0.9821 | 27563200.0 |
| 2000-04-12 11:10:00 | AAPL | Stock | 0.9821 | 0.9827 | 0.9715 | 0.9754 | 16844800.0 |
| 2000-04-12 11:15:00 | AAPL | Stock | 0.9754 | 0.99 | 0.9727 | 0.9897 | 29993600.0 |
| 2000-04-12 11:20:00 | AAPL | Stock | 0.9897 | 0.99 | 0.9766 | 0.9833 | 15422400.0 |
| 2000-04-12 11:25:00 | AAPL | Stock | 0.9833 | 0.9933 | 0.981 | 0.9922 | 20608000.0 |
| 2000-04-12 11:30:00 | AAPL | Stock | 0.9911 | 0.9955 | 0.9877 | 0.9911 | 15836800.0 |
| 2000-04-12 11:35:00 | AAPL | Stock | 0.9911 | 0.9944 | 0.9866 | 0.9888 | 15993600.0 |
| 2000-04-12 11:40:00 | AAPL | Stock | 0.9888 | 0.9888 | 0.9821 | 0.9877 | 18715200.0 |
| 2000-04-12 11:45:00 | AAPL | Stock | 0.9877 | 0.9894 | 0.9849 | 0.9877 | 6182400.0 |
| 2000-04-12 11:50:00 | AAPL | Stock | 0.9872 | 0.9877 | 0.9754 | 0.9821 | 5868800.0 |
| 2000-04-12 11:55:00 | AAPL | Stock | 0.9849 | 0.9877 | 0.9833 | 0.9855 | 6809600.0 |
| 2000-04-12 12:00:00 | AAPL | Stock | 0.9872 | 0.9911 | 0.9872 | 0.99 | 8220800.0 |
| 2000-04-12 12:05:00 | AAPL | Stock | 0.9916 | 0.9955 | 0.9894 | 0.99 | 9856000.0 |
| 2000-04-12 12:10:00 | AAPL | Stock | 0.9894 | 0.9955 | 0.9855 | 0.9933 | 8814400.0 |
| 2000-04-12 12:15:00 | AAPL | Stock | 0.9933 | 0.9955 | 0.9888 | 0.9944 | 6372800.0 |
| 2000-04-12 12:20:00 | AAPL | Stock | 0.9939 | 0.9972 | 0.9933 | 0.9961 | 9968000.0 |
| 2000-04-12 12:25:00 | AAPL | Stock | 0.9955 | 1.0033 | 0.9944 | 1.0031 | 18177600.0 |
| 2000-04-12 12:30:00 | AAPL | Stock | 1.0045 | 1.0078 | 0.9955 | 0.9961 | 7392000.0 |
| 2000-04-12 12:35:00 | AAPL | Stock | 0.9967 | 1.0 | 0.9961 | 0.9983 | 5476800.0 |
| 2000-04-12 12:40:00 | AAPL | Stock | 0.9983 | 1.0045 | 0.9967 | 1.0045 | 8086400.0 |
| 2000-04-12 12:45:00 | AAPL | Stock | 1.0045 | 1.0045 | 0.9989 | 0.9994 | 4032000.0 |
| 2000-04-12 12:50:00 | AAPL | Stock | 0.9994 | 1.0 | 0.9922 | 0.9941 | 4592000.0 |
| 2000-04-12 12:55:00 | AAPL | Stock | 0.9939 | 1.0022 | 0.9927 | 1.0 | 6764800.0 |
| 2000-04-12 13:00:00 | AAPL | Stock | 1.0022 | 1.0033 | 0.9955 | 0.9983 | 3068800.0 |
| 2000-04-12 13:05:00 | AAPL | Stock | 0.9967 | 1.0039 | 0.9955 | 1.0022 | 3404800.0 |
| 2000-04-12 13:10:00 | AAPL | Stock | 1.0017 | 1.0033 | 0.9955 | 1.0 | 4424000.0 |
| 2000-04-12 13:15:00 | AAPL | Stock | 1.0 | 1.0022 | 1.0 | 1.0 | 8792000.0 |
| 2000-04-12 13:20:00 | AAPL | Stock | 1.0 | 1.0022 | 0.9978 | 0.9978 | 6350400.0 |
| 2000-04-12 13:25:00 | AAPL | Stock | 0.9978 | 0.9989 | 0.9939 | 0.9939 | 2620800.0 |
| 2000-04-12 13:30:00 | AAPL | Stock | 0.9939 | 1.0179 | 0.9939 | 1.0128 | 30419200.0 |
| 2000-04-12 13:35:00 | AAPL | Stock | 1.0134 | 1.0134 | 1.0056 | 1.0078 | 11827200.0 |
> showing 50 of 88,956 rows — these rows as CSV