PREVIEW / stock_5min / 2009-11-19
file: by_date/stock_5min/2009/2009-11-19.parquet size: 4.6 MB rows: 317,523 symbols: 3,403
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-11-19 05:30:00 | AAPL | Stock | 7.3232 | 7.3232 | 7.3232 | 7.3232 | 13888.0 |
| 2009-11-19 06:40:00 | AAPL | Stock | 7.3171 | 7.3171 | 7.3171 | 7.3171 | 7000.0 |
| 2009-11-19 06:45:00 | AAPL | Stock | 7.3089 | 7.3089 | 7.3089 | 7.3089 | 20468.0 |
| 2009-11-19 07:00:00 | AAPL | Stock | 7.3089 | 7.3089 | 7.3089 | 7.3089 | 4200.0 |
| 2009-11-19 07:05:00 | AAPL | Stock | 7.3036 | 7.3036 | 7.2975 | 7.2975 | 7000.0 |
| 2009-11-19 07:15:00 | AAPL | Stock | 7.3011 | 7.3011 | 7.3011 | 7.3011 | 5600.0 |
| 2009-11-19 07:20:00 | AAPL | Stock | 7.2968 | 7.2968 | 7.2896 | 7.2896 | 17388.0 |
| 2009-11-19 07:25:00 | AAPL | Stock | 7.2879 | 7.2879 | 7.2857 | 7.2857 | 81200.0 |
| 2009-11-19 07:30:00 | AAPL | Stock | 7.2893 | 7.2954 | 7.2893 | 7.2954 | 8400.0 |
| 2009-11-19 07:35:00 | AAPL | Stock | 7.2786 | 7.2836 | 7.2714 | 7.2714 | 67200.0 |
| 2009-11-19 07:40:00 | AAPL | Stock | 7.2714 | 7.2857 | 7.2714 | 7.2857 | 76860.0 |
| 2009-11-19 07:45:00 | AAPL | Stock | 7.2854 | 7.2875 | 7.2854 | 7.2875 | 42000.0 |
| 2009-11-19 07:50:00 | AAPL | Stock | 7.2871 | 7.2875 | 7.2871 | 7.2875 | 22736.0 |
| 2009-11-19 07:55:00 | AAPL | Stock | 7.2871 | 7.2932 | 7.2843 | 7.285 | 112448.0 |
| 2009-11-19 08:00:00 | AAPL | Stock | 7.285 | 7.2946 | 7.2719 | 7.2929 | 242564.0 |
| 2009-11-19 08:05:00 | AAPL | Stock | 7.2943 | 7.2943 | 7.2857 | 7.2936 | 243124.0 |
| 2009-11-19 08:10:00 | AAPL | Stock | 7.2936 | 7.2936 | 7.2857 | 7.2893 | 50848.0 |
| 2009-11-19 08:15:00 | AAPL | Stock | 7.2877 | 7.2964 | 7.2875 | 7.2964 | 191912.0 |
| 2009-11-19 08:20:00 | AAPL | Stock | 7.2964 | 7.2979 | 7.2929 | 7.2964 | 87360.0 |
| 2009-11-19 08:25:00 | AAPL | Stock | 7.2961 | 7.2982 | 7.2936 | 7.2982 | 35896.0 |
| 2009-11-19 08:30:00 | AAPL | Stock | 7.2946 | 7.3089 | 7.2932 | 7.3089 | 239092.0 |
| 2009-11-19 08:35:00 | AAPL | Stock | 7.3121 | 7.3214 | 7.3093 | 7.3129 | 279748.0 |
| 2009-11-19 08:40:00 | AAPL | Stock | 7.3121 | 7.3171 | 7.3084 | 7.3096 | 133616.0 |
| 2009-11-19 08:45:00 | AAPL | Stock | 7.3159 | 7.3164 | 7.3114 | 7.3143 | 67200.0 |
| 2009-11-19 08:50:00 | AAPL | Stock | 7.3157 | 7.3193 | 7.3157 | 7.3189 | 177800.0 |
| 2009-11-19 08:55:00 | AAPL | Stock | 7.3179 | 7.3189 | 7.3086 | 7.3086 | 67648.0 |
| 2009-11-19 09:00:00 | AAPL | Stock | 7.3104 | 7.3143 | 7.3089 | 7.3089 | 31472.0 |
| 2009-11-19 09:05:00 | AAPL | Stock | 7.3121 | 7.3121 | 7.3071 | 7.3105 | 89600.0 |
| 2009-11-19 09:10:00 | AAPL | Stock | 7.3107 | 7.3111 | 7.3105 | 7.3107 | 44688.0 |
| 2009-11-19 09:15:00 | AAPL | Stock | 7.3125 | 7.3139 | 7.3125 | 7.3136 | 22400.0 |
| 2009-11-19 09:20:00 | AAPL | Stock | 7.3171 | 7.3186 | 7.3143 | 7.3143 | 27580.0 |
| 2009-11-19 09:25:00 | AAPL | Stock | 7.3154 | 7.3179 | 7.3075 | 7.3104 | 161980.0 |
| 2009-11-19 09:30:00 | AAPL | Stock | 7.3107 | 7.3129 | 7.2661 | 7.2768 | 20374368.0 |
| 2009-11-19 09:35:00 | AAPL | Stock | 7.2768 | 7.2807 | 7.2325 | 7.2357 | 21872592.0 |
| 2009-11-19 09:40:00 | AAPL | Stock | 7.2357 | 7.2364 | 7.1964 | 7.2111 | 23262148.0 |
| 2009-11-19 09:45:00 | AAPL | Stock | 7.2096 | 7.2243 | 7.1986 | 7.2154 | 17888752.0 |
| 2009-11-19 09:50:00 | AAPL | Stock | 7.2143 | 7.2204 | 7.165 | 7.1814 | 22089452.0 |
| 2009-11-19 09:55:00 | AAPL | Stock | 7.1818 | 7.1968 | 7.1789 | 7.18 | 12541284.0 |
| 2009-11-19 10:00:00 | AAPL | Stock | 7.1789 | 7.2018 | 7.1771 | 7.1898 | 13718180.0 |
| 2009-11-19 10:05:00 | AAPL | Stock | 7.1875 | 7.2064 | 7.1821 | 7.1978 | 10157588.0 |
| 2009-11-19 10:10:00 | AAPL | Stock | 7.1997 | 7.2105 | 7.1964 | 7.2021 | 9639420.0 |
| 2009-11-19 10:15:00 | AAPL | Stock | 7.2014 | 7.2086 | 7.1982 | 7.2021 | 7846692.0 |
| 2009-11-19 10:20:00 | AAPL | Stock | 7.2014 | 7.2164 | 7.2 | 7.2107 | 8240680.0 |
| 2009-11-19 10:25:00 | AAPL | Stock | 7.2111 | 7.2204 | 7.2064 | 7.2082 | 6491856.0 |
| 2009-11-19 10:30:00 | AAPL | Stock | 7.2079 | 7.2129 | 7.1982 | 7.2045 | 6991152.0 |
| 2009-11-19 10:35:00 | AAPL | Stock | 7.2055 | 7.2161 | 7.2025 | 7.2161 | 5472292.0 |
| 2009-11-19 10:40:00 | AAPL | Stock | 7.215 | 7.2175 | 7.2007 | 7.2129 | 5291216.0 |
| 2009-11-19 10:45:00 | AAPL | Stock | 7.2129 | 7.2139 | 7.1875 | 7.1936 | 7696052.0 |
| 2009-11-19 10:50:00 | AAPL | Stock | 7.1931 | 7.1971 | 7.1829 | 7.1932 | 9394644.0 |
| 2009-11-19 10:55:00 | AAPL | Stock | 7.1932 | 7.2 | 7.1879 | 7.1911 | 5467952.0 |
> showing 50 of 317,523 rows — these rows as CSV