PREVIEW / stock_1hour / 2017-11-03

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-11-03.parquet
  size:    1.1 MB
  rows:    48,119
  symbols: 2,948

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
2017-11-03 04:00:00	AAPL	Stock	43.3875	43.4925	43.35	43.4475	108196.0
2017-11-03 05:00:00	AAPL	Stock	43.4375	43.4525	43.2	43.245	142308.0
2017-11-03 06:00:00	AAPL	Stock	43.255	43.52	43.215	43.5125	246436.0
2017-11-03 07:00:00	AAPL	Stock	43.5125	43.7275	43.4525	43.65	1958612.0
2017-11-03 08:00:00	AAPL	Stock	43.65	43.9875	43.25	43.7	7220028.0
2017-11-03 09:00:00	AAPL	Stock	43.7	43.7875	42.78	42.94	58523804.0
2017-11-03 10:00:00	AAPL	Stock	42.94	43.1725	42.7952	43.0025	39761136.0
2017-11-03 11:00:00	AAPL	Stock	43.0075	43.2375	42.9482	43.2285	24637616.0
2017-11-03 12:00:00	AAPL	Stock	43.235	43.3175	43.155	43.2692	20227244.0
2017-11-03 13:00:00	AAPL	Stock	43.27	43.4525	43.2425	43.37	16221048.0
2017-11-03 14:00:00	AAPL	Stock	43.37	43.3725	43.1375	43.2075	15691420.0
2017-11-03 15:00:00	AAPL	Stock	43.2062	43.228	43.0775	43.12	23202920.0
2017-11-03 16:00:00	AAPL	Stock	43.125	43.2788	43.0625	43.1125	7429824.0
2017-11-03 17:00:00	AAPL	Stock	43.105	43.125	43.0825	43.1	500148.0
2017-11-03 18:00:00	AAPL	Stock	43.1125	43.1175	43.1	43.105	100376.0
2017-11-03 19:00:00	AAPL	Stock	43.1025	43.12	43.1	43.1	42408.0
2017-11-03 04:00:00	MSFT	Stock	84.2	84.2	84.2	84.2	180.0
2017-11-03 05:00:00	MSFT	Stock	84.4	84.4	84.37	84.37	700.0
2017-11-03 06:00:00	MSFT	Stock	84.37	84.39	84.26	84.35	1209.0
2017-11-03 07:00:00	MSFT	Stock	84.3	84.42	84.3	84.4	3692.0
2017-11-03 08:00:00	MSFT	Stock	84.37	84.45	84.2	84.3	25172.0
2017-11-03 09:00:00	MSFT	Stock	84.34	84.35	83.4	83.53	2917609.0
2017-11-03 10:00:00	MSFT	Stock	83.53	83.98	83.475	83.98	2478046.0
2017-11-03 11:00:00	MSFT	Stock	83.97	84.275	83.845	84.27	1620943.0
2017-11-03 12:00:00	MSFT	Stock	84.28	84.54	84.21	84.37	1707795.0
2017-11-03 13:00:00	MSFT	Stock	84.37	84.44	84.06	84.095	1645936.0
2017-11-03 14:00:00	MSFT	Stock	84.1	84.215	84.0	84.015	1575944.0
2017-11-03 15:00:00	MSFT	Stock	84.01	84.14	84.0	84.13	2536544.0
2017-11-03 16:00:00	MSFT	Stock	84.14	84.31	83.85	84.0	1773195.0
2017-11-03 17:00:00	MSFT	Stock	84.05	84.12	84.0	84.0	5883.0
2017-11-03 18:00:00	MSFT	Stock	84.02	84.02	84.02	84.02	200.0
2017-11-03 19:00:00	MSFT	Stock	84.03	84.03	84.01	84.01	2100.0
2017-11-03 04:00:00	NVDA	Stock	5.1875	5.197	5.1875	5.197	15120.0
2017-11-03 06:00:00	NVDA	Stock	5.1958	5.1968	5.188	5.1968	42200.0
2017-11-03 07:00:00	NVDA	Stock	5.1873	5.212	5.1873	5.195	519880.0
2017-11-03 08:00:00	NVDA	Stock	5.1912	5.2098	5.1835	5.195	2107640.0
2017-11-03 09:00:00	NVDA	Stock	5.194	5.2015	5.1335	5.1406	49535880.0
2017-11-03 10:00:00	NVDA	Stock	5.1405	5.1975	5.135	5.197	65060200.0
2017-11-03 11:00:00	NVDA	Stock	5.1975	5.206	5.186	5.1932	36854200.0
2017-11-03 12:00:00	NVDA	Stock	5.1931	5.1968	5.1713	5.1876	26240160.0
2017-11-03 13:00:00	NVDA	Stock	5.188	5.2028	5.1805	5.1928	27350600.0
2017-11-03 14:00:00	NVDA	Stock	5.1934	5.2071	5.191	5.2005	33737440.0
2017-11-03 15:00:00	NVDA	Stock	5.2003	5.217	5.1895	5.217	54571360.0
2017-11-03 16:00:00	NVDA	Stock	5.2172	5.2225	5.208	5.2125	10961200.0
2017-11-03 17:00:00	NVDA	Stock	5.2125	5.2125	5.2083	5.2112	357280.0
2017-11-03 18:00:00	NVDA	Stock	5.2088	5.2112	5.2025	5.2088	477480.0
2017-11-03 19:00:00	NVDA	Stock	5.2088	5.2138	5.2083	5.2125	228720.0
2017-11-03 04:00:00	AMZN	Stock	54.75	54.8145	54.75	54.8145	4000.0
2017-11-03 05:00:00	AMZN	Stock	54.8145	54.8245	54.8145	54.8245	11880.0
2017-11-03 06:00:00	AMZN	Stock	54.8	54.8	54.7945	54.7945	7000.0

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

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