PREVIEW / stock_1hour / 2012-02-15

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-02-15.parquet
  size:    959 KB
  rows:    45,470
  symbols: 3,536

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
2012-02-15 04:00:00	AAPL	Stock	18.2982	18.5243	18.2982	18.4493	158060.0
2012-02-15 05:00:00	AAPL	Stock	18.4554	18.4893	18.4325	18.4561	95900.0
2012-02-15 06:00:00	AAPL	Stock	18.4536	18.4604	18.4429	18.4532	355012.0
2012-02-15 07:00:00	AAPL	Stock	18.4393	18.4536	18.3929	18.4143	2051476.0
2012-02-15 08:00:00	AAPL	Stock	18.4143	18.4604	18.2786	18.2789	8359148.0
2012-02-15 09:00:00	AAPL	Stock	18.2814	18.5196	18.2768	18.4904	142288244.0
2012-02-15 10:00:00	AAPL	Stock	18.4875	18.7457	18.4804	18.6646	218901956.0
2012-02-15 11:00:00	AAPL	Stock	18.6646	18.7961	18.6504	18.7861	130322724.0
2012-02-15 12:00:00	AAPL	Stock	18.7886	18.7886	18.0989	18.1814	309728692.0
2012-02-15 13:00:00	AAPL	Stock	18.1821	18.35	17.9314	18.2675	238733460.0
2012-02-15 14:00:00	AAPL	Stock	18.2675	18.2857	17.9857	18.0093	145304460.0
2012-02-15 15:00:00	AAPL	Stock	18.005	18.0157	17.7461	17.7704	276118136.0
2012-02-15 16:00:00	AAPL	Stock	17.7636	18.7684	17.76	17.7857	18532948.0
2012-02-15 17:00:00	AAPL	Stock	17.7871	17.7893	17.6079	17.6857	5289648.0
2012-02-15 18:00:00	AAPL	Stock	17.6911	17.6964	17.6429	17.6475	2328984.0
2012-02-15 19:00:00	AAPL	Stock	17.6482	17.6568	17.6204	17.6361	1515332.0
2012-02-15 04:00:00	MSFT	Stock	30.32	30.32	30.32	30.32	800.0
2012-02-15 05:00:00	MSFT	Stock	30.4	30.4	30.4	30.4	100.0
2012-02-15 06:00:00	MSFT	Stock	30.46	30.46	30.46	30.46	920.0
2012-02-15 07:00:00	MSFT	Stock	30.39	30.42	30.33	30.38	9206.0
2012-02-15 08:00:00	MSFT	Stock	30.34	30.39	30.31	30.33	30450.0
2012-02-15 09:00:00	MSFT	Stock	30.34	30.39	30.12	30.235	5439857.0
2012-02-15 10:00:00	MSFT	Stock	30.24	30.38	30.22	30.285	5649051.0
2012-02-15 11:00:00	MSFT	Stock	30.29	30.36	30.245	30.328	4315912.0
2012-02-15 12:00:00	MSFT	Stock	30.33	30.34	30.12	30.21	5215870.0
2012-02-15 13:00:00	MSFT	Stock	30.21	30.225	30.11	30.22	5453566.0
2012-02-15 14:00:00	MSFT	Stock	30.215	30.25	30.06	30.07	5067714.0
2012-02-15 15:00:00	MSFT	Stock	30.06	30.16	30.03	30.05	8302205.0
2012-02-15 16:00:00	MSFT	Stock	30.05	30.305	30.0	30.04	2037029.0
2012-02-15 17:00:00	MSFT	Stock	30.03	30.03	30.02	30.02	2750.0
2012-02-15 18:00:00	MSFT	Stock	30.02	30.02	30.01	30.01	1800.0
2012-02-15 19:00:00	MSFT	Stock	30.0	30.0	29.95	29.95	3897.0
2012-02-15 08:00:00	NVDA	Stock	0.4122	0.413	0.4095	0.4095	812000.0
2012-02-15 09:00:00	NVDA	Stock	0.4122	0.4225	0.4098	0.4169	167995800.0
2012-02-15 10:00:00	NVDA	Stock	0.4168	0.419	0.4062	0.4062	229574160.0
2012-02-15 11:00:00	NVDA	Stock	0.4062	0.4115	0.4062	0.4098	125194280.0
2012-02-15 12:00:00	NVDA	Stock	0.4098	0.4099	0.405	0.4062	86200160.0
2012-02-15 13:00:00	NVDA	Stock	0.4062	0.4085	0.4032	0.4077	80050760.0
2012-02-15 14:00:00	NVDA	Stock	0.4078	0.4082	0.4043	0.405	78770440.0
2012-02-15 15:00:00	NVDA	Stock	0.4049	0.4072	0.4035	0.4043	241403400.0
2012-02-15 16:00:00	NVDA	Stock	0.4043	0.4108	0.38	0.3875	47590160.0
2012-02-15 17:00:00	NVDA	Stock	0.3868	0.3875	0.3815	0.3838	8609000.0
2012-02-15 18:00:00	NVDA	Stock	0.3845	0.3862	0.3815	0.3825	2632040.0
2012-02-15 19:00:00	NVDA	Stock	0.382	0.3848	0.3813	0.3825	880200.0
2012-02-15 07:00:00	AMZN	Stock	9.6125	9.6375	9.609	9.61	42000.0
2012-02-15 08:00:00	AMZN	Stock	9.623	9.6315	9.57	9.5895	213380.0
2012-02-15 09:00:00	AMZN	Stock	9.59	9.6145	9.475	9.511	13225420.0
2012-02-15 10:00:00	AMZN	Stock	9.511	9.52	9.4515	9.4948	13789560.0
2012-02-15 11:00:00	AMZN	Stock	9.5	9.565	9.487	9.509	13896240.0
2012-02-15 12:00:00	AMZN	Stock	9.511	9.511	9.3175	9.339	30181960.0

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

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