PREVIEW / stock_1hour / 2017-07-21

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-07-21.parquet
  size:    1.0 MB
  rows:    47,720
  symbols: 2,992

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-07-21 04:00:00	AAPL	Stock	37.58	37.58	37.58	37.58	1292.0
2017-07-21 06:00:00	AAPL	Stock	37.6	37.6	37.4625	37.525	16616.0
2017-07-21 07:00:00	AAPL	Stock	37.55	37.5575	37.525	37.5275	7628.0
2017-07-21 08:00:00	AAPL	Stock	37.55	37.56	37.505	37.5425	82972.0
2017-07-21 09:00:00	AAPL	Stock	37.52	37.5675	37.22	37.385	23039176.0
2017-07-21 10:00:00	AAPL	Stock	37.3875	37.5125	37.3475	37.419	10154380.0
2017-07-21 11:00:00	AAPL	Stock	37.42	37.4975	37.34	37.49	8328264.0
2017-07-21 12:00:00	AAPL	Stock	37.4925	37.585	37.47	37.5782	5019808.0
2017-07-21 13:00:00	AAPL	Stock	37.58	37.61	37.4975	37.525	4897524.0
2017-07-21 14:00:00	AAPL	Stock	37.5238	37.5325	37.48	37.5112	4579380.0
2017-07-21 15:00:00	AAPL	Stock	37.5125	37.5825	37.4825	37.575	15707112.0
2017-07-21 16:00:00	AAPL	Stock	37.5825	37.5825	37.3375	37.5475	11539180.0
2017-07-21 17:00:00	AAPL	Stock	37.55	37.5625	37.535	37.535	49760.0
2017-07-21 18:00:00	AAPL	Stock	37.5275	37.545	37.5275	37.5275	11000.0
2017-07-21 19:00:00	AAPL	Stock	37.56	37.5725	37.5325	37.5325	28480.0
2017-07-21 04:00:00	MSFT	Stock	74.44	75.5	74.44	75.3	11600.0
2017-07-21 05:00:00	MSFT	Stock	75.0	75.09	74.63	74.63	6179.0
2017-07-21 06:00:00	MSFT	Stock	74.75	74.92	74.16	74.54	49905.0
2017-07-21 07:00:00	MSFT	Stock	74.42	74.75	74.3	74.3	129844.0
2017-07-21 08:00:00	MSFT	Stock	74.27	74.8	73.4	73.84	1295335.0
2017-07-21 09:00:00	MSFT	Stock	73.84	74.29	73.19	73.89	13765804.0
2017-07-21 10:00:00	MSFT	Stock	73.89	74.16	73.66	73.765	6549395.0
2017-07-21 11:00:00	MSFT	Stock	73.765	73.85	73.55	73.835	3896004.0
2017-07-21 12:00:00	MSFT	Stock	73.835	73.84	73.35	73.537	3581341.0
2017-07-21 13:00:00	MSFT	Stock	73.53	73.6	73.2	73.345	2814882.0
2017-07-21 14:00:00	MSFT	Stock	73.34	73.43	73.17	73.35	2489800.0
2017-07-21 15:00:00	MSFT	Stock	73.345	73.83	73.23	73.75	6154719.0
2017-07-21 16:00:00	MSFT	Stock	73.79	73.79	73.55	73.6	2509006.0
2017-07-21 17:00:00	MSFT	Stock	73.61	73.68	73.61	73.66	23173.0
2017-07-21 18:00:00	MSFT	Stock	73.7	73.7	73.65	73.65	6890.0
2017-07-21 19:00:00	MSFT	Stock	73.65	73.69	73.55	73.57	8664.0
2017-07-21 04:00:00	NVDA	Stock	4.1888	4.1888	4.1888	4.1888	12000.0
2017-07-21 06:00:00	NVDA	Stock	4.1772	4.1772	4.1772	4.1772	10360.0
2017-07-21 07:00:00	NVDA	Stock	4.165	4.1722	4.1625	4.1688	342720.0
2017-07-21 08:00:00	NVDA	Stock	4.1688	4.1722	4.1512	4.1638	2242320.0
2017-07-21 09:00:00	NVDA	Stock	4.164	4.2185	4.1523	4.2148	125497160.0
2017-07-21 10:00:00	NVDA	Stock	4.216	4.2325	4.2	4.2075	146560000.0
2017-07-21 11:00:00	NVDA	Stock	4.2072	4.2142	4.1868	4.2048	91668480.0
2017-07-21 12:00:00	NVDA	Stock	4.205	4.2213	4.197	4.2125	63584320.0
2017-07-21 13:00:00	NVDA	Stock	4.2125	4.2163	4.194	4.2058	42587480.0
2017-07-21 14:00:00	NVDA	Stock	4.2059	4.2108	4.1934	4.2058	45277200.0
2017-07-21 15:00:00	NVDA	Stock	4.2058	4.2072	4.196	4.2008	78110280.0
2017-07-21 16:00:00	NVDA	Stock	4.2025	4.2025	4.1975	4.1975	17900600.0
2017-07-21 17:00:00	NVDA	Stock	4.1962	4.2	4.1953	4.1953	310520.0
2017-07-21 18:00:00	NVDA	Stock	4.1955	4.1995	4.1955	4.1972	94360.0
2017-07-21 19:00:00	NVDA	Stock	4.1972	4.2	4.1955	4.2	140720.0
2017-07-21 05:00:00	AMZN	Stock	51.425	51.425	51.425	51.425	2000.0
2017-07-21 06:00:00	AMZN	Stock	51.2675	51.2675	51.2675	51.2675	2000.0
2017-07-21 07:00:00	AMZN	Stock	51.27	51.275	51.27	51.27	9600.0
2017-07-21 08:00:00	AMZN	Stock	51.225	51.225	51.0475	51.05	228780.0

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

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