PREVIEW / stock_1hour / 2018-03-06

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-03-06.parquet
  size:    1.1 MB
  rows:    50,739
  symbols: 2,873

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-03-06 04:00:00	AAPL	Stock	44.3425	44.3875	44.3375	44.3875	8000.0
2018-03-06 05:00:00	AAPL	Stock	44.3375	44.4425	44.325	44.4375	8516.0
2018-03-06 06:00:00	AAPL	Stock	44.405	44.5325	44.405	44.5	37584.0
2018-03-06 07:00:00	AAPL	Stock	44.4875	44.54	44.46	44.5325	202788.0
2018-03-06 08:00:00	AAPL	Stock	44.525	44.54	44.4325	44.4625	395816.0
2018-03-06 09:00:00	AAPL	Stock	44.4775	44.56	44.35	44.475	14898964.0
2018-03-06 10:00:00	AAPL	Stock	44.475	44.5625	44.2025	44.2575	13748424.0
2018-03-06 11:00:00	AAPL	Stock	44.2525	44.265	44.085	44.2448	12113084.0
2018-03-06 12:00:00	AAPL	Stock	44.24	44.355	44.1425	44.355	8395664.0
2018-03-06 13:00:00	AAPL	Stock	44.3525	44.385	44.085	44.12	9069060.0
2018-03-06 14:00:00	AAPL	Stock	44.12	44.25	44.0325	44.175	7696088.0
2018-03-06 15:00:00	AAPL	Stock	44.1763	44.215	44.05	44.17	12659716.0
2018-03-06 16:00:00	AAPL	Stock	44.1675	44.1725	44.13	44.1625	6022188.0
2018-03-06 17:00:00	AAPL	Stock	44.145	44.145	43.45	43.5625	472588.0
2018-03-06 18:00:00	AAPL	Stock	43.5625	43.625	43.35	43.4625	508884.0
2018-03-06 19:00:00	AAPL	Stock	43.4725	43.4975	43.4	43.485	226668.0
2018-03-06 06:00:00	MSFT	Stock	94.15	94.15	94.15	94.15	100.0
2018-03-06 07:00:00	MSFT	Stock	94.45	94.45	94.03	94.03	7004.0
2018-03-06 08:00:00	MSFT	Stock	94.19	94.19	93.85	94.05	19734.0
2018-03-06 09:00:00	MSFT	Stock	94.0	94.49	93.92	94.12	2696563.0
2018-03-06 10:00:00	MSFT	Stock	94.125	94.24	93.32	93.365	2515168.0
2018-03-06 11:00:00	MSFT	Stock	93.37	93.55	92.941	93.5	2180534.0
2018-03-06 12:00:00	MSFT	Stock	93.5	93.63	93.215	93.62	1722118.0
2018-03-06 13:00:00	MSFT	Stock	93.625	93.775	93.2	93.275	1675997.0
2018-03-06 14:00:00	MSFT	Stock	93.27	93.545	92.97	93.385	2435847.0
2018-03-06 15:00:00	MSFT	Stock	93.38	93.49	93.03	93.32	4193947.0
2018-03-06 16:00:00	MSFT	Stock	93.32	93.32	93.13	93.2	2589574.0
2018-03-06 17:00:00	MSFT	Stock	93.2	93.28	92.13	92.2	18661.0
2018-03-06 18:00:00	MSFT	Stock	92.23	92.44	91.82	91.95	22530.0
2018-03-06 19:00:00	MSFT	Stock	91.9	91.99	91.52	91.75	27939.0
2018-03-06 04:00:00	NVDA	Stock	5.928	5.9412	5.928	5.94	59480.0
2018-03-06 05:00:00	NVDA	Stock	5.9373	5.9373	5.9322	5.9322	12000.0
2018-03-06 06:00:00	NVDA	Stock	5.9375	5.95	5.9375	5.949	70440.0
2018-03-06 07:00:00	NVDA	Stock	5.9438	5.9663	5.9415	5.9628	975440.0
2018-03-06 08:00:00	NVDA	Stock	5.9438	5.99	5.9438	5.9713	3363120.0
2018-03-06 09:00:00	NVDA	Stock	5.9738	6.0455	5.934	6.0218	136319160.0
2018-03-06 10:00:00	NVDA	Stock	6.023	6.0685	5.9865	5.9925	134114960.0
2018-03-06 11:00:00	NVDA	Stock	5.9948	6.04	5.958	6.0388	91056160.0
2018-03-06 12:00:00	NVDA	Stock	6.0384	6.0735	6.0272	6.072	78716720.0
2018-03-06 13:00:00	NVDA	Stock	6.0721	6.0725	6.0125	6.0235	52258720.0
2018-03-06 14:00:00	NVDA	Stock	6.0242	6.05	6.0123	6.0362	45010840.0
2018-03-06 15:00:00	NVDA	Stock	6.0355	6.057	6.0175	6.054	71334360.0
2018-03-06 16:00:00	NVDA	Stock	6.054	6.054	6.0465	6.0465	1667800.0
2018-03-06 17:00:00	NVDA	Stock	6.05	6.05	5.8825	5.9125	5496360.0
2018-03-06 18:00:00	NVDA	Stock	5.915	5.95	5.905	5.905	3725480.0
2018-03-06 19:00:00	NVDA	Stock	5.905	5.93	5.897	5.93	2223480.0
2018-03-06 04:00:00	AMZN	Stock	76.3485	76.525	76.3485	76.5125	30980.0
2018-03-06 05:00:00	AMZN	Stock	76.6	76.6	76.5155	76.5155	8120.0
2018-03-06 06:00:00	AMZN	Stock	76.45	76.5655	76.45	76.5655	43560.0
2018-03-06 07:00:00	AMZN	Stock	76.5	76.667	76.5	76.6	698960.0

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

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