PREVIEW / stock_30min / 2015-07-06

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-07-06.parquet
  size:    1.6 MB
  rows:    82,495
  symbols: 3,488

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-07-06 04:00:00	AAPL	Stock	31.25	31.345	31.25	31.3	101136.0
2015-07-06 04:30:00	AAPL	Stock	31.325	31.36	31.3	31.3525	16644.0
2015-07-06 05:00:00	AAPL	Stock	31.355	31.3675	31.3425	31.3675	5320.0
2015-07-06 05:30:00	AAPL	Stock	31.345	31.425	31.345	31.425	43104.0
2015-07-06 06:00:00	AAPL	Stock	31.425	31.4275	31.3775	31.3775	52724.0
2015-07-06 06:30:00	AAPL	Stock	31.375	31.4	31.375	31.375	26532.0
2015-07-06 07:00:00	AAPL	Stock	31.375	31.4	31.35	31.3525	54432.0
2015-07-06 07:30:00	AAPL	Stock	31.3425	31.3825	31.3125	31.3125	199240.0
2015-07-06 08:00:00	AAPL	Stock	31.325	31.4275	31.2875	31.3675	872184.0
2015-07-06 08:30:00	AAPL	Stock	31.3725	31.375	31.33	31.335	247568.0
2015-07-06 09:00:00	AAPL	Stock	31.3425	31.3575	31.205	31.205	551884.0
2015-07-06 09:30:00	AAPL	Stock	31.235	31.4825	31.2125	31.42	22849412.0
2015-07-06 10:00:00	AAPL	Stock	31.42	31.4875	31.375	31.4025	9270792.0
2015-07-06 10:30:00	AAPL	Stock	31.4	31.5575	31.3938	31.5	9277412.0
2015-07-06 11:00:00	AAPL	Stock	31.5	31.5138	31.4152	31.43	6257200.0
2015-07-06 11:30:00	AAPL	Stock	31.4325	31.4675	31.4	31.4375	5212204.0
2015-07-06 12:00:00	AAPL	Stock	31.4375	31.445	31.395	31.4225	3662936.0
2015-07-06 12:30:00	AAPL	Stock	31.4225	31.4675	31.405	31.4672	3734276.0
2015-07-06 13:00:00	AAPL	Stock	31.4675	31.4825	31.405	31.415	4811704.0
2015-07-06 13:30:00	AAPL	Stock	31.4135	31.4135	31.3525	31.38	6242860.0
2015-07-06 14:00:00	AAPL	Stock	31.3812	31.415	31.3425	31.3475	5540060.0
2015-07-06 14:30:00	AAPL	Stock	31.3475	31.4075	31.3422	31.3712	4689988.0
2015-07-06 15:00:00	AAPL	Stock	31.37	31.4425	31.3625	31.43	5770220.0
2015-07-06 15:30:00	AAPL	Stock	31.4275	31.5	31.4225	31.4975	10899752.0
2015-07-06 16:00:00	AAPL	Stock	31.5	31.53	31.495	31.5	4317904.0
2015-07-06 16:30:00	AAPL	Stock	31.5175	31.5475	31.5175	31.5382	105164.0
2015-07-06 17:00:00	AAPL	Stock	31.54	31.5675	31.54	31.5675	68488.0
2015-07-06 17:30:00	AAPL	Stock	31.5675	31.575	31.5375	31.5375	35804.0
2015-07-06 18:00:00	AAPL	Stock	31.54	31.575	31.5375	31.575	50040.0
2015-07-06 18:30:00	AAPL	Stock	31.575	31.595	31.565	31.5875	60632.0
2015-07-06 19:00:00	AAPL	Stock	31.5875	31.6	31.55	31.55	30036.0
2015-07-06 19:30:00	AAPL	Stock	31.585	31.5875	31.55	31.5875	20088.0
2015-07-06 07:30:00	MSFT	Stock	44.1	44.1	44.03	44.03	300.0
2015-07-06 08:00:00	MSFT	Stock	44.1	44.18	44.03	44.1	5127.0
2015-07-06 08:30:00	MSFT	Stock	44.12	44.12	44.06	44.09	2084.0
2015-07-06 09:00:00	MSFT	Stock	44.09	44.123	43.93	43.97	21181.0
2015-07-06 09:30:00	MSFT	Stock	43.96	44.245	43.95	44.11	3408967.0
2015-07-06 10:00:00	MSFT	Stock	44.11	44.31	44.09	44.264	1724546.0
2015-07-06 10:30:00	MSFT	Stock	44.26	44.47	44.21	44.29	2048377.0
2015-07-06 11:00:00	MSFT	Stock	44.29	44.35	44.14	44.16	1145233.0
2015-07-06 11:30:00	MSFT	Stock	44.16	44.285	44.12	44.265	1517755.0
2015-07-06 12:00:00	MSFT	Stock	44.26	44.32	44.21	44.3	954111.0
2015-07-06 12:30:00	MSFT	Stock	44.3	44.425	44.21	44.42	970696.0
2015-07-06 13:00:00	MSFT	Stock	44.42	44.48	44.28	44.35	1372028.0
2015-07-06 13:30:00	MSFT	Stock	44.35	44.37	44.23	44.364	1172989.0
2015-07-06 14:00:00	MSFT	Stock	44.36	44.45	44.17	44.21	1464364.0
2015-07-06 14:30:00	MSFT	Stock	44.21	44.29	44.14	44.18	1260342.0
2015-07-06 15:00:00	MSFT	Stock	44.175	44.32	44.14	44.265	1599766.0
2015-07-06 15:30:00	MSFT	Stock	44.27	44.42	44.27	44.4	2027523.0
2015-07-06 16:00:00	MSFT	Stock	44.41	44.48	44.39	44.48	1327850.0

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

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