PREVIEW / stock_5min / 2009-04-16
file: by_date/stock_5min/2009/2009-04-16.parquet size: 4.5 MB rows: 308,797 symbols: 3,344
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 |
|---|---|---|---|---|---|---|---|
| 2009-04-16 07:30:00 | AAPL | Stock | 4.1961 | 4.1961 | 4.1961 | 4.1961 | 5600.0 |
| 2009-04-16 08:00:00 | AAPL | Stock | 4.1961 | 4.1982 | 4.1893 | 4.1893 | 118748.0 |
| 2009-04-16 08:05:00 | AAPL | Stock | 4.1893 | 4.1893 | 4.1893 | 4.1893 | 31780.0 |
| 2009-04-16 08:10:00 | AAPL | Stock | 4.1964 | 4.1964 | 4.1964 | 4.1964 | 8400.0 |
| 2009-04-16 08:15:00 | AAPL | Stock | 4.1964 | 4.2071 | 4.1964 | 4.2071 | 47600.0 |
| 2009-04-16 08:20:00 | AAPL | Stock | 4.2071 | 4.2143 | 4.2071 | 4.2079 | 90944.0 |
| 2009-04-16 08:25:00 | AAPL | Stock | 4.2054 | 4.2125 | 4.2054 | 4.2125 | 13608.0 |
| 2009-04-16 08:30:00 | AAPL | Stock | 4.2136 | 4.2286 | 4.2107 | 4.2286 | 103320.0 |
| 2009-04-16 08:35:00 | AAPL | Stock | 4.2214 | 4.2286 | 4.2214 | 4.225 | 38780.0 |
| 2009-04-16 08:40:00 | AAPL | Stock | 4.2321 | 4.2429 | 4.2286 | 4.2286 | 109256.0 |
| 2009-04-16 08:45:00 | AAPL | Stock | 4.225 | 4.2461 | 4.225 | 4.2421 | 122304.0 |
| 2009-04-16 08:50:00 | AAPL | Stock | 4.2421 | 4.2443 | 4.2357 | 4.2393 | 84280.0 |
| 2009-04-16 08:55:00 | AAPL | Stock | 4.2361 | 4.2361 | 4.2357 | 4.2361 | 12656.0 |
| 2009-04-16 09:00:00 | AAPL | Stock | 4.2361 | 4.2407 | 4.2361 | 4.2375 | 88480.0 |
| 2009-04-16 09:05:00 | AAPL | Stock | 4.2425 | 4.2429 | 4.2393 | 4.2429 | 51800.0 |
| 2009-04-16 09:10:00 | AAPL | Stock | 4.2436 | 4.2489 | 4.2429 | 4.2461 | 121520.0 |
| 2009-04-16 09:15:00 | AAPL | Stock | 4.2432 | 4.2454 | 4.2421 | 4.2421 | 25200.0 |
| 2009-04-16 09:20:00 | AAPL | Stock | 4.2446 | 4.2479 | 4.2446 | 4.2471 | 92120.0 |
| 2009-04-16 09:25:00 | AAPL | Stock | 4.2482 | 4.2625 | 4.2014 | 4.2571 | 7635264.0 |
| 2009-04-16 09:30:00 | AAPL | Stock | 4.2564 | 4.2636 | 4.2446 | 4.2471 | 16447844.0 |
| 2009-04-16 09:35:00 | AAPL | Stock | 4.2475 | 4.2696 | 4.2446 | 4.2668 | 12035352.0 |
| 2009-04-16 09:40:00 | AAPL | Stock | 4.2664 | 4.275 | 4.2586 | 4.2686 | 7690592.0 |
| 2009-04-16 09:45:00 | AAPL | Stock | 4.2679 | 4.2714 | 4.2518 | 4.2518 | 8552656.0 |
| 2009-04-16 09:50:00 | AAPL | Stock | 4.2525 | 4.2539 | 4.2425 | 4.2482 | 9492896.0 |
| 2009-04-16 09:55:00 | AAPL | Stock | 4.2482 | 4.2746 | 4.2482 | 4.2741 | 9430540.0 |
| 2009-04-16 10:00:00 | AAPL | Stock | 4.2746 | 4.2807 | 4.2668 | 4.2721 | 8856400.0 |
| 2009-04-16 10:05:00 | AAPL | Stock | 4.2725 | 4.2786 | 4.2711 | 4.2786 | 7604912.0 |
| 2009-04-16 10:10:00 | AAPL | Stock | 4.2786 | 4.28 | 4.2696 | 4.2779 | 7124880.0 |
| 2009-04-16 10:15:00 | AAPL | Stock | 4.2775 | 4.2929 | 4.2775 | 4.2907 | 11112024.0 |
| 2009-04-16 10:20:00 | AAPL | Stock | 4.2899 | 4.3025 | 4.2854 | 4.2864 | 9116576.0 |
| 2009-04-16 10:25:00 | AAPL | Stock | 4.2864 | 4.3018 | 4.2857 | 4.2992 | 5708724.0 |
| 2009-04-16 10:30:00 | AAPL | Stock | 4.2989 | 4.3161 | 4.2989 | 4.3129 | 10676064.0 |
| 2009-04-16 10:35:00 | AAPL | Stock | 4.3125 | 4.3168 | 4.3018 | 4.3021 | 8159004.0 |
| 2009-04-16 10:40:00 | AAPL | Stock | 4.3018 | 4.3018 | 4.2879 | 4.2886 | 5890080.0 |
| 2009-04-16 10:45:00 | AAPL | Stock | 4.2882 | 4.2896 | 4.2679 | 4.2782 | 10402868.0 |
| 2009-04-16 10:50:00 | AAPL | Stock | 4.2781 | 4.2781 | 4.2657 | 4.2657 | 5103196.0 |
| 2009-04-16 10:55:00 | AAPL | Stock | 4.2664 | 4.2714 | 4.2575 | 4.2689 | 5997516.0 |
| 2009-04-16 11:00:00 | AAPL | Stock | 4.2689 | 4.2757 | 4.2689 | 4.2707 | 4750060.0 |
| 2009-04-16 11:05:00 | AAPL | Stock | 4.2711 | 4.2839 | 4.2696 | 4.2827 | 4213916.0 |
| 2009-04-16 11:10:00 | AAPL | Stock | 4.2825 | 4.2875 | 4.2796 | 4.2846 | 5239416.0 |
| 2009-04-16 11:15:00 | AAPL | Stock | 4.285 | 4.285 | 4.2754 | 4.2811 | 3856720.0 |
| 2009-04-16 11:20:00 | AAPL | Stock | 4.2807 | 4.2921 | 4.2793 | 4.2886 | 5767776.0 |
| 2009-04-16 11:25:00 | AAPL | Stock | 4.2886 | 4.2968 | 4.2886 | 4.2964 | 5370260.0 |
| 2009-04-16 11:30:00 | AAPL | Stock | 4.2954 | 4.3029 | 4.2886 | 4.2925 | 6754888.0 |
| 2009-04-16 11:35:00 | AAPL | Stock | 4.2925 | 4.3107 | 4.2925 | 4.3094 | 7407064.0 |
| 2009-04-16 11:40:00 | AAPL | Stock | 4.31 | 4.32 | 4.3093 | 4.3186 | 8264928.0 |
| 2009-04-16 11:45:00 | AAPL | Stock | 4.3189 | 4.3204 | 4.3107 | 4.3125 | 5911416.0 |
| 2009-04-16 11:50:00 | AAPL | Stock | 4.3125 | 4.3139 | 4.3089 | 4.3125 | 2805460.0 |
| 2009-04-16 11:55:00 | AAPL | Stock | 4.3132 | 4.3132 | 4.2996 | 4.3011 | 4434696.0 |
| 2009-04-16 12:00:00 | AAPL | Stock | 4.3018 | 4.305 | 4.2979 | 4.3036 | 2965368.0 |
> showing 50 of 308,797 rows — these rows as CSV