PREVIEW / stock_5min / 2010-06-03
file: by_date/stock_5min/2010/2010-06-03.parquet size: 4.8 MB rows: 329,299 symbols: 3,460
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 |
|---|---|---|---|---|---|---|---|
| 2010-06-03 04:15:00 | AAPL | Stock | 9.5575 | 9.5575 | 9.4532 | 9.4875 | 19600.0 |
| 2010-06-03 04:20:00 | AAPL | Stock | 9.4889 | 9.4889 | 9.4889 | 9.4889 | 2800.0 |
| 2010-06-03 04:25:00 | AAPL | Stock | 9.5 | 9.5 | 9.5 | 9.5 | 2800.0 |
| 2010-06-03 05:05:00 | AAPL | Stock | 9.5004 | 9.5004 | 9.5004 | 9.5004 | 5600.0 |
| 2010-06-03 05:10:00 | AAPL | Stock | 9.5179 | 9.5179 | 9.5179 | 9.5179 | 5600.0 |
| 2010-06-03 05:40:00 | AAPL | Stock | 9.5143 | 9.5143 | 9.5143 | 9.5143 | 2800.0 |
| 2010-06-03 06:05:00 | AAPL | Stock | 9.5143 | 9.5143 | 9.5143 | 9.5143 | 2800.0 |
| 2010-06-03 06:20:00 | AAPL | Stock | 9.4911 | 9.4911 | 9.4911 | 9.4911 | 5600.0 |
| 2010-06-03 06:50:00 | AAPL | Stock | 9.4911 | 9.4911 | 9.4911 | 9.4911 | 3332.0 |
| 2010-06-03 06:55:00 | AAPL | Stock | 9.4911 | 9.4911 | 9.4911 | 9.4911 | 14000.0 |
| 2010-06-03 07:00:00 | AAPL | Stock | 9.4911 | 9.4911 | 9.4821 | 9.4857 | 167300.0 |
| 2010-06-03 07:05:00 | AAPL | Stock | 9.4964 | 9.4979 | 9.4857 | 9.4857 | 44800.0 |
| 2010-06-03 07:10:00 | AAPL | Stock | 9.4804 | 9.4921 | 9.4786 | 9.4921 | 15232.0 |
| 2010-06-03 07:15:00 | AAPL | Stock | 9.4918 | 9.4921 | 9.4914 | 9.4918 | 11200.0 |
| 2010-06-03 07:20:00 | AAPL | Stock | 9.4921 | 9.4921 | 9.4921 | 9.4921 | 2800.0 |
| 2010-06-03 07:25:00 | AAPL | Stock | 9.4929 | 9.4929 | 9.4789 | 9.4875 | 95200.0 |
| 2010-06-03 07:30:00 | AAPL | Stock | 9.4893 | 9.5054 | 9.4893 | 9.5054 | 125440.0 |
| 2010-06-03 07:35:00 | AAPL | Stock | 9.5054 | 9.5121 | 9.5054 | 9.5075 | 63140.0 |
| 2010-06-03 07:40:00 | AAPL | Stock | 9.5071 | 9.5075 | 9.5054 | 9.5054 | 25200.0 |
| 2010-06-03 07:45:00 | AAPL | Stock | 9.5054 | 9.5054 | 9.5 | 9.5032 | 241892.0 |
| 2010-06-03 07:50:00 | AAPL | Stock | 9.5032 | 9.5054 | 9.5029 | 9.5029 | 67200.0 |
| 2010-06-03 07:55:00 | AAPL | Stock | 9.4986 | 9.4986 | 9.4986 | 9.4986 | 2800.0 |
| 2010-06-03 08:00:00 | AAPL | Stock | 9.4954 | 9.5032 | 9.4786 | 9.4854 | 478352.0 |
| 2010-06-03 08:05:00 | AAPL | Stock | 9.4854 | 9.4886 | 9.4732 | 9.4821 | 141148.0 |
| 2010-06-03 08:10:00 | AAPL | Stock | 9.48 | 9.4857 | 9.4754 | 9.4811 | 171612.0 |
| 2010-06-03 08:15:00 | AAPL | Stock | 9.4736 | 9.475 | 9.4511 | 9.4529 | 738696.0 |
| 2010-06-03 08:20:00 | AAPL | Stock | 9.4518 | 9.4729 | 9.4518 | 9.4596 | 370580.0 |
| 2010-06-03 08:25:00 | AAPL | Stock | 9.4571 | 9.4643 | 9.4561 | 9.4643 | 141288.0 |
| 2010-06-03 08:30:00 | AAPL | Stock | 9.4643 | 9.4686 | 9.4493 | 9.4568 | 348180.0 |
| 2010-06-03 08:35:00 | AAPL | Stock | 9.4568 | 9.4621 | 9.4539 | 9.4568 | 268324.0 |
| 2010-06-03 08:40:00 | AAPL | Stock | 9.4557 | 9.4625 | 9.4514 | 9.4589 | 250292.0 |
| 2010-06-03 08:45:00 | AAPL | Stock | 9.4625 | 9.4804 | 9.4625 | 9.475 | 314020.0 |
| 2010-06-03 08:50:00 | AAPL | Stock | 9.4754 | 9.4821 | 9.4661 | 9.47 | 382900.0 |
| 2010-06-03 08:55:00 | AAPL | Stock | 9.4729 | 9.4771 | 9.4696 | 9.4761 | 193200.0 |
| 2010-06-03 09:00:00 | AAPL | Stock | 9.4775 | 9.4786 | 9.4718 | 9.4725 | 404264.0 |
| 2010-06-03 09:05:00 | AAPL | Stock | 9.4729 | 9.4754 | 9.4693 | 9.475 | 336504.0 |
| 2010-06-03 09:10:00 | AAPL | Stock | 9.4732 | 9.4775 | 9.4725 | 9.4754 | 312620.0 |
| 2010-06-03 09:15:00 | AAPL | Stock | 9.475 | 9.4782 | 9.4679 | 9.4725 | 99036.0 |
| 2010-06-03 09:20:00 | AAPL | Stock | 9.4736 | 9.4757 | 9.4625 | 9.4625 | 324436.0 |
| 2010-06-03 09:25:00 | AAPL | Stock | 9.4625 | 9.4746 | 9.4539 | 9.4696 | 417704.0 |
| 2010-06-03 09:30:00 | AAPL | Stock | 9.4696 | 9.4839 | 9.4379 | 9.4511 | 23738064.0 |
| 2010-06-03 09:35:00 | AAPL | Stock | 9.4511 | 9.4554 | 9.4075 | 9.4164 | 22995784.0 |
| 2010-06-03 09:40:00 | AAPL | Stock | 9.4164 | 9.4482 | 9.4107 | 9.4418 | 14852012.0 |
| 2010-06-03 09:45:00 | AAPL | Stock | 9.4414 | 9.4571 | 9.4304 | 9.4539 | 13133484.0 |
| 2010-06-03 09:50:00 | AAPL | Stock | 9.4543 | 9.4554 | 9.415 | 9.4168 | 14327180.0 |
| 2010-06-03 09:55:00 | AAPL | Stock | 9.4168 | 9.4375 | 9.4157 | 9.4345 | 10990504.0 |
| 2010-06-03 10:00:00 | AAPL | Stock | 9.4343 | 9.4343 | 9.3857 | 9.3886 | 20259792.0 |
| 2010-06-03 10:05:00 | AAPL | Stock | 9.3934 | 9.4036 | 9.3793 | 9.4009 | 15209488.0 |
| 2010-06-03 10:10:00 | AAPL | Stock | 9.4007 | 9.4071 | 9.3871 | 9.3904 | 7657356.0 |
| 2010-06-03 10:15:00 | AAPL | Stock | 9.3904 | 9.4071 | 9.3821 | 9.3855 | 8131088.0 |
> showing 50 of 329,299 rows — these rows as CSV