PREVIEW / stock_30min / 2009-11-11
file: by_date/stock_30min/2009/2009-11-11.parquet size: 1.4 MB rows: 73,521 symbols: 3,402
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-11 04:00:00 | AAPL | Stock | 7.2632 | 7.2686 | 7.2632 | 7.2686 | 8400.0 |
| 2009-11-11 06:00:00 | AAPL | Stock | 7.2857 | 7.2857 | 7.2857 | 7.2857 | 2800.0 |
| 2009-11-11 06:30:00 | AAPL | Stock | 7.2839 | 7.2857 | 7.2839 | 7.2857 | 6720.0 |
| 2009-11-11 07:00:00 | AAPL | Stock | 7.3054 | 7.3071 | 7.2911 | 7.3 | 118748.0 |
| 2009-11-11 07:30:00 | AAPL | Stock | 7.2996 | 7.3107 | 7.2929 | 7.3107 | 202944.0 |
| 2009-11-11 08:00:00 | AAPL | Stock | 7.3061 | 7.3157 | 7.3011 | 7.3054 | 2144380.0 |
| 2009-11-11 08:30:00 | AAPL | Stock | 7.3071 | 7.3125 | 7.3 | 7.3107 | 1095724.0 |
| 2009-11-11 09:00:00 | AAPL | Stock | 7.3093 | 7.3143 | 7.3004 | 7.3079 | 963116.0 |
| 2009-11-11 09:30:00 | AAPL | Stock | 7.3082 | 7.3214 | 7.275 | 7.3025 | 90879236.0 |
| 2009-11-11 10:00:00 | AAPL | Stock | 7.3025 | 7.3168 | 7.275 | 7.3025 | 52390464.0 |
| 2009-11-11 10:30:00 | AAPL | Stock | 7.3025 | 7.3132 | 7.2829 | 7.2878 | 39138372.0 |
| 2009-11-11 11:00:00 | AAPL | Stock | 7.2868 | 7.2892 | 7.2554 | 7.2857 | 45096072.0 |
| 2009-11-11 11:30:00 | AAPL | Stock | 7.2857 | 7.2975 | 7.2696 | 7.2718 | 22259524.0 |
| 2009-11-11 12:00:00 | AAPL | Stock | 7.2725 | 7.2911 | 7.2704 | 7.2911 | 10747548.0 |
| 2009-11-11 12:30:00 | AAPL | Stock | 7.2893 | 7.2946 | 7.2554 | 7.2554 | 20374788.0 |
| 2009-11-11 13:00:00 | AAPL | Stock | 7.2554 | 7.2771 | 7.2525 | 7.2543 | 14898492.0 |
| 2009-11-11 13:30:00 | AAPL | Stock | 7.2539 | 7.2581 | 7.2082 | 7.2275 | 39309788.0 |
| 2009-11-11 14:00:00 | AAPL | Stock | 7.2275 | 7.2554 | 7.2237 | 7.25 | 24175060.0 |
| 2009-11-11 14:30:00 | AAPL | Stock | 7.2501 | 7.2757 | 7.2464 | 7.2632 | 19389664.0 |
| 2009-11-11 15:00:00 | AAPL | Stock | 7.2629 | 7.2704 | 7.245 | 7.2625 | 17824716.0 |
| 2009-11-11 15:30:00 | AAPL | Stock | 7.2632 | 7.2679 | 7.2471 | 7.2593 | 31388168.0 |
| 2009-11-11 16:00:00 | AAPL | Stock | 7.2589 | 7.2824 | 7.2494 | 7.2714 | 4740288.0 |
| 2009-11-11 16:30:00 | AAPL | Stock | 7.2725 | 7.2732 | 7.2589 | 7.2589 | 237216.0 |
| 2009-11-11 17:00:00 | AAPL | Stock | 7.2621 | 7.2636 | 7.2589 | 7.2625 | 292964.0 |
| 2009-11-11 17:30:00 | AAPL | Stock | 7.2639 | 7.2661 | 7.2629 | 7.2629 | 22400.0 |
| 2009-11-11 18:00:00 | AAPL | Stock | 7.2621 | 7.2664 | 7.2589 | 7.2664 | 73444.0 |
| 2009-11-11 18:30:00 | AAPL | Stock | 7.2625 | 7.2693 | 7.2625 | 7.2693 | 35000.0 |
| 2009-11-11 19:00:00 | AAPL | Stock | 7.2664 | 7.2664 | 7.2629 | 7.2629 | 23800.0 |
| 2009-11-11 19:30:00 | AAPL | Stock | 7.2636 | 7.2704 | 7.2636 | 7.2696 | 117432.0 |
| 2009-11-11 04:30:00 | MSFT | Stock | 29.14 | 29.14 | 29.14 | 29.14 | 700.0 |
| 2009-11-11 06:00:00 | MSFT | Stock | 29.18 | 29.18 | 29.18 | 29.18 | 300.0 |
| 2009-11-11 07:00:00 | MSFT | Stock | 29.11 | 29.11 | 29.11 | 29.11 | 150.0 |
| 2009-11-11 07:30:00 | MSFT | Stock | 29.14 | 29.15 | 29.14 | 29.15 | 700.0 |
| 2009-11-11 08:00:00 | MSFT | Stock | 29.15 | 29.24 | 28.955 | 29.1 | 14765.0 |
| 2009-11-11 08:30:00 | MSFT | Stock | 29.12 | 29.16 | 29.06 | 29.08 | 20625.0 |
| 2009-11-11 09:00:00 | MSFT | Stock | 29.1 | 29.13 | 29.05 | 29.07 | 32244.0 |
| 2009-11-11 09:30:00 | MSFT | Stock | 29.08 | 29.26 | 29.02 | 29.255 | 6469276.0 |
| 2009-11-11 10:00:00 | MSFT | Stock | 29.26 | 29.3 | 29.17 | 29.19 | 7139687.0 |
| 2009-11-11 10:30:00 | MSFT | Stock | 29.19 | 29.215 | 29.05 | 29.12 | 5711646.0 |
| 2009-11-11 11:00:00 | MSFT | Stock | 29.12 | 29.27 | 29.09 | 29.2 | 4747891.0 |
| 2009-11-11 11:30:00 | MSFT | Stock | 29.205 | 29.21 | 29.11 | 29.13 | 2180860.0 |
| 2009-11-11 12:00:00 | MSFT | Stock | 29.13 | 29.2 | 29.122 | 29.2 | 1555824.0 |
| 2009-11-11 12:30:00 | MSFT | Stock | 29.2 | 29.25 | 29.18 | 29.2 | 2625546.0 |
| 2009-11-11 13:00:00 | MSFT | Stock | 29.2 | 29.23 | 29.13 | 29.13 | 2286186.0 |
| 2009-11-11 13:30:00 | MSFT | Stock | 29.14 | 29.16 | 29.12 | 29.134 | 1604579.0 |
| 2009-11-11 14:00:00 | MSFT | Stock | 29.14 | 29.19 | 29.12 | 29.13 | 2261021.0 |
| 2009-11-11 14:30:00 | MSFT | Stock | 29.133 | 29.17 | 29.06 | 29.07 | 2028089.0 |
| 2009-11-11 15:00:00 | MSFT | Stock | 29.072 | 29.12 | 29.03 | 29.103 | 3670938.0 |
| 2009-11-11 15:30:00 | MSFT | Stock | 29.1 | 29.15 | 29.06 | 29.13 | 4696555.0 |
| 2009-11-11 16:00:00 | MSFT | Stock | 29.13 | 29.197 | 29.101 | 29.16 | 1149009.0 |
> showing 50 of 73,521 rows — these rows as CSV