PREVIEW / stock_30min / 2009-03-04
file: by_date/stock_30min/2009/2009-03-04.parquet size: 1.2 MB rows: 68,923 symbols: 3,331
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-03-04 05:00:00 | AAPL | Stock | 3.19 | 3.19 | 3.19 | 3.19 | 2800.0 |
| 2009-03-04 07:00:00 | AAPL | Stock | 3.1925 | 3.1925 | 3.1911 | 3.1911 | 16800.0 |
| 2009-03-04 07:30:00 | AAPL | Stock | 3.1982 | 3.2054 | 3.1789 | 3.1789 | 63952.0 |
| 2009-03-04 08:00:00 | AAPL | Stock | 3.1786 | 3.1857 | 3.1707 | 3.1764 | 640836.0 |
| 2009-03-04 08:30:00 | AAPL | Stock | 3.1786 | 3.2086 | 3.1786 | 3.2054 | 1177064.0 |
| 2009-03-04 09:00:00 | AAPL | Stock | 3.2054 | 3.2229 | 3.2036 | 3.215 | 1792448.0 |
| 2009-03-04 09:30:00 | AAPL | Stock | 3.2182 | 3.2329 | 3.1946 | 3.2225 | 84043148.0 |
| 2009-03-04 10:00:00 | AAPL | Stock | 3.2229 | 3.2418 | 3.2086 | 3.2336 | 60581108.0 |
| 2009-03-04 10:30:00 | AAPL | Stock | 3.235 | 3.2607 | 3.2225 | 3.2545 | 53223100.0 |
| 2009-03-04 11:00:00 | AAPL | Stock | 3.2543 | 3.2814 | 3.2539 | 3.2775 | 49590632.0 |
| 2009-03-04 11:30:00 | AAPL | Stock | 3.2771 | 3.2839 | 3.2679 | 3.2773 | 43202824.0 |
| 2009-03-04 12:00:00 | AAPL | Stock | 3.2768 | 3.2811 | 3.2618 | 3.2754 | 36618932.0 |
| 2009-03-04 12:30:00 | AAPL | Stock | 3.2761 | 3.2857 | 3.2579 | 3.26 | 33758592.0 |
| 2009-03-04 13:00:00 | AAPL | Stock | 3.2604 | 3.2743 | 3.2464 | 3.2641 | 36789592.0 |
| 2009-03-04 13:30:00 | AAPL | Stock | 3.2646 | 3.2814 | 3.2611 | 3.2732 | 26559260.0 |
| 2009-03-04 14:00:00 | AAPL | Stock | 3.2732 | 3.2979 | 3.27 | 3.2748 | 54731404.0 |
| 2009-03-04 14:30:00 | AAPL | Stock | 3.2757 | 3.3036 | 3.2686 | 3.3004 | 51855804.0 |
| 2009-03-04 15:00:00 | AAPL | Stock | 3.3011 | 3.3125 | 3.2911 | 3.3104 | 61800872.0 |
| 2009-03-04 15:30:00 | AAPL | Stock | 3.3089 | 3.3132 | 3.2568 | 3.2636 | 118500060.0 |
| 2009-03-04 16:00:00 | AAPL | Stock | 3.2589 | 3.2964 | 3.2143 | 3.2539 | 23576112.0 |
| 2009-03-04 16:30:00 | AAPL | Stock | 3.2561 | 3.2618 | 3.2536 | 3.2543 | 294868.0 |
| 2009-03-04 17:00:00 | AAPL | Stock | 3.26 | 3.2607 | 3.2518 | 3.2607 | 355040.0 |
| 2009-03-04 17:30:00 | AAPL | Stock | 3.2571 | 3.2675 | 3.2571 | 3.2629 | 203868.0 |
| 2009-03-04 18:00:00 | AAPL | Stock | 3.2646 | 3.2657 | 3.2561 | 3.2636 | 431088.0 |
| 2009-03-04 18:30:00 | AAPL | Stock | 3.2679 | 3.2679 | 3.2671 | 3.2671 | 14000.0 |
| 2009-03-04 19:00:00 | AAPL | Stock | 3.2661 | 3.2704 | 3.2661 | 3.2704 | 19516.0 |
| 2009-03-04 19:30:00 | AAPL | Stock | 3.2704 | 3.2732 | 3.2679 | 3.2679 | 66304.0 |
| 2009-03-04 07:00:00 | MSFT | Stock | 15.97 | 15.97 | 15.97 | 15.97 | 500.0 |
| 2009-03-04 07:30:00 | MSFT | Stock | 16.02 | 16.02 | 15.97 | 15.97 | 900.0 |
| 2009-03-04 08:00:00 | MSFT | Stock | 15.88 | 16.01 | 15.88 | 15.95 | 767616.0 |
| 2009-03-04 08:30:00 | MSFT | Stock | 15.99 | 16.08 | 15.99 | 16.08 | 16062.0 |
| 2009-03-04 09:00:00 | MSFT | Stock | 16.09 | 16.18 | 16.06 | 16.11 | 235358.0 |
| 2009-03-04 09:30:00 | MSFT | Stock | 16.12 | 16.24 | 15.97 | 16.03 | 6972825.0 |
| 2009-03-04 10:00:00 | MSFT | Stock | 16.03 | 16.05 | 15.89 | 15.97 | 5370992.0 |
| 2009-03-04 10:30:00 | MSFT | Stock | 15.98 | 16.19 | 15.975 | 16.145 | 4620508.0 |
| 2009-03-04 11:00:00 | MSFT | Stock | 16.16 | 16.36 | 16.145 | 16.3 | 4629457.0 |
| 2009-03-04 11:30:00 | MSFT | Stock | 16.31 | 16.36 | 15.98 | 16.32 | 4200740.0 |
| 2009-03-04 12:00:00 | MSFT | Stock | 16.32 | 16.36 | 16.17 | 16.242 | 4167635.0 |
| 2009-03-04 12:30:00 | MSFT | Stock | 16.23 | 16.26 | 16.11 | 16.178 | 2454828.0 |
| 2009-03-04 13:00:00 | MSFT | Stock | 16.18 | 16.25 | 16.09 | 16.2 | 2016512.0 |
| 2009-03-04 13:30:00 | MSFT | Stock | 16.2 | 16.281 | 16.16 | 16.19 | 3728522.0 |
| 2009-03-04 14:00:00 | MSFT | Stock | 16.19 | 16.34 | 16.16 | 16.2 | 3523255.0 |
| 2009-03-04 14:30:00 | MSFT | Stock | 16.208 | 16.35 | 16.17 | 16.335 | 4353289.0 |
| 2009-03-04 15:00:00 | MSFT | Stock | 16.33 | 16.4 | 16.242 | 16.39 | 4646592.0 |
| 2009-03-04 15:30:00 | MSFT | Stock | 16.39 | 16.4 | 16.07 | 16.12 | 11008542.0 |
| 2009-03-04 16:00:00 | MSFT | Stock | 16.12 | 16.32 | 16.07 | 16.12 | 4262402.0 |
| 2009-03-04 16:30:00 | MSFT | Stock | 16.12 | 16.188 | 16.11 | 16.13 | 59702.0 |
| 2009-03-04 17:00:00 | MSFT | Stock | 16.12 | 16.13 | 16.12 | 16.12 | 1300.0 |
| 2009-03-04 17:30:00 | MSFT | Stock | 16.13 | 16.19 | 16.13 | 16.19 | 3279.0 |
| 2009-03-04 18:00:00 | MSFT | Stock | 16.12 | 16.12 | 16.11 | 16.11 | 439372.0 |
> showing 50 of 68,923 rows — these rows as CSV