PREVIEW / stock_1hour / 2018-08-22

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-08-22.parquet
  size:    1.1 MB
  rows:    48,830
  symbols: 2,793

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-08-22 04:00:00	AAPL	Stock	53.5	53.6	53.5	53.6	6328.0
2018-08-22 06:00:00	AAPL	Stock	53.6125	53.7	53.5975	53.7	42976.0
2018-08-22 07:00:00	AAPL	Stock	53.7	53.7375	53.605	53.6625	137344.0
2018-08-22 08:00:00	AAPL	Stock	53.6375	53.7	53.5625	53.675	261984.0
2018-08-22 09:00:00	AAPL	Stock	53.6675	53.9298	53.5125	53.5662	9724096.0
2018-08-22 10:00:00	AAPL	Stock	53.565	53.865	53.46	53.815	11832992.0
2018-08-22 11:00:00	AAPL	Stock	53.815	54.09	53.8025	54.0325	8502104.0
2018-08-22 12:00:00	AAPL	Stock	54.03	54.0425	53.78	53.835	4307412.0
2018-08-22 13:00:00	AAPL	Stock	53.8325	53.92	53.7578	53.8375	4216280.0
2018-08-22 14:00:00	AAPL	Stock	53.8375	53.945	53.64	53.8842	8543528.0
2018-08-22 15:00:00	AAPL	Stock	53.88	53.91	53.75	53.765	9859776.0
2018-08-22 16:00:00	AAPL	Stock	53.765	53.7975	53.7375	53.765	9121648.0
2018-08-22 17:00:00	AAPL	Stock	53.7625	53.7725	53.7525	53.7725	9268.0
2018-08-22 18:00:00	AAPL	Stock	53.7725	53.7875	53.7625	53.775	34268.0
2018-08-22 19:00:00	AAPL	Stock	53.8075	53.8125	53.8	53.8125	45720.0
2018-08-22 04:00:00	MSFT	Stock	105.42	105.42	105.42	105.42	179.0
2018-08-22 06:00:00	MSFT	Stock	105.75	105.79	105.75	105.79	300.0
2018-08-22 07:00:00	MSFT	Stock	105.78	105.82	105.7	105.73	9553.0
2018-08-22 08:00:00	MSFT	Stock	105.78	105.94	105.5	105.71	18761.0
2018-08-22 09:00:00	MSFT	Stock	105.65	106.4	105.6	106.04	2175467.0
2018-08-22 10:00:00	MSFT	Stock	106.04	106.48	105.79	106.424	3038612.0
2018-08-22 11:00:00	MSFT	Stock	106.422	106.71	106.36	106.69	1520757.0
2018-08-22 12:00:00	MSFT	Stock	106.69	106.77	106.47	106.6	1066359.0
2018-08-22 13:00:00	MSFT	Stock	106.61	106.89	106.51	106.81	1379920.0
2018-08-22 14:00:00	MSFT	Stock	106.81	107.04	106.78	107.03	1644846.0
2018-08-22 15:00:00	MSFT	Stock	107.03	107.34	106.96	107.07	3553191.0
2018-08-22 16:00:00	MSFT	Stock	107.06	107.2	107.04	107.063	1990760.0
2018-08-22 17:00:00	MSFT	Stock	107.063	107.11	107.05	107.11	3325.0
2018-08-22 18:00:00	MSFT	Stock	107.11	107.11	107.06	107.1	2328.0
2018-08-22 19:00:00	MSFT	Stock	107.06	107.11	107.06	107.11	512.0
2018-08-22 04:00:00	NVDA	Stock	6.2935	6.2935	6.2935	6.2935	4000.0
2018-08-22 06:00:00	NVDA	Stock	6.3132	6.3132	6.3125	6.3125	8000.0
2018-08-22 07:00:00	NVDA	Stock	6.3153	6.325	6.3125	6.3162	543880.0
2018-08-22 08:00:00	NVDA	Stock	6.315	6.325	6.3002	6.317	1807320.0
2018-08-22 09:00:00	NVDA	Stock	6.3173	6.3838	6.2965	6.3525	70119040.0
2018-08-22 10:00:00	NVDA	Stock	6.355	6.482	6.3405	6.465	132617520.0
2018-08-22 11:00:00	NVDA	Stock	6.4651	6.5458	6.4578	6.5427	139457560.0
2018-08-22 12:00:00	NVDA	Stock	6.543	6.545	6.4839	6.4971	82556680.0
2018-08-22 13:00:00	NVDA	Stock	6.4968	6.5415	6.496	6.5323	66247080.0
2018-08-22 14:00:00	NVDA	Stock	6.5325	6.5607	6.5125	6.5595	68553080.0
2018-08-22 15:00:00	NVDA	Stock	6.5595	6.5755	6.5572	6.5708	103580800.0
2018-08-22 16:00:00	NVDA	Stock	6.5705	6.572	6.4812	6.5705	5690560.0
2018-08-22 17:00:00	NVDA	Stock	6.5648	6.5688	6.5505	6.5675	1480280.0
2018-08-22 18:00:00	NVDA	Stock	6.5662	6.5688	6.564	6.565	542720.0
2018-08-22 19:00:00	NVDA	Stock	6.5662	6.575	6.5658	6.5725	991760.0
2018-08-22 05:00:00	AMZN	Stock	94.005	94.075	94.005	94.075	4000.0
2018-08-22 07:00:00	AMZN	Stock	94.0	94.103	94.0	94.0	90580.0
2018-08-22 08:00:00	AMZN	Stock	94.0615	94.4	93.85	93.93	251120.0
2018-08-22 09:00:00	AMZN	Stock	93.95	94.765	93.832	94.384	9373100.0
2018-08-22 10:00:00	AMZN	Stock	94.3925	94.9545	94.2885	94.8825	8082760.0

> showing 50 of 48,830 rows — these rows as CSV

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