PREVIEW / stock_1hour / 2017-05-26

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-05-26.parquet
  size:    1.0 MB
  rows:    47,309
  symbols: 3,033

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-05-26 04:00:00	AAPL	Stock	38.5	38.5	38.5	38.5	400.0
2017-05-26 05:00:00	AAPL	Stock	38.455	38.455	38.455	38.455	400.0
2017-05-26 06:00:00	AAPL	Stock	38.45	38.45	38.45	38.45	896.0
2017-05-26 07:00:00	AAPL	Stock	38.4875	38.5075	38.35	38.35	34864.0
2017-05-26 08:00:00	AAPL	Stock	38.3575	38.3875	38.3125	38.3575	144052.0
2017-05-26 09:00:00	AAPL	Stock	38.385	38.56	38.3625	38.475	9439364.0
2017-05-26 10:00:00	AAPL	Stock	38.4725	38.51	38.3978	38.4125	7771312.0
2017-05-26 11:00:00	AAPL	Stock	38.415	38.4293	38.365	38.3675	6587464.0
2017-05-26 12:00:00	AAPL	Stock	38.365	38.45	38.3625	38.398	4968176.0
2017-05-26 13:00:00	AAPL	Stock	38.3975	38.4465	38.3775	38.4425	4879384.0
2017-05-26 14:00:00	AAPL	Stock	38.44	38.48	38.4075	38.4412	6047492.0
2017-05-26 15:00:00	AAPL	Stock	38.4415	38.465	38.3275	38.3975	12784912.0
2017-05-26 16:00:00	AAPL	Stock	38.4	38.4375	38.2575	38.355	9653348.0
2017-05-26 17:00:00	AAPL	Stock	38.34	38.345	38.3175	38.345	47064.0
2017-05-26 18:00:00	AAPL	Stock	38.3475	38.3475	38.325	38.34	17024.0
2017-05-26 19:00:00	AAPL	Stock	38.335	38.3475	38.325	38.33	59396.0
2017-05-26 07:00:00	MSFT	Stock	69.54	69.54	69.52	69.52	15218.0
2017-05-26 08:00:00	MSFT	Stock	69.58	69.72	69.44	69.6	25965.0
2017-05-26 09:00:00	MSFT	Stock	69.7	69.99	69.52	69.86	2045945.0
2017-05-26 10:00:00	MSFT	Stock	69.86	70.22	69.84	70.01	3393444.0
2017-05-26 11:00:00	MSFT	Stock	70.015	70.06	69.88	69.915	1695440.0
2017-05-26 12:00:00	MSFT	Stock	69.92	70.085	69.85	70.025	1485133.0
2017-05-26 13:00:00	MSFT	Stock	70.025	70.04	69.96	70.0	1401861.0
2017-05-26 14:00:00	MSFT	Stock	70.0	70.04	69.94	69.995	1488254.0
2017-05-26 15:00:00	MSFT	Stock	70.0	70.02	69.83	69.96	5283168.0
2017-05-26 16:00:00	MSFT	Stock	69.97	69.99	69.959	69.99	1434423.0
2017-05-26 17:00:00	MSFT	Stock	69.99	70.03	69.95	70.03	4795.0
2017-05-26 18:00:00	MSFT	Stock	70.0	70.02	70.0	70.02	600.0
2017-05-26 19:00:00	MSFT	Stock	69.96	70.03	69.96	70.03	767.0
2017-05-26 05:00:00	NVDA	Stock	3.465	3.465	3.465	3.465	9600.0
2017-05-26 06:00:00	NVDA	Stock	3.4518	3.4518	3.4465	3.4465	103480.0
2017-05-26 07:00:00	NVDA	Stock	3.4502	3.4502	3.4325	3.4325	123600.0
2017-05-26 08:00:00	NVDA	Stock	3.4435	3.4435	3.425	3.44	1053920.0
2017-05-26 09:00:00	NVDA	Stock	3.4382	3.471	3.4278	3.4542	82180600.0
2017-05-26 10:00:00	NVDA	Stock	3.4542	3.4672	3.4388	3.4595	65756480.0
2017-05-26 11:00:00	NVDA	Stock	3.459	3.4865	3.4568	3.4781	88913040.0
2017-05-26 12:00:00	NVDA	Stock	3.4781	3.4988	3.4775	3.4988	70341360.0
2017-05-26 13:00:00	NVDA	Stock	3.4983	3.5088	3.4943	3.5	72832280.0
2017-05-26 14:00:00	NVDA	Stock	3.4998	3.632	3.4943	3.5225	172985120.0
2017-05-26 15:00:00	NVDA	Stock	3.5222	3.5465	3.5155	3.5458	177590200.0
2017-05-26 16:00:00	NVDA	Stock	3.5465	3.5545	3.5202	3.5505	6694400.0
2017-05-26 17:00:00	NVDA	Stock	3.5495	3.5518	3.549	3.55	309480.0
2017-05-26 18:00:00	NVDA	Stock	3.5488	3.5528	3.5488	3.5515	646000.0
2017-05-26 19:00:00	NVDA	Stock	3.5513	3.556	3.551	3.556	318720.0
2017-05-26 06:00:00	AMZN	Stock	49.6495	49.782	49.6495	49.65	20040.0
2017-05-26 07:00:00	AMZN	Stock	49.6685	49.725	49.578	49.6	80960.0
2017-05-26 08:00:00	AMZN	Stock	49.6	49.66	49.525	49.66	104620.0
2017-05-26 09:00:00	AMZN	Stock	49.7395	49.9105	49.565	49.854	12731580.0
2017-05-26 10:00:00	AMZN	Stock	49.8505	49.9325	49.682	49.7	10728760.0
2017-05-26 11:00:00	AMZN	Stock	49.715	49.781	49.6252	49.656	6729600.0

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

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