PREVIEW / stock_5min / 2000-09-18
file: by_date/stock_5min/2000/2000-09-18.parquet size: 1.2 MB rows: 92,896 symbols: 1,224
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-09-18 08:00:00 | AAPL | Stock | 0.9861 | 0.9861 | 0.9861 | 0.9861 | 520800.0 |
| 2000-09-18 08:15:00 | AAPL | Stock | 0.9866 | 0.9866 | 0.9866 | 0.9866 | 28000.0 |
| 2000-09-18 08:55:00 | AAPL | Stock | 0.9994 | 0.9994 | 0.9994 | 0.9994 | 28000.0 |
| 2000-09-18 09:05:00 | AAPL | Stock | 0.9955 | 1.0 | 0.9888 | 0.9888 | 67200.0 |
| 2000-09-18 09:15:00 | AAPL | Stock | 0.9888 | 0.9888 | 0.9888 | 0.9888 | 16800.0 |
| 2000-09-18 09:20:00 | AAPL | Stock | 0.9866 | 0.9866 | 0.9866 | 0.9866 | 11200.0 |
| 2000-09-18 09:25:00 | AAPL | Stock | 0.9855 | 0.9866 | 0.9849 | 0.9866 | 448000.0 |
| 2000-09-18 09:30:00 | AAPL | Stock | 0.9866 | 0.9933 | 0.9866 | 0.9933 | 8993600.0 |
| 2000-09-18 09:35:00 | AAPL | Stock | 0.9933 | 0.9933 | 0.9877 | 0.9911 | 8904000.0 |
| 2000-09-18 09:40:00 | AAPL | Stock | 0.9922 | 0.9922 | 0.99 | 0.99 | 11474400.0 |
| 2000-09-18 09:45:00 | AAPL | Stock | 0.9911 | 1.0011 | 0.9905 | 1.0006 | 3561600.0 |
| 2000-09-18 09:50:00 | AAPL | Stock | 1.0022 | 1.01 | 1.0 | 1.0089 | 5583200.0 |
| 2000-09-18 09:55:00 | AAPL | Stock | 1.01 | 1.0134 | 1.0067 | 1.0089 | 6171200.0 |
| 2000-09-18 10:00:00 | AAPL | Stock | 1.0089 | 1.0123 | 1.0089 | 1.0089 | 12140800.0 |
| 2000-09-18 10:05:00 | AAPL | Stock | 1.0078 | 1.0112 | 1.0056 | 1.0089 | 2542400.0 |
| 2000-09-18 10:10:00 | AAPL | Stock | 1.01 | 1.0156 | 1.0089 | 1.0123 | 9066400.0 |
| 2000-09-18 10:15:00 | AAPL | Stock | 1.0112 | 1.0201 | 1.0112 | 1.019 | 13126400.0 |
| 2000-09-18 10:20:00 | AAPL | Stock | 1.019 | 1.0246 | 1.0179 | 1.019 | 3063200.0 |
| 2000-09-18 10:25:00 | AAPL | Stock | 1.0195 | 1.0195 | 1.0134 | 1.0167 | 1388800.0 |
| 2000-09-18 10:30:00 | AAPL | Stock | 1.0167 | 1.0246 | 1.0167 | 1.0212 | 1752800.0 |
| 2000-09-18 10:35:00 | AAPL | Stock | 1.0212 | 1.0223 | 1.0145 | 1.0167 | 1164800.0 |
| 2000-09-18 10:40:00 | AAPL | Stock | 1.0167 | 1.0179 | 1.0112 | 1.0123 | 2010400.0 |
| 2000-09-18 10:45:00 | AAPL | Stock | 1.0123 | 1.0134 | 1.0056 | 1.0089 | 3248000.0 |
| 2000-09-18 10:50:00 | AAPL | Stock | 1.0112 | 1.0156 | 1.0056 | 1.0145 | 1792000.0 |
| 2000-09-18 10:55:00 | AAPL | Stock | 1.0134 | 1.0156 | 1.0112 | 1.0112 | 560000.0 |
| 2000-09-18 11:00:00 | AAPL | Stock | 1.0112 | 1.0112 | 1.0067 | 1.0067 | 1058400.0 |
| 2000-09-18 11:05:00 | AAPL | Stock | 1.0067 | 1.0089 | 1.0056 | 1.0089 | 2060800.0 |
| 2000-09-18 11:10:00 | AAPL | Stock | 1.0089 | 1.0134 | 1.0089 | 1.0112 | 2111200.0 |
| 2000-09-18 11:15:00 | AAPL | Stock | 1.01 | 1.0145 | 1.0067 | 1.0145 | 1052800.0 |
| 2000-09-18 11:20:00 | AAPL | Stock | 1.0145 | 1.0201 | 1.0145 | 1.0145 | 5902400.0 |
| 2000-09-18 11:25:00 | AAPL | Stock | 1.0145 | 1.0167 | 1.0123 | 1.0134 | 3858400.0 |
| 2000-09-18 11:30:00 | AAPL | Stock | 1.0145 | 1.0145 | 1.0089 | 1.0089 | 2699200.0 |
| 2000-09-18 11:35:00 | AAPL | Stock | 1.0089 | 1.0123 | 1.0056 | 1.0112 | 9688000.0 |
| 2000-09-18 11:40:00 | AAPL | Stock | 1.0112 | 1.0112 | 1.0078 | 1.0089 | 8450400.0 |
| 2000-09-18 11:45:00 | AAPL | Stock | 1.0089 | 1.01 | 1.0022 | 1.0045 | 1092000.0 |
| 2000-09-18 11:50:00 | AAPL | Stock | 1.0045 | 1.0078 | 1.0022 | 1.0033 | 2945600.0 |
| 2000-09-18 11:55:00 | AAPL | Stock | 1.0045 | 1.0089 | 1.0022 | 1.0056 | 3259200.0 |
| 2000-09-18 12:00:00 | AAPL | Stock | 1.0056 | 1.0067 | 1.0022 | 1.0033 | 4110400.0 |
| 2000-09-18 12:05:00 | AAPL | Stock | 1.0033 | 1.0045 | 1.0011 | 1.0011 | 2049600.0 |
| 2000-09-18 12:10:00 | AAPL | Stock | 1.0011 | 1.0011 | 0.9933 | 0.9967 | 3220000.0 |
| 2000-09-18 12:15:00 | AAPL | Stock | 0.9967 | 0.9967 | 0.9833 | 0.99 | 2783200.0 |
| 2000-09-18 12:20:00 | AAPL | Stock | 0.9877 | 0.99 | 0.9866 | 0.9877 | 4379200.0 |
| 2000-09-18 12:25:00 | AAPL | Stock | 0.9888 | 0.9888 | 0.9844 | 0.9855 | 6294400.0 |
| 2000-09-18 12:30:00 | AAPL | Stock | 0.9855 | 0.9911 | 0.9844 | 0.9911 | 4228000.0 |
| 2000-09-18 12:35:00 | AAPL | Stock | 0.9911 | 0.9967 | 0.9888 | 0.9955 | 6753600.0 |
| 2000-09-18 12:40:00 | AAPL | Stock | 0.9944 | 0.9944 | 0.9922 | 0.9944 | 5835200.0 |
| 2000-09-18 12:45:00 | AAPL | Stock | 0.9933 | 0.9944 | 0.9922 | 0.9944 | 6720000.0 |
| 2000-09-18 12:50:00 | AAPL | Stock | 0.9944 | 1.0033 | 0.9944 | 1.0011 | 5880000.0 |
| 2000-09-18 12:55:00 | AAPL | Stock | 1.0011 | 1.0022 | 1.0 | 1.0011 | 1411200.0 |
| 2000-09-18 13:00:00 | AAPL | Stock | 1.0 | 1.0022 | 0.9978 | 0.9994 | 5600000.0 |
> showing 50 of 92,896 rows — these rows as CSV