PREVIEW / stock_5min / 2010-09-22
file: by_date/stock_5min/2010/2010-09-22.parquet size: 4.6 MB rows: 317,119 symbols: 3,475
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-09-22 05:05:00 | AAPL | Stock | 10.125 | 10.125 | 10.125 | 10.125 | 5600.0 |
| 2010-09-22 05:10:00 | AAPL | Stock | 10.0914 | 10.0914 | 10.0914 | 10.0914 | 14000.0 |
| 2010-09-22 05:55:00 | AAPL | Stock | 10.0946 | 10.0946 | 10.0946 | 10.0946 | 2800.0 |
| 2010-09-22 06:30:00 | AAPL | Stock | 10.1018 | 10.1018 | 10.1018 | 10.1018 | 14000.0 |
| 2010-09-22 07:00:00 | AAPL | Stock | 10.1 | 10.1 | 10.1 | 10.1 | 26460.0 |
| 2010-09-22 07:05:00 | AAPL | Stock | 10.0893 | 10.0893 | 10.0893 | 10.0893 | 2800.0 |
| 2010-09-22 07:10:00 | AAPL | Stock | 10.0893 | 10.0893 | 10.0893 | 10.0893 | 5376.0 |
| 2010-09-22 07:15:00 | AAPL | Stock | 10.09 | 10.09 | 10.0893 | 10.0893 | 19600.0 |
| 2010-09-22 07:25:00 | AAPL | Stock | 10.0889 | 10.0889 | 10.0889 | 10.0889 | 2800.0 |
| 2010-09-22 07:30:00 | AAPL | Stock | 10.1 | 10.1 | 10.0989 | 10.0993 | 10332.0 |
| 2010-09-22 07:35:00 | AAPL | Stock | 10.1 | 10.125 | 10.1 | 10.125 | 53200.0 |
| 2010-09-22 07:40:00 | AAPL | Stock | 10.1207 | 10.1211 | 10.1207 | 10.1211 | 8400.0 |
| 2010-09-22 07:45:00 | AAPL | Stock | 10.1075 | 10.1075 | 10.0996 | 10.1 | 129416.0 |
| 2010-09-22 07:50:00 | AAPL | Stock | 10.1 | 10.1 | 10.1 | 10.1 | 2800.0 |
| 2010-09-22 07:55:00 | AAPL | Stock | 10.105 | 10.105 | 10.0946 | 10.0946 | 64400.0 |
| 2010-09-22 08:00:00 | AAPL | Stock | 10.0914 | 10.1071 | 10.0893 | 10.0925 | 322056.0 |
| 2010-09-22 08:05:00 | AAPL | Stock | 10.0929 | 10.0986 | 10.0846 | 10.0982 | 329112.0 |
| 2010-09-22 08:10:00 | AAPL | Stock | 10.0936 | 10.1 | 10.0936 | 10.1 | 173656.0 |
| 2010-09-22 08:15:00 | AAPL | Stock | 10.1 | 10.1032 | 10.0911 | 10.1032 | 174160.0 |
| 2010-09-22 08:20:00 | AAPL | Stock | 10.1018 | 10.1057 | 10.0971 | 10.1014 | 276920.0 |
| 2010-09-22 08:25:00 | AAPL | Stock | 10.1014 | 10.1107 | 10.1014 | 10.1061 | 108164.0 |
| 2010-09-22 08:30:00 | AAPL | Stock | 10.1071 | 10.1071 | 10.0839 | 10.0879 | 249592.0 |
| 2010-09-22 08:35:00 | AAPL | Stock | 10.0893 | 10.0964 | 10.0875 | 10.0875 | 130480.0 |
| 2010-09-22 08:40:00 | AAPL | Stock | 10.0907 | 10.1025 | 10.0796 | 10.0857 | 281148.0 |
| 2010-09-22 08:45:00 | AAPL | Stock | 10.0907 | 10.0907 | 10.0786 | 10.0786 | 172760.0 |
| 2010-09-22 08:50:00 | AAPL | Stock | 10.0771 | 10.0932 | 10.0754 | 10.0925 | 208628.0 |
| 2010-09-22 08:55:00 | AAPL | Stock | 10.0936 | 10.0939 | 10.0846 | 10.0857 | 64400.0 |
| 2010-09-22 09:00:00 | AAPL | Stock | 10.0861 | 10.0911 | 10.0861 | 10.0893 | 126000.0 |
| 2010-09-22 09:05:00 | AAPL | Stock | 10.0868 | 10.0886 | 10.0857 | 10.0857 | 158788.0 |
| 2010-09-22 09:10:00 | AAPL | Stock | 10.085 | 10.0943 | 10.085 | 10.0943 | 194460.0 |
| 2010-09-22 09:15:00 | AAPL | Stock | 10.0954 | 10.0982 | 10.0939 | 10.0961 | 109704.0 |
| 2010-09-22 09:20:00 | AAPL | Stock | 10.0939 | 10.0939 | 10.0836 | 10.0854 | 385448.0 |
| 2010-09-22 09:25:00 | AAPL | Stock | 10.0882 | 10.1111 | 10.0879 | 10.1057 | 324156.0 |
| 2010-09-22 09:30:00 | AAPL | Stock | 10.0968 | 10.1432 | 10.0861 | 10.1432 | 22979908.0 |
| 2010-09-22 09:35:00 | AAPL | Stock | 10.1432 | 10.2193 | 10.1402 | 10.21 | 27730276.0 |
| 2010-09-22 09:40:00 | AAPL | Stock | 10.2107 | 10.2732 | 10.2082 | 10.2611 | 29700188.0 |
| 2010-09-22 09:45:00 | AAPL | Stock | 10.2589 | 10.285 | 10.2393 | 10.2446 | 24082352.0 |
| 2010-09-22 09:50:00 | AAPL | Stock | 10.245 | 10.2621 | 10.2371 | 10.25 | 14928032.0 |
| 2010-09-22 09:55:00 | AAPL | Stock | 10.2504 | 10.2675 | 10.2479 | 10.2614 | 12479852.0 |
| 2010-09-22 10:00:00 | AAPL | Stock | 10.2618 | 10.275 | 10.2219 | 10.2236 | 22877624.0 |
| 2010-09-22 10:05:00 | AAPL | Stock | 10.2229 | 10.2271 | 10.1843 | 10.2036 | 17417680.0 |
| 2010-09-22 10:10:00 | AAPL | Stock | 10.205 | 10.2404 | 10.2007 | 10.2343 | 12198312.0 |
| 2010-09-22 10:15:00 | AAPL | Stock | 10.2343 | 10.2439 | 10.2232 | 10.2429 | 8549576.0 |
| 2010-09-22 10:20:00 | AAPL | Stock | 10.2421 | 10.2425 | 10.2168 | 10.2207 | 16504068.0 |
| 2010-09-22 10:25:00 | AAPL | Stock | 10.2194 | 10.2223 | 10.1915 | 10.2046 | 10738364.0 |
| 2010-09-22 10:30:00 | AAPL | Stock | 10.2036 | 10.2232 | 10.1946 | 10.2221 | 8774136.0 |
| 2010-09-22 10:35:00 | AAPL | Stock | 10.2221 | 10.2332 | 10.2079 | 10.2107 | 8423408.0 |
| 2010-09-22 10:40:00 | AAPL | Stock | 10.2107 | 10.2236 | 10.2011 | 10.2075 | 8763104.0 |
| 2010-09-22 10:45:00 | AAPL | Stock | 10.2079 | 10.2239 | 10.2029 | 10.2146 | 6597584.0 |
| 2010-09-22 10:50:00 | AAPL | Stock | 10.2143 | 10.2211 | 10.21 | 10.2157 | 6866664.0 |
> showing 50 of 317,119 rows — these rows as CSV