PREVIEW / stock_5min / 2013-08-28
file: by_date/stock_5min/2013/2013-08-28.parquet size: 5.0 MB rows: 335,903 symbols: 3,513
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-08-28 04:00:00 | AAPL | Stock | 17.4107 | 17.4214 | 17.3843 | 17.3843 | 41440.0 |
| 2013-08-28 04:05:00 | AAPL | Stock | 17.3843 | 17.4179 | 17.3843 | 17.4179 | 11200.0 |
| 2013-08-28 04:15:00 | AAPL | Stock | 17.4007 | 17.4007 | 17.4007 | 17.4007 | 2800.0 |
| 2013-08-28 04:20:00 | AAPL | Stock | 17.3939 | 17.3939 | 17.3939 | 17.3939 | 2800.0 |
| 2013-08-28 04:25:00 | AAPL | Stock | 17.3936 | 17.3936 | 17.3929 | 17.3929 | 8400.0 |
| 2013-08-28 04:35:00 | AAPL | Stock | 17.4 | 17.4 | 17.4 | 17.4 | 2800.0 |
| 2013-08-28 04:40:00 | AAPL | Stock | 17.4 | 17.4 | 17.3768 | 17.3768 | 43484.0 |
| 2013-08-28 04:50:00 | AAPL | Stock | 17.3757 | 17.3757 | 17.3757 | 17.3757 | 2800.0 |
| 2013-08-28 05:05:00 | AAPL | Stock | 17.4 | 17.4018 | 17.4 | 17.4018 | 8988.0 |
| 2013-08-28 05:20:00 | AAPL | Stock | 17.3929 | 17.3929 | 17.3879 | 17.3879 | 14700.0 |
| 2013-08-28 05:50:00 | AAPL | Stock | 17.375 | 17.375 | 17.375 | 17.375 | 11200.0 |
| 2013-08-28 06:10:00 | AAPL | Stock | 17.3732 | 17.3732 | 17.3714 | 17.3714 | 8400.0 |
| 2013-08-28 06:15:00 | AAPL | Stock | 17.3368 | 17.3368 | 17.3368 | 17.3368 | 2800.0 |
| 2013-08-28 06:20:00 | AAPL | Stock | 17.3464 | 17.3464 | 17.3464 | 17.3464 | 2800.0 |
| 2013-08-28 06:30:00 | AAPL | Stock | 17.3464 | 17.3464 | 17.3464 | 17.3464 | 8400.0 |
| 2013-08-28 06:40:00 | AAPL | Stock | 17.3386 | 17.3386 | 17.3271 | 17.3386 | 11200.0 |
| 2013-08-28 06:45:00 | AAPL | Stock | 17.3304 | 17.3486 | 17.3304 | 17.3429 | 32200.0 |
| 2013-08-28 06:50:00 | AAPL | Stock | 17.3411 | 17.3411 | 17.3321 | 17.3329 | 74564.0 |
| 2013-08-28 06:55:00 | AAPL | Stock | 17.3393 | 17.3529 | 17.3393 | 17.3529 | 11200.0 |
| 2013-08-28 07:00:00 | AAPL | Stock | 17.3529 | 17.3575 | 17.3529 | 17.3575 | 16800.0 |
| 2013-08-28 07:05:00 | AAPL | Stock | 17.3596 | 17.3596 | 17.34 | 17.34 | 34188.0 |
| 2013-08-28 07:10:00 | AAPL | Stock | 17.3429 | 17.3429 | 17.3393 | 17.3393 | 12236.0 |
| 2013-08-28 07:20:00 | AAPL | Stock | 17.35 | 17.3686 | 17.35 | 17.3639 | 83272.0 |
| 2013-08-28 07:30:00 | AAPL | Stock | 17.3418 | 17.3418 | 17.3393 | 17.3393 | 14000.0 |
| 2013-08-28 07:35:00 | AAPL | Stock | 17.3479 | 17.3479 | 17.3321 | 17.3321 | 72800.0 |
| 2013-08-28 07:40:00 | AAPL | Stock | 17.3261 | 17.3325 | 17.3261 | 17.3307 | 17304.0 |
| 2013-08-28 07:45:00 | AAPL | Stock | 17.3321 | 17.3425 | 17.3307 | 17.3357 | 66192.0 |
| 2013-08-28 07:50:00 | AAPL | Stock | 17.3375 | 17.3375 | 17.3236 | 17.3357 | 72800.0 |
| 2013-08-28 07:55:00 | AAPL | Stock | 17.3375 | 17.3421 | 17.3329 | 17.3332 | 55720.0 |
| 2013-08-28 08:00:00 | AAPL | Stock | 17.3539 | 17.4496 | 17.3236 | 17.3714 | 354704.0 |
| 2013-08-28 08:05:00 | AAPL | Stock | 17.3743 | 17.3929 | 17.3743 | 17.3807 | 95004.0 |
| 2013-08-28 08:10:00 | AAPL | Stock | 17.3807 | 17.3836 | 17.3711 | 17.3821 | 55384.0 |
| 2013-08-28 08:15:00 | AAPL | Stock | 17.3854 | 17.4161 | 17.3811 | 17.4161 | 118720.0 |
| 2013-08-28 08:20:00 | AAPL | Stock | 17.415 | 17.4196 | 17.4036 | 17.4057 | 129136.0 |
| 2013-08-28 08:25:00 | AAPL | Stock | 17.4068 | 17.4482 | 17.4054 | 17.4304 | 127708.0 |
| 2013-08-28 08:30:00 | AAPL | Stock | 17.4286 | 17.4325 | 17.4196 | 17.4196 | 84364.0 |
| 2013-08-28 08:35:00 | AAPL | Stock | 17.4175 | 17.4325 | 17.4143 | 17.4325 | 64148.0 |
| 2013-08-28 08:40:00 | AAPL | Stock | 17.4386 | 17.4857 | 17.4386 | 17.4857 | 257236.0 |
| 2013-08-28 08:45:00 | AAPL | Stock | 17.4857 | 17.4882 | 17.4618 | 17.4636 | 529956.0 |
| 2013-08-28 08:50:00 | AAPL | Stock | 17.4586 | 17.4643 | 17.4325 | 17.4425 | 691040.0 |
| 2013-08-28 08:55:00 | AAPL | Stock | 17.4425 | 17.4425 | 17.4154 | 17.4286 | 794668.0 |
| 2013-08-28 09:00:00 | AAPL | Stock | 17.4286 | 17.4416 | 17.425 | 17.4286 | 259812.0 |
| 2013-08-28 09:05:00 | AAPL | Stock | 17.4407 | 17.4464 | 17.4343 | 17.4464 | 130340.0 |
| 2013-08-28 09:10:00 | AAPL | Stock | 17.4414 | 17.4468 | 17.4343 | 17.4343 | 126364.0 |
| 2013-08-28 09:15:00 | AAPL | Stock | 17.4489 | 17.4489 | 17.4218 | 17.4221 | 112000.0 |
| 2013-08-28 09:20:00 | AAPL | Stock | 17.4286 | 17.4286 | 17.4225 | 17.4225 | 245840.0 |
| 2013-08-28 09:25:00 | AAPL | Stock | 17.4275 | 17.4286 | 17.3593 | 17.3661 | 612584.0 |
| 2013-08-28 09:30:00 | AAPL | Stock | 17.3571 | 17.5175 | 17.3571 | 17.4852 | 18596088.0 |
| 2013-08-28 09:35:00 | AAPL | Stock | 17.4868 | 17.5973 | 17.4656 | 17.5696 | 15078924.0 |
| 2013-08-28 09:40:00 | AAPL | Stock | 17.5654 | 17.6179 | 17.5554 | 17.5946 | 11026540.0 |
> showing 50 of 335,903 rows — these rows as CSV