PREVIEW / stock_1hour / 2016-06-13

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-06-13.parquet
  size:    1.0 MB
  rows:    48,931
  symbols: 3,295

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-13 04:00:00	AAPL	Stock	24.71	24.71	24.525	24.525	15600.0
2016-06-13 05:00:00	AAPL	Stock	24.505	24.505	24.475	24.4875	2904.0
2016-06-13 06:00:00	AAPL	Stock	24.525	24.5625	24.525	24.55	17524.0
2016-06-13 07:00:00	AAPL	Stock	24.5625	24.575	24.3725	24.52	230592.0
2016-06-13 08:00:00	AAPL	Stock	24.5125	24.575	24.425	24.5625	289628.0
2016-06-13 09:00:00	AAPL	Stock	24.5525	24.78	24.3825	24.42	23418656.0
2016-06-13 10:00:00	AAPL	Stock	24.42	24.475	24.275	24.4078	28993924.0
2016-06-13 11:00:00	AAPL	Stock	24.41	24.4725	24.35	24.3675	15236512.0
2016-06-13 12:00:00	AAPL	Stock	24.365	24.41	24.3275	24.39	12590772.0
2016-06-13 13:00:00	AAPL	Stock	24.3925	24.4075	24.337	24.3425	11743884.0
2016-06-13 14:00:00	AAPL	Stock	24.341	24.5125	24.3125	24.435	16985376.0
2016-06-13 15:00:00	AAPL	Stock	24.4375	24.455	24.31	24.335	21233692.0
2016-06-13 16:00:00	AAPL	Stock	24.335	24.389	24.3025	24.31	7415216.0
2016-06-13 17:00:00	AAPL	Stock	24.31	24.3125	24.2875	24.3	1082596.0
2016-06-13 18:00:00	AAPL	Stock	24.2925	24.315	24.28	24.2925	109068.0
2016-06-13 19:00:00	AAPL	Stock	24.3	24.3125	24.2875	24.3125	51960.0
2016-06-13 05:00:00	MSFT	Stock	51.25	51.25	51.04	51.25	303.0
2016-06-13 06:00:00	MSFT	Stock	51.25	51.29	51.25	51.29	580.0
2016-06-13 07:00:00	MSFT	Stock	51.29	51.29	51.29	51.29	1000.0
2016-06-13 08:00:00	MSFT	Stock	51.3	51.3	48.03	49.89	1260766.0
2016-06-13 09:00:00	MSFT	Stock	49.85	50.15	49.02	49.75	23859947.0
2016-06-13 10:00:00	MSFT	Stock	49.75	50.36	49.38	50.29	16576899.0
2016-06-13 11:00:00	MSFT	Stock	50.295	50.715	49.95	49.99	10183636.0
2016-06-13 12:00:00	MSFT	Stock	49.99	50.25	49.89	50.14	6486119.0
2016-06-13 13:00:00	MSFT	Stock	50.135	50.19	49.96	50.075	4299837.0
2016-06-13 14:00:00	MSFT	Stock	50.07	50.27	50.02	50.045	3756418.0
2016-06-13 15:00:00	MSFT	Stock	50.045	50.29	49.995	50.15	10260737.0
2016-06-13 16:00:00	MSFT	Stock	50.14	50.196	50.05	50.15	2476771.0
2016-06-13 17:00:00	MSFT	Stock	50.12	50.14	50.03	50.03	2823.0
2016-06-13 18:00:00	MSFT	Stock	50.03	50.12	50.03	50.1	1600.0
2016-06-13 19:00:00	MSFT	Stock	50.1	50.1	50.0	50.09	6734.0
2016-06-13 04:00:00	NVDA	Stock	1.155	1.155	1.155	1.155	10680.0
2016-06-13 08:00:00	NVDA	Stock	1.1562	1.1685	1.1525	1.1625	365960.0
2016-06-13 09:00:00	NVDA	Stock	1.1625	1.1895	1.1558	1.1885	64806880.0
2016-06-13 10:00:00	NVDA	Stock	1.1888	1.1925	1.183	1.1868	55160160.0
2016-06-13 11:00:00	NVDA	Stock	1.1868	1.1922	1.1819	1.1822	48112560.0
2016-06-13 12:00:00	NVDA	Stock	1.1822	1.1885	1.1803	1.1871	39919000.0
2016-06-13 13:00:00	NVDA	Stock	1.1875	1.1878	1.183	1.1834	42096760.0
2016-06-13 14:00:00	NVDA	Stock	1.1832	1.1855	1.177	1.1782	42517080.0
2016-06-13 15:00:00	NVDA	Stock	1.178	1.1785	1.1672	1.17	91942120.0
2016-06-13 16:00:00	NVDA	Stock	1.1698	1.1735	1.1698	1.17	31374960.0
2016-06-13 17:00:00	NVDA	Stock	1.1698	1.1698	1.1698	1.1698	806480.0
2016-06-13 19:00:00	NVDA	Stock	1.1698	1.1698	1.1698	1.1698	40000.0
2016-06-13 04:00:00	AMZN	Stock	35.625	35.625	35.625	35.625	7960.0
2016-06-13 05:00:00	AMZN	Stock	35.523	35.523	35.4995	35.5	31880.0
2016-06-13 06:00:00	AMZN	Stock	35.5495	35.55	35.549	35.55	20260.0
2016-06-13 07:00:00	AMZN	Stock	35.591	35.6915	35.575	35.651	100500.0
2016-06-13 08:00:00	AMZN	Stock	35.69	35.795	35.457	35.703	299660.0
2016-06-13 09:00:00	AMZN	Stock	35.701	35.877	35.558	35.858	10235960.0
2016-06-13 10:00:00	AMZN	Stock	35.8602	36.0995	35.8325	35.9995	12747540.0

> showing 50 of 48,931 rows — these rows as CSV

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