PREVIEW / stock_30min / 2009-07-22
file: by_date/stock_30min/2009/2009-07-22.parquet size: 1.3 MB rows: 69,141 symbols: 3,333
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 |
|---|---|---|---|---|---|---|---|
| 2009-07-22 04:00:00 | AAPL | Stock | 5.6075 | 5.6182 | 5.6075 | 5.6182 | 86800.0 |
| 2009-07-22 04:30:00 | AAPL | Stock | 5.6075 | 5.6107 | 5.5925 | 5.6054 | 74900.0 |
| 2009-07-22 05:00:00 | AAPL | Stock | 5.6054 | 5.6064 | 5.6054 | 5.6064 | 22400.0 |
| 2009-07-22 05:30:00 | AAPL | Stock | 5.6139 | 5.6196 | 5.6139 | 5.6161 | 41384.0 |
| 2009-07-22 06:00:00 | AAPL | Stock | 5.6239 | 5.6239 | 5.6064 | 5.6068 | 179004.0 |
| 2009-07-22 06:30:00 | AAPL | Stock | 5.6071 | 5.6143 | 5.6 | 5.6107 | 294196.0 |
| 2009-07-22 07:00:00 | AAPL | Stock | 5.6143 | 5.6429 | 5.6107 | 5.6429 | 1026088.0 |
| 2009-07-22 07:30:00 | AAPL | Stock | 5.6482 | 5.6729 | 5.6429 | 5.6721 | 2498608.0 |
| 2009-07-22 08:00:00 | AAPL | Stock | 5.67 | 5.67 | 5.6125 | 5.6286 | 6205416.0 |
| 2009-07-22 08:30:00 | AAPL | Stock | 5.6279 | 5.6286 | 5.5979 | 5.6118 | 7721196.0 |
| 2009-07-22 09:00:00 | AAPL | Stock | 5.6121 | 5.645 | 5.6075 | 5.6325 | 8980972.0 |
| 2009-07-22 09:30:00 | AAPL | Stock | 5.6321 | 5.665 | 5.5754 | 5.6525 | 231426692.0 |
| 2009-07-22 10:00:00 | AAPL | Stock | 5.6518 | 5.6689 | 5.6282 | 5.6357 | 102602528.0 |
| 2009-07-22 10:30:00 | AAPL | Stock | 5.6357 | 5.6436 | 5.6089 | 5.6289 | 56222236.0 |
| 2009-07-22 11:00:00 | AAPL | Stock | 5.6286 | 5.6375 | 5.6161 | 5.6368 | 38964016.0 |
| 2009-07-22 11:30:00 | AAPL | Stock | 5.6361 | 5.6479 | 5.6225 | 5.6296 | 30562028.0 |
| 2009-07-22 12:00:00 | AAPL | Stock | 5.6298 | 5.64 | 5.6225 | 5.6304 | 31663492.0 |
| 2009-07-22 12:30:00 | AAPL | Stock | 5.6304 | 5.6318 | 5.6004 | 5.6139 | 49617372.0 |
| 2009-07-22 13:00:00 | AAPL | Stock | 5.6133 | 5.6268 | 5.6046 | 5.6171 | 31136532.0 |
| 2009-07-22 13:30:00 | AAPL | Stock | 5.6171 | 5.6243 | 5.6139 | 5.6164 | 26730200.0 |
| 2009-07-22 14:00:00 | AAPL | Stock | 5.6161 | 5.6179 | 5.5993 | 5.6043 | 40183724.0 |
| 2009-07-22 14:30:00 | AAPL | Stock | 5.6043 | 5.6354 | 5.6021 | 5.6275 | 44928940.0 |
| 2009-07-22 15:00:00 | AAPL | Stock | 5.6275 | 5.6329 | 5.6004 | 5.6014 | 43549436.0 |
| 2009-07-22 15:30:00 | AAPL | Stock | 5.6011 | 5.6036 | 5.5761 | 5.5968 | 81485012.0 |
| 2009-07-22 16:00:00 | AAPL | Stock | 5.6 | 5.6321 | 5.4143 | 5.5957 | 14706076.0 |
| 2009-07-22 16:30:00 | AAPL | Stock | 5.5918 | 5.6224 | 5.5911 | 5.5932 | 3989692.0 |
| 2009-07-22 17:00:00 | AAPL | Stock | 5.5914 | 5.5986 | 5.5914 | 5.5957 | 268072.0 |
| 2009-07-22 17:30:00 | AAPL | Stock | 5.5921 | 5.5964 | 5.5921 | 5.5946 | 89236.0 |
| 2009-07-22 18:00:00 | AAPL | Stock | 5.5939 | 5.5946 | 5.5904 | 5.5929 | 80136.0 |
| 2009-07-22 18:30:00 | AAPL | Stock | 5.5907 | 5.5914 | 5.5875 | 5.5893 | 137508.0 |
| 2009-07-22 19:00:00 | AAPL | Stock | 5.5889 | 5.5896 | 5.5857 | 5.5886 | 87500.0 |
| 2009-07-22 19:30:00 | AAPL | Stock | 5.5861 | 5.5896 | 5.5857 | 5.5896 | 116396.0 |
| 2009-07-22 20:00:00 | AAPL | Stock | 5.6261 | 5.6261 | 5.6261 | 5.6261 | 45640.0 |
| 2009-07-22 08:00:00 | MSFT | Stock | 24.8 | 24.8 | 24.25 | 24.75 | 23645.0 |
| 2009-07-22 08:30:00 | MSFT | Stock | 24.71 | 24.71 | 24.65 | 24.68 | 8527.0 |
| 2009-07-22 09:00:00 | MSFT | Stock | 24.73 | 24.75 | 24.63 | 24.71 | 50077.0 |
| 2009-07-22 09:30:00 | MSFT | Stock | 24.7 | 24.77 | 24.51 | 24.65 | 6503647.0 |
| 2009-07-22 10:00:00 | MSFT | Stock | 24.65 | 24.74 | 24.62 | 24.65 | 3658899.0 |
| 2009-07-22 10:30:00 | MSFT | Stock | 24.65 | 24.685 | 24.6 | 24.65 | 3198533.0 |
| 2009-07-22 11:00:00 | MSFT | Stock | 24.652 | 24.72 | 24.63 | 24.695 | 2506649.0 |
| 2009-07-22 11:30:00 | MSFT | Stock | 24.699 | 24.71 | 24.65 | 24.652 | 1830671.0 |
| 2009-07-22 12:00:00 | MSFT | Stock | 24.66 | 24.71 | 24.6 | 24.69 | 4022761.0 |
| 2009-07-22 12:30:00 | MSFT | Stock | 24.681 | 24.7 | 24.62 | 24.62 | 4599898.0 |
| 2009-07-22 13:00:00 | MSFT | Stock | 24.63 | 24.69 | 24.62 | 24.66 | 6756226.0 |
| 2009-07-22 13:30:00 | MSFT | Stock | 24.657 | 24.69 | 24.58 | 24.62 | 3789315.0 |
| 2009-07-22 14:00:00 | MSFT | Stock | 24.612 | 24.65 | 24.58 | 24.62 | 2473155.0 |
| 2009-07-22 14:30:00 | MSFT | Stock | 24.62 | 24.79 | 24.57 | 24.741 | 8812193.0 |
| 2009-07-22 15:00:00 | MSFT | Stock | 24.742 | 24.78 | 24.65 | 24.685 | 4630806.0 |
| 2009-07-22 15:30:00 | MSFT | Stock | 24.68 | 24.9 | 24.65 | 24.754 | 8416545.0 |
| 2009-07-22 16:00:00 | MSFT | Stock | 24.8 | 24.86 | 24.669 | 24.8 | 3829611.0 |
> showing 50 of 69,141 rows — these rows as CSV