PREVIEW / stock_1hour / 2011-05-09

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-05-09.parquet
  size:    950 KB
  rows:    45,645
  symbols: 3,561

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-05-09 04:00:00	AAPL	Stock	12.4464	12.4575	12.4464	12.4575	9800.0
2011-05-09 05:00:00	AAPL	Stock	12.4214	12.4214	12.4214	12.4214	2800.0
2011-05-09 06:00:00	AAPL	Stock	12.455	12.455	12.3929	12.3929	41300.0
2011-05-09 07:00:00	AAPL	Stock	12.3929	12.4393	12.3929	12.4304	343616.0
2011-05-09 08:00:00	AAPL	Stock	12.4368	12.4454	12.395	12.3982	988428.0
2011-05-09 09:00:00	AAPL	Stock	12.4032	12.4714	12.3964	12.4114	40950112.0
2011-05-09 10:00:00	AAPL	Stock	12.4114	12.4375	12.376	12.4154	35989240.0
2011-05-09 11:00:00	AAPL	Stock	12.4161	12.4389	12.4014	12.4318	21074004.0
2011-05-09 12:00:00	AAPL	Stock	12.4336	12.4521	12.4036	12.4042	31341240.0
2011-05-09 13:00:00	AAPL	Stock	12.4054	12.4439	12.4054	12.4296	14916104.0
2011-05-09 14:00:00	AAPL	Stock	12.4311	12.4446	12.4161	12.435	20611584.0
2011-05-09 15:00:00	AAPL	Stock	12.4347	12.4382	12.4104	12.4111	30678592.0
2011-05-09 16:00:00	AAPL	Stock	12.4142	12.429	12.4071	12.4071	5289200.0
2011-05-09 17:00:00	AAPL	Stock	12.4093	12.4121	12.4057	12.4104	132048.0
2011-05-09 18:00:00	AAPL	Stock	12.4107	12.4143	12.41	12.41	108808.0
2011-05-09 19:00:00	AAPL	Stock	12.4114	12.4121	12.4082	12.4121	89012.0
2011-05-09 08:00:00	MSFT	Stock	25.98	25.99	25.87	25.89	8308.0
2011-05-09 09:00:00	MSFT	Stock	25.86	25.9	25.8	25.82	3412656.0
2011-05-09 10:00:00	MSFT	Stock	25.82	25.88	25.675	25.759	7249142.0
2011-05-09 11:00:00	MSFT	Stock	25.755	25.85	25.67	25.835	5087442.0
2011-05-09 12:00:00	MSFT	Stock	25.83	25.95	25.83	25.88	5526208.0
2011-05-09 13:00:00	MSFT	Stock	25.88	25.96	25.87	25.93	3525232.0
2011-05-09 14:00:00	MSFT	Stock	25.93	25.95	25.83	25.85	3336499.0
2011-05-09 15:00:00	MSFT	Stock	25.86	25.89	25.8	25.82	6558138.0
2011-05-09 16:00:00	MSFT	Stock	25.82	25.87	25.691	25.81	3363210.0
2011-05-09 17:00:00	MSFT	Stock	25.81	25.84	25.8	25.8	11783.0
2011-05-09 18:00:00	MSFT	Stock	25.83	25.83	25.78	25.79	78909.0
2011-05-09 19:00:00	MSFT	Stock	25.8	25.8	25.79	25.8	3300.0
2011-05-09 07:00:00	NVDA	Stock	0.4805	0.4875	0.4805	0.4875	40000.0
2011-05-09 08:00:00	NVDA	Stock	0.4868	0.4888	0.484	0.4848	260000.0
2011-05-09 09:00:00	NVDA	Stock	0.4845	0.4963	0.481	0.494	143078600.0
2011-05-09 10:00:00	NVDA	Stock	0.4942	0.4958	0.484	0.4864	151976840.0
2011-05-09 11:00:00	NVDA	Stock	0.4862	0.4905	0.4832	0.4898	118044640.0
2011-05-09 12:00:00	NVDA	Stock	0.4898	0.4918	0.4885	0.489	61843680.0
2011-05-09 13:00:00	NVDA	Stock	0.489	0.4912	0.4885	0.4905	49997160.0
2011-05-09 14:00:00	NVDA	Stock	0.4905	0.4925	0.4895	0.4923	49580680.0
2011-05-09 15:00:00	NVDA	Stock	0.492	0.4955	0.4918	0.4938	112619160.0
2011-05-09 16:00:00	NVDA	Stock	0.4938	0.4963	0.483	0.495	13309440.0
2011-05-09 17:00:00	NVDA	Stock	0.495	0.495	0.4942	0.4945	220400.0
2011-05-09 18:00:00	NVDA	Stock	0.4948	0.4948	0.4948	0.4948	92400.0
2011-05-09 19:00:00	NVDA	Stock	0.4948	0.4955	0.4948	0.4955	61600.0
2011-05-09 06:00:00	AMZN	Stock	9.9565	9.965	9.9565	9.965	10000.0
2011-05-09 07:00:00	AMZN	Stock	9.942	9.942	9.935	9.935	6000.0
2011-05-09 08:00:00	AMZN	Stock	9.9465	9.9465	9.907	9.907	91820.0
2011-05-09 09:00:00	AMZN	Stock	9.918	9.972	9.839	9.9515	14924460.0
2011-05-09 10:00:00	AMZN	Stock	9.9557	10.06	9.9135	10.0425	26022800.0
2011-05-09 11:00:00	AMZN	Stock	10.0465	10.111	10.008	10.0904	22301800.0
2011-05-09 12:00:00	AMZN	Stock	10.0875	10.118	10.044	10.0555	12144440.0
2011-05-09 13:00:00	AMZN	Stock	10.057	10.1105	10.0505	10.092	9358020.0
2011-05-09 14:00:00	AMZN	Stock	10.0935	10.103	10.045	10.061	9642440.0

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

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