PREVIEW / stock_30min / 2008-06-10
file: by_date/stock_30min/2008/2008-06-10.parquet size: 1.3 MB rows: 68,510 symbols: 3,316
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 |
|---|---|---|---|---|---|---|---|
| 2008-06-10 04:30:00 | AAPL | Stock | 6.4518 | 6.4518 | 6.4464 | 6.4464 | 5600.0 |
| 2008-06-10 05:30:00 | AAPL | Stock | 6.4754 | 6.4821 | 6.4754 | 6.4821 | 36400.0 |
| 2008-06-10 06:30:00 | AAPL | Stock | 6.4804 | 6.5014 | 6.4804 | 6.5014 | 5600.0 |
| 2008-06-10 07:00:00 | AAPL | Stock | 6.4825 | 6.5 | 6.4579 | 6.4661 | 142912.0 |
| 2008-06-10 07:30:00 | AAPL | Stock | 6.4643 | 6.5464 | 6.4593 | 6.5179 | 1745492.0 |
| 2008-06-10 08:00:00 | AAPL | Stock | 6.5179 | 6.5393 | 6.4075 | 6.4411 | 7920780.0 |
| 2008-06-10 08:30:00 | AAPL | Stock | 6.4429 | 6.4725 | 6.4354 | 6.4489 | 2515044.0 |
| 2008-06-10 09:00:00 | AAPL | Stock | 6.4525 | 6.4525 | 6.3793 | 6.4489 | 7890120.0 |
| 2008-06-10 09:30:00 | AAPL | Stock | 6.4468 | 6.5736 | 6.3936 | 6.5593 | 182120680.0 |
| 2008-06-10 10:00:00 | AAPL | Stock | 6.5589 | 6.6143 | 6.5129 | 6.5836 | 121927316.0 |
| 2008-06-10 10:30:00 | AAPL | Stock | 6.5832 | 6.6082 | 6.5621 | 6.5982 | 74607344.0 |
| 2008-06-10 11:00:00 | AAPL | Stock | 6.5982 | 6.6239 | 6.5643 | 6.5813 | 79822176.0 |
| 2008-06-10 11:30:00 | AAPL | Stock | 6.5814 | 6.6271 | 6.5668 | 6.5875 | 70099064.0 |
| 2008-06-10 12:00:00 | AAPL | Stock | 6.5879 | 6.6314 | 6.5764 | 6.6268 | 55795376.0 |
| 2008-06-10 12:30:00 | AAPL | Stock | 6.6268 | 6.6596 | 6.6193 | 6.6582 | 60924640.0 |
| 2008-06-10 13:00:00 | AAPL | Stock | 6.6579 | 6.667 | 6.6286 | 6.6596 | 68326328.0 |
| 2008-06-10 13:30:00 | AAPL | Stock | 6.6589 | 6.6707 | 6.6357 | 6.6425 | 64324680.0 |
| 2008-06-10 14:00:00 | AAPL | Stock | 6.6429 | 6.6461 | 6.5932 | 6.6386 | 78168020.0 |
| 2008-06-10 14:30:00 | AAPL | Stock | 6.6379 | 6.6429 | 6.61 | 6.6189 | 43779960.0 |
| 2008-06-10 15:00:00 | AAPL | Stock | 6.6189 | 6.6554 | 6.6184 | 6.6475 | 55966064.0 |
| 2008-06-10 15:30:00 | AAPL | Stock | 6.6479 | 6.6661 | 6.6268 | 6.63 | 83329120.0 |
| 2008-06-10 16:00:00 | AAPL | Stock | 6.63 | 6.6357 | 6.5883 | 6.6268 | 11040064.0 |
| 2008-06-10 16:30:00 | AAPL | Stock | 6.6268 | 6.6325 | 6.6221 | 6.6321 | 791056.0 |
| 2008-06-10 17:00:00 | AAPL | Stock | 6.6321 | 6.6339 | 6.6293 | 6.6325 | 557452.0 |
| 2008-06-10 17:30:00 | AAPL | Stock | 6.6304 | 6.6325 | 6.6279 | 6.63 | 70504.0 |
| 2008-06-10 18:00:00 | AAPL | Stock | 6.6282 | 6.6293 | 6.6257 | 6.6257 | 87668.0 |
| 2008-06-10 18:30:00 | AAPL | Stock | 6.625 | 6.6279 | 6.6179 | 6.6182 | 114464.0 |
| 2008-06-10 19:00:00 | AAPL | Stock | 6.6193 | 6.625 | 6.6182 | 6.6243 | 116704.0 |
| 2008-06-10 19:30:00 | AAPL | Stock | 6.6239 | 6.6239 | 6.6179 | 6.6182 | 136472.0 |
| 2008-06-10 08:00:00 | MSFT | Stock | 27.5 | 27.5 | 27.36 | 27.38 | 25095.0 |
| 2008-06-10 08:30:00 | MSFT | Stock | 27.4 | 27.71 | 27.38 | 27.42 | 1014058.0 |
| 2008-06-10 09:00:00 | MSFT | Stock | 27.41 | 27.44 | 27.33 | 27.36 | 99633.0 |
| 2008-06-10 09:30:00 | MSFT | Stock | 27.39 | 27.78 | 27.32 | 27.672 | 9680604.0 |
| 2008-06-10 10:00:00 | MSFT | Stock | 27.672 | 27.95 | 27.59 | 27.87 | 7259399.0 |
| 2008-06-10 10:30:00 | MSFT | Stock | 27.87 | 27.93 | 27.77 | 27.88 | 5522246.0 |
| 2008-06-10 11:00:00 | MSFT | Stock | 27.87 | 28.03 | 27.79 | 27.93 | 5961713.0 |
| 2008-06-10 11:30:00 | MSFT | Stock | 27.92 | 28.1 | 27.88 | 27.96 | 7007905.0 |
| 2008-06-10 12:00:00 | MSFT | Stock | 27.97 | 28.29 | 27.89 | 28.14 | 5666194.0 |
| 2008-06-10 12:30:00 | MSFT | Stock | 28.14 | 28.22 | 28.03 | 28.06 | 3041479.0 |
| 2008-06-10 13:00:00 | MSFT | Stock | 28.06 | 28.21 | 27.97 | 28.21 | 3687592.0 |
| 2008-06-10 13:30:00 | MSFT | Stock | 28.21 | 28.24 | 28.08 | 28.14 | 3153919.0 |
| 2008-06-10 14:00:00 | MSFT | Stock | 28.14 | 28.16 | 27.87 | 27.92 | 5556698.0 |
| 2008-06-10 14:30:00 | MSFT | Stock | 27.93 | 27.94 | 27.81 | 27.88 | 4060578.0 |
| 2008-06-10 15:00:00 | MSFT | Stock | 27.89 | 27.97 | 27.81 | 27.94 | 4756915.0 |
| 2008-06-10 15:30:00 | MSFT | Stock | 27.94 | 27.96 | 27.82 | 27.91 | 5428955.0 |
| 2008-06-10 16:00:00 | MSFT | Stock | 27.9 | 28.04 | 27.85 | 27.946 | 1855777.0 |
| 2008-06-10 16:30:00 | MSFT | Stock | 27.87 | 27.89 | 27.87 | 27.89 | 3768.0 |
| 2008-06-10 17:00:00 | MSFT | Stock | 27.88 | 27.89 | 27.88 | 27.89 | 35171.0 |
| 2008-06-10 17:30:00 | MSFT | Stock | 27.87 | 27.87 | 27.87 | 27.87 | 500.0 |
| 2008-06-10 18:00:00 | MSFT | Stock | 27.86 | 27.89 | 27.85 | 27.85 | 3270.0 |
> showing 50 of 68,510 rows — these rows as CSV