PREVIEW / stock_1hour / 2016-02-11

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-02-11.parquet
  size:    1.0 MB
  rows:    49,386
  symbols: 3,362

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-11 04:00:00	AAPL	Stock	23.45	23.45	23.005	23.055	111820.0
2016-02-11 05:00:00	AAPL	Stock	23.0375	23.1625	23.0375	23.15	8400.0
2016-02-11 06:00:00	AAPL	Stock	23.17	23.1875	23.05	23.115	39668.0
2016-02-11 07:00:00	AAPL	Stock	23.055	23.29	23.04	23.1975	316704.0
2016-02-11 08:00:00	AAPL	Stock	23.2125	23.375	23.0625	23.315	591844.0
2016-02-11 09:00:00	AAPL	Stock	23.325	23.68	23.32	23.55	24132112.0
2016-02-11 10:00:00	AAPL	Stock	23.5525	23.635	23.2375	23.275	34089960.0
2016-02-11 11:00:00	AAPL	Stock	23.275	23.325	23.1475	23.3	23673376.0
2016-02-11 12:00:00	AAPL	Stock	23.295	23.3825	23.221	23.361	15707304.0
2016-02-11 13:00:00	AAPL	Stock	23.3625	23.4175	23.2675	23.2962	15062088.0
2016-02-11 14:00:00	AAPL	Stock	23.295	23.5525	23.2025	23.465	25865176.0
2016-02-11 15:00:00	AAPL	Stock	23.4638	23.5575	23.3825	23.415	32802964.0
2016-02-11 16:00:00	AAPL	Stock	23.4125	23.4932	23.2943	23.425	11542480.0
2016-02-11 17:00:00	AAPL	Stock	23.425	23.43	23.35	23.3875	127664.0
2016-02-11 18:00:00	AAPL	Stock	23.3875	23.4225	23.3875	23.4075	126776.0
2016-02-11 19:00:00	AAPL	Stock	23.4025	23.425	23.3875	23.4	62064.0
2016-02-11 04:00:00	MSFT	Stock	48.45	48.45	48.45	48.45	100.0
2016-02-11 05:00:00	MSFT	Stock	48.75	48.75	48.75	48.75	1500.0
2016-02-11 06:00:00	MSFT	Stock	48.56	48.6	48.56	48.56	10650.0
2016-02-11 07:00:00	MSFT	Stock	48.46	48.89	48.28	48.6	16587.0
2016-02-11 08:00:00	MSFT	Stock	48.69	48.88	48.28	48.8	15939.0
2016-02-11 09:00:00	MSFT	Stock	48.75	49.49	48.51	49.37	4710746.0
2016-02-11 10:00:00	MSFT	Stock	49.35	49.42	49.05	49.085	6092082.0
2016-02-11 11:00:00	MSFT	Stock	49.09	49.3	48.83	49.216	4984646.0
2016-02-11 12:00:00	MSFT	Stock	49.215	49.39	48.9	49.27	4596439.0
2016-02-11 13:00:00	MSFT	Stock	49.29	49.41	48.93	49.005	4624816.0
2016-02-11 14:00:00	MSFT	Stock	49.0	49.81	48.86	49.649	7339555.0
2016-02-11 15:00:00	MSFT	Stock	49.655	50.11	49.52	49.64	11014916.0
2016-02-11 16:00:00	MSFT	Stock	49.64	49.72	49.192	49.68	2949715.0
2016-02-11 17:00:00	MSFT	Stock	49.7	49.7	49.68	49.68	88612.0
2016-02-11 18:00:00	MSFT	Stock	49.72	50.1	49.72	50.1	5850.0
2016-02-11 19:00:00	MSFT	Stock	50.0	50.0	49.76	49.85	4600.0
2016-02-11 08:00:00	NVDA	Stock	0.6285	0.6293	0.619	0.619	26400.0
2016-02-11 09:00:00	NVDA	Stock	0.6205	0.6355	0.619	0.6325	41546560.0
2016-02-11 10:00:00	NVDA	Stock	0.6322	0.637	0.6273	0.6288	35332720.0
2016-02-11 11:00:00	NVDA	Stock	0.6288	0.63	0.62	0.6265	41028400.0
2016-02-11 12:00:00	NVDA	Stock	0.6263	0.6325	0.6238	0.6318	23420520.0
2016-02-11 13:00:00	NVDA	Stock	0.6318	0.6349	0.6263	0.627	24889040.0
2016-02-11 14:00:00	NVDA	Stock	0.627	0.6353	0.6223	0.6332	37903320.0
2016-02-11 15:00:00	NVDA	Stock	0.6332	0.639	0.631	0.6325	73116800.0
2016-02-11 16:00:00	NVDA	Stock	0.6325	0.633	0.6325	0.6325	25770400.0
2016-02-11 17:00:00	NVDA	Stock	0.6338	0.6338	0.6338	0.6338	4000.0
2016-02-11 04:00:00	AMZN	Stock	24.55	24.55	24.05	24.05	12800.0
2016-02-11 05:00:00	AMZN	Stock	24.055	24.175	24.05	24.175	20000.0
2016-02-11 06:00:00	AMZN	Stock	24.0755	24.186	24.05	24.055	86560.0
2016-02-11 07:00:00	AMZN	Stock	24.0575	24.3	24.05	24.3	336900.0
2016-02-11 08:00:00	AMZN	Stock	24.25	24.5	24.05	24.407	999040.0
2016-02-11 09:00:00	AMZN	Stock	24.4255	24.748	24.2	24.702	18062860.0
2016-02-11 10:00:00	AMZN	Stock	24.6895	25.091	24.555	24.787	25994720.0
2016-02-11 11:00:00	AMZN	Stock	24.7765	24.885	24.541	24.807	15267280.0

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

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