PREVIEW / stock_1hour / 2015-11-10

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-11-10.parquet
  size:    1.0 MB
  rows:    48,175
  symbols: 3,398

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-10 04:00:00	AAPL	Stock	30.1125	30.1125	29.9725	29.9725	43824.0
2015-11-10 05:00:00	AAPL	Stock	30.0075	30.0075	29.95	29.95	11472.0
2015-11-10 06:00:00	AAPL	Stock	29.93	29.93	29.8625	29.895	158004.0
2015-11-10 07:00:00	AAPL	Stock	29.91	29.9125	29.4775	29.575	1147392.0
2015-11-10 08:00:00	AAPL	Stock	29.575	30.075	29.3775	29.445	3520328.0
2015-11-10 09:00:00	AAPL	Stock	29.445	29.475	29.14	29.3525	51084872.0
2015-11-10 10:00:00	AAPL	Stock	29.3475	29.485	29.275	29.454	29145904.0
2015-11-10 11:00:00	AAPL	Stock	29.4525	29.5175	29.3525	29.3688	19821936.0
2015-11-10 12:00:00	AAPL	Stock	29.37	29.37	29.195	29.2325	24596820.0
2015-11-10 13:00:00	AAPL	Stock	29.2325	29.2348	29.095	29.0975	21490096.0
2015-11-10 14:00:00	AAPL	Stock	29.0975	29.2	29.0152	29.1875	26180996.0
2015-11-10 15:00:00	AAPL	Stock	29.1875	29.265	29.0825	29.195	34917332.0
2015-11-10 16:00:00	AAPL	Stock	29.1688	29.205	29.0375	29.1675	10429704.0
2015-11-10 17:00:00	AAPL	Stock	29.1725	29.1725	29.08	29.1025	426028.0
2015-11-10 18:00:00	AAPL	Stock	29.1125	29.12	29.09	29.1	135584.0
2015-11-10 19:00:00	AAPL	Stock	29.1075	29.1175	29.085	29.085	101584.0
2015-11-10 06:00:00	MSFT	Stock	54.08	54.1	54.03	54.03	4730.0
2015-11-10 07:00:00	MSFT	Stock	54.03	54.1	54.03	54.1	2200.0
2015-11-10 08:00:00	MSFT	Stock	54.03	54.2	54.03	54.18	40506.0
2015-11-10 09:00:00	MSFT	Stock	54.2	54.2	53.81	54.0	4674850.0
2015-11-10 10:00:00	MSFT	Stock	54.0	54.015	53.44	53.57	4854451.0
2015-11-10 11:00:00	MSFT	Stock	53.58	53.7	53.51	53.515	5151384.0
2015-11-10 12:00:00	MSFT	Stock	53.511	53.56	53.413	53.43	15572335.0
2015-11-10 13:00:00	MSFT	Stock	53.438	53.56	53.27	53.51	6206617.0
2015-11-10 14:00:00	MSFT	Stock	53.505	53.57	53.38	53.499	3685483.0
2015-11-10 15:00:00	MSFT	Stock	53.5	53.56	53.29	53.53	9159554.0
2015-11-10 16:00:00	MSFT	Stock	53.51	53.6	53.459	53.46	2411126.0
2015-11-10 17:00:00	MSFT	Stock	53.5	53.5	53.46	53.46	1400.0
2015-11-10 18:00:00	MSFT	Stock	53.5	53.5	53.5	53.5	5150.0
2015-11-10 19:00:00	MSFT	Stock	53.46	53.46	53.46	53.46	1000.0
2015-11-10 09:00:00	NVDA	Stock	0.7825	0.7825	0.7638	0.7638	63136720.0
2015-11-10 10:00:00	NVDA	Stock	0.764	0.7644	0.7538	0.7595	130145520.0
2015-11-10 11:00:00	NVDA	Stock	0.7595	0.7603	0.754	0.7585	48873160.0
2015-11-10 12:00:00	NVDA	Stock	0.7586	0.7662	0.7579	0.7643	41600560.0
2015-11-10 13:00:00	NVDA	Stock	0.7643	0.7708	0.7628	0.7688	42627160.0
2015-11-10 14:00:00	NVDA	Stock	0.7685	0.7708	0.7665	0.7698	101247200.0
2015-11-10 15:00:00	NVDA	Stock	0.7698	0.7718	0.7665	0.7702	96785600.0
2015-11-10 16:00:00	NVDA	Stock	0.7702	0.7708	0.7688	0.77	1416800.0
2015-11-10 17:00:00	NVDA	Stock	0.77	0.77	0.77	0.77	40000.0
2015-11-10 18:00:00	NVDA	Stock	0.7665	0.7665	0.7665	0.7665	4000.0
2015-11-10 04:00:00	AMZN	Stock	32.7	32.7	32.7	32.7	8000.0
2015-11-10 06:00:00	AMZN	Stock	32.613	32.613	32.613	32.613	4000.0
2015-11-10 07:00:00	AMZN	Stock	32.6615	32.6695	32.66	32.6695	30760.0
2015-11-10 08:00:00	AMZN	Stock	32.745	32.745	32.6245	32.6245	50740.0
2015-11-10 09:00:00	AMZN	Stock	32.6335	32.6885	32.3631	32.6685	9769040.0
2015-11-10 10:00:00	AMZN	Stock	32.656	32.8647	32.5	32.8549	11689880.0
2015-11-10 11:00:00	AMZN	Stock	32.849	32.9445	32.7716	32.856	9015240.0
2015-11-10 12:00:00	AMZN	Stock	32.8515	32.936	32.782	32.854	6069540.0
2015-11-10 13:00:00	AMZN	Stock	32.844	32.905	32.7302	32.854	6322660.0
2015-11-10 14:00:00	AMZN	Stock	32.867	32.9795	32.7759	32.951	5719360.0

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

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