PREVIEW / stock_1hour / 2021-07-13

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-07-13.parquet
  size:    1.4 MB
  rows:    65,259
  symbols: 2,891

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-07-13 04:00:00	AAPL	Stock	144.0	144.42	143.86	144.41	24855.0
2021-07-13 05:00:00	AAPL	Stock	144.47	144.8	144.4	144.8	11206.0
2021-07-13 06:00:00	AAPL	Stock	144.8	144.85	144.57	144.7	19510.0
2021-07-13 07:00:00	AAPL	Stock	144.71	144.99	144.7	144.87	78957.0
2021-07-13 08:00:00	AAPL	Stock	144.8701	145.0	143.55	143.6	700605.0
2021-07-13 09:00:00	AAPL	Stock	143.6	146.51	143.39	146.345	15000476.0
2021-07-13 10:00:00	AAPL	Stock	146.35	146.96	146.0	146.52	15133541.0
2021-07-13 11:00:00	AAPL	Stock	146.525	147.46	146.51	147.45	11163349.0
2021-07-13 12:00:00	AAPL	Stock	147.44	147.46	147.01	147.21	6293886.0
2021-07-13 13:00:00	AAPL	Stock	147.21	147.21	145.3	145.7301	13024482.0
2021-07-13 14:00:00	AAPL	Stock	145.73	146.07	144.62	146.065	11442771.0
2021-07-13 15:00:00	AAPL	Stock	146.0699	146.08	145.3401	145.68	12406921.0
2021-07-13 16:00:00	AAPL	Stock	145.68	146.0745	145.5	145.58	4569186.0
2021-07-13 17:00:00	AAPL	Stock	145.57	145.68	145.55	145.65	62303.0
2021-07-13 18:00:00	AAPL	Stock	145.67	145.76	145.64	145.7	35978.0
2021-07-13 19:00:00	AAPL	Stock	145.72	145.75	145.4	145.45	80914.0
2021-07-13 04:00:00	MSFT	Stock	277.13	277.7	277.13	277.7	1292.0
2021-07-13 05:00:00	MSFT	Stock	278.2	278.5	278.18	278.5	7123.0
2021-07-13 06:00:00	MSFT	Stock	278.48	278.62	278.4	278.5	930.0
2021-07-13 07:00:00	MSFT	Stock	278.31	278.55	278.2	278.2	24294.0
2021-07-13 08:00:00	MSFT	Stock	278.35	278.45	276.55	276.6	73662.0
2021-07-13 09:00:00	MSFT	Stock	276.63	280.57	276.55	280.46	2200987.0
2021-07-13 10:00:00	MSFT	Stock	280.5	282.62	280.48	281.85	3842194.0
2021-07-13 11:00:00	MSFT	Stock	281.865	282.8477	281.67	282.4301	2680437.0
2021-07-13 12:00:00	MSFT	Stock	282.4399	282.48	281.81	282.01	1641588.0
2021-07-13 13:00:00	MSFT	Stock	282.005	282.04	279.92	280.36	2247989.0
2021-07-13 14:00:00	MSFT	Stock	280.36	281.17	279.58	281.1584	1887634.0
2021-07-13 15:00:00	MSFT	Stock	281.16	281.38	280.39	280.98	3228283.0
2021-07-13 16:00:00	MSFT	Stock	280.98	281.13	280.74	280.98	2991449.0
2021-07-13 17:00:00	MSFT	Stock	280.98	280.98	280.9	280.92	2047.0
2021-07-13 18:00:00	MSFT	Stock	280.96	281.13	280.91	280.91	5252.0
2021-07-13 19:00:00	MSFT	Stock	281.08	281.12	280.7	280.9	5555.0
2021-07-13 04:00:00	NVDA	Stock	20.5	20.5713	20.5	20.5713	37840.0
2021-07-13 05:00:00	NVDA	Stock	20.5748	20.575	20.5748	20.575	9960.0
2021-07-13 06:00:00	NVDA	Stock	20.6068	20.6245	20.6003	20.6065	71160.0
2021-07-13 07:00:00	NVDA	Stock	20.6065	20.6248	20.587	20.5888	738600.0
2021-07-13 08:00:00	NVDA	Stock	20.6245	20.6248	20.375	20.376	2822360.0
2021-07-13 09:00:00	NVDA	Stock	20.3825	20.4613	20.206	20.328	33781960.0
2021-07-13 10:00:00	NVDA	Stock	20.3333	20.4548	20.3165	20.4018	30864840.0
2021-07-13 11:00:00	NVDA	Stock	20.4015	20.4326	20.3258	20.4065	16035080.0
2021-07-13 12:00:00	NVDA	Stock	20.4066	20.425	20.3525	20.3702	10978440.0
2021-07-13 13:00:00	NVDA	Stock	20.37	20.3818	20.1388	20.213	21277400.0
2021-07-13 14:00:00	NVDA	Stock	20.2035	20.305	20.114	20.298	19434280.0
2021-07-13 15:00:00	NVDA	Stock	20.3025	20.3025	20.1913	20.2412	21142640.0
2021-07-13 16:00:00	NVDA	Stock	20.25	20.3115	20.2262	20.237	13127880.0
2021-07-13 17:00:00	NVDA	Stock	20.2373	20.2438	20.23	20.2375	244000.0
2021-07-13 18:00:00	NVDA	Stock	20.2415	20.2415	20.2375	20.2375	65440.0
2021-07-13 19:00:00	NVDA	Stock	20.23	20.2463	20.1878	20.1878	194360.0
2021-07-13 05:00:00	AMZN	Stock	186.4275	186.4275	186.4275	186.4275	2000.0
2021-07-13 07:00:00	AMZN	Stock	186.35	186.35	186.3	186.3	40420.0

> showing 50 of 65,259 rows — these rows as CSV

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