PREVIEW / stock_1hour / 2009-09-16
file: by_date/stock_1hour/2009/2009-09-16.parquet size: 911 KB rows: 44,015 symbols: 3,391
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-16 04:00:00 | AAPL | Stock | 6.3389 | 6.3389 | 6.3354 | 6.3389 | 20944.0 |
| 2009-09-16 05:00:00 | AAPL | Stock | 6.3525 | 6.3525 | 6.3393 | 6.3393 | 5600.0 |
| 2009-09-16 06:00:00 | AAPL | Stock | 6.3393 | 6.3804 | 6.3393 | 6.3804 | 77504.0 |
| 2009-09-16 07:00:00 | AAPL | Stock | 6.3696 | 6.3696 | 6.3304 | 6.3414 | 1248800.0 |
| 2009-09-16 08:00:00 | AAPL | Stock | 6.3443 | 6.3679 | 6.3414 | 6.3554 | 4756836.0 |
| 2009-09-16 09:00:00 | AAPL | Stock | 6.3564 | 6.4214 | 6.3468 | 6.4111 | 127356180.0 |
| 2009-09-16 10:00:00 | AAPL | Stock | 6.4114 | 6.4346 | 6.3889 | 6.4289 | 95501420.0 |
| 2009-09-16 11:00:00 | AAPL | Stock | 6.4289 | 6.4929 | 6.4257 | 6.4676 | 115335948.0 |
| 2009-09-16 12:00:00 | AAPL | Stock | 6.4682 | 6.5268 | 6.4661 | 6.4729 | 105477484.0 |
| 2009-09-16 13:00:00 | AAPL | Stock | 6.4722 | 6.505 | 6.4686 | 6.5011 | 57297772.0 |
| 2009-09-16 14:00:00 | AAPL | Stock | 6.5011 | 6.5207 | 6.4929 | 6.4954 | 75815880.0 |
| 2009-09-16 15:00:00 | AAPL | Stock | 6.4957 | 6.5068 | 6.4839 | 6.4957 | 105213752.0 |
| 2009-09-16 16:00:00 | AAPL | Stock | 6.4979 | 6.4996 | 6.4582 | 6.49 | 11415572.0 |
| 2009-09-16 17:00:00 | AAPL | Stock | 6.4954 | 6.4954 | 6.4821 | 6.4889 | 6733860.0 |
| 2009-09-16 18:00:00 | AAPL | Stock | 6.4882 | 6.5 | 6.4857 | 6.5 | 996632.0 |
| 2009-09-16 19:00:00 | AAPL | Stock | 6.4996 | 6.5054 | 6.4929 | 6.5029 | 434336.0 |
| 2009-09-16 05:00:00 | MSFT | Stock | 25.3 | 25.3 | 25.3 | 25.3 | 100.0 |
| 2009-09-16 07:00:00 | MSFT | Stock | 25.31 | 25.31 | 25.1 | 25.21 | 6300.0 |
| 2009-09-16 08:00:00 | MSFT | Stock | 25.21 | 25.25 | 25.21 | 25.23 | 16406.0 |
| 2009-09-16 09:00:00 | MSFT | Stock | 25.25 | 25.35 | 24.95 | 25.05 | 8539355.0 |
| 2009-09-16 10:00:00 | MSFT | Stock | 25.05 | 25.14 | 25.03 | 25.08 | 5257058.0 |
| 2009-09-16 11:00:00 | MSFT | Stock | 25.08 | 25.12 | 25.0 | 25.1 | 4734416.0 |
| 2009-09-16 12:00:00 | MSFT | Stock | 25.09 | 25.18 | 25.03 | 25.035 | 4421624.0 |
| 2009-09-16 13:00:00 | MSFT | Stock | 25.04 | 25.16 | 25.03 | 25.122 | 3109270.0 |
| 2009-09-16 14:00:00 | MSFT | Stock | 25.12 | 25.31 | 25.12 | 25.23 | 5007061.0 |
| 2009-09-16 15:00:00 | MSFT | Stock | 25.23 | 25.32 | 25.19 | 25.2 | 10320163.0 |
| 2009-09-16 16:00:00 | MSFT | Stock | 25.19 | 25.249 | 25.08 | 25.15 | 4434598.0 |
| 2009-09-16 17:00:00 | MSFT | Stock | 25.2 | 25.2 | 25.15 | 25.16 | 573135.0 |
| 2009-09-16 18:00:00 | MSFT | Stock | 25.14 | 25.14 | 25.14 | 25.14 | 2400.0 |
| 2009-09-16 19:00:00 | MSFT | Stock | 25.15 | 25.15 | 25.13 | 25.13 | 5366.0 |
| 2009-09-16 08:00:00 | NVDA | Stock | 0.4102 | 0.4102 | 0.4005 | 0.4038 | 1801560.0 |
| 2009-09-16 09:00:00 | NVDA | Stock | 0.405 | 0.41 | 0.397 | 0.3978 | 167814320.0 |
| 2009-09-16 10:00:00 | NVDA | Stock | 0.3978 | 0.401 | 0.3935 | 0.394 | 126086280.0 |
| 2009-09-16 11:00:00 | NVDA | Stock | 0.394 | 0.3962 | 0.3925 | 0.3948 | 80161560.0 |
| 2009-09-16 12:00:00 | NVDA | Stock | 0.3945 | 0.4003 | 0.3945 | 0.3966 | 100294680.0 |
| 2009-09-16 13:00:00 | NVDA | Stock | 0.3968 | 0.399 | 0.3958 | 0.3965 | 58787160.0 |
| 2009-09-16 14:00:00 | NVDA | Stock | 0.3965 | 0.3975 | 0.3958 | 0.3964 | 35423840.0 |
| 2009-09-16 15:00:00 | NVDA | Stock | 0.3962 | 0.3985 | 0.395 | 0.3985 | 87240880.0 |
| 2009-09-16 16:00:00 | NVDA | Stock | 0.397 | 0.3986 | 0.3965 | 0.3965 | 10951720.0 |
| 2009-09-16 17:00:00 | NVDA | Stock | 0.3985 | 0.3985 | 0.3985 | 0.3985 | 4414080.0 |
| 2009-09-16 18:00:00 | NVDA | Stock | 0.3985 | 0.4 | 0.3985 | 0.4 | 480000.0 |
| 2009-09-16 04:00:00 | AMZN | Stock | 4.225 | 4.25 | 4.225 | 4.25 | 12000.0 |
| 2009-09-16 05:00:00 | AMZN | Stock | 4.26 | 4.26 | 4.26 | 4.26 | 4000.0 |
| 2009-09-16 06:00:00 | AMZN | Stock | 4.28 | 4.29 | 4.28 | 4.29 | 30000.0 |
| 2009-09-16 07:00:00 | AMZN | Stock | 4.292 | 4.292 | 4.272 | 4.275 | 84900.0 |
| 2009-09-16 08:00:00 | AMZN | Stock | 4.274 | 4.2875 | 4.2665 | 4.28 | 1061160.0 |
| 2009-09-16 09:00:00 | AMZN | Stock | 4.278 | 4.374 | 4.278 | 4.3444 | 42207280.0 |
| 2009-09-16 10:00:00 | AMZN | Stock | 4.3445 | 4.41 | 4.344 | 4.402 | 38451800.0 |
| 2009-09-16 11:00:00 | AMZN | Stock | 4.4015 | 4.453 | 4.3975 | 4.4475 | 27186900.0 |
| 2009-09-16 12:00:00 | AMZN | Stock | 4.448 | 4.455 | 4.4275 | 4.4455 | 27485300.0 |
> showing 50 of 44,015 rows — these rows as CSV