PREVIEW / stock_30min / 2019-10-24

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-10-24.parquet
  size:    1.7 MB
  rows:    82,815
  symbols: 2,516

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-10-24 04:00:00	AAPL	Stock	61.0175	61.0175	60.925	60.9975	15024.0
2019-10-24 04:30:00	AAPL	Stock	60.9975	60.9975	60.9975	60.9975	3952.0
2019-10-24 05:00:00	AAPL	Stock	61.05	61.1025	61.05	61.1025	12932.0
2019-10-24 05:30:00	AAPL	Stock	61.0525	61.0525	61.05	61.0525	1600.0
2019-10-24 06:00:00	AAPL	Stock	61.0525	61.11	61.0525	61.11	6700.0
2019-10-24 06:30:00	AAPL	Stock	61.11	61.2225	61.11	61.1575	14680.0
2019-10-24 07:00:00	AAPL	Stock	61.175	61.1875	61.1125	61.1875	52252.0
2019-10-24 07:30:00	AAPL	Stock	61.1975	61.255	61.195	61.25	126544.0
2019-10-24 08:00:00	AAPL	Stock	61.144	61.25	60.645	61.2	221652.0
2019-10-24 08:30:00	AAPL	Stock	61.2	61.2125	61.0875	61.1175	223696.0
2019-10-24 09:00:00	AAPL	Stock	61.1275	61.1725	61.0875	61.1175	239160.0
2019-10-24 09:30:00	AAPL	Stock	61.1275	61.2	60.5475	60.6525	12707680.0
2019-10-24 10:00:00	AAPL	Stock	60.6575	60.7475	60.48	60.69	5782064.0
2019-10-24 10:30:00	AAPL	Stock	60.69	60.6975	60.4512	60.6132	4243396.0
2019-10-24 11:00:00	AAPL	Stock	60.615	60.83	60.5775	60.815	3708816.0
2019-10-24 11:30:00	AAPL	Stock	60.82	60.8662	60.64	60.82	4356944.0
2019-10-24 12:00:00	AAPL	Stock	60.815	60.8475	60.55	60.6825	3147216.0
2019-10-24 12:30:00	AAPL	Stock	60.6775	60.8375	60.65	60.7525	2353668.0
2019-10-24 13:00:00	AAPL	Stock	60.7525	60.771	60.68	60.755	1805956.0
2019-10-24 13:30:00	AAPL	Stock	60.755	60.7675	60.58	60.6025	2671844.0
2019-10-24 14:00:00	AAPL	Stock	60.605	60.7205	60.5875	60.7205	2141596.0
2019-10-24 14:30:00	AAPL	Stock	60.7175	60.8075	60.705	60.75	2152624.0
2019-10-24 15:00:00	AAPL	Stock	60.7525	60.805	60.74	60.7825	2118660.0
2019-10-24 15:30:00	AAPL	Stock	60.785	60.915	60.76	60.9	5971372.0
2019-10-24 16:00:00	AAPL	Stock	60.9	60.9	60.625	60.8	5165896.0
2019-10-24 16:30:00	AAPL	Stock	60.775	60.895	60.7625	60.8	67960.0
2019-10-24 17:00:00	AAPL	Stock	60.81	60.825	60.8	60.805	22896.0
2019-10-24 17:30:00	AAPL	Stock	60.82	60.8325	60.8	60.8125	24976.0
2019-10-24 18:00:00	AAPL	Stock	60.835	60.835	60.825	60.835	21436.0
2019-10-24 18:30:00	AAPL	Stock	60.835	60.86	60.8325	60.8325	24648.0
2019-10-24 19:00:00	AAPL	Stock	60.8425	60.85	60.83	60.85	11516.0
2019-10-24 19:30:00	AAPL	Stock	60.8475	60.85	60.8125	60.8225	79288.0
2019-10-24 04:00:00	MSFT	Stock	138.75	138.77	138.0	138.43	3468.0
2019-10-24 04:30:00	MSFT	Stock	138.4	138.58	138.4	138.5	1587.0
2019-10-24 05:00:00	MSFT	Stock	138.58	138.58	138.5	138.5	610.0
2019-10-24 05:30:00	MSFT	Stock	138.45	138.45	138.34	138.4	900.0
2019-10-24 06:00:00	MSFT	Stock	138.5	138.69	138.5	138.69	4191.0
2019-10-24 06:30:00	MSFT	Stock	138.69	138.69	138.35	138.38	6449.0
2019-10-24 07:00:00	MSFT	Stock	138.5	138.88	137.86	138.69	88944.0
2019-10-24 07:30:00	MSFT	Stock	138.7	138.84	138.54	138.8	73387.0
2019-10-24 08:00:00	MSFT	Stock	138.0	138.97	137.9	138.8	185398.0
2019-10-24 08:30:00	MSFT	Stock	138.77	139.13	138.54	138.69	137515.0
2019-10-24 09:00:00	MSFT	Stock	138.689	139.38	138.56	139.11	199718.0
2019-10-24 09:30:00	MSFT	Stock	139.11	140.09	138.72	139.37	8416856.0
2019-10-24 10:00:00	MSFT	Stock	139.37	139.918	138.67	139.515	3865334.0
2019-10-24 10:30:00	MSFT	Stock	139.52	139.688	139.075	139.645	1722539.0
2019-10-24 11:00:00	MSFT	Stock	139.65	139.82	139.32	139.76	2005456.0
2019-10-24 11:30:00	MSFT	Stock	139.76	140.26	139.71	140.16	2992652.0
2019-10-24 12:00:00	MSFT	Stock	140.17	140.32	139.59	139.968	1949700.0
2019-10-24 12:30:00	MSFT	Stock	139.97	140.42	139.95	140.362	1556292.0

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

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