PREVIEW / stock_1hour / 2004-05-11
file: by_date/stock_1hour/2004/2004-05-11.parquet size: 511 KB rows: 23,941 symbols: 1,774
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-11 08:00:00 | AAPL | Stock | 0.4723 | 0.473 | 0.4723 | 0.473 | 285600.0 |
| 2004-05-11 09:00:00 | AAPL | Stock | 0.473 | 0.4818 | 0.4705 | 0.4809 | 53264960.0 |
| 2004-05-11 10:00:00 | AAPL | Stock | 0.4809 | 0.4816 | 0.4738 | 0.4795 | 39456480.0 |
| 2004-05-11 11:00:00 | AAPL | Stock | 0.4796 | 0.4854 | 0.4796 | 0.4845 | 32057032.0 |
| 2004-05-11 12:00:00 | AAPL | Stock | 0.4845 | 0.4845 | 0.4814 | 0.482 | 16587424.0 |
| 2004-05-11 13:00:00 | AAPL | Stock | 0.482 | 0.4841 | 0.478 | 0.4798 | 23762704.0 |
| 2004-05-11 14:00:00 | AAPL | Stock | 0.4798 | 0.4846 | 0.4798 | 0.4839 | 23338448.0 |
| 2004-05-11 15:00:00 | AAPL | Stock | 0.4839 | 0.4854 | 0.4802 | 0.4836 | 47840296.0 |
| 2004-05-11 16:00:00 | AAPL | Stock | 0.4836 | 0.4846 | 0.4773 | 0.4846 | 7106848.0 |
| 2004-05-11 08:00:00 | MSFT | Stock | 25.935 | 26.1 | 25.935 | 26.07 | 54800.0 |
| 2004-05-11 09:00:00 | MSFT | Stock | 26.1 | 26.11 | 25.95 | 26.02 | 7020509.0 |
| 2004-05-11 10:00:00 | MSFT | Stock | 26.01 | 26.1 | 25.94 | 25.99 | 7410205.0 |
| 2004-05-11 11:00:00 | MSFT | Stock | 25.99 | 26.07 | 25.96 | 25.98 | 4879394.0 |
| 2004-05-11 12:00:00 | MSFT | Stock | 25.98 | 26.01 | 25.83 | 25.84 | 5147757.0 |
| 2004-05-11 13:00:00 | MSFT | Stock | 25.84 | 25.88 | 25.79 | 25.85 | 5881857.0 |
| 2004-05-11 14:00:00 | MSFT | Stock | 25.85 | 25.95 | 25.84 | 25.9 | 6933087.0 |
| 2004-05-11 15:00:00 | MSFT | Stock | 25.91 | 25.99 | 25.86 | 25.95 | 10954251.0 |
| 2004-05-11 16:00:00 | MSFT | Stock | 25.95 | 26.065 | 25.71 | 25.98 | 476256.0 |
| 2004-05-11 17:00:00 | MSFT | Stock | 25.98 | 25.98 | 25.9 | 25.92 | 36942.0 |
| 2004-05-11 18:00:00 | MSFT | Stock | 25.9 | 25.91 | 25.87 | 25.87 | 14700.0 |
| 2004-05-11 08:00:00 | NVDA | Stock | 0.1783 | 0.1808 | 0.1783 | 0.1808 | 132000.0 |
| 2004-05-11 09:00:00 | NVDA | Stock | 0.1788 | 0.1809 | 0.1785 | 0.1802 | 54145320.0 |
| 2004-05-11 10:00:00 | NVDA | Stock | 0.1802 | 0.1824 | 0.1802 | 0.1808 | 91852800.0 |
| 2004-05-11 11:00:00 | NVDA | Stock | 0.1809 | 0.1829 | 0.1809 | 0.1822 | 20345640.0 |
| 2004-05-11 12:00:00 | NVDA | Stock | 0.1823 | 0.1826 | 0.1803 | 0.1807 | 30893400.0 |
| 2004-05-11 13:00:00 | NVDA | Stock | 0.1807 | 0.1812 | 0.1783 | 0.1794 | 44160360.0 |
| 2004-05-11 14:00:00 | NVDA | Stock | 0.1794 | 0.1811 | 0.1793 | 0.1806 | 31878120.0 |
| 2004-05-11 15:00:00 | NVDA | Stock | 0.1807 | 0.1814 | 0.18 | 0.1814 | 57988440.0 |
| 2004-05-11 16:00:00 | NVDA | Stock | 0.1814 | 0.1816 | 0.18 | 0.1807 | 3747360.0 |
| 2004-05-11 17:00:00 | NVDA | Stock | 0.1804 | 0.1804 | 0.1804 | 0.1804 | 120000.0 |
| 2004-05-11 18:00:00 | NVDA | Stock | 0.1803 | 0.1803 | 0.1801 | 0.1801 | 120000.0 |
| 2004-05-11 08:00:00 | AMZN | Stock | 2.063 | 2.0995 | 2.063 | 2.0995 | 174000.0 |
| 2004-05-11 09:00:00 | AMZN | Stock | 2.1 | 2.1185 | 2.0935 | 2.1145 | 25234580.0 |
| 2004-05-11 10:00:00 | AMZN | Stock | 2.1145 | 2.1355 | 2.113 | 2.131 | 29675420.0 |
| 2004-05-11 11:00:00 | AMZN | Stock | 2.132 | 2.152 | 2.1305 | 2.1455 | 19482900.0 |
| 2004-05-11 12:00:00 | AMZN | Stock | 2.147 | 2.147 | 2.13 | 2.141 | 7234960.0 |
| 2004-05-11 13:00:00 | AMZN | Stock | 2.141 | 2.141 | 2.12 | 2.129 | 9978800.0 |
| 2004-05-11 14:00:00 | AMZN | Stock | 2.1285 | 2.1375 | 2.126 | 2.132 | 9264600.0 |
| 2004-05-11 15:00:00 | AMZN | Stock | 2.133 | 2.142 | 2.1195 | 2.135 | 21463100.0 |
| 2004-05-11 16:00:00 | AMZN | Stock | 2.137 | 2.137 | 2.1265 | 2.137 | 2047320.0 |
| 2004-05-11 17:00:00 | AMZN | Stock | 2.127 | 2.1275 | 2.125 | 2.125 | 130000.0 |
| 2004-05-11 09:00:00 | CL | Stock | 28.655 | 28.655 | 28.35 | 28.405 | 554000.0 |
| 2004-05-11 10:00:00 | CL | Stock | 28.395 | 28.395 | 28.2 | 28.245 | 681000.0 |
| 2004-05-11 11:00:00 | CL | Stock | 28.245 | 28.345 | 28.175 | 28.325 | 455600.0 |
| 2004-05-11 12:00:00 | CL | Stock | 28.3 | 28.325 | 28.26 | 28.275 | 237000.0 |
| 2004-05-11 13:00:00 | CL | Stock | 28.275 | 28.33 | 28.175 | 28.255 | 281400.0 |
| 2004-05-11 14:00:00 | CL | Stock | 28.255 | 28.485 | 28.25 | 28.38 | 323200.0 |
| 2004-05-11 15:00:00 | CL | Stock | 28.38 | 28.565 | 28.37 | 28.545 | 726800.0 |
| 2004-05-11 16:00:00 | CL | Stock | 28.535 | 28.535 | 28.535 | 28.535 | 1600.0 |
| 2004-05-11 17:00:00 | CL | Stock | 28.54 | 28.54 | 28.54 | 28.54 | 48000.0 |
> showing 50 of 23,941 rows — these rows as CSV