PREVIEW / stock_1hour / 2015-05-19

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-05-19.parquet
  size:    1.1 MB
  rows:    49,137
  symbols: 3,518

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-05-19 04:00:00	AAPL	Stock	32.675	32.7225	32.6675	32.7125	69896.0
2015-05-19 05:00:00	AAPL	Stock	32.71	32.7225	32.6875	32.705	60724.0
2015-05-19 06:00:00	AAPL	Stock	32.7075	32.725	32.6925	32.705	110168.0
2015-05-19 07:00:00	AAPL	Stock	32.695	32.715	32.6725	32.7	322112.0
2015-05-19 08:00:00	AAPL	Stock	32.7	32.7162	32.5675	32.6	1922456.0
2015-05-19 09:00:00	AAPL	Stock	32.6	32.72	32.4875	32.6	28764476.0
2015-05-19 10:00:00	AAPL	Stock	32.6025	32.63	32.455	32.6	29343692.0
2015-05-19 11:00:00	AAPL	Stock	32.595	32.6175	32.545	32.6	14469564.0
2015-05-19 12:00:00	AAPL	Stock	32.6002	32.61	32.5088	32.5828	14416816.0
2015-05-19 13:00:00	AAPL	Stock	32.5845	32.69	32.5475	32.675	14881684.0
2015-05-19 14:00:00	AAPL	Stock	32.6725	32.6922	32.59	32.595	13736648.0
2015-05-19 15:00:00	AAPL	Stock	32.595	32.6225	32.41	32.5175	29917772.0
2015-05-19 16:00:00	AAPL	Stock	32.5175	32.5552	32.5	32.5225	14917988.0
2015-05-19 17:00:00	AAPL	Stock	32.53	32.53	32.5075	32.525	87360.0
2015-05-19 18:00:00	AAPL	Stock	32.5125	32.52	32.5075	32.52	69448.0
2015-05-19 19:00:00	AAPL	Stock	32.5175	32.525	32.5075	32.525	45912.0
2015-05-19 04:00:00	MSFT	Stock	47.87	47.87	47.85	47.85	3500.0
2015-05-19 06:00:00	MSFT	Stock	47.84	47.85	47.84	47.85	1000.0
2015-05-19 07:00:00	MSFT	Stock	47.81	47.82	47.81	47.82	400.0
2015-05-19 08:00:00	MSFT	Stock	47.83	47.88	47.75	47.75	18148.0
2015-05-19 09:00:00	MSFT	Stock	47.8	47.81	47.39	47.427	3673268.0
2015-05-19 10:00:00	MSFT	Stock	47.43	47.5	47.18	47.19	3548016.0
2015-05-19 11:00:00	MSFT	Stock	47.195	47.46	47.195	47.35	3620548.0
2015-05-19 12:00:00	MSFT	Stock	47.35	47.49	47.29	47.48	1893052.0
2015-05-19 13:00:00	MSFT	Stock	47.485	47.6	47.44	47.505	2120255.0
2015-05-19 14:00:00	MSFT	Stock	47.505	47.54	47.37	47.455	1872881.0
2015-05-19 15:00:00	MSFT	Stock	47.455	47.62	47.35	47.57	5773714.0
2015-05-19 16:00:00	MSFT	Stock	47.58	47.58	47.51	47.51	1959077.0
2015-05-19 17:00:00	MSFT	Stock	47.51	47.51	47.4	47.42	3687.0
2015-05-19 18:00:00	MSFT	Stock	47.5	47.5	47.5	47.5	2000.0
2015-05-19 19:00:00	MSFT	Stock	47.49	47.5	47.49	47.5	400.0
2015-05-19 06:00:00	NVDA	Stock	0.531	0.531	0.531	0.531	12000.0
2015-05-19 07:00:00	NVDA	Stock	0.531	0.531	0.531	0.531	16000.0
2015-05-19 09:00:00	NVDA	Stock	0.53	0.5318	0.5272	0.5304	29693400.0
2015-05-19 10:00:00	NVDA	Stock	0.5305	0.531	0.5255	0.5275	34730640.0
2015-05-19 11:00:00	NVDA	Stock	0.5275	0.5285	0.5265	0.5275	18330360.0
2015-05-19 12:00:00	NVDA	Stock	0.5275	0.5305	0.5275	0.5295	17896840.0
2015-05-19 13:00:00	NVDA	Stock	0.5293	0.5294	0.5282	0.5286	10858240.0
2015-05-19 14:00:00	NVDA	Stock	0.5285	0.5295	0.527	0.5272	29499840.0
2015-05-19 15:00:00	NVDA	Stock	0.5272	0.5272	0.525	0.5259	67976800.0
2015-05-19 16:00:00	NVDA	Stock	0.526	0.526	0.5258	0.5258	3139800.0
2015-05-19 08:00:00	AMZN	Stock	21.31	21.31	21.31	21.31	4000.0
2015-05-19 09:00:00	AMZN	Stock	21.28	21.412	21.2	21.374	7607140.0
2015-05-19 10:00:00	AMZN	Stock	21.367	21.393	21.135	21.1439	7337240.0
2015-05-19 11:00:00	AMZN	Stock	21.1465	21.162	21.0575	21.1155	6993320.0
2015-05-19 12:00:00	AMZN	Stock	21.107	21.1335	21.093	21.1197	2351380.0
2015-05-19 13:00:00	AMZN	Stock	21.127	21.129	21.0695	21.0785	4106040.0
2015-05-19 14:00:00	AMZN	Stock	21.0785	21.1008	21.0315	21.0874	5547900.0
2015-05-19 15:00:00	AMZN	Stock	21.0915	21.112	21.0405	21.0845	7711240.0
2015-05-19 16:00:00	AMZN	Stock	21.0855	21.0855	21.0855	21.0855	1802380.0

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

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