PREVIEW / stock_30min / 2009-10-13
file: by_date/stock_30min/2009/2009-10-13.parquet size: 1.3 MB rows: 71,924 symbols: 3,400
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-10-13 05:30:00 | AAPL | Stock | 6.7946 | 6.7946 | 6.7946 | 6.7946 | 5600.0 |
| 2009-10-13 06:30:00 | AAPL | Stock | 6.8036 | 6.8218 | 6.8036 | 6.8214 | 36820.0 |
| 2009-10-13 07:00:00 | AAPL | Stock | 6.8214 | 6.8325 | 6.8214 | 6.8321 | 61656.0 |
| 2009-10-13 07:30:00 | AAPL | Stock | 6.8325 | 6.8511 | 6.8321 | 6.8321 | 58800.0 |
| 2009-10-13 08:00:00 | AAPL | Stock | 6.8218 | 6.8293 | 6.8079 | 6.8093 | 281120.0 |
| 2009-10-13 08:30:00 | AAPL | Stock | 6.815 | 6.8214 | 6.8107 | 6.8107 | 115584.0 |
| 2009-10-13 09:00:00 | AAPL | Stock | 6.8093 | 6.8093 | 6.7968 | 6.8086 | 270144.0 |
| 2009-10-13 09:30:00 | AAPL | Stock | 6.8068 | 6.8275 | 6.7804 | 6.805 | 42971740.0 |
| 2009-10-13 10:00:00 | AAPL | Stock | 6.8054 | 6.8118 | 6.7771 | 6.7957 | 35649936.0 |
| 2009-10-13 10:30:00 | AAPL | Stock | 6.7946 | 6.8039 | 6.7875 | 6.7875 | 18104968.0 |
| 2009-10-13 11:00:00 | AAPL | Stock | 6.7875 | 6.7982 | 6.7807 | 6.795 | 17031672.0 |
| 2009-10-13 11:30:00 | AAPL | Stock | 6.7954 | 6.8146 | 6.7914 | 6.805 | 18314016.0 |
| 2009-10-13 12:00:00 | AAPL | Stock | 6.8044 | 6.8111 | 6.7961 | 6.7979 | 11343836.0 |
| 2009-10-13 12:30:00 | AAPL | Stock | 6.7982 | 6.7993 | 6.7879 | 6.7956 | 9489256.0 |
| 2009-10-13 13:00:00 | AAPL | Stock | 6.7957 | 6.7986 | 6.7871 | 6.7879 | 8648612.0 |
| 2009-10-13 13:30:00 | AAPL | Stock | 6.7871 | 6.79 | 6.7764 | 6.7854 | 15865892.0 |
| 2009-10-13 14:00:00 | AAPL | Stock | 6.785 | 6.7907 | 6.775 | 6.785 | 19133940.0 |
| 2009-10-13 14:30:00 | AAPL | Stock | 6.7857 | 6.7946 | 6.7825 | 6.7878 | 15434860.0 |
| 2009-10-13 15:00:00 | AAPL | Stock | 6.7871 | 6.8032 | 6.7804 | 6.7975 | 20940276.0 |
| 2009-10-13 15:30:00 | AAPL | Stock | 6.7982 | 6.8004 | 6.7814 | 6.7854 | 33974612.0 |
| 2009-10-13 16:00:00 | AAPL | Stock | 6.7854 | 6.8468 | 6.7821 | 6.8271 | 15924832.0 |
| 2009-10-13 16:30:00 | AAPL | Stock | 6.83 | 6.8464 | 6.7864 | 6.8264 | 2155216.0 |
| 2009-10-13 17:00:00 | AAPL | Stock | 6.8271 | 6.8414 | 6.8214 | 6.8357 | 833532.0 |
| 2009-10-13 17:30:00 | AAPL | Stock | 6.84 | 6.8511 | 6.84 | 6.85 | 753872.0 |
| 2009-10-13 18:00:00 | AAPL | Stock | 6.85 | 6.8554 | 6.7864 | 6.8518 | 840196.0 |
| 2009-10-13 18:30:00 | AAPL | Stock | 6.8536 | 6.8536 | 6.845 | 6.8482 | 186088.0 |
| 2009-10-13 19:00:00 | AAPL | Stock | 6.845 | 6.8479 | 6.8393 | 6.8393 | 319956.0 |
| 2009-10-13 19:30:00 | AAPL | Stock | 6.8375 | 6.8536 | 6.8375 | 6.8464 | 350532.0 |
| 2009-10-13 07:00:00 | MSFT | Stock | 25.77 | 25.77 | 25.77 | 25.77 | 100.0 |
| 2009-10-13 08:00:00 | MSFT | Stock | 25.72 | 25.78 | 25.72 | 25.78 | 1600.0 |
| 2009-10-13 08:30:00 | MSFT | Stock | 25.71 | 25.71 | 25.7 | 25.7 | 1300.0 |
| 2009-10-13 09:00:00 | MSFT | Stock | 25.6 | 25.63 | 25.54 | 25.59 | 27500.0 |
| 2009-10-13 09:30:00 | MSFT | Stock | 25.59 | 25.76 | 25.56 | 25.6 | 3599493.0 |
| 2009-10-13 10:00:00 | MSFT | Stock | 25.603 | 25.61 | 25.52 | 25.6 | 2541078.0 |
| 2009-10-13 10:30:00 | MSFT | Stock | 25.598 | 25.61 | 25.56 | 25.59 | 1482611.0 |
| 2009-10-13 11:00:00 | MSFT | Stock | 25.58 | 25.72 | 25.57 | 25.72 | 1344363.0 |
| 2009-10-13 11:30:00 | MSFT | Stock | 25.714 | 25.94 | 25.71 | 25.92 | 2968678.0 |
| 2009-10-13 12:00:00 | MSFT | Stock | 25.93 | 25.93 | 25.8 | 25.801 | 2138772.0 |
| 2009-10-13 12:30:00 | MSFT | Stock | 25.8 | 25.88 | 25.8 | 25.851 | 1830619.0 |
| 2009-10-13 13:00:00 | MSFT | Stock | 25.86 | 25.89 | 25.83 | 25.88 | 1526850.0 |
| 2009-10-13 13:30:00 | MSFT | Stock | 25.88 | 25.92 | 25.86 | 25.9 | 1835155.0 |
| 2009-10-13 14:00:00 | MSFT | Stock | 25.89 | 25.89 | 25.75 | 25.82 | 2027013.0 |
| 2009-10-13 14:30:00 | MSFT | Stock | 25.83 | 25.85 | 25.79 | 25.82 | 1503367.0 |
| 2009-10-13 15:00:00 | MSFT | Stock | 25.82 | 25.89 | 25.8 | 25.851 | 1909137.0 |
| 2009-10-13 15:30:00 | MSFT | Stock | 25.85 | 25.88 | 25.77 | 25.82 | 5714344.0 |
| 2009-10-13 16:00:00 | MSFT | Stock | 25.82 | 26.1 | 25.65 | 26.0 | 5175476.0 |
| 2009-10-13 16:30:00 | MSFT | Stock | 26.0 | 26.17 | 25.81 | 26.12 | 161432.0 |
| 2009-10-13 17:00:00 | MSFT | Stock | 26.14 | 26.17 | 25.839 | 26.14 | 53259.0 |
| 2009-10-13 17:30:00 | MSFT | Stock | 26.14 | 26.16 | 26.11 | 26.14 | 11576.0 |
| 2009-10-13 18:00:00 | MSFT | Stock | 26.14 | 26.15 | 26.12 | 26.12 | 4035.0 |
> showing 50 of 71,924 rows — these rows as CSV