PREVIEW / stock_30min / 2015-01-21

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-01-21.parquet
  size:    1.6 MB
  rows:    83,310
  symbols: 3,520

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-01-21 04:00:00	AAPL	Stock	27.2975	27.2975	27.2625	27.285	10332.0
2015-01-21 04:30:00	AAPL	Stock	27.29	27.29	27.2525	27.2525	8004.0
2015-01-21 05:00:00	AAPL	Stock	27.255	27.255	27.255	27.255	400.0
2015-01-21 05:30:00	AAPL	Stock	27.23	27.2325	27.23	27.2325	7352.0
2015-01-21 06:00:00	AAPL	Stock	27.25	27.2825	27.2325	27.2475	25896.0
2015-01-21 06:30:00	AAPL	Stock	27.2925	27.2925	27.2475	27.2475	7540.0
2015-01-21 07:00:00	AAPL	Stock	27.2475	27.25	27.19	27.2025	62092.0
2015-01-21 07:30:00	AAPL	Stock	27.19	27.2125	27.155	27.1825	124928.0
2015-01-21 08:00:00	AAPL	Stock	27.195	27.325	27.1575	27.32	402392.0
2015-01-21 08:30:00	AAPL	Stock	27.325	27.3375	27.2875	27.315	365936.0
2015-01-21 09:00:00	AAPL	Stock	27.3075	27.3125	27.1875	27.2325	513472.0
2015-01-21 09:30:00	AAPL	Stock	27.19	27.41	27.0675	27.26	28547108.0
2015-01-21 10:00:00	AAPL	Stock	27.2588	27.535	27.2312	27.4875	22606816.0
2015-01-21 10:30:00	AAPL	Stock	27.49	27.7388	27.475	27.7075	19406480.0
2015-01-21 11:00:00	AAPL	Stock	27.71	27.765	27.58	27.685	14451256.0
2015-01-21 11:30:00	AAPL	Stock	27.685	27.72	27.6275	27.64	9156140.0
2015-01-21 12:00:00	AAPL	Stock	27.64	27.675	27.5875	27.6065	7041548.0
2015-01-21 12:30:00	AAPL	Stock	27.6075	27.6225	27.4075	27.4975	9697236.0
2015-01-21 13:00:00	AAPL	Stock	27.4925	27.5425	27.4375	27.4515	7307196.0
2015-01-21 13:30:00	AAPL	Stock	27.4525	27.47	27.3512	27.3525	8813628.0
2015-01-21 14:00:00	AAPL	Stock	27.353	27.4815	27.3025	27.4568	10409992.0
2015-01-21 14:30:00	AAPL	Stock	27.455	27.55	27.3975	27.5275	7927808.0
2015-01-21 15:00:00	AAPL	Stock	27.5275	27.5288	27.425	27.4525	8875620.0
2015-01-21 15:30:00	AAPL	Stock	27.45	27.495	27.355	27.3875	17008192.0
2015-01-21 16:00:00	AAPL	Stock	27.3825	27.5998	27.212	27.375	7639036.0
2015-01-21 16:30:00	AAPL	Stock	27.3725	27.4942	27.3725	27.3825	156752.0
2015-01-21 17:00:00	AAPL	Stock	27.38	27.4	27.3725	27.4	124720.0
2015-01-21 17:30:00	AAPL	Stock	27.3925	27.4	27.3875	27.3875	14460.0
2015-01-21 18:00:00	AAPL	Stock	27.3825	27.3875	27.355	27.355	190104.0
2015-01-21 18:30:00	AAPL	Stock	27.355	27.3825	27.3475	27.3625	38908.0
2015-01-21 19:00:00	AAPL	Stock	27.3625	27.3625	27.315	27.325	34840.0
2015-01-21 19:30:00	AAPL	Stock	27.3375	27.3575	27.3175	27.3475	75032.0
2015-01-21 06:00:00	MSFT	Stock	46.43	46.43	46.38	46.38	2500.0
2015-01-21 06:30:00	MSFT	Stock	46.32	46.32	46.29	46.29	800.0
2015-01-21 07:00:00	MSFT	Stock	46.29	46.29	46.29	46.29	100.0
2015-01-21 07:30:00	MSFT	Stock	46.12	46.2	46.12	46.2	1100.0
2015-01-21 08:00:00	MSFT	Stock	46.2	46.2	46.12	46.18	1994.0
2015-01-21 08:30:00	MSFT	Stock	46.2	46.2	46.1	46.15	2300.0
2015-01-21 09:00:00	MSFT	Stock	46.1	46.17	45.9	45.95	29937.0
2015-01-21 09:30:00	MSFT	Stock	45.94	46.14	45.52	45.71	5448974.0
2015-01-21 10:00:00	MSFT	Stock	45.71	45.83	45.53	45.68	3037392.0
2015-01-21 10:30:00	MSFT	Stock	45.68	45.94	45.48	45.94	3769593.0
2015-01-21 11:00:00	MSFT	Stock	45.935	46.05	45.86	46.025	3211094.0
2015-01-21 11:30:00	MSFT	Stock	46.02	46.06	45.83	45.96	2052017.0
2015-01-21 12:00:00	MSFT	Stock	45.966	46.025	45.91	45.99	1615175.0
2015-01-21 12:30:00	MSFT	Stock	46.0	46.04	45.82	45.895	1802983.0
2015-01-21 13:00:00	MSFT	Stock	45.895	45.96	45.81	45.834	1247369.0
2015-01-21 13:30:00	MSFT	Stock	45.84	45.84	45.625	45.66	1717756.0
2015-01-21 14:00:00	MSFT	Stock	45.67	45.73	45.59	45.665	1421821.0
2015-01-21 14:30:00	MSFT	Stock	45.67	45.82	45.6	45.79	1388872.0

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

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