PREVIEW / stock_30min / 2007-04-05
file: by_date/stock_30min/2007/2007-04-05.parquet size: 1007 KB rows: 54,743 symbols: 2,577
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 |
|---|---|---|---|---|---|---|---|
| 2007-04-05 06:00:00 | AAPL | Stock | 3.3614 | 3.3764 | 3.3614 | 3.3764 | 8400.0 |
| 2007-04-05 08:00:00 | AAPL | Stock | 3.3696 | 3.3704 | 3.3671 | 3.3704 | 149548.0 |
| 2007-04-05 08:30:00 | AAPL | Stock | 3.3686 | 3.3686 | 3.3621 | 3.3621 | 204288.0 |
| 2007-04-05 09:00:00 | AAPL | Stock | 3.3625 | 3.365 | 3.3607 | 3.3629 | 602840.0 |
| 2007-04-05 09:30:00 | AAPL | Stock | 3.3614 | 3.3661 | 3.34 | 3.3496 | 54402768.0 |
| 2007-04-05 10:00:00 | AAPL | Stock | 3.3496 | 3.3589 | 3.3432 | 3.3475 | 35349188.0 |
| 2007-04-05 10:30:00 | AAPL | Stock | 3.3475 | 3.36 | 3.3446 | 3.3546 | 42937020.0 |
| 2007-04-05 11:00:00 | AAPL | Stock | 3.3546 | 3.3575 | 3.3482 | 3.3539 | 25006184.0 |
| 2007-04-05 11:30:00 | AAPL | Stock | 3.3539 | 3.3625 | 3.3504 | 3.3611 | 25166036.0 |
| 2007-04-05 12:00:00 | AAPL | Stock | 3.3611 | 3.3646 | 3.3536 | 3.3571 | 24507252.0 |
| 2007-04-05 12:30:00 | AAPL | Stock | 3.3575 | 3.3607 | 3.3554 | 3.3557 | 11136328.0 |
| 2007-04-05 13:00:00 | AAPL | Stock | 3.3557 | 3.3582 | 3.3532 | 3.3568 | 13577284.0 |
| 2007-04-05 13:30:00 | AAPL | Stock | 3.3564 | 3.36 | 3.3536 | 3.3582 | 12761812.0 |
| 2007-04-05 14:00:00 | AAPL | Stock | 3.3582 | 3.3582 | 3.3546 | 3.3571 | 11898712.0 |
| 2007-04-05 14:30:00 | AAPL | Stock | 3.3571 | 3.3714 | 3.3568 | 3.3689 | 27563424.0 |
| 2007-04-05 15:00:00 | AAPL | Stock | 3.3686 | 3.3704 | 3.365 | 3.3686 | 18149432.0 |
| 2007-04-05 15:30:00 | AAPL | Stock | 3.3689 | 3.3811 | 3.365 | 3.3811 | 40927684.0 |
| 2007-04-05 16:00:00 | AAPL | Stock | 3.3814 | 3.3836 | 3.3693 | 3.3796 | 4772208.0 |
| 2007-04-05 16:30:00 | AAPL | Stock | 3.3789 | 3.3814 | 3.3786 | 3.3786 | 422408.0 |
| 2007-04-05 17:00:00 | AAPL | Stock | 3.3804 | 3.3811 | 3.3789 | 3.3789 | 120456.0 |
| 2007-04-05 17:30:00 | AAPL | Stock | 3.3789 | 3.3789 | 3.3779 | 3.3789 | 66920.0 |
| 2007-04-05 18:30:00 | AAPL | Stock | 3.3786 | 3.3786 | 3.3768 | 3.3768 | 23100.0 |
| 2007-04-05 19:00:00 | AAPL | Stock | 3.3771 | 3.3786 | 3.3771 | 3.3771 | 14000.0 |
| 2007-04-05 19:30:00 | AAPL | Stock | 3.3793 | 3.3804 | 3.3768 | 3.3804 | 85176.0 |
| 2007-04-05 08:00:00 | MSFT | Stock | 28.48 | 28.48 | 28.46 | 28.46 | 3500.0 |
| 2007-04-05 08:30:00 | MSFT | Stock | 28.45 | 28.45 | 28.4 | 28.42 | 1600.0 |
| 2007-04-05 09:00:00 | MSFT | Stock | 28.38 | 28.44 | 28.3 | 28.32 | 60980.0 |
| 2007-04-05 09:30:00 | MSFT | Stock | 28.32 | 28.56 | 28.3 | 28.51 | 4408356.0 |
| 2007-04-05 10:00:00 | MSFT | Stock | 28.51 | 28.542 | 28.47 | 28.49 | 2206947.0 |
| 2007-04-05 10:30:00 | MSFT | Stock | 28.49 | 28.52 | 28.49 | 28.49 | 1274593.0 |
| 2007-04-05 11:00:00 | MSFT | Stock | 28.49 | 28.57 | 28.49 | 28.54 | 2018970.0 |
| 2007-04-05 11:30:00 | MSFT | Stock | 28.54 | 28.58 | 28.5 | 28.52 | 2148470.0 |
| 2007-04-05 12:00:00 | MSFT | Stock | 28.52 | 28.55 | 28.52 | 28.53 | 1661361.0 |
| 2007-04-05 12:30:00 | MSFT | Stock | 28.53 | 28.54 | 28.5 | 28.52 | 1378196.0 |
| 2007-04-05 13:00:00 | MSFT | Stock | 28.52 | 28.6 | 28.52 | 28.547 | 1393557.0 |
| 2007-04-05 13:30:00 | MSFT | Stock | 28.54 | 28.59 | 28.53 | 28.555 | 1008394.0 |
| 2007-04-05 14:00:00 | MSFT | Stock | 28.55 | 28.65 | 28.55 | 28.64 | 2032397.0 |
| 2007-04-05 14:30:00 | MSFT | Stock | 28.63 | 28.65 | 28.54 | 28.55 | 2148430.0 |
| 2007-04-05 15:00:00 | MSFT | Stock | 28.55 | 28.61 | 28.52 | 28.53 | 2346222.0 |
| 2007-04-05 15:30:00 | MSFT | Stock | 28.53 | 28.55 | 28.51 | 28.55 | 4722744.0 |
| 2007-04-05 16:00:00 | MSFT | Stock | 28.55 | 28.61 | 28.51 | 28.57 | 110159.0 |
| 2007-04-05 17:00:00 | MSFT | Stock | 28.52 | 28.52 | 28.52 | 28.52 | 200.0 |
| 2007-04-05 17:30:00 | MSFT | Stock | 28.52 | 28.52 | 28.51 | 28.51 | 450.0 |
| 2007-04-05 19:00:00 | MSFT | Stock | 28.55 | 28.55 | 28.55 | 28.55 | 100.0 |
| 2007-04-05 08:30:00 | NVDA | Stock | 0.4803 | 0.4803 | 0.4803 | 0.4803 | 66000.0 |
| 2007-04-05 09:00:00 | NVDA | Stock | 0.4797 | 0.4808 | 0.479 | 0.479 | 312000.0 |
| 2007-04-05 09:30:00 | NVDA | Stock | 0.4783 | 0.4905 | 0.4783 | 0.489 | 87479820.0 |
| 2007-04-05 10:00:00 | NVDA | Stock | 0.4889 | 0.493 | 0.488 | 0.49 | 93718320.0 |
| 2007-04-05 10:30:00 | NVDA | Stock | 0.4902 | 0.4908 | 0.4883 | 0.4897 | 43190940.0 |
| 2007-04-05 11:00:00 | NVDA | Stock | 0.4898 | 0.4932 | 0.4868 | 0.4927 | 50331540.0 |
> showing 50 of 54,743 rows — these rows as CSV