PREVIEW / stock_5min / 2013-06-18

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-06-18.parquet
  size:    5.1 MB
  rows:    345,438
  symbols: 3,515

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
2013-06-18 06:25:00	AAPL	Stock	15.4746	15.4746	15.4746	15.4746	2800.0
2013-06-18 07:15:00	AAPL	Stock	15.4768	15.4768	15.4768	15.4768	14700.0
2013-06-18 07:30:00	AAPL	Stock	15.4643	15.4643	15.4643	15.4643	8400.0
2013-06-18 07:35:00	AAPL	Stock	15.4639	15.4643	15.4318	15.4318	11200.0
2013-06-18 07:45:00	AAPL	Stock	15.4604	15.4604	15.4604	15.4604	2800.0
2013-06-18 07:50:00	AAPL	Stock	15.4468	15.4468	15.4468	15.4468	2912.0
2013-06-18 08:00:00	AAPL	Stock	15.4671	15.4671	15.4157	15.4157	68432.0
2013-06-18 08:05:00	AAPL	Stock	15.4157	15.4504	15.4107	15.4289	72240.0
2013-06-18 08:10:00	AAPL	Stock	15.4389	15.4389	15.4389	15.4389	2800.0
2013-06-18 08:15:00	AAPL	Stock	15.4361	15.4364	15.4357	15.4357	8400.0
2013-06-18 08:20:00	AAPL	Stock	15.4368	15.4411	15.4364	15.4364	18676.0
2013-06-18 08:25:00	AAPL	Stock	15.4411	15.4446	15.4411	15.4446	5600.0
2013-06-18 08:30:00	AAPL	Stock	15.4411	15.4411	15.4304	15.4354	115640.0
2013-06-18 08:35:00	AAPL	Stock	15.4357	15.4357	15.4286	15.4286	61600.0
2013-06-18 08:40:00	AAPL	Stock	15.425	15.4425	15.4246	15.4332	290360.0
2013-06-18 08:45:00	AAPL	Stock	15.4314	15.4314	15.4214	15.4214	8400.0
2013-06-18 08:55:00	AAPL	Stock	15.4368	15.4375	15.4214	15.4214	61600.0
2013-06-18 09:00:00	AAPL	Stock	15.4279	15.4289	15.4271	15.4282	33600.0
2013-06-18 09:05:00	AAPL	Stock	15.4282	15.4436	15.4282	15.4429	44184.0
2013-06-18 09:10:00	AAPL	Stock	15.4368	15.4421	15.4368	15.4421	8400.0
2013-06-18 09:20:00	AAPL	Stock	15.4421	15.4421	15.4418	15.4418	8400.0
2013-06-18 09:25:00	AAPL	Stock	15.4411	15.4411	15.4043	15.4043	141232.0
2013-06-18 09:30:00	AAPL	Stock	15.4039	15.4425	15.3646	15.4321	10729992.0
2013-06-18 09:35:00	AAPL	Stock	15.4332	15.4571	15.3993	15.441	7009548.0
2013-06-18 09:40:00	AAPL	Stock	15.4429	15.445	15.3971	15.4189	5849872.0
2013-06-18 09:45:00	AAPL	Stock	15.4136	15.4761	15.4129	15.4697	5593392.0
2013-06-18 09:50:00	AAPL	Stock	15.4732	15.475	15.4354	15.4379	4004868.0
2013-06-18 09:55:00	AAPL	Stock	15.4386	15.4589	15.4289	15.4511	2149532.0
2013-06-18 10:00:00	AAPL	Stock	15.4489	15.4596	15.4293	15.4431	2136848.0
2013-06-18 10:05:00	AAPL	Stock	15.4429	15.4618	15.4304	15.4446	4130532.0
2013-06-18 10:10:00	AAPL	Stock	15.445	15.4543	15.4304	15.4457	2627352.0
2013-06-18 10:15:00	AAPL	Stock	15.4454	15.4714	15.4429	15.4593	2530668.0
2013-06-18 10:20:00	AAPL	Stock	15.4625	15.4907	15.4574	15.4832	3558632.0
2013-06-18 10:25:00	AAPL	Stock	15.4832	15.5124	15.4754	15.5054	4447044.0
2013-06-18 10:30:00	AAPL	Stock	15.5079	15.5321	15.5079	15.5154	4431056.0
2013-06-18 10:35:00	AAPL	Stock	15.5161	15.5278	15.5075	15.5075	3149804.0
2013-06-18 10:40:00	AAPL	Stock	15.5075	15.5236	15.4904	15.4993	3173828.0
2013-06-18 10:45:00	AAPL	Stock	15.5036	15.5175	15.4948	15.5071	2291044.0
2013-06-18 10:50:00	AAPL	Stock	15.5062	15.5232	15.5039	15.5193	2479428.0
2013-06-18 10:55:00	AAPL	Stock	15.5199	15.5232	15.4893	15.4946	2325148.0
2013-06-18 11:00:00	AAPL	Stock	15.4946	15.5082	15.4911	15.5039	3213700.0
2013-06-18 11:05:00	AAPL	Stock	15.5039	15.5064	15.4804	15.4953	2326100.0
2013-06-18 11:10:00	AAPL	Stock	15.495	15.5029	15.4864	15.5029	2786336.0
2013-06-18 11:15:00	AAPL	Stock	15.5021	15.5132	15.4982	15.5007	2454060.0
2013-06-18 11:20:00	AAPL	Stock	15.5011	15.5039	15.4921	15.4957	815724.0
2013-06-18 11:25:00	AAPL	Stock	15.4964	15.5089	15.489	15.5089	1687896.0
2013-06-18 11:30:00	AAPL	Stock	15.5089	15.5229	15.5004	15.5204	2698192.0
2013-06-18 11:35:00	AAPL	Stock	15.52	15.52	15.5018	15.5064	1567328.0
2013-06-18 11:40:00	AAPL	Stock	15.5064	15.5064	15.4789	15.4968	2126880.0
2013-06-18 11:45:00	AAPL	Stock	15.4946	15.4989	15.4679	15.475	1368948.0

> showing 50 of 345,438 rows — these rows as CSV

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