PREVIEW / stock_5min / 2009-11-13
file: by_date/stock_5min/2009/2009-11-13.parquet size: 4.6 MB rows: 313,715 symbols: 3,400
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-11-13 05:20:00 | AAPL | Stock | 7.2411 | 7.2411 | 7.215 | 7.215 | 12936.0 |
| 2009-11-13 05:30:00 | AAPL | Stock | 7.215 | 7.215 | 7.215 | 7.215 | 4872.0 |
| 2009-11-13 05:35:00 | AAPL | Stock | 7.2004 | 7.2004 | 7.1714 | 7.2004 | 14000.0 |
| 2009-11-13 05:40:00 | AAPL | Stock | 7.2071 | 7.2071 | 7.2071 | 7.2071 | 2800.0 |
| 2009-11-13 06:00:00 | AAPL | Stock | 7.2146 | 7.2146 | 7.2146 | 7.2146 | 2800.0 |
| 2009-11-13 06:25:00 | AAPL | Stock | 7.2404 | 7.2404 | 7.2404 | 7.2404 | 2800.0 |
| 2009-11-13 07:00:00 | AAPL | Stock | 7.2429 | 7.2429 | 7.2429 | 7.2429 | 5600.0 |
| 2009-11-13 07:55:00 | AAPL | Stock | 7.2364 | 7.2364 | 7.2364 | 7.2364 | 8400.0 |
| 2009-11-13 08:00:00 | AAPL | Stock | 7.2321 | 7.2411 | 7.2321 | 7.2357 | 155260.0 |
| 2009-11-13 08:05:00 | AAPL | Stock | 7.2361 | 7.2361 | 7.225 | 7.2321 | 109368.0 |
| 2009-11-13 08:10:00 | AAPL | Stock | 7.2325 | 7.2357 | 7.2318 | 7.2354 | 44184.0 |
| 2009-11-13 08:15:00 | AAPL | Stock | 7.235 | 7.2357 | 7.2321 | 7.2329 | 33908.0 |
| 2009-11-13 08:20:00 | AAPL | Stock | 7.2357 | 7.2429 | 7.2357 | 7.2411 | 142800.0 |
| 2009-11-13 08:25:00 | AAPL | Stock | 7.2429 | 7.2429 | 7.2429 | 7.2429 | 29260.0 |
| 2009-11-13 08:30:00 | AAPL | Stock | 7.2429 | 7.2554 | 7.2429 | 7.2554 | 190260.0 |
| 2009-11-13 08:35:00 | AAPL | Stock | 7.2554 | 7.2707 | 7.2554 | 7.2696 | 399784.0 |
| 2009-11-13 08:40:00 | AAPL | Stock | 7.2707 | 7.2757 | 7.2593 | 7.2593 | 317100.0 |
| 2009-11-13 08:45:00 | AAPL | Stock | 7.2621 | 7.2679 | 7.2607 | 7.2625 | 369488.0 |
| 2009-11-13 08:50:00 | AAPL | Stock | 7.2629 | 7.2632 | 7.2596 | 7.26 | 39200.0 |
| 2009-11-13 08:55:00 | AAPL | Stock | 7.2596 | 7.2607 | 7.2593 | 7.26 | 73920.0 |
| 2009-11-13 09:00:00 | AAPL | Stock | 7.2607 | 7.2607 | 7.2539 | 7.2564 | 183260.0 |
| 2009-11-13 09:05:00 | AAPL | Stock | 7.2582 | 7.26 | 7.2571 | 7.26 | 88200.0 |
| 2009-11-13 09:10:00 | AAPL | Stock | 7.2568 | 7.2568 | 7.2404 | 7.2404 | 170212.0 |
| 2009-11-13 09:15:00 | AAPL | Stock | 7.2443 | 7.2493 | 7.2443 | 7.2493 | 44800.0 |
| 2009-11-13 09:20:00 | AAPL | Stock | 7.255 | 7.2625 | 7.25 | 7.2543 | 159208.0 |
| 2009-11-13 09:25:00 | AAPL | Stock | 7.2539 | 7.2539 | 7.2457 | 7.2457 | 44800.0 |
| 2009-11-13 09:30:00 | AAPL | Stock | 7.2464 | 7.2536 | 7.2279 | 7.2357 | 11951772.0 |
| 2009-11-13 09:35:00 | AAPL | Stock | 7.2357 | 7.2429 | 7.2168 | 7.242 | 8535968.0 |
| 2009-11-13 09:40:00 | AAPL | Stock | 7.2421 | 7.2614 | 7.2321 | 7.2439 | 7813008.0 |
| 2009-11-13 09:45:00 | AAPL | Stock | 7.2432 | 7.2543 | 7.2411 | 7.2468 | 4922708.0 |
| 2009-11-13 09:50:00 | AAPL | Stock | 7.245 | 7.2546 | 7.2393 | 7.2504 | 8271564.0 |
| 2009-11-13 09:55:00 | AAPL | Stock | 7.245 | 7.2554 | 7.2232 | 7.2357 | 13518960.0 |
| 2009-11-13 10:00:00 | AAPL | Stock | 7.2343 | 7.2475 | 7.2282 | 7.2421 | 5104624.0 |
| 2009-11-13 10:05:00 | AAPL | Stock | 7.2439 | 7.2475 | 7.2357 | 7.2396 | 4411484.0 |
| 2009-11-13 10:10:00 | AAPL | Stock | 7.2411 | 7.2479 | 7.2329 | 7.2398 | 4329836.0 |
| 2009-11-13 10:15:00 | AAPL | Stock | 7.2393 | 7.2554 | 7.2364 | 7.2518 | 4752748.0 |
| 2009-11-13 10:20:00 | AAPL | Stock | 7.2511 | 7.2679 | 7.2511 | 7.2659 | 10976896.0 |
| 2009-11-13 10:25:00 | AAPL | Stock | 7.265 | 7.2664 | 7.2582 | 7.2639 | 3269252.0 |
| 2009-11-13 10:30:00 | AAPL | Stock | 7.2621 | 7.2696 | 7.2414 | 7.2482 | 7643552.0 |
| 2009-11-13 10:35:00 | AAPL | Stock | 7.2493 | 7.2643 | 7.2482 | 7.2607 | 4614456.0 |
| 2009-11-13 10:40:00 | AAPL | Stock | 7.2607 | 7.2664 | 7.2571 | 7.2625 | 3943632.0 |
| 2009-11-13 10:45:00 | AAPL | Stock | 7.2639 | 7.2689 | 7.2579 | 7.2593 | 2965116.0 |
| 2009-11-13 10:50:00 | AAPL | Stock | 7.2593 | 7.2657 | 7.2564 | 7.2618 | 2779504.0 |
| 2009-11-13 10:55:00 | AAPL | Stock | 7.2618 | 7.2639 | 7.2564 | 7.2564 | 2211384.0 |
| 2009-11-13 11:00:00 | AAPL | Stock | 7.2568 | 7.2607 | 7.2529 | 7.2602 | 3628744.0 |
| 2009-11-13 11:05:00 | AAPL | Stock | 7.2604 | 7.2643 | 7.2586 | 7.2627 | 1810900.0 |
| 2009-11-13 11:10:00 | AAPL | Stock | 7.2626 | 7.2626 | 7.2579 | 7.2586 | 2537304.0 |
| 2009-11-13 11:15:00 | AAPL | Stock | 7.2586 | 7.2661 | 7.2579 | 7.2645 | 2675204.0 |
| 2009-11-13 11:20:00 | AAPL | Stock | 7.2643 | 7.2761 | 7.2636 | 7.275 | 5604144.0 |
| 2009-11-13 11:25:00 | AAPL | Stock | 7.2746 | 7.2829 | 7.2743 | 7.2779 | 6363476.0 |
> showing 50 of 313,715 rows — these rows as CSV