PREVIEW / stock_1hour / 2013-06-14

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-06-14.parquet
  size:    974 KB
  rows:    45,365
  symbols: 3,500

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-06-14 05:00:00	AAPL	Stock	15.5607	15.5718	15.5607	15.5718	68320.0
2013-06-14 06:00:00	AAPL	Stock	15.5536	15.5536	15.5357	15.5357	41244.0
2013-06-14 07:00:00	AAPL	Stock	15.5257	15.5464	15.5243	15.5411	98084.0
2013-06-14 08:00:00	AAPL	Stock	15.5589	15.5811	15.5243	15.5811	1170260.0
2013-06-14 09:00:00	AAPL	Stock	15.5804	15.5961	15.4886	15.4975	37944844.0
2013-06-14 10:00:00	AAPL	Stock	15.4975	15.5389	15.3989	15.4131	50612828.0
2013-06-14 11:00:00	AAPL	Stock	15.4129	15.4429	15.3529	15.395	38358908.0
2013-06-14 12:00:00	AAPL	Stock	15.3921	15.4278	15.375	15.3843	20321896.0
2013-06-14 13:00:00	AAPL	Stock	15.3843	15.3846	15.3036	15.3429	32039784.0
2013-06-14 14:00:00	AAPL	Stock	15.3424	15.3871	15.3286	15.3439	24140480.0
2013-06-14 15:00:00	AAPL	Stock	15.3437	15.3675	15.3346	15.3547	42573580.0
2013-06-14 16:00:00	AAPL	Stock	15.3571	15.4926	15.35	15.3589	21186760.0
2013-06-14 17:00:00	AAPL	Stock	15.355	15.3589	15.3525	15.3564	159292.0
2013-06-14 18:00:00	AAPL	Stock	15.3529	15.3557	15.3521	15.3529	43036.0
2013-06-14 19:00:00	AAPL	Stock	15.3554	15.3554	15.3489	15.3489	190932.0
2013-06-14 07:00:00	MSFT	Stock	34.6	34.61	34.6	34.6	1970.0
2013-06-14 08:00:00	MSFT	Stock	34.68	34.72	34.6	34.69	83670.0
2013-06-14 09:00:00	MSFT	Stock	34.64	34.69	34.36	34.395	7022421.0
2013-06-14 10:00:00	MSFT	Stock	34.4	34.52	34.32	34.4	7985371.0
2013-06-14 11:00:00	MSFT	Stock	34.395	34.44	34.33	34.36	4214048.0
2013-06-14 12:00:00	MSFT	Stock	34.37	34.44	34.34	34.36	3283333.0
2013-06-14 13:00:00	MSFT	Stock	34.36	34.39	34.25	34.33	3596926.0
2013-06-14 14:00:00	MSFT	Stock	34.325	34.41	34.28	34.355	3311988.0
2013-06-14 15:00:00	MSFT	Stock	34.355	34.415	34.32	34.4	7788891.0
2013-06-14 16:00:00	MSFT	Stock	34.39	34.432	34.318	34.4	15236001.0
2013-06-14 17:00:00	MSFT	Stock	34.4	34.42	34.38	34.38	7869.0
2013-06-14 18:00:00	MSFT	Stock	34.38	34.4	34.36	34.36	4100.0
2013-06-14 19:00:00	MSFT	Stock	34.33	34.39	34.27	34.27	3298.0
2013-06-14 09:00:00	NVDA	Stock	0.3605	0.3608	0.357	0.3602	21689000.0
2013-06-14 10:00:00	NVDA	Stock	0.3602	0.3608	0.3579	0.359	32609200.0
2013-06-14 11:00:00	NVDA	Stock	0.359	0.361	0.3585	0.3602	35459640.0
2013-06-14 12:00:00	NVDA	Stock	0.36	0.361	0.358	0.358	42134880.0
2013-06-14 13:00:00	NVDA	Stock	0.3582	0.3582	0.3562	0.3569	26971440.0
2013-06-14 14:00:00	NVDA	Stock	0.3569	0.3598	0.3565	0.3582	29644680.0
2013-06-14 15:00:00	NVDA	Stock	0.358	0.3602	0.358	0.3585	36381120.0
2013-06-14 16:00:00	NVDA	Stock	0.3588	0.3607	0.3587	0.3587	1702400.0
2013-06-14 17:00:00	NVDA	Stock	0.3588	0.3588	0.3588	0.3588	4880.0
2013-06-14 06:00:00	AMZN	Stock	13.84	13.845	13.84	13.845	6000.0
2013-06-14 07:00:00	AMZN	Stock	13.812	13.812	13.812	13.812	2000.0
2013-06-14 08:00:00	AMZN	Stock	13.825	13.825	13.725	13.7895	79440.0
2013-06-14 09:00:00	AMZN	Stock	13.7975	13.8535	13.7045	13.819	7119300.0
2013-06-14 10:00:00	AMZN	Stock	13.8177	13.834	13.685	13.7115	8343840.0
2013-06-14 11:00:00	AMZN	Stock	13.7136	13.8	13.7	13.76	5562580.0
2013-06-14 12:00:00	AMZN	Stock	13.764	13.822	13.75	13.7745	3737580.0
2013-06-14 13:00:00	AMZN	Stock	13.7685	13.7685	13.6721	13.7005	4187780.0
2013-06-14 14:00:00	AMZN	Stock	13.702	13.7465	13.6835	13.7052	2989400.0
2013-06-14 15:00:00	AMZN	Stock	13.7105	13.7465	13.6905	13.6975	7590340.0
2013-06-14 16:00:00	AMZN	Stock	13.7025	13.7924	13.6885	13.6995	562980.0
2013-06-14 17:00:00	AMZN	Stock	13.6995	13.6995	13.6995	13.6995	12760.0
2013-06-14 18:00:00	AMZN	Stock	13.692	13.692	13.692	13.692	4000.0

> showing 50 of 45,365 rows — these rows as CSV

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