PREVIEW / stock_5min / 2012-08-16
file: by_date/stock_5min/2012/2012-08-16.parquet size: 4.7 MB rows: 312,206 symbols: 3,440
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-08-16 04:00:00 | AAPL | Stock | 22.5539 | 22.5539 | 22.5539 | 22.5539 | 5600.0 |
| 2012-08-16 04:05:00 | AAPL | Stock | 22.5536 | 22.5536 | 22.5536 | 22.5536 | 2800.0 |
| 2012-08-16 04:10:00 | AAPL | Stock | 22.5429 | 22.5429 | 22.5429 | 22.5429 | 7784.0 |
| 2012-08-16 04:15:00 | AAPL | Stock | 22.5464 | 22.5464 | 22.5464 | 22.5464 | 3416.0 |
| 2012-08-16 04:20:00 | AAPL | Stock | 22.5361 | 22.5361 | 22.5361 | 22.5361 | 5600.0 |
| 2012-08-16 06:50:00 | AAPL | Stock | 22.5871 | 22.5889 | 22.5871 | 22.5889 | 5600.0 |
| 2012-08-16 07:00:00 | AAPL | Stock | 22.58 | 22.5971 | 22.58 | 22.5971 | 39900.0 |
| 2012-08-16 07:05:00 | AAPL | Stock | 22.5957 | 22.6 | 22.5707 | 22.5714 | 65800.0 |
| 2012-08-16 07:15:00 | AAPL | Stock | 22.5614 | 22.5707 | 22.5611 | 22.5707 | 32956.0 |
| 2012-08-16 07:20:00 | AAPL | Stock | 22.5707 | 22.5821 | 22.5707 | 22.5821 | 16324.0 |
| 2012-08-16 07:30:00 | AAPL | Stock | 22.5889 | 22.5889 | 22.5889 | 22.5889 | 2800.0 |
| 2012-08-16 07:40:00 | AAPL | Stock | 22.5893 | 22.5893 | 22.5893 | 22.5893 | 11200.0 |
| 2012-08-16 07:45:00 | AAPL | Stock | 22.5946 | 22.6 | 22.5893 | 22.6 | 59500.0 |
| 2012-08-16 07:50:00 | AAPL | Stock | 22.6036 | 22.605 | 22.6036 | 22.605 | 11144.0 |
| 2012-08-16 07:55:00 | AAPL | Stock | 22.6011 | 22.6011 | 22.6007 | 22.6007 | 5600.0 |
| 2012-08-16 08:00:00 | AAPL | Stock | 22.5907 | 22.6071 | 22.5775 | 22.5786 | 336980.0 |
| 2012-08-16 08:05:00 | AAPL | Stock | 22.5875 | 22.5929 | 22.5854 | 22.5875 | 55860.0 |
| 2012-08-16 08:10:00 | AAPL | Stock | 22.5854 | 22.5893 | 22.575 | 22.575 | 56140.0 |
| 2012-08-16 08:15:00 | AAPL | Stock | 22.5804 | 22.5804 | 22.5743 | 22.5743 | 11200.0 |
| 2012-08-16 08:20:00 | AAPL | Stock | 22.5843 | 22.5843 | 22.5768 | 22.5768 | 8400.0 |
| 2012-08-16 08:25:00 | AAPL | Stock | 22.5814 | 22.5821 | 22.5814 | 22.5821 | 5600.0 |
| 2012-08-16 08:30:00 | AAPL | Stock | 22.5832 | 22.5911 | 22.5821 | 22.5854 | 128800.0 |
| 2012-08-16 08:35:00 | AAPL | Stock | 22.5886 | 22.6064 | 22.5857 | 22.5886 | 108444.0 |
| 2012-08-16 08:40:00 | AAPL | Stock | 22.5921 | 22.6039 | 22.5893 | 22.5979 | 96824.0 |
| 2012-08-16 08:45:00 | AAPL | Stock | 22.5957 | 22.5957 | 22.5854 | 22.5893 | 133280.0 |
| 2012-08-16 08:50:00 | AAPL | Stock | 22.5857 | 22.5929 | 22.5714 | 22.5714 | 118776.0 |
| 2012-08-16 08:55:00 | AAPL | Stock | 22.5714 | 22.5714 | 22.5643 | 22.5643 | 187768.0 |
| 2012-08-16 09:00:00 | AAPL | Stock | 22.5629 | 22.5629 | 22.5607 | 22.5614 | 28000.0 |
| 2012-08-16 09:05:00 | AAPL | Stock | 22.5714 | 22.5714 | 22.5714 | 22.5714 | 8400.0 |
| 2012-08-16 09:10:00 | AAPL | Stock | 22.565 | 22.5661 | 22.5589 | 22.5589 | 31024.0 |
| 2012-08-16 09:15:00 | AAPL | Stock | 22.5571 | 22.5625 | 22.545 | 22.5493 | 134176.0 |
| 2012-08-16 09:20:00 | AAPL | Stock | 22.5468 | 22.5518 | 22.5368 | 22.5518 | 78400.0 |
| 2012-08-16 09:25:00 | AAPL | Stock | 22.5464 | 22.5607 | 22.5371 | 22.5411 | 340480.0 |
| 2012-08-16 09:30:00 | AAPL | Stock | 22.5411 | 22.5689 | 22.5179 | 22.54 | 10502324.0 |
| 2012-08-16 09:35:00 | AAPL | Stock | 22.5429 | 22.6071 | 22.5336 | 22.6039 | 6108172.0 |
| 2012-08-16 09:40:00 | AAPL | Stock | 22.6007 | 22.6071 | 22.5793 | 22.5975 | 6052340.0 |
| 2012-08-16 09:45:00 | AAPL | Stock | 22.5979 | 22.6071 | 22.5607 | 22.5679 | 4212404.0 |
| 2012-08-16 09:50:00 | AAPL | Stock | 22.5711 | 22.5921 | 22.5664 | 22.5875 | 3144344.0 |
| 2012-08-16 09:55:00 | AAPL | Stock | 22.5854 | 22.5882 | 22.5457 | 22.5707 | 4470312.0 |
| 2012-08-16 10:00:00 | AAPL | Stock | 22.57 | 22.5714 | 22.5261 | 22.5529 | 5213628.0 |
| 2012-08-16 10:05:00 | AAPL | Stock | 22.556 | 22.5561 | 22.5357 | 22.5453 | 2738484.0 |
| 2012-08-16 10:10:00 | AAPL | Stock | 22.5429 | 22.5575 | 22.5286 | 22.5486 | 3702104.0 |
| 2012-08-16 10:15:00 | AAPL | Stock | 22.55 | 22.5514 | 22.5371 | 22.5389 | 1893332.0 |
| 2012-08-16 10:20:00 | AAPL | Stock | 22.5421 | 22.5675 | 22.5421 | 22.5646 | 3310832.0 |
| 2012-08-16 10:25:00 | AAPL | Stock | 22.5639 | 22.5846 | 22.5557 | 22.5768 | 3021872.0 |
| 2012-08-16 10:30:00 | AAPL | Stock | 22.5771 | 22.595 | 22.5761 | 22.5829 | 3887156.0 |
| 2012-08-16 10:35:00 | AAPL | Stock | 22.5832 | 22.6179 | 22.5832 | 22.6179 | 5289984.0 |
| 2012-08-16 10:40:00 | AAPL | Stock | 22.6136 | 22.6207 | 22.6004 | 22.6179 | 3072160.0 |
| 2012-08-16 10:45:00 | AAPL | Stock | 22.6193 | 22.6354 | 22.6175 | 22.6318 | 3601304.0 |
| 2012-08-16 10:50:00 | AAPL | Stock | 22.6319 | 22.6368 | 22.6129 | 22.6179 | 2581264.0 |
> showing 50 of 312,206 rows — these rows as CSV