PREVIEW / stock_30min / 2012-06-26

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-06-26.parquet
  size:    1.4 MB
  rows:    74,861
  symbols: 3,497

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-26 04:30:00	AAPL	Stock	20.4357	20.4357	20.4286	20.4286	30800.0
2012-06-26 05:00:00	AAPL	Stock	20.4304	20.4357	20.4107	20.4107	61600.0
2012-06-26 05:30:00	AAPL	Stock	20.4286	20.4411	20.4286	20.4411	25200.0
2012-06-26 06:00:00	AAPL	Stock	20.4639	20.4639	20.4639	20.4639	2800.0
2012-06-26 06:30:00	AAPL	Stock	20.4536	20.4604	20.4536	20.4604	8400.0
2012-06-26 07:00:00	AAPL	Stock	20.4468	20.4468	20.4107	20.4107	70000.0
2012-06-26 07:30:00	AAPL	Stock	20.4107	20.4204	20.3661	20.39	80528.0
2012-06-26 08:00:00	AAPL	Stock	20.4014	20.4125	20.3821	20.385	476280.0
2012-06-26 08:30:00	AAPL	Stock	20.3846	20.4	20.3825	20.3932	330036.0
2012-06-26 09:00:00	AAPL	Stock	20.3975	20.4257	20.3893	20.4054	531216.0
2012-06-26 09:30:00	AAPL	Stock	20.4111	20.4929	20.3146	20.4364	45881780.0
2012-06-26 10:00:00	AAPL	Stock	20.4359	20.5175	20.3929	20.4189	31534804.0
2012-06-26 10:30:00	AAPL	Stock	20.415	20.4368	20.3461	20.3596	18491536.0
2012-06-26 11:00:00	AAPL	Stock	20.3554	20.4086	20.3214	20.3411	20406008.0
2012-06-26 11:30:00	AAPL	Stock	20.34	20.4093	20.3396	20.3857	11023068.0
2012-06-26 12:00:00	AAPL	Stock	20.3904	20.3971	20.3368	20.3574	9279704.0
2012-06-26 12:30:00	AAPL	Stock	20.36	20.3946	20.3511	20.3757	9420796.0
2012-06-26 13:00:00	AAPL	Stock	20.3757	20.3832	20.3571	20.3571	5280296.0
2012-06-26 13:30:00	AAPL	Stock	20.3571	20.3582	20.2618	20.2625	24266256.0
2012-06-26 14:00:00	AAPL	Stock	20.2636	20.4286	20.2625	20.4239	25440016.0
2012-06-26 14:30:00	AAPL	Stock	20.4232	20.4264	20.3321	20.3789	17232376.0
2012-06-26 15:00:00	AAPL	Stock	20.3782	20.4161	20.3746	20.3854	15514968.0
2012-06-26 15:30:00	AAPL	Stock	20.385	20.4589	20.3804	20.4307	26094152.0
2012-06-26 16:00:00	AAPL	Stock	20.4329	20.4387	20.3752	20.4286	7789348.0
2012-06-26 16:30:00	AAPL	Stock	20.4346	20.4346	20.3855	20.3855	242900.0
2012-06-26 17:00:00	AAPL	Stock	20.4196	20.425	20.4186	20.425	10640.0
2012-06-26 17:30:00	AAPL	Stock	20.4189	20.4189	20.4189	20.4189	2800.0
2012-06-26 18:00:00	AAPL	Stock	20.4268	20.4286	20.4221	20.4221	44828.0
2012-06-26 18:30:00	AAPL	Stock	20.4221	20.4264	20.4196	20.4225	39200.0
2012-06-26 19:00:00	AAPL	Stock	20.4239	20.425	20.4225	20.425	38276.0
2012-06-26 19:30:00	AAPL	Stock	20.4229	20.4232	20.4107	20.4107	125104.0
2012-06-26 07:30:00	MSFT	Stock	29.95	29.95	29.87	29.87	300.0
2012-06-26 08:00:00	MSFT	Stock	29.87	29.92	29.87	29.89	5552.0
2012-06-26 08:30:00	MSFT	Stock	29.86	29.93	29.84	29.84	24155.0
2012-06-26 09:00:00	MSFT	Stock	29.93	30.0	29.93	29.99	28043.0
2012-06-26 09:30:00	MSFT	Stock	30.0	30.26	29.97	30.14	5495447.0
2012-06-26 10:00:00	MSFT	Stock	30.14	30.27	30.065	30.12	3356387.0
2012-06-26 10:30:00	MSFT	Stock	30.13	30.17	30.07	30.13	3081572.0
2012-06-26 11:00:00	MSFT	Stock	30.13	30.24	29.95	30.01	3396515.0
2012-06-26 11:30:00	MSFT	Stock	30.005	30.13	30.005	30.07	2047044.0
2012-06-26 12:00:00	MSFT	Stock	30.065	30.12	29.995	30.035	2163730.0
2012-06-26 12:30:00	MSFT	Stock	30.04	30.11	30.01	30.015	1707525.0
2012-06-26 13:00:00	MSFT	Stock	30.015	30.04	29.96	29.975	1436878.0
2012-06-26 13:30:00	MSFT	Stock	29.975	30.05	29.94	30.038	1540831.0
2012-06-26 14:00:00	MSFT	Stock	30.031	30.12	30.03	30.074	1722907.0
2012-06-26 14:30:00	MSFT	Stock	30.08	30.09	29.99	30.055	2354488.0
2012-06-26 15:00:00	MSFT	Stock	30.05	30.1	30.01	30.042	2593526.0
2012-06-26 15:30:00	MSFT	Stock	30.05	30.14	30.0	30.0	4883135.0
2012-06-26 16:00:00	MSFT	Stock	30.035	30.083	29.822	30.02	2297443.0
2012-06-26 16:30:00	MSFT	Stock	29.99	30.06	29.99	30.06	69886.0

> showing 50 of 74,861 rows — these rows as CSV

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