PREVIEW / stock_1hour / 2014-11-24

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-11-24.parquet
  size:    1.1 MB
  rows:    50,296
  symbols: 3,570

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-11-24 04:00:00	AAPL	Stock	29.15	29.22	29.15	29.1875	31964.0
2014-11-24 05:00:00	AAPL	Stock	29.1875	29.1875	29.15	29.175	23300.0
2014-11-24 06:00:00	AAPL	Stock	29.1875	29.195	29.165	29.175	50016.0
2014-11-24 07:00:00	AAPL	Stock	29.175	29.2075	29.1625	29.185	183168.0
2014-11-24 08:00:00	AAPL	Stock	29.19	29.265	29.1775	29.215	630184.0
2014-11-24 09:00:00	AAPL	Stock	29.22	29.33	29.155	29.295	24403412.0
2014-11-24 10:00:00	AAPL	Stock	29.295	29.435	29.29	29.3725	30297580.0
2014-11-24 11:00:00	AAPL	Stock	29.3725	29.4625	29.3625	29.41	20568212.0
2014-11-24 12:00:00	AAPL	Stock	29.4148	29.565	29.4025	29.5375	21600284.0
2014-11-24 13:00:00	AAPL	Stock	29.5375	29.575	29.5025	29.5675	12535888.0
2014-11-24 14:00:00	AAPL	Stock	29.57	29.6125	29.5325	29.605	15964204.0
2014-11-24 15:00:00	AAPL	Stock	29.6062	29.6925	29.5675	29.6562	26826568.0
2014-11-24 16:00:00	AAPL	Stock	29.6562	29.675	29.0815	29.6325	20498768.0
2014-11-24 17:00:00	AAPL	Stock	29.63	29.665	29.482	29.6575	387776.0
2014-11-24 18:00:00	AAPL	Stock	29.6625	29.695	29.655	29.695	1246096.0
2014-11-24 19:00:00	AAPL	Stock	29.695	29.7	29.685	29.6925	130732.0
2014-11-24 05:00:00	MSFT	Stock	48.03	48.1	48.0	48.1	2500.0
2014-11-24 06:00:00	MSFT	Stock	48.1	48.1	48.01	48.01	1450.0
2014-11-24 07:00:00	MSFT	Stock	48.03	48.03	48.03	48.03	150.0
2014-11-24 08:00:00	MSFT	Stock	48.03	48.07	48.0	48.0	8259.0
2014-11-24 09:00:00	MSFT	Stock	48.07	48.07	47.39	47.5	6126085.0
2014-11-24 10:00:00	MSFT	Stock	47.51	47.76	47.48	47.7	5624279.0
2014-11-24 11:00:00	MSFT	Stock	47.695	47.83	47.67	47.78	2972811.0
2014-11-24 12:00:00	MSFT	Stock	47.775	47.85	47.7	47.76	2772406.0
2014-11-24 13:00:00	MSFT	Stock	47.75	47.85	47.73	47.77	2393276.0
2014-11-24 14:00:00	MSFT	Stock	47.77	47.83	47.71	47.77	2828698.0
2014-11-24 15:00:00	MSFT	Stock	47.765	47.79	47.58	47.6	6853870.0
2014-11-24 16:00:00	MSFT	Stock	47.59	48.064	47.49	47.59	3632646.0
2014-11-24 17:00:00	MSFT	Stock	47.59	47.75	47.59	47.59	103538.0
2014-11-24 18:00:00	MSFT	Stock	47.71	47.71	47.59	47.65	5311.0
2014-11-24 19:00:00	MSFT	Stock	47.59	47.6	47.59	47.6	1154907.0
2014-11-24 09:00:00	NVDA	Stock	0.513	0.5168	0.5115	0.515	19976800.0
2014-11-24 10:00:00	NVDA	Stock	0.515	0.516	0.5108	0.5118	21697640.0
2014-11-24 11:00:00	NVDA	Stock	0.5118	0.5142	0.5105	0.514	14573840.0
2014-11-24 12:00:00	NVDA	Stock	0.5138	0.5148	0.5122	0.5125	8817720.0
2014-11-24 13:00:00	NVDA	Stock	0.5122	0.5133	0.5115	0.512	12855840.0
2014-11-24 14:00:00	NVDA	Stock	0.512	0.514	0.512	0.514	16164560.0
2014-11-24 15:00:00	NVDA	Stock	0.514	0.5149	0.5135	0.5145	31309840.0
2014-11-24 16:00:00	NVDA	Stock	0.5145	0.5147	0.5145	0.5145	5592120.0
2014-11-24 17:00:00	NVDA	Stock	0.5145	0.5146	0.5145	0.5146	204040.0
2014-11-24 05:00:00	AMZN	Stock	16.638	16.638	16.638	16.638	2060.0
2014-11-24 07:00:00	AMZN	Stock	16.6985	16.703	16.6985	16.7	10600.0
2014-11-24 08:00:00	AMZN	Stock	16.7195	16.734	16.6315	16.7335	104500.0
2014-11-24 09:00:00	AMZN	Stock	16.7335	16.8695	16.68	16.7385	10657160.0
2014-11-24 10:00:00	AMZN	Stock	16.7508	16.862	16.733	16.776	7474620.0
2014-11-24 11:00:00	AMZN	Stock	16.776	16.8005	16.743	16.792	4185200.0
2014-11-24 12:00:00	AMZN	Stock	16.793	16.8235	16.7395	16.7715	4535440.0
2014-11-24 13:00:00	AMZN	Stock	16.7685	16.869	16.7565	16.858	5688860.0
2014-11-24 14:00:00	AMZN	Stock	16.853	16.857	16.7825	16.8	5002740.0
2014-11-24 15:00:00	AMZN	Stock	16.8	16.8085	16.7395	16.781	10125200.0

> showing 50 of 50,296 rows — these rows as CSV

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