PREVIEW / stock_5min / 2011-06-24
file: by_date/stock_5min/2011/2011-06-24.parquet size: 5.1 MB rows: 348,572 symbols: 3,549
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-06-24 04:35:00 | AAPL | Stock | 11.8636 | 11.8636 | 11.8636 | 11.8636 | 2800.0 |
| 2011-06-24 05:10:00 | AAPL | Stock | 11.9111 | 11.9111 | 11.9107 | 11.9107 | 5600.0 |
| 2011-06-24 05:15:00 | AAPL | Stock | 11.9107 | 11.9107 | 11.9107 | 11.9107 | 19600.0 |
| 2011-06-24 05:25:00 | AAPL | Stock | 11.9107 | 11.9107 | 11.9107 | 11.9107 | 11200.0 |
| 2011-06-24 05:45:00 | AAPL | Stock | 11.9071 | 11.9071 | 11.9071 | 11.9071 | 14000.0 |
| 2011-06-24 06:00:00 | AAPL | Stock | 11.9018 | 11.9018 | 11.8764 | 11.8764 | 8400.0 |
| 2011-06-24 06:05:00 | AAPL | Stock | 11.8754 | 11.8754 | 11.8754 | 11.8754 | 10640.0 |
| 2011-06-24 06:15:00 | AAPL | Stock | 11.8679 | 11.8679 | 11.8632 | 11.8632 | 8400.0 |
| 2011-06-24 06:40:00 | AAPL | Stock | 11.8632 | 11.8632 | 11.8632 | 11.8632 | 5600.0 |
| 2011-06-24 06:45:00 | AAPL | Stock | 11.8643 | 11.8643 | 11.8643 | 11.8643 | 2800.0 |
| 2011-06-24 07:00:00 | AAPL | Stock | 11.8611 | 11.8611 | 11.8482 | 11.8482 | 28000.0 |
| 2011-06-24 07:05:00 | AAPL | Stock | 11.8571 | 11.8571 | 11.8504 | 11.8504 | 5600.0 |
| 2011-06-24 07:10:00 | AAPL | Stock | 11.8475 | 11.8571 | 11.8429 | 11.8571 | 70000.0 |
| 2011-06-24 07:15:00 | AAPL | Stock | 11.8604 | 11.8604 | 11.8529 | 11.8546 | 11200.0 |
| 2011-06-24 07:20:00 | AAPL | Stock | 11.8504 | 11.8504 | 11.8482 | 11.8482 | 5600.0 |
| 2011-06-24 07:25:00 | AAPL | Stock | 11.8446 | 11.8446 | 11.8393 | 11.8393 | 32900.0 |
| 2011-06-24 07:30:00 | AAPL | Stock | 11.8393 | 11.8464 | 11.8393 | 11.8461 | 35980.0 |
| 2011-06-24 07:35:00 | AAPL | Stock | 11.8482 | 11.8482 | 11.8446 | 11.8446 | 11200.0 |
| 2011-06-24 07:40:00 | AAPL | Stock | 11.8446 | 11.8446 | 11.8339 | 11.8393 | 25200.0 |
| 2011-06-24 07:45:00 | AAPL | Stock | 11.8393 | 11.8393 | 11.8393 | 11.8393 | 8400.0 |
| 2011-06-24 07:50:00 | AAPL | Stock | 11.8464 | 11.85 | 11.8464 | 11.85 | 14000.0 |
| 2011-06-24 07:55:00 | AAPL | Stock | 11.8471 | 11.8471 | 11.8229 | 11.8229 | 50232.0 |
| 2011-06-24 08:00:00 | AAPL | Stock | 11.8393 | 11.8464 | 11.8214 | 11.8239 | 270004.0 |
| 2011-06-24 08:05:00 | AAPL | Stock | 11.8171 | 11.8214 | 11.795 | 11.8211 | 130424.0 |
| 2011-06-24 08:10:00 | AAPL | Stock | 11.8036 | 11.815 | 11.7829 | 11.7893 | 297108.0 |
| 2011-06-24 08:15:00 | AAPL | Stock | 11.7889 | 11.8 | 11.7857 | 11.8 | 128408.0 |
| 2011-06-24 08:20:00 | AAPL | Stock | 11.7868 | 11.8036 | 11.7832 | 11.8036 | 158200.0 |
| 2011-06-24 08:25:00 | AAPL | Stock | 11.8168 | 11.8286 | 11.8107 | 11.8246 | 200984.0 |
| 2011-06-24 08:30:00 | AAPL | Stock | 11.825 | 11.845 | 11.8071 | 11.8125 | 429464.0 |
| 2011-06-24 08:35:00 | AAPL | Stock | 11.8143 | 11.83 | 11.8075 | 11.8082 | 287112.0 |
| 2011-06-24 08:40:00 | AAPL | Stock | 11.8139 | 11.8204 | 11.8086 | 11.8196 | 101472.0 |
| 2011-06-24 08:45:00 | AAPL | Stock | 11.82 | 11.8214 | 11.8143 | 11.8214 | 185220.0 |
| 2011-06-24 08:50:00 | AAPL | Stock | 11.8214 | 11.8375 | 11.8214 | 11.8314 | 132468.0 |
| 2011-06-24 08:55:00 | AAPL | Stock | 11.8336 | 11.8414 | 11.8304 | 11.8311 | 266476.0 |
| 2011-06-24 09:00:00 | AAPL | Stock | 11.8271 | 11.8321 | 11.8196 | 11.8211 | 189868.0 |
| 2011-06-24 09:05:00 | AAPL | Stock | 11.8214 | 11.8225 | 11.8143 | 11.8161 | 167804.0 |
| 2011-06-24 09:10:00 | AAPL | Stock | 11.8161 | 11.8314 | 11.8143 | 11.8314 | 204204.0 |
| 2011-06-24 09:15:00 | AAPL | Stock | 11.8243 | 11.8243 | 11.815 | 11.815 | 42280.0 |
| 2011-06-24 09:20:00 | AAPL | Stock | 11.8189 | 11.8189 | 11.815 | 11.8161 | 72800.0 |
| 2011-06-24 09:25:00 | AAPL | Stock | 11.8161 | 11.8493 | 11.8161 | 11.8375 | 558852.0 |
| 2011-06-24 09:30:00 | AAPL | Stock | 11.8364 | 11.88 | 11.8131 | 11.8686 | 24864448.0 |
| 2011-06-24 09:35:00 | AAPL | Stock | 11.8686 | 11.8982 | 11.8443 | 11.8757 | 16998576.0 |
| 2011-06-24 09:40:00 | AAPL | Stock | 11.8761 | 11.8857 | 11.83 | 11.8336 | 12124728.0 |
| 2011-06-24 09:45:00 | AAPL | Stock | 11.832 | 11.8529 | 11.8061 | 11.8158 | 10686144.0 |
| 2011-06-24 09:50:00 | AAPL | Stock | 11.8154 | 11.8454 | 11.8121 | 11.8354 | 7816536.0 |
| 2011-06-24 09:55:00 | AAPL | Stock | 11.8354 | 11.8589 | 11.8189 | 11.8404 | 6362496.0 |
| 2011-06-24 10:00:00 | AAPL | Stock | 11.8393 | 11.8496 | 11.8132 | 11.8261 | 7680960.0 |
| 2011-06-24 10:05:00 | AAPL | Stock | 11.825 | 11.8418 | 11.7961 | 11.8029 | 7741916.0 |
| 2011-06-24 10:10:00 | AAPL | Stock | 11.8029 | 11.8029 | 11.7411 | 11.7582 | 13210344.0 |
| 2011-06-24 10:15:00 | AAPL | Stock | 11.76 | 11.7832 | 11.7532 | 11.7779 | 7570304.0 |
> showing 50 of 348,572 rows — these rows as CSV