PREVIEW / stock_1min / 2006-07-17
file: by_date/stock_1min/2006/2006-07-17.parquet size: 8.3 MB rows: 681,173 symbols: 1,890
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-07-17 04:47:00 | AAPL | Stock | 1.825 | 1.825 | 1.8107 | 1.8143 | 143108.0 |
| 2006-07-17 04:50:00 | AAPL | Stock | 1.8107 | 1.8161 | 1.8107 | 1.8161 | 28000.0 |
| 2006-07-17 04:51:00 | AAPL | Stock | 1.8232 | 1.8232 | 1.8232 | 1.8232 | 28000.0 |
| 2006-07-17 04:56:00 | AAPL | Stock | 1.8214 | 1.8214 | 1.8214 | 1.8214 | 28000.0 |
| 2006-07-17 05:38:00 | AAPL | Stock | 1.8282 | 1.8282 | 1.8282 | 1.8282 | 28000.0 |
| 2006-07-17 06:53:00 | AAPL | Stock | 1.8214 | 1.8214 | 1.8214 | 1.8214 | 2800.0 |
| 2006-07-17 06:59:00 | AAPL | Stock | 1.8357 | 1.8375 | 1.8357 | 1.8375 | 8400.0 |
| 2006-07-17 07:27:00 | AAPL | Stock | 1.8357 | 1.8357 | 1.8357 | 1.8357 | 2800.0 |
| 2006-07-17 07:30:00 | AAPL | Stock | 1.8339 | 1.8357 | 1.8339 | 1.8357 | 16800.0 |
| 2006-07-17 07:41:00 | AAPL | Stock | 1.8357 | 1.8357 | 1.8357 | 1.8357 | 16800.0 |
| 2006-07-17 07:42:00 | AAPL | Stock | 1.8375 | 1.8407 | 1.8375 | 1.8407 | 9800.0 |
| 2006-07-17 07:44:00 | AAPL | Stock | 1.8407 | 1.8482 | 1.8407 | 1.8482 | 36400.0 |
| 2006-07-17 07:45:00 | AAPL | Stock | 1.8393 | 1.8393 | 1.8393 | 1.8393 | 8400.0 |
| 2006-07-17 07:46:00 | AAPL | Stock | 1.8393 | 1.8393 | 1.8393 | 1.8393 | 53200.0 |
| 2006-07-17 07:48:00 | AAPL | Stock | 1.8371 | 1.8371 | 1.8371 | 1.8371 | 5600.0 |
| 2006-07-17 07:49:00 | AAPL | Stock | 1.8371 | 1.8371 | 1.8371 | 1.8371 | 2800.0 |
| 2006-07-17 07:51:00 | AAPL | Stock | 1.8393 | 1.8393 | 1.8393 | 1.8393 | 39200.0 |
| 2006-07-17 07:52:00 | AAPL | Stock | 1.8393 | 1.84 | 1.8393 | 1.8393 | 11200.0 |
| 2006-07-17 07:53:00 | AAPL | Stock | 1.8393 | 1.8393 | 1.8393 | 1.8393 | 64400.0 |
| 2006-07-17 07:54:00 | AAPL | Stock | 1.8393 | 1.8393 | 1.8393 | 1.8393 | 84336.0 |
| 2006-07-17 07:55:00 | AAPL | Stock | 1.8393 | 1.8393 | 1.8393 | 1.8393 | 2800.0 |
| 2006-07-17 07:57:00 | AAPL | Stock | 1.8393 | 1.8393 | 1.8393 | 1.8393 | 2800.0 |
| 2006-07-17 07:58:00 | AAPL | Stock | 1.8393 | 1.8446 | 1.8393 | 1.8446 | 5600.0 |
| 2006-07-17 07:59:00 | AAPL | Stock | 1.8446 | 1.8446 | 1.8446 | 1.8446 | 2800.0 |
| 2006-07-17 08:00:00 | AAPL | Stock | 1.8393 | 1.8457 | 1.83 | 1.8429 | 484148.0 |
| 2006-07-17 08:01:00 | AAPL | Stock | 1.8393 | 1.8429 | 1.8357 | 1.8407 | 447552.0 |
| 2006-07-17 08:02:00 | AAPL | Stock | 1.8411 | 1.8411 | 1.8389 | 1.8393 | 196700.0 |
| 2006-07-17 08:03:00 | AAPL | Stock | 1.8393 | 1.84 | 1.8393 | 1.84 | 78960.0 |
| 2006-07-17 08:04:00 | AAPL | Stock | 1.8393 | 1.8393 | 1.8375 | 1.8393 | 23940.0 |
| 2006-07-17 08:05:00 | AAPL | Stock | 1.8393 | 1.84 | 1.8393 | 1.84 | 54460.0 |
| 2006-07-17 08:06:00 | AAPL | Stock | 1.84 | 1.84 | 1.8396 | 1.8396 | 22400.0 |
| 2006-07-17 08:07:00 | AAPL | Stock | 1.8396 | 1.8429 | 1.8396 | 1.8404 | 424872.0 |
| 2006-07-17 08:08:00 | AAPL | Stock | 1.8411 | 1.8439 | 1.8411 | 1.8432 | 25900.0 |
| 2006-07-17 08:09:00 | AAPL | Stock | 1.8432 | 1.8443 | 1.8429 | 1.8439 | 69580.0 |
| 2006-07-17 08:10:00 | AAPL | Stock | 1.8432 | 1.8443 | 1.8429 | 1.8443 | 42000.0 |
| 2006-07-17 08:11:00 | AAPL | Stock | 1.8439 | 1.8486 | 1.8439 | 1.8482 | 318668.0 |
| 2006-07-17 08:12:00 | AAPL | Stock | 1.8493 | 1.8571 | 1.8489 | 1.8571 | 326256.0 |
| 2006-07-17 08:13:00 | AAPL | Stock | 1.8564 | 1.8607 | 1.8561 | 1.8596 | 975996.0 |
| 2006-07-17 08:14:00 | AAPL | Stock | 1.8596 | 1.86 | 1.8554 | 1.8557 | 346080.0 |
| 2006-07-17 08:15:00 | AAPL | Stock | 1.8557 | 1.8575 | 1.8518 | 1.8518 | 338800.0 |
| 2006-07-17 08:16:00 | AAPL | Stock | 1.8518 | 1.8571 | 1.8518 | 1.8571 | 174356.0 |
| 2006-07-17 08:17:00 | AAPL | Stock | 1.8543 | 1.8543 | 1.8539 | 1.8539 | 9100.0 |
| 2006-07-17 08:18:00 | AAPL | Stock | 1.8529 | 1.855 | 1.8521 | 1.855 | 119700.0 |
| 2006-07-17 08:19:00 | AAPL | Stock | 1.8546 | 1.855 | 1.8521 | 1.8521 | 266700.0 |
| 2006-07-17 08:20:00 | AAPL | Stock | 1.8529 | 1.8536 | 1.8521 | 1.8536 | 84000.0 |
| 2006-07-17 08:21:00 | AAPL | Stock | 1.8536 | 1.8536 | 1.8525 | 1.8536 | 151200.0 |
| 2006-07-17 08:22:00 | AAPL | Stock | 1.8536 | 1.8543 | 1.8536 | 1.8536 | 137200.0 |
| 2006-07-17 08:23:00 | AAPL | Stock | 1.8543 | 1.855 | 1.8536 | 1.855 | 139552.0 |
| 2006-07-17 08:24:00 | AAPL | Stock | 1.855 | 1.8589 | 1.855 | 1.8575 | 284928.0 |
| 2006-07-17 08:25:00 | AAPL | Stock | 1.8579 | 1.8593 | 1.855 | 1.8571 | 439852.0 |
> showing 50 of 681,173 rows — these rows as CSV