PREVIEW / stock_1hour / 2013-11-12

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-11-12.parquet
  size:    1.0 MB
  rows:    47,438
  symbols: 3,549

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
2013-11-12 05:00:00	AAPL	Stock	18.4839	18.4839	18.4821	18.4821	5600.0
2013-11-12 07:00:00	AAPL	Stock	18.4936	18.5204	18.475	18.5018	270760.0
2013-11-12 08:00:00	AAPL	Stock	18.4939	18.5374	18.4786	18.4964	2392572.0
2013-11-12 09:00:00	AAPL	Stock	18.5086	18.6036	18.4643	18.5999	32261880.0
2013-11-12 10:00:00	AAPL	Stock	18.6016	18.7114	18.5714	18.6282	56240744.0
2013-11-12 11:00:00	AAPL	Stock	18.6279	18.6579	18.5886	18.6093	24572408.0
2013-11-12 12:00:00	AAPL	Stock	18.6107	18.6393	18.5946	18.6161	13706336.0
2013-11-12 13:00:00	AAPL	Stock	18.6161	18.6454	18.555	18.5725	15276912.0
2013-11-12 14:00:00	AAPL	Stock	18.5733	18.5886	18.5096	18.5636	18932592.0
2013-11-12 15:00:00	AAPL	Stock	18.5646	18.5925	18.5257	18.5754	24715376.0
2013-11-12 16:00:00	AAPL	Stock	18.5718	18.6	18.5	18.5979	9709560.0
2013-11-12 17:00:00	AAPL	Stock	18.5864	18.5936	18.5839	18.5875	47236.0
2013-11-12 18:00:00	AAPL	Stock	18.5821	18.5982	18.5821	18.5982	54824.0
2013-11-12 19:00:00	AAPL	Stock	18.5989	18.6036	18.5964	18.6	127176.0
2013-11-12 06:00:00	MSFT	Stock	37.46	37.46	37.46	37.46	500.0
2013-11-12 07:00:00	MSFT	Stock	37.46	37.51	37.46	37.51	2300.0
2013-11-12 08:00:00	MSFT	Stock	37.5	37.5	37.42	37.45	10436.0
2013-11-12 09:00:00	MSFT	Stock	37.47	37.56	37.2	37.44	3905845.0
2013-11-12 10:00:00	MSFT	Stock	37.45	37.595	37.38	37.48	4179892.0
2013-11-12 11:00:00	MSFT	Stock	37.48	37.51	37.36	37.42	4193967.0
2013-11-12 12:00:00	MSFT	Stock	37.42	37.46	37.348	37.37	4413010.0
2013-11-12 13:00:00	MSFT	Stock	37.372	37.43	37.31	37.321	2665312.0
2013-11-12 14:00:00	MSFT	Stock	37.32	37.38	37.28	37.373	3089140.0
2013-11-12 15:00:00	MSFT	Stock	37.38	37.39	37.31	37.355	5461636.0
2013-11-12 16:00:00	MSFT	Stock	37.35	37.41	37.34	37.41	3085961.0
2013-11-12 18:00:00	MSFT	Stock	37.38	37.38	37.32	37.32	200.0
2013-11-12 19:00:00	MSFT	Stock	37.38	37.4	37.38	37.4	1200.0
2013-11-12 09:00:00	NVDA	Stock	0.3902	0.3962	0.3898	0.392	44324280.0
2013-11-12 10:00:00	NVDA	Stock	0.392	0.3933	0.39	0.392	63231880.0
2013-11-12 11:00:00	NVDA	Stock	0.392	0.3928	0.3905	0.3915	36582960.0
2013-11-12 12:00:00	NVDA	Stock	0.3914	0.3925	0.391	0.3915	18638880.0
2013-11-12 13:00:00	NVDA	Stock	0.3915	0.3915	0.3885	0.3896	42751200.0
2013-11-12 14:00:00	NVDA	Stock	0.3895	0.392	0.3895	0.3918	35542800.0
2013-11-12 15:00:00	NVDA	Stock	0.3918	0.393	0.391	0.393	62439480.0
2013-11-12 16:00:00	NVDA	Stock	0.393	0.3931	0.3917	0.3929	2722000.0
2013-11-12 19:00:00	NVDA	Stock	0.393	0.393	0.393	0.393	14000.0
2013-11-12 08:00:00	AMZN	Stock	17.7189	17.7189	17.6115	17.625	315240.0
2013-11-12 09:00:00	AMZN	Stock	17.6355	17.7742	17.5605	17.6155	7541940.0
2013-11-12 10:00:00	AMZN	Stock	17.6155	17.6435	17.488	17.5406	8676040.0
2013-11-12 11:00:00	AMZN	Stock	17.5335	17.5451	17.4005	17.442	5790960.0
2013-11-12 12:00:00	AMZN	Stock	17.4438	17.4685	17.365	17.45	5408680.0
2013-11-12 13:00:00	AMZN	Stock	17.4395	17.475	17.3785	17.415	2948260.0
2013-11-12 14:00:00	AMZN	Stock	17.4125	17.431	17.3641	17.4075	4286660.0
2013-11-12 15:00:00	AMZN	Stock	17.413	17.512	17.4	17.4765	8300840.0
2013-11-12 16:00:00	AMZN	Stock	17.4745	17.5054	17.4313	17.471	2178980.0
2013-11-12 17:00:00	AMZN	Stock	17.4775	17.4875	17.4775	17.4875	13800.0
2013-11-12 18:00:00	AMZN	Stock	17.4985	17.4985	17.4985	17.4985	4000.0
2013-11-12 19:00:00	AMZN	Stock	17.4775	17.4775	17.4775	17.4775	8120.0
2013-11-12 04:00:00	META	Stock	45.94	45.98	45.81	45.81	15172.0
2013-11-12 05:00:00	META	Stock	45.82	45.84	45.5	45.6	49925.0

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

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