PREVIEW / stock_30min / 2019-01-10

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-01-10.parquet
  size:    1.7 MB
  rows:    83,416
  symbols: 2,691

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-01-10 04:00:00	AAPL	Stock	37.95	37.98	37.9	37.98	11296.0
2019-01-10 04:30:00	AAPL	Stock	37.9925	38.025	37.9925	38.005	12200.0
2019-01-10 05:00:00	AAPL	Stock	37.975	38.0675	37.975	38.0675	6936.0
2019-01-10 05:30:00	AAPL	Stock	38.05	38.06	38.0125	38.03	3072.0
2019-01-10 06:00:00	AAPL	Stock	38.0375	38.0375	38.0375	38.0375	2000.0
2019-01-10 06:30:00	AAPL	Stock	38.0375	38.0375	38.0	38.0	11756.0
2019-01-10 07:00:00	AAPL	Stock	38.0125	38.075	38.0	38.03	66568.0
2019-01-10 07:30:00	AAPL	Stock	38.045	38.08	37.965	38.075	56384.0
2019-01-10 08:00:00	AAPL	Stock	38.05	38.1225	37.9575	38.0625	120312.0
2019-01-10 08:30:00	AAPL	Stock	38.055	38.1125	38.0125	38.0675	97156.0
2019-01-10 09:00:00	AAPL	Stock	38.05	38.12	38.0025	38.115	117340.0
2019-01-10 09:30:00	AAPL	Stock	38.125	38.1975	37.715	37.83	18389676.0
2019-01-10 10:00:00	AAPL	Stock	37.8325	38.1075	37.775	38.014	10784156.0
2019-01-10 10:30:00	AAPL	Stock	38.015	38.175	37.9075	38.13	7951368.0
2019-01-10 11:00:00	AAPL	Stock	38.1342	38.155	37.995	38.045	7571896.0
2019-01-10 11:30:00	AAPL	Stock	38.0475	38.265	38.0475	38.25	5645128.0
2019-01-10 12:00:00	AAPL	Stock	38.2472	38.3125	38.1675	38.2712	5101840.0
2019-01-10 12:30:00	AAPL	Stock	38.275	38.4125	38.2025	38.36	5875844.0
2019-01-10 13:00:00	AAPL	Stock	38.36	38.3625	38.0775	38.205	6339044.0
2019-01-10 13:30:00	AAPL	Stock	38.2	38.2375	38.0875	38.1875	4977980.0
2019-01-10 14:00:00	AAPL	Stock	38.1875	38.3865	38.184	38.2675	5862336.0
2019-01-10 14:30:00	AAPL	Stock	38.27	38.32	38.19	38.2975	5136540.0
2019-01-10 15:00:00	AAPL	Stock	38.295	38.4025	38.25	38.3875	6426196.0
2019-01-10 15:30:00	AAPL	Stock	38.385	38.4925	38.315	38.45	12439140.0
2019-01-10 16:00:00	AAPL	Stock	38.45	38.475	38.4275	38.4475	11132336.0
2019-01-10 16:30:00	AAPL	Stock	38.4475	38.4675	38.4425	38.45	45032.0
2019-01-10 17:00:00	AAPL	Stock	38.45	38.4625	38.45	38.45	21284.0
2019-01-10 17:30:00	AAPL	Stock	38.45	38.4625	38.45	38.4625	800.0
2019-01-10 18:00:00	AAPL	Stock	38.44	38.45	38.425	38.44	48256.0
2019-01-10 18:30:00	AAPL	Stock	38.4375	38.525	38.4025	38.5	203988.0
2019-01-10 19:00:00	AAPL	Stock	38.4875	38.5625	38.4875	38.5625	119384.0
2019-01-10 19:30:00	AAPL	Stock	38.5625	38.5625	38.525	38.5625	71592.0
2019-01-10 04:30:00	MSFT	Stock	103.5	103.5	103.48	103.48	600.0
2019-01-10 05:00:00	MSFT	Stock	103.48	103.7	103.48	103.7	600.0
2019-01-10 05:30:00	MSFT	Stock	103.7	103.7	103.56	103.56	400.0
2019-01-10 06:00:00	MSFT	Stock	103.43	103.6	103.43	103.6	250.0
2019-01-10 07:00:00	MSFT	Stock	103.56	103.65	103.54	103.54	6487.0
2019-01-10 07:30:00	MSFT	Stock	103.53	103.58	103.42	103.53	6383.0
2019-01-10 08:00:00	MSFT	Stock	103.501	103.7	103.5	103.522	14156.0
2019-01-10 08:30:00	MSFT	Stock	103.6	103.69	103.45	103.55	8958.0
2019-01-10 09:00:00	MSFT	Stock	103.506	103.6	102.85	102.85	40378.0
2019-01-10 09:30:00	MSFT	Stock	103.25	103.6	102.594	102.9	2909955.0
2019-01-10 10:00:00	MSFT	Stock	102.905	103.547	102.62	103.51	2114792.0
2019-01-10 10:30:00	MSFT	Stock	103.51	103.66	103.26	103.545	1296256.0
2019-01-10 11:00:00	MSFT	Stock	103.55	103.6	103.22	103.245	1212096.0
2019-01-10 11:30:00	MSFT	Stock	103.26	103.61	103.21	103.45	970979.0
2019-01-10 12:00:00	MSFT	Stock	103.44	103.58	103.0	103.04	1693964.0
2019-01-10 12:30:00	MSFT	Stock	103.05	103.47	102.9	103.25	1478037.0
2019-01-10 13:00:00	MSFT	Stock	103.255	103.26	102.62	102.845	1506086.0
2019-01-10 13:30:00	MSFT	Stock	102.845	102.898	102.38	102.86	1210619.0

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

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