PREVIEW / stock_5min / 2013-01-15
file: by_date/stock_5min/2013/2013-01-15.parquet size: 4.8 MB rows: 323,731 symbols: 3,457
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-01-15 04:05:00 | AAPL | Stock | 17.8575 | 17.8575 | 17.8575 | 17.8575 | 11200.0 |
| 2013-01-15 04:50:00 | AAPL | Stock | 17.8575 | 17.8575 | 17.8575 | 17.8575 | 2800.0 |
| 2013-01-15 05:00:00 | AAPL | Stock | 17.8929 | 17.8929 | 17.8929 | 17.8929 | 2800.0 |
| 2013-01-15 05:35:00 | AAPL | Stock | 17.8814 | 17.8814 | 17.875 | 17.875 | 5600.0 |
| 2013-01-15 06:00:00 | AAPL | Stock | 17.8557 | 17.8557 | 17.8557 | 17.8557 | 2800.0 |
| 2013-01-15 06:05:00 | AAPL | Stock | 17.8554 | 17.875 | 17.8554 | 17.875 | 8400.0 |
| 2013-01-15 06:25:00 | AAPL | Stock | 17.8714 | 17.8736 | 17.8571 | 17.8571 | 8400.0 |
| 2013-01-15 06:35:00 | AAPL | Stock | 17.8571 | 17.8571 | 17.8571 | 17.8571 | 2800.0 |
| 2013-01-15 06:45:00 | AAPL | Stock | 17.8607 | 17.8607 | 17.8607 | 17.8607 | 24500.0 |
| 2013-01-15 06:50:00 | AAPL | Stock | 17.8607 | 17.8607 | 17.8607 | 17.8607 | 5600.0 |
| 2013-01-15 06:55:00 | AAPL | Stock | 17.8746 | 17.8746 | 17.8746 | 17.8746 | 2800.0 |
| 2013-01-15 07:00:00 | AAPL | Stock | 17.8754 | 17.9121 | 17.8754 | 17.8929 | 50120.0 |
| 2013-01-15 07:05:00 | AAPL | Stock | 17.8839 | 17.8857 | 17.8668 | 17.8668 | 106400.0 |
| 2013-01-15 07:10:00 | AAPL | Stock | 17.875 | 17.9071 | 17.875 | 17.9071 | 98224.0 |
| 2013-01-15 07:15:00 | AAPL | Stock | 17.9036 | 17.9107 | 17.8929 | 17.8929 | 41580.0 |
| 2013-01-15 07:20:00 | AAPL | Stock | 17.91 | 17.9107 | 17.91 | 17.9107 | 27440.0 |
| 2013-01-15 07:25:00 | AAPL | Stock | 17.9111 | 17.9143 | 17.9054 | 17.9054 | 46200.0 |
| 2013-01-15 07:30:00 | AAPL | Stock | 17.9107 | 17.9264 | 17.9089 | 17.9264 | 32508.0 |
| 2013-01-15 07:35:00 | AAPL | Stock | 17.9282 | 17.9536 | 17.9282 | 17.9336 | 116536.0 |
| 2013-01-15 07:40:00 | AAPL | Stock | 17.9329 | 17.9357 | 17.9107 | 17.9107 | 233268.0 |
| 2013-01-15 07:45:00 | AAPL | Stock | 17.9125 | 17.9411 | 17.9125 | 17.9304 | 79716.0 |
| 2013-01-15 07:50:00 | AAPL | Stock | 17.9357 | 17.9554 | 17.9286 | 17.9554 | 54432.0 |
| 2013-01-15 07:55:00 | AAPL | Stock | 17.9632 | 17.9707 | 17.9529 | 17.9707 | 83188.0 |
| 2013-01-15 08:00:00 | AAPL | Stock | 17.9493 | 18.015 | 17.8661 | 18.0143 | 435120.0 |
| 2013-01-15 08:05:00 | AAPL | Stock | 18.0075 | 18.0125 | 17.8929 | 17.9643 | 325164.0 |
| 2013-01-15 08:10:00 | AAPL | Stock | 17.9682 | 17.9979 | 17.9643 | 17.965 | 290164.0 |
| 2013-01-15 08:15:00 | AAPL | Stock | 17.9646 | 17.98 | 17.9393 | 17.95 | 196616.0 |
| 2013-01-15 08:20:00 | AAPL | Stock | 17.9464 | 17.9557 | 17.9336 | 17.9461 | 237272.0 |
| 2013-01-15 08:25:00 | AAPL | Stock | 17.95 | 17.9643 | 17.95 | 17.9511 | 178724.0 |
| 2013-01-15 08:30:00 | AAPL | Stock | 17.9607 | 17.9625 | 17.9393 | 17.9564 | 121380.0 |
| 2013-01-15 08:35:00 | AAPL | Stock | 17.9586 | 17.9804 | 17.9575 | 17.9804 | 280896.0 |
| 2013-01-15 08:40:00 | AAPL | Stock | 17.9807 | 17.9807 | 17.9429 | 17.9539 | 163520.0 |
| 2013-01-15 08:45:00 | AAPL | Stock | 17.9539 | 17.9589 | 17.9286 | 17.9286 | 243880.0 |
| 2013-01-15 08:50:00 | AAPL | Stock | 17.9343 | 17.9539 | 17.9214 | 17.9275 | 306600.0 |
| 2013-01-15 08:55:00 | AAPL | Stock | 17.9264 | 17.9286 | 17.9107 | 17.9146 | 253176.0 |
| 2013-01-15 09:00:00 | AAPL | Stock | 17.9186 | 17.9282 | 17.9125 | 17.9132 | 187292.0 |
| 2013-01-15 09:05:00 | AAPL | Stock | 17.9111 | 17.9111 | 17.9025 | 17.9036 | 292572.0 |
| 2013-01-15 09:10:00 | AAPL | Stock | 17.9025 | 17.9025 | 17.8186 | 17.8482 | 1341760.0 |
| 2013-01-15 09:15:00 | AAPL | Stock | 17.8439 | 17.8568 | 17.8389 | 17.8518 | 541156.0 |
| 2013-01-15 09:20:00 | AAPL | Stock | 17.8518 | 17.855 | 17.8257 | 17.8286 | 591192.0 |
| 2013-01-15 09:25:00 | AAPL | Stock | 17.8286 | 17.8414 | 17.7857 | 17.7982 | 2240308.0 |
| 2013-01-15 09:30:00 | AAPL | Stock | 17.7964 | 17.8211 | 17.6432 | 17.6696 | 49673008.0 |
| 2013-01-15 09:35:00 | AAPL | Stock | 17.6673 | 17.6739 | 17.5539 | 17.5943 | 46100292.0 |
| 2013-01-15 09:40:00 | AAPL | Stock | 17.5939 | 17.6225 | 17.4721 | 17.4864 | 34354628.0 |
| 2013-01-15 09:45:00 | AAPL | Stock | 17.4861 | 17.5439 | 17.4382 | 17.5093 | 35072688.0 |
| 2013-01-15 09:50:00 | AAPL | Stock | 17.5143 | 17.5579 | 17.4771 | 17.4964 | 19730060.0 |
| 2013-01-15 09:55:00 | AAPL | Stock | 17.4961 | 17.5518 | 17.4418 | 17.5437 | 21511448.0 |
| 2013-01-15 10:00:00 | AAPL | Stock | 17.5496 | 17.5711 | 17.48 | 17.5239 | 18219096.0 |
| 2013-01-15 10:05:00 | AAPL | Stock | 17.5243 | 17.5975 | 17.5 | 17.59 | 16115680.0 |
| 2013-01-15 10:10:00 | AAPL | Stock | 17.5923 | 17.5964 | 17.525 | 17.5264 | 10256316.0 |
> showing 50 of 323,731 rows — these rows as CSV