PREVIEW / stock_1hour / 2011-06-10

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-06-10.parquet
  size:    953 KB
  rows:    45,965
  symbols: 3,540

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-10 04:00:00	AAPL	Stock	11.8268	11.8286	11.8268	11.8275	30800.0
2011-06-10 05:00:00	AAPL	Stock	11.8571	11.8571	11.8571	11.8571	8400.0
2011-06-10 07:00:00	AAPL	Stock	11.8482	11.8568	11.835	11.85	161980.0
2011-06-10 08:00:00	AAPL	Stock	11.8468	11.8482	11.8075	11.8193	1200248.0
2011-06-10 09:00:00	AAPL	Stock	11.8118	11.845	11.7775	11.8279	62787228.0
2011-06-10 10:00:00	AAPL	Stock	11.8254	11.83	11.6964	11.7061	90689928.0
2011-06-10 11:00:00	AAPL	Stock	11.7071	11.7243	11.6639	11.6975	62291096.0
2011-06-10 12:00:00	AAPL	Stock	11.6975	11.7204	11.6789	11.6964	30019276.0
2011-06-10 13:00:00	AAPL	Stock	11.6968	11.6979	11.6514	11.6775	38960572.0
2011-06-10 14:00:00	AAPL	Stock	11.6775	11.7214	11.6611	11.7164	50409520.0
2011-06-10 15:00:00	AAPL	Stock	11.7161	11.72	11.6254	11.6275	79131276.0
2011-06-10 16:00:00	AAPL	Stock	11.6325	11.7275	11.6093	11.6257	12824280.0
2011-06-10 17:00:00	AAPL	Stock	11.6282	11.6286	11.6182	11.6196	177968.0
2011-06-10 18:00:00	AAPL	Stock	11.6196	11.6393	11.6182	11.6211	175756.0
2011-06-10 19:00:00	AAPL	Stock	11.6214	11.6279	11.6196	11.6279	63560.0
2011-06-10 05:00:00	MSFT	Stock	23.99	23.99	23.99	23.99	100.0
2011-06-10 07:00:00	MSFT	Stock	23.92	23.92	23.92	23.92	378.0
2011-06-10 08:00:00	MSFT	Stock	23.88	23.92	23.88	23.92	8486.0
2011-06-10 09:00:00	MSFT	Stock	23.91	24.02	23.84	23.93	5283759.0
2011-06-10 10:00:00	MSFT	Stock	23.935	23.98	23.8	23.85	7113901.0
2011-06-10 11:00:00	MSFT	Stock	23.85	23.89	23.81	23.855	5884737.0
2011-06-10 12:00:00	MSFT	Stock	23.86	23.89	23.81	23.83	5605799.0
2011-06-10 13:00:00	MSFT	Stock	23.84	23.84	23.72	23.77	4906771.0
2011-06-10 14:00:00	MSFT	Stock	23.77	23.888	23.77	23.886	6047853.0
2011-06-10 15:00:00	MSFT	Stock	23.885	23.89	23.69	23.69	10019690.0
2011-06-10 16:00:00	MSFT	Stock	23.7	23.852	23.64	23.69	3159497.0
2011-06-10 17:00:00	MSFT	Stock	23.69	23.69	23.67	23.68	7790.0
2011-06-10 18:00:00	MSFT	Stock	23.7	23.7	23.63	23.63	34648.0
2011-06-10 19:00:00	MSFT	Stock	23.65	23.67	23.64	23.67	6776.0
2011-06-10 08:00:00	NVDA	Stock	0.435	0.4405	0.435	0.4362	716200.0
2011-06-10 09:00:00	NVDA	Stock	0.4358	0.4376	0.4258	0.4265	63294480.0
2011-06-10 10:00:00	NVDA	Stock	0.4265	0.429	0.4245	0.4265	98937920.0
2011-06-10 11:00:00	NVDA	Stock	0.4262	0.4288	0.4255	0.4286	54541760.0
2011-06-10 12:00:00	NVDA	Stock	0.4285	0.4305	0.4272	0.4298	41952520.0
2011-06-10 13:00:00	NVDA	Stock	0.4298	0.4302	0.4268	0.4278	43240200.0
2011-06-10 14:00:00	NVDA	Stock	0.4278	0.432	0.4278	0.4318	60258760.0
2011-06-10 15:00:00	NVDA	Stock	0.4318	0.432	0.4275	0.4278	113824440.0
2011-06-10 16:00:00	NVDA	Stock	0.428	0.4298	0.4265	0.428	3688400.0
2011-06-10 17:00:00	NVDA	Stock	0.428	0.428	0.428	0.428	206160.0
2011-06-10 18:00:00	NVDA	Stock	0.428	0.428	0.428	0.428	20000.0
2011-06-10 19:00:00	NVDA	Stock	0.4288	0.4288	0.4282	0.4285	34000.0
2011-06-10 08:00:00	AMZN	Stock	9.4325	9.4325	9.405	9.405	4000.0
2011-06-10 09:00:00	AMZN	Stock	9.42	9.531	9.4075	9.523	8473720.0
2011-06-10 10:00:00	AMZN	Stock	9.523	9.5385	9.3505	9.365	15503240.0
2011-06-10 11:00:00	AMZN	Stock	9.364	9.417	9.336	9.396	9088200.0
2011-06-10 12:00:00	AMZN	Stock	9.3945	9.4485	9.372	9.417	5297660.0
2011-06-10 13:00:00	AMZN	Stock	9.4151	9.4151	9.3335	9.3745	7092560.0
2011-06-10 14:00:00	AMZN	Stock	9.377	9.43	9.36	9.4275	8589900.0
2011-06-10 15:00:00	AMZN	Stock	9.4325	9.4365	9.314	9.326	17141840.0
2011-06-10 16:00:00	AMZN	Stock	9.3265	9.4043	9.31	9.325	1334720.0

> showing 50 of 45,965 rows — these rows as CSV

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