PREVIEW / stock_1hour / 2011-06-03

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-06-03.parquet
  size:    960 KB
  rows:    46,175
  symbols: 3,552

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-06-03 04:00:00	AAPL	Stock	12.3571	12.365	12.3571	12.3575	20300.0
2011-06-03 06:00:00	AAPL	Stock	12.3575	12.3575	12.3393	12.3554	70560.0
2011-06-03 07:00:00	AAPL	Stock	12.34	12.3554	12.3393	12.3393	73780.0
2011-06-03 08:00:00	AAPL	Stock	12.3375	12.3525	12.25	12.2714	3962812.0
2011-06-03 09:00:00	AAPL	Stock	12.2689	12.3107	12.2382	12.2618	66764572.0
2011-06-03 10:00:00	AAPL	Stock	12.2664	12.3332	12.2643	12.3002	59677380.0
2011-06-03 11:00:00	AAPL	Stock	12.3004	12.3011	12.26	12.2821	31398416.0
2011-06-03 12:00:00	AAPL	Stock	12.2839	12.3139	12.275	12.3021	23456412.0
2011-06-03 13:00:00	AAPL	Stock	12.3021	12.3089	12.2829	12.2862	15873676.0
2011-06-03 14:00:00	AAPL	Stock	12.2854	12.2871	12.2629	12.265	25127396.0
2011-06-03 15:00:00	AAPL	Stock	12.263	12.2821	12.2146	12.2611	71859200.0
2011-06-03 16:00:00	AAPL	Stock	12.2648	12.2911	12.2446	12.2675	9975196.0
2011-06-03 17:00:00	AAPL	Stock	12.2639	12.2643	12.2586	12.2607	1371496.0
2011-06-03 18:00:00	AAPL	Stock	12.2636	12.2675	12.2629	12.2671	163884.0
2011-06-03 19:00:00	AAPL	Stock	12.2671	12.2671	12.2657	12.2661	156940.0
2011-06-03 07:00:00	MSFT	Stock	24.19	24.22	24.19	24.22	1948.0
2011-06-03 08:00:00	MSFT	Stock	24.2	24.22	24.05	24.05	73237.0
2011-06-03 09:00:00	MSFT	Stock	24.06	24.14	24.02	24.09	5297317.0
2011-06-03 10:00:00	MSFT	Stock	24.08	24.11	23.99	24.06	12613827.0
2011-06-03 11:00:00	MSFT	Stock	24.06	24.1	24.025	24.078	5807062.0
2011-06-03 12:00:00	MSFT	Stock	24.075	24.11	24.01	24.015	3456809.0
2011-06-03 13:00:00	MSFT	Stock	24.015	24.06	24.0	24.023	4152383.0
2011-06-03 14:00:00	MSFT	Stock	24.02	24.03	23.95	23.96	6217064.0
2011-06-03 15:00:00	MSFT	Stock	23.96	23.96	23.84	23.89	18245468.0
2011-06-03 16:00:00	MSFT	Stock	23.91	23.992	23.84	23.89	3545099.0
2011-06-03 17:00:00	MSFT	Stock	23.87	23.9	23.85	23.85	377790.0
2011-06-03 18:00:00	MSFT	Stock	23.87	23.91	23.83	23.86	52702.0
2011-06-03 19:00:00	MSFT	Stock	23.87	23.9	23.85	23.89	2800.0
2011-06-03 08:00:00	NVDA	Stock	0.468	0.472	0.465	0.4675	623760.0
2011-06-03 09:00:00	NVDA	Stock	0.4662	0.4745	0.465	0.4698	63778040.0
2011-06-03 10:00:00	NVDA	Stock	0.4698	0.4742	0.4685	0.4742	84931720.0
2011-06-03 11:00:00	NVDA	Stock	0.4742	0.475	0.47	0.4715	51432360.0
2011-06-03 12:00:00	NVDA	Stock	0.4716	0.4725	0.471	0.4715	23645920.0
2011-06-03 13:00:00	NVDA	Stock	0.4715	0.4718	0.4668	0.4668	53145920.0
2011-06-03 14:00:00	NVDA	Stock	0.467	0.4673	0.4608	0.461	115195160.0
2011-06-03 15:00:00	NVDA	Stock	0.4608	0.4636	0.4593	0.4615	144706680.0
2011-06-03 16:00:00	NVDA	Stock	0.4615	0.4669	0.4598	0.4604	10099920.0
2011-06-03 17:00:00	NVDA	Stock	0.4605	0.4615	0.4605	0.4615	1188000.0
2011-06-03 18:00:00	NVDA	Stock	0.4615	0.4615	0.4615	0.4615	20000.0
2011-06-03 19:00:00	NVDA	Stock	0.462	0.4622	0.462	0.4622	82440.0
2011-06-03 04:00:00	AMZN	Stock	9.6925	9.6925	9.6925	9.6925	2000.0
2011-06-03 08:00:00	AMZN	Stock	9.6585	9.6895	9.525	9.5495	228600.0
2011-06-03 09:00:00	AMZN	Stock	9.539	9.6115	9.5145	9.5275	12089880.0
2011-06-03 10:00:00	AMZN	Stock	9.5255	9.6605	9.506	9.621	20553660.0
2011-06-03 11:00:00	AMZN	Stock	9.622	9.6355	9.5565	9.573	8304340.0
2011-06-03 12:00:00	AMZN	Stock	9.575	9.5845	9.543	9.5515	7075580.0
2011-06-03 13:00:00	AMZN	Stock	9.5535	9.576	9.54	9.543	5900580.0
2011-06-03 14:00:00	AMZN	Stock	9.544	9.5455	9.5015	9.505	7247300.0
2011-06-03 15:00:00	AMZN	Stock	9.502	9.5065	9.381	9.4135	33351900.0
2011-06-03 16:00:00	AMZN	Stock	9.4155	9.5211	9.382	9.4095	757500.0

> showing 50 of 46,175 rows — these rows as CSV

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