PREVIEW / stock_1hour / 2014-05-29

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-05-29.parquet
  size:    1.0 MB
  rows:    47,998
  symbols: 3,550

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-05-29 04:00:00	AAPL	Stock	22.3789	22.3789	22.3789	22.3789	5600.0
2014-05-29 05:00:00	AAPL	Stock	22.3821	22.3821	22.3571	22.3643	39200.0
2014-05-29 06:00:00	AAPL	Stock	22.3311	22.4071	22.3311	22.3571	50232.0
2014-05-29 07:00:00	AAPL	Stock	22.3686	22.3811	22.34	22.3696	169652.0
2014-05-29 08:00:00	AAPL	Stock	22.3804	22.3929	22.3429	22.3821	1173984.0
2014-05-29 09:00:00	AAPL	Stock	22.3839	22.5218	22.3796	22.5011	52484152.0
2014-05-29 10:00:00	AAPL	Stock	22.4964	22.5179	22.4221	22.4614	45609928.0
2014-05-29 11:00:00	AAPL	Stock	22.4596	22.4943	22.4329	22.46	19755988.0
2014-05-29 12:00:00	AAPL	Stock	22.4596	22.53	22.4321	22.5286	22144976.0
2014-05-29 13:00:00	AAPL	Stock	22.5264	22.6407	22.525	22.6157	42328888.0
2014-05-29 14:00:00	AAPL	Stock	22.6118	22.73	22.6075	22.7029	40761308.0
2014-05-29 15:00:00	AAPL	Stock	22.7036	22.7454	22.6161	22.6886	53538744.0
2014-05-29 16:00:00	AAPL	Stock	22.6886	22.7243	22.5652	22.7139	10163916.0
2014-05-29 17:00:00	AAPL	Stock	22.7004	22.7446	22.6921	22.7446	1278088.0
2014-05-29 18:00:00	AAPL	Stock	22.7354	22.7464	22.6921	22.7321	352912.0
2014-05-29 19:00:00	AAPL	Stock	22.7325	22.7393	22.7286	22.7393	126308.0
2014-05-29 08:00:00	MSFT	Stock	40.11	40.11	40.11	40.11	300.0
2014-05-29 09:00:00	MSFT	Stock	40.11	40.19	39.915	39.945	2549918.0
2014-05-29 10:00:00	MSFT	Stock	39.94	40.1	39.935	40.05	3049340.0
2014-05-29 11:00:00	MSFT	Stock	40.055	40.14	40.02	40.045	1463569.0
2014-05-29 12:00:00	MSFT	Stock	40.04	40.09	40.02	40.03	1199362.0
2014-05-29 13:00:00	MSFT	Stock	40.03	40.04	39.91	39.99	1636781.0
2014-05-29 14:00:00	MSFT	Stock	39.995	40.13	39.99	40.11	1585701.0
2014-05-29 15:00:00	MSFT	Stock	40.11	40.35	40.1	40.34	6324065.0
2014-05-29 16:00:00	MSFT	Stock	40.34	40.348	40.102	40.131	1445193.0
2014-05-29 17:00:00	MSFT	Stock	40.28	40.34	40.25	40.28	36953.0
2014-05-29 18:00:00	MSFT	Stock	40.25	40.3	40.25	40.3	5969.0
2014-05-29 09:00:00	NVDA	Stock	0.4745	0.4782	0.4742	0.4762	17799160.0
2014-05-29 10:00:00	NVDA	Stock	0.4761	0.4778	0.4738	0.4758	26842000.0
2014-05-29 11:00:00	NVDA	Stock	0.4756	0.4769	0.4753	0.4761	24360920.0
2014-05-29 12:00:00	NVDA	Stock	0.4763	0.4763	0.4745	0.475	7594280.0
2014-05-29 13:00:00	NVDA	Stock	0.4748	0.475	0.4728	0.4731	11811440.0
2014-05-29 14:00:00	NVDA	Stock	0.473	0.4745	0.473	0.4732	15281760.0
2014-05-29 15:00:00	NVDA	Stock	0.4732	0.4742	0.4732	0.4736	34790520.0
2014-05-29 16:00:00	NVDA	Stock	0.4738	0.4739	0.4738	0.4738	30445640.0
2014-05-29 17:00:00	NVDA	Stock	0.4738	0.4738	0.4738	0.4738	94200.0
2014-05-29 08:00:00	AMZN	Stock	15.525	15.5405	15.515	15.525	98460.0
2014-05-29 09:00:00	AMZN	Stock	15.525	15.678	15.485	15.646	6885080.0
2014-05-29 10:00:00	AMZN	Stock	15.642	15.725	15.547	15.7059	10489840.0
2014-05-29 11:00:00	AMZN	Stock	15.713	15.7435	15.645	15.656	5533260.0
2014-05-29 12:00:00	AMZN	Stock	15.6545	15.7084	15.6255	15.678	2608820.0
2014-05-29 13:00:00	AMZN	Stock	15.677	15.6935	15.6565	15.6655	2883220.0
2014-05-29 14:00:00	AMZN	Stock	15.67	15.6835	15.64	15.675	3151920.0
2014-05-29 15:00:00	AMZN	Stock	15.682	15.7055	15.6025	15.689	9371720.0
2014-05-29 16:00:00	AMZN	Stock	15.689	15.6922	15.6595	15.689	1745960.0
2014-05-29 17:00:00	AMZN	Stock	15.7	15.7	15.689	15.689	32060.0
2014-05-29 18:00:00	AMZN	Stock	15.689	15.689	15.689	15.689	31460.0
2014-05-29 07:00:00	GOOGL	Stock	28.5355	28.5355	28.5355	28.5355	2000.0
2014-05-29 08:00:00	GOOGL	Stock	28.65	28.65	28.625	28.6425	40280.0
2014-05-29 09:00:00	GOOGL	Stock	28.6375	28.6885	28.4226	28.589	4418400.0

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

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