PREVIEW / stock_5min / 2012-06-18

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-06-18.parquet
  size:    4.8 MB
  rows:    329,663
  symbols: 3,518

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
2012-06-18 04:05:00	AAPL	Stock	20.5414	20.5414	20.5182	20.5182	44800.0
2012-06-18 04:10:00	AAPL	Stock	20.5404	20.5404	20.5125	20.5125	29820.0
2012-06-18 04:20:00	AAPL	Stock	20.5271	20.5271	20.5086	20.5086	14000.0
2012-06-18 04:25:00	AAPL	Stock	20.5	20.5	20.4893	20.4893	5600.0
2012-06-18 06:45:00	AAPL	Stock	20.4886	20.4886	20.4864	20.4864	25200.0
2012-06-18 07:00:00	AAPL	Stock	20.5	20.5	20.4821	20.4821	19180.0
2012-06-18 07:05:00	AAPL	Stock	20.4964	20.5	20.4964	20.5	37520.0
2012-06-18 07:10:00	AAPL	Stock	20.4911	20.4929	20.4911	20.4929	6636.0
2012-06-18 07:15:00	AAPL	Stock	20.4664	20.4664	20.4571	20.4636	33600.0
2012-06-18 07:20:00	AAPL	Stock	20.4871	20.4911	20.4654	20.4654	34300.0
2012-06-18 07:25:00	AAPL	Stock	20.4643	20.465	20.4596	20.465	8400.0
2012-06-18 07:35:00	AAPL	Stock	20.4646	20.4646	20.4571	20.4646	25200.0
2012-06-18 07:40:00	AAPL	Stock	20.475	20.475	20.4646	20.4729	14000.0
2012-06-18 07:45:00	AAPL	Stock	20.4646	20.4646	20.4639	20.4639	9800.0
2012-06-18 07:50:00	AAPL	Stock	20.4479	20.4496	20.4404	20.4468	24360.0
2012-06-18 07:55:00	AAPL	Stock	20.4382	20.4514	20.4382	20.4514	29988.0
2012-06-18 08:00:00	AAPL	Stock	20.4557	20.4643	20.4425	20.4586	98224.0
2012-06-18 08:05:00	AAPL	Stock	20.4525	20.4646	20.4525	20.4646	95816.0
2012-06-18 08:10:00	AAPL	Stock	20.4646	20.4671	20.4646	20.4661	14000.0
2012-06-18 08:15:00	AAPL	Stock	20.4714	20.4721	20.4554	20.4554	62048.0
2012-06-18 08:20:00	AAPL	Stock	20.4607	20.4607	20.4482	20.45	17892.0
2012-06-18 08:25:00	AAPL	Stock	20.4518	20.4589	20.4425	20.4521	50400.0
2012-06-18 08:30:00	AAPL	Stock	20.4521	20.4521	20.4425	20.4464	49224.0
2012-06-18 08:35:00	AAPL	Stock	20.4461	20.4461	20.4221	20.425	451248.0
2012-06-18 08:40:00	AAPL	Stock	20.4214	20.425	20.4021	20.4086	211064.0
2012-06-18 08:45:00	AAPL	Stock	20.4021	20.4025	20.3789	20.3857	154000.0
2012-06-18 08:50:00	AAPL	Stock	20.3882	20.4107	20.3868	20.4107	231280.0
2012-06-18 08:55:00	AAPL	Stock	20.41	20.5046	20.4029	20.4275	331912.0
2012-06-18 09:00:00	AAPL	Stock	20.4239	20.4243	20.3929	20.4107	487788.0
2012-06-18 09:05:00	AAPL	Stock	20.4093	20.4107	20.4068	20.4107	42000.0
2012-06-18 09:10:00	AAPL	Stock	20.4107	20.4107	20.3961	20.3964	133224.0
2012-06-18 09:15:00	AAPL	Stock	20.3975	20.4107	20.3964	20.405	102424.0
2012-06-18 09:20:00	AAPL	Stock	20.4107	20.4114	20.3936	20.3996	368032.0
2012-06-18 09:25:00	AAPL	Stock	20.3943	20.41	20.3871	20.3882	489020.0
2012-06-18 09:30:00	AAPL	Stock	20.3914	20.4979	20.3704	20.4475	11640776.0
2012-06-18 09:35:00	AAPL	Stock	20.4553	20.6071	20.4489	20.585	12695368.0
2012-06-18 09:40:00	AAPL	Stock	20.5847	20.6924	20.5711	20.6718	17180772.0
2012-06-18 09:45:00	AAPL	Stock	20.6689	20.6718	20.5811	20.5811	10010308.0
2012-06-18 09:50:00	AAPL	Stock	20.5832	20.6311	20.5579	20.6207	9688140.0
2012-06-18 09:55:00	AAPL	Stock	20.6207	20.6286	20.5765	20.6118	5953836.0
2012-06-18 10:00:00	AAPL	Stock	20.6196	20.6639	20.5968	20.6586	7410900.0
2012-06-18 10:05:00	AAPL	Stock	20.6575	20.7036	20.6555	20.6971	8642256.0
2012-06-18 10:10:00	AAPL	Stock	20.6929	20.7254	20.6611	20.7082	10261608.0
2012-06-18 10:15:00	AAPL	Stock	20.7064	20.7829	20.6825	20.7817	8308776.0
2012-06-18 10:20:00	AAPL	Stock	20.7806	20.8106	20.7675	20.7904	10076388.0
2012-06-18 10:25:00	AAPL	Stock	20.7949	20.8525	20.7782	20.8396	11233572.0
2012-06-18 10:30:00	AAPL	Stock	20.8364	20.8429	20.795	20.7996	6072332.0
2012-06-18 10:35:00	AAPL	Stock	20.7957	20.8036	20.7679	20.7826	6784848.0
2012-06-18 10:40:00	AAPL	Stock	20.7807	20.825	20.7704	20.8214	5578524.0
2012-06-18 10:45:00	AAPL	Stock	20.8214	20.8339	20.8054	20.8293	6387052.0

> showing 50 of 329,663 rows — these rows as CSV

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