PREVIEW / stock_1hour / 2016-06-22

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-06-22.parquet
  size:    1.0 MB
  rows:    47,781
  symbols: 3,291

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-22 04:00:00	AAPL	Stock	24.0125	24.0125	24.0125	24.0125	1400.0
2016-06-22 05:00:00	AAPL	Stock	24.0475	24.0475	24.0475	24.0475	480.0
2016-06-22 06:00:00	AAPL	Stock	24.0625	24.0725	24.0375	24.0725	8360.0
2016-06-22 07:00:00	AAPL	Stock	24.075	24.175	24.06	24.1625	117968.0
2016-06-22 08:00:00	AAPL	Stock	24.1625	24.175	24.05	24.1225	570780.0
2016-06-22 09:00:00	AAPL	Stock	24.1175	24.2225	24.06	24.15	14786788.0
2016-06-22 10:00:00	AAPL	Stock	24.155	24.2175	24.105	24.1912	15199200.0
2016-06-22 11:00:00	AAPL	Stock	24.1925	24.2075	24.075	24.0875	11407948.0
2016-06-22 12:00:00	AAPL	Stock	24.0855	24.0975	23.885	23.94	17552824.0
2016-06-22 13:00:00	AAPL	Stock	23.9425	23.96	23.8375	23.935	13858824.0
2016-06-22 14:00:00	AAPL	Stock	23.9328	23.9625	23.8975	23.915	8152808.0
2016-06-22 15:00:00	AAPL	Stock	23.915	23.9625	23.8412	23.89	17604468.0
2016-06-22 16:00:00	AAPL	Stock	23.8875	23.9	23.885	23.8975	7181296.0
2016-06-22 17:00:00	AAPL	Stock	23.9	23.925	23.89	23.92	99744.0
2016-06-22 18:00:00	AAPL	Stock	23.9325	23.97	23.925	23.94	135540.0
2016-06-22 19:00:00	AAPL	Stock	23.9525	23.9575	23.94	23.9575	30304.0
2016-06-22 06:00:00	MSFT	Stock	51.5	51.5	51.5	51.5	100.0
2016-06-22 07:00:00	MSFT	Stock	51.24	51.45	51.22	51.45	1189.0
2016-06-22 08:00:00	MSFT	Stock	51.23	51.45	51.23	51.25	4800.0
2016-06-22 09:00:00	MSFT	Stock	51.39	51.46	51.04	51.335	3184308.0
2016-06-22 10:00:00	MSFT	Stock	51.33	51.35	51.11	51.305	4122840.0
2016-06-22 11:00:00	MSFT	Stock	51.31	51.33	51.2	51.214	3290819.0
2016-06-22 12:00:00	MSFT	Stock	51.22	51.28	50.99	51.24	2833001.0
2016-06-22 13:00:00	MSFT	Stock	51.235	51.28	50.99	51.21	2335475.0
2016-06-22 14:00:00	MSFT	Stock	51.214	51.27	51.01	51.18	2667092.0
2016-06-22 15:00:00	MSFT	Stock	51.17	51.22	50.952	51.0	5599110.0
2016-06-22 16:00:00	MSFT	Stock	50.99	51.04	50.96	50.99	2795714.0
2016-06-22 17:00:00	MSFT	Stock	51.02	51.06	51.0	51.06	4168.0
2016-06-22 18:00:00	MSFT	Stock	51.06	51.06	51.06	51.06	10130.0
2016-06-22 19:00:00	MSFT	Stock	51.09	51.14	51.06	51.06	3049.0
2016-06-22 09:00:00	NVDA	Stock	1.184	1.192	1.1838	1.1895	30570600.0
2016-06-22 10:00:00	NVDA	Stock	1.1895	1.1911	1.1852	1.189	30696720.0
2016-06-22 11:00:00	NVDA	Stock	1.1891	1.1902	1.1855	1.1888	21132120.0
2016-06-22 12:00:00	NVDA	Stock	1.1888	1.1893	1.182	1.1832	17432480.0
2016-06-22 13:00:00	NVDA	Stock	1.183	1.1868	1.1788	1.186	16742200.0
2016-06-22 14:00:00	NVDA	Stock	1.1858	1.1862	1.1818	1.1835	17812400.0
2016-06-22 15:00:00	NVDA	Stock	1.1832	1.1848	1.1788	1.1808	42765160.0
2016-06-22 16:00:00	NVDA	Stock	1.1805	1.1808	1.1785	1.1785	4690720.0
2016-06-22 17:00:00	NVDA	Stock	1.1808	1.1825	1.1785	1.179	2354000.0
2016-06-22 18:00:00	NVDA	Stock	1.1808	1.1808	1.1808	1.1808	800000.0
2016-06-22 19:00:00	NVDA	Stock	1.1835	1.1835	1.1835	1.1835	8000.0
2016-06-22 07:00:00	AMZN	Stock	35.8445	35.8675	35.8445	35.8675	6000.0
2016-06-22 08:00:00	AMZN	Stock	35.8005	35.8625	35.8005	35.858	15000.0
2016-06-22 09:00:00	AMZN	Stock	35.85	35.855	35.414	35.4355	6886100.0
2016-06-22 10:00:00	AMZN	Stock	35.42	35.599	35.3782	35.5925	5309340.0
2016-06-22 11:00:00	AMZN	Stock	35.5942	35.7535	35.5795	35.6456	5334220.0
2016-06-22 12:00:00	AMZN	Stock	35.6473	35.7245	35.518	35.5965	3698040.0
2016-06-22 13:00:00	AMZN	Stock	35.591	35.68	35.5	35.649	4242840.0
2016-06-22 14:00:00	AMZN	Stock	35.651	35.7055	35.556	35.5873	2995100.0
2016-06-22 15:00:00	AMZN	Stock	35.583	35.638	35.4765	35.53	7279540.0

> showing 50 of 47,781 rows — these rows as CSV

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