PREVIEW / stock_5min / 2011-04-15
file: by_date/stock_5min/2011/2011-04-15.parquet size: 4.8 MB rows: 324,570 symbols: 3,530
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 |
|---|---|---|---|---|---|---|---|
| 2011-04-15 04:40:00 | AAPL | Stock | 11.8736 | 11.8736 | 11.8736 | 11.8736 | 2800.0 |
| 2011-04-15 05:25:00 | AAPL | Stock | 11.8993 | 11.8993 | 11.8993 | 11.8993 | 2800.0 |
| 2011-04-15 05:35:00 | AAPL | Stock | 11.8929 | 11.8929 | 11.8929 | 11.8929 | 2800.0 |
| 2011-04-15 05:40:00 | AAPL | Stock | 11.8868 | 11.8868 | 11.8868 | 11.8868 | 2800.0 |
| 2011-04-15 05:45:00 | AAPL | Stock | 11.8736 | 11.8736 | 11.8721 | 11.8721 | 27580.0 |
| 2011-04-15 05:50:00 | AAPL | Stock | 11.8714 | 11.8714 | 11.8714 | 11.8714 | 14000.0 |
| 2011-04-15 06:00:00 | AAPL | Stock | 11.8714 | 11.8714 | 11.8714 | 11.8714 | 2800.0 |
| 2011-04-15 06:30:00 | AAPL | Stock | 11.8714 | 11.8714 | 11.8714 | 11.8714 | 5600.0 |
| 2011-04-15 06:55:00 | AAPL | Stock | 11.8714 | 11.8714 | 11.8714 | 11.8714 | 2800.0 |
| 2011-04-15 07:00:00 | AAPL | Stock | 11.8468 | 11.8571 | 11.8464 | 11.8571 | 19600.0 |
| 2011-04-15 07:05:00 | AAPL | Stock | 11.8536 | 11.8536 | 11.8536 | 11.8536 | 2800.0 |
| 2011-04-15 07:15:00 | AAPL | Stock | 11.8571 | 11.8571 | 11.8571 | 11.8571 | 39200.0 |
| 2011-04-15 07:20:00 | AAPL | Stock | 11.8711 | 11.8711 | 11.8711 | 11.8711 | 2800.0 |
| 2011-04-15 07:35:00 | AAPL | Stock | 11.8707 | 11.8707 | 11.8607 | 11.8607 | 14000.0 |
| 2011-04-15 07:40:00 | AAPL | Stock | 11.8607 | 11.8607 | 11.8607 | 11.8607 | 22652.0 |
| 2011-04-15 07:50:00 | AAPL | Stock | 11.8704 | 11.8704 | 11.8704 | 11.8704 | 2800.0 |
| 2011-04-15 07:55:00 | AAPL | Stock | 11.8704 | 11.8711 | 11.8704 | 11.8704 | 14000.0 |
| 2011-04-15 08:00:00 | AAPL | Stock | 11.8611 | 11.8611 | 11.85 | 11.85 | 44800.0 |
| 2011-04-15 08:05:00 | AAPL | Stock | 11.8536 | 11.8536 | 11.8321 | 11.8321 | 44660.0 |
| 2011-04-15 08:10:00 | AAPL | Stock | 11.8364 | 11.8479 | 11.8293 | 11.8346 | 89600.0 |
| 2011-04-15 08:15:00 | AAPL | Stock | 11.8257 | 11.8393 | 11.8214 | 11.8393 | 180264.0 |
| 2011-04-15 08:20:00 | AAPL | Stock | 11.8411 | 11.8429 | 11.8286 | 11.8286 | 33880.0 |
| 2011-04-15 08:25:00 | AAPL | Stock | 11.8304 | 11.8304 | 11.8179 | 11.8179 | 67200.0 |
| 2011-04-15 08:30:00 | AAPL | Stock | 11.8189 | 11.8493 | 11.8189 | 11.8493 | 127680.0 |
| 2011-04-15 08:35:00 | AAPL | Stock | 11.85 | 11.8504 | 11.8418 | 11.8446 | 28000.0 |
| 2011-04-15 08:40:00 | AAPL | Stock | 11.8471 | 11.8514 | 11.8471 | 11.8514 | 26600.0 |
| 2011-04-15 08:45:00 | AAPL | Stock | 11.8464 | 11.8596 | 11.8429 | 11.8554 | 166516.0 |
| 2011-04-15 08:50:00 | AAPL | Stock | 11.8468 | 11.8571 | 11.8436 | 11.8468 | 86100.0 |
| 2011-04-15 08:55:00 | AAPL | Stock | 11.8529 | 11.8571 | 11.8529 | 11.8554 | 91476.0 |
| 2011-04-15 09:00:00 | AAPL | Stock | 11.8536 | 11.8836 | 11.8536 | 11.8836 | 197148.0 |
| 2011-04-15 09:05:00 | AAPL | Stock | 11.8836 | 11.9 | 11.8836 | 11.8929 | 657916.0 |
| 2011-04-15 09:10:00 | AAPL | Stock | 11.8893 | 11.8921 | 11.875 | 11.8829 | 165508.0 |
| 2011-04-15 09:15:00 | AAPL | Stock | 11.8843 | 11.9036 | 11.8843 | 11.8989 | 197652.0 |
| 2011-04-15 09:20:00 | AAPL | Stock | 11.8968 | 11.8993 | 11.8929 | 11.8964 | 334656.0 |
| 2011-04-15 09:25:00 | AAPL | Stock | 11.8907 | 11.9189 | 11.8907 | 11.9089 | 1670256.0 |
| 2011-04-15 09:30:00 | AAPL | Stock | 11.9089 | 11.9157 | 11.8591 | 11.8607 | 13123544.0 |
| 2011-04-15 09:35:00 | AAPL | Stock | 11.8629 | 11.8654 | 11.7911 | 11.7918 | 17771768.0 |
| 2011-04-15 09:40:00 | AAPL | Stock | 11.7918 | 11.8089 | 11.7571 | 11.7732 | 25540340.0 |
| 2011-04-15 09:45:00 | AAPL | Stock | 11.7736 | 11.7907 | 11.755 | 11.7727 | 12192796.0 |
| 2011-04-15 09:50:00 | AAPL | Stock | 11.7737 | 11.8007 | 11.7721 | 11.8 | 8867852.0 |
| 2011-04-15 09:55:00 | AAPL | Stock | 11.7992 | 11.8096 | 11.7882 | 11.7932 | 8640520.0 |
| 2011-04-15 10:00:00 | AAPL | Stock | 11.7939 | 11.8082 | 11.7857 | 11.8068 | 8280944.0 |
| 2011-04-15 10:05:00 | AAPL | Stock | 11.8054 | 11.8193 | 11.7921 | 11.8084 | 8137276.0 |
| 2011-04-15 10:10:00 | AAPL | Stock | 11.8096 | 11.8107 | 11.7929 | 11.8061 | 4385108.0 |
| 2011-04-15 10:15:00 | AAPL | Stock | 11.8064 | 11.8089 | 11.7929 | 11.7963 | 4854388.0 |
| 2011-04-15 10:20:00 | AAPL | Stock | 11.7966 | 11.8018 | 11.7889 | 11.7989 | 4717328.0 |
| 2011-04-15 10:25:00 | AAPL | Stock | 11.7979 | 11.8004 | 11.7846 | 11.7911 | 5628028.0 |
| 2011-04-15 10:30:00 | AAPL | Stock | 11.7925 | 11.8143 | 11.7825 | 11.7907 | 9320248.0 |
| 2011-04-15 10:35:00 | AAPL | Stock | 11.7893 | 11.7964 | 11.7821 | 11.7957 | 3776864.0 |
| 2011-04-15 10:40:00 | AAPL | Stock | 11.7954 | 11.7964 | 11.7868 | 11.7871 | 2849056.0 |
> showing 50 of 324,570 rows — these rows as CSV