PREVIEW / stock_30min / 2017-11-21

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-11-21.parquet
  size:    1.7 MB
  rows:    84,894
  symbols: 2,972

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-11-21 04:00:00	AAPL	Stock	42.58	42.58	42.4775	42.4775	900.0
2017-11-21 05:00:00	AAPL	Stock	42.6	42.6225	42.595	42.6225	6000.0
2017-11-21 06:00:00	AAPL	Stock	42.6225	42.625	42.57	42.57	4932.0
2017-11-21 06:30:00	AAPL	Stock	42.5875	42.625	42.5875	42.6125	10560.0
2017-11-21 07:00:00	AAPL	Stock	42.6225	42.6675	42.58	42.65	59388.0
2017-11-21 07:30:00	AAPL	Stock	42.63	42.6575	42.625	42.65	17136.0
2017-11-21 08:00:00	AAPL	Stock	42.6375	42.675	42.62	42.6575	156752.0
2017-11-21 08:30:00	AAPL	Stock	42.66	42.7125	42.66	42.675	154796.0
2017-11-21 09:00:00	AAPL	Stock	42.6725	42.75	42.64	42.7225	395516.0
2017-11-21 09:30:00	AAPL	Stock	42.695	43.215	42.695	43.2125	17040460.0
2017-11-21 10:00:00	AAPL	Stock	43.2112	43.425	43.195	43.39	11984244.0
2017-11-21 10:30:00	AAPL	Stock	43.3875	43.4025	43.2425	43.318	7237664.0
2017-11-21 11:00:00	AAPL	Stock	43.315	43.38	43.305	43.361	4630908.0
2017-11-21 11:30:00	AAPL	Stock	43.365	43.4125	43.3525	43.3812	4216704.0
2017-11-21 12:00:00	AAPL	Stock	43.38	43.4	43.2925	43.3125	3623300.0
2017-11-21 12:30:00	AAPL	Stock	43.3125	43.35	43.28	43.2925	2538016.0
2017-11-21 13:00:00	AAPL	Stock	43.294	43.3075	43.235	43.2838	2927440.0
2017-11-21 13:30:00	AAPL	Stock	43.2848	43.3	43.2675	43.2782	2391608.0
2017-11-21 14:00:00	AAPL	Stock	43.28	43.285	43.1875	43.214	3662688.0
2017-11-21 14:30:00	AAPL	Stock	43.2135	43.265	43.17	43.2412	2846544.0
2017-11-21 15:00:00	AAPL	Stock	43.2412	43.2575	43.1725	43.2062	3203300.0
2017-11-21 15:30:00	AAPL	Stock	43.2062	43.3075	43.1975	43.2825	8418164.0
2017-11-21 16:00:00	AAPL	Stock	43.285	43.3	43.25	43.28	8768660.0
2017-11-21 16:30:00	AAPL	Stock	43.275	43.285	43.2375	43.2575	258904.0
2017-11-21 17:00:00	AAPL	Stock	43.2625	43.2725	43.2525	43.2525	40472.0
2017-11-21 17:30:00	AAPL	Stock	43.2525	43.2725	43.25	43.2725	21368.0
2017-11-21 18:00:00	AAPL	Stock	43.2725	43.285	43.265	43.285	25668.0
2017-11-21 18:30:00	AAPL	Stock	43.2875	43.2875	43.285	43.2875	32820.0
2017-11-21 19:00:00	AAPL	Stock	43.2875	43.2875	43.265	43.2675	13300.0
2017-11-21 19:30:00	AAPL	Stock	43.2675	43.2725	43.2525	43.2625	24600.0
2017-11-21 06:00:00	MSFT	Stock	82.98	82.98	82.98	82.98	200.0
2017-11-21 07:00:00	MSFT	Stock	82.84	82.84	82.84	82.84	842.0
2017-11-21 07:30:00	MSFT	Stock	82.83	82.99	82.83	82.95	1802.0
2017-11-21 08:00:00	MSFT	Stock	82.99	82.99	82.9	82.95	3600.0
2017-11-21 08:30:00	MSFT	Stock	82.8	82.99	82.74	82.74	6890.0
2017-11-21 09:00:00	MSFT	Stock	82.9	83.02	82.74	82.93	4344.0
2017-11-21 09:30:00	MSFT	Stock	82.74	83.46	82.74	83.41	2192652.0
2017-11-21 10:00:00	MSFT	Stock	83.41	83.77	83.35	83.67	1753278.0
2017-11-21 10:30:00	MSFT	Stock	83.67	83.74	83.46	83.74	1296388.0
2017-11-21 11:00:00	MSFT	Stock	83.74	83.84	83.63	83.67	1177006.0
2017-11-21 11:30:00	MSFT	Stock	83.67	83.715	83.61	83.644	790572.0
2017-11-21 12:00:00	MSFT	Stock	83.65	83.685	83.57	83.624	506382.0
2017-11-21 12:30:00	MSFT	Stock	83.63	83.66	83.57	83.63	629184.0
2017-11-21 13:00:00	MSFT	Stock	83.635	83.7	83.59	83.68	551187.0
2017-11-21 13:30:00	MSFT	Stock	83.68	83.78	83.65	83.745	529437.0
2017-11-21 14:00:00	MSFT	Stock	83.74	83.76	83.64	83.68	456613.0
2017-11-21 14:30:00	MSFT	Stock	83.69	83.74	83.65	83.71	681275.0
2017-11-21 15:00:00	MSFT	Stock	83.7	83.75	83.66	83.705	1100545.0
2017-11-21 15:30:00	MSFT	Stock	83.71	83.78	83.61	83.73	2617195.0
2017-11-21 16:00:00	MSFT	Stock	83.72	83.78	83.61	83.61	4262122.0

> showing 50 of 84,894 rows — these rows as CSV

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