PREVIEW / stock_30min / 2014-09-17

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-09-17.parquet
  size:    1.6 MB
  rows:    82,250
  symbols: 3,577

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-09-17 04:00:00	AAPL	Stock	25.175	25.1875	25.175	25.175	6800.0
2014-09-17 04:30:00	AAPL	Stock	25.17	25.17	25.165	25.1675	6012.0
2014-09-17 05:00:00	AAPL	Stock	25.1625	25.1625	25.1625	25.1625	800.0
2014-09-17 05:30:00	AAPL	Stock	25.1525	25.1525	25.1	25.13	22800.0
2014-09-17 06:00:00	AAPL	Stock	25.135	25.15	25.0625	25.0625	27692.0
2014-09-17 06:30:00	AAPL	Stock	25.05	25.09	25.025	25.09	11756.0
2014-09-17 07:00:00	AAPL	Stock	25.0875	25.09	25.065	25.09	39248.0
2014-09-17 07:30:00	AAPL	Stock	25.09	25.125	25.0825	25.1	88228.0
2014-09-17 08:00:00	AAPL	Stock	25.095	25.215	25.0825	25.14	421564.0
2014-09-17 08:30:00	AAPL	Stock	25.15	25.31	25.15	25.28	502628.0
2014-09-17 09:00:00	AAPL	Stock	25.265	25.3425	25.2	25.32	907376.0
2014-09-17 09:30:00	AAPL	Stock	25.3175	25.4225	25.275	25.345	28912572.0
2014-09-17 10:00:00	AAPL	Stock	25.3475	25.385	25.3175	25.3538	17258448.0
2014-09-17 10:30:00	AAPL	Stock	25.3525	25.3575	25.1875	25.295	17904920.0
2014-09-17 11:00:00	AAPL	Stock	25.295	25.33	25.265	25.2892	10696160.0
2014-09-17 11:30:00	AAPL	Stock	25.2875	25.3	25.2525	25.2675	7791768.0
2014-09-17 12:00:00	AAPL	Stock	25.2675	25.305	25.225	25.24	9669924.0
2014-09-17 12:30:00	AAPL	Stock	25.2375	25.2675	25.215	25.22	7798980.0
2014-09-17 13:00:00	AAPL	Stock	25.22	25.28	25.1875	25.26	9912332.0
2014-09-17 13:30:00	AAPL	Stock	25.26	25.3125	25.2325	25.2975	9530188.0
2014-09-17 14:00:00	AAPL	Stock	25.2965	25.3975	25.148	25.3925	22820472.0
2014-09-17 14:30:00	AAPL	Stock	25.395	25.405	25.2825	25.3675	14103812.0
2014-09-17 15:00:00	AAPL	Stock	25.3688	25.45	25.36	25.44	18907612.0
2014-09-17 15:30:00	AAPL	Stock	25.4375	25.4498	25.3175	25.395	21652528.0
2014-09-17 16:00:00	AAPL	Stock	25.395	25.42	25.26	25.4	11206616.0
2014-09-17 16:30:00	AAPL	Stock	25.395	25.7195	25.327	25.3875	329576.0
2014-09-17 17:00:00	AAPL	Stock	25.395	25.395	25.3825	25.3825	46160.0
2014-09-17 17:30:00	AAPL	Stock	25.3825	25.395	25.37	25.375	388224.0
2014-09-17 18:00:00	AAPL	Stock	25.385	25.395	25.3775	25.38	74248.0
2014-09-17 18:30:00	AAPL	Stock	25.375	25.39	25.375	25.39	29152.0
2014-09-17 19:00:00	AAPL	Stock	25.39	25.39	25.38	25.38	11132.0
2014-09-17 19:30:00	AAPL	Stock	25.385	25.4	25.385	25.4	33200.0
2014-09-17 04:00:00	MSFT	Stock	46.7	46.7	46.6	46.7	5425.0
2014-09-17 05:00:00	MSFT	Stock	46.64	46.64	46.64	46.64	300.0
2014-09-17 05:30:00	MSFT	Stock	46.6	46.6	46.55	46.55	600.0
2014-09-17 06:00:00	MSFT	Stock	46.6	46.6	46.6	46.6	300.0
2014-09-17 06:30:00	MSFT	Stock	46.4	46.48	46.36	46.4	8108.0
2014-09-17 07:00:00	MSFT	Stock	46.4	46.43	46.31	46.38	16330.0
2014-09-17 07:30:00	MSFT	Stock	46.4	46.43	46.39	46.4	30530.0
2014-09-17 08:00:00	MSFT	Stock	46.4	46.43	46.16	46.34	145956.0
2014-09-17 08:30:00	MSFT	Stock	46.34	46.35	46.25	46.3	30080.0
2014-09-17 09:00:00	MSFT	Stock	46.3	46.35	46.24	46.26	112088.0
2014-09-17 09:30:00	MSFT	Stock	46.27	46.66	46.23	46.55	5123166.0
2014-09-17 10:00:00	MSFT	Stock	46.56	46.67	46.5	46.644	2203194.0
2014-09-17 10:30:00	MSFT	Stock	46.65	46.67	46.505	46.52	2122131.0
2014-09-17 11:00:00	MSFT	Stock	46.51	46.54	46.47	46.51	1291767.0
2014-09-17 11:30:00	MSFT	Stock	46.5	46.53	46.46	46.48	2222929.0
2014-09-17 12:00:00	MSFT	Stock	46.485	46.53	46.45	46.45	1253494.0
2014-09-17 12:30:00	MSFT	Stock	46.46	46.51	46.4	46.48	1510791.0
2014-09-17 13:00:00	MSFT	Stock	46.47	46.52	46.41	46.5	1228741.0

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

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