PREVIEW / stock_1hour / 2009-08-14
file: by_date/stock_1hour/2009/2009-08-14.parquet size: 851 KB rows: 41,364 symbols: 3,355
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-08-14 05:00:00 | AAPL | Stock | 6.0268 | 6.0268 | 6.0268 | 6.0268 | 2800.0 |
| 2009-08-14 06:00:00 | AAPL | Stock | 6.0211 | 6.0268 | 6.0211 | 6.0211 | 16800.0 |
| 2009-08-14 07:00:00 | AAPL | Stock | 6.0179 | 6.0179 | 6.0089 | 6.0089 | 29400.0 |
| 2009-08-14 08:00:00 | AAPL | Stock | 6.0175 | 6.0179 | 6.0011 | 6.0046 | 597548.0 |
| 2009-08-14 09:00:00 | AAPL | Stock | 6.0036 | 6.0081 | 5.935 | 5.9554 | 57308440.0 |
| 2009-08-14 10:00:00 | AAPL | Stock | 5.9554 | 5.9568 | 5.9146 | 5.9263 | 64064056.0 |
| 2009-08-14 11:00:00 | AAPL | Stock | 5.9257 | 5.9321 | 5.9118 | 5.9204 | 34968752.0 |
| 2009-08-14 12:00:00 | AAPL | Stock | 5.9204 | 5.9332 | 5.9144 | 5.9325 | 25050620.0 |
| 2009-08-14 13:00:00 | AAPL | Stock | 5.9329 | 5.9357 | 5.9152 | 5.9304 | 26537644.0 |
| 2009-08-14 14:00:00 | AAPL | Stock | 5.9304 | 5.9404 | 5.9189 | 5.9304 | 25381468.0 |
| 2009-08-14 15:00:00 | AAPL | Stock | 5.93 | 5.9575 | 5.9225 | 5.9571 | 55304256.0 |
| 2009-08-14 16:00:00 | AAPL | Stock | 5.9571 | 6.015 | 5.9378 | 5.9571 | 14895832.0 |
| 2009-08-14 17:00:00 | AAPL | Stock | 5.9539 | 5.9564 | 5.9464 | 5.9468 | 384048.0 |
| 2009-08-14 18:00:00 | AAPL | Stock | 5.9468 | 5.9493 | 5.9446 | 5.9489 | 129668.0 |
| 2009-08-14 19:00:00 | AAPL | Stock | 5.9493 | 5.9493 | 5.9471 | 5.9471 | 109312.0 |
| 2009-08-14 07:00:00 | MSFT | Stock | 23.7 | 23.7 | 23.7 | 23.7 | 149.0 |
| 2009-08-14 08:00:00 | MSFT | Stock | 23.63 | 23.74 | 23.6 | 23.65 | 16725.0 |
| 2009-08-14 09:00:00 | MSFT | Stock | 23.6 | 23.8 | 23.52 | 23.68 | 8084736.0 |
| 2009-08-14 10:00:00 | MSFT | Stock | 23.68 | 23.77 | 23.55 | 23.71 | 11381910.0 |
| 2009-08-14 11:00:00 | MSFT | Stock | 23.7 | 23.74 | 23.55 | 23.59 | 4849144.0 |
| 2009-08-14 12:00:00 | MSFT | Stock | 23.592 | 23.62 | 23.56 | 23.61 | 3559352.0 |
| 2009-08-14 13:00:00 | MSFT | Stock | 23.61 | 23.61 | 23.55 | 23.58 | 2887714.0 |
| 2009-08-14 14:00:00 | MSFT | Stock | 23.58 | 23.59 | 23.54 | 23.55 | 3393887.0 |
| 2009-08-14 15:00:00 | MSFT | Stock | 23.545 | 23.71 | 23.51 | 23.71 | 7253905.0 |
| 2009-08-14 16:00:00 | MSFT | Stock | 23.69 | 24.32 | 23.599 | 23.7 | 3494090.0 |
| 2009-08-14 17:00:00 | MSFT | Stock | 23.71 | 23.71 | 23.65 | 23.7 | 2000.0 |
| 2009-08-14 18:00:00 | MSFT | Stock | 23.65 | 23.7 | 23.65 | 23.65 | 1319.0 |
| 2009-08-14 19:00:00 | MSFT | Stock | 23.69 | 23.69 | 23.67 | 23.69 | 1500.0 |
| 2009-08-14 08:00:00 | NVDA | Stock | 0.3458 | 0.3468 | 0.3445 | 0.345 | 192560.0 |
| 2009-08-14 09:00:00 | NVDA | Stock | 0.3455 | 0.3458 | 0.335 | 0.337 | 79221000.0 |
| 2009-08-14 10:00:00 | NVDA | Stock | 0.337 | 0.3371 | 0.331 | 0.3338 | 125049920.0 |
| 2009-08-14 11:00:00 | NVDA | Stock | 0.3338 | 0.3359 | 0.3333 | 0.3344 | 58259000.0 |
| 2009-08-14 12:00:00 | NVDA | Stock | 0.3344 | 0.3345 | 0.3325 | 0.3335 | 32561280.0 |
| 2009-08-14 13:00:00 | NVDA | Stock | 0.3334 | 0.3355 | 0.333 | 0.3355 | 22432920.0 |
| 2009-08-14 14:00:00 | NVDA | Stock | 0.3355 | 0.3355 | 0.3333 | 0.3338 | 31556760.0 |
| 2009-08-14 15:00:00 | NVDA | Stock | 0.3335 | 0.336 | 0.333 | 0.3353 | 56436800.0 |
| 2009-08-14 16:00:00 | NVDA | Stock | 0.3353 | 0.3458 | 0.3349 | 0.3358 | 7929080.0 |
| 2009-08-14 17:00:00 | NVDA | Stock | 0.335 | 0.335 | 0.335 | 0.335 | 4000.0 |
| 2009-08-14 18:00:00 | NVDA | Stock | 0.334 | 0.334 | 0.334 | 0.334 | 12000.0 |
| 2009-08-14 07:00:00 | AMZN | Stock | 4.23 | 4.2305 | 4.23 | 4.23 | 77860.0 |
| 2009-08-14 08:00:00 | AMZN | Stock | 4.234 | 4.234 | 4.2005 | 4.2005 | 26000.0 |
| 2009-08-14 09:00:00 | AMZN | Stock | 4.201 | 4.2085 | 4.1595 | 4.1725 | 19695140.0 |
| 2009-08-14 10:00:00 | AMZN | Stock | 4.1735 | 4.187 | 4.1525 | 4.1695 | 15878640.0 |
| 2009-08-14 11:00:00 | AMZN | Stock | 4.171 | 4.178 | 4.143 | 4.1445 | 12483340.0 |
| 2009-08-14 12:00:00 | AMZN | Stock | 4.145 | 4.161 | 4.1395 | 4.1595 | 6836440.0 |
| 2009-08-14 13:00:00 | AMZN | Stock | 4.1585 | 4.1605 | 4.139 | 4.1505 | 7495300.0 |
| 2009-08-14 14:00:00 | AMZN | Stock | 4.1505 | 4.1725 | 4.1435 | 4.1615 | 7882460.0 |
| 2009-08-14 15:00:00 | AMZN | Stock | 4.16 | 4.1825 | 4.148 | 4.1765 | 21487340.0 |
| 2009-08-14 16:00:00 | AMZN | Stock | 4.1775 | 4.23 | 4.1608 | 4.1825 | 4840600.0 |
| 2009-08-14 17:00:00 | AMZN | Stock | 4.178 | 4.178 | 4.178 | 4.178 | 2000.0 |
> showing 50 of 41,364 rows — these rows as CSV