PREVIEW / stock_30min / 2018-07-26

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-07-26.parquet
  size:    1.7 MB
  rows:    83,127
  symbols: 2,832

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-07-26 04:00:00	AAPL	Stock	48.205	48.3175	48.205	48.31	9880.0
2018-07-26 04:30:00	AAPL	Stock	48.3125	48.3125	48.2475	48.3125	19964.0
2018-07-26 05:00:00	AAPL	Stock	48.3	48.3125	48.2475	48.3025	13476.0
2018-07-26 05:30:00	AAPL	Stock	48.3125	48.3125	48.3125	48.3125	23556.0
2018-07-26 06:00:00	AAPL	Stock	48.2875	48.36	48.2875	48.36	10624.0
2018-07-26 06:30:00	AAPL	Stock	48.3575	48.4125	48.35	48.375	47900.0
2018-07-26 07:00:00	AAPL	Stock	48.38	48.445	48.3625	48.3925	76036.0
2018-07-26 07:30:00	AAPL	Stock	48.3975	48.45	48.3875	48.4475	33328.0
2018-07-26 08:00:00	AAPL	Stock	48.39	48.6875	48.39	48.6	400876.0
2018-07-26 08:30:00	AAPL	Stock	48.57	48.6175	48.475	48.5025	229220.0
2018-07-26 09:00:00	AAPL	Stock	48.4975	48.6525	48.4625	48.6525	488040.0
2018-07-26 09:30:00	AAPL	Stock	48.6525	48.82	48.4025	48.7975	15127160.0
2018-07-26 10:00:00	AAPL	Stock	48.8025	48.99	48.715	48.7425	8353856.0
2018-07-26 10:30:00	AAPL	Stock	48.7425	48.8575	48.7275	48.7975	3796052.0
2018-07-26 11:00:00	AAPL	Stock	48.7975	48.82	48.7075	48.7175	3142016.0
2018-07-26 11:30:00	AAPL	Stock	48.7225	48.765	48.6415	48.735	3500868.0
2018-07-26 12:00:00	AAPL	Stock	48.7362	48.755	48.6225	48.6538	2807328.0
2018-07-26 12:30:00	AAPL	Stock	48.655	48.685	48.505	48.5425	3233360.0
2018-07-26 13:00:00	AAPL	Stock	48.5425	48.7475	48.5225	48.7025	2422972.0
2018-07-26 13:30:00	AAPL	Stock	48.7	48.71	48.6075	48.6425	2035156.0
2018-07-26 14:00:00	AAPL	Stock	48.645	48.695	48.6125	48.6675	1886228.0
2018-07-26 14:30:00	AAPL	Stock	48.6675	48.6975	48.62	48.6562	1811652.0
2018-07-26 15:00:00	AAPL	Stock	48.6575	48.661	48.5625	48.6225	3275748.0
2018-07-26 15:30:00	AAPL	Stock	48.6225	48.6488	48.5	48.5575	6012888.0
2018-07-26 16:00:00	AAPL	Stock	48.56	48.7225	48.3725	48.58	8161240.0
2018-07-26 16:30:00	AAPL	Stock	48.55	48.625	48.55	48.5875	57300.0
2018-07-26 17:00:00	AAPL	Stock	48.5875	48.6825	48.5525	48.65	393264.0
2018-07-26 17:30:00	AAPL	Stock	48.625	48.6475	48.625	48.6425	30536.0
2018-07-26 18:00:00	AAPL	Stock	48.6475	48.65	48.625	48.65	34284.0
2018-07-26 18:30:00	AAPL	Stock	48.65	48.6775	48.64	48.65	49812.0
2018-07-26 19:00:00	AAPL	Stock	48.6675	48.6875	48.6675	48.675	15852.0
2018-07-26 19:30:00	AAPL	Stock	48.6625	48.7	48.65	48.65	39820.0
2018-07-26 04:00:00	MSFT	Stock	110.3	110.3	110.0	110.27	1500.0
2018-07-26 04:30:00	MSFT	Stock	110.06	110.2	110.06	110.2	720.0
2018-07-26 05:00:00	MSFT	Stock	109.94	110.2	109.88	109.88	4500.0
2018-07-26 05:30:00	MSFT	Stock	110.15	110.2	110.15	110.2	567.0
2018-07-26 06:00:00	MSFT	Stock	110.2	110.2	110.2	110.2	222.0
2018-07-26 06:30:00	MSFT	Stock	110.05	110.17	109.95	110.0	8603.0
2018-07-26 07:00:00	MSFT	Stock	110.06	110.2	110.0	110.15	9798.0
2018-07-26 07:30:00	MSFT	Stock	110.15	110.2	110.11	110.2	6631.0
2018-07-26 08:00:00	MSFT	Stock	110.0	110.46	109.987	110.29	36635.0
2018-07-26 08:30:00	MSFT	Stock	110.22	110.22	110.0	110.1	19490.0
2018-07-26 09:00:00	MSFT	Stock	110.12	110.64	110.05	110.53	260593.0
2018-07-26 09:30:00	MSFT	Stock	110.74	110.75	109.52	110.06	5087441.0
2018-07-26 10:00:00	MSFT	Stock	110.08	111.0	110.06	110.44	2726437.0
2018-07-26 10:30:00	MSFT	Stock	110.434	110.605	110.145	110.23	1755366.0
2018-07-26 11:00:00	MSFT	Stock	110.225	110.43	110.127	110.21	1313746.0
2018-07-26 11:30:00	MSFT	Stock	110.21	110.373	109.985	110.36	1579561.0
2018-07-26 12:00:00	MSFT	Stock	110.365	110.37	109.78	109.865	1270280.0
2018-07-26 12:30:00	MSFT	Stock	109.87	110.065	109.84	109.98	1472378.0

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

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