PREVIEW / stock_30min / 2006-03-01
file: by_date/stock_30min/2006/2006-03-01.parquet size: 922 KB rows: 50,026 symbols: 2,206
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-03-01 07:30:00 | AAPL | Stock | 2.4643 | 2.4732 | 2.4571 | 2.4571 | 42000.0 |
| 2006-03-01 08:00:00 | AAPL | Stock | 2.4732 | 2.4814 | 2.4461 | 2.4643 | 2265368.0 |
| 2006-03-01 08:30:00 | AAPL | Stock | 2.4643 | 2.4671 | 2.4607 | 2.4664 | 1359932.0 |
| 2006-03-01 09:00:00 | AAPL | Stock | 2.4668 | 2.4668 | 2.4568 | 2.4639 | 4769016.0 |
| 2006-03-01 09:30:00 | AAPL | Stock | 2.4639 | 2.4818 | 2.45 | 2.4689 | 128848720.0 |
| 2006-03-01 10:00:00 | AAPL | Stock | 2.4686 | 2.4739 | 2.4293 | 2.45 | 145520284.0 |
| 2006-03-01 10:30:00 | AAPL | Stock | 2.4504 | 2.4714 | 2.4471 | 2.4671 | 75557132.0 |
| 2006-03-01 11:00:00 | AAPL | Stock | 2.4668 | 2.47 | 2.4557 | 2.4646 | 47938520.0 |
| 2006-03-01 11:30:00 | AAPL | Stock | 2.4643 | 2.4782 | 2.4629 | 2.4782 | 44670948.0 |
| 2006-03-01 12:00:00 | AAPL | Stock | 2.4775 | 2.48 | 2.4704 | 2.4721 | 33199292.0 |
| 2006-03-01 12:30:00 | AAPL | Stock | 2.4718 | 2.4814 | 2.4718 | 2.4775 | 24792740.0 |
| 2006-03-01 13:00:00 | AAPL | Stock | 2.4775 | 2.4807 | 2.4679 | 2.47 | 25532612.0 |
| 2006-03-01 13:30:00 | AAPL | Stock | 2.4703 | 2.4757 | 2.4661 | 2.4675 | 23829652.0 |
| 2006-03-01 14:00:00 | AAPL | Stock | 2.4679 | 2.4679 | 2.4514 | 2.4604 | 47154296.0 |
| 2006-03-01 14:30:00 | AAPL | Stock | 2.4604 | 2.4729 | 2.4582 | 2.4654 | 35827792.0 |
| 2006-03-01 15:00:00 | AAPL | Stock | 2.4654 | 2.4793 | 2.4643 | 2.475 | 35275548.0 |
| 2006-03-01 15:30:00 | AAPL | Stock | 2.475 | 2.4793 | 2.4621 | 2.4679 | 60399136.0 |
| 2006-03-01 16:00:00 | AAPL | Stock | 2.4679 | 2.475 | 2.463 | 2.4707 | 1848476.0 |
| 2006-03-01 16:30:00 | AAPL | Stock | 2.4707 | 2.4732 | 2.4679 | 2.4707 | 434812.0 |
| 2006-03-01 17:00:00 | AAPL | Stock | 2.4725 | 2.4732 | 2.4707 | 2.4714 | 436240.0 |
| 2006-03-01 17:30:00 | AAPL | Stock | 2.4711 | 2.4729 | 2.4678 | 2.4707 | 139496.0 |
| 2006-03-01 18:00:00 | AAPL | Stock | 2.4714 | 2.4732 | 2.4707 | 2.4732 | 53200.0 |
| 2006-03-01 07:00:00 | MSFT | Stock | 26.92 | 26.92 | 26.92 | 26.92 | 1000.0 |
| 2006-03-01 07:30:00 | MSFT | Stock | 26.87 | 26.88 | 26.87 | 26.87 | 2500.0 |
| 2006-03-01 08:00:00 | MSFT | Stock | 26.92 | 26.94 | 26.87 | 26.94 | 18225.0 |
| 2006-03-01 08:30:00 | MSFT | Stock | 26.95 | 26.98 | 26.9 | 26.97 | 35920.0 |
| 2006-03-01 09:00:00 | MSFT | Stock | 26.97 | 26.99 | 26.87 | 26.96 | 72876.0 |
| 2006-03-01 09:30:00 | MSFT | Stock | 26.98 | 27.09 | 26.95 | 27.06 | 6524009.0 |
| 2006-03-01 10:00:00 | MSFT | Stock | 27.06 | 27.08 | 26.96 | 26.97 | 3486939.0 |
| 2006-03-01 10:30:00 | MSFT | Stock | 26.98 | 27.09 | 26.96 | 27.04 | 4403622.0 |
| 2006-03-01 11:00:00 | MSFT | Stock | 27.05 | 27.16 | 26.96 | 27.16 | 4260320.0 |
| 2006-03-01 11:30:00 | MSFT | Stock | 27.16 | 27.18 | 27.06 | 27.1 | 3897287.0 |
| 2006-03-01 12:00:00 | MSFT | Stock | 27.09 | 27.13 | 27.03 | 27.05 | 1695562.0 |
| 2006-03-01 12:30:00 | MSFT | Stock | 27.04 | 27.06 | 27.03 | 27.05 | 1193011.0 |
| 2006-03-01 13:00:00 | MSFT | Stock | 27.06 | 27.09 | 27.03 | 27.04 | 1977416.0 |
| 2006-03-01 13:30:00 | MSFT | Stock | 27.04 | 27.08 | 27.03 | 27.07 | 2179260.0 |
| 2006-03-01 14:00:00 | MSFT | Stock | 27.07 | 27.15 | 27.05 | 27.15 | 2958729.0 |
| 2006-03-01 14:30:00 | MSFT | Stock | 27.15 | 27.2 | 27.12 | 27.16 | 4059545.0 |
| 2006-03-01 15:00:00 | MSFT | Stock | 27.16 | 27.16 | 27.08 | 27.09 | 4929747.0 |
| 2006-03-01 15:30:00 | MSFT | Stock | 27.088 | 27.14 | 27.05 | 27.13 | 6537989.0 |
| 2006-03-01 16:00:00 | MSFT | Stock | 27.14 | 27.14 | 27.06 | 27.07 | 2138826.0 |
| 2006-03-01 16:30:00 | MSFT | Stock | 27.06 | 27.14 | 27.06 | 27.1 | 22493.0 |
| 2006-03-01 17:00:00 | MSFT | Stock | 27.14 | 27.14 | 27.14 | 27.14 | 48219.0 |
| 2006-03-01 17:30:00 | MSFT | Stock | 27.09 | 27.14 | 27.09 | 27.09 | 6792.0 |
| 2006-03-01 18:00:00 | MSFT | Stock | 27.09 | 27.1 | 27.08 | 27.1 | 8200.0 |
| 2006-03-01 09:00:00 | NVDA | Stock | 0.3933 | 0.3937 | 0.3922 | 0.3934 | 877920.0 |
| 2006-03-01 09:30:00 | NVDA | Stock | 0.3942 | 0.4007 | 0.3917 | 0.4006 | 85332360.0 |
| 2006-03-01 10:00:00 | NVDA | Stock | 0.4006 | 0.4016 | 0.3972 | 0.3983 | 57635760.0 |
| 2006-03-01 10:30:00 | NVDA | Stock | 0.3985 | 0.4032 | 0.3982 | 0.402 | 48612240.0 |
| 2006-03-01 11:00:00 | NVDA | Stock | 0.4022 | 0.4052 | 0.4009 | 0.4035 | 54870120.0 |
> showing 50 of 50,026 rows — these rows as CSV