PREVIEW / stock_30min / 2014-07-11

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-07-11.parquet
  size:    1.5 MB
  rows:    81,409
  symbols: 3,537

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
2014-07-11 04:00:00	AAPL	Stock	23.795	23.8125	23.7925	23.7925	4000.0
2014-07-11 04:30:00	AAPL	Stock	23.8125	23.8125	23.8075	23.8075	2448.0
2014-07-11 05:00:00	AAPL	Stock	23.8025	23.82	23.8025	23.81	7568.0
2014-07-11 05:30:00	AAPL	Stock	23.8075	23.8075	23.8	23.8	4000.0
2014-07-11 06:00:00	AAPL	Stock	23.8	23.8075	23.8	23.8075	8340.0
2014-07-11 06:30:00	AAPL	Stock	23.82	23.8375	23.8	23.8325	16560.0
2014-07-11 07:00:00	AAPL	Stock	23.81	23.835	23.81	23.825	32232.0
2014-07-11 07:30:00	AAPL	Stock	23.8225	23.8225	23.7875	23.7925	19484.0
2014-07-11 08:00:00	AAPL	Stock	23.81	23.8375	23.7875	23.825	217160.0
2014-07-11 08:30:00	AAPL	Stock	23.825	23.845	23.8025	23.805	147400.0
2014-07-11 09:00:00	AAPL	Stock	23.805	23.845	23.7975	23.8425	269936.0
2014-07-11 09:30:00	AAPL	Stock	23.84	23.905	23.74	23.825	22008576.0
2014-07-11 10:00:00	AAPL	Stock	23.825	23.9725	23.795	23.8848	17615740.0
2014-07-11 10:30:00	AAPL	Stock	23.8848	23.9475	23.8725	23.9175	7140808.0
2014-07-11 11:00:00	AAPL	Stock	23.9175	23.9375	23.8325	23.85	7181584.0
2014-07-11 11:30:00	AAPL	Stock	23.85	23.875	23.805	23.8375	7165456.0
2014-07-11 12:00:00	AAPL	Stock	23.835	23.835	23.77	23.7825	4905356.0
2014-07-11 12:30:00	AAPL	Stock	23.78	23.8075	23.7325	23.7575	5650000.0
2014-07-11 13:00:00	AAPL	Stock	23.755	23.8125	23.7525	23.7913	4783292.0
2014-07-11 13:30:00	AAPL	Stock	23.794	23.7975	23.7475	23.7512	4467124.0
2014-07-11 14:00:00	AAPL	Stock	23.752	23.7725	23.7155	23.76	6903588.0
2014-07-11 14:30:00	AAPL	Stock	23.7575	23.79	23.75	23.7625	5354520.0
2014-07-11 15:00:00	AAPL	Stock	23.765	23.7775	23.74	23.7575	5871656.0
2014-07-11 15:30:00	AAPL	Stock	23.755	23.805	23.7475	23.805	15424864.0
2014-07-11 16:00:00	AAPL	Stock	23.8075	23.8922	23.7838	23.8175	7734224.0
2014-07-11 16:30:00	AAPL	Stock	23.8175	23.8225	23.795	23.8175	95312.0
2014-07-11 17:00:00	AAPL	Stock	23.825	23.8325	23.8075	23.82	148972.0
2014-07-11 17:30:00	AAPL	Stock	23.82	23.83	23.8175	23.8225	49468.0
2014-07-11 18:00:00	AAPL	Stock	23.825	23.825	23.815	23.815	7800.0
2014-07-11 18:30:00	AAPL	Stock	23.815	23.82	23.8075	23.82	32956.0
2014-07-11 19:00:00	AAPL	Stock	23.815	23.8225	23.815	23.8225	28544.0
2014-07-11 19:30:00	AAPL	Stock	23.8175	23.8275	23.8175	23.8275	45368.0
2014-07-11 04:00:00	MSFT	Stock	41.7	41.7	41.7	41.7	100.0
2014-07-11 05:30:00	MSFT	Stock	41.7	41.7	41.7	41.7	100.0
2014-07-11 07:00:00	MSFT	Stock	41.82	41.82	41.82	41.82	100.0
2014-07-11 07:30:00	MSFT	Stock	41.84	41.85	41.84	41.85	200.0
2014-07-11 08:00:00	MSFT	Stock	41.9	41.9	41.7	41.7	2200.0
2014-07-11 08:30:00	MSFT	Stock	41.7	41.7	41.68	41.68	3000.0
2014-07-11 09:00:00	MSFT	Stock	41.7	41.78	41.7	41.71	80958.0
2014-07-11 09:30:00	MSFT	Stock	41.7	41.8	41.48	41.5	3601529.0
2014-07-11 10:00:00	MSFT	Stock	41.5	41.61	41.48	41.61	1714523.0
2014-07-11 10:30:00	MSFT	Stock	41.61	41.73	41.55	41.73	1081005.0
2014-07-11 11:00:00	MSFT	Stock	41.73	41.85	41.71	41.795	1253727.0
2014-07-11 11:30:00	MSFT	Stock	41.809	41.89	41.8	41.806	1049545.0
2014-07-11 12:00:00	MSFT	Stock	41.8	41.86	41.78	41.84	960777.0
2014-07-11 12:30:00	MSFT	Stock	41.84	41.91	41.84	41.881	842344.0
2014-07-11 13:00:00	MSFT	Stock	41.886	41.95	41.88	41.894	950216.0
2014-07-11 13:30:00	MSFT	Stock	41.89	41.95	41.88	41.93	1008343.0
2014-07-11 14:00:00	MSFT	Stock	41.93	41.975	41.91	41.965	1120440.0
2014-07-11 14:30:00	MSFT	Stock	41.968	42.015	41.95	41.96	1359014.0

> showing 50 of 81,409 rows — these rows as CSV

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