PREVIEW / stock_1hour / 2018-10-01

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-10-01.parquet
  size:    1.1 MB
  rows:    50,911
  symbols: 2,791

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-01 04:00:00	AAPL	Stock	56.6875	56.99	56.6875	56.8975	45240.0
2018-10-01 05:00:00	AAPL	Stock	56.8975	56.925	56.8975	56.9	10084.0
2018-10-01 06:00:00	AAPL	Stock	56.9	57.0	56.875	56.995	61676.0
2018-10-01 07:00:00	AAPL	Stock	56.9525	57.11	56.9125	56.9625	340364.0
2018-10-01 08:00:00	AAPL	Stock	56.93	57.1125	56.9	56.9425	544344.0
2018-10-01 09:00:00	AAPL	Stock	56.94	57.335	56.8575	57.1975	15102548.0
2018-10-01 10:00:00	AAPL	Stock	57.1925	57.355	57.115	57.2175	11531448.0
2018-10-01 11:00:00	AAPL	Stock	57.22	57.2475	57.0325	57.22	8277620.0
2018-10-01 12:00:00	AAPL	Stock	57.2212	57.2212	56.8875	56.8945	6868108.0
2018-10-01 13:00:00	AAPL	Stock	56.895	57.0025	56.8525	56.935	5873976.0
2018-10-01 14:00:00	AAPL	Stock	56.935	56.9425	56.6825	56.785	7019132.0
2018-10-01 15:00:00	AAPL	Stock	56.79	56.865	56.5875	56.8175	10856628.0
2018-10-01 16:00:00	AAPL	Stock	56.815	56.855	56.8	56.8325	5805548.0
2018-10-01 17:00:00	AAPL	Stock	56.8142	56.8325	56.8125	56.8125	24532.0
2018-10-01 18:00:00	AAPL	Stock	56.815	56.8375	56.815	56.825	66932.0
2018-10-01 19:00:00	AAPL	Stock	56.825	56.85	56.82	56.845	34048.0
2018-10-01 04:00:00	MSFT	Stock	114.52	115.33	114.52	115.15	2984.0
2018-10-01 06:00:00	MSFT	Stock	115.25	115.45	115.25	115.4	1050.0
2018-10-01 07:00:00	MSFT	Stock	115.47	115.47	115.15	115.18	7177.0
2018-10-01 08:00:00	MSFT	Stock	115.15	115.47	114.37	115.06	32647.0
2018-10-01 09:00:00	MSFT	Stock	115.08	115.485	114.37	115.18	2231246.0
2018-10-01 10:00:00	MSFT	Stock	115.19	115.49	115.08	115.48	2222946.0
2018-10-01 11:00:00	MSFT	Stock	115.48	115.655	115.305	115.521	1891041.0
2018-10-01 12:00:00	MSFT	Stock	115.53	115.645	115.34	115.396	1427070.0
2018-10-01 13:00:00	MSFT	Stock	115.395	115.54	115.32	115.53	1156380.0
2018-10-01 14:00:00	MSFT	Stock	115.53	115.6	115.14	115.576	1462639.0
2018-10-01 15:00:00	MSFT	Stock	115.58	115.68	115.14	115.59	3223932.0
2018-10-01 16:00:00	MSFT	Stock	115.61	115.69	115.57	115.6	2727689.0
2018-10-01 17:00:00	MSFT	Stock	115.55	115.6	115.55	115.6	5573.0
2018-10-01 18:00:00	MSFT	Stock	115.59	115.59	115.55	115.55	630.0
2018-10-01 19:00:00	MSFT	Stock	115.62	115.62	115.51	115.55	1082.0
2018-10-01 04:00:00	NVDA	Stock	7.072	7.09	7.072	7.09	63160.0
2018-10-01 05:00:00	NVDA	Stock	7.0948	7.1002	7.0862	7.088	121400.0
2018-10-01 06:00:00	NVDA	Stock	7.093	7.093	7.088	7.088	157960.0
2018-10-01 07:00:00	NVDA	Stock	7.085	7.0888	7.0722	7.0793	1005520.0
2018-10-01 08:00:00	NVDA	Stock	7.075	7.1	7.028	7.0928	3180160.0
2018-10-01 09:00:00	NVDA	Stock	7.0928	7.1875	7.065	7.185	91129600.0
2018-10-01 10:00:00	NVDA	Stock	7.1853	7.23	7.1625	7.1922	85250840.0
2018-10-01 11:00:00	NVDA	Stock	7.1912	7.2512	7.172	7.2285	65610880.0
2018-10-01 12:00:00	NVDA	Stock	7.2282	7.2938	7.227	7.272	67619360.0
2018-10-01 13:00:00	NVDA	Stock	7.2728	7.3015	7.2578	7.2828	48226080.0
2018-10-01 14:00:00	NVDA	Stock	7.2832	7.2868	7.222	7.2648	51835160.0
2018-10-01 15:00:00	NVDA	Stock	7.2655	7.2696	7.197	7.2342	88794960.0
2018-10-01 16:00:00	NVDA	Stock	7.2342	7.2874	7.23	7.2302	17714680.0
2018-10-01 17:00:00	NVDA	Stock	7.24	7.25	7.2348	7.2388	310440.0
2018-10-01 18:00:00	NVDA	Stock	7.24	7.24	7.2362	7.2362	224360.0
2018-10-01 19:00:00	NVDA	Stock	7.2358	7.2358	7.225	7.23	468640.0
2018-10-01 04:00:00	AMZN	Stock	101.1185	101.1185	101.05	101.05	6740.0
2018-10-01 05:00:00	AMZN	Stock	101.05	101.05	100.975	100.975	6000.0
2018-10-01 06:00:00	AMZN	Stock	100.942	100.942	100.94	100.94	4000.0

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

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