PREVIEW / stock_1hour / 2016-05-12

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-05-12.parquet
  size:    1.0 MB
  rows:    48,112
  symbols: 3,297

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-05-12 04:00:00	AAPL	Stock	23.125	23.17	23.125	23.17	17256.0
2016-05-12 05:00:00	AAPL	Stock	23.16	23.175	23.16	23.175	4368.0
2016-05-12 06:00:00	AAPL	Stock	23.1725	23.2075	23.1725	23.2075	7600.0
2016-05-12 07:00:00	AAPL	Stock	23.1975	23.2475	23.1725	23.1925	102540.0
2016-05-12 08:00:00	AAPL	Stock	23.1925	23.2	23.145	23.1625	121004.0
2016-05-12 09:00:00	AAPL	Stock	23.1625	23.2	22.7125	22.735	41263120.0
2016-05-12 10:00:00	AAPL	Stock	22.7338	22.8025	22.525	22.5425	63543760.0
2016-05-12 11:00:00	AAPL	Stock	22.5425	22.5825	22.3675	22.4792	62209352.0
2016-05-12 12:00:00	AAPL	Stock	22.4775	22.58	22.445	22.5668	26710996.0
2016-05-12 13:00:00	AAPL	Stock	22.5675	22.5825	22.4725	22.5612	21885468.0
2016-05-12 14:00:00	AAPL	Stock	22.5612	22.6925	22.5225	22.6425	26915940.0
2016-05-12 15:00:00	AAPL	Stock	22.6447	22.7025	22.5325	22.585	33130540.0
2016-05-12 16:00:00	AAPL	Stock	22.585	22.9232	22.5325	22.5375	6904340.0
2016-05-12 17:00:00	AAPL	Stock	22.5425	22.575	22.5375	22.555	135416.0
2016-05-12 18:00:00	AAPL	Stock	22.555	22.5675	22.5225	22.5325	90592.0
2016-05-12 19:00:00	AAPL	Stock	22.525	22.54	22.47	22.505	321172.0
2016-05-12 07:00:00	MSFT	Stock	51.32	51.32	51.24	51.29	24356.0
2016-05-12 08:00:00	MSFT	Stock	51.25	51.43	51.25	51.28	4153.0
2016-05-12 09:00:00	MSFT	Stock	51.28	51.48	51.05	51.33	2284699.0
2016-05-12 10:00:00	MSFT	Stock	51.335	51.518	51.325	51.41	3091967.0
2016-05-12 11:00:00	MSFT	Stock	51.41	51.43	50.98	51.02	2778627.0
2016-05-12 12:00:00	MSFT	Stock	51.015	51.21	50.92	51.2	1675652.0
2016-05-12 13:00:00	MSFT	Stock	51.207	51.44	51.11	51.44	1918860.0
2016-05-12 14:00:00	MSFT	Stock	51.44	51.81	51.43	51.7	3179630.0
2016-05-12 15:00:00	MSFT	Stock	51.69	51.7	51.442	51.51	5860008.0
2016-05-12 16:00:00	MSFT	Stock	51.52	51.53	51.5	51.51	2038369.0
2016-05-12 17:00:00	MSFT	Stock	51.5	51.56	51.43	51.43	739.0
2016-05-12 18:00:00	MSFT	Stock	51.44	51.44	51.44	51.44	256.0
2016-05-12 19:00:00	MSFT	Stock	51.52	51.52	51.52	51.52	100.0
2016-05-12 07:00:00	NVDA	Stock	0.9082	0.9088	0.9082	0.9088	60600.0
2016-05-12 08:00:00	NVDA	Stock	0.909	0.9148	0.909	0.9123	532360.0
2016-05-12 09:00:00	NVDA	Stock	0.91	0.9133	0.8875	0.8875	50749760.0
2016-05-12 10:00:00	NVDA	Stock	0.8875	0.8926	0.8834	0.8846	83855160.0
2016-05-12 11:00:00	NVDA	Stock	0.8845	0.8854	0.8732	0.8758	89673280.0
2016-05-12 12:00:00	NVDA	Stock	0.8756	0.884	0.8745	0.884	59379040.0
2016-05-12 13:00:00	NVDA	Stock	0.884	0.8865	0.8784	0.8863	48166880.0
2016-05-12 14:00:00	NVDA	Stock	0.8863	0.8938	0.8852	0.8932	71573480.0
2016-05-12 15:00:00	NVDA	Stock	0.8935	0.8935	0.8868	0.889	142400560.0
2016-05-12 16:00:00	NVDA	Stock	0.8893	0.9488	0.8868	0.941	34869280.0
2016-05-12 17:00:00	NVDA	Stock	0.94	0.9588	0.94	0.9578	14446320.0
2016-05-12 18:00:00	NVDA	Stock	0.9565	0.958	0.9515	0.952	1386560.0
2016-05-12 19:00:00	NVDA	Stock	0.9525	0.9552	0.9505	0.9548	971440.0
2016-05-12 04:00:00	AMZN	Stock	35.7	35.7	35.7	35.7	4000.0
2016-05-12 05:00:00	AMZN	Stock	35.7885	35.7885	35.7885	35.7885	2080.0
2016-05-12 06:00:00	AMZN	Stock	35.7825	35.8	35.7825	35.8	14000.0
2016-05-12 07:00:00	AMZN	Stock	35.845	35.994	35.845	35.9015	287220.0
2016-05-12 08:00:00	AMZN	Stock	35.9155	35.9975	35.59	35.8605	490060.0
2016-05-12 09:00:00	AMZN	Stock	35.8745	36.0605	35.747	35.839	18574660.0
2016-05-12 10:00:00	AMZN	Stock	35.8385	35.898	35.612	35.7079	15257400.0
2016-05-12 11:00:00	AMZN	Stock	35.7068	35.822	35.5755	35.6895	7928800.0

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

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