PREVIEW / stock_5min / 2006-04-07
file: by_date/stock_5min/2006/2006-04-07.parquet size: 3.1 MB rows: 226,412 symbols: 2,226
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 |
|---|---|---|---|---|---|---|---|
| 2006-04-07 06:05:00 | AAPL | Stock | 2.5714 | 2.5714 | 2.5714 | 2.5714 | 2800.0 |
| 2006-04-07 06:15:00 | AAPL | Stock | 2.5732 | 2.5732 | 2.5732 | 2.5732 | 5600.0 |
| 2006-04-07 06:20:00 | AAPL | Stock | 2.5721 | 2.5721 | 2.5714 | 2.5714 | 5600.0 |
| 2006-04-07 06:35:00 | AAPL | Stock | 2.5696 | 2.5696 | 2.5696 | 2.5696 | 2800.0 |
| 2006-04-07 07:30:00 | AAPL | Stock | 2.5554 | 2.5554 | 2.5536 | 2.5536 | 30800.0 |
| 2006-04-07 07:35:00 | AAPL | Stock | 2.555 | 2.555 | 2.555 | 2.555 | 12880.0 |
| 2006-04-07 07:45:00 | AAPL | Stock | 2.5482 | 2.5482 | 2.5482 | 2.5482 | 2800.0 |
| 2006-04-07 07:50:00 | AAPL | Stock | 2.5468 | 2.5468 | 2.5446 | 2.5446 | 126868.0 |
| 2006-04-07 07:55:00 | AAPL | Stock | 2.5446 | 2.5446 | 2.5429 | 2.5429 | 30800.0 |
| 2006-04-07 08:00:00 | AAPL | Stock | 2.5443 | 2.55 | 2.5179 | 2.5304 | 1262184.0 |
| 2006-04-07 08:05:00 | AAPL | Stock | 2.5304 | 2.5357 | 2.5286 | 2.5357 | 281988.0 |
| 2006-04-07 08:10:00 | AAPL | Stock | 2.5375 | 2.5375 | 2.5321 | 2.5343 | 378336.0 |
| 2006-04-07 08:15:00 | AAPL | Stock | 2.5343 | 2.5382 | 2.5286 | 2.5286 | 727972.0 |
| 2006-04-07 08:20:00 | AAPL | Stock | 2.5286 | 2.5318 | 2.5232 | 2.5289 | 454384.0 |
| 2006-04-07 08:25:00 | AAPL | Stock | 2.5286 | 2.5357 | 2.5286 | 2.5336 | 626836.0 |
| 2006-04-07 08:30:00 | AAPL | Stock | 2.5339 | 2.5539 | 2.5321 | 2.5496 | 2820020.0 |
| 2006-04-07 08:35:00 | AAPL | Stock | 2.5489 | 2.5518 | 2.5286 | 2.5371 | 2603608.0 |
| 2006-04-07 08:40:00 | AAPL | Stock | 2.5386 | 2.5407 | 2.5343 | 2.5375 | 745220.0 |
| 2006-04-07 08:45:00 | AAPL | Stock | 2.5379 | 2.5393 | 2.5343 | 2.5357 | 840196.0 |
| 2006-04-07 08:50:00 | AAPL | Stock | 2.5357 | 2.5393 | 2.5346 | 2.5357 | 730576.0 |
| 2006-04-07 08:55:00 | AAPL | Stock | 2.535 | 2.5393 | 2.535 | 2.5382 | 670824.0 |
| 2006-04-07 09:00:00 | AAPL | Stock | 2.5382 | 2.5439 | 2.5368 | 2.5386 | 845460.0 |
| 2006-04-07 09:05:00 | AAPL | Stock | 2.5386 | 2.5411 | 2.5361 | 2.5375 | 469420.0 |
| 2006-04-07 09:10:00 | AAPL | Stock | 2.5375 | 2.5429 | 2.5357 | 2.5411 | 997472.0 |
| 2006-04-07 09:15:00 | AAPL | Stock | 2.5411 | 2.5421 | 2.5389 | 2.5393 | 398356.0 |
| 2006-04-07 09:20:00 | AAPL | Stock | 2.5393 | 2.5411 | 2.535 | 2.535 | 850808.0 |
| 2006-04-07 09:25:00 | AAPL | Stock | 2.5357 | 2.5425 | 2.5232 | 2.5332 | 7508984.0 |
| 2006-04-07 09:30:00 | AAPL | Stock | 2.5332 | 2.5432 | 2.5182 | 2.5186 | 56777980.0 |
| 2006-04-07 09:35:00 | AAPL | Stock | 2.5182 | 2.5321 | 2.5018 | 2.51 | 50168104.0 |
| 2006-04-07 09:40:00 | AAPL | Stock | 2.51 | 2.5139 | 2.4957 | 2.4986 | 47181484.0 |
| 2006-04-07 09:45:00 | AAPL | Stock | 2.4986 | 2.5086 | 2.4929 | 2.5 | 38917704.0 |
| 2006-04-07 09:50:00 | AAPL | Stock | 2.4993 | 2.5046 | 2.4936 | 2.5007 | 25957232.0 |
| 2006-04-07 09:55:00 | AAPL | Stock | 2.5007 | 2.5064 | 2.4914 | 2.495 | 26705028.0 |
| 2006-04-07 10:00:00 | AAPL | Stock | 2.4946 | 2.5054 | 2.4946 | 2.4982 | 23664592.0 |
| 2006-04-07 10:05:00 | AAPL | Stock | 2.4982 | 2.5139 | 2.4957 | 2.5111 | 25828180.0 |
| 2006-04-07 10:10:00 | AAPL | Stock | 2.5111 | 2.5136 | 2.5036 | 2.5082 | 20523188.0 |
| 2006-04-07 10:15:00 | AAPL | Stock | 2.5086 | 2.5118 | 2.4968 | 2.4975 | 19103896.0 |
| 2006-04-07 10:20:00 | AAPL | Stock | 2.4975 | 2.4989 | 2.4918 | 2.4943 | 20403544.0 |
| 2006-04-07 10:25:00 | AAPL | Stock | 2.4943 | 2.4957 | 2.4821 | 2.4832 | 25863684.0 |
| 2006-04-07 10:30:00 | AAPL | Stock | 2.4829 | 2.4857 | 2.4796 | 2.4839 | 24787812.0 |
| 2006-04-07 10:35:00 | AAPL | Stock | 2.4836 | 2.4907 | 2.4814 | 2.4839 | 17608948.0 |
| 2006-04-07 10:40:00 | AAPL | Stock | 2.4836 | 2.4857 | 2.4675 | 2.4693 | 36239840.0 |
| 2006-04-07 10:45:00 | AAPL | Stock | 2.4689 | 2.4711 | 2.46 | 2.4654 | 53343500.0 |
| 2006-04-07 10:50:00 | AAPL | Stock | 2.465 | 2.4714 | 2.4621 | 2.4675 | 19563908.0 |
| 2006-04-07 10:55:00 | AAPL | Stock | 2.4675 | 2.4746 | 2.4671 | 2.4707 | 20442100.0 |
| 2006-04-07 11:00:00 | AAPL | Stock | 2.4704 | 2.4704 | 2.4543 | 2.4557 | 30668120.0 |
| 2006-04-07 11:05:00 | AAPL | Stock | 2.4557 | 2.4657 | 2.4539 | 2.4632 | 23364880.0 |
| 2006-04-07 11:10:00 | AAPL | Stock | 2.4636 | 2.4745 | 2.4625 | 2.4643 | 12449556.0 |
| 2006-04-07 11:15:00 | AAPL | Stock | 2.4643 | 2.47 | 2.4607 | 2.4689 | 10594668.0 |
| 2006-04-07 11:20:00 | AAPL | Stock | 2.4689 | 2.4739 | 2.4643 | 2.4711 | 19535068.0 |
> showing 50 of 226,412 rows — these rows as CSV