PREVIEW / stock_1hour / 2016-06-29

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-06-29.parquet
  size:    1.0 MB
  rows:    49,029
  symbols: 3,297

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
2016-06-29 04:00:00	AAPL	Stock	23.45	23.46	23.45	23.46	4800.0
2016-06-29 05:00:00	AAPL	Stock	23.495	23.495	23.495	23.495	640.0
2016-06-29 06:00:00	AAPL	Stock	23.4875	23.52	23.475	23.495	15352.0
2016-06-29 07:00:00	AAPL	Stock	23.475	23.5075	23.4675	23.5075	62452.0
2016-06-29 08:00:00	AAPL	Stock	23.5075	23.5325	23.465	23.5275	284516.0
2016-06-29 09:00:00	AAPL	Stock	23.52	23.6275	23.455	23.6075	19420404.0
2016-06-29 10:00:00	AAPL	Stock	23.6075	23.615	23.4075	23.435	24840392.0
2016-06-29 11:00:00	AAPL	Stock	23.4332	23.58	23.4325	23.5775	16082812.0
2016-06-29 12:00:00	AAPL	Stock	23.575	23.625	23.53	23.5525	13169168.0
2016-06-29 13:00:00	AAPL	Stock	23.5525	23.6075	23.5325	23.5925	9814420.0
2016-06-29 14:00:00	AAPL	Stock	23.592	23.635	23.575	23.595	14248592.0
2016-06-29 15:00:00	AAPL	Stock	23.595	23.6375	23.58	23.6	23652944.0
2016-06-29 16:00:00	AAPL	Stock	23.6	23.62	23.55	23.61	13048748.0
2016-06-29 17:00:00	AAPL	Stock	23.6175	23.6175	23.6	23.605	70264.0
2016-06-29 18:00:00	AAPL	Stock	23.6075	23.6075	23.5975	23.5975	12544.0
2016-06-29 19:00:00	AAPL	Stock	23.595	23.595	23.5525	23.5875	41244.0
2016-06-29 04:00:00	MSFT	Stock	49.56	49.82	49.56	49.82	300.0
2016-06-29 06:00:00	MSFT	Stock	49.75	49.9	49.75	49.9	1899.0
2016-06-29 07:00:00	MSFT	Stock	49.8	49.9	49.77	49.77	1652.0
2016-06-29 08:00:00	MSFT	Stock	49.77	49.95	49.77	49.95	11007.0
2016-06-29 09:00:00	MSFT	Stock	49.95	50.1	49.8	50.02	3152938.0
2016-06-29 10:00:00	MSFT	Stock	50.02	50.16	49.92	50.015	3016740.0
2016-06-29 11:00:00	MSFT	Stock	50.015	50.35	50.005	50.34	2941127.0
2016-06-29 12:00:00	MSFT	Stock	50.34	50.53	50.3	50.51	2946975.0
2016-06-29 13:00:00	MSFT	Stock	50.515	50.55	50.4	50.545	2502354.0
2016-06-29 14:00:00	MSFT	Stock	50.548	50.64	50.5	50.605	3130422.0
2016-06-29 15:00:00	MSFT	Stock	50.605	50.72	50.47	50.54	6969867.0
2016-06-29 16:00:00	MSFT	Stock	50.54	50.67	50.5	50.67	3820565.0
2016-06-29 17:00:00	MSFT	Stock	50.65	50.69	50.58	50.58	3186.0
2016-06-29 18:00:00	MSFT	Stock	50.58	50.58	50.55	50.56	11768.0
2016-06-29 19:00:00	MSFT	Stock	50.61	50.61	50.6	50.6	800.0
2016-06-29 06:00:00	NVDA	Stock	1.155	1.155	1.155	1.155	9640.0
2016-06-29 07:00:00	NVDA	Stock	1.155	1.16	1.155	1.16	33360.0
2016-06-29 08:00:00	NVDA	Stock	1.1575	1.1638	1.155	1.1613	556600.0
2016-06-29 09:00:00	NVDA	Stock	1.1578	1.166	1.1545	1.1605	50544640.0
2016-06-29 10:00:00	NVDA	Stock	1.1605	1.1651	1.1575	1.1628	45081080.0
2016-06-29 11:00:00	NVDA	Stock	1.1628	1.166	1.1615	1.1646	28750040.0
2016-06-29 12:00:00	NVDA	Stock	1.1648	1.1709	1.1645	1.1693	25417600.0
2016-06-29 13:00:00	NVDA	Stock	1.1695	1.173	1.1675	1.1707	31006200.0
2016-06-29 14:00:00	NVDA	Stock	1.1708	1.1752	1.1698	1.1705	34807200.0
2016-06-29 15:00:00	NVDA	Stock	1.1705	1.1718	1.1649	1.1655	82920760.0
2016-06-29 16:00:00	NVDA	Stock	1.1662	1.1698	1.1653	1.1698	13398640.0
2016-06-29 17:00:00	NVDA	Stock	1.1675	1.1675	1.1662	1.1662	264000.0
2016-06-29 19:00:00	NVDA	Stock	1.1688	1.1688	1.1688	1.1688	34000.0
2016-06-29 04:00:00	AMZN	Stock	35.425	35.55	35.425	35.55	10000.0
2016-06-29 06:00:00	AMZN	Stock	35.677	35.7	35.6115	35.6115	27920.0
2016-06-29 07:00:00	AMZN	Stock	35.688	35.6945	35.6115	35.6875	100140.0
2016-06-29 08:00:00	AMZN	Stock	35.638	35.7	35.6365	35.65	390160.0
2016-06-29 09:00:00	AMZN	Stock	35.65	35.9025	35.6255	35.765	15635960.0
2016-06-29 10:00:00	AMZN	Stock	35.777	35.898	35.712	35.8095	7180800.0

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

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