PREVIEW / stock_5min / 2010-05-10
file: by_date/stock_5min/2010/2010-05-10.parquet size: 5.2 MB rows: 353,963 symbols: 3,504
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-05-10 04:10:00 | AAPL | Stock | 9.1071 | 9.1071 | 9.1071 | 9.1071 | 2800.0 |
| 2010-05-10 04:15:00 | AAPL | Stock | 9.0 | 9.1071 | 8.9696 | 9.1071 | 92848.0 |
| 2010-05-10 04:20:00 | AAPL | Stock | 9.1071 | 9.1429 | 9.1071 | 9.1429 | 64764.0 |
| 2010-05-10 04:25:00 | AAPL | Stock | 9.0961 | 9.0961 | 9.0889 | 9.0889 | 5600.0 |
| 2010-05-10 04:30:00 | AAPL | Stock | 9.125 | 9.125 | 9.125 | 9.125 | 2800.0 |
| 2010-05-10 04:35:00 | AAPL | Stock | 9.0786 | 9.0786 | 9.0375 | 9.0375 | 28336.0 |
| 2010-05-10 04:40:00 | AAPL | Stock | 9.0571 | 9.0571 | 9.0036 | 9.0429 | 103600.0 |
| 2010-05-10 04:45:00 | AAPL | Stock | 9.0286 | 9.0521 | 9.0071 | 9.0521 | 37856.0 |
| 2010-05-10 05:00:00 | AAPL | Stock | 9.0521 | 9.0521 | 9.0521 | 9.0521 | 8400.0 |
| 2010-05-10 05:05:00 | AAPL | Stock | 9.0196 | 9.0357 | 9.0196 | 9.0357 | 17500.0 |
| 2010-05-10 05:10:00 | AAPL | Stock | 9.0029 | 9.0029 | 8.9893 | 8.9893 | 135800.0 |
| 2010-05-10 05:30:00 | AAPL | Stock | 9.0204 | 9.0268 | 9.0204 | 9.0268 | 8400.0 |
| 2010-05-10 05:35:00 | AAPL | Stock | 9.0279 | 9.0307 | 8.995 | 9.0307 | 52220.0 |
| 2010-05-10 05:40:00 | AAPL | Stock | 8.9954 | 9.0 | 8.9643 | 8.9643 | 108276.0 |
| 2010-05-10 05:45:00 | AAPL | Stock | 8.9771 | 8.9771 | 8.9771 | 8.9771 | 12600.0 |
| 2010-05-10 05:50:00 | AAPL | Stock | 8.9475 | 8.9475 | 8.9475 | 8.9475 | 13300.0 |
| 2010-05-10 05:55:00 | AAPL | Stock | 8.9707 | 9.0 | 8.9643 | 9.0 | 29120.0 |
| 2010-05-10 06:00:00 | AAPL | Stock | 9.0 | 9.0 | 8.9643 | 8.9929 | 18116.0 |
| 2010-05-10 06:05:00 | AAPL | Stock | 8.9893 | 8.9893 | 8.9689 | 8.9689 | 26880.0 |
| 2010-05-10 06:10:00 | AAPL | Stock | 8.9686 | 9.0 | 8.9686 | 8.9918 | 57148.0 |
| 2010-05-10 06:15:00 | AAPL | Stock | 8.9957 | 8.9996 | 8.9957 | 8.9982 | 40768.0 |
| 2010-05-10 06:20:00 | AAPL | Stock | 8.9975 | 8.9979 | 8.9789 | 8.9789 | 19600.0 |
| 2010-05-10 06:25:00 | AAPL | Stock | 8.9821 | 9.0029 | 8.9821 | 8.9911 | 30324.0 |
| 2010-05-10 06:30:00 | AAPL | Stock | 8.9911 | 8.9911 | 8.9911 | 8.9911 | 12376.0 |
| 2010-05-10 06:35:00 | AAPL | Stock | 8.9846 | 8.9911 | 8.9846 | 8.9911 | 22400.0 |
| 2010-05-10 06:40:00 | AAPL | Stock | 8.9821 | 8.9911 | 8.9821 | 8.9911 | 47600.0 |
| 2010-05-10 06:45:00 | AAPL | Stock | 8.9821 | 8.9911 | 8.9821 | 8.9893 | 19600.0 |
| 2010-05-10 06:50:00 | AAPL | Stock | 8.9911 | 8.9911 | 8.9714 | 8.9714 | 58828.0 |
| 2010-05-10 06:55:00 | AAPL | Stock | 8.9679 | 8.9786 | 8.9643 | 8.975 | 57344.0 |
| 2010-05-10 07:00:00 | AAPL | Stock | 8.9643 | 8.9896 | 8.9443 | 8.9643 | 701288.0 |
| 2010-05-10 07:05:00 | AAPL | Stock | 8.9714 | 9.0 | 8.9693 | 8.9961 | 510664.0 |
| 2010-05-10 07:10:00 | AAPL | Stock | 9.0 | 9.0071 | 8.9893 | 8.9929 | 357812.0 |
| 2010-05-10 07:15:00 | AAPL | Stock | 8.9843 | 8.9857 | 8.9786 | 8.9821 | 137368.0 |
| 2010-05-10 07:20:00 | AAPL | Stock | 8.9893 | 8.9921 | 8.9786 | 8.9921 | 451388.0 |
| 2010-05-10 07:25:00 | AAPL | Stock | 8.9893 | 9.0089 | 8.985 | 9.0089 | 231308.0 |
| 2010-05-10 07:30:00 | AAPL | Stock | 9.0086 | 9.0218 | 8.9857 | 9.0 | 499352.0 |
| 2010-05-10 07:35:00 | AAPL | Stock | 8.9846 | 8.9921 | 8.9607 | 8.9668 | 405748.0 |
| 2010-05-10 07:40:00 | AAPL | Stock | 8.9664 | 8.9775 | 8.9582 | 8.9625 | 162120.0 |
| 2010-05-10 07:45:00 | AAPL | Stock | 8.9625 | 8.9625 | 8.9286 | 8.9286 | 597912.0 |
| 2010-05-10 07:50:00 | AAPL | Stock | 8.9286 | 8.9286 | 8.8864 | 8.8904 | 373604.0 |
| 2010-05-10 07:55:00 | AAPL | Stock | 8.8925 | 8.9039 | 8.875 | 8.8907 | 884772.0 |
| 2010-05-10 08:00:00 | AAPL | Stock | 8.8893 | 8.9275 | 8.8686 | 8.8929 | 2359672.0 |
| 2010-05-10 08:05:00 | AAPL | Stock | 8.8925 | 8.8964 | 8.87 | 8.8829 | 973840.0 |
| 2010-05-10 08:10:00 | AAPL | Stock | 8.8829 | 8.8929 | 8.8482 | 8.8664 | 1034124.0 |
| 2010-05-10 08:15:00 | AAPL | Stock | 8.8661 | 8.9168 | 8.8571 | 8.9129 | 1339156.0 |
| 2010-05-10 08:20:00 | AAPL | Stock | 8.9164 | 8.9243 | 8.8875 | 8.8979 | 1421560.0 |
| 2010-05-10 08:25:00 | AAPL | Stock | 8.8964 | 8.9 | 8.87 | 8.8929 | 1357720.0 |
| 2010-05-10 08:30:00 | AAPL | Stock | 8.8937 | 8.9021 | 8.8821 | 8.8982 | 828856.0 |
| 2010-05-10 08:35:00 | AAPL | Stock | 8.898 | 8.9029 | 8.8821 | 8.8889 | 826196.0 |
| 2010-05-10 08:40:00 | AAPL | Stock | 8.8921 | 8.8921 | 8.8839 | 8.8896 | 672224.0 |
> showing 50 of 353,963 rows — these rows as CSV