PREVIEW / stock_30min / 2016-04-29

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-04-29.parquet
  size:    1.6 MB
  rows:    81,427
  symbols: 3,299

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
2016-04-29 04:00:00	AAPL	Stock	23.775	23.775	23.56	23.5625	55176.0
2016-04-29 04:30:00	AAPL	Stock	23.5775	23.5775	23.5625	23.5725	13768.0
2016-04-29 05:00:00	AAPL	Stock	23.5625	23.575	23.5475	23.575	68380.0
2016-04-29 05:30:00	AAPL	Stock	23.5775	23.6	23.5775	23.6	14032.0
2016-04-29 06:00:00	AAPL	Stock	23.61	23.6225	23.5875	23.6125	45548.0
2016-04-29 06:30:00	AAPL	Stock	23.6	23.6225	23.5875	23.6125	28060.0
2016-04-29 07:00:00	AAPL	Stock	23.6125	23.64	23.5825	23.5925	124264.0
2016-04-29 07:30:00	AAPL	Stock	23.6	23.67	23.595	23.6475	107832.0
2016-04-29 08:00:00	AAPL	Stock	23.6475	23.7075	23.5825	23.7	712040.0
2016-04-29 08:30:00	AAPL	Stock	23.705	23.7375	23.66	23.67	362528.0
2016-04-29 09:00:00	AAPL	Stock	23.6625	23.7025	23.4975	23.5	1470884.0
2016-04-29 09:30:00	AAPL	Stock	23.5	23.68	23.4	23.4448	39734596.0
2016-04-29 10:00:00	AAPL	Stock	23.445	23.455	23.2925	23.3337	26831612.0
2016-04-29 10:30:00	AAPL	Stock	23.3337	23.4198	23.21	23.235	25793480.0
2016-04-29 11:00:00	AAPL	Stock	23.235	23.265	23.145	23.2075	24509044.0
2016-04-29 11:30:00	AAPL	Stock	23.2075	23.3675	23.1275	23.34	21661452.0
2016-04-29 12:00:00	AAPL	Stock	23.3375	23.42	23.265	23.4	12798296.0
2016-04-29 12:30:00	AAPL	Stock	23.4012	23.4475	23.3375	23.3535	10131824.0
2016-04-29 13:00:00	AAPL	Stock	23.355	23.515	23.335	23.4475	12234424.0
2016-04-29 13:30:00	AAPL	Stock	23.445	23.465	23.315	23.32	9283404.0
2016-04-29 14:00:00	AAPL	Stock	23.32	23.355	23.2425	23.3	11412912.0
2016-04-29 14:30:00	AAPL	Stock	23.3017	23.3425	23.25	23.305	9682480.0
2016-04-29 15:00:00	AAPL	Stock	23.305	23.4475	23.3	23.3838	12871412.0
2016-04-29 15:30:00	AAPL	Stock	23.3825	23.4725	23.3825	23.435	19814124.0
2016-04-29 16:00:00	AAPL	Stock	23.4375	23.5148	23.303	23.4375	13010696.0
2016-04-29 16:30:00	AAPL	Stock	23.4375	23.45	23.4375	23.445	51576.0
2016-04-29 17:00:00	AAPL	Stock	23.4375	23.44	23.415	23.415	55792.0
2016-04-29 17:30:00	AAPL	Stock	23.415	23.435	23.3775	23.3775	96256.0
2016-04-29 18:00:00	AAPL	Stock	23.3875	23.3875	23.3675	23.3875	81496.0
2016-04-29 18:30:00	AAPL	Stock	23.375	23.42	23.375	23.405	9104.0
2016-04-29 19:00:00	AAPL	Stock	23.4125	23.42	23.38	23.4075	31448.0
2016-04-29 19:30:00	AAPL	Stock	23.4025	23.4325	23.39	23.4	55088.0
2016-04-29 04:00:00	MSFT	Stock	49.9	49.9	49.9	49.9	2027.0
2016-04-29 04:30:00	MSFT	Stock	49.88	49.88	49.88	49.88	500.0
2016-04-29 05:30:00	MSFT	Stock	49.9	49.9	49.9	49.9	2100.0
2016-04-29 06:00:00	MSFT	Stock	49.9	49.9	49.88	49.88	500.0
2016-04-29 06:30:00	MSFT	Stock	49.86	49.86	49.81	49.81	955.0
2016-04-29 07:00:00	MSFT	Stock	49.86	49.9	49.7	49.73	7620.0
2016-04-29 07:30:00	MSFT	Stock	49.73	49.77	49.7	49.7	11778.0
2016-04-29 08:00:00	MSFT	Stock	49.7	49.84	49.64	49.65	26543.0
2016-04-29 08:30:00	MSFT	Stock	49.78	49.78	49.5	49.51	24612.0
2016-04-29 09:00:00	MSFT	Stock	49.58	49.72	49.36	49.41	56510.0
2016-04-29 09:30:00	MSFT	Stock	49.35	50.1	49.35	49.815	7054062.0
2016-04-29 10:00:00	MSFT	Stock	49.815	49.97	49.56	49.72	3531703.0
2016-04-29 10:30:00	MSFT	Stock	49.73	50.1	49.69	49.93	4849420.0
2016-04-29 11:00:00	MSFT	Stock	49.925	49.97	49.8	49.81	3012211.0
2016-04-29 11:30:00	MSFT	Stock	49.81	49.92	49.73	49.89	3086347.0
2016-04-29 12:00:00	MSFT	Stock	49.88	50.075	49.83	49.96	2082612.0
2016-04-29 12:30:00	MSFT	Stock	49.97	50.07	49.9	49.982	2250891.0
2016-04-29 13:00:00	MSFT	Stock	49.986	50.25	49.92	50.215	2062631.0

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

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