PREVIEW / stock_1hour / 2021-02-22

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-02-22.parquet
  size:    1.5 MB
  rows:    72,323
  symbols: 2,838

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
2021-02-22 04:00:00	AAPL	Stock	127.8	127.97	127.16	127.75	48986.0
2021-02-22 05:00:00	AAPL	Stock	127.75	128.0	127.57	127.57	29823.0
2021-02-22 06:00:00	AAPL	Stock	127.61	127.78	127.0	127.55	59939.0
2021-02-22 07:00:00	AAPL	Stock	127.5	128.06	127.33	127.9	374422.0
2021-02-22 08:00:00	AAPL	Stock	127.88	130.194	127.33	127.88	561460.0
2021-02-22 09:00:00	AAPL	Stock	127.87	129.72	127.46	128.485	12039857.0
2021-02-22 10:00:00	AAPL	Stock	128.48	128.85	125.6	125.926	21551229.0
2021-02-22 11:00:00	AAPL	Stock	125.92	127.25	125.79	126.905	11012720.0
2021-02-22 12:00:00	AAPL	Stock	126.9	127.257	126.5	127.257	6602019.0
2021-02-22 13:00:00	AAPL	Stock	127.25	127.96	126.94	127.76	6218933.0
2021-02-22 14:00:00	AAPL	Stock	127.77	127.82	127.19	127.29	5745407.0
2021-02-22 15:00:00	AAPL	Stock	127.285	127.295	126.0	126.01	16934116.0
2021-02-22 16:00:00	AAPL	Stock	126.01	126.3	125.75	126.1	7678841.0
2021-02-22 17:00:00	AAPL	Stock	126.1	126.14	126.0	126.05	122120.0
2021-02-22 18:00:00	AAPL	Stock	126.05	126.2	126.03	126.11	110238.0
2021-02-22 19:00:00	AAPL	Stock	126.11	126.16	125.79	125.82	163284.0
2021-02-22 04:00:00	MSFT	Stock	237.99	237.99	236.49	237.5	15610.0
2021-02-22 05:00:00	MSFT	Stock	237.39	237.65	237.39	237.65	923.0
2021-02-22 06:00:00	MSFT	Stock	237.1	237.21	236.61	236.99	4629.0
2021-02-22 07:00:00	MSFT	Stock	237.0	237.56	236.59	237.0	25308.0
2021-02-22 08:00:00	MSFT	Stock	237.57	237.94	236.75	237.7	55240.0
2021-02-22 09:00:00	MSFT	Stock	237.501	237.93	236.236	236.44	3010794.0
2021-02-22 10:00:00	MSFT	Stock	236.42	236.55	233.81	234.21	5849897.0
2021-02-22 11:00:00	MSFT	Stock	234.19	235.028	232.54	232.73	4373446.0
2021-02-22 12:00:00	MSFT	Stock	232.75	234.57	232.4	234.181	2659150.0
2021-02-22 13:00:00	MSFT	Stock	234.19	235.65	233.94	235.521	1602251.0
2021-02-22 14:00:00	MSFT	Stock	235.52	235.57	234.83	235.36	1647800.0
2021-02-22 15:00:00	MSFT	Stock	235.33	235.41	234.06	234.6	4663446.0
2021-02-22 16:00:00	MSFT	Stock	234.63	234.95	234.08	234.3	5311541.0
2021-02-22 17:00:00	MSFT	Stock	234.26	234.4	234.15	234.38	6168.0
2021-02-22 18:00:00	MSFT	Stock	234.38	234.82	234.26	234.27	6498.0
2021-02-22 19:00:00	MSFT	Stock	234.25	234.3	234.0	234.07	11798.0
2021-02-22 04:00:00	NVDA	Stock	14.7623	14.7623	14.6875	14.688	22840.0
2021-02-22 05:00:00	NVDA	Stock	14.7435	14.75	14.7198	14.7198	32840.0
2021-02-22 06:00:00	NVDA	Stock	14.7	14.7008	14.695	14.695	72720.0
2021-02-22 07:00:00	NVDA	Stock	14.715	14.7988	14.715	14.7188	854440.0
2021-02-22 08:00:00	NVDA	Stock	14.7722	14.7972	14.6788	14.7675	1183160.0
2021-02-22 09:00:00	NVDA	Stock	14.775	15.1333	14.7	15.0438	47877960.0
2021-02-22 10:00:00	NVDA	Stock	15.0458	15.1175	14.7775	14.7985	36822120.0
2021-02-22 11:00:00	NVDA	Stock	14.7918	14.8592	14.7502	14.7852	30606480.0
2021-02-22 12:00:00	NVDA	Stock	14.784	14.8713	14.7062	14.812	22496000.0
2021-02-22 13:00:00	NVDA	Stock	14.8118	14.8225	14.7475	14.7606	16517720.0
2021-02-22 14:00:00	NVDA	Stock	14.761	14.8148	14.6668	14.6972	15077360.0
2021-02-22 15:00:00	NVDA	Stock	14.694	14.697	14.325	14.3558	59758960.0
2021-02-22 16:00:00	NVDA	Stock	14.3558	14.7448	14.3475	14.3722	35677520.0
2021-02-22 17:00:00	NVDA	Stock	14.3738	14.3815	14.3652	14.375	298000.0
2021-02-22 18:00:00	NVDA	Stock	14.375	14.425	14.375	14.41	177440.0
2021-02-22 19:00:00	NVDA	Stock	14.3903	14.4035	14.3575	14.37	690160.0
2021-02-22 04:00:00	AMZN	Stock	161.575	161.575	160.5	160.9265	24700.0
2021-02-22 06:00:00	AMZN	Stock	160.805	160.9795	160.75	160.9	27300.0

> showing 50 of 72,323 rows — these rows as CSV

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