PREVIEW / stock_1hour / 2015-07-30

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-07-30.parquet
  size:    1.0 MB
  rows:    48,322
  symbols: 3,469

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-07-30 04:00:00	AAPL	Stock	30.625	30.675	30.6	30.6425	11544.0
2015-07-30 05:00:00	AAPL	Stock	30.6125	30.685	30.6125	30.685	11724.0
2015-07-30 06:00:00	AAPL	Stock	30.7	30.74	30.6925	30.7	12400.0
2015-07-30 07:00:00	AAPL	Stock	30.7	30.7	30.6125	30.6875	77256.0
2015-07-30 08:00:00	AAPL	Stock	30.685	30.7	30.625	30.6375	269232.0
2015-07-30 09:00:00	AAPL	Stock	30.635	30.645	30.4275	30.465	29969696.0
2015-07-30 10:00:00	AAPL	Stock	30.465	30.6075	30.435	30.5188	21837216.0
2015-07-30 11:00:00	AAPL	Stock	30.5198	30.5825	30.4425	30.565	14667840.0
2015-07-30 12:00:00	AAPL	Stock	30.565	30.6	30.5338	30.5775	8516172.0
2015-07-30 13:00:00	AAPL	Stock	30.5762	30.595	30.4825	30.492	10996440.0
2015-07-30 14:00:00	AAPL	Stock	30.4912	30.57	30.465	30.535	9646812.0
2015-07-30 15:00:00	AAPL	Stock	30.535	30.6425	30.5325	30.5925	18365516.0
2015-07-30 16:00:00	AAPL	Stock	30.595	30.7125	30.5	30.7125	4254716.0
2015-07-30 17:00:00	AAPL	Stock	30.72	30.7425	30.5925	30.6375	556980.0
2015-07-30 18:00:00	AAPL	Stock	30.6375	30.6375	30.5075	30.5375	469220.0
2015-07-30 19:00:00	AAPL	Stock	30.5425	30.6	30.5075	30.5775	167564.0
2015-07-30 05:00:00	MSFT	Stock	46.25	46.25	46.25	46.25	143.0
2015-07-30 08:00:00	MSFT	Stock	46.36	46.36	46.17	46.17	26484.0
2015-07-30 09:00:00	MSFT	Stock	46.21	46.37	45.941	45.97	3766043.0
2015-07-30 10:00:00	MSFT	Stock	45.97	46.37	45.93	46.25	4464121.0
2015-07-30 11:00:00	MSFT	Stock	46.25	46.77	46.194	46.744	4849039.0
2015-07-30 12:00:00	MSFT	Stock	46.75	47.24	46.67	47.21	5193239.0
2015-07-30 13:00:00	MSFT	Stock	47.22	47.4	47.08	47.08	6184155.0
2015-07-30 14:00:00	MSFT	Stock	47.08	47.18	46.98	47.12	3509813.0
2015-07-30 15:00:00	MSFT	Stock	47.11	47.16	46.89	46.89	7675574.0
2015-07-30 16:00:00	MSFT	Stock	46.89	47.2	46.2	47.0	2254491.0
2015-07-30 17:00:00	MSFT	Stock	47.01	47.01	46.98	46.98	2334.0
2015-07-30 18:00:00	MSFT	Stock	46.95	46.95	46.88	46.88	19322.0
2015-07-30 19:00:00	MSFT	Stock	47.03	47.05	47.03	47.05	390.0
2015-07-30 09:00:00	NVDA	Stock	0.498	0.503	0.498	0.501	14666040.0
2015-07-30 10:00:00	NVDA	Stock	0.5008	0.5055	0.4995	0.5	28235800.0
2015-07-30 11:00:00	NVDA	Stock	0.4998	0.5032	0.4992	0.5013	30755120.0
2015-07-30 12:00:00	NVDA	Stock	0.5013	0.5025	0.5	0.5013	23739680.0
2015-07-30 13:00:00	NVDA	Stock	0.5013	0.5015	0.4998	0.5005	15772880.0
2015-07-30 14:00:00	NVDA	Stock	0.5003	0.5022	0.5	0.502	22393320.0
2015-07-30 15:00:00	NVDA	Stock	0.5021	0.5022	0.5	0.5003	42484480.0
2015-07-30 16:00:00	NVDA	Stock	0.5005	0.5005	0.5003	0.5005	6311960.0
2015-07-30 17:00:00	NVDA	Stock	0.5025	0.5025	0.5025	0.5025	4000.0
2015-07-30 18:00:00	NVDA	Stock	0.5025	0.5025	0.5006	0.5006	10000.0
2015-07-30 07:00:00	AMZN	Stock	26.412	26.446	26.375	26.375	8000.0
2015-07-30 08:00:00	AMZN	Stock	26.408	26.4525	26.3965	26.435	162480.0
2015-07-30 09:00:00	AMZN	Stock	26.4105	26.5675	26.2145	26.2945	8483240.0
2015-07-30 10:00:00	AMZN	Stock	26.295	26.485	26.266	26.444	9703760.0
2015-07-30 11:00:00	AMZN	Stock	26.446	26.81	26.4265	26.727	14206960.0
2015-07-30 12:00:00	AMZN	Stock	26.735	26.853	26.7	26.834	8100960.0
2015-07-30 13:00:00	AMZN	Stock	26.8205	26.96	26.7681	26.855	8977440.0
2015-07-30 14:00:00	AMZN	Stock	26.8536	26.907	26.802	26.8999	5701440.0
2015-07-30 15:00:00	AMZN	Stock	26.895	26.946	26.834	26.8375	11147000.0
2015-07-30 16:00:00	AMZN	Stock	26.838	26.8825	26.838	26.875	261080.0
2015-07-30 17:00:00	AMZN	Stock	26.8	26.847	26.8	26.835	12920.0

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

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