PREVIEW / stock_1hour / 2016-02-17

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-02-17.parquet
  size:    1.0 MB
  rows:    48,616
  symbols: 3,360

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-02-17 04:00:00	AAPL	Stock	24.1325	24.1325	24.1325	24.1325	1200.0
2016-02-17 05:00:00	AAPL	Stock	24.125	24.2375	24.125	24.225	21804.0
2016-02-17 06:00:00	AAPL	Stock	24.22	24.225	24.2	24.2125	82264.0
2016-02-17 07:00:00	AAPL	Stock	24.2	24.2175	24.1375	24.2075	181468.0
2016-02-17 08:00:00	AAPL	Stock	24.19	24.2125	23.9675	24.055	1016012.0
2016-02-17 09:00:00	AAPL	Stock	24.055	24.295	23.9875	24.208	26869384.0
2016-02-17 10:00:00	AAPL	Stock	24.21	24.29	24.1675	24.27	28898840.0
2016-02-17 11:00:00	AAPL	Stock	24.2675	24.3475	24.235	24.25	19984660.0
2016-02-17 12:00:00	AAPL	Stock	24.25	24.485	24.2425	24.4275	18352344.0
2016-02-17 13:00:00	AAPL	Stock	24.425	24.4625	24.385	24.42	12492848.0
2016-02-17 14:00:00	AAPL	Stock	24.4182	24.5525	24.4	24.459	18857612.0
2016-02-17 15:00:00	AAPL	Stock	24.46	24.55	24.4125	24.5275	28443680.0
2016-02-17 16:00:00	AAPL	Stock	24.53	24.55	24.1268	24.5475	11328660.0
2016-02-17 17:00:00	AAPL	Stock	24.55	24.55	24.5325	24.54	88668.0
2016-02-17 18:00:00	AAPL	Stock	24.54	24.5625	24.54	24.5575	39692.0
2016-02-17 19:00:00	AAPL	Stock	24.5575	24.57	24.54	24.565	98264.0
2016-02-17 05:00:00	MSFT	Stock	51.25	51.4	51.25	51.4	1649.0
2016-02-17 06:00:00	MSFT	Stock	51.28	51.28	51.28	51.28	300.0
2016-02-17 07:00:00	MSFT	Stock	51.25	51.45	51.25	51.45	11635.0
2016-02-17 08:00:00	MSFT	Stock	51.33	51.43	51.25	51.41	21764.0
2016-02-17 09:00:00	MSFT	Stock	51.42	51.76	51.09	51.615	3685223.0
2016-02-17 10:00:00	MSFT	Stock	51.62	52.45	51.615	52.37	5618920.0
2016-02-17 11:00:00	MSFT	Stock	52.36	52.37	51.93	52.195	4100116.0
2016-02-17 12:00:00	MSFT	Stock	52.2	52.52	52.14	52.45	3657249.0
2016-02-17 13:00:00	MSFT	Stock	52.45	52.77	52.435	52.59	2804589.0
2016-02-17 14:00:00	MSFT	Stock	52.58	52.72	52.39	52.42	3715494.0
2016-02-17 15:00:00	MSFT	Stock	52.42	52.46	52.14	52.42	8674914.0
2016-02-17 16:00:00	MSFT	Stock	52.42	52.44	52.269	52.44	5254609.0
2016-02-17 17:00:00	MSFT	Stock	52.42	52.5	52.42	52.43	2407.0
2016-02-17 18:00:00	MSFT	Stock	52.45	52.46	52.45	52.46	584.0
2016-02-17 19:00:00	MSFT	Stock	52.5	52.55	52.5	52.55	400.0
2016-02-17 07:00:00	NVDA	Stock	0.6838	0.6838	0.6838	0.6838	15400.0
2016-02-17 08:00:00	NVDA	Stock	0.6838	0.6985	0.6812	0.6902	806880.0
2016-02-17 09:00:00	NVDA	Stock	0.6912	0.6958	0.6825	0.6868	63295520.0
2016-02-17 10:00:00	NVDA	Stock	0.687	0.698	0.6851	0.6958	108455760.0
2016-02-17 11:00:00	NVDA	Stock	0.6959	0.6965	0.6918	0.6941	79681760.0
2016-02-17 12:00:00	NVDA	Stock	0.6942	0.6968	0.691	0.6911	64925720.0
2016-02-17 13:00:00	NVDA	Stock	0.691	0.6944	0.6805	0.6832	73687480.0
2016-02-17 14:00:00	NVDA	Stock	0.6832	0.6918	0.6824	0.684	81475440.0
2016-02-17 15:00:00	NVDA	Stock	0.6842	0.6946	0.6838	0.692	168101680.0
2016-02-17 16:00:00	NVDA	Stock	0.6918	0.761	0.6835	0.7348	67350480.0
2016-02-17 17:00:00	NVDA	Stock	0.7368	0.7488	0.734	0.74	5566960.0
2016-02-17 18:00:00	NVDA	Stock	0.7425	0.7463	0.7425	0.745	1025920.0
2016-02-17 19:00:00	NVDA	Stock	0.7428	0.746	0.7403	0.7415	1316680.0
2016-02-17 07:00:00	AMZN	Stock	26.25	26.4	26.25	26.4	44120.0
2016-02-17 08:00:00	AMZN	Stock	26.29	26.397	26.245	26.35	362960.0
2016-02-17 09:00:00	AMZN	Stock	26.3675	26.45	25.9695	26.3144	15357840.0
2016-02-17 10:00:00	AMZN	Stock	26.3315	26.45	26.1964	26.3944	16116740.0
2016-02-17 11:00:00	AMZN	Stock	26.4	26.676	26.36	26.5735	16058160.0
2016-02-17 12:00:00	AMZN	Stock	26.5805	26.874	26.576	26.7945	12825300.0

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

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