PREVIEW / stock_5min / 2013-09-25
file: by_date/stock_5min/2013/2013-09-25.parquet size: 5.2 MB rows: 344,085 symbols: 3,536
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-25 04:00:00 | AAPL | Stock | 17.4643 | 17.4643 | 17.4643 | 17.4643 | 2800.0 |
| 2013-09-25 04:05:00 | AAPL | Stock | 17.4343 | 17.4343 | 17.4129 | 17.4129 | 16800.0 |
| 2013-09-25 04:10:00 | AAPL | Stock | 17.4225 | 17.4286 | 17.4225 | 17.4286 | 5600.0 |
| 2013-09-25 04:15:00 | AAPL | Stock | 17.4232 | 17.4232 | 17.2361 | 17.3936 | 39648.0 |
| 2013-09-25 04:20:00 | AAPL | Stock | 17.39 | 17.39 | 17.3793 | 17.3793 | 11200.0 |
| 2013-09-25 04:25:00 | AAPL | Stock | 17.3571 | 17.3571 | 17.3571 | 17.3571 | 2800.0 |
| 2013-09-25 04:30:00 | AAPL | Stock | 17.3571 | 17.3571 | 17.3571 | 17.3571 | 2800.0 |
| 2013-09-25 04:40:00 | AAPL | Stock | 17.3589 | 17.385 | 17.3589 | 17.385 | 9324.0 |
| 2013-09-25 04:45:00 | AAPL | Stock | 17.3679 | 17.3936 | 17.3679 | 17.3936 | 8400.0 |
| 2013-09-25 04:50:00 | AAPL | Stock | 17.3589 | 17.3589 | 17.3589 | 17.3589 | 2800.0 |
| 2013-09-25 04:55:00 | AAPL | Stock | 17.3589 | 17.3589 | 17.3589 | 17.3589 | 2800.0 |
| 2013-09-25 05:00:00 | AAPL | Stock | 17.3571 | 17.3571 | 17.3571 | 17.3571 | 22400.0 |
| 2013-09-25 05:10:00 | AAPL | Stock | 17.3893 | 17.3893 | 17.3893 | 17.3893 | 2800.0 |
| 2013-09-25 05:15:00 | AAPL | Stock | 17.375 | 17.3893 | 17.375 | 17.3893 | 16800.0 |
| 2013-09-25 05:20:00 | AAPL | Stock | 17.3893 | 17.4086 | 17.3893 | 17.3971 | 39200.0 |
| 2013-09-25 05:25:00 | AAPL | Stock | 17.3929 | 17.4214 | 17.3857 | 17.4214 | 24948.0 |
| 2013-09-25 05:45:00 | AAPL | Stock | 17.4214 | 17.4293 | 17.4214 | 17.4293 | 14000.0 |
| 2013-09-25 05:50:00 | AAPL | Stock | 17.44 | 17.44 | 17.44 | 17.44 | 2800.0 |
| 2013-09-25 05:55:00 | AAPL | Stock | 17.4396 | 17.4396 | 17.4396 | 17.4396 | 2800.0 |
| 2013-09-25 06:05:00 | AAPL | Stock | 17.4375 | 17.4375 | 17.4286 | 17.4286 | 8540.0 |
| 2013-09-25 06:30:00 | AAPL | Stock | 17.4196 | 17.4286 | 17.4196 | 17.4279 | 61600.0 |
| 2013-09-25 06:35:00 | AAPL | Stock | 17.4296 | 17.4296 | 17.42 | 17.4218 | 53200.0 |
| 2013-09-25 06:45:00 | AAPL | Stock | 17.4393 | 17.4393 | 17.4393 | 17.4393 | 2800.0 |
| 2013-09-25 06:50:00 | AAPL | Stock | 17.4436 | 17.4589 | 17.4436 | 17.4589 | 8400.0 |
| 2013-09-25 07:00:00 | AAPL | Stock | 17.4614 | 17.4814 | 17.425 | 17.425 | 116060.0 |
| 2013-09-25 07:05:00 | AAPL | Stock | 17.4218 | 17.4393 | 17.4146 | 17.4375 | 102620.0 |
| 2013-09-25 07:10:00 | AAPL | Stock | 17.4286 | 17.4286 | 17.4179 | 17.4286 | 39200.0 |
| 2013-09-25 07:15:00 | AAPL | Stock | 17.4161 | 17.4261 | 17.4161 | 17.4214 | 25200.0 |
| 2013-09-25 07:20:00 | AAPL | Stock | 17.4218 | 17.4218 | 17.4218 | 17.4218 | 2800.0 |
| 2013-09-25 07:25:00 | AAPL | Stock | 17.4189 | 17.4196 | 17.4179 | 17.4179 | 45360.0 |
| 2013-09-25 07:30:00 | AAPL | Stock | 17.4193 | 17.4193 | 17.4193 | 17.4193 | 5600.0 |
| 2013-09-25 07:35:00 | AAPL | Stock | 17.4164 | 17.4164 | 17.4164 | 17.4164 | 2800.0 |
| 2013-09-25 07:40:00 | AAPL | Stock | 17.4268 | 17.4321 | 17.4268 | 17.4321 | 8400.0 |
| 2013-09-25 07:45:00 | AAPL | Stock | 17.4282 | 17.4361 | 17.4282 | 17.4361 | 16800.0 |
| 2013-09-25 07:50:00 | AAPL | Stock | 17.4543 | 17.4543 | 17.4361 | 17.4361 | 14000.0 |
| 2013-09-25 08:00:00 | AAPL | Stock | 17.4482 | 17.4875 | 17.4125 | 17.4539 | 240464.0 |
| 2013-09-25 08:05:00 | AAPL | Stock | 17.4554 | 17.4636 | 17.4464 | 17.4464 | 67228.0 |
| 2013-09-25 08:10:00 | AAPL | Stock | 17.4554 | 17.4571 | 17.4536 | 17.4536 | 14000.0 |
| 2013-09-25 08:15:00 | AAPL | Stock | 17.4564 | 17.4643 | 17.4561 | 17.4643 | 82012.0 |
| 2013-09-25 08:20:00 | AAPL | Stock | 17.4714 | 17.4886 | 17.4618 | 17.4696 | 248500.0 |
| 2013-09-25 08:25:00 | AAPL | Stock | 17.4732 | 17.5 | 17.4732 | 17.5 | 190568.0 |
| 2013-09-25 08:30:00 | AAPL | Stock | 17.5025 | 17.5179 | 17.4911 | 17.4911 | 469336.0 |
| 2013-09-25 08:35:00 | AAPL | Stock | 17.4911 | 17.505 | 17.4839 | 17.505 | 148092.0 |
| 2013-09-25 08:40:00 | AAPL | Stock | 17.5089 | 17.5179 | 17.4964 | 17.5179 | 251720.0 |
| 2013-09-25 08:45:00 | AAPL | Stock | 17.5175 | 17.5429 | 17.5175 | 17.5357 | 251300.0 |
| 2013-09-25 08:50:00 | AAPL | Stock | 17.5446 | 17.545 | 17.5107 | 17.5179 | 202104.0 |
| 2013-09-25 08:55:00 | AAPL | Stock | 17.5321 | 17.5411 | 17.4679 | 17.5286 | 198044.0 |
| 2013-09-25 09:00:00 | AAPL | Stock | 17.5271 | 17.535 | 17.5268 | 17.5314 | 132944.0 |
| 2013-09-25 09:05:00 | AAPL | Stock | 17.5275 | 17.5518 | 17.5268 | 17.5486 | 371028.0 |
| 2013-09-25 09:10:00 | AAPL | Stock | 17.545 | 17.5625 | 17.545 | 17.5571 | 312452.0 |
> showing 50 of 344,085 rows — these rows as CSV