PREVIEW / stock_30min / 2018-05-03

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-05-03.parquet
  size:    1.7 MB
  rows:    82,922
  symbols: 2,826

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-05-03 04:00:00	AAPL	Stock	44.06	44.0875	44.0	44.0625	25992.0
2018-05-03 04:30:00	AAPL	Stock	44.0125	44.0125	44.0	44.01	8860.0
2018-05-03 05:00:00	AAPL	Stock	44.01	44.06	43.94	44.06	19352.0
2018-05-03 05:30:00	AAPL	Stock	44.0	44.0	44.0	44.0	11272.0
2018-05-03 06:00:00	AAPL	Stock	44.02	44.075	44.0	44.075	16472.0
2018-05-03 06:30:00	AAPL	Stock	44.075	44.0925	44.0525	44.0525	13652.0
2018-05-03 07:00:00	AAPL	Stock	44.0725	44.1125	44.0075	44.05	144152.0
2018-05-03 07:30:00	AAPL	Stock	44.0525	44.0875	43.925	43.9375	175992.0
2018-05-03 08:00:00	AAPL	Stock	44.0625	44.125	43.9	43.9462	294908.0
2018-05-03 08:30:00	AAPL	Stock	43.9375	44.0275	43.9275	43.95	216376.0
2018-05-03 09:00:00	AAPL	Stock	43.95	44.0	43.9	43.945	239188.0
2018-05-03 09:30:00	AAPL	Stock	43.97	44.1875	43.7025	44.175	21707400.0
2018-05-03 10:00:00	AAPL	Stock	44.1625	44.18	43.82	43.95	10835140.0
2018-05-03 10:30:00	AAPL	Stock	43.9475	43.9652	43.6102	43.6987	11648608.0
2018-05-03 11:00:00	AAPL	Stock	43.7	43.85	43.6325	43.7592	7222608.0
2018-05-03 11:30:00	AAPL	Stock	43.765	43.9325	43.6225	43.8752	6749536.0
2018-05-03 12:00:00	AAPL	Stock	43.88	43.905	43.74	43.7725	4643988.0
2018-05-03 12:30:00	AAPL	Stock	43.775	44.2225	43.77	44.215	7814336.0
2018-05-03 13:00:00	AAPL	Stock	44.21	44.285	44.1075	44.195	7225336.0
2018-05-03 13:30:00	AAPL	Stock	44.195	44.335	44.18	44.235	6686196.0
2018-05-03 14:00:00	AAPL	Stock	44.2375	44.295	44.15	44.1975	4039024.0
2018-05-03 14:30:00	AAPL	Stock	44.1975	44.375	44.175	44.2175	7583460.0
2018-05-03 15:00:00	AAPL	Stock	44.2258	44.3	44.2075	44.2575	6469140.0
2018-05-03 15:30:00	AAPL	Stock	44.255	44.2825	44.12	44.2225	10418536.0
2018-05-03 16:00:00	AAPL	Stock	44.2225	44.325	44.0372	44.2525	7203840.0
2018-05-03 16:30:00	AAPL	Stock	44.26	44.27	44.2225	44.27	231100.0
2018-05-03 17:00:00	AAPL	Stock	44.24	44.245	44.24	44.24	15060.0
2018-05-03 17:30:00	AAPL	Stock	44.245	44.2675	44.24	44.25	13920.0
2018-05-03 18:00:00	AAPL	Stock	44.2575	44.31	44.2575	44.31	25040.0
2018-05-03 18:30:00	AAPL	Stock	44.3125	44.3125	44.2875	44.31	11220.0
2018-05-03 19:00:00	AAPL	Stock	44.2875	44.3	44.2575	44.275	6944.0
2018-05-03 19:30:00	AAPL	Stock	44.2375	44.25	44.2	44.25	66836.0
2018-05-03 07:00:00	MSFT	Stock	93.78	93.78	93.4	93.55	5236.0
2018-05-03 07:30:00	MSFT	Stock	93.55	93.64	93.1	93.15	8755.0
2018-05-03 08:00:00	MSFT	Stock	93.64	93.64	92.9	93.25	12155.0
2018-05-03 08:30:00	MSFT	Stock	93.17	93.4	93.1	93.16	11854.0
2018-05-03 09:00:00	MSFT	Stock	93.2	93.33	92.98	92.98	16158.0
2018-05-03 09:30:00	MSFT	Stock	92.97	94.05	92.7	94.01	2894283.0
2018-05-03 10:00:00	MSFT	Stock	94.01	94.04	92.922	93.2	2040208.0
2018-05-03 10:30:00	MSFT	Stock	93.205	93.23	92.45	92.675	2306676.0
2018-05-03 11:00:00	MSFT	Stock	92.67	93.11	92.49	92.68	1579766.0
2018-05-03 11:30:00	MSFT	Stock	92.685	93.38	92.59	93.21	1518480.0
2018-05-03 12:00:00	MSFT	Stock	93.21	93.32	92.83	92.88	1001302.0
2018-05-03 12:30:00	MSFT	Stock	92.87	94.23	92.86	94.15	2036341.0
2018-05-03 13:00:00	MSFT	Stock	94.15	94.21	93.69	93.831	1335361.0
2018-05-03 13:30:00	MSFT	Stock	93.84	94.38	93.82	94.18	1714868.0
2018-05-03 14:00:00	MSFT	Stock	94.17	94.39	94.04	94.295	1256633.0
2018-05-03 14:30:00	MSFT	Stock	94.29	94.925	94.23	94.37	1934255.0
2018-05-03 15:00:00	MSFT	Stock	94.375	94.61	94.28	94.58	1450136.0
2018-05-03 15:30:00	MSFT	Stock	94.59	94.74	93.83	94.09	2986098.0

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

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