PREVIEW / stock_1hour / 2011-08-18

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-08-18.parquet
  size:    950 KB
  rows:    45,614
  symbols: 3,548

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-08-18 04:00:00	AAPL	Stock	13.5154	13.5154	13.4114	13.4114	8400.0
2011-08-18 05:00:00	AAPL	Stock	13.3825	13.3921	13.2682	13.3921	89572.0
2011-08-18 06:00:00	AAPL	Stock	13.3875	13.3929	13.3804	13.3846	28000.0
2011-08-18 07:00:00	AAPL	Stock	13.4032	13.4354	13.3536	13.3714	775376.0
2011-08-18 08:00:00	AAPL	Stock	13.3786	13.425	13.3236	13.325	4016628.0
2011-08-18 09:00:00	AAPL	Stock	13.3239	13.3321	13.0761	13.1668	150021844.0
2011-08-18 10:00:00	AAPL	Stock	13.1661	13.1661	13.0536	13.145	139493676.0
2011-08-18 11:00:00	AAPL	Stock	13.1491	13.1864	13.1161	13.1741	89948376.0
2011-08-18 12:00:00	AAPL	Stock	13.1746	13.2028	13.1361	13.1621	61586672.0
2011-08-18 13:00:00	AAPL	Stock	13.1607	13.1689	13.0082	13.0236	94213140.0
2011-08-18 14:00:00	AAPL	Stock	13.0246	13.0996	12.9432	12.9486	97549844.0
2011-08-18 15:00:00	AAPL	Stock	12.9525	13.1214	12.9061	13.0661	188655768.0
2011-08-18 16:00:00	AAPL	Stock	13.1144	13.116	12.9548	13.0964	18617648.0
2011-08-18 17:00:00	AAPL	Stock	13.0946	13.1246	13.0732	13.1071	663908.0
2011-08-18 18:00:00	AAPL	Stock	13.1107	13.1132	13.0732	13.1071	422324.0
2011-08-18 19:00:00	AAPL	Stock	13.1029	13.1357	13.0954	13.1018	524020.0
2011-08-18 04:00:00	MSFT	Stock	25.05	25.05	24.93	24.93	200.0
2011-08-18 05:00:00	MSFT	Stock	24.81	24.81	24.69	24.74	3000.0
2011-08-18 06:00:00	MSFT	Stock	24.7	24.7	24.7	24.7	2000.0
2011-08-18 07:00:00	MSFT	Stock	24.75	24.79	24.66	24.7	8896.0
2011-08-18 08:00:00	MSFT	Stock	24.71	24.75	24.58	24.6	56593.0
2011-08-18 09:00:00	MSFT	Stock	24.6	24.88	24.5	24.51	10973488.0
2011-08-18 10:00:00	MSFT	Stock	24.51	24.515	24.03	24.41	18476978.0
2011-08-18 11:00:00	MSFT	Stock	24.41	24.92	24.25	24.885	13439107.0
2011-08-18 12:00:00	MSFT	Stock	24.88	25.09	24.78	24.812	13793936.0
2011-08-18 13:00:00	MSFT	Stock	24.81	24.845	24.7	24.81	7429663.0
2011-08-18 14:00:00	MSFT	Stock	24.81	25.02	24.75	24.75	10419483.0
2011-08-18 15:00:00	MSFT	Stock	24.755	24.84	24.45	24.68	24029088.0
2011-08-18 16:00:00	MSFT	Stock	24.68	24.79	24.48	24.67	6340187.0
2011-08-18 17:00:00	MSFT	Stock	24.68	24.74	24.67	24.74	20265.0
2011-08-18 18:00:00	MSFT	Stock	24.67	24.7	24.65	24.69	30043.0
2011-08-18 19:00:00	MSFT	Stock	24.7	24.7	24.67	24.67	700.0
2011-08-18 08:00:00	NVDA	Stock	0.315	0.315	0.3065	0.309	841400.0
2011-08-18 09:00:00	NVDA	Stock	0.3083	0.309	0.3028	0.307	91589480.0
2011-08-18 10:00:00	NVDA	Stock	0.3065	0.3068	0.3012	0.306	185192520.0
2011-08-18 11:00:00	NVDA	Stock	0.3062	0.3068	0.3025	0.3042	72530720.0
2011-08-18 12:00:00	NVDA	Stock	0.3042	0.306	0.3005	0.3025	72129680.0
2011-08-18 13:00:00	NVDA	Stock	0.3022	0.3025	0.3	0.3002	61703240.0
2011-08-18 14:00:00	NVDA	Stock	0.3001	0.3028	0.2982	0.2985	86161360.0
2011-08-18 15:00:00	NVDA	Stock	0.2984	0.3	0.295	0.2988	180522920.0
2011-08-18 16:00:00	NVDA	Stock	0.2988	0.3028	0.2956	0.2985	14132040.0
2011-08-18 17:00:00	NVDA	Stock	0.3008	0.302	0.3008	0.302	411520.0
2011-08-18 18:00:00	NVDA	Stock	0.3015	0.3018	0.2985	0.3	246040.0
2011-08-18 19:00:00	NVDA	Stock	0.3012	0.3018	0.2988	0.3008	214000.0
2011-08-18 04:00:00	AMZN	Stock	9.74	9.74	9.699	9.699	6000.0
2011-08-18 07:00:00	AMZN	Stock	9.65	9.651	9.65	9.651	26000.0
2011-08-18 08:00:00	AMZN	Stock	9.649	9.659	9.538	9.547	314660.0
2011-08-18 09:00:00	AMZN	Stock	9.547	9.573	9.458	9.494	19150500.0
2011-08-18 10:00:00	AMZN	Stock	9.4905	9.4938	9.29	9.386	27561780.0
2011-08-18 11:00:00	AMZN	Stock	9.3865	9.403	9.327	9.3765	12381080.0

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

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