PREVIEW / stock_5min / 2012-08-13
file: by_date/stock_5min/2012/2012-08-13.parquet size: 4.5 MB rows: 309,724 symbols: 3,471
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-13 04:00:00 | AAPL | Stock | 22.2036 | 22.2036 | 22.1661 | 22.1661 | 21000.0 |
| 2012-08-13 04:20:00 | AAPL | Stock | 22.1664 | 22.1664 | 22.1664 | 22.1664 | 3276.0 |
| 2012-08-13 04:50:00 | AAPL | Stock | 22.1786 | 22.1786 | 22.1786 | 22.1786 | 2800.0 |
| 2012-08-13 05:10:00 | AAPL | Stock | 22.2054 | 22.2054 | 22.2054 | 22.2054 | 5600.0 |
| 2012-08-13 05:30:00 | AAPL | Stock | 22.2054 | 22.2054 | 22.2054 | 22.2054 | 2800.0 |
| 2012-08-13 05:40:00 | AAPL | Stock | 22.2054 | 22.2054 | 22.2054 | 22.2054 | 18060.0 |
| 2012-08-13 06:25:00 | AAPL | Stock | 22.2321 | 22.2321 | 22.2321 | 22.2321 | 9800.0 |
| 2012-08-13 06:30:00 | AAPL | Stock | 22.2321 | 22.2321 | 22.2321 | 22.2321 | 11200.0 |
| 2012-08-13 06:55:00 | AAPL | Stock | 22.2464 | 22.2464 | 22.2464 | 22.2464 | 2800.0 |
| 2012-08-13 07:00:00 | AAPL | Stock | 22.2464 | 22.2464 | 22.2439 | 22.2439 | 16800.0 |
| 2012-08-13 07:05:00 | AAPL | Stock | 22.24 | 22.24 | 22.24 | 22.24 | 5600.0 |
| 2012-08-13 07:15:00 | AAPL | Stock | 22.2714 | 22.2714 | 22.2625 | 22.2625 | 21168.0 |
| 2012-08-13 07:20:00 | AAPL | Stock | 22.2589 | 22.2589 | 22.2454 | 22.2454 | 24528.0 |
| 2012-08-13 07:25:00 | AAPL | Stock | 22.2411 | 22.2632 | 22.2411 | 22.2632 | 52920.0 |
| 2012-08-13 07:30:00 | AAPL | Stock | 22.2621 | 22.2643 | 22.2589 | 22.2589 | 19600.0 |
| 2012-08-13 07:35:00 | AAPL | Stock | 22.2589 | 22.2589 | 22.2518 | 22.2518 | 25200.0 |
| 2012-08-13 07:40:00 | AAPL | Stock | 22.2607 | 22.2814 | 22.2589 | 22.2814 | 96460.0 |
| 2012-08-13 07:45:00 | AAPL | Stock | 22.2811 | 22.3514 | 22.2811 | 22.3482 | 232036.0 |
| 2012-08-13 07:50:00 | AAPL | Stock | 22.3493 | 22.3571 | 22.3429 | 22.3429 | 69636.0 |
| 2012-08-13 07:55:00 | AAPL | Stock | 22.3464 | 22.3464 | 22.3261 | 22.3261 | 48300.0 |
| 2012-08-13 08:00:00 | AAPL | Stock | 22.3268 | 22.3429 | 22.2632 | 22.2968 | 488068.0 |
| 2012-08-13 08:05:00 | AAPL | Stock | 22.3 | 22.3118 | 22.2857 | 22.2889 | 153048.0 |
| 2012-08-13 08:10:00 | AAPL | Stock | 22.2929 | 22.3036 | 22.2929 | 22.3036 | 100520.0 |
| 2012-08-13 08:15:00 | AAPL | Stock | 22.3054 | 22.3054 | 22.2979 | 22.2979 | 33600.0 |
| 2012-08-13 08:20:00 | AAPL | Stock | 22.2986 | 22.3011 | 22.2779 | 22.2779 | 174720.0 |
| 2012-08-13 08:25:00 | AAPL | Stock | 22.2857 | 22.2904 | 22.2679 | 22.2786 | 200788.0 |
| 2012-08-13 08:30:00 | AAPL | Stock | 22.2807 | 22.2857 | 22.2761 | 22.2832 | 70672.0 |
| 2012-08-13 08:35:00 | AAPL | Stock | 22.2789 | 22.2857 | 22.2764 | 22.2814 | 186452.0 |
| 2012-08-13 08:40:00 | AAPL | Stock | 22.2821 | 22.2929 | 22.2821 | 22.285 | 308812.0 |
| 2012-08-13 08:45:00 | AAPL | Stock | 22.2886 | 22.2886 | 22.2839 | 22.2839 | 58800.0 |
| 2012-08-13 08:50:00 | AAPL | Stock | 22.2807 | 22.2929 | 22.2768 | 22.2929 | 176428.0 |
| 2012-08-13 08:55:00 | AAPL | Stock | 22.2929 | 22.2936 | 22.2857 | 22.2889 | 183232.0 |
| 2012-08-13 09:00:00 | AAPL | Stock | 22.2864 | 22.3025 | 22.2854 | 22.2946 | 410004.0 |
| 2012-08-13 09:05:00 | AAPL | Stock | 22.29 | 22.29 | 22.2807 | 22.2857 | 147476.0 |
| 2012-08-13 09:10:00 | AAPL | Stock | 22.2882 | 22.2882 | 22.2768 | 22.2768 | 136696.0 |
| 2012-08-13 09:15:00 | AAPL | Stock | 22.2786 | 22.2836 | 22.2671 | 22.2832 | 212240.0 |
| 2012-08-13 09:20:00 | AAPL | Stock | 22.2829 | 22.2936 | 22.2786 | 22.2914 | 120820.0 |
| 2012-08-13 09:25:00 | AAPL | Stock | 22.2929 | 22.2961 | 22.2625 | 22.2679 | 859936.0 |
| 2012-08-13 09:30:00 | AAPL | Stock | 22.2621 | 22.3164 | 22.2589 | 22.305 | 14255528.0 |
| 2012-08-13 09:35:00 | AAPL | Stock | 22.3032 | 22.4024 | 22.3004 | 22.3936 | 18461912.0 |
| 2012-08-13 09:40:00 | AAPL | Stock | 22.3936 | 22.445 | 22.3886 | 22.4296 | 12809328.0 |
| 2012-08-13 09:45:00 | AAPL | Stock | 22.4286 | 22.4375 | 22.4143 | 22.4189 | 7966952.0 |
| 2012-08-13 09:50:00 | AAPL | Stock | 22.4246 | 22.435 | 22.4143 | 22.4179 | 6722744.0 |
| 2012-08-13 09:55:00 | AAPL | Stock | 22.4168 | 22.4177 | 22.375 | 22.3799 | 9842196.0 |
| 2012-08-13 10:00:00 | AAPL | Stock | 22.3769 | 22.4189 | 22.3769 | 22.4175 | 4037320.0 |
| 2012-08-13 10:05:00 | AAPL | Stock | 22.4157 | 22.4179 | 22.3979 | 22.3993 | 3418436.0 |
| 2012-08-13 10:10:00 | AAPL | Stock | 22.3996 | 22.3996 | 22.3618 | 22.3714 | 5780768.0 |
| 2012-08-13 10:15:00 | AAPL | Stock | 22.3718 | 22.3839 | 22.3429 | 22.382 | 6733048.0 |
| 2012-08-13 10:20:00 | AAPL | Stock | 22.3824 | 22.3868 | 22.3614 | 22.3643 | 3408664.0 |
| 2012-08-13 10:25:00 | AAPL | Stock | 22.3625 | 22.41 | 22.3532 | 22.4036 | 5992056.0 |
> showing 50 of 309,724 rows — these rows as CSV