PREVIEW / stock_1hour / 2014-02-14

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-02-14.parquet
  size:    1.0 MB
  rows:    47,649
  symbols: 3,536

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-02-14 04:00:00	AAPL	Stock	19.4432	19.4461	19.4432	19.4461	5600.0
2014-02-14 06:00:00	AAPL	Stock	19.45	19.4821	19.45	19.4821	25200.0
2014-02-14 07:00:00	AAPL	Stock	19.4857	19.5364	19.4732	19.4839	350728.0
2014-02-14 08:00:00	AAPL	Stock	19.4793	19.5493	19.4664	19.4668	1064364.0
2014-02-14 09:00:00	AAPL	Stock	19.4679	19.4993	19.3589	19.4268	53204116.0
2014-02-14 10:00:00	AAPL	Stock	19.4311	19.4586	19.3289	19.3582	43872920.0
2014-02-14 11:00:00	AAPL	Stock	19.3571	19.4614	19.3496	19.4429	27758108.0
2014-02-14 12:00:00	AAPL	Stock	19.4411	19.445	19.3571	19.3693	20694072.0
2014-02-14 13:00:00	AAPL	Stock	19.3686	19.4286	19.3661	19.4071	16318260.0
2014-02-14 14:00:00	AAPL	Stock	19.4064	19.4561	19.4061	19.4286	18049164.0
2014-02-14 15:00:00	AAPL	Stock	19.4293	19.4318	19.3786	19.4243	40513172.0
2014-02-14 16:00:00	AAPL	Stock	19.4282	19.4536	19.409	19.4536	9071272.0
2014-02-14 17:00:00	AAPL	Stock	19.4536	19.4571	19.4282	19.4393	165676.0
2014-02-14 18:00:00	AAPL	Stock	19.4386	19.4454	19.4354	19.4446	53480.0
2014-02-14 19:00:00	AAPL	Stock	19.4375	19.4446	19.4286	19.4446	105224.0
2014-02-14 07:00:00	MSFT	Stock	37.54	37.54	37.54	37.54	508.0
2014-02-14 08:00:00	MSFT	Stock	37.53	37.57	37.52	37.57	2530.0
2014-02-14 09:00:00	MSFT	Stock	37.62	37.62	37.33	37.45	5212039.0
2014-02-14 10:00:00	MSFT	Stock	37.45	37.64	37.41	37.46	4596228.0
2014-02-14 11:00:00	MSFT	Stock	37.46	37.68	37.45	37.635	2785179.0
2014-02-14 12:00:00	MSFT	Stock	37.64	37.68	37.58	37.655	2837519.0
2014-02-14 13:00:00	MSFT	Stock	37.65	37.68	37.58	37.65	2588821.0
2014-02-14 14:00:00	MSFT	Stock	37.66	37.78	37.65	37.775	2418021.0
2014-02-14 15:00:00	MSFT	Stock	37.77	37.78	37.58	37.61	5139744.0
2014-02-14 16:00:00	MSFT	Stock	37.62	37.683	37.554	37.59	3223898.0
2014-02-14 17:00:00	MSFT	Stock	37.676	37.676	37.676	37.676	560.0
2014-02-14 18:00:00	MSFT	Stock	37.62	37.65	37.62	37.65	1000.0
2014-02-14 19:00:00	MSFT	Stock	37.64	37.64	37.64	37.64	240.0
2014-02-14 08:00:00	NVDA	Stock	0.436	0.4378	0.4338	0.434	632000.0
2014-02-14 09:00:00	NVDA	Stock	0.4335	0.4405	0.428	0.4356	123204200.0
2014-02-14 10:00:00	NVDA	Stock	0.4358	0.4438	0.4356	0.4404	123333920.0
2014-02-14 11:00:00	NVDA	Stock	0.4405	0.4462	0.4402	0.4458	72761520.0
2014-02-14 12:00:00	NVDA	Stock	0.4458	0.4461	0.443	0.4458	61973760.0
2014-02-14 13:00:00	NVDA	Stock	0.4459	0.4462	0.4445	0.4458	51711000.0
2014-02-14 14:00:00	NVDA	Stock	0.4458	0.4475	0.4455	0.4472	59129040.0
2014-02-14 15:00:00	NVDA	Stock	0.4472	0.4488	0.4455	0.4479	152956840.0
2014-02-14 16:00:00	NVDA	Stock	0.4478	0.4479	0.4346	0.4478	144193560.0
2014-02-14 17:00:00	NVDA	Stock	0.447	0.4475	0.447	0.4475	44000.0
2014-02-14 18:00:00	NVDA	Stock	0.4475	0.4475	0.4475	0.4475	4000.0
2014-02-14 07:00:00	AMZN	Stock	17.895	17.895	17.895	17.895	2000.0
2014-02-14 08:00:00	AMZN	Stock	17.9075	17.975	17.9075	17.9505	116380.0
2014-02-14 09:00:00	AMZN	Stock	17.944	17.99	17.7134	17.7415	10514660.0
2014-02-14 10:00:00	AMZN	Stock	17.7415	17.8	17.6705	17.7378	9835140.0
2014-02-14 11:00:00	AMZN	Stock	17.724	17.854	17.6675	17.785	10116080.0
2014-02-14 12:00:00	AMZN	Stock	17.7905	17.9175	17.7785	17.8515	7380700.0
2014-02-14 13:00:00	AMZN	Stock	17.8515	17.8645	17.795	17.8447	6030160.0
2014-02-14 14:00:00	AMZN	Stock	17.8465	17.944	17.8265	17.932	7213880.0
2014-02-14 15:00:00	AMZN	Stock	17.9308	17.9355	17.796	17.85	11905520.0
2014-02-14 16:00:00	AMZN	Stock	17.8675	17.8711	17.8121	17.8675	230780.0
2014-02-14 17:00:00	AMZN	Stock	17.821	17.8385	17.8175	17.8385	31640.0

> showing 50 of 47,649 rows — these rows as CSV

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