PREVIEW / stock_1hour / 2017-11-10

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-11-10.parquet
  size:    1.1 MB
  rows:    48,648
  symbols: 2,942

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-10 04:00:00	AAPL	Stock	43.855	43.855	43.65	43.65	50568.0
2017-11-10 05:00:00	AAPL	Stock	43.625	43.76	43.575	43.66	49688.0
2017-11-10 06:00:00	AAPL	Stock	43.6625	43.745	43.6625	43.6925	16220.0
2017-11-10 07:00:00	AAPL	Stock	43.71	43.825	43.71	43.8125	137808.0
2017-11-10 08:00:00	AAPL	Stock	43.8125	43.87	43.7125	43.825	452164.0
2017-11-10 09:00:00	AAPL	Stock	43.815	43.8625	43.5675	43.7125	14114420.0
2017-11-10 10:00:00	AAPL	Stock	43.715	43.8125	43.605	43.8103	11756516.0
2017-11-10 11:00:00	AAPL	Stock	43.8125	43.835	43.6625	43.7532	8468512.0
2017-11-10 12:00:00	AAPL	Stock	43.7525	43.7725	43.695	43.705	5447752.0
2017-11-10 13:00:00	AAPL	Stock	43.7038	43.783	43.675	43.705	6044920.0
2017-11-10 14:00:00	AAPL	Stock	43.705	43.7625	43.6925	43.74	6103448.0
2017-11-10 15:00:00	AAPL	Stock	43.7388	43.75	43.6512	43.665	10147480.0
2017-11-10 16:00:00	AAPL	Stock	43.665	43.69	43.6275	43.63	23746632.0
2017-11-10 17:00:00	AAPL	Stock	43.6275	43.65	43.6125	43.6375	62248.0
2017-11-10 18:00:00	AAPL	Stock	43.625	43.64	43.6225	43.625	15240.0
2017-11-10 19:00:00	AAPL	Stock	43.6325	43.6475	43.6325	43.64	28372.0
2017-11-10 06:00:00	MSFT	Stock	84.03	84.03	83.68	83.68	500.0
2017-11-10 07:00:00	MSFT	Stock	83.96	83.96	83.89	83.94	9630.0
2017-11-10 08:00:00	MSFT	Stock	83.81	83.94	83.81	83.82	1575.0
2017-11-10 09:00:00	MSFT	Stock	83.95	84.095	83.67	83.73	2480623.0
2017-11-10 10:00:00	MSFT	Stock	83.735	83.77	83.23	83.46	2809174.0
2017-11-10 11:00:00	MSFT	Stock	83.46	83.6	83.285	83.564	1480152.0
2017-11-10 12:00:00	MSFT	Stock	83.56	83.63	83.4	83.415	1291389.0
2017-11-10 13:00:00	MSFT	Stock	83.415	83.66	83.33	83.565	1763621.0
2017-11-10 14:00:00	MSFT	Stock	83.565	83.8	83.565	83.716	1538061.0
2017-11-10 15:00:00	MSFT	Stock	83.715	83.88	83.67	83.86	2557668.0
2017-11-10 16:00:00	MSFT	Stock	83.87	83.87	83.73	83.76	4484997.0
2017-11-10 17:00:00	MSFT	Stock	83.78	83.8	83.78	83.8	1077.0
2017-11-10 18:00:00	MSFT	Stock	83.8	83.8	83.8	83.8	690.0
2017-11-10 19:00:00	MSFT	Stock	83.78	83.83	83.77	83.83	658.0
2017-11-10 04:00:00	NVDA	Stock	5.275	5.347	5.275	5.3125	838000.0
2017-11-10 05:00:00	NVDA	Stock	5.32	5.3595	5.32	5.3595	274800.0
2017-11-10 06:00:00	NVDA	Stock	5.3575	5.3585	5.32	5.339	1258400.0
2017-11-10 07:00:00	NVDA	Stock	5.3375	5.4188	5.3278	5.3998	10459440.0
2017-11-10 08:00:00	NVDA	Stock	5.3975	5.4095	5.2888	5.3303	20578440.0
2017-11-10 09:00:00	NVDA	Stock	5.3313	5.3943	5.28	5.3368	290033680.0
2017-11-10 10:00:00	NVDA	Stock	5.335	5.4438	5.3305	5.4375	285945760.0
2017-11-10 11:00:00	NVDA	Stock	5.4375	5.458	5.4045	5.4513	127140240.0
2017-11-10 12:00:00	NVDA	Stock	5.4509	5.4668	5.4133	5.4172	114605760.0
2017-11-10 13:00:00	NVDA	Stock	5.4165	5.4373	5.4095	5.4349	73989840.0
2017-11-10 14:00:00	NVDA	Stock	5.436	5.45	5.419	5.4305	75714920.0
2017-11-10 15:00:00	NVDA	Stock	5.4315	5.435	5.3798	5.4035	160619760.0
2017-11-10 16:00:00	NVDA	Stock	5.4032	5.4122	5.4032	5.408	5783680.0
2017-11-10 17:00:00	NVDA	Stock	5.4075	5.4112	5.4065	5.409	503760.0
2017-11-10 18:00:00	NVDA	Stock	5.4098	5.4112	5.405	5.406	522880.0
2017-11-10 19:00:00	NVDA	Stock	5.4078	5.4125	5.407	5.4125	437320.0
2017-11-10 06:00:00	AMZN	Stock	56.2665	56.2665	56.2665	56.2665	7740.0
2017-11-10 07:00:00	AMZN	Stock	56.2795	56.2795	56.2035	56.275	52320.0
2017-11-10 08:00:00	AMZN	Stock	56.275	56.4035	56.275	56.4035	85020.0
2017-11-10 09:00:00	AMZN	Stock	56.3875	56.5875	56.2485	56.49	7291880.0

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

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