PREVIEW / stock_1hour / 2022-05-06

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-05-06.parquet
  size:    1.4 MB
  rows:    62,591
  symbols: 2,396

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-05-06 04:00:00	AAPL	Stock	157.29	157.3	156.2	156.5	43609.0
2022-05-06 05:00:00	AAPL	Stock	156.65	156.82	156.21	156.82	12031.0
2022-05-06 06:00:00	AAPL	Stock	156.84	157.06	156.21	156.3	43031.0
2022-05-06 07:00:00	AAPL	Stock	156.4	156.44	155.51	156.19	96352.0
2022-05-06 08:00:00	AAPL	Stock	156.1402	157.8	155.58	155.75	982960.0
2022-05-06 09:00:00	AAPL	Stock	155.7	157.08	154.18	154.7	11337374.0
2022-05-06 10:00:00	AAPL	Stock	154.7	159.165	154.58	158.54	20177686.0
2022-05-06 11:00:00	AAPL	Stock	158.53	159.43	157.3	157.51	12600279.0
2022-05-06 12:00:00	AAPL	Stock	157.51	159.44	157.32	159.07	10291493.0
2022-05-06 13:00:00	AAPL	Stock	159.065	159.38	157.25	157.4	7966571.0
2022-05-06 14:00:00	AAPL	Stock	157.3969	157.85	156.23	156.6	8878183.0
2022-05-06 15:00:00	AAPL	Stock	156.58	158.7	155.8	157.35	18192691.0
2022-05-06 16:00:00	AAPL	Stock	157.4	157.47	156.65	157.18	9428223.0
2022-05-06 17:00:00	AAPL	Stock	157.2	157.26	157.1	157.1301	59163.0
2022-05-06 18:00:00	AAPL	Stock	157.18	157.18	156.8	156.85	47481.0
2022-05-06 19:00:00	AAPL	Stock	156.8799	157.21	156.83	157.15	22806.0
2022-05-06 04:00:00	MSFT	Stock	275.8	277.0	275.75	275.75	7468.0
2022-05-06 05:00:00	MSFT	Stock	275.65	276.06	275.15	276.06	3275.0
2022-05-06 06:00:00	MSFT	Stock	276.05	276.25	275.88	276.0	1596.0
2022-05-06 07:00:00	MSFT	Stock	275.93	276.09	274.57	275.5	31449.0
2022-05-06 08:00:00	MSFT	Stock	275.8	278.88	274.5325	274.84	121106.0
2022-05-06 09:00:00	MSFT	Stock	275.4	276.1	271.3603	271.97	2648083.0
2022-05-06 10:00:00	MSFT	Stock	271.99	278.74	271.73	277.79	4481937.0
2022-05-06 11:00:00	MSFT	Stock	277.78	279.25	275.38	275.82	3062205.0
2022-05-06 12:00:00	MSFT	Stock	275.825	278.27	275.415	278.115	2095369.0
2022-05-06 13:00:00	MSFT	Stock	278.17	278.79	274.13	274.28	2000631.0
2022-05-06 14:00:00	MSFT	Stock	274.24	275.28	272.82	273.4092	2426354.0
2022-05-06 15:00:00	MSFT	Stock	273.46	275.56	271.27	274.73	5318977.0
2022-05-06 16:00:00	MSFT	Stock	274.72	274.9	273.5577	274.5012	3777431.0
2022-05-06 17:00:00	MSFT	Stock	274.5	275.0	274.35	274.45	26666.0
2022-05-06 18:00:00	MSFT	Stock	274.43	274.55	274.06	274.55	3481.0
2022-05-06 19:00:00	MSFT	Stock	274.11	274.72	274.0	274.62	8034.0
2022-05-06 04:00:00	NVDA	Stock	18.9	18.9	18.696	18.742	93880.0
2022-05-06 05:00:00	NVDA	Stock	18.715	18.75	18.618	18.732	70030.0
2022-05-06 06:00:00	NVDA	Stock	18.75	18.75	18.65	18.651	107620.0
2022-05-06 07:00:00	NVDA	Stock	18.67	18.686	18.552	18.608	535300.0
2022-05-06 08:00:00	NVDA	Stock	18.59	18.925	18.552	18.595	2253320.0
2022-05-06 09:00:00	NVDA	Stock	18.573	18.819	17.99	18.2945	67927900.0
2022-05-06 10:00:00	NVDA	Stock	18.3	19.198	18.27	19.168	107867860.0
2022-05-06 11:00:00	NVDA	Stock	19.167	19.512	18.732	18.7852	98452580.0
2022-05-06 12:00:00	NVDA	Stock	18.7811	19.182	18.713	19.169	58093810.0
2022-05-06 13:00:00	NVDA	Stock	19.174	19.193	18.7	18.725	43524490.0
2022-05-06 14:00:00	NVDA	Stock	18.725	18.7701	18.51	18.5391	39614900.0
2022-05-06 15:00:00	NVDA	Stock	18.534	18.7745	18.387	18.678	63137460.0
2022-05-06 16:00:00	NVDA	Stock	18.678	18.689	18.55	18.65	24163140.0
2022-05-06 17:00:00	NVDA	Stock	18.65	18.672	18.625	18.641	81620.0
2022-05-06 18:00:00	NVDA	Stock	18.635	18.645	18.63	18.631	69490.0
2022-05-06 19:00:00	NVDA	Stock	18.631	18.649	18.6	18.6	137040.0
2022-05-06 04:00:00	AMZN	Stock	116.499	116.499	116.2	116.394	11980.0
2022-05-06 05:00:00	AMZN	Stock	116.0	116.0	116.0	116.0	2000.0

> showing 50 of 62,591 rows — these rows as CSV

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