PREVIEW / stock_5min / 2012-12-27
file: by_date/stock_5min/2012/2012-12-27.parquet size: 4.8 MB rows: 322,324 symbols: 3,510
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-12-27 04:05:00 | AAPL | Stock | 18.2504 | 18.2504 | 18.2504 | 18.2504 | 2800.0 |
| 2012-12-27 04:15:00 | AAPL | Stock | 18.2504 | 18.2504 | 18.2504 | 18.2504 | 2800.0 |
| 2012-12-27 04:40:00 | AAPL | Stock | 18.1968 | 18.1968 | 18.1968 | 18.1968 | 5600.0 |
| 2012-12-27 05:00:00 | AAPL | Stock | 18.2143 | 18.2143 | 18.2143 | 18.2143 | 2800.0 |
| 2012-12-27 05:15:00 | AAPL | Stock | 18.1982 | 18.2071 | 18.1982 | 18.2071 | 75572.0 |
| 2012-12-27 06:00:00 | AAPL | Stock | 18.2043 | 18.2043 | 18.2043 | 18.2043 | 2800.0 |
| 2012-12-27 06:10:00 | AAPL | Stock | 18.2018 | 18.2018 | 18.2018 | 18.2018 | 2800.0 |
| 2012-12-27 06:50:00 | AAPL | Stock | 18.2179 | 18.2179 | 18.2179 | 18.2179 | 2800.0 |
| 2012-12-27 07:00:00 | AAPL | Stock | 18.2146 | 18.2146 | 18.2146 | 18.2146 | 2800.0 |
| 2012-12-27 07:05:00 | AAPL | Stock | 18.2464 | 18.2714 | 18.2464 | 18.2714 | 21700.0 |
| 2012-12-27 07:10:00 | AAPL | Stock | 18.2786 | 18.2843 | 18.2768 | 18.2839 | 14000.0 |
| 2012-12-27 07:15:00 | AAPL | Stock | 18.2818 | 18.3036 | 18.2818 | 18.2925 | 22484.0 |
| 2012-12-27 07:20:00 | AAPL | Stock | 18.3214 | 18.3314 | 18.3129 | 18.3314 | 71204.0 |
| 2012-12-27 07:25:00 | AAPL | Stock | 18.3389 | 18.3446 | 18.3257 | 18.3393 | 30800.0 |
| 2012-12-27 07:30:00 | AAPL | Stock | 18.3482 | 18.3482 | 18.3482 | 18.3482 | 2800.0 |
| 2012-12-27 07:35:00 | AAPL | Stock | 18.3429 | 18.3429 | 18.3214 | 18.3393 | 25200.0 |
| 2012-12-27 07:40:00 | AAPL | Stock | 18.3368 | 18.3393 | 18.3214 | 18.3393 | 14000.0 |
| 2012-12-27 07:45:00 | AAPL | Stock | 18.3429 | 18.3568 | 18.3429 | 18.3568 | 11200.0 |
| 2012-12-27 07:50:00 | AAPL | Stock | 18.3429 | 18.3429 | 18.3271 | 18.3271 | 7224.0 |
| 2012-12-27 07:55:00 | AAPL | Stock | 18.3261 | 18.3393 | 18.3261 | 18.3393 | 39200.0 |
| 2012-12-27 08:00:00 | AAPL | Stock | 18.3393 | 18.375 | 18.2464 | 18.375 | 249396.0 |
| 2012-12-27 08:05:00 | AAPL | Stock | 18.3536 | 18.3536 | 18.3393 | 18.3393 | 56840.0 |
| 2012-12-27 08:10:00 | AAPL | Stock | 18.3507 | 18.4107 | 18.3504 | 18.4107 | 284116.0 |
| 2012-12-27 08:15:00 | AAPL | Stock | 18.4225 | 18.4225 | 18.375 | 18.3857 | 113148.0 |
| 2012-12-27 08:20:00 | AAPL | Stock | 18.3836 | 18.3861 | 18.3611 | 18.3743 | 71400.0 |
| 2012-12-27 08:25:00 | AAPL | Stock | 18.3804 | 18.3911 | 18.3804 | 18.3911 | 41636.0 |
| 2012-12-27 08:30:00 | AAPL | Stock | 18.3914 | 18.3914 | 18.3636 | 18.3818 | 93408.0 |
| 2012-12-27 08:35:00 | AAPL | Stock | 18.3679 | 18.3736 | 18.3386 | 18.3571 | 197512.0 |
| 2012-12-27 08:40:00 | AAPL | Stock | 18.3643 | 18.3982 | 18.3536 | 18.3929 | 232792.0 |
| 2012-12-27 08:45:00 | AAPL | Stock | 18.3929 | 18.3929 | 18.3643 | 18.3825 | 204484.0 |
| 2012-12-27 08:50:00 | AAPL | Stock | 18.375 | 18.3818 | 18.3643 | 18.3786 | 45360.0 |
| 2012-12-27 08:55:00 | AAPL | Stock | 18.3786 | 18.3811 | 18.3611 | 18.3811 | 28000.0 |
| 2012-12-27 09:00:00 | AAPL | Stock | 18.3643 | 18.3643 | 18.3643 | 18.3643 | 2800.0 |
| 2012-12-27 09:05:00 | AAPL | Stock | 18.3664 | 18.3846 | 18.3571 | 18.3611 | 132720.0 |
| 2012-12-27 09:10:00 | AAPL | Stock | 18.3611 | 18.3732 | 18.3425 | 18.3732 | 205912.0 |
| 2012-12-27 09:15:00 | AAPL | Stock | 18.3721 | 18.3779 | 18.3621 | 18.3736 | 148680.0 |
| 2012-12-27 09:20:00 | AAPL | Stock | 18.3746 | 18.3961 | 18.3593 | 18.3732 | 181384.0 |
| 2012-12-27 09:25:00 | AAPL | Stock | 18.3664 | 18.3732 | 18.34 | 18.3429 | 106400.0 |
| 2012-12-27 09:30:00 | AAPL | Stock | 18.3407 | 18.3561 | 18.2364 | 18.2482 | 12135704.0 |
| 2012-12-27 09:35:00 | AAPL | Stock | 18.2464 | 18.3036 | 18.2321 | 18.2886 | 9002308.0 |
| 2012-12-27 09:40:00 | AAPL | Stock | 18.2882 | 18.32 | 18.2611 | 18.2718 | 7824348.0 |
| 2012-12-27 09:45:00 | AAPL | Stock | 18.2782 | 18.2918 | 18.2564 | 18.2621 | 5621644.0 |
| 2012-12-27 09:50:00 | AAPL | Stock | 18.2664 | 18.2752 | 18.2346 | 18.2664 | 5990936.0 |
| 2012-12-27 09:55:00 | AAPL | Stock | 18.2586 | 18.2857 | 18.2507 | 18.2646 | 3549980.0 |
| 2012-12-27 10:00:00 | AAPL | Stock | 18.2636 | 18.265 | 18.2143 | 18.2218 | 11540648.0 |
| 2012-12-27 10:05:00 | AAPL | Stock | 18.2246 | 18.2546 | 18.2136 | 18.2321 | 9012500.0 |
| 2012-12-27 10:10:00 | AAPL | Stock | 18.2311 | 18.2546 | 18.2271 | 18.2393 | 3741556.0 |
| 2012-12-27 10:15:00 | AAPL | Stock | 18.2357 | 18.2582 | 18.2143 | 18.2168 | 6396824.0 |
| 2012-12-27 10:20:00 | AAPL | Stock | 18.216 | 18.2357 | 18.1571 | 18.1836 | 11756220.0 |
| 2012-12-27 10:25:00 | AAPL | Stock | 18.1875 | 18.21 | 18.1768 | 18.1971 | 6046656.0 |
> showing 50 of 322,324 rows — these rows as CSV