PREVIEW / stock_1hour / 2009-11-11
file: by_date/stock_1hour/2009/2009-11-11.parquet size: 919 KB rows: 44,554 symbols: 3,402
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-11-11 04:00:00 | AAPL | Stock | 7.2632 | 7.2686 | 7.2632 | 7.2686 | 8400.0 |
| 2009-11-11 06:00:00 | AAPL | Stock | 7.2857 | 7.2857 | 7.2839 | 7.2857 | 9520.0 |
| 2009-11-11 07:00:00 | AAPL | Stock | 7.3054 | 7.3107 | 7.2911 | 7.3107 | 321692.0 |
| 2009-11-11 08:00:00 | AAPL | Stock | 7.3061 | 7.3157 | 7.3 | 7.3107 | 3240104.0 |
| 2009-11-11 09:00:00 | AAPL | Stock | 7.3093 | 7.3214 | 7.275 | 7.3025 | 91842352.0 |
| 2009-11-11 10:00:00 | AAPL | Stock | 7.3025 | 7.3168 | 7.275 | 7.2878 | 91528836.0 |
| 2009-11-11 11:00:00 | AAPL | Stock | 7.2868 | 7.2975 | 7.2554 | 7.2718 | 67355596.0 |
| 2009-11-11 12:00:00 | AAPL | Stock | 7.2725 | 7.2946 | 7.2554 | 7.2554 | 31122336.0 |
| 2009-11-11 13:00:00 | AAPL | Stock | 7.2554 | 7.2771 | 7.2082 | 7.2275 | 54208280.0 |
| 2009-11-11 14:00:00 | AAPL | Stock | 7.2275 | 7.2757 | 7.2237 | 7.2632 | 43564724.0 |
| 2009-11-11 15:00:00 | AAPL | Stock | 7.2629 | 7.2704 | 7.245 | 7.2593 | 49212884.0 |
| 2009-11-11 16:00:00 | AAPL | Stock | 7.2589 | 7.2824 | 7.2494 | 7.2589 | 4977504.0 |
| 2009-11-11 17:00:00 | AAPL | Stock | 7.2621 | 7.2661 | 7.2589 | 7.2629 | 315364.0 |
| 2009-11-11 18:00:00 | AAPL | Stock | 7.2621 | 7.2693 | 7.2589 | 7.2693 | 108444.0 |
| 2009-11-11 19:00:00 | AAPL | Stock | 7.2664 | 7.2704 | 7.2629 | 7.2696 | 141232.0 |
| 2009-11-11 04:00:00 | MSFT | Stock | 29.14 | 29.14 | 29.14 | 29.14 | 700.0 |
| 2009-11-11 06:00:00 | MSFT | Stock | 29.18 | 29.18 | 29.18 | 29.18 | 300.0 |
| 2009-11-11 07:00:00 | MSFT | Stock | 29.11 | 29.15 | 29.11 | 29.15 | 850.0 |
| 2009-11-11 08:00:00 | MSFT | Stock | 29.15 | 29.24 | 28.955 | 29.08 | 35390.0 |
| 2009-11-11 09:00:00 | MSFT | Stock | 29.1 | 29.26 | 29.02 | 29.255 | 6501520.0 |
| 2009-11-11 10:00:00 | MSFT | Stock | 29.26 | 29.3 | 29.05 | 29.12 | 12851333.0 |
| 2009-11-11 11:00:00 | MSFT | Stock | 29.12 | 29.27 | 29.09 | 29.13 | 6928751.0 |
| 2009-11-11 12:00:00 | MSFT | Stock | 29.13 | 29.25 | 29.122 | 29.2 | 4181370.0 |
| 2009-11-11 13:00:00 | MSFT | Stock | 29.2 | 29.23 | 29.12 | 29.134 | 3890765.0 |
| 2009-11-11 14:00:00 | MSFT | Stock | 29.14 | 29.19 | 29.06 | 29.07 | 4289110.0 |
| 2009-11-11 15:00:00 | MSFT | Stock | 29.072 | 29.15 | 29.03 | 29.13 | 8367493.0 |
| 2009-11-11 16:00:00 | MSFT | Stock | 29.13 | 29.197 | 29.101 | 29.12 | 1151568.0 |
| 2009-11-11 17:00:00 | MSFT | Stock | 29.12 | 29.12 | 29.12 | 29.12 | 20677.0 |
| 2009-11-11 18:00:00 | MSFT | Stock | 29.12 | 29.19 | 29.12 | 29.19 | 2666.0 |
| 2009-11-11 19:00:00 | MSFT | Stock | 29.15 | 29.19 | 29.15 | 29.19 | 892.0 |
| 2009-11-11 20:00:00 | MSFT | Stock | 29.17 | 29.17 | 29.17 | 29.17 | 30800.0 |
| 2009-11-11 07:00:00 | NVDA | Stock | 0.3322 | 0.3322 | 0.3322 | 0.3322 | 20000.0 |
| 2009-11-11 08:00:00 | NVDA | Stock | 0.3325 | 0.334 | 0.3289 | 0.3325 | 1153960.0 |
| 2009-11-11 09:00:00 | NVDA | Stock | 0.3325 | 0.342 | 0.33 | 0.3415 | 111949120.0 |
| 2009-11-11 10:00:00 | NVDA | Stock | 0.3415 | 0.3455 | 0.34 | 0.3407 | 196554160.0 |
| 2009-11-11 11:00:00 | NVDA | Stock | 0.3405 | 0.3418 | 0.337 | 0.3395 | 114219480.0 |
| 2009-11-11 12:00:00 | NVDA | Stock | 0.3393 | 0.3408 | 0.3382 | 0.3385 | 49026800.0 |
| 2009-11-11 13:00:00 | NVDA | Stock | 0.3385 | 0.3402 | 0.3382 | 0.3388 | 51389240.0 |
| 2009-11-11 14:00:00 | NVDA | Stock | 0.3385 | 0.3428 | 0.3382 | 0.341 | 131477520.0 |
| 2009-11-11 15:00:00 | NVDA | Stock | 0.3413 | 0.342 | 0.3375 | 0.3375 | 196099680.0 |
| 2009-11-11 16:00:00 | NVDA | Stock | 0.3375 | 0.3405 | 0.3368 | 0.34 | 8656080.0 |
| 2009-11-11 17:00:00 | NVDA | Stock | 0.3375 | 0.3405 | 0.3375 | 0.3405 | 152680.0 |
| 2009-11-11 19:00:00 | NVDA | Stock | 0.3402 | 0.3402 | 0.3402 | 0.3402 | 110000.0 |
| 2009-11-11 05:00:00 | AMZN | Stock | 6.5475 | 6.5475 | 6.5475 | 6.5475 | 2000.0 |
| 2009-11-11 07:00:00 | AMZN | Stock | 6.575 | 6.575 | 6.53 | 6.545 | 24000.0 |
| 2009-11-11 08:00:00 | AMZN | Stock | 6.545 | 6.575 | 6.5255 | 6.547 | 939180.0 |
| 2009-11-11 09:00:00 | AMZN | Stock | 6.5375 | 6.5655 | 6.4745 | 6.528 | 25280040.0 |
| 2009-11-11 10:00:00 | AMZN | Stock | 6.5275 | 6.5602 | 6.4805 | 6.4865 | 31343960.0 |
| 2009-11-11 11:00:00 | AMZN | Stock | 6.4875 | 6.512 | 6.4535 | 6.469 | 21130540.0 |
| 2009-11-11 12:00:00 | AMZN | Stock | 6.469 | 6.5225 | 6.455 | 6.476 | 13954680.0 |
> showing 50 of 44,554 rows — these rows as CSV