PREVIEW / stock_30min / 2020-03-12

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-03-12.parquet
  size:    2.0 MB
  rows:    100,849
  symbols: 2,488

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
2020-03-12 04:00:00	AAPL	Stock	65.95	66.185	65.525	65.555	173496.0
2020-03-12 04:30:00	AAPL	Stock	65.57	65.71	65.0575	65.275	97240.0
2020-03-12 05:00:00	AAPL	Stock	65.275	65.275	64.9475	64.97	68324.0
2020-03-12 05:30:00	AAPL	Stock	64.95	65.355	64.8775	65.125	105116.0
2020-03-12 06:00:00	AAPL	Stock	65.0675	65.3375	64.9975	65.3375	83056.0
2020-03-12 06:30:00	AAPL	Stock	65.215	65.375	65.1375	65.375	32588.0
2020-03-12 07:00:00	AAPL	Stock	65.4025	65.7475	64.625	64.645	672220.0
2020-03-12 07:30:00	AAPL	Stock	64.6675	64.815	64.275	64.325	535508.0
2020-03-12 08:00:00	AAPL	Stock	64.35	65.4338	63.75	64.0	1245852.0
2020-03-12 08:30:00	AAPL	Stock	63.975	64.3875	63.75	64.02	892988.0
2020-03-12 09:00:00	AAPL	Stock	64.1	64.2098	63.3875	63.9975	1637328.0
2020-03-12 09:30:00	AAPL	Stock	64.01	64.71	62.595	64.6825	38828092.0
2020-03-12 10:00:00	AAPL	Stock	64.6775	65.5	63.3775	64.9375	32114212.0
2020-03-12 10:30:00	AAPL	Stock	64.9488	65.6	64.5675	64.85	21181708.0
2020-03-12 11:00:00	AAPL	Stock	64.855	64.8675	63.66	63.723	17416172.0
2020-03-12 11:30:00	AAPL	Stock	63.7262	64.07	62.75	63.1562	18516776.0
2020-03-12 12:00:00	AAPL	Stock	63.15	63.41	62.3825	63.075	22208060.0
2020-03-12 12:30:00	AAPL	Stock	63.08	65.03	62.7	64.475	22062228.0
2020-03-12 13:00:00	AAPL	Stock	64.482	67.5	63.875	65.555	32934364.0
2020-03-12 13:30:00	AAPL	Stock	65.545	65.97	63.7625	64.8225	17515376.0
2020-03-12 14:00:00	AAPL	Stock	64.815	64.9625	63.1925	63.5525	17393424.0
2020-03-12 14:30:00	AAPL	Stock	63.56	64.5325	63.3068	63.43	17533424.0
2020-03-12 15:00:00	AAPL	Stock	63.435	63.9798	62.945	63.015	20130904.0
2020-03-12 15:30:00	AAPL	Stock	63.015	64.5125	62.0	62.0	34353296.0
2020-03-12 16:00:00	AAPL	Stock	62.0	62.8562	61.5575	61.7975	22526088.0
2020-03-12 16:30:00	AAPL	Stock	61.85	62.0625	60.825	60.875	714156.0
2020-03-12 17:00:00	AAPL	Stock	60.875	60.9275	59.5825	59.655	702160.0
2020-03-12 17:30:00	AAPL	Stock	59.625	60.1925	59.45	59.9575	866332.0
2020-03-12 18:00:00	AAPL	Stock	60.0	60.9875	59.6	60.08	672144.0
2020-03-12 18:30:00	AAPL	Stock	60.17	60.875	60.0625	60.585	514148.0
2020-03-12 19:00:00	AAPL	Stock	60.5025	60.65	60.1025	60.14	251624.0
2020-03-12 19:30:00	AAPL	Stock	60.2425	60.25	58.8775	59.1625	457120.0
2020-03-12 04:00:00	MSFT	Stock	147.88	148.45	147.0	147.02	39140.0
2020-03-12 04:30:00	MSFT	Stock	146.95	147.18	146.1	146.5	32733.0
2020-03-12 05:00:00	MSFT	Stock	146.54	146.55	146.0	146.0	21452.0
2020-03-12 05:30:00	MSFT	Stock	146.1	146.8	146.0	146.06	14552.0
2020-03-12 06:00:00	MSFT	Stock	146.1	146.4	145.8	146.1	18053.0
2020-03-12 06:30:00	MSFT	Stock	146.14	146.81	146.1	146.6	22746.0
2020-03-12 07:00:00	MSFT	Stock	146.51	147.4	145.62	145.65	170418.0
2020-03-12 07:30:00	MSFT	Stock	145.8	146.5	145.12	145.12	101015.0
2020-03-12 08:00:00	MSFT	Stock	147.0	147.2	143.5	143.99	234808.0
2020-03-12 08:30:00	MSFT	Stock	144.2	145.5	144.0	145.5	207563.0
2020-03-12 09:00:00	MSFT	Stock	145.5	146.32	143.63	145.59	304939.0
2020-03-12 09:30:00	MSFT	Stock	145.85	149.93	141.59	147.26	9196017.0
2020-03-12 10:00:00	MSFT	Stock	147.25	147.3	143.53	145.36	7274386.0
2020-03-12 10:30:00	MSFT	Stock	145.42	147.51	144.57	146.52	4797910.0
2020-03-12 11:00:00	MSFT	Stock	146.555	146.6	143.11	143.236	4104313.0
2020-03-12 11:30:00	MSFT	Stock	143.23	143.81	141.74	143.23	4060150.0
2020-03-12 12:00:00	MSFT	Stock	143.2	144.79	141.07	143.71	4132047.0
2020-03-12 12:30:00	MSFT	Stock	143.71	149.93	143.0	148.06	4334222.0

> showing 50 of 100,849 rows — these rows as CSV

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