PREVIEW / stock_30min / 2016-04-08

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-04-08.parquet
  size:    1.5 MB
  rows:    81,048
  symbols: 3,334

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-08 04:00:00	AAPL	Stock	27.335	27.3425	27.2825	27.3075	2640.0
2016-04-08 04:30:00	AAPL	Stock	27.3075	27.3075	27.3075	27.3075	800.0
2016-04-08 06:00:00	AAPL	Stock	27.3	27.325	27.3	27.325	2752.0
2016-04-08 06:30:00	AAPL	Stock	27.33	27.3425	27.33	27.3425	1056.0
2016-04-08 07:00:00	AAPL	Stock	27.35	27.375	27.31	27.3175	45708.0
2016-04-08 07:30:00	AAPL	Stock	27.325	27.3675	27.325	27.35	33980.0
2016-04-08 08:00:00	AAPL	Stock	27.35	27.375	27.3125	27.35	148572.0
2016-04-08 08:30:00	AAPL	Stock	27.355	27.405	27.35	27.375	247612.0
2016-04-08 09:00:00	AAPL	Stock	27.375	27.375	27.2325	27.2325	383928.0
2016-04-08 09:30:00	AAPL	Stock	27.235	27.3875	27.17	27.36	14335048.0
2016-04-08 10:00:00	AAPL	Stock	27.3575	27.435	27.3375	27.385	9055176.0
2016-04-08 10:30:00	AAPL	Stock	27.385	27.4425	27.3375	27.3475	5853864.0
2016-04-08 11:00:00	AAPL	Stock	27.3472	27.375	27.3025	27.3068	5272296.0
2016-04-08 11:30:00	AAPL	Stock	27.305	27.3275	27.175	27.245	6987424.0
2016-04-08 12:00:00	AAPL	Stock	27.245	27.25	27.075	27.085	5759844.0
2016-04-08 12:30:00	AAPL	Stock	27.0825	27.2175	27.06	27.2025	4119764.0
2016-04-08 13:00:00	AAPL	Stock	27.2025	27.205	27.0525	27.085	4117264.0
2016-04-08 13:30:00	AAPL	Stock	27.0825	27.21	27.065	27.21	3639188.0
2016-04-08 14:00:00	AAPL	Stock	27.2102	27.25	27.16	27.2328	3693400.0
2016-04-08 14:30:00	AAPL	Stock	27.235	27.2375	27.1475	27.175	2822908.0
2016-04-08 15:00:00	AAPL	Stock	27.1762	27.182	27.075	27.0825	4639196.0
2016-04-08 15:30:00	AAPL	Stock	27.08	27.165	27.0425	27.165	9234536.0
2016-04-08 16:00:00	AAPL	Stock	27.165	27.22	27.1208	27.14	6296640.0
2016-04-08 16:30:00	AAPL	Stock	27.1475	27.1625	27.1475	27.16	23796.0
2016-04-08 17:00:00	AAPL	Stock	27.1475	27.16	27.1475	27.16	13344.0
2016-04-08 17:30:00	AAPL	Stock	27.15	27.15	27.1475	27.1475	5244.0
2016-04-08 18:00:00	AAPL	Stock	27.1475	27.1625	27.145	27.1525	20588.0
2016-04-08 18:30:00	AAPL	Stock	27.175	27.175	27.1525	27.1525	10228.0
2016-04-08 19:00:00	AAPL	Stock	27.1525	27.16	27.1525	27.16	8476.0
2016-04-08 19:30:00	AAPL	Stock	27.1525	27.1525	27.1425	27.1425	62280.0
2016-04-08 04:00:00	MSFT	Stock	54.63	54.63	54.63	54.63	200.0
2016-04-08 06:30:00	MSFT	Stock	54.87	54.87	54.87	54.87	200.0
2016-04-08 07:30:00	MSFT	Stock	54.76	54.78	54.6	54.64	1041.0
2016-04-08 08:00:00	MSFT	Stock	54.76	54.91	54.73	54.91	13625.0
2016-04-08 08:30:00	MSFT	Stock	54.93	54.93	54.85	54.86	2515.0
2016-04-08 09:00:00	MSFT	Stock	54.86	54.92	54.67	54.68	23894.0
2016-04-08 09:30:00	MSFT	Stock	54.68	55.16	54.67	55.12	2286180.0
2016-04-08 10:00:00	MSFT	Stock	55.139	55.28	55.07	55.095	1641762.0
2016-04-08 10:30:00	MSFT	Stock	55.1	55.13	54.835	54.84	1490801.0
2016-04-08 11:00:00	MSFT	Stock	54.84	55.05	54.84	54.91	1044143.0
2016-04-08 11:30:00	MSFT	Stock	54.91	54.95	54.73	54.83	1006901.0
2016-04-08 12:00:00	MSFT	Stock	54.822	54.875	54.525	54.545	1100521.0
2016-04-08 12:30:00	MSFT	Stock	54.54	54.64	54.49	54.59	1066946.0
2016-04-08 13:00:00	MSFT	Stock	54.58	54.595	54.48	54.511	896198.0
2016-04-08 13:30:00	MSFT	Stock	54.51	54.57	54.39	54.56	1547750.0
2016-04-08 14:00:00	MSFT	Stock	54.57	54.71	54.48	54.62	1188893.0
2016-04-08 14:30:00	MSFT	Stock	54.63	54.63	54.39	54.52	1073426.0
2016-04-08 15:00:00	MSFT	Stock	54.52	54.53	54.37	54.445	1491721.0
2016-04-08 15:30:00	MSFT	Stock	54.44	54.48	54.32	54.42	2878427.0
2016-04-08 16:00:00	MSFT	Stock	54.42	54.46	54.42	54.46	2089261.0

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

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