PREVIEW / stock_30min / 2007-09-04
file: by_date/stock_30min/2007/2007-09-04.parquet size: 1.1 MB rows: 64,333 symbols: 3,105
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-09-04 09:30:00 | AAPL | Stock | 4.9979 | 5.0875 | 4.9943 | 5.0723 | 211926484.0 |
| 2007-09-04 10:00:00 | AAPL | Stock | 5.0729 | 5.105 | 5.0679 | 5.0986 | 122861060.0 |
| 2007-09-04 10:30:00 | AAPL | Stock | 5.0986 | 5.1169 | 5.0714 | 5.0968 | 112283108.0 |
| 2007-09-04 11:00:00 | AAPL | Stock | 5.0968 | 5.1107 | 5.0906 | 5.1039 | 64622796.0 |
| 2007-09-04 11:30:00 | AAPL | Stock | 5.1043 | 5.1089 | 5.0954 | 5.1032 | 42133476.0 |
| 2007-09-04 12:00:00 | AAPL | Stock | 5.1032 | 5.1086 | 5.0925 | 5.1021 | 47194980.0 |
| 2007-09-04 12:30:00 | AAPL | Stock | 5.1025 | 5.1211 | 5.1014 | 5.1125 | 49101388.0 |
| 2007-09-04 13:00:00 | AAPL | Stock | 5.1129 | 5.1304 | 5.1079 | 5.129 | 48521928.0 |
| 2007-09-04 13:30:00 | AAPL | Stock | 5.129 | 5.1486 | 5.1232 | 5.1457 | 65171736.0 |
| 2007-09-04 14:00:00 | AAPL | Stock | 5.1457 | 5.1468 | 5.1332 | 5.1421 | 50503152.0 |
| 2007-09-04 14:30:00 | AAPL | Stock | 5.1421 | 5.1782 | 5.1414 | 5.1721 | 70447300.0 |
| 2007-09-04 15:00:00 | AAPL | Stock | 5.1721 | 5.1964 | 5.1679 | 5.195 | 97481580.0 |
| 2007-09-04 15:30:00 | AAPL | Stock | 5.195 | 5.2046 | 5.1211 | 5.1489 | 187064668.0 |
| 2007-09-04 16:00:00 | AAPL | Stock | 5.1493 | 5.1496 | 5.1486 | 5.1486 | 11829664.0 |
| 2007-09-04 09:30:00 | MSFT | Stock | 28.5 | 28.77 | 28.48 | 28.74 | 4215290.0 |
| 2007-09-04 10:00:00 | MSFT | Stock | 28.75 | 28.92 | 28.74 | 28.9 | 4132644.0 |
| 2007-09-04 10:30:00 | MSFT | Stock | 28.89 | 29.0 | 28.86 | 28.94 | 2903978.0 |
| 2007-09-04 11:00:00 | MSFT | Stock | 28.93 | 29.06 | 28.92 | 29.02 | 2626976.0 |
| 2007-09-04 11:30:00 | MSFT | Stock | 29.03 | 29.05 | 28.86 | 28.88 | 1825317.0 |
| 2007-09-04 12:00:00 | MSFT | Stock | 28.88 | 28.921 | 28.84 | 28.89 | 1241340.0 |
| 2007-09-04 12:30:00 | MSFT | Stock | 28.9 | 28.98 | 28.89 | 28.95 | 1113453.0 |
| 2007-09-04 13:00:00 | MSFT | Stock | 28.95 | 29.04 | 28.9 | 29.031 | 1582988.0 |
| 2007-09-04 13:30:00 | MSFT | Stock | 29.031 | 29.04 | 28.98 | 29.02 | 1790421.0 |
| 2007-09-04 14:00:00 | MSFT | Stock | 29.02 | 29.07 | 28.99 | 29.03 | 2131891.0 |
| 2007-09-04 14:30:00 | MSFT | Stock | 29.03 | 29.04 | 28.98 | 29.0 | 2173761.0 |
| 2007-09-04 15:00:00 | MSFT | Stock | 29.01 | 29.1 | 28.93 | 29.09 | 2719748.0 |
| 2007-09-04 15:30:00 | MSFT | Stock | 29.09 | 29.09 | 28.79 | 28.81 | 7266442.0 |
| 2007-09-04 16:00:00 | MSFT | Stock | 28.81 | 28.82 | 28.8 | 28.81 | 2037518.0 |
| 2007-09-04 07:30:00 | NVDA | Stock | 0.8432 | 0.8432 | 0.8432 | 0.8432 | 30000.0 |
| 2007-09-04 08:00:00 | NVDA | Stock | 0.8538 | 0.86 | 0.8523 | 0.8568 | 1362420.0 |
| 2007-09-04 08:30:00 | NVDA | Stock | 0.8542 | 0.8558 | 0.8542 | 0.8558 | 78300.0 |
| 2007-09-04 09:00:00 | NVDA | Stock | 0.8567 | 0.8575 | 0.8527 | 0.8562 | 393420.0 |
| 2007-09-04 09:30:00 | NVDA | Stock | 0.8565 | 0.8815 | 0.8432 | 0.8797 | 108357240.0 |
| 2007-09-04 10:00:00 | NVDA | Stock | 0.8802 | 0.8813 | 0.8743 | 0.8777 | 58511280.0 |
| 2007-09-04 10:30:00 | NVDA | Stock | 0.8777 | 0.8803 | 0.8752 | 0.8758 | 45694980.0 |
| 2007-09-04 11:00:00 | NVDA | Stock | 0.8758 | 0.8768 | 0.8717 | 0.874 | 46518240.0 |
| 2007-09-04 11:30:00 | NVDA | Stock | 0.8738 | 0.877 | 0.871 | 0.872 | 26586480.0 |
| 2007-09-04 12:00:00 | NVDA | Stock | 0.872 | 0.8725 | 0.8668 | 0.8685 | 29730840.0 |
| 2007-09-04 12:30:00 | NVDA | Stock | 0.8685 | 0.8705 | 0.865 | 0.8685 | 27495660.0 |
| 2007-09-04 13:00:00 | NVDA | Stock | 0.8685 | 0.8688 | 0.8633 | 0.8638 | 25767300.0 |
| 2007-09-04 13:30:00 | NVDA | Stock | 0.8637 | 0.873 | 0.8633 | 0.8707 | 36328800.0 |
| 2007-09-04 14:00:00 | NVDA | Stock | 0.8707 | 0.8782 | 0.8705 | 0.8775 | 36340920.0 |
| 2007-09-04 14:30:00 | NVDA | Stock | 0.8773 | 0.879 | 0.8752 | 0.877 | 32670120.0 |
| 2007-09-04 15:00:00 | NVDA | Stock | 0.877 | 0.88 | 0.8748 | 0.8798 | 35765160.0 |
| 2007-09-04 15:30:00 | NVDA | Stock | 0.88 | 0.8827 | 0.8753 | 0.879 | 76658700.0 |
| 2007-09-04 16:00:00 | NVDA | Stock | 0.8783 | 0.879 | 0.8758 | 0.8768 | 4247340.0 |
| 2007-09-04 16:30:00 | NVDA | Stock | 0.8767 | 0.8767 | 0.8767 | 0.8767 | 21900.0 |
| 2007-09-04 17:00:00 | NVDA | Stock | 0.8758 | 0.8768 | 0.8758 | 0.8758 | 54240.0 |
| 2007-09-04 17:30:00 | NVDA | Stock | 0.8767 | 0.8768 | 0.8767 | 0.8768 | 48000.0 |
| 2007-09-04 18:00:00 | NVDA | Stock | 0.875 | 0.875 | 0.875 | 0.875 | 25740.0 |
> showing 50 of 64,333 rows — these rows as CSV