PREVIEW / stock_30min / 2014-11-25

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-11-25.parquet
  size:    1.6 MB
  rows:    82,834
  symbols: 3,562

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-11-25 04:00:00	AAPL	Stock	29.6825	29.8625	29.6825	29.7475	28800.0
2014-11-25 04:30:00	AAPL	Stock	29.7475	29.75	29.7375	29.74	7652.0
2014-11-25 05:00:00	AAPL	Stock	29.7375	29.7625	29.7375	29.75	31600.0
2014-11-25 05:30:00	AAPL	Stock	29.7525	29.7525	29.7375	29.75	27080.0
2014-11-25 06:00:00	AAPL	Stock	29.7525	29.7825	29.75	29.75	25116.0
2014-11-25 06:30:00	AAPL	Stock	29.7675	29.7675	29.725	29.7375	15448.0
2014-11-25 07:00:00	AAPL	Stock	29.74	29.74	29.705	29.7125	125036.0
2014-11-25 07:30:00	AAPL	Stock	29.7125	29.765	29.7	29.755	296428.0
2014-11-25 08:00:00	AAPL	Stock	29.7525	29.77	29.48	29.75	500848.0
2014-11-25 08:30:00	AAPL	Stock	29.7475	29.8325	29.7425	29.81	831216.0
2014-11-25 09:00:00	AAPL	Stock	29.81	29.8125	29.755	29.7625	578248.0
2014-11-25 09:30:00	AAPL	Stock	29.7675	29.9375	29.76	29.8282	44384680.0
2014-11-25 10:00:00	AAPL	Stock	29.8298	29.87	29.675	29.8338	24371588.0
2014-11-25 10:30:00	AAPL	Stock	29.8338	29.91	29.8175	29.8312	15289988.0
2014-11-25 11:00:00	AAPL	Stock	29.8325	29.87	29.7625	29.795	11122040.0
2014-11-25 11:30:00	AAPL	Stock	29.795	29.835	29.7625	29.77	8822452.0
2014-11-25 12:00:00	AAPL	Stock	29.7678	29.7825	29.6125	29.665	15211444.0
2014-11-25 12:30:00	AAPL	Stock	29.665	29.6775	29.3625	29.395	25684332.0
2014-11-25 13:00:00	AAPL	Stock	29.3875	29.6225	29.385	29.5888	19192716.0
2014-11-25 13:30:00	AAPL	Stock	29.59	29.615	29.4875	29.506	9747344.0
2014-11-25 14:00:00	AAPL	Stock	29.5075	29.5752	29.475	29.5028	9316640.0
2014-11-25 14:30:00	AAPL	Stock	29.5042	29.5325	29.4375	29.4675	10147604.0
2014-11-25 15:00:00	AAPL	Stock	29.47	29.51	29.445	29.4548	9723976.0
2014-11-25 15:30:00	AAPL	Stock	29.455	29.4825	29.4	29.4	22769020.0
2014-11-25 16:00:00	AAPL	Stock	29.4	29.8755	29.3938	29.4225	21969228.0
2014-11-25 16:30:00	AAPL	Stock	29.42	29.435	29.3952	29.4325	85212.0
2014-11-25 17:00:00	AAPL	Stock	29.4325	29.5205	29.4225	29.425	59920.0
2014-11-25 17:30:00	AAPL	Stock	29.4	29.435	29.4	29.435	202764.0
2014-11-25 18:00:00	AAPL	Stock	29.435	29.435	29.4275	29.43	53068.0
2014-11-25 18:30:00	AAPL	Stock	29.4325	29.4425	29.4	29.4425	98492.0
2014-11-25 19:00:00	AAPL	Stock	29.445	29.445	29.4375	29.445	23516.0
2014-11-25 19:30:00	AAPL	Stock	29.445	29.445	29.425	29.4325	74072.0
2014-11-25 07:00:00	MSFT	Stock	47.63	47.63	47.56	47.56	200.0
2014-11-25 07:30:00	MSFT	Stock	47.56	47.56	47.56	47.56	100.0
2014-11-25 08:00:00	MSFT	Stock	47.63	47.63	47.5	47.52	4000.0
2014-11-25 08:30:00	MSFT	Stock	47.58	47.66	47.56	47.6	3045.0
2014-11-25 09:00:00	MSFT	Stock	47.6	47.62	47.52	47.61	8771.0
2014-11-25 09:30:00	MSFT	Stock	47.66	47.97	47.52	47.925	3685411.0
2014-11-25 10:00:00	MSFT	Stock	47.93	47.93	47.7	47.79	1931783.0
2014-11-25 10:30:00	MSFT	Stock	47.781	47.81	47.66	47.78	1433003.0
2014-11-25 11:00:00	MSFT	Stock	47.78	47.96	47.78	47.93	788491.0
2014-11-25 11:30:00	MSFT	Stock	47.93	47.93	47.77	47.799	1160015.0
2014-11-25 12:00:00	MSFT	Stock	47.8	47.82	47.77	47.775	494681.0
2014-11-25 12:30:00	MSFT	Stock	47.78	47.855	47.775	47.815	1050342.0
2014-11-25 13:00:00	MSFT	Stock	47.815	47.85	47.78	47.84	832055.0
2014-11-25 13:30:00	MSFT	Stock	47.84	47.86	47.72	47.76	1037932.0
2014-11-25 14:00:00	MSFT	Stock	47.77	47.775	47.68	47.71	828434.0
2014-11-25 14:30:00	MSFT	Stock	47.71	47.74	47.61	47.675	1058858.0
2014-11-25 15:00:00	MSFT	Stock	47.675	47.695	47.61	47.61	1778931.0
2014-11-25 15:30:00	MSFT	Stock	47.61	47.64	47.45	47.475	4780809.0

> showing 50 of 82,834 rows — these rows as CSV

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