PREVIEW / stock_1hour / 2019-03-21

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-03-21.parquet
  size:    1.1 MB
  rows:    50,539
  symbols: 2,662

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-03-21 04:00:00	AAPL	Stock	47.1	47.15	47.045	47.05	7564.0
2019-03-21 05:00:00	AAPL	Stock	47.0725	47.15	47.0725	47.125	7992.0
2019-03-21 06:00:00	AAPL	Stock	47.17	47.3025	47.1675	47.3	17372.0
2019-03-21 07:00:00	AAPL	Stock	47.265	47.455	47.13	47.35	535628.0
2019-03-21 08:00:00	AAPL	Stock	47.3125	47.6625	47.2125	47.62	1268428.0
2019-03-21 09:00:00	AAPL	Stock	47.6025	48.225	47.4525	48.1542	31187004.0
2019-03-21 10:00:00	AAPL	Stock	48.155	48.71	48.1	48.704	30930008.0
2019-03-21 11:00:00	AAPL	Stock	48.705	48.775	48.5525	48.7125	22471396.0
2019-03-21 12:00:00	AAPL	Stock	48.71	48.735	48.51	48.6685	13620380.0
2019-03-21 13:00:00	AAPL	Stock	48.6675	48.8925	48.61	48.89	11657216.0
2019-03-21 14:00:00	AAPL	Stock	48.89	49.07	48.855	48.9425	18530232.0
2019-03-21 15:00:00	AAPL	Stock	48.945	49.0825	48.75	48.7625	30339676.0
2019-03-21 16:00:00	AAPL	Stock	48.7625	48.9925	48.7525	48.9525	22653416.0
2019-03-21 17:00:00	AAPL	Stock	48.965	48.995	48.7725	48.985	457100.0
2019-03-21 18:00:00	AAPL	Stock	48.965	48.9825	48.95	48.975	70024.0
2019-03-21 19:00:00	AAPL	Stock	48.9625	48.995	48.94	48.995	121004.0
2019-03-21 05:00:00	MSFT	Stock	117.52	117.52	117.52	117.52	125.0
2019-03-21 06:00:00	MSFT	Stock	117.52	117.52	117.52	117.52	2120.0
2019-03-21 07:00:00	MSFT	Stock	117.68	117.68	116.72	116.98	26461.0
2019-03-21 08:00:00	MSFT	Stock	117.0	117.2	116.71	117.0	24485.0
2019-03-21 09:00:00	MSFT	Stock	117.1	118.79	117.045	118.46	2749991.0
2019-03-21 10:00:00	MSFT	Stock	118.47	118.61	118.23	118.375	2800132.0
2019-03-21 11:00:00	MSFT	Stock	118.365	118.8	118.32	118.77	2250477.0
2019-03-21 12:00:00	MSFT	Stock	118.76	118.788	118.24	118.549	1562068.0
2019-03-21 13:00:00	MSFT	Stock	118.545	119.03	118.543	118.89	1521336.0
2019-03-21 14:00:00	MSFT	Stock	118.89	119.68	118.875	119.63	2416651.0
2019-03-21 15:00:00	MSFT	Stock	119.63	120.82	119.45	120.64	7401727.0
2019-03-21 16:00:00	MSFT	Stock	120.64	120.64	119.89	120.04	3864375.0
2019-03-21 17:00:00	MSFT	Stock	120.0	120.22	119.96	120.19	150880.0
2019-03-21 18:00:00	MSFT	Stock	120.0	120.2	119.96	119.96	3867.0
2019-03-21 19:00:00	MSFT	Stock	119.96	120.16	119.78	120.16	6198.0
2019-03-21 04:00:00	NVDA	Stock	4.39	4.4	4.3888	4.3888	71080.0
2019-03-21 05:00:00	NVDA	Stock	4.39	4.3912	4.39	4.3912	16400.0
2019-03-21 06:00:00	NVDA	Stock	4.3875	4.3922	4.3678	4.3922	30920.0
2019-03-21 07:00:00	NVDA	Stock	4.3898	4.3898	4.343	4.3595	1065960.0
2019-03-21 08:00:00	NVDA	Stock	4.3675	4.3845	4.34	4.3704	915960.0
2019-03-21 09:00:00	NVDA	Stock	4.3688	4.4833	4.3688	4.4675	126330400.0
2019-03-21 10:00:00	NVDA	Stock	4.4678	4.5112	4.45	4.4946	101746160.0
2019-03-21 11:00:00	NVDA	Stock	4.4932	4.5305	4.4768	4.524	84266840.0
2019-03-21 12:00:00	NVDA	Stock	4.5232	4.554	4.514	4.5455	95710240.0
2019-03-21 13:00:00	NVDA	Stock	4.5452	4.575	4.5383	4.5632	73802000.0
2019-03-21 14:00:00	NVDA	Stock	4.5628	4.6155	4.5598	4.6012	84945840.0
2019-03-21 15:00:00	NVDA	Stock	4.6023	4.625	4.595	4.5975	124220880.0
2019-03-21 16:00:00	NVDA	Stock	4.5985	4.605	4.5895	4.5948	13810440.0
2019-03-21 17:00:00	NVDA	Stock	4.5945	4.5985	4.5788	4.5858	1104160.0
2019-03-21 18:00:00	NVDA	Stock	4.5872	4.5908	4.5868	4.5895	577400.0
2019-03-21 19:00:00	NVDA	Stock	4.5902	4.5945	4.589	4.5945	954440.0
2019-03-21 05:00:00	AMZN	Stock	90.006	90.006	90.006	90.006	4000.0
2019-03-21 06:00:00	AMZN	Stock	90.0395	90.0995	90.0395	90.065	14980.0
2019-03-21 07:00:00	AMZN	Stock	90.1315	90.1535	89.5055	89.746	265380.0

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

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