PREVIEW / stock_1hour / 2011-10-26

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-10-26.parquet
  size:    921 KB
  rows:    43,930
  symbols: 3,493

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-10-26 04:00:00	AAPL	Stock	14.2336	14.3214	14.2336	14.2643	43484.0
2011-10-26 05:00:00	AAPL	Stock	14.2661	14.2661	14.25	14.25	14000.0
2011-10-26 06:00:00	AAPL	Stock	14.2786	14.2786	14.2786	14.2786	2800.0
2011-10-26 07:00:00	AAPL	Stock	14.2854	14.2996	14.2639	14.2786	547288.0
2011-10-26 08:00:00	AAPL	Stock	14.2746	14.3368	14.2579	14.3186	3085040.0
2011-10-26 09:00:00	AAPL	Stock	14.3229	14.3786	14.2786	14.3104	53704308.0
2011-10-26 10:00:00	AAPL	Stock	14.3143	14.3175	14.0411	14.0841	80756116.0
2011-10-26 11:00:00	AAPL	Stock	14.085	14.2143	14.0639	14.1789	55468280.0
2011-10-26 12:00:00	AAPL	Stock	14.1821	14.2082	14.1096	14.12	29495396.0
2011-10-26 13:00:00	AAPL	Stock	14.1204	14.2589	14.0768	14.2496	55237728.0
2011-10-26 14:00:00	AAPL	Stock	14.249	14.3093	14.2361	14.2589	58370564.0
2011-10-26 15:00:00	AAPL	Stock	14.2582	14.3425	14.25	14.2971	80123820.0
2011-10-26 16:00:00	AAPL	Stock	14.3104	14.3282	14.2326	14.3057	35065408.0
2011-10-26 17:00:00	AAPL	Stock	14.3254	14.3432	14.3071	14.3214	389032.0
2011-10-26 18:00:00	AAPL	Stock	14.3214	14.3221	14.3071	14.3168	187208.0
2011-10-26 19:00:00	AAPL	Stock	14.3168	14.3429	14.3168	14.3393	375592.0
2011-10-26 07:00:00	MSFT	Stock	27.0	27.0	26.96	26.96	4600.0
2011-10-26 08:00:00	MSFT	Stock	26.96	27.0	26.92	26.99	23093.0
2011-10-26 09:00:00	MSFT	Stock	26.95	27.06	26.84	26.94	5378271.0
2011-10-26 10:00:00	MSFT	Stock	26.946	26.95	26.1	26.155	12070564.0
2011-10-26 11:00:00	MSFT	Stock	26.155	26.5	26.1	26.33	8905529.0
2011-10-26 12:00:00	MSFT	Stock	26.338	26.43	26.285	26.294	5333383.0
2011-10-26 13:00:00	MSFT	Stock	26.29	26.63	26.25	26.6	6264095.0
2011-10-26 14:00:00	MSFT	Stock	26.595	26.66	26.421	26.46	7164514.0
2011-10-26 15:00:00	MSFT	Stock	26.46	26.7	26.45	26.59	11734202.0
2011-10-26 16:00:00	MSFT	Stock	26.59	26.7	26.518	26.65	5311130.0
2011-10-26 17:00:00	MSFT	Stock	26.64	26.69	26.61	26.69	3149.0
2011-10-26 18:00:00	MSFT	Stock	26.64	26.66	26.59	26.61	15954.0
2011-10-26 19:00:00	MSFT	Stock	26.65	26.67	26.6	26.6	10321.0
2011-10-26 08:00:00	NVDA	Stock	0.365	0.3675	0.365	0.3665	105760.0
2011-10-26 09:00:00	NVDA	Stock	0.367	0.3703	0.3642	0.3652	46310440.0
2011-10-26 10:00:00	NVDA	Stock	0.3655	0.3658	0.355	0.356	87093560.0
2011-10-26 11:00:00	NVDA	Stock	0.3562	0.3655	0.356	0.3638	57057960.0
2011-10-26 12:00:00	NVDA	Stock	0.3639	0.3655	0.3622	0.3622	37563160.0
2011-10-26 13:00:00	NVDA	Stock	0.3623	0.3652	0.3588	0.364	94996840.0
2011-10-26 14:00:00	NVDA	Stock	0.3642	0.3675	0.363	0.3638	50806240.0
2011-10-26 15:00:00	NVDA	Stock	0.364	0.3685	0.3635	0.3655	106993840.0
2011-10-26 16:00:00	NVDA	Stock	0.3652	0.3655	0.3615	0.3655	7912000.0
2011-10-26 17:00:00	NVDA	Stock	0.3665	0.3665	0.3655	0.3655	103960.0
2011-10-26 18:00:00	NVDA	Stock	0.3655	0.3682	0.3655	0.3682	342480.0
2011-10-26 19:00:00	NVDA	Stock	0.366	0.366	0.366	0.366	40000.0
2011-10-26 04:00:00	AMZN	Stock	10.045	10.175	10.045	10.07	44300.0
2011-10-26 05:00:00	AMZN	Stock	10.07	10.1525	10.07	10.1525	88780.0
2011-10-26 06:00:00	AMZN	Stock	10.125	10.175	10.113	10.175	24400.0
2011-10-26 07:00:00	AMZN	Stock	10.155	10.155	9.8005	9.9315	2140980.0
2011-10-26 08:00:00	AMZN	Stock	9.9495	10.1195	9.9	10.1	10754560.0
2011-10-26 09:00:00	AMZN	Stock	10.1	10.379	10.09	10.2895	111135860.0
2011-10-26 10:00:00	AMZN	Stock	10.2905	10.32	10.0275	10.0465	78940540.0
2011-10-26 11:00:00	AMZN	Stock	10.047	10.0875	9.9875	10.0115	56098480.0
2011-10-26 12:00:00	AMZN	Stock	10.0115	10.1245	9.9961	10.0885	34385940.0

> showing 50 of 43,930 rows — these rows as CSV

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