PREVIEW / stock_1hour / 2018-11-29

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-11-29.parquet
  size:    1.1 MB
  rows:    49,942
  symbols: 2,751

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-11-29 04:00:00	AAPL	Stock	45.425	45.5	45.05	45.2	157484.0
2018-11-29 05:00:00	AAPL	Stock	45.1675	45.2125	45.125	45.15	37884.0
2018-11-29 06:00:00	AAPL	Stock	45.15	45.1875	45.0	45.105	98036.0
2018-11-29 07:00:00	AAPL	Stock	45.105	45.45	45.075	45.355	357056.0
2018-11-29 08:00:00	AAPL	Stock	45.42	45.7	45.0725	45.5875	1497468.0
2018-11-29 09:00:00	AAPL	Stock	45.5875	45.7	44.8125	44.9575	24415752.0
2018-11-29 10:00:00	AAPL	Stock	44.9575	44.9725	44.505	44.58	24047532.0
2018-11-29 11:00:00	AAPL	Stock	44.579	44.7625	44.425	44.738	19536844.0
2018-11-29 12:00:00	AAPL	Stock	44.74	44.895	44.4825	44.8932	12409488.0
2018-11-29 13:00:00	AAPL	Stock	44.8925	44.8925	44.585	44.666	7809776.0
2018-11-29 14:00:00	AAPL	Stock	44.6665	45.08	44.6025	45.0725	13768564.0
2018-11-29 15:00:00	AAPL	Stock	45.07	45.0925	44.85	44.8875	21213068.0
2018-11-29 16:00:00	AAPL	Stock	44.8875	44.9	44.78	44.8225	8857264.0
2018-11-29 17:00:00	AAPL	Stock	44.8	44.8875	44.79	44.8575	136188.0
2018-11-29 18:00:00	AAPL	Stock	44.84	44.86	44.7725	44.8225	36184.0
2018-11-29 19:00:00	AAPL	Stock	44.8125	44.8225	44.6375	44.6375	129720.0
2018-11-29 04:00:00	MSFT	Stock	110.5	111.0	110.5	110.77	3010.0
2018-11-29 05:00:00	MSFT	Stock	110.76	110.76	110.46	110.46	625.0
2018-11-29 06:00:00	MSFT	Stock	110.49	110.51	110.19	110.5	4789.0
2018-11-29 07:00:00	MSFT	Stock	110.52	110.9	110.25	110.75	15852.0
2018-11-29 08:00:00	MSFT	Stock	110.48	110.85	110.31	110.62	54480.0
2018-11-29 09:00:00	MSFT	Stock	110.69	110.87	110.17	110.41	2897698.0
2018-11-29 10:00:00	MSFT	Stock	110.4	110.63	109.03	109.14	5169730.0
2018-11-29 11:00:00	MSFT	Stock	109.145	110.22	109.12	110.01	3780171.0
2018-11-29 12:00:00	MSFT	Stock	110.01	110.2	109.65	110.11	1686861.0
2018-11-29 13:00:00	MSFT	Stock	110.11	110.64	109.87	110.389	1612477.0
2018-11-29 14:00:00	MSFT	Stock	110.37	111.05	110.23	111.03	2316903.0
2018-11-29 15:00:00	MSFT	Stock	111.03	111.115	110.15	110.19	4614802.0
2018-11-29 16:00:00	MSFT	Stock	110.19	110.6	110.11	110.3	2430776.0
2018-11-29 17:00:00	MSFT	Stock	110.35	110.4	110.19	110.25	17425.0
2018-11-29 18:00:00	MSFT	Stock	110.2	110.38	110.19	110.28	11205.0
2018-11-29 19:00:00	MSFT	Stock	110.3	110.35	110.3	110.33	2958.0
2018-11-29 04:00:00	NVDA	Stock	3.9908	3.995	3.95	3.9795	38520.0
2018-11-29 05:00:00	NVDA	Stock	3.9755	3.9795	3.9755	3.9795	26200.0
2018-11-29 06:00:00	NVDA	Stock	3.9625	3.9628	3.953	3.9605	76760.0
2018-11-29 07:00:00	NVDA	Stock	3.9605	3.9962	3.9583	3.9818	773320.0
2018-11-29 08:00:00	NVDA	Stock	3.979	4.0112	3.9578	3.986	3045600.0
2018-11-29 09:00:00	NVDA	Stock	3.9888	4.0375	3.935	4.005	93345920.0
2018-11-29 10:00:00	NVDA	Stock	4.0025	4.0158	3.9152	3.9152	94878480.0
2018-11-29 11:00:00	NVDA	Stock	3.9165	3.967	3.9035	3.943	77269080.0
2018-11-29 12:00:00	NVDA	Stock	3.942	3.9702	3.924	3.9694	46182200.0
2018-11-29 13:00:00	NVDA	Stock	3.9685	3.97	3.9325	3.9544	37371720.0
2018-11-29 14:00:00	NVDA	Stock	3.954	3.984	3.95	3.981	55808040.0
2018-11-29 15:00:00	NVDA	Stock	3.9824	3.9873	3.9278	3.9343	76798040.0
2018-11-29 16:00:00	NVDA	Stock	3.934	3.9442	3.934	3.9388	5546120.0
2018-11-29 17:00:00	NVDA	Stock	3.9403	3.9403	3.9322	3.9325	4651280.0
2018-11-29 18:00:00	NVDA	Stock	3.9338	3.934	3.929	3.9338	295840.0
2018-11-29 19:00:00	NVDA	Stock	3.9312	3.9415	3.9288	3.9288	304640.0
2018-11-29 04:00:00	AMZN	Stock	83.364	83.364	83.364	83.364	2360.0
2018-11-29 05:00:00	AMZN	Stock	83.4	83.4	83.15	83.15	12700.0

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

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