PREVIEW / stock_1hour / 2014-10-23

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-10-23.parquet
  size:    1.0 MB
  rows:    48,789
  symbols: 3,559

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
2014-10-23 04:00:00	AAPL	Stock	25.7825	25.9225	25.7825	25.895	20676.0
2014-10-23 05:00:00	AAPL	Stock	25.92	25.93	25.885	25.9025	24192.0
2014-10-23 06:00:00	AAPL	Stock	25.905	25.9125	25.885	25.8925	48604.0
2014-10-23 07:00:00	AAPL	Stock	25.87	26.0	25.8625	25.995	476540.0
2014-10-23 08:00:00	AAPL	Stock	25.9875	26.0125	25.675	25.9975	1668932.0
2014-10-23 09:00:00	AAPL	Stock	26.0	26.055	25.9075	26.01	28952712.0
2014-10-23 10:00:00	AAPL	Stock	26.01	26.2628	26.0	26.2425	73090860.0
2014-10-23 11:00:00	AAPL	Stock	26.2425	26.25	26.15	26.2312	35158548.0
2014-10-23 12:00:00	AAPL	Stock	26.23	26.25	26.205	26.2292	18663820.0
2014-10-23 13:00:00	AAPL	Stock	26.229	26.25	26.205	26.2475	18221752.0
2014-10-23 14:00:00	AAPL	Stock	26.2462	26.2575	26.145	26.195	26495384.0
2014-10-23 15:00:00	AAPL	Stock	26.1965	26.2325	26.14	26.2075	57458012.0
2014-10-23 16:00:00	AAPL	Stock	26.2075	26.24	26.1585	26.23	3186444.0
2014-10-23 17:00:00	AAPL	Stock	26.235	26.245	26.2075	26.2375	1111312.0
2014-10-23 18:00:00	AAPL	Stock	26.2325	26.24	26.2075	26.225	174356.0
2014-10-23 19:00:00	AAPL	Stock	26.225	26.2475	26.225	26.2475	129336.0
2014-10-23 08:00:00	MSFT	Stock	44.73	44.74	44.71	44.73	22442.0
2014-10-23 09:00:00	MSFT	Stock	44.73	44.79	44.53	44.674	2766170.0
2014-10-23 10:00:00	MSFT	Stock	44.68	44.88	44.66	44.76	4992551.0
2014-10-23 11:00:00	MSFT	Stock	44.765	44.89	44.62	44.69	4443151.0
2014-10-23 12:00:00	MSFT	Stock	44.69	44.94	44.68	44.885	3049134.0
2014-10-23 13:00:00	MSFT	Stock	44.88	45.28	44.85	45.21	3978316.0
2014-10-23 14:00:00	MSFT	Stock	45.21	45.445	45.04	45.135	5695844.0
2014-10-23 15:00:00	MSFT	Stock	45.14	45.15	44.89	44.99	10187908.0
2014-10-23 16:00:00	MSFT	Stock	45.02	47.05	44.751	46.75	4968195.0
2014-10-23 17:00:00	MSFT	Stock	46.77	47.08	45.02	45.75	1149050.0
2014-10-23 18:00:00	MSFT	Stock	45.84	46.74	45.02	46.25	329403.0
2014-10-23 19:00:00	MSFT	Stock	46.23	46.47	46.11	46.42	60955.0
2014-10-23 09:00:00	NVDA	Stock	0.454	0.4552	0.4518	0.4536	28118520.0
2014-10-23 10:00:00	NVDA	Stock	0.4536	0.4605	0.4536	0.4565	29476880.0
2014-10-23 11:00:00	NVDA	Stock	0.4568	0.4575	0.455	0.4558	21658640.0
2014-10-23 12:00:00	NVDA	Stock	0.4558	0.4578	0.4558	0.4566	15053240.0
2014-10-23 13:00:00	NVDA	Stock	0.4565	0.4572	0.4558	0.4564	14153640.0
2014-10-23 14:00:00	NVDA	Stock	0.4564	0.4595	0.4542	0.456	25055680.0
2014-10-23 15:00:00	NVDA	Stock	0.4558	0.459	0.4544	0.4571	66548600.0
2014-10-23 16:00:00	NVDA	Stock	0.4571	0.46	0.4563	0.457	9610000.0
2014-10-23 17:00:00	NVDA	Stock	0.4571	0.4571	0.4571	0.4571	798800.0
2014-10-23 19:00:00	NVDA	Stock	0.4605	0.4608	0.4605	0.4608	225000.0
2014-10-23 04:00:00	AMZN	Stock	15.6925	15.6925	15.6925	15.6925	2000.0
2014-10-23 06:00:00	AMZN	Stock	15.757	15.757	15.745	15.745	11200.0
2014-10-23 07:00:00	AMZN	Stock	15.75	15.7595	15.7155	15.7215	62600.0
2014-10-23 08:00:00	AMZN	Stock	15.725	15.7565	15.675	15.6755	524100.0
2014-10-23 09:00:00	AMZN	Stock	15.693	15.7135	15.57	15.6682	9364200.0
2014-10-23 10:00:00	AMZN	Stock	15.675	15.8395	15.6685	15.773	14638500.0
2014-10-23 11:00:00	AMZN	Stock	15.7795	15.794	15.645	15.716	9981120.0
2014-10-23 12:00:00	AMZN	Stock	15.718	15.7545	15.6852	15.7185	5088220.0
2014-10-23 13:00:00	AMZN	Stock	15.7175	15.812	15.7005	15.7715	7984480.0
2014-10-23 14:00:00	AMZN	Stock	15.774	15.84	15.712	15.725	14071960.0
2014-10-23 15:00:00	AMZN	Stock	15.7235	15.749	15.615	15.652	27387100.0
2014-10-23 16:00:00	AMZN	Stock	15.6435	15.7529	13.85	13.998	53247200.0

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

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