PREVIEW / stock_30min / 2008-08-04
file: by_date/stock_30min/2008/2008-08-04.parquet size: 1.2 MB rows: 67,865 symbols: 3,299
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 |
|---|---|---|---|---|---|---|---|
| 2008-08-04 04:00:00 | AAPL | Stock | 5.6096 | 5.6096 | 5.6096 | 5.6096 | 8400.0 |
| 2008-08-04 07:00:00 | AAPL | Stock | 5.5893 | 5.5893 | 5.5893 | 5.5893 | 5600.0 |
| 2008-08-04 07:30:00 | AAPL | Stock | 5.5564 | 5.5564 | 5.5564 | 5.5564 | 2800.0 |
| 2008-08-04 08:00:00 | AAPL | Stock | 5.5714 | 5.5832 | 5.5675 | 5.5764 | 517188.0 |
| 2008-08-04 08:30:00 | AAPL | Stock | 5.5729 | 5.5768 | 5.5661 | 5.5725 | 143332.0 |
| 2008-08-04 09:00:00 | AAPL | Stock | 5.575 | 5.59 | 5.575 | 5.5893 | 397040.0 |
| 2008-08-04 09:30:00 | AAPL | Stock | 5.5929 | 5.6393 | 5.5539 | 5.6111 | 76298936.0 |
| 2008-08-04 10:00:00 | AAPL | Stock | 5.6111 | 5.6261 | 5.5746 | 5.5921 | 52078880.0 |
| 2008-08-04 10:30:00 | AAPL | Stock | 5.5929 | 5.6104 | 5.5625 | 5.58 | 39015592.0 |
| 2008-08-04 11:00:00 | AAPL | Stock | 5.5789 | 5.5971 | 5.5682 | 5.5775 | 30116548.0 |
| 2008-08-04 11:30:00 | AAPL | Stock | 5.5775 | 5.6268 | 5.5757 | 5.6104 | 46404372.0 |
| 2008-08-04 12:00:00 | AAPL | Stock | 5.6086 | 5.6268 | 5.5971 | 5.6161 | 23648268.0 |
| 2008-08-04 12:30:00 | AAPL | Stock | 5.615 | 5.625 | 5.5964 | 5.6046 | 18626552.0 |
| 2008-08-04 13:00:00 | AAPL | Stock | 5.6043 | 5.6186 | 5.59 | 5.59 | 26442136.0 |
| 2008-08-04 13:30:00 | AAPL | Stock | 5.59 | 5.5975 | 5.575 | 5.5904 | 20376608.0 |
| 2008-08-04 14:00:00 | AAPL | Stock | 5.59 | 5.5939 | 5.565 | 5.5782 | 31863524.0 |
| 2008-08-04 14:30:00 | AAPL | Stock | 5.5781 | 5.5821 | 5.5196 | 5.5239 | 47709928.0 |
| 2008-08-04 15:00:00 | AAPL | Stock | 5.5239 | 5.535 | 5.4675 | 5.4736 | 75681508.0 |
| 2008-08-04 15:30:00 | AAPL | Stock | 5.4739 | 5.5125 | 5.4611 | 5.4746 | 83012216.0 |
| 2008-08-04 16:00:00 | AAPL | Stock | 5.4743 | 5.5651 | 5.4725 | 5.4821 | 7570024.0 |
| 2008-08-04 16:30:00 | AAPL | Stock | 5.4814 | 5.5608 | 5.4725 | 5.4746 | 2404360.0 |
| 2008-08-04 17:00:00 | AAPL | Stock | 5.4764 | 5.4804 | 5.475 | 5.4786 | 174636.0 |
| 2008-08-04 17:30:00 | AAPL | Stock | 5.4821 | 5.4821 | 5.4725 | 5.4725 | 1652476.0 |
| 2008-08-04 18:00:00 | AAPL | Stock | 5.4786 | 5.4786 | 5.4775 | 5.4775 | 43176.0 |
| 2008-08-04 18:30:00 | AAPL | Stock | 5.4761 | 5.4771 | 5.4746 | 5.4746 | 26712.0 |
| 2008-08-04 19:00:00 | AAPL | Stock | 5.4768 | 5.4857 | 5.4768 | 5.4854 | 108780.0 |
| 2008-08-04 19:30:00 | AAPL | Stock | 5.4854 | 5.4946 | 5.4825 | 5.4893 | 60340.0 |
| 2008-08-04 08:00:00 | MSFT | Stock | 25.5 | 25.5 | 25.43 | 25.43 | 700.0 |
| 2008-08-04 08:30:00 | MSFT | Stock | 25.45 | 25.45 | 25.43 | 25.43 | 3145.0 |
| 2008-08-04 09:00:00 | MSFT | Stock | 25.43 | 25.43 | 25.35 | 25.36 | 16825.0 |
| 2008-08-04 09:30:00 | MSFT | Stock | 25.38 | 25.5 | 25.12 | 25.16 | 6155926.0 |
| 2008-08-04 10:00:00 | MSFT | Stock | 25.16 | 25.28 | 25.11 | 25.23 | 7719868.0 |
| 2008-08-04 10:30:00 | MSFT | Stock | 25.23 | 25.25 | 25.172 | 25.25 | 3205766.0 |
| 2008-08-04 11:00:00 | MSFT | Stock | 25.24 | 25.25 | 25.21 | 25.23 | 2723969.0 |
| 2008-08-04 11:30:00 | MSFT | Stock | 25.235 | 25.545 | 25.23 | 25.33 | 5210235.0 |
| 2008-08-04 12:00:00 | MSFT | Stock | 25.33 | 25.36 | 25.21 | 25.29 | 3955798.0 |
| 2008-08-04 12:30:00 | MSFT | Stock | 25.29 | 25.33 | 25.22 | 25.249 | 1936929.0 |
| 2008-08-04 13:00:00 | MSFT | Stock | 25.242 | 25.38 | 25.22 | 25.27 | 3119123.0 |
| 2008-08-04 13:30:00 | MSFT | Stock | 25.27 | 25.36 | 25.26 | 25.3 | 2276625.0 |
| 2008-08-04 14:00:00 | MSFT | Stock | 25.3 | 25.35 | 25.26 | 25.33 | 2258775.0 |
| 2008-08-04 14:30:00 | MSFT | Stock | 25.33 | 25.47 | 25.31 | 25.399 | 3521178.0 |
| 2008-08-04 15:00:00 | MSFT | Stock | 25.39 | 25.44 | 25.3 | 25.33 | 3767342.0 |
| 2008-08-04 15:30:00 | MSFT | Stock | 25.33 | 25.36 | 25.2 | 25.24 | 8503933.0 |
| 2008-08-04 16:00:00 | MSFT | Stock | 25.25 | 25.31 | 25.2 | 25.2 | 5027519.0 |
| 2008-08-04 16:30:00 | MSFT | Stock | 25.28 | 25.28 | 25.22 | 25.22 | 446059.0 |
| 2008-08-04 17:30:00 | MSFT | Stock | 25.22 | 25.3 | 25.22 | 25.28 | 182182.0 |
| 2008-08-04 18:00:00 | MSFT | Stock | 25.3 | 25.3 | 25.3 | 25.3 | 400.0 |
| 2008-08-04 18:30:00 | MSFT | Stock | 25.28 | 25.28 | 25.28 | 25.28 | 450.0 |
| 2008-08-04 19:00:00 | MSFT | Stock | 25.28 | 25.28 | 25.28 | 25.28 | 550.0 |
| 2008-08-04 19:30:00 | MSFT | Stock | 25.29 | 25.3 | 25.28 | 25.3 | 3675.0 |
> showing 50 of 67,865 rows — these rows as CSV