PREVIEW / stock_1min / 2009-07-17
file: by_date/stock_1min/2009/2009-07-17.parquet size: 11.8 MB rows: 912,201 symbols: 2,712
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-17 05:09:00 | AAPL | Stock | 5.2686 | 5.2686 | 5.2686 | 5.2686 | 2800.0 |
| 2009-07-17 06:31:00 | AAPL | Stock | 5.2664 | 5.2664 | 5.2664 | 5.2664 | 5600.0 |
| 2009-07-17 07:00:00 | AAPL | Stock | 5.2575 | 5.2575 | 5.2575 | 5.2575 | 2800.0 |
| 2009-07-17 07:05:00 | AAPL | Stock | 5.2629 | 5.2714 | 5.2629 | 5.2714 | 16800.0 |
| 2009-07-17 07:06:00 | AAPL | Stock | 5.2629 | 5.2629 | 5.2625 | 5.2625 | 5600.0 |
| 2009-07-17 07:09:00 | AAPL | Stock | 5.2539 | 5.2539 | 5.2539 | 5.2539 | 12040.0 |
| 2009-07-17 07:14:00 | AAPL | Stock | 5.2571 | 5.2571 | 5.2571 | 5.2571 | 19600.0 |
| 2009-07-17 07:15:00 | AAPL | Stock | 5.2571 | 5.2571 | 5.2571 | 5.2571 | 3192.0 |
| 2009-07-17 07:17:00 | AAPL | Stock | 5.2579 | 5.2579 | 5.2579 | 5.2579 | 14000.0 |
| 2009-07-17 07:29:00 | AAPL | Stock | 5.2571 | 5.2571 | 5.2571 | 5.2571 | 9464.0 |
| 2009-07-17 07:37:00 | AAPL | Stock | 5.2536 | 5.2536 | 5.2536 | 5.2536 | 10136.0 |
| 2009-07-17 07:42:00 | AAPL | Stock | 5.2536 | 5.2589 | 5.2504 | 5.2589 | 84000.0 |
| 2009-07-17 07:44:00 | AAPL | Stock | 5.2589 | 5.2589 | 5.2589 | 5.2589 | 28000.0 |
| 2009-07-17 07:46:00 | AAPL | Stock | 5.2507 | 5.2507 | 5.2507 | 5.2507 | 2800.0 |
| 2009-07-17 07:48:00 | AAPL | Stock | 5.2536 | 5.2536 | 5.2536 | 5.2536 | 2800.0 |
| 2009-07-17 07:59:00 | AAPL | Stock | 5.2518 | 5.2529 | 5.2518 | 5.2525 | 19544.0 |
| 2009-07-17 08:00:00 | AAPL | Stock | 5.2571 | 5.2607 | 5.2511 | 5.2607 | 61600.0 |
| 2009-07-17 08:01:00 | AAPL | Stock | 5.2679 | 5.2679 | 5.2679 | 5.2679 | 2800.0 |
| 2009-07-17 08:02:00 | AAPL | Stock | 5.2664 | 5.2754 | 5.2657 | 5.2668 | 16800.0 |
| 2009-07-17 08:04:00 | AAPL | Stock | 5.2611 | 5.2611 | 5.2611 | 5.2611 | 11200.0 |
| 2009-07-17 08:05:00 | AAPL | Stock | 5.2621 | 5.2621 | 5.2611 | 5.2611 | 8400.0 |
| 2009-07-17 08:06:00 | AAPL | Stock | 5.2621 | 5.2621 | 5.2621 | 5.2621 | 2800.0 |
| 2009-07-17 08:08:00 | AAPL | Stock | 5.2643 | 5.2643 | 5.2643 | 5.2643 | 8400.0 |
| 2009-07-17 08:09:00 | AAPL | Stock | 5.2664 | 5.2664 | 5.2664 | 5.2664 | 2800.0 |
| 2009-07-17 08:10:00 | AAPL | Stock | 5.2664 | 5.2679 | 5.2664 | 5.2679 | 42000.0 |
| 2009-07-17 08:11:00 | AAPL | Stock | 5.2686 | 5.2686 | 5.2686 | 5.2686 | 14000.0 |
| 2009-07-17 08:12:00 | AAPL | Stock | 5.2707 | 5.275 | 5.2707 | 5.275 | 30800.0 |
| 2009-07-17 08:13:00 | AAPL | Stock | 5.2754 | 5.2754 | 5.2732 | 5.2732 | 83020.0 |
| 2009-07-17 08:14:00 | AAPL | Stock | 5.2754 | 5.2754 | 5.2754 | 5.2754 | 2800.0 |
| 2009-07-17 08:15:00 | AAPL | Stock | 5.2782 | 5.2786 | 5.2782 | 5.2786 | 22400.0 |
| 2009-07-17 08:16:00 | AAPL | Stock | 5.2786 | 5.2804 | 5.2786 | 5.2804 | 12600.0 |
| 2009-07-17 08:17:00 | AAPL | Stock | 5.2761 | 5.2761 | 5.2757 | 5.2757 | 16800.0 |
| 2009-07-17 08:18:00 | AAPL | Stock | 5.2754 | 5.2754 | 5.2754 | 5.2754 | 12180.0 |
| 2009-07-17 08:19:00 | AAPL | Stock | 5.2779 | 5.2779 | 5.2779 | 5.2779 | 2800.0 |
| 2009-07-17 08:21:00 | AAPL | Stock | 5.275 | 5.275 | 5.2732 | 5.2732 | 52864.0 |
| 2009-07-17 08:25:00 | AAPL | Stock | 5.2696 | 5.2696 | 5.2696 | 5.2696 | 18200.0 |
| 2009-07-17 08:28:00 | AAPL | Stock | 5.2746 | 5.2746 | 5.2746 | 5.2746 | 2800.0 |
| 2009-07-17 08:29:00 | AAPL | Stock | 5.2704 | 5.2704 | 5.27 | 5.27 | 11200.0 |
| 2009-07-17 08:30:00 | AAPL | Stock | 5.2743 | 5.2743 | 5.2743 | 5.2743 | 4452.0 |
| 2009-07-17 08:32:00 | AAPL | Stock | 5.2736 | 5.275 | 5.2736 | 5.275 | 79380.0 |
| 2009-07-17 08:35:00 | AAPL | Stock | 5.2757 | 5.2796 | 5.2754 | 5.2796 | 90496.0 |
| 2009-07-17 08:36:00 | AAPL | Stock | 5.2782 | 5.2796 | 5.2782 | 5.2796 | 28448.0 |
| 2009-07-17 08:37:00 | AAPL | Stock | 5.2818 | 5.2821 | 5.2804 | 5.2821 | 50568.0 |
| 2009-07-17 08:38:00 | AAPL | Stock | 5.2796 | 5.2796 | 5.2789 | 5.2796 | 28252.0 |
| 2009-07-17 08:39:00 | AAPL | Stock | 5.2821 | 5.2893 | 5.2821 | 5.2893 | 67200.0 |
| 2009-07-17 08:40:00 | AAPL | Stock | 5.2918 | 5.2921 | 5.2918 | 5.2918 | 19600.0 |
| 2009-07-17 08:41:00 | AAPL | Stock | 5.2921 | 5.2929 | 5.2921 | 5.2929 | 54600.0 |
| 2009-07-17 08:43:00 | AAPL | Stock | 5.2896 | 5.2896 | 5.2896 | 5.2896 | 11564.0 |
| 2009-07-17 08:44:00 | AAPL | Stock | 5.2929 | 5.2936 | 5.2929 | 5.2936 | 5600.0 |
| 2009-07-17 08:45:00 | AAPL | Stock | 5.2936 | 5.2936 | 5.2936 | 5.2936 | 2800.0 |
> showing 50 of 912,201 rows — these rows as CSV