PREVIEW / stock_30min / 2012-12-27

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-12-27.parquet
  size:    1.4 MB
  rows:    74,817
  symbols: 3,510

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-27 04:00:00	AAPL	Stock	18.2504	18.2504	18.2504	18.2504	5600.0
2012-12-27 04:30:00	AAPL	Stock	18.1968	18.1968	18.1968	18.1968	5600.0
2012-12-27 05:00:00	AAPL	Stock	18.2143	18.2143	18.1982	18.2071	78372.0
2012-12-27 06:00:00	AAPL	Stock	18.2043	18.2043	18.2018	18.2018	5600.0
2012-12-27 06:30:00	AAPL	Stock	18.2179	18.2179	18.2179	18.2179	2800.0
2012-12-27 07:00:00	AAPL	Stock	18.2146	18.3446	18.2146	18.3393	162988.0
2012-12-27 07:30:00	AAPL	Stock	18.3482	18.3568	18.3214	18.3393	99624.0
2012-12-27 08:00:00	AAPL	Stock	18.3393	18.4225	18.2464	18.3911	816536.0
2012-12-27 08:30:00	AAPL	Stock	18.3914	18.3982	18.3386	18.3811	801556.0
2012-12-27 09:00:00	AAPL	Stock	18.3643	18.3961	18.34	18.3429	777896.0
2012-12-27 09:30:00	AAPL	Stock	18.3407	18.3561	18.2321	18.2646	44124920.0
2012-12-27 10:00:00	AAPL	Stock	18.2636	18.265	18.1571	18.1971	48494404.0
2012-12-27 10:30:00	AAPL	Stock	18.2018	18.2121	18.1429	18.1971	24159828.0
2012-12-27 11:00:00	AAPL	Stock	18.1946	18.2507	18.1879	18.22	22354472.0
2012-12-27 11:30:00	AAPL	Stock	18.2182	18.2321	18.1618	18.1843	16274020.0
2012-12-27 12:00:00	AAPL	Stock	18.185	18.2	18.1114	18.1354	25913804.0
2012-12-27 12:30:00	AAPL	Stock	18.1357	18.1357	18.0571	18.1021	33380340.0
2012-12-27 13:00:00	AAPL	Stock	18.1096	18.1464	18.0811	18.0954	21318024.0
2012-12-27 13:30:00	AAPL	Stock	18.0979	18.1154	18.0596	18.0714	16611028.0
2012-12-27 14:00:00	AAPL	Stock	18.0711	18.0843	18.0432	18.0489	20286504.0
2012-12-27 14:30:00	AAPL	Stock	18.0486	18.2354	18.0236	18.2321	50114596.0
2012-12-27 15:00:00	AAPL	Stock	18.2325	18.3929	18.2	18.3164	51501828.0
2012-12-27 15:30:00	AAPL	Stock	18.3125	18.4375	18.3061	18.3912	60943036.0
2012-12-27 16:00:00	AAPL	Stock	18.3894	18.4007	18.2132	18.395	6738116.0
2012-12-27 16:30:00	AAPL	Stock	18.3714	18.3786	18.3671	18.3786	530208.0
2012-12-27 17:00:00	AAPL	Stock	18.3704	18.3793	18.3696	18.3757	144228.0
2012-12-27 17:30:00	AAPL	Stock	18.375	18.3757	18.3575	18.3575	113484.0
2012-12-27 18:00:00	AAPL	Stock	18.3689	18.3839	18.3482	18.3839	216636.0
2012-12-27 18:30:00	AAPL	Stock	18.3768	18.3821	18.3679	18.3679	131404.0
2012-12-27 19:00:00	AAPL	Stock	18.375	18.375	18.3654	18.3654	67564.0
2012-12-27 19:30:00	AAPL	Stock	18.3696	18.3921	18.3682	18.3918	266028.0
2012-12-27 04:30:00	MSFT	Stock	27.04	27.04	27.04	27.04	500.0
2012-12-27 07:30:00	MSFT	Stock	26.99	27.01	26.98	27.01	1660.0
2012-12-27 08:00:00	MSFT	Stock	26.96	27.01	26.94	26.94	9060.0
2012-12-27 08:30:00	MSFT	Stock	26.93	26.95	26.87	26.94	122851.0
2012-12-27 09:00:00	MSFT	Stock	26.94	26.94	26.85	26.89	14940.0
2012-12-27 09:30:00	MSFT	Stock	26.89	26.93	26.8	26.9	2925303.0
2012-12-27 10:00:00	MSFT	Stock	26.9	26.95	26.72	26.76	3309597.0
2012-12-27 10:30:00	MSFT	Stock	26.75	26.82	26.7	26.8	2075068.0
2012-12-27 11:00:00	MSFT	Stock	26.795	26.83	26.71	26.76	2146683.0
2012-12-27 11:30:00	MSFT	Stock	26.755	26.8	26.62	26.662	2250134.0
2012-12-27 12:00:00	MSFT	Stock	26.664	26.73	26.57	26.73	2731416.0
2012-12-27 12:30:00	MSFT	Stock	26.73	26.79	26.64	26.772	2618731.0
2012-12-27 13:00:00	MSFT	Stock	26.78	26.8	26.73	26.761	2520076.0
2012-12-27 13:30:00	MSFT	Stock	26.76	26.82	26.76	26.794	2051722.0
2012-12-27 14:00:00	MSFT	Stock	26.79	26.82	26.74	26.745	1895540.0
2012-12-27 14:30:00	MSFT	Stock	26.745	26.99	26.73	26.945	3583336.0
2012-12-27 15:00:00	MSFT	Stock	26.94	27.02	26.9	26.96	3596638.0
2012-12-27 15:30:00	MSFT	Stock	26.96	27.09	26.95	26.95	5466503.0
2012-12-27 16:00:00	MSFT	Stock	26.96	27.014	26.779	26.96	1497715.0

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

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