PREVIEW / stock_1hour / 2006-02-13
file: by_date/stock_1hour/2006/2006-02-13.parquet size: 604 KB rows: 28,545 symbols: 2,194
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-02-13 07:00:00 | AAPL | Stock | 2.3821 | 2.3929 | 2.3807 | 2.3893 | 240800.0 |
| 2006-02-13 08:00:00 | AAPL | Stock | 2.3889 | 2.3889 | 2.3714 | 2.3804 | 3298848.0 |
| 2006-02-13 09:00:00 | AAPL | Stock | 2.3793 | 2.3839 | 2.3346 | 2.3461 | 166040756.0 |
| 2006-02-13 10:00:00 | AAPL | Stock | 2.3464 | 2.3583 | 2.3186 | 2.3354 | 184806440.0 |
| 2006-02-13 11:00:00 | AAPL | Stock | 2.3357 | 2.3571 | 2.3286 | 2.3321 | 123148816.0 |
| 2006-02-13 12:00:00 | AAPL | Stock | 2.332 | 2.3546 | 2.3296 | 2.3479 | 60803680.0 |
| 2006-02-13 13:00:00 | AAPL | Stock | 2.3482 | 2.3546 | 2.3214 | 2.3214 | 80411856.0 |
| 2006-02-13 14:00:00 | AAPL | Stock | 2.3225 | 2.3421 | 2.3214 | 2.3257 | 78041432.0 |
| 2006-02-13 15:00:00 | AAPL | Stock | 2.3257 | 2.3296 | 2.3086 | 2.3111 | 170778272.0 |
| 2006-02-13 16:00:00 | AAPL | Stock | 2.3114 | 2.3186 | 2.2996 | 2.3089 | 3499776.0 |
| 2006-02-13 17:00:00 | AAPL | Stock | 2.3089 | 2.31 | 2.3057 | 2.3071 | 809480.0 |
| 2006-02-13 18:00:00 | AAPL | Stock | 2.3071 | 2.3086 | 2.3057 | 2.3071 | 171080.0 |
| 2006-02-13 08:00:00 | MSFT | Stock | 26.67 | 26.74 | 26.55 | 26.72 | 23581.0 |
| 2006-02-13 09:00:00 | MSFT | Stock | 26.73 | 26.75 | 26.56 | 26.6 | 4857045.0 |
| 2006-02-13 10:00:00 | MSFT | Stock | 26.59 | 26.65 | 26.54 | 26.58 | 5039983.0 |
| 2006-02-13 11:00:00 | MSFT | Stock | 26.58 | 26.6 | 26.56 | 26.58 | 3701848.0 |
| 2006-02-13 12:00:00 | MSFT | Stock | 26.572 | 26.59 | 26.51 | 26.51 | 3116806.0 |
| 2006-02-13 13:00:00 | MSFT | Stock | 26.52 | 26.54 | 26.34 | 26.36 | 10683479.0 |
| 2006-02-13 14:00:00 | MSFT | Stock | 26.35 | 26.46 | 26.34 | 26.38 | 6101569.0 |
| 2006-02-13 15:00:00 | MSFT | Stock | 26.38 | 26.46 | 26.35 | 26.39 | 12107797.0 |
| 2006-02-13 16:00:00 | MSFT | Stock | 26.4 | 26.59 | 26.39 | 26.42 | 201542.0 |
| 2006-02-13 17:00:00 | MSFT | Stock | 26.43 | 26.43 | 26.4 | 26.43 | 9350.0 |
| 2006-02-13 18:00:00 | MSFT | Stock | 26.4 | 26.4 | 26.4 | 26.4 | 3400.0 |
| 2006-02-13 09:00:00 | NVDA | Stock | 0.3646 | 0.3672 | 0.3622 | 0.366 | 31350480.0 |
| 2006-02-13 10:00:00 | NVDA | Stock | 0.366 | 0.3697 | 0.3648 | 0.3667 | 64274760.0 |
| 2006-02-13 11:00:00 | NVDA | Stock | 0.3669 | 0.3675 | 0.364 | 0.3646 | 24414480.0 |
| 2006-02-13 12:00:00 | NVDA | Stock | 0.3644 | 0.3667 | 0.3643 | 0.3666 | 32379960.0 |
| 2006-02-13 13:00:00 | NVDA | Stock | 0.3667 | 0.3672 | 0.3643 | 0.3651 | 36211320.0 |
| 2006-02-13 14:00:00 | NVDA | Stock | 0.3648 | 0.3667 | 0.3646 | 0.3655 | 22024440.0 |
| 2006-02-13 15:00:00 | NVDA | Stock | 0.3655 | 0.3675 | 0.3649 | 0.3669 | 39461040.0 |
| 2006-02-13 16:00:00 | NVDA | Stock | 0.367 | 0.3676 | 0.3669 | 0.3671 | 605640.0 |
| 2006-02-13 17:00:00 | NVDA | Stock | 0.3672 | 0.3674 | 0.3672 | 0.3674 | 213600.0 |
| 2006-02-13 08:00:00 | AMZN | Stock | 1.91 | 1.9195 | 1.91 | 1.9125 | 254000.0 |
| 2006-02-13 09:00:00 | AMZN | Stock | 1.9175 | 1.9285 | 1.885 | 1.887 | 13540400.0 |
| 2006-02-13 10:00:00 | AMZN | Stock | 1.887 | 1.894 | 1.8785 | 1.8845 | 18124800.0 |
| 2006-02-13 11:00:00 | AMZN | Stock | 1.883 | 1.8905 | 1.8765 | 1.8875 | 10165400.0 |
| 2006-02-13 12:00:00 | AMZN | Stock | 1.888 | 1.892 | 1.8795 | 1.892 | 6996040.0 |
| 2006-02-13 13:00:00 | AMZN | Stock | 1.89 | 1.897 | 1.883 | 1.8864 | 10973620.0 |
| 2006-02-13 14:00:00 | AMZN | Stock | 1.886 | 1.895 | 1.877 | 1.8845 | 10842100.0 |
| 2006-02-13 15:00:00 | AMZN | Stock | 1.8845 | 1.902 | 1.881 | 1.8945 | 20917240.0 |
| 2006-02-13 16:00:00 | AMZN | Stock | 1.893 | 1.9 | 1.893 | 1.893 | 510420.0 |
| 2006-02-13 08:00:00 | CL | Stock | 27.01 | 27.01 | 27.01 | 27.01 | 1600.0 |
| 2006-02-13 09:00:00 | CL | Stock | 27.0 | 27.06 | 26.85 | 26.905 | 302800.0 |
| 2006-02-13 10:00:00 | CL | Stock | 26.905 | 26.945 | 26.875 | 26.915 | 280000.0 |
| 2006-02-13 11:00:00 | CL | Stock | 26.92 | 27.015 | 26.87 | 27.005 | 353200.0 |
| 2006-02-13 12:00:00 | CL | Stock | 27.0055 | 27.015 | 26.935 | 26.975 | 196000.0 |
| 2006-02-13 13:00:00 | CL | Stock | 26.975 | 27.0 | 26.935 | 26.945 | 256000.0 |
| 2006-02-13 14:00:00 | CL | Stock | 26.95 | 27.005 | 26.92 | 26.945 | 360400.0 |
| 2006-02-13 15:00:00 | CL | Stock | 26.945 | 27.065 | 26.925 | 27.035 | 482400.0 |
> showing 49 of 28,545 rows — these rows as CSV