PREVIEW / stock_1hour / 2019-09-11

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-09-11.parquet
  size:    1.1 MB
  rows:    50,984
  symbols: 2,565

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
2019-09-11 04:00:00	AAPL	Stock	54.2975	54.415	54.25	54.2625	41520.0
2019-09-11 05:00:00	AAPL	Stock	54.1925	54.2475	54.1325	54.2475	41108.0
2019-09-11 06:00:00	AAPL	Stock	54.22	54.2875	54.205	54.21	15052.0
2019-09-11 07:00:00	AAPL	Stock	54.25	54.37	54.21	54.35	349832.0
2019-09-11 08:00:00	AAPL	Stock	54.35	54.4425	54.2275	54.425	681056.0
2019-09-11 09:00:00	AAPL	Stock	54.425	55.1975	54.175	55.025	35127052.0
2019-09-11 10:00:00	AAPL	Stock	55.0212	55.21	54.9625	55.095	21900440.0
2019-09-11 11:00:00	AAPL	Stock	55.0975	55.625	55.05	55.553	21320212.0
2019-09-11 12:00:00	AAPL	Stock	55.5525	55.75	55.52	55.6625	14823840.0
2019-09-11 13:00:00	AAPL	Stock	55.665	55.79	55.5275	55.603	13706416.0
2019-09-11 14:00:00	AAPL	Stock	55.607	55.65	55.43	55.5675	9979516.0
2019-09-11 15:00:00	AAPL	Stock	55.5675	55.91	55.5625	55.8968	22061960.0
2019-09-11 16:00:00	AAPL	Stock	55.8975	55.97	55.3578	55.95	8686736.0
2019-09-11 17:00:00	AAPL	Stock	55.95	55.9625	55.9125	55.9375	75276.0
2019-09-11 18:00:00	AAPL	Stock	55.9375	55.985	55.93	55.965	80228.0
2019-09-11 19:00:00	AAPL	Stock	55.95	56.42	55.94	56.4075	860724.0
2019-09-11 04:00:00	MSFT	Stock	136.14	136.5	136.14	136.34	1402.0
2019-09-11 05:00:00	MSFT	Stock	136.23	136.23	136.0	136.2	1411.0
2019-09-11 06:00:00	MSFT	Stock	136.38	136.38	136.24	136.24	378.0
2019-09-11 07:00:00	MSFT	Stock	136.1	136.55	136.1	136.55	10272.0
2019-09-11 08:00:00	MSFT	Stock	136.18	136.59	136.0	136.45	30364.0
2019-09-11 09:00:00	MSFT	Stock	136.4	136.57	135.11	135.84	3083763.0
2019-09-11 10:00:00	MSFT	Stock	135.84	136.11	135.175	135.27	2736303.0
2019-09-11 11:00:00	MSFT	Stock	135.28	135.69	135.09	135.515	2257835.0
2019-09-11 12:00:00	MSFT	Stock	135.515	135.74	135.16	135.58	2086829.0
2019-09-11 13:00:00	MSFT	Stock	135.58	135.84	135.49	135.65	1218017.0
2019-09-11 14:00:00	MSFT	Stock	135.65	135.76	135.53	135.7	1081552.0
2019-09-11 15:00:00	MSFT	Stock	135.7	136.27	135.65	136.15	4112992.0
2019-09-11 16:00:00	MSFT	Stock	136.12	136.2	135.71	136.1	3743093.0
2019-09-11 17:00:00	MSFT	Stock	136.17	136.2	136.08	136.15	16581.0
2019-09-11 18:00:00	MSFT	Stock	136.2	136.2	136.03	136.03	11496.0
2019-09-11 19:00:00	MSFT	Stock	136.08	137.4	136.08	137.4	39139.0
2019-09-11 04:00:00	NVDA	Stock	4.6	4.6038	4.6	4.6	44400.0
2019-09-11 05:00:00	NVDA	Stock	4.582	4.5822	4.582	4.5822	14680.0
2019-09-11 07:00:00	NVDA	Stock	4.5875	4.6	4.5833	4.6	119920.0
2019-09-11 08:00:00	NVDA	Stock	4.5803	4.6083	4.5682	4.5895	874000.0
2019-09-11 09:00:00	NVDA	Stock	4.59	4.6335	4.565	4.6283	56970040.0
2019-09-11 10:00:00	NVDA	Stock	4.6292	4.6445	4.6142	4.6334	55710800.0
2019-09-11 11:00:00	NVDA	Stock	4.6337	4.6568	4.6297	4.6392	39822920.0
2019-09-11 12:00:00	NVDA	Stock	4.6398	4.6455	4.631	4.639	26994400.0
2019-09-11 13:00:00	NVDA	Stock	4.6375	4.6435	4.5848	4.5995	47952040.0
2019-09-11 14:00:00	NVDA	Stock	4.5988	4.6142	4.5918	4.6134	27707760.0
2019-09-11 15:00:00	NVDA	Stock	4.6125	4.6188	4.5935	4.6102	48111240.0
2019-09-11 16:00:00	NVDA	Stock	4.6083	4.61	4.5988	4.61	2188560.0
2019-09-11 17:00:00	NVDA	Stock	4.6057	4.6158	4.605	4.6158	327080.0
2019-09-11 18:00:00	NVDA	Stock	4.6108	4.6132	4.6083	4.609	213920.0
2019-09-11 19:00:00	NVDA	Stock	4.611	4.6735	4.611	4.663	878000.0
2019-09-11 05:00:00	AMZN	Stock	90.9	90.9	89.75	90.05	50480.0
2019-09-11 06:00:00	AMZN	Stock	90.2	90.3	90.2	90.275	8000.0
2019-09-11 07:00:00	AMZN	Stock	90.25	90.8	90.25	90.8	143760.0

> showing 50 of 50,984 rows — these rows as CSV

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