PREVIEW / stock_30min / 2011-05-02

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-05-02.parquet
  size:    1.4 MB
  rows:    76,396
  symbols: 3,567

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-05-02 04:00:00	AAPL	Stock	12.5786	12.6071	12.5786	12.6071	60760.0
2011-05-02 04:30:00	AAPL	Stock	12.5932	12.5932	12.5932	12.5932	2800.0
2011-05-02 05:00:00	AAPL	Stock	12.6071	12.6071	12.6071	12.6071	5600.0
2011-05-02 05:30:00	AAPL	Stock	12.6154	12.6154	12.6071	12.6071	11200.0
2011-05-02 06:00:00	AAPL	Stock	12.5829	12.61	12.5714	12.6018	65800.0
2011-05-02 06:30:00	AAPL	Stock	12.6018	12.6018	12.5961	12.5961	81760.0
2011-05-02 07:00:00	AAPL	Stock	12.5796	12.5857	12.5368	12.5857	804244.0
2011-05-02 07:30:00	AAPL	Stock	12.5871	12.5964	12.5539	12.5689	1014720.0
2011-05-02 08:00:00	AAPL	Stock	12.5643	12.5732	12.4368	12.5129	2856448.0
2011-05-02 08:30:00	AAPL	Stock	12.5132	12.5175	12.4475	12.4671	6509048.0
2011-05-02 09:00:00	AAPL	Stock	12.4668	12.5046	12.4368	12.4921	4397008.0
2011-05-02 09:30:00	AAPL	Stock	12.4904	12.5167	12.425	12.4714	97405756.0
2011-05-02 10:00:00	AAPL	Stock	12.4714	12.4918	12.4432	12.4639	40385128.0
2011-05-02 10:30:00	AAPL	Stock	12.4636	12.4764	12.4107	12.4189	35084392.0
2011-05-02 11:00:00	AAPL	Stock	12.4161	12.4518	12.4	12.4079	25640692.0
2011-05-02 11:30:00	AAPL	Stock	12.4079	12.4161	12.3839	12.4065	22596784.0
2011-05-02 12:00:00	AAPL	Stock	12.4054	12.4168	12.3843	12.3846	15472184.0
2011-05-02 12:30:00	AAPL	Stock	12.3846	12.3946	12.3543	12.3764	27417992.0
2011-05-02 13:00:00	AAPL	Stock	12.3761	12.4444	12.3757	12.4386	19715668.0
2011-05-02 13:30:00	AAPL	Stock	12.4389	12.4392	12.4089	12.4133	9417464.0
2011-05-02 14:00:00	AAPL	Stock	12.4121	12.445	12.4029	12.4032	17540544.0
2011-05-02 14:30:00	AAPL	Stock	12.4043	12.4143	12.3696	12.3696	16953272.0
2011-05-02 15:00:00	AAPL	Stock	12.37	12.3929	12.3571	12.3643	18987444.0
2011-05-02 15:30:00	AAPL	Stock	12.3643	12.3711	12.3393	12.3653	45685388.0
2011-05-02 16:00:00	AAPL	Stock	12.3671	12.4463	12.3625	12.3693	20574820.0
2011-05-02 16:30:00	AAPL	Stock	12.3682	12.3725	12.3499	12.3725	179312.0
2011-05-02 17:00:00	AAPL	Stock	12.3736	12.3739	12.3661	12.3736	70616.0
2011-05-02 17:30:00	AAPL	Stock	12.3736	12.3743	12.3732	12.3732	14616.0
2011-05-02 18:00:00	AAPL	Stock	12.3714	12.4011	12.3671	12.3929	578900.0
2011-05-02 18:30:00	AAPL	Stock	12.3921	12.4111	12.3832	12.3964	301504.0
2011-05-02 19:00:00	AAPL	Stock	12.3929	12.3932	12.3804	12.3804	114296.0
2011-05-02 19:30:00	AAPL	Stock	12.3929	12.3964	12.3875	12.3929	118160.0
2011-05-02 04:00:00	MSFT	Stock	26.0	26.05	26.0	26.05	4100.0
2011-05-02 05:30:00	MSFT	Stock	26.15	26.15	26.14	26.14	1700.0
2011-05-02 06:00:00	MSFT	Stock	26.14	26.14	26.14	26.14	250.0
2011-05-02 06:30:00	MSFT	Stock	26.1	26.1	26.09	26.09	2866.0
2011-05-02 07:00:00	MSFT	Stock	26.09	26.09	26.03	26.03	11663.0
2011-05-02 07:30:00	MSFT	Stock	26.03	26.06	25.96	26.0	49888.0
2011-05-02 08:00:00	MSFT	Stock	26.03	26.04	25.96	25.98	61473.0
2011-05-02 08:30:00	MSFT	Stock	25.98	26.02	25.93	25.95	205536.0
2011-05-02 09:00:00	MSFT	Stock	25.95	25.98	25.92	25.95	132584.0
2011-05-02 09:30:00	MSFT	Stock	25.94	26.0	25.59	25.6	15167940.0
2011-05-02 10:00:00	MSFT	Stock	25.59	25.68	25.52	25.63	8663690.0
2011-05-02 10:30:00	MSFT	Stock	25.63	25.69	25.625	25.65	6262799.0
2011-05-02 11:00:00	MSFT	Stock	25.65	25.77	25.64	25.656	6609698.0
2011-05-02 11:30:00	MSFT	Stock	25.651	25.66	25.55	25.58	5041861.0
2011-05-02 12:00:00	MSFT	Stock	25.585	25.62	25.51	25.52	4627033.0
2011-05-02 12:30:00	MSFT	Stock	25.52	25.57	25.48	25.49	5445403.0
2011-05-02 13:00:00	MSFT	Stock	25.485	25.58	25.48	25.56	5060400.0
2011-05-02 13:30:00	MSFT	Stock	25.57	25.58	25.53	25.56	2548561.0

> showing 50 of 76,396 rows — these rows as CSV

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