PREVIEW / stock_1hour / 2022-03-09

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-03-09.parquet
  size:    1.4 MB
  rows:    65,125
  symbols: 2,529

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-09 04:00:00	AAPL	Stock	157.94	161.02	157.94	160.93	45738.0
2022-03-09 05:00:00	AAPL	Stock	160.99	161.5	160.52	160.52	49451.0
2022-03-09 06:00:00	AAPL	Stock	160.99	161.25	160.57	160.72	34967.0
2022-03-09 07:00:00	AAPL	Stock	160.64	160.87	160.2	160.73	153573.0
2022-03-09 08:00:00	AAPL	Stock	157.44	161.39	157.44	160.98	720596.0
2022-03-09 09:00:00	AAPL	Stock	160.97	161.99	159.41	160.4073	11429501.0
2022-03-09 10:00:00	AAPL	Stock	160.41	162.26	160.151	162.0599	12028280.0
2022-03-09 11:00:00	AAPL	Stock	162.0499	162.16	161.0238	162.005	7456834.0
2022-03-09 12:00:00	AAPL	Stock	162.01	162.69	161.57	162.655	6575379.0
2022-03-09 13:00:00	AAPL	Stock	162.67	162.6801	161.56	161.98	6145022.0
2022-03-09 14:00:00	AAPL	Stock	161.981	163.0	161.79	162.56	7315236.0
2022-03-09 15:00:00	AAPL	Stock	162.58	163.41	162.28	162.98	14039592.0
2022-03-09 16:00:00	AAPL	Stock	162.77	163.2	162.56	162.66	9961325.0
2022-03-09 17:00:00	AAPL	Stock	162.71	162.71	162.35	162.5	89029.0
2022-03-09 18:00:00	AAPL	Stock	162.5	162.5	161.78	161.97	95592.0
2022-03-09 19:00:00	AAPL	Stock	161.99	162.27	161.9	162.25	33777.0
2022-03-09 04:00:00	MSFT	Stock	279.59	281.3	279.43	281.3	8379.0
2022-03-09 05:00:00	MSFT	Stock	281.06	282.7	281.06	282.31	37748.0
2022-03-09 06:00:00	MSFT	Stock	282.23	283.1	282.01	282.01	12874.0
2022-03-09 07:00:00	MSFT	Stock	281.75	283.68	281.29	283.68	28446.0
2022-03-09 08:00:00	MSFT	Stock	275.85	283.98	275.85	283.35	62450.0
2022-03-09 09:00:00	MSFT	Stock	283.45	284.88	280.78	283.67	3515952.0
2022-03-09 10:00:00	MSFT	Stock	283.7585	286.96	282.83	286.5136	3630194.0
2022-03-09 11:00:00	MSFT	Stock	286.52	286.605	284.49	285.0191	2324806.0
2022-03-09 12:00:00	MSFT	Stock	285.015	287.58	284.7486	286.8428	2199150.0
2022-03-09 13:00:00	MSFT	Stock	286.85	287.01	285.56	286.455	1365121.0
2022-03-09 14:00:00	MSFT	Stock	286.46	288.47	286.34	287.51	2080784.0
2022-03-09 15:00:00	MSFT	Stock	287.503	289.6	287.14	288.48	4663478.0
2022-03-09 16:00:00	MSFT	Stock	288.5	288.5	286.31	287.3878	5215377.0
2022-03-09 17:00:00	MSFT	Stock	287.39	287.39	286.56	286.8	22138.0
2022-03-09 18:00:00	MSFT	Stock	287.0	287.22	285.6	286.3	18466.0
2022-03-09 19:00:00	MSFT	Stock	286.3	286.68	285.85	286.0201	10417.0
2022-03-09 04:00:00	NVDA	Stock	21.8	22.34	21.8	22.34	287500.0
2022-03-09 05:00:00	NVDA	Stock	22.28	22.422	22.275	22.33	334010.0
2022-03-09 06:00:00	NVDA	Stock	22.284	22.439	22.26	22.28	143370.0
2022-03-09 07:00:00	NVDA	Stock	22.231	22.34	22.207	22.328	830130.0
2022-03-09 08:00:00	NVDA	Stock	21.514	22.449	21.514	22.332	1747230.0
2022-03-09 09:00:00	NVDA	Stock	22.332	22.6399	22.247	22.5729	55487780.0
2022-03-09 10:00:00	NVDA	Stock	22.5735	22.994	22.5735	22.726	67930550.0
2022-03-09 11:00:00	NVDA	Stock	22.729	22.754	22.486	22.738	54854820.0
2022-03-09 12:00:00	NVDA	Stock	22.74	23.036	22.674	22.953	40005210.0
2022-03-09 13:00:00	NVDA	Stock	22.958	23.081	22.813	22.9805	39015860.0
2022-03-09 14:00:00	NVDA	Stock	22.984	23.133	22.914	23.089	36015540.0
2022-03-09 15:00:00	NVDA	Stock	23.096	23.22	22.93	23.014	49603480.0
2022-03-09 16:00:00	NVDA	Stock	23.027	23.035	22.9	22.999	23614320.0
2022-03-09 17:00:00	NVDA	Stock	22.99	23.015	22.911	22.931	259200.0
2022-03-09 18:00:00	NVDA	Stock	22.93	22.96	22.812	22.833	424520.0
2022-03-09 19:00:00	NVDA	Stock	22.85	22.889	22.831	22.845	258950.0
2022-03-09 04:00:00	AMZN	Stock	138.7575	138.7575	138.7575	138.7575	2000.0
2022-03-09 05:00:00	AMZN	Stock	139.0	139.05	139.0	139.05	4020.0

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

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