PREVIEW / stock_30min / 2010-11-09

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-11-09.parquet
  size:    1.4 MB
  rows:    77,356
  symbols: 3,519

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-11-09 05:00:00	AAPL	Stock	11.3321	11.3321	11.3321	11.3321	5600.0
2010-11-09 05:30:00	AAPL	Stock	11.3529	11.3693	11.3529	11.3686	8400.0
2010-11-09 06:00:00	AAPL	Stock	11.3571	11.3604	11.3571	11.3604	5600.0
2010-11-09 06:30:00	AAPL	Stock	11.375	11.375	11.375	11.375	22400.0
2010-11-09 07:00:00	AAPL	Stock	11.4071	11.4486	11.3968	11.4411	540400.0
2010-11-09 07:30:00	AAPL	Stock	11.4421	11.4489	11.4339	11.4457	126140.0
2010-11-09 08:00:00	AAPL	Stock	11.4457	11.4725	11.4286	11.4664	4353972.0
2010-11-09 08:30:00	AAPL	Stock	11.4664	11.4946	11.4511	11.4589	3455872.0
2010-11-09 09:00:00	AAPL	Stock	11.4675	11.4886	11.4625	11.4657	2102772.0
2010-11-09 09:30:00	AAPL	Stock	11.4657	11.475	11.4218	11.4454	59049172.0
2010-11-09 10:00:00	AAPL	Stock	11.4432	11.4639	11.4357	11.4596	31973872.0
2010-11-09 10:30:00	AAPL	Stock	11.4593	11.4607	11.4407	11.4514	17413732.0
2010-11-09 11:00:00	AAPL	Stock	11.4536	11.4582	11.4018	11.4146	25518668.0
2010-11-09 11:30:00	AAPL	Stock	11.4139	11.4211	11.3775	11.3789	16138976.0
2010-11-09 12:00:00	AAPL	Stock	11.3786	11.395	11.3771	11.3929	16591344.0
2010-11-09 12:30:00	AAPL	Stock	11.3932	11.3954	11.3804	11.3854	9291604.0
2010-11-09 13:00:00	AAPL	Stock	11.3843	11.4107	11.3786	11.3794	16986620.0
2010-11-09 13:30:00	AAPL	Stock	11.3796	11.3861	11.3143	11.3464	34604360.0
2010-11-09 14:00:00	AAPL	Stock	11.3461	11.3557	11.3371	11.3457	14527268.0
2010-11-09 14:30:00	AAPL	Stock	11.345	11.375	11.345	11.3532	13645884.0
2010-11-09 15:00:00	AAPL	Stock	11.3536	11.3568	11.3268	11.328	21004256.0
2010-11-09 15:30:00	AAPL	Stock	11.3282	11.3354	11.2321	11.2886	81483696.0
2010-11-09 16:00:00	AAPL	Stock	11.2886	11.4538	11.2628	11.2854	7474600.0
2010-11-09 16:30:00	AAPL	Stock	11.2821	11.4577	11.275	11.275	528444.0
2010-11-09 17:00:00	AAPL	Stock	11.2736	11.275	11.2625	11.2679	324100.0
2010-11-09 17:30:00	AAPL	Stock	11.2682	11.2693	11.2643	11.2671	553420.0
2010-11-09 18:00:00	AAPL	Stock	11.2661	11.2886	11.2643	11.2729	377776.0
2010-11-09 18:30:00	AAPL	Stock	11.2682	11.2821	11.2682	11.2789	268688.0
2010-11-09 19:00:00	AAPL	Stock	11.2789	11.2939	11.2789	11.2893	228480.0
2010-11-09 19:30:00	AAPL	Stock	11.2911	11.2939	11.2857	11.2896	171780.0
2010-11-09 04:30:00	MSFT	Stock	26.89	26.94	26.89	26.94	500.0
2010-11-09 05:00:00	MSFT	Stock	26.94	26.94	26.94	26.94	100.0
2010-11-09 06:30:00	MSFT	Stock	26.97	26.99	26.97	26.99	600.0
2010-11-09 07:00:00	MSFT	Stock	26.97	26.97	26.95	26.95	1670.0
2010-11-09 07:30:00	MSFT	Stock	26.95	26.96	26.94	26.94	7000.0
2010-11-09 08:00:00	MSFT	Stock	26.94	26.96	26.9	26.92	20792.0
2010-11-09 08:30:00	MSFT	Stock	26.92	26.92	26.9	26.91	12012.0
2010-11-09 09:00:00	MSFT	Stock	26.91	26.93	26.81	26.81	76764.0
2010-11-09 09:30:00	MSFT	Stock	26.81	26.9	26.71	26.83	6141202.0
2010-11-09 10:00:00	MSFT	Stock	26.825	27.11	26.8	27.021	7796461.0
2010-11-09 10:30:00	MSFT	Stock	27.02	27.045	26.99	27.02	4045894.0
2010-11-09 11:00:00	MSFT	Stock	27.03	27.05	26.95	27.035	4824618.0
2010-11-09 11:30:00	MSFT	Stock	27.035	27.05	26.94	26.94	3212646.0
2010-11-09 12:00:00	MSFT	Stock	26.95	27.04	26.93	27.004	2434521.0
2010-11-09 12:30:00	MSFT	Stock	27.01	27.03	27.0	27.01	1589311.0
2010-11-09 13:00:00	MSFT	Stock	27.02	27.05	27.0	27.01	1956708.0
2010-11-09 13:30:00	MSFT	Stock	27.0	27.02	26.92	27.013	2755722.0
2010-11-09 14:00:00	MSFT	Stock	27.01	27.04	26.97	26.993	2075044.0
2010-11-09 14:30:00	MSFT	Stock	27.0	27.05	26.99	27.003	2175186.0
2010-11-09 15:00:00	MSFT	Stock	27.0	27.01	26.92	26.93	3917435.0

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

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