PREVIEW / stock_1hour / 2014-11-03

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-11-03.parquet
  size:    1.0 MB
  rows:    49,194
  symbols: 3,559

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
2014-11-03 04:00:00	AAPL	Stock	27.0	27.0	26.9375	26.9375	34108.0
2014-11-03 05:00:00	AAPL	Stock	26.975	26.995	26.975	26.9775	12092.0
2014-11-03 06:00:00	AAPL	Stock	26.9875	27.025	26.97	26.975	32240.0
2014-11-03 07:00:00	AAPL	Stock	26.985	26.9925	26.9625	26.9925	128504.0
2014-11-03 08:00:00	AAPL	Stock	26.9925	27.095	26.9625	27.0675	578208.0
2014-11-03 09:00:00	AAPL	Stock	27.0675	27.2675	27.0025	27.26	33512892.0
2014-11-03 10:00:00	AAPL	Stock	27.26	27.435	27.23	27.4298	38910824.0
2014-11-03 11:00:00	AAPL	Stock	27.43	27.475	27.3675	27.4	30379264.0
2014-11-03 12:00:00	AAPL	Stock	27.4002	27.46	27.38	27.435	14001668.0
2014-11-03 13:00:00	AAPL	Stock	27.4375	27.455	27.39	27.3912	12939468.0
2014-11-03 14:00:00	AAPL	Stock	27.3925	27.415	27.2325	27.2662	22801836.0
2014-11-03 15:00:00	AAPL	Stock	27.265	27.3525	27.2525	27.345	24713740.0
2014-11-03 16:00:00	AAPL	Stock	27.35	27.4448	27.326	27.3425	5592424.0
2014-11-03 17:00:00	AAPL	Stock	27.3425	27.3608	27.2498	27.3175	799268.0
2014-11-03 18:00:00	AAPL	Stock	27.32	27.35	27.315	27.32	127500.0
2014-11-03 19:00:00	AAPL	Stock	27.3225	27.35	27.2925	27.3125	239504.0
2014-11-03 08:00:00	MSFT	Stock	46.88	46.95	46.82	46.88	35737.0
2014-11-03 09:00:00	MSFT	Stock	46.88	47.18	46.69	47.165	3147115.0
2014-11-03 10:00:00	MSFT	Stock	47.17	47.28	47.06	47.24	3928886.0
2014-11-03 11:00:00	MSFT	Stock	47.24	47.38	47.16	47.325	2691216.0
2014-11-03 12:00:00	MSFT	Stock	47.32	47.4	47.235	47.364	1691733.0
2014-11-03 13:00:00	MSFT	Stock	47.365	47.45	47.31	47.424	1531411.0
2014-11-03 14:00:00	MSFT	Stock	47.421	47.46	47.34	47.37	2399682.0
2014-11-03 15:00:00	MSFT	Stock	47.36	47.46	47.295	47.43	4275292.0
2014-11-03 16:00:00	MSFT	Stock	47.44	47.45	47.272	47.43	1848990.0
2014-11-03 17:00:00	MSFT	Stock	47.41	47.44	47.113	47.42	230903.0
2014-11-03 18:00:00	MSFT	Stock	47.41	47.44	47.41	47.44	29283.0
2014-11-03 19:00:00	MSFT	Stock	47.41	47.41	47.4	47.4	10735.0
2014-11-03 08:00:00	NVDA	Stock	0.4905	0.497	0.4905	0.497	332800.0
2014-11-03 09:00:00	NVDA	Stock	0.497	0.5013	0.4938	0.5003	53458160.0
2014-11-03 10:00:00	NVDA	Stock	0.5005	0.5015	0.4942	0.4965	70811440.0
2014-11-03 11:00:00	NVDA	Stock	0.4965	0.4982	0.496	0.4964	28900080.0
2014-11-03 12:00:00	NVDA	Stock	0.4964	0.4971	0.4942	0.4968	19541960.0
2014-11-03 13:00:00	NVDA	Stock	0.4968	0.4972	0.4948	0.4955	18935280.0
2014-11-03 14:00:00	NVDA	Stock	0.4956	0.497	0.4942	0.4955	20544680.0
2014-11-03 15:00:00	NVDA	Stock	0.4952	0.4972	0.495	0.497	75047920.0
2014-11-03 16:00:00	NVDA	Stock	0.4968	0.4971	0.4956	0.4968	1334200.0
2014-11-03 17:00:00	NVDA	Stock	0.4968	0.4998	0.4963	0.4998	4908000.0
2014-11-03 18:00:00	NVDA	Stock	0.4972	0.4972	0.4972	0.4972	76000.0
2014-11-03 07:00:00	AMZN	Stock	15.255	15.255	15.244	15.244	28000.0
2014-11-03 08:00:00	AMZN	Stock	15.255	15.255	15.2075	15.2375	22400.0
2014-11-03 09:00:00	AMZN	Stock	15.271	15.3415	15.162	15.228	10736660.0
2014-11-03 10:00:00	AMZN	Stock	15.232	15.361	15.201	15.3545	12135300.0
2014-11-03 11:00:00	AMZN	Stock	15.3545	15.4005	15.3185	15.3752	7436140.0
2014-11-03 12:00:00	AMZN	Stock	15.378	15.392	15.344	15.3635	5071320.0
2014-11-03 13:00:00	AMZN	Stock	15.362	15.3635	15.3045	15.3425	4723620.0
2014-11-03 14:00:00	AMZN	Stock	15.3325	15.3385	15.2625	15.2755	5908180.0
2014-11-03 15:00:00	AMZN	Stock	15.2775	15.3085	15.2595	15.2855	10146400.0
2014-11-03 16:00:00	AMZN	Stock	15.286	15.3673	15.2744	15.286	247120.0
2014-11-03 17:00:00	AMZN	Stock	15.286	15.3096	15.286	15.3096	271920.0

> showing 50 of 49,194 rows — these rows as CSV

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