PREVIEW / stock_5min / 2012-09-18
file: by_date/stock_5min/2012/2012-09-18.parquet size: 4.8 MB rows: 324,298 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 |
|---|---|---|---|---|---|---|---|
| 2012-09-18 04:15:00 | AAPL | Stock | 25.0286 | 25.0286 | 25.0286 | 25.0286 | 8400.0 |
| 2012-09-18 04:40:00 | AAPL | Stock | 25.0607 | 25.0607 | 25.0607 | 25.0607 | 2800.0 |
| 2012-09-18 04:50:00 | AAPL | Stock | 25.0607 | 25.0607 | 25.0607 | 25.0607 | 16800.0 |
| 2012-09-18 05:00:00 | AAPL | Stock | 25.0607 | 25.0607 | 25.0607 | 25.0607 | 11200.0 |
| 2012-09-18 05:05:00 | AAPL | Stock | 25.0607 | 25.0607 | 25.0607 | 25.0607 | 11200.0 |
| 2012-09-18 05:20:00 | AAPL | Stock | 25.0643 | 25.0643 | 25.0643 | 25.0643 | 5460.0 |
| 2012-09-18 05:30:00 | AAPL | Stock | 25.0536 | 25.0536 | 25.0536 | 25.0536 | 2800.0 |
| 2012-09-18 05:40:00 | AAPL | Stock | 25.0357 | 25.0357 | 25.0357 | 25.0357 | 5600.0 |
| 2012-09-18 05:55:00 | AAPL | Stock | 25.0357 | 25.0357 | 25.0268 | 25.0268 | 5964.0 |
| 2012-09-18 06:15:00 | AAPL | Stock | 25.0271 | 25.0271 | 25.0268 | 25.0268 | 16800.0 |
| 2012-09-18 06:20:00 | AAPL | Stock | 25.0271 | 25.0271 | 25.0271 | 25.0271 | 15260.0 |
| 2012-09-18 06:25:00 | AAPL | Stock | 25.0357 | 25.0357 | 25.0357 | 25.0357 | 2800.0 |
| 2012-09-18 06:30:00 | AAPL | Stock | 25.0275 | 25.0275 | 25.0275 | 25.0275 | 5600.0 |
| 2012-09-18 06:55:00 | AAPL | Stock | 25.0521 | 25.0521 | 25.0521 | 25.0521 | 2800.0 |
| 2012-09-18 07:00:00 | AAPL | Stock | 25.0586 | 25.0586 | 25.0357 | 25.0357 | 14000.0 |
| 2012-09-18 07:05:00 | AAPL | Stock | 25.0543 | 25.0982 | 25.0543 | 25.0982 | 324856.0 |
| 2012-09-18 07:10:00 | AAPL | Stock | 25.1 | 25.1 | 25.0804 | 25.0893 | 227024.0 |
| 2012-09-18 07:15:00 | AAPL | Stock | 25.0768 | 25.0821 | 25.0768 | 25.0768 | 43400.0 |
| 2012-09-18 07:20:00 | AAPL | Stock | 25.0768 | 25.0786 | 25.0379 | 25.0379 | 157220.0 |
| 2012-09-18 07:25:00 | AAPL | Stock | 25.0571 | 25.0571 | 25.0364 | 25.0446 | 14000.0 |
| 2012-09-18 07:30:00 | AAPL | Stock | 25.0554 | 25.0686 | 25.0536 | 25.0686 | 54796.0 |
| 2012-09-18 07:35:00 | AAPL | Stock | 25.0679 | 25.0804 | 25.0614 | 25.0768 | 51604.0 |
| 2012-09-18 07:40:00 | AAPL | Stock | 25.0768 | 25.0821 | 25.0768 | 25.0821 | 42392.0 |
| 2012-09-18 07:45:00 | AAPL | Stock | 25.0754 | 25.0754 | 25.0607 | 25.0646 | 126476.0 |
| 2012-09-18 07:50:00 | AAPL | Stock | 25.0621 | 25.0643 | 25.0457 | 25.0457 | 145796.0 |
| 2012-09-18 07:55:00 | AAPL | Stock | 25.045 | 25.0893 | 25.045 | 25.0893 | 175840.0 |
| 2012-09-18 08:00:00 | AAPL | Stock | 25.0893 | 25.0893 | 25.0554 | 25.0643 | 599396.0 |
| 2012-09-18 08:05:00 | AAPL | Stock | 25.0696 | 25.0768 | 24.9689 | 24.9761 | 1036980.0 |
| 2012-09-18 08:10:00 | AAPL | Stock | 24.9893 | 25.0036 | 24.9782 | 25.0007 | 407008.0 |
| 2012-09-18 08:15:00 | AAPL | Stock | 25.0004 | 25.0086 | 24.9286 | 24.9504 | 644112.0 |
| 2012-09-18 08:20:00 | AAPL | Stock | 24.9504 | 24.9646 | 24.9393 | 24.9575 | 289856.0 |
| 2012-09-18 08:25:00 | AAPL | Stock | 24.96 | 24.9625 | 24.9332 | 24.9596 | 217532.0 |
| 2012-09-18 08:30:00 | AAPL | Stock | 24.9464 | 24.9654 | 24.9446 | 24.9564 | 127764.0 |
| 2012-09-18 08:35:00 | AAPL | Stock | 24.9571 | 24.9946 | 24.95 | 24.9868 | 252868.0 |
| 2012-09-18 08:40:00 | AAPL | Stock | 24.9886 | 24.9921 | 24.9643 | 24.9643 | 425292.0 |
| 2012-09-18 08:45:00 | AAPL | Stock | 24.9707 | 24.9975 | 24.9707 | 24.9968 | 179088.0 |
| 2012-09-18 08:50:00 | AAPL | Stock | 24.9971 | 25.0114 | 24.9936 | 25.0036 | 259868.0 |
| 2012-09-18 08:55:00 | AAPL | Stock | 25.0036 | 25.0175 | 24.9921 | 24.9971 | 291732.0 |
| 2012-09-18 09:00:00 | AAPL | Stock | 24.9929 | 25.0 | 24.9921 | 24.9939 | 160468.0 |
| 2012-09-18 09:05:00 | AAPL | Stock | 24.9896 | 25.0043 | 24.9821 | 24.9893 | 324912.0 |
| 2012-09-18 09:10:00 | AAPL | Stock | 24.9911 | 25.0029 | 24.9821 | 24.9821 | 351736.0 |
| 2012-09-18 09:15:00 | AAPL | Stock | 24.9821 | 25.0 | 24.9821 | 25.0 | 238392.0 |
| 2012-09-18 09:20:00 | AAPL | Stock | 24.9943 | 25.0 | 24.9893 | 24.9893 | 229432.0 |
| 2012-09-18 09:25:00 | AAPL | Stock | 24.9893 | 25.0175 | 24.9807 | 24.9954 | 1367688.0 |
| 2012-09-18 09:30:00 | AAPL | Stock | 24.9961 | 24.9982 | 24.9175 | 24.9186 | 20932128.0 |
| 2012-09-18 09:35:00 | AAPL | Stock | 24.9218 | 24.9561 | 24.8964 | 24.94 | 13177192.0 |
| 2012-09-18 09:40:00 | AAPL | Stock | 24.9275 | 24.9493 | 24.9129 | 24.9257 | 8106448.0 |
| 2012-09-18 09:45:00 | AAPL | Stock | 24.9286 | 24.9305 | 24.8721 | 24.9176 | 12396552.0 |
| 2012-09-18 09:50:00 | AAPL | Stock | 24.9207 | 24.9932 | 24.9175 | 24.99 | 12647264.0 |
| 2012-09-18 09:55:00 | AAPL | Stock | 24.9896 | 25.0154 | 24.9607 | 25.0125 | 13486788.0 |
> showing 50 of 324,298 rows — these rows as CSV