PREVIEW / stock_1hour / 2019-01-31

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-01-31.parquet
  size:    1.1 MB
  rows:    50,582
  symbols: 2,689

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-01-31 04:00:00	AAPL	Stock	41.5875	41.66	41.5	41.66	83584.0
2019-01-31 05:00:00	AAPL	Stock	41.6025	41.6025	41.45	41.5	74468.0
2019-01-31 06:00:00	AAPL	Stock	41.5	41.6	41.5	41.6	7488.0
2019-01-31 07:00:00	AAPL	Stock	41.5475	41.6625	41.525	41.625	295452.0
2019-01-31 08:00:00	AAPL	Stock	41.55	41.675	41.525	41.5675	521888.0
2019-01-31 09:00:00	AAPL	Stock	41.565	41.67	41.14	41.635	17291112.0
2019-01-31 10:00:00	AAPL	Stock	41.64	42.18	41.545	42.07	29326488.0
2019-01-31 11:00:00	AAPL	Stock	42.07	42.25	41.9275	42.221	16442488.0
2019-01-31 12:00:00	AAPL	Stock	42.22	42.2275	41.88	41.9435	12461688.0
2019-01-31 13:00:00	AAPL	Stock	41.9408	41.9425	41.7	41.859	11190808.0
2019-01-31 14:00:00	AAPL	Stock	41.8575	41.885	41.6395	41.68	10205688.0
2019-01-31 15:00:00	AAPL	Stock	41.685	41.745	41.545	41.5675	17851752.0
2019-01-31 16:00:00	AAPL	Stock	41.61	41.725	41.55	41.7225	25067560.0
2019-01-31 17:00:00	AAPL	Stock	41.7225	41.725	41.605	41.6125	188868.0
2019-01-31 18:00:00	AAPL	Stock	41.655	41.685	41.625	41.63	176048.0
2019-01-31 19:00:00	AAPL	Stock	41.63	41.7475	41.625	41.7425	133344.0
2019-01-31 04:00:00	MSFT	Stock	103.63	104.38	103.63	104.38	9688.0
2019-01-31 05:00:00	MSFT	Stock	104.22	104.48	103.9	104.25	11920.0
2019-01-31 06:00:00	MSFT	Stock	104.12	104.44	104.11	104.18	3549.0
2019-01-31 07:00:00	MSFT	Stock	104.21	104.4	103.5	103.89	109816.0
2019-01-31 08:00:00	MSFT	Stock	104.11	104.33	103.26	103.36	443785.0
2019-01-31 09:00:00	MSFT	Stock	103.36	105.08	102.9	104.095	9702904.0
2019-01-31 10:00:00	MSFT	Stock	104.095	104.48	103.18	103.86	8849550.0
2019-01-31 11:00:00	MSFT	Stock	103.865	104.93	103.76	104.814	4524947.0
2019-01-31 12:00:00	MSFT	Stock	104.815	105.21	104.2	104.97	4484874.0
2019-01-31 13:00:00	MSFT	Stock	104.97	105.22	104.83	105.02	3676543.0
2019-01-31 14:00:00	MSFT	Stock	105.01	105.045	104.09	104.135	3807260.0
2019-01-31 15:00:00	MSFT	Stock	104.135	104.53	103.9	104.48	7222695.0
2019-01-31 16:00:00	MSFT	Stock	104.43	104.8	104.22	104.65	7748372.0
2019-01-31 17:00:00	MSFT	Stock	104.7	104.79	104.34	104.38	19087.0
2019-01-31 18:00:00	MSFT	Stock	104.56	104.68	104.34	104.6	39984.0
2019-01-31 19:00:00	MSFT	Stock	104.62	104.89	104.57	104.57	21946.0
2019-01-31 04:00:00	NVDA	Stock	3.45	3.4608	3.445	3.445	90880.0
2019-01-31 05:00:00	NVDA	Stock	3.4452	3.4452	3.43	3.4448	32800.0
2019-01-31 06:00:00	NVDA	Stock	3.4375	3.4513	3.4375	3.4502	34840.0
2019-01-31 07:00:00	NVDA	Stock	3.45	3.4642	3.4412	3.462	767680.0
2019-01-31 08:00:00	NVDA	Stock	3.4432	3.4625	3.4295	3.435	1938880.0
2019-01-31 09:00:00	NVDA	Stock	3.4305	3.5082	3.4096	3.49	99055720.0
2019-01-31 10:00:00	NVDA	Stock	3.4892	3.544	3.482	3.542	131041960.0
2019-01-31 11:00:00	NVDA	Stock	3.5426	3.5925	3.5333	3.581	98095920.0
2019-01-31 12:00:00	NVDA	Stock	3.5825	3.625	3.569	3.62	112960680.0
2019-01-31 13:00:00	NVDA	Stock	3.6197	3.6298	3.5938	3.6258	96629840.0
2019-01-31 14:00:00	NVDA	Stock	3.6258	3.6278	3.5845	3.587	67642160.0
2019-01-31 15:00:00	NVDA	Stock	3.5869	3.5968	3.5522	3.5938	140888040.0
2019-01-31 16:00:00	NVDA	Stock	3.5938	3.605	3.5648	3.6012	6918280.0
2019-01-31 17:00:00	NVDA	Stock	3.605	3.6125	3.5903	3.5905	844880.0
2019-01-31 18:00:00	NVDA	Stock	3.5985	3.5985	3.569	3.5752	707440.0
2019-01-31 19:00:00	NVDA	Stock	3.5788	3.6125	3.5788	3.6112	721840.0
2019-01-31 04:00:00	AMZN	Stock	85.2	85.2	85.0705	85.0705	43540.0
2019-01-31 05:00:00	AMZN	Stock	85.039	85.05	85.0	85.0	38000.0

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

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