PREVIEW / stock_30min / 2015-04-30

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-04-30.parquet
  size:    1.6 MB
  rows:    83,105
  symbols: 3,515

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-04-30 04:00:00	AAPL	Stock	31.9525	31.9525	31.6625	31.745	90340.0
2015-04-30 04:30:00	AAPL	Stock	31.77	31.7925	31.75	31.78	94856.0
2015-04-30 05:00:00	AAPL	Stock	31.77	31.825	31.75	31.825	49896.0
2015-04-30 05:30:00	AAPL	Stock	31.8125	31.895	31.8125	31.895	31552.0
2015-04-30 06:00:00	AAPL	Stock	31.8875	31.9	31.8	31.8925	101568.0
2015-04-30 06:30:00	AAPL	Stock	31.88	31.8825	31.8475	31.8575	23404.0
2015-04-30 07:00:00	AAPL	Stock	31.8675	31.94	31.8675	31.9225	122916.0
2015-04-30 07:30:00	AAPL	Stock	31.905	31.99	31.85	31.975	291952.0
2015-04-30 08:00:00	AAPL	Stock	31.9675	32.275	31.8475	32.0075	718648.0
2015-04-30 08:30:00	AAPL	Stock	32.0	32.025	31.95	31.965	527168.0
2015-04-30 09:00:00	AAPL	Stock	31.9625	31.9975	31.875	31.875	1232404.0
2015-04-30 09:30:00	AAPL	Stock	31.875	31.97	31.57	31.5772	44916408.0
2015-04-30 10:00:00	AAPL	Stock	31.5758	31.6575	31.3625	31.4225	39879768.0
2015-04-30 10:30:00	AAPL	Stock	31.4225	31.585	31.4225	31.515	23452464.0
2015-04-30 11:00:00	AAPL	Stock	31.5138	31.7	31.5125	31.605	17930128.0
2015-04-30 11:30:00	AAPL	Stock	31.6075	31.655	31.4525	31.4625	13021564.0
2015-04-30 12:00:00	AAPL	Stock	31.465	31.5475	31.4075	31.4718	12089884.0
2015-04-30 12:30:00	AAPL	Stock	31.4715	31.4875	31.3125	31.4185	17528392.0
2015-04-30 13:00:00	AAPL	Stock	31.42	31.4975	31.365	31.3975	13839624.0
2015-04-30 13:30:00	AAPL	Stock	31.3975	31.445	31.355	31.405	11313824.0
2015-04-30 14:00:00	AAPL	Stock	31.4078	31.455	31.3175	31.33	12486064.0
2015-04-30 14:30:00	AAPL	Stock	31.33	31.37	31.2675	31.29	14633888.0
2015-04-30 15:00:00	AAPL	Stock	31.2875	31.36	31.145	31.2725	28321340.0
2015-04-30 15:30:00	AAPL	Stock	31.2712	31.37	31.205	31.305	27190276.0
2015-04-30 16:00:00	AAPL	Stock	31.31	31.4525	31.22	31.2725	23523708.0
2015-04-30 16:30:00	AAPL	Stock	31.2725	31.8328	31.23	31.2525	236192.0
2015-04-30 17:00:00	AAPL	Stock	31.2525	31.26	31.2125	31.22	176264.0
2015-04-30 17:30:00	AAPL	Stock	31.22	31.3	31.2125	31.295	311496.0
2015-04-30 18:00:00	AAPL	Stock	31.2875	31.3125	31.26	31.2925	228332.0
2015-04-30 18:30:00	AAPL	Stock	31.28	31.3175	31.2775	31.28	90516.0
2015-04-30 19:00:00	AAPL	Stock	31.2875	31.3225	31.2875	31.315	96572.0
2015-04-30 19:30:00	AAPL	Stock	31.3125	31.32	31.3	31.32	157020.0
2015-04-30 04:00:00	MSFT	Stock	48.79	48.79	48.72	48.72	9763.0
2015-04-30 04:30:00	MSFT	Stock	48.75	48.85	48.75	48.85	3320.0
2015-04-30 05:00:00	MSFT	Stock	48.83	48.85	48.75	48.75	2200.0
2015-04-30 05:30:00	MSFT	Stock	48.8	48.8	48.73	48.79	1700.0
2015-04-30 06:00:00	MSFT	Stock	48.76	48.8	48.75	48.79	4873.0
2015-04-30 06:30:00	MSFT	Stock	48.8	48.8	48.8	48.8	1000.0
2015-04-30 07:00:00	MSFT	Stock	48.85	48.92	48.85	48.87	7740.0
2015-04-30 07:30:00	MSFT	Stock	48.82	48.89	48.5	48.89	12057.0
2015-04-30 08:00:00	MSFT	Stock	48.85	48.93	48.82	48.86	39943.0
2015-04-30 08:30:00	MSFT	Stock	48.85	49.0	48.81	48.85	274652.0
2015-04-30 09:00:00	MSFT	Stock	48.85	48.85	48.64	48.71	85071.0
2015-04-30 09:30:00	MSFT	Stock	48.72	49.41	48.64	48.95	10653606.0
2015-04-30 10:00:00	MSFT	Stock	48.95	49.1	48.715	48.8	4808559.0
2015-04-30 10:30:00	MSFT	Stock	48.8	48.86	48.62	48.67	3854895.0
2015-04-30 11:00:00	MSFT	Stock	48.677	49.18	48.67	49.13	4202153.0
2015-04-30 11:30:00	MSFT	Stock	49.13	49.37	49.05	49.254	3921869.0
2015-04-30 12:00:00	MSFT	Stock	49.255	49.54	49.25	49.39	4635578.0
2015-04-30 12:30:00	MSFT	Stock	49.39	49.41	49.15	49.24	2371552.0

> showing 50 of 83,105 rows — these rows as CSV

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