PREVIEW / stock_5min / 2006-01-20
file: by_date/stock_5min/2006/2006-01-20.parquet size: 3.0 MB rows: 216,294 symbols: 2,173
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 |
|---|---|---|---|---|---|---|---|
| 2006-01-20 05:35:00 | AAPL | Stock | 2.8286 | 2.8286 | 2.8286 | 2.8286 | 5600.0 |
| 2006-01-20 06:20:00 | AAPL | Stock | 2.8264 | 2.8264 | 2.8264 | 2.8264 | 18788.0 |
| 2006-01-20 06:45:00 | AAPL | Stock | 2.8093 | 2.8093 | 2.8093 | 2.8093 | 13412.0 |
| 2006-01-20 07:00:00 | AAPL | Stock | 2.8089 | 2.8232 | 2.8089 | 2.8232 | 36400.0 |
| 2006-01-20 07:05:00 | AAPL | Stock | 2.8125 | 2.8125 | 2.8125 | 2.8125 | 2800.0 |
| 2006-01-20 07:20:00 | AAPL | Stock | 2.8125 | 2.8125 | 2.8071 | 2.8071 | 30800.0 |
| 2006-01-20 07:40:00 | AAPL | Stock | 2.8171 | 2.8171 | 2.8143 | 2.8143 | 36400.0 |
| 2006-01-20 07:45:00 | AAPL | Stock | 2.8143 | 2.8214 | 2.8143 | 2.8214 | 62636.0 |
| 2006-01-20 07:50:00 | AAPL | Stock | 2.8211 | 2.8214 | 2.8211 | 2.8214 | 30800.0 |
| 2006-01-20 08:00:00 | AAPL | Stock | 2.8214 | 2.8375 | 2.8175 | 2.8286 | 549584.0 |
| 2006-01-20 08:05:00 | AAPL | Stock | 2.8318 | 2.8357 | 2.8268 | 2.8304 | 205044.0 |
| 2006-01-20 08:10:00 | AAPL | Stock | 2.8304 | 2.8357 | 2.8304 | 2.8357 | 53200.0 |
| 2006-01-20 08:15:00 | AAPL | Stock | 2.8357 | 2.8371 | 2.8343 | 2.835 | 95900.0 |
| 2006-01-20 08:20:00 | AAPL | Stock | 2.8354 | 2.8382 | 2.835 | 2.8382 | 170912.0 |
| 2006-01-20 08:25:00 | AAPL | Stock | 2.8382 | 2.8429 | 2.8375 | 2.8411 | 453040.0 |
| 2006-01-20 08:30:00 | AAPL | Stock | 2.8411 | 2.8421 | 2.8357 | 2.8393 | 224756.0 |
| 2006-01-20 08:35:00 | AAPL | Stock | 2.8375 | 2.8396 | 2.8357 | 2.8396 | 243180.0 |
| 2006-01-20 08:40:00 | AAPL | Stock | 2.8407 | 2.8418 | 2.8393 | 2.8393 | 158200.0 |
| 2006-01-20 08:45:00 | AAPL | Stock | 2.8393 | 2.84 | 2.8354 | 2.8357 | 157696.0 |
| 2006-01-20 08:50:00 | AAPL | Stock | 2.8389 | 2.8407 | 2.8361 | 2.8361 | 106512.0 |
| 2006-01-20 08:55:00 | AAPL | Stock | 2.8361 | 2.8386 | 2.8361 | 2.8361 | 127960.0 |
| 2006-01-20 09:00:00 | AAPL | Stock | 2.8361 | 2.8375 | 2.8361 | 2.8361 | 40600.0 |
| 2006-01-20 09:05:00 | AAPL | Stock | 2.8375 | 2.8375 | 2.8321 | 2.8321 | 344960.0 |
| 2006-01-20 09:10:00 | AAPL | Stock | 2.8332 | 2.8371 | 2.8321 | 2.8371 | 288512.0 |
| 2006-01-20 09:15:00 | AAPL | Stock | 2.8368 | 2.8371 | 2.8357 | 2.8361 | 106400.0 |
| 2006-01-20 09:20:00 | AAPL | Stock | 2.8361 | 2.8361 | 2.8311 | 2.8314 | 351232.0 |
| 2006-01-20 09:25:00 | AAPL | Stock | 2.8368 | 2.8404 | 2.8311 | 2.8311 | 1815772.0 |
| 2006-01-20 09:30:00 | AAPL | Stock | 2.8314 | 2.8496 | 2.8261 | 2.8454 | 35510160.0 |
| 2006-01-20 09:35:00 | AAPL | Stock | 2.8457 | 2.8539 | 2.8396 | 2.8486 | 18126360.0 |
| 2006-01-20 09:40:00 | AAPL | Stock | 2.8486 | 2.8586 | 2.8457 | 2.8536 | 19722500.0 |
| 2006-01-20 09:45:00 | AAPL | Stock | 2.8532 | 2.8539 | 2.8457 | 2.85 | 14788172.0 |
| 2006-01-20 09:50:00 | AAPL | Stock | 2.8504 | 2.8539 | 2.8471 | 2.8485 | 10921736.0 |
| 2006-01-20 09:55:00 | AAPL | Stock | 2.8486 | 2.8504 | 2.8364 | 2.8396 | 15758092.0 |
| 2006-01-20 10:00:00 | AAPL | Stock | 2.84 | 2.8557 | 2.8279 | 2.8325 | 20542788.0 |
| 2006-01-20 10:05:00 | AAPL | Stock | 2.8321 | 2.8446 | 2.8296 | 2.8304 | 14886004.0 |
| 2006-01-20 10:10:00 | AAPL | Stock | 2.83 | 2.8318 | 2.8179 | 2.8179 | 24492972.0 |
| 2006-01-20 10:15:00 | AAPL | Stock | 2.8182 | 2.8268 | 2.8025 | 2.8043 | 30239748.0 |
| 2006-01-20 10:20:00 | AAPL | Stock | 2.8046 | 2.8071 | 2.7889 | 2.8 | 40126688.0 |
| 2006-01-20 10:25:00 | AAPL | Stock | 2.8 | 2.8036 | 2.7954 | 2.7993 | 20327244.0 |
| 2006-01-20 10:30:00 | AAPL | Stock | 2.7989 | 2.8071 | 2.7932 | 2.7971 | 19686996.0 |
| 2006-01-20 10:35:00 | AAPL | Stock | 2.7971 | 2.8036 | 2.7954 | 2.8029 | 13947220.0 |
| 2006-01-20 10:40:00 | AAPL | Stock | 2.8032 | 2.8082 | 2.7964 | 2.7968 | 14078736.0 |
| 2006-01-20 10:45:00 | AAPL | Stock | 2.7968 | 2.7971 | 2.775 | 2.7768 | 26518520.0 |
| 2006-01-20 10:50:00 | AAPL | Stock | 2.7764 | 2.7857 | 2.77 | 2.7829 | 32783632.0 |
| 2006-01-20 10:55:00 | AAPL | Stock | 2.7829 | 2.7939 | 2.7768 | 2.7882 | 21291200.0 |
| 2006-01-20 11:00:00 | AAPL | Stock | 2.7882 | 2.7954 | 2.7836 | 2.7939 | 14128436.0 |
| 2006-01-20 11:05:00 | AAPL | Stock | 2.7939 | 2.7982 | 2.7875 | 2.7911 | 13011208.0 |
| 2006-01-20 11:10:00 | AAPL | Stock | 2.7911 | 2.7929 | 2.7843 | 2.7907 | 13670132.0 |
| 2006-01-20 11:15:00 | AAPL | Stock | 2.7911 | 2.7911 | 2.7746 | 2.775 | 9844548.0 |
| 2006-01-20 11:20:00 | AAPL | Stock | 2.775 | 2.7911 | 2.7696 | 2.7786 | 18974060.0 |
> showing 50 of 216,294 rows — these rows as CSV