PREVIEW / stock_1hour / 2016-07-06

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-07-06.parquet
  size:    1.0 MB
  rows:    48,122
  symbols: 3,252

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-07-06 04:00:00	AAPL	Stock	23.755	23.755	23.6925	23.6925	7832.0
2016-07-06 05:00:00	AAPL	Stock	23.68	23.68	23.6425	23.6425	42568.0
2016-07-06 06:00:00	AAPL	Stock	23.67	23.67	23.6175	23.6275	42940.0
2016-07-06 07:00:00	AAPL	Stock	23.625	23.675	23.6225	23.6625	70564.0
2016-07-06 08:00:00	AAPL	Stock	23.645	23.68	23.6125	23.65	309252.0
2016-07-06 09:00:00	AAPL	Stock	23.65	23.775	23.625	23.7325	16366556.0
2016-07-06 10:00:00	AAPL	Stock	23.73	23.85	23.5925	23.6962	25191632.0
2016-07-06 11:00:00	AAPL	Stock	23.6975	23.825	23.695	23.7975	16459768.0
2016-07-06 12:00:00	AAPL	Stock	23.8	23.915	23.7985	23.8688	11892188.0
2016-07-06 13:00:00	AAPL	Stock	23.87	23.905	23.8125	23.825	8089052.0
2016-07-06 14:00:00	AAPL	Stock	23.8275	23.8862	23.755	23.8762	12627948.0
2016-07-06 15:00:00	AAPL	Stock	23.8775	23.885	23.8075	23.8825	18970960.0
2016-07-06 16:00:00	AAPL	Stock	23.8825	23.8975	23.7878	23.865	5479076.0
2016-07-06 17:00:00	AAPL	Stock	23.875	23.8825	23.8575	23.8825	9564.0
2016-07-06 18:00:00	AAPL	Stock	23.8625	23.875	23.8625	23.875	26304.0
2016-07-06 19:00:00	AAPL	Stock	23.875	23.875	23.865	23.875	27740.0
2016-07-06 05:00:00	MSFT	Stock	51.0	51.0	50.9	50.9	1700.0
2016-07-06 07:00:00	MSFT	Stock	50.84	50.85	50.84	50.85	535.0
2016-07-06 08:00:00	MSFT	Stock	50.95	50.98	50.86	50.86	534.0
2016-07-06 09:00:00	MSFT	Stock	50.97	50.98	50.39	50.49	3357719.0
2016-07-06 10:00:00	MSFT	Stock	50.49	50.82	50.46	50.805	4401282.0
2016-07-06 11:00:00	MSFT	Stock	50.81	51.167	50.73	51.14	4280140.0
2016-07-06 12:00:00	MSFT	Stock	51.14	51.37	51.14	51.365	2475175.0
2016-07-06 13:00:00	MSFT	Stock	51.36	51.37	51.22	51.27	1935510.0
2016-07-06 14:00:00	MSFT	Stock	51.28	51.54	51.185	51.44	2512781.0
2016-07-06 15:00:00	MSFT	Stock	51.43	51.45	51.25	51.38	5945157.0
2016-07-06 16:00:00	MSFT	Stock	51.39	51.4	51.079	51.4	1579475.0
2016-07-06 17:00:00	MSFT	Stock	51.37	51.38	51.35	51.38	1018.0
2016-07-06 18:00:00	MSFT	Stock	51.28	51.28	51.28	51.28	122.0
2016-07-06 19:00:00	MSFT	Stock	51.28	51.3	51.28	51.3	600.0
2016-07-06 05:00:00	NVDA	Stock	1.175	1.175	1.175	1.175	4000.0
2016-07-06 07:00:00	NVDA	Stock	1.2108	1.2108	1.2108	1.2108	11920.0
2016-07-06 08:00:00	NVDA	Stock	1.1838	1.1838	1.1775	1.1775	154880.0
2016-07-06 09:00:00	NVDA	Stock	1.1788	1.1838	1.1695	1.182	38335240.0
2016-07-06 10:00:00	NVDA	Stock	1.182	1.1973	1.1813	1.1971	47699560.0
2016-07-06 11:00:00	NVDA	Stock	1.1973	1.1981	1.1907	1.192	26905840.0
2016-07-06 12:00:00	NVDA	Stock	1.1922	1.1962	1.191	1.1946	16965680.0
2016-07-06 13:00:00	NVDA	Stock	1.195	1.198	1.1932	1.196	24847760.0
2016-07-06 14:00:00	NVDA	Stock	1.196	1.1977	1.1932	1.1968	21626160.0
2016-07-06 15:00:00	NVDA	Stock	1.1968	1.1973	1.189	1.1915	56211160.0
2016-07-06 16:00:00	NVDA	Stock	1.1912	1.1925	1.1904	1.1912	19683200.0
2016-07-06 17:00:00	NVDA	Stock	1.1912	1.1912	1.1912	1.1912	600000.0
2016-07-06 18:00:00	NVDA	Stock	1.1905	1.1905	1.1905	1.1905	16000.0
2016-07-06 19:00:00	NVDA	Stock	1.19	1.1905	1.19	1.19	108800.0
2016-07-06 04:00:00	AMZN	Stock	36.2795	36.2795	36.2795	36.2795	4000.0
2016-07-06 05:00:00	AMZN	Stock	36.2515	36.2515	36.2515	36.2515	2000.0
2016-07-06 07:00:00	AMZN	Stock	36.1615	36.19	36.07	36.19	24320.0
2016-07-06 08:00:00	AMZN	Stock	36.16	36.3	36.16	36.25	282460.0
2016-07-06 09:00:00	AMZN	Stock	36.292	36.561	36.129	36.4828	13283140.0
2016-07-06 10:00:00	AMZN	Stock	36.472	36.718	36.4	36.63	14001980.0

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

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