PREVIEW / stock_1hour / 2017-04-27

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-04-27.parquet
  size:    1.0 MB
  rows:    48,256
  symbols: 3,029

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-04-27 04:00:00	AAPL	Stock	35.9375	35.9975	35.9375	35.9375	15304.0
2017-04-27 05:00:00	AAPL	Stock	35.9125	35.9375	35.8825	35.9125	8496.0
2017-04-27 06:00:00	AAPL	Stock	35.93	35.9875	35.915	35.9875	17460.0
2017-04-27 07:00:00	AAPL	Stock	35.9675	35.97	35.9375	35.945	33664.0
2017-04-27 08:00:00	AAPL	Stock	35.96	35.9875	35.9375	35.9425	115044.0
2017-04-27 09:00:00	AAPL	Stock	35.96	36.04	35.8578	35.8975	8678340.0
2017-04-27 10:00:00	AAPL	Stock	35.8965	35.9375	35.8275	35.845	7793408.0
2017-04-27 11:00:00	AAPL	Stock	35.845	35.91	35.8375	35.9075	5405952.0
2017-04-27 12:00:00	AAPL	Stock	35.9075	35.9725	35.89	35.97	3992876.0
2017-04-27 13:00:00	AAPL	Stock	35.9718	35.975	35.93	35.955	2923828.0
2017-04-27 14:00:00	AAPL	Stock	35.9525	35.955	35.9	35.9425	3512568.0
2017-04-27 15:00:00	AAPL	Stock	35.9425	35.9725	35.8725	35.9475	10594768.0
2017-04-27 16:00:00	AAPL	Stock	35.9475	35.99	35.875	35.92	8231156.0
2017-04-27 17:00:00	AAPL	Stock	35.925	35.985	35.915	35.97	137896.0
2017-04-27 18:00:00	AAPL	Stock	35.97	35.975	35.95	35.975	68820.0
2017-04-27 19:00:00	AAPL	Stock	35.975	35.9775	35.9575	35.975	38520.0
2017-04-27 04:00:00	MSFT	Stock	68.29	68.29	67.92	67.92	3200.0
2017-04-27 06:00:00	MSFT	Stock	68.03	68.13	67.91	68.03	2953.0
2017-04-27 07:00:00	MSFT	Stock	68.16	68.39	68.08	68.3	18770.0
2017-04-27 08:00:00	MSFT	Stock	68.24	68.37	68.0	68.26	97952.0
2017-04-27 09:00:00	MSFT	Stock	68.27	68.31	67.66	67.82	3603403.0
2017-04-27 10:00:00	MSFT	Stock	67.82	68.055	67.74	67.805	4308334.0
2017-04-27 11:00:00	MSFT	Stock	67.806	67.89	67.75	67.826	2429050.0
2017-04-27 12:00:00	MSFT	Stock	67.83	67.88	67.58	67.815	3243609.0
2017-04-27 13:00:00	MSFT	Stock	67.815	67.88	67.73	67.87	2490094.0
2017-04-27 14:00:00	MSFT	Stock	67.865	68.035	67.84	67.915	3442721.0
2017-04-27 15:00:00	MSFT	Stock	67.92	68.38	67.88	68.29	7521994.0
2017-04-27 16:00:00	MSFT	Stock	68.27	68.66	65.81	67.21	3356621.0
2017-04-27 17:00:00	MSFT	Stock	67.21	67.67	67.18	67.52	342300.0
2017-04-27 18:00:00	MSFT	Stock	67.53	68.44	67.5	68.07	414499.0
2017-04-27 19:00:00	MSFT	Stock	68.08	68.08	67.77	67.96	63682.0
2017-04-27 05:00:00	NVDA	Stock	2.5843	2.5843	2.5843	2.5843	22000.0
2017-04-27 06:00:00	NVDA	Stock	2.6105	2.6178	2.6105	2.6178	8000.0
2017-04-27 07:00:00	NVDA	Stock	2.5952	2.5952	2.59	2.59	8080.0
2017-04-27 08:00:00	NVDA	Stock	2.5965	2.5988	2.5962	2.5962	134000.0
2017-04-27 09:00:00	NVDA	Stock	2.5988	2.6195	2.5898	2.6108	53928520.0
2017-04-27 10:00:00	NVDA	Stock	2.611	2.6448	2.6102	2.6372	61922320.0
2017-04-27 11:00:00	NVDA	Stock	2.6371	2.6415	2.6317	2.641	29464560.0
2017-04-27 12:00:00	NVDA	Stock	2.6415	2.6486	2.6398	2.6485	25300440.0
2017-04-27 13:00:00	NVDA	Stock	2.6483	2.6495	2.641	2.6429	32738600.0
2017-04-27 14:00:00	NVDA	Stock	2.6429	2.646	2.637	2.6391	24998680.0
2017-04-27 15:00:00	NVDA	Stock	2.6391	2.6435	2.632	2.6408	50166600.0
2017-04-27 16:00:00	NVDA	Stock	2.641	2.647	2.6315	2.6448	4034200.0
2017-04-27 17:00:00	NVDA	Stock	2.6352	2.641	2.6325	2.6345	282440.0
2017-04-27 18:00:00	NVDA	Stock	2.64	2.6425	2.638	2.638	215440.0
2017-04-27 19:00:00	NVDA	Stock	2.6425	2.644	2.641	2.644	29200.0
2017-04-27 06:00:00	AMZN	Stock	45.545	45.6	45.545	45.6	6220.0
2017-04-27 07:00:00	AMZN	Stock	45.639	45.6395	45.5875	45.6	39500.0
2017-04-27 08:00:00	AMZN	Stock	45.5875	45.63	45.541	45.55	176900.0
2017-04-27 09:00:00	AMZN	Stock	45.551	45.825	45.55	45.6888	9911500.0

> showing 50 of 48,256 rows — these rows as CSV

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