PREVIEW / stock_1hour / 2021-05-20

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-05-20.parquet
  size:    1.4 MB
  rows:    63,528
  symbols: 2,972

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
2021-05-20 04:00:00	AAPL	Stock	124.91	124.91	124.25	124.26	10402.0
2021-05-20 05:00:00	AAPL	Stock	124.24	124.4	124.09	124.28	12450.0
2021-05-20 06:00:00	AAPL	Stock	124.33	124.87	124.32	124.87	14287.0
2021-05-20 07:00:00	AAPL	Stock	124.76	125.22	124.7	125.03	129386.0
2021-05-20 08:00:00	AAPL	Stock	124.818	125.55	124.71	125.55	338541.0
2021-05-20 09:00:00	AAPL	Stock	125.55	126.22	125.1	125.84	9356908.0
2021-05-20 10:00:00	AAPL	Stock	125.835	126.47	125.76	126.36	8473874.0
2021-05-20 11:00:00	AAPL	Stock	126.36	127.265	126.28	127.045	8918809.0
2021-05-20 12:00:00	AAPL	Stock	127.05	127.07	126.67	126.97	7130477.0
2021-05-20 13:00:00	AAPL	Stock	126.97	127.37	126.895	127.155	5547963.0
2021-05-20 14:00:00	AAPL	Stock	127.16	127.6	127.09	127.53	5534744.0
2021-05-20 15:00:00	AAPL	Stock	127.53	127.72	127.2	127.31	10606373.0
2021-05-20 16:00:00	AAPL	Stock	127.31	127.49	127.26	127.42	8497700.0
2021-05-20 17:00:00	AAPL	Stock	127.36	127.43	127.35	127.43	44554.0
2021-05-20 18:00:00	AAPL	Stock	127.41	127.43	127.36	127.38	37969.0
2021-05-20 19:00:00	AAPL	Stock	127.39	127.55	127.36	127.55	63101.0
2021-05-20 04:00:00	MSFT	Stock	243.39	243.39	242.5	242.5	2354.0
2021-05-20 05:00:00	MSFT	Stock	242.43	242.45	241.5	241.57	1697.0
2021-05-20 06:00:00	MSFT	Stock	241.81	242.45	241.7	242.25	3161.0
2021-05-20 07:00:00	MSFT	Stock	242.85	243.35	242.45	242.91	21770.0
2021-05-20 08:00:00	MSFT	Stock	242.46	243.85	242.46	243.75	24576.0
2021-05-20 09:00:00	MSFT	Stock	243.73	246.45	243.5	245.53	2207932.0
2021-05-20 10:00:00	MSFT	Stock	245.535	246.96	245.52	246.3901	2052901.0
2021-05-20 11:00:00	MSFT	Stock	246.41	247.95	245.99	247.35	2125347.0
2021-05-20 12:00:00	MSFT	Stock	247.36	247.3852	246.4	246.9	1766661.0
2021-05-20 13:00:00	MSFT	Stock	246.9	247.52	246.81	247.3	1038657.0
2021-05-20 14:00:00	MSFT	Stock	247.32	247.53	246.84	247.05	1200685.0
2021-05-20 15:00:00	MSFT	Stock	247.06	247.45	246.14	246.48	2454367.0
2021-05-20 16:00:00	MSFT	Stock	246.48	246.51	246.1	246.41	4689644.0
2021-05-20 17:00:00	MSFT	Stock	246.41	246.58	246.4	246.51	8193.0
2021-05-20 18:00:00	MSFT	Stock	246.49	246.79	246.49	246.6	4342.0
2021-05-20 19:00:00	MSFT	Stock	246.6	246.89	246.6	246.89	3377.0
2021-05-20 04:00:00	NVDA	Stock	14.0025	14.0025	14.0	14.0	53280.0
2021-05-20 05:00:00	NVDA	Stock	14.0402	14.1652	14.0402	14.1652	161640.0
2021-05-20 06:00:00	NVDA	Stock	14.1748	14.1998	14.1625	14.1998	79840.0
2021-05-20 07:00:00	NVDA	Stock	14.2038	14.2375	14.2	14.2008	489440.0
2021-05-20 08:00:00	NVDA	Stock	14.2325	14.2984	14.1009	14.2875	710480.0
2021-05-20 09:00:00	NVDA	Stock	14.2865	14.489	14.27	14.3953	38755320.0
2021-05-20 10:00:00	NVDA	Stock	14.3963	14.5675	14.3882	14.5075	31001120.0
2021-05-20 11:00:00	NVDA	Stock	14.5118	14.6062	14.5001	14.5834	24061440.0
2021-05-20 12:00:00	NVDA	Stock	14.5865	14.5868	14.4774	14.5438	18772520.0
2021-05-20 13:00:00	NVDA	Stock	14.5428	14.616	14.5333	14.5814	16680120.0
2021-05-20 14:00:00	NVDA	Stock	14.5822	14.6475	14.56	14.638	18904360.0
2021-05-20 15:00:00	NVDA	Stock	14.641	14.6838	14.6032	14.6125	32146520.0
2021-05-20 16:00:00	NVDA	Stock	14.6125	14.65	14.6028	14.613	20332320.0
2021-05-20 17:00:00	NVDA	Stock	14.6145	14.6325	14.6145	14.625	128040.0
2021-05-20 18:00:00	NVDA	Stock	14.6262	14.665	14.6262	14.66	276040.0
2021-05-20 19:00:00	NVDA	Stock	14.66	14.6625	14.6523	14.6562	235120.0
2021-05-20 05:00:00	AMZN	Stock	160.9425	160.9425	160.9425	160.9425	3620.0
2021-05-20 07:00:00	AMZN	Stock	161.35	161.772	161.35	161.7435	11800.0

> showing 50 of 63,528 rows — these rows as CSV

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