PREVIEW / stock_30min / 2019-05-22

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-05-22.parquet
  size:    1.7 MB
  rows:    82,731
  symbols: 2,601

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-05-22 04:00:00	AAPL	Stock	46.445	46.445	46.4175	46.4175	7272.0
2019-05-22 04:30:00	AAPL	Stock	46.375	46.425	46.375	46.375	2500.0
2019-05-22 05:00:00	AAPL	Stock	46.34	46.375	46.3	46.3375	16604.0
2019-05-22 05:30:00	AAPL	Stock	46.3125	46.3125	46.155	46.225	16592.0
2019-05-22 06:00:00	AAPL	Stock	46.225	46.3925	46.225	46.37	18592.0
2019-05-22 06:30:00	AAPL	Stock	46.365	46.365	46.25	46.25	19168.0
2019-05-22 07:00:00	AAPL	Stock	46.275	46.315	46.15	46.175	105740.0
2019-05-22 07:30:00	AAPL	Stock	46.2	46.24	46.0725	46.1	177632.0
2019-05-22 08:00:00	AAPL	Stock	46.1225	46.325	45.8125	45.9	429484.0
2019-05-22 08:30:00	AAPL	Stock	45.9375	46.1225	45.9375	46.065	236456.0
2019-05-22 09:00:00	AAPL	Stock	46.075	46.165	46.0375	46.1625	146392.0
2019-05-22 09:30:00	AAPL	Stock	46.165	46.4275	46.1125	46.2638	13813932.0
2019-05-22 10:00:00	AAPL	Stock	46.2638	46.315	46.095	46.1675	10376844.0
2019-05-22 10:30:00	AAPL	Stock	46.165	46.2	45.7625	45.8098	9588308.0
2019-05-22 11:00:00	AAPL	Stock	45.8088	46.0675	45.6375	46.06	9185560.0
2019-05-22 11:30:00	AAPL	Stock	46.0625	46.1025	45.8302	45.9735	5052252.0
2019-05-22 12:00:00	AAPL	Stock	45.9738	46.0078	45.75	45.85	5208932.0
2019-05-22 12:30:00	AAPL	Stock	45.8425	45.87	45.75	45.8375	3697504.0
2019-05-22 13:00:00	AAPL	Stock	45.835	45.8525	45.74	45.7775	3636196.0
2019-05-22 13:30:00	AAPL	Stock	45.775	45.8575	45.685	45.8325	5308188.0
2019-05-22 14:00:00	AAPL	Stock	45.8375	45.845	45.735	45.8013	4965624.0
2019-05-22 14:30:00	AAPL	Stock	45.8	45.9625	45.8	45.903	4977824.0
2019-05-22 15:00:00	AAPL	Stock	45.9075	45.9272	45.685	45.7075	5974368.0
2019-05-22 15:30:00	AAPL	Stock	45.7075	45.8062	45.6625	45.6975	9396120.0
2019-05-22 16:00:00	AAPL	Stock	45.695	45.695	45.6	45.615	9482672.0
2019-05-22 16:30:00	AAPL	Stock	45.6175	45.6375	45.6	45.615	15572.0
2019-05-22 17:00:00	AAPL	Stock	45.6325	45.6375	45.625	45.625	23144.0
2019-05-22 17:30:00	AAPL	Stock	45.6375	45.675	45.6375	45.6525	36240.0
2019-05-22 18:00:00	AAPL	Stock	45.6525	45.6525	45.6025	45.6025	24972.0
2019-05-22 18:30:00	AAPL	Stock	45.6025	45.6275	45.6	45.62	14692.0
2019-05-22 19:00:00	AAPL	Stock	45.61	45.6125	45.545	45.5725	25044.0
2019-05-22 19:30:00	AAPL	Stock	45.5675	45.6125	45.5625	45.6125	62492.0
2019-05-22 04:00:00	MSFT	Stock	126.58	126.71	126.57	126.71	300.0
2019-05-22 04:30:00	MSFT	Stock	126.72	126.72	126.7	126.7	916.0
2019-05-22 05:00:00	MSFT	Stock	126.75	126.75	126.75	126.75	200.0
2019-05-22 05:30:00	MSFT	Stock	126.89	127.0	126.76	126.9	871.0
2019-05-22 06:00:00	MSFT	Stock	126.9	126.99	126.89	126.94	1212.0
2019-05-22 06:30:00	MSFT	Stock	127.14	127.14	126.92	126.92	807.0
2019-05-22 07:00:00	MSFT	Stock	126.77	126.77	126.52	126.7	2103.0
2019-05-22 07:30:00	MSFT	Stock	126.62	126.8	126.35	126.35	900.0
2019-05-22 08:00:00	MSFT	Stock	126.65	126.768	126.01	126.57	13100.0
2019-05-22 08:30:00	MSFT	Stock	126.37	126.49	126.12	126.45	7294.0
2019-05-22 09:00:00	MSFT	Stock	126.45	126.55	126.32	126.55	7063.0
2019-05-22 09:30:00	MSFT	Stock	126.55	127.34	126.52	127.31	1414847.0
2019-05-22 10:00:00	MSFT	Stock	127.32	127.89	127.1	127.44	1375527.0
2019-05-22 10:30:00	MSFT	Stock	127.44	127.61	127.22	127.405	907594.0
2019-05-22 11:00:00	MSFT	Stock	127.4	127.6	127.19	127.597	645219.0
2019-05-22 11:30:00	MSFT	Stock	127.59	127.715	127.21	127.42	651446.0
2019-05-22 12:00:00	MSFT	Stock	127.42	127.69	127.34	127.6	578621.0
2019-05-22 12:30:00	MSFT	Stock	127.6	127.64	127.42	127.58	496637.0

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

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