PREVIEW / stock_30min / 2009-04-24

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-04-24.parquet
  size:    1.2 MB
  rows:    67,939
  symbols: 3,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
2009-04-24 07:00:00	AAPL	Stock	4.47	4.5036	4.47	4.5004	52136.0
2009-04-24 07:30:00	AAPL	Stock	4.5007	4.5107	4.5	4.5	30800.0
2009-04-24 08:00:00	AAPL	Stock	4.5	4.5068	4.4679	4.4861	410004.0
2009-04-24 08:30:00	AAPL	Stock	4.4893	4.4896	4.4768	4.4857	443604.0
2009-04-24 09:00:00	AAPL	Stock	4.4857	4.49	4.4482	4.4539	1137668.0
2009-04-24 09:30:00	AAPL	Stock	4.4514	4.4693	4.4189	4.435	77714616.0
2009-04-24 10:00:00	AAPL	Stock	4.4364	4.4486	4.4214	4.4386	50277556.0
2009-04-24 10:30:00	AAPL	Stock	4.4379	4.4607	4.4286	4.4343	26518940.0
2009-04-24 11:00:00	AAPL	Stock	4.4339	4.4479	4.425	4.4371	22676416.0
2009-04-24 11:30:00	AAPL	Stock	4.4382	4.4557	4.4368	4.4496	21636664.0
2009-04-24 12:00:00	AAPL	Stock	4.4496	4.4511	4.4289	4.4364	22422764.0
2009-04-24 12:30:00	AAPL	Stock	4.4364	4.4536	4.4325	4.4496	24303272.0
2009-04-24 13:00:00	AAPL	Stock	4.4507	4.4636	4.4432	4.4521	21264992.0
2009-04-24 13:30:00	AAPL	Stock	4.4529	4.4529	4.4286	4.4314	21974232.0
2009-04-24 14:00:00	AAPL	Stock	4.4321	4.4532	4.4	4.4209	63462168.0
2009-04-24 14:30:00	AAPL	Stock	4.4218	4.4457	4.4086	4.4257	32627840.0
2009-04-24 15:00:00	AAPL	Stock	4.4264	4.4357	4.3918	4.4079	52197320.0
2009-04-24 15:30:00	AAPL	Stock	4.4079	4.4329	4.3946	4.4246	82336772.0
2009-04-24 16:00:00	AAPL	Stock	4.42	4.4303	4.4061	4.4182	13444592.0
2009-04-24 16:30:00	AAPL	Stock	4.4179	4.4243	4.4161	4.4204	165172.0
2009-04-24 17:00:00	AAPL	Stock	4.4239	4.4239	4.4196	4.4232	12600.0
2009-04-24 17:30:00	AAPL	Stock	4.4196	4.4196	4.4146	4.4179	29148.0
2009-04-24 18:00:00	AAPL	Stock	4.425	4.425	4.4164	4.4196	650216.0
2009-04-24 18:30:00	AAPL	Stock	4.4193	4.4229	4.4179	4.4221	57400.0
2009-04-24 19:00:00	AAPL	Stock	4.4221	4.4221	4.4214	4.4214	14840.0
2009-04-24 19:30:00	AAPL	Stock	4.4221	4.4221	4.4214	4.4214	35756.0
2009-04-24 04:30:00	MSFT	Stock	19.5	19.5	19.5	19.5	200.0
2009-04-24 05:00:00	MSFT	Stock	19.71	19.74	19.71	19.73	1200.0
2009-04-24 05:30:00	MSFT	Stock	19.65	19.65	19.65	19.65	700.0
2009-04-24 06:30:00	MSFT	Stock	19.74	19.74	19.7	19.7	2500.0
2009-04-24 07:00:00	MSFT	Stock	19.69	19.83	19.69	19.75	24165.0
2009-04-24 07:30:00	MSFT	Stock	19.75	19.8	19.7	19.76	26346.0
2009-04-24 08:00:00	MSFT	Stock	19.76	19.99	19.7	19.75	336789.0
2009-04-24 08:30:00	MSFT	Stock	19.76	19.83	19.67	19.74	356646.0
2009-04-24 09:00:00	MSFT	Stock	19.75	19.91	19.75	19.8	944036.0
2009-04-24 09:30:00	MSFT	Stock	19.8	20.38	19.5	20.29	26925247.0
2009-04-24 10:00:00	MSFT	Stock	20.29	20.45	20.1	20.232	17730710.0
2009-04-24 10:30:00	MSFT	Stock	20.24	20.37	20.16	20.32	11218407.0
2009-04-24 11:00:00	MSFT	Stock	20.32	20.39	20.23	20.39	7402850.0
2009-04-24 11:30:00	MSFT	Stock	20.39	20.55	20.37	20.501	8320935.0
2009-04-24 12:00:00	MSFT	Stock	20.51	20.56	20.4	20.501	6426747.0
2009-04-24 12:30:00	MSFT	Stock	20.51	20.55	20.42	20.53	5754521.0
2009-04-24 13:00:00	MSFT	Stock	20.53	20.62	20.5	20.56	6116665.0
2009-04-24 13:30:00	MSFT	Stock	20.56	20.57	20.44	20.462	8004025.0
2009-04-24 14:00:00	MSFT	Stock	20.46	20.57	20.34	20.56	7677296.0
2009-04-24 14:30:00	MSFT	Stock	20.57	20.89	20.55	20.88	12020633.0
2009-04-24 15:00:00	MSFT	Stock	20.89	21.2	20.84	21.0	17692617.0
2009-04-24 15:30:00	MSFT	Stock	21.001	21.04	20.63	20.89	22719894.0
2009-04-24 16:00:00	MSFT	Stock	20.92	20.96	20.478	20.92	2987168.0
2009-04-24 16:30:00	MSFT	Stock	20.92	20.95	20.87	20.9	26696.0

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

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