PREVIEW / stock_30min / 2006-09-25
file: by_date/stock_30min/2006/2006-09-25.parquet size: 933 KB rows: 50,713 symbols: 2,380
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-25 07:00:00 | AAPL | Stock | 2.6239 | 2.6357 | 2.6239 | 2.6286 | 11200.0 |
| 2006-09-25 07:30:00 | AAPL | Stock | 2.6339 | 2.6339 | 2.6339 | 2.6339 | 14000.0 |
| 2006-09-25 08:00:00 | AAPL | Stock | 2.6354 | 2.6364 | 2.6264 | 2.6311 | 2891252.0 |
| 2006-09-25 08:30:00 | AAPL | Stock | 2.6318 | 2.6336 | 2.6286 | 2.6325 | 1260308.0 |
| 2006-09-25 09:00:00 | AAPL | Stock | 2.6332 | 2.6379 | 2.6304 | 2.6357 | 3263624.0 |
| 2006-09-25 09:30:00 | AAPL | Stock | 2.6361 | 2.6636 | 2.6329 | 2.6611 | 115008264.0 |
| 2006-09-25 10:00:00 | AAPL | Stock | 2.6611 | 2.6668 | 2.6436 | 2.6475 | 106682632.0 |
| 2006-09-25 10:30:00 | AAPL | Stock | 2.6471 | 2.66 | 2.6357 | 2.6564 | 70942984.0 |
| 2006-09-25 11:00:00 | AAPL | Stock | 2.6561 | 2.6818 | 2.6543 | 2.6761 | 90932968.0 |
| 2006-09-25 11:30:00 | AAPL | Stock | 2.6764 | 2.6796 | 2.6686 | 2.6704 | 42288260.0 |
| 2006-09-25 12:00:00 | AAPL | Stock | 2.6704 | 2.6875 | 2.6679 | 2.6846 | 56097356.0 |
| 2006-09-25 12:30:00 | AAPL | Stock | 2.6839 | 2.6982 | 2.6836 | 2.6939 | 49225568.0 |
| 2006-09-25 13:00:00 | AAPL | Stock | 2.6939 | 2.7018 | 2.6879 | 2.6925 | 53241272.0 |
| 2006-09-25 13:30:00 | AAPL | Stock | 2.6925 | 2.6943 | 2.6846 | 2.6861 | 28859824.0 |
| 2006-09-25 14:00:00 | AAPL | Stock | 2.6864 | 2.6964 | 2.6857 | 2.6893 | 44019304.0 |
| 2006-09-25 14:30:00 | AAPL | Stock | 2.6889 | 2.6986 | 2.6886 | 2.6943 | 41832336.0 |
| 2006-09-25 15:00:00 | AAPL | Stock | 2.6946 | 2.7093 | 2.6929 | 2.7068 | 69324864.0 |
| 2006-09-25 15:30:00 | AAPL | Stock | 2.7068 | 2.7086 | 2.7 | 2.7071 | 70536424.0 |
| 2006-09-25 16:00:00 | AAPL | Stock | 2.7071 | 2.7089 | 2.7036 | 2.7036 | 1579284.0 |
| 2006-09-25 16:30:00 | AAPL | Stock | 2.7054 | 2.7064 | 2.7036 | 2.7036 | 327488.0 |
| 2006-09-25 17:00:00 | AAPL | Stock | 2.7054 | 2.7071 | 2.7054 | 2.7071 | 90860.0 |
| 2006-09-25 17:30:00 | AAPL | Stock | 2.7071 | 2.7082 | 2.7068 | 2.7068 | 105280.0 |
| 2006-09-25 18:00:00 | AAPL | Stock | 2.7068 | 2.7143 | 2.7068 | 2.7104 | 154672.0 |
| 2006-09-25 18:30:00 | AAPL | Stock | 2.7104 | 2.7143 | 2.7104 | 2.7139 | 178948.0 |
| 2006-09-25 19:00:00 | AAPL | Stock | 2.7139 | 2.7139 | 2.7125 | 2.7139 | 173600.0 |
| 2006-09-25 19:30:00 | AAPL | Stock | 2.7139 | 2.7139 | 2.7125 | 2.7139 | 67088.0 |
| 2006-09-25 08:00:00 | MSFT | Stock | 26.7 | 26.81 | 26.7 | 26.75 | 2885.0 |
| 2006-09-25 08:30:00 | MSFT | Stock | 26.75 | 26.75 | 26.7 | 26.7 | 2650.0 |
| 2006-09-25 09:00:00 | MSFT | Stock | 26.79 | 26.84 | 26.74 | 26.83 | 74260.0 |
| 2006-09-25 09:30:00 | MSFT | Stock | 26.81 | 26.97 | 26.79 | 26.88 | 6905440.0 |
| 2006-09-25 10:00:00 | MSFT | Stock | 26.87 | 26.95 | 26.83 | 26.85 | 4674438.0 |
| 2006-09-25 10:30:00 | MSFT | Stock | 26.85 | 26.89 | 26.79 | 26.86 | 3746900.0 |
| 2006-09-25 11:00:00 | MSFT | Stock | 26.85 | 26.95 | 26.844 | 26.85 | 3606693.0 |
| 2006-09-25 11:30:00 | MSFT | Stock | 26.851 | 26.87 | 26.81 | 26.85 | 3293567.0 |
| 2006-09-25 12:00:00 | MSFT | Stock | 26.85 | 26.96 | 26.83 | 26.94 | 2767068.0 |
| 2006-09-25 12:30:00 | MSFT | Stock | 26.94 | 27.02 | 26.93 | 27.0 | 3033584.0 |
| 2006-09-25 13:00:00 | MSFT | Stock | 27.01 | 27.1 | 27.0 | 27.031 | 3915970.0 |
| 2006-09-25 13:30:00 | MSFT | Stock | 27.03 | 27.06 | 26.99 | 27.0 | 1855646.0 |
| 2006-09-25 14:00:00 | MSFT | Stock | 27.0 | 27.1 | 27.0 | 27.061 | 2754383.0 |
| 2006-09-25 14:30:00 | MSFT | Stock | 27.07 | 27.17 | 27.03 | 27.09 | 3851756.0 |
| 2006-09-25 15:00:00 | MSFT | Stock | 27.1 | 27.19 | 27.0 | 27.18 | 5039891.0 |
| 2006-09-25 15:30:00 | MSFT | Stock | 27.17 | 27.18 | 26.93 | 26.97 | 15689181.0 |
| 2006-09-25 16:00:00 | MSFT | Stock | 26.96 | 26.98 | 26.93 | 26.94 | 111078.0 |
| 2006-09-25 16:30:00 | MSFT | Stock | 26.93 | 26.96 | 26.92 | 26.92 | 281300.0 |
| 2006-09-25 17:00:00 | MSFT | Stock | 26.96 | 26.96 | 26.93 | 26.94 | 337450.0 |
| 2006-09-25 17:30:00 | MSFT | Stock | 26.95 | 26.97 | 26.95 | 26.97 | 22225.0 |
| 2006-09-25 18:00:00 | MSFT | Stock | 26.96 | 26.97 | 26.96 | 26.96 | 13012.0 |
| 2006-09-25 18:30:00 | MSFT | Stock | 27.0 | 27.0 | 27.0 | 27.0 | 490.0 |
| 2006-09-25 19:00:00 | MSFT | Stock | 26.98 | 26.98 | 26.98 | 26.98 | 3000.0 |
| 2006-09-25 19:30:00 | MSFT | Stock | 26.97 | 26.97 | 26.97 | 26.97 | 750.0 |
> showing 50 of 50,713 rows — these rows as CSV