PREVIEW / stock_5min / 2008-02-11
file: by_date/stock_5min/2008/2008-02-11.parquet size: 4.3 MB rows: 316,818 symbols: 3,264
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 |
|---|---|---|---|---|---|---|---|
| 2008-02-11 06:00:00 | AAPL | Stock | 4.4911 | 4.4911 | 4.4911 | 4.4911 | 5600.0 |
| 2008-02-11 06:20:00 | AAPL | Stock | 4.4911 | 4.4911 | 4.4911 | 4.4911 | 2800.0 |
| 2008-02-11 06:25:00 | AAPL | Stock | 4.5 | 4.5 | 4.5 | 4.5 | 28000.0 |
| 2008-02-11 06:35:00 | AAPL | Stock | 4.5104 | 4.5175 | 4.5104 | 4.5175 | 5600.0 |
| 2008-02-11 06:40:00 | AAPL | Stock | 4.5179 | 4.5179 | 4.5043 | 4.5082 | 112000.0 |
| 2008-02-11 06:45:00 | AAPL | Stock | 4.5264 | 4.5357 | 4.5264 | 4.5357 | 184800.0 |
| 2008-02-11 06:55:00 | AAPL | Stock | 4.5336 | 4.5336 | 4.5336 | 4.5336 | 14000.0 |
| 2008-02-11 07:00:00 | AAPL | Stock | 4.5357 | 4.5357 | 4.5279 | 4.5279 | 42840.0 |
| 2008-02-11 07:10:00 | AAPL | Stock | 4.5357 | 4.5357 | 4.5279 | 4.5357 | 33600.0 |
| 2008-02-11 07:15:00 | AAPL | Stock | 4.5354 | 4.5361 | 4.5354 | 4.5361 | 40516.0 |
| 2008-02-11 07:20:00 | AAPL | Stock | 4.5364 | 4.5364 | 4.5357 | 4.5357 | 5600.0 |
| 2008-02-11 07:25:00 | AAPL | Stock | 4.5429 | 4.5536 | 4.5429 | 4.5525 | 53200.0 |
| 2008-02-11 07:30:00 | AAPL | Stock | 4.5436 | 4.5536 | 4.5429 | 4.5429 | 50400.0 |
| 2008-02-11 07:40:00 | AAPL | Stock | 4.5357 | 4.5357 | 4.5357 | 4.5357 | 16800.0 |
| 2008-02-11 07:45:00 | AAPL | Stock | 4.5393 | 4.5393 | 4.5393 | 4.5393 | 5600.0 |
| 2008-02-11 07:50:00 | AAPL | Stock | 4.5393 | 4.5436 | 4.5357 | 4.5436 | 91000.0 |
| 2008-02-11 07:55:00 | AAPL | Stock | 4.5436 | 4.5436 | 4.5321 | 4.5357 | 173600.0 |
| 2008-02-11 08:00:00 | AAPL | Stock | 4.5321 | 4.5461 | 4.5282 | 4.5446 | 903952.0 |
| 2008-02-11 08:05:00 | AAPL | Stock | 4.5407 | 4.5446 | 4.5357 | 4.5418 | 638960.0 |
| 2008-02-11 08:10:00 | AAPL | Stock | 4.5418 | 4.5518 | 4.5411 | 4.5482 | 922600.0 |
| 2008-02-11 08:15:00 | AAPL | Stock | 4.55 | 4.5604 | 4.5461 | 4.56 | 531076.0 |
| 2008-02-11 08:20:00 | AAPL | Stock | 4.555 | 4.5696 | 4.5546 | 4.5664 | 785876.0 |
| 2008-02-11 08:25:00 | AAPL | Stock | 4.5664 | 4.5707 | 4.565 | 4.5679 | 609028.0 |
| 2008-02-11 08:30:00 | AAPL | Stock | 4.5679 | 4.58 | 4.5675 | 4.5786 | 2563960.0 |
| 2008-02-11 08:35:00 | AAPL | Stock | 4.5736 | 4.5821 | 4.5654 | 4.5693 | 982464.0 |
| 2008-02-11 08:40:00 | AAPL | Stock | 4.5704 | 4.575 | 4.5679 | 4.5704 | 601664.0 |
| 2008-02-11 08:45:00 | AAPL | Stock | 4.5704 | 4.5761 | 4.5661 | 4.5739 | 598136.0 |
| 2008-02-11 08:50:00 | AAPL | Stock | 4.5714 | 4.5718 | 4.5664 | 4.5664 | 419384.0 |
| 2008-02-11 08:55:00 | AAPL | Stock | 4.5679 | 4.5836 | 4.5661 | 4.5821 | 1318100.0 |
| 2008-02-11 09:00:00 | AAPL | Stock | 4.5821 | 4.5871 | 4.5668 | 4.5832 | 2034844.0 |
| 2008-02-11 09:05:00 | AAPL | Stock | 4.5825 | 4.5857 | 4.5754 | 4.5786 | 991312.0 |
| 2008-02-11 09:10:00 | AAPL | Stock | 4.5786 | 4.5796 | 4.5643 | 4.5707 | 1898848.0 |
| 2008-02-11 09:15:00 | AAPL | Stock | 4.5711 | 4.5764 | 4.5707 | 4.575 | 587328.0 |
| 2008-02-11 09:20:00 | AAPL | Stock | 4.5736 | 4.5754 | 4.5664 | 4.5679 | 500612.0 |
| 2008-02-11 09:25:00 | AAPL | Stock | 4.5679 | 4.575 | 4.5593 | 4.5714 | 1895292.0 |
| 2008-02-11 09:30:00 | AAPL | Stock | 4.5718 | 4.6064 | 4.5486 | 4.6064 | 42859152.0 |
| 2008-02-11 09:35:00 | AAPL | Stock | 4.6064 | 4.6071 | 4.5568 | 4.5614 | 36454432.0 |
| 2008-02-11 09:40:00 | AAPL | Stock | 4.5611 | 4.5786 | 4.5539 | 4.5732 | 27723668.0 |
| 2008-02-11 09:45:00 | AAPL | Stock | 4.5729 | 4.5989 | 4.565 | 4.5818 | 29381856.0 |
| 2008-02-11 09:50:00 | AAPL | Stock | 4.5818 | 4.6 | 4.5793 | 4.5925 | 27699280.0 |
| 2008-02-11 09:55:00 | AAPL | Stock | 4.5929 | 4.6107 | 4.5893 | 4.5929 | 32424784.0 |
| 2008-02-11 10:00:00 | AAPL | Stock | 4.5932 | 4.605 | 4.5811 | 4.5889 | 26449472.0 |
| 2008-02-11 10:05:00 | AAPL | Stock | 4.5889 | 4.5914 | 4.5575 | 4.5596 | 24734164.0 |
| 2008-02-11 10:10:00 | AAPL | Stock | 4.5586 | 4.5614 | 4.5429 | 4.5546 | 25742556.0 |
| 2008-02-11 10:15:00 | AAPL | Stock | 4.5543 | 4.5696 | 4.5529 | 4.5579 | 13615504.0 |
| 2008-02-11 10:20:00 | AAPL | Stock | 4.56 | 4.5696 | 4.5536 | 4.5632 | 14526260.0 |
| 2008-02-11 10:25:00 | AAPL | Stock | 4.5639 | 4.5811 | 4.5543 | 4.5768 | 13374060.0 |
| 2008-02-11 10:30:00 | AAPL | Stock | 4.5771 | 4.5818 | 4.5629 | 4.57 | 12861408.0 |
| 2008-02-11 10:35:00 | AAPL | Stock | 4.5704 | 4.5789 | 4.5654 | 4.5732 | 10112984.0 |
| 2008-02-11 10:40:00 | AAPL | Stock | 4.5732 | 4.5843 | 4.5682 | 4.5827 | 10331888.0 |
> showing 50 of 316,818 rows — these rows as CSV