PREVIEW / stock_1hour / 2019-03-07

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-03-07.parquet
  size:    1.1 MB
  rows:    49,896
  symbols: 2,656

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-03-07 04:00:00	AAPL	Stock	43.5	43.5	43.475	43.485	4832.0
2019-03-07 05:00:00	AAPL	Stock	43.44	43.44	43.44	43.44	400.0
2019-03-07 06:00:00	AAPL	Stock	43.47	43.4775	43.47	43.4775	2000.0
2019-03-07 07:00:00	AAPL	Stock	43.4875	43.5875	43.45	43.5875	88992.0
2019-03-07 08:00:00	AAPL	Stock	43.515	43.675	43.495	43.58	164672.0
2019-03-07 09:00:00	AAPL	Stock	43.5875	43.62	43.3625	43.3825	11073504.0
2019-03-07 10:00:00	AAPL	Stock	43.385	43.3875	43.005	43.2285	16661636.0
2019-03-07 11:00:00	AAPL	Stock	43.2275	43.4125	43.1825	43.4	8267504.0
2019-03-07 12:00:00	AAPL	Stock	43.3988	43.5575	43.2575	43.5	8572640.0
2019-03-07 13:00:00	AAPL	Stock	43.5	43.555	43.35	43.44	5539352.0
2019-03-07 14:00:00	AAPL	Stock	43.4375	43.46	43.14	43.185	8297040.0
2019-03-07 15:00:00	AAPL	Stock	43.1875	43.215	43.075	43.1175	15419316.0
2019-03-07 16:00:00	AAPL	Stock	43.12	43.1525	43.12	43.15	15984220.0
2019-03-07 17:00:00	AAPL	Stock	43.1575	43.1625	43.13	43.14	17892.0
2019-03-07 18:00:00	AAPL	Stock	43.145	43.2	43.125	43.2	83768.0
2019-03-07 19:00:00	AAPL	Stock	43.1775	43.2	43.0775	43.0775	52164.0
2019-03-07 04:00:00	MSFT	Stock	111.24	111.24	111.22	111.22	200.0
2019-03-07 05:00:00	MSFT	Stock	111.0	111.2	111.0	111.2	485.0
2019-03-07 07:00:00	MSFT	Stock	111.22	111.55	111.22	111.54	14390.0
2019-03-07 08:00:00	MSFT	Stock	111.491	111.9	111.29	111.7	12464.0
2019-03-07 09:00:00	MSFT	Stock	111.65	111.65	110.57	110.64	2675778.0
2019-03-07 10:00:00	MSFT	Stock	110.625	110.71	109.865	110.41	3485359.0
2019-03-07 11:00:00	MSFT	Stock	110.415	110.92	110.13	110.78	2165942.0
2019-03-07 12:00:00	MSFT	Stock	110.77	111.21	110.55	111.16	1428448.0
2019-03-07 13:00:00	MSFT	Stock	111.16	111.22	110.7	110.74	1149000.0
2019-03-07 14:00:00	MSFT	Stock	110.74	110.84	109.939	110.07	1744146.0
2019-03-07 15:00:00	MSFT	Stock	110.08	110.5	109.94	110.38	3650175.0
2019-03-07 16:00:00	MSFT	Stock	110.32	110.48	110.32	110.48	4466954.0
2019-03-07 17:00:00	MSFT	Stock	110.39	110.44	110.36	110.4	1469.0
2019-03-07 18:00:00	MSFT	Stock	110.4	110.4	110.3	110.4	2138.0
2019-03-07 19:00:00	MSFT	Stock	110.4	110.44	110.0	110.0	14387.0
2019-03-07 04:00:00	NVDA	Stock	3.7782	3.7782	3.7675	3.7675	37120.0
2019-03-07 05:00:00	NVDA	Stock	3.7625	3.7625	3.7625	3.7625	41160.0
2019-03-07 06:00:00	NVDA	Stock	3.772	3.7725	3.772	3.7725	19960.0
2019-03-07 07:00:00	NVDA	Stock	3.7725	3.7875	3.7625	3.7875	461440.0
2019-03-07 08:00:00	NVDA	Stock	3.775	3.8	3.771	3.7939	1021000.0
2019-03-07 09:00:00	NVDA	Stock	3.7875	3.7938	3.685	3.7238	105188760.0
2019-03-07 10:00:00	NVDA	Stock	3.7238	3.7585	3.709	3.7388	91389480.0
2019-03-07 11:00:00	NVDA	Stock	3.738	3.7688	3.726	3.7488	56943760.0
2019-03-07 12:00:00	NVDA	Stock	3.7488	3.7632	3.7438	3.7598	30232600.0
2019-03-07 13:00:00	NVDA	Stock	3.7585	3.7668	3.7395	3.744	24927160.0
2019-03-07 14:00:00	NVDA	Stock	3.744	3.7468	3.7185	3.7213	30102920.0
2019-03-07 15:00:00	NVDA	Stock	3.7218	3.775	3.7135	3.7312	63719720.0
2019-03-07 16:00:00	NVDA	Stock	3.7315	3.735	3.7262	3.729	1975520.0
2019-03-07 17:00:00	NVDA	Stock	3.729	3.729	3.7262	3.7263	50840.0
2019-03-07 18:00:00	NVDA	Stock	3.7262	3.7348	3.7262	3.7348	77120.0
2019-03-07 19:00:00	NVDA	Stock	3.729	3.73	3.7275	3.7275	135600.0
2019-03-07 07:00:00	AMZN	Stock	83.0995	83.394	83.075	83.394	44000.0
2019-03-07 08:00:00	AMZN	Stock	83.0657	83.6995	83.0548	83.45	237820.0
2019-03-07 09:00:00	AMZN	Stock	83.49	83.5695	82.675	82.9212	7875580.0

> showing 50 of 49,896 rows — these rows as CSV

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