PREVIEW / stock_1hour / 2022-06-16

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-06-16.parquet
  size:    1.4 MB
  rows:    64,627
  symbols: 2,415

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-06-16 04:00:00	AAPL	Stock	133.0	133.0	131.51	131.67	122329.0
2022-06-16 05:00:00	AAPL	Stock	131.53	131.83	131.2	131.73	42725.0
2022-06-16 06:00:00	AAPL	Stock	131.69	131.91	131.25	131.63	55786.0
2022-06-16 07:00:00	AAPL	Stock	131.63	132.34	131.63	132.3	247952.0
2022-06-16 08:00:00	AAPL	Stock	131.8399	134.75	131.65	132.63	1044384.0
2022-06-16 09:00:00	AAPL	Stock	132.63	132.68	130.5	131.21	12056810.0
2022-06-16 10:00:00	AAPL	Stock	131.21	131.44	129.89	130.1281	13203608.0
2022-06-16 11:00:00	AAPL	Stock	130.1285	131.16	130.09	130.89	8303052.0
2022-06-16 12:00:00	AAPL	Stock	130.89	131.186	130.195	131.04	7500555.0
2022-06-16 13:00:00	AAPL	Stock	131.03	131.53	130.01	130.02	7963330.0
2022-06-16 14:00:00	AAPL	Stock	130.01	130.205	129.29	129.55	9239752.0
2022-06-16 15:00:00	AAPL	Stock	129.54	130.3	129.04	130.1	17714916.0
2022-06-16 16:00:00	AAPL	Stock	130.11	131.195	130.05	130.55	13964314.0
2022-06-16 17:00:00	AAPL	Stock	130.5	130.53	130.33	130.48	62750.0
2022-06-16 18:00:00	AAPL	Stock	130.48	130.8	130.4	130.46	91242.0
2022-06-16 19:00:00	AAPL	Stock	130.45	130.6	130.2	130.53	69087.0
2022-06-16 04:00:00	MSFT	Stock	251.97	251.97	244.84	244.84	17578.0
2022-06-16 05:00:00	MSFT	Stock	244.53	244.75	243.5	244.75	10376.0
2022-06-16 06:00:00	MSFT	Stock	244.62	245.35	244.15	244.59	6324.0
2022-06-16 07:00:00	MSFT	Stock	244.76	246.18	244.41	245.1	46195.0
2022-06-16 08:00:00	MSFT	Stock	244.5	251.131	244.44	246.53	114356.0
2022-06-16 09:00:00	MSFT	Stock	246.54	247.4174	244.9	246.67	2551230.0
2022-06-16 10:00:00	MSFT	Stock	246.6818	246.6818	243.57	244.23	2570975.0
2022-06-16 11:00:00	MSFT	Stock	244.19	246.2	244.18	245.3479	2060015.0
2022-06-16 12:00:00	MSFT	Stock	245.35	245.4	244.14	245.24	1632131.0
2022-06-16 13:00:00	MSFT	Stock	245.22	246.29	243.55	243.58	1999570.0
2022-06-16 14:00:00	MSFT	Stock	243.57	244.6299	243.02	243.49	2057490.0
2022-06-16 15:00:00	MSFT	Stock	243.47	245.26	243.11	245.11	4782829.0
2022-06-16 16:00:00	MSFT	Stock	245.12	246.625	244.6884	245.8981	6947604.0
2022-06-16 17:00:00	MSFT	Stock	245.88	245.89	245.24	245.8	6737.0
2022-06-16 18:00:00	MSFT	Stock	245.84	246.46	245.08	245.4	35067.0
2022-06-16 19:00:00	MSFT	Stock	245.47	245.82	244.53	245.8	13262.0
2022-06-16 04:00:00	NVDA	Stock	16.2	16.2	15.89	15.901	318340.0
2022-06-16 05:00:00	NVDA	Stock	15.85	15.966	15.848	15.932	204940.0
2022-06-16 06:00:00	NVDA	Stock	15.93	15.977	15.879	15.91	126580.0
2022-06-16 07:00:00	NVDA	Stock	15.883	15.995	15.88	15.95	637930.0
2022-06-16 08:00:00	NVDA	Stock	15.9403	16.6	15.902	16.017	1830070.0
2022-06-16 09:00:00	NVDA	Stock	16.017	16.069	15.59	15.6263	62798750.0
2022-06-16 10:00:00	NVDA	Stock	15.6265	15.729	15.4755	15.476	67691200.0
2022-06-16 11:00:00	NVDA	Stock	15.479	15.721	15.468	15.569	54694590.0
2022-06-16 12:00:00	NVDA	Stock	15.569	15.659	15.455	15.634	36597870.0
2022-06-16 13:00:00	NVDA	Stock	15.6353	15.687	15.46	15.465	34747350.0
2022-06-16 14:00:00	NVDA	Stock	15.464	15.538	15.401	15.461	36488530.0
2022-06-16 15:00:00	NVDA	Stock	15.459	15.643	15.449	15.6022	75915940.0
2022-06-16 16:00:00	NVDA	Stock	15.603	15.675	15.586	15.65	35680270.0
2022-06-16 17:00:00	NVDA	Stock	15.65	15.673	15.62	15.65	612180.0
2022-06-16 18:00:00	NVDA	Stock	15.66	15.692	15.625	15.639	354460.0
2022-06-16 19:00:00	NVDA	Stock	15.63	15.645	15.601	15.612	313720.0
2022-06-16 04:00:00	AMZN	Stock	105.3	109.0	104.01	104.04	117368.0
2022-06-16 05:00:00	AMZN	Stock	104.02	104.44	103.66	104.25	22769.0

> showing 50 of 64,627 rows — these rows as CSV

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