PREVIEW / stock_30min / 2018-10-12

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-10-12.parquet
  size:    1.7 MB
  rows:    85,503
  symbols: 2,756

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-10-12 04:00:00	AAPL	Stock	54.805	54.9675	54.685	54.685	36800.0
2018-10-12 04:30:00	AAPL	Stock	54.75	54.775	54.75	54.775	1900.0
2018-10-12 05:00:00	AAPL	Stock	54.7	54.735	54.61	54.7125	10000.0
2018-10-12 05:30:00	AAPL	Stock	54.735	54.84	54.73	54.8225	22172.0
2018-10-12 06:00:00	AAPL	Stock	54.825	54.825	54.6725	54.675	14196.0
2018-10-12 06:30:00	AAPL	Stock	54.7125	54.8125	54.655	54.8	25548.0
2018-10-12 07:00:00	AAPL	Stock	54.775	54.9625	54.7125	54.8125	263636.0
2018-10-12 07:30:00	AAPL	Stock	54.8125	54.8375	54.69	54.775	163512.0
2018-10-12 08:00:00	AAPL	Stock	54.925	54.97	54.725	54.845	471016.0
2018-10-12 08:30:00	AAPL	Stock	54.845	54.8525	54.6325	54.7425	316368.0
2018-10-12 09:00:00	AAPL	Stock	54.72	55.25	54.715	55.1525	1344088.0
2018-10-12 09:30:00	AAPL	Stock	55.1375	55.46	54.95	55.1975	23639024.0
2018-10-12 10:00:00	AAPL	Stock	55.1875	55.5625	55.0675	55.0775	12585760.0
2018-10-12 10:30:00	AAPL	Stock	55.0775	55.36	55.025	55.0435	8267280.0
2018-10-12 11:00:00	AAPL	Stock	55.05	55.2025	54.9625	55.025	5978484.0
2018-10-12 11:30:00	AAPL	Stock	55.0175	55.02	54.5	54.755	8388628.0
2018-10-12 12:00:00	AAPL	Stock	54.755	54.82	54.55	54.6685	4087132.0
2018-10-12 12:30:00	AAPL	Stock	54.67	54.75	54.21	54.6425	7377904.0
2018-10-12 13:00:00	AAPL	Stock	54.6435	54.9875	54.5525	54.6125	5891736.0
2018-10-12 13:30:00	AAPL	Stock	54.6125	54.8075	54.4218	54.645	3929192.0
2018-10-12 14:00:00	AAPL	Stock	54.645	54.8125	54.3625	54.7875	3613588.0
2018-10-12 14:30:00	AAPL	Stock	54.7875	55.0325	54.5375	54.96	4339616.0
2018-10-12 15:00:00	AAPL	Stock	54.9475	55.2525	54.86	55.195	6931616.0
2018-10-12 15:30:00	AAPL	Stock	55.195	55.72	55.1075	55.5275	18561716.0
2018-10-12 16:00:00	AAPL	Stock	55.5275	55.6375	55.525	55.635	15427372.0
2018-10-12 16:30:00	AAPL	Stock	55.62	55.6425	55.5275	55.6265	176564.0
2018-10-12 17:00:00	AAPL	Stock	55.62	55.645	55.5275	55.6025	117740.0
2018-10-12 17:30:00	AAPL	Stock	55.5875	55.6325	55.5875	55.5925	28908.0
2018-10-12 18:00:00	AAPL	Stock	55.6025	55.6175	55.59	55.6075	42456.0
2018-10-12 18:30:00	AAPL	Stock	55.595	55.605	55.5875	55.605	32832.0
2018-10-12 19:00:00	AAPL	Stock	55.5875	55.6375	55.5875	55.6075	41864.0
2018-10-12 19:30:00	AAPL	Stock	55.63	55.7375	55.605	55.7	50632.0
2018-10-12 04:00:00	MSFT	Stock	108.8	108.8	108.05	108.05	3098.0
2018-10-12 04:30:00	MSFT	Stock	108.44	108.47	108.3	108.3	2350.0
2018-10-12 05:00:00	MSFT	Stock	108.4	108.63	108.4	108.6	18977.0
2018-10-12 05:30:00	MSFT	Stock	108.78	109.4	108.78	109.15	15178.0
2018-10-12 06:00:00	MSFT	Stock	109.16	109.26	109.0	109.0	2900.0
2018-10-12 06:30:00	MSFT	Stock	109.25	109.43	109.25	109.4	5423.0
2018-10-12 07:00:00	MSFT	Stock	109.29	109.47	108.82	109.2	34521.0
2018-10-12 07:30:00	MSFT	Stock	109.04	109.2	108.79	109.03	26468.0
2018-10-12 08:00:00	MSFT	Stock	109.1	109.49	108.8	108.9	122727.0
2018-10-12 08:30:00	MSFT	Stock	109.0	109.18	108.69	108.84	75573.0
2018-10-12 09:00:00	MSFT	Stock	108.9	109.43	108.9	109.02	80140.0
2018-10-12 09:30:00	MSFT	Stock	109.02	109.301	107.58	108.46	6220728.0
2018-10-12 10:00:00	MSFT	Stock	108.45	109.28	108.1	108.11	3420142.0
2018-10-12 10:30:00	MSFT	Stock	108.1	109.2	108.1	108.69	2360892.0
2018-10-12 11:00:00	MSFT	Stock	108.71	108.945	108.495	108.65	1894645.0
2018-10-12 11:30:00	MSFT	Stock	108.64	108.92	108.05	108.41	1930442.0
2018-10-12 12:00:00	MSFT	Stock	108.41	108.49	107.7	107.94	2054931.0
2018-10-12 12:30:00	MSFT	Stock	107.94	108.02	107.12	107.83	2039545.0

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

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