PREVIEW / stock_5min / 2012-10-10
file: by_date/stock_5min/2012/2012-10-10.parquet size: 4.6 MB rows: 312,295 symbols: 3,474
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-10-10 04:05:00 | AAPL | Stock | 22.8171 | 22.8171 | 22.8171 | 22.8171 | 6412.0 |
| 2012-10-10 04:10:00 | AAPL | Stock | 22.8214 | 22.8214 | 22.8214 | 22.8214 | 67760.0 |
| 2012-10-10 04:25:00 | AAPL | Stock | 22.8214 | 22.8214 | 22.8214 | 22.8214 | 2800.0 |
| 2012-10-10 04:45:00 | AAPL | Stock | 22.8071 | 22.8071 | 22.8071 | 22.8071 | 2800.0 |
| 2012-10-10 05:05:00 | AAPL | Stock | 22.8039 | 22.8039 | 22.7946 | 22.7946 | 14336.0 |
| 2012-10-10 05:40:00 | AAPL | Stock | 22.7929 | 22.7929 | 22.7929 | 22.7929 | 4200.0 |
| 2012-10-10 05:45:00 | AAPL | Stock | 22.7857 | 22.7857 | 22.6914 | 22.6914 | 29400.0 |
| 2012-10-10 05:50:00 | AAPL | Stock | 22.6914 | 22.7286 | 22.6911 | 22.7286 | 78820.0 |
| 2012-10-10 05:55:00 | AAPL | Stock | 22.7286 | 22.7286 | 22.7143 | 22.7143 | 22232.0 |
| 2012-10-10 06:00:00 | AAPL | Stock | 22.7071 | 22.7107 | 22.7071 | 22.7107 | 40040.0 |
| 2012-10-10 06:05:00 | AAPL | Stock | 22.7143 | 22.7143 | 22.7143 | 22.7143 | 2800.0 |
| 2012-10-10 06:15:00 | AAPL | Stock | 22.7071 | 22.7071 | 22.7071 | 22.7071 | 14000.0 |
| 2012-10-10 06:20:00 | AAPL | Stock | 22.7139 | 22.7179 | 22.7139 | 22.7179 | 18368.0 |
| 2012-10-10 06:40:00 | AAPL | Stock | 22.7286 | 22.7286 | 22.7286 | 22.7286 | 2800.0 |
| 2012-10-10 07:00:00 | AAPL | Stock | 22.7232 | 22.7232 | 22.7179 | 22.7179 | 12068.0 |
| 2012-10-10 07:05:00 | AAPL | Stock | 22.7321 | 22.7321 | 22.7321 | 22.7321 | 22400.0 |
| 2012-10-10 07:10:00 | AAPL | Stock | 22.7446 | 22.7461 | 22.7379 | 22.7379 | 116200.0 |
| 2012-10-10 07:15:00 | AAPL | Stock | 22.7382 | 22.7386 | 22.7379 | 22.7379 | 62468.0 |
| 2012-10-10 07:20:00 | AAPL | Stock | 22.7407 | 22.7511 | 22.7407 | 22.7511 | 16800.0 |
| 2012-10-10 07:25:00 | AAPL | Stock | 22.7571 | 22.7643 | 22.7571 | 22.7571 | 53704.0 |
| 2012-10-10 07:30:00 | AAPL | Stock | 22.7643 | 22.7643 | 22.7643 | 22.7643 | 2940.0 |
| 2012-10-10 07:35:00 | AAPL | Stock | 22.7639 | 22.8207 | 22.7639 | 22.7929 | 255052.0 |
| 2012-10-10 07:40:00 | AAPL | Stock | 22.7939 | 22.8125 | 22.7861 | 22.7914 | 113456.0 |
| 2012-10-10 07:45:00 | AAPL | Stock | 22.8 | 22.8 | 22.7814 | 22.7925 | 72800.0 |
| 2012-10-10 07:50:00 | AAPL | Stock | 22.7939 | 22.8321 | 22.7936 | 22.83 | 480452.0 |
| 2012-10-10 07:55:00 | AAPL | Stock | 22.825 | 22.8318 | 22.8214 | 22.8214 | 61600.0 |
| 2012-10-10 08:00:00 | AAPL | Stock | 22.8311 | 22.8393 | 22.7857 | 22.7893 | 645344.0 |
| 2012-10-10 08:05:00 | AAPL | Stock | 22.7857 | 22.8207 | 22.7839 | 22.8136 | 145432.0 |
| 2012-10-10 08:10:00 | AAPL | Stock | 22.8125 | 22.8279 | 22.7971 | 22.8143 | 209020.0 |
| 2012-10-10 08:15:00 | AAPL | Stock | 22.8171 | 22.8214 | 22.8054 | 22.8214 | 279356.0 |
| 2012-10-10 08:20:00 | AAPL | Stock | 22.8218 | 22.855 | 22.8218 | 22.8393 | 396004.0 |
| 2012-10-10 08:25:00 | AAPL | Stock | 22.8468 | 22.8482 | 22.8204 | 22.8214 | 296604.0 |
| 2012-10-10 08:30:00 | AAPL | Stock | 22.8107 | 22.8179 | 22.7954 | 22.8054 | 131292.0 |
| 2012-10-10 08:35:00 | AAPL | Stock | 22.7964 | 22.8014 | 22.7786 | 22.7825 | 146048.0 |
| 2012-10-10 08:40:00 | AAPL | Stock | 22.7786 | 22.7789 | 22.7607 | 22.7643 | 154756.0 |
| 2012-10-10 08:45:00 | AAPL | Stock | 22.7614 | 22.7857 | 22.7557 | 22.7857 | 89096.0 |
| 2012-10-10 08:50:00 | AAPL | Stock | 22.7793 | 22.7911 | 22.775 | 22.7864 | 71932.0 |
| 2012-10-10 08:55:00 | AAPL | Stock | 22.7861 | 22.8 | 22.7861 | 22.7904 | 119000.0 |
| 2012-10-10 09:00:00 | AAPL | Stock | 22.7904 | 22.7939 | 22.7857 | 22.7939 | 54600.0 |
| 2012-10-10 09:05:00 | AAPL | Stock | 22.7904 | 22.8032 | 22.7904 | 22.8032 | 44464.0 |
| 2012-10-10 09:10:00 | AAPL | Stock | 22.8032 | 22.8036 | 22.7911 | 22.7946 | 130088.0 |
| 2012-10-10 09:15:00 | AAPL | Stock | 22.79 | 22.7943 | 22.7821 | 22.7943 | 114800.0 |
| 2012-10-10 09:20:00 | AAPL | Stock | 22.7939 | 22.8061 | 22.7861 | 22.7943 | 172704.0 |
| 2012-10-10 09:25:00 | AAPL | Stock | 22.7971 | 22.8489 | 22.7964 | 22.8482 | 887712.0 |
| 2012-10-10 09:30:00 | AAPL | Stock | 22.8482 | 22.9011 | 22.8036 | 22.8507 | 25513068.0 |
| 2012-10-10 09:35:00 | AAPL | Stock | 22.8423 | 22.85 | 22.7696 | 22.7761 | 15838480.0 |
| 2012-10-10 09:40:00 | AAPL | Stock | 22.7732 | 22.8571 | 22.75 | 22.8393 | 12201252.0 |
| 2012-10-10 09:45:00 | AAPL | Stock | 22.8393 | 22.9482 | 22.8136 | 22.9482 | 16508296.0 |
| 2012-10-10 09:50:00 | AAPL | Stock | 22.945 | 22.9489 | 22.8504 | 22.8657 | 14172424.0 |
| 2012-10-10 09:55:00 | AAPL | Stock | 22.8646 | 22.8657 | 22.7614 | 22.835 | 13837796.0 |
> showing 50 of 312,295 rows — these rows as CSV