PREVIEW / stock_1hour / 2016-06-03

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-06-03.parquet
  size:    1.0 MB
  rows:    48,494
  symbols: 3,298

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-03 05:00:00	AAPL	Stock	24.4875	24.4875	24.4875	24.4875	400.0
2016-06-03 06:00:00	AAPL	Stock	24.5	24.5	24.475	24.495	2460.0
2016-06-03 07:00:00	AAPL	Stock	24.475	24.495	24.475	24.4875	19008.0
2016-06-03 08:00:00	AAPL	Stock	24.4875	24.52	24.3575	24.36	696440.0
2016-06-03 09:00:00	AAPL	Stock	24.365	24.5675	24.335	24.4675	18864564.0
2016-06-03 10:00:00	AAPL	Stock	24.4675	24.5125	24.3625	24.44	21404036.0
2016-06-03 11:00:00	AAPL	Stock	24.44	24.541	24.4	24.5275	12863276.0
2016-06-03 12:00:00	AAPL	Stock	24.53	24.55	24.4645	24.466	8557740.0
2016-06-03 13:00:00	AAPL	Stock	24.465	24.509	24.445	24.5	6557544.0
2016-06-03 14:00:00	AAPL	Stock	24.5	24.515	24.425	24.485	9562628.0
2016-06-03 15:00:00	AAPL	Stock	24.4825	24.525	24.46	24.4775	14516532.0
2016-06-03 16:00:00	AAPL	Stock	24.48	24.5	24.475	24.5	6001988.0
2016-06-03 17:00:00	AAPL	Stock	24.4975	24.4975	24.4775	24.48	32008.0
2016-06-03 18:00:00	AAPL	Stock	24.49	24.5	24.48	24.48	13388.0
2016-06-03 19:00:00	AAPL	Stock	24.48	24.49	24.4775	24.48	10592.0
2016-06-03 08:00:00	MSFT	Stock	52.43	52.43	52.1	52.15	8298.0
2016-06-03 09:00:00	MSFT	Stock	52.16	52.42	51.89	51.89	2775787.0
2016-06-03 10:00:00	MSFT	Stock	51.89	51.92	51.6	51.83	3597179.0
2016-06-03 11:00:00	MSFT	Stock	51.84	51.995	51.7	51.955	2241407.0
2016-06-03 12:00:00	MSFT	Stock	51.96	51.985	51.73	51.74	1491228.0
2016-06-03 13:00:00	MSFT	Stock	51.74	51.82	51.68	51.76	1635386.0
2016-06-03 14:00:00	MSFT	Stock	51.76	51.92	51.71	51.865	2222681.0
2016-06-03 15:00:00	MSFT	Stock	51.86	51.93	51.7	51.79	4812355.0
2016-06-03 16:00:00	MSFT	Stock	51.79	51.9	51.7	51.75	2988711.0
2016-06-03 17:00:00	MSFT	Stock	51.79	51.79	51.71	51.74	143201.0
2016-06-03 19:00:00	MSFT	Stock	51.72	51.74	51.71	51.71	3614.0
2016-06-03 07:00:00	NVDA	Stock	1.1745	1.1745	1.1682	1.1685	16000.0
2016-06-03 08:00:00	NVDA	Stock	1.17	1.1748	1.1653	1.1653	276600.0
2016-06-03 09:00:00	NVDA	Stock	1.1638	1.1685	1.1422	1.1508	106649600.0
2016-06-03 10:00:00	NVDA	Stock	1.1508	1.159	1.1415	1.154	106937720.0
2016-06-03 11:00:00	NVDA	Stock	1.154	1.1602	1.1538	1.157	56562480.0
2016-06-03 12:00:00	NVDA	Stock	1.157	1.1598	1.155	1.1566	30577800.0
2016-06-03 13:00:00	NVDA	Stock	1.1565	1.1614	1.1553	1.1599	32260480.0
2016-06-03 14:00:00	NVDA	Stock	1.1598	1.1615	1.157	1.1602	30917800.0
2016-06-03 15:00:00	NVDA	Stock	1.1602	1.1638	1.1592	1.162	73089560.0
2016-06-03 16:00:00	NVDA	Stock	1.162	1.1638	1.1558	1.1622	673280.0
2016-06-03 17:00:00	NVDA	Stock	1.1622	1.1625	1.162	1.162	27520.0
2016-06-03 19:00:00	NVDA	Stock	1.1638	1.1638	1.16	1.1638	28000.0
2016-06-03 05:00:00	AMZN	Stock	36.458	36.458	36.458	36.458	2200.0
2016-06-03 07:00:00	AMZN	Stock	36.5	36.55	36.4495	36.4495	65700.0
2016-06-03 08:00:00	AMZN	Stock	36.4375	36.4735	36.245	36.275	494260.0
2016-06-03 09:00:00	AMZN	Stock	36.2855	36.35	36.181	36.233	10171040.0
2016-06-03 10:00:00	AMZN	Stock	36.237	36.2382	35.9215	36.125	17606720.0
2016-06-03 11:00:00	AMZN	Stock	36.1265	36.169	36.0305	36.1372	7342600.0
2016-06-03 12:00:00	AMZN	Stock	36.1475	36.257	36.128	36.2195	5310940.0
2016-06-03 13:00:00	AMZN	Stock	36.2172	36.2735	36.1555	36.189	3970540.0
2016-06-03 14:00:00	AMZN	Stock	36.1815	36.299	36.1425	36.2775	3705880.0
2016-06-03 15:00:00	AMZN	Stock	36.2765	36.3	36.2255	36.277	9175880.0
2016-06-03 16:00:00	AMZN	Stock	36.277	36.2925	36.275	36.275	548760.0
2016-06-03 17:00:00	AMZN	Stock	36.28	36.28	36.2675	36.2675	26500.0

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

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