PREVIEW / stock_1hour / 2021-06-10

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-06-10.parquet
  size:    1.4 MB
  rows:    66,255
  symbols: 2,971

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-06-10 04:00:00	AAPL	Stock	126.82	126.92	126.36	126.5	20606.0
2021-06-10 05:00:00	AAPL	Stock	126.51	126.64	126.47	126.57	9749.0
2021-06-10 06:00:00	AAPL	Stock	126.6	126.69	126.55	126.55	1974.0
2021-06-10 07:00:00	AAPL	Stock	126.62	127.0	126.42	126.73	106253.0
2021-06-10 08:00:00	AAPL	Stock	126.5801	127.38	126.22	127.26	574558.0
2021-06-10 09:00:00	AAPL	Stock	127.26	128.19	126.61	127.92	10340374.0
2021-06-10 10:00:00	AAPL	Stock	127.92	128.015	126.115	126.48	12050305.0
2021-06-10 11:00:00	AAPL	Stock	126.475	126.69	126.19	126.59	7129260.0
2021-06-10 12:00:00	AAPL	Stock	126.5901	126.825	126.42	126.59	4472279.0
2021-06-10 13:00:00	AAPL	Stock	126.59	126.63	126.24	126.3535	4975347.0
2021-06-10 14:00:00	AAPL	Stock	126.3576	126.39	125.96	126.34	6373057.0
2021-06-10 15:00:00	AAPL	Stock	126.335	126.41	125.94	126.11	12786841.0
2021-06-10 16:00:00	AAPL	Stock	126.11	126.36	126.02	126.26	5772667.0
2021-06-10 17:00:00	AAPL	Stock	126.24	126.28	126.16	126.27	45006.0
2021-06-10 18:00:00	AAPL	Stock	126.26	126.32	126.22	126.27	50244.0
2021-06-10 19:00:00	AAPL	Stock	126.28	126.3	126.21	126.2801	59758.0
2021-06-10 04:00:00	MSFT	Stock	253.2	253.2	252.78	252.78	683.0
2021-06-10 05:00:00	MSFT	Stock	253.0	253.0	253.0	253.0	966.0
2021-06-10 06:00:00	MSFT	Stock	252.8	252.8	252.8	252.8	100.0
2021-06-10 07:00:00	MSFT	Stock	252.85	253.08	252.36	252.95	16758.0
2021-06-10 08:00:00	MSFT	Stock	253.11	254.22	251.5	254.0	43828.0
2021-06-10 09:00:00	MSFT	Stock	254.24	256.35	253.64	255.87	2320002.0
2021-06-10 10:00:00	MSFT	Stock	255.86	256.42	254.58	255.21	2986549.0
2021-06-10 11:00:00	MSFT	Stock	255.2	256.895	254.98	256.78	3049580.0
2021-06-10 12:00:00	MSFT	Stock	256.78	257.445	256.5702	257.43	2002299.0
2021-06-10 13:00:00	MSFT	Stock	257.43	257.46	256.28	256.99	1702975.0
2021-06-10 14:00:00	MSFT	Stock	256.99	257.05	256.2599	256.84	1424160.0
2021-06-10 15:00:00	MSFT	Stock	256.845	257.44	256.355	257.24	3045215.0
2021-06-10 16:00:00	MSFT	Stock	257.24	257.89	257.06	257.56	3376104.0
2021-06-10 17:00:00	MSFT	Stock	257.7	258.37	257.7	258.3199	33299.0
2021-06-10 18:00:00	MSFT	Stock	258.27	258.33	258.18	258.2	24081.0
2021-06-10 19:00:00	MSFT	Stock	258.2	258.5	258.02	258.5	7168.0
2021-06-10 04:00:00	NVDA	Stock	17.3045	17.305	17.3045	17.305	58400.0
2021-06-10 05:00:00	NVDA	Stock	17.2875	17.2875	17.2875	17.2875	5800.0
2021-06-10 06:00:00	NVDA	Stock	17.3048	17.305	17.253	17.253	392000.0
2021-06-10 07:00:00	NVDA	Stock	17.2662	17.28	17.2	17.28	1088320.0
2021-06-10 08:00:00	NVDA	Stock	17.2605	17.3758	17.2	17.3632	1130680.0
2021-06-10 09:00:00	NVDA	Stock	17.3698	17.4725	17.2324	17.4025	42689040.0
2021-06-10 10:00:00	NVDA	Stock	17.4072	17.45	17.176	17.2694	28919680.0
2021-06-10 11:00:00	NVDA	Stock	17.2688	17.4005	17.2258	17.3799	20410040.0
2021-06-10 12:00:00	NVDA	Stock	17.3788	17.4325	17.339	17.4248	15718280.0
2021-06-10 13:00:00	NVDA	Stock	17.4269	17.4625	17.3982	17.4518	19175920.0
2021-06-10 14:00:00	NVDA	Stock	17.4518	17.492	17.3887	17.4824	14286560.0
2021-06-10 15:00:00	NVDA	Stock	17.4824	17.4895	17.39	17.42	25043920.0
2021-06-10 16:00:00	NVDA	Stock	17.4198	17.4374	17.4188	17.425	10533080.0
2021-06-10 17:00:00	NVDA	Stock	17.4375	17.445	17.4375	17.445	24000.0
2021-06-10 18:00:00	NVDA	Stock	17.4375	17.4375	17.4313	17.4313	43840.0
2021-06-10 19:00:00	NVDA	Stock	17.4313	17.443	17.425	17.425	38360.0
2021-06-10 04:00:00	AMZN	Stock	163.5	163.5	163.5	163.5	2440.0
2021-06-10 06:00:00	AMZN	Stock	163.3835	163.3835	163.3835	163.3835	2000.0

> showing 50 of 66,255 rows — these rows as CSV

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