PREVIEW / stock_1hour / 2022-05-19

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-05-19.parquet
  size:    1.4 MB
  rows:    62,612
  symbols: 2,374

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-19 04:00:00	AAPL	Stock	140.18	140.18	139.03	139.07	61511.0
2022-05-19 05:00:00	AAPL	Stock	139.02	139.25	138.56	138.91	49414.0
2022-05-19 06:00:00	AAPL	Stock	138.86	139.88	138.86	139.84	57258.0
2022-05-19 07:00:00	AAPL	Stock	139.85	140.5	139.45	140.35	183947.0
2022-05-19 08:00:00	AAPL	Stock	139.7542	140.4899	139.2012	140.0	1139841.0
2022-05-19 09:00:00	AAPL	Stock	139.98	141.66	138.7	139.49	16738509.0
2022-05-19 10:00:00	AAPL	Stock	139.47	141.02	137.84	138.73	20167735.0
2022-05-19 11:00:00	AAPL	Stock	138.73	140.4	137.99	139.44	15573417.0
2022-05-19 12:00:00	AAPL	Stock	139.445	140.04	137.79	138.09	11630183.0
2022-05-19 13:00:00	AAPL	Stock	138.1	138.44	136.6	137.81	14039149.0
2022-05-19 14:00:00	AAPL	Stock	137.795	139.15	136.97	138.8	11256762.0
2022-05-19 15:00:00	AAPL	Stock	138.805	139.41	136.67	137.31	18273286.0
2022-05-19 16:00:00	AAPL	Stock	137.33	137.9	137.12	137.8	6695125.0
2022-05-19 17:00:00	AAPL	Stock	137.82	137.82	137.35	137.78	217537.0
2022-05-19 18:00:00	AAPL	Stock	137.7899	138.0	137.69	137.88	82938.0
2022-05-19 19:00:00	AAPL	Stock	137.89	138.33	137.7	138.3	80174.0
2022-05-19 04:00:00	MSFT	Stock	252.0	252.14	250.75	250.77	23503.0
2022-05-19 05:00:00	MSFT	Stock	250.55	250.7	250.0	250.53	14534.0
2022-05-19 06:00:00	MSFT	Stock	250.5	251.86	250.5	251.86	15093.0
2022-05-19 07:00:00	MSFT	Stock	251.41	252.84	251.35	252.84	34745.0
2022-05-19 08:00:00	MSFT	Stock	251.5073	252.8794	251.2	252.43	56764.0
2022-05-19 09:00:00	MSFT	Stock	252.2	256.0	252.03	254.45	3426836.0
2022-05-19 10:00:00	MSFT	Stock	254.46	256.835	253.6701	255.88	3372855.0
2022-05-19 11:00:00	MSFT	Stock	255.9	257.67	254.88	256.36	2294466.0
2022-05-19 12:00:00	MSFT	Stock	256.365	257.58	253.03	253.86	2456922.0
2022-05-19 13:00:00	MSFT	Stock	253.84	254.45	251.88	254.315	2446714.0
2022-05-19 14:00:00	MSFT	Stock	254.29	256.15	252.9691	255.64	2277672.0
2022-05-19 15:00:00	MSFT	Stock	255.62	256.395	252.29	253.13	3962323.0
2022-05-19 16:00:00	MSFT	Stock	253.14	254.17	252.5172	254.08	2926509.0
2022-05-19 17:00:00	MSFT	Stock	254.0077	254.0077	253.14	253.75	23764.0
2022-05-19 18:00:00	MSFT	Stock	253.59	254.99	253.59	254.36	13705.0
2022-05-19 19:00:00	MSFT	Stock	254.2801	254.75	254.0	254.75	5266.0
2022-05-19 04:00:00	NVDA	Stock	16.665	16.757	16.5	16.5	403260.0
2022-05-19 05:00:00	NVDA	Stock	16.493	16.539	16.461	16.478	269730.0
2022-05-19 06:00:00	NVDA	Stock	16.48	16.671	16.48	16.608	379100.0
2022-05-19 07:00:00	NVDA	Stock	16.609	16.729	16.543	16.7	494530.0
2022-05-19 08:00:00	NVDA	Stock	16.62	16.7459	16.5331	16.71	1718880.0
2022-05-19 09:00:00	NVDA	Stock	16.69	17.411	16.69	17.051	89319210.0
2022-05-19 10:00:00	NVDA	Stock	17.044	17.495	17.025	17.44	106762870.0
2022-05-19 11:00:00	NVDA	Stock	17.4408	17.687	17.314	17.618	72932460.0
2022-05-19 12:00:00	NVDA	Stock	17.623	17.647	17.208	17.328	54718900.0
2022-05-19 13:00:00	NVDA	Stock	17.3221	17.4541	17.133	17.428	50839700.0
2022-05-19 14:00:00	NVDA	Stock	17.435	17.528	17.2725	17.4712	46614640.0
2022-05-19 15:00:00	NVDA	Stock	17.4761	17.549	17.068	17.129	68202380.0
2022-05-19 16:00:00	NVDA	Stock	17.124	17.24	17.04	17.22	23122040.0
2022-05-19 17:00:00	NVDA	Stock	17.229	17.2376	17.171	17.195	283740.0
2022-05-19 18:00:00	NVDA	Stock	17.185	17.28	17.183	17.21	298260.0
2022-05-19 19:00:00	NVDA	Stock	17.242	17.338	17.22	17.338	318940.0
2022-05-19 05:00:00	AMZN	Stock	105.0125	105.0125	105.0125	105.0125	2000.0
2022-05-19 06:00:00	AMZN	Stock	105.5	106.0	105.5	106.0	16480.0

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

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