PREVIEW / stock_30min / 2015-06-10

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-06-10.parquet
  size:    1.6 MB
  rows:    83,170
  symbols: 3,497

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-06-10 04:00:00	AAPL	Stock	32.0	32.0475	31.9375	31.9375	24000.0
2015-06-10 04:30:00	AAPL	Stock	31.9175	31.9225	31.9175	31.9225	1600.0
2015-06-10 05:00:00	AAPL	Stock	31.995	31.995	31.975	31.9925	4000.0
2015-06-10 05:30:00	AAPL	Stock	32.0	32.075	32.0	32.075	30420.0
2015-06-10 06:00:00	AAPL	Stock	32.0425	32.0475	32.005	32.045	16892.0
2015-06-10 06:30:00	AAPL	Stock	32.035	32.0375	32.0075	32.0175	26172.0
2015-06-10 07:00:00	AAPL	Stock	32.0075	32.0125	31.965	31.9925	50512.0
2015-06-10 07:30:00	AAPL	Stock	31.9875	32.0075	31.9875	32.0	75180.0
2015-06-10 08:00:00	AAPL	Stock	32.0	32.0125	31.9475	31.9575	370860.0
2015-06-10 08:30:00	AAPL	Stock	31.965	31.9825	31.94	31.98	168940.0
2015-06-10 09:00:00	AAPL	Stock	31.98	31.995	31.9625	31.9925	270196.0
2015-06-10 09:30:00	AAPL	Stock	31.9825	32.205	31.9625	32.14	23352564.0
2015-06-10 10:00:00	AAPL	Stock	32.1425	32.2512	32.1412	32.185	13837160.0
2015-06-10 10:30:00	AAPL	Stock	32.1875	32.23	32.11	32.17	11372252.0
2015-06-10 11:00:00	AAPL	Stock	32.165	32.2725	32.1375	32.2132	13041940.0
2015-06-10 11:30:00	AAPL	Stock	32.215	32.2525	32.1875	32.2322	8106048.0
2015-06-10 12:00:00	AAPL	Stock	32.23	32.2325	32.165	32.2138	6071516.0
2015-06-10 12:30:00	AAPL	Stock	32.2125	32.2575	32.1825	32.24	6621492.0
2015-06-10 13:00:00	AAPL	Stock	32.2388	32.26	32.1825	32.2165	6211044.0
2015-06-10 13:30:00	AAPL	Stock	32.2175	32.245	32.1848	32.2438	5035484.0
2015-06-10 14:00:00	AAPL	Stock	32.245	32.335	32.2375	32.31	10845744.0
2015-06-10 14:30:00	AAPL	Stock	32.31	32.33	32.2625	32.3	8749200.0
2015-06-10 15:00:00	AAPL	Stock	32.305	32.305	32.2475	32.2625	7251772.0
2015-06-10 15:30:00	AAPL	Stock	32.2638	32.2775	32.21	32.2175	16524388.0
2015-06-10 16:00:00	AAPL	Stock	32.22	32.235	32.21	32.2275	9132152.0
2015-06-10 16:30:00	AAPL	Stock	32.2275	32.235	32.22	32.235	123956.0
2015-06-10 17:00:00	AAPL	Stock	32.2275	32.2375	32.2275	32.2375	15572.0
2015-06-10 17:30:00	AAPL	Stock	32.23	32.2425	32.22	32.24	20352.0
2015-06-10 18:00:00	AAPL	Stock	32.235	32.235	32.225	32.225	54972.0
2015-06-10 18:30:00	AAPL	Stock	32.2175	32.25	32.215	32.2375	83764.0
2015-06-10 19:00:00	AAPL	Stock	32.23	32.24	32.225	32.24	13488.0
2015-06-10 19:30:00	AAPL	Stock	32.23	32.2398	32.23	32.23	28952.0
2015-06-10 07:00:00	MSFT	Stock	45.9	45.9	45.9	45.9	1200.0
2015-06-10 07:30:00	MSFT	Stock	45.9	45.9	45.9	45.9	1200.0
2015-06-10 08:00:00	MSFT	Stock	45.9	46.03	45.9	45.95	6108.0
2015-06-10 08:30:00	MSFT	Stock	45.95	46.0	45.9	45.95	22360.0
2015-06-10 09:00:00	MSFT	Stock	45.96	46.0	45.8	45.84	26050.0
2015-06-10 09:30:00	MSFT	Stock	45.79	46.15	45.69	46.02	3007416.0
2015-06-10 10:00:00	MSFT	Stock	46.02	46.32	46.0	46.32	1897114.0
2015-06-10 10:30:00	MSFT	Stock	46.32	46.51	46.264	46.455	1980574.0
2015-06-10 11:00:00	MSFT	Stock	46.45	46.785	46.36	46.72	2819699.0
2015-06-10 11:30:00	MSFT	Stock	46.71	46.77	46.62	46.675	1411242.0
2015-06-10 12:00:00	MSFT	Stock	46.67	46.75	46.61	46.71	1061954.0
2015-06-10 12:30:00	MSFT	Stock	46.7	46.78	46.68	46.74	965232.0
2015-06-10 13:00:00	MSFT	Stock	46.74	46.79	46.61	46.68	1103350.0
2015-06-10 13:30:00	MSFT	Stock	46.68	46.75	46.655	46.723	902562.0
2015-06-10 14:00:00	MSFT	Stock	46.73	46.83	46.7	46.734	1282806.0
2015-06-10 14:30:00	MSFT	Stock	46.74	46.785	46.69	46.78	877561.0
2015-06-10 15:00:00	MSFT	Stock	46.78	46.785	46.69	46.745	1250016.0
2015-06-10 15:30:00	MSFT	Stock	46.74	46.76	46.58	46.59	3486083.0

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

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