PREVIEW / stock_30min / 2018-10-30

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-10-30.parquet
  size:    1.7 MB
  rows:    83,811
  symbols: 2,760

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
2018-10-30 04:00:00	AAPL	Stock	53.2775	53.6925	53.2775	53.625	19832.0
2018-10-30 04:30:00	AAPL	Stock	53.65	53.65	53.45	53.45	24160.0
2018-10-30 05:00:00	AAPL	Stock	53.375	53.375	53.1	53.17	20128.0
2018-10-30 05:30:00	AAPL	Stock	53.1325	53.2325	53.0625	53.2325	57376.0
2018-10-30 06:00:00	AAPL	Stock	53.2075	53.375	53.205	53.325	22216.0
2018-10-30 06:30:00	AAPL	Stock	53.3725	53.3725	53.2025	53.22	12316.0
2018-10-30 07:00:00	AAPL	Stock	53.22	53.3275	53.0725	53.2575	168800.0
2018-10-30 07:30:00	AAPL	Stock	53.295	53.4	53.205	53.3	172916.0
2018-10-30 08:00:00	AAPL	Stock	53.3125	53.4625	53.06	53.2975	429984.0
2018-10-30 08:30:00	AAPL	Stock	53.27	53.325	52.8	52.875	713680.0
2018-10-30 09:00:00	AAPL	Stock	52.8875	52.89	52.3975	52.79	817296.0
2018-10-30 09:30:00	AAPL	Stock	52.7875	53.795	52.3175	53.7125	21499344.0
2018-10-30 10:00:00	AAPL	Stock	53.7125	53.7425	53.1375	53.3725	10912156.0
2018-10-30 10:30:00	AAPL	Stock	53.3725	53.575	52.8325	53.0212	10143356.0
2018-10-30 11:00:00	AAPL	Stock	53.0312	53.505	52.937	53.455	7381740.0
2018-10-30 11:30:00	AAPL	Stock	53.455	53.625	53.1825	53.2175	6465776.0
2018-10-30 12:00:00	AAPL	Stock	53.2275	53.4022	53.0625	53.3325	4665496.0
2018-10-30 12:30:00	AAPL	Stock	53.3325	53.515	53.07	53.1115	4140616.0
2018-10-30 13:00:00	AAPL	Stock	53.1075	53.195	52.73	52.9175	6123656.0
2018-10-30 13:30:00	AAPL	Stock	52.905	53.265	52.7125	53.2368	6110204.0
2018-10-30 14:00:00	AAPL	Stock	53.2328	53.33	52.8775	52.984	4807116.0
2018-10-30 14:30:00	AAPL	Stock	52.995	53.3375	52.8638	53.24	5063564.0
2018-10-30 15:00:00	AAPL	Stock	53.2475	53.3975	53.025	53.1725	7009164.0
2018-10-30 15:30:00	AAPL	Stock	53.1725	53.4325	53.0775	53.3325	12043368.0
2018-10-30 16:00:00	AAPL	Stock	53.3325	53.5	53.125	53.5	13755328.0
2018-10-30 16:30:00	AAPL	Stock	53.5	53.625	53.4775	53.6	242960.0
2018-10-30 17:00:00	AAPL	Stock	53.5975	53.5975	53.25	53.34	358104.0
2018-10-30 17:30:00	AAPL	Stock	53.3	53.7	53.275	53.675	278596.0
2018-10-30 18:00:00	AAPL	Stock	53.675	53.7	53.575	53.605	134260.0
2018-10-30 18:30:00	AAPL	Stock	53.625	53.64	53.5925	53.595	48804.0
2018-10-30 19:00:00	AAPL	Stock	53.5875	53.625	53.545	53.6225	42568.0
2018-10-30 19:30:00	AAPL	Stock	53.6075	53.7375	53.6075	53.725	45172.0
2018-10-30 04:30:00	MSFT	Stock	104.5	104.5	104.5	104.5	1200.0
2018-10-30 05:00:00	MSFT	Stock	104.5	104.5	103.96	104.0	2177.0
2018-10-30 05:30:00	MSFT	Stock	103.83	104.34	103.83	104.34	602.0
2018-10-30 06:00:00	MSFT	Stock	104.1	104.29	104.06	104.29	1190.0
2018-10-30 06:30:00	MSFT	Stock	104.29	104.29	104.05	104.2	2600.0
2018-10-30 07:00:00	MSFT	Stock	104.05	104.38	103.85	104.34	27656.0
2018-10-30 07:30:00	MSFT	Stock	104.34	104.57	104.25	104.5	13646.0
2018-10-30 08:00:00	MSFT	Stock	104.3	104.88	103.8	104.71	133869.0
2018-10-30 08:30:00	MSFT	Stock	104.59	104.71	103.65	103.8	50751.0
2018-10-30 09:00:00	MSFT	Stock	103.93	103.96	102.68	103.63	81703.0
2018-10-30 09:30:00	MSFT	Stock	103.66	104.38	102.61	104.02	5485181.0
2018-10-30 10:00:00	MSFT	Stock	104.025	104.21	102.8	103.31	4578841.0
2018-10-30 10:30:00	MSFT	Stock	103.32	103.85	101.65	102.31	5160248.0
2018-10-30 11:00:00	MSFT	Stock	102.33	102.84	101.67	102.55	4081553.0
2018-10-30 11:30:00	MSFT	Stock	102.54	103.33	102.31	102.39	3408239.0
2018-10-30 12:00:00	MSFT	Stock	102.4	102.65	102.01	102.255	2699217.0
2018-10-30 12:30:00	MSFT	Stock	102.25	102.31	101.13	101.2	2876715.0
2018-10-30 13:00:00	MSFT	Stock	101.2	101.21	100.11	100.82	5848939.0

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

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