PREVIEW / stock_30min / 2001-04-03
file: by_date/stock_30min/2001/2001-04-03.parquet size: 536 KB rows: 27,414 symbols: 1,285
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-04-03 08:30:00 | AAPL | Stock | 0.3838 | 0.3838 | 0.3838 | 0.3838 | 106400.0 |
| 2001-04-03 09:00:00 | AAPL | Stock | 0.383 | 0.383 | 0.3813 | 0.3813 | 397600.0 |
| 2001-04-03 09:30:00 | AAPL | Stock | 0.3814 | 0.3814 | 0.3745 | 0.3752 | 52130400.0 |
| 2001-04-03 10:00:00 | AAPL | Stock | 0.3752 | 0.3784 | 0.3723 | 0.3761 | 29618400.0 |
| 2001-04-03 10:30:00 | AAPL | Stock | 0.3757 | 0.3759 | 0.3727 | 0.3739 | 18272800.0 |
| 2001-04-03 11:00:00 | AAPL | Stock | 0.3729 | 0.3739 | 0.3696 | 0.3698 | 37962400.0 |
| 2001-04-03 11:30:00 | AAPL | Stock | 0.37 | 0.3723 | 0.367 | 0.367 | 29607200.0 |
| 2001-04-03 12:00:00 | AAPL | Stock | 0.3671 | 0.3736 | 0.3661 | 0.3677 | 18698400.0 |
| 2001-04-03 12:30:00 | AAPL | Stock | 0.3677 | 0.3757 | 0.3661 | 0.3757 | 33650400.0 |
| 2001-04-03 13:00:00 | AAPL | Stock | 0.3759 | 0.3766 | 0.3696 | 0.3704 | 16256800.0 |
| 2001-04-03 13:30:00 | AAPL | Stock | 0.3702 | 0.3739 | 0.3702 | 0.3718 | 10561600.0 |
| 2001-04-03 14:00:00 | AAPL | Stock | 0.3718 | 0.3734 | 0.3661 | 0.3663 | 10466400.0 |
| 2001-04-03 14:30:00 | AAPL | Stock | 0.3661 | 0.3677 | 0.3643 | 0.3668 | 23419200.0 |
| 2001-04-03 15:00:00 | AAPL | Stock | 0.3663 | 0.3675 | 0.3607 | 0.3621 | 18648000.0 |
| 2001-04-03 15:30:00 | AAPL | Stock | 0.362 | 0.3652 | 0.3595 | 0.3614 | 46636800.0 |
| 2001-04-03 16:00:00 | AAPL | Stock | 0.3613 | 0.3704 | 0.3573 | 0.3614 | 12605600.0 |
| 2001-04-03 16:30:00 | AAPL | Stock | 0.3589 | 0.3614 | 0.3589 | 0.3614 | 16800.0 |
| 2001-04-03 17:00:00 | AAPL | Stock | 0.3614 | 0.3614 | 0.3614 | 0.3614 | 672000.0 |
| 2001-04-03 17:30:00 | AAPL | Stock | 0.3571 | 0.3571 | 0.3571 | 0.3571 | 61600.0 |
| 2001-04-03 08:00:00 | MSFT | Stock | 27.4375 | 27.75 | 27.375 | 27.5625 | 25224.0 |
| 2001-04-03 08:30:00 | MSFT | Stock | 27.5625 | 27.625 | 27.4688 | 27.5 | 37200.0 |
| 2001-04-03 09:00:00 | MSFT | Stock | 27.5625 | 27.7812 | 27.5312 | 27.6562 | 490600.0 |
| 2001-04-03 09:30:00 | MSFT | Stock | 27.6562 | 27.7812 | 27.2188 | 27.2188 | 11401400.0 |
| 2001-04-03 10:00:00 | MSFT | Stock | 27.2188 | 27.75 | 27.125 | 27.4375 | 10764200.0 |
| 2001-04-03 10:30:00 | MSFT | Stock | 27.4375 | 27.5 | 27.0625 | 27.125 | 6440600.0 |
| 2001-04-03 11:00:00 | MSFT | Stock | 27.0938 | 27.125 | 26.8438 | 26.9375 | 7111600.0 |
| 2001-04-03 11:30:00 | MSFT | Stock | 26.9375 | 27.2188 | 26.875 | 27.0312 | 4903800.0 |
| 2001-04-03 12:00:00 | MSFT | Stock | 27.0469 | 27.5 | 26.9688 | 27.375 | 5239400.0 |
| 2001-04-03 12:30:00 | MSFT | Stock | 27.3438 | 27.4375 | 27.25 | 27.375 | 4008200.0 |
| 2001-04-03 13:00:00 | MSFT | Stock | 27.3438 | 27.375 | 27.1562 | 27.2188 | 3064200.0 |
| 2001-04-03 13:30:00 | MSFT | Stock | 27.2188 | 27.3125 | 26.9688 | 27.0 | 4314000.0 |
| 2001-04-03 14:00:00 | MSFT | Stock | 26.9688 | 27.0 | 26.6875 | 26.7188 | 6117400.0 |
| 2001-04-03 14:30:00 | MSFT | Stock | 26.75 | 27.0312 | 26.5625 | 26.7812 | 5043600.0 |
| 2001-04-03 15:00:00 | MSFT | Stock | 26.7812 | 26.8438 | 26.4375 | 26.4688 | 6731400.0 |
| 2001-04-03 15:30:00 | MSFT | Stock | 26.4688 | 26.75 | 26.375 | 26.7031 | 13640400.0 |
| 2001-04-03 16:00:00 | MSFT | Stock | 26.6875 | 27.0938 | 26.4531 | 26.7812 | 3213800.0 |
| 2001-04-03 16:30:00 | MSFT | Stock | 26.75 | 27.5 | 26.6875 | 26.7812 | 248000.0 |
| 2001-04-03 17:00:00 | MSFT | Stock | 26.8594 | 26.8594 | 26.6875 | 26.8125 | 360600.0 |
| 2001-04-03 17:30:00 | MSFT | Stock | 26.7812 | 26.875 | 26.6875 | 26.7188 | 129200.0 |
| 2001-04-03 18:00:00 | MSFT | Stock | 26.6875 | 26.75 | 26.6875 | 26.75 | 1600.0 |
| 2001-04-03 08:00:00 | NVDA | Stock | 0.2563 | 0.2583 | 0.2563 | 0.2583 | 336000.0 |
| 2001-04-03 08:30:00 | NVDA | Stock | 0.2594 | 0.2594 | 0.2583 | 0.2583 | 456000.0 |
| 2001-04-03 09:00:00 | NVDA | Stock | 0.2568 | 0.2586 | 0.2549 | 0.2555 | 2424000.0 |
| 2001-04-03 09:30:00 | NVDA | Stock | 0.2552 | 0.2646 | 0.2549 | 0.263 | 177840000.0 |
| 2001-04-03 10:00:00 | NVDA | Stock | 0.2629 | 0.2721 | 0.2625 | 0.2664 | 258384000.0 |
| 2001-04-03 10:30:00 | NVDA | Stock | 0.2664 | 0.268 | 0.2633 | 0.2661 | 123360000.0 |
| 2001-04-03 11:00:00 | NVDA | Stock | 0.2659 | 0.2664 | 0.2633 | 0.2656 | 137304000.0 |
| 2001-04-03 11:30:00 | NVDA | Stock | 0.2655 | 0.2695 | 0.2641 | 0.2677 | 118176000.0 |
| 2001-04-03 12:00:00 | NVDA | Stock | 0.2677 | 0.2745 | 0.2674 | 0.2701 | 157392000.0 |
| 2001-04-03 12:30:00 | NVDA | Stock | 0.2701 | 0.2747 | 0.2695 | 0.274 | 84624000.0 |
> showing 50 of 27,414 rows — these rows as CSV