PREVIEW / stock_1hour / 2019-12-27

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-12-27.parquet
  size:    1.1 MB
  rows:    50,602
  symbols: 2,465

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-12-27 04:00:00	AAPL	Stock	72.7	72.75	72.6525	72.675	29096.0
2019-12-27 05:00:00	AAPL	Stock	72.675	72.8175	72.675	72.8125	18000.0
2019-12-27 06:00:00	AAPL	Stock	72.7625	72.8	72.7375	72.795	17728.0
2019-12-27 07:00:00	AAPL	Stock	72.7975	72.995	72.795	72.925	561852.0
2019-12-27 08:00:00	AAPL	Stock	72.925	72.9975	72.785	72.825	1030612.0
2019-12-27 09:00:00	AAPL	Stock	72.8275	73.4925	72.4775	72.562	29437732.0
2019-12-27 10:00:00	AAPL	Stock	72.56	73.08	72.525	72.805	21327464.0
2019-12-27 11:00:00	AAPL	Stock	72.8125	72.9918	72.6625	72.6725	10505368.0
2019-12-27 12:00:00	AAPL	Stock	72.6702	72.735	72.4525	72.525	10932188.0
2019-12-27 13:00:00	AAPL	Stock	72.5275	72.545	72.03	72.449	18622944.0
2019-12-27 14:00:00	AAPL	Stock	72.4475	72.645	72.4275	72.5775	8353676.0
2019-12-27 15:00:00	AAPL	Stock	72.5773	72.61	72.125	72.4575	15156472.0
2019-12-27 16:00:00	AAPL	Stock	72.4575	72.485	72.3875	72.45	12313572.0
2019-12-27 17:00:00	AAPL	Stock	72.45	72.4625	72.425	72.455	275404.0
2019-12-27 18:00:00	AAPL	Stock	72.45	72.45	72.4275	72.45	43780.0
2019-12-27 19:00:00	AAPL	Stock	72.45	72.5	72.45	72.5	59964.0
2019-12-27 04:00:00	MSFT	Stock	159.25	159.3	159.05	159.05	953.0
2019-12-27 05:00:00	MSFT	Stock	159.29	159.39	159.29	159.33	1940.0
2019-12-27 06:00:00	MSFT	Stock	159.33	159.38	159.32	159.38	1929.0
2019-12-27 07:00:00	MSFT	Stock	159.46	159.58	159.36	159.36	14261.0
2019-12-27 08:00:00	MSFT	Stock	159.4	159.55	159.27	159.27	29352.0
2019-12-27 09:00:00	MSFT	Stock	159.27	159.55	158.23	158.25	2337620.0
2019-12-27 10:00:00	MSFT	Stock	158.24	158.96	158.22	158.76	1968069.0
2019-12-27 11:00:00	MSFT	Stock	158.76	159.0	158.61	158.62	1234046.0
2019-12-27 12:00:00	MSFT	Stock	158.63	158.86	158.47	158.64	857435.0
2019-12-27 13:00:00	MSFT	Stock	158.64	158.82	158.532	158.755	782611.0
2019-12-27 14:00:00	MSFT	Stock	158.76	158.99	158.75	158.98	812473.0
2019-12-27 15:00:00	MSFT	Stock	158.985	159.08	158.395	158.95	2360646.0
2019-12-27 16:00:00	MSFT	Stock	158.95	158.98	158.715	158.75	5255702.0
2019-12-27 17:00:00	MSFT	Stock	158.8	158.89	158.8	158.8	698.0
2019-12-27 18:00:00	MSFT	Stock	158.77	158.82	158.77	158.81	1037.0
2019-12-27 19:00:00	MSFT	Stock	158.8	158.8	158.78	158.78	614.0
2019-12-27 04:00:00	NVDA	Stock	5.9798	5.9798	5.9798	5.9798	16000.0
2019-12-27 05:00:00	NVDA	Stock	5.998	6.009	5.9962	6.009	21360.0
2019-12-27 06:00:00	NVDA	Stock	6.0068	6.0082	5.9978	5.998	27400.0
2019-12-27 07:00:00	NVDA	Stock	6.0	6.0088	5.9978	6.0035	267920.0
2019-12-27 08:00:00	NVDA	Stock	6.0075	6.0088	5.9798	5.9975	1672520.0
2019-12-27 09:00:00	NVDA	Stock	5.9926	6.0085	5.9215	5.9288	37098600.0
2019-12-27 10:00:00	NVDA	Stock	5.9298	5.9445	5.9108	5.919	46323240.0
2019-12-27 11:00:00	NVDA	Stock	5.9193	5.9458	5.9135	5.9373	29181840.0
2019-12-27 12:00:00	NVDA	Stock	5.937	5.9375	5.9148	5.929	16967760.0
2019-12-27 13:00:00	NVDA	Stock	5.93	5.9303	5.9065	5.9135	17870560.0
2019-12-27 14:00:00	NVDA	Stock	5.9131	5.9308	5.8953	5.93	20327880.0
2019-12-27 15:00:00	NVDA	Stock	5.9295	5.9298	5.8988	5.9218	28422880.0
2019-12-27 16:00:00	NVDA	Stock	5.9218	5.9218	5.908	5.9112	9951640.0
2019-12-27 17:00:00	NVDA	Stock	5.9125	5.9148	5.908	5.908	65280.0
2019-12-27 18:00:00	NVDA	Stock	5.9103	5.9138	5.9103	5.9138	13800.0
2019-12-27 19:00:00	NVDA	Stock	5.9083	5.9145	5.908	5.9145	116280.0
2019-12-27 04:00:00	AMZN	Stock	93.75	93.75	93.575	93.575	35500.0
2019-12-27 05:00:00	AMZN	Stock	93.65	93.75	93.65	93.75	23720.0

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

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