PREVIEW / stock_5min / 2011-12-12
file: by_date/stock_5min/2011/2011-12-12.parquet size: 4.7 MB rows: 324,958 symbols: 3,529
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 |
|---|---|---|---|---|---|---|---|
| 2011-12-12 04:00:00 | AAPL | Stock | 14.0268 | 14.0268 | 14.0268 | 14.0268 | 2800.0 |
| 2011-12-12 04:20:00 | AAPL | Stock | 14.0 | 14.0 | 14.0 | 14.0 | 30800.0 |
| 2011-12-12 04:30:00 | AAPL | Stock | 13.9821 | 13.9821 | 13.9764 | 13.9764 | 8400.0 |
| 2011-12-12 04:35:00 | AAPL | Stock | 13.98 | 13.98 | 13.98 | 13.98 | 5600.0 |
| 2011-12-12 04:45:00 | AAPL | Stock | 13.9643 | 13.9643 | 13.9643 | 13.9643 | 2800.0 |
| 2011-12-12 04:55:00 | AAPL | Stock | 13.9646 | 13.9646 | 13.9643 | 13.9643 | 7840.0 |
| 2011-12-12 05:00:00 | AAPL | Stock | 13.9643 | 13.9643 | 13.9643 | 13.9643 | 11200.0 |
| 2011-12-12 05:30:00 | AAPL | Stock | 13.9714 | 13.9714 | 13.9714 | 13.9714 | 5600.0 |
| 2011-12-12 05:40:00 | AAPL | Stock | 13.9714 | 13.9714 | 13.9714 | 13.9714 | 5600.0 |
| 2011-12-12 06:10:00 | AAPL | Stock | 13.9679 | 13.9714 | 13.9643 | 13.9714 | 17360.0 |
| 2011-12-12 07:00:00 | AAPL | Stock | 13.9682 | 14.0714 | 13.9682 | 14.0143 | 44800.0 |
| 2011-12-12 07:05:00 | AAPL | Stock | 14.0211 | 14.0211 | 14.0211 | 14.0211 | 2800.0 |
| 2011-12-12 07:10:00 | AAPL | Stock | 14.0225 | 14.0225 | 14.0179 | 14.0179 | 25200.0 |
| 2011-12-12 07:15:00 | AAPL | Stock | 14.0143 | 14.0143 | 14.0071 | 14.0071 | 7980.0 |
| 2011-12-12 07:20:00 | AAPL | Stock | 14.0111 | 14.0143 | 14.0111 | 14.0143 | 17360.0 |
| 2011-12-12 07:25:00 | AAPL | Stock | 14.0143 | 14.0143 | 14.0 | 14.0 | 115220.0 |
| 2011-12-12 07:30:00 | AAPL | Stock | 14.0 | 14.0 | 14.0 | 14.0 | 2800.0 |
| 2011-12-12 07:35:00 | AAPL | Stock | 14.0029 | 14.0029 | 13.9911 | 13.9911 | 130648.0 |
| 2011-12-12 07:40:00 | AAPL | Stock | 13.9975 | 14.0107 | 13.9964 | 14.0107 | 66332.0 |
| 2011-12-12 07:50:00 | AAPL | Stock | 14.0054 | 14.0143 | 14.0 | 14.0004 | 71232.0 |
| 2011-12-12 07:55:00 | AAPL | Stock | 14.0004 | 14.0086 | 14.0004 | 14.0071 | 50848.0 |
| 2011-12-12 08:00:00 | AAPL | Stock | 14.0071 | 14.0143 | 14.0071 | 14.0071 | 149016.0 |
| 2011-12-12 08:05:00 | AAPL | Stock | 14.0018 | 14.0036 | 14.0 | 14.0018 | 35700.0 |
| 2011-12-12 08:10:00 | AAPL | Stock | 14.005 | 14.005 | 14.0 | 14.0036 | 16576.0 |
| 2011-12-12 08:15:00 | AAPL | Stock | 14.0007 | 14.0089 | 13.9932 | 13.9993 | 214116.0 |
| 2011-12-12 08:20:00 | AAPL | Stock | 14.0018 | 14.0054 | 13.9929 | 14.0018 | 144200.0 |
| 2011-12-12 08:25:00 | AAPL | Stock | 14.0018 | 14.0121 | 14.0018 | 14.0071 | 83552.0 |
| 2011-12-12 08:30:00 | AAPL | Stock | 14.0136 | 14.0214 | 14.0136 | 14.0196 | 74620.0 |
| 2011-12-12 08:35:00 | AAPL | Stock | 14.0189 | 14.0393 | 14.0179 | 14.0314 | 232176.0 |
| 2011-12-12 08:40:00 | AAPL | Stock | 14.0314 | 14.0354 | 14.0182 | 14.0182 | 96600.0 |
| 2011-12-12 08:45:00 | AAPL | Stock | 14.0286 | 14.0321 | 14.0218 | 14.03 | 65800.0 |
| 2011-12-12 08:50:00 | AAPL | Stock | 14.0296 | 14.0296 | 14.0204 | 14.025 | 122416.0 |
| 2011-12-12 08:55:00 | AAPL | Stock | 14.0254 | 14.0254 | 14.0143 | 14.0179 | 122080.0 |
| 2011-12-12 09:00:00 | AAPL | Stock | 14.0179 | 14.0179 | 13.9879 | 14.0139 | 673904.0 |
| 2011-12-12 09:05:00 | AAPL | Stock | 14.0039 | 14.0143 | 14.0 | 14.0143 | 317520.0 |
| 2011-12-12 09:10:00 | AAPL | Stock | 14.0089 | 14.0161 | 14.0036 | 14.0039 | 93100.0 |
| 2011-12-12 09:15:00 | AAPL | Stock | 14.0043 | 14.0043 | 13.9946 | 14.0 | 242144.0 |
| 2011-12-12 09:20:00 | AAPL | Stock | 14.0011 | 14.0132 | 13.9971 | 14.0132 | 80976.0 |
| 2011-12-12 09:25:00 | AAPL | Stock | 14.0132 | 14.0225 | 13.9821 | 13.9904 | 744772.0 |
| 2011-12-12 09:30:00 | AAPL | Stock | 13.9904 | 14.0536 | 13.9879 | 14.0371 | 12425868.0 |
| 2011-12-12 09:35:00 | AAPL | Stock | 14.0428 | 14.0679 | 14.0025 | 14.0214 | 12207244.0 |
| 2011-12-12 09:40:00 | AAPL | Stock | 14.0214 | 14.046 | 14.0025 | 14.025 | 5031404.0 |
| 2011-12-12 09:45:00 | AAPL | Stock | 14.0209 | 14.0507 | 14.0182 | 14.0429 | 4470508.0 |
| 2011-12-12 09:50:00 | AAPL | Stock | 14.0432 | 14.0539 | 14.0089 | 14.0118 | 5466412.0 |
| 2011-12-12 09:55:00 | AAPL | Stock | 14.0114 | 14.0218 | 13.9911 | 14.0118 | 5170452.0 |
| 2011-12-12 10:00:00 | AAPL | Stock | 14.0114 | 14.0236 | 13.9893 | 13.9936 | 5859644.0 |
| 2011-12-12 10:05:00 | AAPL | Stock | 13.9932 | 14.0357 | 13.99 | 14.0246 | 4293688.0 |
| 2011-12-12 10:10:00 | AAPL | Stock | 14.0268 | 14.0268 | 13.9896 | 13.9982 | 3601052.0 |
| 2011-12-12 10:15:00 | AAPL | Stock | 14.0064 | 14.0064 | 13.9679 | 13.9693 | 9368240.0 |
| 2011-12-12 10:20:00 | AAPL | Stock | 13.9699 | 13.9857 | 13.9643 | 13.9786 | 5613132.0 |
> showing 50 of 324,958 rows — these rows as CSV