PREVIEW / stock_1hour / 2003-07-08
file: by_date/stock_1hour/2003/2003-07-08.parquet size: 471 KB rows: 22,260 symbols: 1,596
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 |
|---|---|---|---|---|---|---|---|
| 2003-07-08 08:00:00 | AAPL | Stock | 0.3484 | 0.3484 | 0.3484 | 0.3484 | 5600.0 |
| 2003-07-08 09:00:00 | AAPL | Stock | 0.355 | 0.3552 | 0.348 | 0.3489 | 29192688.0 |
| 2003-07-08 10:00:00 | AAPL | Stock | 0.3491 | 0.3596 | 0.3486 | 0.3596 | 32108888.0 |
| 2003-07-08 11:00:00 | AAPL | Stock | 0.3595 | 0.3627 | 0.3593 | 0.3627 | 32707528.0 |
| 2003-07-08 12:00:00 | AAPL | Stock | 0.3627 | 0.3627 | 0.3574 | 0.3605 | 24549616.0 |
| 2003-07-08 13:00:00 | AAPL | Stock | 0.3604 | 0.3614 | 0.3589 | 0.3593 | 18475576.0 |
| 2003-07-08 14:00:00 | AAPL | Stock | 0.3593 | 0.3638 | 0.358 | 0.3636 | 22077776.0 |
| 2003-07-08 15:00:00 | AAPL | Stock | 0.3638 | 0.3661 | 0.3632 | 0.3645 | 55315904.0 |
| 2003-07-08 16:00:00 | AAPL | Stock | 0.3645 | 0.3663 | 0.3643 | 0.3643 | 4047288.0 |
| 2003-07-08 17:00:00 | AAPL | Stock | 0.3646 | 0.3646 | 0.3645 | 0.3645 | 33600.0 |
| 2003-07-08 08:00:00 | MSFT | Stock | 27.3 | 27.6 | 27.2 | 27.25 | 253041.0 |
| 2003-07-08 09:00:00 | MSFT | Stock | 27.25 | 27.52 | 27.201 | 27.3211 | 8839862.0 |
| 2003-07-08 10:00:00 | MSFT | Stock | 27.32 | 27.45 | 27.249 | 27.42 | 8653734.0 |
| 2003-07-08 11:00:00 | MSFT | Stock | 27.42 | 27.441 | 27.34 | 27.41 | 6428518.0 |
| 2003-07-08 12:00:00 | MSFT | Stock | 27.41 | 27.41 | 27.27 | 27.38 | 5009905.0 |
| 2003-07-08 13:00:00 | MSFT | Stock | 27.38 | 27.4 | 27.31 | 27.34 | 4099389.0 |
| 2003-07-08 14:00:00 | MSFT | Stock | 27.35 | 27.48 | 27.28 | 27.47 | 5455248.0 |
| 2003-07-08 15:00:00 | MSFT | Stock | 27.479 | 27.8 | 27.45 | 27.667 | 15393901.0 |
| 2003-07-08 16:00:00 | MSFT | Stock | 27.65 | 27.75 | 27.35 | 27.6 | 1929925.0 |
| 2003-07-08 17:00:00 | MSFT | Stock | 27.6 | 27.62 | 27.45 | 27.5 | 268414.0 |
| 2003-07-08 18:00:00 | MSFT | Stock | 27.5 | 27.538 | 27.4489 | 27.51 | 41244.0 |
| 2003-07-08 08:00:00 | NVDA | Stock | 0.2084 | 0.2087 | 0.2068 | 0.2069 | 1524000.0 |
| 2003-07-08 09:00:00 | NVDA | Stock | 0.2072 | 0.2092 | 0.2025 | 0.2047 | 94248840.0 |
| 2003-07-08 10:00:00 | NVDA | Stock | 0.2045 | 0.2081 | 0.2033 | 0.2067 | 113894760.0 |
| 2003-07-08 11:00:00 | NVDA | Stock | 0.2067 | 0.2081 | 0.2058 | 0.2069 | 78319440.0 |
| 2003-07-08 12:00:00 | NVDA | Stock | 0.2069 | 0.2073 | 0.2047 | 0.2069 | 54150240.0 |
| 2003-07-08 13:00:00 | NVDA | Stock | 0.2067 | 0.2072 | 0.2055 | 0.206 | 44334240.0 |
| 2003-07-08 14:00:00 | NVDA | Stock | 0.206 | 0.207 | 0.2054 | 0.2067 | 32816520.0 |
| 2003-07-08 15:00:00 | NVDA | Stock | 0.2066 | 0.2076 | 0.2058 | 0.2063 | 118114200.0 |
| 2003-07-08 16:00:00 | NVDA | Stock | 0.2062 | 0.2067 | 0.2057 | 0.2064 | 7182000.0 |
| 2003-07-08 17:00:00 | NVDA | Stock | 0.2061 | 0.2065 | 0.2061 | 0.2062 | 1427400.0 |
| 2003-07-08 18:00:00 | NVDA | Stock | 0.2062 | 0.2062 | 0.2062 | 0.2062 | 24000.0 |
| 2003-07-08 08:00:00 | AMZN | Stock | 1.9475 | 1.9476 | 1.94 | 1.9416 | 65600.0 |
| 2003-07-08 09:00:00 | AMZN | Stock | 1.9415 | 1.9895 | 1.9375 | 1.9604 | 28887120.0 |
| 2003-07-08 10:00:00 | AMZN | Stock | 1.9605 | 1.9815 | 1.938 | 1.975 | 38649620.0 |
| 2003-07-08 11:00:00 | AMZN | Stock | 1.975 | 2.0415 | 1.968 | 2.0365 | 51853260.0 |
| 2003-07-08 12:00:00 | AMZN | Stock | 2.036 | 2.0375 | 2.0065 | 2.0155 | 40266340.0 |
| 2003-07-08 13:00:00 | AMZN | Stock | 2.0155 | 2.0255 | 2.0125 | 2.0132 | 16813880.0 |
| 2003-07-08 14:00:00 | AMZN | Stock | 2.013 | 2.0205 | 2.0075 | 2.015 | 17399940.0 |
| 2003-07-08 15:00:00 | AMZN | Stock | 2.015 | 2.03 | 2.0125 | 2.024 | 28890900.0 |
| 2003-07-08 16:00:00 | AMZN | Stock | 2.024 | 2.0285 | 2.0225 | 2.0245 | 1717520.0 |
| 2003-07-08 17:00:00 | AMZN | Stock | 1.9958 | 2.0275 | 1.9958 | 2.0275 | 1804000.0 |
| 2003-07-08 18:00:00 | AMZN | Stock | 2.0274 | 2.0274 | 2.025 | 2.0255 | 30400.0 |
| 2003-07-08 09:00:00 | CL | Stock | 28.875 | 28.895 | 28.83 | 28.86 | 310600.0 |
| 2003-07-08 10:00:00 | CL | Stock | 28.855 | 28.865 | 28.65 | 28.8 | 1019600.0 |
| 2003-07-08 11:00:00 | CL | Stock | 28.81 | 28.84 | 28.75 | 28.785 | 358000.0 |
| 2003-07-08 12:00:00 | CL | Stock | 28.765 | 28.925 | 28.72 | 28.925 | 454400.0 |
| 2003-07-08 13:00:00 | CL | Stock | 28.93 | 28.95 | 28.915 | 28.915 | 326400.0 |
| 2003-07-08 14:00:00 | CL | Stock | 28.92 | 29.015 | 28.87 | 29.005 | 477800.0 |
| 2003-07-08 15:00:00 | CL | Stock | 29.005 | 29.085 | 28.95 | 28.98 | 581400.0 |
> showing 50 of 22,260 rows — these rows as CSV