PREVIEW / stock_5min / 2013-07-01
file: by_date/stock_5min/2013/2013-07-01.parquet size: 5.2 MB rows: 348,495 symbols: 3,507
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-07-01 04:00:00 | AAPL | Stock | 14.2311 | 14.2543 | 14.2311 | 14.2321 | 11200.0 |
| 2013-07-01 04:05:00 | AAPL | Stock | 14.2393 | 14.2393 | 14.2393 | 14.2393 | 11200.0 |
| 2013-07-01 04:10:00 | AAPL | Stock | 14.2193 | 14.2193 | 14.2193 | 14.2193 | 5600.0 |
| 2013-07-01 05:20:00 | AAPL | Stock | 14.2143 | 14.2143 | 14.2107 | 14.2107 | 8400.0 |
| 2013-07-01 05:30:00 | AAPL | Stock | 14.2393 | 14.2393 | 14.2393 | 14.2393 | 12208.0 |
| 2013-07-01 05:35:00 | AAPL | Stock | 14.2375 | 14.2482 | 14.2375 | 14.2482 | 15792.0 |
| 2013-07-01 05:45:00 | AAPL | Stock | 14.2361 | 14.2361 | 14.2361 | 14.2361 | 14000.0 |
| 2013-07-01 05:50:00 | AAPL | Stock | 14.2321 | 14.2321 | 14.2321 | 14.2321 | 26880.0 |
| 2013-07-01 06:20:00 | AAPL | Stock | 14.2321 | 14.2321 | 14.2321 | 14.2321 | 8400.0 |
| 2013-07-01 06:35:00 | AAPL | Stock | 14.2411 | 14.2411 | 14.2411 | 14.2411 | 15400.0 |
| 2013-07-01 06:40:00 | AAPL | Stock | 14.2482 | 14.2482 | 14.2411 | 14.2411 | 19292.0 |
| 2013-07-01 06:50:00 | AAPL | Stock | 14.2411 | 14.25 | 14.2411 | 14.25 | 24332.0 |
| 2013-07-01 06:55:00 | AAPL | Stock | 14.2543 | 14.2857 | 14.2543 | 14.2857 | 67144.0 |
| 2013-07-01 07:00:00 | AAPL | Stock | 14.2854 | 14.3304 | 14.2768 | 14.3214 | 179844.0 |
| 2013-07-01 07:05:00 | AAPL | Stock | 14.3214 | 14.3529 | 14.3214 | 14.3286 | 271432.0 |
| 2013-07-01 07:10:00 | AAPL | Stock | 14.3286 | 14.375 | 14.3286 | 14.3568 | 207536.0 |
| 2013-07-01 07:15:00 | AAPL | Stock | 14.345 | 14.3564 | 14.345 | 14.345 | 54880.0 |
| 2013-07-01 07:20:00 | AAPL | Stock | 14.3514 | 14.3518 | 14.3304 | 14.3386 | 73444.0 |
| 2013-07-01 07:25:00 | AAPL | Stock | 14.3307 | 14.3357 | 14.3214 | 14.3339 | 214312.0 |
| 2013-07-01 07:30:00 | AAPL | Stock | 14.335 | 14.3721 | 14.335 | 14.3571 | 139608.0 |
| 2013-07-01 07:35:00 | AAPL | Stock | 14.3571 | 14.3661 | 14.3571 | 14.3661 | 75600.0 |
| 2013-07-01 07:40:00 | AAPL | Stock | 14.3714 | 14.3821 | 14.3714 | 14.3821 | 47600.0 |
| 2013-07-01 07:45:00 | AAPL | Stock | 14.3771 | 14.3771 | 14.3679 | 14.3679 | 35392.0 |
| 2013-07-01 07:50:00 | AAPL | Stock | 14.3696 | 14.3696 | 14.3571 | 14.3579 | 123732.0 |
| 2013-07-01 07:55:00 | AAPL | Stock | 14.3611 | 14.375 | 14.36 | 14.375 | 126280.0 |
| 2013-07-01 08:00:00 | AAPL | Stock | 14.3668 | 14.3821 | 14.1193 | 14.3482 | 556752.0 |
| 2013-07-01 08:05:00 | AAPL | Stock | 14.3418 | 14.3479 | 14.1618 | 14.3479 | 158340.0 |
| 2013-07-01 08:10:00 | AAPL | Stock | 14.3514 | 14.3686 | 14.3482 | 14.3686 | 224896.0 |
| 2013-07-01 08:15:00 | AAPL | Stock | 14.3696 | 14.3929 | 14.3696 | 14.3893 | 342188.0 |
| 2013-07-01 08:20:00 | AAPL | Stock | 14.3857 | 14.3857 | 14.3668 | 14.3789 | 155428.0 |
| 2013-07-01 08:25:00 | AAPL | Stock | 14.375 | 14.3786 | 14.3629 | 14.3643 | 125216.0 |
| 2013-07-01 08:30:00 | AAPL | Stock | 14.3661 | 14.3661 | 14.3464 | 14.3582 | 155820.0 |
| 2013-07-01 08:35:00 | AAPL | Stock | 14.3568 | 14.3568 | 14.3543 | 14.3554 | 10500.0 |
| 2013-07-01 08:40:00 | AAPL | Stock | 14.3568 | 14.3571 | 14.3375 | 14.3461 | 183540.0 |
| 2013-07-01 08:45:00 | AAPL | Stock | 14.3464 | 14.3482 | 14.3393 | 14.3461 | 97300.0 |
| 2013-07-01 08:50:00 | AAPL | Stock | 14.3511 | 14.3511 | 14.3411 | 14.3429 | 128212.0 |
| 2013-07-01 08:55:00 | AAPL | Stock | 14.3393 | 14.3564 | 14.3307 | 14.3518 | 106148.0 |
| 2013-07-01 09:00:00 | AAPL | Stock | 14.3518 | 14.3621 | 14.3471 | 14.3611 | 76496.0 |
| 2013-07-01 09:05:00 | AAPL | Stock | 14.3579 | 14.3679 | 14.3571 | 14.3661 | 220024.0 |
| 2013-07-01 09:10:00 | AAPL | Stock | 14.3707 | 14.375 | 14.3661 | 14.375 | 212772.0 |
| 2013-07-01 09:15:00 | AAPL | Stock | 14.375 | 14.375 | 14.3696 | 14.375 | 118496.0 |
| 2013-07-01 09:20:00 | AAPL | Stock | 14.38 | 14.3993 | 14.38 | 14.3921 | 520744.0 |
| 2013-07-01 09:25:00 | AAPL | Stock | 14.3964 | 14.3993 | 14.3771 | 14.3814 | 798980.0 |
| 2013-07-01 09:30:00 | AAPL | Stock | 14.3818 | 14.4161 | 14.3304 | 14.3307 | 17272752.0 |
| 2013-07-01 09:35:00 | AAPL | Stock | 14.3329 | 14.4204 | 14.3293 | 14.3793 | 13858628.0 |
| 2013-07-01 09:40:00 | AAPL | Stock | 14.3809 | 14.4018 | 14.3571 | 14.3764 | 6022632.0 |
| 2013-07-01 09:45:00 | AAPL | Stock | 14.3782 | 14.4361 | 14.3764 | 14.4241 | 10783528.0 |
| 2013-07-01 09:50:00 | AAPL | Stock | 14.4256 | 14.4914 | 14.4139 | 14.4796 | 10440780.0 |
| 2013-07-01 09:55:00 | AAPL | Stock | 14.4793 | 14.515 | 14.4675 | 14.4807 | 9319856.0 |
| 2013-07-01 10:00:00 | AAPL | Stock | 14.4846 | 14.5193 | 14.4761 | 14.4996 | 6485108.0 |
> showing 50 of 348,495 rows — these rows as CSV