PREVIEW / stock_1hour / 2016-04-12

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-04-12.parquet
  size:    1.0 MB
  rows:    48,140
  symbols: 3,345

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-04-12 04:00:00	AAPL	Stock	27.215	27.255	27.215	27.23	1600.0
2016-04-12 05:00:00	AAPL	Stock	27.29	27.3375	27.29	27.3375	2516.0
2016-04-12 06:00:00	AAPL	Stock	27.34	27.3675	27.325	27.325	15904.0
2016-04-12 07:00:00	AAPL	Stock	27.3375	27.3575	27.285	27.32	32720.0
2016-04-12 08:00:00	AAPL	Stock	27.33	27.4125	27.31	27.365	220844.0
2016-04-12 09:00:00	AAPL	Stock	27.36	27.5025	27.28	27.2825	17271244.0
2016-04-12 10:00:00	AAPL	Stock	27.285	27.435	27.165	27.3948	22073908.0
2016-04-12 11:00:00	AAPL	Stock	27.395	27.5375	27.365	27.42	12332548.0
2016-04-12 12:00:00	AAPL	Stock	27.425	27.4975	27.4	27.46	7627468.0
2016-04-12 13:00:00	AAPL	Stock	27.465	27.5	27.3925	27.495	8356548.0
2016-04-12 14:00:00	AAPL	Stock	27.4948	27.575	27.4675	27.5688	11670488.0
2016-04-12 15:00:00	AAPL	Stock	27.5675	27.625	27.5638	27.61	15981512.0
2016-04-12 16:00:00	AAPL	Stock	27.61	27.62	27.575	27.5875	4111740.0
2016-04-12 17:00:00	AAPL	Stock	27.5875	27.61	27.585	27.595	21228.0
2016-04-12 18:00:00	AAPL	Stock	27.595	27.5975	27.58	27.5975	26368.0
2016-04-12 19:00:00	AAPL	Stock	27.6	27.615	27.595	27.615	65440.0
2016-04-12 07:00:00	MSFT	Stock	54.42	54.42	54.42	54.42	100.0
2016-04-12 08:00:00	MSFT	Stock	54.5	54.59	54.45	54.46	21245.0
2016-04-12 09:00:00	MSFT	Stock	54.46	54.46	54.06	54.09	2737462.0
2016-04-12 10:00:00	MSFT	Stock	54.085	54.21	53.76	54.12	4697949.0
2016-04-12 11:00:00	MSFT	Stock	54.12	54.44	54.06	54.27	3570194.0
2016-04-12 12:00:00	MSFT	Stock	54.28	54.58	54.275	54.52	2044114.0
2016-04-12 13:00:00	MSFT	Stock	54.516	54.52	54.325	54.5	1829031.0
2016-04-12 14:00:00	MSFT	Stock	54.51	54.659	54.07	54.571	2299744.0
2016-04-12 15:00:00	MSFT	Stock	54.57	54.78	54.493	54.65	4005572.0
2016-04-12 16:00:00	MSFT	Stock	54.66	54.69	54.55	54.65	1203359.0
2016-04-12 17:00:00	MSFT	Stock	54.55	54.6	54.55	54.6	250.0
2016-04-12 19:00:00	MSFT	Stock	54.65	54.65	54.65	54.65	500.0
2016-04-12 08:00:00	NVDA	Stock	0.896	0.896	0.896	0.896	4000.0
2016-04-12 09:00:00	NVDA	Stock	0.9	0.9012	0.8835	0.8835	28379200.0
2016-04-12 10:00:00	NVDA	Stock	0.8838	0.8901	0.8785	0.8895	60126280.0
2016-04-12 11:00:00	NVDA	Stock	0.8895	0.894	0.8878	0.8922	31345800.0
2016-04-12 12:00:00	NVDA	Stock	0.8922	0.8975	0.8922	0.8935	25400400.0
2016-04-12 13:00:00	NVDA	Stock	0.8938	0.8956	0.8924	0.8945	23473120.0
2016-04-12 14:00:00	NVDA	Stock	0.8945	0.899	0.8932	0.8975	26791280.0
2016-04-12 15:00:00	NVDA	Stock	0.8974	0.8992	0.8945	0.896	59343720.0
2016-04-12 16:00:00	NVDA	Stock	0.896	0.897	0.895	0.896	405320.0
2016-04-12 18:00:00	NVDA	Stock	0.896	0.9005	0.896	0.9005	84000.0
2016-04-12 07:00:00	AMZN	Stock	29.85	29.85	29.85	29.85	8860.0
2016-04-12 08:00:00	AMZN	Stock	29.8985	29.925	29.885	29.9	11500.0
2016-04-12 09:00:00	AMZN	Stock	29.913	29.961	29.764	29.8432	4805920.0
2016-04-12 10:00:00	AMZN	Stock	29.8345	29.987	29.6155	29.9712	8012380.0
2016-04-12 11:00:00	AMZN	Stock	29.967	30.075	29.9122	29.945	6608980.0
2016-04-12 12:00:00	AMZN	Stock	29.9365	30.0595	29.9258	30.021	4168160.0
2016-04-12 13:00:00	AMZN	Stock	30.029	30.05	29.937	30.0044	3925360.0
2016-04-12 14:00:00	AMZN	Stock	30.0059	30.14	29.9965	30.082	5619580.0
2016-04-12 15:00:00	AMZN	Stock	30.0825	30.203	30.056	30.17	10705760.0
2016-04-12 16:00:00	AMZN	Stock	30.1585	30.175	30.1585	30.1625	2134840.0
2016-04-12 17:00:00	AMZN	Stock	30.1575	30.1575	30.1575	30.1575	2000.0
2016-04-12 18:00:00	AMZN	Stock	30.1575	30.1745	30.1575	30.1745	10000.0

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

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