PREVIEW / stock_1hour / 2015-07-16

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-07-16.parquet
  size:    1.1 MB
  rows:    49,186
  symbols: 3,502

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-07-16 04:00:00	AAPL	Stock	31.8625	31.9175	31.86	31.9	30016.0
2015-07-16 05:00:00	AAPL	Stock	31.92	31.925	31.9	31.9125	25768.0
2015-07-16 06:00:00	AAPL	Stock	31.9125	31.925	31.9	31.9	22824.0
2015-07-16 07:00:00	AAPL	Stock	31.9	31.925	31.875	31.895	184904.0
2015-07-16 08:00:00	AAPL	Stock	31.8875	31.96	31.8525	31.9325	778644.0
2015-07-16 09:00:00	AAPL	Stock	31.9325	32.0475	31.8375	31.9888	24987276.0
2015-07-16 10:00:00	AAPL	Stock	31.9875	32.0125	31.85	31.94	20197240.0
2015-07-16 11:00:00	AAPL	Stock	31.94	32.03	31.9	31.9775	12643108.0
2015-07-16 12:00:00	AAPL	Stock	31.975	32.0375	31.96	32.01	17567384.0
2015-07-16 13:00:00	AAPL	Stock	32.0088	32.0175	31.945	31.995	8925120.0
2015-07-16 14:00:00	AAPL	Stock	31.995	32.115	31.9875	32.1075	14921696.0
2015-07-16 15:00:00	AAPL	Stock	32.1068	32.1425	32.0862	32.125	24605640.0
2015-07-16 16:00:00	AAPL	Stock	32.1225	32.195	32.105	32.195	7709764.0
2015-07-16 17:00:00	AAPL	Stock	32.1775	32.25	32.1775	32.24	470076.0
2015-07-16 18:00:00	AAPL	Stock	32.23	32.3125	32.23	32.275	248596.0
2015-07-16 19:00:00	AAPL	Stock	32.275	32.31	32.2655	32.3	242736.0
2015-07-16 06:00:00	MSFT	Stock	46.1	46.1	46.1	46.1	100.0
2015-07-16 07:00:00	MSFT	Stock	46.08	46.13	46.08	46.1	5200.0
2015-07-16 08:00:00	MSFT	Stock	46.1	46.1	46.01	46.08	4517.0
2015-07-16 09:00:00	MSFT	Stock	46.11	46.24	45.965	46.11	2847377.0
2015-07-16 10:00:00	MSFT	Stock	46.11	46.5	45.995	46.45	4118004.0
2015-07-16 11:00:00	MSFT	Stock	46.45	46.54	46.31	46.44	3037423.0
2015-07-16 12:00:00	MSFT	Stock	46.45	46.48	46.28	46.285	2525385.0
2015-07-16 13:00:00	MSFT	Stock	46.284	46.41	46.28	46.34	2026359.0
2015-07-16 14:00:00	MSFT	Stock	46.35	46.54	46.33	46.51	3187162.0
2015-07-16 15:00:00	MSFT	Stock	46.515	46.69	46.5	46.65	5178398.0
2015-07-16 16:00:00	MSFT	Stock	46.64	46.75	46.64	46.71	1736764.0
2015-07-16 17:00:00	MSFT	Stock	46.74	46.85	46.74	46.85	5927.0
2015-07-16 18:00:00	MSFT	Stock	46.85	46.85	46.85	46.85	1368.0
2015-07-16 19:00:00	MSFT	Stock	46.87	46.87	46.83	46.86	2296.0
2015-07-16 08:00:00	NVDA	Stock	0.5013	0.5013	0.5005	0.5005	23560.0
2015-07-16 09:00:00	NVDA	Stock	0.5005	0.5026	0.495	0.5013	60017160.0
2015-07-16 10:00:00	NVDA	Stock	0.5013	0.5045	0.501	0.5028	42598960.0
2015-07-16 11:00:00	NVDA	Stock	0.5028	0.5043	0.5025	0.5039	18434080.0
2015-07-16 12:00:00	NVDA	Stock	0.504	0.5048	0.502	0.502	30810280.0
2015-07-16 13:00:00	NVDA	Stock	0.5021	0.5025	0.5003	0.5009	30006760.0
2015-07-16 14:00:00	NVDA	Stock	0.5008	0.502	0.5008	0.5018	25558520.0
2015-07-16 15:00:00	NVDA	Stock	0.5016	0.5048	0.5016	0.5045	58092120.0
2015-07-16 16:00:00	NVDA	Stock	0.5048	0.5048	0.5038	0.5038	10867560.0
2015-07-16 17:00:00	NVDA	Stock	0.5038	0.5038	0.5038	0.5038	9800.0
2015-07-16 07:00:00	AMZN	Stock	23.1965	23.1965	23.1965	23.1965	2000.0
2015-07-16 08:00:00	AMZN	Stock	23.1988	23.199	23.16	23.1944	75500.0
2015-07-16 09:00:00	AMZN	Stock	23.1945	23.391	23.1945	23.2908	9312680.0
2015-07-16 10:00:00	AMZN	Stock	23.293	23.435	23.24	23.3735	7420320.0
2015-07-16 11:00:00	AMZN	Stock	23.3755	23.518	23.365	23.462	6723140.0
2015-07-16 12:00:00	AMZN	Stock	23.457	23.5935	23.4555	23.5705	6385440.0
2015-07-16 13:00:00	AMZN	Stock	23.585	23.6395	23.543	23.5825	6304660.0
2015-07-16 14:00:00	AMZN	Stock	23.578	23.6605	23.5725	23.638	7532360.0
2015-07-16 15:00:00	AMZN	Stock	23.6365	23.794	23.6345	23.774	18240160.0
2015-07-16 16:00:00	AMZN	Stock	23.774	23.8998	23.77	23.8526	9328480.0

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

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