PREVIEW / stock_30min / 2005-03-31
file: by_date/stock_30min/2005/2005-03-31.parquet size: 839 KB rows: 45,173 symbols: 1,957
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-31 08:00:00 | AAPL | Stock | 1.5286 | 1.5346 | 1.5179 | 1.5246 | 703920.0 |
| 2005-03-31 08:30:00 | AAPL | Stock | 1.5246 | 1.5304 | 1.5232 | 1.5239 | 1794856.0 |
| 2005-03-31 09:00:00 | AAPL | Stock | 1.5236 | 1.5236 | 1.5107 | 1.5125 | 7656404.0 |
| 2005-03-31 09:30:00 | AAPL | Stock | 1.5161 | 1.5186 | 1.4964 | 1.5086 | 132814416.0 |
| 2005-03-31 10:00:00 | AAPL | Stock | 1.5086 | 1.5104 | 1.5 | 1.5082 | 51237620.0 |
| 2005-03-31 10:30:00 | AAPL | Stock | 1.5082 | 1.5104 | 1.5011 | 1.5043 | 27794956.0 |
| 2005-03-31 11:00:00 | AAPL | Stock | 1.5039 | 1.5093 | 1.5004 | 1.5057 | 33056996.0 |
| 2005-03-31 11:30:00 | AAPL | Stock | 1.5054 | 1.5075 | 1.4971 | 1.5011 | 29947904.0 |
| 2005-03-31 12:00:00 | AAPL | Stock | 1.5011 | 1.5014 | 1.4921 | 1.4946 | 40728828.0 |
| 2005-03-31 12:30:00 | AAPL | Stock | 1.4946 | 1.4946 | 1.4854 | 1.4879 | 45717896.0 |
| 2005-03-31 13:00:00 | AAPL | Stock | 1.4875 | 1.4954 | 1.4857 | 1.4954 | 30101904.0 |
| 2005-03-31 13:30:00 | AAPL | Stock | 1.495 | 1.4971 | 1.4911 | 1.4939 | 25713128.0 |
| 2005-03-31 14:00:00 | AAPL | Stock | 1.4936 | 1.4979 | 1.4911 | 1.4971 | 31249624.0 |
| 2005-03-31 14:30:00 | AAPL | Stock | 1.4971 | 1.5079 | 1.4957 | 1.5029 | 52825304.0 |
| 2005-03-31 15:00:00 | AAPL | Stock | 1.5029 | 1.5054 | 1.4982 | 1.4982 | 24933496.0 |
| 2005-03-31 15:30:00 | AAPL | Stock | 1.4982 | 1.5054 | 1.4882 | 1.4886 | 53884124.0 |
| 2005-03-31 16:00:00 | AAPL | Stock | 1.4882 | 1.5001 | 1.4882 | 1.4882 | 4270168.0 |
| 2005-03-31 16:30:00 | AAPL | Stock | 1.4907 | 1.4907 | 1.4886 | 1.4893 | 321440.0 |
| 2005-03-31 17:00:00 | AAPL | Stock | 1.4889 | 1.4911 | 1.4882 | 1.4907 | 194964.0 |
| 2005-03-31 17:30:00 | AAPL | Stock | 1.4882 | 1.4911 | 1.4882 | 1.4893 | 213248.0 |
| 2005-03-31 18:00:00 | AAPL | Stock | 1.4889 | 1.4925 | 1.4886 | 1.4886 | 149072.0 |
| 2005-03-31 08:00:00 | MSFT | Stock | 24.26 | 24.26 | 24.23 | 24.25 | 46550.0 |
| 2005-03-31 08:30:00 | MSFT | Stock | 24.25 | 24.27 | 24.23 | 24.26 | 84649.0 |
| 2005-03-31 09:00:00 | MSFT | Stock | 24.25 | 24.28 | 24.2 | 24.28 | 109698.0 |
| 2005-03-31 09:30:00 | MSFT | Stock | 24.25 | 24.3 | 24.13 | 24.3 | 8402829.0 |
| 2005-03-31 10:00:00 | MSFT | Stock | 24.3 | 24.31 | 24.15 | 24.19 | 5937264.0 |
| 2005-03-31 10:30:00 | MSFT | Stock | 24.2 | 24.221 | 24.139 | 24.16 | 3560743.0 |
| 2005-03-31 11:00:00 | MSFT | Stock | 24.16 | 24.29 | 24.15 | 24.25 | 3356645.0 |
| 2005-03-31 11:30:00 | MSFT | Stock | 24.25 | 24.26 | 24.19 | 24.22 | 2809232.0 |
| 2005-03-31 12:00:00 | MSFT | Stock | 24.22 | 24.22 | 24.13 | 24.15 | 4256840.0 |
| 2005-03-31 12:30:00 | MSFT | Stock | 24.15 | 24.18 | 24.12 | 24.17 | 2480506.0 |
| 2005-03-31 13:00:00 | MSFT | Stock | 24.16 | 24.21 | 24.15 | 24.19 | 1327472.0 |
| 2005-03-31 13:30:00 | MSFT | Stock | 24.18 | 24.25 | 24.18 | 24.21 | 3742864.0 |
| 2005-03-31 14:00:00 | MSFT | Stock | 24.21 | 24.28 | 24.19 | 24.26 | 4833477.0 |
| 2005-03-31 14:30:00 | MSFT | Stock | 24.26 | 24.31 | 24.26 | 24.28 | 5217444.0 |
| 2005-03-31 15:00:00 | MSFT | Stock | 24.28 | 24.3 | 24.23 | 24.23 | 3934022.0 |
| 2005-03-31 15:30:00 | MSFT | Stock | 24.24 | 24.3 | 24.14 | 24.15 | 7080589.0 |
| 2005-03-31 16:00:00 | MSFT | Stock | 24.15 | 24.17 | 24.12 | 24.14 | 830374.0 |
| 2005-03-31 16:30:00 | MSFT | Stock | 24.14 | 24.17 | 24.12 | 24.12 | 68823.0 |
| 2005-03-31 17:00:00 | MSFT | Stock | 24.14 | 24.15 | 24.12 | 24.13 | 25690.0 |
| 2005-03-31 17:30:00 | MSFT | Stock | 24.13 | 24.17 | 24.12 | 24.13 | 5400.0 |
| 2005-03-31 18:00:00 | MSFT | Stock | 24.13 | 24.16 | 24.13 | 24.16 | 8400.0 |
| 2005-03-31 09:00:00 | NVDA | Stock | 0.202 | 0.202 | 0.2013 | 0.2013 | 570000.0 |
| 2005-03-31 09:30:00 | NVDA | Stock | 0.2013 | 0.2027 | 0.2001 | 0.2012 | 58610880.0 |
| 2005-03-31 10:00:00 | NVDA | Stock | 0.2012 | 0.2012 | 0.1989 | 0.1997 | 46124640.0 |
| 2005-03-31 10:30:00 | NVDA | Stock | 0.1997 | 0.2004 | 0.1992 | 0.1995 | 25251600.0 |
| 2005-03-31 11:00:00 | NVDA | Stock | 0.1995 | 0.2002 | 0.1992 | 0.1999 | 21472800.0 |
| 2005-03-31 11:30:00 | NVDA | Stock | 0.1999 | 0.2 | 0.1996 | 0.1999 | 17031360.0 |
| 2005-03-31 12:00:00 | NVDA | Stock | 0.2 | 0.2 | 0.1971 | 0.1992 | 37505520.0 |
| 2005-03-31 12:30:00 | NVDA | Stock | 0.1992 | 0.1994 | 0.1989 | 0.1992 | 11482320.0 |
> showing 50 of 45,173 rows — these rows as CSV