PREVIEW / stock_1hour / 2019-07-22

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-07-22.parquet
  size:    1.1 MB
  rows:    49,403
  symbols: 2,594

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-07-22 04:00:00	AAPL	Stock	50.7725	50.9575	50.7725	50.9575	11700.0
2019-07-22 05:00:00	AAPL	Stock	50.9975	51.1	50.9975	51.05	32136.0
2019-07-22 06:00:00	AAPL	Stock	51.0825	51.0875	51.035	51.085	35920.0
2019-07-22 07:00:00	AAPL	Stock	51.0325	51.0425	50.8125	50.87	170756.0
2019-07-22 08:00:00	AAPL	Stock	51.045	51.045	50.8	50.9	459364.0
2019-07-22 09:00:00	AAPL	Stock	50.905	51.5675	50.8	51.51	16068368.0
2019-07-22 10:00:00	AAPL	Stock	51.515	51.5712	51.4025	51.55	11839496.0
2019-07-22 11:00:00	AAPL	Stock	51.5513	51.595	51.46	51.565	7522660.0
2019-07-22 12:00:00	AAPL	Stock	51.565	51.61	51.5025	51.5462	5234988.0
2019-07-22 13:00:00	AAPL	Stock	51.5462	51.59	51.4675	51.5625	4592432.0
2019-07-22 14:00:00	AAPL	Stock	51.5625	51.625	51.535	51.6238	4921724.0
2019-07-22 15:00:00	AAPL	Stock	51.6225	51.8075	51.615	51.805	14488156.0
2019-07-22 16:00:00	AAPL	Stock	51.805	51.875	51.765	51.81	10269652.0
2019-07-22 17:00:00	AAPL	Stock	51.8425	51.95	51.815	51.9125	109096.0
2019-07-22 18:00:00	AAPL	Stock	51.9125	51.9425	51.9125	51.93	70136.0
2019-07-22 19:00:00	AAPL	Stock	51.925	52.0	51.92	52.0	70716.0
2019-07-22 04:00:00	MSFT	Stock	137.01	137.23	136.87	137.23	5509.0
2019-07-22 05:00:00	MSFT	Stock	137.2	137.2	136.95	137.1	6285.0
2019-07-22 06:00:00	MSFT	Stock	137.09	137.27	137.09	137.15	3327.0
2019-07-22 07:00:00	MSFT	Stock	137.08	137.18	136.9	136.98	34766.0
2019-07-22 08:00:00	MSFT	Stock	137.15	137.25	136.83	137.05	90049.0
2019-07-22 09:00:00	MSFT	Stock	137.08	138.75	136.983	138.67	4223860.0
2019-07-22 10:00:00	MSFT	Stock	138.67	139.19	138.31	138.4	4310002.0
2019-07-22 11:00:00	MSFT	Stock	138.4	138.64	138.14	138.595	2034137.0
2019-07-22 12:00:00	MSFT	Stock	138.59	138.63	138.31	138.375	1305691.0
2019-07-22 13:00:00	MSFT	Stock	138.375	138.42	138.04	138.17	1169327.0
2019-07-22 14:00:00	MSFT	Stock	138.175	138.47	138.12	138.45	1263642.0
2019-07-22 15:00:00	MSFT	Stock	138.445	138.8	138.295	138.43	2958327.0
2019-07-22 16:00:00	MSFT	Stock	138.43	138.6	138.32	138.58	3340230.0
2019-07-22 17:00:00	MSFT	Stock	138.5	138.56	138.44	138.44	7419.0
2019-07-22 18:00:00	MSFT	Stock	138.49	138.58	138.49	138.53	4870.0
2019-07-22 19:00:00	MSFT	Stock	138.55	138.57	138.54	138.57	1763.0
2019-07-22 04:00:00	NVDA	Stock	4.226	4.23	4.225	4.225	32000.0
2019-07-22 05:00:00	NVDA	Stock	4.225	4.2275	4.2243	4.2275	27600.0
2019-07-22 07:00:00	NVDA	Stock	4.2232	4.2275	4.221	4.225	281560.0
2019-07-22 08:00:00	NVDA	Stock	4.2275	4.2412	4.2155	4.2312	1198120.0
2019-07-22 09:00:00	NVDA	Stock	4.23	4.296	4.225	4.2808	64485400.0
2019-07-22 10:00:00	NVDA	Stock	4.2808	4.2885	4.2615	4.2655	63155120.0
2019-07-22 11:00:00	NVDA	Stock	4.2653	4.2762	4.2582	4.2655	26336240.0
2019-07-22 12:00:00	NVDA	Stock	4.2645	4.2668	4.2498	4.2597	23841400.0
2019-07-22 13:00:00	NVDA	Stock	4.2597	4.2688	4.2522	4.2623	18280560.0
2019-07-22 14:00:00	NVDA	Stock	4.2622	4.27	4.2518	4.2617	19923240.0
2019-07-22 15:00:00	NVDA	Stock	4.2617	4.2862	4.2612	4.2828	44705200.0
2019-07-22 16:00:00	NVDA	Stock	4.283	4.2908	4.2805	4.2908	9965960.0
2019-07-22 17:00:00	NVDA	Stock	4.2908	4.297	4.2875	4.2925	320840.0
2019-07-22 18:00:00	NVDA	Stock	4.2905	4.2925	4.29	4.2917	112000.0
2019-07-22 19:00:00	NVDA	Stock	4.2917	4.2995	4.2917	4.2972	322440.0
2019-07-22 05:00:00	AMZN	Stock	98.62	98.675	98.5	98.5	8360.0
2019-07-22 06:00:00	AMZN	Stock	98.547	98.652	98.547	98.652	15440.0
2019-07-22 07:00:00	AMZN	Stock	98.65	98.717	98.605	98.675	57940.0

> showing 50 of 49,403 rows — these rows as CSV

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