PREVIEW / stock_1hour / 2018-06-08

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-06-08.parquet
  size:    1.1 MB
  rows:    49,360
  symbols: 2,811

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-08 04:00:00	AAPL	Stock	47.9375	47.9375	47.0475	47.3875	148152.0
2018-06-08 05:00:00	AAPL	Stock	47.3875	47.4375	47.2375	47.2375	67364.0
2018-06-08 06:00:00	AAPL	Stock	47.31	47.5525	47.3	47.38	173152.0
2018-06-08 07:00:00	AAPL	Stock	47.415	47.8775	47.3875	47.7375	953824.0
2018-06-08 08:00:00	AAPL	Stock	47.755	47.865	47.4	47.7	988200.0
2018-06-08 09:00:00	AAPL	Stock	47.6875	47.8125	47.4425	47.7012	20312500.0
2018-06-08 10:00:00	AAPL	Stock	47.7	47.7025	47.465	47.6125	15674408.0
2018-06-08 11:00:00	AAPL	Stock	47.6075	47.7375	47.54	47.6335	9352168.0
2018-06-08 12:00:00	AAPL	Stock	47.6325	47.7975	47.6325	47.7692	7379160.0
2018-06-08 13:00:00	AAPL	Stock	47.7675	47.855	47.7225	47.7825	6918740.0
2018-06-08 14:00:00	AAPL	Stock	47.785	47.8875	47.7825	47.8475	6075888.0
2018-06-08 15:00:00	AAPL	Stock	47.8475	48.0	47.8432	47.87	14056784.0
2018-06-08 16:00:00	AAPL	Stock	47.925	47.985	47.8725	47.925	13953388.0
2018-06-08 17:00:00	AAPL	Stock	47.925	47.9725	47.925	47.95	59932.0
2018-06-08 18:00:00	AAPL	Stock	47.9725	47.9725	47.925	47.9525	234176.0
2018-06-08 19:00:00	AAPL	Stock	47.9725	48.0	47.9725	48.0	27408.0
2018-06-08 04:00:00	MSFT	Stock	100.5	100.5	100.03	100.03	1644.0
2018-06-08 05:00:00	MSFT	Stock	100.01	100.01	100.0	100.0	5266.0
2018-06-08 06:00:00	MSFT	Stock	100.0	100.08	99.98	100.07	1080.0
2018-06-08 07:00:00	MSFT	Stock	100.14	100.5	100.0	100.3	11496.0
2018-06-08 08:00:00	MSFT	Stock	100.14	100.65	100.01	100.55	34224.0
2018-06-08 09:00:00	MSFT	Stock	100.55	101.27	100.5	101.02	3047958.0
2018-06-08 10:00:00	MSFT	Stock	101.03	101.17	100.63	101.155	2596763.0
2018-06-08 11:00:00	MSFT	Stock	101.15	101.63	101.08	101.25	2013673.0
2018-06-08 12:00:00	MSFT	Stock	101.255	101.56	101.17	101.47	1460745.0
2018-06-08 13:00:00	MSFT	Stock	101.465	101.51	101.25	101.38	1396123.0
2018-06-08 14:00:00	MSFT	Stock	101.375	101.84	101.36	101.675	1653994.0
2018-06-08 15:00:00	MSFT	Stock	101.67	101.95	101.515	101.63	3885655.0
2018-06-08 16:00:00	MSFT	Stock	101.63	101.68	101.34	101.6	4287075.0
2018-06-08 17:00:00	MSFT	Stock	101.6	101.66	101.57	101.6	14822.0
2018-06-08 18:00:00	MSFT	Stock	101.6	101.66	101.58	101.58	3900.0
2018-06-08 19:00:00	MSFT	Stock	101.63	101.63	101.63	101.63	300.0
2018-06-08 04:00:00	NVDA	Stock	6.55	6.55	6.45	6.483	93520.0
2018-06-08 05:00:00	NVDA	Stock	6.4515	6.4612	6.4515	6.4563	116160.0
2018-06-08 06:00:00	NVDA	Stock	6.4567	6.4795	6.4567	6.4795	35600.0
2018-06-08 07:00:00	NVDA	Stock	6.47	6.5	6.4578	6.4878	596920.0
2018-06-08 08:00:00	NVDA	Stock	6.49	6.5162	6.475	6.4975	1530600.0
2018-06-08 09:00:00	NVDA	Stock	6.4988	6.58	6.48	6.5648	51662480.0
2018-06-08 10:00:00	NVDA	Stock	6.5656	6.6	6.533	6.5508	60725800.0
2018-06-08 11:00:00	NVDA	Stock	6.549	6.56	6.5325	6.5429	29669960.0
2018-06-08 12:00:00	NVDA	Stock	6.5435	6.5591	6.5342	6.5428	19554760.0
2018-06-08 13:00:00	NVDA	Stock	6.5433	6.5542	6.536	6.546	18771360.0
2018-06-08 14:00:00	NVDA	Stock	6.547	6.5848	6.545	6.5661	51137760.0
2018-06-08 15:00:00	NVDA	Stock	6.567	6.5728	6.5442	6.5542	51877720.0
2018-06-08 16:00:00	NVDA	Stock	6.557	6.557	6.5372	6.5545	24998480.0
2018-06-08 17:00:00	NVDA	Stock	6.5542	6.556	6.55	6.55	39160.0
2018-06-08 18:00:00	NVDA	Stock	6.5548	6.5548	6.5548	6.5548	4000.0
2018-06-08 19:00:00	NVDA	Stock	6.5498	6.5498	6.544	6.5445	195160.0
2018-06-08 04:00:00	AMZN	Stock	83.5005	83.5005	83.5005	83.5005	2120.0
2018-06-08 05:00:00	AMZN	Stock	83.501	83.501	83.501	83.501	9200.0

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

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