PREVIEW / stock_30min / 2005-10-07
file: by_date/stock_30min/2005/2005-10-07.parquet size: 834 KB rows: 45,156 symbols: 2,084
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-10-07 07:00:00 | AAPL | Stock | 1.8446 | 1.8446 | 1.8118 | 1.8143 | 497280.0 |
| 2005-10-07 07:30:00 | AAPL | Stock | 1.8143 | 1.8196 | 1.8143 | 1.8143 | 219240.0 |
| 2005-10-07 08:00:00 | AAPL | Stock | 1.8129 | 1.8196 | 1.8018 | 1.8054 | 3867668.0 |
| 2005-10-07 08:30:00 | AAPL | Stock | 1.805 | 1.8318 | 1.8043 | 1.8314 | 3858232.0 |
| 2005-10-07 09:00:00 | AAPL | Stock | 1.8314 | 1.8482 | 1.8311 | 1.8475 | 6138104.0 |
| 2005-10-07 09:30:00 | AAPL | Stock | 1.8471 | 1.8546 | 1.8082 | 1.8204 | 155140468.0 |
| 2005-10-07 10:00:00 | AAPL | Stock | 1.8204 | 1.8243 | 1.8054 | 1.8125 | 85885800.0 |
| 2005-10-07 10:30:00 | AAPL | Stock | 1.8118 | 1.8271 | 1.81 | 1.8246 | 66860528.0 |
| 2005-10-07 11:00:00 | AAPL | Stock | 1.8246 | 1.83 | 1.8168 | 1.8257 | 42387128.0 |
| 2005-10-07 11:30:00 | AAPL | Stock | 1.8254 | 1.8275 | 1.8168 | 1.8214 | 36513148.0 |
| 2005-10-07 12:00:00 | AAPL | Stock | 1.8211 | 1.8214 | 1.8111 | 1.8157 | 25275096.0 |
| 2005-10-07 12:30:00 | AAPL | Stock | 1.8157 | 1.8214 | 1.8129 | 1.815 | 21048076.0 |
| 2005-10-07 13:00:00 | AAPL | Stock | 1.8146 | 1.8179 | 1.8111 | 1.8161 | 25701816.0 |
| 2005-10-07 13:30:00 | AAPL | Stock | 1.8161 | 1.8286 | 1.8157 | 1.825 | 36930964.0 |
| 2005-10-07 14:00:00 | AAPL | Stock | 1.825 | 1.8314 | 1.8214 | 1.8304 | 35597464.0 |
| 2005-10-07 14:30:00 | AAPL | Stock | 1.8307 | 1.8436 | 1.8275 | 1.84 | 41444508.0 |
| 2005-10-07 15:00:00 | AAPL | Stock | 1.8404 | 1.8404 | 1.8254 | 1.8304 | 40505164.0 |
| 2005-10-07 15:30:00 | AAPL | Stock | 1.8296 | 1.8375 | 1.8261 | 1.8321 | 42752808.0 |
| 2005-10-07 16:00:00 | AAPL | Stock | 1.8307 | 1.8321 | 1.8268 | 1.8307 | 709828.0 |
| 2005-10-07 16:30:00 | AAPL | Stock | 1.8321 | 1.8321 | 1.8304 | 1.8321 | 115332.0 |
| 2005-10-07 17:00:00 | AAPL | Stock | 1.8321 | 1.8321 | 1.8321 | 1.8321 | 866544.0 |
| 2005-10-07 17:30:00 | AAPL | Stock | 1.8325 | 1.8339 | 1.8325 | 1.8339 | 36400.0 |
| 2005-10-07 18:00:00 | AAPL | Stock | 1.835 | 1.8357 | 1.8236 | 1.8325 | 270956.0 |
| 2005-10-07 08:00:00 | MSFT | Stock | 24.79 | 24.81 | 24.76 | 24.8 | 18916.0 |
| 2005-10-07 08:30:00 | MSFT | Stock | 24.81 | 24.89 | 24.76 | 24.84 | 55073.0 |
| 2005-10-07 09:00:00 | MSFT | Stock | 24.83 | 24.86 | 24.75 | 24.77 | 63198.0 |
| 2005-10-07 09:30:00 | MSFT | Stock | 24.77 | 24.84 | 24.64 | 24.71 | 10691874.0 |
| 2005-10-07 10:00:00 | MSFT | Stock | 24.71 | 24.77 | 24.63 | 24.68 | 5408346.0 |
| 2005-10-07 10:30:00 | MSFT | Stock | 24.68 | 24.71 | 24.63 | 24.68 | 3041972.0 |
| 2005-10-07 11:00:00 | MSFT | Stock | 24.68 | 24.73 | 24.65 | 24.72 | 2456090.0 |
| 2005-10-07 11:30:00 | MSFT | Stock | 24.71 | 24.74 | 24.65 | 24.7 | 2489954.0 |
| 2005-10-07 12:00:00 | MSFT | Stock | 24.7 | 24.73 | 24.68 | 24.71 | 1764019.0 |
| 2005-10-07 12:30:00 | MSFT | Stock | 24.71 | 24.71 | 24.66 | 24.67 | 1377378.0 |
| 2005-10-07 13:00:00 | MSFT | Stock | 24.68 | 24.69 | 24.61 | 24.63 | 3452285.0 |
| 2005-10-07 13:30:00 | MSFT | Stock | 24.64 | 24.75 | 24.6 | 24.62 | 2207081.0 |
| 2005-10-07 14:00:00 | MSFT | Stock | 24.62 | 24.69 | 24.52 | 24.55 | 4153105.0 |
| 2005-10-07 14:30:00 | MSFT | Stock | 24.55 | 24.61 | 24.55 | 24.58 | 2607456.0 |
| 2005-10-07 15:00:00 | MSFT | Stock | 24.58 | 24.63 | 24.56 | 24.58 | 2557538.0 |
| 2005-10-07 15:30:00 | MSFT | Stock | 24.59 | 24.65 | 24.56 | 24.6 | 6055200.0 |
| 2005-10-07 16:00:00 | MSFT | Stock | 24.59 | 24.7 | 24.56 | 24.56 | 113693.0 |
| 2005-10-07 16:30:00 | MSFT | Stock | 24.58 | 24.58 | 24.57 | 24.58 | 5291.0 |
| 2005-10-07 17:00:00 | MSFT | Stock | 24.59 | 24.59 | 24.57 | 24.58 | 344382.0 |
| 2005-10-07 17:30:00 | MSFT | Stock | 24.57 | 24.59 | 24.56 | 24.59 | 5988.0 |
| 2005-10-07 18:00:00 | MSFT | Stock | 24.667 | 24.667 | 24.584 | 24.59 | 21486.0 |
| 2005-10-07 08:00:00 | NVDA | Stock | 0.2796 | 0.2796 | 0.2781 | 0.2781 | 114000.0 |
| 2005-10-07 09:00:00 | NVDA | Stock | 0.2792 | 0.2798 | 0.2792 | 0.2792 | 187560.0 |
| 2005-10-07 09:30:00 | NVDA | Stock | 0.2796 | 0.2824 | 0.2789 | 0.2797 | 74381520.0 |
| 2005-10-07 10:00:00 | NVDA | Stock | 0.2797 | 0.2809 | 0.2767 | 0.2774 | 64406880.0 |
| 2005-10-07 10:30:00 | NVDA | Stock | 0.2775 | 0.2786 | 0.2733 | 0.2759 | 54690720.0 |
| 2005-10-07 11:00:00 | NVDA | Stock | 0.2759 | 0.2771 | 0.2737 | 0.2741 | 39804600.0 |
> showing 50 of 45,156 rows — these rows as CSV