PREVIEW / stock_1hour / 2015-06-18

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-06-18.parquet
  size:    1.1 MB
  rows:    49,049
  symbols: 3,520

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-06-18 04:00:00	AAPL	Stock	31.78	31.78	31.75	31.7525	18044.0
2015-06-18 05:00:00	AAPL	Stock	31.735	31.78	31.735	31.78	23792.0
2015-06-18 06:00:00	AAPL	Stock	31.81	31.8425	31.795	31.825	111408.0
2015-06-18 07:00:00	AAPL	Stock	31.8125	31.87	31.8	31.84	92016.0
2015-06-18 08:00:00	AAPL	Stock	31.8375	31.8575	31.805	31.825	355768.0
2015-06-18 09:00:00	AAPL	Stock	31.815	32.0525	31.7725	32.0175	24652936.0
2015-06-18 10:00:00	AAPL	Stock	32.0175	32.0775	32.0025	32.0325	22236272.0
2015-06-18 11:00:00	AAPL	Stock	32.0325	32.075	31.96	31.965	18276524.0
2015-06-18 12:00:00	AAPL	Stock	31.9625	32.04	31.945	31.975	14771252.0
2015-06-18 13:00:00	AAPL	Stock	31.9775	32.0	31.91	31.92	12051932.0
2015-06-18 14:00:00	AAPL	Stock	31.9188	32.0325	31.9162	32.0312	13036784.0
2015-06-18 15:00:00	AAPL	Stock	32.0325	32.045	31.9375	31.96	22535736.0
2015-06-18 16:00:00	AAPL	Stock	31.97	32.0127	31.9425	31.9725	5633880.0
2015-06-18 17:00:00	AAPL	Stock	31.9675	31.98	31.96	31.975	403204.0
2015-06-18 18:00:00	AAPL	Stock	31.9725	31.975	31.96	31.96	58764.0
2015-06-18 19:00:00	AAPL	Stock	31.9575	31.96	31.9275	31.95	33968.0
2015-06-18 04:00:00	MSFT	Stock	45.85	45.85	45.85	45.85	900.0
2015-06-18 05:00:00	MSFT	Stock	45.92	45.92	45.92	45.92	900.0
2015-06-18 06:00:00	MSFT	Stock	45.92	46.05	45.92	45.97	6696.0
2015-06-18 07:00:00	MSFT	Stock	46.02	46.04	45.95	45.97	4550.0
2015-06-18 08:00:00	MSFT	Stock	45.99	46.13	45.99	46.13	9930.0
2015-06-18 09:00:00	MSFT	Stock	46.09	46.5	46.07	46.34	4365612.0
2015-06-18 10:00:00	MSFT	Stock	46.33	46.52	46.18	46.515	5174158.0
2015-06-18 11:00:00	MSFT	Stock	46.52	46.67	46.38	46.63	3925730.0
2015-06-18 12:00:00	MSFT	Stock	46.63	46.8	46.55	46.645	2830281.0
2015-06-18 13:00:00	MSFT	Stock	46.65	46.7	46.55	46.57	2252855.0
2015-06-18 14:00:00	MSFT	Stock	46.57	46.77	46.54	46.735	2954843.0
2015-06-18 15:00:00	MSFT	Stock	46.74	46.77	46.63	46.71	6224992.0
2015-06-18 16:00:00	MSFT	Stock	46.695	46.8	46.5	46.8	3225875.0
2015-06-18 17:00:00	MSFT	Stock	46.8	46.8	46.72	46.75	47140.0
2015-06-18 18:00:00	MSFT	Stock	46.7	46.7	46.65	46.65	723.0
2015-06-18 19:00:00	MSFT	Stock	46.72	46.78	46.72	46.78	2970.0
2015-06-18 08:00:00	NVDA	Stock	0.5395	0.5395	0.5395	0.5395	80000.0
2015-06-18 09:00:00	NVDA	Stock	0.5422	0.5525	0.5422	0.5449	37008320.0
2015-06-18 10:00:00	NVDA	Stock	0.5448	0.5495	0.5425	0.5484	45837120.0
2015-06-18 11:00:00	NVDA	Stock	0.5484	0.5501	0.5482	0.5494	24243920.0
2015-06-18 12:00:00	NVDA	Stock	0.5494	0.552	0.5488	0.5488	24392080.0
2015-06-18 13:00:00	NVDA	Stock	0.5488	0.5498	0.5475	0.5478	19795960.0
2015-06-18 14:00:00	NVDA	Stock	0.5477	0.5498	0.5474	0.5488	16475080.0
2015-06-18 15:00:00	NVDA	Stock	0.549	0.5505	0.548	0.5482	96808400.0
2015-06-18 16:00:00	NVDA	Stock	0.5482	0.5485	0.5482	0.5485	18708080.0
2015-06-18 17:00:00	NVDA	Stock	0.551	0.551	0.551	0.551	4000.0
2015-06-18 18:00:00	NVDA	Stock	0.551	0.551	0.551	0.551	8000.0
2015-06-18 04:00:00	AMZN	Stock	21.353	21.353	21.353	21.353	10000.0
2015-06-18 08:00:00	AMZN	Stock	21.425	21.435	21.425	21.435	4000.0
2015-06-18 09:00:00	AMZN	Stock	21.481	21.7095	21.4702	21.6885	8824900.0
2015-06-18 10:00:00	AMZN	Stock	21.69	21.7925	21.6579	21.769	11384640.0
2015-06-18 11:00:00	AMZN	Stock	21.7735	21.8405	21.737	21.7875	6165140.0
2015-06-18 12:00:00	AMZN	Stock	21.783	21.812	21.74	21.796	5002560.0
2015-06-18 13:00:00	AMZN	Stock	21.7885	21.825	21.749	21.7655	5273980.0

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

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