PREVIEW / stock_30min / 2019-07-19

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-07-19.parquet
  size:    1.7 MB
  rows:    83,808
  symbols: 2,577

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-19 04:00:00	AAPL	Stock	51.5875	51.675	51.5875	51.59	10352.0
2019-07-19 04:30:00	AAPL	Stock	51.5325	51.5325	51.5325	51.5325	1304.0
2019-07-19 05:00:00	AAPL	Stock	51.525	51.5725	51.525	51.5725	8200.0
2019-07-19 05:30:00	AAPL	Stock	51.5375	51.575	51.505	51.505	23856.0
2019-07-19 06:00:00	AAPL	Stock	51.4975	51.4975	51.475	51.475	800.0
2019-07-19 06:30:00	AAPL	Stock	51.4775	51.4875	51.3	51.39	19996.0
2019-07-19 07:00:00	AAPL	Stock	51.4625	51.48	51.39	51.41	67992.0
2019-07-19 07:30:00	AAPL	Stock	51.39	51.4625	51.39	51.4	39768.0
2019-07-19 08:00:00	AAPL	Stock	51.4275	51.485	51.39	51.4625	102608.0
2019-07-19 08:30:00	AAPL	Stock	51.4625	51.5175	51.4375	51.5175	92460.0
2019-07-19 09:00:00	AAPL	Stock	51.4975	51.645	51.43	51.4425	201288.0
2019-07-19 09:30:00	AAPL	Stock	51.445	51.625	51.1725	51.2775	12318772.0
2019-07-19 10:00:00	AAPL	Stock	51.2788	51.395	51.1775	51.3775	4961820.0
2019-07-19 10:30:00	AAPL	Stock	51.3775	51.39	51.1575	51.24	4002164.0
2019-07-19 11:00:00	AAPL	Stock	51.245	51.33	51.2075	51.25	3295156.0
2019-07-19 11:30:00	AAPL	Stock	51.2512	51.2762	51.0675	51.1425	3963308.0
2019-07-19 12:00:00	AAPL	Stock	51.14	51.2725	51.1325	51.265	2496636.0
2019-07-19 12:30:00	AAPL	Stock	51.2632	51.2875	51.2225	51.2463	1882240.0
2019-07-19 13:00:00	AAPL	Stock	51.2475	51.25	51.14	51.2425	2134768.0
2019-07-19 13:30:00	AAPL	Stock	51.2425	51.2425	51.14	51.207	2071976.0
2019-07-19 14:00:00	AAPL	Stock	51.2078	51.245	50.9625	50.9625	3737360.0
2019-07-19 14:30:00	AAPL	Stock	50.9675	51.025	50.86	50.935	3074084.0
2019-07-19 15:00:00	AAPL	Stock	50.9325	50.9325	50.6675	50.775	4867196.0
2019-07-19 15:30:00	AAPL	Stock	50.775	50.825	50.59	50.6425	8703112.0
2019-07-19 16:00:00	AAPL	Stock	50.6475	50.6475	50.5875	50.63	5970516.0
2019-07-19 16:30:00	AAPL	Stock	50.6475	50.6475	50.5925	50.6175	303348.0
2019-07-19 17:00:00	AAPL	Stock	50.6175	50.6175	50.5625	50.6125	153600.0
2019-07-19 17:30:00	AAPL	Stock	50.6075	50.625	50.6	50.6	39440.0
2019-07-19 18:00:00	AAPL	Stock	50.6	50.64	50.59	50.64	18848.0
2019-07-19 18:30:00	AAPL	Stock	50.605	50.62	50.605	50.61	9276.0
2019-07-19 19:00:00	AAPL	Stock	50.61	50.625	50.605	50.605	12240.0
2019-07-19 19:30:00	AAPL	Stock	50.605	50.625	50.5775	50.6	31836.0
2019-07-19 04:00:00	MSFT	Stock	140.26	140.98	140.2	140.96	10329.0
2019-07-19 04:30:00	MSFT	Stock	140.82	141.15	140.62	141.05	10762.0
2019-07-19 05:00:00	MSFT	Stock	141.08	141.37	141.0	141.37	6500.0
2019-07-19 05:30:00	MSFT	Stock	141.26	141.4	141.25	141.39	3325.0
2019-07-19 06:00:00	MSFT	Stock	141.25	141.3	141.01	141.25	14849.0
2019-07-19 06:30:00	MSFT	Stock	141.1	141.23	141.0	141.07	25749.0
2019-07-19 07:00:00	MSFT	Stock	141.1	141.1	140.23	140.39	140838.0
2019-07-19 07:30:00	MSFT	Stock	140.5	140.87	140.29	140.85	39489.0
2019-07-19 08:00:00	MSFT	Stock	140.95	141.1	139.64	140.27	371517.0
2019-07-19 08:30:00	MSFT	Stock	140.35	140.36	140.0	140.34	214531.0
2019-07-19 09:00:00	MSFT	Stock	140.26	141.0	140.0	140.22	463541.0
2019-07-19 09:30:00	MSFT	Stock	140.21	140.67	138.88	139.335	9613204.0
2019-07-19 10:00:00	MSFT	Stock	139.33	139.67	138.65	138.852	3774877.0
2019-07-19 10:30:00	MSFT	Stock	138.87	139.05	138.46	138.63	2179586.0
2019-07-19 11:00:00	MSFT	Stock	138.63	139.2	138.57	138.85	2160203.0
2019-07-19 11:30:00	MSFT	Stock	138.855	139.03	138.04	138.25	2144645.0
2019-07-19 12:00:00	MSFT	Stock	138.26	138.44	138.12	138.32	1317815.0
2019-07-19 12:30:00	MSFT	Stock	138.325	138.77	138.3	138.635	1431512.0

> showing 50 of 83,808 rows — these rows as CSV

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