PREVIEW / stock_30min / 2006-09-20
file: by_date/stock_30min/2006/2006-09-20.parquet size: 934 KB rows: 50,750 symbols: 2,375
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 |
|---|---|---|---|---|---|---|---|
| 2006-09-20 07:00:00 | AAPL | Stock | 2.6443 | 2.6443 | 2.6429 | 2.6429 | 19600.0 |
| 2006-09-20 08:00:00 | AAPL | Stock | 2.65 | 2.6518 | 2.6429 | 2.6489 | 450184.0 |
| 2006-09-20 08:30:00 | AAPL | Stock | 2.6493 | 2.6579 | 2.6346 | 2.655 | 778456.0 |
| 2006-09-20 09:00:00 | AAPL | Stock | 2.6539 | 2.6596 | 2.6539 | 2.6561 | 1013824.0 |
| 2006-09-20 09:30:00 | AAPL | Stock | 2.6564 | 2.6786 | 2.6507 | 2.6664 | 106275792.0 |
| 2006-09-20 10:00:00 | AAPL | Stock | 2.6664 | 2.6775 | 2.6575 | 2.6761 | 59608248.0 |
| 2006-09-20 10:30:00 | AAPL | Stock | 2.6764 | 2.6889 | 2.6689 | 2.6886 | 94392116.0 |
| 2006-09-20 11:00:00 | AAPL | Stock | 2.6882 | 2.7018 | 2.6861 | 2.6995 | 94814412.0 |
| 2006-09-20 11:30:00 | AAPL | Stock | 2.6993 | 2.7029 | 2.6904 | 2.6921 | 49245252.0 |
| 2006-09-20 12:00:00 | AAPL | Stock | 2.692 | 2.6982 | 2.6879 | 2.6936 | 27118952.0 |
| 2006-09-20 12:30:00 | AAPL | Stock | 2.6939 | 2.6964 | 2.6864 | 2.6864 | 23284828.0 |
| 2006-09-20 13:00:00 | AAPL | Stock | 2.6864 | 2.6907 | 2.6839 | 2.6896 | 22510740.0 |
| 2006-09-20 13:30:00 | AAPL | Stock | 2.6893 | 2.6936 | 2.6864 | 2.69 | 21634256.0 |
| 2006-09-20 14:00:00 | AAPL | Stock | 2.6904 | 2.6943 | 2.6754 | 2.6775 | 76326796.0 |
| 2006-09-20 14:30:00 | AAPL | Stock | 2.6771 | 2.6839 | 2.6661 | 2.6771 | 87216360.0 |
| 2006-09-20 15:00:00 | AAPL | Stock | 2.6768 | 2.6871 | 2.6729 | 2.6857 | 64154216.0 |
| 2006-09-20 15:30:00 | AAPL | Stock | 2.6854 | 2.6925 | 2.6825 | 2.6921 | 74831344.0 |
| 2006-09-20 16:00:00 | AAPL | Stock | 2.6918 | 2.7011 | 2.6907 | 2.7011 | 2400804.0 |
| 2006-09-20 16:30:00 | AAPL | Stock | 2.7011 | 2.7011 | 2.6929 | 2.6936 | 1986460.0 |
| 2006-09-20 17:00:00 | AAPL | Stock | 2.6929 | 2.6946 | 2.6929 | 2.6929 | 190260.0 |
| 2006-09-20 17:30:00 | AAPL | Stock | 2.6936 | 2.6946 | 2.6921 | 2.6946 | 138600.0 |
| 2006-09-20 18:00:00 | AAPL | Stock | 2.6946 | 2.6961 | 2.6943 | 2.6946 | 25200.0 |
| 2006-09-20 18:30:00 | AAPL | Stock | 2.6964 | 2.6964 | 2.6961 | 2.6964 | 151200.0 |
| 2006-09-20 19:00:00 | AAPL | Stock | 2.6964 | 2.6964 | 2.6964 | 2.6964 | 21840.0 |
| 2006-09-20 07:00:00 | MSFT | Stock | 27.06 | 27.06 | 27.0 | 27.0 | 900.0 |
| 2006-09-20 07:30:00 | MSFT | Stock | 27.1 | 27.1 | 27.03 | 27.1 | 2160.0 |
| 2006-09-20 08:00:00 | MSFT | Stock | 27.1 | 27.12 | 26.86 | 27.1 | 327200.0 |
| 2006-09-20 08:30:00 | MSFT | Stock | 27.1 | 27.1 | 27.04 | 27.04 | 35635.0 |
| 2006-09-20 09:00:00 | MSFT | Stock | 27.05 | 27.09 | 26.99 | 26.99 | 155356.0 |
| 2006-09-20 09:30:00 | MSFT | Stock | 27.01 | 27.15 | 26.99 | 27.09 | 6725901.0 |
| 2006-09-20 10:00:00 | MSFT | Stock | 27.098 | 27.19 | 27.02 | 27.18 | 6003247.0 |
| 2006-09-20 10:30:00 | MSFT | Stock | 27.188 | 27.19 | 27.1 | 27.16 | 5319312.0 |
| 2006-09-20 11:00:00 | MSFT | Stock | 27.16 | 27.19 | 27.09 | 27.12 | 5639024.0 |
| 2006-09-20 11:30:00 | MSFT | Stock | 27.12 | 27.16 | 27.0 | 27.11 | 3942068.0 |
| 2006-09-20 12:00:00 | MSFT | Stock | 27.11 | 27.13 | 27.1 | 27.11 | 2058838.0 |
| 2006-09-20 12:30:00 | MSFT | Stock | 27.11 | 27.16 | 27.11 | 27.13 | 3182686.0 |
| 2006-09-20 13:00:00 | MSFT | Stock | 27.13 | 27.14 | 27.1 | 27.14 | 2025982.0 |
| 2006-09-20 13:30:00 | MSFT | Stock | 27.13 | 27.19 | 27.13 | 27.17 | 3272306.0 |
| 2006-09-20 14:00:00 | MSFT | Stock | 27.18 | 27.19 | 27.09 | 27.1 | 7055530.0 |
| 2006-09-20 14:30:00 | MSFT | Stock | 27.1 | 27.2 | 27.09 | 27.173 | 6043508.0 |
| 2006-09-20 15:00:00 | MSFT | Stock | 27.17 | 27.23 | 27.14 | 27.19 | 6188855.0 |
| 2006-09-20 15:30:00 | MSFT | Stock | 27.2 | 27.21 | 27.11 | 27.19 | 9199743.0 |
| 2006-09-20 16:00:00 | MSFT | Stock | 27.19 | 27.21 | 27.15 | 27.16 | 267377.0 |
| 2006-09-20 16:30:00 | MSFT | Stock | 27.18 | 27.18 | 27.16 | 27.16 | 8464.0 |
| 2006-09-20 17:00:00 | MSFT | Stock | 27.18 | 27.18 | 27.16 | 27.16 | 1880.0 |
| 2006-09-20 17:30:00 | MSFT | Stock | 27.18 | 27.18 | 27.16 | 27.16 | 1100.0 |
| 2006-09-20 18:00:00 | MSFT | Stock | 27.17 | 27.17 | 27.16 | 27.17 | 1240.0 |
| 2006-09-20 08:00:00 | NVDA | Stock | 0.5017 | 0.5018 | 0.5 | 0.5018 | 48000.0 |
| 2006-09-20 08:30:00 | NVDA | Stock | 0.5022 | 0.5022 | 0.5022 | 0.5022 | 7200.0 |
| 2006-09-20 09:00:00 | NVDA | Stock | 0.5033 | 0.5042 | 0.5017 | 0.5017 | 351000.0 |
> showing 50 of 50,750 rows — these rows as CSV