PREVIEW / stock_30min / 2010-08-19
file: by_date/stock_30min/2010/2010-08-19.parquet size: 1.4 MB rows: 77,333 symbols: 3,476
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 |
|---|---|---|---|---|---|---|---|
| 2010-08-19 06:00:00 | AAPL | Stock | 9.065 | 9.0661 | 9.065 | 9.0661 | 9800.0 |
| 2010-08-19 07:00:00 | AAPL | Stock | 9.0643 | 9.0643 | 9.0625 | 9.0625 | 14000.0 |
| 2010-08-19 07:30:00 | AAPL | Stock | 9.0564 | 9.0564 | 9.0518 | 9.0518 | 80920.0 |
| 2010-08-19 08:00:00 | AAPL | Stock | 9.0589 | 9.0857 | 9.0507 | 9.0786 | 1118432.0 |
| 2010-08-19 08:30:00 | AAPL | Stock | 9.085 | 9.0854 | 8.9968 | 9.0268 | 2944592.0 |
| 2010-08-19 09:00:00 | AAPL | Stock | 9.0236 | 9.0479 | 9.0225 | 9.0321 | 710528.0 |
| 2010-08-19 09:30:00 | AAPL | Stock | 9.0279 | 9.0529 | 8.9982 | 9.0125 | 48351212.0 |
| 2010-08-19 10:00:00 | AAPL | Stock | 9.0125 | 9.0129 | 8.9375 | 8.9682 | 53749668.0 |
| 2010-08-19 10:30:00 | AAPL | Stock | 8.9675 | 8.9736 | 8.9386 | 8.9525 | 32647020.0 |
| 2010-08-19 11:00:00 | AAPL | Stock | 8.9511 | 8.9532 | 8.9296 | 8.9429 | 27902364.0 |
| 2010-08-19 11:30:00 | AAPL | Stock | 8.9429 | 8.9432 | 8.8814 | 8.9093 | 48758500.0 |
| 2010-08-19 12:00:00 | AAPL | Stock | 8.9096 | 8.9332 | 8.8857 | 8.9314 | 31458616.0 |
| 2010-08-19 12:30:00 | AAPL | Stock | 8.93 | 8.9311 | 8.9086 | 8.9264 | 19257980.0 |
| 2010-08-19 13:00:00 | AAPL | Stock | 8.9261 | 8.9375 | 8.9175 | 8.9218 | 14276192.0 |
| 2010-08-19 13:30:00 | AAPL | Stock | 8.9225 | 8.9318 | 8.9114 | 8.9146 | 14420980.0 |
| 2010-08-19 14:00:00 | AAPL | Stock | 8.9142 | 8.9386 | 8.9039 | 8.9364 | 20422668.0 |
| 2010-08-19 14:30:00 | AAPL | Stock | 8.9351 | 8.9486 | 8.9218 | 8.9325 | 24205020.0 |
| 2010-08-19 15:00:00 | AAPL | Stock | 8.9329 | 8.9571 | 8.9236 | 8.9489 | 29223040.0 |
| 2010-08-19 15:30:00 | AAPL | Stock | 8.9489 | 8.955 | 8.9225 | 8.9225 | 41709220.0 |
| 2010-08-19 16:00:00 | AAPL | Stock | 8.9261 | 8.9478 | 8.9193 | 8.9196 | 12371688.0 |
| 2010-08-19 16:30:00 | AAPL | Stock | 8.9243 | 8.9525 | 8.9211 | 8.9275 | 2277408.0 |
| 2010-08-19 17:00:00 | AAPL | Stock | 8.9275 | 8.9275 | 8.9196 | 8.9196 | 73640.0 |
| 2010-08-19 17:30:00 | AAPL | Stock | 8.9211 | 8.9243 | 8.9196 | 8.9196 | 54992.0 |
| 2010-08-19 18:00:00 | AAPL | Stock | 8.9196 | 8.9257 | 8.9196 | 8.9257 | 182280.0 |
| 2010-08-19 18:30:00 | AAPL | Stock | 8.9179 | 8.9243 | 8.9179 | 8.9243 | 5600.0 |
| 2010-08-19 19:00:00 | AAPL | Stock | 8.9175 | 8.9243 | 8.9175 | 8.9243 | 32144.0 |
| 2010-08-19 19:30:00 | AAPL | Stock | 8.9232 | 8.9261 | 8.92 | 8.9236 | 127484.0 |
| 2010-08-19 05:00:00 | MSFT | Stock | 24.91 | 24.93 | 24.91 | 24.93 | 400.0 |
| 2010-08-19 06:00:00 | MSFT | Stock | 25.0 | 25.0 | 25.0 | 25.0 | 200.0 |
| 2010-08-19 06:30:00 | MSFT | Stock | 25.0 | 25.0 | 25.0 | 25.0 | 300.0 |
| 2010-08-19 07:00:00 | MSFT | Stock | 24.93 | 24.93 | 24.9 | 24.91 | 2300.0 |
| 2010-08-19 07:30:00 | MSFT | Stock | 24.86 | 24.86 | 24.85 | 24.85 | 2000.0 |
| 2010-08-19 08:00:00 | MSFT | Stock | 24.85 | 24.85 | 24.8 | 24.84 | 4582.0 |
| 2010-08-19 08:30:00 | MSFT | Stock | 24.81 | 24.81 | 24.6 | 24.65 | 41480.0 |
| 2010-08-19 09:00:00 | MSFT | Stock | 24.66 | 24.68 | 24.61 | 24.62 | 36905.0 |
| 2010-08-19 09:30:00 | MSFT | Stock | 24.62 | 24.74 | 24.56 | 24.59 | 8078577.0 |
| 2010-08-19 10:00:00 | MSFT | Stock | 24.58 | 24.58 | 24.48 | 24.555 | 6930950.0 |
| 2010-08-19 10:30:00 | MSFT | Stock | 24.56 | 24.58 | 24.41 | 24.45 | 5426888.0 |
| 2010-08-19 11:00:00 | MSFT | Stock | 24.45 | 24.474 | 24.38 | 24.39 | 4649331.0 |
| 2010-08-19 11:30:00 | MSFT | Stock | 24.39 | 24.39 | 24.21 | 24.305 | 3657278.0 |
| 2010-08-19 12:00:00 | MSFT | Stock | 24.3 | 24.44 | 24.28 | 24.422 | 2628389.0 |
| 2010-08-19 12:30:00 | MSFT | Stock | 24.42 | 24.47 | 24.35 | 24.398 | 1907148.0 |
| 2010-08-19 13:00:00 | MSFT | Stock | 24.4 | 24.5 | 24.395 | 24.445 | 1764791.0 |
| 2010-08-19 13:30:00 | MSFT | Stock | 24.44 | 24.46 | 24.35 | 24.371 | 1234186.0 |
| 2010-08-19 14:00:00 | MSFT | Stock | 24.375 | 24.45 | 24.312 | 24.418 | 2055607.0 |
| 2010-08-19 14:30:00 | MSFT | Stock | 24.418 | 24.47 | 24.37 | 24.4 | 2478473.0 |
| 2010-08-19 15:00:00 | MSFT | Stock | 24.409 | 24.53 | 24.375 | 24.45 | 2814561.0 |
| 2010-08-19 15:30:00 | MSFT | Stock | 24.455 | 24.5 | 24.43 | 24.44 | 5955070.0 |
| 2010-08-19 16:00:00 | MSFT | Stock | 24.44 | 24.56 | 24.4 | 24.51 | 628173.0 |
| 2010-08-19 16:30:00 | MSFT | Stock | 24.47 | 24.51 | 24.43 | 24.43 | 332508.0 |
> showing 50 of 77,333 rows — these rows as CSV