PREVIEW / stock_5min / 2009-07-16
file: by_date/stock_5min/2009/2009-07-16.parquet size: 4.5 MB rows: 311,320 symbols: 3,335
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 |
|---|---|---|---|---|---|---|---|
| 2009-07-16 05:55:00 | AAPL | Stock | 5.2643 | 5.2643 | 5.2643 | 5.2643 | 2800.0 |
| 2009-07-16 07:30:00 | AAPL | Stock | 5.2625 | 5.2625 | 5.2625 | 5.2625 | 2800.0 |
| 2009-07-16 07:40:00 | AAPL | Stock | 5.2436 | 5.25 | 5.2321 | 5.25 | 44856.0 |
| 2009-07-16 07:45:00 | AAPL | Stock | 5.2271 | 5.2271 | 5.2143 | 5.2143 | 355600.0 |
| 2009-07-16 07:50:00 | AAPL | Stock | 5.2246 | 5.2246 | 5.2071 | 5.21 | 77000.0 |
| 2009-07-16 07:55:00 | AAPL | Stock | 5.2071 | 5.2096 | 5.1904 | 5.1929 | 263368.0 |
| 2009-07-16 08:00:00 | AAPL | Stock | 5.1929 | 5.2082 | 5.1929 | 5.1964 | 302484.0 |
| 2009-07-16 08:05:00 | AAPL | Stock | 5.1946 | 5.2018 | 5.1946 | 5.2014 | 102984.0 |
| 2009-07-16 08:10:00 | AAPL | Stock | 5.2018 | 5.2071 | 5.1993 | 5.1993 | 122080.0 |
| 2009-07-16 08:15:00 | AAPL | Stock | 5.1986 | 5.2 | 5.1946 | 5.1968 | 344344.0 |
| 2009-07-16 08:20:00 | AAPL | Stock | 5.1964 | 5.1968 | 5.1932 | 5.1968 | 175028.0 |
| 2009-07-16 08:25:00 | AAPL | Stock | 5.2004 | 5.2071 | 5.2004 | 5.2039 | 157080.0 |
| 2009-07-16 08:30:00 | AAPL | Stock | 5.2068 | 5.2268 | 5.2068 | 5.2211 | 646940.0 |
| 2009-07-16 08:35:00 | AAPL | Stock | 5.2229 | 5.2229 | 5.2125 | 5.2143 | 374528.0 |
| 2009-07-16 08:40:00 | AAPL | Stock | 5.2179 | 5.2179 | 5.2046 | 5.2046 | 104132.0 |
| 2009-07-16 08:45:00 | AAPL | Stock | 5.2043 | 5.2043 | 5.1982 | 5.1982 | 104300.0 |
| 2009-07-16 08:50:00 | AAPL | Stock | 5.1982 | 5.2018 | 5.1964 | 5.2 | 113120.0 |
| 2009-07-16 08:55:00 | AAPL | Stock | 5.2018 | 5.2089 | 5.2018 | 5.2089 | 19600.0 |
| 2009-07-16 09:00:00 | AAPL | Stock | 5.2057 | 5.2057 | 5.2 | 5.2018 | 88032.0 |
| 2009-07-16 09:05:00 | AAPL | Stock | 5.2 | 5.2014 | 5.1982 | 5.2 | 68628.0 |
| 2009-07-16 09:10:00 | AAPL | Stock | 5.2018 | 5.2018 | 5.1964 | 5.2 | 221704.0 |
| 2009-07-16 09:15:00 | AAPL | Stock | 5.1982 | 5.2004 | 5.1982 | 5.2004 | 50400.0 |
| 2009-07-16 09:20:00 | AAPL | Stock | 5.1982 | 5.1982 | 5.1957 | 5.1961 | 80472.0 |
| 2009-07-16 09:25:00 | AAPL | Stock | 5.1961 | 5.2139 | 5.1946 | 5.2139 | 534996.0 |
| 2009-07-16 09:30:00 | AAPL | Stock | 5.21 | 5.2496 | 5.1989 | 5.24 | 15006152.0 |
| 2009-07-16 09:35:00 | AAPL | Stock | 5.2386 | 5.2754 | 5.2336 | 5.27 | 18782904.0 |
| 2009-07-16 09:40:00 | AAPL | Stock | 5.27 | 5.2825 | 5.2546 | 5.26 | 15094800.0 |
| 2009-07-16 09:45:00 | AAPL | Stock | 5.26 | 5.2668 | 5.2386 | 5.2439 | 14628208.0 |
| 2009-07-16 09:50:00 | AAPL | Stock | 5.2454 | 5.2764 | 5.2454 | 5.2659 | 12772760.0 |
| 2009-07-16 09:55:00 | AAPL | Stock | 5.2671 | 5.2679 | 5.2546 | 5.2652 | 5370764.0 |
| 2009-07-16 10:00:00 | AAPL | Stock | 5.2664 | 5.2664 | 5.2457 | 5.2457 | 7954520.0 |
| 2009-07-16 10:05:00 | AAPL | Stock | 5.2457 | 5.2482 | 5.2286 | 5.2399 | 9084264.0 |
| 2009-07-16 10:10:00 | AAPL | Stock | 5.24 | 5.2446 | 5.2332 | 5.2441 | 4301808.0 |
| 2009-07-16 10:15:00 | AAPL | Stock | 5.2443 | 5.2529 | 5.2368 | 5.2382 | 5192264.0 |
| 2009-07-16 10:20:00 | AAPL | Stock | 5.2396 | 5.2479 | 5.2357 | 5.24 | 3499440.0 |
| 2009-07-16 10:25:00 | AAPL | Stock | 5.24 | 5.2589 | 5.24 | 5.2554 | 4379368.0 |
| 2009-07-16 10:30:00 | AAPL | Stock | 5.255 | 5.2625 | 5.2521 | 5.2539 | 5054504.0 |
| 2009-07-16 10:35:00 | AAPL | Stock | 5.2536 | 5.2679 | 5.2529 | 5.2654 | 4271316.0 |
| 2009-07-16 10:40:00 | AAPL | Stock | 5.2657 | 5.2693 | 5.2614 | 5.2664 | 4051600.0 |
| 2009-07-16 10:45:00 | AAPL | Stock | 5.2664 | 5.2693 | 5.2589 | 5.26 | 3684100.0 |
| 2009-07-16 10:50:00 | AAPL | Stock | 5.2596 | 5.2671 | 5.2564 | 5.2643 | 2469404.0 |
| 2009-07-16 10:55:00 | AAPL | Stock | 5.2654 | 5.2657 | 5.2536 | 5.2536 | 2543100.0 |
| 2009-07-16 11:00:00 | AAPL | Stock | 5.2537 | 5.2646 | 5.2532 | 5.2632 | 2470552.0 |
| 2009-07-16 11:05:00 | AAPL | Stock | 5.2632 | 5.2693 | 5.2625 | 5.2654 | 2583056.0 |
| 2009-07-16 11:10:00 | AAPL | Stock | 5.2646 | 5.2646 | 5.2507 | 5.2546 | 3569216.0 |
| 2009-07-16 11:15:00 | AAPL | Stock | 5.2546 | 5.2554 | 5.2429 | 5.2486 | 4515028.0 |
| 2009-07-16 11:20:00 | AAPL | Stock | 5.2489 | 5.2596 | 5.2483 | 5.2582 | 2762340.0 |
| 2009-07-16 11:25:00 | AAPL | Stock | 5.2582 | 5.2593 | 5.2532 | 5.2539 | 1879360.0 |
| 2009-07-16 11:30:00 | AAPL | Stock | 5.2536 | 5.2539 | 5.2464 | 5.2481 | 3542084.0 |
| 2009-07-16 11:35:00 | AAPL | Stock | 5.2473 | 5.2521 | 5.2429 | 5.2518 | 3350116.0 |
> showing 50 of 311,320 rows — these rows as CSV