PREVIEW / stock_30min / 2010-05-07

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-05-07.parquet
  size:    1.5 MB
  rows:    78,610
  symbols: 3,480

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
2010-05-07 04:00:00	AAPL	Stock	8.6714	8.7036	8.6714	8.7036	103600.0
2010-05-07 04:30:00	AAPL	Stock	8.7043	8.7171	8.6564	8.6564	74200.0
2010-05-07 05:00:00	AAPL	Stock	8.6504	8.6957	8.6429	8.6936	53200.0
2010-05-07 05:30:00	AAPL	Stock	8.6893	8.6904	8.6893	8.6904	6300.0
2010-05-07 06:00:00	AAPL	Stock	8.6921	8.7236	8.6796	8.7236	121408.0
2010-05-07 06:30:00	AAPL	Stock	8.7214	8.7968	8.7214	8.7768	556752.0
2010-05-07 07:00:00	AAPL	Stock	8.7893	8.8471	8.7771	8.8004	1092084.0
2010-05-07 07:30:00	AAPL	Stock	8.8007	8.8436	8.7718	8.7907	1620556.0
2010-05-07 08:00:00	AAPL	Stock	8.7857	8.8179	8.7057	8.7807	4352712.0
2010-05-07 08:30:00	AAPL	Stock	8.7807	8.8443	8.7382	8.7625	9133152.0
2010-05-07 09:00:00	AAPL	Stock	8.76	8.77	8.6821	8.7029	4000584.0
2010-05-07 09:30:00	AAPL	Stock	8.7039	8.8061	8.5193	8.6554	209249488.0
2010-05-07 10:00:00	AAPL	Stock	8.6557	8.6632	8.0432	8.2061	277343556.0
2010-05-07 10:30:00	AAPL	Stock	8.1982	8.4796	8.1429	8.3865	198370088.0
2010-05-07 11:00:00	AAPL	Stock	8.3884	8.5714	8.3643	8.4732	143176152.0
2010-05-07 11:30:00	AAPL	Stock	8.4732	8.6507	8.3939	8.5804	110427716.0
2010-05-07 12:00:00	AAPL	Stock	8.5793	8.6736	8.5304	8.5707	94215184.0
2010-05-07 12:30:00	AAPL	Stock	8.5766	8.5879	8.4821	8.4957	60232704.0
2010-05-07 13:00:00	AAPL	Stock	8.4982	8.5296	8.4293	8.434	64125320.0
2010-05-07 13:30:00	AAPL	Stock	8.4332	8.5339	8.4325	8.4675	57923404.0
2010-05-07 14:00:00	AAPL	Stock	8.4668	8.4893	8.3661	8.3664	64517964.0
2010-05-07 14:30:00	AAPL	Stock	8.3664	8.5	8.36	8.4139	75394116.0
2010-05-07 15:00:00	AAPL	Stock	8.415	8.42	8.2789	8.3608	117671652.0
2010-05-07 15:30:00	AAPL	Stock	8.3621	8.4921	8.2932	8.4221	147579292.0
2010-05-07 16:00:00	AAPL	Stock	8.4229	8.4757	8.3719	8.4227	20039964.0
2010-05-07 16:30:00	AAPL	Stock	8.4104	8.4236	8.3957	8.4186	382144.0
2010-05-07 17:00:00	AAPL	Stock	8.4182	8.4189	8.3986	8.4007	445872.0
2010-05-07 17:30:00	AAPL	Stock	8.3986	8.4054	8.3768	8.4036	829892.0
2010-05-07 18:00:00	AAPL	Stock	8.4036	8.4236	8.3804	8.3875	229432.0
2010-05-07 18:30:00	AAPL	Stock	8.3875	8.3875	8.3814	8.3814	129864.0
2010-05-07 19:00:00	AAPL	Stock	8.3804	8.4036	8.3761	8.39	173628.0
2010-05-07 19:30:00	AAPL	Stock	8.3904	8.4032	8.3875	8.4025	318612.0
2010-05-07 04:30:00	MSFT	Stock	28.74	28.74	28.74	28.74	200.0
2010-05-07 05:00:00	MSFT	Stock	28.9	28.9	28.9	28.9	700.0
2010-05-07 06:00:00	MSFT	Stock	28.93	28.94	28.93	28.94	1178.0
2010-05-07 06:30:00	MSFT	Stock	29.03	29.05	28.94	28.94	700.0
2010-05-07 07:00:00	MSFT	Stock	29.15	29.15	29.15	29.15	1500.0
2010-05-07 07:30:00	MSFT	Stock	29.1	29.15	29.0	29.0	6682.0
2010-05-07 08:00:00	MSFT	Stock	29.0	29.11	28.99	29.09	14044.0
2010-05-07 08:30:00	MSFT	Stock	29.1	29.16	29.08	29.15	27114.0
2010-05-07 09:00:00	MSFT	Stock	29.15	29.15	28.87	28.92	96549.0
2010-05-07 09:30:00	MSFT	Stock	28.92	28.95	28.428	28.45	16011470.0
2010-05-07 10:00:00	MSFT	Stock	28.46	28.5	27.32	27.611	24559945.0
2010-05-07 10:30:00	MSFT	Stock	27.64	28.56	27.56	28.33	20296734.0
2010-05-07 11:00:00	MSFT	Stock	28.35	28.94	28.33	28.482	14134555.0
2010-05-07 11:30:00	MSFT	Stock	28.49	28.81	28.29	28.65	7239635.0
2010-05-07 12:00:00	MSFT	Stock	28.65	28.94	28.45	28.69	6392558.0
2010-05-07 12:30:00	MSFT	Stock	28.69	28.72	28.52	28.55	6869818.0
2010-05-07 13:00:00	MSFT	Stock	28.55	28.6	28.35	28.44	6367800.0
2010-05-07 13:30:00	MSFT	Stock	28.44	28.54	28.3	28.4	7420431.0

> showing 50 of 78,610 rows — these rows as CSV

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