PREVIEW / stock_30min / 2007-10-08
file: by_date/stock_30min/2007/2007-10-08.parquet size: 1.1 MB rows: 65,453 symbols: 3,102
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 |
|---|---|---|---|---|---|---|---|
| 2007-10-08 05:30:00 | AAPL | Stock | 5.8014 | 5.8014 | 5.7875 | 5.7875 | 81200.0 |
| 2007-10-08 07:00:00 | AAPL | Stock | 5.7796 | 5.8214 | 5.7782 | 5.7982 | 142800.0 |
| 2007-10-08 07:30:00 | AAPL | Stock | 5.7982 | 5.8114 | 5.7982 | 5.8036 | 131600.0 |
| 2007-10-08 08:00:00 | AAPL | Stock | 5.8 | 5.8518 | 5.7982 | 5.8446 | 4312364.0 |
| 2007-10-08 08:30:00 | AAPL | Stock | 5.8446 | 5.8468 | 5.7661 | 5.8325 | 2687748.0 |
| 2007-10-08 09:00:00 | AAPL | Stock | 5.8314 | 5.8393 | 5.8143 | 5.8389 | 5631472.0 |
| 2007-10-08 09:30:00 | AAPL | Stock | 5.84 | 5.8929 | 5.8204 | 5.868 | 175951748.0 |
| 2007-10-08 10:00:00 | AAPL | Stock | 5.8704 | 5.8857 | 5.8604 | 5.8657 | 69423284.0 |
| 2007-10-08 10:30:00 | AAPL | Stock | 5.8657 | 5.8839 | 5.8536 | 5.8549 | 51028768.0 |
| 2007-10-08 11:00:00 | AAPL | Stock | 5.8557 | 5.865 | 5.85 | 5.8532 | 40791212.0 |
| 2007-10-08 11:30:00 | AAPL | Stock | 5.8532 | 5.8568 | 5.8421 | 5.8536 | 35315196.0 |
| 2007-10-08 12:00:00 | AAPL | Stock | 5.8536 | 5.8643 | 5.8486 | 5.8639 | 22831088.0 |
| 2007-10-08 12:30:00 | AAPL | Stock | 5.8639 | 5.8836 | 5.8632 | 5.8807 | 35314132.0 |
| 2007-10-08 13:00:00 | AAPL | Stock | 5.8811 | 5.8857 | 5.8725 | 5.8782 | 24807020.0 |
| 2007-10-08 13:30:00 | AAPL | Stock | 5.8786 | 5.9104 | 5.8768 | 5.8936 | 64619968.0 |
| 2007-10-08 14:00:00 | AAPL | Stock | 5.8929 | 5.9211 | 5.8893 | 5.9179 | 61420016.0 |
| 2007-10-08 14:30:00 | AAPL | Stock | 5.9179 | 5.9425 | 5.9093 | 5.9296 | 63514416.0 |
| 2007-10-08 15:00:00 | AAPL | Stock | 5.9296 | 5.9382 | 5.9161 | 5.9282 | 50639680.0 |
| 2007-10-08 15:30:00 | AAPL | Stock | 5.9282 | 5.9961 | 5.9214 | 5.9961 | 113350356.0 |
| 2007-10-08 16:00:00 | AAPL | Stock | 5.9964 | 5.9996 | 5.8703 | 5.99 | 9440648.0 |
| 2007-10-08 16:30:00 | AAPL | Stock | 5.9893 | 5.9968 | 5.951 | 5.9871 | 2150400.0 |
| 2007-10-08 17:00:00 | AAPL | Stock | 5.9857 | 5.9968 | 5.9682 | 5.9804 | 877268.0 |
| 2007-10-08 17:30:00 | AAPL | Stock | 5.9804 | 5.9893 | 5.9729 | 5.9893 | 173236.0 |
| 2007-10-08 18:00:00 | AAPL | Stock | 5.9825 | 5.9968 | 5.9825 | 5.9829 | 733936.0 |
| 2007-10-08 18:30:00 | AAPL | Stock | 5.9829 | 5.99 | 5.9821 | 5.9821 | 270536.0 |
| 2007-10-08 19:00:00 | AAPL | Stock | 5.9821 | 5.9957 | 5.9821 | 5.9893 | 105196.0 |
| 2007-10-08 19:30:00 | AAPL | Stock | 5.9929 | 5.9982 | 5.9896 | 5.9957 | 186620.0 |
| 2007-10-08 07:30:00 | MSFT | Stock | 29.66 | 29.8 | 29.66 | 29.8 | 3300.0 |
| 2007-10-08 08:00:00 | MSFT | Stock | 29.8 | 29.8 | 29.67 | 29.71 | 10640.0 |
| 2007-10-08 08:30:00 | MSFT | Stock | 29.71 | 29.84 | 29.69 | 29.71 | 10910.0 |
| 2007-10-08 09:00:00 | MSFT | Stock | 29.77 | 29.78 | 29.61 | 29.65 | 56270.0 |
| 2007-10-08 09:30:00 | MSFT | Stock | 29.66 | 29.84 | 29.61 | 29.73 | 3707700.0 |
| 2007-10-08 10:00:00 | MSFT | Stock | 29.73 | 29.8 | 29.7 | 29.77 | 2444131.0 |
| 2007-10-08 10:30:00 | MSFT | Stock | 29.772 | 29.85 | 29.77 | 29.85 | 1669080.0 |
| 2007-10-08 11:00:00 | MSFT | Stock | 29.84 | 29.85 | 29.78 | 29.78 | 2454644.0 |
| 2007-10-08 11:30:00 | MSFT | Stock | 29.78 | 29.85 | 29.78 | 29.82 | 1685564.0 |
| 2007-10-08 12:00:00 | MSFT | Stock | 29.82 | 29.83 | 29.72 | 29.72 | 1026833.0 |
| 2007-10-08 12:30:00 | MSFT | Stock | 29.73 | 29.73 | 29.67 | 29.68 | 1242896.0 |
| 2007-10-08 13:00:00 | MSFT | Stock | 29.68 | 29.69 | 29.65 | 29.67 | 974665.0 |
| 2007-10-08 13:30:00 | MSFT | Stock | 29.68 | 29.69 | 29.6 | 29.64 | 2077239.0 |
| 2007-10-08 14:00:00 | MSFT | Stock | 29.64 | 29.69 | 29.61 | 29.68 | 1641632.0 |
| 2007-10-08 14:30:00 | MSFT | Stock | 29.69 | 29.78 | 29.68 | 29.695 | 3095303.0 |
| 2007-10-08 15:00:00 | MSFT | Stock | 29.695 | 29.75 | 29.68 | 29.74 | 2022618.0 |
| 2007-10-08 15:30:00 | MSFT | Stock | 29.74 | 29.84 | 29.72 | 29.84 | 4593187.0 |
| 2007-10-08 16:00:00 | MSFT | Stock | 29.83 | 29.86 | 29.731 | 29.74 | 1524781.0 |
| 2007-10-08 16:30:00 | MSFT | Stock | 29.84 | 29.9 | 29.8 | 29.87 | 29473.0 |
| 2007-10-08 17:00:00 | MSFT | Stock | 29.84 | 29.84 | 29.8 | 29.84 | 3194.0 |
| 2007-10-08 18:00:00 | MSFT | Stock | 29.8 | 29.87 | 29.8 | 29.87 | 965.0 |
| 2007-10-08 08:00:00 | NVDA | Stock | 0.9275 | 0.9363 | 0.9262 | 0.93 | 318800.0 |
| 2007-10-08 08:30:00 | NVDA | Stock | 0.9312 | 0.9373 | 0.9232 | 0.936 | 106640.0 |
> showing 50 of 65,453 rows — these rows as CSV