PREVIEW / stock_1hour / 2015-10-13

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-10-13.parquet
  size:    1.0 MB
  rows:    47,693
  symbols: 3,417

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
2015-10-13 04:00:00	AAPL	Stock	27.7625	27.7625	27.675	27.72	8896.0
2015-10-13 05:00:00	AAPL	Stock	27.6925	27.7475	27.6925	27.7425	5200.0
2015-10-13 06:00:00	AAPL	Stock	27.755	27.755	27.73	27.7475	14828.0
2015-10-13 07:00:00	AAPL	Stock	27.7675	27.7825	27.7375	27.745	62408.0
2015-10-13 08:00:00	AAPL	Stock	27.75	27.8	27.725	27.7375	690640.0
2015-10-13 09:00:00	AAPL	Stock	27.7425	27.965	27.67	27.9338	18294456.0
2015-10-13 10:00:00	AAPL	Stock	27.9338	28.1025	27.8125	28.1	23985020.0
2015-10-13 11:00:00	AAPL	Stock	28.0975	28.1125	27.9275	27.9575	19464168.0
2015-10-13 12:00:00	AAPL	Stock	27.9575	28.02	27.905	27.9312	10418184.0
2015-10-13 13:00:00	AAPL	Stock	27.929	28.0	27.9025	27.9625	10127312.0
2015-10-13 14:00:00	AAPL	Stock	27.9638	28.055	27.9375	28.0522	12220032.0
2015-10-13 15:00:00	AAPL	Stock	28.051	28.0525	27.8925	27.9475	20266148.0
2015-10-13 16:00:00	AAPL	Stock	27.9475	27.96	27.9275	27.93	4897664.0
2015-10-13 17:00:00	AAPL	Stock	27.9375	27.9375	27.9025	27.91	81900.0
2015-10-13 18:00:00	AAPL	Stock	27.91	27.91	27.8075	27.8075	68480.0
2015-10-13 19:00:00	AAPL	Stock	27.7975	27.8175	27.7875	27.805	69024.0
2015-10-13 07:00:00	MSFT	Stock	46.81	46.81	46.81	46.81	600.0
2015-10-13 09:00:00	MSFT	Stock	46.79	46.85	46.56	46.85	2478110.0
2015-10-13 10:00:00	MSFT	Stock	46.85	47.09	46.7	47.09	2978875.0
2015-10-13 11:00:00	MSFT	Stock	47.08	47.085	46.93	47.005	1501632.0
2015-10-13 12:00:00	MSFT	Stock	47.01	47.13	46.9	46.901	1458263.0
2015-10-13 13:00:00	MSFT	Stock	46.9	46.93	46.7	46.865	1514807.0
2015-10-13 14:00:00	MSFT	Stock	46.87	47.04	46.81	46.996	2087465.0
2015-10-13 15:00:00	MSFT	Stock	46.99	47.02	46.795	46.88	3837580.0
2015-10-13 16:00:00	MSFT	Stock	46.89	46.97	46.677	46.78	1582489.0
2015-10-13 17:00:00	MSFT	Stock	46.89	46.89	46.73	46.73	3136.0
2015-10-13 18:00:00	MSFT	Stock	46.85	46.85	46.85	46.85	200.0
2015-10-13 19:00:00	MSFT	Stock	46.69	46.69	46.69	46.69	200.0
2015-10-13 08:00:00	NVDA	Stock	0.6503	0.6513	0.65	0.65	56000.0
2015-10-13 09:00:00	NVDA	Stock	0.65	0.6595	0.65	0.6593	26754080.0
2015-10-13 10:00:00	NVDA	Stock	0.6595	0.6628	0.6588	0.6626	57665840.0
2015-10-13 11:00:00	NVDA	Stock	0.6625	0.6639	0.6608	0.6612	34132400.0
2015-10-13 12:00:00	NVDA	Stock	0.661	0.663	0.6605	0.6605	25881400.0
2015-10-13 13:00:00	NVDA	Stock	0.6605	0.6612	0.6585	0.659	41964080.0
2015-10-13 14:00:00	NVDA	Stock	0.6588	0.6619	0.658	0.6615	21312200.0
2015-10-13 15:00:00	NVDA	Stock	0.6616	0.6619	0.6585	0.6602	56843000.0
2015-10-13 16:00:00	NVDA	Stock	0.66	0.6602	0.6598	0.6602	7153360.0
2015-10-13 17:00:00	NVDA	Stock	0.6612	0.6612	0.6602	0.6602	15040.0
2015-10-13 07:00:00	AMZN	Stock	27.439	27.4395	27.3665	27.3665	42080.0
2015-10-13 08:00:00	AMZN	Stock	27.4475	27.4475	27.3205	27.328	131160.0
2015-10-13 09:00:00	AMZN	Stock	27.332	27.4915	27.155	27.4915	7336120.0
2015-10-13 10:00:00	AMZN	Stock	27.4705	27.66	27.4705	27.6085	11363320.0
2015-10-13 11:00:00	AMZN	Stock	27.601	27.638	27.3753	27.4125	6662260.0
2015-10-13 12:00:00	AMZN	Stock	27.4088	27.535	27.323	27.3609	4287220.0
2015-10-13 13:00:00	AMZN	Stock	27.3495	27.4495	27.322	27.397	3616840.0
2015-10-13 14:00:00	AMZN	Stock	27.399	27.5418	27.343	27.53	3977200.0
2015-10-13 15:00:00	AMZN	Stock	27.53	27.5375	27.411	27.442	6900820.0
2015-10-13 16:00:00	AMZN	Stock	27.445	27.452	27.4125	27.4125	550460.0
2015-10-13 17:00:00	AMZN	Stock	27.4145	27.4145	27.363	27.3665	36280.0
2015-10-13 18:00:00	AMZN	Stock	27.363	27.363	27.313	27.313	15200.0

> showing 50 of 47,693 rows — these rows as CSV

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