PREVIEW / stock_30min / 2005-09-14
file: by_date/stock_30min/2005/2005-09-14.parquet size: 839 KB rows: 45,847 symbols: 2,063
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 |
|---|---|---|---|---|---|---|---|
| 2005-09-14 08:00:00 | AAPL | Stock | 1.8107 | 1.8204 | 1.8107 | 1.8204 | 148260.0 |
| 2005-09-14 08:30:00 | AAPL | Stock | 1.8196 | 1.835 | 1.8179 | 1.825 | 1456140.0 |
| 2005-09-14 09:00:00 | AAPL | Stock | 1.8254 | 1.8286 | 1.8204 | 1.8279 | 2009140.0 |
| 2005-09-14 09:30:00 | AAPL | Stock | 1.8236 | 1.8282 | 1.8089 | 1.8104 | 55608392.0 |
| 2005-09-14 10:00:00 | AAPL | Stock | 1.8107 | 1.8229 | 1.8093 | 1.815 | 33477472.0 |
| 2005-09-14 10:30:00 | AAPL | Stock | 1.8154 | 1.825 | 1.8121 | 1.82 | 36821176.0 |
| 2005-09-14 11:00:00 | AAPL | Stock | 1.8204 | 1.8243 | 1.8164 | 1.8179 | 18488540.0 |
| 2005-09-14 11:30:00 | AAPL | Stock | 1.8179 | 1.8229 | 1.8161 | 1.8161 | 15650600.0 |
| 2005-09-14 12:00:00 | AAPL | Stock | 1.8157 | 1.8161 | 1.8089 | 1.8089 | 17283728.0 |
| 2005-09-14 12:30:00 | AAPL | Stock | 1.8093 | 1.81 | 1.8036 | 1.81 | 25945948.0 |
| 2005-09-14 13:00:00 | AAPL | Stock | 1.8096 | 1.8136 | 1.8079 | 1.8107 | 13516104.0 |
| 2005-09-14 13:30:00 | AAPL | Stock | 1.8104 | 1.8107 | 1.7996 | 1.8018 | 26329744.0 |
| 2005-09-14 14:00:00 | AAPL | Stock | 1.8018 | 1.8043 | 1.7879 | 1.7925 | 39063332.0 |
| 2005-09-14 14:30:00 | AAPL | Stock | 1.7921 | 1.7946 | 1.7732 | 1.7732 | 50484000.0 |
| 2005-09-14 15:00:00 | AAPL | Stock | 1.7732 | 1.7796 | 1.7665 | 1.7746 | 58039436.0 |
| 2005-09-14 15:30:00 | AAPL | Stock | 1.775 | 1.7846 | 1.7718 | 1.7718 | 57412404.0 |
| 2005-09-14 16:00:00 | AAPL | Stock | 1.7718 | 1.8282 | 1.7718 | 1.775 | 4546164.0 |
| 2005-09-14 16:30:00 | AAPL | Stock | 1.775 | 1.7768 | 1.775 | 1.7764 | 99400.0 |
| 2005-09-14 17:00:00 | AAPL | Stock | 1.7768 | 1.7768 | 1.7714 | 1.7757 | 135968.0 |
| 2005-09-14 17:30:00 | AAPL | Stock | 1.7757 | 1.7779 | 1.7757 | 1.7779 | 50764.0 |
| 2005-09-14 18:00:00 | AAPL | Stock | 1.7768 | 1.7786 | 1.7768 | 1.7786 | 85316.0 |
| 2005-09-14 08:00:00 | MSFT | Stock | 26.5 | 26.5 | 26.48 | 26.5 | 10350.0 |
| 2005-09-14 08:30:00 | MSFT | Stock | 26.51 | 26.51 | 26.49 | 26.51 | 3420.0 |
| 2005-09-14 09:00:00 | MSFT | Stock | 26.52 | 26.55 | 26.51 | 26.52 | 24662.0 |
| 2005-09-14 09:30:00 | MSFT | Stock | 26.52 | 26.55 | 26.46 | 26.5 | 5642587.0 |
| 2005-09-14 10:00:00 | MSFT | Stock | 26.5 | 26.64 | 26.5 | 26.58 | 5582476.0 |
| 2005-09-14 10:30:00 | MSFT | Stock | 26.58 | 26.64 | 26.53 | 26.54 | 3506379.0 |
| 2005-09-14 11:00:00 | MSFT | Stock | 26.55 | 26.57 | 26.5 | 26.52 | 2215710.0 |
| 2005-09-14 11:30:00 | MSFT | Stock | 26.52 | 26.55 | 26.48 | 26.54 | 2412197.0 |
| 2005-09-14 12:00:00 | MSFT | Stock | 26.54 | 26.62 | 26.52 | 26.57 | 2932283.0 |
| 2005-09-14 12:30:00 | MSFT | Stock | 26.57 | 26.59 | 26.53 | 26.59 | 2174820.0 |
| 2005-09-14 13:00:00 | MSFT | Stock | 26.58 | 26.59 | 26.532 | 26.55 | 2247145.0 |
| 2005-09-14 13:30:00 | MSFT | Stock | 26.55 | 26.56 | 26.48 | 26.5 | 3341149.0 |
| 2005-09-14 14:00:00 | MSFT | Stock | 26.5 | 26.52 | 26.39 | 26.43 | 4020250.0 |
| 2005-09-14 14:30:00 | MSFT | Stock | 26.43 | 26.45 | 26.4 | 26.44 | 2832816.0 |
| 2005-09-14 15:00:00 | MSFT | Stock | 26.43 | 26.43 | 26.349 | 26.35 | 5981433.0 |
| 2005-09-14 15:30:00 | MSFT | Stock | 26.35 | 26.39 | 26.3 | 26.3 | 8010804.0 |
| 2005-09-14 16:00:00 | MSFT | Stock | 26.32 | 26.57 | 26.28 | 26.31 | 424241.0 |
| 2005-09-14 16:30:00 | MSFT | Stock | 26.31 | 26.32 | 26.31 | 26.32 | 50200.0 |
| 2005-09-14 17:00:00 | MSFT | Stock | 26.32 | 26.32 | 26.3 | 26.31 | 1100.0 |
| 2005-09-14 17:30:00 | MSFT | Stock | 26.33 | 26.34 | 26.31 | 26.33 | 646460.0 |
| 2005-09-14 18:00:00 | MSFT | Stock | 26.34 | 26.34 | 26.3 | 26.32 | 2800.0 |
| 2005-09-14 08:00:00 | NVDA | Stock | 0.275 | 0.275 | 0.275 | 0.275 | 60000.0 |
| 2005-09-14 08:30:00 | NVDA | Stock | 0.275 | 0.275 | 0.275 | 0.275 | 42000.0 |
| 2005-09-14 09:00:00 | NVDA | Stock | 0.2746 | 0.2763 | 0.2731 | 0.2731 | 2880000.0 |
| 2005-09-14 09:30:00 | NVDA | Stock | 0.2733 | 0.275 | 0.2727 | 0.2746 | 49701720.0 |
| 2005-09-14 10:00:00 | NVDA | Stock | 0.2747 | 0.2758 | 0.2743 | 0.2746 | 30222720.0 |
| 2005-09-14 10:30:00 | NVDA | Stock | 0.2746 | 0.2758 | 0.2743 | 0.2752 | 31562280.0 |
| 2005-09-14 11:00:00 | NVDA | Stock | 0.2751 | 0.2769 | 0.2749 | 0.2762 | 27044160.0 |
| 2005-09-14 11:30:00 | NVDA | Stock | 0.2762 | 0.277 | 0.2759 | 0.2759 | 24220200.0 |
> showing 50 of 45,847 rows — these rows as CSV