PREVIEW / stock_30min / 2007-02-07
file: by_date/stock_30min/2007/2007-02-07.parquet size: 978 KB rows: 53,247 symbols: 2,517
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-02-07 07:30:00 | AAPL | Stock | 3.0143 | 3.0143 | 3.0107 | 3.0107 | 8400.0 |
| 2007-02-07 08:00:00 | AAPL | Stock | 3.0129 | 3.0179 | 3.0107 | 3.0125 | 1407448.0 |
| 2007-02-07 08:30:00 | AAPL | Stock | 3.0125 | 3.0143 | 3.0046 | 3.0061 | 1067192.0 |
| 2007-02-07 09:00:00 | AAPL | Stock | 3.0071 | 3.0179 | 3.0061 | 3.0179 | 3117212.0 |
| 2007-02-07 09:30:00 | AAPL | Stock | 3.0171 | 3.0214 | 2.9839 | 2.9943 | 89075840.0 |
| 2007-02-07 10:00:00 | AAPL | Stock | 2.9936 | 3.0189 | 2.9864 | 3.0127 | 85308244.0 |
| 2007-02-07 10:30:00 | AAPL | Stock | 3.0132 | 3.0286 | 3.0086 | 3.0193 | 79044812.0 |
| 2007-02-07 11:00:00 | AAPL | Stock | 3.0193 | 3.0264 | 3.0146 | 3.0171 | 55365240.0 |
| 2007-02-07 11:30:00 | AAPL | Stock | 3.0171 | 3.0339 | 3.0146 | 3.0329 | 54952744.0 |
| 2007-02-07 12:00:00 | AAPL | Stock | 3.0325 | 3.0625 | 3.0318 | 3.0536 | 117237596.0 |
| 2007-02-07 12:30:00 | AAPL | Stock | 3.0536 | 3.0825 | 3.0507 | 3.0811 | 105057932.0 |
| 2007-02-07 13:00:00 | AAPL | Stock | 3.0814 | 3.085 | 3.0704 | 3.0743 | 76190912.0 |
| 2007-02-07 13:30:00 | AAPL | Stock | 3.0746 | 3.0754 | 3.0604 | 3.0643 | 55280652.0 |
| 2007-02-07 14:00:00 | AAPL | Stock | 3.0661 | 3.075 | 3.0557 | 3.0721 | 84731640.0 |
| 2007-02-07 14:30:00 | AAPL | Stock | 3.0714 | 3.0739 | 3.05 | 3.0582 | 74635596.0 |
| 2007-02-07 15:00:00 | AAPL | Stock | 3.0586 | 3.0711 | 3.0582 | 3.0639 | 56983108.0 |
| 2007-02-07 15:30:00 | AAPL | Stock | 3.0642 | 3.0771 | 3.0589 | 3.0768 | 87746904.0 |
| 2007-02-07 16:00:00 | AAPL | Stock | 3.0764 | 3.0786 | 3.0214 | 3.0786 | 23883356.0 |
| 2007-02-07 16:30:00 | AAPL | Stock | 3.0786 | 3.0804 | 3.0771 | 3.0804 | 792960.0 |
| 2007-02-07 17:00:00 | AAPL | Stock | 3.0796 | 3.0864 | 3.0768 | 3.0864 | 3924648.0 |
| 2007-02-07 17:30:00 | AAPL | Stock | 3.0864 | 3.0904 | 3.0818 | 3.0893 | 1271172.0 |
| 2007-02-07 18:00:00 | AAPL | Stock | 3.0907 | 3.0979 | 3.0893 | 3.0964 | 878304.0 |
| 2007-02-07 18:30:00 | AAPL | Stock | 3.0964 | 3.0982 | 3.0765 | 3.0946 | 545020.0 |
| 2007-02-07 19:00:00 | AAPL | Stock | 3.0946 | 3.0975 | 3.0929 | 3.0975 | 169008.0 |
| 2007-02-07 19:30:00 | AAPL | Stock | 3.0932 | 3.1018 | 3.0929 | 3.1 | 393876.0 |
| 2007-02-07 08:00:00 | MSFT | Stock | 29.55 | 29.6 | 29.5 | 29.58 | 8960.0 |
| 2007-02-07 08:30:00 | MSFT | Stock | 29.58 | 29.65 | 29.58 | 29.63 | 17600.0 |
| 2007-02-07 09:00:00 | MSFT | Stock | 29.64 | 29.68 | 29.63 | 29.65 | 62893.0 |
| 2007-02-07 09:30:00 | MSFT | Stock | 29.64 | 29.68 | 29.25 | 29.41 | 11103465.0 |
| 2007-02-07 10:00:00 | MSFT | Stock | 29.4 | 29.55 | 29.35 | 29.48 | 6079517.0 |
| 2007-02-07 10:30:00 | MSFT | Stock | 29.49 | 29.7 | 29.45 | 29.59 | 7243463.0 |
| 2007-02-07 11:00:00 | MSFT | Stock | 29.59 | 29.6 | 29.5 | 29.55 | 3427377.0 |
| 2007-02-07 11:30:00 | MSFT | Stock | 29.54 | 29.57 | 29.42 | 29.45 | 2017633.0 |
| 2007-02-07 12:00:00 | MSFT | Stock | 29.457 | 29.64 | 29.41 | 29.42 | 2370432.0 |
| 2007-02-07 12:30:00 | MSFT | Stock | 29.42 | 29.46 | 29.41 | 29.44 | 1475341.0 |
| 2007-02-07 13:00:00 | MSFT | Stock | 29.432 | 29.46 | 29.43 | 29.43 | 2671611.0 |
| 2007-02-07 13:30:00 | MSFT | Stock | 29.43 | 29.45 | 29.4 | 29.42 | 4124010.0 |
| 2007-02-07 14:00:00 | MSFT | Stock | 29.42 | 29.45 | 29.4 | 29.42 | 2647025.0 |
| 2007-02-07 14:30:00 | MSFT | Stock | 29.42 | 29.43 | 29.34 | 29.4 | 8528279.0 |
| 2007-02-07 15:00:00 | MSFT | Stock | 29.34 | 29.37 | 29.34 | 29.36 | 3637940.0 |
| 2007-02-07 15:30:00 | MSFT | Stock | 29.36 | 29.46 | 29.34 | 29.372 | 7745439.0 |
| 2007-02-07 16:00:00 | MSFT | Stock | 29.38 | 29.4 | 29.35 | 29.38 | 112574.0 |
| 2007-02-07 16:30:00 | MSFT | Stock | 29.39 | 29.39 | 29.38 | 29.39 | 380625.0 |
| 2007-02-07 17:00:00 | MSFT | Stock | 29.39 | 29.4 | 29.39 | 29.4 | 4700.0 |
| 2007-02-07 17:30:00 | MSFT | Stock | 29.4 | 29.4 | 29.39 | 29.39 | 4739.0 |
| 2007-02-07 18:00:00 | MSFT | Stock | 29.4 | 29.4 | 29.4 | 29.4 | 2050.0 |
| 2007-02-07 18:30:00 | MSFT | Stock | 29.39 | 29.39 | 29.38 | 29.38 | 2560.0 |
| 2007-02-07 19:00:00 | MSFT | Stock | 29.39 | 29.39 | 29.39 | 29.39 | 219.0 |
| 2007-02-07 19:30:00 | MSFT | Stock | 29.4 | 29.43 | 29.4 | 29.43 | 1300.0 |
| 2007-02-07 07:30:00 | NVDA | Stock | 0.5625 | 0.5625 | 0.5625 | 0.5625 | 12000.0 |
> showing 50 of 53,247 rows — these rows as CSV