PREVIEW / stock_30min / 2018-04-17

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-04-17.parquet
  size:    1.7 MB
  rows:    83,331
  symbols: 2,853

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-04-17 04:00:00	AAPL	Stock	44.1275	44.3	44.1275	44.23	30840.0
2018-04-17 04:30:00	AAPL	Stock	44.165	44.165	44.165	44.165	588.0
2018-04-17 05:30:00	AAPL	Stock	44.15	44.25	44.15	44.25	7376.0
2018-04-17 06:00:00	AAPL	Stock	44.27	44.275	44.2075	44.2075	7924.0
2018-04-17 06:30:00	AAPL	Stock	44.2625	44.2625	44.195	44.25	11600.0
2018-04-17 07:00:00	AAPL	Stock	44.2	44.25	44.1575	44.1875	49444.0
2018-04-17 07:30:00	AAPL	Stock	44.1875	44.2325	44.1875	44.23	30424.0
2018-04-17 08:00:00	AAPL	Stock	44.17	44.2625	44.17	44.1925	125228.0
2018-04-17 08:30:00	AAPL	Stock	44.21	44.2325	44.18	44.18	93836.0
2018-04-17 09:00:00	AAPL	Stock	44.175	44.2375	44.105	44.105	139880.0
2018-04-17 09:30:00	AAPL	Stock	44.105	44.345	44.1025	44.2475	12720268.0
2018-04-17 10:00:00	AAPL	Stock	44.2495	44.37	44.2425	44.32	7595508.0
2018-04-17 10:30:00	AAPL	Stock	44.3225	44.4625	44.3075	44.4465	6103440.0
2018-04-17 11:00:00	AAPL	Stock	44.4525	44.6075	44.4512	44.5925	7363520.0
2018-04-17 11:30:00	AAPL	Stock	44.5925	44.6225	44.5225	44.595	5036908.0
2018-04-17 12:00:00	AAPL	Stock	44.5975	44.665	44.585	44.6275	4256424.0
2018-04-17 12:30:00	AAPL	Stock	44.63	44.6425	44.5	44.5425	3653052.0
2018-04-17 13:00:00	AAPL	Stock	44.5425	44.5975	44.4575	44.5775	4084872.0
2018-04-17 13:30:00	AAPL	Stock	44.58	44.6225	44.5375	44.6125	3318204.0
2018-04-17 14:00:00	AAPL	Stock	44.6075	44.665	44.5575	44.597	4542344.0
2018-04-17 14:30:00	AAPL	Stock	44.5982	44.6425	44.555	44.62	3908524.0
2018-04-17 15:00:00	AAPL	Stock	44.6198	44.69	44.6025	44.6888	4578340.0
2018-04-17 15:30:00	AAPL	Stock	44.69	44.734	44.515	44.56	10399468.0
2018-04-17 16:00:00	AAPL	Stock	44.56	44.625	44.5375	44.5625	10648932.0
2018-04-17 16:30:00	AAPL	Stock	44.5625	44.5825	44.555	44.555	93180.0
2018-04-17 17:00:00	AAPL	Stock	44.5575	44.5625	44.52	44.52	138808.0
2018-04-17 17:30:00	AAPL	Stock	44.525	44.5275	44.5	44.5	26900.0
2018-04-17 18:00:00	AAPL	Stock	44.525	44.5275	44.5	44.5125	6660.0
2018-04-17 18:30:00	AAPL	Stock	44.5125	44.53	44.5125	44.53	14288.0
2018-04-17 19:00:00	AAPL	Stock	44.53	44.5375	44.525	44.5375	3620.0
2018-04-17 19:30:00	AAPL	Stock	44.5375	44.5575	44.53	44.5575	16868.0
2018-04-17 04:00:00	MSFT	Stock	94.61	94.61	94.61	94.61	2433.0
2018-04-17 04:30:00	MSFT	Stock	94.7	94.7	94.7	94.7	2600.0
2018-04-17 05:00:00	MSFT	Stock	94.79	94.82	94.78	94.78	1688.0
2018-04-17 05:30:00	MSFT	Stock	94.78	94.78	94.78	94.78	100.0
2018-04-17 06:00:00	MSFT	Stock	94.73	94.73	94.73	94.73	150.0
2018-04-17 07:00:00	MSFT	Stock	94.78	94.89	94.75	94.86	3626.0
2018-04-17 07:30:00	MSFT	Stock	94.88	94.96	94.77	94.95	3732.0
2018-04-17 08:00:00	MSFT	Stock	94.84	95.1	94.75	95.05	25519.0
2018-04-17 08:30:00	MSFT	Stock	95.05	95.1	95.0	95.01	26231.0
2018-04-17 09:00:00	MSFT	Stock	95.0	95.05	94.87	94.95	22771.0
2018-04-17 09:30:00	MSFT	Stock	95.0	95.42	94.88	95.34	2833394.0
2018-04-17 10:00:00	MSFT	Stock	95.34	95.619	95.32	95.52	1920637.0
2018-04-17 10:30:00	MSFT	Stock	95.514	96.05	95.48	96.03	1944463.0
2018-04-17 11:00:00	MSFT	Stock	96.03	96.53	96.03	96.38	1780658.0
2018-04-17 11:30:00	MSFT	Stock	96.384	96.415	96.205	96.395	1595889.0
2018-04-17 12:00:00	MSFT	Stock	96.4	96.515	96.36	96.455	1145807.0
2018-04-17 12:30:00	MSFT	Stock	96.46	96.467	96.17	96.29	1002696.0
2018-04-17 13:00:00	MSFT	Stock	96.3	96.42	96.12	96.38	1208292.0
2018-04-17 13:30:00	MSFT	Stock	96.39	96.49	96.22	96.35	758878.0

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

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