PREVIEW / stock_1hour / 2019-08-05

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-08-05.parquet
  size:    1.2 MB
  rows:    51,990
  symbols: 2,568

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
2019-08-05 04:00:00	AAPL	Stock	49.75	49.995	49.6525	49.6525	77532.0
2019-08-05 05:00:00	AAPL	Stock	49.645	50.0	49.6	49.875	80772.0
2019-08-05 06:00:00	AAPL	Stock	49.8625	49.975	49.735	49.76	58792.0
2019-08-05 07:00:00	AAPL	Stock	49.775	49.875	49.465	49.6125	465576.0
2019-08-05 08:00:00	AAPL	Stock	49.725	49.86	49.4225	49.475	916768.0
2019-08-05 09:00:00	AAPL	Stock	49.435	49.6622	48.8328	49.0575	27903160.0
2019-08-05 10:00:00	AAPL	Stock	49.0375	49.1702	48.575	48.8528	27365148.0
2019-08-05 11:00:00	AAPL	Stock	48.8525	49.07	48.7075	48.78	16262020.0
2019-08-05 12:00:00	AAPL	Stock	48.7812	48.81	48.275	48.3025	16331140.0
2019-08-05 13:00:00	AAPL	Stock	48.3025	48.695	48.2625	48.41	14444780.0
2019-08-05 14:00:00	AAPL	Stock	48.4075	48.495	48.175	48.24	17126640.0
2019-08-05 15:00:00	AAPL	Stock	48.2425	48.575	48.145	48.305	32022416.0
2019-08-05 16:00:00	AAPL	Stock	48.2975	48.335	48.0125	48.085	21951448.0
2019-08-05 17:00:00	AAPL	Stock	48.0925	48.335	47.775	47.775	461084.0
2019-08-05 18:00:00	AAPL	Stock	47.8075	47.8075	47.0	47.1075	734452.0
2019-08-05 19:00:00	AAPL	Stock	47.1	47.1925	46.7625	46.825	324240.0
2019-08-05 04:00:00	MSFT	Stock	135.2	135.2	134.0	134.4	9420.0
2019-08-05 05:00:00	MSFT	Stock	134.05	134.94	134.0	134.94	10753.0
2019-08-05 06:00:00	MSFT	Stock	134.94	134.94	134.26	134.5	8843.0
2019-08-05 07:00:00	MSFT	Stock	134.68	134.8	133.76	134.12	78781.0
2019-08-05 08:00:00	MSFT	Stock	134.18	134.73	133.33	133.47	140369.0
2019-08-05 09:00:00	MSFT	Stock	133.49	133.66	132.0	133.559	4432406.0
2019-08-05 10:00:00	MSFT	Stock	133.53	133.755	132.714	133.15	3519813.0
2019-08-05 11:00:00	MSFT	Stock	133.15	133.93	133.03	133.62	3649550.0
2019-08-05 12:00:00	MSFT	Stock	133.63	133.66	132.31	132.37	3260331.0
2019-08-05 13:00:00	MSFT	Stock	132.36	132.93	131.94	131.98	2747084.0
2019-08-05 14:00:00	MSFT	Stock	131.98	132.18	131.0	131.22	4126308.0
2019-08-05 15:00:00	MSFT	Stock	131.225	132.73	130.78	132.2	9012204.0
2019-08-05 16:00:00	MSFT	Stock	132.18	132.44	131.01	131.28	5277484.0
2019-08-05 17:00:00	MSFT	Stock	131.28	132.21	130.55	130.55	35253.0
2019-08-05 18:00:00	MSFT	Stock	130.52	130.52	128.3	129.25	67071.0
2019-08-05 19:00:00	MSFT	Stock	129.15	129.35	128.5	128.56	38092.0
2019-08-05 04:00:00	NVDA	Stock	3.9375	3.9375	3.8968	3.9	186720.0
2019-08-05 05:00:00	NVDA	Stock	3.895	3.925	3.895	3.925	73120.0
2019-08-05 06:00:00	NVDA	Stock	3.9175	3.9175	3.9	3.9	61200.0
2019-08-05 07:00:00	NVDA	Stock	3.9048	3.9162	3.8608	3.87	1063400.0
2019-08-05 08:00:00	NVDA	Stock	3.89	3.912	3.8525	3.855	2659880.0
2019-08-05 09:00:00	NVDA	Stock	3.8525	3.856	3.7932	3.8189	91864800.0
2019-08-05 10:00:00	NVDA	Stock	3.8172	3.8292	3.758	3.7878	85619920.0
2019-08-05 11:00:00	NVDA	Stock	3.7868	3.7992	3.7625	3.7648	56807160.0
2019-08-05 12:00:00	NVDA	Stock	3.7628	3.7818	3.7542	3.7617	46798720.0
2019-08-05 13:00:00	NVDA	Stock	3.7615	3.7768	3.7473	3.7535	37453600.0
2019-08-05 14:00:00	NVDA	Stock	3.753	3.761	3.7252	3.7299	49562000.0
2019-08-05 15:00:00	NVDA	Stock	3.7305	3.7803	3.7225	3.7682	110656080.0
2019-08-05 16:00:00	NVDA	Stock	3.7698	3.7698	3.7378	3.745	38852680.0
2019-08-05 17:00:00	NVDA	Stock	3.7488	3.7488	3.7278	3.7325	431160.0
2019-08-05 18:00:00	NVDA	Stock	3.735	3.735	3.6625	3.6625	1077960.0
2019-08-05 19:00:00	NVDA	Stock	3.6583	3.6725	3.6438	3.6438	502640.0
2019-08-05 04:00:00	AMZN	Stock	89.75	89.75	89.3	89.3	41740.0
2019-08-05 05:00:00	AMZN	Stock	89.044	89.044	88.711	89.0265	102960.0

> showing 50 of 51,990 rows — these rows as CSV

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