PREVIEW / stock_1hour / 2014-11-10

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-11-10.parquet
  size:    1.0 MB
  rows:    48,939
  symbols: 3,561

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-11-10 04:00:00	AAPL	Stock	27.2525	27.275	27.2375	27.25	10272.0
2014-11-10 05:00:00	AAPL	Stock	27.25	27.2725	27.225	27.2725	6120.0
2014-11-10 06:00:00	AAPL	Stock	27.2625	27.2625	27.25	27.25	8400.0
2014-11-10 07:00:00	AAPL	Stock	27.25	27.3225	27.25	27.3025	98068.0
2014-11-10 08:00:00	AAPL	Stock	27.3	27.3225	27.0075	27.2875	329960.0
2014-11-10 09:00:00	AAPL	Stock	27.285	27.31	27.225	27.2525	15810012.0
2014-11-10 10:00:00	AAPL	Stock	27.255	27.3325	27.2275	27.2888	19213392.0
2014-11-10 11:00:00	AAPL	Stock	27.29	27.2975	27.17	27.2212	15414660.0
2014-11-10 12:00:00	AAPL	Stock	27.221	27.2725	27.2162	27.2475	9351468.0
2014-11-10 13:00:00	AAPL	Stock	27.2475	27.255	27.225	27.24	6569300.0
2014-11-10 14:00:00	AAPL	Stock	27.24	27.265	27.23	27.2588	8691464.0
2014-11-10 15:00:00	AAPL	Stock	27.2575	27.285	27.1675	27.205	17841924.0
2014-11-10 16:00:00	AAPL	Stock	27.2075	27.2518	27.1875	27.2025	4695116.0
2014-11-10 17:00:00	AAPL	Stock	27.2025	27.2485	27.1775	27.1775	38752.0
2014-11-10 18:00:00	AAPL	Stock	27.1825	27.2075	27.1675	27.175	425960.0
2014-11-10 19:00:00	AAPL	Stock	27.19	27.1975	27.1625	27.165	74356.0
2014-11-10 04:00:00	MSFT	Stock	48.7	48.73	48.7	48.7	1800.0
2014-11-10 05:00:00	MSFT	Stock	48.9	48.9	48.9	48.9	700.0
2014-11-10 06:00:00	MSFT	Stock	48.78	48.78	48.74	48.74	1100.0
2014-11-10 07:00:00	MSFT	Stock	48.8	48.8	48.8	48.8	650.0
2014-11-10 08:00:00	MSFT	Stock	48.87	48.87	48.73	48.73	3290.0
2014-11-10 09:00:00	MSFT	Stock	48.73	48.74	48.56	48.615	3374564.0
2014-11-10 10:00:00	MSFT	Stock	48.615	48.87	48.55	48.785	6482003.0
2014-11-10 11:00:00	MSFT	Stock	48.79	49.15	48.78	49.11	6572840.0
2014-11-10 12:00:00	MSFT	Stock	49.1	49.11	48.95	48.97	2708602.0
2014-11-10 13:00:00	MSFT	Stock	48.97	48.989	48.82	48.84	3180714.0
2014-11-10 14:00:00	MSFT	Stock	48.835	48.97	48.8	48.846	3581177.0
2014-11-10 15:00:00	MSFT	Stock	48.845	48.965	48.78	48.89	7470293.0
2014-11-10 16:00:00	MSFT	Stock	48.89	48.89	48.633	48.89	1933940.0
2014-11-10 18:00:00	MSFT	Stock	48.82	48.89	48.8	48.89	3638.0
2014-11-10 19:00:00	MSFT	Stock	48.8	48.82	48.8	48.82	1300.0
2014-11-10 08:00:00	NVDA	Stock	0.495	0.495	0.4938	0.4938	9000.0
2014-11-10 09:00:00	NVDA	Stock	0.4935	0.5038	0.493	0.5028	35313240.0
2014-11-10 10:00:00	NVDA	Stock	0.5025	0.5035	0.4972	0.4985	48339600.0
2014-11-10 11:00:00	NVDA	Stock	0.4986	0.5	0.4979	0.499	26859560.0
2014-11-10 12:00:00	NVDA	Stock	0.4991	0.4992	0.4978	0.4981	19690560.0
2014-11-10 13:00:00	NVDA	Stock	0.4982	0.499	0.4975	0.4975	25100640.0
2014-11-10 14:00:00	NVDA	Stock	0.4975	0.4998	0.4972	0.4987	31528680.0
2014-11-10 15:00:00	NVDA	Stock	0.4985	0.5005	0.4985	0.5004	71309000.0
2014-11-10 16:00:00	NVDA	Stock	0.5005	0.501	0.4958	0.4995	1326720.0
2014-11-10 17:00:00	NVDA	Stock	0.499	0.5005	0.499	0.5005	1050000.0
2014-11-10 18:00:00	NVDA	Stock	0.5005	0.5005	0.5005	0.5005	151440.0
2014-11-10 06:00:00	AMZN	Stock	14.989	14.989	14.989	14.989	4640.0
2014-11-10 08:00:00	AMZN	Stock	15.015	15.025	15.0125	15.025	61480.0
2014-11-10 09:00:00	AMZN	Stock	15.025	15.1	14.9885	15.071	8239160.0
2014-11-10 10:00:00	AMZN	Stock	15.072	15.2445	15.0625	15.2335	10945720.0
2014-11-10 11:00:00	AMZN	Stock	15.2335	15.2425	15.1557	15.1875	5977040.0
2014-11-10 12:00:00	AMZN	Stock	15.1862	15.1975	15.143	15.1845	3182600.0
2014-11-10 13:00:00	AMZN	Stock	15.182	15.216	15.167	15.197	2673920.0
2014-11-10 14:00:00	AMZN	Stock	15.1965	15.258	15.1905	15.2565	4278520.0

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

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