PREVIEW / stock_30min / 2009-08-26
file: by_date/stock_30min/2009/2009-08-26.parquet size: 1.3 MB rows: 71,609 symbols: 3,367
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-08-26 04:00:00 | AAPL | Stock | 6.0696 | 6.0696 | 6.0696 | 6.0696 | 2800.0 |
| 2009-08-26 06:30:00 | AAPL | Stock | 6.0536 | 6.0536 | 6.0536 | 6.0536 | 2800.0 |
| 2009-08-26 07:30:00 | AAPL | Stock | 6.0375 | 6.0529 | 6.0346 | 6.0504 | 117460.0 |
| 2009-08-26 08:00:00 | AAPL | Stock | 6.0375 | 6.0514 | 6.0375 | 6.0514 | 170884.0 |
| 2009-08-26 08:30:00 | AAPL | Stock | 6.0464 | 6.0514 | 6.0429 | 6.0482 | 257208.0 |
| 2009-08-26 09:00:00 | AAPL | Stock | 6.0482 | 6.0482 | 6.0332 | 6.0346 | 400204.0 |
| 2009-08-26 09:30:00 | AAPL | Stock | 6.0329 | 6.0554 | 6.0232 | 6.0354 | 32101748.0 |
| 2009-08-26 10:00:00 | AAPL | Stock | 6.0343 | 6.05 | 6.0218 | 6.0348 | 35220304.0 |
| 2009-08-26 10:30:00 | AAPL | Stock | 6.0346 | 6.0446 | 6.0143 | 6.0211 | 20363672.0 |
| 2009-08-26 11:00:00 | AAPL | Stock | 6.0204 | 6.0239 | 5.9675 | 5.9765 | 34268248.0 |
| 2009-08-26 11:30:00 | AAPL | Stock | 5.9771 | 5.9829 | 5.9643 | 5.9668 | 20310836.0 |
| 2009-08-26 12:00:00 | AAPL | Stock | 5.9668 | 5.9814 | 5.9589 | 5.9754 | 16915640.0 |
| 2009-08-26 12:30:00 | AAPL | Stock | 5.9764 | 5.9782 | 5.9664 | 5.9696 | 10348772.0 |
| 2009-08-26 13:00:00 | AAPL | Stock | 5.9696 | 5.9736 | 5.9557 | 5.9668 | 15650096.0 |
| 2009-08-26 13:30:00 | AAPL | Stock | 5.9668 | 5.9946 | 5.9643 | 5.9939 | 13714148.0 |
| 2009-08-26 14:00:00 | AAPL | Stock | 5.9943 | 5.9982 | 5.9868 | 5.9914 | 15751624.0 |
| 2009-08-26 14:30:00 | AAPL | Stock | 5.9907 | 6.0036 | 5.9825 | 5.9857 | 18050732.0 |
| 2009-08-26 15:00:00 | AAPL | Stock | 5.9854 | 5.9889 | 5.9725 | 5.9789 | 19105268.0 |
| 2009-08-26 15:30:00 | AAPL | Stock | 5.9786 | 5.9904 | 5.9704 | 5.9789 | 31626168.0 |
| 2009-08-26 16:00:00 | AAPL | Stock | 5.9793 | 6.0375 | 5.9771 | 5.9839 | 13379100.0 |
| 2009-08-26 16:30:00 | AAPL | Stock | 5.9839 | 5.9929 | 5.9789 | 5.9896 | 414428.0 |
| 2009-08-26 17:00:00 | AAPL | Stock | 5.9824 | 5.9893 | 5.9793 | 5.9793 | 101724.0 |
| 2009-08-26 17:30:00 | AAPL | Stock | 5.9793 | 5.9804 | 5.9793 | 5.9804 | 5600.0 |
| 2009-08-26 18:00:00 | AAPL | Stock | 5.9821 | 5.9821 | 5.9771 | 5.9771 | 231224.0 |
| 2009-08-26 18:30:00 | AAPL | Stock | 5.9771 | 5.9782 | 5.9725 | 5.9725 | 29400.0 |
| 2009-08-26 19:00:00 | AAPL | Stock | 5.9782 | 5.9782 | 5.9714 | 5.9732 | 47600.0 |
| 2009-08-26 19:30:00 | AAPL | Stock | 5.9732 | 5.9789 | 5.9607 | 5.9607 | 390236.0 |
| 2009-08-26 08:00:00 | MSFT | Stock | 24.55 | 24.62 | 24.55 | 24.62 | 800.0 |
| 2009-08-26 08:30:00 | MSFT | Stock | 24.65 | 24.65 | 24.6 | 24.6 | 1003600.0 |
| 2009-08-26 09:00:00 | MSFT | Stock | 24.6 | 24.64 | 24.55 | 24.58 | 7752.0 |
| 2009-08-26 09:30:00 | MSFT | Stock | 24.59 | 24.63 | 24.47 | 24.58 | 5333460.0 |
| 2009-08-26 10:00:00 | MSFT | Stock | 24.58 | 24.75 | 24.57 | 24.6 | 4332329.0 |
| 2009-08-26 10:30:00 | MSFT | Stock | 24.61 | 24.67 | 24.55 | 24.56 | 2815476.0 |
| 2009-08-26 11:00:00 | MSFT | Stock | 24.57 | 24.58 | 24.485 | 24.52 | 3839085.0 |
| 2009-08-26 11:30:00 | MSFT | Stock | 24.52 | 24.54 | 24.47 | 24.5 | 1681747.0 |
| 2009-08-26 12:00:00 | MSFT | Stock | 24.5 | 24.55 | 24.48 | 24.513 | 1322446.0 |
| 2009-08-26 12:30:00 | MSFT | Stock | 24.51 | 24.642 | 24.49 | 24.52 | 1355305.0 |
| 2009-08-26 13:00:00 | MSFT | Stock | 24.51 | 24.53 | 24.48 | 24.5 | 1309389.0 |
| 2009-08-26 13:30:00 | MSFT | Stock | 24.503 | 24.58 | 24.49 | 24.58 | 2078830.0 |
| 2009-08-26 14:00:00 | MSFT | Stock | 24.58 | 24.59 | 24.51 | 24.52 | 1674007.0 |
| 2009-08-26 14:30:00 | MSFT | Stock | 24.511 | 24.58 | 24.42 | 24.44 | 2079249.0 |
| 2009-08-26 15:00:00 | MSFT | Stock | 24.44 | 24.51 | 24.42 | 24.44 | 2511611.0 |
| 2009-08-26 15:30:00 | MSFT | Stock | 24.44 | 24.55 | 24.43 | 24.54 | 5517041.0 |
| 2009-08-26 16:00:00 | MSFT | Stock | 24.55 | 24.55 | 24.4 | 24.51 | 3660590.0 |
| 2009-08-26 16:30:00 | MSFT | Stock | 24.514 | 24.55 | 24.51 | 24.53 | 54855.0 |
| 2009-08-26 17:00:00 | MSFT | Stock | 24.53 | 24.53 | 24.53 | 24.53 | 366.0 |
| 2009-08-26 17:30:00 | MSFT | Stock | 24.51 | 24.51 | 24.49 | 24.5 | 2990.0 |
| 2009-08-26 18:00:00 | MSFT | Stock | 24.47 | 24.55 | 24.46 | 24.46 | 12661.0 |
| 2009-08-26 18:30:00 | MSFT | Stock | 24.46 | 24.48 | 24.45 | 24.48 | 1353.0 |
| 2009-08-26 19:00:00 | MSFT | Stock | 24.45 | 24.47 | 24.45 | 24.47 | 300.0 |
> showing 50 of 71,609 rows — these rows as CSV