PREVIEW / stock_1hour / 2016-08-10

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-08-10.parquet
  size:    1.0 MB
  rows:    48,555
  symbols: 3,266

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-08-10 04:00:00	AAPL	Stock	27.1675	27.1925	27.1625	27.1675	5816.0
2016-08-10 05:00:00	AAPL	Stock	27.1625	27.185	27.1625	27.1725	4188.0
2016-08-10 06:00:00	AAPL	Stock	27.1725	27.1725	27.1325	27.1325	6036.0
2016-08-10 07:00:00	AAPL	Stock	27.15	27.2125	27.15	27.2	28104.0
2016-08-10 08:00:00	AAPL	Stock	27.21	27.225	27.1325	27.205	170580.0
2016-08-10 09:00:00	AAPL	Stock	27.2075	27.2325	27.1	27.1025	12802628.0
2016-08-10 10:00:00	AAPL	Stock	27.1025	27.14	27.0625	27.075	15584696.0
2016-08-10 11:00:00	AAPL	Stock	27.0755	27.0975	26.94	26.99	15044300.0
2016-08-10 12:00:00	AAPL	Stock	26.99	27.02	26.9675	27.0	8388420.0
2016-08-10 13:00:00	AAPL	Stock	27.0018	27.06	26.99	27.0275	7186148.0
2016-08-10 14:00:00	AAPL	Stock	27.0275	27.04	26.9525	26.9538	9357952.0
2016-08-10 15:00:00	AAPL	Stock	26.9525	27.03	26.9475	27.0	16139848.0
2016-08-10 16:00:00	AAPL	Stock	27.0	27.0125	26.9875	27.0	3460400.0
2016-08-10 17:00:00	AAPL	Stock	27.0	27.0	26.9875	26.9975	199792.0
2016-08-10 18:00:00	AAPL	Stock	26.9975	26.9975	26.9625	26.9675	32036.0
2016-08-10 19:00:00	AAPL	Stock	26.9775	26.985	26.9675	26.97	12860.0
2016-08-10 05:00:00	MSFT	Stock	58.23	58.23	58.23	58.23	200.0
2016-08-10 07:00:00	MSFT	Stock	58.19	58.22	58.19	58.22	1375.0
2016-08-10 08:00:00	MSFT	Stock	58.23	58.35	58.21	58.35	2890.0
2016-08-10 09:00:00	MSFT	Stock	58.23	58.26	57.82	58.045	2505572.0
2016-08-10 10:00:00	MSFT	Stock	58.05	58.32	58.045	58.165	1488259.0
2016-08-10 11:00:00	MSFT	Stock	58.17	58.24	57.88	57.93	2137218.0
2016-08-10 12:00:00	MSFT	Stock	57.92	58.04	57.865	58.015	1464360.0
2016-08-10 13:00:00	MSFT	Stock	58.02	58.04	57.89	57.97	1241775.0
2016-08-10 14:00:00	MSFT	Stock	57.97	58.02	57.83	57.876	1726790.0
2016-08-10 15:00:00	MSFT	Stock	57.88	58.03	57.834	58.02	3301381.0
2016-08-10 16:00:00	MSFT	Stock	58.02	58.03	58.01	58.03	922265.0
2016-08-10 17:00:00	MSFT	Stock	58.04	58.04	58.04	58.04	225.0
2016-08-10 19:00:00	MSFT	Stock	58.0	58.02	58.0	58.02	2295.0
2016-08-10 06:00:00	NVDA	Stock	1.48	1.48	1.473	1.473	24960.0
2016-08-10 07:00:00	NVDA	Stock	1.485	1.485	1.4845	1.4848	92000.0
2016-08-10 08:00:00	NVDA	Stock	1.4875	1.4875	1.4775	1.481	421880.0
2016-08-10 09:00:00	NVDA	Stock	1.4808	1.4875	1.464	1.472	56614800.0
2016-08-10 10:00:00	NVDA	Stock	1.472	1.4725	1.4613	1.4633	55904200.0
2016-08-10 11:00:00	NVDA	Stock	1.4634	1.4698	1.4581	1.4672	35741840.0
2016-08-10 12:00:00	NVDA	Stock	1.467	1.4702	1.4662	1.4693	21716560.0
2016-08-10 13:00:00	NVDA	Stock	1.4693	1.4715	1.4675	1.4702	39077240.0
2016-08-10 14:00:00	NVDA	Stock	1.4705	1.4705	1.4626	1.4633	26421720.0
2016-08-10 15:00:00	NVDA	Stock	1.4633	1.4685	1.4613	1.4628	91092560.0
2016-08-10 16:00:00	NVDA	Stock	1.4628	1.4695	1.4625	1.4695	20485000.0
2016-08-10 17:00:00	NVDA	Stock	1.4648	1.4688	1.4602	1.4688	122480.0
2016-08-10 18:00:00	NVDA	Stock	1.4662	1.4665	1.4628	1.4665	151800.0
2016-08-10 19:00:00	NVDA	Stock	1.4675	1.4675	1.465	1.4672	294080.0
2016-08-10 04:00:00	AMZN	Stock	38.5195	38.5195	38.5195	38.5195	4460.0
2016-08-10 05:00:00	AMZN	Stock	38.528	38.528	38.497	38.497	4000.0
2016-08-10 06:00:00	AMZN	Stock	38.4915	38.4915	38.4915	38.4915	2000.0
2016-08-10 07:00:00	AMZN	Stock	38.485	38.5475	38.483	38.5475	42700.0
2016-08-10 08:00:00	AMZN	Stock	38.5	38.5	38.4725	38.4725	20620.0
2016-08-10 09:00:00	AMZN	Stock	38.49	38.605	38.432	38.506	4649360.0
2016-08-10 10:00:00	AMZN	Stock	38.5355	38.5875	38.4145	38.4738	5321120.0

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

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