PREVIEW / stock_30min / 2019-09-16

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-09-16.parquet
  size:    1.7 MB
  rows:    87,002
  symbols: 2,559

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-09-16 04:00:00	AAPL	Stock	54.3725	54.3725	54.0775	54.1125	51392.0
2019-09-16 04:30:00	AAPL	Stock	54.1375	54.1625	54.075	54.125	26648.0
2019-09-16 05:00:00	AAPL	Stock	54.1275	54.21	54.1	54.15	82192.0
2019-09-16 05:30:00	AAPL	Stock	54.1275	54.1525	54.0925	54.15	16400.0
2019-09-16 06:00:00	AAPL	Stock	54.175	54.31	54.1625	54.31	20820.0
2019-09-16 06:30:00	AAPL	Stock	54.295	54.3125	54.2125	54.3125	9716.0
2019-09-16 07:00:00	AAPL	Stock	54.255	54.355	54.15	54.35	136272.0
2019-09-16 07:30:00	AAPL	Stock	54.345	54.45	54.325	54.4475	112568.0
2019-09-16 08:00:00	AAPL	Stock	54.2005	54.5275	54.15	54.45	251264.0
2019-09-16 08:30:00	AAPL	Stock	54.45	54.48	54.375	54.4375	148700.0
2019-09-16 09:00:00	AAPL	Stock	54.4375	54.45	54.34	54.42	152764.0
2019-09-16 09:30:00	AAPL	Stock	54.435	54.963	54.39	54.92	12926248.0
2019-09-16 10:00:00	AAPL	Stock	54.928	54.9325	54.5862	54.5975	6419460.0
2019-09-16 10:30:00	AAPL	Stock	54.6	54.7525	54.5475	54.7312	4531028.0
2019-09-16 11:00:00	AAPL	Stock	54.735	55.0238	54.72	54.9765	6270460.0
2019-09-16 11:30:00	AAPL	Stock	54.975	55.0325	54.725	54.7625	5930088.0
2019-09-16 12:00:00	AAPL	Stock	54.76	54.85	54.745	54.8285	2593660.0
2019-09-16 12:30:00	AAPL	Stock	54.8275	54.8675	54.7275	54.7875	2358212.0
2019-09-16 13:00:00	AAPL	Stock	54.785	54.8682	54.755	54.86	1955848.0
2019-09-16 13:30:00	AAPL	Stock	54.8608	55.0225	54.86	55.0025	2782848.0
2019-09-16 14:00:00	AAPL	Stock	55.0025	55.025	54.8975	54.955	3185452.0
2019-09-16 14:30:00	AAPL	Stock	54.955	54.9975	54.89	54.94	2445392.0
2019-09-16 15:00:00	AAPL	Stock	54.935	54.9875	54.892	54.92	3423824.0
2019-09-16 15:30:00	AAPL	Stock	54.9175	55.0175	54.885	54.975	5026228.0
2019-09-16 16:00:00	AAPL	Stock	54.975	55.025	54.975	55.0	6348236.0
2019-09-16 16:30:00	AAPL	Stock	54.9875	55.025	54.975	55.0225	61452.0
2019-09-16 17:00:00	AAPL	Stock	55.0225	55.025	55.005	55.02	16928.0
2019-09-16 17:30:00	AAPL	Stock	55.0075	55.025	54.9775	54.9775	19368.0
2019-09-16 18:00:00	AAPL	Stock	55.02	55.0375	55.0175	55.02	24632.0
2019-09-16 18:30:00	AAPL	Stock	55.02	55.095	55.02	55.0575	22272.0
2019-09-16 19:00:00	AAPL	Stock	55.0625	55.0625	55.0175	55.0625	26484.0
2019-09-16 19:30:00	AAPL	Stock	55.0625	55.0725	55.025	55.0725	29908.0
2019-09-16 04:30:00	MSFT	Stock	136.33	136.33	136.01	136.24	978.0
2019-09-16 05:00:00	MSFT	Stock	136.62	136.62	136.34	136.34	1990.0
2019-09-16 05:30:00	MSFT	Stock	136.41	136.41	136.41	136.41	100.0
2019-09-16 06:00:00	MSFT	Stock	136.46	136.46	136.46	136.46	100.0
2019-09-16 06:30:00	MSFT	Stock	136.4	136.42	136.4	136.42	1180.0
2019-09-16 07:00:00	MSFT	Stock	136.35	136.42	136.05	136.35	5249.0
2019-09-16 07:30:00	MSFT	Stock	136.25	136.25	136.12	136.2	3955.0
2019-09-16 08:00:00	MSFT	Stock	136.35	136.5	136.1	136.3	11600.0
2019-09-16 08:30:00	MSFT	Stock	136.35	136.5	136.15	136.3	15329.0
2019-09-16 09:00:00	MSFT	Stock	136.3	136.33	135.67	135.86	56176.0
2019-09-16 09:30:00	MSFT	Stock	135.82	136.54	135.66	136.45	1923825.0
2019-09-16 10:00:00	MSFT	Stock	136.47	136.668	136.25	136.31	935683.0
2019-09-16 10:30:00	MSFT	Stock	136.305	136.44	136.13	136.23	668650.0
2019-09-16 11:00:00	MSFT	Stock	136.24	136.7	136.09	136.57	585956.0
2019-09-16 11:30:00	MSFT	Stock	136.56	136.61	136.08	136.21	530514.0
2019-09-16 12:00:00	MSFT	Stock	136.19	136.55	136.19	136.485	393734.0
2019-09-16 12:30:00	MSFT	Stock	136.488	136.53	136.17	136.236	444884.0
2019-09-16 13:00:00	MSFT	Stock	136.23	136.39	136.16	136.35	207527.0

> showing 50 of 87,002 rows — these rows as CSV

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