PREVIEW / stock_30min / 2006-10-26
file: by_date/stock_30min/2006/2006-10-26.parquet size: 952 KB rows: 51,783 symbols: 2,414
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-10-26 08:00:00 | AAPL | Stock | 2.925 | 2.9321 | 2.9232 | 2.9239 | 629160.0 |
| 2006-10-26 08:30:00 | AAPL | Stock | 2.9239 | 2.9339 | 2.9239 | 2.9286 | 755048.0 |
| 2006-10-26 09:00:00 | AAPL | Stock | 2.93 | 2.9304 | 2.9232 | 2.9279 | 411824.0 |
| 2006-10-26 09:30:00 | AAPL | Stock | 2.925 | 2.9293 | 2.9071 | 2.9132 | 52745448.0 |
| 2006-10-26 10:00:00 | AAPL | Stock | 2.9132 | 2.9168 | 2.8986 | 2.9 | 39614008.0 |
| 2006-10-26 10:30:00 | AAPL | Stock | 2.9008 | 2.9107 | 2.8975 | 2.9079 | 26591096.0 |
| 2006-10-26 11:00:00 | AAPL | Stock | 2.9082 | 2.9107 | 2.9018 | 2.9082 | 19159280.0 |
| 2006-10-26 11:30:00 | AAPL | Stock | 2.9079 | 2.9282 | 2.9079 | 2.9265 | 31514728.0 |
| 2006-10-26 12:00:00 | AAPL | Stock | 2.9271 | 2.9336 | 2.9225 | 2.9318 | 41736912.0 |
| 2006-10-26 12:30:00 | AAPL | Stock | 2.9318 | 2.9329 | 2.925 | 2.9271 | 17579016.0 |
| 2006-10-26 13:00:00 | AAPL | Stock | 2.9279 | 2.9368 | 2.9239 | 2.9357 | 24296972.0 |
| 2006-10-26 13:30:00 | AAPL | Stock | 2.9361 | 2.9461 | 2.9339 | 2.9386 | 34984040.0 |
| 2006-10-26 14:00:00 | AAPL | Stock | 2.9389 | 2.9496 | 2.9386 | 2.9475 | 39826612.0 |
| 2006-10-26 14:30:00 | AAPL | Stock | 2.9479 | 2.95 | 2.9429 | 2.9454 | 26571188.0 |
| 2006-10-26 15:00:00 | AAPL | Stock | 2.9457 | 2.9464 | 2.935 | 2.9386 | 25196808.0 |
| 2006-10-26 15:30:00 | AAPL | Stock | 2.9386 | 2.9409 | 2.931 | 2.9339 | 44389548.0 |
| 2006-10-26 16:00:00 | AAPL | Stock | 2.9336 | 2.9375 | 2.9321 | 2.9321 | 701232.0 |
| 2006-10-26 16:30:00 | AAPL | Stock | 2.9336 | 2.9343 | 2.9321 | 2.9332 | 103600.0 |
| 2006-10-26 17:00:00 | AAPL | Stock | 2.9343 | 2.9343 | 2.9339 | 2.9339 | 40936.0 |
| 2006-10-26 17:30:00 | AAPL | Stock | 2.9346 | 2.9354 | 2.9314 | 2.9321 | 176736.0 |
| 2006-10-26 18:00:00 | AAPL | Stock | 2.9321 | 2.9325 | 2.9321 | 2.9321 | 109200.0 |
| 2006-10-26 19:30:00 | AAPL | Stock | 2.9304 | 2.9304 | 2.9304 | 2.9304 | 16800.0 |
| 2006-10-26 08:00:00 | MSFT | Stock | 28.35 | 28.49 | 28.33 | 28.48 | 12670.0 |
| 2006-10-26 08:30:00 | MSFT | Stock | 28.48 | 28.48 | 28.41 | 28.42 | 35550.0 |
| 2006-10-26 09:00:00 | MSFT | Stock | 28.42 | 28.44 | 28.32 | 28.34 | 64320.0 |
| 2006-10-26 09:30:00 | MSFT | Stock | 28.33 | 28.41 | 28.08 | 28.17 | 6292961.0 |
| 2006-10-26 10:00:00 | MSFT | Stock | 28.17 | 28.29 | 28.04 | 28.07 | 5442509.0 |
| 2006-10-26 10:30:00 | MSFT | Stock | 28.08 | 28.16 | 28.06 | 28.1 | 5499456.0 |
| 2006-10-26 11:00:00 | MSFT | Stock | 28.11 | 28.23 | 28.08 | 28.2 | 4043851.0 |
| 2006-10-26 11:30:00 | MSFT | Stock | 28.2 | 28.22 | 28.064 | 28.21 | 2463619.0 |
| 2006-10-26 12:00:00 | MSFT | Stock | 28.21 | 28.32 | 28.18 | 28.29 | 2991803.0 |
| 2006-10-26 12:30:00 | MSFT | Stock | 28.293 | 28.3 | 28.11 | 28.193 | 2519969.0 |
| 2006-10-26 13:00:00 | MSFT | Stock | 28.2 | 28.23 | 28.15 | 28.19 | 2214617.0 |
| 2006-10-26 13:30:00 | MSFT | Stock | 28.19 | 28.27 | 28.18 | 28.23 | 2388932.0 |
| 2006-10-26 14:00:00 | MSFT | Stock | 28.23 | 28.31 | 28.22 | 28.28 | 3006376.0 |
| 2006-10-26 14:30:00 | MSFT | Stock | 28.28 | 28.31 | 28.178 | 28.25 | 3864449.0 |
| 2006-10-26 15:00:00 | MSFT | Stock | 28.26 | 28.28 | 28.18 | 28.24 | 6901172.0 |
| 2006-10-26 15:30:00 | MSFT | Stock | 28.24 | 28.39 | 28.23 | 28.34 | 14085645.0 |
| 2006-10-26 16:00:00 | MSFT | Stock | 28.32 | 28.6 | 27.68 | 28.26 | 4721583.0 |
| 2006-10-26 16:30:00 | MSFT | Stock | 28.26 | 28.32 | 28.2 | 28.23 | 611804.0 |
| 2006-10-26 17:00:00 | MSFT | Stock | 28.23 | 28.75 | 28.2 | 28.57 | 1035471.0 |
| 2006-10-26 17:30:00 | MSFT | Stock | 28.57 | 28.65 | 28.41 | 28.56 | 378054.0 |
| 2006-10-26 18:00:00 | MSFT | Stock | 28.56 | 28.56 | 28.41 | 28.47 | 128858.0 |
| 2006-10-26 18:30:00 | MSFT | Stock | 28.47 | 28.47 | 28.45 | 28.45 | 12690.0 |
| 2006-10-26 19:00:00 | MSFT | Stock | 28.43 | 28.44 | 28.41 | 28.42 | 5776.0 |
| 2006-10-26 19:30:00 | MSFT | Stock | 28.43 | 28.44 | 28.36 | 28.37 | 23289.0 |
| 2006-10-26 08:00:00 | NVDA | Stock | 0.5492 | 0.55 | 0.5492 | 0.55 | 102000.0 |
| 2006-10-26 09:00:00 | NVDA | Stock | 0.549 | 0.5492 | 0.5475 | 0.5492 | 48000.0 |
| 2006-10-26 09:30:00 | NVDA | Stock | 0.548 | 0.5547 | 0.548 | 0.552 | 30402420.0 |
| 2006-10-26 10:00:00 | NVDA | Stock | 0.5523 | 0.555 | 0.5497 | 0.55 | 32355000.0 |
> showing 50 of 51,783 rows — these rows as CSV