PREVIEW / stock_30min / 2001-03-20
file: by_date/stock_30min/2001/2001-03-20.parquet size: 527 KB rows: 26,831 symbols: 1,280
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 |
|---|---|---|---|---|---|---|---|
| 2001-03-20 08:00:00 | AAPL | Stock | 0.3571 | 0.3722 | 0.3571 | 0.3722 | 599200.0 |
| 2001-03-20 08:30:00 | AAPL | Stock | 0.375 | 0.375 | 0.3683 | 0.3683 | 235200.0 |
| 2001-03-20 09:00:00 | AAPL | Stock | 0.3683 | 0.3705 | 0.3672 | 0.3705 | 3371200.0 |
| 2001-03-20 09:30:00 | AAPL | Stock | 0.37 | 0.3728 | 0.365 | 0.365 | 41960800.0 |
| 2001-03-20 10:00:00 | AAPL | Stock | 0.3661 | 0.3705 | 0.365 | 0.3683 | 13501600.0 |
| 2001-03-20 10:30:00 | AAPL | Stock | 0.37 | 0.3717 | 0.3683 | 0.3694 | 23867200.0 |
| 2001-03-20 11:00:00 | AAPL | Stock | 0.3694 | 0.3717 | 0.3661 | 0.3705 | 45858400.0 |
| 2001-03-20 11:30:00 | AAPL | Stock | 0.3705 | 0.3717 | 0.3694 | 0.3717 | 25009600.0 |
| 2001-03-20 12:00:00 | AAPL | Stock | 0.3717 | 0.3717 | 0.3672 | 0.3672 | 44503200.0 |
| 2001-03-20 12:30:00 | AAPL | Stock | 0.3672 | 0.3683 | 0.365 | 0.3661 | 31460800.0 |
| 2001-03-20 13:00:00 | AAPL | Stock | 0.365 | 0.3717 | 0.3638 | 0.3705 | 28655200.0 |
| 2001-03-20 13:30:00 | AAPL | Stock | 0.3705 | 0.3728 | 0.3694 | 0.3694 | 40779200.0 |
| 2001-03-20 14:00:00 | AAPL | Stock | 0.3694 | 0.3739 | 0.365 | 0.3694 | 33236000.0 |
| 2001-03-20 14:30:00 | AAPL | Stock | 0.3683 | 0.3717 | 0.365 | 0.365 | 22836800.0 |
| 2001-03-20 15:00:00 | AAPL | Stock | 0.3661 | 0.3661 | 0.3594 | 0.3594 | 41591200.0 |
| 2001-03-20 15:30:00 | AAPL | Stock | 0.3583 | 0.3594 | 0.3516 | 0.3521 | 47891200.0 |
| 2001-03-20 16:00:00 | AAPL | Stock | 0.3516 | 0.3672 | 0.3516 | 0.3516 | 32799200.0 |
| 2001-03-20 16:30:00 | AAPL | Stock | 0.3504 | 0.3504 | 0.3504 | 0.3504 | 168000.0 |
| 2001-03-20 17:00:00 | AAPL | Stock | 0.3504 | 0.3504 | 0.3493 | 0.3493 | 39200.0 |
| 2001-03-20 18:00:00 | AAPL | Stock | 0.3493 | 0.3527 | 0.3493 | 0.3527 | 56000.0 |
| 2001-03-20 08:00:00 | MSFT | Stock | 27.3438 | 27.5625 | 27.3438 | 27.5625 | 33800.0 |
| 2001-03-20 08:30:00 | MSFT | Stock | 27.5625 | 27.5625 | 27.3125 | 27.3125 | 127000.0 |
| 2001-03-20 09:00:00 | MSFT | Stock | 27.4062 | 27.4688 | 27.25 | 27.2812 | 895200.0 |
| 2001-03-20 09:30:00 | MSFT | Stock | 27.2812 | 27.6875 | 27.1562 | 27.5625 | 11345000.0 |
| 2001-03-20 10:00:00 | MSFT | Stock | 27.5625 | 27.875 | 27.5 | 27.6562 | 6565000.0 |
| 2001-03-20 10:30:00 | MSFT | Stock | 27.6875 | 27.8438 | 27.5312 | 27.5312 | 2847200.0 |
| 2001-03-20 11:00:00 | MSFT | Stock | 27.5312 | 27.625 | 27.3438 | 27.3438 | 2737600.0 |
| 2001-03-20 11:30:00 | MSFT | Stock | 27.3438 | 27.5938 | 27.3438 | 27.5938 | 2994800.0 |
| 2001-03-20 12:00:00 | MSFT | Stock | 27.5938 | 27.6562 | 27.4688 | 27.5312 | 1451800.0 |
| 2001-03-20 12:30:00 | MSFT | Stock | 27.5625 | 27.5938 | 27.25 | 27.3438 | 5575600.0 |
| 2001-03-20 13:00:00 | MSFT | Stock | 27.3438 | 27.5938 | 27.3125 | 27.5625 | 2876600.0 |
| 2001-03-20 13:30:00 | MSFT | Stock | 27.5312 | 27.875 | 27.5 | 27.7188 | 5844600.0 |
| 2001-03-20 14:00:00 | MSFT | Stock | 27.75 | 28.0625 | 27.3125 | 27.7812 | 11489600.0 |
| 2001-03-20 14:30:00 | MSFT | Stock | 27.7812 | 27.8125 | 26.9062 | 26.9375 | 9479000.0 |
| 2001-03-20 15:00:00 | MSFT | Stock | 26.9375 | 27.125 | 26.6562 | 26.7812 | 8432200.0 |
| 2001-03-20 15:30:00 | MSFT | Stock | 26.8125 | 26.9062 | 26.3125 | 26.3438 | 12850400.0 |
| 2001-03-20 16:00:00 | MSFT | Stock | 26.3438 | 27.375 | 26.0938 | 26.2188 | 2695400.0 |
| 2001-03-20 16:30:00 | MSFT | Stock | 26.25 | 27.7031 | 26.25 | 26.3125 | 57000.0 |
| 2001-03-20 17:00:00 | MSFT | Stock | 26.3125 | 26.3438 | 26.2812 | 26.2812 | 29000.0 |
| 2001-03-20 17:30:00 | MSFT | Stock | 26.3438 | 26.3438 | 26.25 | 26.25 | 8000.0 |
| 2001-03-20 18:00:00 | MSFT | Stock | 26.375 | 26.375 | 26.25 | 26.3594 | 1600.0 |
| 2001-03-20 08:30:00 | NVDA | Stock | 0.2625 | 0.2625 | 0.2625 | 0.2625 | 480000.0 |
| 2001-03-20 09:00:00 | NVDA | Stock | 0.2609 | 0.2622 | 0.2583 | 0.2604 | 3408000.0 |
| 2001-03-20 09:30:00 | NVDA | Stock | 0.2596 | 0.2719 | 0.2594 | 0.2701 | 332400000.0 |
| 2001-03-20 10:00:00 | NVDA | Stock | 0.2701 | 0.2719 | 0.2664 | 0.2688 | 147576000.0 |
| 2001-03-20 10:30:00 | NVDA | Stock | 0.2688 | 0.275 | 0.2677 | 0.2727 | 116400000.0 |
| 2001-03-20 11:00:00 | NVDA | Stock | 0.2724 | 0.2729 | 0.2667 | 0.2688 | 101760000.0 |
| 2001-03-20 11:30:00 | NVDA | Stock | 0.2688 | 0.276 | 0.2682 | 0.274 | 96048000.0 |
| 2001-03-20 12:00:00 | NVDA | Stock | 0.274 | 0.2758 | 0.2708 | 0.2727 | 98448000.0 |
| 2001-03-20 12:30:00 | NVDA | Stock | 0.2727 | 0.2745 | 0.2708 | 0.2724 | 70464000.0 |
> showing 50 of 26,831 rows — these rows as CSV