PREVIEW / stock_1min / 2014-05-16
file: by_date/stock_1min/2014/2014-05-16.parquet size: 13.8 MB rows: 1,022,190 symbols: 2,867
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 |
|---|---|---|---|---|---|---|---|
| 2014-05-16 05:22:00 | AAPL | Stock | 21.0375 | 21.0375 | 21.0375 | 21.0375 | 2800.0 |
| 2014-05-16 05:37:00 | AAPL | Stock | 21.0386 | 21.0386 | 21.0386 | 21.0386 | 2800.0 |
| 2014-05-16 05:39:00 | AAPL | Stock | 21.04 | 21.04 | 21.04 | 21.04 | 2800.0 |
| 2014-05-16 05:56:00 | AAPL | Stock | 21.0314 | 21.0314 | 21.0314 | 21.0314 | 5600.0 |
| 2014-05-16 05:58:00 | AAPL | Stock | 21.0318 | 21.0318 | 21.0318 | 21.0318 | 2800.0 |
| 2014-05-16 06:02:00 | AAPL | Stock | 21.0264 | 21.0264 | 21.0264 | 21.0264 | 2800.0 |
| 2014-05-16 07:01:00 | AAPL | Stock | 21.0225 | 21.0225 | 21.0225 | 21.0225 | 2800.0 |
| 2014-05-16 07:32:00 | AAPL | Stock | 21.0018 | 21.0018 | 21.0 | 21.0 | 14000.0 |
| 2014-05-16 07:35:00 | AAPL | Stock | 21.0229 | 21.0229 | 21.0229 | 21.0229 | 2800.0 |
| 2014-05-16 07:46:00 | AAPL | Stock | 21.0211 | 21.0211 | 21.0211 | 21.0211 | 2800.0 |
| 2014-05-16 07:50:00 | AAPL | Stock | 21.0114 | 21.0114 | 21.0114 | 21.0114 | 26600.0 |
| 2014-05-16 07:51:00 | AAPL | Stock | 21.0114 | 21.0114 | 21.0114 | 21.0114 | 4480.0 |
| 2014-05-16 08:00:00 | AAPL | Stock | 21.0161 | 21.0243 | 20.9868 | 21.0 | 20524.0 |
| 2014-05-16 08:03:00 | AAPL | Stock | 21.0 | 21.0 | 21.0 | 21.0 | 5600.0 |
| 2014-05-16 08:05:00 | AAPL | Stock | 21.0 | 21.0 | 21.0 | 21.0 | 4424.0 |
| 2014-05-16 08:09:00 | AAPL | Stock | 20.9929 | 20.9929 | 20.9929 | 20.9929 | 5600.0 |
| 2014-05-16 08:12:00 | AAPL | Stock | 20.9957 | 20.9957 | 20.9946 | 20.9946 | 16156.0 |
| 2014-05-16 08:22:00 | AAPL | Stock | 20.9929 | 20.9929 | 20.9918 | 20.9918 | 33600.0 |
| 2014-05-16 08:25:00 | AAPL | Stock | 20.9918 | 20.9918 | 20.9839 | 20.9839 | 11200.0 |
| 2014-05-16 08:26:00 | AAPL | Stock | 20.9954 | 20.9954 | 20.9954 | 20.9954 | 5600.0 |
| 2014-05-16 08:29:00 | AAPL | Stock | 20.9911 | 20.9957 | 20.9911 | 20.9957 | 11900.0 |
| 2014-05-16 08:30:00 | AAPL | Stock | 20.9957 | 21.0025 | 20.9957 | 21.0025 | 30828.0 |
| 2014-05-16 08:33:00 | AAPL | Stock | 21.0107 | 21.0107 | 21.0107 | 21.0107 | 8400.0 |
| 2014-05-16 08:34:00 | AAPL | Stock | 21.0111 | 21.0179 | 21.0111 | 21.0179 | 5600.0 |
| 2014-05-16 08:35:00 | AAPL | Stock | 21.0221 | 21.0232 | 21.0221 | 21.0232 | 14000.0 |
| 2014-05-16 08:36:00 | AAPL | Stock | 21.0179 | 21.0232 | 21.0179 | 21.0214 | 19600.0 |
| 2014-05-16 08:38:00 | AAPL | Stock | 21.0264 | 21.0389 | 21.0264 | 21.0389 | 21000.0 |
| 2014-05-16 08:40:00 | AAPL | Stock | 21.0464 | 21.0607 | 21.0464 | 21.0607 | 45640.0 |
| 2014-05-16 08:41:00 | AAPL | Stock | 21.0564 | 21.0564 | 21.0564 | 21.0564 | 2800.0 |
| 2014-05-16 08:42:00 | AAPL | Stock | 21.0379 | 21.0379 | 21.0379 | 21.0379 | 5600.0 |
| 2014-05-16 08:43:00 | AAPL | Stock | 21.0529 | 21.0529 | 21.0529 | 21.0529 | 2800.0 |
| 2014-05-16 08:44:00 | AAPL | Stock | 21.0379 | 21.0379 | 21.0379 | 21.0379 | 2800.0 |
| 2014-05-16 08:46:00 | AAPL | Stock | 21.0504 | 21.0529 | 21.0493 | 21.0529 | 14000.0 |
| 2014-05-16 08:47:00 | AAPL | Stock | 21.0529 | 21.0554 | 21.0529 | 21.0554 | 19768.0 |
| 2014-05-16 08:48:00 | AAPL | Stock | 21.0579 | 21.0579 | 21.0571 | 21.0571 | 15680.0 |
| 2014-05-16 08:49:00 | AAPL | Stock | 21.0582 | 21.0582 | 21.0536 | 21.0536 | 48664.0 |
| 2014-05-16 08:51:00 | AAPL | Stock | 21.0571 | 21.0571 | 21.0571 | 21.0571 | 5600.0 |
| 2014-05-16 08:56:00 | AAPL | Stock | 21.0557 | 21.0557 | 21.0557 | 21.0557 | 2800.0 |
| 2014-05-16 08:58:00 | AAPL | Stock | 21.0536 | 21.0564 | 21.0536 | 21.0564 | 5600.0 |
| 2014-05-16 09:00:00 | AAPL | Stock | 21.0536 | 21.0568 | 21.0536 | 21.0568 | 14000.0 |
| 2014-05-16 09:02:00 | AAPL | Stock | 21.0571 | 21.0571 | 21.0571 | 21.0571 | 14000.0 |
| 2014-05-16 09:04:00 | AAPL | Stock | 21.0607 | 21.0643 | 21.0607 | 21.0643 | 20412.0 |
| 2014-05-16 09:05:00 | AAPL | Stock | 21.0643 | 21.0671 | 21.0643 | 21.0671 | 43400.0 |
| 2014-05-16 09:06:00 | AAPL | Stock | 21.0643 | 21.0796 | 21.0643 | 21.0796 | 56700.0 |
| 2014-05-16 09:07:00 | AAPL | Stock | 21.0886 | 21.0886 | 21.0886 | 21.0886 | 3080.0 |
| 2014-05-16 09:09:00 | AAPL | Stock | 21.0714 | 21.0714 | 21.0671 | 21.0671 | 22400.0 |
| 2014-05-16 09:10:00 | AAPL | Stock | 21.0711 | 21.0804 | 21.0711 | 21.0804 | 36652.0 |
| 2014-05-16 09:11:00 | AAPL | Stock | 21.075 | 21.075 | 21.075 | 21.075 | 2800.0 |
| 2014-05-16 09:15:00 | AAPL | Stock | 21.0768 | 21.0768 | 21.0768 | 21.0768 | 2800.0 |
| 2014-05-16 09:16:00 | AAPL | Stock | 21.0714 | 21.0718 | 21.0714 | 21.0718 | 14000.0 |
> showing 50 of 1,022,190 rows — these rows as CSV