PREVIEW / stock_1hour / 2019-10-18

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-10-18.parquet
  size:    1.1 MB
  rows:    48,553
  symbols: 2,488

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-10-18 04:00:00	AAPL	Stock	58.84	58.84	58.7275	58.7275	2452.0
2019-10-18 06:00:00	AAPL	Stock	58.75	58.8125	58.75	58.75	3000.0
2019-10-18 07:00:00	AAPL	Stock	58.7925	58.8625	58.7875	58.855	49880.0
2019-10-18 08:00:00	AAPL	Stock	58.865	58.865	58.755	58.7875	126216.0
2019-10-18 09:00:00	AAPL	Stock	58.7875	59.005	58.59	58.98	14600140.0
2019-10-18 10:00:00	AAPL	Stock	58.9775	59.0705	58.74	58.8838	11104272.0
2019-10-18 11:00:00	AAPL	Stock	58.885	59.045	58.735	58.7838	7651520.0
2019-10-18 12:00:00	AAPL	Stock	58.785	58.875	58.5725	58.81	8235144.0
2019-10-18 13:00:00	AAPL	Stock	58.8125	59.1425	58.7975	59.0275	6801256.0
2019-10-18 14:00:00	AAPL	Stock	59.0275	59.1825	58.985	59.1775	5186604.0
2019-10-18 15:00:00	AAPL	Stock	59.18	59.395	59.0675	59.07	15007892.0
2019-10-18 16:00:00	AAPL	Stock	59.1025	59.1175	59.07	59.1	9263720.0
2019-10-18 17:00:00	AAPL	Stock	59.0975	59.105	59.0525	59.0675	39052.0
2019-10-18 18:00:00	AAPL	Stock	59.075	59.1	59.075	59.075	31488.0
2019-10-18 19:00:00	AAPL	Stock	59.0875	59.0925	59.0525	59.0525	49524.0
2019-10-18 04:00:00	MSFT	Stock	139.64	140.04	139.64	140.04	1900.0
2019-10-18 05:00:00	MSFT	Stock	140.02	140.2	140.01	140.1	6093.0
2019-10-18 06:00:00	MSFT	Stock	140.17	140.19	140.06	140.06	1970.0
2019-10-18 07:00:00	MSFT	Stock	140.05	140.2	140.01	140.18	18266.0
2019-10-18 08:00:00	MSFT	Stock	140.07	140.28	140.02	140.15	55059.0
2019-10-18 09:00:00	MSFT	Stock	140.08	140.16	139.31	139.61	4334618.0
2019-10-18 10:00:00	MSFT	Stock	139.615	139.625	138.2	138.34	3047669.0
2019-10-18 11:00:00	MSFT	Stock	138.35	138.365	137.03	137.07	3788202.0
2019-10-18 12:00:00	MSFT	Stock	137.05	137.445	136.56	137.216	4700314.0
2019-10-18 13:00:00	MSFT	Stock	137.216	138.23	137.16	138.17	2394771.0
2019-10-18 14:00:00	MSFT	Stock	138.18	138.495	138.01	138.13	1772740.0
2019-10-18 15:00:00	MSFT	Stock	138.14	138.28	137.34	137.34	3745312.0
2019-10-18 16:00:00	MSFT	Stock	137.28	137.65	137.28	137.52	2696786.0
2019-10-18 17:00:00	MSFT	Stock	137.55	137.6	137.41	137.5	14488.0
2019-10-18 18:00:00	MSFT	Stock	137.55	137.69	137.55	137.69	4520.0
2019-10-18 19:00:00	MSFT	Stock	137.73	137.73	137.65	137.7	5740.0
2019-10-18 04:00:00	NVDA	Stock	4.8573	4.8573	4.8573	4.8573	4000.0
2019-10-18 07:00:00	NVDA	Stock	4.8465	4.8465	4.8338	4.8413	271520.0
2019-10-18 08:00:00	NVDA	Stock	4.8358	4.8573	4.8358	4.8475	557800.0
2019-10-18 09:00:00	NVDA	Stock	4.8452	4.8905	4.839	4.8525	47171760.0
2019-10-18 10:00:00	NVDA	Stock	4.8525	4.8708	4.7755	4.8048	49679480.0
2019-10-18 11:00:00	NVDA	Stock	4.8042	4.8042	4.7172	4.7215	45453920.0
2019-10-18 12:00:00	NVDA	Stock	4.721	4.742	4.6875	4.7378	45555240.0
2019-10-18 13:00:00	NVDA	Stock	4.7378	4.7758	4.7362	4.7685	22142680.0
2019-10-18 14:00:00	NVDA	Stock	4.7685	4.7788	4.7555	4.776	19743800.0
2019-10-18 15:00:00	NVDA	Stock	4.777	4.7972	4.7588	4.7605	35319920.0
2019-10-18 16:00:00	NVDA	Stock	4.7623	4.7746	4.7525	4.7662	13705440.0
2019-10-18 17:00:00	NVDA	Stock	4.7653	4.7668	4.7607	4.7623	71040.0
2019-10-18 18:00:00	NVDA	Stock	4.7625	4.7662	4.7605	4.7612	121120.0
2019-10-18 19:00:00	NVDA	Stock	4.7627	4.7627	4.7565	4.7612	88760.0
2019-10-18 05:00:00	AMZN	Stock	89.175	89.175	89.175	89.175	2000.0
2019-10-18 06:00:00	AMZN	Stock	89.324	89.324	89.324	89.324	2000.0
2019-10-18 07:00:00	AMZN	Stock	89.4	89.5745	89.4	89.5745	42100.0
2019-10-18 08:00:00	AMZN	Stock	89.45	89.646	89.374	89.374	91440.0
2019-10-18 09:00:00	AMZN	Stock	89.45	89.699	89.0803	89.25	8434620.0

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

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