PREVIEW / stock_1hour / 2015-11-11

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-11-11.parquet
  size:    1.0 MB
  rows:    47,666
  symbols: 3,394

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
2015-11-11 04:00:00	AAPL	Stock	29.1	29.15	29.085	29.135	29188.0
2015-11-11 05:00:00	AAPL	Stock	29.1375	29.175	29.1325	29.15	20212.0
2015-11-11 06:00:00	AAPL	Stock	29.13	29.155	29.1075	29.135	28724.0
2015-11-11 07:00:00	AAPL	Stock	29.135	29.17	29.0275	29.17	139396.0
2015-11-11 08:00:00	AAPL	Stock	29.17	29.17	28.9	29.055	1471100.0
2015-11-11 09:00:00	AAPL	Stock	29.04	29.16	28.8025	28.855	32435612.0
2015-11-11 10:00:00	AAPL	Stock	28.8625	29.05	28.8075	28.8775	33215112.0
2015-11-11 11:00:00	AAPL	Stock	28.8775	29.1375	28.8325	29.096	21910796.0
2015-11-11 12:00:00	AAPL	Stock	29.0975	29.355	29.0675	29.275	25111676.0
2015-11-11 13:00:00	AAPL	Stock	29.275	29.285	29.1	29.145	15955180.0
2015-11-11 14:00:00	AAPL	Stock	29.1425	29.3025	29.1125	29.1425	14933940.0
2015-11-11 15:00:00	AAPL	Stock	29.1425	29.2075	29.025	29.0275	22609784.0
2015-11-11 16:00:00	AAPL	Stock	29.0275	29.035	28.965	28.98	3785708.0
2015-11-11 17:00:00	AAPL	Stock	28.98	29.0	28.9575	29.0	76112.0
2015-11-11 18:00:00	AAPL	Stock	29.0	29.005	28.975	28.9865	23900.0
2015-11-11 19:00:00	AAPL	Stock	28.985	28.99	28.975	28.99	36808.0
2015-11-11 04:00:00	MSFT	Stock	53.59	53.59	53.59	53.59	500.0
2015-11-11 06:00:00	MSFT	Stock	53.63	53.65	53.63	53.65	4882.0
2015-11-11 07:00:00	MSFT	Stock	53.61	53.74	53.61	53.7	12053.0
2015-11-11 08:00:00	MSFT	Stock	53.72	53.93	53.7	53.75	76872.0
2015-11-11 09:00:00	MSFT	Stock	53.75	54.0	53.46	53.47	4635789.0
2015-11-11 10:00:00	MSFT	Stock	53.47	53.775	53.464	53.74	7528588.0
2015-11-11 11:00:00	MSFT	Stock	53.75	53.995	53.67	53.96	3786960.0
2015-11-11 12:00:00	MSFT	Stock	53.95	54.2	53.94	54.19	4367791.0
2015-11-11 13:00:00	MSFT	Stock	54.19	54.2	53.895	54.0	2946651.0
2015-11-11 14:00:00	MSFT	Stock	53.996	54.08	53.86	53.88	2891395.0
2015-11-11 15:00:00	MSFT	Stock	53.87	53.9	53.65	53.65	4777021.0
2015-11-11 16:00:00	MSFT	Stock	53.65	53.67	53.55	53.57	1712012.0
2015-11-11 17:00:00	MSFT	Stock	53.59	53.65	53.59	53.65	2481749.0
2015-11-11 18:00:00	MSFT	Stock	53.58	53.646	53.58	53.6	2454.0
2015-11-11 19:00:00	MSFT	Stock	53.6	53.65	53.6	53.65	1200.0
2015-11-11 08:00:00	NVDA	Stock	0.7702	0.7727	0.7702	0.7727	122800.0
2015-11-11 09:00:00	NVDA	Stock	0.771	0.773	0.7644	0.7698	46629280.0
2015-11-11 10:00:00	NVDA	Stock	0.7695	0.77	0.7645	0.7674	62089200.0
2015-11-11 11:00:00	NVDA	Stock	0.7673	0.7706	0.7638	0.7696	65601880.0
2015-11-11 12:00:00	NVDA	Stock	0.7695	0.7763	0.7678	0.7749	46216040.0
2015-11-11 13:00:00	NVDA	Stock	0.775	0.775	0.7625	0.7625	57258680.0
2015-11-11 14:00:00	NVDA	Stock	0.7625	0.7725	0.7608	0.7636	80964200.0
2015-11-11 15:00:00	NVDA	Stock	0.7636	0.768	0.76	0.7628	216051120.0
2015-11-11 16:00:00	NVDA	Stock	0.7628	0.7638	0.7628	0.7638	1048840.0
2015-11-11 17:00:00	NVDA	Stock	0.7612	0.7612	0.7612	0.7612	48000.0
2015-11-11 18:00:00	NVDA	Stock	0.7612	0.7612	0.7612	0.7612	160000.0
2015-11-11 05:00:00	AMZN	Stock	33.1995	33.1995	33.13	33.13	9000.0
2015-11-11 06:00:00	AMZN	Stock	33.127	33.127	33.1245	33.1265	21980.0
2015-11-11 07:00:00	AMZN	Stock	33.155	33.318	33.14	33.2265	206220.0
2015-11-11 08:00:00	AMZN	Stock	33.2105	33.325	33.134	33.2225	742080.0
2015-11-11 09:00:00	AMZN	Stock	33.2215	33.6372	33.1625	33.5163	18080980.0
2015-11-11 10:00:00	AMZN	Stock	33.5245	33.6335	33.4255	33.6	13671460.0
2015-11-11 11:00:00	AMZN	Stock	33.6	33.713	33.526	33.673	10211640.0
2015-11-11 12:00:00	AMZN	Stock	33.6745	33.798	33.619	33.7345	10710360.0

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

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