PREVIEW / stock_30min / 2018-05-23

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-05-23.parquet
  size:    1.7 MB
  rows:    83,123
  symbols: 2,847

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-05-23 04:00:00	AAPL	Stock	46.4975	46.515	46.35	46.35	13008.0
2018-05-23 04:30:00	AAPL	Stock	46.31	46.35	46.2625	46.2625	38416.0
2018-05-23 05:00:00	AAPL	Stock	46.2525	46.2525	46.1625	46.25	27556.0
2018-05-23 06:00:00	AAPL	Stock	46.3	46.3	46.3	46.3	4400.0
2018-05-23 06:30:00	AAPL	Stock	46.3425	46.355	46.3025	46.325	10160.0
2018-05-23 07:00:00	AAPL	Stock	46.375	46.4875	46.3025	46.4375	176504.0
2018-05-23 07:30:00	AAPL	Stock	46.4475	46.4625	46.38	46.4	35372.0
2018-05-23 08:00:00	AAPL	Stock	46.41	46.4875	46.3025	46.475	355672.0
2018-05-23 08:30:00	AAPL	Stock	46.4775	46.5575	46.4775	46.5525	343964.0
2018-05-23 09:00:00	AAPL	Stock	46.5475	46.5675	46.465	46.5525	224252.0
2018-05-23 09:30:00	AAPL	Stock	46.5875	46.7875	46.4875	46.52	9279900.0
2018-05-23 10:00:00	AAPL	Stock	46.525	46.7	46.4975	46.6	5013996.0
2018-05-23 10:30:00	AAPL	Stock	46.6	46.62	46.44	46.48	3860344.0
2018-05-23 11:00:00	AAPL	Stock	46.4775	46.6025	46.4675	46.54	3106692.0
2018-05-23 11:30:00	AAPL	Stock	46.5475	46.6375	46.4825	46.5725	3431180.0
2018-05-23 12:00:00	AAPL	Stock	46.5775	46.6675	46.5525	46.5838	2813352.0
2018-05-23 12:30:00	AAPL	Stock	46.585	46.7425	46.5825	46.7285	2240732.0
2018-05-23 13:00:00	AAPL	Stock	46.7275	46.7425	46.63	46.695	2057884.0
2018-05-23 13:30:00	AAPL	Stock	46.6975	46.705	46.6375	46.6725	1555920.0
2018-05-23 14:00:00	AAPL	Stock	46.675	46.9275	46.6425	46.82	4735924.0
2018-05-23 14:30:00	AAPL	Stock	46.8212	46.915	46.7825	46.9132	2509296.0
2018-05-23 15:00:00	AAPL	Stock	46.9125	47.015	46.8962	47.005	3903952.0
2018-05-23 15:30:00	AAPL	Stock	47.0025	47.125	46.935	47.1125	8147520.0
2018-05-23 16:00:00	AAPL	Stock	47.115	47.115	46.972	47.0875	13634412.0
2018-05-23 16:30:00	AAPL	Stock	47.0875	47.09	47.06	47.07	120360.0
2018-05-23 17:00:00	AAPL	Stock	47.07	47.1075	47.07	47.1075	1817752.0
2018-05-23 17:30:00	AAPL	Stock	47.1175	47.1425	47.1175	47.125	133964.0
2018-05-23 18:00:00	AAPL	Stock	47.1125	47.195	47.1	47.15	108424.0
2018-05-23 18:30:00	AAPL	Stock	47.14	47.175	47.14	47.175	13240.0
2018-05-23 19:00:00	AAPL	Stock	47.1875	47.2025	47.1725	47.175	38860.0
2018-05-23 19:30:00	AAPL	Stock	47.1625	47.1875	47.135	47.1625	39024.0
2018-05-23 04:00:00	MSFT	Stock	96.9	96.9	96.9	96.9	150.0
2018-05-23 04:30:00	MSFT	Stock	96.86	96.86	96.81	96.81	724.0
2018-05-23 05:00:00	MSFT	Stock	96.75	96.75	96.74	96.74	512.0
2018-05-23 05:30:00	MSFT	Stock	96.76	96.76	96.76	96.76	500.0
2018-05-23 06:30:00	MSFT	Stock	96.75	96.75	96.75	96.75	447.0
2018-05-23 07:00:00	MSFT	Stock	96.8	96.98	96.7	96.85	5499.0
2018-05-23 07:30:00	MSFT	Stock	96.75	96.8	96.59	96.7	2817.0
2018-05-23 08:00:00	MSFT	Stock	96.55	96.84	96.55	96.65	4832.0
2018-05-23 08:30:00	MSFT	Stock	96.67	96.83	96.62	96.63	7346.0
2018-05-23 09:00:00	MSFT	Stock	96.67	96.88	96.6	96.65	25937.0
2018-05-23 09:30:00	MSFT	Stock	96.63	97.43	96.32	97.33	2381816.0
2018-05-23 10:00:00	MSFT	Stock	97.33	97.805	97.24	97.44	1251609.0
2018-05-23 10:30:00	MSFT	Stock	97.44	97.475	96.98	97.12	899030.0
2018-05-23 11:00:00	MSFT	Stock	97.125	97.605	97.1	97.527	935053.0
2018-05-23 11:30:00	MSFT	Stock	97.53	97.818	97.41	97.51	697296.0
2018-05-23 12:00:00	MSFT	Stock	97.51	97.68	97.33	97.35	627219.0
2018-05-23 12:30:00	MSFT	Stock	97.35	97.82	97.35	97.755	618537.0
2018-05-23 13:00:00	MSFT	Stock	97.75	97.76	97.41	97.515	535876.0
2018-05-23 13:30:00	MSFT	Stock	97.514	97.66	97.41	97.59	527154.0

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

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