PREVIEW / stock_5min / 2013-09-06
file: by_date/stock_5min/2013/2013-09-06.parquet size: 5.1 MB rows: 336,941 symbols: 3,507
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-06 05:25:00 | AAPL | Stock | 17.7696 | 17.7696 | 17.7696 | 17.7696 | 12040.0 |
| 2013-09-06 05:30:00 | AAPL | Stock | 17.7607 | 17.7607 | 17.7607 | 17.7607 | 2800.0 |
| 2013-09-06 05:45:00 | AAPL | Stock | 17.7657 | 17.7657 | 17.7657 | 17.7657 | 2800.0 |
| 2013-09-06 05:55:00 | AAPL | Stock | 17.7661 | 17.7661 | 17.7657 | 17.7657 | 5600.0 |
| 2013-09-06 06:15:00 | AAPL | Stock | 17.7661 | 17.7661 | 17.7661 | 17.7661 | 2800.0 |
| 2013-09-06 06:20:00 | AAPL | Stock | 17.7814 | 17.7814 | 17.7814 | 17.7814 | 2800.0 |
| 2013-09-06 07:00:00 | AAPL | Stock | 17.7996 | 17.8 | 17.7996 | 17.8 | 6272.0 |
| 2013-09-06 07:05:00 | AAPL | Stock | 17.8018 | 17.8021 | 17.8011 | 17.8018 | 25368.0 |
| 2013-09-06 07:10:00 | AAPL | Stock | 17.8014 | 17.8018 | 17.7857 | 17.7861 | 75600.0 |
| 2013-09-06 07:15:00 | AAPL | Stock | 17.7946 | 17.8179 | 17.7946 | 17.8179 | 68880.0 |
| 2013-09-06 07:20:00 | AAPL | Stock | 17.8171 | 17.8357 | 17.8071 | 17.8214 | 124376.0 |
| 2013-09-06 07:25:00 | AAPL | Stock | 17.8211 | 17.8211 | 17.7864 | 17.8032 | 56252.0 |
| 2013-09-06 07:30:00 | AAPL | Stock | 17.8036 | 17.8036 | 17.8029 | 17.8036 | 15596.0 |
| 2013-09-06 07:35:00 | AAPL | Stock | 17.8089 | 17.8089 | 17.8089 | 17.8089 | 2800.0 |
| 2013-09-06 07:40:00 | AAPL | Stock | 17.8039 | 17.8125 | 17.8039 | 17.8071 | 19852.0 |
| 2013-09-06 07:45:00 | AAPL | Stock | 17.8157 | 17.8479 | 17.8157 | 17.8411 | 233688.0 |
| 2013-09-06 07:50:00 | AAPL | Stock | 17.8386 | 17.8393 | 17.8268 | 17.8282 | 48720.0 |
| 2013-09-06 07:55:00 | AAPL | Stock | 17.8286 | 17.8393 | 17.8271 | 17.8393 | 55664.0 |
| 2013-09-06 08:00:00 | AAPL | Stock | 17.8393 | 17.8532 | 17.7686 | 17.8429 | 537740.0 |
| 2013-09-06 08:05:00 | AAPL | Stock | 17.8475 | 17.8489 | 17.8214 | 17.8236 | 189168.0 |
| 2013-09-06 08:10:00 | AAPL | Stock | 17.8171 | 17.8179 | 17.8 | 17.8046 | 204316.0 |
| 2013-09-06 08:15:00 | AAPL | Stock | 17.8118 | 17.8157 | 17.7946 | 17.7979 | 162400.0 |
| 2013-09-06 08:20:00 | AAPL | Stock | 17.8071 | 17.815 | 17.7964 | 17.815 | 280364.0 |
| 2013-09-06 08:25:00 | AAPL | Stock | 17.8125 | 17.8146 | 17.7982 | 17.8036 | 329700.0 |
| 2013-09-06 08:30:00 | AAPL | Stock | 17.7946 | 17.8321 | 17.7857 | 17.7964 | 792176.0 |
| 2013-09-06 08:35:00 | AAPL | Stock | 17.7996 | 17.8014 | 17.7696 | 17.7786 | 322336.0 |
| 2013-09-06 08:40:00 | AAPL | Stock | 17.7843 | 17.8071 | 17.7754 | 17.8043 | 253288.0 |
| 2013-09-06 08:45:00 | AAPL | Stock | 17.8093 | 17.8268 | 17.8093 | 17.8111 | 331884.0 |
| 2013-09-06 08:50:00 | AAPL | Stock | 17.8132 | 17.8275 | 17.81 | 17.825 | 139916.0 |
| 2013-09-06 08:55:00 | AAPL | Stock | 17.825 | 17.8264 | 17.8111 | 17.8218 | 355180.0 |
| 2013-09-06 09:00:00 | AAPL | Stock | 17.8218 | 17.8264 | 17.8 | 17.8007 | 194236.0 |
| 2013-09-06 09:05:00 | AAPL | Stock | 17.8021 | 17.8021 | 17.7932 | 17.8011 | 175924.0 |
| 2013-09-06 09:10:00 | AAPL | Stock | 17.8018 | 17.8018 | 17.7921 | 17.7929 | 121436.0 |
| 2013-09-06 09:15:00 | AAPL | Stock | 17.7961 | 17.8 | 17.7904 | 17.7943 | 287224.0 |
| 2013-09-06 09:20:00 | AAPL | Stock | 17.7918 | 17.8214 | 17.7911 | 17.8164 | 597184.0 |
| 2013-09-06 09:25:00 | AAPL | Stock | 17.8143 | 17.8179 | 17.8007 | 17.805 | 286300.0 |
| 2013-09-06 09:30:00 | AAPL | Stock | 17.8046 | 17.8196 | 17.7514 | 17.7696 | 16063796.0 |
| 2013-09-06 09:35:00 | AAPL | Stock | 17.7675 | 17.77 | 17.6925 | 17.7089 | 12471396.0 |
| 2013-09-06 09:40:00 | AAPL | Stock | 17.7111 | 17.7193 | 17.6796 | 17.6953 | 9110388.0 |
| 2013-09-06 09:45:00 | AAPL | Stock | 17.6954 | 17.6971 | 17.6257 | 17.6529 | 11383484.0 |
| 2013-09-06 09:50:00 | AAPL | Stock | 17.6482 | 17.6743 | 17.62 | 17.6543 | 12120332.0 |
| 2013-09-06 09:55:00 | AAPL | Stock | 17.6518 | 17.6518 | 17.5739 | 17.5893 | 9586248.0 |
| 2013-09-06 10:00:00 | AAPL | Stock | 17.5861 | 17.5989 | 17.4982 | 17.5136 | 13903036.0 |
| 2013-09-06 10:05:00 | AAPL | Stock | 17.5136 | 17.5904 | 17.5082 | 17.5904 | 10218824.0 |
| 2013-09-06 10:10:00 | AAPL | Stock | 17.5882 | 17.6236 | 17.5796 | 17.6111 | 10322816.0 |
| 2013-09-06 10:15:00 | AAPL | Stock | 17.6111 | 17.6536 | 17.6004 | 17.6304 | 7940744.0 |
| 2013-09-06 10:20:00 | AAPL | Stock | 17.6311 | 17.6346 | 17.5925 | 17.5964 | 3659348.0 |
| 2013-09-06 10:25:00 | AAPL | Stock | 17.5961 | 17.6448 | 17.5907 | 17.6275 | 4222540.0 |
| 2013-09-06 10:30:00 | AAPL | Stock | 17.6275 | 17.6607 | 17.6107 | 17.6561 | 3200932.0 |
| 2013-09-06 10:35:00 | AAPL | Stock | 17.6518 | 17.6854 | 17.6464 | 17.6754 | 6230364.0 |
> showing 50 of 336,941 rows — these rows as CSV