PREVIEW / stock_30min / 2014-09-23

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-09-23.parquet
  size:    1.6 MB
  rows:    86,593
  symbols: 3,578

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-09-23 04:00:00	AAPL	Stock	25.265	25.265	25.14	25.1725	14596.0
2014-09-23 04:30:00	AAPL	Stock	25.175	25.185	25.175	25.185	13096.0
2014-09-23 05:00:00	AAPL	Stock	25.17	25.17	25.16	25.16	2000.0
2014-09-23 05:30:00	AAPL	Stock	25.1375	25.1475	25.07	25.0875	17676.0
2014-09-23 06:00:00	AAPL	Stock	25.1475	25.1475	25.125	25.125	9196.0
2014-09-23 06:30:00	AAPL	Stock	25.1225	25.1475	25.1025	25.1475	22364.0
2014-09-23 07:00:00	AAPL	Stock	25.1625	25.165	25.105	25.16	45388.0
2014-09-23 07:30:00	AAPL	Stock	25.1275	25.1675	25.1275	25.155	67784.0
2014-09-23 08:00:00	AAPL	Stock	25.1425	25.1875	25.14	25.185	254292.0
2014-09-23 08:30:00	AAPL	Stock	25.185	25.1925	25.16	25.1925	231968.0
2014-09-23 09:00:00	AAPL	Stock	25.185	25.195	25.145	25.1525	257040.0
2014-09-23 09:30:00	AAPL	Stock	25.155	25.5	25.135	25.47	31982860.0
2014-09-23 10:00:00	AAPL	Stock	25.47	25.535	25.4025	25.4408	25208172.0
2014-09-23 10:30:00	AAPL	Stock	25.44	25.52	25.4	25.486	11058928.0
2014-09-23 11:00:00	AAPL	Stock	25.4875	25.57	25.435	25.5232	15535904.0
2014-09-23 11:30:00	AAPL	Stock	25.525	25.5975	25.5225	25.5612	13255400.0
2014-09-23 12:00:00	AAPL	Stock	25.5612	25.625	25.5525	25.6025	12592556.0
2014-09-23 12:30:00	AAPL	Stock	25.6025	25.69	25.6	25.6625	19094824.0
2014-09-23 13:00:00	AAPL	Stock	25.6625	25.695	25.595	25.655	16220480.0
2014-09-23 13:30:00	AAPL	Stock	25.6525	25.685	25.615	25.6175	9956288.0
2014-09-23 14:00:00	AAPL	Stock	25.6175	25.6475	25.5375	25.565	13766288.0
2014-09-23 14:30:00	AAPL	Stock	25.5662	25.65	25.56	25.6275	10526640.0
2014-09-23 15:00:00	AAPL	Stock	25.6275	25.7125	25.6075	25.71	15198052.0
2014-09-23 15:30:00	AAPL	Stock	25.7125	25.735	25.655	25.66	32962704.0
2014-09-23 16:00:00	AAPL	Stock	25.66	25.6875	25.489	25.6425	8136940.0
2014-09-23 16:30:00	AAPL	Stock	25.6425	25.66	25.5775	25.624	446724.0
2014-09-23 17:00:00	AAPL	Stock	25.59	25.66	25.5525	25.61	341564.0
2014-09-23 17:30:00	AAPL	Stock	25.66	25.66	25.59	25.5925	65616.0
2014-09-23 18:00:00	AAPL	Stock	25.6	25.66	25.5975	25.6225	103368.0
2014-09-23 18:30:00	AAPL	Stock	25.615	25.66	25.605	25.62	223152.0
2014-09-23 19:00:00	AAPL	Stock	25.615	25.615	25.5975	25.5975	59836.0
2014-09-23 19:30:00	AAPL	Stock	25.595	25.6425	25.595	25.6375	106516.0
2014-09-23 04:00:00	MSFT	Stock	46.83	46.83	46.83	46.83	100.0
2014-09-23 04:30:00	MSFT	Stock	46.83	46.83	46.83	46.83	100.0
2014-09-23 05:00:00	MSFT	Stock	46.83	46.83	46.83	46.83	100.0
2014-09-23 07:00:00	MSFT	Stock	46.87	46.87	46.87	46.87	500.0
2014-09-23 08:00:00	MSFT	Stock	46.86	46.9	46.85	46.85	1440.0
2014-09-23 08:30:00	MSFT	Stock	46.95	46.98	46.93	46.93	612.0
2014-09-23 09:00:00	MSFT	Stock	47.02	47.02	46.85	46.96	17526.0
2014-09-23 09:30:00	MSFT	Stock	46.85	46.97	46.74	46.9	4132458.0
2014-09-23 10:00:00	MSFT	Stock	46.9	46.98	46.78	46.865	2474180.0
2014-09-23 10:30:00	MSFT	Stock	46.855	46.92	46.77	46.875	1688460.0
2014-09-23 11:00:00	MSFT	Stock	46.876	46.89	46.8	46.85	1163603.0
2014-09-23 11:30:00	MSFT	Stock	46.85	46.88	46.81	46.86	1131986.0
2014-09-23 12:00:00	MSFT	Stock	46.86	46.88	46.71	46.715	2222015.0
2014-09-23 12:30:00	MSFT	Stock	46.71	46.76	46.67	46.685	1909255.0
2014-09-23 13:00:00	MSFT	Stock	46.68	46.77	46.66	46.73	2597248.0
2014-09-23 13:30:00	MSFT	Stock	46.73	46.765	46.66	46.725	2335429.0
2014-09-23 14:00:00	MSFT	Stock	46.725	46.78	46.65	46.68	2048144.0
2014-09-23 14:30:00	MSFT	Stock	46.68	46.71	46.55	46.61	2438788.0

> showing 50 of 86,593 rows — these rows as CSV

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