PREVIEW / stock_1hour / 2018-09-18

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-09-18.parquet
  size:    1.1 MB
  rows:    49,516
  symbols: 2,802

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
2018-09-18 04:00:00	AAPL	Stock	54.54	54.5825	54.525	54.5575	20696.0
2018-09-18 05:00:00	AAPL	Stock	54.55	54.72	54.55	54.6825	28908.0
2018-09-18 06:00:00	AAPL	Stock	54.6875	54.74	54.685	54.6875	39400.0
2018-09-18 07:00:00	AAPL	Stock	54.6875	54.69	54.5	54.61	163820.0
2018-09-18 08:00:00	AAPL	Stock	54.6678	54.775	54.55	54.725	710548.0
2018-09-18 09:00:00	AAPL	Stock	54.7225	55.4625	54.28	55.093	25620944.0
2018-09-18 10:00:00	AAPL	Stock	55.1025	55.345	54.835	55.0545	19506860.0
2018-09-18 11:00:00	AAPL	Stock	55.05	55.0625	54.8178	54.9075	12184060.0
2018-09-18 12:00:00	AAPL	Stock	54.9062	54.9975	54.5875	54.6882	8663996.0
2018-09-18 13:00:00	AAPL	Stock	54.6895	54.8475	54.635	54.7925	7813916.0
2018-09-18 14:00:00	AAPL	Stock	54.7925	54.9375	54.6962	54.7125	8225472.0
2018-09-18 15:00:00	AAPL	Stock	54.7125	54.7825	54.5425	54.56	15332004.0
2018-09-18 16:00:00	AAPL	Stock	54.56	54.61	54.515	54.53	8994968.0
2018-09-18 17:00:00	AAPL	Stock	54.52	54.5575	54.515	54.5478	75700.0
2018-09-18 18:00:00	AAPL	Stock	54.5575	54.625	54.5525	54.5875	65048.0
2018-09-18 19:00:00	AAPL	Stock	54.605	54.625	54.59	54.61	66692.0
2018-09-18 04:00:00	MSFT	Stock	112.2	112.31	112.2	112.3	652.0
2018-09-18 05:00:00	MSFT	Stock	112.3	112.3	112.3	112.3	3137.0
2018-09-18 06:00:00	MSFT	Stock	112.4	112.4	112.39	112.39	2700.0
2018-09-18 07:00:00	MSFT	Stock	112.31	112.68	112.3	112.49	13377.0
2018-09-18 08:00:00	MSFT	Stock	112.37	112.59	112.3	112.55	28030.0
2018-09-18 09:00:00	MSFT	Stock	112.55	113.29	111.72	113.225	2710127.0
2018-09-18 10:00:00	MSFT	Stock	113.23	113.5	113.06	113.205	3103661.0
2018-09-18 11:00:00	MSFT	Stock	113.2	113.54	113.165	113.54	2312022.0
2018-09-18 12:00:00	MSFT	Stock	113.54	113.695	113.28	113.41	1725191.0
2018-09-18 13:00:00	MSFT	Stock	113.415	113.61	113.26	113.6	1143103.0
2018-09-18 14:00:00	MSFT	Stock	113.59	113.69	113.48	113.525	1093565.0
2018-09-18 15:00:00	MSFT	Stock	113.52	113.61	113.21	113.22	3868192.0
2018-09-18 16:00:00	MSFT	Stock	113.22	113.33	113.16	113.17	2967451.0
2018-09-18 17:00:00	MSFT	Stock	113.2	113.2	113.16	113.2	1996.0
2018-09-18 18:00:00	MSFT	Stock	113.2	113.36	113.18	113.28	19700.0
2018-09-18 19:00:00	MSFT	Stock	113.28	113.35	113.25	113.25	3392.0
2018-09-18 05:00:00	NVDA	Stock	6.8975	6.8975	6.8975	6.8975	4000.0
2018-09-18 06:00:00	NVDA	Stock	6.8875	6.9	6.8875	6.899	125800.0
2018-09-18 07:00:00	NVDA	Stock	6.8862	6.897	6.8625	6.8778	395200.0
2018-09-18 08:00:00	NVDA	Stock	6.9	6.905	6.8675	6.9	892040.0
2018-09-18 09:00:00	NVDA	Stock	6.8953	6.9372	6.8375	6.9134	35325240.0
2018-09-18 10:00:00	NVDA	Stock	6.9132	6.956	6.8912	6.903	47920720.0
2018-09-18 11:00:00	NVDA	Stock	6.9048	6.9147	6.8208	6.8433	36830960.0
2018-09-18 12:00:00	NVDA	Stock	6.8448	6.8823	6.7888	6.8178	42895680.0
2018-09-18 13:00:00	NVDA	Stock	6.8182	6.828	6.7928	6.814	23873960.0
2018-09-18 14:00:00	NVDA	Stock	6.8137	6.8298	6.7958	6.8082	22494000.0
2018-09-18 15:00:00	NVDA	Stock	6.807	6.82	6.7688	6.7754	41437040.0
2018-09-18 16:00:00	NVDA	Stock	6.7755	6.7823	6.774	6.775	5111720.0
2018-09-18 17:00:00	NVDA	Stock	6.781	6.7815	6.7755	6.7815	117720.0
2018-09-18 18:00:00	NVDA	Stock	6.7815	6.7925	6.7763	6.7908	86400.0
2018-09-18 19:00:00	NVDA	Stock	6.7918	6.792	6.7875	6.792	116200.0
2018-09-18 04:00:00	AMZN	Stock	95.39	95.445	95.355	95.355	17600.0
2018-09-18 05:00:00	AMZN	Stock	95.3	95.3	95.3	95.3	2680.0
2018-09-18 06:00:00	AMZN	Stock	95.6795	95.7	95.6795	95.7	15440.0

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

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