PREVIEW / stock_1hour / 2014-12-18

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-12-18.parquet
  size:    1.1 MB
  rows:    51,495
  symbols: 3,577

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
2014-12-18 04:00:00	AAPL	Stock	27.265	27.75	27.265	27.75	37528.0
2014-12-18 05:00:00	AAPL	Stock	27.75	27.9375	27.75	27.925	131240.0
2014-12-18 06:00:00	AAPL	Stock	27.91	27.91	27.7075	27.75	91836.0
2014-12-18 07:00:00	AAPL	Stock	27.75	27.85	27.7	27.8125	458020.0
2014-12-18 08:00:00	AAPL	Stock	27.815	27.8825	27.7	27.825	1572136.0
2014-12-18 09:00:00	AAPL	Stock	27.83	27.9875	27.68	27.7975	40504460.0
2014-12-18 10:00:00	AAPL	Stock	27.8	27.9125	27.715	27.78	32379440.0
2014-12-18 11:00:00	AAPL	Stock	27.78	27.8325	27.665	27.8125	21059444.0
2014-12-18 12:00:00	AAPL	Stock	27.81	27.92	27.77	27.9125	16513172.0
2014-12-18 13:00:00	AAPL	Stock	27.913	28.07	27.8825	28.0338	22590744.0
2014-12-18 14:00:00	AAPL	Stock	28.0325	28.0375	27.8775	27.9588	20131284.0
2014-12-18 15:00:00	AAPL	Stock	27.96	28.1625	27.925	28.1625	41140768.0
2014-12-18 16:00:00	AAPL	Stock	28.1625	28.168	27.7878	28.1275	18494212.0
2014-12-18 17:00:00	AAPL	Stock	28.14	28.1625	27.88	28.1575	499980.0
2014-12-18 18:00:00	AAPL	Stock	28.155	28.1775	28.1375	28.17	245968.0
2014-12-18 19:00:00	AAPL	Stock	28.1775	28.2175	28.165	28.1975	201800.0
2014-12-18 05:00:00	MSFT	Stock	46.29	46.32	46.29	46.32	200.0
2014-12-18 06:00:00	MSFT	Stock	46.35	46.35	46.35	46.35	950.0
2014-12-18 07:00:00	MSFT	Stock	46.2	46.27	46.18	46.27	5050.0
2014-12-18 08:00:00	MSFT	Stock	46.17	46.4	46.17	46.3	9659.0
2014-12-18 09:00:00	MSFT	Stock	46.3	46.73	46.3	46.695	4276905.0
2014-12-18 10:00:00	MSFT	Stock	46.69	47.19	46.65	47.095	5674854.0
2014-12-18 11:00:00	MSFT	Stock	47.09	47.09	46.79	47.08	3574879.0
2014-12-18 12:00:00	MSFT	Stock	47.08	47.2	46.97	47.18	2823936.0
2014-12-18 13:00:00	MSFT	Stock	47.185	47.3	46.85	47.27	3184958.0
2014-12-18 14:00:00	MSFT	Stock	47.26	47.37	47.16	47.23	3150349.0
2014-12-18 15:00:00	MSFT	Stock	47.227	47.52	47.14	47.52	9873168.0
2014-12-18 16:00:00	MSFT	Stock	47.52	47.58	45.816	47.54	6202184.0
2014-12-18 17:00:00	MSFT	Stock	47.51	47.55	47.5	47.54	29678.0
2014-12-18 18:00:00	MSFT	Stock	47.52	47.52	47.46	47.5	66882.0
2014-12-18 19:00:00	MSFT	Stock	47.54	47.6	47.54	47.6	6686.0
2014-12-18 05:00:00	NVDA	Stock	0.5088	0.5088	0.5088	0.5088	4000.0
2014-12-18 08:00:00	NVDA	Stock	0.5128	0.5128	0.5125	0.5128	24000.0
2014-12-18 09:00:00	NVDA	Stock	0.5148	0.5158	0.505	0.5075	19554360.0
2014-12-18 10:00:00	NVDA	Stock	0.5078	0.5095	0.5058	0.506	25908520.0
2014-12-18 11:00:00	NVDA	Stock	0.5058	0.5058	0.5025	0.5038	19189960.0
2014-12-18 12:00:00	NVDA	Stock	0.5038	0.5075	0.5035	0.5058	21501960.0
2014-12-18 13:00:00	NVDA	Stock	0.506	0.5075	0.505	0.5051	20596280.0
2014-12-18 14:00:00	NVDA	Stock	0.505	0.5055	0.5008	0.502	23217600.0
2014-12-18 15:00:00	NVDA	Stock	0.5021	0.5061	0.5018	0.5055	67924960.0
2014-12-18 16:00:00	NVDA	Stock	0.5055	0.5056	0.5055	0.5056	21288320.0
2014-12-18 17:00:00	NVDA	Stock	0.505	0.505	0.505	0.505	1604840.0
2014-12-18 18:00:00	NVDA	Stock	0.5055	0.5055	0.5055	0.5055	831240.0
2014-12-18 04:00:00	AMZN	Stock	15.042	15.042	15.042	15.042	2000.0
2014-12-18 07:00:00	AMZN	Stock	15.1585	15.1665	15.125	15.125	24720.0
2014-12-18 08:00:00	AMZN	Stock	15.1665	15.1915	15.12	15.1915	266240.0
2014-12-18 09:00:00	AMZN	Stock	15.1915	15.225	14.8885	14.8995	17458820.0
2014-12-18 10:00:00	AMZN	Stock	14.9	14.9935	14.7525	14.763	24827140.0
2014-12-18 11:00:00	AMZN	Stock	14.761	14.7925	14.6625	14.784	22671920.0
2014-12-18 12:00:00	AMZN	Stock	14.785	14.86	14.7705	14.8245	16507700.0

> showing 50 of 51,495 rows — these rows as CSV

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