PREVIEW / stock_5min / 2002-09-24
file: by_date/stock_5min/2002/2002-09-24.parquet size: 1.8 MB rows: 130,168 symbols: 1,480
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 |
|---|---|---|---|---|---|---|---|
| 2002-09-24 08:00:00 | AAPL | Stock | 0.2623 | 0.2623 | 0.2623 | 0.2623 | 89600.0 |
| 2002-09-24 08:50:00 | AAPL | Stock | 0.2621 | 0.2621 | 0.262 | 0.2621 | 78400.0 |
| 2002-09-24 08:55:00 | AAPL | Stock | 0.2616 | 0.2616 | 0.2616 | 0.2616 | 50400.0 |
| 2002-09-24 09:00:00 | AAPL | Stock | 0.2616 | 0.2616 | 0.2616 | 0.2616 | 84000.0 |
| 2002-09-24 09:20:00 | AAPL | Stock | 0.2634 | 0.2643 | 0.2634 | 0.2643 | 117600.0 |
| 2002-09-24 09:25:00 | AAPL | Stock | 0.2634 | 0.2634 | 0.2571 | 0.2579 | 128800.0 |
| 2002-09-24 09:30:00 | AAPL | Stock | 0.2571 | 0.2646 | 0.2571 | 0.2634 | 7402192.0 |
| 2002-09-24 09:35:00 | AAPL | Stock | 0.2634 | 0.2634 | 0.2613 | 0.262 | 4720800.0 |
| 2002-09-24 09:40:00 | AAPL | Stock | 0.262 | 0.2625 | 0.2611 | 0.2613 | 8925336.0 |
| 2002-09-24 09:45:00 | AAPL | Stock | 0.2615 | 0.2618 | 0.2609 | 0.2616 | 8034992.0 |
| 2002-09-24 09:50:00 | AAPL | Stock | 0.2614 | 0.2621 | 0.2586 | 0.2586 | 6206480.0 |
| 2002-09-24 09:55:00 | AAPL | Stock | 0.2586 | 0.2589 | 0.2579 | 0.258 | 3605000.0 |
| 2002-09-24 10:00:00 | AAPL | Stock | 0.2582 | 0.2616 | 0.2582 | 0.2614 | 10468080.0 |
| 2002-09-24 10:05:00 | AAPL | Stock | 0.2609 | 0.2621 | 0.2607 | 0.2621 | 6208720.0 |
| 2002-09-24 10:10:00 | AAPL | Stock | 0.2621 | 0.2634 | 0.2611 | 0.2616 | 4154920.0 |
| 2002-09-24 10:15:00 | AAPL | Stock | 0.2616 | 0.2625 | 0.2613 | 0.2625 | 7397152.0 |
| 2002-09-24 10:20:00 | AAPL | Stock | 0.2625 | 0.2625 | 0.2616 | 0.2616 | 4589984.0 |
| 2002-09-24 10:25:00 | AAPL | Stock | 0.2618 | 0.2623 | 0.2616 | 0.2616 | 2016000.0 |
| 2002-09-24 10:30:00 | AAPL | Stock | 0.2616 | 0.2625 | 0.2613 | 0.2613 | 1901648.0 |
| 2002-09-24 10:35:00 | AAPL | Stock | 0.2613 | 0.2614 | 0.2605 | 0.2613 | 2217432.0 |
| 2002-09-24 10:40:00 | AAPL | Stock | 0.2613 | 0.2614 | 0.2611 | 0.2613 | 1439200.0 |
| 2002-09-24 10:45:00 | AAPL | Stock | 0.2614 | 0.2618 | 0.2613 | 0.2618 | 1002400.0 |
| 2002-09-24 10:50:00 | AAPL | Stock | 0.2618 | 0.2625 | 0.2616 | 0.2618 | 1030232.0 |
| 2002-09-24 10:55:00 | AAPL | Stock | 0.2616 | 0.262 | 0.2613 | 0.2613 | 2878400.0 |
| 2002-09-24 11:00:00 | AAPL | Stock | 0.2613 | 0.2614 | 0.2607 | 0.2613 | 1288000.0 |
| 2002-09-24 11:05:00 | AAPL | Stock | 0.2614 | 0.2621 | 0.2613 | 0.2616 | 1414840.0 |
| 2002-09-24 11:10:00 | AAPL | Stock | 0.2616 | 0.2618 | 0.2613 | 0.2614 | 459200.0 |
| 2002-09-24 11:15:00 | AAPL | Stock | 0.2614 | 0.2615 | 0.2607 | 0.2613 | 1332800.0 |
| 2002-09-24 11:20:00 | AAPL | Stock | 0.2613 | 0.2614 | 0.2609 | 0.2611 | 1736000.0 |
| 2002-09-24 11:25:00 | AAPL | Stock | 0.2611 | 0.2618 | 0.2611 | 0.2616 | 4773328.0 |
| 2002-09-24 11:30:00 | AAPL | Stock | 0.2616 | 0.2618 | 0.2616 | 0.2616 | 2133600.0 |
| 2002-09-24 11:35:00 | AAPL | Stock | 0.2616 | 0.2618 | 0.2614 | 0.2616 | 1164800.0 |
| 2002-09-24 11:40:00 | AAPL | Stock | 0.2616 | 0.262 | 0.2616 | 0.2616 | 3248000.0 |
| 2002-09-24 11:45:00 | AAPL | Stock | 0.2618 | 0.262 | 0.2616 | 0.262 | 453600.0 |
| 2002-09-24 11:50:00 | AAPL | Stock | 0.262 | 0.2621 | 0.2614 | 0.2614 | 1605800.0 |
| 2002-09-24 11:55:00 | AAPL | Stock | 0.2614 | 0.2616 | 0.2613 | 0.2614 | 5676944.0 |
| 2002-09-24 12:00:00 | AAPL | Stock | 0.2614 | 0.2618 | 0.2613 | 0.2616 | 766416.0 |
| 2002-09-24 12:05:00 | AAPL | Stock | 0.2616 | 0.262 | 0.2616 | 0.2618 | 710808.0 |
| 2002-09-24 12:10:00 | AAPL | Stock | 0.2616 | 0.2616 | 0.2613 | 0.2613 | 1114400.0 |
| 2002-09-24 12:15:00 | AAPL | Stock | 0.2614 | 0.2618 | 0.2613 | 0.2616 | 1769600.0 |
| 2002-09-24 12:20:00 | AAPL | Stock | 0.2616 | 0.2618 | 0.2613 | 0.2616 | 856800.0 |
| 2002-09-24 12:25:00 | AAPL | Stock | 0.2614 | 0.2616 | 0.2605 | 0.2614 | 3509408.0 |
| 2002-09-24 12:30:00 | AAPL | Stock | 0.2614 | 0.2616 | 0.2605 | 0.2609 | 1377600.0 |
| 2002-09-24 12:35:00 | AAPL | Stock | 0.2612 | 0.2612 | 0.2605 | 0.2611 | 1892800.0 |
| 2002-09-24 12:40:00 | AAPL | Stock | 0.2611 | 0.2611 | 0.2602 | 0.2602 | 862400.0 |
| 2002-09-24 12:45:00 | AAPL | Stock | 0.2602 | 0.2605 | 0.2595 | 0.2602 | 1702400.0 |
| 2002-09-24 12:50:00 | AAPL | Stock | 0.2602 | 0.2602 | 0.2589 | 0.2589 | 1593200.0 |
| 2002-09-24 12:55:00 | AAPL | Stock | 0.2591 | 0.2593 | 0.258 | 0.2588 | 2688000.0 |
| 2002-09-24 13:00:00 | AAPL | Stock | 0.2588 | 0.2595 | 0.2586 | 0.2595 | 369600.0 |
| 2002-09-24 13:05:00 | AAPL | Stock | 0.2593 | 0.2595 | 0.2589 | 0.2589 | 509600.0 |
> showing 50 of 130,168 rows — these rows as CSV