PREVIEW / stock_1hour / 2022-04-27

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-04-27.parquet
  size:    1.4 MB
  rows:    63,626
  symbols: 2,510

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-04-27 04:00:00	AAPL	Stock	157.2	158.4	156.69	157.8	80597.0
2022-04-27 05:00:00	AAPL	Stock	157.85	157.87	157.52	157.87	34575.0
2022-04-27 06:00:00	AAPL	Stock	157.91	158.12	157.5	157.91	38159.0
2022-04-27 07:00:00	AAPL	Stock	157.84	158.0	156.09	156.51	248806.0
2022-04-27 08:00:00	AAPL	Stock	157.5	158.0	156.02	156.09	430325.0
2022-04-27 09:00:00	AAPL	Stock	156.14	158.9293	155.1	158.091	9585050.0
2022-04-27 10:00:00	AAPL	Stock	158.1022	158.39	155.38	157.3506	12005152.0
2022-04-27 11:00:00	AAPL	Stock	157.37	158.6699	157.3375	157.62	9451920.0
2022-04-27 12:00:00	AAPL	Stock	157.64	159.79	157.0	159.0447	7507225.0
2022-04-27 13:00:00	AAPL	Stock	159.05	159.1081	157.981	158.95	6333968.0
2022-04-27 14:00:00	AAPL	Stock	158.945	159.0	156.5	156.75	6593389.0
2022-04-27 15:00:00	AAPL	Stock	156.7564	157.39	156.17	156.6	13152133.0
2022-04-27 16:00:00	AAPL	Stock	156.52	158.7	156.4	158.4	6598669.0
2022-04-27 17:00:00	AAPL	Stock	158.58	159.4	158.25	159.08	264480.0
2022-04-27 18:00:00	AAPL	Stock	159.06	159.1	158.51	158.61	111951.0
2022-04-27 19:00:00	AAPL	Stock	158.55	158.95	158.5	158.77	74506.0
2022-04-27 04:00:00	MSFT	Stock	284.67	285.54	283.0	284.77	63544.0
2022-04-27 05:00:00	MSFT	Stock	284.35	285.29	283.98	284.85	20911.0
2022-04-27 06:00:00	MSFT	Stock	284.83	285.05	283.51	284.73	30998.0
2022-04-27 07:00:00	MSFT	Stock	284.7	284.9	279.05	279.73	222605.0
2022-04-27 08:00:00	MSFT	Stock	282.5812	285.0	278.57	281.4	346657.0
2022-04-27 09:00:00	MSFT	Stock	281.5	286.49	279.6	285.04	8475544.0
2022-04-27 10:00:00	MSFT	Stock	285.09	287.2	279.16	285.62	9420035.0
2022-04-27 11:00:00	MSFT	Stock	285.615	289.14	285.497	286.055	6358872.0
2022-04-27 12:00:00	MSFT	Stock	286.085	290.97	284.94	288.93	5023704.0
2022-04-27 13:00:00	MSFT	Stock	288.99	289.8	286.72	289.33	3347089.0
2022-04-27 14:00:00	MSFT	Stock	289.3	289.39	285.49	285.802	2821536.0
2022-04-27 15:00:00	MSFT	Stock	285.81	286.2099	282.55	283.08	6448931.0
2022-04-27 16:00:00	MSFT	Stock	283.3	286.77	283.22	285.62	4078935.0
2022-04-27 17:00:00	MSFT	Stock	285.81	286.67	285.25	286.5	62373.0
2022-04-27 18:00:00	MSFT	Stock	286.5	286.5	285.0	285.0	70502.0
2022-04-27 19:00:00	MSFT	Stock	285.18	285.88	285.03	285.65	23071.0
2022-04-27 04:00:00	NVDA	Stock	18.72	19.07	18.72	18.91	455430.0
2022-04-27 05:00:00	NVDA	Stock	18.9	18.932	18.88	18.91	51150.0
2022-04-27 06:00:00	NVDA	Stock	18.91	18.934	18.85	18.925	66190.0
2022-04-27 07:00:00	NVDA	Stock	18.92	18.92	18.61	18.635	578670.0
2022-04-27 08:00:00	NVDA	Stock	18.8061	18.938	18.551	18.6514	1314070.0
2022-04-27 09:00:00	NVDA	Stock	18.66	19.167	18.525	18.951	57218950.0
2022-04-27 10:00:00	NVDA	Stock	18.968	19.118	18.29	18.454	85211630.0
2022-04-27 11:00:00	NVDA	Stock	18.46	18.768	18.452	18.5695	54132130.0
2022-04-27 12:00:00	NVDA	Stock	18.5661	18.906	18.467	18.8405	45788160.0
2022-04-27 13:00:00	NVDA	Stock	18.84	18.864	18.506	18.655	40050610.0
2022-04-27 14:00:00	NVDA	Stock	18.6415	18.754	18.452	18.493	31937690.0
2022-04-27 15:00:00	NVDA	Stock	18.493	18.527	18.338	18.41	49594550.0
2022-04-27 16:00:00	NVDA	Stock	18.415	18.803	18.35	18.762	20287460.0
2022-04-27 17:00:00	NVDA	Stock	18.773	18.877	18.74	18.825	1072770.0
2022-04-27 18:00:00	NVDA	Stock	18.825	18.836	18.7	18.791	396690.0
2022-04-27 19:00:00	NVDA	Stock	18.785	18.83	18.757	18.83	379900.0
2022-04-27 04:00:00	AMZN	Stock	141.09	141.75	141.0845	141.4215	33260.0
2022-04-27 05:00:00	AMZN	Stock	141.5215	141.5215	141.5065	141.5065	6000.0

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

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