PREVIEW / stock_1hour / 2016-09-13

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-09-13.parquet
  size:    1.0 MB
  rows:    48,766
  symbols: 3,245

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-09-13 04:00:00	AAPL	Stock	26.32	26.32	26.25	26.25	8200.0
2016-09-13 05:00:00	AAPL	Stock	26.245	26.26	26.225	26.26	8512.0
2016-09-13 06:00:00	AAPL	Stock	26.25	26.35	26.25	26.31	31496.0
2016-09-13 07:00:00	AAPL	Stock	26.3	26.7475	26.3	26.73	1055280.0
2016-09-13 08:00:00	AAPL	Stock	26.73	26.9025	26.3275	26.84	4423680.0
2016-09-13 09:00:00	AAPL	Stock	26.845	27.1975	26.79	27.0325	63105556.0
2016-09-13 10:00:00	AAPL	Stock	27.035	27.1375	26.9225	27.0675	39296376.0
2016-09-13 11:00:00	AAPL	Stock	27.0675	27.0825	27.005	27.025	23303620.0
2016-09-13 12:00:00	AAPL	Stock	27.0212	27.1	26.36	27.046	18090012.0
2016-09-13 13:00:00	AAPL	Stock	27.0462	27.12	26.965	27.0075	17338724.0
2016-09-13 14:00:00	AAPL	Stock	27.0075	27.05	26.9548	26.965	20272308.0
2016-09-13 15:00:00	AAPL	Stock	26.965	27.08	26.93	27.005	36208300.0
2016-09-13 16:00:00	AAPL	Stock	26.9875	27.04	26.975	26.9925	8759364.0
2016-09-13 17:00:00	AAPL	Stock	26.995	27.0	26.95	26.98	385420.0
2016-09-13 18:00:00	AAPL	Stock	26.9825	26.985	26.9675	26.98	54052.0
2016-09-13 19:00:00	AAPL	Stock	26.985	26.985	26.9525	26.9525	75616.0
2016-09-13 08:00:00	MSFT	Stock	56.73	56.78	56.57	56.62	3575.0
2016-09-13 09:00:00	MSFT	Stock	56.57	56.64	56.25	56.375	3473890.0
2016-09-13 10:00:00	MSFT	Stock	56.38	56.485	56.18	56.23	3730530.0
2016-09-13 11:00:00	MSFT	Stock	56.22	56.3	56.05	56.264	2451377.0
2016-09-13 12:00:00	MSFT	Stock	56.26	57.05	56.1	56.185	2869313.0
2016-09-13 13:00:00	MSFT	Stock	56.18	56.455	56.07	56.31	2548172.0
2016-09-13 14:00:00	MSFT	Stock	56.305	56.4	56.17	56.22	3036594.0
2016-09-13 15:00:00	MSFT	Stock	56.22	56.65	56.12	56.53	7397631.0
2016-09-13 16:00:00	MSFT	Stock	56.53	56.57	56.49	56.57	2362043.0
2016-09-13 17:00:00	MSFT	Stock	56.67	56.67	56.53	56.53	248169.0
2016-09-13 18:00:00	MSFT	Stock	56.56	56.56	56.56	56.56	300.0
2016-09-13 19:00:00	MSFT	Stock	56.59	56.66	56.56	56.58	2050.0
2016-09-13 04:00:00	NVDA	Stock	1.52	1.52	1.5025	1.5025	158440.0
2016-09-13 05:00:00	NVDA	Stock	1.5025	1.5025	1.495	1.495	159160.0
2016-09-13 06:00:00	NVDA	Stock	1.495	1.5002	1.495	1.5	132080.0
2016-09-13 07:00:00	NVDA	Stock	1.5038	1.514	1.5038	1.51	279720.0
2016-09-13 08:00:00	NVDA	Stock	1.51	1.5138	1.5072	1.5125	497200.0
2016-09-13 09:00:00	NVDA	Stock	1.5078	1.5325	1.5075	1.516	81316560.0
2016-09-13 10:00:00	NVDA	Stock	1.5165	1.5188	1.5065	1.51	69384080.0
2016-09-13 11:00:00	NVDA	Stock	1.51	1.5105	1.4886	1.4916	67524880.0
2016-09-13 12:00:00	NVDA	Stock	1.4912	1.5188	1.4882	1.493	44987360.0
2016-09-13 13:00:00	NVDA	Stock	1.493	1.5053	1.489	1.5002	28920480.0
2016-09-13 14:00:00	NVDA	Stock	1.5	1.502	1.4922	1.4938	25347840.0
2016-09-13 15:00:00	NVDA	Stock	1.4938	1.5042	1.4928	1.4972	70540640.0
2016-09-13 16:00:00	NVDA	Stock	1.4968	1.4998	1.4968	1.4998	51621240.0
2016-09-13 17:00:00	NVDA	Stock	1.5005	1.5005	1.4968	1.497	738000.0
2016-09-13 18:00:00	NVDA	Stock	1.5	1.5005	1.5	1.5	152000.0
2016-09-13 19:00:00	NVDA	Stock	1.4968	1.4968	1.4968	1.4968	4000.0
2016-09-13 04:00:00	AMZN	Stock	38.453	38.453	38.453	38.453	2000.0
2016-09-13 07:00:00	AMZN	Stock	38.422	38.422	38.388	38.4	25540.0
2016-09-13 08:00:00	AMZN	Stock	38.365	38.4325	38.331	38.386	130840.0
2016-09-13 09:00:00	AMZN	Stock	38.3945	38.4945	38.1	38.168	8657700.0
2016-09-13 10:00:00	AMZN	Stock	38.1615	38.199	37.978	37.978	10640160.0
2016-09-13 11:00:00	AMZN	Stock	37.9805	38.11	37.9546	38.0905	5982400.0

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

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