PREVIEW / stock_30min / 2012-06-06

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-06-06.parquet
  size:    1.4 MB
  rows:    77,198
  symbols: 3,536

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-06-06 04:00:00	AAPL	Stock	20.2018	20.3214	20.2018	20.3211	35952.0
2012-06-06 04:30:00	AAPL	Stock	20.3204	20.3204	20.2857	20.2857	47600.0
2012-06-06 05:00:00	AAPL	Stock	20.2857	20.2857	20.2857	20.2857	8400.0
2012-06-06 06:00:00	AAPL	Stock	20.2329	20.3	20.2329	20.2679	21700.0
2012-06-06 06:30:00	AAPL	Stock	20.2732	20.3214	20.2732	20.3057	60340.0
2012-06-06 07:00:00	AAPL	Stock	20.3054	20.3429	20.2946	20.3393	460096.0
2012-06-06 07:30:00	AAPL	Stock	20.3379	20.3546	20.2996	20.3339	613816.0
2012-06-06 08:00:00	AAPL	Stock	20.3371	20.3532	20.275	20.2996	1143464.0
2012-06-06 08:30:00	AAPL	Stock	20.3029	20.3168	20.2068	20.2164	1983996.0
2012-06-06 09:00:00	AAPL	Stock	20.2089	20.2821	20.1907	20.2786	1431108.0
2012-06-06 09:30:00	AAPL	Stock	20.2821	20.3482	20.1964	20.3222	64538516.0
2012-06-06 10:00:00	AAPL	Stock	20.3243	20.4054	20.2964	20.3689	48058024.0
2012-06-06 10:30:00	AAPL	Stock	20.3665	20.4946	20.3664	20.4589	41944980.0
2012-06-06 11:00:00	AAPL	Stock	20.4625	20.4821	20.4289	20.4706	27214208.0
2012-06-06 11:30:00	AAPL	Stock	20.4682	20.4796	20.3854	20.4257	28741832.0
2012-06-06 12:00:00	AAPL	Stock	20.4239	20.4518	20.4125	20.435	16516836.0
2012-06-06 12:30:00	AAPL	Stock	20.43	20.4589	20.4268	20.4421	10417624.0
2012-06-06 13:00:00	AAPL	Stock	20.4454	20.4532	20.375	20.4168	18952248.0
2012-06-06 13:30:00	AAPL	Stock	20.4179	20.4321	20.3957	20.4054	12418616.0
2012-06-06 14:00:00	AAPL	Stock	20.4039	20.4246	20.3236	20.4014	26677700.0
2012-06-06 14:30:00	AAPL	Stock	20.3971	20.4414	20.3964	20.4196	18845344.0
2012-06-06 15:00:00	AAPL	Stock	20.4232	20.4361	20.3568	20.3739	22605800.0
2012-06-06 15:30:00	AAPL	Stock	20.3743	20.4339	20.3646	20.4189	41353480.0
2012-06-06 16:00:00	AAPL	Stock	20.4189	20.4251	20.3863	20.4143	9495276.0
2012-06-06 16:30:00	AAPL	Stock	20.4139	20.4286	20.4093	20.4286	901908.0
2012-06-06 17:00:00	AAPL	Stock	20.4307	20.4329	20.4093	20.4286	112364.0
2012-06-06 17:30:00	AAPL	Stock	20.4268	20.4268	20.4154	20.4214	84280.0
2012-06-06 18:00:00	AAPL	Stock	20.425	20.4286	20.4232	20.4286	38276.0
2012-06-06 18:30:00	AAPL	Stock	20.435	20.4375	20.4286	20.4371	94808.0
2012-06-06 19:00:00	AAPL	Stock	20.4375	20.4375	20.4286	20.4296	111944.0
2012-06-06 19:30:00	AAPL	Stock	20.4332	20.4421	20.4218	20.4393	203392.0
2012-06-06 04:00:00	MSFT	Stock	28.8	28.8	28.8	28.8	100.0
2012-06-06 04:30:00	MSFT	Stock	28.8	28.9	28.8	28.9	900.0
2012-06-06 05:30:00	MSFT	Stock	28.89	28.9	28.89	28.9	1000.0
2012-06-06 06:00:00	MSFT	Stock	28.95	28.95	28.95	28.95	172.0
2012-06-06 07:00:00	MSFT	Stock	28.9	28.94	28.9	28.9	34800.0
2012-06-06 07:30:00	MSFT	Stock	28.9	28.9	28.82	28.86	12811.0
2012-06-06 08:00:00	MSFT	Stock	28.84	28.9	28.8	28.87	20488.0
2012-06-06 08:30:00	MSFT	Stock	28.86	28.87	28.75	28.75	21430.0
2012-06-06 09:00:00	MSFT	Stock	28.75	28.89	28.75	28.85	41647.0
2012-06-06 09:30:00	MSFT	Stock	28.86	29.045	28.808	28.967	6456169.0
2012-06-06 10:00:00	MSFT	Stock	28.96	29.06	28.95	29.007	3762051.0
2012-06-06 10:30:00	MSFT	Stock	29.0	29.16	28.97	29.065	4043877.0
2012-06-06 11:00:00	MSFT	Stock	29.065	29.1	29.0	29.05	2774168.0
2012-06-06 11:30:00	MSFT	Stock	29.06	29.07	29.01	29.02	1858525.0
2012-06-06 12:00:00	MSFT	Stock	29.02	29.06	29.0	29.025	1563003.0
2012-06-06 12:30:00	MSFT	Stock	29.028	29.07	29.01	29.05	2049482.0
2012-06-06 13:00:00	MSFT	Stock	29.06	29.06	29.02	29.05	1384921.0
2012-06-06 13:30:00	MSFT	Stock	29.055	29.08	29.01	29.01	1532798.0
2012-06-06 14:00:00	MSFT	Stock	29.01	29.06	29.01	29.039	2259728.0

> showing 50 of 77,198 rows — these rows as CSV

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