PREVIEW / stock_30min / 2019-03-22

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-03-22.parquet
  size:    1.7 MB
  rows:    84,865
  symbols: 2,627

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-03-22 04:00:00	AAPL	Stock	49.1	49.25	49.0325	49.0325	30016.0
2019-03-22 04:30:00	AAPL	Stock	49.0975	49.0975	48.88	48.88	36324.0
2019-03-22 05:00:00	AAPL	Stock	48.9425	48.945	48.7875	48.875	29880.0
2019-03-22 05:30:00	AAPL	Stock	48.81	48.9	48.81	48.8875	3416.0
2019-03-22 06:00:00	AAPL	Stock	48.8875	48.8875	48.8075	48.8075	7452.0
2019-03-22 06:30:00	AAPL	Stock	48.8325	48.835	48.7725	48.7725	16380.0
2019-03-22 07:00:00	AAPL	Stock	48.7975	48.925	48.7975	48.92	131800.0
2019-03-22 07:30:00	AAPL	Stock	48.91	48.92	48.8125	48.855	70628.0
2019-03-22 08:00:00	AAPL	Stock	48.835	48.9225	48.72	48.72	854564.0
2019-03-22 08:30:00	AAPL	Stock	48.7275	48.7975	48.6325	48.7725	379308.0
2019-03-22 09:00:00	AAPL	Stock	48.76	48.8625	48.7125	48.82	270628.0
2019-03-22 09:30:00	AAPL	Stock	48.835	49.4225	48.5025	48.6225	32931660.0
2019-03-22 10:00:00	AAPL	Stock	48.6225	49.1225	48.6225	48.925	16576816.0
2019-03-22 10:30:00	AAPL	Stock	48.9275	49.035	48.6025	48.705	9951912.0
2019-03-22 11:00:00	AAPL	Stock	48.7075	48.7225	48.445	48.5945	10389900.0
2019-03-22 11:30:00	AAPL	Stock	48.5875	48.6575	48.2275	48.2375	9696924.0
2019-03-22 12:00:00	AAPL	Stock	48.235	48.415	48.135	48.165	8568176.0
2019-03-22 12:30:00	AAPL	Stock	48.1575	48.3075	48.0075	48.19	6294220.0
2019-03-22 13:00:00	AAPL	Stock	48.19	48.36	48.08	48.1425	4916668.0
2019-03-22 13:30:00	AAPL	Stock	48.14	48.2375	48.005	48.03	3898140.0
2019-03-22 14:00:00	AAPL	Stock	48.0325	48.295	48.0125	48.24	5111048.0
2019-03-22 14:30:00	AAPL	Stock	48.2382	48.3725	48.155	48.35	4821056.0
2019-03-22 15:00:00	AAPL	Stock	48.3525	48.4125	48.0625	48.07	6618212.0
2019-03-22 15:30:00	AAPL	Stock	48.065	48.0725	47.695	47.765	18828696.0
2019-03-22 16:00:00	AAPL	Stock	47.7625	48.5458	47.7375	48.5458	10620184.0
2019-03-22 16:30:00	AAPL	Stock	47.8	47.8125	47.785	47.7875	93580.0
2019-03-22 17:00:00	AAPL	Stock	47.8	47.8125	47.7625	47.775	154008.0
2019-03-22 17:30:00	AAPL	Stock	47.775	47.8125	47.775	47.8125	47776.0
2019-03-22 18:00:00	AAPL	Stock	47.7875	47.82	47.775	47.815	75768.0
2019-03-22 18:30:00	AAPL	Stock	47.8075	47.82	47.79	47.79	16236.0
2019-03-22 19:00:00	AAPL	Stock	47.8125	47.82	47.7775	47.7875	17608.0
2019-03-22 19:30:00	AAPL	Stock	47.7875	47.8125	47.75	47.75	56920.0
2019-03-22 04:30:00	MSFT	Stock	119.92	119.92	119.16	119.16	865.0
2019-03-22 05:30:00	MSFT	Stock	119.95	120.0	119.54	119.7	3985.0
2019-03-22 06:00:00	MSFT	Stock	119.75	119.75	119.67	119.67	790.0
2019-03-22 06:30:00	MSFT	Stock	119.6	119.69	119.6	119.68	1000.0
2019-03-22 07:00:00	MSFT	Stock	119.67	119.87	119.65	119.8	5116.0
2019-03-22 07:30:00	MSFT	Stock	119.85	119.95	119.51	119.6	9775.0
2019-03-22 08:00:00	MSFT	Stock	119.628	119.72	119.25	119.59	9631.0
2019-03-22 08:30:00	MSFT	Stock	119.52	119.59	119.25	119.5	47186.0
2019-03-22 09:00:00	MSFT	Stock	119.48	119.57	119.3	119.3	15289.0
2019-03-22 09:30:00	MSFT	Stock	119.5	119.59	118.24	118.56	3095221.0
2019-03-22 10:00:00	MSFT	Stock	118.57	119.34	118.52	118.95	1941529.0
2019-03-22 10:30:00	MSFT	Stock	118.95	119.07	118.42	118.66	1374224.0
2019-03-22 11:00:00	MSFT	Stock	118.65	118.8	118.425	118.455	1593464.0
2019-03-22 11:30:00	MSFT	Stock	118.45	118.61	117.785	117.79	1900623.0
2019-03-22 12:00:00	MSFT	Stock	117.799	118.153	117.69	117.79	1889236.0
2019-03-22 12:30:00	MSFT	Stock	117.79	118.21	117.615	118.15	1167977.0
2019-03-22 13:00:00	MSFT	Stock	118.15	118.25	117.87	117.95	971492.0
2019-03-22 13:30:00	MSFT	Stock	117.92	118.14	117.48	117.57	1024847.0

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

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