PREVIEW / stock_1hour / 2022-06-23

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-06-23.parquet
  size:    1.4 MB
  rows:    62,799
  symbols: 2,320

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-23 04:00:00	AAPL	Stock	134.21	135.95	134.21	135.72	44617.0
2022-06-23 05:00:00	AAPL	Stock	135.76	136.3	135.75	136.3	15611.0
2022-06-23 06:00:00	AAPL	Stock	136.23	136.95	136.23	136.76	26140.0
2022-06-23 07:00:00	AAPL	Stock	136.77	136.94	136.35	136.6	139305.0
2022-06-23 08:00:00	AAPL	Stock	136.5	136.9	134.65	136.32	495699.0
2022-06-23 09:00:00	AAPL	Stock	136.27	137.45	135.63	136.62	9719001.0
2022-06-23 10:00:00	AAPL	Stock	136.61	137.77	136.42	137.68	10714206.0
2022-06-23 11:00:00	AAPL	Stock	137.67	138.26	136.9201	137.0901	7813199.0
2022-06-23 12:00:00	AAPL	Stock	137.095	137.145	136.12	136.415	5819720.0
2022-06-23 13:00:00	AAPL	Stock	136.41	137.03	136.04	137.0041	5087985.0
2022-06-23 14:00:00	AAPL	Stock	137.005	137.725	136.89	137.63	5156469.0
2022-06-23 15:00:00	AAPL	Stock	137.63	138.59	137.36	138.25	10164283.0
2022-06-23 16:00:00	AAPL	Stock	138.24	138.35	137.71	137.89	6034819.0
2022-06-23 17:00:00	AAPL	Stock	137.85	138.01	137.7904	137.9	51710.0
2022-06-23 18:00:00	AAPL	Stock	137.85	138.17	137.85	138.1	52595.0
2022-06-23 19:00:00	AAPL	Stock	138.06	138.25	138.02	138.1	47830.0
2022-06-23 04:00:00	MSFT	Stock	251.53	255.0	251.45	253.91	27578.0
2022-06-23 05:00:00	MSFT	Stock	254.24	255.3	254.24	255.3	4260.0
2022-06-23 06:00:00	MSFT	Stock	255.2	256.54	254.91	256.5	3524.0
2022-06-23 07:00:00	MSFT	Stock	256.02	256.5	255.5	256.25	15658.0
2022-06-23 08:00:00	MSFT	Stock	255.938	256.19	251.82	254.9245	32326.0
2022-06-23 09:00:00	MSFT	Stock	254.83	256.35	253.63	256.2553	2094270.0
2022-06-23 10:00:00	MSFT	Stock	256.23	258.49	254.74	258.3876	2224193.0
2022-06-23 11:00:00	MSFT	Stock	258.38	258.42	256.37	256.44	1671613.0
2022-06-23 12:00:00	MSFT	Stock	256.46	256.6578	254.89	255.37	1747896.0
2022-06-23 13:00:00	MSFT	Stock	255.38	257.04	254.89	257.0201	1245595.0
2022-06-23 14:00:00	MSFT	Stock	257.03	258.36	256.83	257.95	1383685.0
2022-06-23 15:00:00	MSFT	Stock	257.93	259.37	257.58	258.92	3030321.0
2022-06-23 16:00:00	MSFT	Stock	258.91	259.36	258.07	258.21	5072044.0
2022-06-23 17:00:00	MSFT	Stock	258.14	258.25	258.11	258.11	4715.0
2022-06-23 18:00:00	MSFT	Stock	258.2	258.6	258.2	258.57	5879.0
2022-06-23 19:00:00	MSFT	Stock	258.77	258.79	258.0	258.0	4649.0
2022-06-23 04:00:00	NVDA	Stock	16.05	16.451	16.05	16.417	151130.0
2022-06-23 05:00:00	NVDA	Stock	16.435	16.556	16.429	16.553	177870.0
2022-06-23 06:00:00	NVDA	Stock	16.548	16.655	16.521	16.612	114500.0
2022-06-23 07:00:00	NVDA	Stock	16.605	16.65	16.541	16.58	298610.0
2022-06-23 08:00:00	NVDA	Stock	16.5746	16.609	16.332	16.524	980400.0
2022-06-23 09:00:00	NVDA	Stock	16.501	16.589	15.95	16.1907	64577430.0
2022-06-23 10:00:00	NVDA	Stock	16.1915	16.424	16.053	16.3513	72909350.0
2022-06-23 11:00:00	NVDA	Stock	16.348	16.3736	16.161	16.164	43636390.0
2022-06-23 12:00:00	NVDA	Stock	16.165	16.171	15.948	15.98	43728600.0
2022-06-23 13:00:00	NVDA	Stock	15.9825	16.002	15.853	15.988	36953150.0
2022-06-23 14:00:00	NVDA	Stock	15.989	16.067	15.943	16.036	34817430.0
2022-06-23 15:00:00	NVDA	Stock	16.038	16.305	16.007	16.224	59339150.0
2022-06-23 16:00:00	NVDA	Stock	16.225	16.24	16.123	16.165	14928580.0
2022-06-23 17:00:00	NVDA	Stock	16.178	16.2	16.1652	16.199	222540.0
2022-06-23 18:00:00	NVDA	Stock	16.205	16.224	16.183	16.215	217640.0
2022-06-23 19:00:00	NVDA	Stock	16.22	16.235	16.177	16.18	216220.0
2022-06-23 04:00:00	AMZN	Stock	108.21	109.97	108.21	109.6	12827.0
2022-06-23 05:00:00	AMZN	Stock	109.68	110.12	109.65	109.99	8163.0

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

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