PREVIEW / stock_5min / 2000-04-14
file: by_date/stock_5min/2000/2000-04-14.parquet size: 1.3 MB rows: 97,591 symbols: 1,162
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-14 09:30:00 | AAPL | Stock | 0.976 | 1.0022 | 0.9732 | 0.995 | 9464000.0 |
| 2000-04-14 09:35:00 | AAPL | Stock | 0.9955 | 1.0011 | 0.9866 | 0.9911 | 9553600.0 |
| 2000-04-14 09:40:00 | AAPL | Stock | 0.9933 | 1.0022 | 0.9866 | 0.9972 | 10696000.0 |
| 2000-04-14 09:45:00 | AAPL | Stock | 0.9967 | 1.0268 | 0.9927 | 1.0262 | 7929600.0 |
| 2000-04-14 09:50:00 | AAPL | Stock | 1.0268 | 1.0385 | 1.0234 | 1.0346 | 6742400.0 |
| 2000-04-14 09:55:00 | AAPL | Stock | 1.036 | 1.0525 | 1.029 | 1.0452 | 6876800.0 |
| 2000-04-14 10:00:00 | AAPL | Stock | 1.0452 | 1.0469 | 1.0346 | 1.043 | 11883200.0 |
| 2000-04-14 10:05:00 | AAPL | Stock | 1.043 | 1.0452 | 1.0424 | 1.0435 | 9396800.0 |
| 2000-04-14 10:10:00 | AAPL | Stock | 1.043 | 1.0513 | 1.0402 | 1.043 | 18401600.0 |
| 2000-04-14 10:15:00 | AAPL | Stock | 1.0446 | 1.0485 | 1.0446 | 1.0446 | 8579200.0 |
| 2000-04-14 10:20:00 | AAPL | Stock | 1.048 | 1.048 | 1.0446 | 1.0452 | 10998400.0 |
| 2000-04-14 10:25:00 | AAPL | Stock | 1.0446 | 1.0452 | 1.0424 | 1.0446 | 4849600.0 |
| 2000-04-14 10:30:00 | AAPL | Stock | 1.0446 | 1.048 | 1.0446 | 1.0458 | 5992000.0 |
| 2000-04-14 10:35:00 | AAPL | Stock | 1.0469 | 1.0469 | 1.0268 | 1.0268 | 14089600.0 |
| 2000-04-14 10:40:00 | AAPL | Stock | 1.0268 | 1.0301 | 1.0229 | 1.0257 | 7672000.0 |
| 2000-04-14 10:45:00 | AAPL | Stock | 1.0262 | 1.029 | 1.0229 | 1.0262 | 9721600.0 |
| 2000-04-14 10:50:00 | AAPL | Stock | 1.0262 | 1.0326 | 1.0212 | 1.0234 | 8848000.0 |
| 2000-04-14 10:55:00 | AAPL | Stock | 1.0234 | 1.029 | 1.0223 | 1.0276 | 2475200.0 |
| 2000-04-14 11:00:00 | AAPL | Stock | 1.0276 | 1.0276 | 1.0223 | 1.0223 | 4110400.0 |
| 2000-04-14 11:05:00 | AAPL | Stock | 1.0223 | 1.0223 | 1.0134 | 1.0134 | 11043200.0 |
| 2000-04-14 11:10:00 | AAPL | Stock | 1.0134 | 1.0162 | 1.0112 | 1.0117 | 5432000.0 |
| 2000-04-14 11:15:00 | AAPL | Stock | 1.0117 | 1.0117 | 1.0 | 1.005 | 8288000.0 |
| 2000-04-14 11:20:00 | AAPL | Stock | 1.0045 | 1.0089 | 0.9978 | 0.9983 | 5868800.0 |
| 2000-04-14 11:25:00 | AAPL | Stock | 0.9989 | 1.0073 | 0.9983 | 1.0 | 9609600.0 |
| 2000-04-14 11:30:00 | AAPL | Stock | 1.0006 | 1.0033 | 0.9994 | 0.9994 | 5006400.0 |
| 2000-04-14 11:35:00 | AAPL | Stock | 0.9978 | 1.0089 | 0.9944 | 0.9944 | 6596800.0 |
| 2000-04-14 11:40:00 | AAPL | Stock | 0.9939 | 1.0128 | 0.9933 | 1.0128 | 9060800.0 |
| 2000-04-14 11:45:00 | AAPL | Stock | 1.012 | 1.0134 | 0.9933 | 0.9944 | 3796800.0 |
| 2000-04-14 11:50:00 | AAPL | Stock | 0.9944 | 1.0033 | 0.9944 | 1.0028 | 12409600.0 |
| 2000-04-14 11:55:00 | AAPL | Stock | 0.9989 | 1.0078 | 0.9978 | 0.9989 | 4984000.0 |
| 2000-04-14 12:00:00 | AAPL | Stock | 1.0011 | 1.0011 | 0.9944 | 0.9961 | 6126400.0 |
| 2000-04-14 12:05:00 | AAPL | Stock | 0.995 | 1.0 | 0.9911 | 0.9922 | 11390400.0 |
| 2000-04-14 12:10:00 | AAPL | Stock | 0.9927 | 1.01 | 0.9922 | 1.01 | 19308800.0 |
| 2000-04-14 12:15:00 | AAPL | Stock | 1.0022 | 1.0179 | 1.0017 | 1.0179 | 7772800.0 |
| 2000-04-14 12:20:00 | AAPL | Stock | 1.0179 | 1.024 | 1.0078 | 1.0078 | 8646400.0 |
| 2000-04-14 12:25:00 | AAPL | Stock | 1.0084 | 1.0089 | 1.0045 | 1.0045 | 2878400.0 |
| 2000-04-14 12:30:00 | AAPL | Stock | 1.0045 | 1.005 | 0.9978 | 1.0 | 2352000.0 |
| 2000-04-14 12:35:00 | AAPL | Stock | 0.9978 | 1.0006 | 0.9833 | 0.9905 | 7448000.0 |
| 2000-04-14 12:40:00 | AAPL | Stock | 0.9905 | 1.0 | 0.9888 | 0.995 | 6798400.0 |
| 2000-04-14 12:45:00 | AAPL | Stock | 0.9955 | 1.0134 | 0.9922 | 1.0089 | 7190400.0 |
| 2000-04-14 12:50:00 | AAPL | Stock | 1.0039 | 1.0078 | 0.9911 | 0.9953 | 5252800.0 |
| 2000-04-14 12:55:00 | AAPL | Stock | 0.9955 | 1.0 | 0.9911 | 0.9955 | 5163200.0 |
| 2000-04-14 13:00:00 | AAPL | Stock | 0.9961 | 1.0173 | 0.9922 | 1.0156 | 3752000.0 |
| 2000-04-14 13:05:00 | AAPL | Stock | 1.0151 | 1.0179 | 1.0045 | 1.0167 | 3696000.0 |
| 2000-04-14 13:10:00 | AAPL | Stock | 1.0156 | 1.0246 | 1.0112 | 1.0246 | 3864000.0 |
| 2000-04-14 13:15:00 | AAPL | Stock | 1.0243 | 1.0379 | 1.0212 | 1.034 | 7985600.0 |
| 2000-04-14 13:20:00 | AAPL | Stock | 1.034 | 1.0379 | 1.0301 | 1.0363 | 12096000.0 |
| 2000-04-14 13:25:00 | AAPL | Stock | 1.0366 | 1.0396 | 1.0301 | 1.0313 | 3091200.0 |
| 2000-04-14 13:30:00 | AAPL | Stock | 1.0301 | 1.0346 | 1.0285 | 1.0296 | 5745600.0 |
| 2000-04-14 13:35:00 | AAPL | Stock | 1.0335 | 1.0346 | 1.0268 | 1.0268 | 9419200.0 |
> showing 50 of 97,591 rows — these rows as CSV