PREVIEW / stock_1hour / 2017-11-14

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-11-14.parquet
  size:    1.1 MB
  rows:    48,983
  symbols: 2,952

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
2017-11-14 04:00:00	AAPL	Stock	43.545	43.545	43.545	43.545	492.0
2017-11-14 05:00:00	AAPL	Stock	43.45	43.45	43.45	43.45	2988.0
2017-11-14 06:00:00	AAPL	Stock	43.4725	43.4725	43.45	43.47	6384.0
2017-11-14 07:00:00	AAPL	Stock	43.47	43.5	43.425	43.4625	63200.0
2017-11-14 08:00:00	AAPL	Stock	43.475	43.475	43.3525	43.375	185328.0
2017-11-14 09:00:00	AAPL	Stock	43.3825	43.42	43.1325	43.1875	13004616.0
2017-11-14 10:00:00	AAPL	Stock	43.19	43.3125	43.0275	43.22	15892620.0
2017-11-14 11:00:00	AAPL	Stock	43.2188	43.3125	43.1825	43.2475	7570536.0
2017-11-14 12:00:00	AAPL	Stock	43.2475	43.25	43.045	43.0942	7636400.0
2017-11-14 13:00:00	AAPL	Stock	43.0875	43.0875	42.8675	42.9575	11555524.0
2017-11-14 14:00:00	AAPL	Stock	42.9575	43.0012	42.9375	42.9862	6976792.0
2017-11-14 15:00:00	AAPL	Stock	42.9858	43.0325	42.795	42.835	18430308.0
2017-11-14 16:00:00	AAPL	Stock	42.835	43.1008	42.625	42.8	4064376.0
2017-11-14 17:00:00	AAPL	Stock	42.7975	42.87	42.775	42.87	77732.0
2017-11-14 18:00:00	AAPL	Stock	42.8725	42.96	42.8625	42.925	137428.0
2017-11-14 19:00:00	AAPL	Stock	42.9175	42.9175	42.815	42.875	164584.0
2017-11-14 05:00:00	MSFT	Stock	84.0	84.0	84.0	84.0	1500.0
2017-11-14 07:00:00	MSFT	Stock	84.0	84.0	83.85	83.85	2500.0
2017-11-14 08:00:00	MSFT	Stock	83.9	84.0	83.8	83.8	3015.0
2017-11-14 09:00:00	MSFT	Stock	83.8	83.94	83.18	83.22	2358454.0
2017-11-14 10:00:00	MSFT	Stock	83.215	83.85	82.98	83.73	3053053.0
2017-11-14 11:00:00	MSFT	Stock	83.73	83.79	83.52	83.6	1634183.0
2017-11-14 12:00:00	MSFT	Stock	83.61	83.72	83.35	83.425	1249313.0
2017-11-14 13:00:00	MSFT	Stock	83.42	83.72	83.24	83.69	1905586.0
2017-11-14 14:00:00	MSFT	Stock	83.69	83.73	83.54	83.585	1412439.0
2017-11-14 15:00:00	MSFT	Stock	83.585	84.1	83.585	84.05	3654104.0
2017-11-14 16:00:00	MSFT	Stock	84.05	84.08	83.731	83.96	1711467.0
2017-11-14 17:00:00	MSFT	Stock	83.97	83.98	83.95	83.95	500.0
2017-11-14 18:00:00	MSFT	Stock	84.0	84.0	83.95	83.95	3492.0
2017-11-14 19:00:00	MSFT	Stock	83.95	83.95	83.75	83.75	32385.0
2017-11-14 04:00:00	NVDA	Stock	5.3375	5.3425	5.3375	5.3425	75360.0
2017-11-14 05:00:00	NVDA	Stock	5.34	5.34	5.34	5.34	4040.0
2017-11-14 06:00:00	NVDA	Stock	5.3392	5.3425	5.3392	5.34	67920.0
2017-11-14 07:00:00	NVDA	Stock	5.34	5.3422	5.3212	5.3325	719560.0
2017-11-14 08:00:00	NVDA	Stock	5.3343	5.3413	5.3175	5.3175	1471240.0
2017-11-14 09:00:00	NVDA	Stock	5.3238	5.37	5.3142	5.348	79431400.0
2017-11-14 10:00:00	NVDA	Stock	5.349	5.3522	5.2808	5.3333	114395440.0
2017-11-14 11:00:00	NVDA	Stock	5.3328	5.3675	5.3292	5.3672	54647200.0
2017-11-14 12:00:00	NVDA	Stock	5.367	5.3682	5.3118	5.3154	46770120.0
2017-11-14 13:00:00	NVDA	Stock	5.3142	5.336	5.3005	5.312	49274400.0
2017-11-14 14:00:00	NVDA	Stock	5.3125	5.3393	5.3098	5.3313	39229240.0
2017-11-14 15:00:00	NVDA	Stock	5.3316	5.361	5.3313	5.3545	72358320.0
2017-11-14 16:00:00	NVDA	Stock	5.3545	5.3605	5.3408	5.3545	24878680.0
2017-11-14 17:00:00	NVDA	Stock	5.356	5.3575	5.3525	5.3575	465480.0
2017-11-14 18:00:00	NVDA	Stock	5.3575	5.3598	5.357	5.357	418800.0
2017-11-14 19:00:00	NVDA	Stock	5.357	5.357	5.3422	5.3428	449640.0
2017-11-14 04:00:00	AMZN	Stock	56.513	56.65	56.513	56.65	6000.0
2017-11-14 06:00:00	AMZN	Stock	56.6495	56.6495	56.6495	56.6495	2000.0
2017-11-14 07:00:00	AMZN	Stock	56.5555	56.5835	56.5275	56.55	28280.0
2017-11-14 08:00:00	AMZN	Stock	56.585	56.71	56.5275	56.601	170640.0

> showing 50 of 48,983 rows — these rows as CSV

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