PREVIEW / stock_1hour / 2005-03-03
file: by_date/stock_1hour/2005/2005-03-03.parquet size: 545 KB rows: 25,843 symbols: 1,947
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-03-03 08:00:00 | AAPL | Stock | 1.5875 | 1.5875 | 1.5768 | 1.5836 | 1195040.0 |
| 2005-03-03 09:00:00 | AAPL | Stock | 1.5836 | 1.5882 | 1.5493 | 1.5554 | 96955740.0 |
| 2005-03-03 10:00:00 | AAPL | Stock | 1.5557 | 1.5589 | 1.4982 | 1.5157 | 373026192.0 |
| 2005-03-03 11:00:00 | AAPL | Stock | 1.5161 | 1.5204 | 1.4736 | 1.4746 | 324855412.0 |
| 2005-03-03 12:00:00 | AAPL | Stock | 1.4739 | 1.5 | 1.4721 | 1.4982 | 220039232.0 |
| 2005-03-03 13:00:00 | AAPL | Stock | 1.4982 | 1.4982 | 1.4864 | 1.4936 | 84371952.0 |
| 2005-03-03 14:00:00 | AAPL | Stock | 1.4932 | 1.5061 | 1.4875 | 1.5029 | 144024440.0 |
| 2005-03-03 15:00:00 | AAPL | Stock | 1.5029 | 1.5321 | 1.4893 | 1.4929 | 146242684.0 |
| 2005-03-03 16:00:00 | AAPL | Stock | 1.4932 | 1.5057 | 1.4889 | 1.4925 | 3574368.0 |
| 2005-03-03 17:00:00 | AAPL | Stock | 1.4911 | 1.4939 | 1.4893 | 1.4921 | 463820.0 |
| 2005-03-03 18:00:00 | AAPL | Stock | 1.4921 | 1.508 | 1.4911 | 1.4946 | 1040004.0 |
| 2005-03-03 08:00:00 | MSFT | Stock | 25.34 | 25.34 | 25.31 | 25.31 | 2890.0 |
| 2005-03-03 09:00:00 | MSFT | Stock | 25.32 | 25.34 | 25.24 | 25.24 | 4111020.0 |
| 2005-03-03 10:00:00 | MSFT | Stock | 25.24 | 25.28 | 25.19 | 25.24 | 9295124.0 |
| 2005-03-03 11:00:00 | MSFT | Stock | 25.24 | 25.25 | 25.14 | 25.16 | 10025215.0 |
| 2005-03-03 12:00:00 | MSFT | Stock | 25.16 | 25.2 | 25.15 | 25.17 | 6371387.0 |
| 2005-03-03 13:00:00 | MSFT | Stock | 25.17 | 25.24 | 25.15 | 25.22 | 5310425.0 |
| 2005-03-03 14:00:00 | MSFT | Stock | 25.23 | 25.26 | 25.199 | 25.2 | 4810804.0 |
| 2005-03-03 15:00:00 | MSFT | Stock | 25.2 | 25.21 | 25.15 | 25.17 | 6996429.0 |
| 2005-03-03 16:00:00 | MSFT | Stock | 25.16 | 25.17 | 25.1 | 25.15 | 2010921.0 |
| 2005-03-03 17:00:00 | MSFT | Stock | 25.15 | 25.16 | 25.13 | 25.13 | 18165.0 |
| 2005-03-03 18:00:00 | MSFT | Stock | 25.15 | 25.15 | 25.15 | 25.15 | 1000.0 |
| 2005-03-03 08:00:00 | NVDA | Stock | 0.2333 | 0.2333 | 0.2333 | 0.2333 | 12000.0 |
| 2005-03-03 09:00:00 | NVDA | Stock | 0.2347 | 0.2355 | 0.2314 | 0.2321 | 151880400.0 |
| 2005-03-03 10:00:00 | NVDA | Stock | 0.2321 | 0.2331 | 0.2273 | 0.231 | 216629520.0 |
| 2005-03-03 11:00:00 | NVDA | Stock | 0.231 | 0.231 | 0.2275 | 0.2276 | 98494080.0 |
| 2005-03-03 12:00:00 | NVDA | Stock | 0.2277 | 0.2296 | 0.2276 | 0.2292 | 51020880.0 |
| 2005-03-03 13:00:00 | NVDA | Stock | 0.2292 | 0.23 | 0.2285 | 0.2292 | 37346280.0 |
| 2005-03-03 14:00:00 | NVDA | Stock | 0.2292 | 0.2313 | 0.2292 | 0.2307 | 58937040.0 |
| 2005-03-03 15:00:00 | NVDA | Stock | 0.2308 | 0.2322 | 0.2296 | 0.2307 | 73814040.0 |
| 2005-03-03 16:00:00 | NVDA | Stock | 0.2307 | 0.2316 | 0.2303 | 0.2307 | 13533960.0 |
| 2005-03-03 17:00:00 | NVDA | Stock | 0.2313 | 0.2313 | 0.2313 | 0.2313 | 60000.0 |
| 2005-03-03 18:00:00 | NVDA | Stock | 0.2307 | 0.2313 | 0.2307 | 0.2313 | 96000.0 |
| 2005-03-03 08:00:00 | AMZN | Stock | 1.775 | 1.7885 | 1.775 | 1.7885 | 22000.0 |
| 2005-03-03 09:00:00 | AMZN | Stock | 1.775 | 1.796 | 1.775 | 1.7855 | 11510400.0 |
| 2005-03-03 10:00:00 | AMZN | Stock | 1.785 | 1.793 | 1.782 | 1.7894 | 16856140.0 |
| 2005-03-03 11:00:00 | AMZN | Stock | 1.789 | 1.7945 | 1.782 | 1.7825 | 17566820.0 |
| 2005-03-03 12:00:00 | AMZN | Stock | 1.7825 | 1.7875 | 1.77 | 1.777 | 16046760.0 |
| 2005-03-03 13:00:00 | AMZN | Stock | 1.777 | 1.7906 | 1.7765 | 1.788 | 10865880.0 |
| 2005-03-03 14:00:00 | AMZN | Stock | 1.7875 | 1.798 | 1.7875 | 1.7918 | 9009920.0 |
| 2005-03-03 15:00:00 | AMZN | Stock | 1.792 | 1.7935 | 1.777 | 1.7835 | 17150340.0 |
| 2005-03-03 16:00:00 | AMZN | Stock | 1.7835 | 1.784 | 1.7775 | 1.7825 | 698540.0 |
| 2005-03-03 17:00:00 | AMZN | Stock | 1.7825 | 1.7995 | 1.78 | 1.7995 | 37100.0 |
| 2005-03-03 09:00:00 | CL | Stock | 26.45 | 26.57 | 26.42 | 26.49 | 214800.0 |
| 2005-03-03 10:00:00 | CL | Stock | 26.495 | 26.555 | 26.455 | 26.5 | 442800.0 |
| 2005-03-03 11:00:00 | CL | Stock | 26.5 | 26.5 | 26.25 | 26.27 | 469400.0 |
| 2005-03-03 12:00:00 | CL | Stock | 26.25 | 26.285 | 26.155 | 26.205 | 352800.0 |
| 2005-03-03 13:00:00 | CL | Stock | 26.19 | 26.335 | 26.19 | 26.23 | 359200.0 |
| 2005-03-03 14:00:00 | CL | Stock | 26.215 | 26.35 | 26.185 | 26.315 | 380200.0 |
| 2005-03-03 15:00:00 | CL | Stock | 26.31 | 26.355 | 26.305 | 26.325 | 460600.0 |
> showing 50 of 25,843 rows — these rows as CSV