PREVIEW / stock_1hour / 2016-11-15

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-11-15.parquet
  size:    1.1 MB
  rows:    49,847
  symbols: 3,197

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-11-15 04:00:00	AAPL	Stock	26.4675	26.4675	26.4675	26.4675	1680.0
2016-11-15 06:00:00	AAPL	Stock	26.475	26.4825	26.4375	26.4625	36772.0
2016-11-15 07:00:00	AAPL	Stock	26.47	26.5	26.4	26.4375	49380.0
2016-11-15 08:00:00	AAPL	Stock	26.45	26.675	26.4025	26.665	428244.0
2016-11-15 09:00:00	AAPL	Stock	26.6675	26.825	26.5398	26.7425	21896688.0
2016-11-15 10:00:00	AAPL	Stock	26.7412	26.92	26.6825	26.78	26219248.0
2016-11-15 11:00:00	AAPL	Stock	26.78	26.83	26.68	26.68	13041236.0
2016-11-15 12:00:00	AAPL	Stock	26.68	26.7012	26.5875	26.6112	9284360.0
2016-11-15 13:00:00	AAPL	Stock	26.6125	26.745	26.59	26.7362	7778380.0
2016-11-15 14:00:00	AAPL	Stock	26.7375	26.8638	26.7275	26.8615	10320832.0
2016-11-15 15:00:00	AAPL	Stock	26.8625	26.9025	26.7775	26.7775	21363072.0
2016-11-15 16:00:00	AAPL	Stock	26.7775	26.79	26.6782	26.7775	7904148.0
2016-11-15 17:00:00	AAPL	Stock	26.7775	26.7775	26.7625	26.7725	38184.0
2016-11-15 18:00:00	AAPL	Stock	26.775	26.7775	26.7575	26.7775	63276.0
2016-11-15 19:00:00	AAPL	Stock	26.7625	26.7875	26.7625	26.7775	45872.0
2016-11-15 05:00:00	MSFT	Stock	57.75	57.75	57.75	57.75	500.0
2016-11-15 06:00:00	MSFT	Stock	57.77	57.77	57.77	57.77	400.0
2016-11-15 07:00:00	MSFT	Stock	57.75	57.91	57.75	57.82	20167.0
2016-11-15 08:00:00	MSFT	Stock	57.85	58.35	57.83	58.33	76148.0
2016-11-15 09:00:00	MSFT	Stock	58.34	59.1	58.28	59.08	4602195.0
2016-11-15 10:00:00	MSFT	Stock	59.085	59.49	58.95	59.1	6027625.0
2016-11-15 11:00:00	MSFT	Stock	59.105	59.26	58.96	59.03	3081711.0
2016-11-15 12:00:00	MSFT	Stock	59.03	59.07	58.61	58.665	2333886.0
2016-11-15 13:00:00	MSFT	Stock	58.67	58.85	58.66	58.847	3213591.0
2016-11-15 14:00:00	MSFT	Stock	58.84	59.12	58.793	59.08	2729735.0
2016-11-15 15:00:00	MSFT	Stock	59.08	59.16	58.87	58.87	6889557.0
2016-11-15 16:00:00	MSFT	Stock	58.9	58.97	58.87	58.87	4291026.0
2016-11-15 17:00:00	MSFT	Stock	58.87	59.15	58.87	59.13	544572.0
2016-11-15 18:00:00	MSFT	Stock	59.13	59.2	59.12	59.16	9647.0
2016-11-15 19:00:00	MSFT	Stock	59.14	59.18	59.08	59.18	3640.0
2016-11-15 07:00:00	NVDA	Stock	2.0837	2.0858	2.0837	2.085	55400.0
2016-11-15 08:00:00	NVDA	Stock	2.0925	2.1093	2.0925	2.1088	797160.0
2016-11-15 09:00:00	NVDA	Stock	2.1088	2.132	2.0982	2.1315	98033640.0
2016-11-15 10:00:00	NVDA	Stock	2.131	2.1863	2.1295	2.1765	196112320.0
2016-11-15 11:00:00	NVDA	Stock	2.177	2.1775	2.1478	2.1635	74357400.0
2016-11-15 12:00:00	NVDA	Stock	2.1632	2.1758	2.1543	2.1595	52817960.0
2016-11-15 13:00:00	NVDA	Stock	2.1595	2.1618	2.1438	2.149	33621480.0
2016-11-15 14:00:00	NVDA	Stock	2.149	2.1602	2.1425	2.1552	51868560.0
2016-11-15 15:00:00	NVDA	Stock	2.155	2.1628	2.1508	2.1548	78937040.0
2016-11-15 16:00:00	NVDA	Stock	2.1548	2.1688	2.1548	2.1685	9386480.0
2016-11-15 17:00:00	NVDA	Stock	2.1663	2.1688	2.1625	2.1625	66040.0
2016-11-15 18:00:00	NVDA	Stock	2.1625	2.1872	2.1625	2.1795	1552280.0
2016-11-15 19:00:00	NVDA	Stock	2.1795	2.1875	2.178	2.1875	491480.0
2016-11-15 04:00:00	AMZN	Stock	36.0035	36.0035	35.9975	35.9975	5600.0
2016-11-15 05:00:00	AMZN	Stock	36.209	36.2755	36.209	36.2555	19000.0
2016-11-15 06:00:00	AMZN	Stock	36.2505	36.2565	36.2505	36.2565	4700.0
2016-11-15 07:00:00	AMZN	Stock	36.21	36.325	36.2	36.3	52600.0
2016-11-15 08:00:00	AMZN	Stock	36.2945	36.634	36.1505	36.45	973520.0
2016-11-15 09:00:00	AMZN	Stock	36.4515	37.03	36.2995	36.911	30986060.0
2016-11-15 10:00:00	AMZN	Stock	36.9178	37.1105	36.7425	36.9	21164560.0

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

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