PREVIEW / stock_30min / 2018-10-03

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-10-03.parquet
  size:    1.7 MB
  rows:    84,615
  symbols: 2,794

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-03 04:00:00	AAPL	Stock	57.5	57.5875	57.5	57.5875	4264.0
2018-10-03 04:30:00	AAPL	Stock	57.575	57.6125	57.575	57.6125	1600.0
2018-10-03 05:00:00	AAPL	Stock	57.59	57.5925	57.5	57.525	9632.0
2018-10-03 05:30:00	AAPL	Stock	57.5275	57.575	57.5275	57.55	7200.0
2018-10-03 06:00:00	AAPL	Stock	57.575	57.575	57.57	57.5725	9220.0
2018-10-03 06:30:00	AAPL	Stock	57.545	57.55	57.5325	57.55	4028.0
2018-10-03 07:00:00	AAPL	Stock	57.525	57.5975	57.4625	57.58	50316.0
2018-10-03 07:30:00	AAPL	Stock	57.5675	57.575	57.525	57.55	55896.0
2018-10-03 08:00:00	AAPL	Stock	57.5	57.65	57.4625	57.5375	294776.0
2018-10-03 08:30:00	AAPL	Stock	57.5375	57.62	57.5375	57.61	91572.0
2018-10-03 09:00:00	AAPL	Stock	57.61	57.7	57.505	57.535	283532.0
2018-10-03 09:30:00	AAPL	Stock	57.5125	58.0825	57.445	57.9712	16346080.0
2018-10-03 10:00:00	AAPL	Stock	57.975	58.3675	57.9575	58.2062	12503284.0
2018-10-03 10:30:00	AAPL	Stock	58.21	58.28	58.0575	58.1325	8030452.0
2018-10-03 11:00:00	AAPL	Stock	58.1325	58.325	58.02	58.27	7806000.0
2018-10-03 11:30:00	AAPL	Stock	58.265	58.2848	57.9375	58.1825	7934216.0
2018-10-03 12:00:00	AAPL	Stock	58.185	58.21	58.0875	58.15	3336836.0
2018-10-03 12:30:00	AAPL	Stock	58.15	58.1725	58.0125	58.1725	3224392.0
2018-10-03 13:00:00	AAPL	Stock	58.17	58.235	58.1225	58.172	2573024.0
2018-10-03 13:30:00	AAPL	Stock	58.1735	58.2225	58.12	58.1275	2349416.0
2018-10-03 14:00:00	AAPL	Stock	58.1275	58.22	58.1075	58.125	2541560.0
2018-10-03 14:30:00	AAPL	Stock	58.125	58.1425	57.94	58.0975	6373136.0
2018-10-03 15:00:00	AAPL	Stock	58.0975	58.1375	57.8928	57.9725	5886852.0
2018-10-03 15:30:00	AAPL	Stock	57.9725	58.045	57.94	58.025	7693628.0
2018-10-03 16:00:00	AAPL	Stock	58.0175	58.035	57.9745	58.0052	9685436.0
2018-10-03 16:30:00	AAPL	Stock	58.02	58.02	57.9375	57.975	84112.0
2018-10-03 17:00:00	AAPL	Stock	57.975	57.975	57.96	57.96	9996.0
2018-10-03 17:30:00	AAPL	Stock	57.9375	57.9735	57.9375	57.9625	40840.0
2018-10-03 18:00:00	AAPL	Stock	57.9375	57.95	57.8975	57.93	51996.0
2018-10-03 18:30:00	AAPL	Stock	57.925	57.9875	57.9125	57.975	71856.0
2018-10-03 19:00:00	AAPL	Stock	57.93	57.9625	57.93	57.935	7388.0
2018-10-03 19:30:00	AAPL	Stock	57.9375	57.9475	57.905	57.93	50104.0
2018-10-03 04:30:00	MSFT	Stock	115.5	115.5	115.5	115.5	420.0
2018-10-03 06:30:00	MSFT	Stock	115.37	115.37	115.36	115.37	2054.0
2018-10-03 07:00:00	MSFT	Stock	115.48	115.53	115.26	115.53	4272.0
2018-10-03 08:00:00	MSFT	Stock	115.406	115.65	115.35	115.37	11196.0
2018-10-03 08:30:00	MSFT	Stock	115.5	115.64	115.38	115.64	1976.0
2018-10-03 09:00:00	MSFT	Stock	115.59	115.62	115.5	115.5	9147.0
2018-10-03 09:30:00	MSFT	Stock	115.42	115.9	115.41	115.89	1873091.0
2018-10-03 10:00:00	MSFT	Stock	115.9	116.18	115.855	116.051	1306468.0
2018-10-03 10:30:00	MSFT	Stock	116.06	116.11	115.64	115.71	1027072.0
2018-10-03 11:00:00	MSFT	Stock	115.7	115.97	115.52	115.879	935663.0
2018-10-03 11:30:00	MSFT	Stock	115.875	116.03	115.64	115.813	800797.0
2018-10-03 12:00:00	MSFT	Stock	115.82	115.83	115.66	115.69	431152.0
2018-10-03 12:30:00	MSFT	Stock	115.69	115.69	115.405	115.507	688841.0
2018-10-03 13:00:00	MSFT	Stock	115.5	115.74	115.485	115.523	396536.0
2018-10-03 13:30:00	MSFT	Stock	115.525	115.58	115.43	115.5	429979.0
2018-10-03 14:00:00	MSFT	Stock	115.506	115.63	115.47	115.48	433488.0
2018-10-03 14:30:00	MSFT	Stock	115.48	115.505	115.14	115.22	1084306.0
2018-10-03 15:00:00	MSFT	Stock	115.22	115.38	114.93	115.06	1032852.0

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

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