PREVIEW / stock_30min / 2013-02-21

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-02-21.parquet
  size:    1.5 MB
  rows:    77,734
  symbols: 3,486

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
2013-02-21 05:30:00	AAPL	Stock	15.9339	15.9339	15.9279	15.9279	11200.0
2013-02-21 06:30:00	AAPL	Stock	15.9464	15.9464	15.9118	15.9118	14000.0
2013-02-21 07:00:00	AAPL	Stock	15.9196	15.9364	15.9196	15.9286	96908.0
2013-02-21 07:30:00	AAPL	Stock	15.9214	15.9214	15.8857	15.9079	445200.0
2013-02-21 08:00:00	AAPL	Stock	15.9157	16.0714	15.8936	15.9643	1144416.0
2013-02-21 08:30:00	AAPL	Stock	15.9729	16.0	15.9268	15.9396	1121232.0
2013-02-21 09:00:00	AAPL	Stock	15.945	15.9496	15.9118	15.9225	1863652.0
2013-02-21 09:30:00	AAPL	Stock	15.9193	16.003	15.8454	15.9011	70212772.0
2013-02-21 10:00:00	AAPL	Stock	15.8982	16.0157	15.8539	15.9784	45311336.0
2013-02-21 10:30:00	AAPL	Stock	15.9864	16.03	15.9382	15.9954	40816692.0
2013-02-21 11:00:00	AAPL	Stock	15.9939	16.0031	15.9107	15.9257	31427480.0
2013-02-21 11:30:00	AAPL	Stock	15.9243	15.9457	15.8907	15.9289	24687740.0
2013-02-21 12:00:00	AAPL	Stock	15.9289	15.9314	15.8664	15.885	16168348.0
2013-02-21 12:30:00	AAPL	Stock	15.885	15.8929	15.8536	15.8736	18867156.0
2013-02-21 13:00:00	AAPL	Stock	15.8754	15.9039	15.815	15.8464	21950348.0
2013-02-21 13:30:00	AAPL	Stock	15.8468	15.8643	15.8289	15.8493	14314776.0
2013-02-21 14:00:00	AAPL	Stock	15.8504	15.9071	15.8286	15.9014	22647884.0
2013-02-21 14:30:00	AAPL	Stock	15.9029	15.9821	15.8996	15.9821	34606600.0
2013-02-21 15:00:00	AAPL	Stock	15.9821	16.0418	15.9432	15.9857	36550584.0
2013-02-21 15:30:00	AAPL	Stock	15.99	16.0064	15.9046	15.9271	32790632.0
2013-02-21 16:00:00	AAPL	Stock	15.9286	15.9635	15.8873	15.9443	20638856.0
2013-02-21 16:30:00	AAPL	Stock	15.9361	15.986	15.9275	15.9489	1232476.0
2013-02-21 17:00:00	AAPL	Stock	15.9396	15.9464	15.9311	15.9379	182252.0
2013-02-21 17:30:00	AAPL	Stock	15.9411	15.9443	15.9393	15.9411	30800.0
2013-02-21 18:00:00	AAPL	Stock	15.9393	15.9461	15.9386	15.9411	25368.0
2013-02-21 18:30:00	AAPL	Stock	15.9411	15.9411	15.9307	15.9389	143276.0
2013-02-21 19:00:00	AAPL	Stock	15.9425	15.9568	15.9425	15.9536	294924.0
2013-02-21 19:30:00	AAPL	Stock	15.9571	15.9643	15.9536	15.9621	329868.0
2013-02-21 04:00:00	MSFT	Stock	27.8	27.8	27.8	27.8	101.0
2013-02-21 07:00:00	MSFT	Stock	27.8	27.82	27.72	27.72	9344.0
2013-02-21 08:00:00	MSFT	Stock	27.75	27.85	27.71	27.77	32577.0
2013-02-21 08:30:00	MSFT	Stock	27.76	27.79	27.72	27.79	17976.0
2013-02-21 09:00:00	MSFT	Stock	27.75	27.79	27.7	27.73	26959.0
2013-02-21 09:30:00	MSFT	Stock	27.73	27.74	27.52	27.57	5788020.0
2013-02-21 10:00:00	MSFT	Stock	27.56	27.6	27.5	27.598	4625711.0
2013-02-21 10:30:00	MSFT	Stock	27.595	27.62	27.49	27.49	4577705.0
2013-02-21 11:00:00	MSFT	Stock	27.495	27.56	27.45	27.505	4731535.0
2013-02-21 11:30:00	MSFT	Stock	27.51	27.545	27.48	27.53	2671408.0
2013-02-21 12:00:00	MSFT	Stock	27.522	27.53	27.23	27.48	3464563.0
2013-02-21 12:30:00	MSFT	Stock	27.48	27.54	27.455	27.5	2297576.0
2013-02-21 13:00:00	MSFT	Stock	27.501	27.53	27.43	27.45	2146527.0
2013-02-21 13:30:00	MSFT	Stock	27.455	27.5	27.44	27.495	2485895.0
2013-02-21 14:00:00	MSFT	Stock	27.5	27.51	27.46	27.49	2841239.0
2013-02-21 14:30:00	MSFT	Stock	27.48	27.57	27.48	27.559	3281181.0
2013-02-21 15:00:00	MSFT	Stock	27.55	27.63	27.52	27.58	2779292.0
2013-02-21 15:30:00	MSFT	Stock	27.58	27.58	27.46	27.47	4335282.0
2013-02-21 16:00:00	MSFT	Stock	27.49	27.57	27.467	27.57	2161798.0
2013-02-21 16:30:00	MSFT	Stock	27.533	27.57	27.484	27.56	227704.0
2013-02-21 17:00:00	MSFT	Stock	27.55	27.56	27.49	27.49	69363.0
2013-02-21 18:00:00	MSFT	Stock	27.53	27.53	27.53	27.53	100.0

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

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