PREVIEW / stock_5min / 2014-02-10
file: by_date/stock_5min/2014/2014-02-10.parquet size: 5.5 MB rows: 360,924 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-02-10 04:00:00 | AAPL | Stock | 18.6464 | 18.6464 | 18.6464 | 18.6464 | 2800.0 |
| 2014-02-10 04:15:00 | AAPL | Stock | 18.6221 | 18.6221 | 18.6218 | 18.6218 | 5600.0 |
| 2014-02-10 04:20:00 | AAPL | Stock | 18.625 | 18.625 | 18.625 | 18.625 | 7000.0 |
| 2014-02-10 04:30:00 | AAPL | Stock | 18.6279 | 18.6279 | 18.6279 | 18.6279 | 2800.0 |
| 2014-02-10 04:35:00 | AAPL | Stock | 18.6429 | 18.6429 | 18.6429 | 18.6429 | 5600.0 |
| 2014-02-10 04:55:00 | AAPL | Stock | 18.6554 | 18.6554 | 18.6554 | 18.6554 | 2800.0 |
| 2014-02-10 05:15:00 | AAPL | Stock | 18.6607 | 18.6643 | 18.6607 | 18.6643 | 5600.0 |
| 2014-02-10 05:20:00 | AAPL | Stock | 18.6643 | 18.6643 | 18.6468 | 18.6468 | 5600.0 |
| 2014-02-10 05:25:00 | AAPL | Stock | 18.6454 | 18.6454 | 18.6407 | 18.6407 | 14000.0 |
| 2014-02-10 05:40:00 | AAPL | Stock | 18.6339 | 18.6464 | 18.6339 | 18.6464 | 8484.0 |
| 2014-02-10 06:10:00 | AAPL | Stock | 18.6429 | 18.6429 | 18.6429 | 18.6429 | 2996.0 |
| 2014-02-10 06:15:00 | AAPL | Stock | 18.6321 | 18.6321 | 18.6321 | 18.6321 | 10948.0 |
| 2014-02-10 06:35:00 | AAPL | Stock | 18.6375 | 18.6375 | 18.6375 | 18.6375 | 2800.0 |
| 2014-02-10 07:00:00 | AAPL | Stock | 18.6129 | 18.6161 | 18.6054 | 18.6079 | 17780.0 |
| 2014-02-10 07:10:00 | AAPL | Stock | 18.6071 | 18.6071 | 18.5721 | 18.5721 | 50680.0 |
| 2014-02-10 07:15:00 | AAPL | Stock | 18.5718 | 18.5804 | 18.5718 | 18.5804 | 6160.0 |
| 2014-02-10 07:20:00 | AAPL | Stock | 18.5893 | 18.5893 | 18.5893 | 18.5893 | 24612.0 |
| 2014-02-10 07:25:00 | AAPL | Stock | 18.5971 | 18.5971 | 18.5936 | 18.5939 | 11200.0 |
| 2014-02-10 07:30:00 | AAPL | Stock | 18.5857 | 18.5857 | 18.5857 | 18.5857 | 28000.0 |
| 2014-02-10 07:35:00 | AAPL | Stock | 18.5889 | 18.5889 | 18.5889 | 18.5889 | 2800.0 |
| 2014-02-10 07:40:00 | AAPL | Stock | 18.5857 | 18.5911 | 18.5857 | 18.5893 | 23072.0 |
| 2014-02-10 07:45:00 | AAPL | Stock | 18.5979 | 18.5982 | 18.59 | 18.5982 | 53844.0 |
| 2014-02-10 07:50:00 | AAPL | Stock | 18.6068 | 18.6346 | 18.6054 | 18.6332 | 47600.0 |
| 2014-02-10 07:55:00 | AAPL | Stock | 18.6268 | 18.6268 | 18.6146 | 18.6179 | 84560.0 |
| 2014-02-10 08:00:00 | AAPL | Stock | 18.6161 | 18.6357 | 18.5721 | 18.5911 | 221760.0 |
| 2014-02-10 08:05:00 | AAPL | Stock | 18.5914 | 18.5914 | 18.5714 | 18.5796 | 58800.0 |
| 2014-02-10 08:10:00 | AAPL | Stock | 18.5807 | 18.5821 | 18.5607 | 18.5789 | 151480.0 |
| 2014-02-10 08:15:00 | AAPL | Stock | 18.5721 | 18.5807 | 18.5714 | 18.5807 | 90160.0 |
| 2014-02-10 08:20:00 | AAPL | Stock | 18.5718 | 18.6064 | 18.5714 | 18.5993 | 88928.0 |
| 2014-02-10 08:25:00 | AAPL | Stock | 18.5993 | 18.6054 | 18.5946 | 18.5968 | 33236.0 |
| 2014-02-10 08:30:00 | AAPL | Stock | 18.5971 | 18.6071 | 18.5943 | 18.6071 | 54460.0 |
| 2014-02-10 08:35:00 | AAPL | Stock | 18.6004 | 18.6071 | 18.5971 | 18.6071 | 79884.0 |
| 2014-02-10 08:40:00 | AAPL | Stock | 18.6071 | 18.6143 | 18.6068 | 18.6139 | 145096.0 |
| 2014-02-10 08:45:00 | AAPL | Stock | 18.6139 | 18.6143 | 18.5986 | 18.6032 | 133224.0 |
| 2014-02-10 08:50:00 | AAPL | Stock | 18.5979 | 18.6086 | 18.5946 | 18.5993 | 71400.0 |
| 2014-02-10 08:55:00 | AAPL | Stock | 18.6032 | 18.6064 | 18.6032 | 18.6061 | 28224.0 |
| 2014-02-10 09:00:00 | AAPL | Stock | 18.5986 | 18.6107 | 18.5986 | 18.6107 | 91784.0 |
| 2014-02-10 09:05:00 | AAPL | Stock | 18.6071 | 18.6071 | 18.6018 | 18.6018 | 30800.0 |
| 2014-02-10 09:10:00 | AAPL | Stock | 18.5986 | 18.6132 | 18.5986 | 18.6132 | 45332.0 |
| 2014-02-10 09:15:00 | AAPL | Stock | 18.6111 | 18.6139 | 18.5471 | 18.5536 | 792596.0 |
| 2014-02-10 09:20:00 | AAPL | Stock | 18.5436 | 18.5679 | 18.4686 | 18.5018 | 1896860.0 |
| 2014-02-10 09:25:00 | AAPL | Stock | 18.5036 | 18.5346 | 18.4543 | 18.5014 | 2034844.0 |
| 2014-02-10 09:30:00 | AAPL | Stock | 18.5236 | 18.6661 | 18.5 | 18.6411 | 15943592.0 |
| 2014-02-10 09:35:00 | AAPL | Stock | 18.6411 | 18.7229 | 18.6389 | 18.7214 | 10421460.0 |
| 2014-02-10 09:40:00 | AAPL | Stock | 18.7204 | 18.7974 | 18.7179 | 18.7954 | 11263980.0 |
| 2014-02-10 09:45:00 | AAPL | Stock | 18.7957 | 18.8543 | 18.7864 | 18.8521 | 10376856.0 |
| 2014-02-10 09:50:00 | AAPL | Stock | 18.8536 | 18.8661 | 18.8 | 18.8175 | 10526684.0 |
| 2014-02-10 09:55:00 | AAPL | Stock | 18.8175 | 18.8214 | 18.79 | 18.7995 | 6322568.0 |
| 2014-02-10 10:00:00 | AAPL | Stock | 18.8043 | 18.8354 | 18.7975 | 18.8229 | 4445616.0 |
| 2014-02-10 10:05:00 | AAPL | Stock | 18.825 | 18.8379 | 18.8061 | 18.8268 | 4649092.0 |
> showing 50 of 360,924 rows — these rows as CSV