PREVIEW / stock_30min / 2012-06-20

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-06-20.parquet
  size:    1.4 MB
  rows:    74,948
  symbols: 3,489

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-06-20 06:00:00	AAPL	Stock	20.9732	20.9732	20.9732	20.9732	2800.0
2012-06-20 07:00:00	AAPL	Stock	20.9989	21.025	20.9911	21.025	100800.0
2012-06-20 07:30:00	AAPL	Stock	21.0268	21.0311	21.0039	21.0039	48580.0
2012-06-20 08:00:00	AAPL	Stock	21.0	21.0321	20.9507	20.9946	319284.0
2012-06-20 08:30:00	AAPL	Stock	20.9868	20.9946	20.975	20.9911	239092.0
2012-06-20 09:00:00	AAPL	Stock	20.9914	21.0211	20.9875	21.0032	904204.0
2012-06-20 09:30:00	AAPL	Stock	21.0075	21.0446	20.9304	20.9589	36464960.0
2012-06-20 10:00:00	AAPL	Stock	20.9589	20.966	20.9039	20.9256	22944516.0
2012-06-20 10:30:00	AAPL	Stock	20.9236	20.9321	20.8311	20.87	33600196.0
2012-06-20 11:00:00	AAPL	Stock	20.8696	20.8929	20.8357	20.8789	16869272.0
2012-06-20 11:30:00	AAPL	Stock	20.8789	20.8929	20.8607	20.8686	8675884.0
2012-06-20 12:00:00	AAPL	Stock	20.8679	20.8696	20.75	20.7856	27015324.0
2012-06-20 12:30:00	AAPL	Stock	20.7854	20.9446	20.7429	20.9177	45806264.0
2012-06-20 13:00:00	AAPL	Stock	20.9211	21.0089	20.875	20.9054	38274152.0
2012-06-20 13:30:00	AAPL	Stock	20.9071	20.9546	20.8661	20.9504	16502696.0
2012-06-20 14:00:00	AAPL	Stock	20.9507	20.9582	20.8325	20.8589	21083216.0
2012-06-20 14:30:00	AAPL	Stock	20.8582	20.9075	20.8214	20.8371	19410496.0
2012-06-20 15:00:00	AAPL	Stock	20.8496	20.8714	20.7879	20.8525	21744464.0
2012-06-20 15:30:00	AAPL	Stock	20.855	20.9211	20.8336	20.9163	28563696.0
2012-06-20 16:00:00	AAPL	Stock	20.9196	20.9546	20.8707	20.9154	15710212.0
2012-06-20 16:30:00	AAPL	Stock	20.9143	20.9207	20.9143	20.9196	1480276.0
2012-06-20 17:00:00	AAPL	Stock	20.9186	20.9196	20.9146	20.9146	105560.0
2012-06-20 17:30:00	AAPL	Stock	20.9193	20.9232	20.9179	20.9232	38836.0
2012-06-20 18:00:00	AAPL	Stock	20.9221	20.9243	20.9179	20.9179	67844.0
2012-06-20 18:30:00	AAPL	Stock	20.9171	20.9171	20.9157	20.9157	21756.0
2012-06-20 19:00:00	AAPL	Stock	20.9146	20.9146	20.9	20.9	108724.0
2012-06-20 19:30:00	AAPL	Stock	20.8982	20.9107	20.8954	20.8954	87472.0
2012-06-20 07:00:00	MSFT	Stock	30.89	30.89	30.89	30.89	300.0
2012-06-20 08:00:00	MSFT	Stock	30.86	30.87	30.76	30.83	12057.0
2012-06-20 08:30:00	MSFT	Stock	30.81	30.83	30.79	30.8	4942.0
2012-06-20 09:00:00	MSFT	Stock	30.8	30.97	30.76	30.93	48911.0
2012-06-20 09:30:00	MSFT	Stock	30.94	30.99	30.64	30.76	3718855.0
2012-06-20 10:00:00	MSFT	Stock	30.76	30.8	30.69	30.74	2277701.0
2012-06-20 10:30:00	MSFT	Stock	30.74	30.81	30.72	30.81	2162559.0
2012-06-20 11:00:00	MSFT	Stock	30.805	30.98	30.8	30.98	3619729.0
2012-06-20 11:30:00	MSFT	Stock	30.98	31.05	30.97	30.973	1883026.0
2012-06-20 12:00:00	MSFT	Stock	30.973	30.98	30.75	30.86	1863505.0
2012-06-20 12:30:00	MSFT	Stock	30.855	30.99	30.65	30.965	3486144.0
2012-06-20 13:00:00	MSFT	Stock	30.97	31.05	30.92	30.93	2038659.0
2012-06-20 13:30:00	MSFT	Stock	30.94	30.99	30.89	30.98	1183594.0
2012-06-20 14:00:00	MSFT	Stock	30.975	31.01	30.82	30.85	1909391.0
2012-06-20 14:30:00	MSFT	Stock	30.85	30.92	30.73	30.79	2083191.0
2012-06-20 15:00:00	MSFT	Stock	30.8	30.81	30.65	30.799	2332113.0
2012-06-20 15:30:00	MSFT	Stock	30.79	30.93	30.76	30.93	4671694.0
2012-06-20 16:00:00	MSFT	Stock	30.93	31.05	30.803	30.93	1274257.0
2012-06-20 16:30:00	MSFT	Stock	31.03	31.03	30.682	30.93	455662.0
2012-06-20 17:00:00	MSFT	Stock	30.99	31.0	30.99	31.0	831.0
2012-06-20 17:30:00	MSFT	Stock	31.02	31.02	30.96	30.96	13190.0
2012-06-20 18:00:00	MSFT	Stock	30.95	31.0	30.92	30.93	18307.0
2012-06-20 18:30:00	MSFT	Stock	30.93	30.99	30.93	30.95	12403.0

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

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