PREVIEW / stock_1hour / 2018-11-20

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-11-20.parquet
  size:    1.1 MB
  rows:    50,084
  symbols: 2,765

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
2018-11-20 04:00:00	AAPL	Stock	45.75	45.935	45.7	45.8125	197240.0
2018-11-20 05:00:00	AAPL	Stock	45.7825	45.8775	45.7125	45.7125	63576.0
2018-11-20 06:00:00	AAPL	Stock	45.71	45.88	45.695	45.88	102256.0
2018-11-20 07:00:00	AAPL	Stock	45.8225	45.875	45.175	45.175	1017264.0
2018-11-20 08:00:00	AAPL	Stock	45.1875	45.715	44.725	44.745	2508760.0
2018-11-20 09:00:00	AAPL	Stock	44.745	45.2875	43.8775	44.7675	53902308.0
2018-11-20 10:00:00	AAPL	Stock	44.7625	45.2425	44.1625	45.1287	51667012.0
2018-11-20 11:00:00	AAPL	Stock	45.1292	45.3	44.7275	45.1675	22550924.0
2018-11-20 12:00:00	AAPL	Stock	45.1675	45.3675	44.72	44.7425	16583800.0
2018-11-20 13:00:00	AAPL	Stock	44.7375	44.8252	44.45	44.49	14203908.0
2018-11-20 14:00:00	AAPL	Stock	44.49	44.5375	44.2	44.269	19075316.0
2018-11-20 15:00:00	AAPL	Stock	44.2675	44.3375	43.9625	44.235	37908592.0
2018-11-20 16:00:00	AAPL	Stock	44.24	44.25	44.075	44.175	15427476.0
2018-11-20 17:00:00	AAPL	Stock	44.175	44.245	44.0775	44.165	166988.0
2018-11-20 18:00:00	AAPL	Stock	44.1625	44.1625	44.025	44.0725	218692.0
2018-11-20 19:00:00	AAPL	Stock	44.0875	44.3125	44.0	44.25	231776.0
2018-11-20 04:00:00	MSFT	Stock	103.59	103.65	103.0	103.35	8283.0
2018-11-20 05:00:00	MSFT	Stock	103.22	103.31	103.2	103.24	3955.0
2018-11-20 06:00:00	MSFT	Stock	103.22	103.73	103.0	103.73	9981.0
2018-11-20 07:00:00	MSFT	Stock	103.6	103.6	102.63	102.8	94260.0
2018-11-20 08:00:00	MSFT	Stock	102.802	103.73	101.7	101.87	217561.0
2018-11-20 09:00:00	MSFT	Stock	101.95	102.65	100.71	101.055	9381554.0
2018-11-20 10:00:00	MSFT	Stock	101.06	102.51	99.353	102.41	13180581.0
2018-11-20 11:00:00	MSFT	Stock	102.41	102.97	101.73	102.22	5075442.0
2018-11-20 12:00:00	MSFT	Stock	102.236	102.78	101.91	101.966	3496068.0
2018-11-20 13:00:00	MSFT	Stock	101.96	102.13	101.36	101.5	3262198.0
2018-11-20 14:00:00	MSFT	Stock	101.51	101.88	101.243	101.46	4723178.0
2018-11-20 15:00:00	MSFT	Stock	101.46	101.82	100.77	101.71	9601669.0
2018-11-20 16:00:00	MSFT	Stock	101.71	102.35	101.4	101.92	7767239.0
2018-11-20 17:00:00	MSFT	Stock	101.91	102.15	101.52	101.61	16668.0
2018-11-20 18:00:00	MSFT	Stock	101.64	101.65	101.4	101.45	37668.0
2018-11-20 19:00:00	MSFT	Stock	101.55	102.15	101.55	102.15	16340.0
2018-11-20 04:00:00	NVDA	Stock	3.525	3.5375	3.49	3.5	1020760.0
2018-11-20 05:00:00	NVDA	Stock	3.4943	3.5455	3.4943	3.525	474880.0
2018-11-20 06:00:00	NVDA	Stock	3.525	3.5455	3.5052	3.5325	636920.0
2018-11-20 07:00:00	NVDA	Stock	3.53	3.5375	3.4185	3.423	10792760.0
2018-11-20 08:00:00	NVDA	Stock	3.458	3.503	3.3815	3.39	18863080.0
2018-11-20 09:00:00	NVDA	Stock	3.39	3.5922	3.3312	3.5704	408780800.0
2018-11-20 10:00:00	NVDA	Stock	3.5704	3.8375	3.5375	3.8278	475847320.0
2018-11-20 11:00:00	NVDA	Stock	3.824	3.8565	3.7532	3.7912	202698680.0
2018-11-20 12:00:00	NVDA	Stock	3.7899	3.821	3.7182	3.7392	104827880.0
2018-11-20 13:00:00	NVDA	Stock	3.7385	3.7598	3.6915	3.6922	91123240.0
2018-11-20 14:00:00	NVDA	Stock	3.6918	3.7622	3.6722	3.7228	93182400.0
2018-11-20 15:00:00	NVDA	Stock	3.7246	3.7677	3.672	3.727	139057880.0
2018-11-20 16:00:00	NVDA	Stock	3.727	3.7378	3.7202	3.725	3265880.0
2018-11-20 17:00:00	NVDA	Stock	3.725	3.73	3.7196	3.7212	334560.0
2018-11-20 18:00:00	NVDA	Stock	3.7215	3.7302	3.7188	3.7302	807000.0
2018-11-20 19:00:00	NVDA	Stock	3.7275	3.8002	3.7275	3.8	1301840.0
2018-11-20 04:00:00	AMZN	Stock	73.95	74.2375	73.7425	74.1595	139000.0
2018-11-20 05:00:00	AMZN	Stock	73.985	74.1995	73.945	73.945	67940.0

> showing 50 of 50,084 rows — these rows as CSV

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