PREVIEW / stock_1hour / 2015-12-16

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-12-16.parquet
  size:    1.0 MB
  rows:    49,468
  symbols: 3,435

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-12-16 04:00:00	AAPL	Stock	27.6925	27.7125	27.6925	27.7125	5200.0
2015-12-16 05:00:00	AAPL	Stock	27.8025	27.825	27.735	27.825	10000.0
2015-12-16 06:00:00	AAPL	Stock	27.8	27.8	27.7125	27.7375	73208.0
2015-12-16 07:00:00	AAPL	Stock	27.745	27.745	27.6025	27.6725	161824.0
2015-12-16 08:00:00	AAPL	Stock	27.6725	27.825	27.6325	27.775	509540.0
2015-12-16 09:00:00	AAPL	Stock	27.755	27.9975	27.6588	27.66	23466016.0
2015-12-16 10:00:00	AAPL	Stock	27.66	27.7225	27.43	27.6012	33181200.0
2015-12-16 11:00:00	AAPL	Stock	27.6	27.6025	27.2325	27.2712	32744436.0
2015-12-16 12:00:00	AAPL	Stock	27.2712	27.3175	27.2	27.2625	23593808.0
2015-12-16 13:00:00	AAPL	Stock	27.2625	27.6075	27.25	27.58	18915272.0
2015-12-16 14:00:00	AAPL	Stock	27.5775	27.775	27.32	27.7738	34646972.0
2015-12-16 15:00:00	AAPL	Stock	27.7725	27.9	27.64	27.835	32499604.0
2015-12-16 16:00:00	AAPL	Stock	27.835	27.85	27.677	27.81	9064048.0
2015-12-16 17:00:00	AAPL	Stock	27.8075	27.825	27.8	27.8	86824.0
2015-12-16 18:00:00	AAPL	Stock	27.8	27.8375	27.8	27.825	53644.0
2015-12-16 19:00:00	AAPL	Stock	27.825	27.8375	27.81	27.8175	40532.0
2015-12-16 06:00:00	MSFT	Stock	55.64	55.64	55.6	55.61	5300.0
2015-12-16 07:00:00	MSFT	Stock	55.5	55.57	55.43	55.54	6127.0
2015-12-16 08:00:00	MSFT	Stock	55.48	55.57	55.48	55.53	19270.0
2015-12-16 09:00:00	MSFT	Stock	55.53	55.79	55.41	55.44	3670469.0
2015-12-16 10:00:00	MSFT	Stock	55.44	55.57	55.33	55.47	4457923.0
2015-12-16 11:00:00	MSFT	Stock	55.48	55.53	55.11	55.16	2415229.0
2015-12-16 12:00:00	MSFT	Stock	55.16	55.274	54.97	55.01	2540048.0
2015-12-16 13:00:00	MSFT	Stock	55.02	55.37	54.97	55.335	3007433.0
2015-12-16 14:00:00	MSFT	Stock	55.32	55.98	54.76	55.886	6731881.0
2015-12-16 15:00:00	MSFT	Stock	55.89	56.245	55.72	56.125	9050767.0
2015-12-16 16:00:00	MSFT	Stock	56.13	56.18	56.03	56.06	2651978.0
2015-12-16 17:00:00	MSFT	Stock	56.1	56.13	56.05	56.05	7125.0
2015-12-16 18:00:00	MSFT	Stock	56.13	56.13	56.1	56.1	800.0
2015-12-16 19:00:00	MSFT	Stock	56.13	56.13	56.07	56.08	1926.0
2015-12-16 07:00:00	NVDA	Stock	0.8338	0.8338	0.8338	0.8338	30000.0
2015-12-16 08:00:00	NVDA	Stock	0.8255	0.8268	0.8255	0.8268	20400.0
2015-12-16 09:00:00	NVDA	Stock	0.8265	0.832	0.8245	0.8248	28053840.0
2015-12-16 10:00:00	NVDA	Stock	0.8248	0.8258	0.8198	0.8198	30694760.0
2015-12-16 11:00:00	NVDA	Stock	0.8198	0.8255	0.8194	0.8245	20781880.0
2015-12-16 12:00:00	NVDA	Stock	0.8242	0.8258	0.8198	0.8205	16757080.0
2015-12-16 13:00:00	NVDA	Stock	0.8205	0.8255	0.8193	0.824	19144720.0
2015-12-16 14:00:00	NVDA	Stock	0.8232	0.8283	0.8188	0.8275	40075600.0
2015-12-16 15:00:00	NVDA	Stock	0.8278	0.8315	0.826	0.829	54385720.0
2015-12-16 16:00:00	NVDA	Stock	0.8292	0.8292	0.8292	0.8292	11771000.0
2015-12-16 19:00:00	NVDA	Stock	0.8292	0.8292	0.8292	0.8292	8000.0
2015-12-16 06:00:00	AMZN	Stock	33.15	33.15	33.15	33.15	2000.0
2015-12-16 07:00:00	AMZN	Stock	33.15	33.15	33.0945	33.0945	64060.0
2015-12-16 08:00:00	AMZN	Stock	33.15	33.2	33.0825	33.1895	266600.0
2015-12-16 09:00:00	AMZN	Stock	33.2	33.279	33.005	33.0625	6124460.0
2015-12-16 10:00:00	AMZN	Stock	33.0575	33.2275	32.966	33.2015	7163260.0
2015-12-16 11:00:00	AMZN	Stock	33.2035	33.265	33.15	33.236	4943100.0
2015-12-16 12:00:00	AMZN	Stock	33.2435	33.3082	33.1705	33.1705	3833120.0
2015-12-16 13:00:00	AMZN	Stock	33.182	33.3	33.105	33.2655	4141260.0
2015-12-16 14:00:00	AMZN	Stock	33.2595	33.797	33.0075	33.7945	21195380.0

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

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