PREVIEW / stock_1hour / 2022-04-26

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-04-26.parquet
  size:    1.4 MB
  rows:    63,348
  symbols: 2,435

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-26 04:00:00	AAPL	Stock	162.46	162.85	161.88	162.85	20069.0
2022-04-26 05:00:00	AAPL	Stock	162.86	163.0	162.52	162.73	10770.0
2022-04-26 06:00:00	AAPL	Stock	162.75	162.75	162.23	162.23	11648.0
2022-04-26 07:00:00	AAPL	Stock	162.39	162.54	162.06	162.44	62913.0
2022-04-26 08:00:00	AAPL	Stock	162.11	163.77	162.01	162.27	367192.0
2022-04-26 09:00:00	AAPL	Stock	162.27	162.88	160.14	160.6579	8456378.0
2022-04-26 10:00:00	AAPL	Stock	160.65	160.82	158.71	158.71	12435047.0
2022-04-26 11:00:00	AAPL	Stock	158.7	159.3999	158.07	158.19	9588065.0
2022-04-26 12:00:00	AAPL	Stock	158.2	159.92	158.17	159.63	7250966.0
2022-04-26 13:00:00	AAPL	Stock	159.63	159.65	158.33	158.4185	6329943.0
2022-04-26 14:00:00	AAPL	Stock	158.41	159.03	158.13	158.9	7367259.0
2022-04-26 15:00:00	AAPL	Stock	158.91	159.14	156.72	156.72	18628686.0
2022-04-26 16:00:00	AAPL	Stock	156.795	157.4	153.85	154.15	10634648.0
2022-04-26 17:00:00	AAPL	Stock	154.15	155.41	154.0	155.41	271814.0
2022-04-26 18:00:00	AAPL	Stock	155.43	156.92	155.15	155.7	409208.0
2022-04-26 19:00:00	AAPL	Stock	155.76	156.24	155.7	156.12	170176.0
2022-04-26 04:00:00	MSFT	Stock	280.45	280.7	279.07	280.06	4899.0
2022-04-26 05:00:00	MSFT	Stock	280.7	280.84	280.3	280.7	5071.0
2022-04-26 06:00:00	MSFT	Stock	280.21	280.21	279.58	279.8	3585.0
2022-04-26 07:00:00	MSFT	Stock	280.0	280.25	279.4	279.84	14539.0
2022-04-26 08:00:00	MSFT	Stock	279.8	282.53	278.86	279.15	68390.0
2022-04-26 09:00:00	MSFT	Stock	279.2	279.2	275.0	275.2	3085086.0
2022-04-26 10:00:00	MSFT	Stock	275.18	276.48	273.0501	273.065	3244701.0
2022-04-26 11:00:00	MSFT	Stock	273.05	273.46	272.0	272.24	2714825.0
2022-04-26 12:00:00	MSFT	Stock	272.27	275.24	272.27	274.755	2563738.0
2022-04-26 13:00:00	MSFT	Stock	274.75	274.77	272.55	273.08	2090060.0
2022-04-26 14:00:00	MSFT	Stock	273.06	274.03	272.37	273.85	2713009.0
2022-04-26 15:00:00	MSFT	Stock	273.85	274.54	270.0	270.22	6497351.0
2022-04-26 16:00:00	MSFT	Stock	270.22	276.423	259.5	268.0	6635793.0
2022-04-26 17:00:00	MSFT	Stock	268.0	277.0	265.0	276.94	920688.0
2022-04-26 18:00:00	MSFT	Stock	276.97	289.0	276.5	282.3	1646592.0
2022-04-26 19:00:00	MSFT	Stock	282.28	283.5	281.25	282.3	269022.0
2022-04-26 04:00:00	NVDA	Stock	19.902	19.95	19.743	19.932	88130.0
2022-04-26 05:00:00	NVDA	Stock	19.93	19.94	19.863	19.9	55230.0
2022-04-26 06:00:00	NVDA	Stock	19.914	19.922	19.836	19.836	86550.0
2022-04-26 07:00:00	NVDA	Stock	19.865	19.89	19.8	19.86	165000.0
2022-04-26 08:00:00	NVDA	Stock	19.825	19.9	19.75	19.82	716080.0
2022-04-26 09:00:00	NVDA	Stock	19.8374	19.8374	19.052	19.1404	60460390.0
2022-04-26 10:00:00	NVDA	Stock	19.134	19.1425	18.79	18.8565	94817410.0
2022-04-26 11:00:00	NVDA	Stock	18.853	18.94	18.67	18.8241	71286230.0
2022-04-26 12:00:00	NVDA	Stock	18.828	19.233	18.828	19.2176	72250360.0
2022-04-26 13:00:00	NVDA	Stock	19.2185	19.228	18.927	18.9975	41836220.0
2022-04-26 14:00:00	NVDA	Stock	19.0	19.215	18.933	19.1475	56458230.0
2022-04-26 15:00:00	NVDA	Stock	19.15	19.189	18.783	18.783	72859940.0
2022-04-26 16:00:00	NVDA	Stock	18.784	18.793	18.156	18.236	31513360.0
2022-04-26 17:00:00	NVDA	Stock	18.247	18.788	18.21	18.4878	1729590.0
2022-04-26 18:00:00	NVDA	Stock	18.479	18.723	18.41	18.588	1598180.0
2022-04-26 19:00:00	NVDA	Stock	18.6	18.688	18.58	18.68	500290.0
2022-04-26 08:00:00	AMZN	Stock	145.3042	145.75	145.1	145.4	21380.0
2022-04-26 09:00:00	AMZN	Stock	145.35	145.3816	141.4505	141.711	3941020.0

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

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