PREVIEW / stock_1hour / 2013-04-01

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-04-01.parquet
  size:    993 KB
  rows:    46,472
  symbols: 3,471

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
2013-04-01 07:00:00	AAPL	Stock	15.7657	15.7857	15.7657	15.7857	64456.0
2013-04-01 08:00:00	AAPL	Stock	15.7682	15.8489	15.7679	15.8375	1237796.0
2013-04-01 09:00:00	AAPL	Stock	15.8357	15.8464	15.5775	15.5943	75401564.0
2013-04-01 10:00:00	AAPL	Stock	15.5971	15.6061	15.475	15.5379	86468788.0
2013-04-01 11:00:00	AAPL	Stock	15.5396	15.5875	15.5154	15.5389	30222892.0
2013-04-01 12:00:00	AAPL	Stock	15.5364	15.5406	15.4739	15.5049	25646936.0
2013-04-01 13:00:00	AAPL	Stock	15.5046	15.5443	15.5032	15.5105	20927088.0
2013-04-01 14:00:00	AAPL	Stock	15.5114	15.5411	15.4561	15.4639	27158936.0
2013-04-01 15:00:00	AAPL	Stock	15.4611	15.4718	15.2764	15.3182	101452148.0
2013-04-01 16:00:00	AAPL	Stock	15.3168	15.5406	15.3039	15.3075	12023284.0
2013-04-01 17:00:00	AAPL	Stock	15.31	15.3182	15.2946	15.315	1311436.0
2013-04-01 18:00:00	AAPL	Stock	15.3125	15.3179	15.3036	15.3125	250096.0
2013-04-01 19:00:00	AAPL	Stock	15.3161	15.3407	15.3125	15.3407	302176.0
2013-04-01 04:00:00	MSFT	Stock	28.75	28.75	28.0	28.0	500.0
2013-04-01 08:00:00	MSFT	Stock	28.55	28.6	28.55	28.6	12574.0
2013-04-01 09:00:00	MSFT	Stock	28.59	28.66	28.53	28.599	3373996.0
2013-04-01 10:00:00	MSFT	Stock	28.6	28.605	28.36	28.48	7006861.0
2013-04-01 11:00:00	MSFT	Stock	28.48	28.59	28.43	28.545	2856163.0
2013-04-01 12:00:00	MSFT	Stock	28.552	28.56	28.495	28.535	2693178.0
2013-04-01 13:00:00	MSFT	Stock	28.53	28.56	28.5	28.512	1674717.0
2013-04-01 14:00:00	MSFT	Stock	28.515	28.535	28.5	28.505	2436944.0
2013-04-01 15:00:00	MSFT	Stock	28.505	28.615	28.49	28.6	6453998.0
2013-04-01 16:00:00	MSFT	Stock	28.61	28.611	28.5	28.59	1566836.0
2013-04-01 17:00:00	MSFT	Stock	28.61	28.61	28.58	28.58	260697.0
2013-04-01 18:00:00	MSFT	Stock	28.6	28.6	28.56	28.6	1900.0
2013-04-01 19:00:00	MSFT	Stock	28.6	28.6	28.58	28.58	2107.0
2013-04-01 08:00:00	NVDA	Stock	0.3213	0.3213	0.3213	0.3213	4000.0
2013-04-01 09:00:00	NVDA	Stock	0.32	0.3203	0.3138	0.3141	40992480.0
2013-04-01 10:00:00	NVDA	Stock	0.3143	0.3145	0.311	0.3117	71187840.0
2013-04-01 11:00:00	NVDA	Stock	0.3115	0.3141	0.311	0.3134	30705520.0
2013-04-01 12:00:00	NVDA	Stock	0.3134	0.3135	0.3118	0.312	39954800.0
2013-04-01 13:00:00	NVDA	Stock	0.3123	0.314	0.3113	0.3113	82711440.0
2013-04-01 14:00:00	NVDA	Stock	0.3113	0.3118	0.3095	0.3098	58176320.0
2013-04-01 15:00:00	NVDA	Stock	0.31	0.3105	0.308	0.31	105664880.0
2013-04-01 16:00:00	NVDA	Stock	0.3103	0.3103	0.308	0.3085	12197640.0
2013-04-01 17:00:00	NVDA	Stock	0.3103	0.3103	0.308	0.308	489200.0
2013-04-01 19:00:00	NVDA	Stock	0.31	0.31	0.31	0.31	4000.0
2013-04-01 07:00:00	AMZN	Stock	13.35	13.35	13.35	13.35	4000.0
2013-04-01 08:00:00	AMZN	Stock	13.35	13.35	13.305	13.305	71780.0
2013-04-01 09:00:00	AMZN	Stock	13.33	13.37	13.23	13.2359	7817040.0
2013-04-01 10:00:00	AMZN	Stock	13.245	13.2605	13.149	13.149	10687740.0
2013-04-01 11:00:00	AMZN	Stock	13.1425	13.2165	13.112	13.161	4574360.0
2013-04-01 12:00:00	AMZN	Stock	13.159	13.1835	13.1385	13.177	3542600.0
2013-04-01 13:00:00	AMZN	Stock	13.18	13.189	13.127	13.127	2742660.0
2013-04-01 14:00:00	AMZN	Stock	13.1275	13.1495	13.0595	13.079	5275180.0
2013-04-01 15:00:00	AMZN	Stock	13.0785	13.0995	13.0505	13.075	10847080.0
2013-04-01 16:00:00	AMZN	Stock	13.0805	13.1709	13.0515	13.0625	4103160.0
2013-04-01 17:00:00	AMZN	Stock	13.0625	13.0625	13.0575	13.0575	17940.0
2013-04-01 19:00:00	AMZN	Stock	13.0525	13.074	13.0525	13.0725	9500.0
2013-04-01 04:00:00	META	Stock	25.58	25.58	25.58	25.58	200.0

> showing 50 of 46,472 rows — these rows as CSV

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