PREVIEW / stock_30min / 2019-03-18

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-03-18.parquet
  size:    1.7 MB
  rows:    85,650
  symbols: 2,663

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-18 04:00:00	AAPL	Stock	46.675	46.71	46.6625	46.6625	5884.0
2019-03-18 04:30:00	AAPL	Stock	46.635	46.66	46.635	46.66	988.0
2019-03-18 05:00:00	AAPL	Stock	46.65	46.65	46.625	46.625	5156.0
2019-03-18 05:30:00	AAPL	Stock	46.605	46.625	46.605	46.6225	5432.0
2019-03-18 06:00:00	AAPL	Stock	46.62	46.625	46.5875	46.5875	5392.0
2019-03-18 06:30:00	AAPL	Stock	46.5875	46.5875	46.525	46.525	2400.0
2019-03-18 07:00:00	AAPL	Stock	46.53	46.6025	46.475	46.575	79452.0
2019-03-18 07:30:00	AAPL	Stock	46.575	46.575	46.47	46.525	80496.0
2019-03-18 08:00:00	AAPL	Stock	46.525	46.6475	46.4675	46.505	219656.0
2019-03-18 08:30:00	AAPL	Stock	46.505	46.55	46.47	46.5	100704.0
2019-03-18 09:00:00	AAPL	Stock	46.51	46.53	46.375	46.4325	249436.0
2019-03-18 09:30:00	AAPL	Stock	46.45	46.9115	46.4475	46.8325	15060844.0
2019-03-18 10:00:00	AAPL	Stock	46.83	47.09	46.8225	47.0818	11403228.0
2019-03-18 10:30:00	AAPL	Stock	47.0812	47.0975	46.92	47.055	7130792.0
2019-03-18 11:00:00	AAPL	Stock	47.055	47.0575	46.815	46.9025	6255152.0
2019-03-18 11:30:00	AAPL	Stock	46.905	46.9112	46.795	46.8925	5731264.0
2019-03-18 12:00:00	AAPL	Stock	46.8925	46.9175	46.78	46.8175	3966508.0
2019-03-18 12:30:00	AAPL	Stock	46.82	46.9012	46.755	46.855	3666136.0
2019-03-18 13:00:00	AAPL	Stock	46.85	46.9575	46.825	46.955	3050316.0
2019-03-18 13:30:00	AAPL	Stock	46.9525	47.025	46.935	47.025	3285824.0
2019-03-18 14:00:00	AAPL	Stock	47.022	47.0552	46.95	46.9525	4170624.0
2019-03-18 14:30:00	AAPL	Stock	46.955	46.9975	46.9275	46.9908	4301956.0
2019-03-18 15:00:00	AAPL	Stock	46.9925	47.0152	46.915	46.95	4794792.0
2019-03-18 15:30:00	AAPL	Stock	46.9512	47.0625	46.9425	47.0075	7878300.0
2019-03-18 16:00:00	AAPL	Stock	46.99	47.0475	46.989	47.025	8891072.0
2019-03-18 16:30:00	AAPL	Stock	47.05	47.0975	47.005	47.0775	1143932.0
2019-03-18 17:00:00	AAPL	Stock	47.0775	47.0775	47.05	47.075	20560.0
2019-03-18 17:30:00	AAPL	Stock	47.075	47.075	47.0625	47.0628	11832.0
2019-03-18 18:00:00	AAPL	Stock	47.0725	47.0875	47.0725	47.0875	17128.0
2019-03-18 18:30:00	AAPL	Stock	47.0925	47.0925	47.07	47.0875	5388.0
2019-03-18 19:00:00	AAPL	Stock	47.0925	47.1	47.07	47.1	21304.0
2019-03-18 19:30:00	AAPL	Stock	47.0875	47.1	47.0875	47.1	50516.0
2019-03-18 04:00:00	MSFT	Stock	116.5	116.5	116.5	116.5	410.0
2019-03-18 04:30:00	MSFT	Stock	116.5	116.5	116.5	116.5	479.0
2019-03-18 05:30:00	MSFT	Stock	116.45	116.5	116.3	116.47	2100.0
2019-03-18 06:00:00	MSFT	Stock	116.27	116.27	116.21	116.21	530.0
2019-03-18 06:30:00	MSFT	Stock	116.38	116.38	116.3	116.3	300.0
2019-03-18 07:00:00	MSFT	Stock	116.35	116.45	116.25	116.32	4701.0
2019-03-18 07:30:00	MSFT	Stock	116.33	116.4	116.24	116.4	8779.0
2019-03-18 08:00:00	MSFT	Stock	116.3	116.5	116.11	116.26	24901.0
2019-03-18 08:30:00	MSFT	Stock	116.2	116.28	116.1	116.1	9617.0
2019-03-18 09:00:00	MSFT	Stock	116.18	116.18	116.0	116.11	25573.0
2019-03-18 09:30:00	MSFT	Stock	116.17	116.99	116.05	116.965	2633855.0
2019-03-18 10:00:00	MSFT	Stock	116.97	117.1	116.8	117.017	1445239.0
2019-03-18 10:30:00	MSFT	Stock	117.02	117.27	116.855	117.07	1386371.0
2019-03-18 11:00:00	MSFT	Stock	117.07	117.1	116.4	116.47	1408112.0
2019-03-18 11:30:00	MSFT	Stock	116.47	116.67	116.2	116.49	1404471.0
2019-03-18 12:00:00	MSFT	Stock	116.49	116.56	116.294	116.528	1055270.0
2019-03-18 12:30:00	MSFT	Stock	116.535	116.89	116.39	116.81	975417.0
2019-03-18 13:00:00	MSFT	Stock	116.8	116.99	116.795	116.847	816870.0

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

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