PREVIEW / stock_30min / 2010-12-31
file: by_date/stock_30min/2010/2010-12-31.parquet size: 1.4 MB rows: 73,232 symbols: 3,541
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-31 08:00:00 | AAPL | Stock | 11.5571 | 11.5571 | 11.5386 | 11.5386 | 91196.0 |
| 2010-12-31 08:30:00 | AAPL | Stock | 11.5382 | 11.5479 | 11.5382 | 11.5418 | 81200.0 |
| 2010-12-31 09:00:00 | AAPL | Stock | 11.5386 | 11.5529 | 11.5318 | 11.5343 | 341068.0 |
| 2010-12-31 09:30:00 | AAPL | Stock | 11.5343 | 11.5529 | 11.4793 | 11.5004 | 27017788.0 |
| 2010-12-31 10:00:00 | AAPL | Stock | 11.4989 | 11.5129 | 11.4804 | 11.51 | 18449424.0 |
| 2010-12-31 10:30:00 | AAPL | Stock | 11.5096 | 11.5207 | 11.4946 | 11.4957 | 14089376.0 |
| 2010-12-31 11:00:00 | AAPL | Stock | 11.4954 | 11.4986 | 11.4761 | 11.4914 | 15639204.0 |
| 2010-12-31 11:30:00 | AAPL | Stock | 11.4921 | 11.4982 | 11.49 | 11.4926 | 8285956.0 |
| 2010-12-31 12:00:00 | AAPL | Stock | 11.4929 | 11.5057 | 11.4925 | 11.5043 | 8109612.0 |
| 2010-12-31 12:30:00 | AAPL | Stock | 11.5043 | 11.5054 | 11.4881 | 11.495 | 7577360.0 |
| 2010-12-31 13:00:00 | AAPL | Stock | 11.4947 | 11.4993 | 11.4936 | 11.4954 | 4694676.0 |
| 2010-12-31 13:30:00 | AAPL | Stock | 11.4954 | 11.5043 | 11.4939 | 11.4975 | 8960336.0 |
| 2010-12-31 14:00:00 | AAPL | Stock | 11.4979 | 11.5014 | 11.4921 | 11.4957 | 6402340.0 |
| 2010-12-31 14:30:00 | AAPL | Stock | 11.4961 | 11.5125 | 11.4925 | 11.5075 | 11508756.0 |
| 2010-12-31 15:00:00 | AAPL | Stock | 11.5077 | 11.5171 | 11.4964 | 11.4993 | 10175032.0 |
| 2010-12-31 15:30:00 | AAPL | Stock | 11.4993 | 11.525 | 11.4754 | 11.5157 | 34549536.0 |
| 2010-12-31 16:00:00 | AAPL | Stock | 11.52 | 11.5493 | 11.4996 | 11.5436 | 13172796.0 |
| 2010-12-31 16:30:00 | AAPL | Stock | 11.5393 | 11.5393 | 11.5002 | 11.5393 | 268968.0 |
| 2010-12-31 17:00:00 | AAPL | Stock | 11.5375 | 11.5375 | 11.5339 | 11.5357 | 23156.0 |
| 2010-12-31 17:30:00 | AAPL | Stock | 11.5339 | 11.5429 | 11.5321 | 11.5429 | 32004.0 |
| 2010-12-31 18:00:00 | AAPL | Stock | 11.5396 | 11.5429 | 11.52 | 11.5293 | 154980.0 |
| 2010-12-31 18:30:00 | AAPL | Stock | 11.5325 | 11.5421 | 11.5307 | 11.5307 | 31080.0 |
| 2010-12-31 19:00:00 | AAPL | Stock | 11.5357 | 11.5436 | 11.5357 | 11.5429 | 25620.0 |
| 2010-12-31 19:30:00 | AAPL | Stock | 11.5439 | 11.5493 | 11.5439 | 11.5493 | 32060.0 |
| 2010-12-31 07:00:00 | MSFT | Stock | 27.86 | 27.86 | 27.86 | 27.86 | 300.0 |
| 2010-12-31 08:00:00 | MSFT | Stock | 27.88 | 27.88 | 27.8 | 27.84 | 1200.0 |
| 2010-12-31 09:00:00 | MSFT | Stock | 27.83 | 27.83 | 27.8 | 27.82 | 3918.0 |
| 2010-12-31 09:30:00 | MSFT | Stock | 27.81 | 27.87 | 27.67 | 27.78 | 2813181.0 |
| 2010-12-31 10:00:00 | MSFT | Stock | 27.77 | 27.79 | 27.63 | 27.69 | 2662558.0 |
| 2010-12-31 10:30:00 | MSFT | Stock | 27.69 | 27.73 | 27.65 | 27.67 | 1704901.0 |
| 2010-12-31 11:00:00 | MSFT | Stock | 27.67 | 27.76 | 27.64 | 27.76 | 1659529.0 |
| 2010-12-31 11:30:00 | MSFT | Stock | 27.75 | 27.81 | 27.74 | 27.801 | 1254303.0 |
| 2010-12-31 12:00:00 | MSFT | Stock | 27.8 | 27.84 | 27.79 | 27.82 | 753754.0 |
| 2010-12-31 12:30:00 | MSFT | Stock | 27.82 | 27.84 | 27.74 | 27.77 | 1275996.0 |
| 2010-12-31 13:00:00 | MSFT | Stock | 27.77 | 27.8 | 27.76 | 27.78 | 640925.0 |
| 2010-12-31 13:30:00 | MSFT | Stock | 27.78 | 27.81 | 27.75 | 27.78 | 553064.0 |
| 2010-12-31 14:00:00 | MSFT | Stock | 27.785 | 27.79 | 27.74 | 27.765 | 822625.0 |
| 2010-12-31 14:30:00 | MSFT | Stock | 27.77 | 27.79 | 27.76 | 27.78 | 588148.0 |
| 2010-12-31 15:00:00 | MSFT | Stock | 27.776 | 27.79 | 27.75 | 27.76 | 728072.0 |
| 2010-12-31 15:30:00 | MSFT | Stock | 27.76 | 27.91 | 27.76 | 27.91 | 4750016.0 |
| 2010-12-31 16:00:00 | MSFT | Stock | 27.92 | 27.98 | 27.766 | 27.92 | 2940433.0 |
| 2010-12-31 16:30:00 | MSFT | Stock | 27.92 | 27.93 | 27.785 | 27.92 | 4993.0 |
| 2010-12-31 17:00:00 | MSFT | Stock | 27.92 | 27.92 | 27.92 | 27.92 | 476.0 |
| 2010-12-31 17:30:00 | MSFT | Stock | 27.92 | 27.93 | 27.92 | 27.92 | 580.0 |
| 2010-12-31 18:00:00 | MSFT | Stock | 27.91 | 27.91 | 27.91 | 27.91 | 100.0 |
| 2010-12-31 18:30:00 | MSFT | Stock | 27.92 | 27.97 | 27.92 | 27.95 | 27300.0 |
| 2010-12-31 19:00:00 | MSFT | Stock | 27.92 | 27.92 | 27.92 | 27.92 | 10000.0 |
| 2010-12-31 19:30:00 | MSFT | Stock | 27.95 | 27.95 | 27.9 | 27.9 | 2045.0 |
| 2010-12-31 09:00:00 | NVDA | Stock | 0.375 | 0.375 | 0.375 | 0.375 | 4000.0 |
| 2010-12-31 09:30:00 | NVDA | Stock | 0.375 | 0.3795 | 0.3745 | 0.3788 | 47532720.0 |
> showing 50 of 73,232 rows — these rows as CSV