PREVIEW / stock_30min / 2007-04-03
file: by_date/stock_30min/2007/2007-04-03.parquet size: 1.0 MB rows: 55,590 symbols: 2,573
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-03 07:00:00 | AAPL | Stock | 3.3461 | 3.3468 | 3.3461 | 3.3461 | 27748.0 |
| 2007-04-03 07:30:00 | AAPL | Stock | 3.3482 | 3.3607 | 3.3471 | 3.3554 | 280140.0 |
| 2007-04-03 08:00:00 | AAPL | Stock | 3.3554 | 3.3571 | 3.35 | 3.3532 | 1432424.0 |
| 2007-04-03 08:30:00 | AAPL | Stock | 3.3518 | 3.3564 | 3.3514 | 3.3554 | 503916.0 |
| 2007-04-03 09:00:00 | AAPL | Stock | 3.3554 | 3.3625 | 3.3536 | 3.3621 | 2205756.0 |
| 2007-04-03 09:30:00 | AAPL | Stock | 3.3621 | 3.3793 | 3.3486 | 3.3741 | 116523148.0 |
| 2007-04-03 10:00:00 | AAPL | Stock | 3.3739 | 3.3839 | 3.3664 | 3.3671 | 72618504.0 |
| 2007-04-03 10:30:00 | AAPL | Stock | 3.3671 | 3.3929 | 3.3664 | 3.3918 | 65410548.0 |
| 2007-04-03 11:00:00 | AAPL | Stock | 3.3918 | 3.3954 | 3.3818 | 3.3825 | 43044316.0 |
| 2007-04-03 11:30:00 | AAPL | Stock | 3.3825 | 3.395 | 3.3821 | 3.3925 | 29666168.0 |
| 2007-04-03 12:00:00 | AAPL | Stock | 3.3921 | 3.4011 | 3.3879 | 3.3879 | 31851260.0 |
| 2007-04-03 12:30:00 | AAPL | Stock | 3.3879 | 3.3929 | 3.3846 | 3.3882 | 18400312.0 |
| 2007-04-03 13:00:00 | AAPL | Stock | 3.3879 | 3.3957 | 3.385 | 3.3957 | 21391328.0 |
| 2007-04-03 13:30:00 | AAPL | Stock | 3.3961 | 3.3968 | 3.3864 | 3.3886 | 24369996.0 |
| 2007-04-03 14:00:00 | AAPL | Stock | 3.3886 | 3.3929 | 3.3864 | 3.3911 | 24582292.0 |
| 2007-04-03 14:30:00 | AAPL | Stock | 3.3907 | 3.3968 | 3.3886 | 3.3925 | 24104472.0 |
| 2007-04-03 15:00:00 | AAPL | Stock | 3.3921 | 3.3964 | 3.3882 | 3.3886 | 22131536.0 |
| 2007-04-03 15:30:00 | AAPL | Stock | 3.3886 | 3.3907 | 3.3689 | 3.3739 | 73561544.0 |
| 2007-04-03 16:00:00 | AAPL | Stock | 3.3739 | 3.375 | 3.3707 | 3.375 | 4061680.0 |
| 2007-04-03 16:30:00 | AAPL | Stock | 3.3764 | 3.3764 | 3.3732 | 3.3743 | 121940.0 |
| 2007-04-03 17:00:00 | AAPL | Stock | 3.3743 | 3.3746 | 3.3743 | 3.3746 | 52556.0 |
| 2007-04-03 17:30:00 | AAPL | Stock | 3.3736 | 3.3761 | 3.3736 | 3.3761 | 113596.0 |
| 2007-04-03 18:00:00 | AAPL | Stock | 3.3757 | 3.3757 | 3.3757 | 3.3757 | 5600.0 |
| 2007-04-03 18:30:00 | AAPL | Stock | 3.375 | 3.3757 | 3.375 | 3.375 | 36652.0 |
| 2007-04-03 19:00:00 | AAPL | Stock | 3.375 | 3.3775 | 3.375 | 3.3775 | 60172.0 |
| 2007-04-03 19:30:00 | AAPL | Stock | 3.38 | 3.38 | 3.3796 | 3.38 | 260568.0 |
| 2007-04-03 07:30:00 | MSFT | Stock | 27.87 | 27.87 | 27.87 | 27.87 | 1500.0 |
| 2007-04-03 08:00:00 | MSFT | Stock | 27.75 | 27.81 | 27.75 | 27.81 | 2450.0 |
| 2007-04-03 08:30:00 | MSFT | Stock | 27.81 | 27.83 | 27.81 | 27.81 | 4254.0 |
| 2007-04-03 09:00:00 | MSFT | Stock | 27.81 | 27.87 | 27.8 | 27.87 | 25338.0 |
| 2007-04-03 09:30:00 | MSFT | Stock | 27.86 | 27.92 | 27.75 | 27.86 | 4036626.0 |
| 2007-04-03 10:00:00 | MSFT | Stock | 27.852 | 27.98 | 27.85 | 27.86 | 4122650.0 |
| 2007-04-03 10:30:00 | MSFT | Stock | 27.86 | 28.02 | 27.79 | 27.97 | 4003940.0 |
| 2007-04-03 11:00:00 | MSFT | Stock | 27.97 | 27.99 | 27.93 | 27.95 | 1581954.0 |
| 2007-04-03 11:30:00 | MSFT | Stock | 27.95 | 28.06 | 27.94 | 28.05 | 1812408.0 |
| 2007-04-03 12:00:00 | MSFT | Stock | 28.05 | 28.06 | 27.96 | 27.96 | 1712731.0 |
| 2007-04-03 12:30:00 | MSFT | Stock | 27.96 | 27.98 | 27.91 | 27.91 | 1708450.0 |
| 2007-04-03 13:00:00 | MSFT | Stock | 27.91 | 28.01 | 27.91 | 28.0 | 1347926.0 |
| 2007-04-03 13:30:00 | MSFT | Stock | 28.01 | 28.05 | 27.98 | 28.0 | 2450986.0 |
| 2007-04-03 14:00:00 | MSFT | Stock | 28.0 | 28.0 | 27.91 | 27.94 | 2366897.0 |
| 2007-04-03 14:30:00 | MSFT | Stock | 27.94 | 27.97 | 27.85 | 27.86 | 2798118.0 |
| 2007-04-03 15:00:00 | MSFT | Stock | 27.86 | 27.91 | 27.85 | 27.9 | 2949565.0 |
| 2007-04-03 15:30:00 | MSFT | Stock | 27.89 | 27.91 | 27.82 | 27.87 | 7232738.0 |
| 2007-04-03 16:00:00 | MSFT | Stock | 27.86 | 27.87 | 27.816 | 27.87 | 562614.0 |
| 2007-04-03 16:30:00 | MSFT | Stock | 27.86 | 27.86 | 27.84 | 27.84 | 1300.0 |
| 2007-04-03 17:00:00 | MSFT | Stock | 27.85 | 27.87 | 27.85 | 27.85 | 10300.0 |
| 2007-04-03 18:00:00 | MSFT | Stock | 27.87 | 27.87 | 27.84 | 27.84 | 2814300.0 |
| 2007-04-03 19:00:00 | MSFT | Stock | 27.83 | 27.83 | 27.83 | 27.83 | 450.0 |
| 2007-04-03 19:30:00 | MSFT | Stock | 27.86 | 27.86 | 27.86 | 27.86 | 1412.0 |
| 2007-04-03 08:00:00 | NVDA | Stock | 0.4887 | 0.4887 | 0.48 | 0.4875 | 114000.0 |
> showing 50 of 55,590 rows — these rows as CSV