PREVIEW / stock_30min / 2018-12-18

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-12-18.parquet
  size:    1.7 MB
  rows:    86,693
  symbols: 2,731

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
2018-12-18 04:00:00	AAPL	Stock	41.175	41.2125	41.1	41.1	15320.0
2018-12-18 04:30:00	AAPL	Stock	41.18	41.3325	41.18	41.3325	6372.0
2018-12-18 05:00:00	AAPL	Stock	41.3325	41.375	41.3325	41.375	2400.0
2018-12-18 05:30:00	AAPL	Stock	41.37	41.375	41.255	41.3	8940.0
2018-12-18 06:00:00	AAPL	Stock	41.275	41.375	41.275	41.3375	13988.0
2018-12-18 06:30:00	AAPL	Stock	41.4	41.4	41.355	41.3825	8844.0
2018-12-18 07:00:00	AAPL	Stock	41.41	41.41	41.3	41.3625	83876.0
2018-12-18 07:30:00	AAPL	Stock	41.36	41.4375	41.355	41.4025	120212.0
2018-12-18 08:00:00	AAPL	Stock	41.352	41.44	41.295	41.37	211372.0
2018-12-18 08:30:00	AAPL	Stock	41.3525	41.405	41.2925	41.3375	103312.0
2018-12-18 09:00:00	AAPL	Stock	41.3025	41.375	41.295	41.375	135356.0
2018-12-18 09:30:00	AAPL	Stock	41.34	41.5475	41.1675	41.4875	16792544.0
2018-12-18 10:00:00	AAPL	Stock	41.4875	41.5725	41.3025	41.515	9629808.0
2018-12-18 10:30:00	AAPL	Stock	41.5225	41.5825	41.2775	41.345	7452160.0
2018-12-18 11:00:00	AAPL	Stock	41.3475	41.41	41.215	41.285	5585280.0
2018-12-18 11:30:00	AAPL	Stock	41.29	41.49	41.27	41.3938	4970804.0
2018-12-18 12:00:00	AAPL	Stock	41.3825	41.8	41.3825	41.7312	8264712.0
2018-12-18 12:30:00	AAPL	Stock	41.7325	41.8825	41.6725	41.82	4888804.0
2018-12-18 13:00:00	AAPL	Stock	41.825	41.8375	41.6875	41.7325	4724116.0
2018-12-18 13:30:00	AAPL	Stock	41.7325	41.745	41.475	41.5625	4755876.0
2018-12-18 14:00:00	AAPL	Stock	41.565	41.6625	41.5	41.5928	4436728.0
2018-12-18 14:30:00	AAPL	Stock	41.5925	41.5925	41.22	41.2348	8703640.0
2018-12-18 15:00:00	AAPL	Stock	41.235	41.335	41.0975	41.24	9951196.0
2018-12-18 15:30:00	AAPL	Stock	41.2475	41.7525	41.2475	41.4725	16909036.0
2018-12-18 16:00:00	AAPL	Stock	41.46	41.575	41.41	41.4125	13638724.0
2018-12-18 16:30:00	AAPL	Stock	41.4125	41.5175	41.2375	41.2375	179376.0
2018-12-18 17:00:00	AAPL	Stock	41.2025	41.305	41.15	41.2475	92608.0
2018-12-18 17:30:00	AAPL	Stock	41.25	41.255	41.1275	41.1875	56124.0
2018-12-18 18:00:00	AAPL	Stock	41.1875	41.33	41.1775	41.2975	30512.0
2018-12-18 18:30:00	AAPL	Stock	41.33	41.33	41.2825	41.3025	14036.0
2018-12-18 19:00:00	AAPL	Stock	41.3075	41.325	41.25	41.275	47964.0
2018-12-18 19:30:00	AAPL	Stock	41.275	41.3975	41.275	41.34	28668.0
2018-12-18 04:00:00	MSFT	Stock	103.26	103.26	103.26	103.26	100.0
2018-12-18 04:30:00	MSFT	Stock	103.13	103.5	103.13	103.5	2199.0
2018-12-18 05:00:00	MSFT	Stock	103.6	103.6	103.6	103.6	1235.0
2018-12-18 05:30:00	MSFT	Stock	103.5	103.5	103.5	103.5	142.0
2018-12-18 06:00:00	MSFT	Stock	103.46	103.6	103.4	103.6	4613.0
2018-12-18 06:30:00	MSFT	Stock	103.5	103.65	103.5	103.6	12233.0
2018-12-18 07:00:00	MSFT	Stock	103.58	103.67	103.44	103.52	5129.0
2018-12-18 07:30:00	MSFT	Stock	103.6	103.95	103.6	103.95	11198.0
2018-12-18 08:00:00	MSFT	Stock	103.65	103.96	103.15	103.85	33822.0
2018-12-18 08:30:00	MSFT	Stock	103.9	103.96	103.51	103.62	18621.0
2018-12-18 09:00:00	MSFT	Stock	103.62	103.9	103.62	103.75	10659.0
2018-12-18 09:30:00	MSFT	Stock	103.77	104.08	102.91	103.48	3652204.0
2018-12-18 10:00:00	MSFT	Stock	103.47	103.62	102.93	103.39	2537439.0
2018-12-18 10:30:00	MSFT	Stock	103.4	103.55	102.77	103.04	2733263.0
2018-12-18 11:00:00	MSFT	Stock	103.04	103.3	102.52	102.73	2196416.0
2018-12-18 11:30:00	MSFT	Stock	102.74	103.26	102.729	103.005	1519993.0
2018-12-18 12:00:00	MSFT	Stock	102.98	103.93	102.98	103.7	2090822.0
2018-12-18 12:30:00	MSFT	Stock	103.71	104.2	103.66	104.11	1445296.0

> showing 50 of 86,693 rows — these rows as CSV

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