PREVIEW / stock_5min / 2011-11-10
file: by_date/stock_5min/2011/2011-11-10.parquet size: 4.7 MB rows: 322,258 symbols: 3,489
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-11-10 04:05:00 | AAPL | Stock | 14.1429 | 14.1429 | 14.1429 | 14.1429 | 28000.0 |
| 2011-11-10 04:10:00 | AAPL | Stock | 14.1607 | 14.1607 | 14.1607 | 14.1607 | 13720.0 |
| 2011-11-10 04:25:00 | AAPL | Stock | 14.1514 | 14.1514 | 14.1514 | 14.1514 | 2800.0 |
| 2011-11-10 04:40:00 | AAPL | Stock | 14.175 | 14.1786 | 14.175 | 14.1786 | 14000.0 |
| 2011-11-10 04:45:00 | AAPL | Stock | 14.1971 | 14.1971 | 14.1971 | 14.1971 | 5600.0 |
| 2011-11-10 05:25:00 | AAPL | Stock | 14.1875 | 14.1875 | 14.1875 | 14.1875 | 2800.0 |
| 2011-11-10 07:00:00 | AAPL | Stock | 14.1875 | 14.2089 | 14.1871 | 14.2089 | 30800.0 |
| 2011-11-10 07:05:00 | AAPL | Stock | 14.2054 | 14.2861 | 14.2054 | 14.2239 | 275044.0 |
| 2011-11-10 07:10:00 | AAPL | Stock | 14.2164 | 14.2164 | 14.1964 | 14.1964 | 168000.0 |
| 2011-11-10 07:15:00 | AAPL | Stock | 14.2132 | 14.23 | 14.2132 | 14.225 | 166880.0 |
| 2011-11-10 07:20:00 | AAPL | Stock | 14.225 | 14.2568 | 14.2232 | 14.2507 | 345856.0 |
| 2011-11-10 07:25:00 | AAPL | Stock | 14.2536 | 14.2571 | 14.2371 | 14.2411 | 43120.0 |
| 2011-11-10 07:30:00 | AAPL | Stock | 14.2464 | 14.2464 | 14.2411 | 14.2446 | 81480.0 |
| 2011-11-10 07:35:00 | AAPL | Stock | 14.2446 | 14.25 | 14.2321 | 14.2321 | 149716.0 |
| 2011-11-10 07:40:00 | AAPL | Stock | 14.2389 | 14.2571 | 14.2389 | 14.2568 | 124460.0 |
| 2011-11-10 07:45:00 | AAPL | Stock | 14.2429 | 14.2521 | 14.24 | 14.2496 | 133952.0 |
| 2011-11-10 07:50:00 | AAPL | Stock | 14.2446 | 14.2446 | 14.2304 | 14.2304 | 146972.0 |
| 2011-11-10 07:55:00 | AAPL | Stock | 14.2314 | 14.2314 | 14.2207 | 14.2214 | 66640.0 |
| 2011-11-10 08:00:00 | AAPL | Stock | 14.2168 | 14.25 | 14.2 | 14.2143 | 524972.0 |
| 2011-11-10 08:05:00 | AAPL | Stock | 14.2146 | 14.2146 | 14.1964 | 14.1982 | 419188.0 |
| 2011-11-10 08:10:00 | AAPL | Stock | 14.2036 | 14.2089 | 14.1986 | 14.2089 | 91784.0 |
| 2011-11-10 08:15:00 | AAPL | Stock | 14.2043 | 14.2071 | 14.2036 | 14.2057 | 141820.0 |
| 2011-11-10 08:20:00 | AAPL | Stock | 14.2018 | 14.2139 | 14.2018 | 14.2139 | 146916.0 |
| 2011-11-10 08:25:00 | AAPL | Stock | 14.2114 | 14.2114 | 14.2054 | 14.2093 | 112840.0 |
| 2011-11-10 08:30:00 | AAPL | Stock | 14.2107 | 14.2196 | 14.2071 | 14.2125 | 349720.0 |
| 2011-11-10 08:35:00 | AAPL | Stock | 14.2164 | 14.2214 | 14.2071 | 14.2071 | 151228.0 |
| 2011-11-10 08:40:00 | AAPL | Stock | 14.2089 | 14.2089 | 14.1979 | 14.1979 | 99120.0 |
| 2011-11-10 08:45:00 | AAPL | Stock | 14.2054 | 14.2111 | 14.2054 | 14.2068 | 67648.0 |
| 2011-11-10 08:50:00 | AAPL | Stock | 14.2096 | 14.2279 | 14.2096 | 14.2214 | 336644.0 |
| 2011-11-10 08:55:00 | AAPL | Stock | 14.2229 | 14.2354 | 14.2229 | 14.2307 | 284844.0 |
| 2011-11-10 09:00:00 | AAPL | Stock | 14.2286 | 14.2314 | 14.2218 | 14.2218 | 235480.0 |
| 2011-11-10 09:05:00 | AAPL | Stock | 14.2218 | 14.2225 | 14.2146 | 14.2157 | 198716.0 |
| 2011-11-10 09:10:00 | AAPL | Stock | 14.2154 | 14.2211 | 14.2146 | 14.2211 | 42700.0 |
| 2011-11-10 09:15:00 | AAPL | Stock | 14.2171 | 14.2179 | 14.2071 | 14.2089 | 80500.0 |
| 2011-11-10 09:20:00 | AAPL | Stock | 14.2093 | 14.2093 | 14.1893 | 14.1946 | 415884.0 |
| 2011-11-10 09:25:00 | AAPL | Stock | 14.1918 | 14.1964 | 14.1786 | 14.1789 | 628684.0 |
| 2011-11-10 09:30:00 | AAPL | Stock | 14.1825 | 14.1861 | 14.0796 | 14.0954 | 19319160.0 |
| 2011-11-10 09:35:00 | AAPL | Stock | 14.0954 | 14.1024 | 14.0275 | 14.0382 | 20852328.0 |
| 2011-11-10 09:40:00 | AAPL | Stock | 14.0341 | 14.0429 | 13.9589 | 14.0042 | 20881196.0 |
| 2011-11-10 09:45:00 | AAPL | Stock | 14.0042 | 14.0221 | 13.9825 | 14.0023 | 14272804.0 |
| 2011-11-10 09:50:00 | AAPL | Stock | 14.0022 | 14.0054 | 13.9129 | 13.9196 | 23578856.0 |
| 2011-11-10 09:55:00 | AAPL | Stock | 13.918 | 13.9207 | 13.8254 | 13.8571 | 32426716.0 |
| 2011-11-10 10:00:00 | AAPL | Stock | 13.8571 | 13.8639 | 13.7743 | 13.8086 | 29711612.0 |
| 2011-11-10 10:05:00 | AAPL | Stock | 13.8029 | 13.8354 | 13.8004 | 13.8285 | 22098300.0 |
| 2011-11-10 10:10:00 | AAPL | Stock | 13.8286 | 13.8446 | 13.8057 | 13.8307 | 14265132.0 |
| 2011-11-10 10:15:00 | AAPL | Stock | 13.8293 | 13.8511 | 13.7821 | 13.7843 | 16321704.0 |
| 2011-11-10 10:20:00 | AAPL | Stock | 13.7852 | 13.7864 | 13.6625 | 13.6857 | 36002512.0 |
| 2011-11-10 10:25:00 | AAPL | Stock | 13.6854 | 13.7604 | 13.6832 | 13.7315 | 19542040.0 |
| 2011-11-10 10:30:00 | AAPL | Stock | 13.7314 | 13.7543 | 13.7064 | 13.7332 | 13306804.0 |
| 2011-11-10 10:35:00 | AAPL | Stock | 13.7321 | 13.7607 | 13.7107 | 13.7607 | 14141148.0 |
> showing 50 of 322,258 rows — these rows as CSV