PREVIEW / stock_1hour / 2017-06-09

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-06-09.parquet
  size:    1.0 MB
  rows:    47,812
  symbols: 3,041

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-06-09 04:00:00	AAPL	Stock	38.75	38.75	38.75	38.75	460.0
2017-06-09 05:00:00	AAPL	Stock	38.7975	38.8375	38.7975	38.8375	12612.0
2017-06-09 06:00:00	AAPL	Stock	38.7875	38.795	38.7875	38.7875	4920.0
2017-06-09 07:00:00	AAPL	Stock	38.7825	38.7875	38.775	38.7875	29668.0
2017-06-09 08:00:00	AAPL	Stock	38.7875	38.8175	38.75	38.8025	125648.0
2017-06-09 09:00:00	AAPL	Stock	38.795	38.8	38.6025	38.71	10140700.0
2017-06-09 10:00:00	AAPL	Stock	38.71	38.7955	38.6275	38.6625	10620320.0
2017-06-09 11:00:00	AAPL	Stock	38.6625	38.7025	38.395	38.46	13869176.0
2017-06-09 12:00:00	AAPL	Stock	38.4612	38.4638	37.6052	37.8325	35008416.0
2017-06-09 13:00:00	AAPL	Stock	37.8325	37.89	37.1075	37.4238	41470164.0
2017-06-09 14:00:00	AAPL	Stock	37.4275	37.6775	36.505	36.9075	51537136.0
2017-06-09 15:00:00	AAPL	Stock	36.91	37.295	36.87	37.2425	58372536.0
2017-06-09 16:00:00	AAPL	Stock	37.2425	37.245	37.145	37.2225	15859820.0
2017-06-09 17:00:00	AAPL	Stock	37.2225	37.245	37.1875	37.2375	255856.0
2017-06-09 18:00:00	AAPL	Stock	37.2275	37.25	37.2275	37.245	100504.0
2017-06-09 19:00:00	AAPL	Stock	37.245	37.2475	37.23	37.24	140808.0
2017-06-09 04:00:00	MSFT	Stock	72.0	72.0	72.0	72.0	567.0
2017-06-09 05:00:00	MSFT	Stock	72.3	72.3	72.25	72.25	2431.0
2017-06-09 06:00:00	MSFT	Stock	72.25	72.25	72.25	72.25	400.0
2017-06-09 07:00:00	MSFT	Stock	72.2	72.2	72.2	72.2	100.0
2017-06-09 08:00:00	MSFT	Stock	72.03	72.2	72.03	72.11	6843.0
2017-06-09 09:00:00	MSFT	Stock	72.12	72.15	71.51	71.61	2200969.0
2017-06-09 10:00:00	MSFT	Stock	71.611	72.03	71.575	71.725	2637156.0
2017-06-09 11:00:00	MSFT	Stock	71.73	71.805	71.24	71.24	3322514.0
2017-06-09 12:00:00	MSFT	Stock	71.23	71.26	70.36	70.603	5380791.0
2017-06-09 13:00:00	MSFT	Stock	70.61	70.636	69.65	69.67	6254176.0
2017-06-09 14:00:00	MSFT	Stock	69.66	69.96	68.59	69.33	8235209.0
2017-06-09 15:00:00	MSFT	Stock	69.34	70.35	69.31	70.32	14696270.0
2017-06-09 16:00:00	MSFT	Stock	70.31	70.32	70.12	70.22	4034861.0
2017-06-09 17:00:00	MSFT	Stock	70.21	70.33	70.18	70.31	14587.0
2017-06-09 18:00:00	MSFT	Stock	70.27	70.4	70.26	70.4	8462.0
2017-06-09 19:00:00	MSFT	Stock	70.39	70.46	70.38	70.38	6898.0
2017-06-09 04:00:00	NVDA	Stock	3.9775	4.1075	3.9775	4.1075	1033280.0
2017-06-09 05:00:00	NVDA	Stock	4.107	4.1088	4.0848	4.0848	662960.0
2017-06-09 06:00:00	NVDA	Stock	4.094	4.1128	4.0755	4.0862	1095880.0
2017-06-09 07:00:00	NVDA	Stock	4.094	4.123	4.0862	4.1088	4809320.0
2017-06-09 08:00:00	NVDA	Stock	4.1068	4.1215	4.0765	4.0975	17455160.0
2017-06-09 09:00:00	NVDA	Stock	4.0975	4.2125	4.0918	4.173	464610840.0
2017-06-09 10:00:00	NVDA	Stock	4.173	4.1958	4.0598	4.0825	550483720.0
2017-06-09 11:00:00	NVDA	Stock	4.0828	4.0862	3.9068	3.9288	550074280.0
2017-06-09 12:00:00	NVDA	Stock	3.928	3.93	3.8025	3.8682	455657000.0
2017-06-09 13:00:00	NVDA	Stock	3.8696	4.125	3.6975	3.6992	403146640.0
2017-06-09 14:00:00	NVDA	Stock	3.6994	3.721	3.5688	3.6212	468341480.0
2017-06-09 15:00:00	NVDA	Stock	3.6215	3.805	3.6195	3.7398	598805120.0
2017-06-09 16:00:00	NVDA	Stock	3.7378	3.757	3.7368	3.7413	17432080.0
2017-06-09 17:00:00	NVDA	Stock	3.7438	3.745	3.6862	3.6862	3762240.0
2017-06-09 18:00:00	NVDA	Stock	3.687	3.7125	3.687	3.7078	1579200.0
2017-06-09 19:00:00	NVDA	Stock	3.7078	3.7395	3.7078	3.736	1650640.0
2017-06-09 07:00:00	AMZN	Stock	50.55	50.55	50.52	50.52	25700.0
2017-06-09 08:00:00	AMZN	Stock	50.5265	50.5735	50.5165	50.5505	95480.0

> showing 50 of 47,812 rows — these rows as CSV

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