PREVIEW / stock_1hour / 2020-04-30

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-04-30.parquet
  size:    1.2 MB
  rows:    56,241
  symbols: 2,387

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-04-30 04:00:00	AAPL	Stock	73.375	73.375	72.775	72.775	28092.0
2020-04-30 05:00:00	AAPL	Stock	72.775	73.0	72.775	73.0	20000.0
2020-04-30 06:00:00	AAPL	Stock	73.0	73.075	72.44	72.5	32848.0
2020-04-30 07:00:00	AAPL	Stock	72.575	72.875	72.5	72.55	333268.0
2020-04-30 08:00:00	AAPL	Stock	72.7645	72.875	72.0775	72.13	810484.0
2020-04-30 09:00:00	AAPL	Stock	72.13	73.33	71.8025	73.095	19595956.0
2020-04-30 10:00:00	AAPL	Stock	73.1	73.2675	72.5875	72.885	17642892.0
2020-04-30 11:00:00	AAPL	Stock	72.895	73.105	72.55	72.5525	10530984.0
2020-04-30 12:00:00	AAPL	Stock	72.5575	72.67	72.195	72.6125	12357584.0
2020-04-30 13:00:00	AAPL	Stock	72.6175	72.8625	72.4695	72.7275	9076504.0
2020-04-30 14:00:00	AAPL	Stock	72.7325	72.9575	72.5925	72.7325	12138696.0
2020-04-30 15:00:00	AAPL	Stock	72.735	73.6325	72.7185	73.4975	30284948.0
2020-04-30 16:00:00	AAPL	Stock	73.4975	75.3698	71.8625	72.0625	26731664.0
2020-04-30 17:00:00	AAPL	Stock	72.0925	72.8	71.5	71.5625	3961896.0
2020-04-30 18:00:00	AAPL	Stock	71.5625	71.8375	71.1875	71.6475	1113564.0
2020-04-30 19:00:00	AAPL	Stock	71.625	71.625	71.5	71.575	507316.0
2020-04-30 04:00:00	MSFT	Stock	181.35	182.21	181.09	181.82	12783.0
2020-04-30 05:00:00	MSFT	Stock	181.6	182.0	181.6	181.66	4604.0
2020-04-30 06:00:00	MSFT	Stock	181.75	182.15	180.34	180.8	12208.0
2020-04-30 07:00:00	MSFT	Stock	180.8	181.3	179.4	180.75	180582.0
2020-04-30 08:00:00	MSFT	Stock	181.0	181.28	179.01	179.5	393648.0
2020-04-30 09:00:00	MSFT	Stock	179.5	180.8	176.23	178.999	11200561.0
2020-04-30 10:00:00	MSFT	Stock	178.995	179.57	178.224	179.04	6693294.0
2020-04-30 11:00:00	MSFT	Stock	179.06	179.75	177.518	177.57	4977426.0
2020-04-30 12:00:00	MSFT	Stock	177.56	178.4	176.85	178.37	4070865.0
2020-04-30 13:00:00	MSFT	Stock	178.33	178.61	177.7	178.11	2920006.0
2020-04-30 14:00:00	MSFT	Stock	178.12	178.88	177.36	177.54	3060798.0
2020-04-30 15:00:00	MSFT	Stock	177.55	179.37	177.42	179.22	6931279.0
2020-04-30 16:00:00	MSFT	Stock	179.2	179.22	177.0	177.55	5143282.0
2020-04-30 17:00:00	MSFT	Stock	177.5	177.65	176.75	176.9	53111.0
2020-04-30 18:00:00	MSFT	Stock	176.82	176.89	175.34	176.12	155881.0
2020-04-30 19:00:00	MSFT	Stock	176.0	176.74	175.9	176.29	52391.0
2020-04-30 06:00:00	NVDA	Stock	7.4875	7.4875	7.48	7.48	22200.0
2020-04-30 07:00:00	NVDA	Stock	7.4615	7.4875	7.4385	7.452	438600.0
2020-04-30 08:00:00	NVDA	Stock	7.4435	7.5222	7.375	7.3752	1783840.0
2020-04-30 09:00:00	NVDA	Stock	7.4498	7.4615	7.3502	7.4008	46687400.0
2020-04-30 10:00:00	NVDA	Stock	7.4005	7.4448	7.3228	7.3665	56200760.0
2020-04-30 11:00:00	NVDA	Stock	7.3659	7.4138	7.3598	7.3625	30938240.0
2020-04-30 12:00:00	NVDA	Stock	7.3625	7.3632	7.293	7.3442	35133200.0
2020-04-30 13:00:00	NVDA	Stock	7.344	7.3535	7.3103	7.3388	21471600.0
2020-04-30 14:00:00	NVDA	Stock	7.3368	7.38	7.3268	7.3412	21853120.0
2020-04-30 15:00:00	NVDA	Stock	7.34	7.4008	7.294	7.3012	59805800.0
2020-04-30 16:00:00	NVDA	Stock	7.307	7.329	7.2562	7.263	11975640.0
2020-04-30 17:00:00	NVDA	Stock	7.2588	7.2725	7.2275	7.235	535480.0
2020-04-30 18:00:00	NVDA	Stock	7.2302	7.2302	7.1625	7.1995	578480.0
2020-04-30 19:00:00	NVDA	Stock	7.1922	7.2108	7.175	7.2	222720.0
2020-04-30 04:00:00	AMZN	Stock	121.0	121.0	120.7515	120.925	13580.0
2020-04-30 05:00:00	AMZN	Stock	120.925	122.0	120.925	122.0	47720.0
2020-04-30 06:00:00	AMZN	Stock	122.0275	122.0275	121.1575	121.1575	79560.0
2020-04-30 07:00:00	AMZN	Stock	121.2625	121.443	120.905	121.0155	146380.0

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

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