PREVIEW / stock_5min / 2013-12-26
file: by_date/stock_5min/2013/2013-12-26.parquet size: 5.2 MB rows: 345,269 symbols: 3,532
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-12-26 05:40:00 | AAPL | Stock | 20.3475 | 20.3475 | 20.3475 | 20.3475 | 5600.0 |
| 2013-12-26 06:00:00 | AAPL | Stock | 20.2893 | 20.2893 | 20.2893 | 20.2893 | 5600.0 |
| 2013-12-26 06:30:00 | AAPL | Stock | 20.2861 | 20.2861 | 20.2861 | 20.2861 | 2800.0 |
| 2013-12-26 07:30:00 | AAPL | Stock | 20.3125 | 20.3175 | 20.3125 | 20.3175 | 5600.0 |
| 2013-12-26 07:35:00 | AAPL | Stock | 20.3118 | 20.3118 | 20.3036 | 20.3036 | 23240.0 |
| 2013-12-26 07:40:00 | AAPL | Stock | 20.3118 | 20.3121 | 20.3107 | 20.3107 | 33600.0 |
| 2013-12-26 07:45:00 | AAPL | Stock | 20.3107 | 20.3207 | 20.3071 | 20.3157 | 52220.0 |
| 2013-12-26 07:50:00 | AAPL | Stock | 20.3107 | 20.3143 | 20.3107 | 20.3143 | 5600.0 |
| 2013-12-26 07:55:00 | AAPL | Stock | 20.315 | 20.3314 | 20.315 | 20.3314 | 69020.0 |
| 2013-12-26 08:00:00 | AAPL | Stock | 20.2914 | 20.3361 | 20.2914 | 20.3125 | 163044.0 |
| 2013-12-26 08:05:00 | AAPL | Stock | 20.3107 | 20.3214 | 20.3107 | 20.3114 | 62048.0 |
| 2013-12-26 08:10:00 | AAPL | Stock | 20.3214 | 20.3354 | 20.3214 | 20.3339 | 37604.0 |
| 2013-12-26 08:15:00 | AAPL | Stock | 20.3293 | 20.3379 | 20.3293 | 20.3379 | 62580.0 |
| 2013-12-26 08:20:00 | AAPL | Stock | 20.3304 | 20.3429 | 20.3125 | 20.3357 | 204932.0 |
| 2013-12-26 08:25:00 | AAPL | Stock | 20.3304 | 20.3304 | 20.3304 | 20.3304 | 19600.0 |
| 2013-12-26 08:30:00 | AAPL | Stock | 20.3304 | 20.3304 | 20.33 | 20.33 | 13300.0 |
| 2013-12-26 08:35:00 | AAPL | Stock | 20.3229 | 20.3229 | 20.2739 | 20.2739 | 161280.0 |
| 2013-12-26 08:40:00 | AAPL | Stock | 20.3125 | 20.3214 | 20.3096 | 20.3125 | 66640.0 |
| 2013-12-26 08:45:00 | AAPL | Stock | 20.3129 | 20.3211 | 20.3036 | 20.3036 | 144340.0 |
| 2013-12-26 08:50:00 | AAPL | Stock | 20.3139 | 20.3175 | 20.3089 | 20.3089 | 28000.0 |
| 2013-12-26 08:55:00 | AAPL | Stock | 20.3143 | 20.3143 | 20.2893 | 20.2914 | 70644.0 |
| 2013-12-26 09:00:00 | AAPL | Stock | 20.2964 | 20.2964 | 20.2929 | 20.2929 | 18200.0 |
| 2013-12-26 09:05:00 | AAPL | Stock | 20.3018 | 20.3018 | 20.2779 | 20.2843 | 91560.0 |
| 2013-12-26 09:10:00 | AAPL | Stock | 20.2843 | 20.2946 | 20.2843 | 20.2929 | 28000.0 |
| 2013-12-26 09:15:00 | AAPL | Stock | 20.2929 | 20.3007 | 20.2929 | 20.3007 | 8400.0 |
| 2013-12-26 09:20:00 | AAPL | Stock | 20.2946 | 20.2982 | 20.2929 | 20.2932 | 61600.0 |
| 2013-12-26 09:25:00 | AAPL | Stock | 20.2932 | 20.2961 | 20.2836 | 20.2861 | 159432.0 |
| 2013-12-26 09:30:00 | AAPL | Stock | 20.2893 | 20.3393 | 20.275 | 20.3072 | 7637224.0 |
| 2013-12-26 09:35:00 | AAPL | Stock | 20.3077 | 20.3131 | 20.1964 | 20.2107 | 7906416.0 |
| 2013-12-26 09:40:00 | AAPL | Stock | 20.2107 | 20.2432 | 20.1607 | 20.1868 | 7415268.0 |
| 2013-12-26 09:45:00 | AAPL | Stock | 20.1868 | 20.1925 | 20.1206 | 20.1307 | 7936824.0 |
| 2013-12-26 09:50:00 | AAPL | Stock | 20.1325 | 20.1964 | 20.1307 | 20.185 | 6535536.0 |
| 2013-12-26 09:55:00 | AAPL | Stock | 20.1832 | 20.1929 | 20.1393 | 20.1396 | 3826368.0 |
| 2013-12-26 10:00:00 | AAPL | Stock | 20.1396 | 20.2121 | 20.1396 | 20.1629 | 3276252.0 |
| 2013-12-26 10:05:00 | AAPL | Stock | 20.1625 | 20.1786 | 20.1507 | 20.1729 | 2182012.0 |
| 2013-12-26 10:10:00 | AAPL | Stock | 20.1725 | 20.1775 | 20.1575 | 20.1632 | 1962296.0 |
| 2013-12-26 10:15:00 | AAPL | Stock | 20.1668 | 20.1736 | 20.15 | 20.1571 | 1496320.0 |
| 2013-12-26 10:20:00 | AAPL | Stock | 20.1607 | 20.1621 | 20.1361 | 20.1568 | 2574600.0 |
| 2013-12-26 10:25:00 | AAPL | Stock | 20.1562 | 20.1729 | 20.1429 | 20.1725 | 3154788.0 |
| 2013-12-26 10:30:00 | AAPL | Stock | 20.1686 | 20.1725 | 20.1557 | 20.1668 | 2052988.0 |
| 2013-12-26 10:35:00 | AAPL | Stock | 20.1714 | 20.1764 | 20.1607 | 20.1747 | 1574664.0 |
| 2013-12-26 10:40:00 | AAPL | Stock | 20.1732 | 20.1946 | 20.1664 | 20.1925 | 2409512.0 |
| 2013-12-26 10:45:00 | AAPL | Stock | 20.1915 | 20.1993 | 20.1721 | 20.1786 | 2882348.0 |
| 2013-12-26 10:50:00 | AAPL | Stock | 20.1782 | 20.1989 | 20.1746 | 20.1949 | 1244096.0 |
| 2013-12-26 10:55:00 | AAPL | Stock | 20.1964 | 20.2051 | 20.1825 | 20.1918 | 2316972.0 |
| 2013-12-26 11:00:00 | AAPL | Stock | 20.1946 | 20.2125 | 20.1829 | 20.2111 | 2256744.0 |
| 2013-12-26 11:05:00 | AAPL | Stock | 20.2118 | 20.2325 | 20.2 | 20.2292 | 2587648.0 |
| 2013-12-26 11:10:00 | AAPL | Stock | 20.2304 | 20.2707 | 20.2275 | 20.2571 | 3571372.0 |
| 2013-12-26 11:15:00 | AAPL | Stock | 20.2557 | 20.2804 | 20.2429 | 20.2514 | 2500260.0 |
| 2013-12-26 11:20:00 | AAPL | Stock | 20.2514 | 20.2611 | 20.2418 | 20.2607 | 1233932.0 |
> showing 50 of 345,269 rows — these rows as CSV