PREVIEW / stock_1hour / 2011-05-16

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-05-16.parquet
  size:    949 KB
  rows:    44,961
  symbols: 3,559

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-16 05:00:00	AAPL	Stock	12.1082	12.1082	12.1082	12.1082	2800.0
2011-05-16 06:00:00	AAPL	Stock	12.085	12.085	12.08	12.0807	14000.0
2011-05-16 07:00:00	AAPL	Stock	12.0929	12.1343	12.0857	12.1214	365736.0
2011-05-16 08:00:00	AAPL	Stock	12.125	12.1607	12.0946	12.1054	1331988.0
2011-05-16 09:00:00	AAPL	Stock	12.105	12.1864	12.0625	12.1229	79097788.0
2011-05-16 10:00:00	AAPL	Stock	12.1229	12.1496	12.0786	12.0996	46593848.0
2011-05-16 11:00:00	AAPL	Stock	12.1025	12.125	12.0143	12.0316	54043164.0
2011-05-16 12:00:00	AAPL	Stock	12.0318	12.0414	11.9671	11.9693	51723504.0
2011-05-16 13:00:00	AAPL	Stock	11.9693	11.9992	11.9475	11.9682	46391996.0
2011-05-16 14:00:00	AAPL	Stock	11.9686	11.9786	11.9136	11.9336	54776624.0
2011-05-16 15:00:00	AAPL	Stock	11.9336	11.9664	11.8786	11.9043	82606440.0
2011-05-16 16:00:00	AAPL	Stock	11.9036	12.0367	11.8814	11.8814	24487456.0
2011-05-16 17:00:00	AAPL	Stock	11.8839	11.8929	11.8839	11.89	278964.0
2011-05-16 18:00:00	AAPL	Stock	11.8893	11.9036	11.8893	11.8982	369852.0
2011-05-16 19:00:00	AAPL	Stock	11.8982	11.8989	11.8786	11.8875	310016.0
2011-05-16 06:00:00	MSFT	Stock	25.0	25.0	25.0	25.0	990.0
2011-05-16 07:00:00	MSFT	Stock	24.98	24.98	24.98	24.98	200.0
2011-05-16 08:00:00	MSFT	Stock	25.0	25.04	25.0	25.03	87340.0
2011-05-16 09:00:00	MSFT	Stock	25.03	25.07	24.91	24.95	7555981.0
2011-05-16 10:00:00	MSFT	Stock	24.95	24.99	24.81	24.87	10888257.0
2011-05-16 11:00:00	MSFT	Stock	24.87	24.92	24.83	24.83	7814974.0
2011-05-16 12:00:00	MSFT	Stock	24.83	24.84	24.64	24.649	12660938.0
2011-05-16 13:00:00	MSFT	Stock	24.64	24.7	24.56	24.62	9753430.0
2011-05-16 14:00:00	MSFT	Stock	24.625	24.69	24.61	24.65	9531870.0
2011-05-16 15:00:00	MSFT	Stock	24.64	24.71	24.5	24.58	18494854.0
2011-05-16 16:00:00	MSFT	Stock	24.57	24.802	24.52	24.52	11677316.0
2011-05-16 17:00:00	MSFT	Stock	24.882	24.882	24.46	24.46	53375.0
2011-05-16 18:00:00	MSFT	Stock	24.5	24.57	24.47	24.48	50880.0
2011-05-16 19:00:00	MSFT	Stock	24.48	24.52	24.41	24.43	46569.0
2011-05-16 08:00:00	NVDA	Stock	0.4558	0.456	0.4528	0.455	618640.0
2011-05-16 09:00:00	NVDA	Stock	0.455	0.4562	0.4422	0.4458	173958360.0
2011-05-16 10:00:00	NVDA	Stock	0.4455	0.4512	0.443	0.4511	165541240.0
2011-05-16 11:00:00	NVDA	Stock	0.4512	0.454	0.4498	0.4519	66338760.0
2011-05-16 12:00:00	NVDA	Stock	0.4518	0.4518	0.446	0.4462	59468120.0
2011-05-16 13:00:00	NVDA	Stock	0.446	0.4498	0.446	0.4492	49034040.0
2011-05-16 14:00:00	NVDA	Stock	0.4493	0.4494	0.4432	0.4449	70170640.0
2011-05-16 15:00:00	NVDA	Stock	0.4449	0.446	0.4425	0.4428	120831880.0
2011-05-16 16:00:00	NVDA	Stock	0.4432	0.4471	0.4415	0.4415	4789000.0
2011-05-16 17:00:00	NVDA	Stock	0.4425	0.4425	0.4422	0.4422	61400.0
2011-05-16 18:00:00	NVDA	Stock	0.442	0.4428	0.442	0.4428	285600.0
2011-05-16 19:00:00	NVDA	Stock	0.4428	0.4428	0.4412	0.4425	410400.0
2011-05-16 05:00:00	AMZN	Stock	10.075	10.075	10.075	10.075	12000.0
2011-05-16 06:00:00	AMZN	Stock	10.075	10.075	10.0	10.0	24000.0
2011-05-16 07:00:00	AMZN	Stock	10.0	10.0445	9.999	10.0445	112460.0
2011-05-16 08:00:00	AMZN	Stock	10.026	10.055	10.026	10.0375	121020.0
2011-05-16 09:00:00	AMZN	Stock	10.0495	10.07	9.865	9.8905	20180360.0
2011-05-16 10:00:00	AMZN	Stock	9.8922	9.9465	9.856	9.8965	20945780.0
2011-05-16 11:00:00	AMZN	Stock	9.899	9.9165	9.8565	9.865	12563520.0
2011-05-16 12:00:00	AMZN	Stock	9.8647	9.885	9.806	9.814	20602240.0
2011-05-16 13:00:00	AMZN	Stock	9.814	9.814	9.7315	9.7425	24554680.0

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

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