PREVIEW / stock_1hour / 2018-06-07

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-06-07.parquet
  size:    1.1 MB
  rows:    49,234
  symbols: 2,831

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-06-07 04:00:00	AAPL	Stock	48.5625	48.6125	48.5625	48.575	10196.0
2018-06-07 05:00:00	AAPL	Stock	48.575	48.575	48.575	48.575	4036.0
2018-06-07 06:00:00	AAPL	Stock	48.575	48.575	48.575	48.575	3744.0
2018-06-07 07:00:00	AAPL	Stock	48.53	48.575	48.47	48.515	191692.0
2018-06-07 08:00:00	AAPL	Stock	48.5	48.575	48.465	48.525	211984.0
2018-06-07 09:00:00	AAPL	Stock	48.525	48.55	48.2862	48.45	9414196.0
2018-06-07 10:00:00	AAPL	Stock	48.45	48.45	48.0838	48.32	11989004.0
2018-06-07 11:00:00	AAPL	Stock	48.3172	48.3725	48.215	48.33	6462452.0
2018-06-07 12:00:00	AAPL	Stock	48.33	48.365	48.235	48.305	5662180.0
2018-06-07 13:00:00	AAPL	Stock	48.305	48.35	48.1375	48.145	7293328.0
2018-06-07 14:00:00	AAPL	Stock	48.1475	48.3725	48.1075	48.34	6841872.0
2018-06-07 15:00:00	AAPL	Stock	48.3425	48.48	48.2725	48.37	13129232.0
2018-06-07 16:00:00	AAPL	Stock	48.3675	48.39	48.3175	48.3175	16384908.0
2018-06-07 17:00:00	AAPL	Stock	48.3175	48.35	48.3	48.325	12364.0
2018-06-07 18:00:00	AAPL	Stock	48.3	48.34	48.3	48.3325	13704.0
2018-06-07 19:00:00	AAPL	Stock	48.3325	48.3325	48.25	48.285	26960.0
2018-06-07 05:00:00	MSFT	Stock	102.57	102.65	102.57	102.65	704.0
2018-06-07 06:00:00	MSFT	Stock	102.65	102.77	102.65	102.7	1894.0
2018-06-07 07:00:00	MSFT	Stock	102.56	102.65	102.56	102.56	12170.0
2018-06-07 08:00:00	MSFT	Stock	102.68	102.68	102.5	102.51	13203.0
2018-06-07 09:00:00	MSFT	Stock	102.5	102.69	102.05	102.15	2128770.0
2018-06-07 10:00:00	MSFT	Stock	102.15	102.22	100.92	101.56	4175338.0
2018-06-07 11:00:00	MSFT	Stock	101.55	101.8	101.195	101.47	2574209.0
2018-06-07 12:00:00	MSFT	Stock	101.47	101.73	101.085	101.29	2114896.0
2018-06-07 13:00:00	MSFT	Stock	101.28	101.34	100.51	100.515	2573935.0
2018-06-07 14:00:00	MSFT	Stock	100.52	100.94	100.38	100.78	3109068.0
2018-06-07 15:00:00	MSFT	Stock	100.78	101.1	100.67	100.92	3889553.0
2018-06-07 16:00:00	MSFT	Stock	100.92	100.92	100.57	100.75	5185972.0
2018-06-07 17:00:00	MSFT	Stock	100.84	101.22	100.84	101.18	43697.0
2018-06-07 18:00:00	MSFT	Stock	101.12	101.14	100.3	101.06	35810.0
2018-06-07 19:00:00	MSFT	Stock	101.03	101.24	101.0	101.19	3070.0
2018-06-07 04:00:00	NVDA	Stock	6.6355	6.6355	6.6355	6.6355	9960.0
2018-06-07 07:00:00	NVDA	Stock	6.6375	6.6375	6.6108	6.622	324680.0
2018-06-07 08:00:00	NVDA	Stock	6.6305	6.6412	6.6125	6.6235	880680.0
2018-06-07 09:00:00	NVDA	Stock	6.6188	6.637	6.5958	6.6056	41230680.0
2018-06-07 10:00:00	NVDA	Stock	6.6035	6.6078	6.4812	6.5328	75445160.0
2018-06-07 11:00:00	NVDA	Stock	6.534	6.5595	6.5126	6.5405	34639120.0
2018-06-07 12:00:00	NVDA	Stock	6.54	6.548	6.508	6.5205	25185120.0
2018-06-07 13:00:00	NVDA	Stock	6.5192	6.5269	6.5028	6.5158	26161240.0
2018-06-07 14:00:00	NVDA	Stock	6.5177	6.575	6.5105	6.5602	50546280.0
2018-06-07 15:00:00	NVDA	Stock	6.5612	6.5878	6.5522	6.5725	43478640.0
2018-06-07 16:00:00	NVDA	Stock	6.5728	6.575	6.5505	6.57	5691200.0
2018-06-07 17:00:00	NVDA	Stock	6.5688	6.57	6.5592	6.5592	80160.0
2018-06-07 18:00:00	NVDA	Stock	6.56	6.5658	6.5505	6.5658	115360.0
2018-06-07 19:00:00	NVDA	Stock	6.553	6.5612	6.5513	6.5612	215040.0
2018-06-07 06:00:00	AMZN	Stock	85.1195	85.15	85.0	85.15	26280.0
2018-06-07 07:00:00	AMZN	Stock	85.0	85.01	84.9	85.0	49560.0
2018-06-07 08:00:00	AMZN	Stock	84.9975	85.05	84.7555	84.8185	176400.0
2018-06-07 09:00:00	AMZN	Stock	84.8	84.995	84.538	84.6692	9060020.0
2018-06-07 10:00:00	AMZN	Stock	84.663	84.784	83.8055	84.28	15895220.0

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

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