PREVIEW / stock_1hour / 2010-07-15

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-07-15.parquet
  size:    877 KB
  rows:    42,009
  symbols: 3,435

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
2010-07-15 06:00:00	AAPL	Stock	8.9736	9.0179	8.9721	9.0179	30800.0
2010-07-15 07:00:00	AAPL	Stock	9.0	9.0268	8.9304	8.9643	1185688.0
2010-07-15 08:00:00	AAPL	Stock	8.9679	9.0079	8.9571	8.9779	4337732.0
2010-07-15 09:00:00	AAPL	Stock	8.9764	8.9957	8.8321	8.9137	171620764.0
2010-07-15 10:00:00	AAPL	Stock	8.9137	8.925	8.8382	8.9	165535580.0
2010-07-15 11:00:00	AAPL	Stock	8.8977	8.9114	8.8793	8.8871	64895740.0
2010-07-15 12:00:00	AAPL	Stock	8.8882	8.9184	8.8611	8.8681	56162204.0
2010-07-15 13:00:00	AAPL	Stock	8.8693	8.9143	8.8689	8.8879	50904280.0
2010-07-15 14:00:00	AAPL	Stock	8.8879	8.9832	8.8811	8.9493	92122100.0
2010-07-15 15:00:00	AAPL	Stock	8.9493	9.1775	8.9096	8.975	194394844.0
2010-07-15 16:00:00	AAPL	Stock	8.9796	9.0075	8.8542	8.9929	16172268.0
2010-07-15 17:00:00	AAPL	Stock	9.0	9.0793	8.9968	9.0754	2261532.0
2010-07-15 18:00:00	AAPL	Stock	9.0754	9.0889	8.9804	9.0596	2219588.0
2010-07-15 19:00:00	AAPL	Stock	9.0607	9.0607	9.025	9.0257	815388.0
2010-07-15 04:00:00	MSFT	Stock	25.45	25.45	25.45	25.45	200.0
2010-07-15 06:00:00	MSFT	Stock	25.5	25.5	25.44	25.44	500.0
2010-07-15 07:00:00	MSFT	Stock	25.44	25.54	25.44	25.54	1900.0
2010-07-15 08:00:00	MSFT	Stock	25.52	25.6	25.45	25.52	31490.0
2010-07-15 09:00:00	MSFT	Stock	25.51	25.58	25.235	25.378	5720367.0
2010-07-15 10:00:00	MSFT	Stock	25.38	25.38	24.98	25.15	9687975.0
2010-07-15 11:00:00	MSFT	Stock	25.15	25.41	24.98	25.375	10758122.0
2010-07-15 12:00:00	MSFT	Stock	25.37	25.46	25.29	25.36	6948725.0
2010-07-15 13:00:00	MSFT	Stock	25.355	25.49	25.355	25.39	3619247.0
2010-07-15 14:00:00	MSFT	Stock	25.4	25.47	25.33	25.345	4555671.0
2010-07-15 15:00:00	MSFT	Stock	25.35	25.59	25.26	25.52	12851919.0
2010-07-15 16:00:00	MSFT	Stock	25.51	25.56	25.322	25.48	2151048.0
2010-07-15 17:00:00	MSFT	Stock	25.336	25.52	25.336	25.51	67115.0
2010-07-15 18:00:00	MSFT	Stock	25.5	25.51	25.48	25.48	14009.0
2010-07-15 08:00:00	NVDA	Stock	0.275	0.2775	0.275	0.2768	700000.0
2010-07-15 09:00:00	NVDA	Stock	0.2768	0.2768	0.2703	0.2708	112237840.0
2010-07-15 10:00:00	NVDA	Stock	0.2705	0.2706	0.265	0.2665	210354600.0
2010-07-15 11:00:00	NVDA	Stock	0.2663	0.269	0.2648	0.2678	84351400.0
2010-07-15 12:00:00	NVDA	Stock	0.268	0.2685	0.2663	0.2678	108982680.0
2010-07-15 13:00:00	NVDA	Stock	0.2678	0.27	0.2675	0.269	61317120.0
2010-07-15 14:00:00	NVDA	Stock	0.2688	0.27	0.2678	0.2685	91610400.0
2010-07-15 15:00:00	NVDA	Stock	0.2688	0.2695	0.2668	0.268	264475120.0
2010-07-15 16:00:00	NVDA	Stock	0.268	0.2692	0.2665	0.269	14076720.0
2010-07-15 17:00:00	NVDA	Stock	0.2683	0.2732	0.2678	0.2732	3392480.0
2010-07-15 18:00:00	NVDA	Stock	0.2685	0.2705	0.268	0.2683	932760.0
2010-07-15 19:00:00	NVDA	Stock	0.2683	0.27	0.268	0.27	227720.0
2010-07-15 06:00:00	AMZN	Stock	6.05	6.1	6.025	6.025	39040.0
2010-07-15 07:00:00	AMZN	Stock	6.0265	6.0395	5.97	5.995	553640.0
2010-07-15 08:00:00	AMZN	Stock	5.997	6.0425	5.985	6.0085	993980.0
2010-07-15 09:00:00	AMZN	Stock	6.012	6.045	5.963	6.0295	28871080.0
2010-07-15 10:00:00	AMZN	Stock	6.028	6.042	5.989	6.012	24716720.0
2010-07-15 11:00:00	AMZN	Stock	6.015	6.06	5.9975	6.033	12070420.0
2010-07-15 12:00:00	AMZN	Stock	6.0325	6.0475	6.016	6.0325	7184780.0
2010-07-15 13:00:00	AMZN	Stock	6.0325	6.0735	6.0325	6.0465	7644460.0
2010-07-15 14:00:00	AMZN	Stock	6.0465	6.0865	6.032	6.0685	13602940.0
2010-07-15 15:00:00	AMZN	Stock	6.0695	6.124	6.033	6.1	21480920.0

> showing 50 of 42,009 rows — these rows as CSV

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