PREVIEW / stock_5min / 2009-06-02
file: by_date/stock_5min/2009/2009-06-02.parquet size: 4.9 MB rows: 335,638 symbols: 3,337
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 |
|---|---|---|---|---|---|---|---|
| 2009-06-02 08:00:00 | AAPL | Stock | 4.9818 | 4.9821 | 4.975 | 4.9818 | 37576.0 |
| 2009-06-02 08:05:00 | AAPL | Stock | 4.9804 | 4.9811 | 4.9696 | 4.9736 | 46536.0 |
| 2009-06-02 08:10:00 | AAPL | Stock | 4.9696 | 4.9721 | 4.9643 | 4.9693 | 67004.0 |
| 2009-06-02 08:15:00 | AAPL | Stock | 4.9639 | 4.9639 | 4.9557 | 4.9607 | 14000.0 |
| 2009-06-02 08:20:00 | AAPL | Stock | 4.9639 | 4.9764 | 4.9589 | 4.9714 | 104300.0 |
| 2009-06-02 08:25:00 | AAPL | Stock | 4.9625 | 4.9679 | 4.9582 | 4.9646 | 25200.0 |
| 2009-06-02 08:30:00 | AAPL | Stock | 4.9646 | 4.9646 | 4.9571 | 4.9571 | 54152.0 |
| 2009-06-02 08:35:00 | AAPL | Stock | 4.9554 | 4.9632 | 4.9532 | 4.9632 | 132524.0 |
| 2009-06-02 08:40:00 | AAPL | Stock | 4.9525 | 4.96 | 4.9525 | 4.9546 | 30520.0 |
| 2009-06-02 08:45:00 | AAPL | Stock | 4.9536 | 4.9575 | 4.9464 | 4.9575 | 47600.0 |
| 2009-06-02 08:50:00 | AAPL | Stock | 4.9593 | 4.9593 | 4.95 | 4.9514 | 58100.0 |
| 2009-06-02 08:55:00 | AAPL | Stock | 4.9568 | 4.9607 | 4.9521 | 4.9607 | 13048.0 |
| 2009-06-02 09:00:00 | AAPL | Stock | 4.9557 | 4.9557 | 4.9557 | 4.9557 | 8400.0 |
| 2009-06-02 09:05:00 | AAPL | Stock | 4.9561 | 4.9561 | 4.9507 | 4.9507 | 48020.0 |
| 2009-06-02 09:10:00 | AAPL | Stock | 4.9561 | 4.9561 | 4.9561 | 4.9561 | 8400.0 |
| 2009-06-02 09:15:00 | AAPL | Stock | 4.9536 | 4.9554 | 4.9532 | 4.9536 | 44800.0 |
| 2009-06-02 09:20:00 | AAPL | Stock | 4.9532 | 4.9532 | 4.9532 | 4.9532 | 21000.0 |
| 2009-06-02 09:25:00 | AAPL | Stock | 4.9554 | 4.9596 | 4.9536 | 4.9571 | 306460.0 |
| 2009-06-02 09:30:00 | AAPL | Stock | 4.9539 | 4.9643 | 4.9411 | 4.9475 | 11193588.0 |
| 2009-06-02 09:35:00 | AAPL | Stock | 4.9475 | 4.9907 | 4.9475 | 4.9879 | 11167884.0 |
| 2009-06-02 09:40:00 | AAPL | Stock | 4.9875 | 4.9979 | 4.9789 | 4.9936 | 11253816.0 |
| 2009-06-02 09:45:00 | AAPL | Stock | 4.9923 | 4.9975 | 4.9846 | 4.9929 | 8225896.0 |
| 2009-06-02 09:50:00 | AAPL | Stock | 4.9929 | 5.0164 | 4.9886 | 5.0164 | 14413588.0 |
| 2009-06-02 09:55:00 | AAPL | Stock | 5.0161 | 5.0293 | 5.0118 | 5.0218 | 13188756.0 |
| 2009-06-02 10:00:00 | AAPL | Stock | 5.0246 | 5.0479 | 5.0221 | 5.0357 | 22325828.0 |
| 2009-06-02 10:05:00 | AAPL | Stock | 5.0361 | 5.0404 | 5.0236 | 5.0331 | 9365720.0 |
| 2009-06-02 10:10:00 | AAPL | Stock | 5.0329 | 5.0329 | 5.0136 | 5.0186 | 8498812.0 |
| 2009-06-02 10:15:00 | AAPL | Stock | 5.0186 | 5.0286 | 5.0182 | 5.0257 | 6491128.0 |
| 2009-06-02 10:20:00 | AAPL | Stock | 5.0257 | 5.0279 | 5.0136 | 5.0139 | 8116584.0 |
| 2009-06-02 10:25:00 | AAPL | Stock | 5.0139 | 5.0225 | 5.0043 | 5.0194 | 7879396.0 |
| 2009-06-02 10:30:00 | AAPL | Stock | 5.0196 | 5.0225 | 5.0109 | 5.0125 | 4035556.0 |
| 2009-06-02 10:35:00 | AAPL | Stock | 5.0132 | 5.0246 | 5.0118 | 5.0186 | 3604076.0 |
| 2009-06-02 10:40:00 | AAPL | Stock | 5.0196 | 5.0246 | 5.0107 | 5.0204 | 5132932.0 |
| 2009-06-02 10:45:00 | AAPL | Stock | 5.0206 | 5.0206 | 5.0007 | 5.0039 | 6303024.0 |
| 2009-06-02 10:50:00 | AAPL | Stock | 5.0039 | 5.01 | 4.9832 | 4.9846 | 8429876.0 |
| 2009-06-02 10:55:00 | AAPL | Stock | 4.9846 | 4.9939 | 4.9811 | 4.9861 | 6447924.0 |
| 2009-06-02 11:00:00 | AAPL | Stock | 4.9861 | 4.9918 | 4.975 | 4.9825 | 7398776.0 |
| 2009-06-02 11:05:00 | AAPL | Stock | 4.9827 | 4.99 | 4.9804 | 4.9843 | 3214568.0 |
| 2009-06-02 11:10:00 | AAPL | Stock | 4.9846 | 4.9954 | 4.9811 | 4.9852 | 4504052.0 |
| 2009-06-02 11:15:00 | AAPL | Stock | 4.9852 | 4.9929 | 4.9814 | 4.9914 | 3577812.0 |
| 2009-06-02 11:20:00 | AAPL | Stock | 4.9916 | 5.0057 | 4.9893 | 5.004 | 4004504.0 |
| 2009-06-02 11:25:00 | AAPL | Stock | 5.0039 | 5.0061 | 5.0 | 5.0 | 3772328.0 |
| 2009-06-02 11:30:00 | AAPL | Stock | 5.0 | 5.0014 | 4.9796 | 4.9832 | 5261844.0 |
| 2009-06-02 11:35:00 | AAPL | Stock | 4.9829 | 4.9836 | 4.9771 | 4.9786 | 3680320.0 |
| 2009-06-02 11:40:00 | AAPL | Stock | 4.9782 | 4.9807 | 4.9671 | 4.9711 | 6765444.0 |
| 2009-06-02 11:45:00 | AAPL | Stock | 4.9707 | 4.9718 | 4.9621 | 4.9636 | 4464264.0 |
| 2009-06-02 11:50:00 | AAPL | Stock | 4.9632 | 4.9771 | 4.9621 | 4.9757 | 4334736.0 |
| 2009-06-02 11:55:00 | AAPL | Stock | 4.9761 | 4.9818 | 4.9754 | 4.9775 | 4403896.0 |
| 2009-06-02 12:00:00 | AAPL | Stock | 4.977 | 4.9814 | 4.9704 | 4.9704 | 5113612.0 |
| 2009-06-02 12:05:00 | AAPL | Stock | 4.9711 | 4.9743 | 4.9618 | 4.9693 | 5070800.0 |
> showing 50 of 335,638 rows — these rows as CSV