PREVIEW / stock_1hour / 2014-09-11

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-09-11.parquet
  size:    1.0 MB
  rows:    49,223
  symbols: 3,588

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-09-11 04:00:00	AAPL	Stock	25.3	25.3	25.2075	25.2225	38252.0
2014-09-11 05:00:00	AAPL	Stock	25.215	25.215	25.175	25.175	21000.0
2014-09-11 06:00:00	AAPL	Stock	25.175	25.2	25.175	25.1875	87180.0
2014-09-11 07:00:00	AAPL	Stock	25.1875	25.2175	25.115	25.125	270552.0
2014-09-11 08:00:00	AAPL	Stock	25.1175	25.25	25.065	25.065	1650188.0
2014-09-11 09:00:00	AAPL	Stock	25.065	25.2112	25.0275	25.1272	34835264.0
2014-09-11 10:00:00	AAPL	Stock	25.125	25.14	24.905	24.9652	44427044.0
2014-09-11 11:00:00	AAPL	Stock	24.9675	25.035	24.9325	24.9865	25778028.0
2014-09-11 12:00:00	AAPL	Stock	24.986	25.0625	24.9725	25.0275	14786744.0
2014-09-11 13:00:00	AAPL	Stock	25.0258	25.0425	24.9275	24.97	16633248.0
2014-09-11 14:00:00	AAPL	Stock	24.9675	25.195	24.9625	25.1838	28813168.0
2014-09-11 15:00:00	AAPL	Stock	25.1835	25.36	25.1825	25.355	58429412.0
2014-09-11 16:00:00	AAPL	Stock	25.3575	25.3975	24.95	25.385	7357892.0
2014-09-11 17:00:00	AAPL	Stock	25.3875	25.4	25.33	25.3425	987496.0
2014-09-11 18:00:00	AAPL	Stock	25.345	25.3575	25.315	25.32	277492.0
2014-09-11 19:00:00	AAPL	Stock	25.325	25.34	25.315	25.33	128228.0
2014-09-11 04:00:00	MSFT	Stock	46.78	46.78	46.78	46.78	500.0
2014-09-11 07:00:00	MSFT	Stock	46.81	46.81	46.81	46.81	300.0
2014-09-11 08:00:00	MSFT	Stock	46.7	46.75	46.67	46.67	2909.0
2014-09-11 09:00:00	MSFT	Stock	46.67	46.77	46.57	46.73	2944329.0
2014-09-11 10:00:00	MSFT	Stock	46.725	46.74	46.47	46.51	4058522.0
2014-09-11 11:00:00	MSFT	Stock	46.511	46.66	46.51	46.6	4375895.0
2014-09-11 12:00:00	MSFT	Stock	46.595	46.65	46.48	46.569	2625555.0
2014-09-11 13:00:00	MSFT	Stock	46.57	46.62	46.49	46.6	4194950.0
2014-09-11 14:00:00	MSFT	Stock	46.59	46.85	46.59	46.76	2234176.0
2014-09-11 15:00:00	MSFT	Stock	46.75	47.0	46.73	47.0	4891689.0
2014-09-11 16:00:00	MSFT	Stock	47.0	47.04	46.618	47.0	2729972.0
2014-09-11 17:00:00	MSFT	Stock	47.0	47.02	46.91	46.91	11466.0
2014-09-11 18:00:00	MSFT	Stock	46.95	47.0	46.95	46.95	4286.0
2014-09-11 19:00:00	MSFT	Stock	46.95	46.95	46.95	46.95	200.0
2014-09-11 09:00:00	NVDA	Stock	0.4872	0.4885	0.4828	0.4862	34386240.0
2014-09-11 10:00:00	NVDA	Stock	0.4865	0.487	0.482	0.4832	36695960.0
2014-09-11 11:00:00	NVDA	Stock	0.4832	0.4835	0.48	0.4819	41786040.0
2014-09-11 12:00:00	NVDA	Stock	0.482	0.4855	0.482	0.4845	35501800.0
2014-09-11 13:00:00	NVDA	Stock	0.4843	0.4845	0.481	0.4832	25079920.0
2014-09-11 14:00:00	NVDA	Stock	0.4835	0.4851	0.4828	0.485	16461640.0
2014-09-11 15:00:00	NVDA	Stock	0.485	0.486	0.4845	0.4852	38905600.0
2014-09-11 16:00:00	NVDA	Stock	0.4852	0.4865	0.4852	0.4852	3732880.0
2014-09-11 17:00:00	NVDA	Stock	0.4852	0.4852	0.4852	0.4852	198040.0
2014-09-11 04:00:00	AMZN	Stock	16.425	16.425	16.425	16.425	2000.0
2014-09-11 08:00:00	AMZN	Stock	16.537	16.537	16.4395	16.45	241840.0
2014-09-11 09:00:00	AMZN	Stock	16.47	16.595	16.4515	16.594	5465420.0
2014-09-11 10:00:00	AMZN	Stock	16.5925	16.6505	16.4575	16.5	9197140.0
2014-09-11 11:00:00	AMZN	Stock	16.4975	16.512	16.4195	16.475	8175540.0
2014-09-11 12:00:00	AMZN	Stock	16.4708	16.4825	16.4375	16.4548	3708720.0
2014-09-11 13:00:00	AMZN	Stock	16.4575	16.4649	16.3195	16.383	8373000.0
2014-09-11 14:00:00	AMZN	Stock	16.3835	16.4745	16.3825	16.4625	5496260.0
2014-09-11 15:00:00	AMZN	Stock	16.4655	16.5485	16.441	16.5225	8131200.0
2014-09-11 16:00:00	AMZN	Stock	16.526	16.528	16.4758	16.526	1711440.0
2014-09-11 17:00:00	AMZN	Stock	16.5255	16.526	16.5255	16.526	13000.0

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

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