PREVIEW / stock_5min / 2002-08-01
file: by_date/stock_5min/2002/2002-08-01.parquet size: 1.8 MB rows: 125,825 symbols: 1,450
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-08-01 08:45:00 | AAPL | Stock | 0.2725 | 0.2725 | 0.2725 | 0.2725 | 1859200.0 |
| 2002-08-01 09:20:00 | AAPL | Stock | 0.2725 | 0.2725 | 0.2725 | 0.2725 | 89600.0 |
| 2002-08-01 09:25:00 | AAPL | Stock | 0.2702 | 0.2702 | 0.2702 | 0.2702 | 112000.0 |
| 2002-08-01 09:30:00 | AAPL | Stock | 0.2698 | 0.2736 | 0.2695 | 0.2718 | 2205392.0 |
| 2002-08-01 09:35:00 | AAPL | Stock | 0.272 | 0.2739 | 0.2695 | 0.2739 | 2447200.0 |
| 2002-08-01 09:40:00 | AAPL | Stock | 0.2739 | 0.2754 | 0.272 | 0.2721 | 2679488.0 |
| 2002-08-01 09:45:00 | AAPL | Stock | 0.2723 | 0.2723 | 0.27 | 0.2705 | 2279592.0 |
| 2002-08-01 09:50:00 | AAPL | Stock | 0.2709 | 0.2732 | 0.2705 | 0.272 | 1937600.0 |
| 2002-08-01 09:55:00 | AAPL | Stock | 0.272 | 0.2741 | 0.2709 | 0.2739 | 2267328.0 |
| 2002-08-01 10:00:00 | AAPL | Stock | 0.2739 | 0.2739 | 0.2696 | 0.2696 | 3809624.0 |
| 2002-08-01 10:05:00 | AAPL | Stock | 0.2696 | 0.27 | 0.2684 | 0.2695 | 3080000.0 |
| 2002-08-01 10:10:00 | AAPL | Stock | 0.2695 | 0.27 | 0.2688 | 0.2693 | 2721600.0 |
| 2002-08-01 10:15:00 | AAPL | Stock | 0.2689 | 0.2695 | 0.2677 | 0.2686 | 9010344.0 |
| 2002-08-01 10:20:00 | AAPL | Stock | 0.2689 | 0.2696 | 0.2684 | 0.2686 | 2650256.0 |
| 2002-08-01 10:25:00 | AAPL | Stock | 0.2686 | 0.2688 | 0.2679 | 0.2688 | 2396800.0 |
| 2002-08-01 10:30:00 | AAPL | Stock | 0.2686 | 0.2688 | 0.2677 | 0.268 | 2620016.0 |
| 2002-08-01 10:35:00 | AAPL | Stock | 0.268 | 0.268 | 0.2677 | 0.268 | 2340800.0 |
| 2002-08-01 10:40:00 | AAPL | Stock | 0.2679 | 0.268 | 0.267 | 0.2675 | 6350400.0 |
| 2002-08-01 10:45:00 | AAPL | Stock | 0.2675 | 0.2679 | 0.2668 | 0.267 | 2774800.0 |
| 2002-08-01 10:50:00 | AAPL | Stock | 0.267 | 0.2671 | 0.267 | 0.2671 | 2210488.0 |
| 2002-08-01 10:55:00 | AAPL | Stock | 0.2671 | 0.2677 | 0.267 | 0.2673 | 772800.0 |
| 2002-08-01 11:00:00 | AAPL | Stock | 0.2675 | 0.2679 | 0.267 | 0.2677 | 1068928.0 |
| 2002-08-01 11:05:00 | AAPL | Stock | 0.2675 | 0.2679 | 0.2668 | 0.2671 | 2178344.0 |
| 2002-08-01 11:10:00 | AAPL | Stock | 0.2671 | 0.2673 | 0.2661 | 0.2663 | 3214624.0 |
| 2002-08-01 11:15:00 | AAPL | Stock | 0.2661 | 0.2679 | 0.2661 | 0.2663 | 1800400.0 |
| 2002-08-01 11:20:00 | AAPL | Stock | 0.2663 | 0.2668 | 0.2661 | 0.2661 | 1226400.0 |
| 2002-08-01 11:25:00 | AAPL | Stock | 0.2661 | 0.2663 | 0.2648 | 0.2648 | 2234960.0 |
| 2002-08-01 11:30:00 | AAPL | Stock | 0.2652 | 0.2652 | 0.2648 | 0.2652 | 2777600.0 |
| 2002-08-01 11:35:00 | AAPL | Stock | 0.2652 | 0.2668 | 0.265 | 0.2664 | 2453752.0 |
| 2002-08-01 11:40:00 | AAPL | Stock | 0.2668 | 0.2675 | 0.2661 | 0.2666 | 1618400.0 |
| 2002-08-01 11:45:00 | AAPL | Stock | 0.2666 | 0.2679 | 0.2659 | 0.2659 | 2896880.0 |
| 2002-08-01 11:50:00 | AAPL | Stock | 0.2659 | 0.2664 | 0.2659 | 0.2661 | 2245600.0 |
| 2002-08-01 11:55:00 | AAPL | Stock | 0.2661 | 0.267 | 0.2659 | 0.2666 | 1520400.0 |
| 2002-08-01 12:00:00 | AAPL | Stock | 0.2666 | 0.267 | 0.2661 | 0.2663 | 2968000.0 |
| 2002-08-01 12:05:00 | AAPL | Stock | 0.2664 | 0.267 | 0.2661 | 0.2663 | 1545600.0 |
| 2002-08-01 12:10:00 | AAPL | Stock | 0.2661 | 0.2664 | 0.2661 | 0.2664 | 492800.0 |
| 2002-08-01 12:15:00 | AAPL | Stock | 0.2664 | 0.2668 | 0.2663 | 0.2664 | 386400.0 |
| 2002-08-01 12:20:00 | AAPL | Stock | 0.2664 | 0.2668 | 0.2663 | 0.2663 | 760256.0 |
| 2002-08-01 12:25:00 | AAPL | Stock | 0.2663 | 0.2668 | 0.2661 | 0.2663 | 996128.0 |
| 2002-08-01 12:30:00 | AAPL | Stock | 0.2663 | 0.2666 | 0.2661 | 0.2664 | 1036000.0 |
| 2002-08-01 12:35:00 | AAPL | Stock | 0.2663 | 0.2664 | 0.2661 | 0.2661 | 1166256.0 |
| 2002-08-01 12:40:00 | AAPL | Stock | 0.2661 | 0.2663 | 0.2661 | 0.2663 | 938000.0 |
| 2002-08-01 12:45:00 | AAPL | Stock | 0.2663 | 0.2663 | 0.2659 | 0.2661 | 1349600.0 |
| 2002-08-01 12:50:00 | AAPL | Stock | 0.2661 | 0.2661 | 0.2657 | 0.2657 | 3611664.0 |
| 2002-08-01 12:55:00 | AAPL | Stock | 0.2657 | 0.2664 | 0.2657 | 0.2664 | 4149600.0 |
| 2002-08-01 13:00:00 | AAPL | Stock | 0.2664 | 0.2686 | 0.2661 | 0.268 | 3049200.0 |
| 2002-08-01 13:05:00 | AAPL | Stock | 0.2682 | 0.2696 | 0.268 | 0.2695 | 1590400.0 |
| 2002-08-01 13:10:00 | AAPL | Stock | 0.2695 | 0.2695 | 0.2686 | 0.2686 | 924000.0 |
| 2002-08-01 13:15:00 | AAPL | Stock | 0.2686 | 0.2686 | 0.2679 | 0.2679 | 1125600.0 |
| 2002-08-01 13:20:00 | AAPL | Stock | 0.2675 | 0.2688 | 0.267 | 0.2679 | 1814400.0 |
> showing 50 of 125,825 rows — these rows as CSV