PREVIEW / stock_1hour / 2022-03-08

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-03-08.parquet
  size:    1.4 MB
  rows:    65,757
  symbols: 2,537

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-03-08 04:00:00	AAPL	Stock	160.18	160.18	159.38	159.61	47004.0
2022-03-08 05:00:00	AAPL	Stock	159.62	159.8	159.17	159.59	29671.0
2022-03-08 06:00:00	AAPL	Stock	159.6	159.85	159.26	159.68	23648.0
2022-03-08 07:00:00	AAPL	Stock	159.71	160.72	159.06	159.25	174377.0
2022-03-08 08:00:00	AAPL	Stock	159.8999	160.72	157.81	159.0	913430.0
2022-03-08 09:00:00	AAPL	Stock	159.07	160.32	158.41	159.25	13317535.0
2022-03-08 10:00:00	AAPL	Stock	159.24	159.26	156.0504	157.99	17247400.0
2022-03-08 11:00:00	AAPL	Stock	157.99	158.38	155.8	156.91	12157865.0
2022-03-08 12:00:00	AAPL	Stock	156.905	162.16	156.845	161.75	17069125.0
2022-03-08 13:00:00	AAPL	Stock	161.76	162.88	158.6	158.61	13827597.0
2022-03-08 14:00:00	AAPL	Stock	158.62	160.01	157.83	159.44	11654901.0
2022-03-08 15:00:00	AAPL	Stock	159.44	160.5	157.1066	157.28	15788812.0
2022-03-08 16:00:00	AAPL	Stock	157.36	158.79	156.44	156.66	10047472.0
2022-03-08 17:00:00	AAPL	Stock	156.65	156.69	156.5	156.55	85682.0
2022-03-08 18:00:00	AAPL	Stock	156.55	157.16	156.46	157.1	64924.0
2022-03-08 19:00:00	AAPL	Stock	157.1	157.8	157.1	157.68	87223.0
2022-03-08 04:00:00	MSFT	Stock	279.0	279.95	278.4	279.48	12194.0
2022-03-08 05:00:00	MSFT	Stock	279.5	279.78	278.25	278.41	5254.0
2022-03-08 06:00:00	MSFT	Stock	278.99	279.38	278.0	279.3	4198.0
2022-03-08 07:00:00	MSFT	Stock	279.6	280.92	278.5	279.16	37388.0
2022-03-08 08:00:00	MSFT	Stock	280.1	280.9655	274.59	278.61	69074.0
2022-03-08 09:00:00	MSFT	Stock	278.77	280.3	275.1108	275.33	3917331.0
2022-03-08 10:00:00	MSFT	Stock	275.36	275.67	270.62	275.1816	5715306.0
2022-03-08 11:00:00	MSFT	Stock	275.18	275.59	270.0	273.0	5320565.0
2022-03-08 12:00:00	MSFT	Stock	273.0	283.17	272.97	282.91	5671823.0
2022-03-08 13:00:00	MSFT	Stock	282.93	283.96	277.0209	277.07	3161750.0
2022-03-08 14:00:00	MSFT	Stock	277.1	280.48	275.71	278.98	2827138.0
2022-03-08 15:00:00	MSFT	Stock	278.94	280.9	275.52	275.65	3982588.0
2022-03-08 16:00:00	MSFT	Stock	275.85	276.07	273.73	274.4634	4502790.0
2022-03-08 17:00:00	MSFT	Stock	273.8376	274.5999	273.8376	274.2	8268.0
2022-03-08 18:00:00	MSFT	Stock	274.02	275.74	274.02	275.49	20299.0
2022-03-08 19:00:00	MSFT	Stock	275.29	275.97	275.21	275.85	19103.0
2022-03-08 04:00:00	NVDA	Stock	21.32	21.48	21.301	21.39	223740.0
2022-03-08 05:00:00	NVDA	Stock	21.389	21.4	21.239	21.359	86180.0
2022-03-08 06:00:00	NVDA	Stock	21.3	21.388	21.255	21.351	96010.0
2022-03-08 07:00:00	NVDA	Stock	21.35	21.495	21.242	21.3	484160.0
2022-03-08 08:00:00	NVDA	Stock	21.42	21.499	20.898	21.233	1320960.0
2022-03-08 09:00:00	NVDA	Stock	21.216	21.488	20.951	21.071	56645430.0
2022-03-08 10:00:00	NVDA	Stock	21.0821	21.5978	20.65	21.596	74846060.0
2022-03-08 11:00:00	NVDA	Stock	21.599	21.72	21.02	21.319	53997570.0
2022-03-08 12:00:00	NVDA	Stock	21.3135	22.237	21.283	22.1278	71115400.0
2022-03-08 13:00:00	NVDA	Stock	22.132	22.373	21.726	21.736	50047620.0
2022-03-08 14:00:00	NVDA	Stock	21.7355	22.05	21.555	21.873	39612160.0
2022-03-08 15:00:00	NVDA	Stock	21.876	22.1118	21.481	21.51	51171940.0
2022-03-08 16:00:00	NVDA	Stock	21.514	21.5539	21.1869	21.33	26364190.0
2022-03-08 17:00:00	NVDA	Stock	21.33	21.367	21.2629	21.367	311960.0
2022-03-08 18:00:00	NVDA	Stock	21.345	21.45	21.345	21.439	301960.0
2022-03-08 19:00:00	NVDA	Stock	21.442	21.65	21.43	21.65	461380.0
2022-03-08 05:00:00	AMZN	Stock	137.198	137.2495	137.198	137.198	11000.0
2022-03-08 07:00:00	AMZN	Stock	137.4495	138.3	136.949	136.949	57900.0

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

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