PREVIEW / stock_1hour / 2022-04-28

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-04-28.parquet
  size:    1.4 MB
  rows:    63,965
  symbols: 2,498

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-28 04:00:00	AAPL	Stock	159.31	160.87	159.12	160.8	89653.0
2022-04-28 05:00:00	AAPL	Stock	160.8	160.89	159.95	160.05	23798.0
2022-04-28 06:00:00	AAPL	Stock	160.05	160.5	159.72	159.96	32026.0
2022-04-28 07:00:00	AAPL	Stock	160.12	160.9	160.0	160.2	161094.0
2022-04-28 08:00:00	AAPL	Stock	160.1999	160.9	158.8012	159.38	1005375.0
2022-04-28 09:00:00	AAPL	Stock	159.38	161.11	159.05	159.71	10982319.0
2022-04-28 10:00:00	AAPL	Stock	159.715	161.3238	158.93	160.72	14383747.0
2022-04-28 11:00:00	AAPL	Stock	160.73	162.51	160.07	160.51	12749220.0
2022-04-28 12:00:00	AAPL	Stock	160.5	163.27	160.47	162.7692	9461876.0
2022-04-28 13:00:00	AAPL	Stock	162.77	163.99	162.49	163.65	9453229.0
2022-04-28 14:00:00	AAPL	Stock	163.65	163.9	162.88	163.355	8899431.0
2022-04-28 15:00:00	AAPL	Stock	163.35	164.515	162.55	164.01	18134269.0
2022-04-28 16:00:00	AAPL	Stock	164.01	169.99	160.2	163.77	13597261.0
2022-04-28 17:00:00	AAPL	Stock	163.95	165.0	153.5	157.15	5669451.0
2022-04-28 18:00:00	AAPL	Stock	157.15	160.44	156.65	160.38	1756855.0
2022-04-28 19:00:00	AAPL	Stock	160.2	160.5	159.8	160.01	572152.0
2022-04-28 04:00:00	MSFT	Stock	287.06	288.2	286.7	288.2	23022.0
2022-04-28 05:00:00	MSFT	Stock	288.0	288.02	287.4	287.4	1809.0
2022-04-28 06:00:00	MSFT	Stock	287.5	287.54	287.03	287.16	3060.0
2022-04-28 07:00:00	MSFT	Stock	287.0	288.25	287.0	287.0	32981.0
2022-04-28 08:00:00	MSFT	Stock	287.5	288.2977	284.8001	285.64	122373.0
2022-04-28 09:00:00	MSFT	Stock	285.85	287.61	281.4562	282.86	2952567.0
2022-04-28 10:00:00	MSFT	Stock	282.79	285.75	281.7001	282.985	3665805.0
2022-04-28 11:00:00	MSFT	Stock	282.99	285.61	282.41	283.595	2308994.0
2022-04-28 12:00:00	MSFT	Stock	283.59	288.09	282.92	288.0715	2125057.0
2022-04-28 13:00:00	MSFT	Stock	288.1535	289.62	287.89	289.21	2223621.0
2022-04-28 14:00:00	MSFT	Stock	289.21	290.8599	288.59	290.615	2055207.0
2022-04-28 15:00:00	MSFT	Stock	290.56	290.98	288.79	289.72	4023160.0
2022-04-28 16:00:00	MSFT	Stock	289.73	290.85	287.31	288.08	3883541.0
2022-04-28 17:00:00	MSFT	Stock	288.5478	289.63	286.0	287.81	424622.0
2022-04-28 18:00:00	MSFT	Stock	288.2	289.75	288.1	288.6	68297.0
2022-04-28 19:00:00	MSFT	Stock	288.5	289.0	288.27	288.7999	17112.0
2022-04-28 04:00:00	NVDA	Stock	18.9	19.117	18.9	19.1	241630.0
2022-04-28 05:00:00	NVDA	Stock	19.121	19.121	19.0	19.023	134330.0
2022-04-28 06:00:00	NVDA	Stock	19.003	19.07	18.975	19.04	73250.0
2022-04-28 07:00:00	NVDA	Stock	19.027	19.077	18.93	18.945	376270.0
2022-04-28 08:00:00	NVDA	Stock	19.05	19.085	18.8	18.87	1730840.0
2022-04-28 09:00:00	NVDA	Stock	18.85	19.313	18.766	18.881	57114210.0
2022-04-28 10:00:00	NVDA	Stock	18.866	18.946	18.4896	18.6606	52691810.0
2022-04-28 11:00:00	NVDA	Stock	18.6633	19.104	18.625	18.862	59719650.0
2022-04-28 12:00:00	NVDA	Stock	18.864	19.543	18.772	19.468	69556950.0
2022-04-28 13:00:00	NVDA	Stock	19.4679	19.843	19.467	19.835	62548970.0
2022-04-28 14:00:00	NVDA	Stock	19.831	19.957	19.682	19.863	41128260.0
2022-04-28 15:00:00	NVDA	Stock	19.86	20.037	19.6817	19.786	73963830.0
2022-04-28 16:00:00	NVDA	Stock	19.788	19.788	19.399	19.407	26412870.0
2022-04-28 17:00:00	NVDA	Stock	19.4053	19.782	18.952	19.199	6549000.0
2022-04-28 18:00:00	NVDA	Stock	19.155	19.395	19.122	19.326	869690.0
2022-04-28 19:00:00	NVDA	Stock	19.3	19.324	19.202	19.22	591930.0
2022-04-28 04:00:00	AMZN	Stock	142.5	142.5	142.5	142.5	2500.0
2022-04-28 05:00:00	AMZN	Stock	142.0035	142.0035	142.003	142.003	4000.0

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

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