PREVIEW / stock_5min / 2011-05-23
file: by_date/stock_5min/2011/2011-05-23.parquet size: 4.9 MB rows: 332,969 symbols: 3,530
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-05-23 04:05:00 | AAPL | Stock | 11.8736 | 11.875 | 11.8736 | 11.875 | 5600.0 |
| 2011-05-23 04:20:00 | AAPL | Stock | 11.8571 | 11.8571 | 11.8571 | 11.8571 | 2940.0 |
| 2011-05-23 04:35:00 | AAPL | Stock | 11.8575 | 11.8589 | 11.85 | 11.85 | 8400.0 |
| 2011-05-23 04:40:00 | AAPL | Stock | 11.85 | 11.85 | 11.85 | 11.85 | 8400.0 |
| 2011-05-23 04:50:00 | AAPL | Stock | 11.85 | 11.85 | 11.85 | 11.85 | 2800.0 |
| 2011-05-23 05:00:00 | AAPL | Stock | 11.85 | 11.85 | 11.85 | 11.85 | 5600.0 |
| 2011-05-23 05:05:00 | AAPL | Stock | 11.85 | 11.85 | 11.85 | 11.85 | 2800.0 |
| 2011-05-23 05:10:00 | AAPL | Stock | 11.8536 | 11.8536 | 11.85 | 11.85 | 5600.0 |
| 2011-05-23 05:15:00 | AAPL | Stock | 11.8393 | 11.8429 | 11.8393 | 11.8429 | 26600.0 |
| 2011-05-23 05:25:00 | AAPL | Stock | 11.8429 | 11.8429 | 11.8429 | 11.8429 | 2800.0 |
| 2011-05-23 05:40:00 | AAPL | Stock | 11.85 | 11.85 | 11.85 | 11.85 | 11200.0 |
| 2011-05-23 05:45:00 | AAPL | Stock | 11.8536 | 11.8536 | 11.8536 | 11.8536 | 3360.0 |
| 2011-05-23 06:10:00 | AAPL | Stock | 11.8539 | 11.8539 | 11.8539 | 11.8539 | 4760.0 |
| 2011-05-23 06:45:00 | AAPL | Stock | 11.8679 | 11.8679 | 11.8643 | 11.8643 | 19600.0 |
| 2011-05-23 06:50:00 | AAPL | Stock | 11.8607 | 11.8607 | 11.8607 | 11.8607 | 14000.0 |
| 2011-05-23 07:00:00 | AAPL | Stock | 11.8679 | 11.8686 | 11.8679 | 11.8679 | 39200.0 |
| 2011-05-23 07:05:00 | AAPL | Stock | 11.8621 | 11.875 | 11.8571 | 11.8732 | 44100.0 |
| 2011-05-23 07:10:00 | AAPL | Stock | 11.8661 | 11.875 | 11.8571 | 11.875 | 25312.0 |
| 2011-05-23 07:15:00 | AAPL | Stock | 11.875 | 11.875 | 11.875 | 11.875 | 2800.0 |
| 2011-05-23 07:20:00 | AAPL | Stock | 11.875 | 11.875 | 11.8661 | 11.8661 | 5600.0 |
| 2011-05-23 07:25:00 | AAPL | Stock | 11.8793 | 11.8793 | 11.8793 | 11.8793 | 2800.0 |
| 2011-05-23 07:30:00 | AAPL | Stock | 11.8643 | 11.8743 | 11.8643 | 11.8743 | 8400.0 |
| 2011-05-23 07:35:00 | AAPL | Stock | 11.8679 | 11.8679 | 11.8539 | 11.8539 | 42280.0 |
| 2011-05-23 07:40:00 | AAPL | Stock | 11.8582 | 11.8582 | 11.8539 | 11.8571 | 44800.0 |
| 2011-05-23 07:45:00 | AAPL | Stock | 11.8554 | 11.8661 | 11.8554 | 11.8607 | 19600.0 |
| 2011-05-23 07:50:00 | AAPL | Stock | 11.8711 | 11.8714 | 11.8539 | 11.8539 | 118860.0 |
| 2011-05-23 07:55:00 | AAPL | Stock | 11.865 | 11.865 | 11.85 | 11.8571 | 26600.0 |
| 2011-05-23 08:00:00 | AAPL | Stock | 11.8579 | 11.8686 | 11.8429 | 11.8457 | 249284.0 |
| 2011-05-23 08:05:00 | AAPL | Stock | 11.8464 | 11.8464 | 11.8321 | 11.8379 | 251160.0 |
| 2011-05-23 08:10:00 | AAPL | Stock | 11.8371 | 11.85 | 11.8368 | 11.85 | 253540.0 |
| 2011-05-23 08:15:00 | AAPL | Stock | 11.8443 | 11.8461 | 11.8418 | 11.8429 | 23884.0 |
| 2011-05-23 08:20:00 | AAPL | Stock | 11.8421 | 11.8429 | 11.8368 | 11.8368 | 92400.0 |
| 2011-05-23 08:25:00 | AAPL | Stock | 11.8393 | 11.8393 | 11.8271 | 11.83 | 193312.0 |
| 2011-05-23 08:30:00 | AAPL | Stock | 11.83 | 11.8311 | 11.8214 | 11.8311 | 221424.0 |
| 2011-05-23 08:35:00 | AAPL | Stock | 11.8304 | 11.8393 | 11.8304 | 11.8329 | 139272.0 |
| 2011-05-23 08:40:00 | AAPL | Stock | 11.8332 | 11.8375 | 11.8268 | 11.8375 | 124152.0 |
| 2011-05-23 08:45:00 | AAPL | Stock | 11.8304 | 11.8321 | 11.8218 | 11.8321 | 134120.0 |
| 2011-05-23 08:50:00 | AAPL | Stock | 11.8289 | 11.8343 | 11.8214 | 11.8343 | 122808.0 |
| 2011-05-23 08:55:00 | AAPL | Stock | 11.8304 | 11.8346 | 11.8304 | 11.8346 | 73668.0 |
| 2011-05-23 09:00:00 | AAPL | Stock | 11.8329 | 11.8329 | 11.8214 | 11.8214 | 55132.0 |
| 2011-05-23 09:05:00 | AAPL | Stock | 11.8246 | 11.8318 | 11.8214 | 11.8304 | 182980.0 |
| 2011-05-23 09:10:00 | AAPL | Stock | 11.83 | 11.83 | 11.8125 | 11.8146 | 341292.0 |
| 2011-05-23 09:15:00 | AAPL | Stock | 11.8143 | 11.8207 | 11.8143 | 11.8171 | 98728.0 |
| 2011-05-23 09:20:00 | AAPL | Stock | 11.8171 | 11.82 | 11.8118 | 11.8125 | 220752.0 |
| 2011-05-23 09:25:00 | AAPL | Stock | 11.8125 | 11.8157 | 11.78 | 11.7839 | 1184848.0 |
| 2011-05-23 09:30:00 | AAPL | Stock | 11.7846 | 11.8266 | 11.7768 | 11.7943 | 28107464.0 |
| 2011-05-23 09:35:00 | AAPL | Stock | 11.7932 | 11.8107 | 11.765 | 11.803 | 14906024.0 |
| 2011-05-23 09:40:00 | AAPL | Stock | 11.8029 | 11.8679 | 11.8 | 11.8329 | 15584772.0 |
| 2011-05-23 09:45:00 | AAPL | Stock | 11.8336 | 11.8543 | 11.8282 | 11.8393 | 6896484.0 |
| 2011-05-23 09:50:00 | AAPL | Stock | 11.8386 | 11.8414 | 11.8071 | 11.8176 | 8059156.0 |
> showing 50 of 332,969 rows — these rows as CSV