PREVIEW / stock_30min / 2012-03-23

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-03-23.parquet
  size:    1.4 MB
  rows:    73,448
  symbols: 3,500

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
2012-03-23 04:00:00	AAPL	Stock	21.4643	21.4643	21.4286	21.4286	128800.0
2012-03-23 04:30:00	AAPL	Stock	21.4282	21.4286	21.4189	21.4286	163660.0
2012-03-23 05:00:00	AAPL	Stock	21.4286	21.4643	21.4286	21.4375	43960.0
2012-03-23 05:30:00	AAPL	Stock	21.4232	21.4232	21.3571	21.3571	32200.0
2012-03-23 06:00:00	AAPL	Stock	21.3561	21.3561	21.3561	21.3561	11200.0
2012-03-23 06:30:00	AAPL	Stock	21.3571	21.375	21.3571	21.375	22344.0
2012-03-23 07:00:00	AAPL	Stock	21.375	21.4107	21.375	21.4107	223076.0
2012-03-23 07:30:00	AAPL	Stock	21.4004	21.4018	21.3679	21.3707	263032.0
2012-03-23 08:00:00	AAPL	Stock	21.3782	21.4136	21.3393	21.4107	1004948.0
2012-03-23 08:30:00	AAPL	Stock	21.4021	21.4232	21.3982	21.4214	989016.0
2012-03-23 09:00:00	AAPL	Stock	21.4221	21.4643	21.4111	21.4414	1747424.0
2012-03-23 09:30:00	AAPL	Stock	21.445	21.4929	21.3714	21.4032	65213120.0
2012-03-23 10:00:00	AAPL	Stock	21.4007	21.4021	21.3119	21.345	46378444.0
2012-03-23 10:30:00	AAPL	Stock	21.3471	21.3904	21.3332	21.3654	21722764.0
2012-03-23 11:00:00	AAPL	Stock	21.3611	21.3796	21.3357	21.3704	22369648.0
2012-03-23 11:30:00	AAPL	Stock	21.3707	21.3854	21.3621	21.3743	11723096.0
2012-03-23 12:00:00	AAPL	Stock	21.3743	21.3768	21.2893	21.3057	29605100.0
2012-03-23 12:30:00	AAPL	Stock	21.3057	21.3267	21.2286	21.2783	44366280.0
2012-03-23 13:00:00	AAPL	Stock	21.278	21.3386	21.2714	21.3107	25030712.0
2012-03-23 13:30:00	AAPL	Stock	21.3111	21.3518	21.3107	21.3221	17134796.0
2012-03-23 14:00:00	AAPL	Stock	21.3211	21.3786	21.3036	21.3686	23168768.0
2012-03-23 14:30:00	AAPL	Stock	21.3679	21.3768	21.3482	21.3582	15147636.0
2012-03-23 15:00:00	AAPL	Stock	21.3593	21.3643	21.2836	21.3014	27402424.0
2012-03-23 15:30:00	AAPL	Stock	21.3011	21.3189	21.2575	21.2929	55073592.0
2012-03-23 16:00:00	AAPL	Stock	21.2789	21.3391	21.2757	21.2857	10998848.0
2012-03-23 16:30:00	AAPL	Stock	21.2875	21.4004	21.2679	21.2857	834288.0
2012-03-23 17:00:00	AAPL	Stock	21.3708	21.3708	21.2714	21.2964	933688.0
2012-03-23 17:30:00	AAPL	Stock	21.3	21.3214	21.2946	21.3	399700.0
2012-03-23 18:00:00	AAPL	Stock	21.2971	21.2971	21.2893	21.2893	15120.0
2012-03-23 18:30:00	AAPL	Stock	21.2946	21.2946	21.2786	21.2804	85512.0
2012-03-23 19:00:00	AAPL	Stock	21.2804	21.2886	21.2786	21.2857	44464.0
2012-03-23 19:30:00	AAPL	Stock	21.2857	21.2886	21.2589	21.2814	280504.0
2012-03-23 08:00:00	MSFT	Stock	32.0	32.0	31.99	31.99	690.0
2012-03-23 08:30:00	MSFT	Stock	32.0	32.0	32.0	32.0	2268.0
2012-03-23 09:00:00	MSFT	Stock	32.0	32.12	32.0	32.07	14068.0
2012-03-23 09:30:00	MSFT	Stock	32.07	32.11	31.89	31.949	4183150.0
2012-03-23 10:00:00	MSFT	Stock	31.94	31.945	31.72	31.788	2986800.0
2012-03-23 10:30:00	MSFT	Stock	31.785	31.85	31.77	31.816	1770278.0
2012-03-23 11:00:00	MSFT	Stock	31.82	31.88	31.74	31.842	1883824.0
2012-03-23 11:30:00	MSFT	Stock	31.844	31.89	31.78	31.845	1942387.0
2012-03-23 12:00:00	MSFT	Stock	31.85	31.86	31.81	31.82	1222772.0
2012-03-23 12:30:00	MSFT	Stock	31.821	31.87	31.79	31.845	1414276.0
2012-03-23 13:00:00	MSFT	Stock	31.85	31.888	31.8	31.87	1842455.0
2012-03-23 13:30:00	MSFT	Stock	31.87	31.98	31.83	31.89	2677454.0
2012-03-23 14:00:00	MSFT	Stock	31.88	32.0	31.86	31.998	2435952.0
2012-03-23 14:30:00	MSFT	Stock	31.995	32.0	31.92	31.93	1486793.0
2012-03-23 15:00:00	MSFT	Stock	31.93	31.97	31.91	31.97	1470991.0
2012-03-23 15:30:00	MSFT	Stock	31.96	32.05	31.94	31.97	5601792.0
2012-03-23 16:00:00	MSFT	Stock	31.98	32.045	31.906	32.03	2643175.0
2012-03-23 16:30:00	MSFT	Stock	32.03	32.05	31.912	31.97	827987.0

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

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