PREVIEW / stock_5min / 2010-02-10
file: by_date/stock_5min/2010/2010-02-10.parquet size: 4.5 MB rows: 310,790 symbols: 3,408
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-02-10 05:05:00 | AAPL | Stock | 7.0161 | 7.0161 | 7.0161 | 7.0161 | 4004.0 |
| 2010-02-10 05:40:00 | AAPL | Stock | 7.0318 | 7.0318 | 7.0318 | 7.0318 | 2800.0 |
| 2010-02-10 05:45:00 | AAPL | Stock | 7.0318 | 7.0318 | 7.0318 | 7.0318 | 11200.0 |
| 2010-02-10 05:55:00 | AAPL | Stock | 7.0339 | 7.0339 | 7.0339 | 7.0339 | 3584.0 |
| 2010-02-10 06:45:00 | AAPL | Stock | 7.0393 | 7.0393 | 7.0393 | 7.0393 | 28000.0 |
| 2010-02-10 07:00:00 | AAPL | Stock | 7.02 | 7.02 | 7.02 | 7.02 | 2800.0 |
| 2010-02-10 07:15:00 | AAPL | Stock | 7.0179 | 7.0179 | 7.0179 | 7.0179 | 5600.0 |
| 2010-02-10 07:30:00 | AAPL | Stock | 7.0421 | 7.0421 | 7.0304 | 7.0304 | 38360.0 |
| 2010-02-10 07:35:00 | AAPL | Stock | 7.0361 | 7.0429 | 7.0361 | 7.0429 | 11200.0 |
| 2010-02-10 07:40:00 | AAPL | Stock | 7.0443 | 7.0514 | 7.0443 | 7.0514 | 30800.0 |
| 2010-02-10 07:45:00 | AAPL | Stock | 7.0514 | 7.0514 | 7.0429 | 7.0429 | 16800.0 |
| 2010-02-10 07:50:00 | AAPL | Stock | 7.0386 | 7.0446 | 7.0386 | 7.0446 | 6552.0 |
| 2010-02-10 07:55:00 | AAPL | Stock | 7.04 | 7.04 | 7.0339 | 7.0339 | 84504.0 |
| 2010-02-10 08:00:00 | AAPL | Stock | 7.0271 | 7.0271 | 7.0182 | 7.025 | 155540.0 |
| 2010-02-10 08:05:00 | AAPL | Stock | 7.0221 | 7.025 | 7.0125 | 7.0179 | 381360.0 |
| 2010-02-10 08:10:00 | AAPL | Stock | 7.0175 | 7.0175 | 7.0018 | 7.0043 | 172760.0 |
| 2010-02-10 08:15:00 | AAPL | Stock | 7.0018 | 7.0086 | 6.9968 | 7.0018 | 221200.0 |
| 2010-02-10 08:20:00 | AAPL | Stock | 7.0018 | 7.0075 | 7.0007 | 7.0075 | 54404.0 |
| 2010-02-10 08:25:00 | AAPL | Stock | 7.0104 | 7.0164 | 7.0104 | 7.0139 | 174384.0 |
| 2010-02-10 08:30:00 | AAPL | Stock | 7.0164 | 7.0193 | 7.0043 | 7.0043 | 157528.0 |
| 2010-02-10 08:35:00 | AAPL | Stock | 7.005 | 7.005 | 7.005 | 7.005 | 5600.0 |
| 2010-02-10 08:40:00 | AAPL | Stock | 7.0068 | 7.0089 | 7.0057 | 7.0057 | 22400.0 |
| 2010-02-10 08:45:00 | AAPL | Stock | 7.0061 | 7.0071 | 7.0039 | 7.005 | 30800.0 |
| 2010-02-10 08:50:00 | AAPL | Stock | 7.0064 | 7.0107 | 7.0064 | 7.0107 | 52192.0 |
| 2010-02-10 08:55:00 | AAPL | Stock | 7.0096 | 7.0118 | 7.0096 | 7.0118 | 14000.0 |
| 2010-02-10 09:00:00 | AAPL | Stock | 7.0079 | 7.0146 | 7.0079 | 7.0146 | 38360.0 |
| 2010-02-10 09:05:00 | AAPL | Stock | 7.0154 | 7.0161 | 7.0136 | 7.0136 | 42000.0 |
| 2010-02-10 09:10:00 | AAPL | Stock | 7.0143 | 7.0179 | 7.0075 | 7.0157 | 259000.0 |
| 2010-02-10 09:15:00 | AAPL | Stock | 7.0154 | 7.0154 | 7.0068 | 7.0071 | 78904.0 |
| 2010-02-10 09:20:00 | AAPL | Stock | 7.0054 | 7.0054 | 6.9961 | 7.0032 | 305620.0 |
| 2010-02-10 09:25:00 | AAPL | Stock | 7.0018 | 7.0018 | 6.9932 | 6.9943 | 171080.0 |
| 2010-02-10 09:30:00 | AAPL | Stock | 6.9961 | 7.0143 | 6.9761 | 7.0025 | 10142440.0 |
| 2010-02-10 09:35:00 | AAPL | Stock | 7.0046 | 7.0214 | 6.9925 | 6.9971 | 9098852.0 |
| 2010-02-10 09:40:00 | AAPL | Stock | 6.9968 | 7.0043 | 6.9761 | 6.9789 | 9139312.0 |
| 2010-02-10 09:45:00 | AAPL | Stock | 6.9786 | 6.9954 | 6.9718 | 6.9919 | 9563624.0 |
| 2010-02-10 09:50:00 | AAPL | Stock | 6.9918 | 6.995 | 6.9804 | 6.9886 | 5048456.0 |
| 2010-02-10 09:55:00 | AAPL | Stock | 6.9877 | 6.9982 | 6.9811 | 6.9936 | 6878088.0 |
| 2010-02-10 10:00:00 | AAPL | Stock | 6.9936 | 6.9971 | 6.9675 | 6.9775 | 12712392.0 |
| 2010-02-10 10:05:00 | AAPL | Stock | 6.9768 | 6.9807 | 6.9571 | 6.965 | 12590816.0 |
| 2010-02-10 10:10:00 | AAPL | Stock | 6.9643 | 6.9643 | 6.95 | 6.9614 | 8159956.0 |
| 2010-02-10 10:15:00 | AAPL | Stock | 6.9604 | 6.9604 | 6.9412 | 6.9575 | 8741460.0 |
| 2010-02-10 10:20:00 | AAPL | Stock | 6.9571 | 6.9646 | 6.9482 | 6.9548 | 6141996.0 |
| 2010-02-10 10:25:00 | AAPL | Stock | 6.9564 | 6.9582 | 6.9414 | 6.9541 | 5773908.0 |
| 2010-02-10 10:30:00 | AAPL | Stock | 6.9543 | 6.9571 | 6.9379 | 6.9546 | 6525176.0 |
| 2010-02-10 10:35:00 | AAPL | Stock | 6.955 | 6.9554 | 6.9429 | 6.9542 | 3572968.0 |
| 2010-02-10 10:40:00 | AAPL | Stock | 6.9554 | 6.9639 | 6.9506 | 6.9557 | 5983292.0 |
| 2010-02-10 10:45:00 | AAPL | Stock | 6.9546 | 6.9618 | 6.9479 | 6.955 | 2928828.0 |
| 2010-02-10 10:50:00 | AAPL | Stock | 6.9539 | 6.9689 | 6.9529 | 6.9596 | 4503772.0 |
| 2010-02-10 10:55:00 | AAPL | Stock | 6.9586 | 6.9646 | 6.9525 | 6.9589 | 2964220.0 |
| 2010-02-10 11:00:00 | AAPL | Stock | 6.96 | 6.9625 | 6.9521 | 6.9525 | 2766708.0 |
> showing 50 of 310,790 rows — these rows as CSV