PREVIEW / stock_1hour / 2016-03-28

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-03-28.parquet
  size:    1.0 MB
  rows:    47,827
  symbols: 3,350

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-03-28 04:00:00	AAPL	Stock	26.375	26.475	26.375	26.415	2208.0
2016-03-28 06:00:00	AAPL	Stock	26.475	26.4925	26.475	26.4925	4800.0
2016-03-28 07:00:00	AAPL	Stock	26.4775	26.57	26.4775	26.4875	44996.0
2016-03-28 08:00:00	AAPL	Stock	26.4875	26.57	26.455	26.485	127356.0
2016-03-28 09:00:00	AAPL	Stock	26.495	26.56	26.305	26.3925	12267740.0
2016-03-28 10:00:00	AAPL	Stock	26.39	26.48	26.3425	26.3888	10800796.0
2016-03-28 11:00:00	AAPL	Stock	26.3875	26.44	26.345	26.4362	7053084.0
2016-03-28 12:00:00	AAPL	Stock	26.4388	26.4475	26.3475	26.3778	6749108.0
2016-03-28 13:00:00	AAPL	Stock	26.3788	26.385	26.3125	26.35	6658656.0
2016-03-28 14:00:00	AAPL	Stock	26.3525	26.3775	26.2875	26.33	6774532.0
2016-03-28 15:00:00	AAPL	Stock	26.33	26.37	26.265	26.2975	13084716.0
2016-03-28 16:00:00	AAPL	Stock	26.2975	26.3275	26.2475	26.285	6596292.0
2016-03-28 17:00:00	AAPL	Stock	26.2825	26.3	26.265	26.2775	80004.0
2016-03-28 18:00:00	AAPL	Stock	26.2825	26.2825	26.2625	26.275	41496.0
2016-03-28 19:00:00	AAPL	Stock	26.275	26.28	26.275	26.275	40104.0
2016-03-28 04:00:00	MSFT	Stock	54.4	54.4	54.4	54.4	600.0
2016-03-28 06:00:00	MSFT	Stock	54.49	54.49	54.49	54.49	195.0
2016-03-28 08:00:00	MSFT	Stock	54.4	54.4	54.26	54.27	3500.0
2016-03-28 09:00:00	MSFT	Stock	54.28	54.31	53.705	53.78	1754680.0
2016-03-28 10:00:00	MSFT	Stock	53.77	53.83	53.61	53.705	1782331.0
2016-03-28 11:00:00	MSFT	Stock	53.71	53.81	53.6	53.68	1429353.0
2016-03-28 12:00:00	MSFT	Stock	53.69	53.805	53.62	53.705	1483662.0
2016-03-28 13:00:00	MSFT	Stock	53.708	53.708	53.48	53.58	1564072.0
2016-03-28 14:00:00	MSFT	Stock	53.59	53.71	53.33	53.424	2049868.0
2016-03-28 15:00:00	MSFT	Stock	53.42	53.57	53.38	53.54	3623440.0
2016-03-28 16:00:00	MSFT	Stock	53.54	53.58	53.54	53.56	2120058.0
2016-03-28 17:00:00	MSFT	Stock	53.56	53.56	53.56	53.56	125.0
2016-03-28 19:00:00	MSFT	Stock	53.5	53.57	53.5	53.57	1141.0
2016-03-28 08:00:00	NVDA	Stock	0.8575	0.8575	0.8575	0.8575	4000.0
2016-03-28 09:00:00	NVDA	Stock	0.8605	0.8712	0.8595	0.8628	22830240.0
2016-03-28 10:00:00	NVDA	Stock	0.8628	0.8712	0.8608	0.8697	30277280.0
2016-03-28 11:00:00	NVDA	Stock	0.8695	0.874	0.868	0.871	41557680.0
2016-03-28 12:00:00	NVDA	Stock	0.8711	0.8745	0.8672	0.8697	20402120.0
2016-03-28 13:00:00	NVDA	Stock	0.8696	0.8718	0.868	0.8705	20222840.0
2016-03-28 14:00:00	NVDA	Stock	0.8708	0.8715	0.867	0.8679	37310440.0
2016-03-28 15:00:00	NVDA	Stock	0.8678	0.8722	0.8675	0.871	56992920.0
2016-03-28 16:00:00	NVDA	Stock	0.8708	0.8725	0.87	0.87	1223040.0
2016-03-28 18:00:00	NVDA	Stock	0.8725	0.8738	0.8725	0.8738	167000.0
2016-03-28 04:00:00	AMZN	Stock	29.1475	29.1475	29.1475	29.1475	10000.0
2016-03-28 06:00:00	AMZN	Stock	29.275	29.2995	29.2005	29.2005	11180.0
2016-03-28 07:00:00	AMZN	Stock	29.2005	29.2695	29.2	29.2495	54980.0
2016-03-28 08:00:00	AMZN	Stock	29.2495	29.27	29.1825	29.2	308860.0
2016-03-28 09:00:00	AMZN	Stock	29.201	29.2375	28.778	28.889	11680680.0
2016-03-28 10:00:00	AMZN	Stock	28.8825	29.0765	28.8755	29.043	10631400.0
2016-03-28 11:00:00	AMZN	Stock	29.0535	29.215	29.0125	29.181	6554640.0
2016-03-28 12:00:00	AMZN	Stock	29.1825	29.207	29.005	29.074	5428240.0
2016-03-28 13:00:00	AMZN	Stock	29.0837	29.0863	28.978	29.063	4191660.0
2016-03-28 14:00:00	AMZN	Stock	29.0635	29.137	28.965	28.9995	5603800.0
2016-03-28 15:00:00	AMZN	Stock	29.002	29.062	28.9745	28.9935	9356880.0
2016-03-28 16:00:00	AMZN	Stock	28.9935	29.025	28.8989	29.025	397480.0

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

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