PREVIEW / stock_30min / 2014-11-28

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-11-28.parquet
  size:    1.1 MB
  rows:    50,260
  symbols: 3,472

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-28 04:00:00	AAPL	Stock	29.7875	29.7875	29.7075	29.75	35320.0
2014-11-28 04:30:00	AAPL	Stock	29.75	29.7675	29.7475	29.75	25976.0
2014-11-28 05:00:00	AAPL	Stock	29.74	29.78	29.74	29.775	4000.0
2014-11-28 05:30:00	AAPL	Stock	29.7475	29.75	29.7475	29.75	4400.0
2014-11-28 06:00:00	AAPL	Stock	29.75	29.75	29.745	29.75	17128.0
2014-11-28 06:30:00	AAPL	Stock	29.745	29.775	29.745	29.7575	43920.0
2014-11-28 07:00:00	AAPL	Stock	29.7725	29.8375	29.7725	29.8375	100428.0
2014-11-28 07:30:00	AAPL	Stock	29.8425	29.855	29.835	29.85	113684.0
2014-11-28 08:00:00	AAPL	Stock	29.85	29.8675	29.7488	29.85	348408.0
2014-11-28 08:30:00	AAPL	Stock	29.85	29.85	29.8075	29.82	274876.0
2014-11-28 09:00:00	AAPL	Stock	29.825	29.85	29.8125	29.8225	291912.0
2014-11-28 09:30:00	AAPL	Stock	29.8175	29.85	29.5125	29.6375	23772212.0
2014-11-28 10:00:00	AAPL	Stock	29.6375	29.6875	29.565	29.6232	11245480.0
2014-11-28 10:30:00	AAPL	Stock	29.6225	29.76	29.6125	29.7528	11986440.0
2014-11-28 11:00:00	AAPL	Stock	29.7538	29.755	29.6678	29.745	7574288.0
2014-11-28 11:30:00	AAPL	Stock	29.745	29.7525	29.705	29.725	6072252.0
2014-11-28 12:00:00	AAPL	Stock	29.725	29.7375	29.6825	29.695	7731616.0
2014-11-28 12:30:00	AAPL	Stock	29.6975	29.7475	29.635	29.7325	13854212.0
2014-11-28 13:00:00	AAPL	Stock	29.7325	29.75	29.6882	29.7375	9643816.0
2014-11-28 13:30:00	AAPL	Stock	29.7375	29.745	29.7322	29.745	421744.0
2014-11-28 14:00:00	AAPL	Stock	29.7325	29.7475	29.73	29.735	73960.0
2014-11-28 14:30:00	AAPL	Stock	29.7375	29.7425	29.72	29.73	27988.0
2014-11-28 15:00:00	AAPL	Stock	29.7425	29.7425	29.72	29.73	12440.0
2014-11-28 15:30:00	AAPL	Stock	29.72	29.725	29.7025	29.7025	8692.0
2014-11-28 16:00:00	AAPL	Stock	29.705	29.705	29.7025	29.7025	2400.0
2014-11-28 16:30:00	AAPL	Stock	29.7125	29.7125	29.71	29.71	2208.0
2014-11-28 04:30:00	MSFT	Stock	47.82	47.82	47.82	47.82	100.0
2014-11-28 05:00:00	MSFT	Stock	47.82	47.82	47.82	47.82	100.0
2014-11-28 05:30:00	MSFT	Stock	47.82	47.82	47.8	47.8	985.0
2014-11-28 06:00:00	MSFT	Stock	47.8	47.8	47.8	47.8	500.0
2014-11-28 07:00:00	MSFT	Stock	47.81	47.82	47.8	47.82	2482.0
2014-11-28 07:30:00	MSFT	Stock	47.81	47.81	47.81	47.81	130.0
2014-11-28 08:00:00	MSFT	Stock	47.81	47.81	47.75	47.75	799.0
2014-11-28 08:30:00	MSFT	Stock	47.85	47.85	47.82	47.85	2518.0
2014-11-28 09:00:00	MSFT	Stock	47.83	48.07	47.83	47.95	32973.0
2014-11-28 09:30:00	MSFT	Stock	47.95	47.97	47.61	47.857	3072479.0
2014-11-28 10:00:00	MSFT	Stock	47.86	48.0	47.825	47.99	2578717.0
2014-11-28 10:30:00	MSFT	Stock	47.99	48.18	47.98	48.12	2025654.0
2014-11-28 11:00:00	MSFT	Stock	48.12	48.195	48.04	48.13	1889097.0
2014-11-28 11:30:00	MSFT	Stock	48.125	48.15	48.06	48.12	1332734.0
2014-11-28 12:00:00	MSFT	Stock	48.11	48.15	47.975	47.98	1432328.0
2014-11-28 12:30:00	MSFT	Stock	47.98	48.03	47.72	47.82	2859890.0
2014-11-28 13:00:00	MSFT	Stock	47.81	48.142	47.78	47.81	5350637.0
2014-11-28 13:30:00	MSFT	Stock	47.81	47.9	47.809	47.9	113501.0
2014-11-28 14:00:00	MSFT	Stock	47.9	47.9	47.9	47.9	100.0
2014-11-28 14:30:00	MSFT	Stock	47.9	47.9	47.82	47.82	500.0
2014-11-28 08:00:00	NVDA	Stock	0.521	0.521	0.521	0.521	14000.0
2014-11-28 09:00:00	NVDA	Stock	0.5255	0.5255	0.5255	0.5255	31640.0
2014-11-28 09:30:00	NVDA	Stock	0.5247	0.525	0.5205	0.5222	24523760.0
2014-11-28 10:00:00	NVDA	Stock	0.5222	0.5242	0.5201	0.5242	19382800.0

> showing 50 of 50,260 rows — these rows as CSV

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