PREVIEW / stock_30min / 2004-08-04
file: by_date/stock_30min/2004/2004-08-04.parquet size: 744 KB rows: 40,058 symbols: 1,813
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 |
|---|---|---|---|---|---|---|---|
| 2004-08-04 08:00:00 | AAPL | Stock | 0.5589 | 0.5589 | 0.5552 | 0.5571 | 151200.0 |
| 2004-08-04 08:30:00 | AAPL | Stock | 0.5571 | 0.5571 | 0.5571 | 0.5571 | 33600.0 |
| 2004-08-04 09:00:00 | AAPL | Stock | 0.5568 | 0.5593 | 0.5563 | 0.5577 | 408744.0 |
| 2004-08-04 09:30:00 | AAPL | Stock | 0.557 | 0.5634 | 0.557 | 0.5609 | 28071400.0 |
| 2004-08-04 10:00:00 | AAPL | Stock | 0.5608 | 0.5616 | 0.5582 | 0.5589 | 10847816.0 |
| 2004-08-04 10:30:00 | AAPL | Stock | 0.5589 | 0.5623 | 0.5589 | 0.5589 | 13759536.0 |
| 2004-08-04 11:00:00 | AAPL | Stock | 0.5589 | 0.5607 | 0.558 | 0.5607 | 7308168.0 |
| 2004-08-04 11:30:00 | AAPL | Stock | 0.5611 | 0.5643 | 0.5604 | 0.5643 | 28070504.0 |
| 2004-08-04 12:00:00 | AAPL | Stock | 0.5641 | 0.5657 | 0.5632 | 0.5655 | 32475184.0 |
| 2004-08-04 12:30:00 | AAPL | Stock | 0.5655 | 0.5655 | 0.5641 | 0.5645 | 8889944.0 |
| 2004-08-04 13:00:00 | AAPL | Stock | 0.5645 | 0.5675 | 0.5645 | 0.5664 | 16306696.0 |
| 2004-08-04 13:30:00 | AAPL | Stock | 0.5666 | 0.5688 | 0.5661 | 0.5684 | 19783736.0 |
| 2004-08-04 14:00:00 | AAPL | Stock | 0.5684 | 0.5732 | 0.5684 | 0.573 | 27632472.0 |
| 2004-08-04 14:30:00 | AAPL | Stock | 0.573 | 0.5736 | 0.5711 | 0.5716 | 19021688.0 |
| 2004-08-04 15:00:00 | AAPL | Stock | 0.5714 | 0.573 | 0.5705 | 0.5705 | 22371776.0 |
| 2004-08-04 15:30:00 | AAPL | Stock | 0.5705 | 0.572 | 0.5675 | 0.5679 | 27286056.0 |
| 2004-08-04 16:00:00 | AAPL | Stock | 0.5679 | 0.5693 | 0.5671 | 0.5684 | 3977456.0 |
| 2004-08-04 16:30:00 | AAPL | Stock | 0.5679 | 0.5679 | 0.5677 | 0.5677 | 162400.0 |
| 2004-08-04 18:00:00 | AAPL | Stock | 0.5652 | 0.5652 | 0.5652 | 0.5652 | 128800.0 |
| 2004-08-04 08:00:00 | MSFT | Stock | 28.0 | 28.05 | 27.96 | 28.0 | 40435.0 |
| 2004-08-04 08:30:00 | MSFT | Stock | 27.99 | 28.0 | 27.97 | 28.0 | 18271.0 |
| 2004-08-04 09:00:00 | MSFT | Stock | 27.99 | 28.02 | 27.98 | 27.99 | 180058.0 |
| 2004-08-04 09:30:00 | MSFT | Stock | 28.001 | 28.13 | 27.99 | 28.07 | 5108579.0 |
| 2004-08-04 10:00:00 | MSFT | Stock | 28.06 | 28.14 | 28.02 | 28.1 | 3460938.0 |
| 2004-08-04 10:30:00 | MSFT | Stock | 28.1 | 28.2 | 28.07 | 28.08 | 5086392.0 |
| 2004-08-04 11:00:00 | MSFT | Stock | 28.07 | 28.176 | 28.04 | 28.16 | 3108367.0 |
| 2004-08-04 11:30:00 | MSFT | Stock | 28.16 | 28.17 | 28.11 | 28.16 | 2626986.0 |
| 2004-08-04 12:00:00 | MSFT | Stock | 28.16 | 28.172 | 28.09 | 28.12 | 1795201.0 |
| 2004-08-04 12:30:00 | MSFT | Stock | 28.13 | 28.14 | 28.06 | 28.11 | 1835878.0 |
| 2004-08-04 13:00:00 | MSFT | Stock | 28.11 | 28.11 | 28.049 | 28.07 | 1484784.0 |
| 2004-08-04 13:30:00 | MSFT | Stock | 28.08 | 28.14 | 28.07 | 28.11 | 2687082.0 |
| 2004-08-04 14:00:00 | MSFT | Stock | 28.11 | 28.15 | 28.05 | 28.091 | 3292824.0 |
| 2004-08-04 14:30:00 | MSFT | Stock | 28.09 | 28.151 | 28.06 | 28.1 | 3365260.0 |
| 2004-08-04 15:00:00 | MSFT | Stock | 28.1 | 28.13 | 28.05 | 28.05 | 2508828.0 |
| 2004-08-04 15:30:00 | MSFT | Stock | 28.05 | 28.09 | 27.989 | 28.04 | 6113896.0 |
| 2004-08-04 16:00:00 | MSFT | Stock | 28.05 | 28.1 | 28.01 | 28.06 | 908662.0 |
| 2004-08-04 16:30:00 | MSFT | Stock | 28.09 | 28.11 | 28.06 | 28.06 | 829202.0 |
| 2004-08-04 17:00:00 | MSFT | Stock | 28.1 | 28.1 | 28.1 | 28.1 | 100.0 |
| 2004-08-04 17:30:00 | MSFT | Stock | 28.1 | 28.1 | 28.1 | 28.1 | 400.0 |
| 2004-08-04 18:00:00 | MSFT | Stock | 28.1 | 28.11 | 28.1 | 28.11 | 1050.0 |
| 2004-08-04 08:00:00 | NVDA | Stock | 0.1234 | 0.1234 | 0.123 | 0.123 | 48000.0 |
| 2004-08-04 08:30:00 | NVDA | Stock | 0.123 | 0.123 | 0.1228 | 0.1228 | 120000.0 |
| 2004-08-04 09:00:00 | NVDA | Stock | 0.1226 | 0.1236 | 0.1224 | 0.1235 | 1578600.0 |
| 2004-08-04 09:30:00 | NVDA | Stock | 0.1233 | 0.125 | 0.122 | 0.1241 | 74767320.0 |
| 2004-08-04 10:00:00 | NVDA | Stock | 0.124 | 0.1249 | 0.1235 | 0.1242 | 39702600.0 |
| 2004-08-04 10:30:00 | NVDA | Stock | 0.1242 | 0.1249 | 0.1233 | 0.1233 | 31989600.0 |
| 2004-08-04 11:00:00 | NVDA | Stock | 0.1233 | 0.1235 | 0.1228 | 0.1229 | 26069760.0 |
| 2004-08-04 11:30:00 | NVDA | Stock | 0.123 | 0.1238 | 0.1225 | 0.1237 | 20454120.0 |
| 2004-08-04 12:00:00 | NVDA | Stock | 0.1237 | 0.1238 | 0.1229 | 0.1233 | 17090040.0 |
| 2004-08-04 12:30:00 | NVDA | Stock | 0.1233 | 0.1233 | 0.1224 | 0.1224 | 16359600.0 |
> showing 50 of 40,058 rows — these rows as CSV