PREVIEW / stock_1hour / 2015-09-10

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-09-10.parquet
  size:    1.0 MB
  rows:    48,507
  symbols: 3,455

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
2015-09-10 04:00:00	AAPL	Stock	27.7125	27.7875	27.6	27.675	28792.0
2015-09-10 05:00:00	AAPL	Stock	27.675	27.8125	27.6375	27.7825	95356.0
2015-09-10 06:00:00	AAPL	Stock	27.8125	27.87	27.6375	27.68	119804.0
2015-09-10 07:00:00	AAPL	Stock	27.6875	27.72	27.465	27.525	490080.0
2015-09-10 08:00:00	AAPL	Stock	27.535	27.7125	27.42	27.45	1819340.0
2015-09-10 09:00:00	AAPL	Stock	27.4625	27.92	27.4525	27.795	41465732.0
2015-09-10 10:00:00	AAPL	Stock	27.7975	28.1775	27.6722	28.0838	46772692.0
2015-09-10 11:00:00	AAPL	Stock	28.0825	28.165	27.94	28.105	29988388.0
2015-09-10 12:00:00	AAPL	Stock	28.11	28.195	28.0475	28.1188	21834128.0
2015-09-10 13:00:00	AAPL	Stock	28.1175	28.3205	28.06	28.2075	25277396.0
2015-09-10 14:00:00	AAPL	Stock	28.2075	28.28	28.0778	28.133	21469276.0
2015-09-10 15:00:00	AAPL	Stock	28.1325	28.2125	27.9875	28.1475	37374340.0
2015-09-10 16:00:00	AAPL	Stock	28.1425	28.15	27.7152	28.125	8128472.0
2015-09-10 17:00:00	AAPL	Stock	28.125	28.15	28.1175	28.125	92112.0
2015-09-10 18:00:00	AAPL	Stock	28.12	28.1625	28.12	28.1625	78148.0
2015-09-10 19:00:00	AAPL	Stock	28.145	28.1625	28.105	28.1125	78128.0
2015-09-10 04:00:00	MSFT	Stock	43.44	43.44	43.44	43.44	100.0
2015-09-10 05:00:00	MSFT	Stock	43.48	43.48	43.48	43.48	100.0
2015-09-10 07:00:00	MSFT	Stock	43.08	43.08	43.08	43.08	100.0
2015-09-10 08:00:00	MSFT	Stock	43.15	43.15	42.79	42.83	5300.0
2015-09-10 09:00:00	MSFT	Stock	42.89	43.15	42.82	42.82	3068696.0
2015-09-10 10:00:00	MSFT	Stock	42.825	43.6	42.745	43.49	4949120.0
2015-09-10 11:00:00	MSFT	Stock	43.49	43.49	43.105	43.29	2962347.0
2015-09-10 12:00:00	MSFT	Stock	43.3	43.51	43.25	43.405	2258387.0
2015-09-10 13:00:00	MSFT	Stock	43.409	43.79	43.31	43.53	3404396.0
2015-09-10 14:00:00	MSFT	Stock	43.524	43.58	43.283	43.283	2535643.0
2015-09-10 15:00:00	MSFT	Stock	43.29	43.36	43.07	43.3	5103240.0
2015-09-10 16:00:00	MSFT	Stock	43.29	43.29	43.2	43.2	5919990.0
2015-09-10 09:00:00	NVDA	Stock	0.553	0.5605	0.5508	0.551	42172320.0
2015-09-10 10:00:00	NVDA	Stock	0.5512	0.5668	0.5499	0.5662	59460480.0
2015-09-10 11:00:00	NVDA	Stock	0.5662	0.5665	0.56	0.5655	26869440.0
2015-09-10 12:00:00	NVDA	Stock	0.5655	0.5684	0.5649	0.5655	37250000.0
2015-09-10 13:00:00	NVDA	Stock	0.5658	0.5715	0.5645	0.5696	42358000.0
2015-09-10 14:00:00	NVDA	Stock	0.5698	0.5702	0.5645	0.5646	36158840.0
2015-09-10 15:00:00	NVDA	Stock	0.5645	0.5658	0.5615	0.5645	56094520.0
2015-09-10 16:00:00	NVDA	Stock	0.5645	0.565	0.5645	0.565	39115600.0
2015-09-10 04:00:00	AMZN	Stock	25.9005	25.933	25.9005	25.933	4000.0
2015-09-10 05:00:00	AMZN	Stock	25.997	26.1875	25.997	26.1875	8840.0
2015-09-10 06:00:00	AMZN	Stock	26.05	26.25	25.97	25.975	45080.0
2015-09-10 07:00:00	AMZN	Stock	25.9755	25.9755	25.8845	25.897	44180.0
2015-09-10 08:00:00	AMZN	Stock	25.8995	25.8995	25.671	25.725	210600.0
2015-09-10 09:00:00	AMZN	Stock	25.7	26.057	25.7	25.913	5609880.0
2015-09-10 10:00:00	AMZN	Stock	25.93	26.227	25.8595	26.185	7493740.0
2015-09-10 11:00:00	AMZN	Stock	26.1745	26.1905	26.0095	26.0875	4841640.0
2015-09-10 12:00:00	AMZN	Stock	26.0848	26.1875	26.0485	26.11	2959020.0
2015-09-10 13:00:00	AMZN	Stock	26.0966	26.3065	26.0625	26.2325	5082220.0
2015-09-10 14:00:00	AMZN	Stock	26.24	26.25	26.0005	26.01	5229200.0
2015-09-10 15:00:00	AMZN	Stock	26.0065	26.1205	25.9544	26.112	7606840.0
2015-09-10 16:00:00	AMZN	Stock	26.112	26.112	26.09	26.1095	2180940.0
2015-09-10 17:00:00	AMZN	Stock	26.0975	26.1095	26.0975	26.1085	30000.0

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

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