PREVIEW / stock_30min / 2007-04-25
file: by_date/stock_30min/2007/2007-04-25.parquet size: 1.1 MB rows: 56,760 symbols: 2,601
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 |
|---|---|---|---|---|---|---|---|
| 2007-04-25 06:30:00 | AAPL | Stock | 3.3604 | 3.3604 | 3.3604 | 3.3604 | 2800.0 |
| 2007-04-25 07:00:00 | AAPL | Stock | 3.3604 | 3.3643 | 3.3604 | 3.3643 | 76160.0 |
| 2007-04-25 07:30:00 | AAPL | Stock | 3.3643 | 3.3729 | 3.3629 | 3.3629 | 432600.0 |
| 2007-04-25 08:00:00 | AAPL | Stock | 3.3632 | 3.3786 | 3.3596 | 3.3714 | 2448040.0 |
| 2007-04-25 08:30:00 | AAPL | Stock | 3.3689 | 3.3714 | 3.3575 | 3.3625 | 1202292.0 |
| 2007-04-25 09:00:00 | AAPL | Stock | 3.3639 | 3.3696 | 3.3625 | 3.3654 | 1907192.0 |
| 2007-04-25 09:30:00 | AAPL | Stock | 3.3654 | 3.3821 | 3.35 | 3.3603 | 100268392.0 |
| 2007-04-25 10:00:00 | AAPL | Stock | 3.36 | 3.3711 | 3.3532 | 3.3693 | 57166060.0 |
| 2007-04-25 10:30:00 | AAPL | Stock | 3.3693 | 3.3693 | 3.3589 | 3.3611 | 42426048.0 |
| 2007-04-25 11:00:00 | AAPL | Stock | 3.3614 | 3.3689 | 3.3604 | 3.3657 | 38530940.0 |
| 2007-04-25 11:30:00 | AAPL | Stock | 3.3657 | 3.3689 | 3.3643 | 3.3675 | 37072672.0 |
| 2007-04-25 12:00:00 | AAPL | Stock | 3.3675 | 3.3786 | 3.3661 | 3.3761 | 37899764.0 |
| 2007-04-25 12:30:00 | AAPL | Stock | 3.3761 | 3.3871 | 3.3732 | 3.3871 | 55107192.0 |
| 2007-04-25 13:00:00 | AAPL | Stock | 3.3871 | 3.4007 | 3.3829 | 3.3914 | 70595168.0 |
| 2007-04-25 13:30:00 | AAPL | Stock | 3.3918 | 3.395 | 3.385 | 3.3896 | 38917452.0 |
| 2007-04-25 14:00:00 | AAPL | Stock | 3.3896 | 3.3925 | 3.3796 | 3.3836 | 54125820.0 |
| 2007-04-25 14:30:00 | AAPL | Stock | 3.3836 | 3.3911 | 3.3832 | 3.3896 | 83671532.0 |
| 2007-04-25 15:00:00 | AAPL | Stock | 3.3896 | 3.3993 | 3.385 | 3.3932 | 84662116.0 |
| 2007-04-25 15:30:00 | AAPL | Stock | 3.3936 | 3.4071 | 3.3886 | 3.4039 | 123544568.0 |
| 2007-04-25 16:00:00 | AAPL | Stock | 3.4039 | 3.4132 | 3.3482 | 3.4032 | 19119996.0 |
| 2007-04-25 16:30:00 | AAPL | Stock | 3.4039 | 3.7093 | 3.3929 | 3.6736 | 254692480.0 |
| 2007-04-25 17:00:00 | AAPL | Stock | 3.6736 | 3.6786 | 3.5714 | 3.6071 | 64116416.0 |
| 2007-04-25 17:30:00 | AAPL | Stock | 3.6064 | 3.6179 | 3.5839 | 3.6143 | 24943240.0 |
| 2007-04-25 18:00:00 | AAPL | Stock | 3.6157 | 3.6339 | 3.6143 | 3.6211 | 11276300.0 |
| 2007-04-25 18:30:00 | AAPL | Stock | 3.6211 | 3.6321 | 3.6204 | 3.6311 | 4206496.0 |
| 2007-04-25 19:00:00 | AAPL | Stock | 3.6314 | 3.6496 | 3.6289 | 3.6446 | 5317116.0 |
| 2007-04-25 19:30:00 | AAPL | Stock | 3.6454 | 3.6604 | 3.6411 | 3.6571 | 3569104.0 |
| 2007-04-25 08:00:00 | MSFT | Stock | 28.82 | 28.86 | 28.82 | 28.86 | 4355.0 |
| 2007-04-25 08:30:00 | MSFT | Stock | 28.88 | 28.88 | 28.79 | 28.87 | 931642.0 |
| 2007-04-25 09:00:00 | MSFT | Stock | 28.86 | 28.88 | 28.84 | 28.86 | 49752.0 |
| 2007-04-25 09:30:00 | MSFT | Stock | 28.86 | 28.89 | 28.72 | 28.8 | 6318041.0 |
| 2007-04-25 10:00:00 | MSFT | Stock | 28.79 | 28.858 | 28.7 | 28.79 | 2991592.0 |
| 2007-04-25 10:30:00 | MSFT | Stock | 28.78 | 28.81 | 28.73 | 28.74 | 2204750.0 |
| 2007-04-25 11:00:00 | MSFT | Stock | 28.74 | 28.79 | 28.73 | 28.743 | 2043584.0 |
| 2007-04-25 11:30:00 | MSFT | Stock | 28.74 | 28.77 | 28.69 | 28.76 | 2144436.0 |
| 2007-04-25 12:00:00 | MSFT | Stock | 28.75 | 28.81 | 28.73 | 28.77 | 1803368.0 |
| 2007-04-25 12:30:00 | MSFT | Stock | 28.77 | 28.78 | 28.72 | 28.73 | 780758.0 |
| 2007-04-25 13:00:00 | MSFT | Stock | 28.72 | 28.84 | 28.71 | 28.818 | 1768903.0 |
| 2007-04-25 13:30:00 | MSFT | Stock | 28.82 | 28.95 | 28.77 | 28.91 | 2135535.0 |
| 2007-04-25 14:00:00 | MSFT | Stock | 28.91 | 28.98 | 28.87 | 28.96 | 1916288.0 |
| 2007-04-25 14:30:00 | MSFT | Stock | 28.96 | 29.0 | 28.95 | 28.96 | 2201121.0 |
| 2007-04-25 15:00:00 | MSFT | Stock | 28.96 | 29.0 | 28.89 | 28.99 | 4177777.0 |
| 2007-04-25 15:30:00 | MSFT | Stock | 28.98 | 29.0 | 28.9 | 28.99 | 5450201.0 |
| 2007-04-25 16:00:00 | MSFT | Stock | 28.99 | 29.0 | 28.99 | 28.99 | 1097335.0 |
| 2007-04-25 09:00:00 | NVDA | Stock | 0.5458 | 0.5482 | 0.5427 | 0.5427 | 213000.0 |
| 2007-04-25 09:30:00 | NVDA | Stock | 0.5417 | 0.5548 | 0.5417 | 0.5438 | 63288780.0 |
| 2007-04-25 10:00:00 | NVDA | Stock | 0.5438 | 0.5443 | 0.5392 | 0.5437 | 62236260.0 |
| 2007-04-25 10:30:00 | NVDA | Stock | 0.5438 | 0.5465 | 0.543 | 0.5432 | 32167800.0 |
| 2007-04-25 11:00:00 | NVDA | Stock | 0.543 | 0.5468 | 0.543 | 0.5452 | 26192520.0 |
| 2007-04-25 11:30:00 | NVDA | Stock | 0.5452 | 0.5493 | 0.5438 | 0.5488 | 25139700.0 |
> showing 50 of 56,760 rows — these rows as CSV