PREVIEW / stock_30min / 2018-11-26

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-11-26.parquet
  size:    1.7 MB
  rows:    84,618
  symbols: 2,745

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-11-26 04:00:00	AAPL	Stock	43.6375	43.875	43.6375	43.8725	57296.0
2018-11-26 04:30:00	AAPL	Stock	43.8975	43.8975	43.835	43.875	27596.0
2018-11-26 05:00:00	AAPL	Stock	43.9	43.9	43.8425	43.85	11236.0
2018-11-26 05:30:00	AAPL	Stock	43.8375	43.9975	43.7525	43.85	49568.0
2018-11-26 06:00:00	AAPL	Stock	43.9	43.9175	43.8375	43.9	21860.0
2018-11-26 06:30:00	AAPL	Stock	43.91	43.95	43.85	43.9125	13368.0
2018-11-26 07:00:00	AAPL	Stock	43.88	43.9	43.565	43.6025	373264.0
2018-11-26 07:30:00	AAPL	Stock	43.6025	43.665	43.525	43.625	264588.0
2018-11-26 08:00:00	AAPL	Stock	43.64	43.875	43.5125	43.575	525388.0
2018-11-26 08:30:00	AAPL	Stock	43.595	43.605	43.4625	43.5625	345916.0
2018-11-26 09:00:00	AAPL	Stock	43.5625	43.615	43.505	43.5625	280532.0
2018-11-26 09:30:00	AAPL	Stock	43.56	43.7375	43.1938	43.6725	23092044.0
2018-11-26 10:00:00	AAPL	Stock	43.6688	43.6775	43.195	43.39	12533756.0
2018-11-26 10:30:00	AAPL	Stock	43.4	43.595	43.31	43.5075	8658084.0
2018-11-26 11:00:00	AAPL	Stock	43.505	43.5155	43.1	43.14	11955664.0
2018-11-26 11:30:00	AAPL	Stock	43.135	43.1375	42.835	42.9342	13914124.0
2018-11-26 12:00:00	AAPL	Stock	42.93	43.1475	42.6625	42.73	11008108.0
2018-11-26 12:30:00	AAPL	Stock	42.7275	42.845	42.565	42.84	10567280.0
2018-11-26 13:00:00	AAPL	Stock	42.842	43.0625	42.7075	42.97	8929284.0
2018-11-26 13:30:00	AAPL	Stock	42.965	43.233	42.895	43.22	8011152.0
2018-11-26 14:00:00	AAPL	Stock	43.2218	43.36	43.2218	43.267	7512604.0
2018-11-26 14:30:00	AAPL	Stock	43.2725	43.3825	43.2025	43.34	7041416.0
2018-11-26 15:00:00	AAPL	Stock	43.3425	43.4225	43.295	43.3672	6158044.0
2018-11-26 15:30:00	AAPL	Stock	43.3658	43.6575	43.365	43.655	14831180.0
2018-11-26 16:00:00	AAPL	Stock	43.6575	43.6575	42.775	43.0125	13649860.0
2018-11-26 16:30:00	AAPL	Stock	43.025	43.0725	42.8325	42.9075	778648.0
2018-11-26 17:00:00	AAPL	Stock	42.8825	43.075	42.8325	43.0125	628748.0
2018-11-26 17:30:00	AAPL	Stock	43.0	43.0	42.9125	42.9125	147572.0
2018-11-26 18:00:00	AAPL	Stock	42.915	43.0025	42.8425	42.875	178728.0
2018-11-26 18:30:00	AAPL	Stock	42.875	42.9	42.795	42.8	151712.0
2018-11-26 19:00:00	AAPL	Stock	42.8025	42.825	42.725	42.7725	292984.0
2018-11-26 19:30:00	AAPL	Stock	42.77	42.8125	42.7125	42.7325	214212.0
2018-11-26 04:00:00	MSFT	Stock	104.3	104.98	104.3	104.98	2376.0
2018-11-26 04:30:00	MSFT	Stock	105.3	105.3	105.3	105.3	980.0
2018-11-26 05:00:00	MSFT	Stock	105.0	105.0	104.98	104.98	621.0
2018-11-26 05:30:00	MSFT	Stock	104.5	104.5	104.49	104.49	422.0
2018-11-26 06:00:00	MSFT	Stock	104.74	104.74	104.74	104.74	100.0
2018-11-26 07:00:00	MSFT	Stock	104.7	104.85	104.31	104.69	7030.0
2018-11-26 07:30:00	MSFT	Stock	104.7	104.75	104.6	104.6	3646.0
2018-11-26 08:00:00	MSFT	Stock	104.5	104.77	104.4	104.65	25514.0
2018-11-26 08:30:00	MSFT	Stock	104.59	104.61	104.35	104.52	13746.0
2018-11-26 09:00:00	MSFT	Stock	104.52	104.84	104.52	104.73	17836.0
2018-11-26 09:30:00	MSFT	Stock	104.77	105.43	104.58	105.41	4043227.0
2018-11-26 10:00:00	MSFT	Stock	105.405	105.84	105.312	105.63	2301242.0
2018-11-26 10:30:00	MSFT	Stock	105.63	105.92	105.355	105.745	2062843.0
2018-11-26 11:00:00	MSFT	Stock	105.74	105.94	105.43	105.78	1701908.0
2018-11-26 11:30:00	MSFT	Stock	105.78	105.785	105.18	105.395	1792683.0
2018-11-26 12:00:00	MSFT	Stock	105.4	105.72	105.02	105.16	1250875.0
2018-11-26 12:30:00	MSFT	Stock	105.15	105.16	104.65	105.15	1497503.0
2018-11-26 13:00:00	MSFT	Stock	105.14	105.42	105.06	105.35	955810.0

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

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