PREVIEW / stock_1hour / 2022-10-11

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-10-11.parquet
  size:    1.3 MB
  rows:    60,897
  symbols: 2,201

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
2022-10-11 04:00:00	AAPL	Stock	139.69	140.03	139.04	139.13	35352.0
2022-10-11 05:00:00	AAPL	Stock	139.17	139.46	139.06	139.31	20054.0
2022-10-11 06:00:00	AAPL	Stock	139.17	139.63	139.0	139.62	38845.0
2022-10-11 07:00:00	AAPL	Stock	139.62	140.05	139.48	139.86	96116.0
2022-10-11 08:00:00	AAPL	Stock	139.7	140.58	139.0115	140.06	262728.0
2022-10-11 09:00:00	AAPL	Stock	140.03	140.0702	138.8401	138.88	8733251.0
2022-10-11 10:00:00	AAPL	Stock	138.88	139.83	138.36	139.0612	10409821.0
2022-10-11 11:00:00	AAPL	Stock	139.07	140.78	139.0214	140.3809	8274409.0
2022-10-11 12:00:00	AAPL	Stock	140.405	141.35	140.01	140.7776	7032886.0
2022-10-11 13:00:00	AAPL	Stock	140.78	140.93	139.83	140.44	6082511.0
2022-10-11 14:00:00	AAPL	Stock	140.44	140.55	138.52	138.65	7729444.0
2022-10-11 15:00:00	AAPL	Stock	138.655	139.25	138.22	138.95	13179371.0
2022-10-11 16:00:00	AAPL	Stock	138.95	139.34	138.71	139.25	6628413.0
2022-10-11 17:00:00	AAPL	Stock	139.23	139.25	139.07	139.15	19594.0
2022-10-11 18:00:00	AAPL	Stock	139.15	139.33	139.03	139.11	28648.0
2022-10-11 19:00:00	AAPL	Stock	139.11	139.24	139.0	139.24	28800.0
2022-10-11 04:00:00	MSFT	Stock	228.98	228.98	226.79	226.79	2522.0
2022-10-11 05:00:00	MSFT	Stock	227.43	227.53	226.81	227.0	6000.0
2022-10-11 06:00:00	MSFT	Stock	227.1	228.0	227.0	228.0	8255.0
2022-10-11 07:00:00	MSFT	Stock	227.99	228.45	227.9	228.1	6646.0
2022-10-11 08:00:00	MSFT	Stock	228.2	229.45	227.79	228.64	42993.0
2022-10-11 09:00:00	MSFT	Stock	228.7	228.9	225.21	225.44	2755221.0
2022-10-11 10:00:00	MSFT	Stock	225.41	227.12	224.92	225.82	3538766.0
2022-10-11 11:00:00	MSFT	Stock	225.84	229.03	225.56	228.09	2634842.0
2022-10-11 12:00:00	MSFT	Stock	228.11	229.06	227.19	228.28	1846384.0
2022-10-11 13:00:00	MSFT	Stock	228.29	228.45	227.15	228.295	1604070.0
2022-10-11 14:00:00	MSFT	Stock	228.29	228.5	224.82	225.0	2322542.0
2022-10-11 15:00:00	MSFT	Stock	225.01	225.97	224.11	225.46	4409593.0
2022-10-11 16:00:00	MSFT	Stock	225.41	225.98	225.23	225.6	3448830.0
2022-10-11 17:00:00	MSFT	Stock	225.67	225.74	225.49	225.58	15683.0
2022-10-11 18:00:00	MSFT	Stock	225.58	225.72	225.09	225.6	14357.0
2022-10-11 19:00:00	MSFT	Stock	225.61	225.7	225.21	225.7	5916.0
2022-10-11 04:00:00	NVDA	Stock	11.586	11.586	11.46	11.47	150940.0
2022-10-11 05:00:00	NVDA	Stock	11.466	11.507	11.463	11.489	161040.0
2022-10-11 06:00:00	NVDA	Stock	11.461	11.5	11.459	11.497	313370.0
2022-10-11 07:00:00	NVDA	Stock	11.48	11.565	11.479	11.55	298650.0
2022-10-11 08:00:00	NVDA	Stock	11.4842	11.6409	11.479	11.5795	1662150.0
2022-10-11 09:00:00	NVDA	Stock	11.58	11.692	11.372	11.374	68091200.0
2022-10-11 10:00:00	NVDA	Stock	11.375	11.5344	11.283	11.3471	96485680.0
2022-10-11 11:00:00	NVDA	Stock	11.346	11.761	11.343	11.685	88442210.0
2022-10-11 12:00:00	NVDA	Stock	11.684	11.846	11.582	11.761	73431960.0
2022-10-11 13:00:00	NVDA	Stock	11.761	11.838	11.654	11.742	59210140.0
2022-10-11 14:00:00	NVDA	Stock	11.743	11.768	11.487	11.502	55319420.0
2022-10-11 15:00:00	NVDA	Stock	11.5015	11.606	11.412	11.586	83380050.0
2022-10-11 16:00:00	NVDA	Stock	11.586	11.621	11.569	11.61	32000300.0
2022-10-11 17:00:00	NVDA	Stock	11.62	11.62	11.575	11.591	386770.0
2022-10-11 18:00:00	NVDA	Stock	11.595	11.609	11.586	11.605	311770.0
2022-10-11 19:00:00	NVDA	Stock	11.606	11.634	11.587	11.6299	250420.0
2022-10-11 04:00:00	AMZN	Stock	113.18	113.27	112.51	112.59	7671.0
2022-10-11 05:00:00	AMZN	Stock	112.7	112.88	112.4	112.8	8673.0

> showing 50 of 60,897 rows — these rows as CSV

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