PREVIEW / stock_1hour / 2016-11-11

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-11-11.parquet
  size:    1.1 MB
  rows:    48,687
  symbols: 3,186

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-11-11 04:00:00	AAPL	Stock	26.875	26.875	26.625	26.625	4160.0
2016-11-11 05:00:00	AAPL	Stock	26.6625	26.6875	26.625	26.6425	10796.0
2016-11-11 06:00:00	AAPL	Stock	26.65	26.7075	26.635	26.7075	59344.0
2016-11-11 07:00:00	AAPL	Stock	26.7075	26.7425	26.68	26.74	58000.0
2016-11-11 08:00:00	AAPL	Stock	26.7425	26.8175	26.6825	26.8	259268.0
2016-11-11 09:00:00	AAPL	Stock	26.8	27.0775	26.6375	26.8775	25886972.0
2016-11-11 10:00:00	AAPL	Stock	26.87	27.12	26.835	27.08	25977236.0
2016-11-11 11:00:00	AAPL	Stock	27.0775	27.1175	26.9575	27.0425	14333904.0
2016-11-11 12:00:00	AAPL	Stock	27.0425	27.2175	27.0162	27.1375	14644176.0
2016-11-11 13:00:00	AAPL	Stock	27.1375	27.2025	27.045	27.07	10500892.0
2016-11-11 14:00:00	AAPL	Stock	27.0675	27.115	26.99	27.0025	10819716.0
2016-11-11 15:00:00	AAPL	Stock	27.001	27.155	27.001	27.105	16494932.0
2016-11-11 16:00:00	AAPL	Stock	27.105	27.145	27.095	27.12	8677880.0
2016-11-11 17:00:00	AAPL	Stock	27.115	27.1225	27.1125	27.12	76264.0
2016-11-11 18:00:00	AAPL	Stock	27.125	27.1475	27.12	27.145	15024.0
2016-11-11 19:00:00	AAPL	Stock	27.145	27.145	27.1275	27.13	28292.0
2016-11-11 04:00:00	MSFT	Stock	58.71	58.71	58.24	58.24	200.0
2016-11-11 05:00:00	MSFT	Stock	58.16	58.16	58.16	58.16	400.0
2016-11-11 06:00:00	MSFT	Stock	58.12	58.16	58.12	58.16	1755.0
2016-11-11 07:00:00	MSFT	Stock	58.12	58.38	58.1	58.3	21170.0
2016-11-11 08:00:00	MSFT	Stock	58.05	58.45	58.05	58.37	29189.0
2016-11-11 09:00:00	MSFT	Stock	58.36	58.61	58.05	58.06	5755537.0
2016-11-11 10:00:00	MSFT	Stock	58.06	59.116	58.01	58.88	7871886.0
2016-11-11 11:00:00	MSFT	Stock	58.88	58.88	58.5	58.79	4149921.0
2016-11-11 12:00:00	MSFT	Stock	58.78	59.06	58.75	58.82	3380675.0
2016-11-11 13:00:00	MSFT	Stock	58.825	59.0	58.725	58.73	2330386.0
2016-11-11 14:00:00	MSFT	Stock	58.73	58.889	58.64	58.78	2508269.0
2016-11-11 15:00:00	MSFT	Stock	58.78	59.1	58.77	59.02	5893456.0
2016-11-11 16:00:00	MSFT	Stock	59.02	59.09	58.98	59.02	2416329.0
2016-11-11 17:00:00	MSFT	Stock	59.1	59.1	59.02	59.02	25200.0
2016-11-11 18:00:00	MSFT	Stock	59.1	59.1	59.0	59.0	337.0
2016-11-11 04:00:00	NVDA	Stock	1.9125	1.9292	1.9	1.9095	573000.0
2016-11-11 05:00:00	NVDA	Stock	1.904	1.91	1.9005	1.9005	157240.0
2016-11-11 06:00:00	NVDA	Stock	1.91	1.9212	1.9075	1.9075	1852120.0
2016-11-11 07:00:00	NVDA	Stock	1.9075	1.9288	1.9015	1.9212	8770560.0
2016-11-11 08:00:00	NVDA	Stock	1.9225	1.9988	1.9025	1.99	49759080.0
2016-11-11 09:00:00	NVDA	Stock	1.99	2.0799	1.9625	2.0688	506829960.0
2016-11-11 10:00:00	NVDA	Stock	2.0675	2.1212	2.0675	2.109	392785440.0
2016-11-11 11:00:00	NVDA	Stock	2.1078	2.125	2.0975	2.1202	203048400.0
2016-11-11 12:00:00	NVDA	Stock	2.1203	2.1512	2.1203	2.1483	196181440.0
2016-11-11 13:00:00	NVDA	Stock	2.1483	2.1775	2.138	2.1479	194348160.0
2016-11-11 14:00:00	NVDA	Stock	2.1475	2.175	2.1388	2.1648	113432480.0
2016-11-11 15:00:00	NVDA	Stock	2.1655	2.2192	2.1648	2.1992	332390320.0
2016-11-11 16:00:00	NVDA	Stock	2.1995	2.2032	2.1918	2.195	4831760.0
2016-11-11 17:00:00	NVDA	Stock	2.195	2.1988	2.195	2.1958	335360.0
2016-11-11 18:00:00	NVDA	Stock	2.1958	2.1998	2.1958	2.1998	348600.0
2016-11-11 19:00:00	NVDA	Stock	2.1975	2.2012	2.1975	2.2012	210360.0
2016-11-11 04:00:00	AMZN	Stock	37.117	37.117	36.5205	36.5205	20000.0
2016-11-11 05:00:00	AMZN	Stock	36.521	36.521	36.5	36.5	6000.0
2016-11-11 06:00:00	AMZN	Stock	36.5445	36.682	36.5445	36.6775	27000.0

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

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