PREVIEW / stock_1hour / 2012-08-24

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-08-24.parquet
  size:    903 KB
  rows:    42,679
  symbols: 3,445

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-08-24 04:00:00	AAPL	Stock	23.6786	23.6786	23.5939	23.5939	11200.0
2012-08-24 06:00:00	AAPL	Stock	23.625	23.625	23.5929	23.6079	16800.0
2012-08-24 07:00:00	AAPL	Stock	23.625	23.6525	23.525	23.6339	376488.0
2012-08-24 08:00:00	AAPL	Stock	23.6261	23.6521	23.5296	23.5307	2801120.0
2012-08-24 09:00:00	AAPL	Stock	23.5389	23.6139	23.4125	23.4893	75703516.0
2012-08-24 10:00:00	AAPL	Stock	23.4896	23.7886	23.4804	23.7146	91042140.0
2012-08-24 11:00:00	AAPL	Stock	23.7204	23.8161	23.6946	23.787	54473356.0
2012-08-24 12:00:00	AAPL	Stock	23.7854	23.91	23.7654	23.9068	43057728.0
2012-08-24 13:00:00	AAPL	Stock	23.9096	23.91	23.8057	23.825	42527352.0
2012-08-24 14:00:00	AAPL	Stock	23.8281	23.8496	23.7929	23.805	20042764.0
2012-08-24 15:00:00	AAPL	Stock	23.8064	23.8071	23.6218	23.685	83092072.0
2012-08-24 16:00:00	AAPL	Stock	23.6911	23.8331	23.6464	23.6968	9519608.0
2012-08-24 17:00:00	AAPL	Stock	23.6971	23.6971	23.6679	23.6932	400960.0
2012-08-24 18:00:00	AAPL	Stock	23.6932	24.0086	23.6932	24.0	2668484.0
2012-08-24 19:00:00	AAPL	Stock	24.0	24.1407	23.9646	24.1054	6284852.0
2012-08-24 08:00:00	MSFT	Stock	30.07	30.25	30.07	30.16	5950.0
2012-08-24 09:00:00	MSFT	Stock	30.13	30.29	30.13	30.2	2748101.0
2012-08-24 10:00:00	MSFT	Stock	30.2	30.455	30.195	30.4	3777484.0
2012-08-24 11:00:00	MSFT	Stock	30.4	30.53	30.37	30.39	3360413.0
2012-08-24 12:00:00	MSFT	Stock	30.395	30.48	30.38	30.465	2094746.0
2012-08-24 13:00:00	MSFT	Stock	30.466	30.57	30.405	30.523	2256362.0
2012-08-24 14:00:00	MSFT	Stock	30.52	30.54	30.46	30.48	1814037.0
2012-08-24 15:00:00	MSFT	Stock	30.485	30.63	30.46	30.56	5015761.0
2012-08-24 16:00:00	MSFT	Stock	30.56	30.58	30.425	30.56	1734900.0
2012-08-24 17:00:00	MSFT	Stock	30.51	30.56	30.51	30.56	6290.0
2012-08-24 18:00:00	MSFT	Stock	30.51	30.51	30.5	30.5	1000.0
2012-08-24 19:00:00	MSFT	Stock	30.56	30.6	30.56	30.59	6820.0
2012-08-24 07:00:00	NVDA	Stock	0.3575	0.3575	0.3575	0.3575	20000.0
2012-08-24 08:00:00	NVDA	Stock	0.3575	0.3575	0.3568	0.3568	20000.0
2012-08-24 09:00:00	NVDA	Stock	0.3568	0.3595	0.3565	0.3586	30353360.0
2012-08-24 10:00:00	NVDA	Stock	0.3585	0.3622	0.3578	0.3605	40414360.0
2012-08-24 11:00:00	NVDA	Stock	0.3608	0.3638	0.3606	0.3622	44803120.0
2012-08-24 12:00:00	NVDA	Stock	0.3622	0.3645	0.3622	0.3645	25295320.0
2012-08-24 13:00:00	NVDA	Stock	0.3642	0.3655	0.3638	0.3639	44507800.0
2012-08-24 14:00:00	NVDA	Stock	0.3639	0.3648	0.3635	0.3648	28608720.0
2012-08-24 15:00:00	NVDA	Stock	0.3648	0.3668	0.3645	0.3648	77396200.0
2012-08-24 16:00:00	NVDA	Stock	0.365	0.3661	0.3631	0.3661	54458840.0
2012-08-24 17:00:00	NVDA	Stock	0.366	0.366	0.366	0.366	40000.0
2012-08-24 18:00:00	NVDA	Stock	0.366	0.366	0.366	0.366	64000.0
2012-08-24 07:00:00	AMZN	Stock	12.05	12.055	12.049	12.055	16000.0
2012-08-24 08:00:00	AMZN	Stock	12.06	12.09	12.06	12.065	133700.0
2012-08-24 09:00:00	AMZN	Stock	12.0615	12.205	12.0565	12.201	11718500.0
2012-08-24 10:00:00	AMZN	Stock	12.2008	12.3435	12.175	12.3301	20919400.0
2012-08-24 11:00:00	AMZN	Stock	12.3325	12.3425	12.277	12.3287	10956640.0
2012-08-24 12:00:00	AMZN	Stock	12.327	12.34	12.3	12.3345	6353440.0
2012-08-24 13:00:00	AMZN	Stock	12.333	12.34	12.2815	12.314	5818140.0
2012-08-24 14:00:00	AMZN	Stock	12.3121	12.3135	12.277	12.2795	4455260.0
2012-08-24 15:00:00	AMZN	Stock	12.2795	12.3035	12.262	12.2835	11627500.0
2012-08-24 16:00:00	AMZN	Stock	12.287	12.3099	12.281	12.287	1816380.0
2012-08-24 17:00:00	AMZN	Stock	12.292	12.292	12.292	12.292	2600.0

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

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