PREVIEW / stock_1hour / 2012-11-30

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-11-30.parquet
  size:    957 KB
  rows:    44,804
  symbols: 3,483

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-11-30 04:00:00	AAPL	Stock	21.0014	21.0625	21.0014	21.0625	56980.0
2012-11-30 05:00:00	AAPL	Stock	21.045	21.0536	21.045	21.0536	9800.0
2012-11-30 06:00:00	AAPL	Stock	21.0636	21.0636	21.0357	21.0429	46564.0
2012-11-30 07:00:00	AAPL	Stock	21.0411	21.0964	21.0261	21.0739	777952.0
2012-11-30 08:00:00	AAPL	Stock	21.0721	21.0893	20.9518	20.9664	1915928.0
2012-11-30 09:00:00	AAPL	Stock	20.9643	21.0143	20.8807	20.9436	51484384.0
2012-11-30 10:00:00	AAPL	Stock	20.9393	20.9839	20.8518	20.905	55893992.0
2012-11-30 11:00:00	AAPL	Stock	20.9078	20.9189	20.8296	20.8911	39753196.0
2012-11-30 12:00:00	AAPL	Stock	20.8921	20.9164	20.81	20.8409	34196064.0
2012-11-30 13:00:00	AAPL	Stock	20.8443	20.8914	20.8218	20.8865	24677492.0
2012-11-30 14:00:00	AAPL	Stock	20.8868	20.9157	20.8393	20.8479	27546820.0
2012-11-30 15:00:00	AAPL	Stock	20.8432	20.9021	20.8214	20.8921	77104580.0
2012-11-30 16:00:00	AAPL	Stock	20.8929	20.9551	20.8401	20.9043	28993496.0
2012-11-30 17:00:00	AAPL	Stock	20.8989	20.9029	20.8921	20.9029	905492.0
2012-11-30 18:00:00	AAPL	Stock	20.9032	20.9196	20.9007	20.9175	366744.0
2012-11-30 19:00:00	AAPL	Stock	20.9168	20.9425	20.9146	20.9393	387884.0
2012-11-30 04:00:00	MSFT	Stock	26.9	26.9	26.9	26.9	100.0
2012-11-30 07:00:00	MSFT	Stock	27.0	27.05	26.95	27.0	16950.0
2012-11-30 08:00:00	MSFT	Stock	27.0	27.05	26.95	27.0	94019.0
2012-11-30 09:00:00	MSFT	Stock	27.0	27.13	26.81	26.815	5851802.0
2012-11-30 10:00:00	MSFT	Stock	26.815	26.85	26.66	26.735	15192320.0
2012-11-30 11:00:00	MSFT	Stock	26.735	26.75	26.59	26.605	8738531.0
2012-11-30 12:00:00	MSFT	Stock	26.61	26.63	26.49	26.545	9465698.0
2012-11-30 13:00:00	MSFT	Stock	26.548	26.59	26.5	26.57	6754035.0
2012-11-30 14:00:00	MSFT	Stock	26.565	26.64	26.54	26.54	6215861.0
2012-11-30 15:00:00	MSFT	Stock	26.55	26.71	26.52	26.625	16374519.0
2012-11-30 16:00:00	MSFT	Stock	26.59	26.986	26.53	26.63	11432379.0
2012-11-30 17:00:00	MSFT	Stock	26.63	26.65	26.549	26.65	22021.0
2012-11-30 18:00:00	MSFT	Stock	26.65	26.65	26.219	26.61	4290.0
2012-11-30 19:00:00	MSFT	Stock	26.64	26.65	26.6	26.65	12294.0
2012-11-30 09:00:00	NVDA	Stock	0.3008	0.3014	0.2975	0.2995	49596800.0
2012-11-30 10:00:00	NVDA	Stock	0.2996	0.302	0.299	0.302	49848080.0
2012-11-30 11:00:00	NVDA	Stock	0.302	0.303	0.2995	0.302	46803480.0
2012-11-30 12:00:00	NVDA	Stock	0.3019	0.303	0.3008	0.3012	45022280.0
2012-11-30 13:00:00	NVDA	Stock	0.3015	0.3025	0.3008	0.3022	37762280.0
2012-11-30 14:00:00	NVDA	Stock	0.3025	0.303	0.2985	0.2988	42822720.0
2012-11-30 15:00:00	NVDA	Stock	0.2988	0.2998	0.2978	0.2995	130106920.0
2012-11-30 16:00:00	NVDA	Stock	0.2995	0.3014	0.2985	0.2996	44436520.0
2012-11-30 17:00:00	NVDA	Stock	0.2988	0.2995	0.2988	0.2995	200000.0
2012-11-30 18:00:00	NVDA	Stock	0.2995	0.2995	0.2995	0.2995	16000.0
2012-11-30 05:00:00	AMZN	Stock	12.6	12.6	12.6	12.6	2000.0
2012-11-30 06:00:00	AMZN	Stock	12.6	12.6	12.6	12.6	2000.0
2012-11-30 07:00:00	AMZN	Stock	12.62	12.62	12.585	12.59	135540.0
2012-11-30 08:00:00	AMZN	Stock	12.6225	12.6225	12.5195	12.5195	352060.0
2012-11-30 09:00:00	AMZN	Stock	12.5195	12.547	12.441	12.481	11054760.0
2012-11-30 10:00:00	AMZN	Stock	12.4894	12.5	12.4345	12.478	9419080.0
2012-11-30 11:00:00	AMZN	Stock	12.478	12.5	12.4135	12.4845	7723380.0
2012-11-30 12:00:00	AMZN	Stock	12.488	12.5235	12.4515	12.4653	6522600.0
2012-11-30 13:00:00	AMZN	Stock	12.47	12.505	12.4665	12.5015	3988180.0
2012-11-30 14:00:00	AMZN	Stock	12.498	12.5425	12.493	12.526	12467140.0

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

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