PREVIEW / stock_1hour / 2015-11-19

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-11-19.parquet
  size:    1.0 MB
  rows:    48,421
  symbols: 3,425

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-11-19 04:00:00	AAPL	Stock	29.45	29.465	29.435	29.465	33368.0
2015-11-19 05:00:00	AAPL	Stock	29.4625	29.465	29.435	29.4575	10152.0
2015-11-19 06:00:00	AAPL	Stock	29.465	29.535	29.46	29.46	141152.0
2015-11-19 07:00:00	AAPL	Stock	29.465	29.495	29.2525	29.305	528984.0
2015-11-19 08:00:00	AAPL	Stock	29.305	29.49	29.265	29.3	733628.0
2015-11-19 09:00:00	AAPL	Stock	29.3125	29.49	29.19	29.3375	25859476.0
2015-11-19 10:00:00	AAPL	Stock	29.3475	29.6375	29.3	29.6302	28874268.0
2015-11-19 11:00:00	AAPL	Stock	29.63	29.7575	29.375	29.689	22865940.0
2015-11-19 12:00:00	AAPL	Stock	29.6975	29.9075	29.69	29.873	21646348.0
2015-11-19 13:00:00	AAPL	Stock	29.875	29.9375	29.7475	29.78	18157444.0
2015-11-19 14:00:00	AAPL	Stock	29.78	29.8478	29.6625	29.815	15350636.0
2015-11-19 15:00:00	AAPL	Stock	29.815	29.82	29.685	29.695	20955916.0
2015-11-19 16:00:00	AAPL	Stock	29.695	29.7225	29.375	29.675	7443040.0
2015-11-19 17:00:00	AAPL	Stock	29.675	29.675	29.6	29.6125	92056.0
2015-11-19 18:00:00	AAPL	Stock	29.6	29.6175	29.59	29.6175	64236.0
2015-11-19 19:00:00	AAPL	Stock	29.6175	29.6175	29.6	29.6175	90668.0
2015-11-19 07:00:00	MSFT	Stock	53.89	53.93	53.89	53.93	5200.0
2015-11-19 08:00:00	MSFT	Stock	53.93	53.95	53.89	53.89	20000.0
2015-11-19 09:00:00	MSFT	Stock	53.95	54.48	53.781	54.4	3566423.0
2015-11-19 10:00:00	MSFT	Stock	54.4	54.53	54.25	54.385	4427947.0
2015-11-19 11:00:00	MSFT	Stock	54.38	54.66	54.18	54.234	3411172.0
2015-11-19 12:00:00	MSFT	Stock	54.24	54.5	54.24	54.476	2965256.0
2015-11-19 13:00:00	MSFT	Stock	54.47	54.54	54.38	54.45	2452407.0
2015-11-19 14:00:00	MSFT	Stock	54.46	54.46	54.01	54.06	3153717.0
2015-11-19 15:00:00	MSFT	Stock	54.06	54.18	53.87	53.94	4734795.0
2015-11-19 16:00:00	MSFT	Stock	53.94	53.99	53.86	53.88	1499721.0
2015-11-19 17:00:00	MSFT	Stock	53.92	53.92	53.9	53.9	1200.0
2015-11-19 18:00:00	MSFT	Stock	53.85	53.85	53.85	53.85	300.0
2015-11-19 08:00:00	NVDA	Stock	0.7805	0.7805	0.7775	0.7775	8000.0
2015-11-19 09:00:00	NVDA	Stock	0.7785	0.7814	0.7745	0.7778	39240480.0
2015-11-19 10:00:00	NVDA	Stock	0.7775	0.7795	0.7736	0.7758	28757760.0
2015-11-19 11:00:00	NVDA	Stock	0.7755	0.7778	0.7723	0.7732	21471040.0
2015-11-19 12:00:00	NVDA	Stock	0.7735	0.7835	0.7735	0.7828	22629080.0
2015-11-19 13:00:00	NVDA	Stock	0.7828	0.7858	0.7795	0.7798	45836920.0
2015-11-19 14:00:00	NVDA	Stock	0.78	0.7812	0.7768	0.7805	24590560.0
2015-11-19 15:00:00	NVDA	Stock	0.7804	0.7812	0.7775	0.778	47305440.0
2015-11-19 16:00:00	NVDA	Stock	0.778	0.7795	0.7775	0.7778	7296440.0
2015-11-19 17:00:00	NVDA	Stock	0.78	0.78	0.78	0.78	4000.0
2015-11-19 18:00:00	NVDA	Stock	0.778	0.778	0.778	0.778	10000.0
2015-11-19 06:00:00	AMZN	Stock	33.3435	33.3475	33.3	33.3	31440.0
2015-11-19 07:00:00	AMZN	Stock	33.26	33.3	33.26	33.261	61660.0
2015-11-19 08:00:00	AMZN	Stock	33.2615	33.275	33.177	33.2	1176120.0
2015-11-19 09:00:00	AMZN	Stock	33.1995	33.4995	32.95	33.4217	14280780.0
2015-11-19 10:00:00	AMZN	Stock	33.42	33.643	33.3338	33.4022	17222700.0
2015-11-19 11:00:00	AMZN	Stock	33.4095	33.453	33.211	33.3002	10481660.0
2015-11-19 12:00:00	AMZN	Stock	33.3025	33.425	33.266	33.344	4186780.0
2015-11-19 13:00:00	AMZN	Stock	33.3425	33.5345	33.3305	33.4847	5658920.0
2015-11-19 14:00:00	AMZN	Stock	33.481	33.495	33.05	33.0595	8416280.0
2015-11-19 15:00:00	AMZN	Stock	33.0585	33.2635	33.0305	33.053	15728040.0
2015-11-19 16:00:00	AMZN	Stock	33.0545	33.075	33.032	33.075	181380.0

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

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