PREVIEW / stock_30min / 2007-11-29

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-11-29.parquet
  size:    1.2 MB
  rows:    67,334
  symbols: 3,200

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-11-29 04:30:00	AAPL	Stock	6.4625	6.4643	6.4461	6.4461	11200.0
2007-11-29 05:00:00	AAPL	Stock	6.4339	6.4339	6.4304	6.4304	14000.0
2007-11-29 06:00:00	AAPL	Stock	6.4304	6.4304	6.4218	6.4218	11200.0
2007-11-29 07:00:00	AAPL	Stock	6.4271	6.4271	6.4025	6.4107	53620.0
2007-11-29 07:30:00	AAPL	Stock	6.4114	6.4539	6.4107	6.4539	356916.0
2007-11-29 08:00:00	AAPL	Stock	6.45	6.45	6.4171	6.4232	2958928.0
2007-11-29 08:30:00	AAPL	Stock	6.4225	6.4446	6.3868	6.4125	7222656.0
2007-11-29 09:00:00	AAPL	Stock	6.4125	6.4186	6.3982	6.4082	1132852.0
2007-11-29 09:30:00	AAPL	Stock	6.4111	6.4625	6.3982	6.4189	139119904.0
2007-11-29 10:00:00	AAPL	Stock	6.4182	6.4396	6.4071	6.4386	81550644.0
2007-11-29 10:30:00	AAPL	Stock	6.4386	6.5029	6.4286	6.4964	89886328.0
2007-11-29 11:00:00	AAPL	Stock	6.4964	6.5893	6.495	6.5782	137891180.0
2007-11-29 11:30:00	AAPL	Stock	6.5771	6.5996	6.5607	6.5721	86074688.0
2007-11-29 12:00:00	AAPL	Stock	6.5721	6.5735	6.5375	6.5625	55761020.0
2007-11-29 12:30:00	AAPL	Stock	6.5621	6.5757	6.5268	6.5425	47361832.0
2007-11-29 13:00:00	AAPL	Stock	6.5429	6.5536	6.5061	6.5193	52413172.0
2007-11-29 13:30:00	AAPL	Stock	6.5196	6.5518	6.5036	6.5423	46001564.0
2007-11-29 14:00:00	AAPL	Stock	6.5418	6.5698	6.5364	6.566	48245680.0
2007-11-29 14:30:00	AAPL	Stock	6.5661	6.5886	6.5525	6.5886	49272860.0
2007-11-29 15:00:00	AAPL	Stock	6.5882	6.6132	6.5614	6.5707	93052680.0
2007-11-29 15:30:00	AAPL	Stock	6.5696	6.5857	6.5393	6.5832	93126796.0
2007-11-29 16:00:00	AAPL	Stock	6.5804	6.5964	6.4364	6.5857	12121872.0
2007-11-29 16:30:00	AAPL	Stock	6.5821	6.5875	6.4165	6.5657	2414076.0
2007-11-29 17:00:00	AAPL	Stock	6.5614	6.5661	6.5514	6.5575	640136.0
2007-11-29 17:30:00	AAPL	Stock	6.51	6.5621	6.51	6.5532	823228.0
2007-11-29 18:00:00	AAPL	Stock	6.5536	6.5686	6.5464	6.55	563892.0
2007-11-29 18:30:00	AAPL	Stock	6.5532	6.5679	6.5482	6.5564	412860.0
2007-11-29 19:00:00	AAPL	Stock	6.5536	6.5804	6.5536	6.5714	1058064.0
2007-11-29 19:30:00	AAPL	Stock	6.5746	6.6293	6.5746	6.6293	1593648.0
2007-11-29 07:00:00	MSFT	Stock	33.61	33.61	33.61	33.61	100.0
2007-11-29 08:00:00	MSFT	Stock	33.58	33.61	33.34	33.35	31697.0
2007-11-29 08:30:00	MSFT	Stock	33.48	33.55	33.45	33.5	390104.0
2007-11-29 09:00:00	MSFT	Stock	33.47	33.58	33.46	33.58	56922.0
2007-11-29 09:30:00	MSFT	Stock	33.51	33.93	33.5	33.71	6322860.0
2007-11-29 10:00:00	MSFT	Stock	33.71	33.78	33.44	33.74	4841263.0
2007-11-29 10:30:00	MSFT	Stock	33.74	33.77	33.6	33.71	3693326.0
2007-11-29 11:00:00	MSFT	Stock	33.7	33.84	33.63	33.76	2990304.0
2007-11-29 11:30:00	MSFT	Stock	33.75	33.81	33.67	33.67	3168767.0
2007-11-29 12:00:00	MSFT	Stock	33.67	33.72	33.66	33.68	2240991.0
2007-11-29 12:30:00	MSFT	Stock	33.68	33.7	33.62	33.63	2509130.0
2007-11-29 13:00:00	MSFT	Stock	33.64	33.69	33.48	33.5	3448078.0
2007-11-29 13:30:00	MSFT	Stock	33.51	33.57	33.31	33.51	3766368.0
2007-11-29 14:00:00	MSFT	Stock	33.51	33.64	33.49	33.56	3213698.0
2007-11-29 14:30:00	MSFT	Stock	33.56	33.57	33.46	33.56	2932317.0
2007-11-29 15:00:00	MSFT	Stock	33.57	33.65	33.44	33.52	4728418.0
2007-11-29 15:30:00	MSFT	Stock	33.51	33.61	33.42	33.59	6446469.0
2007-11-29 16:00:00	MSFT	Stock	33.57	33.7	33.3	33.59	2637742.0
2007-11-29 16:30:00	MSFT	Stock	33.59	33.59	33.38	33.59	86775.0
2007-11-29 17:00:00	MSFT	Stock	33.59	33.59	33.41	33.44	92460.0
2007-11-29 17:30:00	MSFT	Stock	33.668	33.668	33.41	33.42	11046.0

> showing 50 of 67,334 rows — these rows as CSV

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