PREVIEW / stock_1hour / 2018-12-06

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-12-06.parquet
  size:    1.1 MB
  rows:    51,985
  symbols: 2,758

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-12-06 04:00:00	AAPL	Stock	43.5	43.5	42.8075	42.8075	72088.0
2018-12-06 05:00:00	AAPL	Stock	42.865	43.15	42.7875	42.9725	177520.0
2018-12-06 06:00:00	AAPL	Stock	42.975	43.15	42.92	43.07	50248.0
2018-12-06 07:00:00	AAPL	Stock	43.08	43.205	42.9325	43.0925	882100.0
2018-12-06 08:00:00	AAPL	Stock	43.0725	43.29	42.9675	43.05	1079340.0
2018-12-06 09:00:00	AAPL	Stock	43.05	43.2325	42.655	42.8275	29355916.0
2018-12-06 10:00:00	AAPL	Stock	42.83	43.0475	42.7175	42.808	27614920.0
2018-12-06 11:00:00	AAPL	Stock	42.805	43.1175	42.605	43.1102	22112616.0
2018-12-06 12:00:00	AAPL	Stock	43.1105	43.59	42.9075	43.42	15030876.0
2018-12-06 13:00:00	AAPL	Stock	43.4175	43.47	43.0125	43.45	10871028.0
2018-12-06 14:00:00	AAPL	Stock	43.4457	43.5225	43.0375	43.2978	11142132.0
2018-12-06 15:00:00	AAPL	Stock	43.3	43.695	43.1875	43.69	18165608.0
2018-12-06 16:00:00	AAPL	Stock	43.69	43.7	43.5097	43.69	12576208.0
2018-12-06 17:00:00	AAPL	Stock	43.7	43.765	43.68	43.735	75740.0
2018-12-06 18:00:00	AAPL	Stock	43.75	43.8125	43.655	43.8	99192.0
2018-12-06 19:00:00	AAPL	Stock	43.8375	43.84	43.72	43.75	108004.0
2018-12-06 04:00:00	MSFT	Stock	107.5	107.5	106.0	106.0	6807.0
2018-12-06 05:00:00	MSFT	Stock	105.93	106.38	105.93	106.0	2952.0
2018-12-06 06:00:00	MSFT	Stock	106.02	106.4	105.9	106.16	8806.0
2018-12-06 07:00:00	MSFT	Stock	106.64	106.73	106.2	106.73	22591.0
2018-12-06 08:00:00	MSFT	Stock	106.5	107.39	106.15	106.62	39588.0
2018-12-06 09:00:00	MSFT	Stock	106.61	107.51	105.0	106.39	6848335.0
2018-12-06 10:00:00	MSFT	Stock	106.39	106.99	105.92	106.0	6490664.0
2018-12-06 11:00:00	MSFT	Stock	105.99	107.02	105.37	107.005	5613227.0
2018-12-06 12:00:00	MSFT	Stock	107.0	108.32	106.6	107.987	4740272.0
2018-12-06 13:00:00	MSFT	Stock	107.995	108.21	106.97	108.19	3236471.0
2018-12-06 14:00:00	MSFT	Stock	108.17	108.396	107.05	107.945	3982203.0
2018-12-06 15:00:00	MSFT	Stock	107.95	109.24	107.69	109.18	6918139.0
2018-12-06 16:00:00	MSFT	Stock	109.19	109.47	107.326	109.0	4793394.0
2018-12-06 17:00:00	MSFT	Stock	109.0	109.19	109.0	109.15	11056.0
2018-12-06 18:00:00	MSFT	Stock	109.14	109.2	109.01	109.15	5323.0
2018-12-06 19:00:00	MSFT	Stock	109.15	109.3	108.75	108.85	13915.0
2018-12-06 04:00:00	NVDA	Stock	3.875	3.875	3.7595	3.775	360400.0
2018-12-06 05:00:00	NVDA	Stock	3.775	3.7775	3.7605	3.7738	111960.0
2018-12-06 06:00:00	NVDA	Stock	3.7875	3.808	3.7875	3.8	142800.0
2018-12-06 07:00:00	NVDA	Stock	3.8095	3.8698	3.7588	3.8125	2345680.0
2018-12-06 08:00:00	NVDA	Stock	3.7998	3.8498	3.775	3.8005	4593120.0
2018-12-06 09:00:00	NVDA	Stock	3.8088	3.9002	3.769	3.8011	124783880.0
2018-12-06 10:00:00	NVDA	Stock	3.8	3.9025	3.798	3.8268	113158040.0
2018-12-06 11:00:00	NVDA	Stock	3.8235	3.8695	3.7962	3.8673	72345320.0
2018-12-06 12:00:00	NVDA	Stock	3.8695	3.9185	3.8395	3.8895	64986160.0
2018-12-06 13:00:00	NVDA	Stock	3.889	3.8924	3.8325	3.8802	51001480.0
2018-12-06 14:00:00	NVDA	Stock	3.8808	3.895	3.8508	3.8874	46585800.0
2018-12-06 15:00:00	NVDA	Stock	3.8885	3.9623	3.872	3.9575	110129240.0
2018-12-06 16:00:00	NVDA	Stock	3.9572	3.9718	3.948	3.9688	7463920.0
2018-12-06 17:00:00	NVDA	Stock	3.97	3.981	3.96	3.9795	5817560.0
2018-12-06 18:00:00	NVDA	Stock	3.9798	3.9943	3.9678	3.9888	791200.0
2018-12-06 19:00:00	NVDA	Stock	3.9943	4.0093	3.9932	4.0	783120.0
2018-12-06 04:00:00	AMZN	Stock	81.2745	81.4105	80.76	80.76	59600.0
2018-12-06 05:00:00	AMZN	Stock	80.61	80.75	80.4455	80.6235	86420.0

> showing 50 of 51,985 rows — these rows as CSV

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