PREVIEW / stock_1hour / 2019-10-09

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-10-09.parquet
  size:    1.1 MB
  rows:    49,652
  symbols: 2,481

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-10-09 04:00:00	AAPL	Stock	56.25	56.4725	56.25	56.425	68620.0
2019-10-09 05:00:00	AAPL	Stock	56.415	56.75	56.415	56.75	88720.0
2019-10-09 06:00:00	AAPL	Stock	56.6425	56.8375	56.6425	56.8075	39420.0
2019-10-09 07:00:00	AAPL	Stock	56.7575	56.83	56.6625	56.775	404864.0
2019-10-09 08:00:00	AAPL	Stock	56.704	56.8125	56.6	56.69	550860.0
2019-10-09 09:00:00	AAPL	Stock	56.69	56.8375	56.4675	56.55	10787404.0
2019-10-09 10:00:00	AAPL	Stock	56.555	56.67	56.4375	56.5075	8381992.0
2019-10-09 11:00:00	AAPL	Stock	56.515	56.7275	56.41	56.6782	7954796.0
2019-10-09 12:00:00	AAPL	Stock	56.6775	56.813	56.65	56.78	5851232.0
2019-10-09 13:00:00	AAPL	Stock	56.781	56.8775	56.6762	56.7125	5421700.0
2019-10-09 14:00:00	AAPL	Stock	56.715	56.905	56.6525	56.8275	4920736.0
2019-10-09 15:00:00	AAPL	Stock	56.8225	56.9475	56.6725	56.75	13693108.0
2019-10-09 16:00:00	AAPL	Stock	56.7575	56.8	56.68	56.7725	5058844.0
2019-10-09 17:00:00	AAPL	Stock	56.775	56.7875	56.75	56.77	26256.0
2019-10-09 18:00:00	AAPL	Stock	56.775	56.8025	55.7825	55.8175	521316.0
2019-10-09 19:00:00	AAPL	Stock	55.815	56.1	55.805	56.075	344172.0
2019-10-09 05:00:00	MSFT	Stock	136.58	137.57	136.58	137.39	5541.0
2019-10-09 06:00:00	MSFT	Stock	137.47	137.5	137.06	137.28	6805.0
2019-10-09 07:00:00	MSFT	Stock	137.21	137.21	136.8	137.05	51895.0
2019-10-09 08:00:00	MSFT	Stock	137.0	137.2	136.81	136.86	38248.0
2019-10-09 09:00:00	MSFT	Stock	136.93	137.662	136.61	137.29	2432418.0
2019-10-09 10:00:00	MSFT	Stock	137.28	137.79	137.25	137.67	2169051.0
2019-10-09 11:00:00	MSFT	Stock	137.68	137.93	137.26	137.799	1775448.0
2019-10-09 12:00:00	MSFT	Stock	137.8	138.07	137.74	138.06	1243955.0
2019-10-09 13:00:00	MSFT	Stock	138.06	138.276	137.95	138.15	1388740.0
2019-10-09 14:00:00	MSFT	Stock	138.14	138.68	138.08	138.513	1601104.0
2019-10-09 15:00:00	MSFT	Stock	138.51	138.7	137.92	138.21	4050810.0
2019-10-09 16:00:00	MSFT	Stock	138.24	138.45	137.95	138.24	2688288.0
2019-10-09 17:00:00	MSFT	Stock	138.32	138.32	138.24	138.24	1170.0
2019-10-09 18:00:00	MSFT	Stock	138.28	138.28	136.12	136.22	69396.0
2019-10-09 19:00:00	MSFT	Stock	136.25	136.72	136.2	136.72	36404.0
2019-10-09 04:00:00	NVDA	Stock	4.4352	4.45	4.4338	4.45	136920.0
2019-10-09 05:00:00	NVDA	Stock	4.45	4.4875	4.45	4.4875	69760.0
2019-10-09 06:00:00	NVDA	Stock	4.4838	4.51	4.4838	4.5095	103000.0
2019-10-09 07:00:00	NVDA	Stock	4.4875	4.5088	4.4815	4.5088	1080640.0
2019-10-09 08:00:00	NVDA	Stock	4.492	4.5125	4.48	4.5063	2276560.0
2019-10-09 09:00:00	NVDA	Stock	4.5052	4.5427	4.4925	4.5196	55818960.0
2019-10-09 10:00:00	NVDA	Stock	4.5192	4.529	4.4948	4.5134	36359920.0
2019-10-09 11:00:00	NVDA	Stock	4.515	4.5199	4.479	4.49	29723320.0
2019-10-09 12:00:00	NVDA	Stock	4.49	4.52	4.488	4.5188	21774560.0
2019-10-09 13:00:00	NVDA	Stock	4.5187	4.5575	4.515	4.547	36494760.0
2019-10-09 14:00:00	NVDA	Stock	4.5478	4.5625	4.537	4.5592	22354320.0
2019-10-09 15:00:00	NVDA	Stock	4.5588	4.5675	4.5125	4.5178	58221240.0
2019-10-09 16:00:00	NVDA	Stock	4.5178	4.5275	4.5148	4.5178	3539240.0
2019-10-09 17:00:00	NVDA	Stock	4.5212	4.5242	4.5175	4.5242	92960.0
2019-10-09 18:00:00	NVDA	Stock	4.5212	4.5262	4.425	4.4275	1833720.0
2019-10-09 19:00:00	NVDA	Stock	4.4275	4.4418	4.4163	4.4373	1001080.0
2019-10-09 05:00:00	AMZN	Stock	86.0	86.0	86.0	86.0	2000.0
2019-10-09 06:00:00	AMZN	Stock	86.188	86.2925	86.188	86.2925	18860.0
2019-10-09 07:00:00	AMZN	Stock	86.025	86.1	85.9505	86.0965	62400.0

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

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