PREVIEW / stock_1hour / 2011-08-26

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-08-26.parquet
  size:    924 KB
  rows:    44,603
  symbols: 3,499

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-26 04:00:00	AAPL	Stock	13.3882	13.3882	13.3882	13.3882	2800.0
2011-08-26 05:00:00	AAPL	Stock	13.3571	13.3571	13.3571	13.3571	5600.0
2011-08-26 06:00:00	AAPL	Stock	13.3321	13.3557	13.3214	13.3539	102060.0
2011-08-26 07:00:00	AAPL	Stock	13.3571	13.3746	13.275	13.2975	443408.0
2011-08-26 08:00:00	AAPL	Stock	13.3154	13.3214	13.2321	13.2568	2268168.0
2011-08-26 09:00:00	AAPL	Stock	13.2571	13.3689	13.2429	13.2943	51552284.0
2011-08-26 10:00:00	AAPL	Stock	13.2968	13.5714	13.2507	13.5254	180477948.0
2011-08-26 11:00:00	AAPL	Stock	13.525	13.655	13.5071	13.6162	103359508.0
2011-08-26 12:00:00	AAPL	Stock	13.6168	13.6589	13.6157	13.6339	59239824.0
2011-08-26 13:00:00	AAPL	Stock	13.6368	13.6868	13.6104	13.6655	55965896.0
2011-08-26 14:00:00	AAPL	Stock	13.6685	13.7025	13.6429	13.7012	55038816.0
2011-08-26 15:00:00	AAPL	Stock	13.7011	13.7071	13.6125	13.7043	98790440.0
2011-08-26 16:00:00	AAPL	Stock	13.6989	13.7325	13.5544	13.6854	25026232.0
2011-08-26 17:00:00	AAPL	Stock	13.6875	13.6993	13.6786	13.6886	975072.0
2011-08-26 18:00:00	AAPL	Stock	13.6857	13.6993	13.6786	13.6918	309708.0
2011-08-26 19:00:00	AAPL	Stock	13.6964	13.6993	13.6804	13.6843	302120.0
2011-08-26 07:00:00	MSFT	Stock	24.55	24.55	24.55	24.55	300.0
2011-08-26 08:00:00	MSFT	Stock	24.5	24.59	24.45	24.45	11894.0
2011-08-26 09:00:00	MSFT	Stock	24.45	24.73	24.3	24.64	4715015.0
2011-08-26 10:00:00	MSFT	Stock	24.65	25.09	24.42	24.9	11599134.0
2011-08-26 11:00:00	MSFT	Stock	24.905	25.22	24.87	25.175	8770148.0
2011-08-26 12:00:00	MSFT	Stock	25.18	25.34	25.171	25.221	5424942.0
2011-08-26 13:00:00	MSFT	Stock	25.23	25.32	25.19	25.32	4084210.0
2011-08-26 14:00:00	MSFT	Stock	25.32	25.335	25.2	25.28	4775452.0
2011-08-26 15:00:00	MSFT	Stock	25.28	25.29	25.14	25.24	12814030.0
2011-08-26 16:00:00	MSFT	Stock	25.25	25.34	25.02	25.082	19030222.0
2011-08-26 17:00:00	MSFT	Stock	25.32	25.32	25.25	25.25	213577.0
2011-08-26 18:00:00	MSFT	Stock	25.25	25.3	25.25	25.3	20659.0
2011-08-26 19:00:00	MSFT	Stock	25.25	25.25	25.25	25.25	992.0
2011-08-26 04:00:00	NVDA	Stock	0.3125	0.3125	0.3125	0.3125	4000.0
2011-08-26 08:00:00	NVDA	Stock	0.3103	0.3103	0.3075	0.3075	112000.0
2011-08-26 09:00:00	NVDA	Stock	0.3093	0.3133	0.3052	0.311	68320400.0
2011-08-26 10:00:00	NVDA	Stock	0.3113	0.3248	0.3065	0.3198	192794960.0
2011-08-26 11:00:00	NVDA	Stock	0.3198	0.3253	0.3185	0.3223	101989440.0
2011-08-26 12:00:00	NVDA	Stock	0.3225	0.327	0.3225	0.3263	80560720.0
2011-08-26 13:00:00	NVDA	Stock	0.3263	0.3285	0.3255	0.3275	60342520.0
2011-08-26 14:00:00	NVDA	Stock	0.3275	0.3284	0.3228	0.326	73632520.0
2011-08-26 15:00:00	NVDA	Stock	0.326	0.3263	0.3225	0.3253	115922520.0
2011-08-26 16:00:00	NVDA	Stock	0.3255	0.3276	0.3208	0.3243	26358160.0
2011-08-26 17:00:00	NVDA	Stock	0.3253	0.3253	0.3253	0.3253	603520.0
2011-08-26 18:00:00	NVDA	Stock	0.3238	0.3238	0.3228	0.3228	20000.0
2011-08-26 19:00:00	NVDA	Stock	0.3255	0.3255	0.325	0.325	27360.0
2011-08-26 07:00:00	AMZN	Stock	9.645	9.645	9.5845	9.5845	14000.0
2011-08-26 08:00:00	AMZN	Stock	9.5975	9.5975	9.5165	9.5355	100760.0
2011-08-26 09:00:00	AMZN	Stock	9.5335	9.6225	9.5005	9.5625	6605060.0
2011-08-26 10:00:00	AMZN	Stock	9.5565	9.887	9.48	9.7805	28638360.0
2011-08-26 11:00:00	AMZN	Stock	9.7805	9.86	9.75	9.8499	12396180.0
2011-08-26 12:00:00	AMZN	Stock	9.85	9.964	9.85	9.934	15237920.0
2011-08-26 13:00:00	AMZN	Stock	9.9287	9.9775	9.905	9.969	8702140.0
2011-08-26 14:00:00	AMZN	Stock	9.9725	9.986	9.908	9.9755	10062080.0

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

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