PREVIEW / stock_30min / 2012-03-02

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-03-02.parquet
  size:    1.4 MB
  rows:    74,939
  symbols: 3,498

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-02 06:00:00	AAPL	Stock	19.4464	19.4464	19.4464	19.4464	5600.0
2012-03-02 06:30:00	AAPL	Stock	19.4464	19.4464	19.4464	19.4464	2800.0
2012-03-02 07:00:00	AAPL	Stock	19.4443	19.4443	19.4014	19.4196	329364.0
2012-03-02 07:30:00	AAPL	Stock	19.4161	19.4204	19.3714	19.4029	727244.0
2012-03-02 08:00:00	AAPL	Stock	19.4071	19.4464	19.3929	19.4143	2300116.0
2012-03-02 08:30:00	AAPL	Stock	19.4139	19.4243	19.3964	19.4007	501032.0
2012-03-02 09:00:00	AAPL	Stock	19.4032	19.4554	19.4007	19.4339	1313424.0
2012-03-02 09:30:00	AAPL	Stock	19.4371	19.4718	19.3757	19.4079	66155012.0
2012-03-02 10:00:00	AAPL	Stock	19.4075	19.4564	19.3857	19.4446	39831288.0
2012-03-02 10:30:00	AAPL	Stock	19.4404	19.4489	19.4211	19.4354	26063128.0
2012-03-02 11:00:00	AAPL	Stock	19.4368	19.5064	19.4111	19.4996	37062760.0
2012-03-02 11:30:00	AAPL	Stock	19.5025	19.5286	19.425	19.4668	49806092.0
2012-03-02 12:00:00	AAPL	Stock	19.4664	19.475	19.4382	19.4482	24833452.0
2012-03-02 12:30:00	AAPL	Stock	19.4482	19.4768	19.4464	19.4632	18134760.0
2012-03-02 13:00:00	AAPL	Stock	19.4641	19.4714	19.4311	19.4421	18632572.0
2012-03-02 13:30:00	AAPL	Stock	19.4414	19.4643	19.4304	19.4643	18972044.0
2012-03-02 14:00:00	AAPL	Stock	19.4639	19.48	19.4521	19.4714	20768328.0
2012-03-02 14:30:00	AAPL	Stock	19.4743	19.4754	19.4586	19.4682	15775452.0
2012-03-02 15:00:00	AAPL	Stock	19.4664	19.4786	19.4589	19.4657	19256720.0
2012-03-02 15:30:00	AAPL	Stock	19.4657	19.4893	19.4554	19.4661	51739016.0
2012-03-02 16:00:00	AAPL	Stock	19.4707	19.4786	19.4495	19.4672	8268064.0
2012-03-02 16:30:00	AAPL	Stock	19.4664	19.4768	19.4634	19.4714	2935828.0
2012-03-02 17:00:00	AAPL	Stock	19.4714	19.4718	19.4439	19.4439	623700.0
2012-03-02 17:30:00	AAPL	Stock	19.4536	19.4714	19.4468	19.4568	214480.0
2012-03-02 18:00:00	AAPL	Stock	19.4568	19.4568	19.4464	19.45	206024.0
2012-03-02 18:30:00	AAPL	Stock	19.4479	19.4518	19.4468	19.4471	14000.0
2012-03-02 19:00:00	AAPL	Stock	19.4468	19.4621	19.4468	19.46	145460.0
2012-03-02 19:30:00	AAPL	Stock	19.4618	19.4625	19.4393	19.4482	833644.0
2012-03-02 06:30:00	MSFT	Stock	32.33	32.33	32.33	32.33	200.0
2012-03-02 07:00:00	MSFT	Stock	32.27	32.27	32.2	32.2	1507.0
2012-03-02 07:30:00	MSFT	Stock	32.2	32.26	32.2	32.26	700.0
2012-03-02 08:00:00	MSFT	Stock	32.25	32.25	32.17	32.19	6242.0
2012-03-02 08:30:00	MSFT	Stock	32.2	32.28	32.2	32.28	4678.0
2012-03-02 09:00:00	MSFT	Stock	32.26	32.36	32.25	32.31	19581.0
2012-03-02 09:30:00	MSFT	Stock	32.32	32.34	32.06	32.13	4986717.0
2012-03-02 10:00:00	MSFT	Stock	32.12	32.36	32.11	32.28	3932863.0
2012-03-02 10:30:00	MSFT	Stock	32.285	32.44	32.215	32.38	4333710.0
2012-03-02 11:00:00	MSFT	Stock	32.39	32.4	32.29	32.31	4385303.0
2012-03-02 11:30:00	MSFT	Stock	32.305	32.31	32.14	32.19	4248662.0
2012-03-02 12:00:00	MSFT	Stock	32.195	32.22	32.09	32.1	2875777.0
2012-03-02 12:30:00	MSFT	Stock	32.092	32.21	32.09	32.175	2785086.0
2012-03-02 13:00:00	MSFT	Stock	32.17	32.18	32.09	32.11	1967527.0
2012-03-02 13:30:00	MSFT	Stock	32.1	32.13	32.08	32.1	1991070.0
2012-03-02 14:00:00	MSFT	Stock	32.105	32.15	32.09	32.1	1906200.0
2012-03-02 14:30:00	MSFT	Stock	32.1	32.11	32.07	32.1	1335056.0
2012-03-02 15:00:00	MSFT	Stock	32.1	32.11	32.02	32.06	2675330.0
2012-03-02 15:30:00	MSFT	Stock	32.06	32.1	32.0	32.08	6700840.0
2012-03-02 16:00:00	MSFT	Stock	32.08	32.181	32.005	32.08	2410335.0
2012-03-02 16:30:00	MSFT	Stock	32.02	32.08	32.01	32.02	343880.0
2012-03-02 17:00:00	MSFT	Stock	32.01	32.01	32.0	32.0	1560.0

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

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