PREVIEW / stock_5min / 2012-08-03
file: by_date/stock_5min/2012/2012-08-03.parquet size: 4.8 MB rows: 323,157 symbols: 3,496
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 |
|---|---|---|---|---|---|---|---|
| 2012-08-03 04:00:00 | AAPL | Stock | 21.7929 | 21.7939 | 21.7929 | 21.7939 | 5600.0 |
| 2012-08-03 04:10:00 | AAPL | Stock | 21.8129 | 21.8129 | 21.8125 | 21.8125 | 22400.0 |
| 2012-08-03 04:40:00 | AAPL | Stock | 21.8321 | 21.8321 | 21.8321 | 21.8321 | 7000.0 |
| 2012-08-03 05:10:00 | AAPL | Stock | 21.8393 | 21.8393 | 21.8393 | 21.8393 | 8400.0 |
| 2012-08-03 05:15:00 | AAPL | Stock | 21.8393 | 21.8393 | 21.8393 | 21.8393 | 8400.0 |
| 2012-08-03 05:25:00 | AAPL | Stock | 21.8393 | 21.8393 | 21.8393 | 21.8393 | 16800.0 |
| 2012-08-03 05:30:00 | AAPL | Stock | 21.8393 | 21.8393 | 21.8393 | 21.8393 | 22400.0 |
| 2012-08-03 05:35:00 | AAPL | Stock | 21.8393 | 21.8393 | 21.8393 | 21.8393 | 2800.0 |
| 2012-08-03 05:50:00 | AAPL | Stock | 21.8357 | 21.8357 | 21.8357 | 21.8357 | 2800.0 |
| 2012-08-03 06:20:00 | AAPL | Stock | 21.8464 | 21.8464 | 21.8464 | 21.8464 | 7000.0 |
| 2012-08-03 06:30:00 | AAPL | Stock | 21.8564 | 21.8643 | 21.8564 | 21.8643 | 5600.0 |
| 2012-08-03 06:45:00 | AAPL | Stock | 21.8571 | 21.8571 | 21.8571 | 21.8571 | 2800.0 |
| 2012-08-03 07:00:00 | AAPL | Stock | 21.8507 | 21.8714 | 21.8357 | 21.8571 | 90608.0 |
| 2012-08-03 07:05:00 | AAPL | Stock | 21.8571 | 21.8632 | 21.8468 | 21.8596 | 34748.0 |
| 2012-08-03 07:10:00 | AAPL | Stock | 21.8564 | 21.8564 | 21.8546 | 21.8564 | 30800.0 |
| 2012-08-03 07:15:00 | AAPL | Stock | 21.8571 | 21.8571 | 21.8536 | 21.8536 | 6300.0 |
| 2012-08-03 07:20:00 | AAPL | Stock | 21.8464 | 21.8464 | 21.8464 | 21.8464 | 6160.0 |
| 2012-08-03 07:25:00 | AAPL | Stock | 21.8429 | 21.8529 | 21.8304 | 21.8475 | 185444.0 |
| 2012-08-03 07:30:00 | AAPL | Stock | 21.8214 | 21.8371 | 21.8136 | 21.8214 | 166012.0 |
| 2012-08-03 07:35:00 | AAPL | Stock | 21.8214 | 21.8214 | 21.8214 | 21.8214 | 33600.0 |
| 2012-08-03 07:40:00 | AAPL | Stock | 21.8207 | 21.8214 | 21.8125 | 21.8193 | 29960.0 |
| 2012-08-03 07:45:00 | AAPL | Stock | 21.8139 | 21.8139 | 21.8014 | 21.8014 | 22400.0 |
| 2012-08-03 07:50:00 | AAPL | Stock | 21.7986 | 21.8093 | 21.7946 | 21.8089 | 89600.0 |
| 2012-08-03 07:55:00 | AAPL | Stock | 21.8043 | 21.8043 | 21.7946 | 21.7946 | 23100.0 |
| 2012-08-03 08:00:00 | AAPL | Stock | 21.7932 | 21.8461 | 21.7893 | 21.7982 | 411404.0 |
| 2012-08-03 08:05:00 | AAPL | Stock | 21.7996 | 21.8146 | 21.7918 | 21.7918 | 231672.0 |
| 2012-08-03 08:10:00 | AAPL | Stock | 21.7961 | 21.7961 | 21.7786 | 21.7871 | 66472.0 |
| 2012-08-03 08:15:00 | AAPL | Stock | 21.7736 | 21.7925 | 21.7143 | 21.785 | 104300.0 |
| 2012-08-03 08:20:00 | AAPL | Stock | 21.7864 | 21.7868 | 21.775 | 21.7814 | 345492.0 |
| 2012-08-03 08:25:00 | AAPL | Stock | 21.7768 | 21.7893 | 21.7682 | 21.7804 | 81704.0 |
| 2012-08-03 08:30:00 | AAPL | Stock | 21.7861 | 21.8893 | 21.7857 | 21.8446 | 1691928.0 |
| 2012-08-03 08:35:00 | AAPL | Stock | 21.8518 | 21.8518 | 21.8218 | 21.8454 | 582904.0 |
| 2012-08-03 08:40:00 | AAPL | Stock | 21.8432 | 21.8571 | 21.8393 | 21.8482 | 351680.0 |
| 2012-08-03 08:45:00 | AAPL | Stock | 21.8482 | 21.8579 | 21.8457 | 21.8457 | 336336.0 |
| 2012-08-03 08:50:00 | AAPL | Stock | 21.8479 | 21.8782 | 21.8418 | 21.8732 | 472024.0 |
| 2012-08-03 08:55:00 | AAPL | Stock | 21.8729 | 21.8732 | 21.86 | 21.8707 | 124656.0 |
| 2012-08-03 09:00:00 | AAPL | Stock | 21.8679 | 21.88 | 21.8664 | 21.875 | 157696.0 |
| 2012-08-03 09:05:00 | AAPL | Stock | 21.875 | 21.8929 | 21.875 | 21.8918 | 311584.0 |
| 2012-08-03 09:10:00 | AAPL | Stock | 21.8918 | 21.8975 | 21.8714 | 21.8839 | 540092.0 |
| 2012-08-03 09:15:00 | AAPL | Stock | 21.8832 | 21.9096 | 21.8832 | 21.8936 | 529004.0 |
| 2012-08-03 09:20:00 | AAPL | Stock | 21.8929 | 21.9107 | 21.8929 | 21.9071 | 390852.0 |
| 2012-08-03 09:25:00 | AAPL | Stock | 21.905 | 21.9421 | 21.905 | 21.9186 | 553868.0 |
| 2012-08-03 09:30:00 | AAPL | Stock | 21.9154 | 21.9414 | 21.8893 | 21.8923 | 16447228.0 |
| 2012-08-03 09:35:00 | AAPL | Stock | 21.8896 | 21.8924 | 21.8414 | 21.8839 | 9854852.0 |
| 2012-08-03 09:40:00 | AAPL | Stock | 21.8839 | 21.9589 | 21.8768 | 21.9539 | 11720632.0 |
| 2012-08-03 09:45:00 | AAPL | Stock | 21.9548 | 22.0 | 21.9518 | 21.98 | 15660008.0 |
| 2012-08-03 09:50:00 | AAPL | Stock | 21.9793 | 21.9839 | 21.9393 | 21.9796 | 7738920.0 |
| 2012-08-03 09:55:00 | AAPL | Stock | 21.98 | 22.005 | 21.9682 | 21.9811 | 7563976.0 |
| 2012-08-03 10:00:00 | AAPL | Stock | 21.9821 | 21.9996 | 21.965 | 21.9721 | 5298664.0 |
| 2012-08-03 10:05:00 | AAPL | Stock | 21.9771 | 21.9818 | 21.9571 | 21.965 | 5373536.0 |
> showing 50 of 323,157 rows — these rows as CSV