PREVIEW / stock_1hour / 2017-11-20

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-11-20.parquet
  size:    1.1 MB
  rows:    49,140
  symbols: 2,936

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-20 04:00:00	AAPL	Stock	42.475	42.475	42.475	42.475	1948.0
2017-11-20 05:00:00	AAPL	Stock	42.475	42.475	42.475	42.475	400.0
2017-11-20 06:00:00	AAPL	Stock	42.5	42.5475	42.5	42.525	10820.0
2017-11-20 07:00:00	AAPL	Stock	42.5075	42.5875	42.5	42.55	38472.0
2017-11-20 08:00:00	AAPL	Stock	42.555	42.66	42.515	42.635	151148.0
2017-11-20 09:00:00	AAPL	Stock	42.6425	42.675	42.4275	42.5425	9191916.0
2017-11-20 10:00:00	AAPL	Stock	42.5375	42.59	42.4325	42.5175	9645264.0
2017-11-20 11:00:00	AAPL	Stock	42.519	42.53	42.4	42.4865	7389540.0
2017-11-20 12:00:00	AAPL	Stock	42.4875	42.4925	42.39	42.491	5090028.0
2017-11-20 13:00:00	AAPL	Stock	42.4912	42.5575	42.48	42.5025	4448708.0
2017-11-20 14:00:00	AAPL	Stock	42.5	42.5125	42.465	42.5075	3780864.0
2017-11-20 15:00:00	AAPL	Stock	42.5075	42.535	42.4625	42.4975	8182116.0
2017-11-20 16:00:00	AAPL	Stock	42.495	42.5	42.475	42.495	10436184.0
2017-11-20 17:00:00	AAPL	Stock	42.4925	42.4975	42.4925	42.495	30020.0
2017-11-20 18:00:00	AAPL	Stock	42.495	42.5175	42.475	42.5175	77348.0
2017-11-20 19:00:00	AAPL	Stock	42.5025	42.52	42.4875	42.5025	41092.0
2017-11-20 04:00:00	MSFT	Stock	82.3	82.3	82.25	82.25	300.0
2017-11-20 07:00:00	MSFT	Stock	82.4	82.4	82.36	82.36	1252.0
2017-11-20 08:00:00	MSFT	Stock	82.4	82.51	82.35	82.4	15336.0
2017-11-20 09:00:00	MSFT	Stock	82.48	82.65	82.31	82.42	1393488.0
2017-11-20 10:00:00	MSFT	Stock	82.425	82.56	82.25	82.5	1802035.0
2017-11-20 11:00:00	MSFT	Stock	82.5	82.59	82.42	82.495	1362171.0
2017-11-20 12:00:00	MSFT	Stock	82.498	82.53	82.31	82.51	1474237.0
2017-11-20 13:00:00	MSFT	Stock	82.505	82.52	82.4	82.49	1536088.0
2017-11-20 14:00:00	MSFT	Stock	82.496	82.54	82.39	82.435	1424128.0
2017-11-20 15:00:00	MSFT	Stock	82.436	82.59	82.39	82.54	2475177.0
2017-11-20 16:00:00	MSFT	Stock	82.53	82.55	82.48	82.55	1951759.0
2017-11-20 17:00:00	MSFT	Stock	82.5	82.6	82.45	82.6	732.0
2017-11-20 18:00:00	MSFT	Stock	82.47	82.5	82.45	82.5	1057.0
2017-11-20 19:00:00	MSFT	Stock	82.53	82.53	82.53	82.53	1000.0
2017-11-20 04:00:00	NVDA	Stock	5.3338	5.3338	5.26	5.26	67680.0
2017-11-20 05:00:00	NVDA	Stock	5.2625	5.2625	5.2625	5.2625	39920.0
2017-11-20 06:00:00	NVDA	Stock	5.275	5.284	5.275	5.284	44000.0
2017-11-20 07:00:00	NVDA	Stock	5.29	5.3	5.284	5.2938	444520.0
2017-11-20 08:00:00	NVDA	Stock	5.2938	5.302	5.2778	5.289	655440.0
2017-11-20 09:00:00	NVDA	Stock	5.289	5.32	5.2625	5.289	58407800.0
2017-11-20 10:00:00	NVDA	Stock	5.2901	5.3306	5.2764	5.3295	64212960.0
2017-11-20 11:00:00	NVDA	Stock	5.3292	5.3592	5.3208	5.3578	49490440.0
2017-11-20 12:00:00	NVDA	Stock	5.3569	5.3642	5.336	5.3484	51608760.0
2017-11-20 13:00:00	NVDA	Stock	5.3485	5.3608	5.3428	5.3525	27774560.0
2017-11-20 14:00:00	NVDA	Stock	5.3528	5.3625	5.3288	5.3478	41326840.0
2017-11-20 15:00:00	NVDA	Stock	5.3482	5.3562	5.3362	5.3508	51767600.0
2017-11-20 16:00:00	NVDA	Stock	5.3502	5.3525	5.3374	5.35	21774320.0
2017-11-20 17:00:00	NVDA	Stock	5.3482	5.355	5.3482	5.354	357120.0
2017-11-20 18:00:00	NVDA	Stock	5.355	5.3573	5.352	5.352	538880.0
2017-11-20 19:00:00	NVDA	Stock	5.3565	5.3568	5.352	5.3568	360120.0
2017-11-20 04:00:00	AMZN	Stock	56.4675	56.4675	56.462	56.462	7120.0
2017-11-20 05:00:00	AMZN	Stock	56.511	56.515	56.511	56.515	12000.0
2017-11-20 07:00:00	AMZN	Stock	56.5055	56.565	56.4685	56.55	30820.0
2017-11-20 08:00:00	AMZN	Stock	56.57	56.682	56.5	56.61	470340.0

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

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