PREVIEW / stock_30min / 2013-06-25

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-06-25.parquet
  size:    1.5 MB
  rows:    79,677
  symbols: 3,521

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
2013-06-25 04:00:00	AAPL	Stock	14.3789	14.3789	14.3789	14.3789	5600.0
2013-06-25 05:30:00	AAPL	Stock	14.4411	14.4464	14.4182	14.4464	32536.0
2013-06-25 06:00:00	AAPL	Stock	14.4643	14.4643	14.4464	14.4464	20636.0
2013-06-25 06:30:00	AAPL	Stock	14.4464	14.4643	14.4296	14.4296	34188.0
2013-06-25 07:00:00	AAPL	Stock	14.4489	14.5	14.4489	14.4611	232008.0
2013-06-25 07:30:00	AAPL	Stock	14.4732	14.5157	14.47	14.5071	196616.0
2013-06-25 08:00:00	AAPL	Stock	14.4929	14.5071	14.3571	14.4536	685944.0
2013-06-25 08:30:00	AAPL	Stock	14.4536	14.4836	14.4536	14.4736	374444.0
2013-06-25 09:00:00	AAPL	Stock	14.4714	14.5036	14.4686	14.4839	1099420.0
2013-06-25 09:30:00	AAPL	Stock	14.48	14.5639	14.3321	14.365	52938592.0
2013-06-25 10:00:00	AAPL	Stock	14.3634	14.3929	14.2439	14.2482	41260940.0
2013-06-25 10:30:00	AAPL	Stock	14.2496	14.3786	14.245	14.3636	33069820.0
2013-06-25 11:00:00	AAPL	Stock	14.3619	14.3704	14.2768	14.3029	15812328.0
2013-06-25 11:30:00	AAPL	Stock	14.3	14.3529	14.2943	14.3406	13692252.0
2013-06-25 12:00:00	AAPL	Stock	14.3411	14.3554	14.3118	14.3368	10156328.0
2013-06-25 12:30:00	AAPL	Stock	14.3343	14.3532	14.2946	14.2982	12108852.0
2013-06-25 13:00:00	AAPL	Stock	14.3045	14.3257	14.265	14.2808	14133784.0
2013-06-25 13:30:00	AAPL	Stock	14.2807	14.3104	14.2679	14.2982	10838492.0
2013-06-25 14:00:00	AAPL	Stock	14.2946	14.3711	14.2843	14.3582	19075448.0
2013-06-25 14:30:00	AAPL	Stock	14.3583	14.362	14.3161	14.342	10878588.0
2013-06-25 15:00:00	AAPL	Stock	14.3439	14.4246	14.3325	14.4204	18169928.0
2013-06-25 15:30:00	AAPL	Stock	14.4211	14.4536	14.3775	14.3779	34921152.0
2013-06-25 16:00:00	AAPL	Stock	14.3796	14.4041	14.3609	14.3654	20277040.0
2013-06-25 16:30:00	AAPL	Stock	14.3704	14.3796	14.3243	14.3661	478716.0
2013-06-25 17:00:00	AAPL	Stock	14.3643	14.4121	14.3593	14.3593	59780.0
2013-06-25 17:30:00	AAPL	Stock	14.3625	14.3625	14.3625	14.3625	2800.0
2013-06-25 18:00:00	AAPL	Stock	14.3625	14.3639	14.3575	14.3639	22400.0
2013-06-25 18:30:00	AAPL	Stock	14.3543	14.3543	14.3393	14.3393	94360.0
2013-06-25 19:00:00	AAPL	Stock	14.3411	14.3411	14.3325	14.3393	14000.0
2013-06-25 19:30:00	AAPL	Stock	14.3411	14.3411	14.3214	14.3268	69636.0
2013-06-25 06:00:00	MSFT	Stock	33.86	33.86	33.86	33.86	100.0
2013-06-25 07:00:00	MSFT	Stock	33.88	33.88	33.88	33.88	1200.0
2013-06-25 07:30:00	MSFT	Stock	33.9	34.12	33.9	34.12	6600.0
2013-06-25 08:00:00	MSFT	Stock	33.9	34.0	33.9	33.96	14600.0
2013-06-25 08:30:00	MSFT	Stock	33.96	33.99	33.71	33.95	59500.0
2013-06-25 09:00:00	MSFT	Stock	33.98	34.11	33.94	34.07	59600.0
2013-06-25 09:30:00	MSFT	Stock	34.1	34.38	33.89	33.99	6604823.0
2013-06-25 10:00:00	MSFT	Stock	33.98	34.08	33.575	33.59	5250048.0
2013-06-25 10:30:00	MSFT	Stock	33.59	33.68	33.46	33.655	4042712.0
2013-06-25 11:00:00	MSFT	Stock	33.655	33.72	33.61	33.68	1878478.0
2013-06-25 11:30:00	MSFT	Stock	33.68	33.76	33.64	33.75	1480893.0
2013-06-25 12:00:00	MSFT	Stock	33.75	33.815	33.61	33.65	1698710.0
2013-06-25 12:30:00	MSFT	Stock	33.647	33.71	33.62	33.66	1711995.0
2013-06-25 13:00:00	MSFT	Stock	33.656	33.66	33.51	33.567	1755561.0
2013-06-25 13:30:00	MSFT	Stock	33.565	33.65	33.515	33.54	1503588.0
2013-06-25 14:00:00	MSFT	Stock	33.545	33.62	33.52	33.585	1730617.0
2013-06-25 14:30:00	MSFT	Stock	33.585	33.61	33.5	33.56	2026892.0
2013-06-25 15:00:00	MSFT	Stock	33.56	33.65	33.54	33.65	2369812.0
2013-06-25 15:30:00	MSFT	Stock	33.65	33.74	33.63	33.65	6245987.0
2013-06-25 16:00:00	MSFT	Stock	33.71	33.748	33.628	33.67	4982933.0

> showing 50 of 79,677 rows — these rows as CSV

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