PREVIEW / stock_1hour / 2017-06-22

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-06-22.parquet
  size:    1.0 MB
  rows:    47,770
  symbols: 3,023

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-22 04:00:00	AAPL	Stock	36.5225	36.5225	36.4875	36.4875	2516.0
2017-06-22 06:00:00	AAPL	Stock	36.485	36.485	36.45	36.45	4764.0
2017-06-22 07:00:00	AAPL	Stock	36.47	36.47	36.4125	36.4475	24492.0
2017-06-22 08:00:00	AAPL	Stock	36.45	36.48	36.4175	36.4475	86292.0
2017-06-22 09:00:00	AAPL	Stock	36.4475	36.5	36.28	36.3325	8578616.0
2017-06-22 10:00:00	AAPL	Stock	36.335	36.4475	36.28	36.38	10592260.0
2017-06-22 11:00:00	AAPL	Stock	36.38	36.3938	36.29	36.3425	6398092.0
2017-06-22 12:00:00	AAPL	Stock	36.34	36.61	36.31	36.5875	6823960.0
2017-06-22 13:00:00	AAPL	Stock	36.5892	36.675	36.56	36.605	7442184.0
2017-06-22 14:00:00	AAPL	Stock	36.605	36.63	36.56	36.5775	4872544.0
2017-06-22 15:00:00	AAPL	Stock	36.5775	36.5825	36.38	36.4075	12598136.0
2017-06-22 16:00:00	AAPL	Stock	36.41	36.4925	36.3975	36.42	11398284.0
2017-06-22 17:00:00	AAPL	Stock	36.4025	36.4125	36.4025	36.4075	29516.0
2017-06-22 18:00:00	AAPL	Stock	36.4125	36.4125	36.4025	36.4075	14992.0
2017-06-22 19:00:00	AAPL	Stock	36.4075	36.4275	36.3975	36.41	54936.0
2017-06-22 07:00:00	MSFT	Stock	70.6	70.65	70.6	70.65	500.0
2017-06-22 08:00:00	MSFT	Stock	70.6	70.78	70.6	70.7	22502.0
2017-06-22 09:00:00	MSFT	Stock	70.7	70.7	69.84	69.91	3482271.0
2017-06-22 10:00:00	MSFT	Stock	69.92	70.07	69.71	69.96	4167000.0
2017-06-22 11:00:00	MSFT	Stock	69.97	70.13	69.85	70.0	3107312.0
2017-06-22 12:00:00	MSFT	Stock	69.995	70.085	69.87	70.0	2212259.0
2017-06-22 13:00:00	MSFT	Stock	70.0	70.35	69.97	70.345	1913406.0
2017-06-22 14:00:00	MSFT	Stock	70.35	70.475	70.27	70.37	1594764.0
2017-06-22 15:00:00	MSFT	Stock	70.37	70.46	70.25	70.26	3295746.0
2017-06-22 16:00:00	MSFT	Stock	70.26	70.26	70.17	70.26	1581414.0
2017-06-22 17:00:00	MSFT	Stock	70.26	70.26	70.26	70.26	362579.0
2017-06-22 18:00:00	MSFT	Stock	70.16	70.16	70.15	70.15	950.0
2017-06-22 04:00:00	NVDA	Stock	3.9938	3.9938	3.9938	3.9938	8000.0
2017-06-22 06:00:00	NVDA	Stock	3.9852	3.994	3.9852	3.994	63160.0
2017-06-22 07:00:00	NVDA	Stock	3.9938	3.9938	3.975	3.9868	295720.0
2017-06-22 08:00:00	NVDA	Stock	3.989	3.9925	3.9688	3.975	1673840.0
2017-06-22 09:00:00	NVDA	Stock	3.975	3.995	3.935	3.9558	91809880.0
2017-06-22 10:00:00	NVDA	Stock	3.9565	4.0085	3.9475	3.9907	98025840.0
2017-06-22 11:00:00	NVDA	Stock	3.9913	3.9983	3.976	3.9875	55211120.0
2017-06-22 12:00:00	NVDA	Stock	3.9868	3.9943	3.9812	3.9818	39141760.0
2017-06-22 13:00:00	NVDA	Stock	3.9822	3.9892	3.9719	3.9818	44965840.0
2017-06-22 14:00:00	NVDA	Stock	3.983	3.9895	3.9728	3.979	32578120.0
2017-06-22 15:00:00	NVDA	Stock	3.9789	3.9828	3.9548	3.9593	67519080.0
2017-06-22 16:00:00	NVDA	Stock	3.9593	3.9715	3.9538	3.9553	7488680.0
2017-06-22 17:00:00	NVDA	Stock	3.9538	3.9575	3.95	3.955	211040.0
2017-06-22 18:00:00	NVDA	Stock	3.957	3.96	3.9558	3.9575	143000.0
2017-06-22 19:00:00	NVDA	Stock	3.9575	3.9625	3.9555	3.9615	331400.0
2017-06-22 06:00:00	AMZN	Stock	50.1145	50.1255	50.1145	50.1255	11900.0
2017-06-22 07:00:00	AMZN	Stock	50.148	50.165	50.148	50.1635	22040.0
2017-06-22 08:00:00	AMZN	Stock	50.1975	50.1975	50.0075	50.112	193260.0
2017-06-22 09:00:00	AMZN	Stock	50.0875	50.1615	49.86	50.0705	7896440.0
2017-06-22 10:00:00	AMZN	Stock	50.086	50.348	50.0555	50.2035	10282200.0
2017-06-22 11:00:00	AMZN	Stock	50.201	50.24	50.033	50.1575	4638280.0
2017-06-22 12:00:00	AMZN	Stock	50.1512	50.2435	50.01	50.174	4052640.0
2017-06-22 13:00:00	AMZN	Stock	50.1765	50.2295	50.1385	50.158	2276560.0

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

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