PREVIEW / stock_1hour / 2018-05-23

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-05-23.parquet
  size:    1.1 MB
  rows:    49,175
  symbols: 2,847

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
2018-05-23 04:00:00	AAPL	Stock	46.4975	46.515	46.2625	46.2625	51424.0
2018-05-23 05:00:00	AAPL	Stock	46.2525	46.2525	46.1625	46.25	27556.0
2018-05-23 06:00:00	AAPL	Stock	46.3	46.355	46.3	46.325	14560.0
2018-05-23 07:00:00	AAPL	Stock	46.375	46.4875	46.3025	46.4	211876.0
2018-05-23 08:00:00	AAPL	Stock	46.41	46.5575	46.3025	46.5525	699636.0
2018-05-23 09:00:00	AAPL	Stock	46.5475	46.7875	46.465	46.52	9504152.0
2018-05-23 10:00:00	AAPL	Stock	46.525	46.7	46.44	46.48	8874340.0
2018-05-23 11:00:00	AAPL	Stock	46.4775	46.6375	46.4675	46.5725	6537872.0
2018-05-23 12:00:00	AAPL	Stock	46.5775	46.7425	46.5525	46.7285	5054084.0
2018-05-23 13:00:00	AAPL	Stock	46.7275	46.7425	46.63	46.6725	3613804.0
2018-05-23 14:00:00	AAPL	Stock	46.675	46.9275	46.6425	46.9132	7245220.0
2018-05-23 15:00:00	AAPL	Stock	46.9125	47.125	46.8962	47.1125	12051472.0
2018-05-23 16:00:00	AAPL	Stock	47.115	47.115	46.972	47.07	13754772.0
2018-05-23 17:00:00	AAPL	Stock	47.07	47.1425	47.07	47.125	1951716.0
2018-05-23 18:00:00	AAPL	Stock	47.1125	47.195	47.1	47.175	121664.0
2018-05-23 19:00:00	AAPL	Stock	47.1875	47.2025	47.135	47.1625	77884.0
2018-05-23 04:00:00	MSFT	Stock	96.9	96.9	96.81	96.81	874.0
2018-05-23 05:00:00	MSFT	Stock	96.75	96.76	96.74	96.76	1012.0
2018-05-23 06:00:00	MSFT	Stock	96.75	96.75	96.75	96.75	447.0
2018-05-23 07:00:00	MSFT	Stock	96.8	96.98	96.59	96.7	8316.0
2018-05-23 08:00:00	MSFT	Stock	96.55	96.84	96.55	96.63	12178.0
2018-05-23 09:00:00	MSFT	Stock	96.67	97.43	96.32	97.33	2407753.0
2018-05-23 10:00:00	MSFT	Stock	97.33	97.805	96.98	97.12	2150639.0
2018-05-23 11:00:00	MSFT	Stock	97.125	97.818	97.1	97.51	1632349.0
2018-05-23 12:00:00	MSFT	Stock	97.51	97.82	97.33	97.755	1245756.0
2018-05-23 13:00:00	MSFT	Stock	97.75	97.76	97.41	97.59	1063030.0
2018-05-23 14:00:00	MSFT	Stock	97.59	98.19	97.5	98.18	1973322.0
2018-05-23 15:00:00	MSFT	Stock	98.18	98.73	98.06	98.72	3972767.0
2018-05-23 16:00:00	MSFT	Stock	98.71	98.73	98.413	98.56	4188704.0
2018-05-23 17:00:00	MSFT	Stock	98.59	98.6	98.55	98.56	1363.0
2018-05-23 18:00:00	MSFT	Stock	98.6	98.73	98.6	98.7	8501.0
2018-05-23 19:00:00	MSFT	Stock	98.7	98.72	98.61	98.62	2972.0
2018-05-23 04:00:00	NVDA	Stock	6.0195	6.0195	5.975	5.975	187560.0
2018-05-23 05:00:00	NVDA	Stock	5.98	5.98	5.98	5.98	8000.0
2018-05-23 06:00:00	NVDA	Stock	5.9845	5.9898	5.9845	5.9858	38080.0
2018-05-23 07:00:00	NVDA	Stock	5.9962	6.0123	5.9782	5.9782	1418640.0
2018-05-23 08:00:00	NVDA	Stock	5.9904	6.0143	5.9788	6.0	3090160.0
2018-05-23 09:00:00	NVDA	Stock	6.0002	6.1103	5.983	6.088	67845200.0
2018-05-23 10:00:00	NVDA	Stock	6.0859	6.121	6.0555	6.0746	70184640.0
2018-05-23 11:00:00	NVDA	Stock	6.0738	6.1258	6.071	6.0938	54398440.0
2018-05-23 12:00:00	NVDA	Stock	6.094	6.1255	6.0903	6.123	32116840.0
2018-05-23 13:00:00	NVDA	Stock	6.1212	6.1239	6.0815	6.0918	25061160.0
2018-05-23 14:00:00	NVDA	Stock	6.0905	6.133	6.0858	6.132	41103920.0
2018-05-23 15:00:00	NVDA	Stock	6.1334	6.1898	6.1292	6.1892	80758240.0
2018-05-23 16:00:00	NVDA	Stock	6.1885	6.1918	6.1702	6.1725	10079520.0
2018-05-23 17:00:00	NVDA	Stock	6.1702	6.1778	6.1702	6.1775	146520.0
2018-05-23 18:00:00	NVDA	Stock	6.1763	6.1838	6.1763	6.1838	340240.0
2018-05-23 19:00:00	NVDA	Stock	6.1838	6.1875	6.1825	6.1875	326440.0
2018-05-23 04:00:00	AMZN	Stock	78.246	78.3	78.246	78.3	8120.0
2018-05-23 05:00:00	AMZN	Stock	78.45	78.45	78.4335	78.4335	4000.0

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

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