PREVIEW / stock_5min / 2012-05-23
file: by_date/stock_5min/2012/2012-05-23.parquet size: 4.9 MB rows: 333,114 symbols: 3,533
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-05-23 04:10:00 | AAPL | Stock | 19.7929 | 19.8304 | 19.7929 | 19.83 | 19600.0 |
| 2012-05-23 04:20:00 | AAPL | Stock | 19.8175 | 19.8175 | 19.7929 | 19.7929 | 9800.0 |
| 2012-05-23 04:25:00 | AAPL | Stock | 19.7571 | 19.7571 | 19.7571 | 19.7571 | 2800.0 |
| 2012-05-23 04:30:00 | AAPL | Stock | 19.7504 | 19.7504 | 19.7504 | 19.7504 | 2800.0 |
| 2012-05-23 04:45:00 | AAPL | Stock | 19.75 | 19.75 | 19.75 | 19.75 | 3500.0 |
| 2012-05-23 05:15:00 | AAPL | Stock | 19.8036 | 19.8036 | 19.8036 | 19.8036 | 2800.0 |
| 2012-05-23 05:20:00 | AAPL | Stock | 19.7504 | 19.7504 | 19.7504 | 19.7504 | 14000.0 |
| 2012-05-23 05:55:00 | AAPL | Stock | 19.75 | 19.75 | 19.75 | 19.75 | 2800.0 |
| 2012-05-23 06:00:00 | AAPL | Stock | 19.7404 | 19.7404 | 19.7404 | 19.7404 | 2800.0 |
| 2012-05-23 06:10:00 | AAPL | Stock | 19.7379 | 19.7379 | 19.7379 | 19.7379 | 5600.0 |
| 2012-05-23 06:15:00 | AAPL | Stock | 19.7257 | 19.75 | 19.7257 | 19.7429 | 11060.0 |
| 2012-05-23 06:45:00 | AAPL | Stock | 19.7375 | 19.7375 | 19.7375 | 19.7375 | 14000.0 |
| 2012-05-23 06:50:00 | AAPL | Stock | 19.7375 | 19.7375 | 19.7375 | 19.7375 | 2800.0 |
| 2012-05-23 07:00:00 | AAPL | Stock | 19.7429 | 19.7679 | 19.7429 | 19.7679 | 11508.0 |
| 2012-05-23 07:05:00 | AAPL | Stock | 19.7821 | 19.7821 | 19.7821 | 19.7821 | 2800.0 |
| 2012-05-23 07:10:00 | AAPL | Stock | 19.7786 | 19.7946 | 19.7786 | 19.7946 | 11200.0 |
| 2012-05-23 07:15:00 | AAPL | Stock | 19.7943 | 19.7946 | 19.7786 | 19.7786 | 37380.0 |
| 2012-05-23 07:20:00 | AAPL | Stock | 19.775 | 19.775 | 19.7696 | 19.7696 | 19012.0 |
| 2012-05-23 07:25:00 | AAPL | Stock | 19.7821 | 19.7893 | 19.7714 | 19.7714 | 48580.0 |
| 2012-05-23 07:30:00 | AAPL | Stock | 19.7696 | 19.7786 | 19.7625 | 19.7625 | 30800.0 |
| 2012-05-23 07:35:00 | AAPL | Stock | 19.7625 | 19.775 | 19.7614 | 19.7661 | 156968.0 |
| 2012-05-23 07:40:00 | AAPL | Stock | 19.7689 | 19.7889 | 19.7689 | 19.7889 | 32928.0 |
| 2012-05-23 07:45:00 | AAPL | Stock | 19.7875 | 19.8171 | 19.7857 | 19.8036 | 80780.0 |
| 2012-05-23 07:50:00 | AAPL | Stock | 19.8036 | 19.8036 | 19.8036 | 19.8036 | 15176.0 |
| 2012-05-23 07:55:00 | AAPL | Stock | 19.8014 | 19.8357 | 19.7964 | 19.8286 | 92400.0 |
| 2012-05-23 08:00:00 | AAPL | Stock | 19.8282 | 19.8414 | 19.7679 | 19.7821 | 503328.0 |
| 2012-05-23 08:05:00 | AAPL | Stock | 19.7821 | 19.8004 | 19.7821 | 19.7929 | 86660.0 |
| 2012-05-23 08:10:00 | AAPL | Stock | 19.7896 | 19.7932 | 19.7775 | 19.7786 | 72688.0 |
| 2012-05-23 08:15:00 | AAPL | Stock | 19.7764 | 19.7764 | 19.7343 | 19.7375 | 213360.0 |
| 2012-05-23 08:20:00 | AAPL | Stock | 19.7382 | 19.7529 | 19.7218 | 19.7529 | 116340.0 |
| 2012-05-23 08:25:00 | AAPL | Stock | 19.7429 | 19.7764 | 19.7429 | 19.7693 | 71960.0 |
| 2012-05-23 08:30:00 | AAPL | Stock | 19.7768 | 19.7768 | 19.7464 | 19.7689 | 122696.0 |
| 2012-05-23 08:35:00 | AAPL | Stock | 19.7679 | 19.7943 | 19.7679 | 19.7761 | 124292.0 |
| 2012-05-23 08:40:00 | AAPL | Stock | 19.7946 | 19.8036 | 19.7868 | 19.8036 | 101640.0 |
| 2012-05-23 08:45:00 | AAPL | Stock | 19.8014 | 19.8029 | 19.7875 | 19.7914 | 106428.0 |
| 2012-05-23 08:50:00 | AAPL | Stock | 19.8 | 19.8646 | 19.8 | 19.8496 | 368088.0 |
| 2012-05-23 08:55:00 | AAPL | Stock | 19.8539 | 19.8929 | 19.8536 | 19.8711 | 381024.0 |
| 2012-05-23 09:00:00 | AAPL | Stock | 19.8711 | 19.8761 | 19.8443 | 19.8761 | 439656.0 |
| 2012-05-23 09:05:00 | AAPL | Stock | 19.8757 | 19.9261 | 19.875 | 19.9171 | 717080.0 |
| 2012-05-23 09:10:00 | AAPL | Stock | 19.9161 | 19.9464 | 19.9111 | 19.9146 | 550928.0 |
| 2012-05-23 09:15:00 | AAPL | Stock | 19.9111 | 19.9182 | 19.8929 | 19.9096 | 480424.0 |
| 2012-05-23 09:20:00 | AAPL | Stock | 19.9021 | 19.9082 | 19.8893 | 19.8893 | 163856.0 |
| 2012-05-23 09:25:00 | AAPL | Stock | 19.8911 | 19.9232 | 19.8864 | 19.9086 | 614068.0 |
| 2012-05-23 09:30:00 | AAPL | Stock | 19.9089 | 20.0493 | 19.875 | 19.9932 | 22307964.0 |
| 2012-05-23 09:35:00 | AAPL | Stock | 19.9911 | 19.9932 | 19.8439 | 19.895 | 15249444.0 |
| 2012-05-23 09:40:00 | AAPL | Stock | 19.8939 | 19.9046 | 19.79 | 19.8157 | 10824240.0 |
| 2012-05-23 09:45:00 | AAPL | Stock | 19.8175 | 19.8836 | 19.7582 | 19.8111 | 11781784.0 |
| 2012-05-23 09:50:00 | AAPL | Stock | 19.8157 | 19.8696 | 19.7832 | 19.8614 | 6917008.0 |
| 2012-05-23 09:55:00 | AAPL | Stock | 19.8611 | 20.0357 | 19.8432 | 19.9611 | 18688600.0 |
| 2012-05-23 10:00:00 | AAPL | Stock | 19.9604 | 20.0089 | 19.8964 | 19.9229 | 14057316.0 |
> showing 50 of 333,114 rows — these rows as CSV