PREVIEW / stock_1hour / 2020-11-06

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-11-06.parquet
  size:    1.3 MB
  rows:    57,100
  symbols: 2,501

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-11-06 04:00:00	AAPL	Stock	117.77	117.77	116.7	116.76	77010.0
2020-11-06 05:00:00	AAPL	Stock	116.77	117.03	116.54	116.81	41181.0
2020-11-06 06:00:00	AAPL	Stock	116.98	117.43	116.9	117.1	24916.0
2020-11-06 07:00:00	AAPL	Stock	117.04	117.58	116.96	116.96	312725.0
2020-11-06 08:00:00	AAPL	Stock	117.32	118.2	116.79	118.1	1173151.0
2020-11-06 09:00:00	AAPL	Stock	118.16	118.64	116.13	116.29	16688576.0
2020-11-06 10:00:00	AAPL	Stock	116.3	117.9	116.131	117.42	14864677.0
2020-11-06 11:00:00	AAPL	Stock	117.414	118.82	117.308	118.74	12112389.0
2020-11-06 12:00:00	AAPL	Stock	118.74	119.19	118.28	118.884	10575648.0
2020-11-06 13:00:00	AAPL	Stock	118.885	119.2	118.83	119.002	6682931.0
2020-11-06 14:00:00	AAPL	Stock	119.0	119.17	118.22	118.47	8510125.0
2020-11-06 15:00:00	AAPL	Stock	118.47	119.06	118.09	118.685	14995041.0
2020-11-06 16:00:00	AAPL	Stock	118.68	118.702	118.42	118.52	7971501.0
2020-11-06 17:00:00	AAPL	Stock	118.52	118.62	118.5	118.53	88157.0
2020-11-06 18:00:00	AAPL	Stock	118.53	118.6	118.42	118.43	63410.0
2020-11-06 19:00:00	AAPL	Stock	118.45	118.55	118.44	118.52	102712.0
2020-11-06 04:00:00	MSFT	Stock	221.35	221.48	219.43	219.43	12254.0
2020-11-06 05:00:00	MSFT	Stock	219.66	220.38	219.14	220.12	11323.0
2020-11-06 06:00:00	MSFT	Stock	220.97	220.97	220.6	220.86	2507.0
2020-11-06 07:00:00	MSFT	Stock	220.74	221.48	220.2	220.3	53955.0
2020-11-06 08:00:00	MSFT	Stock	221.194	222.23	220.0	221.85	80618.0
2020-11-06 09:00:00	MSFT	Stock	221.95	223.0	218.03	218.585	3648886.0
2020-11-06 10:00:00	MSFT	Stock	218.585	221.41	218.08	220.547	2957405.0
2020-11-06 11:00:00	MSFT	Stock	220.59	223.12	220.41	222.62	2123718.0
2020-11-06 12:00:00	MSFT	Stock	222.6	223.36	222.22	222.98	1573108.0
2020-11-06 13:00:00	MSFT	Stock	223.0	224.1	222.95	223.84	1974740.0
2020-11-06 14:00:00	MSFT	Stock	223.86	224.18	223.07	223.52	1631596.0
2020-11-06 15:00:00	MSFT	Stock	223.51	224.36	222.73	223.62	3573896.0
2020-11-06 16:00:00	MSFT	Stock	223.72	223.99	223.5	223.98	2983022.0
2020-11-06 17:00:00	MSFT	Stock	223.75	223.9	223.57	223.58	2031.0
2020-11-06 18:00:00	MSFT	Stock	223.59	223.65	223.29	223.37	4150.0
2020-11-06 19:00:00	MSFT	Stock	223.37	223.46	223.25	223.4	11350.0
2020-11-06 04:00:00	NVDA	Stock	13.85	13.85	13.7602	13.7602	18200.0
2020-11-06 05:00:00	NVDA	Stock	13.762	13.8955	13.7618	13.8942	48320.0
2020-11-06 06:00:00	NVDA	Stock	13.9173	13.9173	13.9	13.9	19600.0
2020-11-06 07:00:00	NVDA	Stock	13.9	13.975	13.8938	13.9032	584840.0
2020-11-06 08:00:00	NVDA	Stock	13.9122	14.1952	13.875	14.0312	1363640.0
2020-11-06 09:00:00	NVDA	Stock	14.0411	14.211	13.895	13.9144	56450760.0
2020-11-06 10:00:00	NVDA	Stock	13.915	14.2698	13.915	14.1892	51692640.0
2020-11-06 11:00:00	NVDA	Stock	14.1881	14.3578	14.1678	14.338	38363000.0
2020-11-06 12:00:00	NVDA	Stock	14.3398	14.4265	14.3248	14.4265	29368760.0
2020-11-06 13:00:00	NVDA	Stock	14.4239	14.5475	14.4208	14.5314	45451000.0
2020-11-06 14:00:00	NVDA	Stock	14.5346	14.5718	14.476	14.5078	32655840.0
2020-11-06 15:00:00	NVDA	Stock	14.5075	14.5888	14.4758	14.5648	55517960.0
2020-11-06 16:00:00	NVDA	Stock	14.562	14.575	14.5545	14.5675	17547240.0
2020-11-06 17:00:00	NVDA	Stock	14.5675	14.5675	14.5535	14.554	430120.0
2020-11-06 18:00:00	NVDA	Stock	14.5608	14.5612	14.5575	14.5612	281440.0
2020-11-06 19:00:00	NVDA	Stock	14.5575	14.5612	14.54	14.5498	280520.0
2020-11-06 04:00:00	AMZN	Stock	164.5	164.5	163.501	163.501	10860.0
2020-11-06 05:00:00	AMZN	Stock	163.008	163.5	163.008	163.5	8980.0

> showing 50 of 57,100 rows — these rows as CSV

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