PREVIEW / stock_5min / 2007-05-16
file: by_date/stock_5min/2007/2007-05-16.parquet size: 4.0 MB rows: 294,092 symbols: 3,015
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 |
|---|---|---|---|---|---|---|---|
| 2007-05-16 09:30:00 | AAPL | Stock | 3.8761 | 3.8761 | 3.86 | 3.8657 | 35975632.0 |
| 2007-05-16 09:35:00 | AAPL | Stock | 3.8654 | 3.8868 | 3.8604 | 3.8807 | 30518684.0 |
| 2007-05-16 09:40:00 | AAPL | Stock | 3.8807 | 3.9518 | 3.8661 | 3.8696 | 20324500.0 |
| 2007-05-16 09:45:00 | AAPL | Stock | 3.8668 | 3.8743 | 3.8586 | 3.8604 | 17689784.0 |
| 2007-05-16 09:50:00 | AAPL | Stock | 3.86 | 3.8689 | 3.8536 | 3.8629 | 19101712.0 |
| 2007-05-16 09:55:00 | AAPL | Stock | 3.8625 | 3.8664 | 3.8479 | 3.8539 | 16765028.0 |
| 2007-05-16 10:00:00 | AAPL | Stock | 3.8539 | 3.8586 | 3.8418 | 3.8564 | 18328940.0 |
| 2007-05-16 10:05:00 | AAPL | Stock | 3.8561 | 3.8593 | 3.8489 | 3.8532 | 8895628.0 |
| 2007-05-16 10:10:00 | AAPL | Stock | 3.8532 | 3.8596 | 3.8518 | 3.8586 | 13814080.0 |
| 2007-05-16 10:15:00 | AAPL | Stock | 3.8582 | 3.8604 | 3.855 | 3.8586 | 7047572.0 |
| 2007-05-16 10:20:00 | AAPL | Stock | 3.8585 | 3.8661 | 3.8571 | 3.8571 | 11922988.0 |
| 2007-05-16 10:25:00 | AAPL | Stock | 3.8571 | 3.8611 | 3.8557 | 3.8579 | 11738804.0 |
| 2007-05-16 10:30:00 | AAPL | Stock | 3.8582 | 3.8582 | 3.8507 | 3.8514 | 8758764.0 |
| 2007-05-16 10:35:00 | AAPL | Stock | 3.8511 | 3.8575 | 3.8489 | 3.8539 | 11832884.0 |
| 2007-05-16 10:40:00 | AAPL | Stock | 3.8539 | 3.8636 | 3.8536 | 3.8632 | 7774200.0 |
| 2007-05-16 10:45:00 | AAPL | Stock | 3.8629 | 3.8632 | 3.8536 | 3.8582 | 11391044.0 |
| 2007-05-16 10:50:00 | AAPL | Stock | 3.858 | 3.8621 | 3.84 | 3.84 | 14693952.0 |
| 2007-05-16 10:55:00 | AAPL | Stock | 3.8404 | 3.8429 | 3.8307 | 3.8393 | 17335248.0 |
| 2007-05-16 11:00:00 | AAPL | Stock | 3.8389 | 3.8446 | 3.8346 | 3.8411 | 6756512.0 |
| 2007-05-16 11:05:00 | AAPL | Stock | 3.8411 | 3.8429 | 3.8346 | 3.8354 | 6313552.0 |
| 2007-05-16 11:10:00 | AAPL | Stock | 3.8357 | 3.8361 | 3.8182 | 3.8189 | 21080276.0 |
| 2007-05-16 11:15:00 | AAPL | Stock | 3.8186 | 3.8282 | 3.8171 | 3.8279 | 11439624.0 |
| 2007-05-16 11:20:00 | AAPL | Stock | 3.8282 | 3.8321 | 3.8243 | 3.8243 | 7807100.0 |
| 2007-05-16 11:25:00 | AAPL | Stock | 3.8243 | 3.8271 | 3.8143 | 3.8229 | 9445044.0 |
| 2007-05-16 11:30:00 | AAPL | Stock | 3.8229 | 3.8386 | 3.8225 | 3.8375 | 11279996.0 |
| 2007-05-16 11:35:00 | AAPL | Stock | 3.8368 | 3.8514 | 3.8357 | 3.8493 | 13284264.0 |
| 2007-05-16 11:40:00 | AAPL | Stock | 3.8493 | 3.8504 | 3.8425 | 3.8443 | 12610920.0 |
| 2007-05-16 11:45:00 | AAPL | Stock | 3.8446 | 3.8493 | 3.8411 | 3.8461 | 5476632.0 |
| 2007-05-16 11:50:00 | AAPL | Stock | 3.8457 | 3.8536 | 3.8446 | 3.8507 | 7554344.0 |
| 2007-05-16 11:55:00 | AAPL | Stock | 3.8518 | 3.8554 | 3.7946 | 3.8125 | 52621968.0 |
| 2007-05-16 12:00:00 | AAPL | Stock | 3.8125 | 3.8129 | 3.6936 | 3.7839 | 104347096.0 |
| 2007-05-16 12:05:00 | AAPL | Stock | 3.7839 | 3.7936 | 3.76 | 3.785 | 57264144.0 |
| 2007-05-16 12:10:00 | AAPL | Stock | 3.7839 | 3.8268 | 3.75 | 3.8243 | 73208380.0 |
| 2007-05-16 12:15:00 | AAPL | Stock | 3.8243 | 3.8393 | 3.8043 | 3.8343 | 76287820.0 |
| 2007-05-16 12:20:00 | AAPL | Stock | 3.8343 | 3.8425 | 3.8186 | 3.8196 | 38367448.0 |
| 2007-05-16 12:25:00 | AAPL | Stock | 3.82 | 3.8279 | 3.8139 | 3.82 | 18789120.0 |
| 2007-05-16 12:30:00 | AAPL | Stock | 3.82 | 3.835 | 3.8175 | 3.8293 | 14917616.0 |
| 2007-05-16 12:35:00 | AAPL | Stock | 3.8289 | 3.8311 | 3.8164 | 3.8196 | 8860684.0 |
| 2007-05-16 12:40:00 | AAPL | Stock | 3.8189 | 3.8204 | 3.81 | 3.8125 | 12180476.0 |
| 2007-05-16 12:45:00 | AAPL | Stock | 3.8125 | 3.8225 | 3.8125 | 3.8157 | 6001884.0 |
| 2007-05-16 12:50:00 | AAPL | Stock | 3.8164 | 3.8218 | 3.8154 | 3.8179 | 5005168.0 |
| 2007-05-16 12:55:00 | AAPL | Stock | 3.8179 | 3.8312 | 3.8168 | 3.8296 | 7647444.0 |
| 2007-05-16 13:00:00 | AAPL | Stock | 3.8293 | 3.8304 | 3.8229 | 3.8236 | 4916044.0 |
| 2007-05-16 13:05:00 | AAPL | Stock | 3.8239 | 3.8243 | 3.8189 | 3.8196 | 4074028.0 |
| 2007-05-16 13:10:00 | AAPL | Stock | 3.8196 | 3.82 | 3.8157 | 3.8196 | 3394468.0 |
| 2007-05-16 13:15:00 | AAPL | Stock | 3.8193 | 3.8218 | 3.8175 | 3.8207 | 3009468.0 |
| 2007-05-16 13:20:00 | AAPL | Stock | 3.8207 | 3.8225 | 3.8204 | 3.8214 | 3796380.0 |
| 2007-05-16 13:25:00 | AAPL | Stock | 3.8214 | 3.8225 | 3.8171 | 3.82 | 3037748.0 |
| 2007-05-16 13:30:00 | AAPL | Stock | 3.8207 | 3.8239 | 3.8179 | 3.8232 | 3119788.0 |
| 2007-05-16 13:35:00 | AAPL | Stock | 3.8236 | 3.8286 | 3.8229 | 3.8282 | 5164068.0 |
> showing 50 of 294,092 rows — these rows as CSV