PREVIEW / stock_1hour / 2020-03-16

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-03-16.parquet
  size:    1.2 MB
  rows:    56,944
  symbols: 2,457

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-16 04:00:00	AAPL	Stock	63.17	64.075	61.5275	61.55	296372.0
2020-03-16 05:00:00	AAPL	Stock	61.7025	62.25	61.415	62.025	199908.0
2020-03-16 06:00:00	AAPL	Stock	61.93	62.15	61.1025	61.2575	327756.0
2020-03-16 07:00:00	AAPL	Stock	61.275	62.075	60.8175	60.89	1276048.0
2020-03-16 08:00:00	AAPL	Stock	61.25	61.9575	59.63	60.1075	2783080.0
2020-03-16 09:00:00	AAPL	Stock	60.085	63.37	59.89	62.4312	35552576.0
2020-03-16 10:00:00	AAPL	Stock	62.43	64.31	62.0322	63.61	47448824.0
2020-03-16 11:00:00	AAPL	Stock	63.59	64.77	63.39	64.5775	31298980.0
2020-03-16 12:00:00	AAPL	Stock	64.575	64.6025	63.1675	63.3762	19376488.0
2020-03-16 13:00:00	AAPL	Stock	63.3812	63.995	62.6662	62.7678	18924648.0
2020-03-16 14:00:00	AAPL	Stock	62.7575	63.75	62.3975	63.225	30426796.0
2020-03-16 15:00:00	AAPL	Stock	63.2025	63.81	60.0	60.3675	52914864.0
2020-03-16 16:00:00	AAPL	Stock	60.5525	61.775	60.1625	61.415	18578148.0
2020-03-16 17:00:00	AAPL	Stock	61.4025	61.4025	60.8325	61.35	520336.0
2020-03-16 18:00:00	AAPL	Stock	61.325	61.975	60.9025	61.825	2150060.0
2020-03-16 19:00:00	AAPL	Stock	61.8025	62.5	61.8	62.5	405904.0
2020-03-16 04:00:00	MSFT	Stock	147.93	147.93	140.1	140.8	52206.0
2020-03-16 05:00:00	MSFT	Stock	140.66	142.88	139.9	142.0	41887.0
2020-03-16 06:00:00	MSFT	Stock	141.97	142.0	140.6	140.85	20567.0
2020-03-16 07:00:00	MSFT	Stock	140.72	142.6	140.42	140.99	176309.0
2020-03-16 08:00:00	MSFT	Stock	141.0	142.5	138.75	140.3	430335.0
2020-03-16 09:00:00	MSFT	Stock	140.3	144.2	137.49	142.528	8478977.0
2020-03-16 10:00:00	MSFT	Stock	142.51	147.77	141.25	145.64	11261770.0
2020-03-16 11:00:00	MSFT	Stock	145.53	149.35	145.0	146.07	8117635.0
2020-03-16 12:00:00	MSFT	Stock	146.05	146.62	142.455	142.51	5838452.0
2020-03-16 13:00:00	MSFT	Stock	142.5	143.69	140.22	140.78	6141318.0
2020-03-16 14:00:00	MSFT	Stock	140.76	144.48	138.15	142.898	7493935.0
2020-03-16 15:00:00	MSFT	Stock	142.891	144.3	135.0	135.414	16824084.0
2020-03-16 16:00:00	MSFT	Stock	136.57	138.4	135.0	136.9	9110929.0
2020-03-16 17:00:00	MSFT	Stock	136.89	137.1	135.0	136.75	89069.0
2020-03-16 18:00:00	MSFT	Stock	136.8	139.1	136.1	138.75	281459.0
2020-03-16 19:00:00	MSFT	Stock	138.78	139.75	138.67	139.5	73800.0
2020-03-16 04:00:00	NVDA	Stock	5.667	5.667	5.375	5.375	252400.0
2020-03-16 05:00:00	NVDA	Stock	5.371	5.3985	5.3125	5.375	265320.0
2020-03-16 06:00:00	NVDA	Stock	5.339	5.35	5.3255	5.3255	258800.0
2020-03-16 07:00:00	NVDA	Stock	5.3375	5.425	5.3125	5.35	952080.0
2020-03-16 08:00:00	NVDA	Stock	5.3386	5.4248	5.2645	5.2812	2205400.0
2020-03-16 09:00:00	NVDA	Stock	5.2895	5.475	5.195	5.3058	74737000.0
2020-03-16 10:00:00	NVDA	Stock	5.3	5.5362	5.2468	5.454	110481320.0
2020-03-16 11:00:00	NVDA	Stock	5.46	5.6525	5.4421	5.5875	71736520.0
2020-03-16 12:00:00	NVDA	Stock	5.5903	5.6212	5.4578	5.4722	43544600.0
2020-03-16 13:00:00	NVDA	Stock	5.4702	5.4895	5.3138	5.3886	52538440.0
2020-03-16 14:00:00	NVDA	Stock	5.3903	5.3903	5.225	5.2745	100149080.0
2020-03-16 15:00:00	NVDA	Stock	5.279	5.307	4.85	4.9148	139181680.0
2020-03-16 16:00:00	NVDA	Stock	4.91	5.1	4.8502	5.0372	49643800.0
2020-03-16 17:00:00	NVDA	Stock	5.0125	5.0125	4.9625	4.9812	574040.0
2020-03-16 18:00:00	NVDA	Stock	4.9775	5.0972	4.9775	5.0625	2772920.0
2020-03-16 19:00:00	NVDA	Stock	5.068	5.1652	5.068	5.1475	1018520.0
2020-03-16 04:00:00	AMZN	Stock	83.9	83.9	81.75	81.75	74280.0
2020-03-16 05:00:00	AMZN	Stock	81.5	81.895	81.427	81.895	100620.0

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

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