PREVIEW / stock_1hour / 2016-03-21

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-03-21.parquet
  size:    1.0 MB
  rows:    48,411
  symbols: 3,348

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
2016-03-21 04:00:00	AAPL	Stock	26.455	26.47	26.4425	26.47	2824.0
2016-03-21 05:00:00	AAPL	Stock	26.475	26.525	26.475	26.5225	2000.0
2016-03-21 06:00:00	AAPL	Stock	26.5225	26.57	26.5225	26.525	20144.0
2016-03-21 07:00:00	AAPL	Stock	26.5125	26.5375	26.4525	26.525	41528.0
2016-03-21 08:00:00	AAPL	Stock	26.535	26.575	26.465	26.4925	232856.0
2016-03-21 09:00:00	AAPL	Stock	26.5	26.73	26.4575	26.6975	15550896.0
2016-03-21 10:00:00	AAPL	Stock	26.6995	26.9125	26.6075	26.6575	18603492.0
2016-03-21 11:00:00	AAPL	Stock	26.66	26.725	26.6325	26.6862	11237824.0
2016-03-21 12:00:00	AAPL	Stock	26.685	26.6975	26.5875	26.615	10983372.0
2016-03-21 13:00:00	AAPL	Stock	26.616	26.7125	26.285	26.3998	29986076.0
2016-03-21 14:00:00	AAPL	Stock	26.399	26.5425	26.34	26.44	20066604.0
2016-03-21 15:00:00	AAPL	Stock	26.44	26.4825	26.385	26.4775	16515800.0
2016-03-21 16:00:00	AAPL	Stock	26.4775	26.6055	26.4125	26.5	6360520.0
2016-03-21 17:00:00	AAPL	Stock	26.4975	26.4975	26.4775	26.4875	73396.0
2016-03-21 18:00:00	AAPL	Stock	26.4825	26.49	26.4775	26.4875	19232.0
2016-03-21 19:00:00	AAPL	Stock	26.4875	26.4925	26.48	26.4875	78644.0
2016-03-21 07:00:00	MSFT	Stock	53.68	53.68	53.68	53.68	500.0
2016-03-21 08:00:00	MSFT	Stock	53.57	53.6	53.27	53.34	10674.0
2016-03-21 09:00:00	MSFT	Stock	53.33	53.64	52.93	53.525	3581140.0
2016-03-21 10:00:00	MSFT	Stock	53.53	53.6	53.15	53.43	3072576.0
2016-03-21 11:00:00	MSFT	Stock	53.43	53.76	53.42	53.627	2377516.0
2016-03-21 12:00:00	MSFT	Stock	53.62	53.67	53.3	53.43	2109001.0
2016-03-21 13:00:00	MSFT	Stock	53.43	53.75	53.39	53.735	2160113.0
2016-03-21 14:00:00	MSFT	Stock	53.74	53.93	53.6	53.86	2734555.0
2016-03-21 15:00:00	MSFT	Stock	53.86	53.925	53.72	53.86	3971936.0
2016-03-21 16:00:00	MSFT	Stock	53.85	53.89	53.588	53.89	2150621.0
2016-03-21 17:00:00	MSFT	Stock	53.89	53.89	53.8	53.8	2500.0
2016-03-21 18:00:00	MSFT	Stock	53.81	53.81	53.81	53.81	1136.0
2016-03-21 19:00:00	MSFT	Stock	53.79	53.79	53.79	53.79	2200.0
2016-03-21 07:00:00	NVDA	Stock	0.8425	0.8425	0.8425	0.8425	7400.0
2016-03-21 08:00:00	NVDA	Stock	0.846	0.8535	0.8452	0.8475	154640.0
2016-03-21 09:00:00	NVDA	Stock	0.8452	0.8452	0.8325	0.836	43803560.0
2016-03-21 10:00:00	NVDA	Stock	0.836	0.8385	0.8288	0.8376	62507800.0
2016-03-21 11:00:00	NVDA	Stock	0.8375	0.8475	0.8375	0.8461	39173720.0
2016-03-21 12:00:00	NVDA	Stock	0.846	0.8475	0.8445	0.8456	21552440.0
2016-03-21 13:00:00	NVDA	Stock	0.8456	0.848	0.845	0.8458	19190400.0
2016-03-21 14:00:00	NVDA	Stock	0.8458	0.8478	0.8448	0.8452	24311720.0
2016-03-21 15:00:00	NVDA	Stock	0.8451	0.8478	0.8408	0.8476	70248320.0
2016-03-21 16:00:00	NVDA	Stock	0.8478	0.8478	0.8478	0.8478	42292040.0
2016-03-21 19:00:00	NVDA	Stock	0.848	0.848	0.848	0.848	8000.0
2016-03-21 06:00:00	AMZN	Stock	27.7	27.7	27.7	27.7	6840.0
2016-03-21 07:00:00	AMZN	Stock	27.61	27.6745	27.61	27.6745	6000.0
2016-03-21 08:00:00	AMZN	Stock	27.65	27.65	27.5575	27.5875	171180.0
2016-03-21 09:00:00	AMZN	Stock	27.5705	27.595	27.3465	27.3505	9910180.0
2016-03-21 10:00:00	AMZN	Stock	27.3505	27.4485	26.929	27.0328	28886000.0
2016-03-21 11:00:00	AMZN	Stock	27.027	27.374	27.0175	27.325	13993660.0
2016-03-21 12:00:00	AMZN	Stock	27.3225	27.391	27.1685	27.387	8655860.0
2016-03-21 13:00:00	AMZN	Stock	27.3852	27.48	27.3085	27.44	8209240.0
2016-03-21 14:00:00	AMZN	Stock	27.44	27.725	27.4285	27.719	10849600.0
2016-03-21 15:00:00	AMZN	Stock	27.718	27.762	27.5	27.699	13370380.0

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

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