PREVIEW / stock_1hour / 2012-02-07

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-02-07.parquet
  size:    947 KB
  rows:    44,652
  symbols: 3,533

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-07 04:00:00	AAPL	Stock	16.6071	16.6071	16.6068	16.6071	44800.0
2012-02-07 05:00:00	AAPL	Stock	16.62	16.62	16.62	16.62	2800.0
2012-02-07 06:00:00	AAPL	Stock	16.6071	16.6071	16.5982	16.5982	63112.0
2012-02-07 07:00:00	AAPL	Stock	16.5907	16.5961	16.5589	16.5714	165452.0
2012-02-07 08:00:00	AAPL	Stock	16.5854	16.6232	16.5357	16.5889	1127280.0
2012-02-07 09:00:00	AAPL	Stock	16.5893	16.675	16.5893	16.6285	53520992.0
2012-02-07 10:00:00	AAPL	Stock	16.6282	16.6964	16.6071	16.6918	48823208.0
2012-02-07 11:00:00	AAPL	Stock	16.6939	16.7654	16.679	16.7517	51561048.0
2012-02-07 12:00:00	AAPL	Stock	16.7518	16.7736	16.7379	16.7625	29277864.0
2012-02-07 13:00:00	AAPL	Stock	16.7636	16.7675	16.7096	16.7355	33237260.0
2012-02-07 14:00:00	AAPL	Stock	16.7357	16.7768	16.7196	16.7486	32772096.0
2012-02-07 15:00:00	AAPL	Stock	16.7489	16.7714	16.72	16.7432	55279560.0
2012-02-07 16:00:00	AAPL	Stock	16.7311	16.7651	16.6841	16.7393	5155220.0
2012-02-07 17:00:00	AAPL	Stock	16.7389	16.7446	16.7389	16.7443	96768.0
2012-02-07 18:00:00	AAPL	Stock	16.7375	16.7421	16.735	16.7421	70868.0
2012-02-07 19:00:00	AAPL	Stock	16.7425	16.7468	16.7357	16.7379	356188.0
2012-02-07 04:00:00	MSFT	Stock	30.2	30.2	30.2	30.2	250.0
2012-02-07 05:00:00	MSFT	Stock	30.2	30.2	30.2	30.2	1200.0
2012-02-07 07:00:00	MSFT	Stock	30.13	30.15	30.1	30.14	2480.0
2012-02-07 08:00:00	MSFT	Stock	30.05	30.19	30.05	30.09	8339.0
2012-02-07 09:00:00	MSFT	Stock	30.09	30.2	30.02	30.132	4157931.0
2012-02-07 10:00:00	MSFT	Stock	30.14	30.32	30.05	30.31	6402093.0
2012-02-07 11:00:00	MSFT	Stock	30.315	30.46	30.27	30.448	7255201.0
2012-02-07 12:00:00	MSFT	Stock	30.448	30.485	30.42	30.453	4025165.0
2012-02-07 13:00:00	MSFT	Stock	30.45	30.48	30.4	30.47	3645591.0
2012-02-07 14:00:00	MSFT	Stock	30.47	30.48	30.29	30.3	3967809.0
2012-02-07 15:00:00	MSFT	Stock	30.305	30.43	30.3	30.36	7305191.0
2012-02-07 16:00:00	MSFT	Stock	30.36	30.47	30.172	30.35	2211944.0
2012-02-07 17:00:00	MSFT	Stock	30.35	30.36	30.33	30.33	3023.0
2012-02-07 18:00:00	MSFT	Stock	30.33	30.35	30.33	30.33	1016.0
2012-02-07 19:00:00	MSFT	Stock	30.35	30.35	30.35	30.35	200.0
2012-02-07 06:00:00	NVDA	Stock	0.3925	0.3925	0.3925	0.3925	4000.0
2012-02-07 09:00:00	NVDA	Stock	0.3938	0.3938	0.3868	0.3877	53649400.0
2012-02-07 10:00:00	NVDA	Stock	0.3878	0.3908	0.3865	0.3898	79617840.0
2012-02-07 11:00:00	NVDA	Stock	0.3898	0.3938	0.3898	0.3928	58160280.0
2012-02-07 12:00:00	NVDA	Stock	0.3926	0.394	0.3925	0.3938	36888320.0
2012-02-07 13:00:00	NVDA	Stock	0.3937	0.3938	0.391	0.3928	27354680.0
2012-02-07 14:00:00	NVDA	Stock	0.3928	0.394	0.3918	0.3933	34724960.0
2012-02-07 15:00:00	NVDA	Stock	0.393	0.3958	0.393	0.3938	102836400.0
2012-02-07 16:00:00	NVDA	Stock	0.3935	0.395	0.3916	0.3935	16564280.0
2012-02-07 17:00:00	NVDA	Stock	0.3935	0.3935	0.3935	0.3935	4000.0
2012-02-07 19:00:00	NVDA	Stock	0.394	0.394	0.394	0.394	8000.0
2012-02-07 07:00:00	AMZN	Stock	9.13	9.13	9.13	9.13	2000.0
2012-02-07 08:00:00	AMZN	Stock	9.144	9.1815	9.12	9.143	129480.0
2012-02-07 09:00:00	AMZN	Stock	9.1475	9.247	9.103	9.2175	19010180.0
2012-02-07 10:00:00	AMZN	Stock	9.2168	9.2335	9.129	9.2325	16649120.0
2012-02-07 11:00:00	AMZN	Stock	9.2325	9.24	9.18	9.183	9012320.0
2012-02-07 12:00:00	AMZN	Stock	9.182	9.2085	9.181	9.2015	12049540.0
2012-02-07 13:00:00	AMZN	Stock	9.2001	9.2165	9.151	9.212	11578600.0
2012-02-07 14:00:00	AMZN	Stock	9.2145	9.2415	9.202	9.2055	14269880.0

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

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