PREVIEW / stock_1hour / 2017-12-08

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-12-08.parquet
  size:    1.1 MB
  rows:    48,915
  symbols: 2,937

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-12-08 04:00:00	AAPL	Stock	42.4875	42.55	42.4875	42.5475	7600.0
2017-12-08 05:00:00	AAPL	Stock	42.5025	42.55	42.475	42.5125	15180.0
2017-12-08 06:00:00	AAPL	Stock	42.5225	42.5625	42.5225	42.535	57012.0
2017-12-08 07:00:00	AAPL	Stock	42.535	42.6	42.535	42.5625	100652.0
2017-12-08 08:00:00	AAPL	Stock	42.5	42.61	42.425	42.6	271796.0
2017-12-08 09:00:00	AAPL	Stock	42.605	42.75	42.4802	42.5248	15779352.0
2017-12-08 10:00:00	AAPL	Stock	42.525	42.6312	42.4625	42.554	12239972.0
2017-12-08 11:00:00	AAPL	Stock	42.555	42.5975	42.4075	42.475	8520396.0
2017-12-08 12:00:00	AAPL	Stock	42.475	42.5225	42.43	42.4762	5357240.0
2017-12-08 13:00:00	AAPL	Stock	42.4775	42.505	42.425	42.4662	4366700.0
2017-12-08 14:00:00	AAPL	Stock	42.4675	42.4825	42.24	42.3425	9275736.0
2017-12-08 15:00:00	AAPL	Stock	42.345	42.3762	42.205	42.34	16881608.0
2017-12-08 16:00:00	AAPL	Stock	42.3425	42.3425	42.2875	42.32	12362800.0
2017-12-08 17:00:00	AAPL	Stock	42.3125	42.345	42.3	42.345	51552.0
2017-12-08 18:00:00	AAPL	Stock	42.345	42.345	42.33	42.34	6560.0
2017-12-08 19:00:00	AAPL	Stock	42.34	42.3425	42.33	42.3425	21596.0
2017-12-08 04:00:00	MSFT	Stock	82.49	82.49	82.49	82.49	176.0
2017-12-08 06:00:00	MSFT	Stock	82.87	82.87	82.87	82.87	300.0
2017-12-08 07:00:00	MSFT	Stock	82.88	83.08	82.88	83.0	14314.0
2017-12-08 08:00:00	MSFT	Stock	82.94	83.39	82.94	83.24	39570.0
2017-12-08 09:00:00	MSFT	Stock	83.16	84.58	83.16	83.94	4458207.0
2017-12-08 10:00:00	MSFT	Stock	83.94	84.46	83.91	84.25	3639446.0
2017-12-08 11:00:00	MSFT	Stock	84.249	84.27	83.63	83.73	2118880.0
2017-12-08 12:00:00	MSFT	Stock	83.725	84.26	83.69	84.019	2167884.0
2017-12-08 13:00:00	MSFT	Stock	84.02	84.27	84.0	84.114	1732120.0
2017-12-08 14:00:00	MSFT	Stock	84.115	84.17	83.914	84.06	2113106.0
2017-12-08 15:00:00	MSFT	Stock	84.06	84.27	84.026	84.16	3202085.0
2017-12-08 16:00:00	MSFT	Stock	84.16	84.23	84.11	84.17	3201371.0
2017-12-08 17:00:00	MSFT	Stock	84.17	84.21	84.17	84.21	3348.0
2017-12-08 18:00:00	MSFT	Stock	84.22	84.24	84.17	84.22	1780.0
2017-12-08 19:00:00	MSFT	Stock	84.2	84.24	84.16	84.24	1402.0
2017-12-08 04:00:00	NVDA	Stock	4.85	4.865	4.85	4.8502	144760.0
2017-12-08 05:00:00	NVDA	Stock	4.851	4.851	4.8485	4.85	22400.0
2017-12-08 06:00:00	NVDA	Stock	4.8485	4.8485	4.831	4.844	275160.0
2017-12-08 07:00:00	NVDA	Stock	4.8428	4.85	4.8383	4.845	1107160.0
2017-12-08 08:00:00	NVDA	Stock	4.8375	4.8625	4.8125	4.8225	5766760.0
2017-12-08 09:00:00	NVDA	Stock	4.8225	4.8695	4.8042	4.8357	99635960.0
2017-12-08 10:00:00	NVDA	Stock	4.8348	4.841	4.8102	4.8178	76168440.0
2017-12-08 11:00:00	NVDA	Stock	4.8178	4.829	4.7833	4.7975	60753400.0
2017-12-08 12:00:00	NVDA	Stock	4.7958	4.8185	4.79	4.8062	32011480.0
2017-12-08 13:00:00	NVDA	Stock	4.8072	4.817	4.8045	4.8068	19946360.0
2017-12-08 14:00:00	NVDA	Stock	4.8078	4.8078	4.7798	4.7926	32167240.0
2017-12-08 15:00:00	NVDA	Stock	4.7932	4.795	4.7788	4.787	50729960.0
2017-12-08 16:00:00	NVDA	Stock	4.7872	4.7878	4.7788	4.7805	11990520.0
2017-12-08 17:00:00	NVDA	Stock	4.7825	4.787	4.7812	4.787	344480.0
2017-12-08 18:00:00	NVDA	Stock	4.7825	4.7913	4.7825	4.7913	5150320.0
2017-12-08 19:00:00	NVDA	Stock	4.7878	4.7955	4.7875	4.7875	158000.0
2017-12-08 07:00:00	AMZN	Stock	58.25	58.35	58.1505	58.24	103280.0
2017-12-08 08:00:00	AMZN	Stock	58.325	58.35	58.2105	58.345	448680.0
2017-12-08 09:00:00	AMZN	Stock	58.343	58.6395	58.325	58.5008	11318920.0

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

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