PREVIEW / stock_30min / 2015-05-05

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-05-05.parquet
  size:    1.6 MB
  rows:    83,399
  symbols: 3,523

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
2015-05-05 04:00:00	AAPL	Stock	32.2	32.275	32.1925	32.215	26784.0
2015-05-05 04:30:00	AAPL	Stock	32.225	32.225	32.2225	32.2225	1200.0
2015-05-05 05:00:00	AAPL	Stock	32.225	32.265	32.215	32.265	5336.0
2015-05-05 06:00:00	AAPL	Stock	32.2375	32.245	32.2375	32.24	4872.0
2015-05-05 06:30:00	AAPL	Stock	32.215	32.215	32.1925	32.1925	19504.0
2015-05-05 07:00:00	AAPL	Stock	32.1925	32.1925	32.12	32.1225	49244.0
2015-05-05 07:30:00	AAPL	Stock	32.1225	32.1225	32.05	32.0675	175944.0
2015-05-05 08:00:00	AAPL	Stock	32.08	32.2325	32.0525	32.0875	482384.0
2015-05-05 08:30:00	AAPL	Stock	32.09	32.1175	32.05	32.0625	248460.0
2015-05-05 09:00:00	AAPL	Stock	32.0675	32.095	32.0175	32.0375	399576.0
2015-05-05 09:30:00	AAPL	Stock	32.0375	32.1125	31.69	31.7	30103040.0
2015-05-05 10:00:00	AAPL	Stock	31.7125	31.8175	31.68	31.7875	16691660.0
2015-05-05 10:30:00	AAPL	Stock	31.79	31.83	31.6975	31.8132	10974264.0
2015-05-05 11:00:00	AAPL	Stock	31.81	31.81	31.61	31.6275	12345004.0
2015-05-05 11:30:00	AAPL	Stock	31.6225	31.68	31.555	31.6425	10061096.0
2015-05-05 12:00:00	AAPL	Stock	31.64	31.7375	31.625	31.6925	7712360.0
2015-05-05 12:30:00	AAPL	Stock	31.6925	31.6962	31.6075	31.6175	6566816.0
2015-05-05 13:00:00	AAPL	Stock	31.6175	31.6218	31.475	31.545	13991976.0
2015-05-05 13:30:00	AAPL	Stock	31.5425	31.605	31.5	31.575	8031916.0
2015-05-05 14:00:00	AAPL	Stock	31.575	31.6475	31.495	31.5688	9983628.0
2015-05-05 14:30:00	AAPL	Stock	31.5675	31.5975	31.4625	31.55	11483728.0
2015-05-05 15:00:00	AAPL	Stock	31.5475	31.605	31.5025	31.5712	9269008.0
2015-05-05 15:30:00	AAPL	Stock	31.57	31.635	31.445	31.4525	20791232.0
2015-05-05 16:00:00	AAPL	Stock	31.45	31.9345	31.45	31.4725	13767844.0
2015-05-05 16:30:00	AAPL	Stock	31.475	31.48	31.4675	31.4725	130320.0
2015-05-05 17:00:00	AAPL	Stock	31.465	31.4725	31.4525	31.46	76976.0
2015-05-05 17:30:00	AAPL	Stock	31.4625	31.47	31.455	31.4625	116760.0
2015-05-05 18:00:00	AAPL	Stock	31.4578	31.475	31.455	31.4725	99976.0
2015-05-05 18:30:00	AAPL	Stock	31.4725	31.475	31.46	31.4625	44648.0
2015-05-05 19:00:00	AAPL	Stock	31.475	31.475	31.4625	31.47	15184.0
2015-05-05 19:30:00	AAPL	Stock	31.465	31.475	31.4625	31.4625	86220.0
2015-05-05 05:30:00	MSFT	Stock	48.15	48.15	48.15	48.15	100.0
2015-05-05 06:00:00	MSFT	Stock	48.15	48.15	48.1	48.1	300.0
2015-05-05 06:30:00	MSFT	Stock	48.08	48.08	48.08	48.08	100.0
2015-05-05 07:00:00	MSFT	Stock	48.08	48.08	48.06	48.07	1858.0
2015-05-05 07:30:00	MSFT	Stock	48.07	48.11	48.05	48.11	2400.0
2015-05-05 08:00:00	MSFT	Stock	48.08	48.11	48.06	48.06	3400.0
2015-05-05 08:30:00	MSFT	Stock	48.1	48.1	47.96	47.98	24081.0
2015-05-05 09:00:00	MSFT	Stock	48.0	48.02	47.81	47.87	61725.0
2015-05-05 09:30:00	MSFT	Stock	47.82	48.16	47.71	48.04	5235190.0
2015-05-05 10:00:00	MSFT	Stock	48.04	48.14	47.86	48.03	2917444.0
2015-05-05 10:30:00	MSFT	Stock	48.02	48.08	47.87	48.015	2501316.0
2015-05-05 11:00:00	MSFT	Stock	48.01	48.03	47.84	47.9	2486073.0
2015-05-05 11:30:00	MSFT	Stock	47.9	47.94	47.76	47.894	1995586.0
2015-05-05 12:00:00	MSFT	Stock	47.9	47.98	47.87	47.92	1362635.0
2015-05-05 12:30:00	MSFT	Stock	47.92	47.93	47.8	47.85	1363888.0
2015-05-05 13:00:00	MSFT	Stock	47.86	47.88	47.72	47.77	2145959.0
2015-05-05 13:30:00	MSFT	Stock	47.77	47.8	47.65	47.71	1573535.0
2015-05-05 14:00:00	MSFT	Stock	47.71	47.87	47.65	47.665	2473199.0
2015-05-05 14:30:00	MSFT	Stock	47.66	48.03	47.31	47.625	7770451.0

> showing 50 of 83,399 rows — these rows as CSV

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