PREVIEW / stock_30min / 2017-02-13

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-02-13.parquet
  size:    1.6 MB
  rows:    82,807
  symbols: 3,107

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
2017-02-13 04:00:00	AAPL	Stock	33.1	33.1	33.0425	33.055	2000.0
2017-02-13 04:30:00	AAPL	Stock	33.06	33.06	33.03	33.03	7516.0
2017-02-13 05:00:00	AAPL	Stock	33.05	33.05	33.05	33.05	592.0
2017-02-13 05:30:00	AAPL	Stock	33.05	33.075	33.05	33.05	3704.0
2017-02-13 06:00:00	AAPL	Stock	33.0525	33.0525	33.0525	33.0525	800.0
2017-02-13 06:30:00	AAPL	Stock	33.08	33.0875	33.08	33.0875	10480.0
2017-02-13 07:00:00	AAPL	Stock	33.0625	33.0875	33.0625	33.0875	6720.0
2017-02-13 07:30:00	AAPL	Stock	33.0875	33.15	33.0875	33.125	97916.0
2017-02-13 08:00:00	AAPL	Stock	33.125	33.1825	32.9475	33.1625	309324.0
2017-02-13 08:30:00	AAPL	Stock	33.16	33.22	33.15	33.2125	230904.0
2017-02-13 09:00:00	AAPL	Stock	33.2075	33.2825	33.2	33.2525	972648.0
2017-02-13 09:30:00	AAPL	Stock	33.2625	33.455	33.1875	33.4012	21934792.0
2017-02-13 10:00:00	AAPL	Stock	33.4012	33.4375	33.37	33.405	6169696.0
2017-02-13 10:30:00	AAPL	Stock	33.4075	33.43	33.385	33.395	3894728.0
2017-02-13 11:00:00	AAPL	Stock	33.3938	33.405	33.33	33.4	5207804.0
2017-02-13 11:30:00	AAPL	Stock	33.4025	33.4375	33.3875	33.4263	4619680.0
2017-02-13 12:00:00	AAPL	Stock	33.425	33.4375	33.4175	33.434	2689688.0
2017-02-13 12:30:00	AAPL	Stock	33.4338	33.445	33.4	33.4138	3331016.0
2017-02-13 13:00:00	AAPL	Stock	33.4125	33.425	33.3812	33.405	3306368.0
2017-02-13 13:30:00	AAPL	Stock	33.4075	33.4125	33.35	33.395	3351668.0
2017-02-13 14:00:00	AAPL	Stock	33.395	33.405	33.3525	33.36	3374040.0
2017-02-13 14:30:00	AAPL	Stock	33.36	33.3725	33.3285	33.34	3051540.0
2017-02-13 15:00:00	AAPL	Stock	33.3425	33.3915	33.34	33.3825	3479364.0
2017-02-13 15:30:00	AAPL	Stock	33.3825	33.395	33.295	33.3225	9278144.0
2017-02-13 16:00:00	AAPL	Stock	33.3225	33.33	33.3	33.3225	8174208.0
2017-02-13 16:30:00	AAPL	Stock	33.3125	33.325	33.3	33.3025	130288.0
2017-02-13 17:00:00	AAPL	Stock	33.3175	33.3675	33.3175	33.35	103148.0
2017-02-13 17:30:00	AAPL	Stock	33.345	33.35	33.3225	33.3375	25756.0
2017-02-13 18:00:00	AAPL	Stock	33.3275	33.3475	33.3275	33.3375	6936.0
2017-02-13 18:30:00	AAPL	Stock	33.3375	33.3475	33.3375	33.3475	8268.0
2017-02-13 19:00:00	AAPL	Stock	33.3375	33.3475	33.33	33.345	34448.0
2017-02-13 19:30:00	AAPL	Stock	33.345	33.3475	33.3375	33.3475	33424.0
2017-02-13 04:00:00	MSFT	Stock	64.1	64.1	64.1	64.1	200.0
2017-02-13 07:30:00	MSFT	Stock	64.18	64.18	64.12	64.13	3778.0
2017-02-13 08:00:00	MSFT	Stock	64.2	64.2	64.12	64.15	4534.0
2017-02-13 08:30:00	MSFT	Stock	64.15	64.16	64.11	64.11	3347.0
2017-02-13 09:00:00	MSFT	Stock	64.14	64.26	64.14	64.23	12585.0
2017-02-13 09:30:00	MSFT	Stock	64.24	64.44	64.13	64.44	2968189.0
2017-02-13 10:00:00	MSFT	Stock	64.44	64.6	64.4	64.5	1445940.0
2017-02-13 10:30:00	MSFT	Stock	64.51	64.545	64.42	64.53	816283.0
2017-02-13 11:00:00	MSFT	Stock	64.53	64.57	64.47	64.525	1025254.0
2017-02-13 11:30:00	MSFT	Stock	64.52	64.58	64.45	64.45	755292.0
2017-02-13 12:00:00	MSFT	Stock	64.45	64.507	64.44	64.481	534779.0
2017-02-13 12:30:00	MSFT	Stock	64.48	64.57	64.47	64.565	675323.0
2017-02-13 13:00:00	MSFT	Stock	64.56	64.65	64.54	64.63	775912.0
2017-02-13 13:30:00	MSFT	Stock	64.63	64.69	64.6	64.685	781930.0
2017-02-13 14:00:00	MSFT	Stock	64.685	64.86	64.67	64.82	1125560.0
2017-02-13 14:30:00	MSFT	Stock	64.82	64.83	64.73	64.77	1086490.0
2017-02-13 15:00:00	MSFT	Stock	64.77	64.78	64.62	64.66	1512077.0
2017-02-13 15:30:00	MSFT	Stock	64.66	64.73	64.56	64.71	3466598.0

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

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