PREVIEW / stock_1min / 2007-07-23
file: by_date/stock_1min/2007/2007-07-23.parquet size: 11.4 MB rows: 936,554 symbols: 2,525
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-23 09:30:00 | AAPL | Stock | 5.1182 | 5.1239 | 5.1143 | 5.1143 | 13867308.0 |
| 2007-07-23 09:31:00 | AAPL | Stock | 5.1143 | 5.1207 | 5.0986 | 5.0993 | 5811904.0 |
| 2007-07-23 09:32:00 | AAPL | Stock | 5.0996 | 5.1175 | 5.0982 | 5.115 | 4511556.0 |
| 2007-07-23 09:33:00 | AAPL | Stock | 5.1036 | 5.1146 | 5.1007 | 5.1086 | 3444784.0 |
| 2007-07-23 09:34:00 | AAPL | Stock | 5.1089 | 5.1089 | 5.0989 | 5.0993 | 3614744.0 |
| 2007-07-23 09:35:00 | AAPL | Stock | 5.0989 | 5.1044 | 5.0825 | 5.0843 | 6541976.0 |
| 2007-07-23 09:36:00 | AAPL | Stock | 5.1005 | 5.1005 | 5.0814 | 5.0818 | 5674424.0 |
| 2007-07-23 09:37:00 | AAPL | Stock | 5.0825 | 5.0839 | 5.0714 | 5.0739 | 6852608.0 |
| 2007-07-23 09:38:00 | AAPL | Stock | 5.0736 | 5.0739 | 5.0629 | 5.0639 | 7247576.0 |
| 2007-07-23 09:39:00 | AAPL | Stock | 5.0639 | 5.0654 | 5.0539 | 5.0589 | 9231096.0 |
| 2007-07-23 09:40:00 | AAPL | Stock | 5.0596 | 5.0746 | 5.0571 | 5.0736 | 6807136.0 |
| 2007-07-23 09:41:00 | AAPL | Stock | 5.0732 | 5.0839 | 5.0714 | 5.0825 | 6812120.0 |
| 2007-07-23 09:42:00 | AAPL | Stock | 5.0825 | 5.1221 | 5.075 | 5.0775 | 5221020.0 |
| 2007-07-23 09:43:00 | AAPL | Stock | 5.0757 | 5.0779 | 5.0714 | 5.0714 | 6865320.0 |
| 2007-07-23 09:44:00 | AAPL | Stock | 5.0714 | 5.072 | 5.0575 | 5.0582 | 5127164.0 |
| 2007-07-23 09:45:00 | AAPL | Stock | 5.0586 | 5.1071 | 5.0407 | 5.0411 | 10369800.0 |
| 2007-07-23 09:46:00 | AAPL | Stock | 5.04 | 5.0429 | 5.0332 | 5.0396 | 10030132.0 |
| 2007-07-23 09:47:00 | AAPL | Stock | 5.0396 | 5.0457 | 5.0375 | 5.0429 | 6093864.0 |
| 2007-07-23 09:48:00 | AAPL | Stock | 5.0429 | 5.0493 | 5.0421 | 5.0493 | 3342724.0 |
| 2007-07-23 09:49:00 | AAPL | Stock | 5.0492 | 5.0536 | 5.0489 | 5.0529 | 4402412.0 |
| 2007-07-23 09:50:00 | AAPL | Stock | 5.0529 | 5.0586 | 5.0511 | 5.0586 | 4372480.0 |
| 2007-07-23 09:51:00 | AAPL | Stock | 5.0589 | 5.0604 | 5.0561 | 5.0586 | 3108868.0 |
| 2007-07-23 09:52:00 | AAPL | Stock | 5.0582 | 5.06 | 5.0539 | 5.0544 | 3131436.0 |
| 2007-07-23 09:53:00 | AAPL | Stock | 5.0546 | 5.0575 | 5.0512 | 5.055 | 3169712.0 |
| 2007-07-23 09:54:00 | AAPL | Stock | 5.055 | 5.0557 | 5.05 | 5.0504 | 2225412.0 |
| 2007-07-23 09:55:00 | AAPL | Stock | 5.05 | 5.0529 | 5.0493 | 5.0518 | 4988256.0 |
| 2007-07-23 09:56:00 | AAPL | Stock | 5.0514 | 5.0604 | 5.05 | 5.0604 | 4043956.0 |
| 2007-07-23 09:57:00 | AAPL | Stock | 5.0604 | 5.0714 | 5.0593 | 5.0714 | 4756920.0 |
| 2007-07-23 09:58:00 | AAPL | Stock | 5.0714 | 5.0721 | 5.0646 | 5.0682 | 4829048.0 |
| 2007-07-23 09:59:00 | AAPL | Stock | 5.0682 | 5.0686 | 5.0625 | 5.065 | 2590140.0 |
| 2007-07-23 10:00:00 | AAPL | Stock | 5.065 | 5.0661 | 5.0636 | 5.065 | 1779512.0 |
| 2007-07-23 10:01:00 | AAPL | Stock | 5.0637 | 5.0675 | 5.0637 | 5.0664 | 1765792.0 |
| 2007-07-23 10:02:00 | AAPL | Stock | 5.0664 | 5.0743 | 5.0661 | 5.0739 | 3429356.0 |
| 2007-07-23 10:03:00 | AAPL | Stock | 5.0743 | 5.075 | 5.0696 | 5.0731 | 3402672.0 |
| 2007-07-23 10:04:00 | AAPL | Stock | 5.0731 | 5.0746 | 5.0664 | 5.0704 | 4337648.0 |
| 2007-07-23 10:05:00 | AAPL | Stock | 5.0707 | 5.0714 | 5.0643 | 5.0646 | 3796268.0 |
| 2007-07-23 10:06:00 | AAPL | Stock | 5.0646 | 5.0646 | 5.0568 | 5.0571 | 3235596.0 |
| 2007-07-23 10:07:00 | AAPL | Stock | 5.0571 | 5.0621 | 5.0536 | 5.06 | 4000892.0 |
| 2007-07-23 10:08:00 | AAPL | Stock | 5.0604 | 5.0654 | 5.0557 | 5.0636 | 2082332.0 |
| 2007-07-23 10:09:00 | AAPL | Stock | 5.0643 | 5.0654 | 5.0546 | 5.0561 | 2315908.0 |
| 2007-07-23 10:10:00 | AAPL | Stock | 5.055 | 5.0554 | 5.0532 | 5.0539 | 2723364.0 |
| 2007-07-23 10:11:00 | AAPL | Stock | 5.0539 | 5.0589 | 5.0536 | 5.0582 | 2739296.0 |
| 2007-07-23 10:12:00 | AAPL | Stock | 5.0586 | 5.0604 | 5.0536 | 5.0536 | 1969324.0 |
| 2007-07-23 10:13:00 | AAPL | Stock | 5.0536 | 5.0582 | 5.0532 | 5.0546 | 2281636.0 |
| 2007-07-23 10:14:00 | AAPL | Stock | 5.0543 | 5.0582 | 5.0536 | 5.0554 | 2501688.0 |
| 2007-07-23 10:15:00 | AAPL | Stock | 5.0554 | 5.0571 | 5.0536 | 5.0539 | 1985816.0 |
| 2007-07-23 10:16:00 | AAPL | Stock | 5.0543 | 5.0614 | 5.0536 | 5.06 | 2164008.0 |
| 2007-07-23 10:17:00 | AAPL | Stock | 5.0596 | 5.06 | 5.0554 | 5.0564 | 1246784.0 |
| 2007-07-23 10:18:00 | AAPL | Stock | 5.0564 | 5.0621 | 5.0557 | 5.0579 | 2406628.0 |
| 2007-07-23 10:19:00 | AAPL | Stock | 5.0579 | 5.0607 | 5.0564 | 5.06 | 1464512.0 |
> showing 50 of 936,554 rows — these rows as CSV