PREVIEW / stock_30min / 2011-11-18

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-11-18.parquet
  size:    1.4 MB
  rows:    72,281
  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
2011-11-18 04:30:00	AAPL	Stock	13.545	13.545	13.545	13.545	2800.0
2011-11-18 05:00:00	AAPL	Stock	13.545	13.545	13.545	13.545	5600.0
2011-11-18 05:30:00	AAPL	Stock	13.5357	13.5357	13.5357	13.5357	21000.0
2011-11-18 06:00:00	AAPL	Stock	13.5357	13.5357	13.5357	13.5357	25200.0
2011-11-18 06:30:00	AAPL	Stock	13.5354	13.5982	13.5354	13.5982	53200.0
2011-11-18 07:00:00	AAPL	Stock	13.5893	13.6071	13.5771	13.6071	148708.0
2011-11-18 07:30:00	AAPL	Stock	13.6179	13.6607	13.6161	13.6161	390040.0
2011-11-18 08:00:00	AAPL	Stock	13.6286	13.63	13.5829	13.5929	403396.0
2011-11-18 08:30:00	AAPL	Stock	13.5989	13.6068	13.5893	13.6	616560.0
2011-11-18 09:00:00	AAPL	Stock	13.6	13.6	13.5289	13.5325	1234968.0
2011-11-18 09:30:00	AAPL	Stock	13.5325	13.5529	13.4375	13.5029	59640056.0
2011-11-18 10:00:00	AAPL	Stock	13.5	13.5318	13.4529	13.4757	30974440.0
2011-11-18 10:30:00	AAPL	Stock	13.475	13.5554	13.4639	13.5396	25124568.0
2011-11-18 11:00:00	AAPL	Stock	13.5368	13.5711	13.5207	13.5318	23340212.0
2011-11-18 11:30:00	AAPL	Stock	13.5318	13.5361	13.4925	13.4982	15347444.0
2011-11-18 12:00:00	AAPL	Stock	13.5011	13.5018	13.4289	13.4729	22566348.0
2011-11-18 12:30:00	AAPL	Stock	13.4729	13.5014	13.4521	13.4671	13799660.0
2011-11-18 13:00:00	AAPL	Stock	13.4671	13.485	13.4543	13.4779	8644048.0
2011-11-18 13:30:00	AAPL	Stock	13.4803	13.4929	13.4539	13.4587	12701920.0
2011-11-18 14:00:00	AAPL	Stock	13.46	13.48	13.4314	13.4455	17526180.0
2011-11-18 14:30:00	AAPL	Stock	13.4459	13.4571	13.3929	13.4018	30661288.0
2011-11-18 15:00:00	AAPL	Stock	13.4025	13.4282	13.3943	13.4014	24874976.0
2011-11-18 15:30:00	AAPL	Stock	13.4025	13.4168	13.3886	13.3911	46934972.0
2011-11-18 16:00:00	AAPL	Stock	13.3932	13.5162	13.3906	13.3914	12193636.0
2011-11-18 16:30:00	AAPL	Stock	13.3911	13.3995	13.3911	13.3943	1333584.0
2011-11-18 17:00:00	AAPL	Stock	13.3929	13.3932	13.3907	13.3921	471772.0
2011-11-18 17:30:00	AAPL	Stock	13.3929	13.3929	13.3875	13.3911	57736.0
2011-11-18 18:00:00	AAPL	Stock	13.3893	13.3907	13.3893	13.3904	22960.0
2011-11-18 18:30:00	AAPL	Stock	13.3904	13.3929	13.3882	13.3929	58324.0
2011-11-18 19:00:00	AAPL	Stock	13.3939	13.3939	13.3918	13.3929	41440.0
2011-11-18 19:30:00	AAPL	Stock	13.3925	13.3929	13.3893	13.3929	36456.0
2011-11-18 07:00:00	MSFT	Stock	25.7	25.7	25.7	25.7	200.0
2011-11-18 07:30:00	MSFT	Stock	25.62	25.7	25.62	25.65	5500.0
2011-11-18 08:00:00	MSFT	Stock	25.65	25.7	25.64	25.65	17025.0
2011-11-18 08:30:00	MSFT	Stock	25.67	25.71	25.63	25.71	11900.0
2011-11-18 09:00:00	MSFT	Stock	25.67	25.7	25.42	25.45	93121.0
2011-11-18 09:30:00	MSFT	Stock	25.5	25.5	25.25	25.27	10455948.0
2011-11-18 10:00:00	MSFT	Stock	25.27	25.27	25.15	25.23	4968020.0
2011-11-18 10:30:00	MSFT	Stock	25.23	25.42	25.22	25.39	4434474.0
2011-11-18 11:00:00	MSFT	Stock	25.39	25.45	25.35	25.388	2729803.0
2011-11-18 11:30:00	MSFT	Stock	25.389	25.42	25.31	25.315	2151215.0
2011-11-18 12:00:00	MSFT	Stock	25.315	25.34	25.23	25.328	2080041.0
2011-11-18 12:30:00	MSFT	Stock	25.325	25.4	25.32	25.379	1505765.0
2011-11-18 13:00:00	MSFT	Stock	25.37	25.47	25.35	25.435	2327366.0
2011-11-18 13:30:00	MSFT	Stock	25.435	25.445	25.35	25.36	1558384.0
2011-11-18 14:00:00	MSFT	Stock	25.35	25.459	25.32	25.38	2910327.0
2011-11-18 14:30:00	MSFT	Stock	25.38	25.41	25.31	25.32	2210346.0
2011-11-18 15:00:00	MSFT	Stock	25.32	25.38	25.31	25.31	2017714.0
2011-11-18 15:30:00	MSFT	Stock	25.31	25.37	25.29	25.3	5048139.0
2011-11-18 16:00:00	MSFT	Stock	25.3	25.54	25.29	25.3	2116706.0

> showing 50 of 72,281 rows — these rows as CSV

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