PREVIEW / stock_1hour / 2015-12-14

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-12-14.parquet
  size:    1.1 MB
  rows:    50,036
  symbols: 3,412

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-12-14 04:00:00	AAPL	Stock	28.4375	28.4975	28.385	28.4775	27000.0
2015-12-14 05:00:00	AAPL	Stock	28.46	28.4625	28.39	28.4625	32480.0
2015-12-14 06:00:00	AAPL	Stock	28.45	28.45	28.1875	28.2125	283944.0
2015-12-14 07:00:00	AAPL	Stock	28.19	28.225	27.725	27.8375	1354700.0
2015-12-14 08:00:00	AAPL	Stock	27.775	28.1875	27.7475	27.965	2286376.0
2015-12-14 09:00:00	AAPL	Stock	27.965	28.045	27.6525	27.7525	38769036.0
2015-12-14 10:00:00	AAPL	Stock	27.75	27.95	27.6825	27.7875	41590584.0
2015-12-14 11:00:00	AAPL	Stock	27.785	27.795	27.4475	27.6382	35123136.0
2015-12-14 12:00:00	AAPL	Stock	27.6432	27.865	27.585	27.825	26879412.0
2015-12-14 13:00:00	AAPL	Stock	27.8225	28.1625	27.815	28.115	25516680.0
2015-12-14 14:00:00	AAPL	Stock	28.1175	28.17	27.9175	28.0588	22335668.0
2015-12-14 15:00:00	AAPL	Stock	28.06	28.125	27.9025	28.1175	32768244.0
2015-12-14 16:00:00	AAPL	Stock	28.12	28.135	27.6862	28.1325	9979192.0
2015-12-14 17:00:00	AAPL	Stock	28.125	28.125	27.9625	28.0	1000556.0
2015-12-14 18:00:00	AAPL	Stock	28.0	28.0825	28.0	28.0425	86616.0
2015-12-14 19:00:00	AAPL	Stock	28.075	28.0875	28.0525	28.075	70584.0
2015-12-14 04:00:00	MSFT	Stock	54.39	54.39	54.38	54.39	1600.0
2015-12-14 06:00:00	MSFT	Stock	53.95	54.17	53.95	54.17	7529.0
2015-12-14 07:00:00	MSFT	Stock	54.16	54.17	53.87	54.05	32781.0
2015-12-14 08:00:00	MSFT	Stock	54.0	54.36	53.87	54.25	45851.0
2015-12-14 09:00:00	MSFT	Stock	54.25	54.37	53.73	53.76	5126259.0
2015-12-14 10:00:00	MSFT	Stock	53.77	54.43	53.68	54.065	7934521.0
2015-12-14 11:00:00	MSFT	Stock	54.07	54.31	53.88	54.25	4622998.0
2015-12-14 12:00:00	MSFT	Stock	54.25	54.59	54.05	54.54	3980365.0
2015-12-14 13:00:00	MSFT	Stock	54.54	54.695	54.41	54.63	3323263.0
2015-12-14 14:00:00	MSFT	Stock	54.63	54.95	54.48	54.89	3866923.0
2015-12-14 15:00:00	MSFT	Stock	54.89	55.21	54.61	55.16	9232856.0
2015-12-14 16:00:00	MSFT	Stock	55.14	55.17	55.03	55.05	4578255.0
2015-12-14 17:00:00	MSFT	Stock	55.05	55.05	55.05	55.05	518.0
2015-12-14 18:00:00	MSFT	Stock	55.09	55.2	55.09	55.15	4018.0
2015-12-14 19:00:00	MSFT	Stock	55.16	55.16	55.16	55.16	200.0
2015-12-14 04:00:00	NVDA	Stock	0.8138	0.8138	0.8138	0.8138	4000.0
2015-12-14 08:00:00	NVDA	Stock	0.8033	0.8033	0.8033	0.8033	8000.0
2015-12-14 09:00:00	NVDA	Stock	0.8128	0.8188	0.8065	0.8135	20406400.0
2015-12-14 10:00:00	NVDA	Stock	0.8135	0.8188	0.8068	0.8084	39754480.0
2015-12-14 11:00:00	NVDA	Stock	0.8082	0.81	0.8045	0.81	38281280.0
2015-12-14 12:00:00	NVDA	Stock	0.81	0.8142	0.8075	0.8137	19533120.0
2015-12-14 13:00:00	NVDA	Stock	0.8138	0.8148	0.8072	0.8105	17274880.0
2015-12-14 14:00:00	NVDA	Stock	0.8105	0.8135	0.8085	0.8128	25373920.0
2015-12-14 15:00:00	NVDA	Stock	0.8128	0.8145	0.808	0.8144	66383920.0
2015-12-14 16:00:00	NVDA	Stock	0.8142	0.8338	0.8118	0.8118	27797080.0
2015-12-14 18:00:00	NVDA	Stock	0.8155	0.8155	0.8155	0.8155	7040.0
2015-12-14 04:00:00	AMZN	Stock	32.052	32.052	32.051	32.051	16120.0
2015-12-14 06:00:00	AMZN	Stock	32.1	32.1	32.081	32.081	8400.0
2015-12-14 07:00:00	AMZN	Stock	31.9695	31.9695	31.8	31.93	68400.0
2015-12-14 08:00:00	AMZN	Stock	31.9015	32.1105	31.7635	32.05	525320.0
2015-12-14 09:00:00	AMZN	Stock	32.076	32.434	31.981	32.2005	9683280.0
2015-12-14 10:00:00	AMZN	Stock	32.2195	32.5164	32.1645	32.3705	10592740.0
2015-12-14 11:00:00	AMZN	Stock	32.3685	32.3915	31.7635	32.1537	8091180.0
2015-12-14 12:00:00	AMZN	Stock	32.1405	32.4621	32.108	32.4488	8516280.0

> showing 50 of 50,036 rows — these rows as CSV

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