PREVIEW / stock_1hour / 2022-06-15

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-06-15.parquet
  size:    1.4 MB
  rows:    63,048
  symbols: 2,389

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-15 04:00:00	AAPL	Stock	133.46	133.84	133.3	133.55	42161.0
2022-06-15 05:00:00	AAPL	Stock	133.5	133.65	133.26	133.44	9339.0
2022-06-15 06:00:00	AAPL	Stock	133.5	133.5	133.34	133.34	3727.0
2022-06-15 07:00:00	AAPL	Stock	133.5	134.21	133.3	134.17	104643.0
2022-06-15 08:00:00	AAPL	Stock	133.476	134.55	132.429	134.33	562094.0
2022-06-15 09:00:00	AAPL	Stock	134.38	134.74	133.67	134.2	8339246.0
2022-06-15 10:00:00	AAPL	Stock	134.22	134.6108	133.38	133.82	9494762.0
2022-06-15 11:00:00	AAPL	Stock	133.81	134.485	133.61	134.42	5871893.0
2022-06-15 12:00:00	AAPL	Stock	134.425	134.88	133.52	133.615	5808285.0
2022-06-15 13:00:00	AAPL	Stock	133.62	134.5299	133.49	134.3899	5670536.0
2022-06-15 14:00:00	AAPL	Stock	134.36	136.49	132.16	134.865	17401338.0
2022-06-15 15:00:00	AAPL	Stock	134.88	137.34	134.66	135.42	16484606.0
2022-06-15 16:00:00	AAPL	Stock	135.43	135.57	134.62	135.4	10260886.0
2022-06-15 17:00:00	AAPL	Stock	135.45	135.9	135.43	135.86	103965.0
2022-06-15 18:00:00	AAPL	Stock	135.86	136.34	135.75	136.25	100479.0
2022-06-15 19:00:00	AAPL	Stock	136.21	136.69	136.04	136.5	56017.0
2022-06-15 04:00:00	MSFT	Stock	246.21	246.68	245.93	246.5	5796.0
2022-06-15 05:00:00	MSFT	Stock	246.37	246.5	246.02	246.25	6597.0
2022-06-15 06:00:00	MSFT	Stock	246.11	246.25	246.0	246.0	2382.0
2022-06-15 07:00:00	MSFT	Stock	246.08	247.5	245.5	247.5	10326.0
2022-06-15 08:00:00	MSFT	Stock	245.848	248.38	243.879	247.8	44763.0
2022-06-15 09:00:00	MSFT	Stock	247.87	250.79	247.25	249.48	2691689.0
2022-06-15 10:00:00	MSFT	Stock	249.51	250.1408	248.22	248.8	2302068.0
2022-06-15 11:00:00	MSFT	Stock	248.8	249.45	248.081	249.2	1348455.0
2022-06-15 12:00:00	MSFT	Stock	249.21	250.61	248.7	248.9	1448124.0
2022-06-15 13:00:00	MSFT	Stock	248.91	250.42	248.84	250.0697	1265201.0
2022-06-15 14:00:00	MSFT	Stock	249.88	253.9	246.42	251.26	4204351.0
2022-06-15 15:00:00	MSFT	Stock	251.27	255.3	250.82	251.76	4566315.0
2022-06-15 16:00:00	MSFT	Stock	251.76	251.97	251.0	251.8	7100077.0
2022-06-15 17:00:00	MSFT	Stock	251.7	252.5	251.7	252.5	36309.0
2022-06-15 18:00:00	MSFT	Stock	252.52	253.6199	252.02	253.3	15211.0
2022-06-15 19:00:00	MSFT	Stock	253.32	253.89	252.5	253.81	15505.0
2022-06-15 04:00:00	NVDA	Stock	15.999	16.014	15.904	15.99	200450.0
2022-06-15 05:00:00	NVDA	Stock	15.945	15.963	15.751	15.944	167110.0
2022-06-15 06:00:00	NVDA	Stock	15.929	15.94	15.91	15.931	23150.0
2022-06-15 07:00:00	NVDA	Stock	15.958	16.07	15.922	16.06	373970.0
2022-06-15 08:00:00	NVDA	Stock	15.96	16.115	15.917	16.09	1255850.0
2022-06-15 09:00:00	NVDA	Stock	16.1	16.347	16.02	16.149	56839950.0
2022-06-15 10:00:00	NVDA	Stock	16.14	16.386	16.057	16.2085	64097670.0
2022-06-15 11:00:00	NVDA	Stock	16.21	16.308	16.146	16.273	47425840.0
2022-06-15 12:00:00	NVDA	Stock	16.275	16.337	16.178	16.1906	32899260.0
2022-06-15 13:00:00	NVDA	Stock	16.193	16.427	16.18	16.393	29890910.0
2022-06-15 14:00:00	NVDA	Stock	16.3845	16.814	15.926	16.456	109748370.0
2022-06-15 15:00:00	NVDA	Stock	16.46	16.868	16.391	16.528	91170730.0
2022-06-15 16:00:00	NVDA	Stock	16.5302	16.577	16.348	16.535	20442090.0
2022-06-15 17:00:00	NVDA	Stock	16.525	16.645	16.5145	16.645	578800.0
2022-06-15 18:00:00	NVDA	Stock	16.629	16.745	16.615	16.695	552710.0
2022-06-15 19:00:00	NVDA	Stock	16.714	16.758	16.673	16.727	510210.0
2022-06-15 04:00:00	AMZN	Stock	103.81	103.81	102.98	103.21	45510.0
2022-06-15 05:00:00	AMZN	Stock	103.0	103.28	102.72	103.16	47639.0

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

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