PREVIEW / stock_30min / 2007-09-05
file: by_date/stock_30min/2007/2007-09-05.parquet size: 1.1 MB rows: 65,034 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-09-05 09:30:00 | AAPL | Stock | 5.1775 | 5.2086 | 5.1171 | 5.1521 | 223580868.0 |
| 2007-09-05 10:00:00 | AAPL | Stock | 5.1525 | 5.1664 | 5.1386 | 5.1529 | 100358580.0 |
| 2007-09-05 10:30:00 | AAPL | Stock | 5.1525 | 5.1864 | 5.1482 | 5.1851 | 84704956.0 |
| 2007-09-05 11:00:00 | AAPL | Stock | 5.185 | 5.1857 | 5.1475 | 5.1579 | 74420864.0 |
| 2007-09-05 11:30:00 | AAPL | Stock | 5.1582 | 5.1671 | 5.1332 | 5.1614 | 78910384.0 |
| 2007-09-05 12:00:00 | AAPL | Stock | 5.1614 | 5.1775 | 5.15 | 5.1704 | 56413196.0 |
| 2007-09-05 12:30:00 | AAPL | Stock | 5.1707 | 5.1718 | 5.1389 | 5.1532 | 57137780.0 |
| 2007-09-05 13:00:00 | AAPL | Stock | 5.1529 | 5.1686 | 4.9286 | 5.0354 | 297642716.0 |
| 2007-09-05 13:30:00 | AAPL | Stock | 5.0356 | 5.1275 | 5.0204 | 5.0725 | 221090828.0 |
| 2007-09-05 14:00:00 | AAPL | Stock | 5.0721 | 5.0825 | 4.9386 | 4.9639 | 256490472.0 |
| 2007-09-05 14:30:00 | AAPL | Stock | 4.9639 | 4.9982 | 4.9179 | 4.9721 | 208038012.0 |
| 2007-09-05 15:00:00 | AAPL | Stock | 4.9707 | 4.9946 | 4.9196 | 4.9293 | 171008040.0 |
| 2007-09-05 15:30:00 | AAPL | Stock | 4.929 | 4.9386 | 4.8607 | 4.8843 | 285033448.0 |
| 2007-09-05 16:00:00 | AAPL | Stock | 4.885 | 4.8854 | 4.8836 | 4.8843 | 11846156.0 |
| 2007-09-05 09:30:00 | MSFT | Stock | 28.65 | 28.73 | 28.58 | 28.59 | 3293647.0 |
| 2007-09-05 10:00:00 | MSFT | Stock | 28.59 | 28.63 | 28.48 | 28.58 | 3394362.0 |
| 2007-09-05 10:30:00 | MSFT | Stock | 28.58 | 28.6 | 28.51 | 28.55 | 2119241.0 |
| 2007-09-05 11:00:00 | MSFT | Stock | 28.55 | 28.56 | 28.46 | 28.5 | 1814050.0 |
| 2007-09-05 11:30:00 | MSFT | Stock | 28.505 | 28.57 | 28.42 | 28.56 | 3031507.0 |
| 2007-09-05 12:00:00 | MSFT | Stock | 28.57 | 28.58 | 28.5 | 28.56 | 1884325.0 |
| 2007-09-05 12:30:00 | MSFT | Stock | 28.56 | 28.65 | 28.53 | 28.65 | 1446034.0 |
| 2007-09-05 13:00:00 | MSFT | Stock | 28.65 | 28.65 | 28.56 | 28.581 | 1618900.0 |
| 2007-09-05 13:30:00 | MSFT | Stock | 28.58 | 28.6 | 28.47 | 28.47 | 2459657.0 |
| 2007-09-05 14:00:00 | MSFT | Stock | 28.47 | 28.52 | 28.45 | 28.47 | 3282312.0 |
| 2007-09-05 14:30:00 | MSFT | Stock | 28.47 | 28.52 | 28.43 | 28.5 | 2219503.0 |
| 2007-09-05 15:00:00 | MSFT | Stock | 28.49 | 28.53 | 28.45 | 28.53 | 3079307.0 |
| 2007-09-05 15:30:00 | MSFT | Stock | 28.521 | 28.58 | 28.44 | 28.47 | 5565373.0 |
| 2007-09-05 16:00:00 | MSFT | Stock | 28.47 | 28.48 | 28.47 | 28.48 | 2214238.0 |
| 2007-09-05 08:00:00 | NVDA | Stock | 0.8733 | 0.8733 | 0.8667 | 0.8667 | 245400.0 |
| 2007-09-05 08:30:00 | NVDA | Stock | 0.8683 | 0.879 | 0.8683 | 0.879 | 500640.0 |
| 2007-09-05 09:00:00 | NVDA | Stock | 0.8685 | 0.875 | 0.8683 | 0.8747 | 381540.0 |
| 2007-09-05 09:30:00 | NVDA | Stock | 0.8758 | 0.9 | 0.8733 | 0.8942 | 99958380.0 |
| 2007-09-05 10:00:00 | NVDA | Stock | 0.8942 | 0.8942 | 0.8788 | 0.8835 | 80824860.0 |
| 2007-09-05 10:30:00 | NVDA | Stock | 0.8835 | 0.8853 | 0.8803 | 0.8845 | 35610720.0 |
| 2007-09-05 11:00:00 | NVDA | Stock | 0.8842 | 0.8853 | 0.8783 | 0.8796 | 54353220.0 |
| 2007-09-05 11:30:00 | NVDA | Stock | 0.8798 | 0.8819 | 0.8767 | 0.881 | 41965320.0 |
| 2007-09-05 12:00:00 | NVDA | Stock | 0.8808 | 0.885 | 0.8793 | 0.8833 | 28355340.0 |
| 2007-09-05 12:30:00 | NVDA | Stock | 0.8833 | 0.8835 | 0.8792 | 0.8818 | 24030960.0 |
| 2007-09-05 13:00:00 | NVDA | Stock | 0.8815 | 0.8842 | 0.88 | 0.8808 | 26769720.0 |
| 2007-09-05 13:30:00 | NVDA | Stock | 0.8807 | 0.8813 | 0.8772 | 0.8792 | 27854760.0 |
| 2007-09-05 14:00:00 | NVDA | Stock | 0.8788 | 0.8802 | 0.8725 | 0.8737 | 41349660.0 |
| 2007-09-05 14:30:00 | NVDA | Stock | 0.874 | 0.8782 | 0.8722 | 0.8763 | 34101900.0 |
| 2007-09-05 15:00:00 | NVDA | Stock | 0.8763 | 0.88 | 0.8742 | 0.8747 | 35463720.0 |
| 2007-09-05 15:30:00 | NVDA | Stock | 0.8747 | 0.8767 | 0.8717 | 0.8725 | 64659420.0 |
| 2007-09-05 16:00:00 | NVDA | Stock | 0.8723 | 0.8748 | 0.8718 | 0.8748 | 21914160.0 |
| 2007-09-05 16:30:00 | NVDA | Stock | 0.8748 | 0.8748 | 0.8748 | 0.8748 | 126600.0 |
| 2007-09-05 17:00:00 | NVDA | Stock | 0.8748 | 0.8752 | 0.8748 | 0.8752 | 85200.0 |
| 2007-09-05 17:30:00 | NVDA | Stock | 0.8752 | 0.8752 | 0.8752 | 0.8752 | 42000.0 |
| 2007-09-05 18:30:00 | NVDA | Stock | 0.8775 | 0.8778 | 0.8775 | 0.8775 | 60000.0 |
| 2007-09-05 19:00:00 | NVDA | Stock | 0.8775 | 0.878 | 0.8758 | 0.8758 | 250320.0 |
> showing 50 of 65,034 rows — these rows as CSV