PREVIEW / stock_30min / 2018-06-19

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-06-19.parquet
  size:    1.7 MB
  rows:    85,347
  symbols: 2,829

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-06-19 04:00:00	AAPL	Stock	46.75	46.75	46.5025	46.525	39196.0
2018-06-19 04:30:00	AAPL	Stock	46.5	46.65	46.5	46.65	47068.0
2018-06-19 05:00:00	AAPL	Stock	46.6875	46.7225	46.675	46.675	13784.0
2018-06-19 05:30:00	AAPL	Stock	46.74	46.74	46.675	46.675	11756.0
2018-06-19 06:00:00	AAPL	Stock	46.7025	46.7525	46.7	46.7525	8000.0
2018-06-19 06:30:00	AAPL	Stock	46.795	46.8	46.7125	46.725	20132.0
2018-06-19 07:00:00	AAPL	Stock	46.7	46.825	46.635	46.635	132636.0
2018-06-19 07:30:00	AAPL	Stock	46.635	46.7425	46.6125	46.725	167268.0
2018-06-19 08:00:00	AAPL	Stock	46.75	46.8225	46.5175	46.5375	504284.0
2018-06-19 08:30:00	AAPL	Stock	46.5275	46.595	46.4375	46.5	533888.0
2018-06-19 09:00:00	AAPL	Stock	46.505	46.6475	46.275	46.275	645732.0
2018-06-19 09:30:00	AAPL	Stock	46.315	46.5825	46.255	46.2975	21747976.0
2018-06-19 10:00:00	AAPL	Stock	46.2975	46.2975	45.96	45.9675	16848516.0
2018-06-19 10:30:00	AAPL	Stock	45.965	46.26	45.8625	46.205	12314404.0
2018-06-19 11:00:00	AAPL	Stock	46.205	46.2725	46.1225	46.2115	7109360.0
2018-06-19 11:30:00	AAPL	Stock	46.2125	46.32	46.1525	46.283	6758216.0
2018-06-19 12:00:00	AAPL	Stock	46.2825	46.315	46.2	46.2802	3857300.0
2018-06-19 12:30:00	AAPL	Stock	46.285	46.3325	46.2452	46.2925	3028208.0
2018-06-19 13:00:00	AAPL	Stock	46.29	46.35	46.2675	46.32	2396208.0
2018-06-19 13:30:00	AAPL	Stock	46.3175	46.4775	46.2575	46.42	4382768.0
2018-06-19 14:00:00	AAPL	Stock	46.42	46.455	46.375	46.4175	3721344.0
2018-06-19 14:30:00	AAPL	Stock	46.415	46.46	46.3925	46.4275	3632164.0
2018-06-19 15:00:00	AAPL	Stock	46.43	46.4362	46.3175	46.3275	3956772.0
2018-06-19 15:30:00	AAPL	Stock	46.3275	46.4625	46.3275	46.4425	8028864.0
2018-06-19 16:00:00	AAPL	Stock	46.4225	46.4475	46.4	46.425	12017220.0
2018-06-19 16:30:00	AAPL	Stock	46.4125	46.435	46.335	46.3875	827708.0
2018-06-19 17:00:00	AAPL	Stock	46.3875	46.435	46.1588	46.4075	145404.0
2018-06-19 17:30:00	AAPL	Stock	46.4375	46.4375	46.4275	46.435	3000.0
2018-06-19 18:00:00	AAPL	Stock	46.42	46.425	46.4075	46.4075	16832.0
2018-06-19 18:30:00	AAPL	Stock	46.4225	46.4225	46.4	46.4225	7400.0
2018-06-19 19:00:00	AAPL	Stock	46.4125	46.4375	46.4075	46.4375	10120.0
2018-06-19 19:30:00	AAPL	Stock	46.4125	46.45	46.4125	46.4375	57732.0
2018-06-19 04:00:00	MSFT	Stock	99.6	99.95	99.25	99.31	7347.0
2018-06-19 04:30:00	MSFT	Stock	99.33	99.57	99.3	99.3	3127.0
2018-06-19 05:00:00	MSFT	Stock	99.7	100.0	99.7	100.0	1100.0
2018-06-19 05:30:00	MSFT	Stock	100.09	100.09	99.72	99.72	200.0
2018-06-19 07:00:00	MSFT	Stock	99.94	99.94	99.7	99.7	14131.0
2018-06-19 07:30:00	MSFT	Stock	99.7	99.75	99.5	99.75	11350.0
2018-06-19 08:00:00	MSFT	Stock	99.85	101.05	99.45	99.5	28092.0
2018-06-19 08:30:00	MSFT	Stock	99.5	99.8	99.5	99.7	10254.0
2018-06-19 09:00:00	MSFT	Stock	99.74	99.85	99.57	99.59	24742.0
2018-06-19 09:30:00	MSFT	Stock	99.59	100.3	99.5	100.03	3669905.0
2018-06-19 10:00:00	MSFT	Stock	100.03	100.17	99.63	99.68	2272324.0
2018-06-19 10:30:00	MSFT	Stock	99.675	100.14	99.52	99.95	2139882.0
2018-06-19 11:00:00	MSFT	Stock	99.945	100.36	99.9	100.332	1686412.0
2018-06-19 11:30:00	MSFT	Stock	100.34	100.586	100.16	100.5	1182432.0
2018-06-19 12:00:00	MSFT	Stock	100.495	100.53	100.245	100.35	1030344.0
2018-06-19 12:30:00	MSFT	Stock	100.35	100.395	100.22	100.38	826749.0
2018-06-19 13:00:00	MSFT	Stock	100.39	100.44	100.25	100.29	511952.0
2018-06-19 13:30:00	MSFT	Stock	100.28	100.56	100.16	100.55	785453.0

> showing 50 of 85,347 rows — these rows as CSV

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