PREVIEW / stock_1hour / 2017-04-28

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-04-28.parquet
  size:    1.0 MB
  rows:    48,313
  symbols: 3,050

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-28 04:00:00	AAPL	Stock	35.99	35.99	35.99	35.99	400.0
2017-04-28 05:00:00	AAPL	Stock	35.995	35.9975	35.995	35.9975	2620.0
2017-04-28 06:00:00	AAPL	Stock	35.9975	36.0	35.9975	36.0	7100.0
2017-04-28 07:00:00	AAPL	Stock	35.975	36.0	35.965	35.995	40796.0
2017-04-28 08:00:00	AAPL	Stock	35.975	36.0	35.9625	35.9875	99780.0
2017-04-28 09:00:00	AAPL	Stock	35.9875	36.045	35.8175	35.8375	11414316.0
2017-04-28 10:00:00	AAPL	Stock	35.835	35.9588	35.8342	35.9525	7922308.0
2017-04-28 11:00:00	AAPL	Stock	35.955	35.995	35.9025	35.9875	6305656.0
2017-04-28 12:00:00	AAPL	Stock	35.9862	36.075	35.9862	36.0675	7217932.0
2017-04-28 13:00:00	AAPL	Stock	36.0675	36.0725	35.965	35.9725	4785580.0
2017-04-28 14:00:00	AAPL	Stock	35.9738	35.9775	35.8925	35.905	6636972.0
2017-04-28 15:00:00	AAPL	Stock	35.9025	35.9425	35.8625	35.91	14343976.0
2017-04-28 16:00:00	AAPL	Stock	35.92	35.9275	35.8962	35.925	10965924.0
2017-04-28 17:00:00	AAPL	Stock	35.925	35.925	35.8775	35.9125	64120.0
2017-04-28 18:00:00	AAPL	Stock	35.925	35.9425	35.9125	35.9375	41180.0
2017-04-28 19:00:00	AAPL	Stock	35.9375	35.975	35.9375	35.975	41732.0
2017-04-28 04:00:00	MSFT	Stock	68.1	68.1	67.95	68.0	1016.0
2017-04-28 05:00:00	MSFT	Stock	68.03	68.05	68.02	68.02	3822.0
2017-04-28 06:00:00	MSFT	Stock	68.01	68.07	67.95	68.06	2250.0
2017-04-28 07:00:00	MSFT	Stock	67.95	68.76	67.95	68.4	117888.0
2017-04-28 08:00:00	MSFT	Stock	68.36	68.73	68.0	68.35	291107.0
2017-04-28 09:00:00	MSFT	Stock	68.35	69.14	68.12	68.26	10383134.0
2017-04-28 10:00:00	MSFT	Stock	68.26	68.59	68.155	68.24	4843191.0
2017-04-28 11:00:00	MSFT	Stock	68.23	68.24	67.69	67.82	4033224.0
2017-04-28 12:00:00	MSFT	Stock	67.82	68.115	67.81	68.05	2528146.0
2017-04-28 13:00:00	MSFT	Stock	68.05	68.14	67.94	68.11	1667192.0
2017-04-28 14:00:00	MSFT	Stock	68.106	68.45	68.1	68.415	2606927.0
2017-04-28 15:00:00	MSFT	Stock	68.415	68.66	68.39	68.46	6768077.0
2017-04-28 16:00:00	MSFT	Stock	68.46	68.64	68.37	68.45	3200822.0
2017-04-28 17:00:00	MSFT	Stock	68.4	68.46	68.31	68.31	2620.0
2017-04-28 18:00:00	MSFT	Stock	68.32	68.33	68.32	68.33	400.0
2017-04-28 19:00:00	MSFT	Stock	68.44	68.44	68.33	68.33	2039.0
2017-04-28 05:00:00	NVDA	Stock	2.645	2.645	2.639	2.639	19320.0
2017-04-28 06:00:00	NVDA	Stock	2.6385	2.6385	2.6385	2.6385	6000.0
2017-04-28 07:00:00	NVDA	Stock	2.6385	2.6385	2.6385	2.6385	16000.0
2017-04-28 08:00:00	NVDA	Stock	2.637	2.6388	2.63	2.6388	366240.0
2017-04-28 09:00:00	NVDA	Stock	2.6315	2.641	2.6195	2.6255	54899240.0
2017-04-28 10:00:00	NVDA	Stock	2.6253	2.6288	2.6128	2.6282	58053240.0
2017-04-28 11:00:00	NVDA	Stock	2.6282	2.6393	2.6278	2.6358	35566960.0
2017-04-28 12:00:00	NVDA	Stock	2.636	2.6365	2.6203	2.6203	29074160.0
2017-04-28 13:00:00	NVDA	Stock	2.6203	2.623	2.614	2.6148	30647400.0
2017-04-28 14:00:00	NVDA	Stock	2.6146	2.6173	2.603	2.6052	32475240.0
2017-04-28 15:00:00	NVDA	Stock	2.6055	2.611	2.6018	2.6075	56220280.0
2017-04-28 16:00:00	NVDA	Stock	2.6075	2.6075	2.6028	2.6048	31588120.0
2017-04-28 17:00:00	NVDA	Stock	2.6048	2.6048	2.6	2.6048	326040.0
2017-04-28 18:00:00	NVDA	Stock	2.6013	2.605	2.6013	2.605	93120.0
2017-04-28 19:00:00	NVDA	Stock	2.6075	2.6075	2.6043	2.6043	44000.0
2017-04-28 04:00:00	AMZN	Stock	47.472	47.472	47.4	47.436	42740.0
2017-04-28 05:00:00	AMZN	Stock	47.54	47.54	47.5065	47.516	18160.0
2017-04-28 06:00:00	AMZN	Stock	47.526	47.5875	47.425	47.5875	119180.0

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

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