PREVIEW / stock_1hour / 2019-07-18

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-07-18.parquet
  size:    1.1 MB
  rows:    49,765
  symbols: 2,583

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-07-18 04:00:00	AAPL	Stock	51.125	51.1725	51.0025	51.115	50888.0
2019-07-18 05:00:00	AAPL	Stock	51.075	51.15	51.025	51.025	18868.0
2019-07-18 06:00:00	AAPL	Stock	50.975	51.0875	50.975	51.0625	27780.0
2019-07-18 07:00:00	AAPL	Stock	51.0625	51.1125	50.875	50.975	182164.0
2019-07-18 08:00:00	AAPL	Stock	51.02	51.095	50.925	51.015	309408.0
2019-07-18 09:00:00	AAPL	Stock	51.015	51.445	50.925	51.305	12255364.0
2019-07-18 10:00:00	AAPL	Stock	51.31	51.3608	51.13	51.165	8674712.0
2019-07-18 11:00:00	AAPL	Stock	51.1625	51.1775	50.94	51.0075	6587320.0
2019-07-18 12:00:00	AAPL	Stock	51.0112	51.2025	50.9775	51.1838	4685280.0
2019-07-18 13:00:00	AAPL	Stock	51.1825	51.25	51.155	51.195	4397480.0
2019-07-18 14:00:00	AAPL	Stock	51.2	51.4025	51.195	51.4025	6646940.0
2019-07-18 15:00:00	AAPL	Stock	51.4038	51.47	51.2675	51.415	9668368.0
2019-07-18 16:00:00	AAPL	Stock	51.4138	51.4875	51.2588	51.4875	5573676.0
2019-07-18 17:00:00	AAPL	Stock	51.4825	51.4925	51.415	51.4925	258516.0
2019-07-18 18:00:00	AAPL	Stock	51.4925	51.55	51.4	51.4	143256.0
2019-07-18 19:00:00	AAPL	Stock	51.4	51.495	51.36	51.4925	71096.0
2019-07-18 04:00:00	MSFT	Stock	136.03	136.03	135.55	135.79	6795.0
2019-07-18 05:00:00	MSFT	Stock	135.9	136.0	135.81	136.0	3583.0
2019-07-18 06:00:00	MSFT	Stock	135.85	136.09	135.85	136.09	5857.0
2019-07-18 07:00:00	MSFT	Stock	135.86	136.15	135.86	136.0	26848.0
2019-07-18 08:00:00	MSFT	Stock	136.06	136.61	135.9	136.1	76515.0
2019-07-18 09:00:00	MSFT	Stock	136.05	136.23	134.75	135.94	2518434.0
2019-07-18 10:00:00	MSFT	Stock	135.945	136.45	135.75	135.8	2853278.0
2019-07-18 11:00:00	MSFT	Stock	135.79	135.83	134.67	135.01	2954702.0
2019-07-18 12:00:00	MSFT	Stock	135.01	135.32	134.93	135.045	2036167.0
2019-07-18 13:00:00	MSFT	Stock	135.05	135.28	134.9	135.08	1997578.0
2019-07-18 14:00:00	MSFT	Stock	135.09	136.03	135.08	135.985	2888774.0
2019-07-18 15:00:00	MSFT	Stock	135.98	136.62	135.6	136.28	5135347.0
2019-07-18 16:00:00	MSFT	Stock	136.21	140.45	132.25	138.3	4452522.0
2019-07-18 17:00:00	MSFT	Stock	138.27	139.29	136.42	139.17	531994.0
2019-07-18 18:00:00	MSFT	Stock	138.87	140.2	138.8	139.65	583024.0
2019-07-18 19:00:00	MSFT	Stock	139.66	140.05	139.53	140.05	157874.0
2019-07-18 04:00:00	NVDA	Stock	4.2075	4.2075	4.2075	4.2075	5760.0
2019-07-18 05:00:00	NVDA	Stock	4.2155	4.2155	4.2102	4.2102	18680.0
2019-07-18 06:00:00	NVDA	Stock	4.2138	4.25	4.2102	4.25	305960.0
2019-07-18 07:00:00	NVDA	Stock	4.235	4.2438	4.2338	4.2438	217760.0
2019-07-18 08:00:00	NVDA	Stock	4.24	4.2575	4.235	4.255	1354080.0
2019-07-18 09:00:00	NVDA	Stock	4.2563	4.3178	4.2478	4.282	82254960.0
2019-07-18 10:00:00	NVDA	Stock	4.2824	4.2833	4.2285	4.231	61508240.0
2019-07-18 11:00:00	NVDA	Stock	4.2318	4.2342	4.1962	4.2028	52422320.0
2019-07-18 12:00:00	NVDA	Stock	4.2026	4.2246	4.199	4.2116	39586160.0
2019-07-18 13:00:00	NVDA	Stock	4.2112	4.24	4.2095	4.2185	30382000.0
2019-07-18 14:00:00	NVDA	Stock	4.2185	4.2518	4.2178	4.2495	30028840.0
2019-07-18 15:00:00	NVDA	Stock	4.2498	4.2552	4.2396	4.2545	46183000.0
2019-07-18 16:00:00	NVDA	Stock	4.2545	4.2688	4.2525	4.2688	47045760.0
2019-07-18 17:00:00	NVDA	Stock	4.265	4.2738	4.2545	4.2675	872920.0
2019-07-18 18:00:00	NVDA	Stock	4.2702	4.2788	4.2625	4.263	592040.0
2019-07-18 19:00:00	NVDA	Stock	4.2627	4.2722	4.2625	4.2712	462880.0
2019-07-18 04:00:00	AMZN	Stock	98.95	98.95	98.77	98.77	10160.0
2019-07-18 05:00:00	AMZN	Stock	98.852	98.942	98.852	98.942	12000.0

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

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