PREVIEW / stock_1hour / 2016-06-02

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-06-02.parquet
  size:    1.0 MB
  rows:    48,625
  symbols: 3,318

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-06-02 04:00:00	AAPL	Stock	24.5075	24.5075	24.4975	24.5	2240.0
2016-06-02 05:00:00	AAPL	Stock	24.48	24.48	24.465	24.465	7388.0
2016-06-02 06:00:00	AAPL	Stock	24.465	24.5	24.4575	24.4925	43432.0
2016-06-02 07:00:00	AAPL	Stock	24.4925	24.5	24.45	24.455	108568.0
2016-06-02 08:00:00	AAPL	Stock	24.45	24.4925	24.405	24.45	563632.0
2016-06-02 09:00:00	AAPL	Stock	24.445	24.485	24.1575	24.257	35569696.0
2016-06-02 10:00:00	AAPL	Stock	24.255	24.3875	24.235	24.38	23280280.0
2016-06-02 11:00:00	AAPL	Stock	24.38	24.46	24.305	24.315	17583488.0
2016-06-02 12:00:00	AAPL	Stock	24.3165	24.33	24.1925	24.3212	19541148.0
2016-06-02 13:00:00	AAPL	Stock	24.3212	24.345	24.2675	24.3263	11685060.0
2016-06-02 14:00:00	AAPL	Stock	24.3275	24.4425	24.3252	24.405	13117376.0
2016-06-02 15:00:00	AAPL	Stock	24.4075	24.4475	24.3825	24.425	18095600.0
2016-06-02 16:00:00	AAPL	Stock	24.43	24.4575	24.405	24.4125	9302676.0
2016-06-02 17:00:00	AAPL	Stock	24.4125	24.4925	24.41	24.4375	597112.0
2016-06-02 18:00:00	AAPL	Stock	24.4325	24.45	24.4325	24.4375	32400.0
2016-06-02 19:00:00	AAPL	Stock	24.4475	24.46	24.4475	24.4475	13756.0
2016-06-02 07:00:00	MSFT	Stock	52.85	52.85	52.85	52.85	6800.0
2016-06-02 08:00:00	MSFT	Stock	52.9	52.9	52.84	52.84	34169.0
2016-06-02 09:00:00	MSFT	Stock	52.81	52.85	51.85	51.865	4156028.0
2016-06-02 10:00:00	MSFT	Stock	51.86	52.315	51.835	52.295	3828059.0
2016-06-02 11:00:00	MSFT	Stock	52.3	52.4	52.16	52.27	2367267.0
2016-06-02 12:00:00	MSFT	Stock	52.27	52.31	52.125	52.3	1499685.0
2016-06-02 13:00:00	MSFT	Stock	52.3	52.44	52.28	52.384	1390293.0
2016-06-02 14:00:00	MSFT	Stock	52.39	52.48	52.35	52.4	1513622.0
2016-06-02 15:00:00	MSFT	Stock	52.4	52.48	52.32	52.48	4494629.0
2016-06-02 16:00:00	MSFT	Stock	52.475	52.5	52.41	52.45	1977576.0
2016-06-02 17:00:00	MSFT	Stock	52.48	52.48	52.45	52.48	111820.0
2016-06-02 18:00:00	MSFT	Stock	52.48	52.48	52.48	52.48	100.0
2016-06-02 19:00:00	MSFT	Stock	52.45	52.47	52.43	52.47	900.0
2016-06-02 08:00:00	NVDA	Stock	1.1765	1.179	1.175	1.179	201680.0
2016-06-02 09:00:00	NVDA	Stock	1.177	1.1885	1.1755	1.1835	54452080.0
2016-06-02 10:00:00	NVDA	Stock	1.1835	1.1848	1.1715	1.1742	57926960.0
2016-06-02 11:00:00	NVDA	Stock	1.1745	1.1752	1.1655	1.1684	36836840.0
2016-06-02 12:00:00	NVDA	Stock	1.1682	1.1728	1.165	1.1728	26521680.0
2016-06-02 13:00:00	NVDA	Stock	1.1728	1.1739	1.17	1.1733	30412000.0
2016-06-02 14:00:00	NVDA	Stock	1.1733	1.18	1.1733	1.1785	39490920.0
2016-06-02 15:00:00	NVDA	Stock	1.1785	1.1793	1.1765	1.1785	54586160.0
2016-06-02 16:00:00	NVDA	Stock	1.1783	1.1802	1.1688	1.1688	12111680.0
2016-06-02 17:00:00	NVDA	Stock	1.1688	1.1785	1.1662	1.1713	689000.0
2016-06-02 18:00:00	NVDA	Stock	1.1713	1.1713	1.1688	1.1688	243600.0
2016-06-02 19:00:00	NVDA	Stock	1.1713	1.1713	1.1682	1.1682	326520.0
2016-06-02 06:00:00	AMZN	Stock	35.95	35.95	35.95	35.95	2000.0
2016-06-02 07:00:00	AMZN	Stock	35.972	36.1	35.9275	35.9275	66000.0
2016-06-02 08:00:00	AMZN	Stock	35.9675	35.987	35.9415	35.984	52080.0
2016-06-02 09:00:00	AMZN	Stock	35.9735	36.097	35.777	35.8175	7531760.0
2016-06-02 10:00:00	AMZN	Stock	35.8075	36.045	35.775	35.945	6617400.0
2016-06-02 11:00:00	AMZN	Stock	35.9555	36.1102	35.9275	36.0335	6815620.0
2016-06-02 12:00:00	AMZN	Stock	36.044	36.1372	35.9795	36.1122	3867620.0
2016-06-02 13:00:00	AMZN	Stock	36.1175	36.242	36.1175	36.2102	6725540.0
2016-06-02 14:00:00	AMZN	Stock	36.2135	36.3	36.183	36.2835	7468760.0

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

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