PREVIEW / stock_30min / 2010-04-27

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-04-27.parquet
  size:    1.5 MB
  rows:    77,431
  symbols: 3,505

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-04-27 04:30:00	AAPL	Stock	9.5807	9.5807	9.5807	9.5807	2800.0
2010-04-27 05:00:00	AAPL	Stock	9.5786	9.5911	9.5786	9.5786	11200.0
2010-04-27 05:30:00	AAPL	Stock	9.5786	9.5786	9.5446	9.5446	19600.0
2010-04-27 06:00:00	AAPL	Stock	9.5379	9.5379	9.4932	9.4932	51520.0
2010-04-27 06:30:00	AAPL	Stock	9.5261	9.5268	9.5114	9.5114	103516.0
2010-04-27 07:00:00	AAPL	Stock	9.525	9.5536	9.5146	9.55	139720.0
2010-04-27 07:30:00	AAPL	Stock	9.5479	9.5571	9.5357	9.5571	214900.0
2010-04-27 08:00:00	AAPL	Stock	9.5479	9.5661	9.5446	9.5589	648200.0
2010-04-27 08:30:00	AAPL	Stock	9.5607	9.5657	9.5482	9.5614	609252.0
2010-04-27 09:00:00	AAPL	Stock	9.5607	9.5632	9.5432	9.5443	711144.0
2010-04-27 09:30:00	AAPL	Stock	9.5454	9.5496	9.4982	9.5354	83097196.0
2010-04-27 10:00:00	AAPL	Stock	9.5357	9.5539	9.5093	9.5318	41015128.0
2010-04-27 10:30:00	AAPL	Stock	9.53	9.5657	9.5257	9.5493	33237540.0
2010-04-27 11:00:00	AAPL	Stock	9.5493	9.5532	9.345	9.3571	82349596.0
2010-04-27 11:30:00	AAPL	Stock	9.3571	9.395	9.3043	9.3832	87298568.0
2010-04-27 12:00:00	AAPL	Stock	9.3832	9.4034	9.3321	9.3581	51992864.0
2010-04-27 12:30:00	AAPL	Stock	9.3579	9.3961	9.3571	9.3858	24478776.0
2010-04-27 13:00:00	AAPL	Stock	9.3868	9.4443	9.3861	9.4443	43617896.0
2010-04-27 13:30:00	AAPL	Stock	9.4443	9.4604	9.4196	9.4531	27567736.0
2010-04-27 14:00:00	AAPL	Stock	9.4532	9.4536	9.3929	9.4041	30746072.0
2010-04-27 14:30:00	AAPL	Stock	9.4032	9.4186	9.3839	9.3968	32842208.0
2010-04-27 15:00:00	AAPL	Stock	9.3968	9.4296	9.3807	9.3971	30764888.0
2010-04-27 15:30:00	AAPL	Stock	9.395	9.3976	9.3186	9.3654	85204196.0
2010-04-27 16:00:00	AAPL	Stock	9.3657	9.6287	9.3442	9.3679	12002620.0
2010-04-27 16:30:00	AAPL	Stock	9.3572	9.3962	9.3572	9.3689	3074512.0
2010-04-27 17:00:00	AAPL	Stock	9.3664	9.3711	9.3643	9.3711	150472.0
2010-04-27 17:30:00	AAPL	Stock	9.3679	9.3729	9.3664	9.3721	140224.0
2010-04-27 18:00:00	AAPL	Stock	9.3725	9.3739	9.3586	9.3705	958916.0
2010-04-27 18:30:00	AAPL	Stock	9.3704	9.3732	9.3679	9.3711	121464.0
2010-04-27 19:00:00	AAPL	Stock	9.3686	9.375	9.3686	9.375	108920.0
2010-04-27 19:30:00	AAPL	Stock	9.375	9.3857	9.3718	9.3857	140448.0
2010-04-27 20:00:00	AAPL	Stock	9.3593	9.3593	9.3593	9.3593	8400.0
2010-04-27 06:30:00	MSFT	Stock	31.02	31.02	31.02	31.02	600.0
2010-04-27 07:00:00	MSFT	Stock	30.93	30.93	30.93	30.93	300.0
2010-04-27 07:30:00	MSFT	Stock	30.95	31.04	30.95	31.04	1060.0
2010-04-27 08:00:00	MSFT	Stock	30.98	31.0	30.96	30.96	7968.0
2010-04-27 08:30:00	MSFT	Stock	30.98	31.0	30.98	30.99	6773.0
2010-04-27 09:00:00	MSFT	Stock	30.99	31.11	30.93	30.95	13121.0
2010-04-27 09:30:00	MSFT	Stock	30.94	31.24	30.93	31.18	8378259.0
2010-04-27 10:00:00	MSFT	Stock	31.18	31.22	31.111	31.2	4420680.0
2010-04-27 10:30:00	MSFT	Stock	31.2	31.25	31.135	31.2	3879144.0
2010-04-27 11:00:00	MSFT	Stock	31.2	31.21	30.925	30.94	6811604.0
2010-04-27 11:30:00	MSFT	Stock	30.94	30.95	30.8	30.842	6879752.0
2010-04-27 12:00:00	MSFT	Stock	30.85	30.99	30.82	30.84	4741153.0
2010-04-27 12:30:00	MSFT	Stock	30.848	30.89	30.8	30.86	2460302.0
2010-04-27 13:00:00	MSFT	Stock	30.855	31.0	30.83	30.995	3153247.0
2010-04-27 13:30:00	MSFT	Stock	30.995	31.0	30.91	30.915	2128453.0
2010-04-27 14:00:00	MSFT	Stock	30.91	30.96	30.84	30.922	2670621.0
2010-04-27 14:30:00	MSFT	Stock	30.93	30.94	30.84	30.858	2635801.0
2010-04-27 15:00:00	MSFT	Stock	30.86	30.988	30.83	30.92	4325726.0

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

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