PREVIEW / stock_30min / 2018-08-30

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-08-30.parquet
  size:    1.7 MB
  rows:    82,292
  symbols: 2,780

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-08-30 04:00:00	AAPL	Stock	56.0	56.0	55.7825	55.8125	17340.0
2018-08-30 04:30:00	AAPL	Stock	55.775	55.775	55.7125	55.75	20040.0
2018-08-30 05:00:00	AAPL	Stock	55.75	55.7625	55.7475	55.75	6388.0
2018-08-30 05:30:00	AAPL	Stock	55.7625	55.7625	55.73	55.73	2400.0
2018-08-30 06:00:00	AAPL	Stock	55.75	55.75	55.68	55.6825	17808.0
2018-08-30 06:30:00	AAPL	Stock	55.7	55.8125	55.685	55.77	23232.0
2018-08-30 07:00:00	AAPL	Stock	55.78	55.81	55.5525	55.775	82244.0
2018-08-30 07:30:00	AAPL	Stock	55.775	55.85	55.775	55.825	54252.0
2018-08-30 08:00:00	AAPL	Stock	55.7575	55.965	55.6625	55.91	276148.0
2018-08-30 08:30:00	AAPL	Stock	55.91	55.9625	55.8525	55.8575	204972.0
2018-08-30 09:00:00	AAPL	Stock	55.8575	55.89	55.8075	55.815	247104.0
2018-08-30 09:30:00	AAPL	Stock	55.8125	56.1425	55.635	55.6625	19735564.0
2018-08-30 10:00:00	AAPL	Stock	55.66	55.89	55.6	55.7325	9051804.0
2018-08-30 10:30:00	AAPL	Stock	55.7325	55.9725	55.6675	55.8575	7606068.0
2018-08-30 11:00:00	AAPL	Stock	55.855	56.12	55.8275	55.9625	8787768.0
2018-08-30 11:30:00	AAPL	Stock	55.96	56.16	55.96	56.125	5951084.0
2018-08-30 12:00:00	AAPL	Stock	56.1275	56.375	56.07	56.359	12539516.0
2018-08-30 12:30:00	AAPL	Stock	56.358	56.6575	56.3425	56.5825	11482944.0
2018-08-30 13:00:00	AAPL	Stock	56.5775	56.97	56.5725	56.9225	14256708.0
2018-08-30 13:30:00	AAPL	Stock	56.92	57.0	56.815	56.9425	10760196.0
2018-08-30 14:00:00	AAPL	Stock	56.9425	57.065	56.4102	56.525	18067488.0
2018-08-30 14:30:00	AAPL	Stock	56.525	56.71	56.2775	56.2775	11772304.0
2018-08-30 15:00:00	AAPL	Stock	56.28	56.3525	55.955	56.3425	17520972.0
2018-08-30 15:30:00	AAPL	Stock	56.34	56.3725	56.1525	56.2675	13679156.0
2018-08-30 16:00:00	AAPL	Stock	56.265	56.3465	56.2525	56.2875	6162664.0
2018-08-30 16:30:00	AAPL	Stock	56.285	56.295	56.2575	56.275	248360.0
2018-08-30 17:00:00	AAPL	Stock	56.275	56.31	56.2625	56.2925	53932.0
2018-08-30 17:30:00	AAPL	Stock	56.3025	56.3025	56.2625	56.2775	24748.0
2018-08-30 18:00:00	AAPL	Stock	56.29	56.3125	56.2125	56.2125	114308.0
2018-08-30 18:30:00	AAPL	Stock	56.22	56.2875	56.205	56.275	71952.0
2018-08-30 19:00:00	AAPL	Stock	56.2625	56.2825	56.2625	56.2825	42032.0
2018-08-30 19:30:00	AAPL	Stock	56.2875	56.2875	56.25	56.25	55804.0
2018-08-30 04:30:00	MSFT	Stock	111.89	111.89	111.82	111.87	1245.0
2018-08-30 05:30:00	MSFT	Stock	111.73	111.73	111.73	111.73	239.0
2018-08-30 06:00:00	MSFT	Stock	111.7	111.85	111.7	111.85	580.0
2018-08-30 07:00:00	MSFT	Stock	111.85	111.95	111.75	111.94	5756.0
2018-08-30 07:30:00	MSFT	Stock	111.93	111.93	111.93	111.93	100.0
2018-08-30 08:00:00	MSFT	Stock	111.8	111.94	111.75	111.819	1283.0
2018-08-30 08:30:00	MSFT	Stock	111.86	111.94	111.804	111.93	2884.0
2018-08-30 09:00:00	MSFT	Stock	111.9	111.93	111.6	111.7	24592.0
2018-08-30 09:30:00	MSFT	Stock	111.66	112.02	111.545	111.725	2438940.0
2018-08-30 10:00:00	MSFT	Stock	111.725	112.285	111.71	112.13	1811561.0
2018-08-30 10:30:00	MSFT	Stock	112.12	112.5	111.97	112.415	1519186.0
2018-08-30 11:00:00	MSFT	Stock	112.42	112.515	112.17	112.25	1422450.0
2018-08-30 11:30:00	MSFT	Stock	112.26	112.46	112.195	112.42	939579.0
2018-08-30 12:00:00	MSFT	Stock	112.42	112.5	112.36	112.42	797749.0
2018-08-30 12:30:00	MSFT	Stock	112.43	112.57	112.375	112.485	642869.0
2018-08-30 13:00:00	MSFT	Stock	112.486	112.61	112.45	112.535	648052.0
2018-08-30 13:30:00	MSFT	Stock	112.535	112.6	112.25	112.288	656447.0
2018-08-30 14:00:00	MSFT	Stock	112.287	112.36	111.72	111.75	1899544.0

> showing 50 of 82,292 rows — these rows as CSV

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