PREVIEW / stock_30min / 2017-08-02

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-08-02.parquet
  size:    1.6 MB
  rows:    81,044
  symbols: 2,989

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-08-02 04:00:00	AAPL	Stock	39.805	39.8875	39.7625	39.8575	164000.0
2017-08-02 04:30:00	AAPL	Stock	39.835	39.9375	39.775	39.8275	106964.0
2017-08-02 05:00:00	AAPL	Stock	39.8275	39.875	39.8	39.875	58208.0
2017-08-02 05:30:00	AAPL	Stock	39.875	39.8825	39.8025	39.825	36852.0
2017-08-02 06:00:00	AAPL	Stock	39.8	39.845	39.6575	39.7	397928.0
2017-08-02 06:30:00	AAPL	Stock	39.6875	39.7	39.5125	39.5875	378312.0
2017-08-02 07:00:00	AAPL	Stock	39.61	39.825	39.585	39.625	586460.0
2017-08-02 07:30:00	AAPL	Stock	39.6175	39.7375	39.565	39.71	695704.0
2017-08-02 08:00:00	AAPL	Stock	39.7025	40.0	39.54	39.98	3687600.0
2017-08-02 08:30:00	AAPL	Stock	39.98	39.995	39.7625	39.7875	3391304.0
2017-08-02 09:00:00	AAPL	Stock	39.7875	39.925	39.7	39.8875	5827396.0
2017-08-02 09:30:00	AAPL	Stock	39.82	39.9375	39.425	39.485	71193696.0
2017-08-02 10:00:00	AAPL	Stock	39.478	39.61	39.0425	39.105	35301228.0
2017-08-02 10:30:00	AAPL	Stock	39.1012	39.3425	39.04	39.2525	23002848.0
2017-08-02 11:00:00	AAPL	Stock	39.2525	39.3375	39.1025	39.3125	16136416.0
2017-08-02 11:30:00	AAPL	Stock	39.3147	39.5175	39.255	39.445	13423404.0
2017-08-02 12:00:00	AAPL	Stock	39.4475	39.4875	39.34	39.3925	6683284.0
2017-08-02 12:30:00	AAPL	Stock	39.39	39.425	39.2325	39.2812	6787016.0
2017-08-02 13:00:00	AAPL	Stock	39.2825	39.2925	39.18	39.24	7182936.0
2017-08-02 13:30:00	AAPL	Stock	39.24	39.4098	39.1915	39.3448	7470304.0
2017-08-02 14:00:00	AAPL	Stock	39.3475	39.485	39.305	39.443	6594036.0
2017-08-02 14:30:00	AAPL	Stock	39.4425	39.5025	39.3845	39.479	7197924.0
2017-08-02 15:00:00	AAPL	Stock	39.48	39.595	39.41	39.5162	9970540.0
2017-08-02 15:30:00	AAPL	Stock	39.5162	39.525	39.25	39.2875	16065772.0
2017-08-02 16:00:00	AAPL	Stock	39.2875	39.665	39.235	39.3	9960896.0
2017-08-02 16:30:00	AAPL	Stock	39.2925	39.3	39.285	39.3	433852.0
2017-08-02 17:00:00	AAPL	Stock	39.29	39.3	39.2525	39.295	93868.0
2017-08-02 17:30:00	AAPL	Stock	39.27	39.32	39.27	39.3	48052.0
2017-08-02 18:00:00	AAPL	Stock	39.305	39.325	39.2975	39.3	50572.0
2017-08-02 18:30:00	AAPL	Stock	39.3	39.3125	39.25	39.2725	610660.0
2017-08-02 19:00:00	AAPL	Stock	39.27	39.3	39.2675	39.285	25572.0
2017-08-02 19:30:00	AAPL	Stock	39.2875	39.2875	39.26	39.26	28764.0
2017-08-02 04:00:00	MSFT	Stock	72.74	72.74	72.5	72.55	2490.0
2017-08-02 04:30:00	MSFT	Stock	72.61	72.61	72.55	72.55	1984.0
2017-08-02 05:30:00	MSFT	Stock	72.64	72.64	72.64	72.64	100.0
2017-08-02 06:00:00	MSFT	Stock	72.5	72.5	72.5	72.5	100.0
2017-08-02 07:00:00	MSFT	Stock	72.5	72.62	72.5	72.6	3100.0
2017-08-02 07:30:00	MSFT	Stock	72.57	72.63	72.51	72.63	13743.0
2017-08-02 08:00:00	MSFT	Stock	72.61	72.71	72.57	72.65	11215.0
2017-08-02 08:30:00	MSFT	Stock	72.65	72.72	72.65	72.65	8071.0
2017-08-02 09:00:00	MSFT	Stock	72.72	72.75	72.45	72.56	42299.0
2017-08-02 09:30:00	MSFT	Stock	72.52	72.56	72.15	72.21	3048052.0
2017-08-02 10:00:00	MSFT	Stock	72.21	72.3	71.785	71.87	2401088.0
2017-08-02 10:30:00	MSFT	Stock	71.88	72.09	71.69	71.75	2277769.0
2017-08-02 11:00:00	MSFT	Stock	71.75	71.84	71.64	71.7	1876625.0
2017-08-02 11:30:00	MSFT	Stock	71.707	71.74	71.58	71.644	1259669.0
2017-08-02 12:00:00	MSFT	Stock	71.65	71.7	71.54	71.55	1200968.0
2017-08-02 12:30:00	MSFT	Stock	71.545	71.64	71.46	71.54	1043028.0
2017-08-02 13:00:00	MSFT	Stock	71.545	71.715	71.445	71.71	1151751.0
2017-08-02 13:30:00	MSFT	Stock	71.7	72.15	71.681	72.05	1841863.0

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

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