PREVIEW / stock_1hour / 2016-01-11

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-01-11.parquet
  size:    1.0 MB
  rows:    49,079
  symbols: 3,385

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-01-11 04:00:00	AAPL	Stock	24.41	24.495	24.41	24.4425	55924.0
2016-01-11 05:00:00	AAPL	Stock	24.4575	24.4575	24.2975	24.3375	22128.0
2016-01-11 06:00:00	AAPL	Stock	24.325	24.4975	24.325	24.4975	74632.0
2016-01-11 07:00:00	AAPL	Stock	24.48	24.5375	24.4375	24.4875	262796.0
2016-01-11 08:00:00	AAPL	Stock	24.4775	24.675	24.4425	24.6275	964132.0
2016-01-11 09:00:00	AAPL	Stock	24.6275	24.7925	24.335	24.49	27277060.0
2016-01-11 10:00:00	AAPL	Stock	24.4875	24.615	24.4175	24.435	28861976.0
2016-01-11 11:00:00	AAPL	Stock	24.4325	24.615	24.375	24.5678	21895284.0
2016-01-11 12:00:00	AAPL	Stock	24.57	24.6125	24.44	24.5038	16814356.0
2016-01-11 13:00:00	AAPL	Stock	24.505	24.5562	24.395	24.4235	18042224.0
2016-01-11 14:00:00	AAPL	Stock	24.423	24.6475	24.41	24.5175	22572704.0
2016-01-11 15:00:00	AAPL	Stock	24.515	24.7138	24.375	24.6325	36097860.0
2016-01-11 16:00:00	AAPL	Stock	24.6325	24.6325	24.3692	24.6175	11118424.0
2016-01-11 17:00:00	AAPL	Stock	24.6175	24.6375	24.6125	24.6375	143252.0
2016-01-11 18:00:00	AAPL	Stock	24.6375	24.6875	24.63	24.68	65404.0
2016-01-11 19:00:00	AAPL	Stock	24.68	24.6875	24.6625	24.6875	92604.0
2016-01-11 04:00:00	MSFT	Stock	52.31	52.31	52.31	52.31	100.0
2016-01-11 06:00:00	MSFT	Stock	52.33	52.33	52.33	52.33	600.0
2016-01-11 08:00:00	MSFT	Stock	52.55	52.7	52.55	52.63	17227.0
2016-01-11 09:00:00	MSFT	Stock	52.63	52.85	52.35	52.425	3365547.0
2016-01-11 10:00:00	MSFT	Stock	52.42	52.541	52.025	52.08	4335723.0
2016-01-11 11:00:00	MSFT	Stock	52.08	52.58	52.01	52.395	3796191.0
2016-01-11 12:00:00	MSFT	Stock	52.4	52.42	51.8	51.926	4461324.0
2016-01-11 13:00:00	MSFT	Stock	51.93	52.02	51.48	51.58	3963535.0
2016-01-11 14:00:00	MSFT	Stock	51.575	52.08	51.46	51.912	4416482.0
2016-01-11 15:00:00	MSFT	Stock	51.92	52.59	51.68	52.3	7278188.0
2016-01-11 16:00:00	MSFT	Stock	52.3	52.3	52.2	52.29	2584115.0
2016-01-11 17:00:00	MSFT	Stock	52.3	52.3	52.24	52.24	224480.0
2016-01-11 18:00:00	MSFT	Stock	52.29	52.3	52.29	52.3	9676.0
2016-01-11 19:00:00	MSFT	Stock	52.34	52.35	52.33	52.35	1830.0
2016-01-11 06:00:00	NVDA	Stock	0.7408	0.7488	0.7408	0.7488	296600.0
2016-01-11 07:00:00	NVDA	Stock	0.7388	0.7425	0.7388	0.7425	26400.0
2016-01-11 08:00:00	NVDA	Stock	0.7433	0.7443	0.7425	0.7438	165440.0
2016-01-11 09:00:00	NVDA	Stock	0.7438	0.7473	0.7318	0.7323	59234920.0
2016-01-11 10:00:00	NVDA	Stock	0.7323	0.7433	0.7315	0.7361	78712960.0
2016-01-11 11:00:00	NVDA	Stock	0.736	0.7383	0.7332	0.7372	48988720.0
2016-01-11 12:00:00	NVDA	Stock	0.7372	0.7378	0.7316	0.7355	25068080.0
2016-01-11 13:00:00	NVDA	Stock	0.7355	0.7378	0.729	0.729	27593440.0
2016-01-11 14:00:00	NVDA	Stock	0.7293	0.7395	0.7288	0.7375	43588560.0
2016-01-11 15:00:00	NVDA	Stock	0.7376	0.7464	0.7334	0.742	106983640.0
2016-01-11 16:00:00	NVDA	Stock	0.742	0.747	0.742	0.747	9223760.0
2016-01-11 18:00:00	NVDA	Stock	0.741	0.741	0.741	0.741	20000.0
2016-01-11 04:00:00	AMZN	Stock	30.6	30.6	30.6	30.6	2000.0
2016-01-11 05:00:00	AMZN	Stock	30.6	30.6	30.4555	30.4555	11620.0
2016-01-11 06:00:00	AMZN	Stock	30.482	30.5075	30.482	30.5075	11540.0
2016-01-11 07:00:00	AMZN	Stock	30.575	30.599	30.55	30.591	52820.0
2016-01-11 08:00:00	AMZN	Stock	30.5005	30.7425	30.5005	30.6495	246800.0
2016-01-11 09:00:00	AMZN	Stock	30.6495	30.9925	30.4505	30.55	14493420.0
2016-01-11 10:00:00	AMZN	Stock	30.562	30.75	30.363	30.4315	11615780.0
2016-01-11 11:00:00	AMZN	Stock	30.4075	30.7445	30.2565	30.6661	11007440.0

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

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