PREVIEW / stock_1hour / 2011-06-13

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-06-13.parquet
  size:    958 KB
  rows:    46,282
  symbols: 3,567

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
2011-06-13 05:00:00	AAPL	Stock	11.6393	11.6393	11.6389	11.6389	5600.0
2011-06-13 06:00:00	AAPL	Stock	11.6696	11.6782	11.6696	11.6782	29960.0
2011-06-13 07:00:00	AAPL	Stock	11.6696	11.6946	11.6696	11.6889	319200.0
2011-06-13 08:00:00	AAPL	Stock	11.68	11.7036	11.6786	11.6964	935172.0
2011-06-13 09:00:00	AAPL	Stock	11.6986	11.6986	11.6096	11.678	62929636.0
2011-06-13 10:00:00	AAPL	Stock	11.675	11.7125	11.6371	11.6696	56174972.0
2011-06-13 11:00:00	AAPL	Stock	11.6671	11.69	11.6371	11.6471	27703060.0
2011-06-13 12:00:00	AAPL	Stock	11.6493	11.675	11.6344	11.6461	25802840.0
2011-06-13 13:00:00	AAPL	Stock	11.6464	11.7032	11.6214	11.6986	41734924.0
2011-06-13 14:00:00	AAPL	Stock	11.6968	11.7254	11.6654	11.6971	49468216.0
2011-06-13 15:00:00	AAPL	Stock	11.6971	11.7082	11.6386	11.6639	48973316.0
2011-06-13 16:00:00	AAPL	Stock	11.6646	11.6833	11.6625	11.6671	7281960.0
2011-06-13 17:00:00	AAPL	Stock	11.6643	11.6679	11.6607	11.6625	332864.0
2011-06-13 18:00:00	AAPL	Stock	11.6607	11.6714	11.6582	11.6714	84588.0
2011-06-13 19:00:00	AAPL	Stock	11.6768	11.6779	11.6704	11.6779	131600.0
2011-06-13 07:00:00	MSFT	Stock	23.8	23.83	23.74	23.75	2300.0
2011-06-13 08:00:00	MSFT	Stock	23.71	23.8	23.71	23.8	15585.0
2011-06-13 09:00:00	MSFT	Stock	23.8	23.83	23.7	23.82	3729493.0
2011-06-13 10:00:00	MSFT	Stock	23.82	24.0	23.815	23.891	5755673.0
2011-06-13 11:00:00	MSFT	Stock	23.9	24.0	23.88	23.94	5322983.0
2011-06-13 12:00:00	MSFT	Stock	23.94	23.97	23.88	23.94	3655244.0
2011-06-13 13:00:00	MSFT	Stock	23.95	24.05	23.89	24.04	4517592.0
2011-06-13 14:00:00	MSFT	Stock	24.04	24.19	24.04	24.12	8145985.0
2011-06-13 15:00:00	MSFT	Stock	24.12	24.16	23.99	24.03	12283001.0
2011-06-13 16:00:00	MSFT	Stock	24.03	24.152	23.98	24.06	3612380.0
2011-06-13 17:00:00	MSFT	Stock	24.023	24.06	23.98	24.03	129465.0
2011-06-13 18:00:00	MSFT	Stock	24.05	24.05	24.04	24.05	11735.0
2011-06-13 19:00:00	MSFT	Stock	24.05	24.05	24.05	24.05	1111.0
2011-06-13 08:00:00	NVDA	Stock	0.4285	0.4285	0.4275	0.4275	60000.0
2011-06-13 09:00:00	NVDA	Stock	0.43	0.4335	0.4262	0.431	60668800.0
2011-06-13 10:00:00	NVDA	Stock	0.4311	0.4318	0.4222	0.4246	124973880.0
2011-06-13 11:00:00	NVDA	Stock	0.4248	0.4248	0.422	0.4231	81233960.0
2011-06-13 12:00:00	NVDA	Stock	0.4232	0.426	0.4222	0.4245	55413920.0
2011-06-13 13:00:00	NVDA	Stock	0.4244	0.4251	0.4225	0.425	58272120.0
2011-06-13 14:00:00	NVDA	Stock	0.425	0.427	0.4238	0.4254	56922160.0
2011-06-13 15:00:00	NVDA	Stock	0.4254	0.427	0.4248	0.425	115738480.0
2011-06-13 16:00:00	NVDA	Stock	0.4253	0.4264	0.4249	0.4253	1230360.0
2011-06-13 17:00:00	NVDA	Stock	0.4253	0.4253	0.425	0.425	116000.0
2011-06-13 19:00:00	NVDA	Stock	0.4242	0.4242	0.4242	0.4242	8800.0
2011-06-13 07:00:00	AMZN	Stock	9.393	9.4	9.393	9.4	6000.0
2011-06-13 08:00:00	AMZN	Stock	9.3905	9.3905	9.375	9.38	22000.0
2011-06-13 09:00:00	AMZN	Stock	9.3705	9.4655	9.339	9.4435	10893540.0
2011-06-13 10:00:00	AMZN	Stock	9.443	9.4525	9.331	9.347	12171920.0
2011-06-13 11:00:00	AMZN	Stock	9.3474	9.415	9.295	9.2985	8322420.0
2011-06-13 12:00:00	AMZN	Stock	9.3005	9.3425	9.276	9.2875	7381460.0
2011-06-13 13:00:00	AMZN	Stock	9.2845	9.377	9.243	9.369	12301920.0
2011-06-13 14:00:00	AMZN	Stock	9.3685	9.377	9.3	9.309	10235500.0
2011-06-13 15:00:00	AMZN	Stock	9.306	9.3295	9.281	9.3145	12633580.0
2011-06-13 16:00:00	AMZN	Stock	9.3145	9.3422	9.3097	9.336	385440.0
2011-06-13 17:00:00	AMZN	Stock	9.336	9.347	9.3177	9.326	146000.0

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

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