PREVIEW / stock_5min / 2016-05-16
file: by_date/stock_5min/2016/2016-05-16.parquet size: 5.4 MB rows: 360,285 symbols: 3,304
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 |
|---|---|---|---|---|---|---|---|
| 2016-05-16 05:55:00 | AAPL | Stock | 22.6725 | 22.6725 | 22.6725 | 22.6725 | 2600.0 |
| 2016-05-16 06:25:00 | AAPL | Stock | 22.6625 | 22.6625 | 22.6625 | 22.6625 | 800.0 |
| 2016-05-16 06:30:00 | AAPL | Stock | 22.655 | 22.655 | 22.655 | 22.655 | 2000.0 |
| 2016-05-16 06:35:00 | AAPL | Stock | 22.655 | 22.655 | 22.655 | 22.655 | 800.0 |
| 2016-05-16 07:05:00 | AAPL | Stock | 22.655 | 22.655 | 22.64 | 22.64 | 8460.0 |
| 2016-05-16 07:10:00 | AAPL | Stock | 22.65 | 22.65 | 22.65 | 22.65 | 2160.0 |
| 2016-05-16 07:15:00 | AAPL | Stock | 22.67 | 22.67 | 22.67 | 22.67 | 400.0 |
| 2016-05-16 07:20:00 | AAPL | Stock | 22.655 | 22.67 | 22.655 | 22.67 | 2396.0 |
| 2016-05-16 07:25:00 | AAPL | Stock | 22.675 | 22.675 | 22.675 | 22.675 | 400.0 |
| 2016-05-16 07:30:00 | AAPL | Stock | 22.6825 | 23.1925 | 22.6775 | 23.1925 | 449080.0 |
| 2016-05-16 07:35:00 | AAPL | Stock | 23.1925 | 23.28 | 23.03 | 23.065 | 894156.0 |
| 2016-05-16 07:40:00 | AAPL | Stock | 23.0425 | 23.125 | 23.005 | 23.09 | 433692.0 |
| 2016-05-16 07:45:00 | AAPL | Stock | 23.095 | 23.125 | 23.0375 | 23.0775 | 340968.0 |
| 2016-05-16 07:50:00 | AAPL | Stock | 23.0775 | 23.125 | 23.0525 | 23.095 | 342556.0 |
| 2016-05-16 07:55:00 | AAPL | Stock | 23.09 | 23.09 | 23.0375 | 23.055 | 152764.0 |
| 2016-05-16 08:00:00 | AAPL | Stock | 23.0425 | 23.125 | 22.65 | 23.05 | 463820.0 |
| 2016-05-16 08:05:00 | AAPL | Stock | 23.06 | 23.0625 | 22.9925 | 23.045 | 163200.0 |
| 2016-05-16 08:10:00 | AAPL | Stock | 23.0425 | 23.0875 | 23.0325 | 23.0675 | 201500.0 |
| 2016-05-16 08:15:00 | AAPL | Stock | 23.08 | 23.08 | 23.0225 | 23.0375 | 226028.0 |
| 2016-05-16 08:20:00 | AAPL | Stock | 23.0375 | 23.0425 | 22.95 | 22.9975 | 271664.0 |
| 2016-05-16 08:25:00 | AAPL | Stock | 22.9975 | 23.0075 | 22.9775 | 23.0 | 145692.0 |
| 2016-05-16 08:30:00 | AAPL | Stock | 22.995 | 23.0 | 22.9575 | 22.9875 | 324764.0 |
| 2016-05-16 08:35:00 | AAPL | Stock | 22.9875 | 23.0 | 22.965 | 22.965 | 137596.0 |
| 2016-05-16 08:40:00 | AAPL | Stock | 22.965 | 23.0 | 22.96 | 23.0 | 150072.0 |
| 2016-05-16 08:45:00 | AAPL | Stock | 22.9975 | 23.0375 | 22.9875 | 23.025 | 231196.0 |
| 2016-05-16 08:50:00 | AAPL | Stock | 23.0225 | 23.025 | 23.0 | 23.0125 | 171804.0 |
| 2016-05-16 08:55:00 | AAPL | Stock | 23.0075 | 23.025 | 22.9875 | 23.0175 | 126308.0 |
| 2016-05-16 09:00:00 | AAPL | Stock | 23.0175 | 23.025 | 23.01 | 23.0225 | 111388.0 |
| 2016-05-16 09:05:00 | AAPL | Stock | 23.0225 | 23.05 | 23.0175 | 23.045 | 245256.0 |
| 2016-05-16 09:10:00 | AAPL | Stock | 23.045 | 23.075 | 23.045 | 23.075 | 229456.0 |
| 2016-05-16 09:15:00 | AAPL | Stock | 23.0725 | 23.075 | 23.0375 | 23.0375 | 106868.0 |
| 2016-05-16 09:20:00 | AAPL | Stock | 23.0375 | 23.0675 | 23.02 | 23.0475 | 260620.0 |
| 2016-05-16 09:25:00 | AAPL | Stock | 23.0375 | 23.1125 | 23.03 | 23.11 | 551120.0 |
| 2016-05-16 09:30:00 | AAPL | Stock | 23.1125 | 23.12 | 22.9125 | 22.9725 | 11601300.0 |
| 2016-05-16 09:35:00 | AAPL | Stock | 22.9725 | 23.0525 | 22.9675 | 23.015 | 5721580.0 |
| 2016-05-16 09:40:00 | AAPL | Stock | 23.012 | 23.125 | 23.0052 | 23.125 | 6413400.0 |
| 2016-05-16 09:45:00 | AAPL | Stock | 23.1225 | 23.225 | 23.1225 | 23.2175 | 6989888.0 |
| 2016-05-16 09:50:00 | AAPL | Stock | 23.2225 | 23.2375 | 23.1675 | 23.18 | 5553052.0 |
| 2016-05-16 09:55:00 | AAPL | Stock | 23.18 | 23.185 | 23.1125 | 23.175 | 4748596.0 |
| 2016-05-16 10:00:00 | AAPL | Stock | 23.1772 | 23.2225 | 23.165 | 23.214 | 3471212.0 |
| 2016-05-16 10:05:00 | AAPL | Stock | 23.2148 | 23.265 | 23.2025 | 23.2615 | 5044168.0 |
| 2016-05-16 10:10:00 | AAPL | Stock | 23.2625 | 23.3 | 23.2525 | 23.2925 | 5183292.0 |
| 2016-05-16 10:15:00 | AAPL | Stock | 23.2925 | 23.3175 | 23.275 | 23.285 | 4271972.0 |
| 2016-05-16 10:20:00 | AAPL | Stock | 23.286 | 23.33 | 23.2662 | 23.3218 | 3449636.0 |
| 2016-05-16 10:25:00 | AAPL | Stock | 23.322 | 23.365 | 23.3178 | 23.335 | 4954116.0 |
| 2016-05-16 10:30:00 | AAPL | Stock | 23.3375 | 23.3412 | 23.305 | 23.3265 | 2867340.0 |
| 2016-05-16 10:35:00 | AAPL | Stock | 23.3272 | 23.3472 | 23.32 | 23.3432 | 2105024.0 |
| 2016-05-16 10:40:00 | AAPL | Stock | 23.3432 | 23.3475 | 23.2875 | 23.2925 | 2391676.0 |
| 2016-05-16 10:45:00 | AAPL | Stock | 23.2913 | 23.3425 | 23.2675 | 23.34 | 3376224.0 |
| 2016-05-16 10:50:00 | AAPL | Stock | 23.3412 | 23.39 | 23.3408 | 23.37 | 3807020.0 |
> showing 50 of 360,285 rows — these rows as CSV