PREVIEW / stock_1hour / 2009-09-28
file: by_date/stock_1hour/2009/2009-09-28.parquet size: 877 KB rows: 42,527 symbols: 3,381
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-09-28 05:00:00 | AAPL | Stock | 6.5371 | 6.5371 | 6.5371 | 6.5371 | 14000.0 |
| 2009-09-28 06:00:00 | AAPL | Stock | 6.5539 | 6.5539 | 6.5539 | 6.5539 | 5600.0 |
| 2009-09-28 07:00:00 | AAPL | Stock | 6.5536 | 6.5679 | 6.5482 | 6.5579 | 62860.0 |
| 2009-09-28 08:00:00 | AAPL | Stock | 6.5571 | 6.6071 | 6.5396 | 6.5857 | 2042544.0 |
| 2009-09-28 09:00:00 | AAPL | Stock | 6.5914 | 6.6061 | 6.5475 | 6.5871 | 66835664.0 |
| 2009-09-28 10:00:00 | AAPL | Stock | 6.5871 | 6.6196 | 6.5857 | 6.6154 | 64140776.0 |
| 2009-09-28 11:00:00 | AAPL | Stock | 6.6159 | 6.6489 | 6.6136 | 6.6425 | 42103572.0 |
| 2009-09-28 12:00:00 | AAPL | Stock | 6.6425 | 6.6671 | 6.6407 | 6.6446 | 31201772.0 |
| 2009-09-28 13:00:00 | AAPL | Stock | 6.6446 | 6.6593 | 6.6325 | 6.6339 | 32080048.0 |
| 2009-09-28 14:00:00 | AAPL | Stock | 6.6339 | 6.6571 | 6.6268 | 6.6502 | 34455204.0 |
| 2009-09-28 15:00:00 | AAPL | Stock | 6.6496 | 6.66 | 6.625 | 6.6486 | 53890144.0 |
| 2009-09-28 16:00:00 | AAPL | Stock | 6.6486 | 6.65 | 6.6161 | 6.6457 | 6555444.0 |
| 2009-09-28 17:00:00 | AAPL | Stock | 6.6096 | 6.6496 | 6.6096 | 6.6496 | 685216.0 |
| 2009-09-28 18:00:00 | AAPL | Stock | 6.65 | 6.6589 | 6.65 | 6.6554 | 126168.0 |
| 2009-09-28 19:00:00 | AAPL | Stock | 6.6586 | 6.6607 | 6.6554 | 6.6571 | 97720.0 |
| 2009-09-28 04:00:00 | MSFT | Stock | 25.59 | 25.59 | 25.59 | 25.59 | 150.0 |
| 2009-09-28 07:00:00 | MSFT | Stock | 25.51 | 25.65 | 25.51 | 25.65 | 1100.0 |
| 2009-09-28 08:00:00 | MSFT | Stock | 25.58 | 25.7 | 25.57 | 25.64 | 12649.0 |
| 2009-09-28 09:00:00 | MSFT | Stock | 25.65 | 25.89 | 25.6 | 25.8 | 4149301.0 |
| 2009-09-28 10:00:00 | MSFT | Stock | 25.8 | 26.05 | 25.79 | 25.97 | 8457866.0 |
| 2009-09-28 11:00:00 | MSFT | Stock | 25.97 | 26.1 | 25.94 | 26.1 | 4396077.0 |
| 2009-09-28 12:00:00 | MSFT | Stock | 26.1 | 26.12 | 26.0 | 26.015 | 2552030.0 |
| 2009-09-28 13:00:00 | MSFT | Stock | 26.012 | 26.16 | 26.012 | 26.072 | 3858283.0 |
| 2009-09-28 14:00:00 | MSFT | Stock | 26.07 | 26.08 | 25.92 | 25.92 | 4259933.0 |
| 2009-09-28 15:00:00 | MSFT | Stock | 25.929 | 25.93 | 25.79 | 25.88 | 8562625.0 |
| 2009-09-28 16:00:00 | MSFT | Stock | 25.83 | 26.2 | 25.77 | 25.86 | 2913307.0 |
| 2009-09-28 18:00:00 | MSFT | Stock | 25.89 | 25.9 | 25.89 | 25.89 | 700.0 |
| 2009-09-28 19:00:00 | MSFT | Stock | 25.89 | 25.95 | 25.88 | 25.95 | 2800.0 |
| 2009-09-28 09:00:00 | NVDA | Stock | 0.3672 | 0.3735 | 0.3638 | 0.373 | 55519200.0 |
| 2009-09-28 10:00:00 | NVDA | Stock | 0.3733 | 0.3778 | 0.37 | 0.3775 | 118189400.0 |
| 2009-09-28 11:00:00 | NVDA | Stock | 0.3775 | 0.38 | 0.3768 | 0.377 | 79298240.0 |
| 2009-09-28 12:00:00 | NVDA | Stock | 0.377 | 0.3788 | 0.376 | 0.3763 | 33987120.0 |
| 2009-09-28 13:00:00 | NVDA | Stock | 0.3763 | 0.3773 | 0.373 | 0.373 | 53578840.0 |
| 2009-09-28 14:00:00 | NVDA | Stock | 0.3733 | 0.374 | 0.371 | 0.371 | 40056520.0 |
| 2009-09-28 15:00:00 | NVDA | Stock | 0.371 | 0.3773 | 0.37 | 0.3705 | 74322840.0 |
| 2009-09-28 16:00:00 | NVDA | Stock | 0.3708 | 0.3739 | 0.3625 | 0.3708 | 4271760.0 |
| 2009-09-28 17:00:00 | NVDA | Stock | 0.3778 | 0.3778 | 0.372 | 0.372 | 408000.0 |
| 2009-09-28 18:00:00 | NVDA | Stock | 0.3703 | 0.3703 | 0.3688 | 0.37 | 184600.0 |
| 2009-09-28 09:00:00 | AMZN | Stock | 4.5345 | 4.5885 | 4.53 | 4.585 | 10339740.0 |
| 2009-09-28 10:00:00 | AMZN | Stock | 4.5865 | 4.627 | 4.5865 | 4.6165 | 14248960.0 |
| 2009-09-28 11:00:00 | AMZN | Stock | 4.615 | 4.6365 | 4.6145 | 4.635 | 7594280.0 |
| 2009-09-28 12:00:00 | AMZN | Stock | 4.635 | 4.6405 | 4.6185 | 4.624 | 6653080.0 |
| 2009-09-28 13:00:00 | AMZN | Stock | 4.624 | 4.6375 | 4.6095 | 4.6145 | 6180880.0 |
| 2009-09-28 14:00:00 | AMZN | Stock | 4.6145 | 4.624 | 4.603 | 4.614 | 5803660.0 |
| 2009-09-28 15:00:00 | AMZN | Stock | 4.6135 | 4.6235 | 4.601 | 4.6115 | 16545680.0 |
| 2009-09-28 16:00:00 | AMZN | Stock | 4.6105 | 4.6175 | 4.61 | 4.6105 | 2042380.0 |
| 2009-09-28 17:00:00 | AMZN | Stock | 4.6155 | 4.624 | 4.6155 | 4.616 | 76000.0 |
| 2009-09-28 18:00:00 | AMZN | Stock | 4.6205 | 4.6205 | 4.6205 | 4.6205 | 10000.0 |
| 2009-09-28 19:00:00 | AMZN | Stock | 4.625 | 4.625 | 4.625 | 4.625 | 8800.0 |
| 2009-09-28 07:00:00 | TLT | Stock | 98.0 | 98.0 | 98.0 | 98.0 | 400.0 |
> showing 50 of 42,527 rows — these rows as CSV