PREVIEW / stock_5min / 2010-05-07
file: by_date/stock_5min/2010/2010-05-07.parquet size: 5.4 MB rows: 359,729 symbols: 3,480
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-05-07 04:05:00 | AAPL | Stock | 8.6714 | 8.6714 | 8.6714 | 8.6714 | 14000.0 |
| 2010-05-07 04:10:00 | AAPL | Stock | 8.6989 | 8.6989 | 8.6975 | 8.6975 | 28000.0 |
| 2010-05-07 04:15:00 | AAPL | Stock | 8.6961 | 8.6961 | 8.685 | 8.685 | 50400.0 |
| 2010-05-07 04:20:00 | AAPL | Stock | 8.7036 | 8.7036 | 8.7036 | 8.7036 | 11200.0 |
| 2010-05-07 04:30:00 | AAPL | Stock | 8.7043 | 8.7171 | 8.7043 | 8.7171 | 28000.0 |
| 2010-05-07 04:35:00 | AAPL | Stock | 8.7136 | 8.7143 | 8.7136 | 8.7143 | 16800.0 |
| 2010-05-07 04:40:00 | AAPL | Stock | 8.7136 | 8.7136 | 8.6864 | 8.7104 | 9800.0 |
| 2010-05-07 04:45:00 | AAPL | Stock | 8.7089 | 8.7089 | 8.7089 | 8.7089 | 5600.0 |
| 2010-05-07 04:50:00 | AAPL | Stock | 8.6889 | 8.6893 | 8.6889 | 8.6893 | 8400.0 |
| 2010-05-07 04:55:00 | AAPL | Stock | 8.6786 | 8.6786 | 8.6564 | 8.6564 | 5600.0 |
| 2010-05-07 05:00:00 | AAPL | Stock | 8.6504 | 8.6886 | 8.6504 | 8.6886 | 9800.0 |
| 2010-05-07 05:05:00 | AAPL | Stock | 8.6429 | 8.6429 | 8.6429 | 8.6429 | 2800.0 |
| 2010-05-07 05:15:00 | AAPL | Stock | 8.6886 | 8.6957 | 8.6886 | 8.6957 | 26600.0 |
| 2010-05-07 05:20:00 | AAPL | Stock | 8.6936 | 8.6936 | 8.6936 | 8.6936 | 14000.0 |
| 2010-05-07 05:35:00 | AAPL | Stock | 8.6893 | 8.6893 | 8.6893 | 8.6893 | 3500.0 |
| 2010-05-07 05:40:00 | AAPL | Stock | 8.6904 | 8.6904 | 8.6904 | 8.6904 | 2800.0 |
| 2010-05-07 06:00:00 | AAPL | Stock | 8.6921 | 8.6971 | 8.6921 | 8.6971 | 16800.0 |
| 2010-05-07 06:05:00 | AAPL | Stock | 8.7032 | 8.7143 | 8.6796 | 8.6796 | 62608.0 |
| 2010-05-07 06:10:00 | AAPL | Stock | 8.7139 | 8.7139 | 8.7096 | 8.7107 | 19600.0 |
| 2010-05-07 06:15:00 | AAPL | Stock | 8.7104 | 8.7207 | 8.7104 | 8.7207 | 11200.0 |
| 2010-05-07 06:20:00 | AAPL | Stock | 8.7236 | 8.7236 | 8.7236 | 8.7236 | 11200.0 |
| 2010-05-07 06:30:00 | AAPL | Stock | 8.7214 | 8.7214 | 8.7214 | 8.7214 | 8400.0 |
| 2010-05-07 06:35:00 | AAPL | Stock | 8.7214 | 8.7964 | 8.7214 | 8.7854 | 265188.0 |
| 2010-05-07 06:40:00 | AAPL | Stock | 8.7836 | 8.7836 | 8.7754 | 8.7821 | 89600.0 |
| 2010-05-07 06:45:00 | AAPL | Stock | 8.7929 | 8.7954 | 8.7857 | 8.7882 | 81200.0 |
| 2010-05-07 06:50:00 | AAPL | Stock | 8.7896 | 8.7896 | 8.7836 | 8.7836 | 22400.0 |
| 2010-05-07 06:55:00 | AAPL | Stock | 8.7954 | 8.7968 | 8.7768 | 8.7768 | 89964.0 |
| 2010-05-07 07:00:00 | AAPL | Stock | 8.7893 | 8.8029 | 8.7775 | 8.7775 | 139020.0 |
| 2010-05-07 07:05:00 | AAPL | Stock | 8.7775 | 8.8179 | 8.7771 | 8.7857 | 238084.0 |
| 2010-05-07 07:10:00 | AAPL | Stock | 8.7854 | 8.8371 | 8.7854 | 8.8014 | 102760.0 |
| 2010-05-07 07:15:00 | AAPL | Stock | 8.8196 | 8.8214 | 8.8007 | 8.8071 | 71400.0 |
| 2010-05-07 07:20:00 | AAPL | Stock | 8.8182 | 8.8193 | 8.7864 | 8.8168 | 161364.0 |
| 2010-05-07 07:25:00 | AAPL | Stock | 8.8179 | 8.8471 | 8.8004 | 8.8004 | 379456.0 |
| 2010-05-07 07:30:00 | AAPL | Stock | 8.8007 | 8.8171 | 8.8007 | 8.8036 | 65800.0 |
| 2010-05-07 07:35:00 | AAPL | Stock | 8.8125 | 8.8157 | 8.7893 | 8.8068 | 173600.0 |
| 2010-05-07 07:40:00 | AAPL | Stock | 8.8043 | 8.8121 | 8.8014 | 8.8121 | 103320.0 |
| 2010-05-07 07:45:00 | AAPL | Stock | 8.8118 | 8.8393 | 8.7986 | 8.825 | 294868.0 |
| 2010-05-07 07:50:00 | AAPL | Stock | 8.8279 | 8.8436 | 8.8218 | 8.8218 | 450184.0 |
| 2010-05-07 07:55:00 | AAPL | Stock | 8.8221 | 8.8229 | 8.7718 | 8.7907 | 532784.0 |
| 2010-05-07 08:00:00 | AAPL | Stock | 8.7857 | 8.8179 | 8.7284 | 8.7425 | 923776.0 |
| 2010-05-07 08:05:00 | AAPL | Stock | 8.7421 | 8.75 | 8.7057 | 8.74 | 797860.0 |
| 2010-05-07 08:10:00 | AAPL | Stock | 8.7486 | 8.795 | 8.7486 | 8.7886 | 1052828.0 |
| 2010-05-07 08:15:00 | AAPL | Stock | 8.7871 | 8.7925 | 8.7693 | 8.7821 | 502152.0 |
| 2010-05-07 08:20:00 | AAPL | Stock | 8.7821 | 8.7857 | 8.7636 | 8.7811 | 620172.0 |
| 2010-05-07 08:25:00 | AAPL | Stock | 8.7736 | 8.7896 | 8.7714 | 8.7807 | 455924.0 |
| 2010-05-07 08:30:00 | AAPL | Stock | 8.7807 | 8.8443 | 8.7807 | 8.8182 | 4123448.0 |
| 2010-05-07 08:35:00 | AAPL | Stock | 8.8114 | 8.8125 | 8.75 | 8.7514 | 1818600.0 |
| 2010-05-07 08:40:00 | AAPL | Stock | 8.7532 | 8.7816 | 8.7529 | 8.7561 | 925792.0 |
| 2010-05-07 08:45:00 | AAPL | Stock | 8.7561 | 8.7929 | 8.7382 | 8.7804 | 1146796.0 |
| 2010-05-07 08:50:00 | AAPL | Stock | 8.7796 | 8.7929 | 8.7625 | 8.765 | 440888.0 |
> showing 50 of 359,729 rows — these rows as CSV