PREVIEW / stock_1hour / 2014-08-04

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-08-04.parquet
  size:    1.0 MB
  rows:    48,750
  symbols: 3,560

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-08-04 04:00:00	AAPL	Stock	24.0	24.1525	24.0	24.1	17176.0
2014-08-04 05:00:00	AAPL	Stock	24.1225	24.165	24.1225	24.165	20368.0
2014-08-04 06:00:00	AAPL	Stock	24.15	24.2	24.15	24.1775	16492.0
2014-08-04 07:00:00	AAPL	Stock	24.1775	24.205	24.1475	24.1625	142436.0
2014-08-04 08:00:00	AAPL	Stock	24.1675	24.21	24.1425	24.175	542624.0
2014-08-04 09:00:00	AAPL	Stock	24.165	24.17	24.0025	24.0725	20214016.0
2014-08-04 10:00:00	AAPL	Stock	24.0725	24.115	23.8025	23.8165	30273060.0
2014-08-04 11:00:00	AAPL	Stock	23.815	23.895	23.7925	23.845	20204584.0
2014-08-04 12:00:00	AAPL	Stock	23.845	23.945	23.805	23.925	14751592.0
2014-08-04 13:00:00	AAPL	Stock	23.925	23.9375	23.87	23.905	11008132.0
2014-08-04 14:00:00	AAPL	Stock	23.9075	23.9675	23.875	23.9625	12895748.0
2014-08-04 15:00:00	AAPL	Stock	23.9625	24.0675	23.895	23.8975	27627464.0
2014-08-04 16:00:00	AAPL	Stock	23.8975	23.988	23.845	23.8875	12365708.0
2014-08-04 17:00:00	AAPL	Stock	23.89	23.9025	23.8775	23.9025	1003644.0
2014-08-04 18:00:00	AAPL	Stock	23.8975	23.8975	23.875	23.885	139496.0
2014-08-04 19:00:00	AAPL	Stock	23.88	23.89	23.875	23.885	85080.0
2014-08-04 04:00:00	MSFT	Stock	42.89	42.89	42.89	42.89	200.0
2014-08-04 05:00:00	MSFT	Stock	42.89	42.89	42.89	42.89	100.0
2014-08-04 07:00:00	MSFT	Stock	43.03	43.05	43.03	43.05	7000.0
2014-08-04 08:00:00	MSFT	Stock	43.07	43.07	43.0	43.01	3280.0
2014-08-04 09:00:00	MSFT	Stock	43.01	43.23	42.81	43.04	4357261.0
2014-08-04 10:00:00	MSFT	Stock	43.05	43.105	42.93	42.95	4998980.0
2014-08-04 11:00:00	MSFT	Stock	42.95	43.2	42.92	43.15	3362465.0
2014-08-04 12:00:00	MSFT	Stock	43.15	43.22	43.1	43.186	2755009.0
2014-08-04 13:00:00	MSFT	Stock	43.185	43.2	43.07	43.16	2026414.0
2014-08-04 14:00:00	MSFT	Stock	43.167	43.36	43.16	43.346	3081189.0
2014-08-04 15:00:00	MSFT	Stock	43.35	43.47	43.284	43.35	7557569.0
2014-08-04 16:00:00	MSFT	Stock	43.37	43.425	43.096	43.13	4535312.0
2014-08-04 17:00:00	MSFT	Stock	43.37	43.39	43.35	43.39	299282.0
2014-08-04 18:00:00	MSFT	Stock	43.38	43.39	43.33	43.33	28094.0
2014-08-04 19:00:00	MSFT	Stock	43.39	43.4	43.37	43.37	4173.0
2014-08-04 09:00:00	NVDA	Stock	0.442	0.4455	0.44	0.443	21316840.0
2014-08-04 10:00:00	NVDA	Stock	0.443	0.4432	0.439	0.4394	37036520.0
2014-08-04 11:00:00	NVDA	Stock	0.4394	0.443	0.439	0.4422	22354520.0
2014-08-04 12:00:00	NVDA	Stock	0.442	0.4428	0.4414	0.4416	11574880.0
2014-08-04 13:00:00	NVDA	Stock	0.4416	0.442	0.4402	0.4402	13437320.0
2014-08-04 14:00:00	NVDA	Stock	0.4402	0.443	0.4392	0.4425	24431800.0
2014-08-04 15:00:00	NVDA	Stock	0.4425	0.4435	0.4408	0.441	72356800.0
2014-08-04 16:00:00	NVDA	Stock	0.4412	0.4418	0.44	0.44	12886400.0
2014-08-04 17:00:00	NVDA	Stock	0.4412	0.4412	0.4412	0.4412	753600.0
2014-08-04 18:00:00	NVDA	Stock	0.44	0.44	0.44	0.44	16000.0
2014-08-04 19:00:00	NVDA	Stock	0.4395	0.4395	0.4395	0.4395	4000.0
2014-08-04 07:00:00	AMZN	Stock	15.4845	15.4845	15.4845	15.4845	2380.0
2014-08-04 08:00:00	AMZN	Stock	15.44	15.4655	15.4265	15.442	103500.0
2014-08-04 09:00:00	AMZN	Stock	15.438	15.606	15.4165	15.5715	10944460.0
2014-08-04 10:00:00	AMZN	Stock	15.5695	15.669	15.5405	15.625	16932020.0
2014-08-04 11:00:00	AMZN	Stock	15.625	15.7495	15.6105	15.749	12678840.0
2014-08-04 12:00:00	AMZN	Stock	15.741	15.809	15.72	15.745	10556140.0
2014-08-04 13:00:00	AMZN	Stock	15.744	15.757	15.665	15.7016	5812200.0
2014-08-04 14:00:00	AMZN	Stock	15.7025	15.744	15.6905	15.7365	3279320.0

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

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