PREVIEW / stock_30min / 2005-01-31
file: by_date/stock_30min/2005/2005-01-31.parquet size: 829 KB rows: 44,717 symbols: 1,930
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-01-31 08:00:00 | AAPL | Stock | 1.3263 | 1.3434 | 1.3263 | 1.34 | 5054112.0 |
| 2005-01-31 08:30:00 | AAPL | Stock | 1.34 | 1.3411 | 1.3357 | 1.3393 | 3121496.0 |
| 2005-01-31 09:00:00 | AAPL | Stock | 1.3393 | 1.3393 | 1.3214 | 1.332 | 6836816.0 |
| 2005-01-31 09:30:00 | AAPL | Stock | 1.3318 | 1.348 | 1.3305 | 1.3445 | 258025544.0 |
| 2005-01-31 10:00:00 | AAPL | Stock | 1.3445 | 1.3543 | 1.3423 | 1.353 | 162228024.0 |
| 2005-01-31 10:30:00 | AAPL | Stock | 1.353 | 1.3598 | 1.3509 | 1.3571 | 145943504.0 |
| 2005-01-31 11:00:00 | AAPL | Stock | 1.3571 | 1.3741 | 1.3563 | 1.3716 | 172762464.0 |
| 2005-01-31 11:30:00 | AAPL | Stock | 1.3716 | 1.3848 | 1.3707 | 1.3754 | 194824168.0 |
| 2005-01-31 12:00:00 | AAPL | Stock | 1.3754 | 1.383 | 1.3725 | 1.3813 | 93341416.0 |
| 2005-01-31 12:30:00 | AAPL | Stock | 1.3811 | 1.385 | 1.3759 | 1.3788 | 66335416.0 |
| 2005-01-31 13:00:00 | AAPL | Stock | 1.3788 | 1.383 | 1.3754 | 1.3813 | 41939464.0 |
| 2005-01-31 13:30:00 | AAPL | Stock | 1.3813 | 1.383 | 1.3771 | 1.3827 | 40231856.0 |
| 2005-01-31 14:00:00 | AAPL | Stock | 1.3829 | 1.3879 | 1.3805 | 1.3827 | 87940720.0 |
| 2005-01-31 14:30:00 | AAPL | Stock | 1.3821 | 1.3909 | 1.3814 | 1.3843 | 88183480.0 |
| 2005-01-31 15:00:00 | AAPL | Stock | 1.3845 | 1.3859 | 1.3682 | 1.3707 | 155997744.0 |
| 2005-01-31 15:30:00 | AAPL | Stock | 1.3707 | 1.3854 | 1.3643 | 1.3729 | 138957224.0 |
| 2005-01-31 16:00:00 | AAPL | Stock | 1.3718 | 1.3732 | 1.3696 | 1.3704 | 4623752.0 |
| 2005-01-31 16:30:00 | AAPL | Stock | 1.3705 | 1.3732 | 1.37 | 1.3732 | 2075416.0 |
| 2005-01-31 17:00:00 | AAPL | Stock | 1.3698 | 1.373 | 1.3696 | 1.3711 | 1122352.0 |
| 2005-01-31 17:30:00 | AAPL | Stock | 1.3721 | 1.3723 | 1.3714 | 1.3721 | 349608.0 |
| 2005-01-31 18:00:00 | AAPL | Stock | 1.3721 | 1.373 | 1.3716 | 1.372 | 192752.0 |
| 2005-01-31 08:00:00 | MSFT | Stock | 26.35 | 26.35 | 26.28 | 26.31 | 35652.0 |
| 2005-01-31 08:30:00 | MSFT | Stock | 26.31 | 26.31 | 26.28 | 26.3 | 57640.0 |
| 2005-01-31 09:00:00 | MSFT | Stock | 26.31 | 26.39 | 26.2 | 26.32 | 273489.0 |
| 2005-01-31 09:30:00 | MSFT | Stock | 26.35 | 26.49 | 26.3 | 26.48 | 10852741.0 |
| 2005-01-31 10:00:00 | MSFT | Stock | 26.48 | 26.52 | 26.34 | 26.39 | 8314744.0 |
| 2005-01-31 10:30:00 | MSFT | Stock | 26.39 | 26.5 | 26.35 | 26.378 | 4219310.0 |
| 2005-01-31 11:00:00 | MSFT | Stock | 26.38 | 26.43 | 26.36 | 26.388 | 3477493.0 |
| 2005-01-31 11:30:00 | MSFT | Stock | 26.39 | 26.421 | 26.35 | 26.42 | 2250452.0 |
| 2005-01-31 12:00:00 | MSFT | Stock | 26.42 | 26.44 | 26.39 | 26.43 | 2179250.0 |
| 2005-01-31 12:30:00 | MSFT | Stock | 26.43 | 26.45 | 26.4 | 26.42 | 2694377.0 |
| 2005-01-31 13:00:00 | MSFT | Stock | 26.42 | 26.44 | 26.39 | 26.39 | 2643926.0 |
| 2005-01-31 13:30:00 | MSFT | Stock | 26.4 | 26.4 | 26.31 | 26.32 | 3443089.0 |
| 2005-01-31 14:00:00 | MSFT | Stock | 26.32 | 26.32 | 26.21 | 26.21 | 5057773.0 |
| 2005-01-31 14:30:00 | MSFT | Stock | 26.21 | 26.3 | 26.2 | 26.26 | 6138269.0 |
| 2005-01-31 15:00:00 | MSFT | Stock | 26.26 | 26.3 | 26.16 | 26.2 | 7993358.0 |
| 2005-01-31 15:30:00 | MSFT | Stock | 26.2 | 26.28 | 26.17 | 26.26 | 8051038.0 |
| 2005-01-31 16:00:00 | MSFT | Stock | 26.28 | 26.41 | 26.26 | 26.27 | 486756.0 |
| 2005-01-31 16:30:00 | MSFT | Stock | 26.27 | 26.28 | 26.27 | 26.28 | 222928.0 |
| 2005-01-31 17:00:00 | MSFT | Stock | 26.28 | 26.28 | 26.27 | 26.27 | 107412.0 |
| 2005-01-31 17:30:00 | MSFT | Stock | 26.26 | 26.28 | 26.2 | 26.2 | 317465.0 |
| 2005-01-31 18:00:00 | MSFT | Stock | 26.26 | 26.28 | 26.25 | 26.25 | 1485.0 |
| 2005-01-31 08:00:00 | NVDA | Stock | 0.1928 | 0.1928 | 0.1928 | 0.1928 | 15000.0 |
| 2005-01-31 08:30:00 | NVDA | Stock | 0.1921 | 0.1928 | 0.1921 | 0.1928 | 36000.0 |
| 2005-01-31 09:00:00 | NVDA | Stock | 0.1925 | 0.1927 | 0.1907 | 0.1927 | 1719840.0 |
| 2005-01-31 09:30:00 | NVDA | Stock | 0.1922 | 0.1946 | 0.1921 | 0.1933 | 94572000.0 |
| 2005-01-31 10:00:00 | NVDA | Stock | 0.1933 | 0.1935 | 0.1899 | 0.1899 | 72775320.0 |
| 2005-01-31 10:30:00 | NVDA | Stock | 0.19 | 0.1915 | 0.1893 | 0.1907 | 58561080.0 |
| 2005-01-31 11:00:00 | NVDA | Stock | 0.1907 | 0.1914 | 0.1902 | 0.191 | 34620720.0 |
| 2005-01-31 11:30:00 | NVDA | Stock | 0.1911 | 0.1917 | 0.191 | 0.1914 | 18518760.0 |
> showing 50 of 44,717 rows — these rows as CSV