PREVIEW / stock_1hour / 2004-03-17
file: by_date/stock_1hour/2004/2004-03-17.parquet size: 507 KB rows: 23,936 symbols: 1,745
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-03-17 08:00:00 | AAPL | Stock | 0.4607 | 0.4625 | 0.4598 | 0.4618 | 116480.0 |
| 2004-03-17 09:00:00 | AAPL | Stock | 0.4616 | 0.4686 | 0.4604 | 0.4652 | 69297088.0 |
| 2004-03-17 10:00:00 | AAPL | Stock | 0.4652 | 0.4711 | 0.4627 | 0.4688 | 70737016.0 |
| 2004-03-17 11:00:00 | AAPL | Stock | 0.4691 | 0.4695 | 0.462 | 0.4625 | 83228488.0 |
| 2004-03-17 12:00:00 | AAPL | Stock | 0.4625 | 0.4643 | 0.4609 | 0.4629 | 39187792.0 |
| 2004-03-17 13:00:00 | AAPL | Stock | 0.463 | 0.465 | 0.4621 | 0.463 | 23330776.0 |
| 2004-03-17 14:00:00 | AAPL | Stock | 0.4629 | 0.4643 | 0.4627 | 0.4643 | 30579528.0 |
| 2004-03-17 15:00:00 | AAPL | Stock | 0.4643 | 0.4675 | 0.4629 | 0.4673 | 56658056.0 |
| 2004-03-17 16:00:00 | AAPL | Stock | 0.4673 | 0.4677 | 0.4646 | 0.4664 | 2374400.0 |
| 2004-03-17 17:00:00 | AAPL | Stock | 0.4661 | 0.4666 | 0.4661 | 0.4666 | 223440.0 |
| 2004-03-17 08:00:00 | MSFT | Stock | 25.25 | 25.34 | 25.22 | 25.31 | 74172.0 |
| 2004-03-17 09:00:00 | MSFT | Stock | 25.3 | 25.36 | 25.24 | 25.28 | 6496837.0 |
| 2004-03-17 10:00:00 | MSFT | Stock | 25.27 | 25.46 | 25.23 | 25.33 | 7612887.0 |
| 2004-03-17 11:00:00 | MSFT | Stock | 25.33 | 25.39 | 25.3 | 25.33 | 6328126.0 |
| 2004-03-17 12:00:00 | MSFT | Stock | 25.33 | 25.35 | 25.26 | 25.3 | 5293631.0 |
| 2004-03-17 13:00:00 | MSFT | Stock | 25.3 | 25.32 | 25.17 | 25.18 | 6531365.0 |
| 2004-03-17 14:00:00 | MSFT | Stock | 25.18 | 25.21 | 25.11 | 25.17 | 10634089.0 |
| 2004-03-17 15:00:00 | MSFT | Stock | 25.17 | 25.26 | 25.13 | 25.13 | 10698058.0 |
| 2004-03-17 16:00:00 | MSFT | Stock | 25.14 | 25.17 | 25.12 | 25.15 | 551088.0 |
| 2004-03-17 17:00:00 | MSFT | Stock | 25.16 | 25.16 | 25.1372 | 25.15 | 28960.0 |
| 2004-03-17 18:00:00 | MSFT | Stock | 25.16 | 25.16 | 25.15 | 25.15 | 2100.0 |
| 2004-03-17 08:00:00 | NVDA | Stock | 0.1821 | 0.1825 | 0.1821 | 0.1825 | 180000.0 |
| 2004-03-17 09:00:00 | NVDA | Stock | 0.1822 | 0.1865 | 0.1818 | 0.185 | 157755000.0 |
| 2004-03-17 10:00:00 | NVDA | Stock | 0.1849 | 0.1857 | 0.1838 | 0.1842 | 70494360.0 |
| 2004-03-17 11:00:00 | NVDA | Stock | 0.1842 | 0.1861 | 0.1841 | 0.185 | 58783560.0 |
| 2004-03-17 12:00:00 | NVDA | Stock | 0.1851 | 0.1856 | 0.1842 | 0.1848 | 56396280.0 |
| 2004-03-17 13:00:00 | NVDA | Stock | 0.1848 | 0.1858 | 0.1846 | 0.1852 | 54578880.0 |
| 2004-03-17 14:00:00 | NVDA | Stock | 0.1853 | 0.1862 | 0.1847 | 0.1861 | 35597280.0 |
| 2004-03-17 15:00:00 | NVDA | Stock | 0.1861 | 0.1866 | 0.1847 | 0.1847 | 76851600.0 |
| 2004-03-17 16:00:00 | NVDA | Stock | 0.1847 | 0.1854 | 0.1846 | 0.1849 | 1651080.0 |
| 2004-03-17 17:00:00 | NVDA | Stock | 0.1849 | 0.1849 | 0.1837 | 0.1849 | 180000.0 |
| 2004-03-17 08:00:00 | AMZN | Stock | 2.104 | 2.15 | 2.104 | 2.1425 | 919200.0 |
| 2004-03-17 09:00:00 | AMZN | Stock | 2.1445 | 2.1725 | 2.1355 | 2.158 | 30654580.0 |
| 2004-03-17 10:00:00 | AMZN | Stock | 2.158 | 2.1645 | 2.1445 | 2.1515 | 17226840.0 |
| 2004-03-17 11:00:00 | AMZN | Stock | 2.1515 | 2.1645 | 2.1395 | 2.1425 | 12333940.0 |
| 2004-03-17 12:00:00 | AMZN | Stock | 2.1415 | 2.145 | 2.1375 | 2.143 | 4446580.0 |
| 2004-03-17 13:00:00 | AMZN | Stock | 2.143 | 2.1465 | 2.13 | 2.1365 | 7793400.0 |
| 2004-03-17 14:00:00 | AMZN | Stock | 2.1365 | 2.1435 | 2.1295 | 2.14 | 8457960.0 |
| 2004-03-17 15:00:00 | AMZN | Stock | 2.1405 | 2.144 | 2.136 | 2.142 | 16409800.0 |
| 2004-03-17 16:00:00 | AMZN | Stock | 2.1385 | 2.1425 | 2.1375 | 2.1395 | 757180.0 |
| 2004-03-17 17:00:00 | AMZN | Stock | 2.1395 | 2.14 | 2.1375 | 2.1395 | 128000.0 |
| 2004-03-17 18:00:00 | AMZN | Stock | 2.1395 | 2.1395 | 2.1395 | 2.1395 | 2000.0 |
| 2004-03-17 09:00:00 | CL | Stock | 27.375 | 27.455 | 27.33 | 27.425 | 484000.0 |
| 2004-03-17 10:00:00 | CL | Stock | 27.425 | 27.47 | 27.335 | 27.335 | 612800.0 |
| 2004-03-17 11:00:00 | CL | Stock | 27.345 | 27.415 | 27.325 | 27.355 | 696800.0 |
| 2004-03-17 12:00:00 | CL | Stock | 27.35 | 27.395 | 27.31 | 27.36 | 548000.0 |
| 2004-03-17 13:00:00 | CL | Stock | 27.36 | 27.5 | 27.35 | 27.45 | 388400.0 |
| 2004-03-17 14:00:00 | CL | Stock | 27.445 | 27.59 | 27.445 | 27.535 | 490200.0 |
| 2004-03-17 15:00:00 | CL | Stock | 27.535 | 27.54 | 27.485 | 27.505 | 493400.0 |
| 2004-03-17 16:00:00 | CL | Stock | 27.5 | 27.5 | 27.5 | 27.5 | 1600.0 |
> showing 50 of 23,936 rows — these rows as CSV