PREVIEW / stock_5min / 2010-01-15
file: by_date/stock_5min/2010/2010-01-15.parquet size: 4.7 MB rows: 322,681 symbols: 3,439
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-01-15 06:30:00 | AAPL | Stock | 7.5086 | 7.5232 | 7.5086 | 7.5232 | 8400.0 |
| 2010-01-15 07:00:00 | AAPL | Stock | 7.4918 | 7.4918 | 7.4918 | 7.4918 | 2800.0 |
| 2010-01-15 07:05:00 | AAPL | Stock | 7.4879 | 7.4914 | 7.4839 | 7.4839 | 20804.0 |
| 2010-01-15 07:10:00 | AAPL | Stock | 7.4718 | 7.4718 | 7.4643 | 7.4643 | 61600.0 |
| 2010-01-15 07:20:00 | AAPL | Stock | 7.4643 | 7.4643 | 7.4643 | 7.4643 | 11200.0 |
| 2010-01-15 07:25:00 | AAPL | Stock | 7.4639 | 7.4643 | 7.4639 | 7.4643 | 78820.0 |
| 2010-01-15 07:50:00 | AAPL | Stock | 7.4732 | 7.4732 | 7.4732 | 7.4732 | 2800.0 |
| 2010-01-15 07:55:00 | AAPL | Stock | 7.4682 | 7.4682 | 7.4657 | 7.4657 | 11200.0 |
| 2010-01-15 08:00:00 | AAPL | Stock | 7.4761 | 7.4821 | 7.4721 | 7.4821 | 243432.0 |
| 2010-01-15 08:05:00 | AAPL | Stock | 7.5 | 7.5 | 7.4793 | 7.4946 | 233996.0 |
| 2010-01-15 08:10:00 | AAPL | Stock | 7.4971 | 7.4971 | 7.4889 | 7.4893 | 54824.0 |
| 2010-01-15 08:15:00 | AAPL | Stock | 7.4896 | 7.4925 | 7.4825 | 7.4825 | 40796.0 |
| 2010-01-15 08:25:00 | AAPL | Stock | 7.4921 | 7.4925 | 7.4921 | 7.4925 | 5600.0 |
| 2010-01-15 08:30:00 | AAPL | Stock | 7.4857 | 7.4911 | 7.4839 | 7.4911 | 21000.0 |
| 2010-01-15 08:35:00 | AAPL | Stock | 7.4911 | 7.4911 | 7.4875 | 7.4875 | 10640.0 |
| 2010-01-15 08:40:00 | AAPL | Stock | 7.4893 | 7.4904 | 7.4893 | 7.4904 | 24220.0 |
| 2010-01-15 08:45:00 | AAPL | Stock | 7.4861 | 7.4893 | 7.4821 | 7.4821 | 134400.0 |
| 2010-01-15 08:50:00 | AAPL | Stock | 7.4821 | 7.4857 | 7.4757 | 7.4857 | 88340.0 |
| 2010-01-15 08:55:00 | AAPL | Stock | 7.4821 | 7.4854 | 7.4821 | 7.4854 | 11200.0 |
| 2010-01-15 09:00:00 | AAPL | Stock | 7.4861 | 7.4882 | 7.4861 | 7.4875 | 22400.0 |
| 2010-01-15 09:05:00 | AAPL | Stock | 7.4843 | 7.4843 | 7.4843 | 7.4843 | 11200.0 |
| 2010-01-15 09:10:00 | AAPL | Stock | 7.4839 | 7.4886 | 7.4825 | 7.4843 | 31640.0 |
| 2010-01-15 09:15:00 | AAPL | Stock | 7.4886 | 7.4961 | 7.4886 | 7.4957 | 37800.0 |
| 2010-01-15 09:20:00 | AAPL | Stock | 7.4914 | 7.4954 | 7.4911 | 7.4954 | 37296.0 |
| 2010-01-15 09:25:00 | AAPL | Stock | 7.4957 | 7.5489 | 7.4957 | 7.5318 | 3332616.0 |
| 2010-01-15 09:30:00 | AAPL | Stock | 7.5329 | 7.5571 | 7.5 | 7.5236 | 28076748.0 |
| 2010-01-15 09:35:00 | AAPL | Stock | 7.5239 | 7.5261 | 7.5054 | 7.5096 | 13326740.0 |
| 2010-01-15 09:40:00 | AAPL | Stock | 7.5096 | 7.515 | 7.4811 | 7.4868 | 12571860.0 |
| 2010-01-15 09:45:00 | AAPL | Stock | 7.485 | 7.4943 | 7.4764 | 7.4827 | 12701416.0 |
| 2010-01-15 09:50:00 | AAPL | Stock | 7.485 | 7.5007 | 7.4832 | 7.4946 | 8000692.0 |
| 2010-01-15 09:55:00 | AAPL | Stock | 7.4946 | 7.5068 | 7.4821 | 7.4975 | 8252720.0 |
| 2010-01-15 10:00:00 | AAPL | Stock | 7.4999 | 7.5068 | 7.4786 | 7.4846 | 12971392.0 |
| 2010-01-15 10:05:00 | AAPL | Stock | 7.4846 | 7.4907 | 7.4643 | 7.4746 | 15437856.0 |
| 2010-01-15 10:10:00 | AAPL | Stock | 7.475 | 7.4868 | 7.4693 | 7.4736 | 9010904.0 |
| 2010-01-15 10:15:00 | AAPL | Stock | 7.4721 | 7.4736 | 7.4446 | 7.4543 | 16284772.0 |
| 2010-01-15 10:20:00 | AAPL | Stock | 7.4543 | 7.4636 | 7.4482 | 7.4575 | 8920884.0 |
| 2010-01-15 10:25:00 | AAPL | Stock | 7.4575 | 7.46 | 7.4421 | 7.4514 | 7461188.0 |
| 2010-01-15 10:30:00 | AAPL | Stock | 7.4507 | 7.4611 | 7.4421 | 7.4544 | 8068004.0 |
| 2010-01-15 10:35:00 | AAPL | Stock | 7.4529 | 7.4568 | 7.4375 | 7.4404 | 7722540.0 |
| 2010-01-15 10:40:00 | AAPL | Stock | 7.4404 | 7.4419 | 7.4139 | 7.4317 | 13281072.0 |
| 2010-01-15 10:45:00 | AAPL | Stock | 7.4317 | 7.4464 | 7.4211 | 7.4464 | 7734692.0 |
| 2010-01-15 10:50:00 | AAPL | Stock | 7.4446 | 7.4475 | 7.4354 | 7.4418 | 5197556.0 |
| 2010-01-15 10:55:00 | AAPL | Stock | 7.4425 | 7.4457 | 7.4375 | 7.4429 | 2904636.0 |
| 2010-01-15 11:00:00 | AAPL | Stock | 7.4432 | 7.4461 | 7.4329 | 7.4375 | 2748788.0 |
| 2010-01-15 11:05:00 | AAPL | Stock | 7.4382 | 7.4446 | 7.4329 | 7.4443 | 3406144.0 |
| 2010-01-15 11:10:00 | AAPL | Stock | 7.4446 | 7.4514 | 7.4404 | 7.4468 | 4092200.0 |
| 2010-01-15 11:15:00 | AAPL | Stock | 7.445 | 7.4486 | 7.4386 | 7.44 | 3252424.0 |
| 2010-01-15 11:20:00 | AAPL | Stock | 7.4411 | 7.4429 | 7.4336 | 7.4393 | 4583824.0 |
| 2010-01-15 11:25:00 | AAPL | Stock | 7.4393 | 7.4454 | 7.4389 | 7.4396 | 2030280.0 |
| 2010-01-15 11:30:00 | AAPL | Stock | 7.4396 | 7.4404 | 7.4354 | 7.4374 | 3298120.0 |
> showing 50 of 322,681 rows — these rows as CSV