PREVIEW / stock_5min / 2012-04-12
file: by_date/stock_5min/2012/2012-04-12.parquet size: 4.8 MB rows: 326,633 symbols: 3,515
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-04-12 04:00:00 | AAPL | Stock | 22.4643 | 22.4643 | 22.4643 | 22.4643 | 5600.0 |
| 2012-04-12 04:05:00 | AAPL | Stock | 22.445 | 22.445 | 22.445 | 22.445 | 11200.0 |
| 2012-04-12 04:10:00 | AAPL | Stock | 22.3968 | 22.3968 | 22.3964 | 22.3964 | 11200.0 |
| 2012-04-12 04:30:00 | AAPL | Stock | 22.4282 | 22.4286 | 22.4196 | 22.4196 | 57400.0 |
| 2012-04-12 04:35:00 | AAPL | Stock | 22.4282 | 22.4286 | 22.4282 | 22.4286 | 11200.0 |
| 2012-04-12 04:50:00 | AAPL | Stock | 22.4214 | 22.4214 | 22.4214 | 22.4214 | 11200.0 |
| 2012-04-12 05:05:00 | AAPL | Stock | 22.4214 | 22.4214 | 22.4179 | 22.4179 | 5600.0 |
| 2012-04-12 05:10:00 | AAPL | Stock | 22.4018 | 22.4282 | 22.4018 | 22.4282 | 19600.0 |
| 2012-04-12 05:15:00 | AAPL | Stock | 22.4018 | 22.4282 | 22.4018 | 22.4282 | 14000.0 |
| 2012-04-12 05:25:00 | AAPL | Stock | 22.3968 | 22.3968 | 22.3968 | 22.3968 | 2800.0 |
| 2012-04-12 05:30:00 | AAPL | Stock | 22.3968 | 22.3968 | 22.3968 | 22.3968 | 8400.0 |
| 2012-04-12 05:40:00 | AAPL | Stock | 22.4325 | 22.4332 | 22.4325 | 22.4332 | 8400.0 |
| 2012-04-12 06:10:00 | AAPL | Stock | 22.4089 | 22.4089 | 22.4089 | 22.4089 | 8400.0 |
| 2012-04-12 06:25:00 | AAPL | Stock | 22.41 | 22.41 | 22.41 | 22.41 | 2800.0 |
| 2012-04-12 06:35:00 | AAPL | Stock | 22.4375 | 22.4375 | 22.4289 | 22.4289 | 5600.0 |
| 2012-04-12 06:40:00 | AAPL | Stock | 22.4464 | 22.4464 | 22.4464 | 22.4464 | 8400.0 |
| 2012-04-12 06:45:00 | AAPL | Stock | 22.4464 | 22.4464 | 22.4464 | 22.4464 | 2800.0 |
| 2012-04-12 06:50:00 | AAPL | Stock | 22.45 | 22.45 | 22.45 | 22.45 | 2800.0 |
| 2012-04-12 07:00:00 | AAPL | Stock | 22.4429 | 22.4621 | 22.4429 | 22.4482 | 36568.0 |
| 2012-04-12 07:05:00 | AAPL | Stock | 22.4429 | 22.4436 | 22.3964 | 22.4089 | 83160.0 |
| 2012-04-12 07:10:00 | AAPL | Stock | 22.4089 | 22.4411 | 22.4089 | 22.4411 | 50400.0 |
| 2012-04-12 07:15:00 | AAPL | Stock | 22.4196 | 22.4196 | 22.4107 | 22.4107 | 16800.0 |
| 2012-04-12 07:20:00 | AAPL | Stock | 22.4179 | 22.4179 | 22.375 | 22.4068 | 114380.0 |
| 2012-04-12 07:25:00 | AAPL | Stock | 22.3929 | 22.4304 | 22.3907 | 22.4089 | 69132.0 |
| 2012-04-12 07:30:00 | AAPL | Stock | 22.4339 | 22.4371 | 22.4336 | 22.4371 | 22400.0 |
| 2012-04-12 07:35:00 | AAPL | Stock | 22.4357 | 22.4464 | 22.4357 | 22.4464 | 91560.0 |
| 2012-04-12 07:40:00 | AAPL | Stock | 22.4554 | 22.4621 | 22.4482 | 22.4532 | 38808.0 |
| 2012-04-12 07:45:00 | AAPL | Stock | 22.4468 | 22.4468 | 22.4411 | 22.4411 | 5600.0 |
| 2012-04-12 07:50:00 | AAPL | Stock | 22.4621 | 22.4714 | 22.4618 | 22.4618 | 65548.0 |
| 2012-04-12 07:55:00 | AAPL | Stock | 22.4643 | 22.4857 | 22.4643 | 22.4732 | 153160.0 |
| 2012-04-12 08:00:00 | AAPL | Stock | 22.4786 | 22.4964 | 22.4282 | 22.4643 | 501788.0 |
| 2012-04-12 08:05:00 | AAPL | Stock | 22.4589 | 22.4643 | 22.45 | 22.4561 | 226240.0 |
| 2012-04-12 08:10:00 | AAPL | Stock | 22.4464 | 22.4518 | 22.4375 | 22.4375 | 108640.0 |
| 2012-04-12 08:15:00 | AAPL | Stock | 22.4375 | 22.4454 | 22.3929 | 22.4043 | 367024.0 |
| 2012-04-12 08:20:00 | AAPL | Stock | 22.3986 | 22.4143 | 22.3889 | 22.3939 | 366156.0 |
| 2012-04-12 08:25:00 | AAPL | Stock | 22.3979 | 22.4229 | 22.3971 | 22.4054 | 234920.0 |
| 2012-04-12 08:30:00 | AAPL | Stock | 22.4086 | 22.4086 | 22.35 | 22.35 | 848092.0 |
| 2012-04-12 08:35:00 | AAPL | Stock | 22.3504 | 22.36 | 22.2218 | 22.2589 | 1279460.0 |
| 2012-04-12 08:40:00 | AAPL | Stock | 22.2596 | 22.2836 | 22.2414 | 22.2771 | 633052.0 |
| 2012-04-12 08:45:00 | AAPL | Stock | 22.2711 | 22.2961 | 22.2554 | 22.2789 | 484036.0 |
| 2012-04-12 08:50:00 | AAPL | Stock | 22.2904 | 22.3125 | 22.2821 | 22.3036 | 158620.0 |
| 2012-04-12 08:55:00 | AAPL | Stock | 22.2946 | 22.2982 | 22.2686 | 22.2971 | 294840.0 |
| 2012-04-12 09:00:00 | AAPL | Stock | 22.2968 | 22.3186 | 22.2968 | 22.3079 | 385028.0 |
| 2012-04-12 09:05:00 | AAPL | Stock | 22.3093 | 22.3389 | 22.3093 | 22.3107 | 211400.0 |
| 2012-04-12 09:10:00 | AAPL | Stock | 22.3107 | 22.3339 | 22.3057 | 22.3264 | 180264.0 |
| 2012-04-12 09:15:00 | AAPL | Stock | 22.3321 | 22.3346 | 22.3089 | 22.3214 | 117992.0 |
| 2012-04-12 09:20:00 | AAPL | Stock | 22.3129 | 22.3193 | 22.2857 | 22.2871 | 239372.0 |
| 2012-04-12 09:25:00 | AAPL | Stock | 22.2861 | 22.3354 | 22.2768 | 22.3214 | 476728.0 |
| 2012-04-12 09:30:00 | AAPL | Stock | 22.3214 | 22.3679 | 22.1936 | 22.2507 | 25575788.0 |
| 2012-04-12 09:35:00 | AAPL | Stock | 22.2507 | 22.32 | 22.2375 | 22.2954 | 15966216.0 |
> showing 50 of 326,633 rows — these rows as CSV