PREVIEW / stock_1hour / 2016-04-29

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-04-29.parquet
  size:    1.0 MB
  rows:    48,237
  symbols: 3,299

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
2016-04-29 04:00:00	AAPL	Stock	23.775	23.775	23.56	23.5725	68944.0
2016-04-29 05:00:00	AAPL	Stock	23.5625	23.6	23.5475	23.6	82412.0
2016-04-29 06:00:00	AAPL	Stock	23.61	23.6225	23.5875	23.6125	73608.0
2016-04-29 07:00:00	AAPL	Stock	23.6125	23.67	23.5825	23.6475	232096.0
2016-04-29 08:00:00	AAPL	Stock	23.6475	23.7375	23.5825	23.67	1074568.0
2016-04-29 09:00:00	AAPL	Stock	23.6625	23.7025	23.4	23.4448	41205480.0
2016-04-29 10:00:00	AAPL	Stock	23.445	23.455	23.21	23.235	52625092.0
2016-04-29 11:00:00	AAPL	Stock	23.235	23.3675	23.1275	23.34	46170496.0
2016-04-29 12:00:00	AAPL	Stock	23.3375	23.4475	23.265	23.3535	22930120.0
2016-04-29 13:00:00	AAPL	Stock	23.355	23.515	23.315	23.32	21517828.0
2016-04-29 14:00:00	AAPL	Stock	23.32	23.355	23.2425	23.305	21095392.0
2016-04-29 15:00:00	AAPL	Stock	23.305	23.4725	23.3	23.435	32685536.0
2016-04-29 16:00:00	AAPL	Stock	23.4375	23.5148	23.303	23.445	13062272.0
2016-04-29 17:00:00	AAPL	Stock	23.4375	23.44	23.3775	23.3775	152048.0
2016-04-29 18:00:00	AAPL	Stock	23.3875	23.42	23.3675	23.405	90600.0
2016-04-29 19:00:00	AAPL	Stock	23.4125	23.4325	23.38	23.4	86536.0
2016-04-29 04:00:00	MSFT	Stock	49.9	49.9	49.88	49.88	2527.0
2016-04-29 05:00:00	MSFT	Stock	49.9	49.9	49.9	49.9	2100.0
2016-04-29 06:00:00	MSFT	Stock	49.9	49.9	49.81	49.81	1455.0
2016-04-29 07:00:00	MSFT	Stock	49.86	49.9	49.7	49.7	19398.0
2016-04-29 08:00:00	MSFT	Stock	49.7	49.84	49.5	49.51	51155.0
2016-04-29 09:00:00	MSFT	Stock	49.58	50.1	49.35	49.815	7110572.0
2016-04-29 10:00:00	MSFT	Stock	49.815	50.1	49.56	49.93	8381123.0
2016-04-29 11:00:00	MSFT	Stock	49.925	49.97	49.73	49.89	6098558.0
2016-04-29 12:00:00	MSFT	Stock	49.88	50.075	49.83	49.982	4333503.0
2016-04-29 13:00:00	MSFT	Stock	49.986	50.25	49.92	49.98	3894075.0
2016-04-29 14:00:00	MSFT	Stock	49.985	50.05	49.78	49.815	3711579.0
2016-04-29 15:00:00	MSFT	Stock	49.81	50.04	49.71	49.88	8289190.0
2016-04-29 16:00:00	MSFT	Stock	49.88	49.94	49.8	49.84	4057129.0
2016-04-29 17:00:00	MSFT	Stock	49.82	49.82	49.8	49.8	2400.0
2016-04-29 18:00:00	MSFT	Stock	49.8	49.85	49.8	49.85	5778.0
2016-04-29 19:00:00	MSFT	Stock	49.8	49.87	49.8	49.81	2860.0
2016-04-29 08:00:00	NVDA	Stock	0.9025	0.9025	0.9025	0.9025	9200.0
2016-04-29 09:00:00	NVDA	Stock	0.9025	0.9033	0.8822	0.883	47211760.0
2016-04-29 10:00:00	NVDA	Stock	0.8828	0.893	0.8792	0.8905	67421800.0
2016-04-29 11:00:00	NVDA	Stock	0.8905	0.8908	0.8828	0.8873	34158480.0
2016-04-29 12:00:00	NVDA	Stock	0.8873	0.8896	0.8845	0.885	20833000.0
2016-04-29 13:00:00	NVDA	Stock	0.8848	0.8905	0.884	0.8842	23705600.0
2016-04-29 14:00:00	NVDA	Stock	0.8842	0.8863	0.8785	0.881	39981480.0
2016-04-29 15:00:00	NVDA	Stock	0.881	0.8891	0.881	0.8883	60304240.0
2016-04-29 16:00:00	NVDA	Stock	0.8882	0.8885	0.886	0.8885	1997560.0
2016-04-29 18:00:00	NVDA	Stock	0.8883	0.8883	0.8883	0.8883	28000.0
2016-04-29 04:00:00	AMZN	Stock	33.7	33.7	33.5255	33.675	74460.0
2016-04-29 05:00:00	AMZN	Stock	33.742	33.85	33.742	33.85	25060.0
2016-04-29 06:00:00	AMZN	Stock	33.766	33.775	33.7	33.775	48340.0
2016-04-29 07:00:00	AMZN	Stock	33.7875	33.838	33.575	33.6	623760.0
2016-04-29 08:00:00	AMZN	Stock	33.6235	33.855	33.5345	33.7095	3045460.0
2016-04-29 09:00:00	AMZN	Stock	33.713	33.7435	32.85	32.9995	61726480.0
2016-04-29 10:00:00	AMZN	Stock	32.9965	33.175	32.725	33.1006	34708420.0
2016-04-29 11:00:00	AMZN	Stock	33.0948	33.2775	32.8338	32.9075	17456600.0

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

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