PREVIEW / stock_30min / 2012-12-21

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-12-21.parquet
  size:    1.5 MB
  rows:    81,076
  symbols: 3,513

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-12-21 04:00:00	AAPL	Stock	18.5071	18.5071	18.3386	18.3707	61068.0
2012-12-21 04:30:00	AAPL	Stock	18.3579	18.3579	18.2768	18.2857	556388.0
2012-12-21 05:00:00	AAPL	Stock	18.26	18.3	18.26	18.2829	126644.0
2012-12-21 05:30:00	AAPL	Stock	18.2864	18.3036	18.2854	18.2964	59528.0
2012-12-21 06:00:00	AAPL	Stock	18.3075	18.3921	18.3075	18.3807	71232.0
2012-12-21 06:30:00	AAPL	Stock	18.3811	18.3893	18.3568	18.3875	22400.0
2012-12-21 07:00:00	AAPL	Stock	18.3393	18.3568	18.2321	18.3282	1034152.0
2012-12-21 07:30:00	AAPL	Stock	18.3143	18.3746	18.3082	18.3214	620704.0
2012-12-21 08:00:00	AAPL	Stock	18.3214	18.375	18.2354	18.2457	3187240.0
2012-12-21 08:30:00	AAPL	Stock	18.2425	18.3661	18.2261	18.2946	3287116.0
2012-12-21 09:00:00	AAPL	Stock	18.2932	18.3286	18.2321	18.3054	3086356.0
2012-12-21 09:30:00	AAPL	Stock	18.3061	18.3464	18.2229	18.2982	169476748.0
2012-12-21 10:00:00	AAPL	Stock	18.2941	18.5	18.2736	18.4429	68255236.0
2012-12-21 10:30:00	AAPL	Stock	18.445	18.4721	18.3929	18.4142	32008592.0
2012-12-21 11:00:00	AAPL	Stock	18.4132	18.4714	18.3689	18.4071	24229324.0
2012-12-21 11:30:00	AAPL	Stock	18.4071	18.4236	18.3321	18.3879	24675812.0
2012-12-21 12:00:00	AAPL	Stock	18.3821	18.3872	18.3357	18.3411	15118712.0
2012-12-21 12:30:00	AAPL	Stock	18.3457	18.3829	18.3218	18.3757	17384612.0
2012-12-21 13:00:00	AAPL	Stock	18.3783	18.3925	18.3361	18.3636	15248492.0
2012-12-21 13:30:00	AAPL	Stock	18.3646	18.4143	18.3536	18.3932	17760904.0
2012-12-21 14:00:00	AAPL	Stock	18.3934	18.4246	18.3668	18.38	17320464.0
2012-12-21 14:30:00	AAPL	Stock	18.3761	18.4179	18.3696	18.4032	16856308.0
2012-12-21 15:00:00	AAPL	Stock	18.4029	18.4304	18.3807	18.4289	23945264.0
2012-12-21 15:30:00	AAPL	Stock	18.4257	18.5596	18.4204	18.5475	70369348.0
2012-12-21 16:00:00	AAPL	Stock	18.5436	18.5775	18.2863	18.575	52267880.0
2012-12-21 16:30:00	AAPL	Stock	18.5714	18.5732	18.5474	18.57	5860288.0
2012-12-21 17:00:00	AAPL	Stock	18.5696	18.5771	18.5453	18.5729	457828.0
2012-12-21 17:30:00	AAPL	Stock	18.5696	18.5804	18.5438	18.5743	272076.0
2012-12-21 18:00:00	AAPL	Stock	18.5714	18.5768	18.5714	18.5768	93072.0
2012-12-21 18:30:00	AAPL	Stock	18.5768	18.5804	18.5721	18.575	114352.0
2012-12-21 19:00:00	AAPL	Stock	18.5729	18.5929	18.5729	18.5911	58660.0
2012-12-21 19:30:00	AAPL	Stock	18.5875	18.5946	18.5832	18.5893	96740.0
2012-12-21 05:00:00	MSFT	Stock	27.38	27.38	27.17	27.17	5000.0
2012-12-21 06:00:00	MSFT	Stock	27.38	27.38	27.38	27.38	200.0
2012-12-21 07:00:00	MSFT	Stock	27.37	27.38	27.23	27.25	1137.0
2012-12-21 07:30:00	MSFT	Stock	27.3	27.3	27.25	27.25	3200.0
2012-12-21 08:00:00	MSFT	Stock	27.3	27.4	27.24	27.24	25692.0
2012-12-21 08:30:00	MSFT	Stock	27.27	27.32	27.25	27.32	22255.0
2012-12-21 09:00:00	MSFT	Stock	27.32	27.48	27.17	27.19	187920.0
2012-12-21 09:30:00	MSFT	Stock	27.17	27.45	27.1	27.25	32620708.0
2012-12-21 10:00:00	MSFT	Stock	27.25	27.27	27.14	27.18	4555349.0
2012-12-21 10:30:00	MSFT	Stock	27.19	27.23	27.17	27.172	3326205.0
2012-12-21 11:00:00	MSFT	Stock	27.18	27.19	27.1	27.13	3119094.0
2012-12-21 11:30:00	MSFT	Stock	27.12	27.17	27.05	27.144	3158219.0
2012-12-21 12:00:00	MSFT	Stock	27.14	27.16	27.02	27.02	2913071.0
2012-12-21 12:30:00	MSFT	Stock	27.03	27.07	27.0	27.06	2765927.0
2012-12-21 13:00:00	MSFT	Stock	27.06	27.14	27.05	27.13	2600267.0
2012-12-21 13:30:00	MSFT	Stock	27.13	27.22	27.1	27.13	3560845.0
2012-12-21 14:00:00	MSFT	Stock	27.14	27.22	27.13	27.2	3206615.0
2012-12-21 14:30:00	MSFT	Stock	27.207	27.24	27.19	27.22	1848494.0

> showing 50 of 81,076 rows — these rows as CSV

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