PREVIEW / stock_1min / 2007-07-05
file: by_date/stock_1min/2007/2007-07-05.parquet size: 11.0 MB rows: 903,346 symbols: 2,480
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 |
|---|---|---|---|---|---|---|---|
| 2007-07-05 09:30:00 | AAPL | Stock | 4.6 | 4.6039 | 4.5961 | 4.5989 | 12270244.0 |
| 2007-07-05 09:31:00 | AAPL | Stock | 4.6018 | 4.6357 | 4.5968 | 4.6214 | 19900580.0 |
| 2007-07-05 09:32:00 | AAPL | Stock | 4.6214 | 4.6368 | 4.5966 | 4.6361 | 10231032.0 |
| 2007-07-05 09:33:00 | AAPL | Stock | 4.635 | 4.6554 | 4.635 | 4.6554 | 17899168.0 |
| 2007-07-05 09:34:00 | AAPL | Stock | 4.655 | 4.6604 | 4.6361 | 4.6382 | 17379768.0 |
| 2007-07-05 09:35:00 | AAPL | Stock | 4.6386 | 4.6546 | 4.6361 | 4.6543 | 10963316.0 |
| 2007-07-05 09:36:00 | AAPL | Stock | 4.6543 | 4.6761 | 4.6474 | 4.67 | 15722784.0 |
| 2007-07-05 09:37:00 | AAPL | Stock | 4.6704 | 4.6896 | 4.6696 | 4.6882 | 16366896.0 |
| 2007-07-05 09:38:00 | AAPL | Stock | 4.6886 | 4.7054 | 4.6768 | 4.6954 | 19122824.0 |
| 2007-07-05 09:39:00 | AAPL | Stock | 4.695 | 4.6961 | 4.6714 | 4.6755 | 15232868.0 |
| 2007-07-05 09:40:00 | AAPL | Stock | 4.6754 | 4.6843 | 4.6721 | 4.6786 | 11341092.0 |
| 2007-07-05 09:41:00 | AAPL | Stock | 4.6786 | 4.6861 | 4.6754 | 4.6836 | 10646020.0 |
| 2007-07-05 09:42:00 | AAPL | Stock | 4.6836 | 4.6904 | 4.6836 | 4.6896 | 10456936.0 |
| 2007-07-05 09:43:00 | AAPL | Stock | 4.69 | 4.6961 | 4.6839 | 4.6839 | 9529576.0 |
| 2007-07-05 09:44:00 | AAPL | Stock | 4.6841 | 4.685 | 4.6521 | 4.6539 | 14425348.0 |
| 2007-07-05 09:45:00 | AAPL | Stock | 4.6539 | 4.6561 | 4.6321 | 4.6396 | 14339304.0 |
| 2007-07-05 09:46:00 | AAPL | Stock | 4.6396 | 4.6464 | 4.63 | 4.6443 | 12884564.0 |
| 2007-07-05 09:47:00 | AAPL | Stock | 4.645 | 4.6539 | 4.6418 | 4.6461 | 9965116.0 |
| 2007-07-05 09:48:00 | AAPL | Stock | 4.6457 | 4.6496 | 4.6307 | 4.6396 | 10843672.0 |
| 2007-07-05 09:49:00 | AAPL | Stock | 4.64 | 4.6429 | 4.6307 | 4.6364 | 7013720.0 |
| 2007-07-05 09:50:00 | AAPL | Stock | 4.6364 | 4.6536 | 4.6342 | 4.6511 | 7845992.0 |
| 2007-07-05 09:51:00 | AAPL | Stock | 4.6511 | 4.6536 | 4.6439 | 4.6525 | 5273408.0 |
| 2007-07-05 09:52:00 | AAPL | Stock | 4.6529 | 4.6718 | 4.6525 | 4.6711 | 10279052.0 |
| 2007-07-05 09:53:00 | AAPL | Stock | 4.6711 | 4.6718 | 4.6561 | 4.6575 | 5614448.0 |
| 2007-07-05 09:54:00 | AAPL | Stock | 4.6579 | 4.6589 | 4.6482 | 4.6514 | 4632292.0 |
| 2007-07-05 09:55:00 | AAPL | Stock | 4.6514 | 4.6554 | 4.6446 | 4.6457 | 5178936.0 |
| 2007-07-05 09:56:00 | AAPL | Stock | 4.6454 | 4.6461 | 4.6375 | 4.6378 | 6243552.0 |
| 2007-07-05 09:57:00 | AAPL | Stock | 4.6382 | 4.6471 | 4.6375 | 4.645 | 6455204.0 |
| 2007-07-05 09:58:00 | AAPL | Stock | 4.6446 | 4.6479 | 4.6414 | 4.6461 | 7851928.0 |
| 2007-07-05 09:59:00 | AAPL | Stock | 4.6457 | 4.6532 | 4.6443 | 4.6507 | 3778712.0 |
| 2007-07-05 10:00:00 | AAPL | Stock | 4.6504 | 4.6561 | 4.6482 | 4.6511 | 5834080.0 |
| 2007-07-05 10:01:00 | AAPL | Stock | 4.6504 | 4.6561 | 4.6504 | 4.6535 | 4271904.0 |
| 2007-07-05 10:02:00 | AAPL | Stock | 4.6536 | 4.6561 | 4.6464 | 4.6514 | 5412932.0 |
| 2007-07-05 10:03:00 | AAPL | Stock | 4.6514 | 4.6636 | 4.65 | 4.6625 | 5959212.0 |
| 2007-07-05 10:04:00 | AAPL | Stock | 4.6629 | 4.6643 | 4.6546 | 4.6571 | 4075596.0 |
| 2007-07-05 10:05:00 | AAPL | Stock | 4.6564 | 4.6571 | 4.6507 | 4.655 | 5555956.0 |
| 2007-07-05 10:06:00 | AAPL | Stock | 4.6546 | 4.6564 | 4.6518 | 4.6543 | 4715956.0 |
| 2007-07-05 10:07:00 | AAPL | Stock | 4.6539 | 4.6568 | 4.6429 | 4.6429 | 7595560.0 |
| 2007-07-05 10:08:00 | AAPL | Stock | 4.6432 | 4.65 | 4.6429 | 4.6489 | 6149556.0 |
| 2007-07-05 10:09:00 | AAPL | Stock | 4.6486 | 4.6554 | 4.6457 | 4.6539 | 4761540.0 |
| 2007-07-05 10:10:00 | AAPL | Stock | 4.6546 | 4.6639 | 4.6521 | 4.6629 | 7021560.0 |
| 2007-07-05 10:11:00 | AAPL | Stock | 4.6625 | 4.6632 | 4.6475 | 4.6475 | 6804000.0 |
| 2007-07-05 10:12:00 | AAPL | Stock | 4.6471 | 4.6479 | 4.6357 | 4.6429 | 12193412.0 |
| 2007-07-05 10:13:00 | AAPL | Stock | 4.6429 | 4.6521 | 4.6411 | 4.6514 | 3995012.0 |
| 2007-07-05 10:14:00 | AAPL | Stock | 4.6511 | 4.6554 | 4.6507 | 4.6529 | 4716068.0 |
| 2007-07-05 10:15:00 | AAPL | Stock | 4.6525 | 4.6704 | 4.6514 | 4.6636 | 8913072.0 |
| 2007-07-05 10:16:00 | AAPL | Stock | 4.6639 | 4.6668 | 4.6582 | 4.6603 | 6224848.0 |
| 2007-07-05 10:17:00 | AAPL | Stock | 4.66 | 4.6607 | 4.6521 | 4.6571 | 4493972.0 |
| 2007-07-05 10:18:00 | AAPL | Stock | 4.6571 | 4.6661 | 4.6554 | 4.6661 | 4435116.0 |
| 2007-07-05 10:19:00 | AAPL | Stock | 4.6661 | 4.6718 | 4.6596 | 4.6711 | 5104064.0 |
> showing 50 of 903,346 rows — these rows as CSV