PREVIEW / stock_30min / 2019-02-11

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-02-11.parquet
  size:    1.7 MB
  rows:    82,879
  symbols: 2,675

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
2019-02-11 04:00:00	AAPL	Stock	42.8175	42.8175	42.7375	42.7375	2400.0
2019-02-11 04:30:00	AAPL	Stock	42.8125	42.8125	42.8125	42.8125	400.0
2019-02-11 05:00:00	AAPL	Stock	42.75	42.75	42.75	42.75	800.0
2019-02-11 05:30:00	AAPL	Stock	42.8	42.8125	42.705	42.705	17324.0
2019-02-11 06:00:00	AAPL	Stock	42.75	42.75	42.7	42.7	2760.0
2019-02-11 06:30:00	AAPL	Stock	42.675	42.7	42.6375	42.6875	14304.0
2019-02-11 07:00:00	AAPL	Stock	42.6975	42.75	42.6375	42.7325	55432.0
2019-02-11 07:30:00	AAPL	Stock	42.745	42.785	42.72	42.785	70924.0
2019-02-11 08:00:00	AAPL	Stock	42.6875	42.845	42.67	42.8	152240.0
2019-02-11 08:30:00	AAPL	Stock	42.8	42.8075	42.7525	42.7875	114988.0
2019-02-11 09:00:00	AAPL	Stock	42.795	42.8025	42.71	42.7475	125676.0
2019-02-11 09:30:00	AAPL	Stock	42.7625	42.8025	42.3525	42.554	11026744.0
2019-02-11 10:00:00	AAPL	Stock	42.555	42.675	42.515	42.6075	7405276.0
2019-02-11 10:30:00	AAPL	Stock	42.615	42.6575	42.5025	42.53	5259116.0
2019-02-11 11:00:00	AAPL	Stock	42.5325	42.5425	42.345	42.4118	5498164.0
2019-02-11 11:30:00	AAPL	Stock	42.41	42.4625	42.3575	42.45	3263676.0
2019-02-11 12:00:00	AAPL	Stock	42.45	42.6275	42.4225	42.6232	3399440.0
2019-02-11 12:30:00	AAPL	Stock	42.625	42.6675	42.5958	42.615	2828972.0
2019-02-11 13:00:00	AAPL	Stock	42.615	42.625	42.45	42.4675	3223884.0
2019-02-11 13:30:00	AAPL	Stock	42.4688	42.5	42.4075	42.48	2432712.0
2019-02-11 14:00:00	AAPL	Stock	42.4775	42.505	42.4275	42.475	2692076.0
2019-02-11 14:30:00	AAPL	Stock	42.4728	42.525	42.3588	42.3825	3831736.0
2019-02-11 15:00:00	AAPL	Stock	42.385	42.48	42.3825	42.4012	3454960.0
2019-02-11 15:30:00	AAPL	Stock	42.4	42.43	42.3125	42.3625	8783836.0
2019-02-11 16:00:00	AAPL	Stock	42.3575	42.36	42.3	42.3075	7028768.0
2019-02-11 16:30:00	AAPL	Stock	42.3	42.3575	42.2575	42.275	157544.0
2019-02-11 17:00:00	AAPL	Stock	42.2675	42.3575	42.255	42.2925	32212.0
2019-02-11 17:30:00	AAPL	Stock	42.27	42.275	42.26	42.2625	16084.0
2019-02-11 18:00:00	AAPL	Stock	42.2625	42.27	42.25	42.25	23100.0
2019-02-11 18:30:00	AAPL	Stock	42.25	42.265	42.225	42.2625	12216.0
2019-02-11 19:00:00	AAPL	Stock	42.2625	42.3	42.25	42.3	63036.0
2019-02-11 19:30:00	AAPL	Stock	42.2975	42.3575	42.29	42.345	73716.0
2019-02-11 05:00:00	MSFT	Stock	106.3	106.3	106.3	106.3	593.0
2019-02-11 05:30:00	MSFT	Stock	106.14	106.14	106.14	106.14	938.0
2019-02-11 07:00:00	MSFT	Stock	106.0	106.15	105.99	106.15	2852.0
2019-02-11 07:30:00	MSFT	Stock	106.07	106.3	106.07	106.3	2906.0
2019-02-11 08:00:00	MSFT	Stock	106.2	106.36	105.85	106.2	8440.0
2019-02-11 08:30:00	MSFT	Stock	106.19	106.23	106.13	106.13	7040.0
2019-02-11 09:00:00	MSFT	Stock	106.11	106.25	105.93	106.06	17568.0
2019-02-11 09:30:00	MSFT	Stock	106.06	106.58	105.78	105.9	2123218.0
2019-02-11 10:00:00	MSFT	Stock	105.9	106.09	105.42	105.57	1332703.0
2019-02-11 10:30:00	MSFT	Stock	105.59	105.92	105.46	105.51	990107.0
2019-02-11 11:00:00	MSFT	Stock	105.51	105.65	105.16	105.4	1143678.0
2019-02-11 11:30:00	MSFT	Stock	105.4	105.46	105.18	105.33	834343.0
2019-02-11 12:00:00	MSFT	Stock	105.322	105.6	105.26	105.56	621245.0
2019-02-11 12:30:00	MSFT	Stock	105.56	105.65	105.428	105.485	582502.0
2019-02-11 13:00:00	MSFT	Stock	105.495	105.52	105.22	105.23	688541.0
2019-02-11 13:30:00	MSFT	Stock	105.23	105.37	105.084	105.23	649315.0
2019-02-11 14:00:00	MSFT	Stock	105.228	105.4	105.14	105.218	654578.0
2019-02-11 14:30:00	MSFT	Stock	105.215	105.329	104.965	105.145	783897.0

> showing 50 of 82,879 rows — these rows as CSV

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