PREVIEW / stock_1hour / 2014-11-18

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-11-18.parquet
  size:    1.1 MB
  rows:    49,610
  symbols: 3,579

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-11-18 04:00:00	AAPL	Stock	28.4425	28.5425	28.4425	28.5275	16000.0
2014-11-18 05:00:00	AAPL	Stock	28.5375	28.5425	28.425	28.4325	12328.0
2014-11-18 06:00:00	AAPL	Stock	28.475	28.475	28.39	28.435	38200.0
2014-11-18 07:00:00	AAPL	Stock	28.435	28.47	28.4275	28.47	103500.0
2014-11-18 08:00:00	AAPL	Stock	28.47	28.5375	28.375	28.5	430936.0
2014-11-18 09:00:00	AAPL	Stock	28.5	28.66	28.4625	28.6575	20327816.0
2014-11-18 10:00:00	AAPL	Stock	28.6575	28.67	28.58	28.605	21195944.0
2014-11-18 11:00:00	AAPL	Stock	28.6025	28.6975	28.5732	28.69	17403980.0
2014-11-18 12:00:00	AAPL	Stock	28.69	28.8075	28.69	28.8	25156236.0
2014-11-18 13:00:00	AAPL	Stock	28.8	28.875	28.7902	28.8492	16307396.0
2014-11-18 14:00:00	AAPL	Stock	28.8475	28.9225	28.7825	28.82	20290412.0
2014-11-18 15:00:00	AAPL	Stock	28.8225	28.9	28.8175	28.87	27628560.0
2014-11-18 16:00:00	AAPL	Stock	28.8675	28.8825	28.6385	28.8525	13961664.0
2014-11-18 17:00:00	AAPL	Stock	28.8525	28.8675	28.8425	28.85	756188.0
2014-11-18 18:00:00	AAPL	Stock	28.8425	28.8675	28.795	28.845	112856.0
2014-11-18 19:00:00	AAPL	Stock	28.845	28.8625	28.845	28.855	63644.0
2014-11-18 05:00:00	MSFT	Stock	49.3	49.3	49.3	49.3	100.0
2014-11-18 07:00:00	MSFT	Stock	49.35	49.35	49.2	49.26	5750.0
2014-11-18 08:00:00	MSFT	Stock	49.18	49.26	49.17	49.25	6000.0
2014-11-18 09:00:00	MSFT	Stock	49.25	49.325	48.94	49.1	2990924.0
2014-11-18 10:00:00	MSFT	Stock	49.095	49.21	48.95	48.95	4558541.0
2014-11-18 11:00:00	MSFT	Stock	48.955	49.06	48.87	48.99	2120563.0
2014-11-18 12:00:00	MSFT	Stock	48.99	49.01	48.82	48.86	2126347.0
2014-11-18 13:00:00	MSFT	Stock	48.86	48.9	48.78	48.809	1535759.0
2014-11-18 14:00:00	MSFT	Stock	48.8	48.905	48.75	48.795	1769905.0
2014-11-18 15:00:00	MSFT	Stock	48.795	48.83	48.7	48.75	4686466.0
2014-11-18 16:00:00	MSFT	Stock	48.74	49.027	48.7	48.74	2651136.0
2014-11-18 17:00:00	MSFT	Stock	48.71	48.831	48.71	48.74	162677.0
2014-11-18 18:00:00	MSFT	Stock	48.74	48.74	48.74	48.74	10052.0
2014-11-18 19:00:00	MSFT	Stock	48.74	48.77	48.74	48.77	800.0
2014-11-18 09:00:00	NVDA	Stock	0.4928	0.4972	0.4915	0.4963	12926840.0
2014-11-18 10:00:00	NVDA	Stock	0.4965	0.4995	0.4963	0.4992	26151160.0
2014-11-18 11:00:00	NVDA	Stock	0.4992	0.5015	0.4988	0.5015	22541320.0
2014-11-18 12:00:00	NVDA	Stock	0.5015	0.5032	0.501	0.503	19957920.0
2014-11-18 13:00:00	NVDA	Stock	0.503	0.5038	0.501	0.5016	13187640.0
2014-11-18 14:00:00	NVDA	Stock	0.5016	0.5045	0.5015	0.5043	33938040.0
2014-11-18 15:00:00	NVDA	Stock	0.5043	0.5055	0.503	0.5043	62751280.0
2014-11-18 16:00:00	NVDA	Stock	0.5043	0.5043	0.5006	0.502	11236200.0
2014-11-18 17:00:00	NVDA	Stock	0.5043	0.5043	0.5043	0.5043	299640.0
2014-11-18 08:00:00	AMZN	Stock	16.1525	16.1925	16.09	16.18	19000.0
2014-11-18 09:00:00	AMZN	Stock	16.1915	16.4	16.1625	16.3745	11931000.0
2014-11-18 10:00:00	AMZN	Stock	16.379	16.478	16.321	16.3765	15729340.0
2014-11-18 11:00:00	AMZN	Stock	16.3778	16.397	16.318	16.3455	7876240.0
2014-11-18 12:00:00	AMZN	Stock	16.3395	16.3685	16.2805	16.3233	5515560.0
2014-11-18 13:00:00	AMZN	Stock	16.324	16.335	16.2143	16.217	6077500.0
2014-11-18 14:00:00	AMZN	Stock	16.215	16.2845	16.2075	16.2675	6315580.0
2014-11-18 15:00:00	AMZN	Stock	16.265	16.313	16.2325	16.2505	9464320.0
2014-11-18 16:00:00	AMZN	Stock	16.2505	16.3797	16.225	16.3349	3011420.0
2014-11-18 17:00:00	AMZN	Stock	16.2065	16.2465	16.2065	16.2465	152380.0
2014-11-18 18:00:00	AMZN	Stock	16.2595	16.3165	16.2595	16.299	116060.0

> showing 50 of 49,610 rows — these rows as CSV

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