PREVIEW / stock_30min / 2005-02-24
file: by_date/stock_30min/2005/2005-02-24.parquet size: 815 KB rows: 43,541 symbols: 1,937
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-02-24 08:00:00 | AAPL | Stock | 1.5771 | 1.582 | 1.5666 | 1.5757 | 3541272.0 |
| 2005-02-24 08:30:00 | AAPL | Stock | 1.5757 | 1.5759 | 1.5643 | 1.5671 | 5940536.0 |
| 2005-02-24 09:00:00 | AAPL | Stock | 1.5661 | 1.5823 | 1.5646 | 1.5802 | 5386080.0 |
| 2005-02-24 09:30:00 | AAPL | Stock | 1.58 | 1.5918 | 1.5666 | 1.5757 | 232532944.0 |
| 2005-02-24 10:00:00 | AAPL | Stock | 1.5757 | 1.5911 | 1.5711 | 1.5871 | 147080416.0 |
| 2005-02-24 10:30:00 | AAPL | Stock | 1.587 | 1.5948 | 1.5809 | 1.5821 | 142822624.0 |
| 2005-02-24 11:00:00 | AAPL | Stock | 1.5821 | 1.5938 | 1.5789 | 1.5873 | 73728984.0 |
| 2005-02-24 11:30:00 | AAPL | Stock | 1.5873 | 1.5914 | 1.5839 | 1.5863 | 43795360.0 |
| 2005-02-24 12:00:00 | AAPL | Stock | 1.5859 | 1.5859 | 1.5766 | 1.5804 | 59091928.0 |
| 2005-02-24 12:30:00 | AAPL | Stock | 1.5805 | 1.5816 | 1.567 | 1.578 | 112200200.0 |
| 2005-02-24 13:00:00 | AAPL | Stock | 1.5779 | 1.5796 | 1.5696 | 1.5766 | 63063168.0 |
| 2005-02-24 13:30:00 | AAPL | Stock | 1.5766 | 1.5864 | 1.5755 | 1.5816 | 60805080.0 |
| 2005-02-24 14:00:00 | AAPL | Stock | 1.582 | 1.5921 | 1.5786 | 1.5898 | 69128864.0 |
| 2005-02-24 14:30:00 | AAPL | Stock | 1.5898 | 1.5913 | 1.5818 | 1.582 | 288360408.0 |
| 2005-02-24 15:00:00 | AAPL | Stock | 1.582 | 1.5868 | 1.5805 | 1.5827 | 84813680.0 |
| 2005-02-24 15:30:00 | AAPL | Stock | 1.5827 | 1.5904 | 1.5813 | 1.5875 | 113362928.0 |
| 2005-02-24 16:00:00 | AAPL | Stock | 1.5875 | 1.588 | 1.5857 | 1.5861 | 5400472.0 |
| 2005-02-24 16:30:00 | AAPL | Stock | 1.5864 | 1.5893 | 1.5864 | 1.5889 | 1122464.0 |
| 2005-02-24 17:00:00 | AAPL | Stock | 1.588 | 1.5893 | 1.5873 | 1.5893 | 421792.0 |
| 2005-02-24 17:30:00 | AAPL | Stock | 1.5895 | 1.5905 | 1.5871 | 1.5871 | 474320.0 |
| 2005-02-24 18:00:00 | AAPL | Stock | 1.5889 | 1.5889 | 1.5857 | 1.5884 | 181664.0 |
| 2005-02-24 08:00:00 | MSFT | Stock | 25.18 | 25.2 | 25.18 | 25.2 | 8675.0 |
| 2005-02-24 08:30:00 | MSFT | Stock | 25.17 | 25.17 | 25.15 | 25.17 | 10052.0 |
| 2005-02-24 09:00:00 | MSFT | Stock | 25.17 | 25.2 | 25.14 | 25.18 | 252247.0 |
| 2005-02-24 09:30:00 | MSFT | Stock | 25.18 | 25.34 | 25.15 | 25.33 | 10449567.0 |
| 2005-02-24 10:00:00 | MSFT | Stock | 25.33 | 25.38 | 25.28 | 25.33 | 7259553.0 |
| 2005-02-24 10:30:00 | MSFT | Stock | 25.32 | 25.37 | 25.25 | 25.261 | 6539179.0 |
| 2005-02-24 11:00:00 | MSFT | Stock | 25.25 | 25.3 | 25.22 | 25.24 | 5500384.0 |
| 2005-02-24 11:30:00 | MSFT | Stock | 25.24 | 25.28 | 25.2 | 25.22 | 4445520.0 |
| 2005-02-24 12:00:00 | MSFT | Stock | 25.23 | 25.24 | 25.179 | 25.22 | 5717365.0 |
| 2005-02-24 12:30:00 | MSFT | Stock | 25.22 | 25.23 | 25.18 | 25.2 | 2387711.0 |
| 2005-02-24 13:00:00 | MSFT | Stock | 25.2 | 25.3 | 25.19 | 25.289 | 5982667.0 |
| 2005-02-24 13:30:00 | MSFT | Stock | 25.29 | 25.38 | 25.29 | 25.321 | 5137341.0 |
| 2005-02-24 14:00:00 | MSFT | Stock | 25.33 | 25.44 | 25.32 | 25.41 | 6345320.0 |
| 2005-02-24 14:30:00 | MSFT | Stock | 25.42 | 25.44 | 25.35 | 25.41 | 4726653.0 |
| 2005-02-24 15:00:00 | MSFT | Stock | 25.4 | 25.44 | 25.34 | 25.36 | 6656182.0 |
| 2005-02-24 15:30:00 | MSFT | Stock | 25.35 | 25.42 | 25.31 | 25.37 | 6100975.0 |
| 2005-02-24 16:00:00 | MSFT | Stock | 25.36 | 25.4 | 25.36 | 25.36 | 1480330.0 |
| 2005-02-24 16:30:00 | MSFT | Stock | 25.36 | 25.45 | 25.36 | 25.45 | 294956.0 |
| 2005-02-24 17:00:00 | MSFT | Stock | 25.4 | 25.47 | 25.38 | 25.47 | 36100.0 |
| 2005-02-24 17:30:00 | MSFT | Stock | 25.36 | 25.42 | 25.36 | 25.41 | 185874.0 |
| 2005-02-24 18:00:00 | MSFT | Stock | 25.37 | 25.42 | 25.37 | 25.42 | 10180.0 |
| 2005-02-24 08:30:00 | NVDA | Stock | 0.23 | 0.23 | 0.23 | 0.23 | 60000.0 |
| 2005-02-24 09:00:00 | NVDA | Stock | 0.2289 | 0.2298 | 0.2274 | 0.2277 | 888000.0 |
| 2005-02-24 09:30:00 | NVDA | Stock | 0.2277 | 0.2359 | 0.2277 | 0.2318 | 153713040.0 |
| 2005-02-24 10:00:00 | NVDA | Stock | 0.2317 | 0.2337 | 0.2307 | 0.2333 | 64701120.0 |
| 2005-02-24 10:30:00 | NVDA | Stock | 0.2338 | 0.2355 | 0.2335 | 0.2338 | 70840920.0 |
| 2005-02-24 11:00:00 | NVDA | Stock | 0.2338 | 0.235 | 0.2337 | 0.2341 | 62109720.0 |
| 2005-02-24 11:30:00 | NVDA | Stock | 0.2342 | 0.2343 | 0.2329 | 0.2334 | 40530120.0 |
| 2005-02-24 12:00:00 | NVDA | Stock | 0.2335 | 0.2335 | 0.2307 | 0.2332 | 29650080.0 |
> showing 50 of 43,541 rows — these rows as CSV