PREVIEW / stock_1hour / 2012-01-06

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-01-06.parquet
  size:    917 KB
  rows:    43,553
  symbols: 3,529

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-01-06 04:00:00	AAPL	Stock	14.9304	14.9304	14.9304	14.9304	8400.0
2012-01-06 07:00:00	AAPL	Stock	14.9532	14.9607	14.9425	14.9561	121156.0
2012-01-06 08:00:00	AAPL	Stock	14.9568	14.9911	14.9379	14.9718	3570812.0
2012-01-06 09:00:00	AAPL	Stock	14.9661	15.0525	14.9589	15.0021	82122516.0
2012-01-06 10:00:00	AAPL	Stock	15.0029	15.0457	14.9879	15.0157	47779396.0
2012-01-06 11:00:00	AAPL	Stock	15.0159	15.0439	15.0146	15.0239	28041608.0
2012-01-06 12:00:00	AAPL	Stock	15.0232	15.0387	15.0107	15.0271	20342756.0
2012-01-06 13:00:00	AAPL	Stock	15.0271	15.0639	15.0193	15.0607	21692300.0
2012-01-06 14:00:00	AAPL	Stock	15.0618	15.0893	15.0457	15.0667	40755680.0
2012-01-06 15:00:00	AAPL	Stock	15.0664	15.0982	15.0464	15.0875	62892732.0
2012-01-06 16:00:00	AAPL	Stock	15.0871	15.0932	15.0237	15.0857	8024156.0
2012-01-06 17:00:00	AAPL	Stock	15.085	15.0861	15.0814	15.0839	123060.0
2012-01-06 18:00:00	AAPL	Stock	15.0818	15.0857	15.0811	15.0832	88284.0
2012-01-06 19:00:00	AAPL	Stock	15.0821	15.0839	15.0793	15.0814	80724.0
2012-01-06 06:00:00	MSFT	Stock	27.7	27.7	27.7	27.7	100.0
2012-01-06 07:00:00	MSFT	Stock	27.68	27.68	27.68	27.68	100.0
2012-01-06 08:00:00	MSFT	Stock	27.65	27.78	27.65	27.68	28377.0
2012-01-06 09:00:00	MSFT	Stock	27.68	27.68	27.525	27.68	7885002.0
2012-01-06 10:00:00	MSFT	Stock	27.67	27.775	27.64	27.758	7037032.0
2012-01-06 11:00:00	MSFT	Stock	27.76	28.0	27.745	27.97	15244110.0
2012-01-06 12:00:00	MSFT	Stock	27.975	28.02	27.94	28.0	14209504.0
2012-01-06 13:00:00	MSFT	Stock	28.0	28.01	27.88	27.976	11184175.0
2012-01-06 14:00:00	MSFT	Stock	27.97	28.1	27.95	28.1	13106309.0
2012-01-06 15:00:00	MSFT	Stock	28.1	28.19	28.02	28.12	22925415.0
2012-01-06 16:00:00	MSFT	Stock	28.12	28.188	27.58	28.11	5786430.0
2012-01-06 17:00:00	MSFT	Stock	28.11	28.12	28.1	28.1	153782.0
2012-01-06 18:00:00	MSFT	Stock	28.11	28.11	28.1	28.1	38329.0
2012-01-06 19:00:00	MSFT	Stock	28.07	28.07	28.02	28.02	2401.0
2012-01-06 08:00:00	NVDA	Stock	0.3688	0.3708	0.3688	0.3695	156000.0
2012-01-06 09:00:00	NVDA	Stock	0.369	0.369	0.3598	0.3625	75303880.0
2012-01-06 10:00:00	NVDA	Stock	0.3625	0.3635	0.361	0.3611	91929040.0
2012-01-06 11:00:00	NVDA	Stock	0.3612	0.364	0.361	0.3625	67688360.0
2012-01-06 12:00:00	NVDA	Stock	0.3625	0.3625	0.36	0.3605	53090600.0
2012-01-06 13:00:00	NVDA	Stock	0.3605	0.3625	0.3592	0.3612	49057080.0
2012-01-06 14:00:00	NVDA	Stock	0.3612	0.364	0.3609	0.364	52615920.0
2012-01-06 15:00:00	NVDA	Stock	0.3638	0.3645	0.3625	0.3636	96542240.0
2012-01-06 16:00:00	NVDA	Stock	0.3638	0.3678	0.3622	0.3631	43137520.0
2012-01-06 17:00:00	NVDA	Stock	0.3638	0.3638	0.3632	0.3632	38000.0
2012-01-06 19:00:00	NVDA	Stock	0.364	0.364	0.364	0.364	396000.0
2012-01-06 07:00:00	AMZN	Stock	8.89	8.9015	8.856	8.9015	28000.0
2012-01-06 08:00:00	AMZN	Stock	8.9025	8.95	8.89	8.89	194820.0
2012-01-06 09:00:00	AMZN	Stock	8.8975	9.0735	8.875	9.05	18543960.0
2012-01-06 10:00:00	AMZN	Stock	9.052	9.1865	9.03	9.169	32034220.0
2012-01-06 11:00:00	AMZN	Stock	9.1695	9.2325	9.166	9.2005	24584660.0
2012-01-06 12:00:00	AMZN	Stock	9.2045	9.2245	9.1695	9.175	13184060.0
2012-01-06 13:00:00	AMZN	Stock	9.175	9.1955	9.155	9.1815	11530420.0
2012-01-06 14:00:00	AMZN	Stock	9.182	9.194	9.145	9.1545	10628760.0
2012-01-06 15:00:00	AMZN	Stock	9.153	9.166	9.1135	9.1335	21715800.0
2012-01-06 16:00:00	AMZN	Stock	9.131	9.146	9.122	9.1245	1219320.0
2012-01-06 17:00:00	AMZN	Stock	9.1295	9.13	9.1295	9.13	6000.0

> showing 50 of 43,553 rows — these rows as CSV

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