PREVIEW / stock_5min / 2011-02-03
file: by_date/stock_5min/2011/2011-02-03.parquet size: 4.8 MB rows: 325,422 symbols: 3,522
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-02-03 06:25:00 | AAPL | Stock | 12.2911 | 12.2911 | 12.2911 | 12.2911 | 2800.0 |
| 2011-02-03 07:00:00 | AAPL | Stock | 12.2664 | 12.2664 | 12.2607 | 12.2657 | 11200.0 |
| 2011-02-03 07:05:00 | AAPL | Stock | 12.2775 | 12.2775 | 12.2714 | 12.2714 | 22400.0 |
| 2011-02-03 07:20:00 | AAPL | Stock | 12.2757 | 12.2757 | 12.2725 | 12.2725 | 18200.0 |
| 2011-02-03 07:25:00 | AAPL | Stock | 12.2746 | 12.2746 | 12.2746 | 12.2746 | 2800.0 |
| 2011-02-03 07:30:00 | AAPL | Stock | 12.2693 | 12.2693 | 12.2693 | 12.2693 | 5600.0 |
| 2011-02-03 07:35:00 | AAPL | Stock | 12.2679 | 12.2679 | 12.2679 | 12.2679 | 8400.0 |
| 2011-02-03 07:40:00 | AAPL | Stock | 12.2689 | 12.2689 | 12.2689 | 12.2689 | 2800.0 |
| 2011-02-03 07:45:00 | AAPL | Stock | 12.2693 | 12.2693 | 12.2679 | 12.2679 | 14000.0 |
| 2011-02-03 07:55:00 | AAPL | Stock | 12.2679 | 12.2679 | 12.2621 | 12.2621 | 5600.0 |
| 2011-02-03 08:00:00 | AAPL | Stock | 12.2711 | 12.2711 | 12.2546 | 12.2607 | 51604.0 |
| 2011-02-03 08:05:00 | AAPL | Stock | 12.2604 | 12.2607 | 12.245 | 12.2564 | 341040.0 |
| 2011-02-03 08:10:00 | AAPL | Stock | 12.2504 | 12.2543 | 12.245 | 12.245 | 68572.0 |
| 2011-02-03 08:15:00 | AAPL | Stock | 12.2493 | 12.2493 | 12.2386 | 12.2386 | 85372.0 |
| 2011-02-03 08:20:00 | AAPL | Stock | 12.2386 | 12.25 | 12.2386 | 12.25 | 201460.0 |
| 2011-02-03 08:25:00 | AAPL | Stock | 12.25 | 12.2536 | 12.25 | 12.2504 | 38808.0 |
| 2011-02-03 08:30:00 | AAPL | Stock | 12.2571 | 12.2675 | 12.2571 | 12.2575 | 219436.0 |
| 2011-02-03 08:35:00 | AAPL | Stock | 12.2643 | 12.2671 | 12.2579 | 12.2643 | 54880.0 |
| 2011-02-03 08:40:00 | AAPL | Stock | 12.2661 | 12.2821 | 12.2661 | 12.2821 | 64400.0 |
| 2011-02-03 08:45:00 | AAPL | Stock | 12.2757 | 12.2768 | 12.2725 | 12.2743 | 36400.0 |
| 2011-02-03 08:50:00 | AAPL | Stock | 12.275 | 12.2789 | 12.2732 | 12.2757 | 61600.0 |
| 2011-02-03 08:55:00 | AAPL | Stock | 12.2796 | 12.2796 | 12.2679 | 12.2679 | 45780.0 |
| 2011-02-03 09:00:00 | AAPL | Stock | 12.2643 | 12.2675 | 12.2593 | 12.2675 | 29120.0 |
| 2011-02-03 09:05:00 | AAPL | Stock | 12.2679 | 12.2768 | 12.2679 | 12.2768 | 116788.0 |
| 2011-02-03 09:10:00 | AAPL | Stock | 12.2807 | 12.2821 | 12.2786 | 12.2786 | 82600.0 |
| 2011-02-03 09:15:00 | AAPL | Stock | 12.2804 | 12.2811 | 12.2768 | 12.2793 | 154000.0 |
| 2011-02-03 09:20:00 | AAPL | Stock | 12.28 | 12.2857 | 12.2793 | 12.2839 | 86212.0 |
| 2011-02-03 09:25:00 | AAPL | Stock | 12.2836 | 12.2836 | 12.2768 | 12.2786 | 59080.0 |
| 2011-02-03 09:30:00 | AAPL | Stock | 12.2768 | 12.2829 | 12.25 | 12.2543 | 8630160.0 |
| 2011-02-03 09:35:00 | AAPL | Stock | 12.2543 | 12.2714 | 12.25 | 12.2668 | 5419652.0 |
| 2011-02-03 09:40:00 | AAPL | Stock | 12.2661 | 12.2689 | 12.2443 | 12.247 | 6773984.0 |
| 2011-02-03 09:45:00 | AAPL | Stock | 12.2479 | 12.2625 | 12.2421 | 12.2614 | 5740588.0 |
| 2011-02-03 09:50:00 | AAPL | Stock | 12.2607 | 12.2621 | 12.25 | 12.2568 | 3950044.0 |
| 2011-02-03 09:55:00 | AAPL | Stock | 12.2568 | 12.2589 | 12.2349 | 12.245 | 9236640.0 |
| 2011-02-03 10:00:00 | AAPL | Stock | 12.2436 | 12.2564 | 12.2179 | 12.225 | 7025172.0 |
| 2011-02-03 10:05:00 | AAPL | Stock | 12.2243 | 12.2282 | 12.1979 | 12.2082 | 10023076.0 |
| 2011-02-03 10:10:00 | AAPL | Stock | 12.2079 | 12.2086 | 12.12 | 12.1329 | 23633652.0 |
| 2011-02-03 10:15:00 | AAPL | Stock | 12.1329 | 12.1482 | 12.0911 | 12.1346 | 26600196.0 |
| 2011-02-03 10:20:00 | AAPL | Stock | 12.1361 | 12.1621 | 12.1268 | 12.1529 | 13667080.0 |
| 2011-02-03 10:25:00 | AAPL | Stock | 12.1514 | 12.1639 | 12.1332 | 12.1536 | 10752476.0 |
| 2011-02-03 10:30:00 | AAPL | Stock | 12.1536 | 12.1536 | 12.1339 | 12.1493 | 6827716.0 |
| 2011-02-03 10:35:00 | AAPL | Stock | 12.1504 | 12.1914 | 12.1432 | 12.1842 | 10470544.0 |
| 2011-02-03 10:40:00 | AAPL | Stock | 12.1832 | 12.1929 | 12.175 | 12.1879 | 7016800.0 |
| 2011-02-03 10:45:00 | AAPL | Stock | 12.1879 | 12.1982 | 12.1857 | 12.1889 | 6044304.0 |
| 2011-02-03 10:50:00 | AAPL | Stock | 12.1904 | 12.1989 | 12.1843 | 12.1927 | 3930836.0 |
| 2011-02-03 10:55:00 | AAPL | Stock | 12.1914 | 12.1979 | 12.1861 | 12.1875 | 4298644.0 |
| 2011-02-03 11:00:00 | AAPL | Stock | 12.1889 | 12.195 | 12.1829 | 12.1868 | 4183900.0 |
| 2011-02-03 11:05:00 | AAPL | Stock | 12.1871 | 12.1889 | 12.1679 | 12.1704 | 6413680.0 |
| 2011-02-03 11:10:00 | AAPL | Stock | 12.1704 | 12.1964 | 12.1625 | 12.1932 | 4100124.0 |
| 2011-02-03 11:15:00 | AAPL | Stock | 12.1936 | 12.2071 | 12.1818 | 12.1971 | 5185152.0 |
> showing 50 of 325,422 rows — these rows as CSV