PREVIEW / stock_30min / 2007-02-06
file: by_date/stock_30min/2007/2007-02-06.parquet size: 984 KB rows: 53,633 symbols: 2,502
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-06 06:30:00 | AAPL | Stock | 3.0089 | 3.0114 | 3.0089 | 3.0114 | 8400.0 |
| 2007-02-06 07:00:00 | AAPL | Stock | 3.0125 | 3.0125 | 3.0114 | 3.0114 | 7560.0 |
| 2007-02-06 07:30:00 | AAPL | Stock | 3.0114 | 3.0121 | 3.0096 | 3.0096 | 11200.0 |
| 2007-02-06 08:00:00 | AAPL | Stock | 3.0107 | 3.0171 | 3.0036 | 3.0104 | 546952.0 |
| 2007-02-06 08:30:00 | AAPL | Stock | 3.0104 | 3.0132 | 3.0018 | 3.0036 | 1278200.0 |
| 2007-02-06 09:00:00 | AAPL | Stock | 3.0036 | 3.0161 | 3.0018 | 3.0161 | 3250884.0 |
| 2007-02-06 09:30:00 | AAPL | Stock | 3.0161 | 3.0168 | 2.9929 | 2.9975 | 80005380.0 |
| 2007-02-06 10:00:00 | AAPL | Stock | 2.9971 | 3.0161 | 2.9929 | 3.0054 | 64911504.0 |
| 2007-02-06 10:30:00 | AAPL | Stock | 3.005 | 3.0057 | 2.9804 | 2.9814 | 73139640.0 |
| 2007-02-06 11:00:00 | AAPL | Stock | 2.9818 | 2.9886 | 2.9707 | 2.9775 | 63294672.0 |
| 2007-02-06 11:30:00 | AAPL | Stock | 2.9781 | 3.0039 | 2.9657 | 2.9661 | 50757728.0 |
| 2007-02-06 12:00:00 | AAPL | Stock | 2.9661 | 2.9761 | 2.9593 | 2.9664 | 52309124.0 |
| 2007-02-06 12:30:00 | AAPL | Stock | 2.9661 | 3.0007 | 2.9625 | 2.9725 | 46119360.0 |
| 2007-02-06 13:00:00 | AAPL | Stock | 2.9725 | 2.9818 | 2.9714 | 2.9743 | 32129132.0 |
| 2007-02-06 13:30:00 | AAPL | Stock | 2.9739 | 2.9829 | 2.9736 | 2.9782 | 30777908.0 |
| 2007-02-06 14:00:00 | AAPL | Stock | 2.9782 | 2.9818 | 2.9693 | 2.9761 | 31656240.0 |
| 2007-02-06 14:30:00 | AAPL | Stock | 2.9757 | 2.9839 | 2.9714 | 2.9839 | 33460588.0 |
| 2007-02-06 15:00:00 | AAPL | Stock | 2.9839 | 3.0161 | 2.9825 | 2.995 | 186172560.0 |
| 2007-02-06 15:30:00 | AAPL | Stock | 2.995 | 3.0118 | 2.9946 | 3.0032 | 102284784.0 |
| 2007-02-06 16:00:00 | AAPL | Stock | 3.0029 | 3.0054 | 2.9964 | 2.9989 | 2149812.0 |
| 2007-02-06 16:30:00 | AAPL | Stock | 2.9975 | 3.0114 | 2.9975 | 3.0114 | 2217152.0 |
| 2007-02-06 17:00:00 | AAPL | Stock | 3.0093 | 3.0125 | 3.0061 | 3.0071 | 734216.0 |
| 2007-02-06 17:30:00 | AAPL | Stock | 3.0089 | 3.0139 | 3.0089 | 3.0125 | 266196.0 |
| 2007-02-06 18:00:00 | AAPL | Stock | 3.0107 | 3.0125 | 3.0089 | 3.0118 | 227388.0 |
| 2007-02-06 18:30:00 | AAPL | Stock | 3.0118 | 3.0129 | 3.0104 | 3.0118 | 200732.0 |
| 2007-02-06 19:00:00 | AAPL | Stock | 3.0096 | 3.0129 | 3.0086 | 3.0125 | 181048.0 |
| 2007-02-06 19:30:00 | AAPL | Stock | 3.0121 | 3.0136 | 3.0089 | 3.0129 | 113876.0 |
| 2007-02-06 08:00:00 | MSFT | Stock | 29.58 | 29.6 | 29.5 | 29.56 | 14750.0 |
| 2007-02-06 08:30:00 | MSFT | Stock | 29.58 | 29.58 | 29.53 | 29.54 | 10995.0 |
| 2007-02-06 09:00:00 | MSFT | Stock | 29.54 | 29.61 | 29.51 | 29.6 | 69684.0 |
| 2007-02-06 09:30:00 | MSFT | Stock | 29.59 | 29.75 | 29.49 | 29.62 | 10669137.0 |
| 2007-02-06 10:00:00 | MSFT | Stock | 29.63 | 29.68 | 29.57 | 29.62 | 4830181.0 |
| 2007-02-06 10:30:00 | MSFT | Stock | 29.62 | 29.63 | 29.51 | 29.51 | 8538821.0 |
| 2007-02-06 11:00:00 | MSFT | Stock | 29.52 | 29.54 | 29.48 | 29.51 | 4042218.0 |
| 2007-02-06 11:30:00 | MSFT | Stock | 29.51 | 29.54 | 29.42 | 29.42 | 6291178.0 |
| 2007-02-06 12:00:00 | MSFT | Stock | 29.42 | 29.49 | 29.29 | 29.37 | 5125771.0 |
| 2007-02-06 12:30:00 | MSFT | Stock | 29.37 | 29.39 | 29.22 | 29.25 | 6223899.0 |
| 2007-02-06 13:00:00 | MSFT | Stock | 29.25 | 29.38 | 29.24 | 29.36 | 6876739.0 |
| 2007-02-06 13:30:00 | MSFT | Stock | 29.36 | 29.48 | 29.348 | 29.42 | 3636953.0 |
| 2007-02-06 14:00:00 | MSFT | Stock | 29.43 | 29.51 | 29.39 | 29.46 | 4169423.0 |
| 2007-02-06 14:30:00 | MSFT | Stock | 29.46 | 29.55 | 29.46 | 29.52 | 4760321.0 |
| 2007-02-06 15:00:00 | MSFT | Stock | 29.53 | 29.57 | 29.48 | 29.55 | 4711772.0 |
| 2007-02-06 15:30:00 | MSFT | Stock | 29.55 | 29.6 | 29.46 | 29.5 | 6749092.0 |
| 2007-02-06 16:00:00 | MSFT | Stock | 29.51 | 29.579 | 29.45 | 29.49 | 159438.0 |
| 2007-02-06 16:30:00 | MSFT | Stock | 29.47 | 29.56 | 29.47 | 29.56 | 161188.0 |
| 2007-02-06 17:00:00 | MSFT | Stock | 29.56 | 29.58 | 29.56 | 29.58 | 8014.0 |
| 2007-02-06 17:30:00 | MSFT | Stock | 29.55 | 29.56 | 29.55 | 29.56 | 3200.0 |
| 2007-02-06 18:00:00 | MSFT | Stock | 29.56 | 29.59 | 29.51 | 29.58 | 335000.0 |
| 2007-02-06 18:30:00 | MSFT | Stock | 29.51 | 29.56 | 29.51 | 29.56 | 36100.0 |
| 2007-02-06 19:00:00 | MSFT | Stock | 29.56 | 29.58 | 29.56 | 29.58 | 1200.0 |
> showing 50 of 53,633 rows — these rows as CSV