PREVIEW / stock_1hour / 2017-06-07

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-06-07.parquet
  size:    1.0 MB
  rows:    47,797
  symbols: 3,042

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
2017-06-07 05:00:00	AAPL	Stock	38.6675	38.6875	38.6675	38.685	5820.0
2017-06-07 06:00:00	AAPL	Stock	38.67	38.67	38.67	38.67	800.0
2017-06-07 07:00:00	AAPL	Stock	38.655	38.7175	38.6375	38.7175	36680.0
2017-06-07 08:00:00	AAPL	Stock	38.6875	38.7375	38.6875	38.735	155356.0
2017-06-07 09:00:00	AAPL	Stock	38.735	38.95	38.7075	38.9212	15644804.0
2017-06-07 10:00:00	AAPL	Stock	38.92	38.995	38.735	38.8125	14481440.0
2017-06-07 11:00:00	AAPL	Stock	38.8125	38.9075	38.81	38.8638	7194856.0
2017-06-07 12:00:00	AAPL	Stock	38.865	38.8725	38.62	38.7275	8266396.0
2017-06-07 13:00:00	AAPL	Stock	38.73	38.83	38.7175	38.805	5888084.0
2017-06-07 14:00:00	AAPL	Stock	38.805	38.8925	38.8	38.85	6154648.0
2017-06-07 15:00:00	AAPL	Stock	38.8525	38.885	38.78	38.8425	12121132.0
2017-06-07 16:00:00	AAPL	Stock	38.8425	38.86	38.79	38.855	6788400.0
2017-06-07 17:00:00	AAPL	Stock	38.84	38.875	38.8375	38.8625	32488.0
2017-06-07 18:00:00	AAPL	Stock	38.8675	38.8725	38.8625	38.865	37032.0
2017-06-07 19:00:00	AAPL	Stock	38.8625	38.8625	38.825	38.8375	49172.0
2017-06-07 06:00:00	MSFT	Stock	72.3	72.31	72.3	72.31	260.0
2017-06-07 08:00:00	MSFT	Stock	72.6	72.67	72.6	72.67	8267.0
2017-06-07 09:00:00	MSFT	Stock	72.65	72.77	72.45	72.465	2005872.0
2017-06-07 10:00:00	MSFT	Stock	72.46	72.525	72.015	72.35	4154266.0
2017-06-07 11:00:00	MSFT	Stock	72.36	72.545	72.23	72.28	2032043.0
2017-06-07 12:00:00	MSFT	Stock	72.27	72.276	71.95	72.07	1367610.0
2017-06-07 13:00:00	MSFT	Stock	72.07	72.3	71.96	72.285	1469871.0
2017-06-07 14:00:00	MSFT	Stock	72.288	72.41	72.15	72.265	2288612.0
2017-06-07 15:00:00	MSFT	Stock	72.265	72.48	72.22	72.39	4233867.0
2017-06-07 16:00:00	MSFT	Stock	72.39	72.39	72.31	72.37	2743791.0
2017-06-07 17:00:00	MSFT	Stock	72.31	72.37	72.31	72.35	600.0
2017-06-07 18:00:00	MSFT	Stock	72.37	72.39	72.32	72.38	9379.0
2017-06-07 06:00:00	NVDA	Stock	3.6875	3.6992	3.6875	3.6992	24000.0
2017-06-07 07:00:00	NVDA	Stock	3.7	3.7002	3.6988	3.7002	127120.0
2017-06-07 08:00:00	NVDA	Stock	3.6992	3.7125	3.6962	3.7025	2108120.0
2017-06-07 09:00:00	NVDA	Stock	3.7	3.7315	3.6925	3.7175	116015080.0
2017-06-07 10:00:00	NVDA	Stock	3.7175	3.7413	3.7138	3.7286	124006160.0
2017-06-07 11:00:00	NVDA	Stock	3.7295	3.747	3.7275	3.7382	74139280.0
2017-06-07 12:00:00	NVDA	Stock	3.7378	3.7413	3.7178	3.7263	57004360.0
2017-06-07 13:00:00	NVDA	Stock	3.726	3.7302	3.7144	3.724	45453960.0
2017-06-07 14:00:00	NVDA	Stock	3.7245	3.741	3.7235	3.7342	50075440.0
2017-06-07 15:00:00	NVDA	Stock	3.7345	3.7358	3.7235	3.728	78600080.0
2017-06-07 16:00:00	NVDA	Stock	3.7282	3.73	3.7252	3.73	4219840.0
2017-06-07 17:00:00	NVDA	Stock	3.7322	3.7322	3.727	3.7275	131440.0
2017-06-07 18:00:00	NVDA	Stock	3.731	3.7322	3.7292	3.7292	312680.0
2017-06-07 19:00:00	NVDA	Stock	3.7285	3.7312	3.7285	3.73	155680.0
2017-06-07 05:00:00	AMZN	Stock	50.2605	50.3	50.2605	50.3	7500.0
2017-06-07 06:00:00	AMZN	Stock	50.25	50.25	50.1745	50.23	32240.0
2017-06-07 07:00:00	AMZN	Stock	50.2745	50.3	50.25	50.266	56220.0
2017-06-07 08:00:00	AMZN	Stock	50.2995	50.3845	50.255	50.3025	95400.0
2017-06-07 09:00:00	AMZN	Stock	50.344	50.467	50.1	50.2688	13771400.0
2017-06-07 10:00:00	AMZN	Stock	50.2758	50.4615	50.261	50.3495	8875520.0
2017-06-07 11:00:00	AMZN	Stock	50.3445	50.387	50.28	50.3575	3423240.0
2017-06-07 12:00:00	AMZN	Stock	50.3665	50.3745	50.131	50.281	4481140.0
2017-06-07 13:00:00	AMZN	Stock	50.2595	50.423	50.217	50.411	3619400.0

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

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