PREVIEW / stock_1hour / 2016-06-15

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-06-15.parquet
  size:    1.0 MB
  rows:    48,477
  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-15 04:00:00	AAPL	Stock	24.415	24.45	24.415	24.4325	2372.0
2016-06-15 05:00:00	AAPL	Stock	24.45	24.475	24.45	24.475	4744.0
2016-06-15 06:00:00	AAPL	Stock	24.475	24.475	24.475	24.475	400.0
2016-06-15 07:00:00	AAPL	Stock	24.475	24.4825	24.45	24.455	32428.0
2016-06-15 08:00:00	AAPL	Stock	24.4375	24.475	24.4025	24.445	231700.0
2016-06-15 09:00:00	AAPL	Stock	24.4425	24.6025	24.43	24.495	16672048.0
2016-06-15 10:00:00	AAPL	Stock	24.495	24.5725	24.4775	24.5525	14604012.0
2016-06-15 11:00:00	AAPL	Stock	24.5512	24.6025	24.5175	24.56	10745860.0
2016-06-15 12:00:00	AAPL	Stock	24.5575	24.5575	24.4425	24.445	9052004.0
2016-06-15 13:00:00	AAPL	Stock	24.445	24.515	24.415	24.4725	7717272.0
2016-06-15 14:00:00	AAPL	Stock	24.4775	24.5525	24.4375	24.455	13948856.0
2016-06-15 15:00:00	AAPL	Stock	24.4525	24.4625	24.2575	24.285	22853144.0
2016-06-15 16:00:00	AAPL	Stock	24.285	24.295	24.245	24.2625	13453476.0
2016-06-15 17:00:00	AAPL	Stock	24.2625	24.285	24.25	24.25	319584.0
2016-06-15 18:00:00	AAPL	Stock	24.25	24.2675	24.2475	24.2475	17640.0
2016-06-15 19:00:00	AAPL	Stock	24.2475	24.265	24.2475	24.2625	38344.0
2016-06-15 05:00:00	MSFT	Stock	50.06	50.23	50.06	50.23	300.0
2016-06-15 06:00:00	MSFT	Stock	50.07	50.15	50.06	50.06	300.0
2016-06-15 07:00:00	MSFT	Stock	50.06	50.12	50.06	50.06	1300.0
2016-06-15 08:00:00	MSFT	Stock	50.12	50.12	49.97	50.03	5261.0
2016-06-15 09:00:00	MSFT	Stock	50.05	50.05	49.72	49.86	3331483.0
2016-06-15 10:00:00	MSFT	Stock	49.87	50.12	49.87	50.045	4280017.0
2016-06-15 11:00:00	MSFT	Stock	50.05	50.12	49.75	49.93	2817730.0
2016-06-15 12:00:00	MSFT	Stock	49.925	49.95	49.77	49.77	3057555.0
2016-06-15 13:00:00	MSFT	Stock	49.77	49.99	49.69	49.93	2874398.0
2016-06-15 14:00:00	MSFT	Stock	49.95	50.06	49.82	49.95	4141373.0
2016-06-15 15:00:00	MSFT	Stock	49.95	50.016	49.69	49.7	7030904.0
2016-06-15 16:00:00	MSFT	Stock	49.69	49.74	42.63	42.63	4673282.0
2016-06-15 17:00:00	MSFT	Stock	49.7	49.7	49.69	49.7	70109.0
2016-06-15 18:00:00	MSFT	Stock	49.7	49.7	49.69	49.69	3600.0
2016-06-15 19:00:00	MSFT	Stock	49.7	49.71	49.7	49.71	3000.0
2016-06-15 06:00:00	NVDA	Stock	1.1873	1.1873	1.1775	1.1775	12000.0
2016-06-15 08:00:00	NVDA	Stock	1.1825	1.1838	1.1825	1.1838	44560.0
2016-06-15 09:00:00	NVDA	Stock	1.1825	1.1875	1.1688	1.1705	32424080.0
2016-06-15 10:00:00	NVDA	Stock	1.1705	1.1832	1.17	1.1805	45019160.0
2016-06-15 11:00:00	NVDA	Stock	1.1802	1.1874	1.1778	1.1855	29382080.0
2016-06-15 12:00:00	NVDA	Stock	1.1855	1.1858	1.1808	1.1824	20915360.0
2016-06-15 13:00:00	NVDA	Stock	1.1824	1.1898	1.1822	1.1898	22214880.0
2016-06-15 14:00:00	NVDA	Stock	1.1898	1.1942	1.1874	1.193	45348960.0
2016-06-15 15:00:00	NVDA	Stock	1.1928	1.1938	1.1825	1.184	50280360.0
2016-06-15 16:00:00	NVDA	Stock	1.184	1.1855	1.1825	1.1825	40476600.0
2016-06-15 17:00:00	NVDA	Stock	1.1825	1.184	1.1825	1.184	820000.0
2016-06-15 18:00:00	NVDA	Stock	1.1825	1.1825	1.1813	1.1813	55600.0
2016-06-15 07:00:00	AMZN	Stock	36.08	36.08	36.0515	36.053	6000.0
2016-06-15 08:00:00	AMZN	Stock	36.05	36.05	36.0195	36.04	148300.0
2016-06-15 09:00:00	AMZN	Stock	36.035	36.128	35.83	35.901	7342480.0
2016-06-15 10:00:00	AMZN	Stock	35.8865	35.9395	35.7067	35.884	5893560.0
2016-06-15 11:00:00	AMZN	Stock	35.89	35.917	35.7775	35.9075	4205940.0
2016-06-15 12:00:00	AMZN	Stock	35.9073	35.922	35.8185	35.878	3633420.0
2016-06-15 13:00:00	AMZN	Stock	35.878	36.0345	35.878	36.004	3398060.0

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

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