PREVIEW / stock_5min / 2008-04-07
file: by_date/stock_5min/2008/2008-04-07.parquet size: 4.4 MB rows: 318,856 symbols: 3,283
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-04-07 04:20:00 | AAPL | Stock | 5.5118 | 5.5118 | 5.5118 | 5.5118 | 2800.0 |
| 2008-04-07 04:35:00 | AAPL | Stock | 5.5039 | 5.5039 | 5.5039 | 5.5039 | 25200.0 |
| 2008-04-07 05:10:00 | AAPL | Stock | 5.5232 | 5.5279 | 5.5232 | 5.5279 | 5600.0 |
| 2008-04-07 05:15:00 | AAPL | Stock | 5.5354 | 5.5354 | 5.5354 | 5.5354 | 2800.0 |
| 2008-04-07 05:30:00 | AAPL | Stock | 5.5446 | 5.5511 | 5.5446 | 5.5511 | 36960.0 |
| 2008-04-07 06:35:00 | AAPL | Stock | 5.5536 | 5.5536 | 5.5536 | 5.5536 | 84000.0 |
| 2008-04-07 06:40:00 | AAPL | Stock | 5.5625 | 5.5679 | 5.5571 | 5.5571 | 100800.0 |
| 2008-04-07 06:45:00 | AAPL | Stock | 5.5679 | 5.5743 | 5.5679 | 5.5714 | 67200.0 |
| 2008-04-07 06:50:00 | AAPL | Stock | 5.5625 | 5.5625 | 5.5625 | 5.5625 | 28000.0 |
| 2008-04-07 06:55:00 | AAPL | Stock | 5.555 | 5.555 | 5.5536 | 5.5536 | 98000.0 |
| 2008-04-07 07:00:00 | AAPL | Stock | 5.5436 | 5.5536 | 5.5436 | 5.5536 | 53508.0 |
| 2008-04-07 07:05:00 | AAPL | Stock | 5.5439 | 5.5536 | 5.5439 | 5.5536 | 92792.0 |
| 2008-04-07 07:10:00 | AAPL | Stock | 5.5536 | 5.5536 | 5.5321 | 5.5321 | 33600.0 |
| 2008-04-07 07:15:00 | AAPL | Stock | 5.5529 | 5.5529 | 5.5521 | 5.5521 | 56000.0 |
| 2008-04-07 07:20:00 | AAPL | Stock | 5.5536 | 5.5536 | 5.5536 | 5.5536 | 2800.0 |
| 2008-04-07 07:25:00 | AAPL | Stock | 5.555 | 5.5568 | 5.555 | 5.5568 | 30100.0 |
| 2008-04-07 07:30:00 | AAPL | Stock | 5.5586 | 5.5586 | 5.5554 | 5.5571 | 19600.0 |
| 2008-04-07 07:35:00 | AAPL | Stock | 5.5571 | 5.5679 | 5.5571 | 5.5679 | 47488.0 |
| 2008-04-07 07:40:00 | AAPL | Stock | 5.5664 | 5.5664 | 5.5554 | 5.5554 | 56700.0 |
| 2008-04-07 07:45:00 | AAPL | Stock | 5.5554 | 5.5557 | 5.5357 | 5.5357 | 157444.0 |
| 2008-04-07 07:50:00 | AAPL | Stock | 5.5529 | 5.5536 | 5.5529 | 5.5536 | 66948.0 |
| 2008-04-07 07:55:00 | AAPL | Stock | 5.5575 | 5.56 | 5.5571 | 5.56 | 67676.0 |
| 2008-04-07 08:00:00 | AAPL | Stock | 5.5582 | 5.56 | 5.5407 | 5.5464 | 893536.0 |
| 2008-04-07 08:05:00 | AAPL | Stock | 5.5482 | 5.5546 | 5.5432 | 5.5536 | 351484.0 |
| 2008-04-07 08:10:00 | AAPL | Stock | 5.555 | 5.5714 | 5.555 | 5.5661 | 479640.0 |
| 2008-04-07 08:15:00 | AAPL | Stock | 5.5664 | 5.5664 | 5.5589 | 5.5596 | 343728.0 |
| 2008-04-07 08:20:00 | AAPL | Stock | 5.5621 | 5.5654 | 5.5607 | 5.5625 | 377272.0 |
| 2008-04-07 08:25:00 | AAPL | Stock | 5.5614 | 5.5639 | 5.5607 | 5.5639 | 106176.0 |
| 2008-04-07 08:30:00 | AAPL | Stock | 5.5643 | 5.5643 | 5.5629 | 5.5639 | 167720.0 |
| 2008-04-07 08:35:00 | AAPL | Stock | 5.5636 | 5.5675 | 5.5625 | 5.5625 | 285432.0 |
| 2008-04-07 08:40:00 | AAPL | Stock | 5.565 | 5.5679 | 5.565 | 5.5661 | 329588.0 |
| 2008-04-07 08:45:00 | AAPL | Stock | 5.5661 | 5.5661 | 5.55 | 5.5504 | 518308.0 |
| 2008-04-07 08:50:00 | AAPL | Stock | 5.5525 | 5.5625 | 5.5525 | 5.5604 | 397152.0 |
| 2008-04-07 08:55:00 | AAPL | Stock | 5.5621 | 5.5661 | 5.5607 | 5.5632 | 625604.0 |
| 2008-04-07 09:00:00 | AAPL | Stock | 5.5625 | 5.5643 | 5.5589 | 5.5625 | 353332.0 |
| 2008-04-07 09:05:00 | AAPL | Stock | 5.5636 | 5.5646 | 5.5586 | 5.56 | 359520.0 |
| 2008-04-07 09:10:00 | AAPL | Stock | 5.56 | 5.5625 | 5.5518 | 5.5529 | 415744.0 |
| 2008-04-07 09:15:00 | AAPL | Stock | 5.5525 | 5.5657 | 5.5518 | 5.5657 | 356972.0 |
| 2008-04-07 09:20:00 | AAPL | Stock | 5.5664 | 5.5664 | 5.5589 | 5.5625 | 626920.0 |
| 2008-04-07 09:25:00 | AAPL | Stock | 5.5625 | 5.5796 | 5.5596 | 5.5764 | 2050328.0 |
| 2008-04-07 09:30:00 | AAPL | Stock | 5.5761 | 5.5986 | 5.5657 | 5.5907 | 31409728.0 |
| 2008-04-07 09:35:00 | AAPL | Stock | 5.59 | 5.5921 | 5.5596 | 5.5714 | 24869544.0 |
| 2008-04-07 09:40:00 | AAPL | Stock | 5.5714 | 5.5807 | 5.5489 | 5.5739 | 26790932.0 |
| 2008-04-07 09:45:00 | AAPL | Stock | 5.5739 | 5.5896 | 5.5662 | 5.5857 | 23040948.0 |
| 2008-04-07 09:50:00 | AAPL | Stock | 5.5857 | 5.6054 | 5.5857 | 5.5946 | 21820232.0 |
| 2008-04-07 09:55:00 | AAPL | Stock | 5.5946 | 5.6 | 5.5714 | 5.5989 | 22996792.0 |
| 2008-04-07 10:00:00 | AAPL | Stock | 5.5996 | 5.6061 | 5.5893 | 5.5939 | 16762088.0 |
| 2008-04-07 10:05:00 | AAPL | Stock | 5.5939 | 5.6018 | 5.5814 | 5.5839 | 16544668.0 |
| 2008-04-07 10:10:00 | AAPL | Stock | 5.5843 | 5.5968 | 5.58 | 5.5918 | 19688536.0 |
| 2008-04-07 10:15:00 | AAPL | Stock | 5.5918 | 5.6004 | 5.5836 | 5.5982 | 14667520.0 |
> showing 50 of 318,856 rows — these rows as CSV