PREVIEW / stock_5min / 2013-04-04
file: by_date/stock_5min/2013/2013-04-04.parquet size: 4.9 MB rows: 326,668 symbols: 3,454
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 |
|---|---|---|---|---|---|---|---|
| 2013-04-04 04:00:00 | AAPL | Stock | 15.4893 | 15.4893 | 15.4893 | 15.4893 | 8400.0 |
| 2013-04-04 05:20:00 | AAPL | Stock | 15.5 | 15.5 | 15.5 | 15.5 | 5600.0 |
| 2013-04-04 06:20:00 | AAPL | Stock | 15.5336 | 15.5336 | 15.5268 | 15.5268 | 16688.0 |
| 2013-04-04 06:30:00 | AAPL | Stock | 15.5357 | 15.5357 | 15.5357 | 15.5357 | 5600.0 |
| 2013-04-04 06:50:00 | AAPL | Stock | 15.5343 | 15.5343 | 15.5343 | 15.5343 | 8400.0 |
| 2013-04-04 07:00:00 | AAPL | Stock | 15.5325 | 15.5325 | 15.5325 | 15.5325 | 7000.0 |
| 2013-04-04 07:05:00 | AAPL | Stock | 15.5357 | 15.5475 | 15.5354 | 15.5475 | 23996.0 |
| 2013-04-04 07:10:00 | AAPL | Stock | 15.5496 | 15.55 | 15.5496 | 15.55 | 30660.0 |
| 2013-04-04 07:15:00 | AAPL | Stock | 15.5536 | 15.5625 | 15.5375 | 15.5375 | 64400.0 |
| 2013-04-04 07:25:00 | AAPL | Stock | 15.5511 | 15.5607 | 15.5511 | 15.5607 | 30436.0 |
| 2013-04-04 07:30:00 | AAPL | Stock | 15.5571 | 15.5571 | 15.5571 | 15.5571 | 2800.0 |
| 2013-04-04 07:35:00 | AAPL | Stock | 15.5536 | 15.5536 | 15.55 | 15.5536 | 27748.0 |
| 2013-04-04 07:40:00 | AAPL | Stock | 15.5321 | 15.55 | 15.5321 | 15.55 | 11648.0 |
| 2013-04-04 07:45:00 | AAPL | Stock | 15.5429 | 15.5429 | 15.5289 | 15.5354 | 21196.0 |
| 2013-04-04 07:50:00 | AAPL | Stock | 15.525 | 15.5271 | 15.525 | 15.5271 | 17360.0 |
| 2013-04-04 07:55:00 | AAPL | Stock | 15.5271 | 15.5271 | 15.5182 | 15.5182 | 19600.0 |
| 2013-04-04 08:00:00 | AAPL | Stock | 15.5343 | 15.5607 | 15.5125 | 15.5143 | 298116.0 |
| 2013-04-04 08:05:00 | AAPL | Stock | 15.5132 | 15.5139 | 15.3929 | 15.4768 | 228284.0 |
| 2013-04-04 08:10:00 | AAPL | Stock | 15.4857 | 15.5079 | 15.485 | 15.4993 | 93212.0 |
| 2013-04-04 08:15:00 | AAPL | Stock | 15.4911 | 15.5004 | 15.485 | 15.5004 | 44156.0 |
| 2013-04-04 08:20:00 | AAPL | Stock | 15.5004 | 15.5004 | 15.4946 | 15.4946 | 28000.0 |
| 2013-04-04 08:25:00 | AAPL | Stock | 15.5 | 15.5232 | 15.4954 | 15.5232 | 221144.0 |
| 2013-04-04 08:30:00 | AAPL | Stock | 15.5186 | 15.5186 | 15.4425 | 15.4807 | 370216.0 |
| 2013-04-04 08:35:00 | AAPL | Stock | 15.4764 | 15.4789 | 15.45 | 15.4643 | 142240.0 |
| 2013-04-04 08:40:00 | AAPL | Stock | 15.4654 | 15.4786 | 15.4571 | 15.4607 | 116984.0 |
| 2013-04-04 08:45:00 | AAPL | Stock | 15.45 | 15.4571 | 15.4289 | 15.4289 | 297304.0 |
| 2013-04-04 08:50:00 | AAPL | Stock | 15.4357 | 15.45 | 15.4232 | 15.4429 | 172172.0 |
| 2013-04-04 08:55:00 | AAPL | Stock | 15.4375 | 15.4375 | 15.4143 | 15.4161 | 223496.0 |
| 2013-04-04 09:00:00 | AAPL | Stock | 15.4268 | 15.4446 | 15.4236 | 15.4446 | 85288.0 |
| 2013-04-04 09:05:00 | AAPL | Stock | 15.4446 | 15.4536 | 15.4411 | 15.4536 | 92736.0 |
| 2013-04-04 09:10:00 | AAPL | Stock | 15.4536 | 15.4779 | 15.4486 | 15.4779 | 305704.0 |
| 2013-04-04 09:15:00 | AAPL | Stock | 15.4679 | 15.4857 | 15.4661 | 15.4768 | 101220.0 |
| 2013-04-04 09:20:00 | AAPL | Stock | 15.4821 | 15.4857 | 15.4729 | 15.4857 | 671776.0 |
| 2013-04-04 09:25:00 | AAPL | Stock | 15.4736 | 15.4961 | 15.4736 | 15.4914 | 174888.0 |
| 2013-04-04 09:30:00 | AAPL | Stock | 15.49 | 15.5357 | 15.4014 | 15.4025 | 14022988.0 |
| 2013-04-04 09:35:00 | AAPL | Stock | 15.4021 | 15.4061 | 15.2968 | 15.3193 | 17573276.0 |
| 2013-04-04 09:40:00 | AAPL | Stock | 15.3218 | 15.4139 | 15.3036 | 15.3191 | 15112328.0 |
| 2013-04-04 09:45:00 | AAPL | Stock | 15.3164 | 15.3543 | 15.2793 | 15.3346 | 11733652.0 |
| 2013-04-04 09:50:00 | AAPL | Stock | 15.3371 | 15.3389 | 15.2729 | 15.3104 | 8201704.0 |
| 2013-04-04 09:55:00 | AAPL | Stock | 15.3096 | 15.3275 | 15.2911 | 15.3071 | 5092864.0 |
| 2013-04-04 10:00:00 | AAPL | Stock | 15.3161 | 15.3825 | 15.3079 | 15.3471 | 9006088.0 |
| 2013-04-04 10:05:00 | AAPL | Stock | 15.3514 | 15.4004 | 15.3157 | 15.3521 | 6999076.0 |
| 2013-04-04 10:10:00 | AAPL | Stock | 15.3532 | 15.3532 | 15.3175 | 15.3419 | 7096068.0 |
| 2013-04-04 10:15:00 | AAPL | Stock | 15.3461 | 15.3461 | 15.2929 | 15.2932 | 5233480.0 |
| 2013-04-04 10:20:00 | AAPL | Stock | 15.2944 | 15.3096 | 15.2754 | 15.2932 | 6354964.0 |
| 2013-04-04 10:25:00 | AAPL | Stock | 15.2921 | 15.3035 | 15.2556 | 15.2764 | 6525960.0 |
| 2013-04-04 10:30:00 | AAPL | Stock | 15.2761 | 15.3061 | 15.2707 | 15.3017 | 5413352.0 |
| 2013-04-04 10:35:00 | AAPL | Stock | 15.2996 | 15.3129 | 15.2857 | 15.2925 | 6273792.0 |
| 2013-04-04 10:40:00 | AAPL | Stock | 15.2979 | 15.3311 | 15.2925 | 15.2993 | 4231948.0 |
| 2013-04-04 10:45:00 | AAPL | Stock | 15.2966 | 15.3325 | 15.2857 | 15.3266 | 3373412.0 |
> showing 50 of 326,668 rows — these rows as CSV