PREVIEW / stock_30min / 2009-09-17
file: by_date/stock_30min/2009/2009-09-17.parquet size: 1.4 MB rows: 72,930 symbols: 3,384
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-09-17 07:00:00 | AAPL | Stock | 6.4968 | 6.5 | 6.4893 | 6.4893 | 25200.0 |
| 2009-09-17 07:30:00 | AAPL | Stock | 6.5089 | 6.51 | 6.4936 | 6.4982 | 57232.0 |
| 2009-09-17 08:00:00 | AAPL | Stock | 6.5 | 6.5261 | 6.4954 | 6.5261 | 1510348.0 |
| 2009-09-17 08:30:00 | AAPL | Stock | 6.525 | 6.5321 | 6.4921 | 6.4921 | 1818992.0 |
| 2009-09-17 09:00:00 | AAPL | Stock | 6.4943 | 6.5071 | 6.4932 | 6.5 | 710444.0 |
| 2009-09-17 09:30:00 | AAPL | Stock | 6.4986 | 6.5786 | 6.4986 | 6.5671 | 113732024.0 |
| 2009-09-17 10:00:00 | AAPL | Stock | 6.5679 | 6.605 | 6.5536 | 6.5775 | 91840252.0 |
| 2009-09-17 10:30:00 | AAPL | Stock | 6.5779 | 6.6239 | 6.5771 | 6.6111 | 66107048.0 |
| 2009-09-17 11:00:00 | AAPL | Stock | 6.6128 | 6.6529 | 6.61 | 6.6504 | 69591592.0 |
| 2009-09-17 11:30:00 | AAPL | Stock | 6.6496 | 6.6711 | 6.6286 | 6.6464 | 91792652.0 |
| 2009-09-17 12:00:00 | AAPL | Stock | 6.6465 | 6.6536 | 6.5982 | 6.6211 | 58875852.0 |
| 2009-09-17 12:30:00 | AAPL | Stock | 6.6207 | 6.6314 | 6.5729 | 6.5743 | 49533652.0 |
| 2009-09-17 13:00:00 | AAPL | Stock | 6.5743 | 6.6071 | 6.5725 | 6.5882 | 42720888.0 |
| 2009-09-17 13:30:00 | AAPL | Stock | 6.5886 | 6.6279 | 6.5861 | 6.6207 | 38376128.0 |
| 2009-09-17 14:00:00 | AAPL | Stock | 6.6207 | 6.6239 | 6.5921 | 6.6011 | 27535060.0 |
| 2009-09-17 14:30:00 | AAPL | Stock | 6.6004 | 6.6243 | 6.6004 | 6.6171 | 32522392.0 |
| 2009-09-17 15:00:00 | AAPL | Stock | 6.6164 | 6.6257 | 6.6079 | 6.6197 | 45762388.0 |
| 2009-09-17 15:30:00 | AAPL | Stock | 6.62 | 6.6207 | 6.5843 | 6.5918 | 61423432.0 |
| 2009-09-17 16:00:00 | AAPL | Stock | 6.5911 | 6.6264 | 6.5843 | 6.5864 | 12397868.0 |
| 2009-09-17 16:30:00 | AAPL | Stock | 6.5911 | 6.5911 | 6.5811 | 6.5893 | 453628.0 |
| 2009-09-17 17:00:00 | AAPL | Stock | 6.5929 | 6.5936 | 6.5825 | 6.5825 | 165256.0 |
| 2009-09-17 17:30:00 | AAPL | Stock | 6.5825 | 6.5864 | 6.5618 | 6.5654 | 206472.0 |
| 2009-09-17 18:00:00 | AAPL | Stock | 6.5654 | 6.5911 | 6.5436 | 6.5593 | 758212.0 |
| 2009-09-17 18:30:00 | AAPL | Stock | 6.5618 | 6.5625 | 6.5507 | 6.5571 | 379764.0 |
| 2009-09-17 19:00:00 | AAPL | Stock | 6.5539 | 6.5589 | 6.5536 | 6.5539 | 172088.0 |
| 2009-09-17 19:30:00 | AAPL | Stock | 6.5539 | 6.5589 | 6.5536 | 6.5557 | 315868.0 |
| 2009-09-17 04:00:00 | MSFT | Stock | 25.43 | 25.43 | 25.43 | 25.43 | 400.0 |
| 2009-09-17 08:00:00 | MSFT | Stock | 25.2 | 25.2 | 25.13 | 25.2 | 8309.0 |
| 2009-09-17 08:30:00 | MSFT | Stock | 25.14 | 25.14 | 25.07 | 25.1 | 28588.0 |
| 2009-09-17 09:00:00 | MSFT | Stock | 25.07 | 25.15 | 25.05 | 25.05 | 26546.0 |
| 2009-09-17 09:30:00 | MSFT | Stock | 25.06 | 25.19 | 25.06 | 25.15 | 3904383.0 |
| 2009-09-17 10:00:00 | MSFT | Stock | 25.15 | 25.18 | 25.065 | 25.083 | 5183166.0 |
| 2009-09-17 10:30:00 | MSFT | Stock | 25.09 | 25.18 | 25.08 | 25.18 | 2273930.0 |
| 2009-09-17 11:00:00 | MSFT | Stock | 25.17 | 25.25 | 25.14 | 25.24 | 2537285.0 |
| 2009-09-17 11:30:00 | MSFT | Stock | 25.24 | 25.27 | 25.15 | 25.19 | 2715482.0 |
| 2009-09-17 12:00:00 | MSFT | Stock | 25.19 | 25.22 | 25.15 | 25.15 | 1962832.0 |
| 2009-09-17 12:30:00 | MSFT | Stock | 25.15 | 25.2 | 25.06 | 25.14 | 2174808.0 |
| 2009-09-17 13:00:00 | MSFT | Stock | 25.13 | 25.21 | 25.12 | 25.16 | 2032557.0 |
| 2009-09-17 13:30:00 | MSFT | Stock | 25.15 | 25.19 | 25.13 | 25.15 | 1887327.0 |
| 2009-09-17 14:00:00 | MSFT | Stock | 25.16 | 25.21 | 25.14 | 25.2 | 1539361.0 |
| 2009-09-17 14:30:00 | MSFT | Stock | 25.2 | 25.27 | 25.17 | 25.25 | 2532244.0 |
| 2009-09-17 15:00:00 | MSFT | Stock | 25.24 | 25.38 | 25.23 | 25.338 | 3614902.0 |
| 2009-09-17 15:30:00 | MSFT | Stock | 25.34 | 25.37 | 25.24 | 25.3 | 5536409.0 |
| 2009-09-17 16:00:00 | MSFT | Stock | 25.29 | 25.32 | 25.186 | 25.3 | 2997974.0 |
| 2009-09-17 16:30:00 | MSFT | Stock | 25.3 | 25.3 | 25.3 | 25.3 | 47890.0 |
| 2009-09-17 17:00:00 | MSFT | Stock | 25.28 | 25.28 | 25.28 | 25.28 | 801.0 |
| 2009-09-17 17:30:00 | MSFT | Stock | 25.28 | 25.28 | 25.28 | 25.28 | 500.0 |
| 2009-09-17 18:00:00 | MSFT | Stock | 25.28 | 25.3 | 25.25 | 25.25 | 13362.0 |
| 2009-09-17 19:00:00 | MSFT | Stock | 25.25 | 25.25 | 25.25 | 25.25 | 1000.0 |
| 2009-09-17 19:30:00 | MSFT | Stock | 25.24 | 25.25 | 25.24 | 25.24 | 1825.0 |
> showing 50 of 72,930 rows — these rows as CSV