PREVIEW / stock_1hour / 2014-07-11

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-07-11.parquet
  size:    1.0 MB
  rows:    48,487
  symbols: 3,537

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
2014-07-11 04:00:00	AAPL	Stock	23.795	23.8125	23.7925	23.8075	6448.0
2014-07-11 05:00:00	AAPL	Stock	23.8025	23.82	23.8	23.8	11568.0
2014-07-11 06:00:00	AAPL	Stock	23.8	23.8375	23.8	23.8325	24900.0
2014-07-11 07:00:00	AAPL	Stock	23.81	23.835	23.7875	23.7925	51716.0
2014-07-11 08:00:00	AAPL	Stock	23.81	23.845	23.7875	23.805	364560.0
2014-07-11 09:00:00	AAPL	Stock	23.805	23.905	23.74	23.825	22278512.0
2014-07-11 10:00:00	AAPL	Stock	23.825	23.9725	23.795	23.9175	24756548.0
2014-07-11 11:00:00	AAPL	Stock	23.9175	23.9375	23.805	23.8375	14347040.0
2014-07-11 12:00:00	AAPL	Stock	23.835	23.835	23.7325	23.7575	10555356.0
2014-07-11 13:00:00	AAPL	Stock	23.755	23.8125	23.7475	23.7512	9250416.0
2014-07-11 14:00:00	AAPL	Stock	23.752	23.79	23.7155	23.7625	12258108.0
2014-07-11 15:00:00	AAPL	Stock	23.765	23.805	23.74	23.805	21296520.0
2014-07-11 16:00:00	AAPL	Stock	23.8075	23.8922	23.7838	23.8175	7829536.0
2014-07-11 17:00:00	AAPL	Stock	23.825	23.8325	23.8075	23.8225	198440.0
2014-07-11 18:00:00	AAPL	Stock	23.825	23.825	23.8075	23.82	40756.0
2014-07-11 19:00:00	AAPL	Stock	23.815	23.8275	23.815	23.8275	73912.0
2014-07-11 04:00:00	MSFT	Stock	41.7	41.7	41.7	41.7	100.0
2014-07-11 05:00:00	MSFT	Stock	41.7	41.7	41.7	41.7	100.0
2014-07-11 07:00:00	MSFT	Stock	41.82	41.85	41.82	41.85	300.0
2014-07-11 08:00:00	MSFT	Stock	41.9	41.9	41.68	41.68	5200.0
2014-07-11 09:00:00	MSFT	Stock	41.7	41.8	41.48	41.5	3682487.0
2014-07-11 10:00:00	MSFT	Stock	41.5	41.73	41.48	41.73	2795528.0
2014-07-11 11:00:00	MSFT	Stock	41.73	41.89	41.71	41.806	2303272.0
2014-07-11 12:00:00	MSFT	Stock	41.8	41.91	41.78	41.881	1803121.0
2014-07-11 13:00:00	MSFT	Stock	41.886	41.95	41.88	41.93	1958559.0
2014-07-11 14:00:00	MSFT	Stock	41.93	42.015	41.91	41.96	2479454.0
2014-07-11 15:00:00	MSFT	Stock	41.967	42.09	41.95	42.08	5286093.0
2014-07-11 16:00:00	MSFT	Stock	42.09	42.15	41.861	42.09	2761501.0
2014-07-11 17:00:00	MSFT	Stock	42.09	42.09	41.9	41.9	10997.0
2014-07-11 18:00:00	MSFT	Stock	42.08	42.08	42.08	42.08	500.0
2014-07-11 19:00:00	MSFT	Stock	42.09	42.11	42.08	42.11	3779.0
2014-07-11 08:00:00	NVDA	Stock	0.475	0.475	0.475	0.475	4000.0
2014-07-11 09:00:00	NVDA	Stock	0.4758	0.4778	0.474	0.477	22643400.0
2014-07-11 10:00:00	NVDA	Stock	0.4768	0.477	0.4748	0.4758	31860280.0
2014-07-11 11:00:00	NVDA	Stock	0.4759	0.4761	0.4745	0.4748	21198320.0
2014-07-11 12:00:00	NVDA	Stock	0.4748	0.4753	0.474	0.4741	13819480.0
2014-07-11 13:00:00	NVDA	Stock	0.474	0.475	0.474	0.475	9277720.0
2014-07-11 14:00:00	NVDA	Stock	0.4749	0.4754	0.4742	0.4748	20611280.0
2014-07-11 15:00:00	NVDA	Stock	0.4749	0.4765	0.4742	0.4763	56121920.0
2014-07-11 16:00:00	NVDA	Stock	0.4763	0.4763	0.4753	0.4753	8111400.0
2014-07-11 17:00:00	NVDA	Stock	0.4763	0.4763	0.4763	0.4763	33520.0
2014-07-11 18:00:00	NVDA	Stock	0.4763	0.4785	0.4763	0.4785	28000.0
2014-07-11 06:00:00	AMZN	Stock	16.5065	16.5065	16.5065	16.5065	2400.0
2014-07-11 07:00:00	AMZN	Stock	16.553	16.7	16.553	16.675	225260.0
2014-07-11 08:00:00	AMZN	Stock	16.649	16.725	16.45	16.664	550340.0
2014-07-11 09:00:00	AMZN	Stock	16.664	17.068	16.664	17.0314	34877480.0
2014-07-11 10:00:00	AMZN	Stock	17.029	17.171	17.025	17.147	29855560.0
2014-07-11 11:00:00	AMZN	Stock	17.148	17.1625	17.0125	17.014	14882080.0
2014-07-11 12:00:00	AMZN	Stock	17.0152	17.2485	17.0145	17.248	15763860.0
2014-07-11 13:00:00	AMZN	Stock	17.247	17.3235	17.1565	17.3025	16154920.0

> showing 50 of 48,487 rows — these rows as CSV

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