PREVIEW / stock_5min / 2013-09-03
file: by_date/stock_5min/2013/2013-09-03.parquet size: 5.2 MB rows: 345,497 symbols: 3,532
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-03 04:00:00 | AAPL | Stock | 17.6036 | 17.6071 | 17.6036 | 17.6071 | 11200.0 |
| 2013-09-03 04:05:00 | AAPL | Stock | 17.6 | 17.6 | 17.6 | 17.6 | 2800.0 |
| 2013-09-03 04:10:00 | AAPL | Stock | 17.5964 | 17.5964 | 17.5943 | 17.5943 | 8960.0 |
| 2013-09-03 04:15:00 | AAPL | Stock | 17.5943 | 17.5943 | 17.5943 | 17.5943 | 2800.0 |
| 2013-09-03 04:35:00 | AAPL | Stock | 17.5357 | 17.5357 | 17.5357 | 17.5357 | 11200.0 |
| 2013-09-03 04:40:00 | AAPL | Stock | 17.5361 | 17.5364 | 17.5361 | 17.5364 | 14000.0 |
| 2013-09-03 05:05:00 | AAPL | Stock | 17.5118 | 17.5118 | 17.5118 | 17.5118 | 5292.0 |
| 2013-09-03 06:00:00 | AAPL | Stock | 17.5207 | 17.5207 | 17.5132 | 17.5132 | 9884.0 |
| 2013-09-03 06:10:00 | AAPL | Stock | 17.4643 | 17.4643 | 17.4643 | 17.4643 | 8400.0 |
| 2013-09-03 06:15:00 | AAPL | Stock | 17.4325 | 17.4325 | 17.4286 | 17.4286 | 16800.0 |
| 2013-09-03 06:25:00 | AAPL | Stock | 17.4714 | 17.4714 | 17.4714 | 17.4714 | 2800.0 |
| 2013-09-03 06:35:00 | AAPL | Stock | 17.4964 | 17.5032 | 17.4964 | 17.5032 | 7000.0 |
| 2013-09-03 06:45:00 | AAPL | Stock | 17.49 | 17.49 | 17.4896 | 17.49 | 16800.0 |
| 2013-09-03 06:50:00 | AAPL | Stock | 17.49 | 17.5 | 17.4786 | 17.5 | 36400.0 |
| 2013-09-03 06:55:00 | AAPL | Stock | 17.4996 | 17.4996 | 17.4893 | 17.4893 | 38640.0 |
| 2013-09-03 07:00:00 | AAPL | Stock | 17.4879 | 17.5354 | 17.4879 | 17.5304 | 203840.0 |
| 2013-09-03 07:05:00 | AAPL | Stock | 17.53 | 17.5357 | 17.5218 | 17.5357 | 130200.0 |
| 2013-09-03 07:10:00 | AAPL | Stock | 17.5357 | 17.5625 | 17.5357 | 17.5475 | 67844.0 |
| 2013-09-03 07:15:00 | AAPL | Stock | 17.5446 | 17.5446 | 17.5357 | 17.5357 | 136808.0 |
| 2013-09-03 07:20:00 | AAPL | Stock | 17.5425 | 17.5446 | 17.5364 | 17.5364 | 28280.0 |
| 2013-09-03 07:25:00 | AAPL | Stock | 17.5443 | 17.5496 | 17.5443 | 17.5479 | 41384.0 |
| 2013-09-03 07:30:00 | AAPL | Stock | 17.5396 | 17.5589 | 17.5396 | 17.5589 | 49280.0 |
| 2013-09-03 07:35:00 | AAPL | Stock | 17.5582 | 17.5582 | 17.5536 | 17.5536 | 46760.0 |
| 2013-09-03 07:40:00 | AAPL | Stock | 17.5436 | 17.5471 | 17.5314 | 17.5314 | 79352.0 |
| 2013-09-03 07:45:00 | AAPL | Stock | 17.5336 | 17.5396 | 17.5336 | 17.5375 | 14280.0 |
| 2013-09-03 07:50:00 | AAPL | Stock | 17.5375 | 17.5504 | 17.5375 | 17.5393 | 42420.0 |
| 2013-09-03 07:55:00 | AAPL | Stock | 17.54 | 17.54 | 17.5179 | 17.5286 | 121492.0 |
| 2013-09-03 08:00:00 | AAPL | Stock | 17.5311 | 17.5761 | 17.5 | 17.5536 | 789096.0 |
| 2013-09-03 08:05:00 | AAPL | Stock | 17.5625 | 17.5718 | 17.5579 | 17.5718 | 293636.0 |
| 2013-09-03 08:10:00 | AAPL | Stock | 17.5693 | 17.5714 | 17.5464 | 17.5479 | 146272.0 |
| 2013-09-03 08:15:00 | AAPL | Stock | 17.55 | 17.5507 | 17.5479 | 17.5482 | 57988.0 |
| 2013-09-03 08:20:00 | AAPL | Stock | 17.5489 | 17.5529 | 17.545 | 17.545 | 150752.0 |
| 2013-09-03 08:25:00 | AAPL | Stock | 17.5475 | 17.55 | 17.5464 | 17.5464 | 22400.0 |
| 2013-09-03 08:30:00 | AAPL | Stock | 17.5464 | 17.5536 | 17.5464 | 17.5536 | 164332.0 |
| 2013-09-03 08:35:00 | AAPL | Stock | 17.55 | 17.5768 | 17.55 | 17.5714 | 513100.0 |
| 2013-09-03 08:40:00 | AAPL | Stock | 17.5714 | 17.5907 | 17.5696 | 17.5879 | 317044.0 |
| 2013-09-03 08:45:00 | AAPL | Stock | 17.5871 | 17.5871 | 17.5804 | 17.5857 | 97608.0 |
| 2013-09-03 08:50:00 | AAPL | Stock | 17.5854 | 17.5907 | 17.5804 | 17.5871 | 233800.0 |
| 2013-09-03 08:55:00 | AAPL | Stock | 17.5864 | 17.5907 | 17.5821 | 17.5821 | 328692.0 |
| 2013-09-03 09:00:00 | AAPL | Stock | 17.5779 | 17.5829 | 17.5714 | 17.5761 | 176064.0 |
| 2013-09-03 09:05:00 | AAPL | Stock | 17.575 | 17.5875 | 17.575 | 17.5875 | 75348.0 |
| 2013-09-03 09:10:00 | AAPL | Stock | 17.585 | 17.5871 | 17.5757 | 17.5757 | 122192.0 |
| 2013-09-03 09:15:00 | AAPL | Stock | 17.5768 | 17.5961 | 17.575 | 17.5961 | 227164.0 |
| 2013-09-03 09:20:00 | AAPL | Stock | 17.5961 | 17.6429 | 17.5911 | 17.6118 | 379344.0 |
| 2013-09-03 09:25:00 | AAPL | Stock | 17.6189 | 17.6207 | 17.5968 | 17.6157 | 354508.0 |
| 2013-09-03 09:30:00 | AAPL | Stock | 17.6157 | 17.8786 | 17.5839 | 17.675 | 22417808.0 |
| 2013-09-03 09:35:00 | AAPL | Stock | 17.675 | 17.6964 | 17.6461 | 17.6875 | 10957072.0 |
| 2013-09-03 09:40:00 | AAPL | Stock | 17.6875 | 17.7054 | 17.6554 | 17.6732 | 7231224.0 |
| 2013-09-03 09:45:00 | AAPL | Stock | 17.6721 | 17.7229 | 17.6693 | 17.7093 | 10311980.0 |
| 2013-09-03 09:50:00 | AAPL | Stock | 17.7132 | 17.7432 | 17.7054 | 17.7161 | 9561776.0 |
> showing 50 of 345,497 rows — these rows as CSV