PREVIEW / stock_1hour / 2004-05-05
file: by_date/stock_1hour/2004/2004-05-05.parquet size: 505 KB rows: 23,765 symbols: 1,767
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-05-05 08:00:00 | AAPL | Stock | 0.4671 | 0.4671 | 0.4671 | 0.4671 | 95200.0 |
| 2004-05-05 09:00:00 | AAPL | Stock | 0.4675 | 0.473 | 0.4636 | 0.4684 | 14755048.0 |
| 2004-05-05 10:00:00 | AAPL | Stock | 0.4684 | 0.4759 | 0.4659 | 0.4702 | 36243984.0 |
| 2004-05-05 11:00:00 | AAPL | Stock | 0.4703 | 0.4725 | 0.4684 | 0.4695 | 14276976.0 |
| 2004-05-05 12:00:00 | AAPL | Stock | 0.4695 | 0.4705 | 0.467 | 0.468 | 14703080.0 |
| 2004-05-05 13:00:00 | AAPL | Stock | 0.468 | 0.4745 | 0.468 | 0.4745 | 30896992.0 |
| 2004-05-05 14:00:00 | AAPL | Stock | 0.4745 | 0.4777 | 0.4738 | 0.4759 | 43369088.0 |
| 2004-05-05 15:00:00 | AAPL | Stock | 0.4757 | 0.4768 | 0.4732 | 0.4757 | 45491488.0 |
| 2004-05-05 16:00:00 | AAPL | Stock | 0.4757 | 0.4759 | 0.4748 | 0.4759 | 8145704.0 |
| 2004-05-05 17:00:00 | AAPL | Stock | 0.4746 | 0.4759 | 0.4746 | 0.4755 | 829920.0 |
| 2004-05-05 08:00:00 | MSFT | Stock | 26.3 | 26.37 | 26.3 | 26.37 | 49960.0 |
| 2004-05-05 09:00:00 | MSFT | Stock | 26.38 | 26.42 | 26.27 | 26.41 | 6042720.0 |
| 2004-05-05 10:00:00 | MSFT | Stock | 26.41 | 26.6 | 26.32 | 26.49 | 9677192.0 |
| 2004-05-05 11:00:00 | MSFT | Stock | 26.49 | 26.49 | 26.37 | 26.42 | 5022039.0 |
| 2004-05-05 12:00:00 | MSFT | Stock | 26.42 | 26.47 | 26.27 | 26.3 | 5986283.0 |
| 2004-05-05 13:00:00 | MSFT | Stock | 26.3 | 26.4 | 26.25 | 26.37 | 4696313.0 |
| 2004-05-05 14:00:00 | MSFT | Stock | 26.38 | 26.45 | 26.32 | 26.41 | 7825463.0 |
| 2004-05-05 15:00:00 | MSFT | Stock | 26.41 | 26.45 | 26.28 | 26.28 | 9218054.0 |
| 2004-05-05 16:00:00 | MSFT | Stock | 26.28 | 26.33 | 26.27 | 26.28 | 875612.0 |
| 2004-05-05 17:00:00 | MSFT | Stock | 26.3 | 26.32 | 26.28 | 26.3 | 1089144.0 |
| 2004-05-05 18:00:00 | MSFT | Stock | 26.31 | 26.31 | 26.29 | 26.29 | 5219.0 |
| 2004-05-05 08:00:00 | NVDA | Stock | 0.1796 | 0.1796 | 0.1796 | 0.1796 | 48000.0 |
| 2004-05-05 09:00:00 | NVDA | Stock | 0.1803 | 0.1803 | 0.1782 | 0.179 | 66226080.0 |
| 2004-05-05 10:00:00 | NVDA | Stock | 0.179 | 0.1824 | 0.1787 | 0.1815 | 129202080.0 |
| 2004-05-05 11:00:00 | NVDA | Stock | 0.1815 | 0.1827 | 0.1805 | 0.1821 | 43310520.0 |
| 2004-05-05 12:00:00 | NVDA | Stock | 0.1821 | 0.1824 | 0.1816 | 0.1817 | 54063240.0 |
| 2004-05-05 13:00:00 | NVDA | Stock | 0.1818 | 0.1821 | 0.1807 | 0.1817 | 30520440.0 |
| 2004-05-05 14:00:00 | NVDA | Stock | 0.1816 | 0.1822 | 0.1808 | 0.1819 | 46366320.0 |
| 2004-05-05 15:00:00 | NVDA | Stock | 0.1818 | 0.1827 | 0.1802 | 0.1802 | 82737720.0 |
| 2004-05-05 16:00:00 | NVDA | Stock | 0.1805 | 0.1813 | 0.18 | 0.1808 | 3681000.0 |
| 2004-05-05 18:00:00 | NVDA | Stock | 0.1811 | 0.1812 | 0.1811 | 0.1812 | 107400.0 |
| 2004-05-05 08:00:00 | AMZN | Stock | 2.195 | 2.206 | 2.195 | 2.206 | 3012000.0 |
| 2004-05-05 09:00:00 | AMZN | Stock | 2.2 | 2.2385 | 2.1955 | 2.234 | 12208940.0 |
| 2004-05-05 10:00:00 | AMZN | Stock | 2.234 | 2.2525 | 2.223 | 2.2365 | 23570720.0 |
| 2004-05-05 11:00:00 | AMZN | Stock | 2.236 | 2.2425 | 2.23 | 2.235 | 7936160.0 |
| 2004-05-05 12:00:00 | AMZN | Stock | 2.235 | 2.2365 | 2.2015 | 2.212 | 11469380.0 |
| 2004-05-05 13:00:00 | AMZN | Stock | 2.211 | 2.2155 | 2.2025 | 2.2155 | 9228420.0 |
| 2004-05-05 14:00:00 | AMZN | Stock | 2.215 | 2.2285 | 2.215 | 2.2235 | 10403820.0 |
| 2004-05-05 15:00:00 | AMZN | Stock | 2.222 | 2.225 | 2.211 | 2.2115 | 12504820.0 |
| 2004-05-05 16:00:00 | AMZN | Stock | 2.2125 | 2.216 | 2.2105 | 2.213 | 492660.0 |
| 2004-05-05 17:00:00 | AMZN | Stock | 2.2165 | 2.2165 | 2.213 | 2.213 | 82440.0 |
| 2004-05-05 09:00:00 | CL | Stock | 29.28 | 29.285 | 29.08 | 29.135 | 424000.0 |
| 2004-05-05 10:00:00 | CL | Stock | 29.135 | 29.38 | 29.115 | 29.21 | 622400.0 |
| 2004-05-05 11:00:00 | CL | Stock | 29.215 | 29.34 | 29.21 | 29.29 | 464600.0 |
| 2004-05-05 12:00:00 | CL | Stock | 29.29 | 29.33 | 29.175 | 29.205 | 458800.0 |
| 2004-05-05 13:00:00 | CL | Stock | 29.21 | 29.31 | 29.14 | 29.275 | 391000.0 |
| 2004-05-05 14:00:00 | CL | Stock | 29.29 | 29.29 | 29.195 | 29.25 | 386000.0 |
| 2004-05-05 15:00:00 | CL | Stock | 29.25 | 29.375 | 29.215 | 29.305 | 590200.0 |
| 2004-05-05 16:00:00 | CL | Stock | 29.315 | 29.315 | 29.288 | 29.2915 | 76600.0 |
| 2004-05-05 17:00:00 | CL | Stock | 29.29 | 29.29 | 29.29 | 29.29 | 200.0 |
> showing 50 of 23,765 rows — these rows as CSV