PREVIEW / stock_5min / 2010-03-22
file: by_date/stock_5min/2010/2010-03-22.parquet size: 4.9 MB rows: 330,726 symbols: 3,490
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-03-22 04:15:00 | AAPL | Stock | 7.9 | 7.9 | 7.9 | 7.9 | 5600.0 |
| 2010-03-22 04:35:00 | AAPL | Stock | 7.8961 | 7.8961 | 7.8961 | 7.8961 | 7000.0 |
| 2010-03-22 05:40:00 | AAPL | Stock | 7.8982 | 7.9064 | 7.8982 | 7.9064 | 26600.0 |
| 2010-03-22 06:15:00 | AAPL | Stock | 7.8982 | 7.8982 | 7.8982 | 7.8982 | 2800.0 |
| 2010-03-22 06:20:00 | AAPL | Stock | 7.9036 | 7.9036 | 7.9036 | 7.9036 | 9912.0 |
| 2010-03-22 06:55:00 | AAPL | Stock | 7.9107 | 7.9107 | 7.9107 | 7.9107 | 2828.0 |
| 2010-03-22 07:00:00 | AAPL | Stock | 7.8982 | 7.8982 | 7.8982 | 7.8982 | 2800.0 |
| 2010-03-22 07:05:00 | AAPL | Stock | 7.9036 | 7.9036 | 7.9036 | 7.9036 | 3640.0 |
| 2010-03-22 07:10:00 | AAPL | Stock | 7.9036 | 7.9089 | 7.9036 | 7.9089 | 5600.0 |
| 2010-03-22 07:15:00 | AAPL | Stock | 7.9089 | 7.9089 | 7.9089 | 7.9089 | 2800.0 |
| 2010-03-22 07:20:00 | AAPL | Stock | 7.9064 | 7.9064 | 7.9064 | 7.9064 | 2800.0 |
| 2010-03-22 07:25:00 | AAPL | Stock | 7.9089 | 7.9089 | 7.9089 | 7.9089 | 7000.0 |
| 2010-03-22 07:30:00 | AAPL | Stock | 7.9064 | 7.9064 | 7.8929 | 7.8982 | 30240.0 |
| 2010-03-22 07:35:00 | AAPL | Stock | 7.8968 | 7.8971 | 7.8968 | 7.8971 | 11200.0 |
| 2010-03-22 07:45:00 | AAPL | Stock | 7.8964 | 7.8964 | 7.8964 | 7.8964 | 11200.0 |
| 2010-03-22 07:50:00 | AAPL | Stock | 7.8893 | 7.8893 | 7.8861 | 7.8861 | 33740.0 |
| 2010-03-22 07:55:00 | AAPL | Stock | 7.8839 | 7.8911 | 7.8775 | 7.8832 | 52892.0 |
| 2010-03-22 08:00:00 | AAPL | Stock | 7.8775 | 7.8929 | 7.875 | 7.8754 | 167524.0 |
| 2010-03-22 08:05:00 | AAPL | Stock | 7.8764 | 7.8768 | 7.8679 | 7.8679 | 177604.0 |
| 2010-03-22 08:10:00 | AAPL | Stock | 7.8682 | 7.8743 | 7.8643 | 7.8696 | 417396.0 |
| 2010-03-22 08:15:00 | AAPL | Stock | 7.8718 | 7.8782 | 7.8714 | 7.8768 | 197456.0 |
| 2010-03-22 08:20:00 | AAPL | Stock | 7.8779 | 7.8786 | 7.8736 | 7.875 | 102844.0 |
| 2010-03-22 08:25:00 | AAPL | Stock | 7.8732 | 7.8804 | 7.8704 | 7.8732 | 230132.0 |
| 2010-03-22 08:30:00 | AAPL | Stock | 7.8729 | 7.8796 | 7.8729 | 7.8754 | 101892.0 |
| 2010-03-22 08:35:00 | AAPL | Stock | 7.8754 | 7.8757 | 7.8739 | 7.875 | 73584.0 |
| 2010-03-22 08:40:00 | AAPL | Stock | 7.8739 | 7.8793 | 7.8736 | 7.875 | 101668.0 |
| 2010-03-22 08:45:00 | AAPL | Stock | 7.875 | 7.8814 | 7.875 | 7.875 | 158200.0 |
| 2010-03-22 08:50:00 | AAPL | Stock | 7.88 | 7.8907 | 7.88 | 7.8889 | 218652.0 |
| 2010-03-22 08:55:00 | AAPL | Stock | 7.8889 | 7.8946 | 7.8861 | 7.8864 | 355460.0 |
| 2010-03-22 09:00:00 | AAPL | Stock | 7.8857 | 7.8861 | 7.8718 | 7.8718 | 295652.0 |
| 2010-03-22 09:05:00 | AAPL | Stock | 7.8721 | 7.8925 | 7.8721 | 7.8893 | 266588.0 |
| 2010-03-22 09:10:00 | AAPL | Stock | 7.8846 | 7.8875 | 7.8796 | 7.8857 | 51240.0 |
| 2010-03-22 09:15:00 | AAPL | Stock | 7.8875 | 7.8886 | 7.8839 | 7.8839 | 14000.0 |
| 2010-03-22 09:20:00 | AAPL | Stock | 7.8836 | 7.8836 | 7.8571 | 7.875 | 492548.0 |
| 2010-03-22 09:25:00 | AAPL | Stock | 7.8754 | 7.8754 | 7.8711 | 7.8739 | 185472.0 |
| 2010-03-22 09:30:00 | AAPL | Stock | 7.8739 | 7.9096 | 7.8625 | 7.9043 | 14283192.0 |
| 2010-03-22 09:35:00 | AAPL | Stock | 7.9039 | 7.9382 | 7.8982 | 7.9361 | 11434556.0 |
| 2010-03-22 09:40:00 | AAPL | Stock | 7.9343 | 7.9696 | 7.925 | 7.9682 | 16120832.0 |
| 2010-03-22 09:45:00 | AAPL | Stock | 7.9675 | 7.9982 | 7.9675 | 7.9861 | 20478332.0 |
| 2010-03-22 09:50:00 | AAPL | Stock | 7.985 | 7.9946 | 7.9721 | 7.9914 | 11748716.0 |
| 2010-03-22 09:55:00 | AAPL | Stock | 7.9904 | 8.0 | 7.98 | 7.9814 | 12907076.0 |
| 2010-03-22 10:00:00 | AAPL | Stock | 7.9814 | 7.9925 | 7.9761 | 7.9836 | 9154908.0 |
| 2010-03-22 10:05:00 | AAPL | Stock | 7.9829 | 7.9836 | 7.9618 | 7.9625 | 9842672.0 |
| 2010-03-22 10:10:00 | AAPL | Stock | 7.9621 | 7.9804 | 7.9614 | 7.9754 | 7742056.0 |
| 2010-03-22 10:15:00 | AAPL | Stock | 7.9746 | 7.9779 | 7.9711 | 7.9768 | 4642372.0 |
| 2010-03-22 10:20:00 | AAPL | Stock | 7.9779 | 7.9839 | 7.9654 | 7.9739 | 9455768.0 |
| 2010-03-22 10:25:00 | AAPL | Stock | 7.9732 | 8.0643 | 7.9732 | 7.9857 | 11139380.0 |
| 2010-03-22 10:30:00 | AAPL | Stock | 7.9857 | 7.9982 | 7.9821 | 7.9893 | 6625416.0 |
| 2010-03-22 10:35:00 | AAPL | Stock | 7.9886 | 7.9982 | 7.9825 | 7.9979 | 4192440.0 |
| 2010-03-22 10:40:00 | AAPL | Stock | 7.998 | 8.0161 | 7.9979 | 8.0039 | 12222644.0 |
> showing 50 of 330,726 rows — these rows as CSV