PREVIEW / stock_30min / 2003-07-31
file: by_date/stock_30min/2003/2003-07-31.parquet size: 712 KB rows: 38,391 symbols: 1,608
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 |
|---|---|---|---|---|---|---|---|
| 2003-07-31 08:30:00 | AAPL | Stock | 0.3627 | 0.3627 | 0.3627 | 0.3627 | 5600.0 |
| 2003-07-31 09:00:00 | AAPL | Stock | 0.3659 | 0.3696 | 0.3646 | 0.3696 | 795200.0 |
| 2003-07-31 09:30:00 | AAPL | Stock | 0.3704 | 0.3716 | 0.3679 | 0.3716 | 19243896.0 |
| 2003-07-31 10:00:00 | AAPL | Stock | 0.3716 | 0.3732 | 0.3673 | 0.3702 | 13752256.0 |
| 2003-07-31 10:30:00 | AAPL | Stock | 0.3702 | 0.3768 | 0.3696 | 0.3763 | 30532656.0 |
| 2003-07-31 11:00:00 | AAPL | Stock | 0.3763 | 0.3811 | 0.3759 | 0.3789 | 29450344.0 |
| 2003-07-31 11:30:00 | AAPL | Stock | 0.3789 | 0.3789 | 0.3759 | 0.377 | 15173256.0 |
| 2003-07-31 12:00:00 | AAPL | Stock | 0.3771 | 0.3796 | 0.3768 | 0.3768 | 9100000.0 |
| 2003-07-31 12:30:00 | AAPL | Stock | 0.3768 | 0.3779 | 0.3754 | 0.3761 | 9623040.0 |
| 2003-07-31 13:00:00 | AAPL | Stock | 0.3759 | 0.3775 | 0.3757 | 0.377 | 10873632.0 |
| 2003-07-31 13:30:00 | AAPL | Stock | 0.3771 | 0.3775 | 0.3764 | 0.3771 | 11992680.0 |
| 2003-07-31 14:00:00 | AAPL | Stock | 0.3771 | 0.3784 | 0.3764 | 0.3771 | 8050784.0 |
| 2003-07-31 14:30:00 | AAPL | Stock | 0.3771 | 0.3782 | 0.3755 | 0.378 | 11556608.0 |
| 2003-07-31 15:00:00 | AAPL | Stock | 0.378 | 0.3813 | 0.377 | 0.3786 | 16955120.0 |
| 2003-07-31 15:30:00 | AAPL | Stock | 0.3786 | 0.3789 | 0.3754 | 0.3777 | 32857664.0 |
| 2003-07-31 16:00:00 | AAPL | Stock | 0.3777 | 0.3793 | 0.3757 | 0.3759 | 37189600.0 |
| 2003-07-31 16:30:00 | AAPL | Stock | 0.3777 | 0.3791 | 0.3759 | 0.3791 | 369600.0 |
| 2003-07-31 17:00:00 | AAPL | Stock | 0.3789 | 0.3791 | 0.3789 | 0.3791 | 140000.0 |
| 2003-07-31 17:30:00 | AAPL | Stock | 0.3759 | 0.3759 | 0.3759 | 0.3759 | 6736800.0 |
| 2003-07-31 08:00:00 | MSFT | Stock | 26.33 | 26.35 | 26.32 | 26.32 | 15258.0 |
| 2003-07-31 08:30:00 | MSFT | Stock | 26.33 | 26.55 | 26.33 | 26.48 | 284806.0 |
| 2003-07-31 09:00:00 | MSFT | Stock | 26.49 | 26.62 | 26.42 | 26.62 | 193843.0 |
| 2003-07-31 09:30:00 | MSFT | Stock | 26.57 | 26.66 | 26.42 | 26.659 | 6368386.0 |
| 2003-07-31 10:00:00 | MSFT | Stock | 26.66 | 26.66 | 26.33 | 26.49 | 5056460.0 |
| 2003-07-31 10:30:00 | MSFT | Stock | 26.49 | 26.88 | 26.46 | 26.85 | 7454800.0 |
| 2003-07-31 11:00:00 | MSFT | Stock | 26.85 | 26.98 | 26.81 | 26.91 | 5286466.0 |
| 2003-07-31 11:30:00 | MSFT | Stock | 26.91 | 26.93 | 26.83 | 26.87 | 2405925.0 |
| 2003-07-31 12:00:00 | MSFT | Stock | 26.87 | 26.921 | 26.8 | 26.8 | 1379594.0 |
| 2003-07-31 12:30:00 | MSFT | Stock | 26.81 | 26.89 | 26.77 | 26.8379 | 1419069.0 |
| 2003-07-31 13:00:00 | MSFT | Stock | 26.839 | 26.95 | 26.8 | 26.86 | 1758472.0 |
| 2003-07-31 13:30:00 | MSFT | Stock | 26.86 | 26.9 | 26.81 | 26.84 | 1330618.0 |
| 2003-07-31 14:00:00 | MSFT | Stock | 26.85 | 26.95 | 26.84 | 26.84 | 1908162.0 |
| 2003-07-31 14:30:00 | MSFT | Stock | 26.84 | 26.841 | 26.58 | 26.66 | 4215740.0 |
| 2003-07-31 15:00:00 | MSFT | Stock | 26.66 | 26.77 | 26.52 | 26.6 | 3451171.0 |
| 2003-07-31 15:30:00 | MSFT | Stock | 26.55 | 26.59 | 26.31 | 26.41 | 8046276.0 |
| 2003-07-31 16:00:00 | MSFT | Stock | 26.41 | 26.44 | 26.352 | 26.4 | 1453125.0 |
| 2003-07-31 16:30:00 | MSFT | Stock | 26.4 | 26.42 | 26.3762 | 26.42 | 881850.0 |
| 2003-07-31 17:00:00 | MSFT | Stock | 26.43 | 26.43 | 26.4 | 26.42 | 27200.0 |
| 2003-07-31 17:30:00 | MSFT | Stock | 26.44 | 26.44 | 26.4 | 26.4 | 3047808.0 |
| 2003-07-31 18:00:00 | MSFT | Stock | 26.42 | 26.44 | 26.42 | 26.44 | 6063.0 |
| 2003-07-31 08:30:00 | NVDA | Stock | 0.1583 | 0.1596 | 0.1583 | 0.1596 | 1548000.0 |
| 2003-07-31 09:00:00 | NVDA | Stock | 0.1595 | 0.1604 | 0.1595 | 0.1604 | 1860720.0 |
| 2003-07-31 09:30:00 | NVDA | Stock | 0.1608 | 0.1609 | 0.1589 | 0.1599 | 93949200.0 |
| 2003-07-31 10:00:00 | NVDA | Stock | 0.1599 | 0.16 | 0.1577 | 0.1587 | 44353080.0 |
| 2003-07-31 10:30:00 | NVDA | Stock | 0.1586 | 0.1599 | 0.1582 | 0.1593 | 104256000.0 |
| 2003-07-31 11:00:00 | NVDA | Stock | 0.1592 | 0.1599 | 0.1589 | 0.1595 | 75867600.0 |
| 2003-07-31 11:30:00 | NVDA | Stock | 0.1595 | 0.1597 | 0.1592 | 0.1595 | 30886800.0 |
| 2003-07-31 12:00:00 | NVDA | Stock | 0.1594 | 0.1597 | 0.1593 | 0.1595 | 10906320.0 |
| 2003-07-31 12:30:00 | NVDA | Stock | 0.1595 | 0.1597 | 0.1594 | 0.1595 | 9301800.0 |
| 2003-07-31 13:00:00 | NVDA | Stock | 0.1594 | 0.1597 | 0.1593 | 0.1597 | 15595200.0 |
> showing 50 of 38,391 rows — these rows as CSV