PREVIEW / stock_30min / 2014-06-27

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-06-27.parquet
  size:    1.7 MB
  rows:    84,195
  symbols: 3,574

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-06-27 04:00:00	AAPL	Stock	22.7375	22.7375	22.7375	22.7375	3600.0
2014-06-27 04:30:00	AAPL	Stock	22.735	22.74	22.735	22.74	800.0
2014-06-27 05:00:00	AAPL	Stock	22.7475	22.7475	22.7475	22.7475	7160.0
2014-06-27 05:30:00	AAPL	Stock	22.7475	22.7475	22.7475	22.7475	5120.0
2014-06-27 06:00:00	AAPL	Stock	22.75	22.7575	22.7475	22.75	10872.0
2014-06-27 06:30:00	AAPL	Stock	22.78	22.78	22.7625	22.7625	11920.0
2014-06-27 07:00:00	AAPL	Stock	22.7575	22.7575	22.7275	22.75	20916.0
2014-06-27 07:30:00	AAPL	Stock	22.73	22.7575	22.73	22.7575	62296.0
2014-06-27 08:00:00	AAPL	Stock	22.76	22.7725	22.665	22.715	185152.0
2014-06-27 08:30:00	AAPL	Stock	22.7125	22.72	22.6925	22.705	133084.0
2014-06-27 09:00:00	AAPL	Stock	22.705	22.715	22.6675	22.7125	379592.0
2014-06-27 09:30:00	AAPL	Stock	22.705	22.9138	22.6925	22.8925	30399768.0
2014-06-27 10:00:00	AAPL	Stock	22.895	22.95	22.89	22.91	15248688.0
2014-06-27 10:30:00	AAPL	Stock	22.91	22.9175	22.855	22.885	8523664.0
2014-06-27 11:00:00	AAPL	Stock	22.885	22.9225	22.8645	22.87	6878136.0
2014-06-27 11:30:00	AAPL	Stock	22.8725	22.89	22.835	22.8858	5534676.0
2014-06-27 12:00:00	AAPL	Stock	22.8858	22.8925	22.84	22.8575	4509352.0
2014-06-27 12:30:00	AAPL	Stock	22.8575	22.9125	22.85	22.9025	4809208.0
2014-06-27 13:00:00	AAPL	Stock	22.9025	22.91	22.84	22.8638	6765648.0
2014-06-27 13:30:00	AAPL	Stock	22.8625	22.885	22.835	22.875	5713220.0
2014-06-27 14:00:00	AAPL	Stock	22.8775	22.905	22.87	22.8832	5427588.0
2014-06-27 14:30:00	AAPL	Stock	22.885	22.8875	22.82	22.8332	6841444.0
2014-06-27 15:00:00	AAPL	Stock	22.8325	22.9012	22.8325	22.9012	8122208.0
2014-06-27 15:30:00	AAPL	Stock	22.9008	23.0	22.9	22.99	25164300.0
2014-06-27 16:00:00	AAPL	Stock	22.9875	23.011	22.8455	22.985	46708760.0
2014-06-27 16:30:00	AAPL	Stock	22.996	23.0042	22.9048	22.9775	34584084.0
2014-06-27 17:00:00	AAPL	Stock	22.9775	22.9905	22.891	22.98	7287608.0
2014-06-27 17:30:00	AAPL	Stock	22.975	22.9995	22.975	22.98	8774916.0
2014-06-27 18:00:00	AAPL	Stock	22.9825	22.995	22.975	22.985	191152.0
2014-06-27 18:30:00	AAPL	Stock	22.98	22.9825	22.975	22.9775	25440.0
2014-06-27 19:00:00	AAPL	Stock	22.9775	22.985	22.975	22.985	43944.0
2014-06-27 19:30:00	AAPL	Stock	22.985	22.985	22.98	22.985	35040.0
2014-06-27 09:00:00	MSFT	Stock	41.68	41.68	41.55	41.61	23346.0
2014-06-27 09:30:00	MSFT	Stock	41.61	41.93	41.51	41.82	2894719.0
2014-06-27 10:00:00	MSFT	Stock	41.82	41.89	41.64	41.738	1628898.0
2014-06-27 10:30:00	MSFT	Stock	41.735	41.78	41.69	41.745	1179847.0
2014-06-27 11:00:00	MSFT	Stock	41.75	41.77	41.64	41.7	959288.0
2014-06-27 11:30:00	MSFT	Stock	41.71	41.78	41.65	41.705	714967.0
2014-06-27 12:00:00	MSFT	Stock	41.705	41.72	41.57	41.58	576216.0
2014-06-27 12:30:00	MSFT	Stock	41.585	41.62	41.525	41.62	783189.0
2014-06-27 13:00:00	MSFT	Stock	41.61	41.63	41.51	41.59	882607.0
2014-06-27 13:30:00	MSFT	Stock	41.585	41.74	41.58	41.72	872784.0
2014-06-27 14:00:00	MSFT	Stock	41.72	41.88	41.71	41.865	1422679.0
2014-06-27 14:30:00	MSFT	Stock	41.87	41.98	41.865	41.918	1302294.0
2014-06-27 15:00:00	MSFT	Stock	41.91	42.03	41.91	42.025	2296314.0
2014-06-27 15:30:00	MSFT	Stock	42.025	42.29	42.02	42.24	5888224.0
2014-06-27 16:00:00	MSFT	Stock	42.25	42.28	41.918	42.253	28556708.0
2014-06-27 16:30:00	MSFT	Stock	42.252	42.267	41.966	42.25	11736686.0
2014-06-27 17:00:00	MSFT	Stock	42.2	42.25	42.2	42.25	4006820.0
2014-06-27 17:30:00	MSFT	Stock	42.258	42.258	42.22	42.22	4199585.0

> showing 50 of 84,195 rows — these rows as CSV

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