PREVIEW / stock_30min / 2011-10-13

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-10-13.parquet
  size:    1.4 MB
  rows:    73,759
  symbols: 3,486

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-13 04:00:00	AAPL	Stock	14.4343	14.4343	14.3821	14.3821	19600.0
2011-10-13 04:30:00	AAPL	Stock	14.3796	14.3796	14.3689	14.37	23380.0
2011-10-13 05:00:00	AAPL	Stock	14.37	14.37	14.37	14.37	5600.0
2011-10-13 05:30:00	AAPL	Stock	14.3571	14.3571	14.3571	14.3571	2800.0
2011-10-13 06:30:00	AAPL	Stock	14.3414	14.3571	14.3414	14.3571	11900.0
2011-10-13 07:00:00	AAPL	Stock	14.3464	14.35	14.3314	14.3314	148820.0
2011-10-13 07:30:00	AAPL	Stock	14.3379	14.3396	14.3111	14.3361	187600.0
2011-10-13 08:00:00	AAPL	Stock	14.3268	14.4286	14.3161	14.4236	1650712.0
2011-10-13 08:30:00	AAPL	Stock	14.4286	14.4886	14.4025	14.4607	3422328.0
2011-10-13 09:00:00	AAPL	Stock	14.4625	14.4911	14.4543	14.4643	2575412.0
2011-10-13 09:30:00	AAPL	Stock	14.465	14.5054	14.3875	14.455	76626620.0
2011-10-13 10:00:00	AAPL	Stock	14.4543	14.5239	14.4268	14.5014	47701416.0
2011-10-13 10:30:00	AAPL	Stock	14.4996	14.5321	14.4411	14.4561	29894704.0
2011-10-13 11:00:00	AAPL	Stock	14.4514	14.5139	14.4514	14.4996	21904092.0
2011-10-13 11:30:00	AAPL	Stock	14.5007	14.5546	14.4961	14.5282	24786132.0
2011-10-13 12:00:00	AAPL	Stock	14.5282	14.5475	14.5004	14.5086	15766436.0
2011-10-13 12:30:00	AAPL	Stock	14.5082	14.5304	14.4968	14.5157	12153736.0
2011-10-13 13:00:00	AAPL	Stock	14.5157	14.5184	14.4439	14.487	22911784.0
2011-10-13 13:30:00	AAPL	Stock	14.4854	14.5036	14.472	14.4857	12126632.0
2011-10-13 14:00:00	AAPL	Stock	14.4879	14.4957	14.4529	14.4736	14343588.0
2011-10-13 14:30:00	AAPL	Stock	14.4746	14.5418	14.4723	14.5239	21899416.0
2011-10-13 15:00:00	AAPL	Stock	14.5218	14.5804	14.5211	14.5304	37840208.0
2011-10-13 15:30:00	AAPL	Stock	14.5289	14.5868	14.5179	14.5864	39456984.0
2011-10-13 16:00:00	AAPL	Stock	14.5868	14.695	14.4628	14.6357	29752072.0
2011-10-13 16:30:00	AAPL	Stock	14.6393	14.7143	14.5306	14.7046	2577260.0
2011-10-13 17:00:00	AAPL	Stock	14.71	14.7739	14.5868	14.7564	1638672.0
2011-10-13 17:30:00	AAPL	Stock	14.7564	14.7696	14.7357	14.7504	1070748.0
2011-10-13 18:00:00	AAPL	Stock	14.7536	14.7768	14.5868	14.7657	614488.0
2011-10-13 18:30:00	AAPL	Stock	14.7654	14.7843	14.7543	14.7643	785512.0
2011-10-13 19:00:00	AAPL	Stock	14.7707	14.7707	14.7536	14.7571	263256.0
2011-10-13 19:30:00	AAPL	Stock	14.7593	14.7675	14.75	14.75	289380.0
2011-10-13 08:00:00	MSFT	Stock	26.78	26.82	26.77	26.82	3450.0
2011-10-13 08:30:00	MSFT	Stock	26.8	26.85	26.75	26.83	4450.0
2011-10-13 09:00:00	MSFT	Stock	26.83	26.96	26.71	26.73	46369.0
2011-10-13 09:30:00	MSFT	Stock	26.76	26.79	26.62	26.77	6068094.0
2011-10-13 10:00:00	MSFT	Stock	26.77	26.92	26.75	26.87	4988585.0
2011-10-13 10:30:00	MSFT	Stock	26.87	26.95	26.75	26.93	3746300.0
2011-10-13 11:00:00	MSFT	Stock	26.93	26.99	26.89	26.91	2356626.0
2011-10-13 11:30:00	MSFT	Stock	26.92	27.07	26.91	27.025	2199766.0
2011-10-13 12:00:00	MSFT	Stock	27.025	27.04	26.96	26.98	1897129.0
2011-10-13 12:30:00	MSFT	Stock	26.98	27.075	26.97	27.0	2421865.0
2011-10-13 13:00:00	MSFT	Stock	27.005	27.085	26.965	27.06	1671367.0
2011-10-13 13:30:00	MSFT	Stock	27.069	27.1	27.04	27.07	1870915.0
2011-10-13 14:00:00	MSFT	Stock	27.06	27.1	27.03	27.085	1465669.0
2011-10-13 14:30:00	MSFT	Stock	27.08	27.165	27.039	27.14	2708399.0
2011-10-13 15:00:00	MSFT	Stock	27.145	27.2	27.041	27.041	3656060.0
2011-10-13 15:30:00	MSFT	Stock	27.05	27.18	27.015	27.18	5228338.0
2011-10-13 16:00:00	MSFT	Stock	27.18	27.25	26.961	27.18	2839090.0
2011-10-13 16:30:00	MSFT	Stock	27.175	27.175	27.06	27.12	25239.0
2011-10-13 17:00:00	MSFT	Stock	27.15	27.18	27.15	27.18	14106.0

> showing 50 of 73,759 rows — these rows as CSV

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