PREVIEW / stock_30min / 2019-07-11

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-07-11.parquet
  size:    1.7 MB
  rows:    84,048
  symbols: 2,591

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-07-11 04:00:00	AAPL	Stock	50.9025	50.9025	50.9025	50.9025	3784.0
2019-07-11 04:30:00	AAPL	Stock	50.96	50.96	50.925	50.925	2704.0
2019-07-11 05:00:00	AAPL	Stock	50.9375	51.0325	50.9375	51.0325	3864.0
2019-07-11 06:00:00	AAPL	Stock	51.0275	51.05	50.9875	50.9875	8068.0
2019-07-11 06:30:00	AAPL	Stock	50.975	50.9975	50.91	50.9975	9120.0
2019-07-11 07:00:00	AAPL	Stock	50.9925	51.0475	50.9925	51.005	67284.0
2019-07-11 07:30:00	AAPL	Stock	51.03	51.03	50.85	50.935	116384.0
2019-07-11 08:00:00	AAPL	Stock	50.9975	51.0425	50.9575	51.0325	88444.0
2019-07-11 08:30:00	AAPL	Stock	51.025	51.025	50.9	50.9875	129608.0
2019-07-11 09:00:00	AAPL	Stock	50.965	51.0125	50.805	50.815	229276.0
2019-07-11 09:30:00	AAPL	Stock	50.8375	51.0975	50.7752	50.995	9726972.0
2019-07-11 10:00:00	AAPL	Stock	50.9925	51.0325	50.8425	50.8775	5554496.0
2019-07-11 10:30:00	AAPL	Stock	50.875	51.0125	50.8325	50.99	4185044.0
2019-07-11 11:00:00	AAPL	Stock	50.99	51.0875	50.9775	51.02	4460128.0
2019-07-11 11:30:00	AAPL	Stock	51.0225	51.0625	50.9725	51.0325	2314752.0
2019-07-11 12:00:00	AAPL	Stock	51.035	51.0582	50.9425	50.99	2711936.0
2019-07-11 12:30:00	AAPL	Stock	50.9925	51.0025	50.92	50.935	2286592.0
2019-07-11 13:00:00	AAPL	Stock	50.9375	50.9425	50.765	50.775	3163048.0
2019-07-11 13:30:00	AAPL	Stock	50.7725	50.7925	50.6275	50.6925	3684352.0
2019-07-11 14:00:00	AAPL	Stock	50.695	50.7075	50.54	50.56	2790160.0
2019-07-11 14:30:00	AAPL	Stock	50.5625	50.645	50.55	50.6325	2578336.0
2019-07-11 15:00:00	AAPL	Stock	50.6325	50.705	50.583	50.614	2840068.0
2019-07-11 15:30:00	AAPL	Stock	50.615	50.67	50.4275	50.435	8037084.0
2019-07-11 16:00:00	AAPL	Stock	50.435	51.041	50.395	50.4275	7384904.0
2019-07-11 16:30:00	AAPL	Stock	50.445	50.46	50.4	50.4125	561908.0
2019-07-11 17:00:00	AAPL	Stock	50.4125	50.4375	50.38	50.39	26584.0
2019-07-11 17:30:00	AAPL	Stock	50.39	50.4125	50.3875	50.4	20484.0
2019-07-11 18:00:00	AAPL	Stock	50.3875	50.4175	50.3875	50.4125	6608.0
2019-07-11 18:30:00	AAPL	Stock	50.4225	50.4225	50.39	50.39	4560.0
2019-07-11 19:00:00	AAPL	Stock	50.4125	50.4125	50.38	50.3875	5132.0
2019-07-11 19:30:00	AAPL	Stock	50.3875	50.4125	50.3875	50.4125	33860.0
2019-07-11 04:00:00	MSFT	Stock	138.1	138.55	138.1	138.55	292.0
2019-07-11 05:00:00	MSFT	Stock	138.2	138.2	138.2	138.2	182.0
2019-07-11 05:30:00	MSFT	Stock	138.5	138.5	138.5	138.5	700.0
2019-07-11 06:00:00	MSFT	Stock	138.43	138.79	138.43	138.79	4420.0
2019-07-11 07:00:00	MSFT	Stock	138.5	138.6	138.25	138.4	10245.0
2019-07-11 07:30:00	MSFT	Stock	138.38	138.43	138.32	138.43	3493.0
2019-07-11 08:00:00	MSFT	Stock	138.4	138.61	138.19	138.5	22329.0
2019-07-11 08:30:00	MSFT	Stock	138.41	138.5	138.05	138.3	25675.0
2019-07-11 09:00:00	MSFT	Stock	138.27	138.55	138.06	138.21	40366.0
2019-07-11 09:30:00	MSFT	Stock	138.21	138.78	138.06	138.65	2897610.0
2019-07-11 10:00:00	MSFT	Stock	138.655	138.75	138.29	138.61	1515087.0
2019-07-11 10:30:00	MSFT	Stock	138.62	138.75	138.34	138.72	1065227.0
2019-07-11 11:00:00	MSFT	Stock	138.72	139.19	138.69	139.17	1392245.0
2019-07-11 11:30:00	MSFT	Stock	139.16	139.22	138.97	139.085	984564.0
2019-07-11 12:00:00	MSFT	Stock	139.083	139.13	138.83	138.985	915304.0
2019-07-11 12:30:00	MSFT	Stock	138.98	139.005	138.875	138.97	721195.0
2019-07-11 13:00:00	MSFT	Stock	138.97	139.0	138.54	138.553	801136.0
2019-07-11 13:30:00	MSFT	Stock	138.555	138.63	138.16	138.247	1184859.0
2019-07-11 14:00:00	MSFT	Stock	138.25	138.3	138.01	138.053	884876.0

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

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