PREVIEW / stock_1hour / 2019-08-07

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-08-07.parquet
  size:    1.1 MB
  rows:    50,766
  symbols: 2,582

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-08-07 04:00:00	AAPL	Stock	49.25	49.58	49.25	49.58	15508.0
2019-08-07 05:00:00	AAPL	Stock	49.57	49.6875	49.545	49.67	20944.0
2019-08-07 06:00:00	AAPL	Stock	49.67	49.7	49.5125	49.5125	56092.0
2019-08-07 07:00:00	AAPL	Stock	49.5	49.685	49.3875	49.43	218244.0
2019-08-07 08:00:00	AAPL	Stock	49.55	49.65	48.675	48.6925	925752.0
2019-08-07 09:00:00	AAPL	Stock	48.6775	49.05	48.455	48.74	15335116.0
2019-08-07 10:00:00	AAPL	Stock	48.745	49.35	48.5875	49.2225	19227828.0
2019-08-07 11:00:00	AAPL	Stock	49.22	49.325	49.0125	49.098	13955556.0
2019-08-07 12:00:00	AAPL	Stock	49.105	49.1725	48.885	49.15	9213144.0
2019-08-07 13:00:00	AAPL	Stock	49.15	49.6625	49.1102	49.4875	12261740.0
2019-08-07 14:00:00	AAPL	Stock	49.4875	49.675	49.345	49.6475	10980276.0
2019-08-07 15:00:00	AAPL	Stock	49.645	49.89	49.465	49.785	19468104.0
2019-08-07 16:00:00	AAPL	Stock	49.7825	49.8275	49.6825	49.75	12857784.0
2019-08-07 17:00:00	AAPL	Stock	49.76	49.775	49.7325	49.76	33952.0
2019-08-07 18:00:00	AAPL	Stock	49.755	49.875	49.7125	49.825	72460.0
2019-08-07 19:00:00	AAPL	Stock	49.825	49.86	49.675	49.7225	47116.0
2019-08-07 04:00:00	MSFT	Stock	135.49	135.5	135.22	135.5	8025.0
2019-08-07 05:00:00	MSFT	Stock	135.5	136.09	135.39	136.05	6205.0
2019-08-07 06:00:00	MSFT	Stock	135.98	136.02	135.35	135.35	12828.0
2019-08-07 07:00:00	MSFT	Stock	135.35	135.58	134.9	135.14	29644.0
2019-08-07 08:00:00	MSFT	Stock	135.35	135.58	132.59	132.61	143454.0
2019-08-07 09:00:00	MSFT	Stock	132.95	133.83	131.828	132.89	3652493.0
2019-08-07 10:00:00	MSFT	Stock	132.87	135.2	132.64	134.75	4875728.0
2019-08-07 11:00:00	MSFT	Stock	134.74	134.92	133.52	133.88	2897796.0
2019-08-07 12:00:00	MSFT	Stock	133.89	134.06	133.07	133.896	2167027.0
2019-08-07 13:00:00	MSFT	Stock	133.89	135.24	133.83	134.83	2264887.0
2019-08-07 14:00:00	MSFT	Stock	134.82	135.52	134.322	135.48	2293590.0
2019-08-07 15:00:00	MSFT	Stock	135.48	135.65	134.92	135.28	4143286.0
2019-08-07 16:00:00	MSFT	Stock	135.28	135.28	135.01	135.2	3840698.0
2019-08-07 17:00:00	MSFT	Stock	135.25	135.25	135.03	135.03	2528.0
2019-08-07 18:00:00	MSFT	Stock	135.03	135.49	135.03	135.45	4709.0
2019-08-07 19:00:00	MSFT	Stock	135.44	135.44	135.0	135.0	13160.0
2019-08-07 04:00:00	NVDA	Stock	3.8038	3.8278	3.8038	3.8278	28360.0
2019-08-07 06:00:00	NVDA	Stock	3.85	3.8552	3.845	3.845	30000.0
2019-08-07 07:00:00	NVDA	Stock	3.85	3.85	3.8175	3.8188	277720.0
2019-08-07 08:00:00	NVDA	Stock	3.8465	3.8465	3.7515	3.758	2782200.0
2019-08-07 09:00:00	NVDA	Stock	3.7555	3.7778	3.73	3.7652	41675560.0
2019-08-07 10:00:00	NVDA	Stock	3.7653	3.8283	3.7538	3.8162	50862480.0
2019-08-07 11:00:00	NVDA	Stock	3.815	3.821	3.7818	3.79	28508680.0
2019-08-07 12:00:00	NVDA	Stock	3.7931	3.81	3.7825	3.7928	20743800.0
2019-08-07 13:00:00	NVDA	Stock	3.7935	3.8335	3.7874	3.8243	22006560.0
2019-08-07 14:00:00	NVDA	Stock	3.8242	3.8592	3.8192	3.8592	29683480.0
2019-08-07 15:00:00	NVDA	Stock	3.8588	3.8588	3.8333	3.8492	45612520.0
2019-08-07 16:00:00	NVDA	Stock	3.8498	3.8498	3.7582	3.847	48704480.0
2019-08-07 17:00:00	NVDA	Stock	3.845	3.8468	3.845	3.8462	76360.0
2019-08-07 18:00:00	NVDA	Stock	3.8438	3.849	3.8428	3.849	109160.0
2019-08-07 19:00:00	NVDA	Stock	3.849	3.8522	3.849	3.8522	79960.0
2019-08-07 04:00:00	AMZN	Stock	89.984	89.998	89.842	89.842	8220.0
2019-08-07 05:00:00	AMZN	Stock	90.0505	90.25	90.047	90.174	17400.0
2019-08-07 06:00:00	AMZN	Stock	89.9255	89.9255	89.9255	89.9255	4580.0

> showing 50 of 50,766 rows — these rows as CSV

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