PREVIEW / stock_30min / 2015-07-17

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-07-17.parquet
  size:    1.6 MB
  rows:    81,994
  symbols: 3,487

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-17 04:00:00	AAPL	Stock	32.2875	32.2875	32.1475	32.225	78544.0
2015-07-17 04:30:00	AAPL	Stock	32.175	32.2225	32.175	32.19	3984.0
2015-07-17 05:00:00	AAPL	Stock	32.2	32.2225	32.2	32.2175	9408.0
2015-07-17 05:30:00	AAPL	Stock	32.19	32.2125	32.19	32.2125	5124.0
2015-07-17 06:00:00	AAPL	Stock	32.2	32.2125	32.195	32.2	9868.0
2015-07-17 06:30:00	AAPL	Stock	32.2	32.235	32.1875	32.2275	48864.0
2015-07-17 07:00:00	AAPL	Stock	32.2275	32.33	32.225	32.29	213140.0
2015-07-17 07:30:00	AAPL	Stock	32.275	32.295	32.2575	32.2675	86780.0
2015-07-17 08:00:00	AAPL	Stock	32.2675	32.3125	32.225	32.285	454892.0
2015-07-17 08:30:00	AAPL	Stock	32.2925	32.2975	32.2675	32.2675	227440.0
2015-07-17 09:00:00	AAPL	Stock	32.2725	32.2975	32.21	32.2275	704520.0
2015-07-17 09:30:00	AAPL	Stock	32.27	32.2725	32.0925	32.1718	32336608.0
2015-07-17 10:00:00	AAPL	Stock	32.1702	32.18	32.0775	32.1475	17432244.0
2015-07-17 10:30:00	AAPL	Stock	32.145	32.3825	32.1325	32.3475	20370008.0
2015-07-17 11:00:00	AAPL	Stock	32.3452	32.36	32.29	32.325	9594908.0
2015-07-17 11:30:00	AAPL	Stock	32.325	32.36	32.2375	32.255	7275084.0
2015-07-17 12:00:00	AAPL	Stock	32.254	32.2872	32.2	32.245	6392008.0
2015-07-17 12:30:00	AAPL	Stock	32.2458	32.2622	32.2175	32.2325	3834204.0
2015-07-17 13:00:00	AAPL	Stock	32.2325	32.28	32.22	32.26	5226856.0
2015-07-17 13:30:00	AAPL	Stock	32.26	32.3525	32.2525	32.3175	6846828.0
2015-07-17 14:00:00	AAPL	Stock	32.316	32.359	32.285	32.3575	5998224.0
2015-07-17 14:30:00	AAPL	Stock	32.3575	32.375	32.3325	32.3718	7242976.0
2015-07-17 15:00:00	AAPL	Stock	32.3725	32.3875	32.29	32.3162	10308520.0
2015-07-17 15:30:00	AAPL	Stock	32.3152	32.405	32.305	32.405	20522872.0
2015-07-17 16:00:00	AAPL	Stock	32.3985	32.405	32.1642	32.4	16456660.0
2015-07-17 16:30:00	AAPL	Stock	32.4025	32.4175	32.39	32.4025	242248.0
2015-07-17 17:00:00	AAPL	Stock	32.4125	32.47	32.4125	32.4575	240664.0
2015-07-17 17:30:00	AAPL	Stock	32.455	32.4575	32.4078	32.4225	128264.0
2015-07-17 18:00:00	AAPL	Stock	32.425	32.44	32.4158	32.44	56496.0
2015-07-17 18:30:00	AAPL	Stock	32.4342	32.435	32.4275	32.43	71660.0
2015-07-17 19:00:00	AAPL	Stock	32.43	32.445	32.425	32.445	54152.0
2015-07-17 19:30:00	AAPL	Stock	32.445	32.45	32.4282	32.4425	91956.0
2015-07-17 04:00:00	MSFT	Stock	46.89	46.89	46.49	46.49	2400.0
2015-07-17 04:30:00	MSFT	Stock	46.4	46.4	46.4	46.4	2330.0
2015-07-17 05:00:00	MSFT	Stock	46.39	46.48	46.39	46.48	4885.0
2015-07-17 05:30:00	MSFT	Stock	46.48	46.51	46.48	46.51	2285.0
2015-07-17 06:30:00	MSFT	Stock	46.47	46.47	46.42	46.42	800.0
2015-07-17 07:00:00	MSFT	Stock	46.45	46.45	46.4	46.42	5541.0
2015-07-17 07:30:00	MSFT	Stock	46.45	46.45	46.38	46.38	3648.0
2015-07-17 08:00:00	MSFT	Stock	46.45	46.45	46.32	46.38	6846.0
2015-07-17 08:30:00	MSFT	Stock	46.42	46.43	46.37	46.43	6741.0
2015-07-17 09:00:00	MSFT	Stock	46.42	46.62	46.4	46.54	207394.0
2015-07-17 09:30:00	MSFT	Stock	46.55	46.63	46.4	46.52	5882443.0
2015-07-17 10:00:00	MSFT	Stock	46.52	46.78	46.51	46.645	2896585.0
2015-07-17 10:30:00	MSFT	Stock	46.64	46.66	46.5	46.54	2043592.0
2015-07-17 11:00:00	MSFT	Stock	46.54	46.62	46.421	46.47	1144685.0
2015-07-17 11:30:00	MSFT	Stock	46.47	46.52	46.36	46.445	1298497.0
2015-07-17 12:00:00	MSFT	Stock	46.45	46.555	46.42	46.455	1221295.0
2015-07-17 12:30:00	MSFT	Stock	46.45	46.49	46.35	46.355	1136813.0
2015-07-17 13:00:00	MSFT	Stock	46.355	46.38	46.26	46.315	1025405.0

> showing 50 of 81,994 rows — these rows as CSV

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