PREVIEW / stock_5min / 2007-01-17
file: by_date/stock_5min/2007/2007-01-17.parquet size: 3.3 MB rows: 242,693 symbols: 2,502
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-01-17 07:00:00 | AAPL | Stock | 3.4729 | 3.4779 | 3.4718 | 3.4718 | 16800.0 |
| 2007-01-17 07:05:00 | AAPL | Stock | 3.4714 | 3.4714 | 3.4714 | 3.4714 | 75600.0 |
| 2007-01-17 07:10:00 | AAPL | Stock | 3.4846 | 3.4846 | 3.4846 | 3.4846 | 14000.0 |
| 2007-01-17 07:20:00 | AAPL | Stock | 3.4807 | 3.4807 | 3.4807 | 3.4807 | 2800.0 |
| 2007-01-17 07:25:00 | AAPL | Stock | 3.4821 | 3.4839 | 3.4821 | 3.4839 | 11200.0 |
| 2007-01-17 07:30:00 | AAPL | Stock | 3.4839 | 3.4839 | 3.4804 | 3.4804 | 165200.0 |
| 2007-01-17 07:35:00 | AAPL | Stock | 3.48 | 3.4807 | 3.48 | 3.4807 | 246400.0 |
| 2007-01-17 07:40:00 | AAPL | Stock | 3.4807 | 3.4807 | 3.4807 | 3.4807 | 2800.0 |
| 2007-01-17 07:45:00 | AAPL | Stock | 3.4807 | 3.4836 | 3.4807 | 3.4821 | 215600.0 |
| 2007-01-17 07:50:00 | AAPL | Stock | 3.4821 | 3.4821 | 3.4814 | 3.4818 | 11200.0 |
| 2007-01-17 07:55:00 | AAPL | Stock | 3.4821 | 3.4821 | 3.4821 | 3.4821 | 47600.0 |
| 2007-01-17 08:00:00 | AAPL | Stock | 3.4811 | 3.4857 | 3.4775 | 3.4818 | 2047360.0 |
| 2007-01-17 08:05:00 | AAPL | Stock | 3.4818 | 3.4821 | 3.4786 | 3.4807 | 555212.0 |
| 2007-01-17 08:10:00 | AAPL | Stock | 3.4807 | 3.4904 | 3.4807 | 3.4893 | 909272.0 |
| 2007-01-17 08:15:00 | AAPL | Stock | 3.4886 | 3.4911 | 3.4871 | 3.4875 | 1379448.0 |
| 2007-01-17 08:20:00 | AAPL | Stock | 3.4875 | 3.4893 | 3.4829 | 3.4857 | 462252.0 |
| 2007-01-17 08:25:00 | AAPL | Stock | 3.4875 | 3.49 | 3.4836 | 3.4857 | 385084.0 |
| 2007-01-17 08:30:00 | AAPL | Stock | 3.4846 | 3.4846 | 3.4793 | 3.4821 | 1349908.0 |
| 2007-01-17 08:35:00 | AAPL | Stock | 3.4821 | 3.4864 | 3.4807 | 3.4864 | 453824.0 |
| 2007-01-17 08:40:00 | AAPL | Stock | 3.4875 | 3.4925 | 3.4875 | 3.4893 | 1509760.0 |
| 2007-01-17 08:45:00 | AAPL | Stock | 3.4907 | 3.4911 | 3.4821 | 3.4839 | 906528.0 |
| 2007-01-17 08:50:00 | AAPL | Stock | 3.4839 | 3.4843 | 3.4804 | 3.4821 | 827904.0 |
| 2007-01-17 08:55:00 | AAPL | Stock | 3.4821 | 3.4875 | 3.4818 | 3.4818 | 761908.0 |
| 2007-01-17 09:00:00 | AAPL | Stock | 3.4818 | 3.4839 | 3.4804 | 3.4818 | 548968.0 |
| 2007-01-17 09:05:00 | AAPL | Stock | 3.4807 | 3.4818 | 3.4789 | 3.4811 | 576492.0 |
| 2007-01-17 09:10:00 | AAPL | Stock | 3.4811 | 3.4814 | 3.4786 | 3.4786 | 677404.0 |
| 2007-01-17 09:15:00 | AAPL | Stock | 3.4786 | 3.4814 | 3.4786 | 3.4804 | 200116.0 |
| 2007-01-17 09:20:00 | AAPL | Stock | 3.4796 | 3.4846 | 3.4796 | 3.4843 | 765744.0 |
| 2007-01-17 09:25:00 | AAPL | Stock | 3.4839 | 3.4879 | 3.4839 | 3.4843 | 872536.0 |
| 2007-01-17 09:30:00 | AAPL | Stock | 3.4843 | 3.4857 | 3.4643 | 3.465 | 48643392.0 |
| 2007-01-17 09:35:00 | AAPL | Stock | 3.465 | 3.4746 | 3.4507 | 3.4511 | 35844704.0 |
| 2007-01-17 09:40:00 | AAPL | Stock | 3.4507 | 3.4525 | 3.4325 | 3.4461 | 39699688.0 |
| 2007-01-17 09:45:00 | AAPL | Stock | 3.4461 | 3.45 | 3.4371 | 3.4432 | 23471868.0 |
| 2007-01-17 09:50:00 | AAPL | Stock | 3.4439 | 3.4475 | 3.4379 | 3.4454 | 21165648.0 |
| 2007-01-17 09:55:00 | AAPL | Stock | 3.4457 | 3.4475 | 3.4071 | 3.4179 | 54566960.0 |
| 2007-01-17 10:00:00 | AAPL | Stock | 3.4182 | 3.4243 | 3.4125 | 3.4236 | 30282504.0 |
| 2007-01-17 10:05:00 | AAPL | Stock | 3.4232 | 3.4286 | 3.4125 | 3.4193 | 28720636.0 |
| 2007-01-17 10:10:00 | AAPL | Stock | 3.4193 | 3.4239 | 3.4114 | 3.4114 | 22619548.0 |
| 2007-01-17 10:15:00 | AAPL | Stock | 3.4114 | 3.4304 | 3.4114 | 3.4239 | 19774356.0 |
| 2007-01-17 10:20:00 | AAPL | Stock | 3.4239 | 3.4375 | 3.4218 | 3.4354 | 19499984.0 |
| 2007-01-17 10:25:00 | AAPL | Stock | 3.4357 | 3.4382 | 3.4254 | 3.4268 | 17910508.0 |
| 2007-01-17 10:30:00 | AAPL | Stock | 3.4271 | 3.4371 | 3.425 | 3.4368 | 13637176.0 |
| 2007-01-17 10:35:00 | AAPL | Stock | 3.4364 | 3.4425 | 3.4339 | 3.4407 | 15564864.0 |
| 2007-01-17 10:40:00 | AAPL | Stock | 3.4407 | 3.4464 | 3.44 | 3.4421 | 18114208.0 |
| 2007-01-17 10:45:00 | AAPL | Stock | 3.4418 | 3.4446 | 3.4343 | 3.44 | 11442620.0 |
| 2007-01-17 10:50:00 | AAPL | Stock | 3.4407 | 3.4439 | 3.4364 | 3.4414 | 10764768.0 |
| 2007-01-17 10:55:00 | AAPL | Stock | 3.4418 | 3.4436 | 3.4286 | 3.4307 | 19879888.0 |
| 2007-01-17 11:00:00 | AAPL | Stock | 3.4304 | 3.4325 | 3.4289 | 3.4321 | 10861088.0 |
| 2007-01-17 11:05:00 | AAPL | Stock | 3.4321 | 3.4336 | 3.4268 | 3.4296 | 25825884.0 |
| 2007-01-17 11:10:00 | AAPL | Stock | 3.4296 | 3.4343 | 3.4279 | 3.4335 | 8850408.0 |
> showing 50 of 242,693 rows — these rows as CSV