PREVIEW / stock_1hour / 2014-12-23

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-12-23.parquet
  size:    1.1 MB
  rows:    49,723
  symbols: 3,569

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-12-23 06:00:00	AAPL	Stock	28.1875	28.2125	28.1875	28.2125	4400.0
2014-12-23 07:00:00	AAPL	Stock	28.2275	28.3625	28.225	28.27	128924.0
2014-12-23 08:00:00	AAPL	Stock	28.275	28.325	28.25	28.325	513324.0
2014-12-23 09:00:00	AAPL	Stock	28.325	28.3525	28.13	28.1775	19016900.0
2014-12-23 10:00:00	AAPL	Stock	28.175	28.275	28.1525	28.2175	18413052.0
2014-12-23 11:00:00	AAPL	Stock	28.2152	28.225	28.1625	28.1778	10750884.0
2014-12-23 12:00:00	AAPL	Stock	28.1788	28.2	28.13	28.1475	8035388.0
2014-12-23 13:00:00	AAPL	Stock	28.1475	28.18	28.115	28.149	9322360.0
2014-12-23 14:00:00	AAPL	Stock	28.1485	28.225	28.1475	28.1975	8807668.0
2014-12-23 15:00:00	AAPL	Stock	28.1975	28.2225	28.13	28.135	13347856.0
2014-12-23 16:00:00	AAPL	Stock	28.135	28.1965	28.1275	28.135	8898316.0
2014-12-23 17:00:00	AAPL	Stock	28.135	28.145	28.13	28.135	100860.0
2014-12-23 18:00:00	AAPL	Stock	28.13	28.135	28.11	28.125	55068.0
2014-12-23 19:00:00	AAPL	Stock	28.115	28.145	28.115	28.145	77780.0
2014-12-23 06:00:00	MSFT	Stock	47.95	47.95	47.95	47.95	1100.0
2014-12-23 07:00:00	MSFT	Stock	47.93	47.93	47.93	47.93	800.0
2014-12-23 08:00:00	MSFT	Stock	47.9	48.12	47.86	48.12	4635.0
2014-12-23 09:00:00	MSFT	Stock	48.11	48.5	48.11	48.481	3091240.0
2014-12-23 10:00:00	MSFT	Stock	48.49	48.66	48.41	48.611	4870515.0
2014-12-23 11:00:00	MSFT	Stock	48.62	48.8	48.6	48.71	2223335.0
2014-12-23 12:00:00	MSFT	Stock	48.71	48.74	48.55	48.56	2083714.0
2014-12-23 13:00:00	MSFT	Stock	48.56	48.8	48.56	48.66	1689455.0
2014-12-23 14:00:00	MSFT	Stock	48.67	48.71	48.55	48.56	1666875.0
2014-12-23 15:00:00	MSFT	Stock	48.555	48.62	48.42	48.44	3805134.0
2014-12-23 16:00:00	MSFT	Stock	48.45	48.69	48.42	48.69	3443104.0
2014-12-23 17:00:00	MSFT	Stock	48.45	48.47	48.42	48.42	6480.0
2014-12-23 18:00:00	MSFT	Stock	48.42	48.42	48.42	48.42	500.0
2014-12-23 19:00:00	MSFT	Stock	48.45	48.45	48.45	48.45	738.0
2014-12-23 08:00:00	NVDA	Stock	0.5198	0.5198	0.5198	0.5198	4000.0
2014-12-23 09:00:00	NVDA	Stock	0.5128	0.526	0.5128	0.5247	17299200.0
2014-12-23 10:00:00	NVDA	Stock	0.525	0.5259	0.5215	0.5228	13746640.0
2014-12-23 11:00:00	NVDA	Stock	0.523	0.5232	0.5209	0.522	10438160.0
2014-12-23 12:00:00	NVDA	Stock	0.5222	0.5225	0.5199	0.521	11057360.0
2014-12-23 13:00:00	NVDA	Stock	0.521	0.521	0.5185	0.5185	8665080.0
2014-12-23 14:00:00	NVDA	Stock	0.5185	0.5188	0.5173	0.5178	7817440.0
2014-12-23 15:00:00	NVDA	Stock	0.5178	0.5182	0.5156	0.516	24640040.0
2014-12-23 16:00:00	NVDA	Stock	0.5162	0.5253	0.5162	0.5162	11939400.0
2014-12-23 17:00:00	NVDA	Stock	0.5205	0.5205	0.5205	0.5205	787760.0
2014-12-23 08:00:00	AMZN	Stock	15.325	15.35	15.3	15.313	116900.0
2014-12-23 09:00:00	AMZN	Stock	15.3045	15.371	15.1626	15.1905	10550540.0
2014-12-23 10:00:00	AMZN	Stock	15.193	15.31	15.185	15.257	9273760.0
2014-12-23 11:00:00	AMZN	Stock	15.2555	15.3745	15.2375	15.3245	6278080.0
2014-12-23 12:00:00	AMZN	Stock	15.3245	15.3405	15.2515	15.2528	5756880.0
2014-12-23 13:00:00	AMZN	Stock	15.253	15.334	15.238	15.326	3840640.0
2014-12-23 14:00:00	AMZN	Stock	15.3205	15.3455	15.293	15.31	3345240.0
2014-12-23 15:00:00	AMZN	Stock	15.312	15.35	15.292	15.314	6975620.0
2014-12-23 16:00:00	AMZN	Stock	15.3142	15.3142	15.31	15.3142	1098980.0
2014-12-23 17:00:00	AMZN	Stock	15.3173	15.3173	15.2973	15.3124	10740.0
2014-12-23 07:00:00	GOOGL	Stock	26.6725	26.6725	26.6725	26.6725	2000.0
2014-12-23 08:00:00	GOOGL	Stock	26.6665	26.7	26.652	26.7	18000.0

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

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