PREVIEW / stock_5min / 2013-09-18
file: by_date/stock_5min/2013/2013-09-18.parquet size: 5.3 MB rows: 349,013 symbols: 3,511
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-09-18 04:00:00 | AAPL | Stock | 16.2857 | 16.3679 | 16.2857 | 16.365 | 23100.0 |
| 2013-09-18 04:05:00 | AAPL | Stock | 16.3929 | 16.4068 | 16.3796 | 16.4068 | 13160.0 |
| 2013-09-18 04:15:00 | AAPL | Stock | 16.3929 | 16.3929 | 16.3907 | 16.3907 | 5600.0 |
| 2013-09-18 04:20:00 | AAPL | Stock | 16.4064 | 16.4107 | 16.4064 | 16.4107 | 13160.0 |
| 2013-09-18 04:25:00 | AAPL | Stock | 16.3986 | 16.3986 | 16.3907 | 16.3907 | 8400.0 |
| 2013-09-18 04:30:00 | AAPL | Stock | 16.3843 | 16.3843 | 16.3843 | 16.3843 | 2800.0 |
| 2013-09-18 04:35:00 | AAPL | Stock | 16.3929 | 16.3929 | 16.3929 | 16.3929 | 8400.0 |
| 2013-09-18 04:40:00 | AAPL | Stock | 16.3893 | 16.3893 | 16.3893 | 16.3893 | 16800.0 |
| 2013-09-18 04:45:00 | AAPL | Stock | 16.3843 | 16.3843 | 16.3571 | 16.3571 | 5600.0 |
| 2013-09-18 04:50:00 | AAPL | Stock | 16.3643 | 16.3643 | 16.3643 | 16.3643 | 2800.0 |
| 2013-09-18 04:55:00 | AAPL | Stock | 16.3714 | 16.3714 | 16.3561 | 16.3561 | 50400.0 |
| 2013-09-18 05:00:00 | AAPL | Stock | 16.3607 | 16.3625 | 16.3607 | 16.3625 | 14000.0 |
| 2013-09-18 05:05:00 | AAPL | Stock | 16.3625 | 16.3625 | 16.3575 | 16.3625 | 47600.0 |
| 2013-09-18 05:15:00 | AAPL | Stock | 16.3786 | 16.3857 | 16.3786 | 16.3814 | 14000.0 |
| 2013-09-18 05:25:00 | AAPL | Stock | 16.3811 | 16.3811 | 16.3811 | 16.3811 | 2800.0 |
| 2013-09-18 05:40:00 | AAPL | Stock | 16.3821 | 16.3821 | 16.3821 | 16.3821 | 50400.0 |
| 2013-09-18 05:45:00 | AAPL | Stock | 16.3821 | 16.3929 | 16.3821 | 16.3929 | 41384.0 |
| 2013-09-18 05:50:00 | AAPL | Stock | 16.385 | 16.385 | 16.3821 | 16.3821 | 11200.0 |
| 2013-09-18 05:55:00 | AAPL | Stock | 16.375 | 16.375 | 16.375 | 16.375 | 16800.0 |
| 2013-09-18 06:00:00 | AAPL | Stock | 16.3696 | 16.375 | 16.3668 | 16.375 | 24584.0 |
| 2013-09-18 06:05:00 | AAPL | Stock | 16.375 | 16.375 | 16.375 | 16.375 | 5600.0 |
| 2013-09-18 06:15:00 | AAPL | Stock | 16.3861 | 16.3861 | 16.3861 | 16.3861 | 2800.0 |
| 2013-09-18 06:20:00 | AAPL | Stock | 16.385 | 16.385 | 16.385 | 16.385 | 2800.0 |
| 2013-09-18 06:30:00 | AAPL | Stock | 16.3757 | 16.3757 | 16.3729 | 16.3729 | 14000.0 |
| 2013-09-18 06:40:00 | AAPL | Stock | 16.375 | 16.375 | 16.375 | 16.375 | 8400.0 |
| 2013-09-18 06:50:00 | AAPL | Stock | 16.3607 | 16.3607 | 16.3607 | 16.3607 | 14000.0 |
| 2013-09-18 06:55:00 | AAPL | Stock | 16.3821 | 16.3821 | 16.3586 | 16.3607 | 22400.0 |
| 2013-09-18 07:00:00 | AAPL | Stock | 16.375 | 16.3818 | 16.375 | 16.375 | 50120.0 |
| 2013-09-18 07:05:00 | AAPL | Stock | 16.3786 | 16.3839 | 16.375 | 16.3839 | 64400.0 |
| 2013-09-18 07:10:00 | AAPL | Stock | 16.3821 | 16.4007 | 16.3718 | 16.4007 | 154308.0 |
| 2013-09-18 07:15:00 | AAPL | Stock | 16.4064 | 16.4104 | 16.3893 | 16.4036 | 83216.0 |
| 2013-09-18 07:20:00 | AAPL | Stock | 16.4018 | 16.4089 | 16.3929 | 16.4036 | 172340.0 |
| 2013-09-18 07:25:00 | AAPL | Stock | 16.4004 | 16.4446 | 16.4004 | 16.4429 | 248780.0 |
| 2013-09-18 07:30:00 | AAPL | Stock | 16.4357 | 16.4357 | 16.4175 | 16.4264 | 53620.0 |
| 2013-09-18 07:35:00 | AAPL | Stock | 16.4282 | 16.4354 | 16.395 | 16.4107 | 103880.0 |
| 2013-09-18 07:40:00 | AAPL | Stock | 16.4107 | 16.4282 | 16.3968 | 16.4125 | 119280.0 |
| 2013-09-18 07:45:00 | AAPL | Stock | 16.4132 | 16.4282 | 16.4011 | 16.4282 | 116060.0 |
| 2013-09-18 07:50:00 | AAPL | Stock | 16.435 | 16.4464 | 16.4286 | 16.4393 | 184100.0 |
| 2013-09-18 07:55:00 | AAPL | Stock | 16.4375 | 16.4539 | 16.435 | 16.4539 | 109984.0 |
| 2013-09-18 08:00:00 | AAPL | Stock | 16.4421 | 16.4643 | 16.3686 | 16.4568 | 770084.0 |
| 2013-09-18 08:05:00 | AAPL | Stock | 16.4518 | 16.4518 | 16.4286 | 16.4407 | 421792.0 |
| 2013-09-18 08:10:00 | AAPL | Stock | 16.4379 | 16.44 | 16.4318 | 16.4318 | 148092.0 |
| 2013-09-18 08:15:00 | AAPL | Stock | 16.4318 | 16.45 | 16.4286 | 16.4464 | 171052.0 |
| 2013-09-18 08:20:00 | AAPL | Stock | 16.45 | 16.4554 | 16.4389 | 16.4529 | 273280.0 |
| 2013-09-18 08:25:00 | AAPL | Stock | 16.4529 | 16.4711 | 16.4518 | 16.4568 | 393960.0 |
| 2013-09-18 08:30:00 | AAPL | Stock | 16.4539 | 16.4661 | 16.4507 | 16.46 | 398860.0 |
| 2013-09-18 08:35:00 | AAPL | Stock | 16.4529 | 16.4554 | 16.4336 | 16.4425 | 166516.0 |
| 2013-09-18 08:40:00 | AAPL | Stock | 16.4393 | 16.4486 | 16.4357 | 16.4446 | 167160.0 |
| 2013-09-18 08:45:00 | AAPL | Stock | 16.4429 | 16.4454 | 16.4414 | 16.4414 | 50400.0 |
| 2013-09-18 08:50:00 | AAPL | Stock | 16.4425 | 16.4496 | 16.44 | 16.4496 | 207340.0 |
> showing 50 of 349,013 rows — these rows as CSV