PREVIEW / stock_30min / 2014-07-25

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-07-25.parquet
  size:    1.6 MB
  rows:    82,579
  symbols: 3,570

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-07-25 04:00:00	AAPL	Stock	24.225	24.225	24.225	24.225	800.0
2014-07-25 05:00:00	AAPL	Stock	24.2175	24.225	24.195	24.205	8000.0
2014-07-25 05:30:00	AAPL	Stock	24.2125	24.2125	24.2125	24.2125	10000.0
2014-07-25 06:00:00	AAPL	Stock	24.2125	24.2275	24.21	24.2125	12324.0
2014-07-25 06:30:00	AAPL	Stock	24.2125	24.2125	24.195	24.195	1612.0
2014-07-25 07:00:00	AAPL	Stock	24.205	24.205	24.1875	24.2	23620.0
2014-07-25 07:30:00	AAPL	Stock	24.2	24.2	24.195	24.2	33448.0
2014-07-25 08:00:00	AAPL	Stock	24.195	24.2575	24.18	24.2275	193912.0
2014-07-25 08:30:00	AAPL	Stock	24.2275	24.23	24.1875	24.2175	89580.0
2014-07-25 09:00:00	AAPL	Stock	24.2075	24.255	24.1775	24.2225	290808.0
2014-07-25 09:30:00	AAPL	Stock	24.215	24.36	24.16	24.32	23677288.0
2014-07-25 10:00:00	AAPL	Stock	24.3225	24.46	24.3225	24.4582	20796756.0
2014-07-25 10:30:00	AAPL	Stock	24.4575	24.46	24.2825	24.3062	13893280.0
2014-07-25 11:00:00	AAPL	Stock	24.305	24.325	24.2125	24.25	17364344.0
2014-07-25 11:30:00	AAPL	Stock	24.2475	24.305	24.235	24.2998	8805548.0
2014-07-25 12:00:00	AAPL	Stock	24.3	24.3588	24.3	24.3375	6720888.0
2014-07-25 12:30:00	AAPL	Stock	24.3375	24.38	24.325	24.3728	6117596.0
2014-07-25 13:00:00	AAPL	Stock	24.3738	24.38	24.338	24.362	5684040.0
2014-07-25 13:30:00	AAPL	Stock	24.3625	24.365	24.31	24.325	5780600.0
2014-07-25 14:00:00	AAPL	Stock	24.325	24.3725	24.3025	24.3525	5771840.0
2014-07-25 14:30:00	AAPL	Stock	24.3518	24.3662	24.3175	24.3348	6395776.0
2014-07-25 15:00:00	AAPL	Stock	24.335	24.365	24.32	24.35	7076916.0
2014-07-25 15:30:00	AAPL	Stock	24.3488	24.4225	24.32	24.42	19346440.0
2014-07-25 16:00:00	AAPL	Stock	24.4225	24.43	24.3365	24.395	11178220.0
2014-07-25 16:30:00	AAPL	Stock	24.39	24.4225	24.3875	24.4	192772.0
2014-07-25 17:00:00	AAPL	Stock	24.4	24.4178	24.3975	24.4025	1979732.0
2014-07-25 17:30:00	AAPL	Stock	24.4025	24.4075	24.395	24.4075	32080.0
2014-07-25 18:00:00	AAPL	Stock	24.4025	24.4075	24.3975	24.4075	52240.0
2014-07-25 18:30:00	AAPL	Stock	24.4225	24.4225	24.4025	24.41	156200.0
2014-07-25 19:00:00	AAPL	Stock	24.4075	24.41	24.3975	24.4075	17260.0
2014-07-25 19:30:00	AAPL	Stock	24.4025	24.4125	24.4	24.405	54660.0
2014-07-25 05:30:00	MSFT	Stock	44.21	44.21	44.21	44.21	200.0
2014-07-25 06:00:00	MSFT	Stock	44.21	44.21	44.21	44.21	100.0
2014-07-25 06:30:00	MSFT	Stock	44.21	44.21	44.21	44.21	500.0
2014-07-25 07:00:00	MSFT	Stock	44.17	44.24	44.17	44.24	400.0
2014-07-25 07:30:00	MSFT	Stock	44.29	44.29	44.24	44.24	2100.0
2014-07-25 08:00:00	MSFT	Stock	44.3	44.32	44.28	44.32	3750.0
2014-07-25 08:30:00	MSFT	Stock	44.33	44.43	44.33	44.35	2990.0
2014-07-25 09:00:00	MSFT	Stock	44.39	44.39	44.29	44.31	21969.0
2014-07-25 09:30:00	MSFT	Stock	44.3	44.66	44.3	44.525	4140001.0
2014-07-25 10:00:00	MSFT	Stock	44.525	44.57	44.47	44.56	2919943.0
2014-07-25 10:30:00	MSFT	Stock	44.56	44.595	44.33	44.35	2203328.0
2014-07-25 11:00:00	MSFT	Stock	44.36	44.45	44.33	44.44	1422965.0
2014-07-25 11:30:00	MSFT	Stock	44.44	44.51	44.43	44.477	1335400.0
2014-07-25 12:00:00	MSFT	Stock	44.47	44.52	44.405	44.43	807961.0
2014-07-25 12:30:00	MSFT	Stock	44.43	44.53	44.42	44.506	1615315.0
2014-07-25 13:00:00	MSFT	Stock	44.505	44.53	44.47	44.5	754023.0
2014-07-25 13:30:00	MSFT	Stock	44.5	44.51	44.41	44.5	1419030.0
2014-07-25 14:00:00	MSFT	Stock	44.49	44.55	44.46	44.47	986522.0
2014-07-25 14:30:00	MSFT	Stock	44.47	44.54	44.47	44.501	1622531.0

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

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