PREVIEW / stock_1hour / 2016-06-17

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-06-17.parquet
  size:    1.0 MB
  rows:    48,354
  symbols: 3,284

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-17 04:00:00	AAPL	Stock	24.3675	24.3675	24.3175	24.3175	3600.0
2016-06-17 05:00:00	AAPL	Stock	24.32	24.3375	24.2125	24.3375	20384.0
2016-06-17 06:00:00	AAPL	Stock	24.3325	24.3325	24.245	24.2525	25684.0
2016-06-17 07:00:00	AAPL	Stock	24.2575	24.2775	24.225	24.225	132252.0
2016-06-17 08:00:00	AAPL	Stock	24.295	24.3375	23.955	23.9875	1676792.0
2016-06-17 09:00:00	AAPL	Stock	23.9875	24.2	23.85	24.03	58849656.0
2016-06-17 10:00:00	AAPL	Stock	24.0275	24.045	23.8388	23.8975	35408168.0
2016-06-17 11:00:00	AAPL	Stock	23.8975	23.9775	23.8425	23.906	19756680.0
2016-06-17 12:00:00	AAPL	Stock	23.9075	23.975	23.8938	23.9125	11249172.0
2016-06-17 13:00:00	AAPL	Stock	23.9125	23.995	23.8775	23.9575	10758244.0
2016-06-17 14:00:00	AAPL	Stock	23.955	23.98	23.915	23.954	10766280.0
2016-06-17 15:00:00	AAPL	Stock	23.9538	23.9625	23.825	23.83	26696140.0
2016-06-17 16:00:00	AAPL	Stock	23.8325	23.8958	23.795	23.825	44456232.0
2016-06-17 17:00:00	AAPL	Stock	23.8125	23.8375	23.8075	23.8125	525208.0
2016-06-17 18:00:00	AAPL	Stock	23.8125	23.8175	23.7675	23.785	167272.0
2016-06-17 19:00:00	AAPL	Stock	23.775	23.775	23.7525	23.7575	190268.0
2016-06-17 04:00:00	MSFT	Stock	50.25	50.25	50.25	50.25	200.0
2016-06-17 07:00:00	MSFT	Stock	50.39	50.39	50.39	50.39	500.0
2016-06-17 08:00:00	MSFT	Stock	50.31	50.5	50.31	50.39	6662.0
2016-06-17 09:00:00	MSFT	Stock	50.35	50.45	49.93	50.055	10949379.0
2016-06-17 10:00:00	MSFT	Stock	50.055	50.23	49.9	49.914	3553234.0
2016-06-17 11:00:00	MSFT	Stock	49.91	50.05	49.82	49.97	4466352.0
2016-06-17 12:00:00	MSFT	Stock	49.97	50.11	49.965	50.045	2138377.0
2016-06-17 13:00:00	MSFT	Stock	50.05	50.28	49.96	50.245	2003017.0
2016-06-17 14:00:00	MSFT	Stock	50.24	50.27	50.11	50.16	4668514.0
2016-06-17 15:00:00	MSFT	Stock	50.16	50.22	50.09	50.12	7043986.0
2016-06-17 16:00:00	MSFT	Stock	50.13	50.18	50.11	50.13	7335373.0
2016-06-17 17:00:00	MSFT	Stock	50.12	50.12	50.12	50.12	1000.0
2016-06-17 19:00:00	MSFT	Stock	50.12	50.12	50.12	50.12	300.0
2016-06-17 07:00:00	NVDA	Stock	1.1908	1.1908	1.1908	1.1908	32000.0
2016-06-17 08:00:00	NVDA	Stock	1.195	1.195	1.1925	1.193	84000.0
2016-06-17 09:00:00	NVDA	Stock	1.1925	1.1928	1.1725	1.1778	52312680.0
2016-06-17 10:00:00	NVDA	Stock	1.1776	1.1818	1.1675	1.1676	62556760.0
2016-06-17 11:00:00	NVDA	Stock	1.1675	1.1702	1.1633	1.1658	42947440.0
2016-06-17 12:00:00	NVDA	Stock	1.166	1.1698	1.165	1.1666	28360000.0
2016-06-17 13:00:00	NVDA	Stock	1.167	1.177	1.1655	1.1748	27225120.0
2016-06-17 14:00:00	NVDA	Stock	1.1745	1.1765	1.1725	1.1734	25329080.0
2016-06-17 15:00:00	NVDA	Stock	1.1735	1.1738	1.165	1.1682	77399640.0
2016-06-17 16:00:00	NVDA	Stock	1.168	1.1716	1.1665	1.1678	126999680.0
2016-06-17 17:00:00	NVDA	Stock	1.1678	1.1678	1.1678	1.1678	140000.0
2016-06-17 08:00:00	AMZN	Stock	35.825	35.95	35.825	35.895	88920.0
2016-06-17 09:00:00	AMZN	Stock	35.865	35.91	35.3275	35.3755	20456960.0
2016-06-17 10:00:00	AMZN	Stock	35.3694	35.4435	35.166	35.2485	11203000.0
2016-06-17 11:00:00	AMZN	Stock	35.2495	35.3493	35.2175	35.2186	6275680.0
2016-06-17 12:00:00	AMZN	Stock	35.2318	35.326	35.1825	35.214	4259920.0
2016-06-17 13:00:00	AMZN	Stock	35.207	35.2715	35.177	35.2395	3942360.0
2016-06-17 14:00:00	AMZN	Stock	35.229	35.2415	35.075	35.1115	7524620.0
2016-06-17 15:00:00	AMZN	Stock	35.115	35.318	34.959	35.318	24869320.0
2016-06-17 16:00:00	AMZN	Stock	35.29	35.318	35.2115	35.225	6373080.0
2016-06-17 17:00:00	AMZN	Stock	35.225	35.2475	35.223	35.2285	47000.0

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

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