PREVIEW / stock_5min / 2013-03-18
file: by_date/stock_5min/2013/2013-03-18.parquet size: 5.0 MB rows: 334,948 symbols: 3,489
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-03-18 04:00:00 | AAPL | Stock | 15.8929 | 15.8929 | 15.7143 | 15.7143 | 24080.0 |
| 2013-03-18 04:10:00 | AAPL | Stock | 15.6786 | 15.6786 | 15.6786 | 15.6786 | 18704.0 |
| 2013-03-18 05:15:00 | AAPL | Stock | 15.71 | 15.71 | 15.71 | 15.71 | 8400.0 |
| 2013-03-18 05:25:00 | AAPL | Stock | 15.7143 | 15.7143 | 15.7143 | 15.7143 | 58688.0 |
| 2013-03-18 05:30:00 | AAPL | Stock | 15.7107 | 15.7143 | 15.7107 | 15.7143 | 19600.0 |
| 2013-03-18 05:40:00 | AAPL | Stock | 15.7143 | 15.7143 | 15.7143 | 15.7143 | 2800.0 |
| 2013-03-18 06:05:00 | AAPL | Stock | 15.7146 | 15.7182 | 15.7146 | 15.7182 | 7000.0 |
| 2013-03-18 06:10:00 | AAPL | Stock | 15.7182 | 15.7182 | 15.7175 | 15.7175 | 14000.0 |
| 2013-03-18 06:20:00 | AAPL | Stock | 15.7318 | 15.7318 | 15.7143 | 15.7143 | 8400.0 |
| 2013-03-18 06:25:00 | AAPL | Stock | 15.71 | 15.71 | 15.71 | 15.71 | 2800.0 |
| 2013-03-18 06:30:00 | AAPL | Stock | 15.71 | 15.71 | 15.71 | 15.71 | 7168.0 |
| 2013-03-18 06:35:00 | AAPL | Stock | 15.6964 | 15.6964 | 15.6964 | 15.6964 | 8400.0 |
| 2013-03-18 06:40:00 | AAPL | Stock | 15.7082 | 15.7082 | 15.6964 | 15.6968 | 23940.0 |
| 2013-03-18 06:55:00 | AAPL | Stock | 15.7121 | 15.7121 | 15.6964 | 15.6964 | 15400.0 |
| 2013-03-18 07:00:00 | AAPL | Stock | 15.6896 | 15.7036 | 15.6593 | 15.6696 | 69076.0 |
| 2013-03-18 07:05:00 | AAPL | Stock | 15.6696 | 15.6893 | 15.6696 | 15.6893 | 70420.0 |
| 2013-03-18 07:10:00 | AAPL | Stock | 15.6943 | 15.7046 | 15.6943 | 15.7046 | 11200.0 |
| 2013-03-18 07:15:00 | AAPL | Stock | 15.7125 | 15.7214 | 15.7125 | 15.7143 | 104104.0 |
| 2013-03-18 07:20:00 | AAPL | Stock | 15.7214 | 15.7571 | 15.7204 | 15.7571 | 90356.0 |
| 2013-03-18 07:25:00 | AAPL | Stock | 15.7546 | 15.7571 | 15.7214 | 15.7214 | 125440.0 |
| 2013-03-18 07:30:00 | AAPL | Stock | 15.7218 | 15.7218 | 15.7218 | 15.7218 | 3612.0 |
| 2013-03-18 07:35:00 | AAPL | Stock | 15.7321 | 15.7429 | 15.7321 | 15.7429 | 27160.0 |
| 2013-03-18 07:40:00 | AAPL | Stock | 15.7329 | 15.7439 | 15.7321 | 15.7404 | 96936.0 |
| 2013-03-18 07:45:00 | AAPL | Stock | 15.7364 | 15.7364 | 15.7143 | 15.7143 | 106680.0 |
| 2013-03-18 07:50:00 | AAPL | Stock | 15.7071 | 15.7243 | 15.7061 | 15.7243 | 34580.0 |
| 2013-03-18 07:55:00 | AAPL | Stock | 15.7179 | 15.7439 | 15.7143 | 15.7439 | 133980.0 |
| 2013-03-18 08:00:00 | AAPL | Stock | 15.7439 | 15.7679 | 15.6696 | 15.7643 | 612892.0 |
| 2013-03-18 08:05:00 | AAPL | Stock | 15.7661 | 15.815 | 15.7593 | 15.8093 | 405356.0 |
| 2013-03-18 08:10:00 | AAPL | Stock | 15.8093 | 15.8093 | 15.7857 | 15.7857 | 501312.0 |
| 2013-03-18 08:15:00 | AAPL | Stock | 15.7861 | 15.7936 | 15.7829 | 15.7868 | 253260.0 |
| 2013-03-18 08:20:00 | AAPL | Stock | 15.7871 | 15.8036 | 15.7804 | 15.7989 | 165088.0 |
| 2013-03-18 08:25:00 | AAPL | Stock | 15.7986 | 15.8036 | 15.7911 | 15.7982 | 199332.0 |
| 2013-03-18 08:30:00 | AAPL | Stock | 15.7921 | 15.8071 | 15.7857 | 15.8004 | 562940.0 |
| 2013-03-18 08:35:00 | AAPL | Stock | 15.805 | 15.805 | 15.7946 | 15.795 | 169792.0 |
| 2013-03-18 08:40:00 | AAPL | Stock | 15.7971 | 15.8 | 15.7911 | 15.7957 | 181048.0 |
| 2013-03-18 08:45:00 | AAPL | Stock | 15.7993 | 15.7996 | 15.7871 | 15.7871 | 112168.0 |
| 2013-03-18 08:50:00 | AAPL | Stock | 15.7879 | 15.7911 | 15.7786 | 15.7832 | 380436.0 |
| 2013-03-18 08:55:00 | AAPL | Stock | 15.7796 | 15.7811 | 15.7725 | 15.7739 | 181328.0 |
| 2013-03-18 09:00:00 | AAPL | Stock | 15.7786 | 15.7882 | 15.7786 | 15.7789 | 190904.0 |
| 2013-03-18 09:05:00 | AAPL | Stock | 15.7786 | 15.7818 | 15.755 | 15.7657 | 282240.0 |
| 2013-03-18 09:10:00 | AAPL | Stock | 15.7661 | 15.7768 | 15.7575 | 15.7643 | 320936.0 |
| 2013-03-18 09:15:00 | AAPL | Stock | 15.7643 | 15.775 | 15.7554 | 15.7593 | 174244.0 |
| 2013-03-18 09:20:00 | AAPL | Stock | 15.7561 | 15.7618 | 15.7521 | 15.7521 | 152180.0 |
| 2013-03-18 09:25:00 | AAPL | Stock | 15.7546 | 15.7729 | 15.7539 | 15.7636 | 280308.0 |
| 2013-03-18 09:30:00 | AAPL | Stock | 15.7671 | 15.8725 | 15.7571 | 15.8286 | 24189228.0 |
| 2013-03-18 09:35:00 | AAPL | Stock | 15.8286 | 15.8993 | 15.8286 | 15.8986 | 21382088.0 |
| 2013-03-18 09:40:00 | AAPL | Stock | 15.8986 | 15.9534 | 15.8839 | 15.9311 | 16919000.0 |
| 2013-03-18 09:45:00 | AAPL | Stock | 15.9304 | 15.9689 | 15.9 | 15.9575 | 12103084.0 |
| 2013-03-18 09:50:00 | AAPL | Stock | 15.9575 | 15.9814 | 15.9286 | 15.9286 | 11247656.0 |
| 2013-03-18 09:55:00 | AAPL | Stock | 15.9286 | 15.9379 | 15.8886 | 15.92 | 10022740.0 |
> showing 50 of 334,948 rows — these rows as CSV