PREVIEW / stock_5min / 2010-07-13
file: by_date/stock_5min/2010/2010-07-13.parquet size: 4.7 MB rows: 326,302 symbols: 3,479
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 |
|---|---|---|---|---|---|---|---|
| 2010-07-13 05:35:00 | AAPL | Stock | 9.2675 | 9.2675 | 9.2675 | 9.2675 | 2800.0 |
| 2010-07-13 06:45:00 | AAPL | Stock | 9.2661 | 9.2661 | 9.2661 | 9.2661 | 2800.0 |
| 2010-07-13 07:00:00 | AAPL | Stock | 9.2018 | 9.2018 | 9.2018 | 9.2018 | 2800.0 |
| 2010-07-13 07:05:00 | AAPL | Stock | 9.2057 | 9.2057 | 9.2057 | 9.2057 | 2800.0 |
| 2010-07-13 07:20:00 | AAPL | Stock | 9.2407 | 9.2407 | 9.2321 | 9.2321 | 44800.0 |
| 2010-07-13 07:25:00 | AAPL | Stock | 9.2325 | 9.2464 | 9.2325 | 9.2464 | 19600.0 |
| 2010-07-13 07:30:00 | AAPL | Stock | 9.2411 | 9.2429 | 9.2411 | 9.2411 | 24444.0 |
| 2010-07-13 07:35:00 | AAPL | Stock | 9.2379 | 9.2464 | 9.2357 | 9.2368 | 126756.0 |
| 2010-07-13 07:40:00 | AAPL | Stock | 9.2321 | 9.2329 | 9.2321 | 9.2329 | 11200.0 |
| 2010-07-13 07:45:00 | AAPL | Stock | 9.2346 | 9.2346 | 9.2346 | 9.2346 | 2800.0 |
| 2010-07-13 07:50:00 | AAPL | Stock | 9.225 | 9.225 | 9.2221 | 9.2221 | 11200.0 |
| 2010-07-13 07:55:00 | AAPL | Stock | 9.2321 | 9.2339 | 9.2318 | 9.2321 | 22400.0 |
| 2010-07-13 08:00:00 | AAPL | Stock | 9.2286 | 9.2464 | 9.22 | 9.225 | 226016.0 |
| 2010-07-13 08:05:00 | AAPL | Stock | 9.2329 | 9.2411 | 9.2314 | 9.235 | 270928.0 |
| 2010-07-13 08:10:00 | AAPL | Stock | 9.2293 | 9.2336 | 9.2068 | 9.2232 | 220556.0 |
| 2010-07-13 08:15:00 | AAPL | Stock | 9.2261 | 9.2357 | 9.225 | 9.2318 | 69160.0 |
| 2010-07-13 08:20:00 | AAPL | Stock | 9.225 | 9.2404 | 9.2236 | 9.2321 | 373268.0 |
| 2010-07-13 08:25:00 | AAPL | Stock | 9.2343 | 9.2343 | 9.2279 | 9.2286 | 88200.0 |
| 2010-07-13 08:30:00 | AAPL | Stock | 9.2268 | 9.2321 | 9.2268 | 9.2314 | 72800.0 |
| 2010-07-13 08:35:00 | AAPL | Stock | 9.2332 | 9.2332 | 9.2289 | 9.2289 | 73080.0 |
| 2010-07-13 08:40:00 | AAPL | Stock | 9.2279 | 9.2314 | 9.2239 | 9.2239 | 76300.0 |
| 2010-07-13 08:45:00 | AAPL | Stock | 9.2232 | 9.2329 | 9.2179 | 9.2264 | 323568.0 |
| 2010-07-13 08:50:00 | AAPL | Stock | 9.2246 | 9.2246 | 9.2168 | 9.2186 | 387296.0 |
| 2010-07-13 08:55:00 | AAPL | Stock | 9.2186 | 9.2186 | 9.1893 | 9.1911 | 1119804.0 |
| 2010-07-13 09:00:00 | AAPL | Stock | 9.1961 | 9.2214 | 9.1832 | 9.1921 | 636580.0 |
| 2010-07-13 09:05:00 | AAPL | Stock | 9.1946 | 9.1957 | 9.1857 | 9.1857 | 1498952.0 |
| 2010-07-13 09:10:00 | AAPL | Stock | 9.1854 | 9.1911 | 9.175 | 9.1821 | 1152676.0 |
| 2010-07-13 09:15:00 | AAPL | Stock | 9.1796 | 9.1839 | 9.1621 | 9.1636 | 890736.0 |
| 2010-07-13 09:20:00 | AAPL | Stock | 9.165 | 9.1679 | 9.1532 | 9.1621 | 1381436.0 |
| 2010-07-13 09:25:00 | AAPL | Stock | 9.1607 | 9.1689 | 9.1536 | 9.1546 | 714028.0 |
| 2010-07-13 09:30:00 | AAPL | Stock | 9.1557 | 9.1571 | 9.0643 | 9.0654 | 39836692.0 |
| 2010-07-13 09:35:00 | AAPL | Stock | 9.0643 | 9.0986 | 8.9661 | 9.0282 | 42324072.0 |
| 2010-07-13 09:40:00 | AAPL | Stock | 9.027 | 9.0346 | 8.9429 | 8.9893 | 43636376.0 |
| 2010-07-13 09:45:00 | AAPL | Stock | 8.9902 | 8.9957 | 8.8842 | 8.8929 | 48996892.0 |
| 2010-07-13 09:50:00 | AAPL | Stock | 8.891 | 8.925 | 8.8011 | 8.9071 | 89222700.0 |
| 2010-07-13 09:55:00 | AAPL | Stock | 8.9054 | 8.9268 | 8.8718 | 8.9214 | 38312652.0 |
| 2010-07-13 10:00:00 | AAPL | Stock | 8.9214 | 8.9525 | 8.905 | 8.9375 | 34244756.0 |
| 2010-07-13 10:05:00 | AAPL | Stock | 8.9375 | 8.95 | 8.9161 | 8.9193 | 23994348.0 |
| 2010-07-13 10:10:00 | AAPL | Stock | 8.9189 | 8.9211 | 8.8768 | 8.9057 | 32139212.0 |
| 2010-07-13 10:15:00 | AAPL | Stock | 8.9054 | 8.9107 | 8.8811 | 8.8986 | 17736768.0 |
| 2010-07-13 10:20:00 | AAPL | Stock | 8.8982 | 8.9264 | 8.8843 | 8.8864 | 19021324.0 |
| 2010-07-13 10:25:00 | AAPL | Stock | 8.8864 | 8.8929 | 8.8464 | 8.8871 | 24303832.0 |
| 2010-07-13 10:30:00 | AAPL | Stock | 8.8871 | 8.8896 | 8.8514 | 8.8571 | 23548196.0 |
| 2010-07-13 10:35:00 | AAPL | Stock | 8.8571 | 8.8575 | 8.8229 | 8.8499 | 26887700.0 |
| 2010-07-13 10:40:00 | AAPL | Stock | 8.85 | 8.8511 | 8.8011 | 8.8241 | 23915416.0 |
| 2010-07-13 10:45:00 | AAPL | Stock | 8.8218 | 8.8518 | 8.8164 | 8.8471 | 15866032.0 |
| 2010-07-13 10:50:00 | AAPL | Stock | 8.8471 | 8.8704 | 8.8432 | 8.8471 | 14739144.0 |
| 2010-07-13 10:55:00 | AAPL | Stock | 8.8468 | 8.865 | 8.8418 | 8.8605 | 11981368.0 |
| 2010-07-13 11:00:00 | AAPL | Stock | 8.8597 | 8.8964 | 8.8571 | 8.8943 | 17734584.0 |
| 2010-07-13 11:05:00 | AAPL | Stock | 8.8946 | 8.9064 | 8.8779 | 8.8939 | 15899240.0 |
> showing 50 of 326,302 rows — these rows as CSV