PREVIEW / stock_1hour / 2015-11-16

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-11-16.parquet
  size:    1.0 MB
  rows:    48,227
  symbols: 3,397

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-11-16 04:00:00	AAPL	Stock	27.97	28.1375	27.97	28.0925	112388.0
2015-11-16 05:00:00	AAPL	Stock	28.0475	28.1475	28.0475	28.12	44240.0
2015-11-16 06:00:00	AAPL	Stock	28.11	28.11	28.0	28.05	60796.0
2015-11-16 07:00:00	AAPL	Stock	28.0275	28.085	27.9625	27.965	97928.0
2015-11-16 08:00:00	AAPL	Stock	27.965	28.05	27.4975	27.725	1726016.0
2015-11-16 09:00:00	AAPL	Stock	27.7175	28.285	27.695	28.2625	27498060.0
2015-11-16 10:00:00	AAPL	Stock	28.26	28.3925	28.18	28.205	24855880.0
2015-11-16 11:00:00	AAPL	Stock	28.205	28.2525	28.11	28.215	16473404.0
2015-11-16 12:00:00	AAPL	Stock	28.22	28.4475	28.21	28.3425	15705084.0
2015-11-16 13:00:00	AAPL	Stock	28.345	28.4775	28.2992	28.465	11276112.0
2015-11-16 14:00:00	AAPL	Stock	28.465	28.5575	28.4418	28.475	13734104.0
2015-11-16 15:00:00	AAPL	Stock	28.474	28.56	28.4725	28.545	20232836.0
2015-11-16 16:00:00	AAPL	Stock	28.5438	28.5475	28.1625	28.52	10011084.0
2015-11-16 17:00:00	AAPL	Stock	28.52	28.535	28.51	28.5125	61420.0
2015-11-16 18:00:00	AAPL	Stock	28.5125	28.5438	28.4625	28.5075	329136.0
2015-11-16 19:00:00	AAPL	Stock	28.51	28.5125	28.4825	28.5125	50596.0
2015-11-16 04:00:00	MSFT	Stock	52.78	52.94	52.78	52.87	4136.0
2015-11-16 06:00:00	MSFT	Stock	52.93	52.93	52.93	52.93	500.0
2015-11-16 07:00:00	MSFT	Stock	52.86	52.94	52.82	52.82	9818.0
2015-11-16 08:00:00	MSFT	Stock	52.9	53.05	52.8	52.8	21477.0
2015-11-16 09:00:00	MSFT	Stock	52.79	53.46	52.71	53.074	3824883.0
2015-11-16 10:00:00	MSFT	Stock	53.07	53.31	52.895	53.035	3682646.0
2015-11-16 11:00:00	MSFT	Stock	53.03	53.45	53.0	53.43	2979622.0
2015-11-16 12:00:00	MSFT	Stock	53.44	53.64	53.36	53.44	2520904.0
2015-11-16 13:00:00	MSFT	Stock	53.43	53.8	53.36	53.79	3080639.0
2015-11-16 14:00:00	MSFT	Stock	53.79	53.875	53.67	53.755	3265808.0
2015-11-16 15:00:00	MSFT	Stock	53.755	53.89	53.66	53.76	6556201.0
2015-11-16 16:00:00	MSFT	Stock	53.765	53.82	53.75	53.76	3694392.0
2015-11-16 17:00:00	MSFT	Stock	53.71	53.865	53.71	53.865	182300.0
2015-11-16 18:00:00	MSFT	Stock	53.75	53.75	53.75	53.75	600.0
2015-11-16 19:00:00	MSFT	Stock	53.75	53.77	53.75	53.77	5850.0
2015-11-16 07:00:00	NVDA	Stock	0.7523	0.7523	0.7523	0.7523	33000.0
2015-11-16 08:00:00	NVDA	Stock	0.7525	0.7532	0.7525	0.7525	107800.0
2015-11-16 09:00:00	NVDA	Stock	0.7532	0.7593	0.7513	0.7545	36443640.0
2015-11-16 10:00:00	NVDA	Stock	0.7543	0.7558	0.7488	0.7528	36619400.0
2015-11-16 11:00:00	NVDA	Stock	0.7526	0.7568	0.7518	0.7532	35188680.0
2015-11-16 12:00:00	NVDA	Stock	0.7532	0.7575	0.753	0.755	31988480.0
2015-11-16 13:00:00	NVDA	Stock	0.7553	0.7563	0.7518	0.7532	28691720.0
2015-11-16 14:00:00	NVDA	Stock	0.7532	0.758	0.7525	0.757	80326520.0
2015-11-16 15:00:00	NVDA	Stock	0.757	0.7605	0.7565	0.76	64618960.0
2015-11-16 16:00:00	NVDA	Stock	0.76	0.76	0.76	0.76	15034360.0
2015-11-16 18:00:00	NVDA	Stock	0.76	0.76	0.76	0.76	44000.0
2015-11-16 19:00:00	NVDA	Stock	0.76	0.7622	0.76	0.7622	20000.0
2015-11-16 04:00:00	AMZN	Stock	32.117	32.117	32.117	32.117	6000.0
2015-11-16 05:00:00	AMZN	Stock	32.2415	32.242	32.1625	32.1625	24400.0
2015-11-16 06:00:00	AMZN	Stock	32.165	32.21	32.15	32.2	37020.0
2015-11-16 07:00:00	AMZN	Stock	32.2125	32.222	32.176	32.176	50260.0
2015-11-16 08:00:00	AMZN	Stock	32.176	32.225	32.0	32.0	333020.0
2015-11-16 09:00:00	AMZN	Stock	32.0	32.05	31.2852	31.4	29298640.0
2015-11-16 10:00:00	AMZN	Stock	31.3875	31.5685	31.1145	31.2955	34660360.0

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

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