PREVIEW / stock_1hour / 2020-03-18

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-03-18.parquet
  size:    1.2 MB
  rows:    56,341
  symbols: 2,472

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
2020-03-18 04:00:00	AAPL	Stock	59.9275	60.15	59.5125	59.995	158276.0
2020-03-18 05:00:00	AAPL	Stock	59.9	59.925	59.5	59.625	106272.0
2020-03-18 06:00:00	AAPL	Stock	59.675	59.68	59.0	59.125	181592.0
2020-03-18 07:00:00	AAPL	Stock	59.125	59.8375	59.0625	59.8125	889980.0
2020-03-18 08:00:00	AAPL	Stock	59.25	60.492	59.1025	60.115	1948776.0
2020-03-18 09:00:00	AAPL	Stock	60.125	61.6025	59.802	61.18	32898564.0
2020-03-18 10:00:00	AAPL	Stock	61.1625	62.0	60.9325	61.3375	28966724.0
2020-03-18 11:00:00	AAPL	Stock	61.3325	61.7	60.825	61.52	27313312.0
2020-03-18 12:00:00	AAPL	Stock	61.5075	61.6225	60.5	60.525	23359924.0
2020-03-18 13:00:00	AAPL	Stock	60.065	60.8125	59.5	60.265	30190000.0
2020-03-18 14:00:00	AAPL	Stock	60.295	60.5	59.28	60.4875	30501600.0
2020-03-18 15:00:00	AAPL	Stock	60.4875	62.5	59.6825	62.25	47584676.0
2020-03-18 16:00:00	AAPL	Stock	61.6675	62.5	61.3125	61.7475	17183224.0
2020-03-18 17:00:00	AAPL	Stock	61.7575	61.85	61.55	61.775	194232.0
2020-03-18 18:00:00	AAPL	Stock	61.785	62.5	61.0	62.3125	522196.0
2020-03-18 19:00:00	AAPL	Stock	62.16	63.5	62.125	63.4375	723660.0
2020-03-18 04:00:00	MSFT	Stock	139.7	139.7	138.03	139.31	13921.0
2020-03-18 05:00:00	MSFT	Stock	139.41	139.5	138.4	138.4	5611.0
2020-03-18 06:00:00	MSFT	Stock	138.5	138.5	137.0	137.52	13468.0
2020-03-18 07:00:00	MSFT	Stock	137.77	138.91	136.96	138.85	139280.0
2020-03-18 08:00:00	MSFT	Stock	137.9	138.91	137.0	137.75	155997.0
2020-03-18 09:00:00	MSFT	Stock	138.02	144.053	136.8	143.07	7991906.0
2020-03-18 10:00:00	MSFT	Stock	143.1	146.0	141.66	142.34	7480529.0
2020-03-18 11:00:00	MSFT	Stock	142.37	144.11	140.54	143.33	6959541.0
2020-03-18 12:00:00	MSFT	Stock	143.33	143.4	139.42	139.43	5975540.0
2020-03-18 13:00:00	MSFT	Stock	138.35	140.18	135.52	138.416	8239179.0
2020-03-18 14:00:00	MSFT	Stock	138.45	138.91	135.02	138.612	8609781.0
2020-03-18 15:00:00	MSFT	Stock	138.63	144.72	135.57	142.13	15732822.0
2020-03-18 16:00:00	MSFT	Stock	142.39	143.604	139.73	141.89	7526358.0
2020-03-18 17:00:00	MSFT	Stock	141.86	141.99	139.898	141.5	101548.0
2020-03-18 18:00:00	MSFT	Stock	141.37	143.5	139.7	143.0	147980.0
2020-03-18 19:00:00	MSFT	Stock	143.0	146.0	142.23	145.0	173931.0
2020-03-18 04:00:00	NVDA	Stock	5.055	5.095	5.0448	5.0775	111120.0
2020-03-18 05:00:00	NVDA	Stock	5.095	5.1	5.01	5.01	251600.0
2020-03-18 06:00:00	NVDA	Stock	5.0325	5.0325	4.9005	4.925	405360.0
2020-03-18 07:00:00	NVDA	Stock	4.925	5.023	4.925	4.9732	1875440.0
2020-03-18 08:00:00	NVDA	Stock	4.925	5.0018	4.9248	4.95	3132040.0
2020-03-18 09:00:00	NVDA	Stock	4.9563	5.2125	4.927	5.1215	72204240.0
2020-03-18 10:00:00	NVDA	Stock	5.125	5.2485	5.0318	5.0413	75265080.0
2020-03-18 11:00:00	NVDA	Stock	5.0465	5.1525	4.9702	5.0998	85126000.0
2020-03-18 12:00:00	NVDA	Stock	5.0985	5.1082	4.8295	4.8304	90195440.0
2020-03-18 13:00:00	NVDA	Stock	4.825	4.8742	4.6138	4.693	112396840.0
2020-03-18 14:00:00	NVDA	Stock	4.6892	4.8195	4.517	4.8048	120332640.0
2020-03-18 15:00:00	NVDA	Stock	4.8035	5.1123	4.6758	5.0878	159587120.0
2020-03-18 16:00:00	NVDA	Stock	5.0705	5.1	4.95	5.0852	44854120.0
2020-03-18 17:00:00	NVDA	Stock	5.0862	5.0928	5.0228	5.0402	1137800.0
2020-03-18 18:00:00	NVDA	Stock	5.05	5.1188	4.9388	5.0875	2264440.0
2020-03-18 19:00:00	NVDA	Stock	5.0988	5.2175	5.0705	5.1875	2731080.0
2020-03-18 04:00:00	AMZN	Stock	86.25	86.25	86.25	86.25	3640.0
2020-03-18 05:00:00	AMZN	Stock	87.5	87.5	87.1495	87.1495	12920.0

> showing 50 of 56,341 rows — these rows as CSV

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