PREVIEW / stock_1hour / 2020-05-15

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-05-15.parquet
  size:    1.2 MB
  rows:    53,987
  symbols: 2,354

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-05-15 04:00:00	AAPL	Stock	77.775	77.8125	77.455	77.455	17824.0
2020-05-15 05:00:00	AAPL	Stock	77.66	77.7625	77.5925	77.5925	13304.0
2020-05-15 06:00:00	AAPL	Stock	77.5525	77.625	76.8	76.8	88112.0
2020-05-15 07:00:00	AAPL	Stock	76.875	76.9625	75.1875	75.3125	1242640.0
2020-05-15 08:00:00	AAPL	Stock	75.3125	76.95	74.9375	75.3025	1810284.0
2020-05-15 09:00:00	AAPL	Stock	75.3025	76.1112	74.95	75.995	27589524.0
2020-05-15 10:00:00	AAPL	Stock	76.01	76.53	75.91	76.0265	21748864.0
2020-05-15 11:00:00	AAPL	Stock	76.0225	76.0225	75.5725	75.7712	13833548.0
2020-05-15 12:00:00	AAPL	Stock	75.7712	76.34	75.72	76.2375	14824008.0
2020-05-15 13:00:00	AAPL	Stock	76.2325	76.5275	76.16	76.375	12608076.0
2020-05-15 14:00:00	AAPL	Stock	76.3725	76.86	76.35	76.52	15067380.0
2020-05-15 15:00:00	AAPL	Stock	76.525	76.975	76.416	76.935	21558556.0
2020-05-15 16:00:00	AAPL	Stock	76.9275	76.945	76.2053	76.7875	7052292.0
2020-05-15 17:00:00	AAPL	Stock	76.805	76.8625	76.765	76.78	72528.0
2020-05-15 18:00:00	AAPL	Stock	76.785	76.8	76.6275	76.6825	46028.0
2020-05-15 19:00:00	AAPL	Stock	76.7	76.7475	76.625	76.655	35752.0
2020-05-15 04:00:00	MSFT	Stock	181.52	181.85	181.01	181.01	4499.0
2020-05-15 05:00:00	MSFT	Stock	181.46	181.61	181.46	181.58	3486.0
2020-05-15 06:00:00	MSFT	Stock	181.25	181.6	179.66	179.98	12295.0
2020-05-15 07:00:00	MSFT	Stock	180.21	180.21	178.11	178.36	69505.0
2020-05-15 08:00:00	MSFT	Stock	179.1	179.85	178.04	178.71	104190.0
2020-05-15 09:00:00	MSFT	Stock	178.8	180.64	178.21	179.31	4943538.0
2020-05-15 10:00:00	MSFT	Stock	179.29	179.76	177.44	177.555	4108184.0
2020-05-15 11:00:00	MSFT	Stock	177.55	178.2	177.0	178.045	3363941.0
2020-05-15 12:00:00	MSFT	Stock	178.04	180.36	177.945	180.27	3771598.0
2020-05-15 13:00:00	MSFT	Stock	180.28	182.0	179.65	180.46	3549462.0
2020-05-15 14:00:00	MSFT	Stock	180.44	181.24	180.19	180.51	3453796.0
2020-05-15 15:00:00	MSFT	Stock	180.51	187.06	180.29	183.39	9523968.0
2020-05-15 16:00:00	MSFT	Stock	183.37	183.48	182.15	182.52	8399747.0
2020-05-15 17:00:00	MSFT	Stock	182.52	182.56	182.26	182.3	22568.0
2020-05-15 18:00:00	MSFT	Stock	182.4	182.5	182.3	182.45	5531.0
2020-05-15 19:00:00	MSFT	Stock	182.35	182.6	182.35	182.6	5251.0
2020-05-15 04:00:00	NVDA	Stock	8.1	8.1192	8.1	8.105	46000.0
2020-05-15 05:00:00	NVDA	Stock	8.1095	8.1095	8.0982	8.0982	27840.0
2020-05-15 06:00:00	NVDA	Stock	8.036	8.0375	8.0	8.0	105400.0
2020-05-15 07:00:00	NVDA	Stock	7.9988	8.011	7.825	7.8405	3627360.0
2020-05-15 08:00:00	NVDA	Stock	7.9138	8.0	7.8125	7.8575	3214520.0
2020-05-15 09:00:00	NVDA	Stock	7.8575	7.991	7.8162	7.9695	93820480.0
2020-05-15 10:00:00	NVDA	Stock	7.9698	8.079	7.9372	7.951	100281560.0
2020-05-15 11:00:00	NVDA	Stock	7.951	7.9872	7.9005	7.9835	51370880.0
2020-05-15 12:00:00	NVDA	Stock	7.9815	8.1622	7.9785	8.1518	105441800.0
2020-05-15 13:00:00	NVDA	Stock	8.1535	8.2218	8.125	8.1908	100608360.0
2020-05-15 14:00:00	NVDA	Stock	8.1912	8.2738	8.1905	8.231	106446240.0
2020-05-15 15:00:00	NVDA	Stock	8.2316	8.5005	8.222	8.4927	241517000.0
2020-05-15 16:00:00	NVDA	Stock	8.4908	8.5058	8.48	8.5	23422360.0
2020-05-15 17:00:00	NVDA	Stock	8.5	8.5	8.4748	8.475	829880.0
2020-05-15 18:00:00	NVDA	Stock	8.475	8.4925	8.475	8.4852	428400.0
2020-05-15 19:00:00	NVDA	Stock	8.48	8.4925	8.48	8.4838	358520.0
2020-05-15 04:00:00	AMZN	Stock	119.6	119.6	119.6	119.6	2060.0
2020-05-15 06:00:00	AMZN	Stock	119.25	119.25	119.25	119.25	4000.0

> showing 50 of 53,987 rows — these rows as CSV

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