PREVIEW / stock_1hour / 2022-06-22

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-06-22.parquet
  size:    1.4 MB
  rows:    62,977
  symbols: 2,346

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-22 04:00:00	AAPL	Stock	134.98	134.98	132.62	132.98	85160.0
2022-06-22 05:00:00	AAPL	Stock	133.09	133.3	132.85	133.23	21653.0
2022-06-22 06:00:00	AAPL	Stock	133.15	133.56	133.15	133.39	28695.0
2022-06-22 07:00:00	AAPL	Stock	133.41	133.89	133.39	133.7	121483.0
2022-06-22 08:00:00	AAPL	Stock	133.66	134.24	132.8612	134.13	404305.0
2022-06-22 09:00:00	AAPL	Stock	134.17	135.945	133.7	135.67	9265348.0
2022-06-22 10:00:00	AAPL	Stock	135.68	137.76	135.25	136.8075	11725688.0
2022-06-22 11:00:00	AAPL	Stock	136.82	136.9843	135.3	135.48	8042296.0
2022-06-22 12:00:00	AAPL	Stock	135.47	136.1	135.14	136.03	6142094.0
2022-06-22 13:00:00	AAPL	Stock	136.04	136.4569	135.6593	136.0601	4619133.0
2022-06-22 14:00:00	AAPL	Stock	136.07	136.97	136.03	136.455	5165855.0
2022-06-22 15:00:00	AAPL	Stock	136.46	136.64	134.98	135.3	9152164.0
2022-06-22 16:00:00	AAPL	Stock	135.31	135.4	135.0	135.21	8787475.0
2022-06-22 17:00:00	AAPL	Stock	135.17	135.22	135.1	135.16	28793.0
2022-06-22 18:00:00	AAPL	Stock	135.15	135.2	134.75	134.78	71557.0
2022-06-22 19:00:00	AAPL	Stock	134.82	134.84	134.15	134.16	99986.0
2022-06-22 04:00:00	MSFT	Stock	250.1	250.1	248.1	248.1	24083.0
2022-06-22 05:00:00	MSFT	Stock	248.3	248.8	248.3	248.51	7548.0
2022-06-22 06:00:00	MSFT	Stock	248.88	249.48	248.88	249.48	5573.0
2022-06-22 07:00:00	MSFT	Stock	249.45	249.84	249.29	249.49	12267.0
2022-06-22 08:00:00	MSFT	Stock	249.3037	253.106	248.61	249.5	45770.0
2022-06-22 09:00:00	MSFT	Stock	249.55	254.53	249.21	254.0	2168075.0
2022-06-22 10:00:00	MSFT	Stock	254.02	257.17	253.34	257.05	2583461.0
2022-06-22 11:00:00	MSFT	Stock	257.06	257.12	254.0375	254.085	2113084.0
2022-06-22 12:00:00	MSFT	Stock	254.085	254.99	253.42	254.9	1335843.0
2022-06-22 13:00:00	MSFT	Stock	254.91	255.57	254.35	255.08	967605.0
2022-06-22 14:00:00	MSFT	Stock	255.09	256.48	255.03	255.58	1144307.0
2022-06-22 15:00:00	MSFT	Stock	255.61	256.0401	252.61	253.0	2852853.0
2022-06-22 16:00:00	MSFT	Stock	253.06	253.18	252.49	252.95	5358782.0
2022-06-22 17:00:00	MSFT	Stock	252.81	252.989	252.8	252.82	1909.0
2022-06-22 18:00:00	MSFT	Stock	252.95	252.98	251.98	252.14	5208.0
2022-06-22 19:00:00	MSFT	Stock	252.02	252.02	250.55	251.47	5927.0
2022-06-22 04:00:00	NVDA	Stock	16.096	16.096	15.902	16.008	133330.0
2022-06-22 05:00:00	NVDA	Stock	16.02	16.147	16.02	16.129	87220.0
2022-06-22 06:00:00	NVDA	Stock	16.123	16.15	16.088	16.13	113800.0
2022-06-22 07:00:00	NVDA	Stock	16.138	16.2	16.11	16.155	475630.0
2022-06-22 08:00:00	NVDA	Stock	16.153	16.265	16.07	16.18	1215020.0
2022-06-22 09:00:00	NVDA	Stock	16.188	16.55	16.136	16.457	57236210.0
2022-06-22 10:00:00	NVDA	Stock	16.4605	16.66	16.3764	16.495	67950670.0
2022-06-22 11:00:00	NVDA	Stock	16.4965	16.59	16.316	16.332	44505920.0
2022-06-22 12:00:00	NVDA	Stock	16.332	16.4632	16.267	16.4503	35694710.0
2022-06-22 13:00:00	NVDA	Stock	16.451	16.529	16.392	16.493	26935170.0
2022-06-22 14:00:00	NVDA	Stock	16.494	16.662	16.476	16.5499	42624580.0
2022-06-22 15:00:00	NVDA	Stock	16.55	16.584	16.3197	16.356	50440050.0
2022-06-22 16:00:00	NVDA	Stock	16.363	16.398	16.328	16.338	25216040.0
2022-06-22 17:00:00	NVDA	Stock	16.342	16.35	16.3299	16.337	231540.0
2022-06-22 18:00:00	NVDA	Stock	16.337	16.343	16.262	16.27	328240.0
2022-06-22 19:00:00	NVDA	Stock	16.273	16.273	16.127	16.15	524970.0
2022-06-22 04:00:00	AMZN	Stock	106.25	108.0	105.9	106.15	25476.0
2022-06-22 05:00:00	AMZN	Stock	106.15	106.37	105.99	106.29	10012.0

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

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