PREVIEW / stock_5min / 2010-12-22
file: by_date/stock_5min/2010/2010-12-22.parquet size: 4.8 MB rows: 331,923 symbols: 3,548
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-12-22 05:40:00 | AAPL | Stock | 11.5914 | 11.5914 | 11.5871 | 11.5871 | 8400.0 |
| 2010-12-22 05:45:00 | AAPL | Stock | 11.5843 | 11.5843 | 11.5843 | 11.5843 | 2800.0 |
| 2010-12-22 06:15:00 | AAPL | Stock | 11.5975 | 11.5975 | 11.5975 | 11.5975 | 2800.0 |
| 2010-12-22 07:00:00 | AAPL | Stock | 11.5929 | 11.5929 | 11.5929 | 11.5929 | 2800.0 |
| 2010-12-22 07:05:00 | AAPL | Stock | 11.5975 | 11.6143 | 11.5975 | 11.6143 | 32620.0 |
| 2010-12-22 07:15:00 | AAPL | Stock | 11.6132 | 11.6132 | 11.6132 | 11.6132 | 5040.0 |
| 2010-12-22 07:20:00 | AAPL | Stock | 11.6096 | 11.6096 | 11.6021 | 11.6096 | 11200.0 |
| 2010-12-22 07:30:00 | AAPL | Stock | 11.6029 | 11.6029 | 11.6021 | 11.6021 | 19236.0 |
| 2010-12-22 07:35:00 | AAPL | Stock | 11.5975 | 11.5975 | 11.5975 | 11.5975 | 16436.0 |
| 2010-12-22 07:40:00 | AAPL | Stock | 11.6071 | 11.6071 | 11.6071 | 11.6071 | 11200.0 |
| 2010-12-22 07:45:00 | AAPL | Stock | 11.6068 | 11.6068 | 11.6 | 11.6 | 16800.0 |
| 2010-12-22 07:50:00 | AAPL | Stock | 11.5968 | 11.6 | 11.5964 | 11.6 | 19600.0 |
| 2010-12-22 07:55:00 | AAPL | Stock | 11.6032 | 11.6032 | 11.6014 | 11.6014 | 5600.0 |
| 2010-12-22 08:00:00 | AAPL | Stock | 11.5964 | 11.5964 | 11.5846 | 11.5857 | 128128.0 |
| 2010-12-22 08:05:00 | AAPL | Stock | 11.5857 | 11.5968 | 11.5839 | 11.595 | 147560.0 |
| 2010-12-22 08:10:00 | AAPL | Stock | 11.5957 | 11.6036 | 11.5946 | 11.5982 | 373604.0 |
| 2010-12-22 08:15:00 | AAPL | Stock | 11.5989 | 11.5989 | 11.5714 | 11.5714 | 307272.0 |
| 2010-12-22 08:20:00 | AAPL | Stock | 11.58 | 11.5868 | 11.58 | 11.5868 | 8400.0 |
| 2010-12-22 08:25:00 | AAPL | Stock | 11.5825 | 11.5889 | 11.5825 | 11.5875 | 141820.0 |
| 2010-12-22 08:30:00 | AAPL | Stock | 11.5875 | 11.5879 | 11.5818 | 11.5875 | 151564.0 |
| 2010-12-22 08:35:00 | AAPL | Stock | 11.5882 | 11.5929 | 11.5821 | 11.5857 | 590968.0 |
| 2010-12-22 08:40:00 | AAPL | Stock | 11.5879 | 11.5889 | 11.5854 | 11.5875 | 94276.0 |
| 2010-12-22 08:45:00 | AAPL | Stock | 11.5875 | 11.5875 | 11.5736 | 11.575 | 668220.0 |
| 2010-12-22 08:50:00 | AAPL | Stock | 11.5754 | 11.5818 | 11.575 | 11.5789 | 84280.0 |
| 2010-12-22 08:55:00 | AAPL | Stock | 11.5789 | 11.5832 | 11.5768 | 11.5832 | 159348.0 |
| 2010-12-22 09:00:00 | AAPL | Stock | 11.5861 | 11.5929 | 11.5857 | 11.5868 | 136360.0 |
| 2010-12-22 09:05:00 | AAPL | Stock | 11.5868 | 11.5875 | 11.5839 | 11.5843 | 69580.0 |
| 2010-12-22 09:10:00 | AAPL | Stock | 11.5836 | 11.5839 | 11.5829 | 11.5829 | 30100.0 |
| 2010-12-22 09:15:00 | AAPL | Stock | 11.5846 | 11.5864 | 11.5839 | 11.5854 | 36400.0 |
| 2010-12-22 09:20:00 | AAPL | Stock | 11.5857 | 11.5857 | 11.5811 | 11.5811 | 64400.0 |
| 2010-12-22 09:25:00 | AAPL | Stock | 11.58 | 11.5857 | 11.5793 | 11.5846 | 461580.0 |
| 2010-12-22 09:30:00 | AAPL | Stock | 11.5854 | 11.5957 | 11.5739 | 11.5782 | 6187356.0 |
| 2010-12-22 09:35:00 | AAPL | Stock | 11.5804 | 11.6071 | 11.5775 | 11.6 | 13628440.0 |
| 2010-12-22 09:40:00 | AAPL | Stock | 11.6007 | 11.6018 | 11.5879 | 11.5929 | 6265812.0 |
| 2010-12-22 09:45:00 | AAPL | Stock | 11.5933 | 11.6018 | 11.5821 | 11.5821 | 5869864.0 |
| 2010-12-22 09:50:00 | AAPL | Stock | 11.5821 | 11.5893 | 11.5743 | 11.5875 | 4003076.0 |
| 2010-12-22 09:55:00 | AAPL | Stock | 11.5864 | 11.59 | 11.5836 | 11.5846 | 2248876.0 |
| 2010-12-22 10:00:00 | AAPL | Stock | 11.5839 | 11.5893 | 11.5757 | 11.5764 | 6767544.0 |
| 2010-12-22 10:05:00 | AAPL | Stock | 11.5757 | 11.5786 | 11.5554 | 11.5721 | 8545320.0 |
| 2010-12-22 10:10:00 | AAPL | Stock | 11.5725 | 11.5786 | 11.5675 | 11.5764 | 2782388.0 |
| 2010-12-22 10:15:00 | AAPL | Stock | 11.5764 | 11.5782 | 11.5714 | 11.5721 | 2105096.0 |
| 2010-12-22 10:20:00 | AAPL | Stock | 11.5732 | 11.5804 | 11.5689 | 11.5743 | 3136308.0 |
| 2010-12-22 10:25:00 | AAPL | Stock | 11.5746 | 11.58 | 11.5714 | 11.5729 | 2079476.0 |
| 2010-12-22 10:30:00 | AAPL | Stock | 11.5739 | 11.5761 | 11.57 | 11.5714 | 1638280.0 |
| 2010-12-22 10:35:00 | AAPL | Stock | 11.5732 | 11.5779 | 11.5704 | 11.5779 | 2226924.0 |
| 2010-12-22 10:40:00 | AAPL | Stock | 11.5761 | 11.5879 | 11.5761 | 11.5821 | 3867332.0 |
| 2010-12-22 10:45:00 | AAPL | Stock | 11.5836 | 11.5893 | 11.5804 | 11.5827 | 1957984.0 |
| 2010-12-22 10:50:00 | AAPL | Stock | 11.5829 | 11.5939 | 11.5829 | 11.5893 | 2917068.0 |
| 2010-12-22 10:55:00 | AAPL | Stock | 11.5893 | 11.5982 | 11.5864 | 11.5979 | 2627464.0 |
| 2010-12-22 11:00:00 | AAPL | Stock | 11.5975 | 11.6054 | 11.5932 | 11.6054 | 4907812.0 |
> showing 50 of 331,923 rows — these rows as CSV