PREVIEW / stock_1hour / 2015-06-22

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-06-22.parquet
  size:    1.1 MB
  rows:    49,538
  symbols: 3,531

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-06-22 04:00:00	AAPL	Stock	31.845	31.9725	31.845	31.9725	74280.0
2015-06-22 05:00:00	AAPL	Stock	31.9725	31.985	31.925	31.97	34204.0
2015-06-22 06:00:00	AAPL	Stock	31.9275	31.9325	31.855	31.8675	84344.0
2015-06-22 07:00:00	AAPL	Stock	31.8875	31.9275	31.875	31.8875	297072.0
2015-06-22 08:00:00	AAPL	Stock	31.8875	31.9075	31.8125	31.83	842116.0
2015-06-22 09:00:00	AAPL	Stock	31.8325	31.925	31.805	31.8448	21416220.0
2015-06-22 10:00:00	AAPL	Stock	31.8438	31.9	31.815	31.865	17834188.0
2015-06-22 11:00:00	AAPL	Stock	31.865	32.015	31.835	31.9925	20799832.0
2015-06-22 12:00:00	AAPL	Stock	31.9925	32.0	31.87	31.91	12752680.0
2015-06-22 13:00:00	AAPL	Stock	31.91	31.91	31.77	31.885	12710184.0
2015-06-22 14:00:00	AAPL	Stock	31.8875	31.915	31.8325	31.8935	9556492.0
2015-06-22 15:00:00	AAPL	Stock	31.8948	31.91	31.86	31.9025	12668244.0
2015-06-22 16:00:00	AAPL	Stock	31.9	31.9125	31.8175	31.8775	19583604.0
2015-06-22 17:00:00	AAPL	Stock	31.8775	31.9525	31.875	31.88	545784.0
2015-06-22 18:00:00	AAPL	Stock	31.8875	31.9025	31.8875	31.8975	63080.0
2015-06-22 19:00:00	AAPL	Stock	31.9	31.9125	31.8925	31.895	86584.0
2015-06-22 04:00:00	MSFT	Stock	46.4	46.43	46.4	46.43	290.0
2015-06-22 06:00:00	MSFT	Stock	46.38	46.38	46.33	46.33	3600.0
2015-06-22 07:00:00	MSFT	Stock	46.34	46.41	46.34	46.4	1000.0
2015-06-22 08:00:00	MSFT	Stock	46.4	46.4	46.31	46.33	18939.0
2015-06-22 09:00:00	MSFT	Stock	46.36	46.567	46.22	46.48	2886270.0
2015-06-22 10:00:00	MSFT	Stock	46.48	46.59	46.41	46.564	2315784.0
2015-06-22 11:00:00	MSFT	Stock	46.56	46.72	46.48	46.485	2068667.0
2015-06-22 12:00:00	MSFT	Stock	46.49	46.52	46.31	46.35	1605897.0
2015-06-22 13:00:00	MSFT	Stock	46.346	46.36	46.235	46.36	1287782.0
2015-06-22 14:00:00	MSFT	Stock	46.36	46.37	46.21	46.36	1555832.0
2015-06-22 15:00:00	MSFT	Stock	46.36	46.37	46.16	46.245	3113584.0
2015-06-22 16:00:00	MSFT	Stock	46.24	46.25	46.11	46.23	4334250.0
2015-06-22 17:00:00	MSFT	Stock	46.24	46.24	46.24	46.24	600.0
2015-06-22 18:00:00	MSFT	Stock	46.15	46.25	46.15	46.25	725.0
2015-06-22 19:00:00	MSFT	Stock	46.25	46.25	46.25	46.25	1950.0
2015-06-22 09:00:00	NVDA	Stock	0.547	0.55	0.547	0.55	33738440.0
2015-06-22 10:00:00	NVDA	Stock	0.5499	0.55	0.5488	0.5498	28561440.0
2015-06-22 11:00:00	NVDA	Stock	0.5495	0.5508	0.5485	0.5488	45713080.0
2015-06-22 12:00:00	NVDA	Stock	0.5485	0.549	0.5442	0.5458	44713560.0
2015-06-22 13:00:00	NVDA	Stock	0.5456	0.5502	0.5448	0.5498	87671680.0
2015-06-22 14:00:00	NVDA	Stock	0.5498	0.5501	0.5362	0.5438	139112240.0
2015-06-22 15:00:00	NVDA	Stock	0.5436	0.5455	0.543	0.5442	103439880.0
2015-06-22 16:00:00	NVDA	Stock	0.5442	0.5444	0.5435	0.5435	3131440.0
2015-06-22 18:00:00	NVDA	Stock	0.544	0.544	0.544	0.544	16000.0
2015-06-22 19:00:00	NVDA	Stock	0.544	0.544	0.543	0.543	68000.0
2015-06-22 07:00:00	AMZN	Stock	21.95	21.95	21.9005	21.9005	51740.0
2015-06-22 08:00:00	AMZN	Stock	21.955	21.972	21.9	21.9095	83500.0
2015-06-22 09:00:00	AMZN	Stock	21.907	21.962	21.8325	21.8694	4714520.0
2015-06-22 10:00:00	AMZN	Stock	21.8705	21.94	21.8075	21.848	5236700.0
2015-06-22 11:00:00	AMZN	Stock	21.84	21.9	21.8175	21.8685	3373580.0
2015-06-22 12:00:00	AMZN	Stock	21.865	21.8705	21.764	21.8105	4369400.0
2015-06-22 13:00:00	AMZN	Stock	21.8196	21.828	21.709	21.775	3915520.0
2015-06-22 14:00:00	AMZN	Stock	21.767	21.874	21.7395	21.8438	3202840.0
2015-06-22 15:00:00	AMZN	Stock	21.8475	21.8735	21.767	21.815	4727320.0

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

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