PREVIEW / stock_1hour / 2006-08-30

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-08-30.parquet
  size:    605 KB
  rows:    29,418
  symbols: 2,337

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-08-30 07:00:00	AAPL	Stock	2.3918	2.3918	2.3918	2.3918	2800.0
2006-08-30 08:00:00	AAPL	Stock	2.3918	2.4	2.3886	2.3964	3006556.0
2006-08-30 09:00:00	AAPL	Stock	2.3957	2.4221	2.3943	2.4075	128768052.0
2006-08-30 10:00:00	AAPL	Stock	2.4079	2.4175	2.3996	2.4032	131914608.0
2006-08-30 11:00:00	AAPL	Stock	2.4032	2.4141	2.3814	2.3896	119849744.0
2006-08-30 12:00:00	AAPL	Stock	2.3896	2.41	2.3871	2.4014	63369516.0
2006-08-30 13:00:00	AAPL	Stock	2.4018	2.4029	2.3964	2.3979	38390268.0
2006-08-30 14:00:00	AAPL	Stock	2.3979	2.4007	2.3921	2.3968	53747260.0
2006-08-30 15:00:00	AAPL	Stock	2.3971	2.4032	2.3868	2.3896	113442308.0
2006-08-30 16:00:00	AAPL	Stock	2.39	2.4039	2.3889	2.3914	1687504.0
2006-08-30 17:00:00	AAPL	Stock	2.3914	2.3914	2.3875	2.3889	186760.0
2006-08-30 18:00:00	AAPL	Stock	2.3882	2.3882	2.3875	2.3875	126000.0
2006-08-30 07:00:00	MSFT	Stock	25.89	25.89	25.84	25.84	1740.0
2006-08-30 08:00:00	MSFT	Stock	25.85	25.92	25.81	25.89	22725.0
2006-08-30 09:00:00	MSFT	Stock	25.89	25.89	25.64	25.7	4263946.0
2006-08-30 10:00:00	MSFT	Stock	25.7	25.84	25.7	25.759	5569817.0
2006-08-30 11:00:00	MSFT	Stock	25.76	25.8	25.74	25.75	3011633.0
2006-08-30 12:00:00	MSFT	Stock	25.75	25.85	25.73	25.84	3289638.0
2006-08-30 13:00:00	MSFT	Stock	25.84	25.89	25.8	25.87	2721290.0
2006-08-30 14:00:00	MSFT	Stock	25.87	25.87	25.76	25.76	2950468.0
2006-08-30 15:00:00	MSFT	Stock	25.77	25.87	25.74	25.81	5769867.0
2006-08-30 16:00:00	MSFT	Stock	25.81	25.85	25.69	25.78	1561736.0
2006-08-30 17:00:00	MSFT	Stock	25.8	25.8	25.779	25.8	4482.0
2006-08-30 18:00:00	MSFT	Stock	25.79	25.8	25.79	25.8	200.0
2006-08-30 08:00:00	NVDA	Stock	0.4782	0.479	0.4768	0.4777	291000.0
2006-08-30 09:00:00	NVDA	Stock	0.478	0.4833	0.478	0.4808	80805060.0
2006-08-30 10:00:00	NVDA	Stock	0.4808	0.4878	0.4805	0.4858	123445620.0
2006-08-30 11:00:00	NVDA	Stock	0.4858	0.4868	0.481	0.483	81010560.0
2006-08-30 12:00:00	NVDA	Stock	0.483	0.4853	0.4813	0.485	73890840.0
2006-08-30 13:00:00	NVDA	Stock	0.4852	0.4882	0.4828	0.4873	64061100.0
2006-08-30 14:00:00	NVDA	Stock	0.4873	0.4882	0.4853	0.4877	72832500.0
2006-08-30 15:00:00	NVDA	Stock	0.4875	0.492	0.4867	0.4872	149469300.0
2006-08-30 16:00:00	NVDA	Stock	0.4872	0.4873	0.4805	0.4862	1571280.0
2006-08-30 17:00:00	NVDA	Stock	0.4852	0.4872	0.485	0.485	8778000.0
2006-08-30 08:00:00	AMZN	Stock	1.4785	1.4785	1.4785	1.4785	6000.0
2006-08-30 09:00:00	AMZN	Stock	1.4825	1.492	1.474	1.4845	20766340.0
2006-08-30 10:00:00	AMZN	Stock	1.485	1.52	1.4845	1.5115	40881180.0
2006-08-30 11:00:00	AMZN	Stock	1.511	1.5185	1.506	1.507	24252120.0
2006-08-30 12:00:00	AMZN	Stock	1.5075	1.517	1.507	1.516	24536540.0
2006-08-30 13:00:00	AMZN	Stock	1.516	1.527	1.515	1.5205	19071600.0
2006-08-30 14:00:00	AMZN	Stock	1.52	1.533	1.52	1.532	23911680.0
2006-08-30 15:00:00	AMZN	Stock	1.5325	1.5425	1.5308	1.535	39990380.0
2006-08-30 16:00:00	AMZN	Stock	1.537	1.538	1.482	1.538	437040.0
2006-08-30 17:00:00	AMZN	Stock	1.5345	1.5345	1.5345	1.5345	2000.0
2006-08-30 18:00:00	AMZN	Stock	1.5365	1.54	1.5365	1.54	60000.0
2006-08-30 09:00:00	CL	Stock	29.65	29.795	29.56	29.675	370600.0
2006-08-30 10:00:00	CL	Stock	29.66	29.9	29.61	29.78	390200.0
2006-08-30 11:00:00	CL	Stock	29.77	29.83	29.59	29.67	317000.0
2006-08-30 12:00:00	CL	Stock	29.655	29.845	29.635	29.84	256400.0
2006-08-30 13:00:00	CL	Stock	29.83	29.86	29.77	29.775	213200.0

> showing 50 of 29,418 rows — these rows as CSV

> unlock the full archive -- $79 one-time