PREVIEW / stock_30min / 2011-09-30

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-09-30.parquet
  size:    1.4 MB
  rows:    75,173
  symbols: 3,520

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-09-30 04:00:00	AAPL	Stock	13.9932	13.9932	13.9325	13.9325	5600.0
2011-09-30 04:30:00	AAPL	Stock	13.9071	13.9071	13.9071	13.9071	2800.0
2011-09-30 05:00:00	AAPL	Stock	13.8518	13.8536	13.8393	13.8536	8400.0
2011-09-30 05:30:00	AAPL	Stock	13.8536	13.8661	13.8536	13.865	8400.0
2011-09-30 06:00:00	AAPL	Stock	13.8468	13.8714	13.8254	13.83	29372.0
2011-09-30 06:30:00	AAPL	Stock	13.8357	13.8357	13.8171	13.8171	8400.0
2011-09-30 07:00:00	AAPL	Stock	13.8393	13.8639	13.8275	13.8393	336980.0
2011-09-30 07:30:00	AAPL	Stock	13.8286	13.8643	13.8286	13.8393	359576.0
2011-09-30 08:00:00	AAPL	Stock	13.8525	13.9196	13.8461	13.9018	1100652.0
2011-09-30 08:30:00	AAPL	Stock	13.8982	13.9121	13.8325	13.8393	1492428.0
2011-09-30 09:00:00	AAPL	Stock	13.8339	13.8393	13.8	13.8243	1147972.0
2011-09-30 09:30:00	AAPL	Stock	13.8277	13.835	13.6504	13.7039	101182760.0
2011-09-30 10:00:00	AAPL	Stock	13.7039	13.8532	13.6789	13.8125	63467012.0
2011-09-30 10:30:00	AAPL	Stock	13.8125	13.8268	13.7218	13.7339	36824424.0
2011-09-30 11:00:00	AAPL	Stock	13.7332	13.875	13.73	13.8511	36645924.0
2011-09-30 11:30:00	AAPL	Stock	13.8521	13.8889	13.8139	13.8318	30968784.0
2011-09-30 12:00:00	AAPL	Stock	13.8321	13.8475	13.7929	13.8275	17042312.0
2011-09-30 12:30:00	AAPL	Stock	13.8275	13.8379	13.7829	13.7953	15583932.0
2011-09-30 13:00:00	AAPL	Stock	13.7875	13.8061	13.7536	13.7954	19575220.0
2011-09-30 13:30:00	AAPL	Stock	13.7915	13.825	13.7789	13.7789	18388804.0
2011-09-30 14:00:00	AAPL	Stock	13.7786	13.7871	13.7325	13.7661	29203496.0
2011-09-30 14:30:00	AAPL	Stock	13.7661	13.7739	13.7093	13.7582	29168832.0
2011-09-30 15:00:00	AAPL	Stock	13.755	13.7736	13.6807	13.6807	29216656.0
2011-09-30 15:30:00	AAPL	Stock	13.6824	13.7143	13.6139	13.6143	77630644.0
2011-09-30 16:00:00	AAPL	Stock	13.6139	13.8285	13.5975	13.62	27032040.0
2011-09-30 16:30:00	AAPL	Stock	13.62	13.7054	13.6071	13.6214	5681732.0
2011-09-30 17:00:00	AAPL	Stock	13.6204	13.6243	13.6025	13.6071	461748.0
2011-09-30 17:30:00	AAPL	Stock	13.6068	13.6196	13.6018	13.6179	80500.0
2011-09-30 18:00:00	AAPL	Stock	13.6179	13.6214	13.5936	13.5936	112224.0
2011-09-30 18:30:00	AAPL	Stock	13.5929	13.5929	13.575	13.5804	213472.0
2011-09-30 19:00:00	AAPL	Stock	13.5721	13.6186	13.5714	13.5786	240576.0
2011-09-30 19:30:00	AAPL	Stock	13.5836	13.5929	13.5732	13.5857	56504.0
2011-09-30 07:30:00	MSFT	Stock	25.19	25.25	25.19	25.23	3100.0
2011-09-30 08:00:00	MSFT	Stock	25.28	25.32	25.25	25.29	7600.0
2011-09-30 08:30:00	MSFT	Stock	25.26	25.29	25.25	25.25	10500.0
2011-09-30 09:00:00	MSFT	Stock	25.25	25.25	25.19	25.21	23614.0
2011-09-30 09:30:00	MSFT	Stock	25.21	25.46	25.17	25.225	6770311.0
2011-09-30 10:00:00	MSFT	Stock	25.22	25.5	25.2	25.389	4801996.0
2011-09-30 10:30:00	MSFT	Stock	25.38	25.39	25.185	25.2	3046348.0
2011-09-30 11:00:00	MSFT	Stock	25.2	25.31	25.162	25.178	2572352.0
2011-09-30 11:30:00	MSFT	Stock	25.18	25.33	25.178	25.29	1961241.0
2011-09-30 12:00:00	MSFT	Stock	25.28	25.32	25.24	25.29	1526292.0
2011-09-30 12:30:00	MSFT	Stock	25.29	25.29	25.15	25.16	1481603.0
2011-09-30 13:00:00	MSFT	Stock	25.15	25.22	25.1	25.18	1337103.0
2011-09-30 13:30:00	MSFT	Stock	25.178	25.3	25.17	25.26	1481918.0
2011-09-30 14:00:00	MSFT	Stock	25.25	25.26	25.04	25.12	3034423.0
2011-09-30 14:30:00	MSFT	Stock	25.11	25.17	25.02	25.14	2922211.0
2011-09-30 15:00:00	MSFT	Stock	25.14	25.24	25.03	25.04	2838460.0
2011-09-30 15:30:00	MSFT	Stock	25.04	25.11	24.88	24.898	10707491.0
2011-09-30 16:00:00	MSFT	Stock	24.9	25.19	24.84	24.89	7325592.0

> showing 50 of 75,173 rows — these rows as CSV

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