PREVIEW / stock_30min / 2011-10-28

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-10-28.parquet
  size:    1.4 MB
  rows:    74,807
  symbols: 3,514

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
2011-10-28 04:00:00	AAPL	Stock	14.4643	14.4643	14.4643	14.4643	5600.0
2011-10-28 05:30:00	AAPL	Stock	14.4357	14.4357	14.4264	14.4329	11200.0
2011-10-28 06:00:00	AAPL	Stock	14.4436	14.4436	14.4121	14.4121	8400.0
2011-10-28 06:30:00	AAPL	Stock	14.405	14.4214	14.405	14.4214	22400.0
2011-10-28 07:00:00	AAPL	Stock	14.4214	14.4214	14.4	14.405	58800.0
2011-10-28 07:30:00	AAPL	Stock	14.3932	14.4	14.3789	14.3929	90552.0
2011-10-28 08:00:00	AAPL	Stock	14.3929	14.4532	14.3929	14.3971	412300.0
2011-10-28 08:30:00	AAPL	Stock	14.3971	14.4071	14.3643	14.3964	395276.0
2011-10-28 09:00:00	AAPL	Stock	14.3929	14.4046	14.3686	14.3914	442008.0
2011-10-28 09:30:00	AAPL	Stock	14.392	14.4893	14.3754	14.4596	48329344.0
2011-10-28 10:00:00	AAPL	Stock	14.465	14.475	14.4132	14.4139	30302552.0
2011-10-28 10:30:00	AAPL	Stock	14.4136	14.4604	14.4093	14.4418	24242148.0
2011-10-28 11:00:00	AAPL	Stock	14.4411	14.4607	14.4261	14.4532	19280380.0
2011-10-28 11:30:00	AAPL	Stock	14.4531	14.4575	14.3968	14.4086	21137536.0
2011-10-28 12:00:00	AAPL	Stock	14.4071	14.4193	14.3929	14.3996	10642520.0
2011-10-28 12:30:00	AAPL	Stock	14.3971	14.4361	14.3907	14.4248	14303884.0
2011-10-28 13:00:00	AAPL	Stock	14.4246	14.4639	14.4129	14.4547	14649432.0
2011-10-28 13:30:00	AAPL	Stock	14.4575	14.4643	14.4407	14.4494	12585412.0
2011-10-28 14:00:00	AAPL	Stock	14.4491	14.4507	14.4221	14.4304	13742904.0
2011-10-28 14:30:00	AAPL	Stock	14.4293	14.4536	14.4289	14.445	11342660.0
2011-10-28 15:00:00	AAPL	Stock	14.4464	14.4625	14.44	14.4511	15778364.0
2011-10-28 15:30:00	AAPL	Stock	14.451	14.5125	14.44	14.4657	48254220.0
2011-10-28 16:00:00	AAPL	Stock	14.4643	14.4714	14.4444	14.4636	27549956.0
2011-10-28 16:30:00	AAPL	Stock	14.4629	14.4686	14.4495	14.4643	440020.0
2011-10-28 17:00:00	AAPL	Stock	14.4532	14.4654	14.4532	14.4536	412972.0
2011-10-28 17:30:00	AAPL	Stock	14.4507	14.4529	14.4429	14.4432	183624.0
2011-10-28 18:00:00	AAPL	Stock	14.4625	14.4625	14.4461	14.4518	43120.0
2011-10-28 18:30:00	AAPL	Stock	14.4461	14.4525	14.4461	14.4464	21140.0
2011-10-28 19:00:00	AAPL	Stock	14.4468	14.4607	14.4468	14.4607	51688.0
2011-10-28 19:30:00	AAPL	Stock	14.4536	14.4607	14.4321	14.4357	345352.0
2011-10-28 06:30:00	MSFT	Stock	27.09	27.09	27.09	27.09	200.0
2011-10-28 07:00:00	MSFT	Stock	27.05	27.08	27.05	27.08	350.0
2011-10-28 07:30:00	MSFT	Stock	27.03	27.04	27.03	27.04	282.0
2011-10-28 08:00:00	MSFT	Stock	27.08	27.25	27.08	27.12	21310.0
2011-10-28 08:30:00	MSFT	Stock	27.14	27.17	27.04	27.11	5350.0
2011-10-28 09:00:00	MSFT	Stock	27.11	27.17	27.05	27.13	216496.0
2011-10-28 09:30:00	MSFT	Stock	27.09	27.19	26.79	26.885	7520824.0
2011-10-28 10:00:00	MSFT	Stock	26.88	27.0	26.81	26.892	4831298.0
2011-10-28 10:30:00	MSFT	Stock	26.89	26.94	26.79	26.89	3506127.0
2011-10-28 11:00:00	MSFT	Stock	26.89	26.94	26.85	26.89	2345168.0
2011-10-28 11:30:00	MSFT	Stock	26.89	26.94	26.81	26.84	2765643.0
2011-10-28 12:00:00	MSFT	Stock	26.83	26.86	26.81	26.83	2057175.0
2011-10-28 12:30:00	MSFT	Stock	26.83	26.91	26.82	26.9	2004600.0
2011-10-28 13:00:00	MSFT	Stock	26.9	26.98	26.9	26.97	2813047.0
2011-10-28 13:30:00	MSFT	Stock	26.965	26.97	26.88	26.935	2189423.0
2011-10-28 14:00:00	MSFT	Stock	26.935	26.95	26.87	26.92	2566036.0
2011-10-28 14:30:00	MSFT	Stock	26.915	26.97	26.9	26.961	2562535.0
2011-10-28 15:00:00	MSFT	Stock	26.96	27.0	26.94	26.97	3190720.0
2011-10-28 15:30:00	MSFT	Stock	26.97	27.0	26.9	26.98	6785472.0
2011-10-28 16:00:00	MSFT	Stock	26.97	27.03	26.911	26.98	9232292.0

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

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