PREVIEW / stock_1hour / 2015-04-09

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-04-09.parquet
  size:    1.0 MB
  rows:    48,003
  symbols: 3,496

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-04-09 04:00:00	AAPL	Stock	31.4125	31.4125	31.355	31.355	41784.0
2015-04-09 05:00:00	AAPL	Stock	31.3825	31.41	31.38	31.38	1600.0
2015-04-09 06:00:00	AAPL	Stock	31.4325	31.44	31.4	31.44	22632.0
2015-04-09 07:00:00	AAPL	Stock	31.45	31.5525	31.45	31.5275	94868.0
2015-04-09 08:00:00	AAPL	Stock	31.5375	31.545	31.43	31.5075	496232.0
2015-04-09 09:00:00	AAPL	Stock	31.5125	31.57	31.2675	31.3488	20048632.0
2015-04-09 10:00:00	AAPL	Stock	31.3525	31.4175	31.2375	31.3175	20636616.0
2015-04-09 11:00:00	AAPL	Stock	31.3175	31.33	31.165	31.32	16676484.0
2015-04-09 12:00:00	AAPL	Stock	31.3225	31.4175	31.2992	31.3612	9313768.0
2015-04-09 13:00:00	AAPL	Stock	31.3625	31.3775	31.285	31.322	7537036.0
2015-04-09 14:00:00	AAPL	Stock	31.321	31.475	31.3	31.475	9261156.0
2015-04-09 15:00:00	AAPL	Stock	31.4725	31.645	31.4525	31.64	28802588.0
2015-04-09 16:00:00	AAPL	Stock	31.64	31.7125	31.6125	31.7	7527100.0
2015-04-09 17:00:00	AAPL	Stock	31.71	31.71	31.675	31.68	229328.0
2015-04-09 18:00:00	AAPL	Stock	31.68	31.6875	31.6625	31.6725	47572.0
2015-04-09 19:00:00	AAPL	Stock	31.6675	31.675	31.65	31.675	162432.0
2015-04-09 04:00:00	MSFT	Stock	41.45	41.45	41.45	41.45	200.0
2015-04-09 07:00:00	MSFT	Stock	41.38	41.38	41.38	41.38	400.0
2015-04-09 08:00:00	MSFT	Stock	41.4	41.4	41.3	41.38	3575.0
2015-04-09 09:00:00	MSFT	Stock	41.25	41.6	41.08	41.45	2835959.0
2015-04-09 10:00:00	MSFT	Stock	41.46	41.54	41.39	41.461	3967556.0
2015-04-09 11:00:00	MSFT	Stock	41.46	41.52	41.39	41.5	2690052.0
2015-04-09 12:00:00	MSFT	Stock	41.5	41.62	41.475	41.541	2356097.0
2015-04-09 13:00:00	MSFT	Stock	41.55	41.59	41.48	41.485	2161310.0
2015-04-09 14:00:00	MSFT	Stock	41.485	41.51	41.42	41.45	2777320.0
2015-04-09 15:00:00	MSFT	Stock	41.456	41.55	41.415	41.48	5754890.0
2015-04-09 16:00:00	MSFT	Stock	41.48	41.48	41.46	41.48	2015583.0
2015-04-09 17:00:00	MSFT	Stock	41.48	41.48	41.1	41.35	3984.0
2015-04-09 18:00:00	MSFT	Stock	41.38	41.38	41.38	41.38	102.0
2015-04-09 19:00:00	MSFT	Stock	41.4	41.44	41.36	41.36	750.0
2015-04-09 06:00:00	NVDA	Stock	0.5462	0.5462	0.5462	0.5462	4000.0
2015-04-09 09:00:00	NVDA	Stock	0.5505	0.5525	0.546	0.5508	28335200.0
2015-04-09 10:00:00	NVDA	Stock	0.5508	0.558	0.5495	0.5572	55819120.0
2015-04-09 11:00:00	NVDA	Stock	0.557	0.5585	0.5562	0.5585	38068840.0
2015-04-09 12:00:00	NVDA	Stock	0.5585	0.562	0.5581	0.5612	35431720.0
2015-04-09 13:00:00	NVDA	Stock	0.5615	0.5625	0.5595	0.5622	33995800.0
2015-04-09 14:00:00	NVDA	Stock	0.562	0.5642	0.5615	0.564	60675360.0
2015-04-09 15:00:00	NVDA	Stock	0.5638	0.565	0.5628	0.563	88450520.0
2015-04-09 16:00:00	NVDA	Stock	0.5631	0.5638	0.563	0.5638	14954640.0
2015-04-09 17:00:00	NVDA	Stock	0.5642	0.5642	0.5642	0.5642	4000.0
2015-04-09 18:00:00	NVDA	Stock	0.5642	0.5642	0.5642	0.5642	18000.0
2015-04-09 08:00:00	AMZN	Stock	19.052	19.052	19.0	19.042	75120.0
2015-04-09 09:00:00	AMZN	Stock	19.036	19.2	19.0213	19.1445	8867280.0
2015-04-09 10:00:00	AMZN	Stock	19.1495	19.221	18.95	18.994	9441000.0
2015-04-09 11:00:00	AMZN	Stock	18.9928	19.082	18.9398	19.05	5820840.0
2015-04-09 12:00:00	AMZN	Stock	19.054	19.1485	19.0445	19.11	3822740.0
2015-04-09 13:00:00	AMZN	Stock	19.119	19.119	19.055	19.0995	2431520.0
2015-04-09 14:00:00	AMZN	Stock	19.1005	19.1155	19.063	19.0985	2757520.0
2015-04-09 15:00:00	AMZN	Stock	19.1	19.1915	19.0872	19.1775	8068400.0
2015-04-09 16:00:00	AMZN	Stock	19.177	19.183	19.167	19.167	544800.0

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

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