PREVIEW / stock_5min / 2012-08-23
file: by_date/stock_5min/2012/2012-08-23.parquet size: 4.5 MB rows: 308,054 symbols: 3,444
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-23 04:00:00 | AAPL | Stock | 23.9286 | 24.0179 | 23.9286 | 24.0179 | 31836.0 |
| 2012-08-23 04:05:00 | AAPL | Stock | 24.0089 | 24.0089 | 24.0004 | 24.0004 | 14140.0 |
| 2012-08-23 04:20:00 | AAPL | Stock | 24.0179 | 24.0354 | 24.0179 | 24.0354 | 14000.0 |
| 2012-08-23 04:25:00 | AAPL | Stock | 24.0 | 24.0 | 24.0 | 24.0 | 2800.0 |
| 2012-08-23 04:30:00 | AAPL | Stock | 24.0 | 24.0 | 24.0 | 24.0 | 12600.0 |
| 2012-08-23 04:50:00 | AAPL | Stock | 24.0 | 24.0 | 24.0 | 24.0 | 5600.0 |
| 2012-08-23 04:55:00 | AAPL | Stock | 23.9911 | 23.9911 | 23.9911 | 23.9911 | 2800.0 |
| 2012-08-23 05:00:00 | AAPL | Stock | 23.9861 | 23.9861 | 23.9861 | 23.9861 | 2800.0 |
| 2012-08-23 05:15:00 | AAPL | Stock | 24.0004 | 24.0046 | 24.0 | 24.0046 | 11480.0 |
| 2012-08-23 05:20:00 | AAPL | Stock | 24.0068 | 24.0068 | 23.9929 | 23.9929 | 19600.0 |
| 2012-08-23 05:25:00 | AAPL | Stock | 24.0 | 24.0 | 24.0 | 24.0 | 8400.0 |
| 2012-08-23 05:35:00 | AAPL | Stock | 24.0071 | 24.0071 | 24.0071 | 24.0071 | 8400.0 |
| 2012-08-23 05:40:00 | AAPL | Stock | 24.0071 | 24.0071 | 24.0071 | 24.0071 | 14000.0 |
| 2012-08-23 06:05:00 | AAPL | Stock | 24.0154 | 24.0154 | 24.0154 | 24.0154 | 2800.0 |
| 2012-08-23 06:10:00 | AAPL | Stock | 24.0114 | 24.0114 | 24.0114 | 24.0114 | 2800.0 |
| 2012-08-23 06:20:00 | AAPL | Stock | 24.0211 | 24.0214 | 24.0079 | 24.0079 | 8400.0 |
| 2012-08-23 06:30:00 | AAPL | Stock | 24.0207 | 24.0214 | 24.01 | 24.0193 | 21000.0 |
| 2012-08-23 06:40:00 | AAPL | Stock | 24.0071 | 24.0071 | 24.0036 | 24.0036 | 8400.0 |
| 2012-08-23 06:45:00 | AAPL | Stock | 24.0011 | 24.0011 | 23.9946 | 23.9946 | 11480.0 |
| 2012-08-23 07:00:00 | AAPL | Stock | 23.9857 | 24.0 | 23.975 | 24.0 | 135856.0 |
| 2012-08-23 07:05:00 | AAPL | Stock | 24.0 | 24.0004 | 23.9843 | 23.9843 | 122780.0 |
| 2012-08-23 07:10:00 | AAPL | Stock | 23.9989 | 23.9989 | 23.9643 | 23.9643 | 85344.0 |
| 2012-08-23 07:15:00 | AAPL | Stock | 23.9746 | 23.9786 | 23.9682 | 23.9786 | 80080.0 |
| 2012-08-23 07:20:00 | AAPL | Stock | 23.9786 | 23.9893 | 23.975 | 23.9893 | 93800.0 |
| 2012-08-23 07:25:00 | AAPL | Stock | 23.9821 | 23.9821 | 23.9814 | 23.9814 | 5600.0 |
| 2012-08-23 07:30:00 | AAPL | Stock | 23.9821 | 23.9921 | 23.9821 | 23.9893 | 46564.0 |
| 2012-08-23 07:35:00 | AAPL | Stock | 23.9925 | 23.9939 | 23.9832 | 23.9939 | 24752.0 |
| 2012-08-23 07:40:00 | AAPL | Stock | 23.9946 | 23.9946 | 23.97 | 23.9718 | 53200.0 |
| 2012-08-23 07:45:00 | AAPL | Stock | 23.9718 | 23.975 | 23.9021 | 23.9182 | 199360.0 |
| 2012-08-23 07:50:00 | AAPL | Stock | 23.9107 | 23.9143 | 23.8629 | 23.8929 | 79296.0 |
| 2012-08-23 07:55:00 | AAPL | Stock | 23.8754 | 23.8754 | 23.8661 | 23.8714 | 57400.0 |
| 2012-08-23 08:00:00 | AAPL | Stock | 23.8714 | 23.9786 | 23.8661 | 23.9196 | 383068.0 |
| 2012-08-23 08:05:00 | AAPL | Stock | 23.9243 | 23.9564 | 23.9196 | 23.95 | 419888.0 |
| 2012-08-23 08:10:00 | AAPL | Stock | 23.95 | 23.9564 | 23.9196 | 23.9282 | 259504.0 |
| 2012-08-23 08:15:00 | AAPL | Stock | 23.9232 | 23.9286 | 23.8875 | 23.9107 | 211036.0 |
| 2012-08-23 08:20:00 | AAPL | Stock | 23.9111 | 23.9286 | 23.9111 | 23.9246 | 180320.0 |
| 2012-08-23 08:25:00 | AAPL | Stock | 23.9264 | 23.9279 | 23.9071 | 23.9071 | 282548.0 |
| 2012-08-23 08:30:00 | AAPL | Stock | 23.9107 | 23.9107 | 23.8686 | 23.8704 | 551544.0 |
| 2012-08-23 08:35:00 | AAPL | Stock | 23.8671 | 23.8725 | 23.7879 | 23.8032 | 656768.0 |
| 2012-08-23 08:40:00 | AAPL | Stock | 23.7946 | 23.8193 | 23.7768 | 23.7925 | 415856.0 |
| 2012-08-23 08:45:00 | AAPL | Stock | 23.7939 | 23.8179 | 23.7914 | 23.8089 | 137256.0 |
| 2012-08-23 08:50:00 | AAPL | Stock | 23.8154 | 23.8304 | 23.8093 | 23.83 | 187292.0 |
| 2012-08-23 08:55:00 | AAPL | Stock | 23.8229 | 23.8464 | 23.8229 | 23.8332 | 208544.0 |
| 2012-08-23 09:00:00 | AAPL | Stock | 23.8293 | 23.8304 | 23.8071 | 23.8071 | 468860.0 |
| 2012-08-23 09:05:00 | AAPL | Stock | 23.8071 | 23.8125 | 23.7907 | 23.8086 | 349468.0 |
| 2012-08-23 09:10:00 | AAPL | Stock | 23.7993 | 23.8036 | 23.7946 | 23.7989 | 94444.0 |
| 2012-08-23 09:15:00 | AAPL | Stock | 23.8018 | 23.8025 | 23.7679 | 23.7696 | 256032.0 |
| 2012-08-23 09:20:00 | AAPL | Stock | 23.775 | 23.7957 | 23.7679 | 23.7957 | 183568.0 |
| 2012-08-23 09:25:00 | AAPL | Stock | 23.7939 | 23.8214 | 23.7868 | 23.7896 | 274960.0 |
| 2012-08-23 09:30:00 | AAPL | Stock | 23.7896 | 23.8704 | 23.7361 | 23.8539 | 19256020.0 |
> showing 50 of 308,054 rows — these rows as CSV