PREVIEW / stock_1hour / 2008-09-29
file: by_date/stock_1hour/2008/2008-09-29.parquet size: 899 KB rows: 45,699 symbols: 3,378
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 |
|---|---|---|---|---|---|---|---|
| 2008-09-29 06:00:00 | AAPL | Stock | 4.4464 | 4.4464 | 4.3571 | 4.3571 | 99232.0 |
| 2008-09-29 07:00:00 | AAPL | Stock | 4.3396 | 4.3418 | 4.2854 | 4.3 | 2491048.0 |
| 2008-09-29 08:00:00 | AAPL | Stock | 4.3054 | 4.3571 | 4.2857 | 4.3161 | 8346492.0 |
| 2008-09-29 09:00:00 | AAPL | Stock | 4.3182 | 4.3304 | 3.8929 | 3.9911 | 414278424.0 |
| 2008-09-29 10:00:00 | AAPL | Stock | 3.9907 | 4.0193 | 3.7775 | 3.9179 | 551935440.0 |
| 2008-09-29 11:00:00 | AAPL | Stock | 3.9141 | 4.0 | 3.8875 | 3.9314 | 310178540.0 |
| 2008-09-29 12:00:00 | AAPL | Stock | 3.9314 | 3.9807 | 3.9068 | 3.9643 | 198214744.0 |
| 2008-09-29 13:00:00 | AAPL | Stock | 3.9643 | 4.0121 | 3.5925 | 3.7946 | 342116628.0 |
| 2008-09-29 14:00:00 | AAPL | Stock | 3.7946 | 3.9068 | 3.7118 | 3.7521 | 326868920.0 |
| 2008-09-29 15:00:00 | AAPL | Stock | 3.7518 | 3.8575 | 3.67 | 3.7814 | 366233756.0 |
| 2008-09-29 16:00:00 | AAPL | Stock | 3.7821 | 3.9067 | 3.75 | 3.75 | 54248572.0 |
| 2008-09-29 17:00:00 | AAPL | Stock | 3.7593 | 3.7593 | 3.7139 | 3.725 | 9629900.0 |
| 2008-09-29 18:00:00 | AAPL | Stock | 3.725 | 3.7339 | 3.7143 | 3.7143 | 1121176.0 |
| 2008-09-29 19:00:00 | AAPL | Stock | 3.7143 | 3.7225 | 3.6929 | 3.6929 | 907536.0 |
| 2008-09-29 07:00:00 | MSFT | Stock | 26.95 | 27.1 | 26.77 | 27.0 | 7950.0 |
| 2008-09-29 08:00:00 | MSFT | Stock | 26.93 | 27.05 | 26.91 | 27.0 | 21339.0 |
| 2008-09-29 09:00:00 | MSFT | Stock | 27.0 | 27.66 | 26.75 | 26.88 | 10245165.0 |
| 2008-09-29 10:00:00 | MSFT | Stock | 26.87 | 26.95 | 26.47 | 26.882 | 16868363.0 |
| 2008-09-29 11:00:00 | MSFT | Stock | 26.88 | 26.91 | 26.6 | 26.71 | 10617739.0 |
| 2008-09-29 12:00:00 | MSFT | Stock | 26.71 | 26.86 | 26.6 | 26.72 | 10167223.0 |
| 2008-09-29 13:00:00 | MSFT | Stock | 26.73 | 26.92 | 25.66 | 26.16 | 18732995.0 |
| 2008-09-29 14:00:00 | MSFT | Stock | 26.17 | 26.52 | 25.5 | 25.88 | 23851603.0 |
| 2008-09-29 15:00:00 | MSFT | Stock | 25.88 | 26.55 | 25.6 | 25.85 | 25946289.0 |
| 2008-09-29 16:00:00 | MSFT | Stock | 25.84 | 26.4 | 25.0 | 25.01 | 16448413.0 |
| 2008-09-29 17:00:00 | MSFT | Stock | 25.25 | 26.172 | 25.01 | 25.29 | 74352.0 |
| 2008-09-29 18:00:00 | MSFT | Stock | 25.32 | 25.32 | 25.23 | 25.3 | 18667.0 |
| 2008-09-29 19:00:00 | MSFT | Stock | 25.3 | 25.39 | 25.2 | 25.39 | 14974.0 |
| 2008-09-29 07:00:00 | NVDA | Stock | 0.3 | 0.3 | 0.3 | 0.3 | 8000.0 |
| 2008-09-29 08:00:00 | NVDA | Stock | 0.288 | 0.288 | 0.2805 | 0.2848 | 708000.0 |
| 2008-09-29 09:00:00 | NVDA | Stock | 0.2848 | 0.288 | 0.2712 | 0.275 | 106510800.0 |
| 2008-09-29 10:00:00 | NVDA | Stock | 0.2748 | 0.2768 | 0.268 | 0.269 | 133695560.0 |
| 2008-09-29 11:00:00 | NVDA | Stock | 0.269 | 0.2703 | 0.2663 | 0.268 | 76567800.0 |
| 2008-09-29 12:00:00 | NVDA | Stock | 0.2678 | 0.2715 | 0.2655 | 0.2703 | 75678880.0 |
| 2008-09-29 13:00:00 | NVDA | Stock | 0.2703 | 0.2725 | 0.2638 | 0.265 | 156313160.0 |
| 2008-09-29 14:00:00 | NVDA | Stock | 0.2652 | 0.2692 | 0.2592 | 0.2595 | 190211320.0 |
| 2008-09-29 15:00:00 | NVDA | Stock | 0.2595 | 0.265 | 0.25 | 0.2533 | 181719680.0 |
| 2008-09-29 16:00:00 | NVDA | Stock | 0.2525 | 0.2666 | 0.252 | 0.2525 | 40884800.0 |
| 2008-09-29 17:00:00 | NVDA | Stock | 0.2525 | 0.26 | 0.2525 | 0.26 | 5265920.0 |
| 2008-09-29 18:00:00 | NVDA | Stock | 0.2563 | 0.2575 | 0.2563 | 0.2575 | 19000.0 |
| 2008-09-29 19:00:00 | NVDA | Stock | 0.255 | 0.255 | 0.255 | 0.255 | 28000.0 |
| 2008-09-29 08:00:00 | AMZN | Stock | 3.471 | 3.4725 | 3.4175 | 3.4175 | 93320.0 |
| 2008-09-29 09:00:00 | AMZN | Stock | 3.4185 | 3.4685 | 3.2915 | 3.304 | 22059540.0 |
| 2008-09-29 10:00:00 | AMZN | Stock | 3.303 | 3.4205 | 3.2669 | 3.365 | 28620520.0 |
| 2008-09-29 11:00:00 | AMZN | Stock | 3.365 | 3.3955 | 3.3275 | 3.3528 | 19287160.0 |
| 2008-09-29 12:00:00 | AMZN | Stock | 3.3525 | 3.3755 | 3.323 | 3.367 | 20618120.0 |
| 2008-09-29 13:00:00 | AMZN | Stock | 3.3675 | 3.4 | 3.2125 | 3.293 | 24303540.0 |
| 2008-09-29 14:00:00 | AMZN | Stock | 3.292 | 3.3495 | 3.201 | 3.2085 | 28450060.0 |
| 2008-09-29 15:00:00 | AMZN | Stock | 3.2095 | 3.3495 | 3.066 | 3.2375 | 74137340.0 |
| 2008-09-29 16:00:00 | AMZN | Stock | 3.2375 | 3.2915 | 3.1586 | 3.1675 | 15259580.0 |
| 2008-09-29 17:00:00 | AMZN | Stock | 3.1675 | 3.2615 | 3.1675 | 3.255 | 1349400.0 |
> showing 50 of 45,699 rows — these rows as CSV