PREVIEW / stock_30min / 2005-07-26
file: by_date/stock_30min/2005/2005-07-26.parquet size: 821 KB rows: 44,746 symbols: 2,054
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 |
|---|---|---|---|---|---|---|---|
| 2005-07-26 08:00:00 | AAPL | Stock | 1.5671 | 1.5671 | 1.5654 | 1.5654 | 30800.0 |
| 2005-07-26 08:30:00 | AAPL | Stock | 1.5671 | 1.5743 | 1.5664 | 1.5711 | 217056.0 |
| 2005-07-26 09:00:00 | AAPL | Stock | 1.5704 | 1.5746 | 1.5696 | 1.5714 | 4494336.0 |
| 2005-07-26 09:30:00 | AAPL | Stock | 1.5718 | 1.5729 | 1.5639 | 1.57 | 44070516.0 |
| 2005-07-26 10:00:00 | AAPL | Stock | 1.5704 | 1.5754 | 1.5679 | 1.57 | 34097504.0 |
| 2005-07-26 10:30:00 | AAPL | Stock | 1.5707 | 1.5714 | 1.5507 | 1.5529 | 38586324.0 |
| 2005-07-26 11:00:00 | AAPL | Stock | 1.5532 | 1.5589 | 1.5486 | 1.5493 | 17959872.0 |
| 2005-07-26 11:30:00 | AAPL | Stock | 1.5489 | 1.5568 | 1.5489 | 1.5564 | 17894268.0 |
| 2005-07-26 12:00:00 | AAPL | Stock | 1.5564 | 1.5564 | 1.5486 | 1.5493 | 11713604.0 |
| 2005-07-26 12:30:00 | AAPL | Stock | 1.5496 | 1.5568 | 1.5486 | 1.5536 | 11256280.0 |
| 2005-07-26 13:00:00 | AAPL | Stock | 1.5532 | 1.5568 | 1.5525 | 1.5529 | 7672364.0 |
| 2005-07-26 13:30:00 | AAPL | Stock | 1.5525 | 1.5636 | 1.5511 | 1.5632 | 15951684.0 |
| 2005-07-26 14:00:00 | AAPL | Stock | 1.5632 | 1.5664 | 1.5621 | 1.5636 | 14068152.0 |
| 2005-07-26 14:30:00 | AAPL | Stock | 1.5636 | 1.5661 | 1.5618 | 1.5636 | 11122552.0 |
| 2005-07-26 15:00:00 | AAPL | Stock | 1.5636 | 1.5639 | 1.5575 | 1.5604 | 13489952.0 |
| 2005-07-26 15:30:00 | AAPL | Stock | 1.5604 | 1.5614 | 1.5564 | 1.5564 | 18042136.0 |
| 2005-07-26 16:00:00 | AAPL | Stock | 1.5568 | 1.5607 | 1.5564 | 1.5582 | 893396.0 |
| 2005-07-26 16:30:00 | AAPL | Stock | 1.5568 | 1.5571 | 1.5564 | 1.5564 | 94360.0 |
| 2005-07-26 17:00:00 | AAPL | Stock | 1.5571 | 1.5571 | 1.5564 | 1.5564 | 107800.0 |
| 2005-07-26 17:30:00 | AAPL | Stock | 1.5564 | 1.5593 | 1.5543 | 1.5593 | 771960.0 |
| 2005-07-26 08:00:00 | MSFT | Stock | 25.75 | 26.1 | 25.66 | 25.7 | 35800.0 |
| 2005-07-26 08:30:00 | MSFT | Stock | 25.7 | 25.72 | 25.7 | 25.7 | 8821.0 |
| 2005-07-26 09:00:00 | MSFT | Stock | 25.7 | 25.73 | 25.7 | 25.72 | 35037.0 |
| 2005-07-26 09:30:00 | MSFT | Stock | 25.72 | 25.74 | 25.65 | 25.72 | 5357694.0 |
| 2005-07-26 10:00:00 | MSFT | Stock | 25.73 | 25.73 | 25.65 | 25.67 | 5163069.0 |
| 2005-07-26 10:30:00 | MSFT | Stock | 25.67 | 25.71 | 25.61 | 25.65 | 4352957.0 |
| 2005-07-26 11:00:00 | MSFT | Stock | 25.65 | 25.67 | 25.64 | 25.65 | 1992757.0 |
| 2005-07-26 11:30:00 | MSFT | Stock | 25.66 | 25.7 | 25.64 | 25.68 | 2645275.0 |
| 2005-07-26 12:00:00 | MSFT | Stock | 25.67 | 25.7 | 25.58 | 25.6 | 3577989.0 |
| 2005-07-26 12:30:00 | MSFT | Stock | 25.6 | 25.63 | 25.56 | 25.57 | 2493332.0 |
| 2005-07-26 13:00:00 | MSFT | Stock | 25.57 | 25.59 | 25.56 | 25.56 | 1273285.0 |
| 2005-07-26 13:30:00 | MSFT | Stock | 25.56 | 25.62 | 25.53 | 25.6 | 4432743.0 |
| 2005-07-26 14:00:00 | MSFT | Stock | 25.6 | 25.61 | 25.55 | 25.56 | 2539077.0 |
| 2005-07-26 14:30:00 | MSFT | Stock | 25.55 | 25.62 | 25.53 | 25.56 | 3866340.0 |
| 2005-07-26 15:00:00 | MSFT | Stock | 25.56 | 25.64 | 25.539 | 25.64 | 3827897.0 |
| 2005-07-26 15:30:00 | MSFT | Stock | 25.64 | 25.66 | 25.54 | 25.54 | 7333964.0 |
| 2005-07-26 16:00:00 | MSFT | Stock | 25.55 | 25.583 | 25.52 | 25.52 | 499534.0 |
| 2005-07-26 16:30:00 | MSFT | Stock | 25.55 | 25.55 | 25.53 | 25.54 | 73466.0 |
| 2005-07-26 17:00:00 | MSFT | Stock | 25.53 | 25.55 | 25.53 | 25.54 | 4778.0 |
| 2005-07-26 17:30:00 | MSFT | Stock | 25.54 | 25.55 | 25.53 | 25.55 | 581750.0 |
| 2005-07-26 18:00:00 | MSFT | Stock | 25.542 | 25.55 | 25.52 | 25.55 | 2595139.0 |
| 2005-07-26 07:30:00 | NVDA | Stock | 0.215 | 0.215 | 0.2133 | 0.2133 | 288000.0 |
| 2005-07-26 08:00:00 | NVDA | Stock | 0.2133 | 0.2171 | 0.2133 | 0.2171 | 3270000.0 |
| 2005-07-26 08:30:00 | NVDA | Stock | 0.2167 | 0.2167 | 0.2167 | 0.2167 | 48000.0 |
| 2005-07-26 09:00:00 | NVDA | Stock | 0.2164 | 0.2164 | 0.2147 | 0.216 | 10128000.0 |
| 2005-07-26 09:30:00 | NVDA | Stock | 0.2156 | 0.2189 | 0.2147 | 0.2183 | 93252840.0 |
| 2005-07-26 10:00:00 | NVDA | Stock | 0.2182 | 0.2185 | 0.2164 | 0.2169 | 60574920.0 |
| 2005-07-26 10:30:00 | NVDA | Stock | 0.2169 | 0.2172 | 0.2163 | 0.2168 | 85438800.0 |
| 2005-07-26 11:00:00 | NVDA | Stock | 0.2168 | 0.2183 | 0.2166 | 0.2177 | 42617040.0 |
| 2005-07-26 11:30:00 | NVDA | Stock | 0.2178 | 0.2184 | 0.2168 | 0.218 | 48116880.0 |
> showing 50 of 44,746 rows — these rows as CSV