PREVIEW / stock_1hour / 2012-06-20

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-06-20.parquet
  size:    933 KB
  rows:    44,377
  symbols: 3,489

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
2012-06-20 06:00:00	AAPL	Stock	20.9732	20.9732	20.9732	20.9732	2800.0
2012-06-20 07:00:00	AAPL	Stock	20.9989	21.0311	20.9911	21.0039	149380.0
2012-06-20 08:00:00	AAPL	Stock	21.0	21.0321	20.9507	20.9911	558376.0
2012-06-20 09:00:00	AAPL	Stock	20.9914	21.0446	20.9304	20.9589	37369164.0
2012-06-20 10:00:00	AAPL	Stock	20.9589	20.966	20.8311	20.87	56544712.0
2012-06-20 11:00:00	AAPL	Stock	20.8696	20.8929	20.8357	20.8686	25545156.0
2012-06-20 12:00:00	AAPL	Stock	20.8679	20.9446	20.7429	20.9177	72821588.0
2012-06-20 13:00:00	AAPL	Stock	20.9211	21.0089	20.8661	20.9504	54776848.0
2012-06-20 14:00:00	AAPL	Stock	20.9507	20.9582	20.8214	20.8371	40493712.0
2012-06-20 15:00:00	AAPL	Stock	20.8496	20.9211	20.7879	20.9163	50308160.0
2012-06-20 16:00:00	AAPL	Stock	20.9196	20.9546	20.8707	20.9196	17190488.0
2012-06-20 17:00:00	AAPL	Stock	20.9186	20.9232	20.9146	20.9232	144396.0
2012-06-20 18:00:00	AAPL	Stock	20.9221	20.9243	20.9157	20.9157	89600.0
2012-06-20 19:00:00	AAPL	Stock	20.9146	20.9146	20.8954	20.8954	196196.0
2012-06-20 07:00:00	MSFT	Stock	30.89	30.89	30.89	30.89	300.0
2012-06-20 08:00:00	MSFT	Stock	30.86	30.87	30.76	30.8	16999.0
2012-06-20 09:00:00	MSFT	Stock	30.8	30.99	30.64	30.76	3767766.0
2012-06-20 10:00:00	MSFT	Stock	30.76	30.81	30.69	30.81	4440260.0
2012-06-20 11:00:00	MSFT	Stock	30.805	31.05	30.8	30.973	5502755.0
2012-06-20 12:00:00	MSFT	Stock	30.973	30.99	30.65	30.965	5349649.0
2012-06-20 13:00:00	MSFT	Stock	30.97	31.05	30.89	30.98	3222253.0
2012-06-20 14:00:00	MSFT	Stock	30.975	31.01	30.73	30.79	3992582.0
2012-06-20 15:00:00	MSFT	Stock	30.8	30.93	30.65	30.93	7003807.0
2012-06-20 16:00:00	MSFT	Stock	30.93	31.05	30.682	30.93	1729919.0
2012-06-20 17:00:00	MSFT	Stock	30.99	31.02	30.96	30.96	14021.0
2012-06-20 18:00:00	MSFT	Stock	30.95	31.0	30.92	30.95	30710.0
2012-06-20 19:00:00	MSFT	Stock	30.95	30.98	30.95	30.98	8052.0
2012-06-20 07:00:00	NVDA	Stock	0.3325	0.3325	0.3313	0.3313	64000.0
2012-06-20 08:00:00	NVDA	Stock	0.3325	0.3348	0.33	0.3342	2485600.0
2012-06-20 09:00:00	NVDA	Stock	0.3342	0.3425	0.3322	0.3411	146035000.0
2012-06-20 10:00:00	NVDA	Stock	0.3411	0.3413	0.336	0.3362	148735560.0
2012-06-20 11:00:00	NVDA	Stock	0.3361	0.3378	0.336	0.3366	86227440.0
2012-06-20 12:00:00	NVDA	Stock	0.3366	0.3378	0.3345	0.3373	126713520.0
2012-06-20 13:00:00	NVDA	Stock	0.3373	0.3418	0.3373	0.3408	126223200.0
2012-06-20 14:00:00	NVDA	Stock	0.3408	0.3422	0.3365	0.3368	90936160.0
2012-06-20 15:00:00	NVDA	Stock	0.3368	0.337	0.334	0.3362	183210560.0
2012-06-20 16:00:00	NVDA	Stock	0.3362	0.3378	0.331	0.3362	14913280.0
2012-06-20 17:00:00	NVDA	Stock	0.3308	0.3378	0.3308	0.3362	192600.0
2012-06-20 19:00:00	NVDA	Stock	0.3375	0.339	0.3375	0.339	47200.0
2012-06-20 08:00:00	AMZN	Stock	11.175	11.225	11.175	11.203	28000.0
2012-06-20 09:00:00	AMZN	Stock	11.222	11.239	11.1435	11.182	4756680.0
2012-06-20 10:00:00	AMZN	Stock	11.18	11.2365	11.159	11.18	6192520.0
2012-06-20 11:00:00	AMZN	Stock	11.18	11.1995	11.1356	11.137	3557880.0
2012-06-20 12:00:00	AMZN	Stock	11.137	11.167	11.042	11.146	8741180.0
2012-06-20 13:00:00	AMZN	Stock	11.149	11.23	11.132	11.1528	7884220.0
2012-06-20 14:00:00	AMZN	Stock	11.151	11.1775	11.05	11.101	7831240.0
2012-06-20 15:00:00	AMZN	Stock	11.1015	11.151	11.067	11.151	8747720.0
2012-06-20 16:00:00	AMZN	Stock	11.151	11.1745	11.1126	11.151	1079760.0
2012-06-20 17:00:00	AMZN	Stock	11.162	11.1745	11.162	11.1635	35000.0
2012-06-20 19:00:00	AMZN	Stock	11.1655	11.198	11.1655	11.198	28840.0

> showing 50 of 44,377 rows — these rows as CSV

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