PREVIEW / stock_5min / 2012-11-29
file: by_date/stock_5min/2012/2012-11-29.parquet size: 4.8 MB rows: 324,256 symbols: 3,489
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 |
|---|---|---|---|---|---|---|---|
| 2012-11-29 04:15:00 | AAPL | Stock | 20.9321 | 20.9321 | 20.9314 | 20.9314 | 8400.0 |
| 2012-11-29 04:35:00 | AAPL | Stock | 20.9464 | 20.9464 | 20.9464 | 20.9464 | 8400.0 |
| 2012-11-29 04:50:00 | AAPL | Stock | 20.9429 | 20.9429 | 20.9375 | 20.9375 | 25200.0 |
| 2012-11-29 05:10:00 | AAPL | Stock | 20.9464 | 20.95 | 20.9464 | 20.95 | 26600.0 |
| 2012-11-29 05:15:00 | AAPL | Stock | 20.9396 | 20.9396 | 20.9396 | 20.9396 | 2800.0 |
| 2012-11-29 05:40:00 | AAPL | Stock | 20.9314 | 20.9314 | 20.9314 | 20.9314 | 2800.0 |
| 2012-11-29 05:50:00 | AAPL | Stock | 20.9607 | 20.9607 | 20.9607 | 20.9607 | 16800.0 |
| 2012-11-29 06:15:00 | AAPL | Stock | 20.9582 | 20.9582 | 20.9582 | 20.9582 | 2800.0 |
| 2012-11-29 06:20:00 | AAPL | Stock | 20.9307 | 20.9307 | 20.9307 | 20.9307 | 5600.0 |
| 2012-11-29 06:30:00 | AAPL | Stock | 20.9464 | 20.9464 | 20.9464 | 20.9464 | 2800.0 |
| 2012-11-29 06:35:00 | AAPL | Stock | 20.9464 | 20.9464 | 20.9464 | 20.9464 | 2800.0 |
| 2012-11-29 06:45:00 | AAPL | Stock | 20.9464 | 20.9536 | 20.9464 | 20.9536 | 14000.0 |
| 2012-11-29 06:50:00 | AAPL | Stock | 20.9339 | 20.9339 | 20.9339 | 20.9339 | 2800.0 |
| 2012-11-29 06:55:00 | AAPL | Stock | 20.9607 | 20.9607 | 20.9607 | 20.9607 | 2800.0 |
| 2012-11-29 07:00:00 | AAPL | Stock | 20.96 | 20.9607 | 20.9464 | 20.9596 | 67564.0 |
| 2012-11-29 07:05:00 | AAPL | Stock | 20.9536 | 20.9543 | 20.9375 | 20.9375 | 30800.0 |
| 2012-11-29 07:10:00 | AAPL | Stock | 20.9375 | 20.9714 | 20.9243 | 20.9679 | 200816.0 |
| 2012-11-29 07:15:00 | AAPL | Stock | 20.9654 | 20.9821 | 20.9643 | 20.9818 | 80724.0 |
| 2012-11-29 07:20:00 | AAPL | Stock | 20.9696 | 20.9814 | 20.9643 | 20.9643 | 104440.0 |
| 2012-11-29 07:25:00 | AAPL | Stock | 20.97 | 20.9732 | 20.9643 | 20.9732 | 78204.0 |
| 2012-11-29 07:30:00 | AAPL | Stock | 20.9818 | 20.9832 | 20.9736 | 20.9832 | 60032.0 |
| 2012-11-29 07:35:00 | AAPL | Stock | 20.9821 | 20.9821 | 20.9818 | 20.9821 | 23940.0 |
| 2012-11-29 07:40:00 | AAPL | Stock | 20.9861 | 21.0196 | 20.9836 | 21.0125 | 141820.0 |
| 2012-11-29 07:45:00 | AAPL | Stock | 21.0071 | 21.0293 | 21.0071 | 21.0293 | 205156.0 |
| 2012-11-29 07:50:00 | AAPL | Stock | 21.0339 | 21.0368 | 21.0243 | 21.0368 | 311192.0 |
| 2012-11-29 07:55:00 | AAPL | Stock | 21.0364 | 21.0368 | 21.0243 | 21.0286 | 157080.0 |
| 2012-11-29 08:00:00 | AAPL | Stock | 21.0268 | 21.0318 | 20.98 | 21.005 | 328272.0 |
| 2012-11-29 08:05:00 | AAPL | Stock | 21.01 | 21.0168 | 21.0014 | 21.0089 | 333312.0 |
| 2012-11-29 08:10:00 | AAPL | Stock | 21.0039 | 21.0071 | 20.9946 | 20.9946 | 122276.0 |
| 2012-11-29 08:15:00 | AAPL | Stock | 20.9946 | 21.0025 | 20.9843 | 20.9843 | 370972.0 |
| 2012-11-29 08:20:00 | AAPL | Stock | 20.9857 | 20.9929 | 20.9693 | 20.9714 | 242368.0 |
| 2012-11-29 08:25:00 | AAPL | Stock | 20.9746 | 20.9911 | 20.9732 | 20.9911 | 138376.0 |
| 2012-11-29 08:30:00 | AAPL | Stock | 20.9829 | 21.0029 | 20.9786 | 21.0004 | 399980.0 |
| 2012-11-29 08:35:00 | AAPL | Stock | 21.0057 | 21.0057 | 20.9929 | 20.9964 | 162400.0 |
| 2012-11-29 08:40:00 | AAPL | Stock | 20.9946 | 21.0164 | 20.9929 | 21.0082 | 498372.0 |
| 2012-11-29 08:45:00 | AAPL | Stock | 21.0014 | 21.0096 | 20.995 | 21.0057 | 287644.0 |
| 2012-11-29 08:50:00 | AAPL | Stock | 21.0068 | 21.0196 | 21.0064 | 21.0196 | 294756.0 |
| 2012-11-29 08:55:00 | AAPL | Stock | 21.0243 | 21.0264 | 21.0154 | 21.0239 | 179424.0 |
| 2012-11-29 09:00:00 | AAPL | Stock | 21.0229 | 21.0293 | 21.0089 | 21.0107 | 306404.0 |
| 2012-11-29 09:05:00 | AAPL | Stock | 21.0104 | 21.0446 | 21.0096 | 21.0446 | 350280.0 |
| 2012-11-29 09:10:00 | AAPL | Stock | 21.0446 | 21.0518 | 21.0446 | 21.05 | 339080.0 |
| 2012-11-29 09:15:00 | AAPL | Stock | 21.0482 | 21.0632 | 21.0446 | 21.0632 | 303184.0 |
| 2012-11-29 09:20:00 | AAPL | Stock | 21.0607 | 21.0654 | 21.05 | 21.0518 | 668472.0 |
| 2012-11-29 09:25:00 | AAPL | Stock | 21.0518 | 21.0986 | 21.0518 | 21.0718 | 1286684.0 |
| 2012-11-29 09:30:00 | AAPL | Stock | 21.075 | 21.2136 | 21.0564 | 21.2121 | 26989928.0 |
| 2012-11-29 09:35:00 | AAPL | Stock | 21.21 | 21.2232 | 21.1164 | 21.1339 | 18210248.0 |
| 2012-11-29 09:40:00 | AAPL | Stock | 21.1339 | 21.1889 | 21.1071 | 21.1539 | 13149108.0 |
| 2012-11-29 09:45:00 | AAPL | Stock | 21.1571 | 21.1875 | 21.1168 | 21.1271 | 9633904.0 |
| 2012-11-29 09:50:00 | AAPL | Stock | 21.1271 | 21.1589 | 21.1171 | 21.1257 | 7865732.0 |
| 2012-11-29 09:55:00 | AAPL | Stock | 21.1257 | 21.1486 | 21.0814 | 21.1129 | 11115272.0 |
> showing 50 of 324,256 rows — these rows as CSV