PREVIEW / stock_30min / 2019-08-06

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-08-06.parquet
  size:    1.7 MB
  rows:    85,016
  symbols: 2,562

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-08-06 04:00:00	AAPL	Stock	48.175	48.67	48.085	48.67	100200.0
2019-08-06 04:30:00	AAPL	Stock	48.65	48.6575	48.415	48.5225	112432.0
2019-08-06 05:00:00	AAPL	Stock	48.5	48.6725	48.435	48.6	66992.0
2019-08-06 05:30:00	AAPL	Stock	48.615	48.6975	48.565	48.565	41552.0
2019-08-06 06:00:00	AAPL	Stock	48.5625	48.6	48.45	48.5325	55584.0
2019-08-06 06:30:00	AAPL	Stock	48.605	48.625	48.45	48.48	39612.0
2019-08-06 07:00:00	AAPL	Stock	48.5	48.7225	48.4375	48.715	333536.0
2019-08-06 07:30:00	AAPL	Stock	48.7125	49.075	48.6375	49.075	836844.0
2019-08-06 08:00:00	AAPL	Stock	48.465	49.1625	48.4275	48.845	1119832.0
2019-08-06 08:30:00	AAPL	Stock	48.8375	48.9875	48.82	48.965	459748.0
2019-08-06 09:00:00	AAPL	Stock	48.9575	49.16	48.895	49.14	598240.0
2019-08-06 09:30:00	AAPL	Stock	49.0775	49.5168	48.9125	49.2875	27913820.0
2019-08-06 10:00:00	AAPL	Stock	49.2825	49.38	48.8425	48.8975	14227652.0
2019-08-06 10:30:00	AAPL	Stock	48.8975	49.005	48.6875	48.895	10063116.0
2019-08-06 11:00:00	AAPL	Stock	48.8975	48.9125	48.585	48.8075	7156036.0
2019-08-06 11:30:00	AAPL	Stock	48.8125	48.8575	48.51	48.8342	5807296.0
2019-08-06 12:00:00	AAPL	Stock	48.8308	48.9438	48.695	48.7212	4567224.0
2019-08-06 12:30:00	AAPL	Stock	48.72	48.8215	48.675	48.765	3447800.0
2019-08-06 13:00:00	AAPL	Stock	48.766	49.1925	48.765	49.1425	5581528.0
2019-08-06 13:30:00	AAPL	Stock	49.1425	49.245	49.0625	49.13	4947040.0
2019-08-06 14:00:00	AAPL	Stock	49.1287	49.28	48.9375	49.2525	6273620.0
2019-08-06 14:30:00	AAPL	Stock	49.255	49.3575	49.1088	49.1175	6642584.0
2019-08-06 15:00:00	AAPL	Stock	49.125	49.25	49.08	49.16	5048460.0
2019-08-06 15:30:00	AAPL	Stock	49.1575	49.3025	49.1	49.245	9301200.0
2019-08-06 16:00:00	AAPL	Stock	49.32	49.32	48.7588	49.2425	8857588.0
2019-08-06 16:30:00	AAPL	Stock	49.2425	49.25	49.2	49.2125	160604.0
2019-08-06 17:00:00	AAPL	Stock	49.205	49.2375	49.15	49.175	14168.0
2019-08-06 17:30:00	AAPL	Stock	49.1875	49.237	49.1875	49.2225	20768.0
2019-08-06 18:00:00	AAPL	Stock	49.2375	49.25	49.2225	49.225	9040.0
2019-08-06 18:30:00	AAPL	Stock	49.2275	49.25	49.21	49.2125	10428.0
2019-08-06 19:00:00	AAPL	Stock	49.2	49.2375	49.055	49.055	31624.0
2019-08-06 19:30:00	AAPL	Stock	49.055	49.1	48.9875	48.9875	37252.0
2019-08-06 04:00:00	MSFT	Stock	132.0	133.59	131.9	133.58	16027.0
2019-08-06 04:30:00	MSFT	Stock	133.5	133.85	133.25	133.6	15073.0
2019-08-06 05:00:00	MSFT	Stock	133.41	133.62	133.39	133.62	1300.0
2019-08-06 05:30:00	MSFT	Stock	133.6	133.82	133.4	133.4	3131.0
2019-08-06 06:00:00	MSFT	Stock	133.31	133.5	133.05	133.48	7538.0
2019-08-06 06:30:00	MSFT	Stock	133.51	133.51	133.12	133.12	3506.0
2019-08-06 07:00:00	MSFT	Stock	133.3	133.55	133.0	133.55	27054.0
2019-08-06 07:30:00	MSFT	Stock	133.53	134.13	133.5	133.66	47077.0
2019-08-06 08:00:00	MSFT	Stock	133.05	134.1	132.92	133.5	73630.0
2019-08-06 08:30:00	MSFT	Stock	133.5	133.776	133.12	133.3	36079.0
2019-08-06 09:00:00	MSFT	Stock	133.28	134.17	133.23	133.79	73138.0
2019-08-06 09:30:00	MSFT	Stock	133.82	134.94	133.22	134.822	4649290.0
2019-08-06 10:00:00	MSFT	Stock	134.835	135.68	133.96	134.38	2956000.0
2019-08-06 10:30:00	MSFT	Stock	134.41	135.02	134.157	134.35	1395627.0
2019-08-06 11:00:00	MSFT	Stock	134.35	134.39	133.63	133.87	1356793.0
2019-08-06 11:30:00	MSFT	Stock	133.88	133.98	133.21	133.95	1407140.0
2019-08-06 12:00:00	MSFT	Stock	133.96	134.24	133.37	133.4	1121916.0
2019-08-06 12:30:00	MSFT	Stock	133.39	133.68	133.22	133.37	927030.0

> showing 50 of 85,016 rows — these rows as CSV

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