PREVIEW / stock_5min / 2000-01-21
file: by_date/stock_5min/2000/2000-01-21.parquet size: 1.2 MB rows: 89,176 symbols: 1,130
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-01-21 09:30:00 | AAPL | Stock | 1.0201 | 1.0201 | 1.0112 | 1.0123 | 18715200.0 |
| 2000-01-21 09:35:00 | AAPL | Stock | 1.0167 | 1.0201 | 1.01 | 1.014 | 29243200.0 |
| 2000-01-21 09:40:00 | AAPL | Stock | 1.0145 | 1.0173 | 1.0117 | 1.014 | 14056000.0 |
| 2000-01-21 09:45:00 | AAPL | Stock | 1.014 | 1.0145 | 1.0022 | 1.0039 | 21884800.0 |
| 2000-01-21 09:50:00 | AAPL | Stock | 1.0078 | 1.0089 | 0.9989 | 1.0028 | 14828800.0 |
| 2000-01-21 09:55:00 | AAPL | Stock | 1.0022 | 1.0045 | 0.9983 | 1.0045 | 10449600.0 |
| 2000-01-21 10:00:00 | AAPL | Stock | 1.0022 | 1.0089 | 1.0 | 1.005 | 11715200.0 |
| 2000-01-21 10:05:00 | AAPL | Stock | 1.005 | 1.0061 | 0.9967 | 0.9972 | 17998400.0 |
| 2000-01-21 10:10:00 | AAPL | Stock | 0.9972 | 0.9983 | 0.9955 | 0.9955 | 14056000.0 |
| 2000-01-21 10:15:00 | AAPL | Stock | 0.9967 | 0.9967 | 0.9933 | 0.995 | 11547200.0 |
| 2000-01-21 10:20:00 | AAPL | Stock | 0.9955 | 0.9978 | 0.995 | 0.9961 | 9296000.0 |
| 2000-01-21 10:25:00 | AAPL | Stock | 0.9961 | 0.9967 | 0.9916 | 0.9955 | 11032000.0 |
| 2000-01-21 10:30:00 | AAPL | Stock | 0.9922 | 0.9944 | 0.99 | 0.9933 | 14672000.0 |
| 2000-01-21 10:35:00 | AAPL | Stock | 0.9939 | 1.0 | 0.9905 | 0.9967 | 13440000.0 |
| 2000-01-21 10:40:00 | AAPL | Stock | 0.9969 | 0.9978 | 0.9927 | 0.9939 | 4424000.0 |
| 2000-01-21 10:45:00 | AAPL | Stock | 0.9933 | 0.9961 | 0.9927 | 0.9955 | 5420800.0 |
| 2000-01-21 10:50:00 | AAPL | Stock | 0.9955 | 0.9994 | 0.9944 | 0.9994 | 4166400.0 |
| 2000-01-21 10:55:00 | AAPL | Stock | 0.9989 | 1.0045 | 0.9989 | 1.0 | 9184000.0 |
| 2000-01-21 11:00:00 | AAPL | Stock | 1.0017 | 1.0028 | 1.0 | 1.0011 | 2900800.0 |
| 2000-01-21 11:05:00 | AAPL | Stock | 1.0017 | 1.0033 | 0.9989 | 0.9994 | 8590400.0 |
| 2000-01-21 11:10:00 | AAPL | Stock | 0.9994 | 1.0033 | 0.9989 | 0.9994 | 7840000.0 |
| 2000-01-21 11:15:00 | AAPL | Stock | 0.9994 | 1.0 | 0.9978 | 0.9989 | 8724800.0 |
| 2000-01-21 11:20:00 | AAPL | Stock | 0.9994 | 1.0006 | 0.9983 | 0.9989 | 7056000.0 |
| 2000-01-21 11:25:00 | AAPL | Stock | 0.9986 | 1.0 | 0.9967 | 0.9986 | 2419200.0 |
| 2000-01-21 11:30:00 | AAPL | Stock | 0.9989 | 1.0006 | 0.9983 | 1.0 | 2105600.0 |
| 2000-01-21 11:35:00 | AAPL | Stock | 0.9989 | 0.9994 | 0.9955 | 0.9978 | 1478400.0 |
| 2000-01-21 11:40:00 | AAPL | Stock | 0.9994 | 1.0025 | 0.9989 | 1.0 | 2441600.0 |
| 2000-01-21 11:45:00 | AAPL | Stock | 1.0017 | 1.0045 | 1.0 | 1.0017 | 2587200.0 |
| 2000-01-21 11:50:00 | AAPL | Stock | 1.0017 | 1.0022 | 0.9978 | 1.0006 | 2184000.0 |
| 2000-01-21 11:55:00 | AAPL | Stock | 1.0008 | 1.0008 | 0.9989 | 0.9994 | 2363200.0 |
| 2000-01-21 12:00:00 | AAPL | Stock | 1.0 | 1.0 | 0.9978 | 0.9989 | 1198400.0 |
| 2000-01-21 12:05:00 | AAPL | Stock | 0.9994 | 1.0045 | 0.9989 | 1.0033 | 2430400.0 |
| 2000-01-21 12:10:00 | AAPL | Stock | 1.0028 | 1.0033 | 1.0 | 1.0022 | 1680000.0 |
| 2000-01-21 12:15:00 | AAPL | Stock | 1.0028 | 1.0045 | 1.0022 | 1.0028 | 2363200.0 |
| 2000-01-21 12:20:00 | AAPL | Stock | 1.0028 | 1.0045 | 1.0022 | 1.0033 | 1355200.0 |
| 2000-01-21 12:25:00 | AAPL | Stock | 1.0028 | 1.0039 | 0.9978 | 0.9978 | 1915200.0 |
| 2000-01-21 12:30:00 | AAPL | Stock | 0.9978 | 1.0045 | 0.9978 | 1.0039 | 1086400.0 |
| 2000-01-21 12:35:00 | AAPL | Stock | 1.0045 | 1.0045 | 1.0 | 1.0 | 784000.0 |
| 2000-01-21 12:40:00 | AAPL | Stock | 1.0011 | 1.0039 | 1.0 | 1.0011 | 806400.0 |
| 2000-01-21 12:45:00 | AAPL | Stock | 1.0039 | 1.0045 | 1.0 | 1.0039 | 1276800.0 |
| 2000-01-21 12:50:00 | AAPL | Stock | 1.0011 | 1.0045 | 1.0011 | 1.0045 | 1254400.0 |
| 2000-01-21 12:55:00 | AAPL | Stock | 1.0045 | 1.005 | 1.0028 | 1.005 | 13070400.0 |
| 2000-01-21 13:00:00 | AAPL | Stock | 1.005 | 1.0084 | 1.0045 | 1.0078 | 1937600.0 |
| 2000-01-21 13:05:00 | AAPL | Stock | 1.0078 | 1.0078 | 1.0039 | 1.0045 | 1780800.0 |
| 2000-01-21 13:10:00 | AAPL | Stock | 1.0039 | 1.0056 | 1.0 | 1.0022 | 5566400.0 |
| 2000-01-21 13:15:00 | AAPL | Stock | 1.0022 | 1.0022 | 1.0 | 1.0011 | 1019200.0 |
| 2000-01-21 13:20:00 | AAPL | Stock | 1.0011 | 1.0033 | 1.0 | 1.0022 | 985600.0 |
| 2000-01-21 13:25:00 | AAPL | Stock | 1.0028 | 1.0033 | 0.9978 | 1.0 | 2576000.0 |
| 2000-01-21 13:30:00 | AAPL | Stock | 1.0006 | 1.0033 | 0.9994 | 1.0011 | 6171200.0 |
| 2000-01-21 13:35:00 | AAPL | Stock | 1.0011 | 1.0028 | 1.0 | 1.0011 | 5846400.0 |
> showing 50 of 89,176 rows — these rows as CSV