PREVIEW / stock_30min / 2006-04-05
file: by_date/stock_30min/2006/2006-04-05.parquet size: 900 KB rows: 48,309 symbols: 2,219
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 |
|---|---|---|---|---|---|---|---|
| 2006-04-05 05:30:00 | AAPL | Stock | 2.1736 | 2.1736 | 2.1732 | 2.1732 | 5600.0 |
| 2006-04-05 06:00:00 | AAPL | Stock | 2.1786 | 2.1786 | 2.1732 | 2.1786 | 168000.0 |
| 2006-04-05 07:30:00 | AAPL | Stock | 2.1789 | 2.1789 | 2.175 | 2.1786 | 14000.0 |
| 2006-04-05 08:00:00 | AAPL | Stock | 2.175 | 2.1836 | 2.1679 | 2.1714 | 1182160.0 |
| 2006-04-05 08:30:00 | AAPL | Stock | 2.1714 | 2.2839 | 2.1682 | 2.2707 | 48324584.0 |
| 2006-04-05 09:00:00 | AAPL | Stock | 2.2714 | 2.3386 | 2.2696 | 2.3129 | 108627204.0 |
| 2006-04-05 09:30:00 | AAPL | Stock | 2.3111 | 2.3429 | 2.2911 | 2.3104 | 430191580.0 |
| 2006-04-05 10:00:00 | AAPL | Stock | 2.3104 | 2.3296 | 2.2939 | 2.3268 | 199211684.0 |
| 2006-04-05 10:30:00 | AAPL | Stock | 2.3264 | 2.3521 | 2.3089 | 2.3511 | 211968148.0 |
| 2006-04-05 11:00:00 | AAPL | Stock | 2.3511 | 2.3518 | 2.3318 | 2.345 | 151353804.0 |
| 2006-04-05 11:30:00 | AAPL | Stock | 2.3454 | 2.3482 | 2.3325 | 2.3407 | 86263268.0 |
| 2006-04-05 12:00:00 | AAPL | Stock | 2.3407 | 2.3582 | 2.3407 | 2.355 | 89129544.0 |
| 2006-04-05 12:30:00 | AAPL | Stock | 2.3551 | 2.3739 | 2.3536 | 2.3689 | 111482924.0 |
| 2006-04-05 13:00:00 | AAPL | Stock | 2.3689 | 2.38 | 2.3682 | 2.3729 | 115736432.0 |
| 2006-04-05 13:30:00 | AAPL | Stock | 2.3725 | 2.3729 | 2.3571 | 2.3671 | 100055228.0 |
| 2006-04-05 14:00:00 | AAPL | Stock | 2.3671 | 2.3793 | 2.3668 | 2.3686 | 87691856.0 |
| 2006-04-05 14:30:00 | AAPL | Stock | 2.3686 | 2.3964 | 2.3679 | 2.3879 | 121367736.0 |
| 2006-04-05 15:00:00 | AAPL | Stock | 2.3868 | 2.3964 | 2.3754 | 2.3911 | 149693124.0 |
| 2006-04-05 15:30:00 | AAPL | Stock | 2.3907 | 2.4004 | 2.3871 | 2.3996 | 179550140.0 |
| 2006-04-05 16:00:00 | AAPL | Stock | 2.3986 | 2.4004 | 2.3646 | 2.395 | 10211432.0 |
| 2006-04-05 16:30:00 | AAPL | Stock | 2.3975 | 2.3996 | 2.3964 | 2.3982 | 1042328.0 |
| 2006-04-05 17:00:00 | AAPL | Stock | 2.3986 | 2.4043 | 2.3982 | 2.4021 | 12554724.0 |
| 2006-04-05 17:30:00 | AAPL | Stock | 2.4021 | 2.41 | 2.4004 | 2.4086 | 1895992.0 |
| 2006-04-05 18:00:00 | AAPL | Stock | 2.4075 | 2.4096 | 2.4036 | 2.4064 | 913696.0 |
| 2006-04-05 07:00:00 | MSFT | Stock | 27.64 | 27.64 | 27.64 | 27.64 | 1000.0 |
| 2006-04-05 08:00:00 | MSFT | Stock | 27.7 | 27.7 | 27.66 | 27.68 | 1900.0 |
| 2006-04-05 08:30:00 | MSFT | Stock | 27.68 | 27.78 | 27.68 | 27.74 | 20610.0 |
| 2006-04-05 09:00:00 | MSFT | Stock | 27.74 | 27.96 | 27.74 | 27.88 | 790230.0 |
| 2006-04-05 09:30:00 | MSFT | Stock | 27.88 | 27.941 | 27.81 | 27.86 | 7586685.0 |
| 2006-04-05 10:00:00 | MSFT | Stock | 27.85 | 27.9 | 27.79 | 27.84 | 3470540.0 |
| 2006-04-05 10:30:00 | MSFT | Stock | 27.83 | 27.85 | 27.74 | 27.75 | 3273428.0 |
| 2006-04-05 11:00:00 | MSFT | Stock | 27.758 | 27.77 | 27.69 | 27.721 | 2314774.0 |
| 2006-04-05 11:30:00 | MSFT | Stock | 27.72 | 27.73 | 27.64 | 27.668 | 2331307.0 |
| 2006-04-05 12:00:00 | MSFT | Stock | 27.662 | 27.69 | 27.66 | 27.66 | 1382958.0 |
| 2006-04-05 12:30:00 | MSFT | Stock | 27.66 | 27.85 | 27.66 | 27.83 | 3744421.0 |
| 2006-04-05 13:00:00 | MSFT | Stock | 27.82 | 27.87 | 27.77 | 27.79 | 2783420.0 |
| 2006-04-05 13:30:00 | MSFT | Stock | 27.791 | 27.83 | 27.72 | 27.77 | 1807684.0 |
| 2006-04-05 14:00:00 | MSFT | Stock | 27.77 | 27.82 | 27.76 | 27.78 | 2001913.0 |
| 2006-04-05 14:30:00 | MSFT | Stock | 27.78 | 27.8 | 27.74 | 27.8 | 1436642.0 |
| 2006-04-05 15:00:00 | MSFT | Stock | 27.8 | 27.84 | 27.73 | 27.8 | 1935776.0 |
| 2006-04-05 15:30:00 | MSFT | Stock | 27.801 | 27.801 | 27.69 | 27.77 | 5124593.0 |
| 2006-04-05 16:00:00 | MSFT | Stock | 27.78 | 27.83 | 27.72 | 27.75 | 59507.0 |
| 2006-04-05 16:30:00 | MSFT | Stock | 27.77 | 27.8 | 27.75 | 27.75 | 11880.0 |
| 2006-04-05 17:00:00 | MSFT | Stock | 27.75 | 27.75 | 27.75 | 27.75 | 800.0 |
| 2006-04-05 17:30:00 | MSFT | Stock | 27.76 | 27.86 | 27.76 | 27.85 | 11287.0 |
| 2006-04-05 18:00:00 | MSFT | Stock | 27.83 | 27.83 | 27.74 | 27.74 | 1081.0 |
| 2006-04-05 08:00:00 | NVDA | Stock | 0.5037 | 0.5046 | 0.4984 | 0.5046 | 191400.0 |
| 2006-04-05 08:30:00 | NVDA | Stock | 0.5026 | 0.5026 | 0.5021 | 0.5021 | 204000.0 |
| 2006-04-05 09:00:00 | NVDA | Stock | 0.5033 | 0.505 | 0.5025 | 0.5034 | 1332000.0 |
| 2006-04-05 09:30:00 | NVDA | Stock | 0.5042 | 0.5117 | 0.5016 | 0.5099 | 142734120.0 |
> showing 50 of 48,309 rows — these rows as CSV