PREVIEW / stock_30min / 2014-11-04

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-11-04.parquet
  size:    1.6 MB
  rows:    82,826
  symbols: 3,535

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-11-04 04:00:00	AAPL	Stock	27.4225	27.4775	27.4225	27.4775	28144.0
2014-11-04 04:30:00	AAPL	Stock	27.475	27.48	27.4275	27.4375	19284.0
2014-11-04 05:00:00	AAPL	Stock	27.4375	27.4375	27.36	27.365	72852.0
2014-11-04 05:30:00	AAPL	Stock	27.3625	27.375	27.325	27.3375	52684.0
2014-11-04 06:00:00	AAPL	Stock	27.3375	27.3425	27.33	27.3425	2028.0
2014-11-04 06:30:00	AAPL	Stock	27.35	27.3775	27.335	27.375	13296.0
2014-11-04 07:00:00	AAPL	Stock	27.375	27.3775	27.325	27.325	63360.0
2014-11-04 07:30:00	AAPL	Stock	27.33	27.3625	27.3125	27.3125	53996.0
2014-11-04 08:00:00	AAPL	Stock	27.3175	27.375	27.25	27.3025	302040.0
2014-11-04 08:30:00	AAPL	Stock	27.2925	27.3475	27.275	27.345	172596.0
2014-11-04 09:00:00	AAPL	Stock	27.345	27.3775	27.315	27.35	273672.0
2014-11-04 09:30:00	AAPL	Stock	27.34	27.3725	27.1725	27.2675	26725620.0
2014-11-04 10:00:00	AAPL	Stock	27.27	27.2925	27.1725	27.1875	12606764.0
2014-11-04 10:30:00	AAPL	Stock	27.1882	27.235	27.0325	27.0475	15105988.0
2014-11-04 11:00:00	AAPL	Stock	27.05	27.085	26.93	27.085	16925444.0
2014-11-04 11:30:00	AAPL	Stock	27.085	27.115	26.98	27.0128	10921864.0
2014-11-04 12:00:00	AAPL	Stock	27.015	27.125	27.0125	27.1175	6862028.0
2014-11-04 12:30:00	AAPL	Stock	27.1175	27.225	27.1125	27.1625	7320800.0
2014-11-04 13:00:00	AAPL	Stock	27.1638	27.195	27.1325	27.1868	5603356.0
2014-11-04 13:30:00	AAPL	Stock	27.185	27.235	27.1525	27.23	5708780.0
2014-11-04 14:00:00	AAPL	Stock	27.23	27.24	27.19	27.195	5196300.0
2014-11-04 14:30:00	AAPL	Stock	27.1975	27.2318	27.175	27.2312	5770104.0
2014-11-04 15:00:00	AAPL	Stock	27.2322	27.2375	27.18	27.195	5503136.0
2014-11-04 15:30:00	AAPL	Stock	27.195	27.2075	27.1475	27.15	11468308.0
2014-11-04 16:00:00	AAPL	Stock	27.15	27.21	27.1125	27.1175	11559316.0
2014-11-04 16:30:00	AAPL	Stock	27.1325	27.1325	27.105	27.125	111656.0
2014-11-04 17:00:00	AAPL	Stock	27.1175	27.1982	27.1	27.1125	209100.0
2014-11-04 17:30:00	AAPL	Stock	27.1125	27.1612	27.1	27.1125	179996.0
2014-11-04 18:00:00	AAPL	Stock	27.1	27.11	27.0975	27.11	50364.0
2014-11-04 18:30:00	AAPL	Stock	27.0975	27.15	27.0975	27.1	92036.0
2014-11-04 19:00:00	AAPL	Stock	27.1	27.15	27.1	27.1375	84040.0
2014-11-04 19:30:00	AAPL	Stock	27.145	27.16	27.115	27.1525	69324.0
2014-11-04 05:00:00	MSFT	Stock	47.42	47.42	47.42	47.42	600.0
2014-11-04 05:30:00	MSFT	Stock	47.42	47.42	47.42	47.42	300.0
2014-11-04 07:30:00	MSFT	Stock	47.42	47.43	47.42	47.43	4000.0
2014-11-04 08:00:00	MSFT	Stock	47.3	47.4	47.3	47.3	5197.0
2014-11-04 08:30:00	MSFT	Stock	47.27	47.27	47.27	47.27	4500.0
2014-11-04 09:00:00	MSFT	Stock	47.3	47.44	47.26	47.39	24411.0
2014-11-04 09:30:00	MSFT	Stock	47.301	47.66	47.3	47.6	2983581.0
2014-11-04 10:00:00	MSFT	Stock	47.62	47.73	47.405	47.42	2256036.0
2014-11-04 10:30:00	MSFT	Stock	47.41	47.62	47.39	47.41	1444347.0
2014-11-04 11:00:00	MSFT	Stock	47.41	47.45	47.25	47.395	1729825.0
2014-11-04 11:30:00	MSFT	Stock	47.4	47.416	47.3	47.345	1064102.0
2014-11-04 12:00:00	MSFT	Stock	47.349	47.56	47.34	47.466	825012.0
2014-11-04 12:30:00	MSFT	Stock	47.47	47.64	47.47	47.556	689450.0
2014-11-04 13:00:00	MSFT	Stock	47.551	47.64	47.49	47.517	662140.0
2014-11-04 13:30:00	MSFT	Stock	47.515	47.65	47.46	47.63	718846.0
2014-11-04 14:00:00	MSFT	Stock	47.635	47.68	47.51	47.51	1358021.0
2014-11-04 14:30:00	MSFT	Stock	47.51	47.61	47.5	47.61	891913.0
2014-11-04 15:00:00	MSFT	Stock	47.61	47.645	47.54	47.58	1492111.0

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

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