PREVIEW / stock_1hour / 2020-10-16

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-10-16.parquet
  size:    1.2 MB
  rows:    56,715
  symbols: 2,498

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
2020-10-16 04:00:00	AAPL	Stock	121.06	121.5	120.91	121.47	57365.0
2020-10-16 05:00:00	AAPL	Stock	121.4	121.5	120.73	120.95	38116.0
2020-10-16 06:00:00	AAPL	Stock	121.05	121.59	120.65	121.13	41874.0
2020-10-16 07:00:00	AAPL	Stock	121.14	121.54	120.82	121.38	284855.0
2020-10-16 08:00:00	AAPL	Stock	121.09	122.11	120.89	121.9	826094.0
2020-10-16 09:00:00	AAPL	Stock	121.89	121.99	120.31	120.85	17374857.0
2020-10-16 10:00:00	AAPL	Stock	120.846	121.27	120.311	120.69	16227829.0
2020-10-16 11:00:00	AAPL	Stock	120.692	120.692	119.46	119.98	13686534.0
2020-10-16 12:00:00	AAPL	Stock	119.985	120.11	119.29	119.827	10780874.0
2020-10-16 13:00:00	AAPL	Stock	119.825	120.36	119.71	120.06	9025487.0
2020-10-16 14:00:00	AAPL	Stock	120.06	120.5	119.875	120.39	7620296.0
2020-10-16 15:00:00	AAPL	Stock	120.395	120.49	118.81	118.96	18285749.0
2020-10-16 16:00:00	AAPL	Stock	119.02	119.16	118.72	118.91	9505872.0
2020-10-16 17:00:00	AAPL	Stock	118.91	118.98	118.9	118.94	134740.0
2020-10-16 18:00:00	AAPL	Stock	118.91	118.98	118.82	118.84	125055.0
2020-10-16 19:00:00	AAPL	Stock	118.83	118.86	118.7	118.72	166307.0
2020-10-16 04:00:00	MSFT	Stock	219.91	219.92	219.74	219.79	2560.0
2020-10-16 05:00:00	MSFT	Stock	219.9	219.9	219.11	219.5	3427.0
2020-10-16 06:00:00	MSFT	Stock	220.0	220.2	219.0	219.01	6927.0
2020-10-16 07:00:00	MSFT	Stock	219.49	220.6	219.0	220.45	27012.0
2020-10-16 08:00:00	MSFT	Stock	220.39	220.999	219.12	220.83	36517.0
2020-10-16 09:00:00	MSFT	Stock	220.86	221.47	219.67	220.36	3288739.0
2020-10-16 10:00:00	MSFT	Stock	220.35	222.29	220.27	221.0	2420668.0
2020-10-16 11:00:00	MSFT	Stock	221.0	221.08	219.86	220.55	1834462.0
2020-10-16 12:00:00	MSFT	Stock	220.53	220.83	219.74	220.54	1568052.0
2020-10-16 13:00:00	MSFT	Stock	220.53	221.28	220.39	220.85	1478071.0
2020-10-16 14:00:00	MSFT	Stock	220.85	222.02	220.51	221.711	1831936.0
2020-10-16 15:00:00	MSFT	Stock	221.71	221.79	219.32	219.65	4648722.0
2020-10-16 16:00:00	MSFT	Stock	219.65	219.89	218.15	218.48	4020785.0
2020-10-16 17:00:00	MSFT	Stock	218.78	219.15	218.78	219.0	16934.0
2020-10-16 18:00:00	MSFT	Stock	219.18	219.18	219.0	219.14	3725.0
2020-10-16 19:00:00	MSFT	Stock	219.18	219.25	218.95	219.16	5754.0
2020-10-16 04:00:00	NVDA	Stock	14.031	14.0468	14.0	14.0468	44760.0
2020-10-16 05:00:00	NVDA	Stock	14.0425	14.065	14.0125	14.0125	375000.0
2020-10-16 06:00:00	NVDA	Stock	14.025	14.0625	14.025	14.025	83320.0
2020-10-16 07:00:00	NVDA	Stock	14.05	14.0725	14.0358	14.0698	281920.0
2020-10-16 08:00:00	NVDA	Stock	14.0375	14.1125	14.0048	14.1018	850640.0
2020-10-16 09:00:00	NVDA	Stock	14.1	14.1215	14.0028	14.0905	33977680.0
2020-10-16 10:00:00	NVDA	Stock	14.0919	14.0998	13.9555	14.0008	26450280.0
2020-10-16 11:00:00	NVDA	Stock	13.995	14.0025	13.813	13.9125	37471120.0
2020-10-16 12:00:00	NVDA	Stock	13.9125	13.9262	13.8288	13.8759	22791120.0
2020-10-16 13:00:00	NVDA	Stock	13.8728	13.9248	13.8655	13.9	14671880.0
2020-10-16 14:00:00	NVDA	Stock	13.9023	13.9538	13.876	13.9396	13484800.0
2020-10-16 15:00:00	NVDA	Stock	13.9412	13.9482	13.7925	13.8115	42126760.0
2020-10-16 16:00:00	NVDA	Stock	13.8115	13.8185	13.7625	13.7675	10708560.0
2020-10-16 17:00:00	NVDA	Stock	13.7625	13.7825	13.7595	13.7688	285840.0
2020-10-16 18:00:00	NVDA	Stock	13.7762	13.7938	13.7758	13.7805	146440.0
2020-10-16 19:00:00	NVDA	Stock	13.7875	13.7875	13.7875	13.7875	11240.0
2020-10-16 04:00:00	AMZN	Stock	167.55	167.6	167.5	167.5	17660.0
2020-10-16 05:00:00	AMZN	Stock	167.4395	167.4395	167.4395	167.4395	2000.0

> showing 50 of 56,715 rows — these rows as CSV

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