PREVIEW / stock_1hour / 2018-10-18

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-10-18.parquet
  size:    1.1 MB
  rows:    49,107
  symbols: 2,757

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-10-18 04:00:00	AAPL	Stock	55.15	55.2625	55.055	55.1625	20136.0
2018-10-18 05:00:00	AAPL	Stock	55.1625	55.175	55.0	55.0	36188.0
2018-10-18 06:00:00	AAPL	Stock	55.0625	55.0625	54.925	54.925	10236.0
2018-10-18 07:00:00	AAPL	Stock	54.99	54.995	54.75	54.75	331640.0
2018-10-18 08:00:00	AAPL	Stock	55.0	55.0	54.6525	54.87	477572.0
2018-10-18 09:00:00	AAPL	Stock	54.855	54.8725	54.425	54.6162	13023396.0
2018-10-18 10:00:00	AAPL	Stock	54.605	54.935	54.44	54.815	13549400.0
2018-10-18 11:00:00	AAPL	Stock	54.82	54.8625	53.9675	54.0725	17112596.0
2018-10-18 12:00:00	AAPL	Stock	54.0725	54.52	54.005	54.2825	10007244.0
2018-10-18 13:00:00	AAPL	Stock	54.28	54.32	53.7125	53.9	14016640.0
2018-10-18 14:00:00	AAPL	Stock	53.9025	54.285	53.855	54.0615	10291092.0
2018-10-18 15:00:00	AAPL	Stock	54.06	54.1225	53.25	54.03	16338760.0
2018-10-18 16:00:00	AAPL	Stock	54.005	54.7985	53.995	54.105	9409188.0
2018-10-18 17:00:00	AAPL	Stock	54.1125	54.155	54.075	54.15	71812.0
2018-10-18 18:00:00	AAPL	Stock	54.125	54.125	54.0275	54.105	72184.0
2018-10-18 19:00:00	AAPL	Stock	54.0875	54.1725	54.0875	54.125	113020.0
2018-10-18 04:00:00	MSFT	Stock	110.68	110.71	110.64	110.71	800.0
2018-10-18 06:00:00	MSFT	Stock	110.71	110.71	110.69	110.69	1712.0
2018-10-18 07:00:00	MSFT	Stock	110.5	110.67	110.13	110.31	6605.0
2018-10-18 08:00:00	MSFT	Stock	110.1	110.65	110.1	110.52	15082.0
2018-10-18 09:00:00	MSFT	Stock	110.51	110.63	109.89	110.025	2516681.0
2018-10-18 10:00:00	MSFT	Stock	110.02	110.18	109.59	109.85	3083509.0
2018-10-18 11:00:00	MSFT	Stock	109.87	110.02	107.905	108.28	4282472.0
2018-10-18 12:00:00	MSFT	Stock	108.27	109.45	108.105	109.0	2738725.0
2018-10-18 13:00:00	MSFT	Stock	109.0	109.034	107.83	108.2	3597817.0
2018-10-18 14:00:00	MSFT	Stock	108.14	108.92	108.04	108.58	2706516.0
2018-10-18 15:00:00	MSFT	Stock	108.575	108.84	108.13	108.51	5160969.0
2018-10-18 16:00:00	MSFT	Stock	108.5	109.37	108.5	108.95	4327145.0
2018-10-18 17:00:00	MSFT	Stock	108.95	108.96	108.7	108.96	3612.0
2018-10-18 18:00:00	MSFT	Stock	108.96	108.96	108.65	108.65	3213.0
2018-10-18 19:00:00	MSFT	Stock	108.7	108.95	108.7	108.9	28125.0
2018-10-18 04:00:00	NVDA	Stock	6.0925	6.0925	6.0925	6.0925	4840.0
2018-10-18 05:00:00	NVDA	Stock	6.0922	6.0922	6.092	6.092	9400.0
2018-10-18 06:00:00	NVDA	Stock	6.0825	6.0825	6.0825	6.0825	8000.0
2018-10-18 07:00:00	NVDA	Stock	6.0575	6.1845	6.0575	6.145	1319480.0
2018-10-18 08:00:00	NVDA	Stock	6.1622	6.185	6.092	6.1313	1949600.0
2018-10-18 09:00:00	NVDA	Stock	6.13	6.1852	6.0838	6.1265	85915920.0
2018-10-18 10:00:00	NVDA	Stock	6.1261	6.1308	6.037	6.0772	76457720.0
2018-10-18 11:00:00	NVDA	Stock	6.079	6.0838	5.9572	5.9846	54545000.0
2018-10-18 12:00:00	NVDA	Stock	5.983	6.031	5.9695	5.976	36171000.0
2018-10-18 13:00:00	NVDA	Stock	5.9758	5.9895	5.9273	5.95	54695800.0
2018-10-18 14:00:00	NVDA	Stock	5.9495	6.0193	5.946	5.9915	54177160.0
2018-10-18 15:00:00	NVDA	Stock	5.9918	6.014	5.9638	5.9892	97212600.0
2018-10-18 16:00:00	NVDA	Stock	5.9883	6.0038	5.9883	6.0	8979760.0
2018-10-18 17:00:00	NVDA	Stock	6.0	6.0025	5.9958	6.0	351560.0
2018-10-18 18:00:00	NVDA	Stock	6.0025	6.0068	5.9972	6.0068	107800.0
2018-10-18 19:00:00	NVDA	Stock	6.01	6.0132	6.0038	6.0132	143480.0
2018-10-18 05:00:00	AMZN	Stock	91.4425	91.5	91.235	91.235	27840.0
2018-10-18 07:00:00	AMZN	Stock	91.23	91.257	90.93	91.0	65920.0
2018-10-18 08:00:00	AMZN	Stock	91.15	91.5865	90.756	91.25	712820.0

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

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