PREVIEW / stock_1hour / 2019-05-29

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-05-29.parquet
  size:    1.1 MB
  rows:    49,900
  symbols: 2,612

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
2019-05-29 04:00:00	AAPL	Stock	44.125	44.3375	44.125	44.1375	38212.0
2019-05-29 05:00:00	AAPL	Stock	44.1375	44.1375	43.875	43.9875	95776.0
2019-05-29 06:00:00	AAPL	Stock	44.0	44.215	44.0	44.215	31308.0
2019-05-29 07:00:00	AAPL	Stock	44.2	44.225	44.0225	44.075	187120.0
2019-05-29 08:00:00	AAPL	Stock	44.1125	44.2075	43.9078	44.0875	444064.0
2019-05-29 09:00:00	AAPL	Stock	44.1	44.555	44.0	44.4908	16378468.0
2019-05-29 10:00:00	AAPL	Stock	44.5	44.8375	44.42	44.439	16295444.0
2019-05-29 11:00:00	AAPL	Stock	44.4375	44.505	44.0925	44.2225	16195828.0
2019-05-29 12:00:00	AAPL	Stock	44.22	44.5125	44.165	44.4015	10058980.0
2019-05-29 13:00:00	AAPL	Stock	44.4075	44.63	44.3675	44.4525	8669316.0
2019-05-29 14:00:00	AAPL	Stock	44.45	44.5325	44.2325	44.295	7960604.0
2019-05-29 15:00:00	AAPL	Stock	44.2925	44.4875	44.195	44.3375	16454484.0
2019-05-29 16:00:00	AAPL	Stock	44.345	44.4	44.3175	44.3475	5657376.0
2019-05-29 17:00:00	AAPL	Stock	44.345	44.35	44.3	44.305	36960.0
2019-05-29 18:00:00	AAPL	Stock	44.3225	44.4075	44.32	44.4075	74572.0
2019-05-29 19:00:00	AAPL	Stock	44.4	44.425	44.3375	44.3875	30100.0
2019-05-29 04:00:00	MSFT	Stock	125.5	125.78	125.3	125.35	725.0
2019-05-29 06:00:00	MSFT	Stock	125.22	125.49	125.22	125.49	3298.0
2019-05-29 07:00:00	MSFT	Stock	125.75	125.76	125.32	125.41	5473.0
2019-05-29 08:00:00	MSFT	Stock	125.605	125.65	125.23	125.43	17206.0
2019-05-29 09:00:00	MSFT	Stock	125.45	125.55	124.56	124.67	2453930.0
2019-05-29 10:00:00	MSFT	Stock	124.67	125.39	124.42	124.91	2561781.0
2019-05-29 11:00:00	MSFT	Stock	124.9	125.33	124.04	124.32	2496665.0
2019-05-29 12:00:00	MSFT	Stock	124.305	124.66	124.15	124.56	1961614.0
2019-05-29 13:00:00	MSFT	Stock	124.56	125.38	124.42	125.17	1768514.0
2019-05-29 14:00:00	MSFT	Stock	125.165	125.315	124.48	124.77	1868491.0
2019-05-29 15:00:00	MSFT	Stock	124.76	125.221	124.435	124.94	3543729.0
2019-05-29 16:00:00	MSFT	Stock	125.03	125.099	124.76	124.92	3030296.0
2019-05-29 17:00:00	MSFT	Stock	124.8	124.9	124.76	124.76	3293.0
2019-05-29 18:00:00	MSFT	Stock	124.83	125.0	124.83	124.96	7684.0
2019-05-29 19:00:00	MSFT	Stock	125.0	125.0	124.96	124.96	441.0
2019-05-29 04:00:00	NVDA	Stock	3.5375	3.5375	3.5375	3.5375	17040.0
2019-05-29 06:00:00	NVDA	Stock	3.5365	3.5365	3.5365	3.5365	27360.0
2019-05-29 07:00:00	NVDA	Stock	3.5333	3.5502	3.5333	3.5425	337280.0
2019-05-29 08:00:00	NVDA	Stock	3.542	3.5561	3.53	3.542	1671600.0
2019-05-29 09:00:00	NVDA	Stock	3.5375	3.5455	3.494	3.5265	110990040.0
2019-05-29 10:00:00	NVDA	Stock	3.5265	3.5705	3.5165	3.5271	98587880.0
2019-05-29 11:00:00	NVDA	Stock	3.5258	3.542	3.4735	3.4888	86957960.0
2019-05-29 12:00:00	NVDA	Stock	3.4892	3.5283	3.4855	3.5141	54030760.0
2019-05-29 13:00:00	NVDA	Stock	3.5148	3.5402	3.5132	3.5196	47368560.0
2019-05-29 14:00:00	NVDA	Stock	3.5199	3.5225	3.4795	3.4902	49349760.0
2019-05-29 15:00:00	NVDA	Stock	3.4905	3.5175	3.4808	3.5078	84151440.0
2019-05-29 16:00:00	NVDA	Stock	3.5085	3.51	3.4925	3.5	4471560.0
2019-05-29 17:00:00	NVDA	Stock	3.5	3.5	3.4955	3.496	99640.0
2019-05-29 18:00:00	NVDA	Stock	3.4975	3.5	3.495	3.4985	581760.0
2019-05-29 19:00:00	NVDA	Stock	3.5	3.5052	3.4928	3.4928	824680.0
2019-05-29 04:00:00	AMZN	Stock	91.341	91.341	91.341	91.341	4000.0
2019-05-29 05:00:00	AMZN	Stock	91.2465	91.25	90.925	90.925	45580.0
2019-05-29 06:00:00	AMZN	Stock	91.1945	91.267	91.1945	91.267	20460.0
2019-05-29 07:00:00	AMZN	Stock	91.348	91.3585	91.0	91.2	277080.0

> showing 50 of 49,900 rows — these rows as CSV

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