PREVIEW / stock_5min / 2007-08-21
file: by_date/stock_5min/2007/2007-08-21.parquet size: 4.0 MB rows: 298,492 symbols: 3,117
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-08-21 09:30:00 | AAPL | Stock | 4.3646 | 4.3646 | 4.3214 | 4.3421 | 18490024.0 |
| 2007-08-21 09:35:00 | AAPL | Stock | 4.3425 | 4.3564 | 4.3364 | 4.3564 | 9079728.0 |
| 2007-08-21 09:40:00 | AAPL | Stock | 4.3564 | 4.3904 | 4.3529 | 4.3718 | 12951652.0 |
| 2007-08-21 09:45:00 | AAPL | Stock | 4.3718 | 4.3821 | 4.3514 | 4.3536 | 9523444.0 |
| 2007-08-21 09:50:00 | AAPL | Stock | 4.3536 | 4.3839 | 4.3536 | 4.3687 | 13107612.0 |
| 2007-08-21 09:55:00 | AAPL | Stock | 4.3689 | 4.4068 | 4.3679 | 4.3929 | 14931952.0 |
| 2007-08-21 10:00:00 | AAPL | Stock | 4.3929 | 4.3996 | 4.3796 | 4.3904 | 11745328.0 |
| 2007-08-21 10:05:00 | AAPL | Stock | 4.3893 | 4.3979 | 4.3811 | 4.3839 | 9977156.0 |
| 2007-08-21 10:10:00 | AAPL | Stock | 4.3839 | 4.3854 | 4.3654 | 4.3789 | 11631536.0 |
| 2007-08-21 10:15:00 | AAPL | Stock | 4.3793 | 4.3911 | 4.3771 | 4.3839 | 8503544.0 |
| 2007-08-21 10:20:00 | AAPL | Stock | 4.3843 | 4.4 | 4.3836 | 4.3879 | 11127760.0 |
| 2007-08-21 10:25:00 | AAPL | Stock | 4.3879 | 4.4214 | 4.3864 | 4.4125 | 14761544.0 |
| 2007-08-21 10:30:00 | AAPL | Stock | 4.4116 | 4.4518 | 4.4116 | 4.4475 | 32991224.0 |
| 2007-08-21 10:35:00 | AAPL | Stock | 4.4479 | 4.4932 | 4.4471 | 4.4929 | 55990256.0 |
| 2007-08-21 10:40:00 | AAPL | Stock | 4.4936 | 4.5139 | 4.4839 | 4.5104 | 47060776.0 |
| 2007-08-21 10:45:00 | AAPL | Stock | 4.5104 | 4.5246 | 4.4929 | 4.5154 | 34407856.0 |
| 2007-08-21 10:50:00 | AAPL | Stock | 4.5154 | 4.5389 | 4.5111 | 4.5325 | 34300308.0 |
| 2007-08-21 10:55:00 | AAPL | Stock | 4.5314 | 4.5582 | 4.5264 | 4.5386 | 43486268.0 |
| 2007-08-21 11:00:00 | AAPL | Stock | 4.5411 | 4.6 | 4.5386 | 4.5537 | 35052444.0 |
| 2007-08-21 11:05:00 | AAPL | Stock | 4.5546 | 4.5571 | 4.4736 | 4.5341 | 34583108.0 |
| 2007-08-21 11:10:00 | AAPL | Stock | 4.5336 | 4.5446 | 4.5221 | 4.5232 | 23141076.0 |
| 2007-08-21 11:15:00 | AAPL | Stock | 4.5246 | 4.5482 | 4.5132 | 4.5457 | 26441576.0 |
| 2007-08-21 11:20:00 | AAPL | Stock | 4.5454 | 4.5529 | 4.5304 | 4.5359 | 15425312.0 |
| 2007-08-21 11:25:00 | AAPL | Stock | 4.5359 | 4.5464 | 4.5304 | 4.5464 | 14151144.0 |
| 2007-08-21 11:30:00 | AAPL | Stock | 4.545 | 4.565 | 4.545 | 4.5629 | 24357732.0 |
| 2007-08-21 11:35:00 | AAPL | Stock | 4.5629 | 4.5714 | 4.5618 | 4.5679 | 17878056.0 |
| 2007-08-21 11:40:00 | AAPL | Stock | 4.5671 | 4.5857 | 4.5643 | 4.5846 | 22427748.0 |
| 2007-08-21 11:45:00 | AAPL | Stock | 4.5857 | 4.6057 | 4.5829 | 4.5907 | 31104780.0 |
| 2007-08-21 11:50:00 | AAPL | Stock | 4.5907 | 4.5918 | 4.5714 | 4.575 | 16943808.0 |
| 2007-08-21 11:55:00 | AAPL | Stock | 4.5757 | 4.5943 | 4.5729 | 4.5939 | 12524904.0 |
| 2007-08-21 12:00:00 | AAPL | Stock | 4.5939 | 4.5982 | 4.5836 | 4.5943 | 15646064.0 |
| 2007-08-21 12:05:00 | AAPL | Stock | 4.5943 | 4.5943 | 4.575 | 4.575 | 12311292.0 |
| 2007-08-21 12:10:00 | AAPL | Stock | 4.575 | 4.5918 | 4.5729 | 4.5843 | 12514768.0 |
| 2007-08-21 12:15:00 | AAPL | Stock | 4.5839 | 4.5857 | 4.5732 | 4.58 | 9267244.0 |
| 2007-08-21 12:20:00 | AAPL | Stock | 4.5807 | 4.5843 | 4.5643 | 4.5646 | 16457448.0 |
| 2007-08-21 12:25:00 | AAPL | Stock | 4.5646 | 4.5839 | 4.5493 | 4.5496 | 19423768.0 |
| 2007-08-21 12:30:00 | AAPL | Stock | 4.5496 | 4.5507 | 4.5339 | 4.54 | 23133768.0 |
| 2007-08-21 12:35:00 | AAPL | Stock | 4.5403 | 4.5482 | 4.5325 | 4.5357 | 13258392.0 |
| 2007-08-21 12:40:00 | AAPL | Stock | 4.535 | 4.5464 | 4.53 | 4.5393 | 11836104.0 |
| 2007-08-21 12:45:00 | AAPL | Stock | 4.5396 | 4.5475 | 4.5332 | 4.5391 | 11971344.0 |
| 2007-08-21 12:50:00 | AAPL | Stock | 4.5382 | 4.5589 | 4.5379 | 4.5486 | 12285308.0 |
| 2007-08-21 12:55:00 | AAPL | Stock | 4.5486 | 4.5589 | 4.5471 | 4.5554 | 8798440.0 |
| 2007-08-21 13:00:00 | AAPL | Stock | 4.555 | 4.5571 | 4.5461 | 4.5496 | 7235928.0 |
| 2007-08-21 13:05:00 | AAPL | Stock | 4.5489 | 4.5504 | 4.535 | 4.5425 | 7993552.0 |
| 2007-08-21 13:10:00 | AAPL | Stock | 4.5418 | 4.5423 | 4.5332 | 4.5386 | 5592608.0 |
| 2007-08-21 13:15:00 | AAPL | Stock | 4.5385 | 4.5655 | 4.5382 | 4.5607 | 11876284.0 |
| 2007-08-21 13:20:00 | AAPL | Stock | 4.5607 | 4.5696 | 4.5589 | 4.5621 | 9575188.0 |
| 2007-08-21 13:25:00 | AAPL | Stock | 4.5621 | 4.5714 | 4.5593 | 4.5686 | 10214988.0 |
| 2007-08-21 13:30:00 | AAPL | Stock | 4.5696 | 4.5732 | 4.5661 | 4.5682 | 7898380.0 |
| 2007-08-21 13:35:00 | AAPL | Stock | 4.5682 | 4.5814 | 4.5629 | 4.5654 | 9965088.0 |
> showing 50 of 298,492 rows — these rows as CSV