PREVIEW / stock_5min / 2014-02-11
file: by_date/stock_5min/2014/2014-02-11.parquet size: 5.6 MB rows: 362,694 symbols: 3,548
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-02-11 04:00:00 | AAPL | Stock | 18.975 | 19.0 | 18.975 | 19.0 | 5600.0 |
| 2014-02-11 04:25:00 | AAPL | Stock | 18.9843 | 18.9843 | 18.9843 | 18.9843 | 2800.0 |
| 2014-02-11 05:00:00 | AAPL | Stock | 18.9893 | 18.9893 | 18.9893 | 18.9893 | 2800.0 |
| 2014-02-11 05:35:00 | AAPL | Stock | 18.9914 | 18.9914 | 18.9914 | 18.9914 | 2800.0 |
| 2014-02-11 05:45:00 | AAPL | Stock | 18.9893 | 18.9893 | 18.9821 | 18.9821 | 30800.0 |
| 2014-02-11 06:15:00 | AAPL | Stock | 18.9611 | 18.9611 | 18.9546 | 18.9546 | 14952.0 |
| 2014-02-11 06:20:00 | AAPL | Stock | 18.9493 | 18.9493 | 18.9493 | 18.9493 | 2800.0 |
| 2014-02-11 06:30:00 | AAPL | Stock | 18.9493 | 18.9493 | 18.9493 | 18.9493 | 8400.0 |
| 2014-02-11 06:40:00 | AAPL | Stock | 18.9546 | 18.9546 | 18.9529 | 18.9529 | 11200.0 |
| 2014-02-11 06:45:00 | AAPL | Stock | 18.9525 | 18.9546 | 18.9525 | 18.9546 | 8120.0 |
| 2014-02-11 07:00:00 | AAPL | Stock | 18.9607 | 18.9607 | 18.9607 | 18.9607 | 5600.0 |
| 2014-02-11 07:05:00 | AAPL | Stock | 18.9464 | 18.9521 | 18.9464 | 18.9521 | 8400.0 |
| 2014-02-11 07:25:00 | AAPL | Stock | 18.9604 | 18.9643 | 18.9557 | 18.9643 | 53620.0 |
| 2014-02-11 07:30:00 | AAPL | Stock | 18.9536 | 18.9536 | 18.9464 | 18.9464 | 50400.0 |
| 2014-02-11 07:40:00 | AAPL | Stock | 18.95 | 18.95 | 18.9496 | 18.95 | 16800.0 |
| 2014-02-11 07:45:00 | AAPL | Stock | 18.9464 | 18.9464 | 18.9329 | 18.9393 | 17164.0 |
| 2014-02-11 07:50:00 | AAPL | Stock | 18.9461 | 18.9464 | 18.9354 | 18.9393 | 33096.0 |
| 2014-02-11 07:55:00 | AAPL | Stock | 18.9393 | 18.9446 | 18.9393 | 18.9393 | 32900.0 |
| 2014-02-11 08:00:00 | AAPL | Stock | 18.9329 | 18.9607 | 18.9314 | 18.9329 | 162988.0 |
| 2014-02-11 08:05:00 | AAPL | Stock | 18.9325 | 18.9325 | 18.9279 | 18.9279 | 65940.0 |
| 2014-02-11 08:10:00 | AAPL | Stock | 18.9214 | 18.9286 | 18.9214 | 18.9286 | 30744.0 |
| 2014-02-11 08:15:00 | AAPL | Stock | 18.9286 | 18.9357 | 18.9286 | 18.9357 | 116452.0 |
| 2014-02-11 08:20:00 | AAPL | Stock | 18.9389 | 18.9393 | 18.9357 | 18.9382 | 39368.0 |
| 2014-02-11 08:25:00 | AAPL | Stock | 18.9439 | 18.9529 | 18.9439 | 18.9504 | 204568.0 |
| 2014-02-11 08:30:00 | AAPL | Stock | 18.9464 | 18.9539 | 18.9286 | 18.9357 | 516460.0 |
| 2014-02-11 08:35:00 | AAPL | Stock | 18.9307 | 18.9532 | 18.9296 | 18.9532 | 149044.0 |
| 2014-02-11 08:40:00 | AAPL | Stock | 18.9532 | 18.9554 | 18.9396 | 18.9554 | 189896.0 |
| 2014-02-11 08:45:00 | AAPL | Stock | 18.9536 | 18.9643 | 18.9468 | 18.9554 | 328020.0 |
| 2014-02-11 08:50:00 | AAPL | Stock | 18.9568 | 18.9646 | 18.9496 | 18.9496 | 248500.0 |
| 2014-02-11 08:55:00 | AAPL | Stock | 18.955 | 18.9679 | 18.95 | 18.9679 | 169540.0 |
| 2014-02-11 09:00:00 | AAPL | Stock | 18.9607 | 18.9679 | 18.9579 | 18.9629 | 79100.0 |
| 2014-02-11 09:05:00 | AAPL | Stock | 18.9575 | 18.9646 | 18.9568 | 18.9636 | 95200.0 |
| 2014-02-11 09:10:00 | AAPL | Stock | 18.9579 | 18.96 | 18.9554 | 18.9593 | 148960.0 |
| 2014-02-11 09:15:00 | AAPL | Stock | 18.9539 | 18.9639 | 18.9539 | 18.9629 | 44800.0 |
| 2014-02-11 09:20:00 | AAPL | Stock | 18.9593 | 18.9629 | 18.9468 | 18.9561 | 254100.0 |
| 2014-02-11 09:25:00 | AAPL | Stock | 18.9629 | 18.9679 | 18.9436 | 18.945 | 238840.0 |
| 2014-02-11 09:30:00 | AAPL | Stock | 18.9504 | 19.0393 | 18.9196 | 18.9911 | 13014456.0 |
| 2014-02-11 09:35:00 | AAPL | Stock | 18.9918 | 19.0079 | 18.9382 | 18.9621 | 7573664.0 |
| 2014-02-11 09:40:00 | AAPL | Stock | 18.9611 | 18.9871 | 18.9107 | 18.9756 | 7332696.0 |
| 2014-02-11 09:45:00 | AAPL | Stock | 18.9768 | 19.0229 | 18.9643 | 19.0011 | 5188652.0 |
| 2014-02-11 09:50:00 | AAPL | Stock | 19.0 | 19.0104 | 18.9861 | 18.9929 | 3175788.0 |
| 2014-02-11 09:55:00 | AAPL | Stock | 18.9939 | 19.0054 | 18.9611 | 18.9896 | 4308276.0 |
| 2014-02-11 10:00:00 | AAPL | Stock | 18.9904 | 18.9961 | 18.9614 | 18.985 | 2560124.0 |
| 2014-02-11 10:05:00 | AAPL | Stock | 18.9879 | 19.0236 | 18.9839 | 19.0128 | 4344284.0 |
| 2014-02-11 10:10:00 | AAPL | Stock | 19.0125 | 19.0582 | 19.0107 | 19.0475 | 6446272.0 |
| 2014-02-11 10:15:00 | AAPL | Stock | 19.0504 | 19.0854 | 19.05 | 19.0782 | 6842500.0 |
| 2014-02-11 10:20:00 | AAPL | Stock | 19.0752 | 19.0786 | 19.0543 | 19.0689 | 3224536.0 |
| 2014-02-11 10:25:00 | AAPL | Stock | 19.0679 | 19.0757 | 19.0446 | 19.0536 | 3621548.0 |
| 2014-02-11 10:30:00 | AAPL | Stock | 19.0536 | 19.0571 | 19.0446 | 19.0493 | 2744840.0 |
| 2014-02-11 10:35:00 | AAPL | Stock | 19.0493 | 19.0918 | 19.0482 | 19.0868 | 3145800.0 |
> showing 50 of 362,694 rows — these rows as CSV