PREVIEW / stock_5min / 2012-12-28
file: by_date/stock_5min/2012/2012-12-28.parquet size: 4.7 MB rows: 320,320 symbols: 3,506
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-28 05:25:00 | AAPL | Stock | 18.3 | 18.3 | 18.3 | 18.3 | 2800.0 |
| 2012-12-28 05:30:00 | AAPL | Stock | 18.3 | 18.3 | 18.3 | 18.3 | 2800.0 |
| 2012-12-28 05:35:00 | AAPL | Stock | 18.3 | 18.3 | 18.2911 | 18.2911 | 19600.0 |
| 2012-12-28 05:40:00 | AAPL | Stock | 18.2914 | 18.2914 | 18.2911 | 18.2911 | 7560.0 |
| 2012-12-28 05:45:00 | AAPL | Stock | 18.2911 | 18.2911 | 18.2911 | 18.2911 | 2800.0 |
| 2012-12-28 05:55:00 | AAPL | Stock | 18.2964 | 18.2964 | 18.2964 | 18.2964 | 2800.0 |
| 2012-12-28 06:00:00 | AAPL | Stock | 18.2954 | 18.2954 | 18.2911 | 18.2911 | 8400.0 |
| 2012-12-28 06:05:00 | AAPL | Stock | 18.2921 | 18.2921 | 18.2921 | 18.2921 | 2800.0 |
| 2012-12-28 06:10:00 | AAPL | Stock | 18.2911 | 18.2911 | 18.2857 | 18.2857 | 10332.0 |
| 2012-12-28 06:15:00 | AAPL | Stock | 18.3054 | 18.3054 | 18.3054 | 18.3054 | 2800.0 |
| 2012-12-28 06:20:00 | AAPL | Stock | 18.2857 | 18.2857 | 18.2857 | 18.2857 | 8400.0 |
| 2012-12-28 06:30:00 | AAPL | Stock | 18.2693 | 18.2693 | 18.2693 | 18.2693 | 2800.0 |
| 2012-12-28 06:45:00 | AAPL | Stock | 18.2786 | 18.2786 | 18.2786 | 18.2786 | 8400.0 |
| 2012-12-28 06:50:00 | AAPL | Stock | 18.2686 | 18.2821 | 18.2686 | 18.2821 | 19600.0 |
| 2012-12-28 06:55:00 | AAPL | Stock | 18.2821 | 18.2821 | 18.2818 | 18.2821 | 16800.0 |
| 2012-12-28 07:00:00 | AAPL | Stock | 18.2754 | 18.2857 | 18.2693 | 18.2857 | 57456.0 |
| 2012-12-28 07:05:00 | AAPL | Stock | 18.2682 | 18.2693 | 18.2579 | 18.2693 | 21000.0 |
| 2012-12-28 07:10:00 | AAPL | Stock | 18.2929 | 18.3 | 18.2789 | 18.2789 | 17920.0 |
| 2012-12-28 07:20:00 | AAPL | Stock | 18.2793 | 18.3 | 18.2793 | 18.2968 | 33600.0 |
| 2012-12-28 07:25:00 | AAPL | Stock | 18.2968 | 18.31 | 18.2893 | 18.3036 | 49728.0 |
| 2012-12-28 07:30:00 | AAPL | Stock | 18.3107 | 18.3207 | 18.3107 | 18.3207 | 40768.0 |
| 2012-12-28 07:35:00 | AAPL | Stock | 18.3214 | 18.3268 | 18.3036 | 18.3036 | 76524.0 |
| 2012-12-28 07:40:00 | AAPL | Stock | 18.2946 | 18.295 | 18.2875 | 18.2875 | 16800.0 |
| 2012-12-28 07:45:00 | AAPL | Stock | 18.2857 | 18.2857 | 18.2846 | 18.2846 | 7896.0 |
| 2012-12-28 07:55:00 | AAPL | Stock | 18.27 | 18.27 | 18.2604 | 18.2604 | 14000.0 |
| 2012-12-28 08:00:00 | AAPL | Stock | 18.2539 | 18.3036 | 18.22 | 18.2514 | 299012.0 |
| 2012-12-28 08:05:00 | AAPL | Stock | 18.2446 | 18.2579 | 18.1986 | 18.2136 | 229600.0 |
| 2012-12-28 08:10:00 | AAPL | Stock | 18.2071 | 18.2382 | 18.2071 | 18.2143 | 219436.0 |
| 2012-12-28 08:15:00 | AAPL | Stock | 18.2143 | 18.2161 | 18.1646 | 18.2125 | 233772.0 |
| 2012-12-28 08:20:00 | AAPL | Stock | 18.2007 | 18.2154 | 18.1857 | 18.1946 | 418852.0 |
| 2012-12-28 08:25:00 | AAPL | Stock | 18.2111 | 18.2214 | 18.1979 | 18.2154 | 169680.0 |
| 2012-12-28 08:30:00 | AAPL | Stock | 18.2157 | 18.2439 | 18.2143 | 18.2439 | 140700.0 |
| 2012-12-28 08:35:00 | AAPL | Stock | 18.2311 | 18.2411 | 18.23 | 18.2368 | 168056.0 |
| 2012-12-28 08:40:00 | AAPL | Stock | 18.2329 | 18.2386 | 18.2179 | 18.2257 | 252084.0 |
| 2012-12-28 08:45:00 | AAPL | Stock | 18.2318 | 18.2554 | 18.2232 | 18.2536 | 163436.0 |
| 2012-12-28 08:50:00 | AAPL | Stock | 18.25 | 18.2536 | 18.2393 | 18.2411 | 89600.0 |
| 2012-12-28 08:55:00 | AAPL | Stock | 18.2357 | 18.25 | 18.2336 | 18.25 | 137116.0 |
| 2012-12-28 09:00:00 | AAPL | Stock | 18.2496 | 18.2507 | 18.2411 | 18.2482 | 134344.0 |
| 2012-12-28 09:05:00 | AAPL | Stock | 18.2493 | 18.25 | 18.2289 | 18.245 | 278796.0 |
| 2012-12-28 09:10:00 | AAPL | Stock | 18.2457 | 18.2507 | 18.2411 | 18.2461 | 78400.0 |
| 2012-12-28 09:15:00 | AAPL | Stock | 18.2386 | 18.2389 | 18.2243 | 18.2243 | 81200.0 |
| 2012-12-28 09:20:00 | AAPL | Stock | 18.2332 | 18.2482 | 18.2214 | 18.2464 | 257096.0 |
| 2012-12-28 09:25:00 | AAPL | Stock | 18.2461 | 18.2461 | 18.2214 | 18.2307 | 449680.0 |
| 2012-12-28 09:30:00 | AAPL | Stock | 18.2321 | 18.2879 | 18.1968 | 18.2725 | 14181776.0 |
| 2012-12-28 09:35:00 | AAPL | Stock | 18.2743 | 18.3289 | 18.2654 | 18.2919 | 9409428.0 |
| 2012-12-28 09:40:00 | AAPL | Stock | 18.2918 | 18.3439 | 18.2786 | 18.3064 | 7691236.0 |
| 2012-12-28 09:45:00 | AAPL | Stock | 18.3025 | 18.3236 | 18.2382 | 18.2382 | 7997248.0 |
| 2012-12-28 09:50:00 | AAPL | Stock | 18.2393 | 18.2589 | 18.2146 | 18.225 | 7689024.0 |
| 2012-12-28 09:55:00 | AAPL | Stock | 18.2247 | 18.2536 | 18.2154 | 18.2414 | 6194440.0 |
| 2012-12-28 10:00:00 | AAPL | Stock | 18.2449 | 18.2707 | 18.2286 | 18.2675 | 4749556.0 |
> showing 50 of 320,320 rows — these rows as CSV