PREVIEW / stock_5min / 2014-05-16
file: by_date/stock_5min/2014/2014-05-16.parquet size: 5.3 MB rows: 353,557 symbols: 3,534
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 |
|---|---|---|---|---|---|---|---|
| 2014-05-16 05:20:00 | AAPL | Stock | 21.0375 | 21.0375 | 21.0375 | 21.0375 | 2800.0 |
| 2014-05-16 05:35:00 | AAPL | Stock | 21.0386 | 21.04 | 21.0386 | 21.04 | 5600.0 |
| 2014-05-16 05:55:00 | AAPL | Stock | 21.0314 | 21.0318 | 21.0314 | 21.0318 | 8400.0 |
| 2014-05-16 06:00:00 | AAPL | Stock | 21.0264 | 21.0264 | 21.0264 | 21.0264 | 2800.0 |
| 2014-05-16 07:00:00 | AAPL | Stock | 21.0225 | 21.0225 | 21.0225 | 21.0225 | 2800.0 |
| 2014-05-16 07:30:00 | AAPL | Stock | 21.0018 | 21.0018 | 21.0 | 21.0 | 14000.0 |
| 2014-05-16 07:35:00 | AAPL | Stock | 21.0229 | 21.0229 | 21.0229 | 21.0229 | 2800.0 |
| 2014-05-16 07:45:00 | AAPL | Stock | 21.0211 | 21.0211 | 21.0211 | 21.0211 | 2800.0 |
| 2014-05-16 07:50:00 | AAPL | Stock | 21.0114 | 21.0114 | 21.0114 | 21.0114 | 31080.0 |
| 2014-05-16 08:00:00 | AAPL | Stock | 21.0161 | 21.0243 | 20.9868 | 21.0 | 26124.0 |
| 2014-05-16 08:05:00 | AAPL | Stock | 21.0 | 21.0 | 20.9929 | 20.9929 | 10024.0 |
| 2014-05-16 08:10:00 | AAPL | Stock | 20.9957 | 20.9957 | 20.9946 | 20.9946 | 16156.0 |
| 2014-05-16 08:20:00 | AAPL | Stock | 20.9929 | 20.9929 | 20.9918 | 20.9918 | 33600.0 |
| 2014-05-16 08:25:00 | AAPL | Stock | 20.9918 | 20.9957 | 20.9839 | 20.9957 | 28700.0 |
| 2014-05-16 08:30:00 | AAPL | Stock | 20.9957 | 21.0179 | 20.9957 | 21.0179 | 44828.0 |
| 2014-05-16 08:35:00 | AAPL | Stock | 21.0221 | 21.0389 | 21.0179 | 21.0389 | 54600.0 |
| 2014-05-16 08:40:00 | AAPL | Stock | 21.0464 | 21.0607 | 21.0379 | 21.0379 | 59640.0 |
| 2014-05-16 08:45:00 | AAPL | Stock | 21.0504 | 21.0582 | 21.0493 | 21.0536 | 98112.0 |
| 2014-05-16 08:50:00 | AAPL | Stock | 21.0571 | 21.0571 | 21.0571 | 21.0571 | 5600.0 |
| 2014-05-16 08:55:00 | AAPL | Stock | 21.0557 | 21.0564 | 21.0536 | 21.0564 | 8400.0 |
| 2014-05-16 09:00:00 | AAPL | Stock | 21.0536 | 21.0643 | 21.0536 | 21.0643 | 48412.0 |
| 2014-05-16 09:05:00 | AAPL | Stock | 21.0643 | 21.0886 | 21.0643 | 21.0671 | 125580.0 |
| 2014-05-16 09:10:00 | AAPL | Stock | 21.0711 | 21.0804 | 21.0711 | 21.075 | 39452.0 |
| 2014-05-16 09:15:00 | AAPL | Stock | 21.0768 | 21.0768 | 21.0575 | 21.0582 | 52388.0 |
| 2014-05-16 09:20:00 | AAPL | Stock | 21.0607 | 21.0607 | 21.0454 | 21.0536 | 95200.0 |
| 2014-05-16 09:25:00 | AAPL | Stock | 21.0536 | 21.0536 | 21.0246 | 21.0268 | 179312.0 |
| 2014-05-16 09:30:00 | AAPL | Stock | 21.0264 | 21.075 | 21.0182 | 21.05 | 21224364.0 |
| 2014-05-16 09:35:00 | AAPL | Stock | 21.0504 | 21.0618 | 20.9929 | 20.9961 | 4548404.0 |
| 2014-05-16 09:40:00 | AAPL | Stock | 21.0016 | 21.0061 | 20.9661 | 20.9929 | 3652992.0 |
| 2014-05-16 09:45:00 | AAPL | Stock | 20.9875 | 21.0064 | 20.9739 | 20.9839 | 2507764.0 |
| 2014-05-16 09:50:00 | AAPL | Stock | 20.9836 | 20.9958 | 20.9779 | 20.9891 | 3142160.0 |
| 2014-05-16 09:55:00 | AAPL | Stock | 20.9879 | 20.9886 | 20.9364 | 20.9721 | 6002108.0 |
| 2014-05-16 10:00:00 | AAPL | Stock | 20.9768 | 20.9839 | 20.96 | 20.9646 | 2433872.0 |
| 2014-05-16 10:05:00 | AAPL | Stock | 20.965 | 20.965 | 20.9071 | 20.9129 | 4852820.0 |
| 2014-05-16 10:10:00 | AAPL | Stock | 20.9168 | 20.9382 | 20.9111 | 20.9354 | 3052700.0 |
| 2014-05-16 10:15:00 | AAPL | Stock | 20.9354 | 20.9604 | 20.9304 | 20.9543 | 2965060.0 |
| 2014-05-16 10:20:00 | AAPL | Stock | 20.9525 | 20.98 | 20.9464 | 20.9679 | 2654848.0 |
| 2014-05-16 10:25:00 | AAPL | Stock | 20.965 | 20.9683 | 20.9221 | 20.925 | 2052484.0 |
| 2014-05-16 10:30:00 | AAPL | Stock | 20.9286 | 20.9468 | 20.9229 | 20.9368 | 1756580.0 |
| 2014-05-16 10:35:00 | AAPL | Stock | 20.9389 | 20.9529 | 20.9343 | 20.9464 | 977816.0 |
| 2014-05-16 10:40:00 | AAPL | Stock | 20.9439 | 20.95 | 20.92 | 20.9243 | 1883196.0 |
| 2014-05-16 10:45:00 | AAPL | Stock | 20.9243 | 20.9518 | 20.9146 | 20.9425 | 1952188.0 |
| 2014-05-16 10:50:00 | AAPL | Stock | 20.9446 | 20.9668 | 20.9411 | 20.9548 | 1507716.0 |
| 2014-05-16 10:55:00 | AAPL | Stock | 20.9546 | 20.9721 | 20.9504 | 20.9532 | 918652.0 |
| 2014-05-16 11:00:00 | AAPL | Stock | 20.955 | 20.9575 | 20.9396 | 20.9571 | 868168.0 |
| 2014-05-16 11:05:00 | AAPL | Stock | 20.9532 | 20.9657 | 20.9421 | 20.9632 | 1029588.0 |
| 2014-05-16 11:10:00 | AAPL | Stock | 20.9611 | 20.9807 | 20.9507 | 20.978 | 855848.0 |
| 2014-05-16 11:15:00 | AAPL | Stock | 20.975 | 20.9918 | 20.9689 | 20.9864 | 1361584.0 |
| 2014-05-16 11:20:00 | AAPL | Stock | 20.9866 | 20.9882 | 20.9629 | 20.97 | 1383312.0 |
| 2014-05-16 11:25:00 | AAPL | Stock | 20.9722 | 20.9743 | 20.9568 | 20.97 | 1121176.0 |
> showing 50 of 353,557 rows — these rows as CSV