PREVIEW / stock_1min / 2004-10-20
file: by_date/stock_1min/2004/2004-10-20.parquet size: 6.1 MB rows: 503,365 symbols: 1,514
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 |
|---|---|---|---|---|---|---|---|
| 2004-10-20 08:01:00 | AAPL | Stock | 0.842 | 0.842 | 0.842 | 0.842 | 44632.0 |
| 2004-10-20 08:02:00 | AAPL | Stock | 0.8465 | 0.8465 | 0.8465 | 0.8465 | 1601600.0 |
| 2004-10-20 08:03:00 | AAPL | Stock | 0.842 | 0.842 | 0.842 | 0.842 | 11368.0 |
| 2004-10-20 08:10:00 | AAPL | Stock | 0.842 | 0.842 | 0.842 | 0.842 | 39200.0 |
| 2004-10-20 08:18:00 | AAPL | Stock | 0.842 | 0.842 | 0.842 | 0.842 | 11368.0 |
| 2004-10-20 08:28:00 | AAPL | Stock | 0.842 | 0.842 | 0.842 | 0.842 | 5600.0 |
| 2004-10-20 08:29:00 | AAPL | Stock | 0.842 | 0.842 | 0.842 | 0.842 | 5600.0 |
| 2004-10-20 08:31:00 | AAPL | Stock | 0.842 | 0.842 | 0.842 | 0.842 | 5600.0 |
| 2004-10-20 08:50:00 | AAPL | Stock | 0.842 | 0.842 | 0.842 | 0.842 | 56000.0 |
| 2004-10-20 09:09:00 | AAPL | Stock | 0.8439 | 0.8439 | 0.8439 | 0.8439 | 33600.0 |
| 2004-10-20 09:10:00 | AAPL | Stock | 0.842 | 0.842 | 0.8404 | 0.8404 | 95200.0 |
| 2004-10-20 09:11:00 | AAPL | Stock | 0.8402 | 0.8402 | 0.84 | 0.8402 | 84000.0 |
| 2004-10-20 09:12:00 | AAPL | Stock | 0.8411 | 0.8411 | 0.8402 | 0.8402 | 33432.0 |
| 2004-10-20 09:13:00 | AAPL | Stock | 0.8418 | 0.8418 | 0.8418 | 0.8418 | 11200.0 |
| 2004-10-20 09:19:00 | AAPL | Stock | 0.8411 | 0.8442 | 0.8411 | 0.8442 | 128800.0 |
| 2004-10-20 09:20:00 | AAPL | Stock | 0.8413 | 0.8413 | 0.8411 | 0.8411 | 11200.0 |
| 2004-10-20 09:21:00 | AAPL | Stock | 0.8429 | 0.8429 | 0.8429 | 0.8429 | 11200.0 |
| 2004-10-20 09:25:00 | AAPL | Stock | 0.8429 | 0.8446 | 0.8427 | 0.8429 | 78400.0 |
| 2004-10-20 09:26:00 | AAPL | Stock | 0.8429 | 0.8434 | 0.8423 | 0.8434 | 39200.0 |
| 2004-10-20 09:27:00 | AAPL | Stock | 0.8429 | 0.8438 | 0.8429 | 0.8438 | 54152.0 |
| 2004-10-20 09:28:00 | AAPL | Stock | 0.8429 | 0.8429 | 0.8429 | 0.8429 | 56000.0 |
| 2004-10-20 09:29:00 | AAPL | Stock | 0.8434 | 0.8438 | 0.8411 | 0.8411 | 523600.0 |
| 2004-10-20 09:30:00 | AAPL | Stock | 0.8411 | 0.8438 | 0.8402 | 0.8431 | 7576968.0 |
| 2004-10-20 09:31:00 | AAPL | Stock | 0.843 | 0.8441 | 0.8411 | 0.8441 | 4751320.0 |
| 2004-10-20 09:32:00 | AAPL | Stock | 0.8441 | 0.8477 | 0.8438 | 0.8468 | 3237752.0 |
| 2004-10-20 09:33:00 | AAPL | Stock | 0.8464 | 0.8471 | 0.845 | 0.8452 | 2671984.0 |
| 2004-10-20 09:34:00 | AAPL | Stock | 0.8452 | 0.8452 | 0.8441 | 0.8445 | 2028936.0 |
| 2004-10-20 09:35:00 | AAPL | Stock | 0.8446 | 0.8448 | 0.8439 | 0.8446 | 1646960.0 |
| 2004-10-20 09:36:00 | AAPL | Stock | 0.8448 | 0.845 | 0.8443 | 0.8446 | 4663960.0 |
| 2004-10-20 09:37:00 | AAPL | Stock | 0.8446 | 0.8446 | 0.8439 | 0.8445 | 2309328.0 |
| 2004-10-20 09:38:00 | AAPL | Stock | 0.8443 | 0.8446 | 0.8439 | 0.8441 | 1646400.0 |
| 2004-10-20 09:39:00 | AAPL | Stock | 0.8445 | 0.8445 | 0.8439 | 0.8445 | 976360.0 |
| 2004-10-20 09:40:00 | AAPL | Stock | 0.8445 | 0.8446 | 0.8439 | 0.8443 | 2342424.0 |
| 2004-10-20 09:41:00 | AAPL | Stock | 0.8444 | 0.8446 | 0.8441 | 0.8445 | 1574048.0 |
| 2004-10-20 09:42:00 | AAPL | Stock | 0.8441 | 0.8455 | 0.8441 | 0.845 | 1352232.0 |
| 2004-10-20 09:43:00 | AAPL | Stock | 0.845 | 0.8455 | 0.8441 | 0.8441 | 1347976.0 |
| 2004-10-20 09:44:00 | AAPL | Stock | 0.8439 | 0.845 | 0.8438 | 0.8446 | 1564472.0 |
| 2004-10-20 09:45:00 | AAPL | Stock | 0.8446 | 0.8455 | 0.8446 | 0.8455 | 593320.0 |
| 2004-10-20 09:46:00 | AAPL | Stock | 0.8455 | 0.8466 | 0.8455 | 0.8463 | 2821224.0 |
| 2004-10-20 09:47:00 | AAPL | Stock | 0.8463 | 0.8473 | 0.8457 | 0.8473 | 1353240.0 |
| 2004-10-20 09:48:00 | AAPL | Stock | 0.847 | 0.8473 | 0.8457 | 0.8464 | 2533048.0 |
| 2004-10-20 09:49:00 | AAPL | Stock | 0.8464 | 0.8488 | 0.8461 | 0.848 | 4047120.0 |
| 2004-10-20 09:50:00 | AAPL | Stock | 0.848 | 0.8488 | 0.8477 | 0.8484 | 1232952.0 |
| 2004-10-20 09:51:00 | AAPL | Stock | 0.8484 | 0.8491 | 0.8482 | 0.8486 | 1145200.0 |
| 2004-10-20 09:52:00 | AAPL | Stock | 0.8486 | 0.8491 | 0.8482 | 0.849 | 1354416.0 |
| 2004-10-20 09:53:00 | AAPL | Stock | 0.8489 | 0.8489 | 0.848 | 0.8486 | 431984.0 |
| 2004-10-20 09:54:00 | AAPL | Stock | 0.8482 | 0.8486 | 0.8482 | 0.8482 | 1791944.0 |
| 2004-10-20 09:55:00 | AAPL | Stock | 0.8484 | 0.8484 | 0.8464 | 0.8473 | 854840.0 |
| 2004-10-20 09:56:00 | AAPL | Stock | 0.8468 | 0.8468 | 0.8457 | 0.8466 | 778008.0 |
| 2004-10-20 09:57:00 | AAPL | Stock | 0.8464 | 0.8477 | 0.8461 | 0.8475 | 907592.0 |
> showing 50 of 503,365 rows — these rows as CSV