PREVIEW / stock_1hour / 2015-08-21

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-08-21.parquet
  size:    1.1 MB
  rows:    49,634
  symbols: 3,475

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-08-21 04:00:00	AAPL	Stock	28.0	28.0	27.8375	27.9125	162276.0
2015-08-21 05:00:00	AAPL	Stock	27.935	28.015	27.9125	27.93	61860.0
2015-08-21 06:00:00	AAPL	Stock	27.9725	27.9725	27.8125	27.85	96192.0
2015-08-21 07:00:00	AAPL	Stock	27.85	27.875	27.8125	27.85	363040.0
2015-08-21 08:00:00	AAPL	Stock	27.8375	27.895	27.675	27.7125	1839508.0
2015-08-21 09:00:00	AAPL	Stock	27.71	27.975	27.5275	27.8725	53254792.0
2015-08-21 10:00:00	AAPL	Stock	27.87	27.945	27.0275	27.2725	81681344.0
2015-08-21 11:00:00	AAPL	Stock	27.2725	27.2875	26.9375	27.1745	72594956.0
2015-08-21 12:00:00	AAPL	Stock	27.1725	27.2175	26.9125	26.975	48468552.0
2015-08-21 13:00:00	AAPL	Stock	26.975	27.145	26.9275	27.1075	37949964.0
2015-08-21 14:00:00	AAPL	Stock	27.11	27.2025	26.76	26.855	42178292.0
2015-08-21 15:00:00	AAPL	Stock	26.8525	26.9	26.4112	26.4425	112818972.0
2015-08-21 16:00:00	AAPL	Stock	26.4425	27.2125	26.4375	26.55	24131816.0
2015-08-21 17:00:00	AAPL	Stock	26.5625	26.6125	26.44	26.5242	3332596.0
2015-08-21 18:00:00	AAPL	Stock	26.515	26.55	26.495	26.5125	253376.0
2015-08-21 19:00:00	AAPL	Stock	26.51	26.5175	26.4375	26.475	326776.0
2015-08-21 04:00:00	MSFT	Stock	45.5	45.5	45.5	45.5	100.0
2015-08-21 05:00:00	MSFT	Stock	45.57	45.58	45.57	45.58	200.0
2015-08-21 06:00:00	MSFT	Stock	45.35	45.35	45.28	45.28	5504.0
2015-08-21 07:00:00	MSFT	Stock	45.37	45.4	45.37	45.4	3400.0
2015-08-21 08:00:00	MSFT	Stock	45.47	45.57	45.2	45.33	14570.0
2015-08-21 09:00:00	MSFT	Stock	45.35	45.44	44.92	45.385	8147730.0
2015-08-21 10:00:00	MSFT	Stock	45.38	45.48	44.88	44.92	6393790.0
2015-08-21 11:00:00	MSFT	Stock	44.91	44.935	44.35	44.4	8434856.0
2015-08-21 12:00:00	MSFT	Stock	44.39	44.51	44.02	44.04	5745119.0
2015-08-21 13:00:00	MSFT	Stock	44.04	44.17	43.87	44.04	6149109.0
2015-08-21 14:00:00	MSFT	Stock	44.035	44.15	43.7	43.84	6714586.0
2015-08-21 15:00:00	MSFT	Stock	43.845	43.902	43.07	43.08	17716482.0
2015-08-21 16:00:00	MSFT	Stock	43.07	43.4	43.06	43.37	7326577.0
2015-08-21 17:00:00	MSFT	Stock	43.37	43.44	43.34	43.37	13300.0
2015-08-21 18:00:00	MSFT	Stock	43.43	43.44	43.07	43.36	369451.0
2015-08-21 19:00:00	MSFT	Stock	43.41	43.44	43.363	43.42	4883.0
2015-08-21 08:00:00	NVDA	Stock	0.55	0.553	0.5475	0.5475	149200.0
2015-08-21 09:00:00	NVDA	Stock	0.554	0.5592	0.5488	0.5562	45989600.0
2015-08-21 10:00:00	NVDA	Stock	0.556	0.556	0.5474	0.5482	56854680.0
2015-08-21 11:00:00	NVDA	Stock	0.5481	0.5482	0.5418	0.5465	48338160.0
2015-08-21 12:00:00	NVDA	Stock	0.5462	0.55	0.543	0.543	31557160.0
2015-08-21 13:00:00	NVDA	Stock	0.543	0.5472	0.5422	0.547	25922000.0
2015-08-21 14:00:00	NVDA	Stock	0.547	0.5482	0.542	0.5428	32053920.0
2015-08-21 15:00:00	NVDA	Stock	0.5428	0.5432	0.5362	0.537	110943760.0
2015-08-21 16:00:00	NVDA	Stock	0.5385	0.5392	0.5367	0.5378	296680.0
2015-08-21 19:00:00	NVDA	Stock	0.5338	0.5338	0.5325	0.533	91400.0
2015-08-21 04:00:00	AMZN	Stock	25.7665	25.7665	25.583	25.583	10220.0
2015-08-21 05:00:00	AMZN	Stock	25.7485	25.7485	25.7485	25.7485	2000.0
2015-08-21 06:00:00	AMZN	Stock	25.644	25.644	25.5775	25.6	68000.0
2015-08-21 07:00:00	AMZN	Stock	25.6015	25.695	25.6015	25.6825	85340.0
2015-08-21 08:00:00	AMZN	Stock	25.6025	25.6505	25.506	25.55	447680.0
2015-08-21 09:00:00	AMZN	Stock	25.5675	25.5795	25.0565	25.509	21902520.0
2015-08-21 10:00:00	AMZN	Stock	25.504	25.6165	25.2527	25.4	14065640.0
2015-08-21 11:00:00	AMZN	Stock	25.4	25.4296	24.9	25.2045	18654080.0

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

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