PREVIEW / stock_30min / 2014-04-11

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-04-11.parquet
  size:    1.6 MB
  rows:    82,397
  symbols: 3,546

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
2014-04-11 04:00:00	AAPL	Stock	18.6729	18.6729	18.6729	18.6729	2800.0
2014-04-11 04:30:00	AAPL	Stock	18.6889	18.6889	18.6771	18.6771	11200.0
2014-04-11 05:00:00	AAPL	Stock	18.6736	18.6736	18.6736	18.6736	2800.0
2014-04-11 05:30:00	AAPL	Stock	18.6821	18.6821	18.6821	18.6821	2800.0
2014-04-11 06:00:00	AAPL	Stock	18.695	18.695	18.695	18.695	5600.0
2014-04-11 06:30:00	AAPL	Stock	18.65	18.65	18.65	18.65	2800.0
2014-04-11 07:00:00	AAPL	Stock	18.6654	18.6654	18.5443	18.6071	89600.0
2014-04-11 07:30:00	AAPL	Stock	18.5893	18.5982	18.5264	18.5982	190540.0
2014-04-11 08:00:00	AAPL	Stock	18.6071	18.6071	18.5357	18.5646	612192.0
2014-04-11 08:30:00	AAPL	Stock	18.5679	18.575	18.5536	18.5661	307580.0
2014-04-11 09:00:00	AAPL	Stock	18.5625	18.5714	18.5321	18.5357	506604.0
2014-04-11 09:30:00	AAPL	Stock	18.5357	18.6571	18.5346	18.5679	32342716.0
2014-04-11 10:00:00	AAPL	Stock	18.5682	18.5818	18.4693	18.5386	28884828.0
2014-04-11 10:30:00	AAPL	Stock	18.5386	18.625	18.5186	18.6029	23349172.0
2014-04-11 11:00:00	AAPL	Stock	18.6025	18.6336	18.5732	18.6304	12046244.0
2014-04-11 11:30:00	AAPL	Stock	18.6325	18.6725	18.6014	18.6019	13823544.0
2014-04-11 12:00:00	AAPL	Stock	18.6043	18.6407	18.5832	18.6006	6274044.0
2014-04-11 12:30:00	AAPL	Stock	18.6014	18.6089	18.5543	18.5699	5776316.0
2014-04-11 13:00:00	AAPL	Stock	18.5754	18.5757	18.5154	18.5157	8728412.0
2014-04-11 13:30:00	AAPL	Stock	18.5154	18.62	18.4889	18.5489	13730948.0
2014-04-11 14:00:00	AAPL	Stock	18.5504	18.5864	18.5346	18.5451	7772828.0
2014-04-11 14:30:00	AAPL	Stock	18.5443	18.5664	18.51	18.5329	11852624.0
2014-04-11 15:00:00	AAPL	Stock	18.5329	18.5971	18.5229	18.5832	10164868.0
2014-04-11 15:30:00	AAPL	Stock	18.5854	18.5868	18.5511	18.5579	27486732.0
2014-04-11 16:00:00	AAPL	Stock	18.5575	18.5679	18.5429	18.5607	11397316.0
2014-04-11 16:30:00	AAPL	Stock	18.5731	18.5731	18.5461	18.5643	226464.0
2014-04-11 17:00:00	AAPL	Stock	18.5625	18.5714	18.5457	18.5671	156240.0
2014-04-11 17:30:00	AAPL	Stock	18.5657	18.5657	18.5504	18.5511	22260.0
2014-04-11 18:00:00	AAPL	Stock	18.5568	18.5625	18.5536	18.5625	86828.0
2014-04-11 18:30:00	AAPL	Stock	18.5589	18.5589	18.5589	18.5589	5600.0
2014-04-11 19:00:00	AAPL	Stock	18.5571	18.5571	18.5571	18.5571	14000.0
2014-04-11 19:30:00	AAPL	Stock	18.5579	18.5696	18.5579	18.5696	29820.0
2014-04-11 04:00:00	MSFT	Stock	39.35	39.35	39.35	39.35	100.0
2014-04-11 04:30:00	MSFT	Stock	39.35	39.35	39.35	39.35	100.0
2014-04-11 05:30:00	MSFT	Stock	39.33	39.33	39.33	39.33	100.0
2014-04-11 06:00:00	MSFT	Stock	39.33	39.33	39.33	39.33	150.0
2014-04-11 07:00:00	MSFT	Stock	39.15	39.15	39.13	39.13	400.0
2014-04-11 07:30:00	MSFT	Stock	39.13	39.13	39.09	39.09	2500.0
2014-04-11 08:00:00	MSFT	Stock	39.09	39.12	39.09	39.12	6960.0
2014-04-11 08:30:00	MSFT	Stock	39.12	39.15	39.09	39.11	8345.0
2014-04-11 09:00:00	MSFT	Stock	39.09	39.36	39.01	39.03	26713.0
2014-04-11 09:30:00	MSFT	Stock	39.0	39.64	39.0	39.61	6156562.0
2014-04-11 10:00:00	MSFT	Stock	39.6	39.635	39.175	39.59	2903168.0
2014-04-11 10:30:00	MSFT	Stock	39.59	39.79	39.5	39.65	3027729.0
2014-04-11 11:00:00	MSFT	Stock	39.65	39.75	39.44	39.52	1899006.0
2014-04-11 11:30:00	MSFT	Stock	39.53	39.53	39.26	39.4	2252776.0
2014-04-11 12:00:00	MSFT	Stock	39.4	39.51	39.36	39.4	1008224.0
2014-04-11 12:30:00	MSFT	Stock	39.41	39.55	39.38	39.47	864344.0
2014-04-11 13:00:00	MSFT	Stock	39.47	39.539	39.27	39.299	1254926.0
2014-04-11 13:30:00	MSFT	Stock	39.295	39.5	39.26	39.355	1075546.0

> showing 50 of 82,397 rows — these rows as CSV

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