PREVIEW / stock_1hour / 2016-10-13

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-10-13.parquet
  size:    1.0 MB
  rows:    47,925
  symbols: 3,200

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-10-13 04:00:00	AAPL	Stock	29.225	29.2325	29.2	29.22	129868.0
2016-10-13 05:00:00	AAPL	Stock	29.225	29.225	29.2025	29.2025	19704.0
2016-10-13 06:00:00	AAPL	Stock	29.2025	29.22	29.19	29.2125	109384.0
2016-10-13 07:00:00	AAPL	Stock	29.205	29.2275	29.17	29.22	107448.0
2016-10-13 08:00:00	AAPL	Stock	29.22	29.275	29.125	29.16	496624.0
2016-10-13 09:00:00	AAPL	Stock	29.1625	29.32	28.995	29.0688	30226560.0
2016-10-13 10:00:00	AAPL	Stock	29.07	29.1125	28.93	29.015	26302420.0
2016-10-13 11:00:00	AAPL	Stock	29.015	29.1825	28.9775	29.1475	17922116.0
2016-10-13 12:00:00	AAPL	Stock	29.15	29.2325	29.1125	29.1825	11898060.0
2016-10-13 13:00:00	AAPL	Stock	29.186	29.255	29.1278	29.2475	9989180.0
2016-10-13 14:00:00	AAPL	Stock	29.2475	29.305	29.2035	29.3	13518960.0
2016-10-13 15:00:00	AAPL	Stock	29.3	29.36	29.175	29.2475	16875620.0
2016-10-13 16:00:00	AAPL	Stock	29.245	29.2675	29.1775	29.255	4321064.0
2016-10-13 17:00:00	AAPL	Stock	29.2475	29.26	29.215	29.245	178436.0
2016-10-13 18:00:00	AAPL	Stock	29.2475	29.2575	29.245	29.255	120688.0
2016-10-13 19:00:00	AAPL	Stock	29.2575	29.2575	29.215	29.245	196036.0
2016-10-13 07:00:00	MSFT	Stock	56.8	56.8	56.77	56.77	3500.0
2016-10-13 08:00:00	MSFT	Stock	56.7	56.89	56.7	56.71	16094.0
2016-10-13 09:00:00	MSFT	Stock	56.72	56.8	56.42	56.52	3457520.0
2016-10-13 10:00:00	MSFT	Stock	56.525	56.605	56.315	56.5	3808858.0
2016-10-13 11:00:00	MSFT	Stock	56.5	56.85	56.435	56.845	2916289.0
2016-10-13 12:00:00	MSFT	Stock	56.84	57.09	56.77	57.09	1938862.0
2016-10-13 13:00:00	MSFT	Stock	57.1	57.21	57.0	57.21	1794813.0
2016-10-13 14:00:00	MSFT	Stock	57.21	57.3	57.13	57.245	2739372.0
2016-10-13 15:00:00	MSFT	Stock	57.25	57.25	56.85	56.92	4205199.0
2016-10-13 16:00:00	MSFT	Stock	56.92	57.02	56.92	56.95	2609151.0
2016-10-13 17:00:00	MSFT	Stock	56.97	56.99	56.97	56.99	1525.0
2016-10-13 18:00:00	MSFT	Stock	56.96	56.98	56.96	56.97	8803.0
2016-10-13 04:00:00	NVDA	Stock	1.6508	1.6508	1.6508	1.6508	4000.0
2016-10-13 07:00:00	NVDA	Stock	1.6413	1.6413	1.6402	1.6402	18000.0
2016-10-13 08:00:00	NVDA	Stock	1.6402	1.6573	1.6402	1.6425	408280.0
2016-10-13 09:00:00	NVDA	Stock	1.645	1.645	1.5983	1.6052	79498320.0
2016-10-13 10:00:00	NVDA	Stock	1.6048	1.6148	1.5925	1.6038	93655280.0
2016-10-13 11:00:00	NVDA	Stock	1.604	1.6195	1.601	1.6195	40476560.0
2016-10-13 12:00:00	NVDA	Stock	1.6194	1.631	1.6175	1.6305	38208720.0
2016-10-13 13:00:00	NVDA	Stock	1.6305	1.6368	1.629	1.6368	29953600.0
2016-10-13 14:00:00	NVDA	Stock	1.6368	1.6402	1.6335	1.639	32961360.0
2016-10-13 15:00:00	NVDA	Stock	1.6392	1.6409	1.6302	1.6338	64071520.0
2016-10-13 16:00:00	NVDA	Stock	1.6338	1.6338	1.6315	1.6315	799600.0
2016-10-13 17:00:00	NVDA	Stock	1.6335	1.636	1.6315	1.6315	36200.0
2016-10-13 18:00:00	NVDA	Stock	1.6325	1.6325	1.6325	1.6325	8000.0
2016-10-13 19:00:00	NVDA	Stock	1.6325	1.6325	1.6325	1.6325	45800.0
2016-10-13 04:00:00	AMZN	Stock	41.3995	41.4	41.377	41.4	14200.0
2016-10-13 05:00:00	AMZN	Stock	41.45	41.45	41.4495	41.45	14000.0
2016-10-13 06:00:00	AMZN	Stock	41.48	41.482	41.48	41.482	10260.0
2016-10-13 07:00:00	AMZN	Stock	41.487	41.5	41.457	41.495	75380.0
2016-10-13 08:00:00	AMZN	Stock	41.4755	41.505	41.403	41.437	269380.0
2016-10-13 09:00:00	AMZN	Stock	41.4325	41.475	41.0605	41.134	14316060.0
2016-10-13 10:00:00	AMZN	Stock	41.133	41.2965	41.1	41.178	9404020.0
2016-10-13 11:00:00	AMZN	Stock	41.187	41.345	41.1035	41.3385	5937040.0

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

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