PREVIEW / stock_5min / 2008-10-07
file: by_date/stock_5min/2008/2008-10-07.parquet size: 4.7 MB rows: 330,116 symbols: 3,378
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-10-07 07:00:00 | AAPL | Stock | 3.5143 | 3.5143 | 3.5143 | 3.5143 | 2800.0 |
| 2008-10-07 07:05:00 | AAPL | Stock | 3.5143 | 3.5625 | 3.5143 | 3.5536 | 14000.0 |
| 2008-10-07 07:10:00 | AAPL | Stock | 3.5407 | 3.5407 | 3.5407 | 3.5407 | 4900.0 |
| 2008-10-07 07:15:00 | AAPL | Stock | 3.5196 | 3.5482 | 3.5196 | 3.5268 | 57540.0 |
| 2008-10-07 07:20:00 | AAPL | Stock | 3.5393 | 3.5464 | 3.5393 | 3.5464 | 15288.0 |
| 2008-10-07 07:25:00 | AAPL | Stock | 3.5421 | 3.5464 | 3.5393 | 3.5464 | 44800.0 |
| 2008-10-07 07:30:00 | AAPL | Stock | 3.5393 | 3.5496 | 3.5393 | 3.5496 | 128800.0 |
| 2008-10-07 07:35:00 | AAPL | Stock | 3.5429 | 3.5496 | 3.5429 | 3.5496 | 25200.0 |
| 2008-10-07 07:40:00 | AAPL | Stock | 3.5496 | 3.5496 | 3.5393 | 3.5393 | 8400.0 |
| 2008-10-07 07:45:00 | AAPL | Stock | 3.5232 | 3.5357 | 3.5232 | 3.5339 | 16800.0 |
| 2008-10-07 07:50:00 | AAPL | Stock | 3.5239 | 3.5239 | 3.5232 | 3.5232 | 14000.0 |
| 2008-10-07 07:55:00 | AAPL | Stock | 3.5304 | 3.5411 | 3.5304 | 3.5411 | 44800.0 |
| 2008-10-07 08:00:00 | AAPL | Stock | 3.5411 | 3.5411 | 3.5232 | 3.5232 | 377132.0 |
| 2008-10-07 08:05:00 | AAPL | Stock | 3.5232 | 3.535 | 3.5214 | 3.535 | 532140.0 |
| 2008-10-07 08:10:00 | AAPL | Stock | 3.535 | 3.535 | 3.5304 | 3.5318 | 392056.0 |
| 2008-10-07 08:15:00 | AAPL | Stock | 3.5346 | 3.535 | 3.4932 | 3.4932 | 1428616.0 |
| 2008-10-07 08:20:00 | AAPL | Stock | 3.4964 | 3.5036 | 3.4571 | 3.4704 | 581924.0 |
| 2008-10-07 08:25:00 | AAPL | Stock | 3.4696 | 3.4811 | 3.4589 | 3.4643 | 620816.0 |
| 2008-10-07 08:30:00 | AAPL | Stock | 3.4611 | 3.4886 | 3.4539 | 3.4886 | 353724.0 |
| 2008-10-07 08:35:00 | AAPL | Stock | 3.4871 | 3.4925 | 3.4736 | 3.4925 | 157108.0 |
| 2008-10-07 08:40:00 | AAPL | Stock | 3.4911 | 3.4925 | 3.4789 | 3.4821 | 97692.0 |
| 2008-10-07 08:45:00 | AAPL | Stock | 3.4821 | 3.4821 | 3.4554 | 3.4607 | 241668.0 |
| 2008-10-07 08:50:00 | AAPL | Stock | 3.4643 | 3.4643 | 3.425 | 3.4304 | 959112.0 |
| 2008-10-07 08:55:00 | AAPL | Stock | 3.4339 | 3.4429 | 3.4268 | 3.4343 | 1003660.0 |
| 2008-10-07 09:00:00 | AAPL | Stock | 3.4343 | 3.5346 | 3.4343 | 3.5196 | 3781148.0 |
| 2008-10-07 09:05:00 | AAPL | Stock | 3.5179 | 3.57 | 3.5164 | 3.5646 | 4606140.0 |
| 2008-10-07 09:10:00 | AAPL | Stock | 3.565 | 3.5832 | 3.5443 | 3.545 | 2296392.0 |
| 2008-10-07 09:15:00 | AAPL | Stock | 3.5446 | 3.5629 | 3.5357 | 3.5579 | 1649704.0 |
| 2008-10-07 09:20:00 | AAPL | Stock | 3.5586 | 3.5793 | 3.5575 | 3.5679 | 1163680.0 |
| 2008-10-07 09:25:00 | AAPL | Stock | 3.5679 | 3.5957 | 3.56 | 3.5871 | 2218748.0 |
| 2008-10-07 09:30:00 | AAPL | Stock | 3.5871 | 3.625 | 3.5357 | 3.5439 | 45924508.0 |
| 2008-10-07 09:35:00 | AAPL | Stock | 3.5443 | 3.5493 | 3.4914 | 3.5104 | 42295400.0 |
| 2008-10-07 09:40:00 | AAPL | Stock | 3.5086 | 3.5493 | 3.4668 | 3.4796 | 42373184.0 |
| 2008-10-07 09:45:00 | AAPL | Stock | 3.4796 | 3.4796 | 3.4196 | 3.455 | 38334828.0 |
| 2008-10-07 09:50:00 | AAPL | Stock | 3.4554 | 3.4571 | 3.3782 | 3.3886 | 31182088.0 |
| 2008-10-07 09:55:00 | AAPL | Stock | 3.3889 | 3.3975 | 3.3432 | 3.3654 | 47493348.0 |
| 2008-10-07 10:00:00 | AAPL | Stock | 3.3661 | 3.3929 | 3.3232 | 3.3643 | 42139020.0 |
| 2008-10-07 10:05:00 | AAPL | Stock | 3.3643 | 3.3918 | 3.3339 | 3.3875 | 31206700.0 |
| 2008-10-07 10:10:00 | AAPL | Stock | 3.3875 | 3.4132 | 3.3721 | 3.4061 | 32981620.0 |
| 2008-10-07 10:15:00 | AAPL | Stock | 3.4054 | 3.4607 | 3.3964 | 3.4375 | 42789712.0 |
| 2008-10-07 10:20:00 | AAPL | Stock | 3.4368 | 3.44 | 3.4043 | 3.4221 | 25676056.0 |
| 2008-10-07 10:25:00 | AAPL | Stock | 3.42 | 3.5 | 3.4186 | 3.4925 | 32801048.0 |
| 2008-10-07 10:30:00 | AAPL | Stock | 3.4932 | 3.5132 | 3.4732 | 3.4836 | 26934740.0 |
| 2008-10-07 10:35:00 | AAPL | Stock | 3.4839 | 3.4875 | 3.4654 | 3.4836 | 17988684.0 |
| 2008-10-07 10:40:00 | AAPL | Stock | 3.4839 | 3.4904 | 3.4289 | 3.4464 | 21542052.0 |
| 2008-10-07 10:45:00 | AAPL | Stock | 3.4464 | 3.4714 | 3.4429 | 3.4567 | 17607912.0 |
| 2008-10-07 10:50:00 | AAPL | Stock | 3.4561 | 3.457 | 3.4214 | 3.4411 | 17968356.0 |
| 2008-10-07 10:55:00 | AAPL | Stock | 3.4404 | 3.4429 | 3.4054 | 3.4214 | 18857160.0 |
| 2008-10-07 11:00:00 | AAPL | Stock | 3.4214 | 3.4321 | 3.4036 | 3.4121 | 15542884.0 |
| 2008-10-07 11:05:00 | AAPL | Stock | 3.4111 | 3.4168 | 3.3796 | 3.4011 | 18798052.0 |
> showing 50 of 330,116 rows — these rows as CSV