PREVIEW / stock_5min / 2012-09-24
file: by_date/stock_5min/2012/2012-09-24.parquet size: 4.9 MB rows: 329,142 symbols: 3,479
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-09-24 04:00:00 | AAPL | Stock | 24.9964 | 24.9964 | 24.9375 | 24.9375 | 23912.0 |
| 2012-09-24 04:20:00 | AAPL | Stock | 24.9561 | 24.9561 | 24.9375 | 24.9375 | 19600.0 |
| 2012-09-24 04:25:00 | AAPL | Stock | 24.9375 | 24.9375 | 24.9375 | 24.9375 | 5600.0 |
| 2012-09-24 04:30:00 | AAPL | Stock | 24.9464 | 24.9464 | 24.9464 | 24.9464 | 2800.0 |
| 2012-09-24 04:40:00 | AAPL | Stock | 24.9304 | 24.9304 | 24.9286 | 24.9286 | 14000.0 |
| 2012-09-24 05:00:00 | AAPL | Stock | 24.9357 | 24.9357 | 24.9357 | 24.9357 | 2800.0 |
| 2012-09-24 05:05:00 | AAPL | Stock | 24.9446 | 24.9446 | 24.8929 | 24.8929 | 16436.0 |
| 2012-09-24 05:20:00 | AAPL | Stock | 24.8893 | 24.8893 | 24.8893 | 24.8893 | 2800.0 |
| 2012-09-24 05:50:00 | AAPL | Stock | 24.8768 | 24.8768 | 24.8768 | 24.8768 | 2800.0 |
| 2012-09-24 05:55:00 | AAPL | Stock | 24.8929 | 24.8929 | 24.8929 | 24.8929 | 3976.0 |
| 2012-09-24 06:50:00 | AAPL | Stock | 24.8921 | 24.8921 | 24.8921 | 24.8921 | 2800.0 |
| 2012-09-24 06:55:00 | AAPL | Stock | 24.8929 | 24.8929 | 24.875 | 24.875 | 16800.0 |
| 2012-09-24 07:00:00 | AAPL | Stock | 24.8446 | 24.875 | 24.8218 | 24.8393 | 75880.0 |
| 2012-09-24 07:05:00 | AAPL | Stock | 24.8393 | 24.8393 | 24.8114 | 24.8393 | 93016.0 |
| 2012-09-24 07:10:00 | AAPL | Stock | 24.8393 | 24.8393 | 24.8214 | 24.8321 | 65380.0 |
| 2012-09-24 07:15:00 | AAPL | Stock | 24.8375 | 24.8389 | 24.8339 | 24.8371 | 49840.0 |
| 2012-09-24 07:20:00 | AAPL | Stock | 24.8393 | 24.8393 | 24.8214 | 24.8214 | 49392.0 |
| 2012-09-24 07:25:00 | AAPL | Stock | 24.8214 | 24.8304 | 24.8125 | 24.8125 | 100968.0 |
| 2012-09-24 07:30:00 | AAPL | Stock | 24.8211 | 24.8304 | 24.8179 | 24.8214 | 145852.0 |
| 2012-09-24 07:35:00 | AAPL | Stock | 24.8214 | 24.8325 | 24.8214 | 24.8325 | 75628.0 |
| 2012-09-24 07:40:00 | AAPL | Stock | 24.8325 | 24.8457 | 24.8304 | 24.8457 | 112028.0 |
| 2012-09-24 07:45:00 | AAPL | Stock | 24.8468 | 24.8482 | 24.8314 | 24.8379 | 68600.0 |
| 2012-09-24 07:50:00 | AAPL | Stock | 24.8379 | 24.8411 | 24.8379 | 24.8386 | 8400.0 |
| 2012-09-24 07:55:00 | AAPL | Stock | 24.8357 | 24.8361 | 24.8211 | 24.825 | 117264.0 |
| 2012-09-24 08:00:00 | AAPL | Stock | 24.825 | 24.8486 | 24.8214 | 24.8289 | 392476.0 |
| 2012-09-24 08:05:00 | AAPL | Stock | 24.8286 | 24.8304 | 24.8211 | 24.8232 | 308224.0 |
| 2012-09-24 08:10:00 | AAPL | Stock | 24.825 | 24.8382 | 24.825 | 24.8382 | 88032.0 |
| 2012-09-24 08:15:00 | AAPL | Stock | 24.8368 | 24.8571 | 24.8332 | 24.8504 | 217392.0 |
| 2012-09-24 08:20:00 | AAPL | Stock | 24.8536 | 24.8571 | 24.8429 | 24.8482 | 151088.0 |
| 2012-09-24 08:25:00 | AAPL | Stock | 24.8482 | 24.8486 | 24.84 | 24.8486 | 127484.0 |
| 2012-09-24 08:30:00 | AAPL | Stock | 24.8486 | 24.8486 | 24.4082 | 24.4286 | 4840388.0 |
| 2012-09-24 08:35:00 | AAPL | Stock | 24.4304 | 24.5132 | 24.3525 | 24.4518 | 3136616.0 |
| 2012-09-24 08:40:00 | AAPL | Stock | 24.4607 | 24.5632 | 24.4607 | 24.5357 | 2228856.0 |
| 2012-09-24 08:45:00 | AAPL | Stock | 24.5446 | 24.5714 | 24.5207 | 24.5211 | 1847384.0 |
| 2012-09-24 08:50:00 | AAPL | Stock | 24.525 | 24.5286 | 24.4821 | 24.4821 | 1108576.0 |
| 2012-09-24 08:55:00 | AAPL | Stock | 24.4821 | 24.5089 | 24.4464 | 24.4464 | 1894816.0 |
| 2012-09-24 09:00:00 | AAPL | Stock | 24.4461 | 24.4461 | 24.3586 | 24.4143 | 2443812.0 |
| 2012-09-24 09:05:00 | AAPL | Stock | 24.4107 | 24.4821 | 24.4107 | 24.4821 | 1576204.0 |
| 2012-09-24 09:10:00 | AAPL | Stock | 24.4832 | 24.5064 | 24.4643 | 24.4946 | 1212848.0 |
| 2012-09-24 09:15:00 | AAPL | Stock | 24.4904 | 24.5357 | 24.4518 | 24.4568 | 1948800.0 |
| 2012-09-24 09:20:00 | AAPL | Stock | 24.4568 | 24.4964 | 24.4414 | 24.4911 | 1193920.0 |
| 2012-09-24 09:25:00 | AAPL | Stock | 24.4821 | 24.5379 | 24.4657 | 24.5268 | 1696016.0 |
| 2012-09-24 09:30:00 | AAPL | Stock | 24.5307 | 24.6184 | 24.3929 | 24.6125 | 39989880.0 |
| 2012-09-24 09:35:00 | AAPL | Stock | 24.6139 | 24.7143 | 24.5725 | 24.7032 | 27126484.0 |
| 2012-09-24 09:40:00 | AAPL | Stock | 24.7032 | 24.7171 | 24.6309 | 24.6893 | 22627752.0 |
| 2012-09-24 09:45:00 | AAPL | Stock | 24.6893 | 24.7661 | 24.6561 | 24.7293 | 21757120.0 |
| 2012-09-24 09:50:00 | AAPL | Stock | 24.7279 | 24.8193 | 24.7279 | 24.7414 | 19156396.0 |
| 2012-09-24 09:55:00 | AAPL | Stock | 24.7416 | 24.7857 | 24.7304 | 24.7646 | 10444588.0 |
| 2012-09-24 10:00:00 | AAPL | Stock | 24.7654 | 24.8257 | 24.7468 | 24.7793 | 11893812.0 |
| 2012-09-24 10:05:00 | AAPL | Stock | 24.7793 | 24.7879 | 24.74 | 24.7427 | 8729644.0 |
> showing 50 of 329,142 rows — these rows as CSV