PREVIEW / stock_30min / 2017-06-20

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-06-20.parquet
  size:    1.6 MB
  rows:    81,649
  symbols: 3,012

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-06-20 04:00:00	AAPL	Stock	36.75	36.75	36.75	36.75	1292.0
2017-06-20 04:30:00	AAPL	Stock	36.75	36.8225	36.75	36.8225	4908.0
2017-06-20 05:00:00	AAPL	Stock	36.82	36.82	36.775	36.775	7760.0
2017-06-20 06:00:00	AAPL	Stock	36.7725	36.7725	36.7725	36.7725	400.0
2017-06-20 06:30:00	AAPL	Stock	36.7725	36.7725	36.69	36.75	17304.0
2017-06-20 07:00:00	AAPL	Stock	36.7625	36.77	36.6875	36.6875	55784.0
2017-06-20 07:30:00	AAPL	Stock	36.72	36.7725	36.7	36.7725	33676.0
2017-06-20 08:00:00	AAPL	Stock	36.79	36.79	36.625	36.64	369816.0
2017-06-20 08:30:00	AAPL	Stock	36.635	36.675	36.5925	36.625	195612.0
2017-06-20 09:00:00	AAPL	Stock	36.6475	36.7225	36.625	36.7175	213448.0
2017-06-20 09:30:00	AAPL	Stock	36.7175	36.7175	36.34	36.355	14578176.0
2017-06-20 10:00:00	AAPL	Stock	36.355	36.4338	36.3175	36.345	8028536.0
2017-06-20 10:30:00	AAPL	Stock	36.3475	36.5175	36.34	36.4825	5514988.0
2017-06-20 11:00:00	AAPL	Stock	36.4825	36.485	36.255	36.275	5670652.0
2017-06-20 11:30:00	AAPL	Stock	36.2775	36.4	36.25	36.3575	5199256.0
2017-06-20 12:00:00	AAPL	Stock	36.36	36.4325	36.27	36.2948	4203096.0
2017-06-20 12:30:00	AAPL	Stock	36.295	36.3575	36.2625	36.32	3454108.0
2017-06-20 13:00:00	AAPL	Stock	36.32	36.3475	36.2838	36.3262	3594932.0
2017-06-20 13:30:00	AAPL	Stock	36.3275	36.395	36.305	36.385	2877384.0
2017-06-20 14:00:00	AAPL	Stock	36.3825	36.4288	36.355	36.3625	3819784.0
2017-06-20 14:30:00	AAPL	Stock	36.36	36.385	36.3025	36.3825	3268192.0
2017-06-20 15:00:00	AAPL	Stock	36.3825	36.4875	36.3675	36.3787	5520484.0
2017-06-20 15:30:00	AAPL	Stock	36.3785	36.3825	36.235	36.2525	12956928.0
2017-06-20 16:00:00	AAPL	Stock	36.2525	36.3675	36.2425	36.26	8785660.0
2017-06-20 16:30:00	AAPL	Stock	36.265	36.3385	36.2525	36.255	269004.0
2017-06-20 17:00:00	AAPL	Stock	36.2525	36.27	36.2525	36.2675	10816.0
2017-06-20 17:30:00	AAPL	Stock	36.2825	36.285	36.2575	36.2575	18512.0
2017-06-20 18:00:00	AAPL	Stock	36.2575	36.275	36.2575	36.275	4100.0
2017-06-20 18:30:00	AAPL	Stock	36.255	36.28	36.2525	36.2525	11600.0
2017-06-20 19:00:00	AAPL	Stock	36.2625	36.2775	36.255	36.2775	6540.0
2017-06-20 19:30:00	AAPL	Stock	36.2775	36.28	36.26	36.2725	15140.0
2017-06-20 04:30:00	MSFT	Stock	70.9	70.9	70.9	70.9	199.0
2017-06-20 05:30:00	MSFT	Stock	70.87	70.87	70.87	70.87	134.0
2017-06-20 06:30:00	MSFT	Stock	71.0	71.0	71.0	71.0	100.0
2017-06-20 07:00:00	MSFT	Stock	71.09	71.09	70.9	70.9	10100.0
2017-06-20 08:00:00	MSFT	Stock	70.87	71.04	70.76	70.76	2267.0
2017-06-20 08:30:00	MSFT	Stock	70.76	70.8	70.52	70.52	1745.0
2017-06-20 09:00:00	MSFT	Stock	70.53	70.73	70.53	70.73	5359.0
2017-06-20 09:30:00	MSFT	Stock	70.82	70.87	70.49	70.595	1710535.0
2017-06-20 10:00:00	MSFT	Stock	70.59	70.76	70.51	70.532	1292642.0
2017-06-20 10:30:00	MSFT	Stock	70.535	70.6	70.44	70.45	1132439.0
2017-06-20 11:00:00	MSFT	Stock	70.46	70.46	70.01	70.012	1310723.0
2017-06-20 11:30:00	MSFT	Stock	70.02	70.164	69.95	70.075	1041020.0
2017-06-20 12:00:00	MSFT	Stock	70.08	70.25	69.96	69.993	1136735.0
2017-06-20 12:30:00	MSFT	Stock	70.0	70.22	69.99	70.21	771987.0
2017-06-20 13:00:00	MSFT	Stock	70.22	70.24	70.14	70.16	511935.0
2017-06-20 13:30:00	MSFT	Stock	70.16	70.18	70.01	70.1	658422.0
2017-06-20 14:00:00	MSFT	Stock	70.09	70.22	70.035	70.046	771960.0
2017-06-20 14:30:00	MSFT	Stock	70.04	70.21	69.975	70.2	674406.0
2017-06-20 15:00:00	MSFT	Stock	70.2	70.29	70.06	70.135	1160215.0

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

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