PREVIEW / stock_1hour / 2020-03-17

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-03-17.parquet
  size:    1.2 MB
  rows:    55,706
  symbols: 2,454

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-17 04:00:00	AAPL	Stock	63.35	64.7	62.0125	62.125	327432.0
2020-03-17 05:00:00	AAPL	Stock	62.23	62.625	60.64	61.585	147572.0
2020-03-17 06:00:00	AAPL	Stock	61.4	63.0625	61.3825	63.0125	165000.0
2020-03-17 07:00:00	AAPL	Stock	62.7775	63.0625	61.5025	61.59	583776.0
2020-03-17 08:00:00	AAPL	Stock	62.515	62.9375	61.5	62.15	858228.0
2020-03-17 09:00:00	AAPL	Stock	62.1475	62.3725	59.7475	60.095	39749288.0
2020-03-17 10:00:00	AAPL	Stock	60.115	62.82	59.6	62.58	48754800.0
2020-03-17 11:00:00	AAPL	Stock	62.5722	63.6875	62.1675	63.6175	35754436.0
2020-03-17 12:00:00	AAPL	Stock	63.6075	64.4025	62.4025	63.147	33380056.0
2020-03-17 13:00:00	AAPL	Stock	63.17	63.525	62.015	63.3025	21459692.0
2020-03-17 14:00:00	AAPL	Stock	63.2975	64.0625	62.6525	63.28	25052880.0
2020-03-17 15:00:00	AAPL	Stock	63.28	64.1375	62.0575	63.2125	42049208.0
2020-03-17 16:00:00	AAPL	Stock	63.2125	63.215	62.375	62.375	17721880.0
2020-03-17 17:00:00	AAPL	Stock	62.3438	62.55	62.185	62.185	121852.0
2020-03-17 18:00:00	AAPL	Stock	63.215	63.215	61.97	62.1075	150244.0
2020-03-17 19:00:00	AAPL	Stock	62.075	62.075	61.0	61.0	272328.0
2020-03-17 04:00:00	MSFT	Stock	142.1	144.41	139.6	139.6	16997.0
2020-03-17 05:00:00	MSFT	Stock	139.5	140.5	135.8	137.19	54903.0
2020-03-17 06:00:00	MSFT	Stock	137.79	141.0	137.79	140.84	15786.0
2020-03-17 07:00:00	MSFT	Stock	141.21	141.3	137.42	137.76	114749.0
2020-03-17 08:00:00	MSFT	Stock	137.49	141.0	137.39	138.5	231441.0
2020-03-17 09:00:00	MSFT	Stock	138.62	141.46	135.42	136.305	8554202.0
2020-03-17 10:00:00	MSFT	Stock	136.34	142.98	135.0	142.11	10670533.0
2020-03-17 11:00:00	MSFT	Stock	142.08	146.0	142.0	145.52	9134268.0
2020-03-17 12:00:00	MSFT	Stock	145.5	147.5	141.39	143.269	7702306.0
2020-03-17 13:00:00	MSFT	Stock	143.28	145.48	140.5	144.6	5345202.0
2020-03-17 14:00:00	MSFT	Stock	144.63	146.92	143.29	145.524	6263985.0
2020-03-17 15:00:00	MSFT	Stock	145.535	147.49	142.01	146.57	12189823.0
2020-03-17 16:00:00	MSFT	Stock	146.57	146.59	144.4	144.45	7530789.0
2020-03-17 17:00:00	MSFT	Stock	144.4	146.57	144.02	144.25	24355.0
2020-03-17 18:00:00	MSFT	Stock	144.25	146.57	143.18	143.25	33649.0
2020-03-17 19:00:00	MSFT	Stock	143.3	143.5	141.42	142.0	48774.0
2020-03-17 04:00:00	NVDA	Stock	5.25	5.25	5.1	5.1	113280.0
2020-03-17 05:00:00	NVDA	Stock	5.0575	5.1443	4.95	5.03	227360.0
2020-03-17 06:00:00	NVDA	Stock	5.0658	5.15	5.0658	5.1458	280360.0
2020-03-17 07:00:00	NVDA	Stock	5.1498	5.1498	4.984	4.984	1414640.0
2020-03-17 08:00:00	NVDA	Stock	5.15	5.15	4.9738	5.0288	2123680.0
2020-03-17 09:00:00	NVDA	Stock	5.0375	5.15	4.8173	4.8401	82054400.0
2020-03-17 10:00:00	NVDA	Stock	4.8425	5.2348	4.775	5.226	157546200.0
2020-03-17 11:00:00	NVDA	Stock	5.225	5.4432	5.184	5.4163	128059920.0
2020-03-17 12:00:00	NVDA	Stock	5.4193	5.4938	5.2	5.3362	78916720.0
2020-03-17 13:00:00	NVDA	Stock	5.3362	5.4179	5.209	5.3868	69683960.0
2020-03-17 14:00:00	NVDA	Stock	5.3835	5.4938	5.35	5.405	60441840.0
2020-03-17 15:00:00	NVDA	Stock	5.4054	5.5215	5.3118	5.4315	126907080.0
2020-03-17 16:00:00	NVDA	Stock	5.4318	5.4425	5.3625	5.3688	3470760.0
2020-03-17 17:00:00	NVDA	Stock	5.3688	5.369	5.35	5.35	687360.0
2020-03-17 18:00:00	NVDA	Stock	5.36	5.4318	5.3438	5.3438	366840.0
2020-03-17 19:00:00	NVDA	Stock	5.3438	5.344	5.2528	5.275	985800.0
2020-03-17 04:00:00	AMZN	Stock	91.05	91.482	88.2575	88.2575	76040.0
2020-03-17 05:00:00	AMZN	Stock	88.3505	88.3505	86.192	86.5	155040.0

> showing 50 of 55,706 rows — these rows as CSV

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