PREVIEW / stock_5min / 2011-04-18

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-04-18.parquet
  size:    4.9 MB
  rows:    327,457
  symbols: 3,532

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
2011-04-18 04:15:00	AAPL	Stock	11.7143	11.7143	11.7143	11.7143	2800.0
2011-04-18 04:25:00	AAPL	Stock	11.7082	11.7082	11.7082	11.7082	2800.0
2011-04-18 04:35:00	AAPL	Stock	11.6964	11.6964	11.6964	11.6964	5600.0
2011-04-18 06:00:00	AAPL	Stock	11.6964	11.6964	11.6964	11.6964	5600.0
2011-04-18 06:35:00	AAPL	Stock	11.6625	11.6625	11.6625	11.6625	2800.0
2011-04-18 06:40:00	AAPL	Stock	11.6521	11.6521	11.6521	11.6521	5600.0
2011-04-18 07:00:00	AAPL	Stock	11.6796	11.695	11.6796	11.6929	11200.0
2011-04-18 07:05:00	AAPL	Stock	11.6925	11.6925	11.6925	11.6925	7000.0
2011-04-18 07:10:00	AAPL	Stock	11.6875	11.6875	11.6875	11.6875	5600.0
2011-04-18 07:15:00	AAPL	Stock	11.6875	11.7143	11.6875	11.6964	46340.0
2011-04-18 07:20:00	AAPL	Stock	11.6964	11.7143	11.6964	11.7143	19880.0
2011-04-18 07:30:00	AAPL	Stock	11.7143	11.7386	11.7143	11.7196	157304.0
2011-04-18 07:35:00	AAPL	Stock	11.7196	11.7421	11.7196	11.7421	22400.0
2011-04-18 07:40:00	AAPL	Stock	11.7354	11.7354	11.735	11.735	5600.0
2011-04-18 07:45:00	AAPL	Stock	11.72	11.7214	11.72	11.7214	5600.0
2011-04-18 07:50:00	AAPL	Stock	11.7268	11.73	11.7268	11.73	11200.0
2011-04-18 07:55:00	AAPL	Stock	11.7268	11.7268	11.7268	11.7268	7000.0
2011-04-18 08:00:00	AAPL	Stock	11.725	11.7354	11.7179	11.7354	163212.0
2011-04-18 08:05:00	AAPL	Stock	11.7396	11.7579	11.7396	11.7496	187376.0
2011-04-18 08:10:00	AAPL	Stock	11.7496	11.75	11.735	11.7429	90244.0
2011-04-18 08:15:00	AAPL	Stock	11.7425	11.7429	11.7321	11.7411	77140.0
2011-04-18 08:20:00	AAPL	Stock	11.7411	11.755	11.7411	11.75	190540.0
2011-04-18 08:25:00	AAPL	Stock	11.75	11.7611	11.75	11.7604	110040.0
2011-04-18 08:30:00	AAPL	Stock	11.7607	11.7675	11.7554	11.7554	139888.0
2011-04-18 08:35:00	AAPL	Stock	11.7543	11.7543	11.7439	11.7439	52192.0
2011-04-18 08:40:00	AAPL	Stock	11.7446	11.7482	11.7429	11.7429	58548.0
2011-04-18 08:45:00	AAPL	Stock	11.7464	11.7511	11.7429	11.7432	110376.0
2011-04-18 08:50:00	AAPL	Stock	11.7393	11.7486	11.7375	11.7482	74648.0
2011-04-18 08:55:00	AAPL	Stock	11.7489	11.75	11.7375	11.7375	266000.0
2011-04-18 09:00:00	AAPL	Stock	11.7379	11.7429	11.7107	11.7107	680708.0
2011-04-18 09:05:00	AAPL	Stock	11.7071	11.7229	11.6468	11.6468	1108604.0
2011-04-18 09:10:00	AAPL	Stock	11.6486	11.6532	11.6286	11.6357	1487612.0
2011-04-18 09:15:00	AAPL	Stock	11.6393	11.6511	11.6154	11.6429	1596056.0
2011-04-18 09:20:00	AAPL	Stock	11.6429	11.6582	11.6339	11.6464	921928.0
2011-04-18 09:25:00	AAPL	Stock	11.6443	11.6539	11.6339	11.6468	940520.0
2011-04-18 09:30:00	AAPL	Stock	11.6482	11.7193	11.6135	11.6172	28805336.0
2011-04-18 09:35:00	AAPL	Stock	11.6182	11.6661	11.6161	11.6536	16631664.0
2011-04-18 09:40:00	AAPL	Stock	11.6532	11.6743	11.4432	11.4871	35679812.0
2011-04-18 09:45:00	AAPL	Stock	11.4875	11.5379	11.4475	11.5136	34052984.0
2011-04-18 09:50:00	AAPL	Stock	11.5146	11.5429	11.4814	11.5225	18028472.0
2011-04-18 09:55:00	AAPL	Stock	11.5214	11.5275	11.4668	11.4929	13123320.0
2011-04-18 10:00:00	AAPL	Stock	11.4907	11.5	11.4536	11.4967	15769628.0
2011-04-18 10:05:00	AAPL	Stock	11.4979	11.5029	11.4393	11.4668	14288036.0
2011-04-18 10:10:00	AAPL	Stock	11.4675	11.4982	11.4525	11.4914	10886932.0
2011-04-18 10:15:00	AAPL	Stock	11.4925	11.5018	11.4343	11.4896	15926400.0
2011-04-18 10:20:00	AAPL	Stock	11.4879	11.5143	11.4779	11.4993	12499984.0
2011-04-18 10:25:00	AAPL	Stock	11.4975	11.5	11.4643	11.4764	8022392.0
2011-04-18 10:30:00	AAPL	Stock	11.4773	11.5136	11.4696	11.4954	9870644.0
2011-04-18 10:35:00	AAPL	Stock	11.4946	11.5124	11.4786	11.4851	5948740.0
2011-04-18 10:40:00	AAPL	Stock	11.4821	11.4846	11.4482	11.4658	7624568.0

> showing 50 of 327,457 rows — these rows as CSV

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