PREVIEW / stock_30min / 2019-09-26

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-09-26.parquet
  size:    1.7 MB
  rows:    82,435
  symbols: 2,506

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-26 04:00:00	AAPL	Stock	55.25	55.2575	55.2425	55.25	4000.0
2019-09-26 04:30:00	AAPL	Stock	55.2725	55.375	55.2675	55.37	14176.0
2019-09-26 05:00:00	AAPL	Stock	55.3	55.3	55.3	55.3	436.0
2019-09-26 05:30:00	AAPL	Stock	55.2425	55.2425	55.175	55.175	14376.0
2019-09-26 06:00:00	AAPL	Stock	55.205	55.205	55.125	55.14	11536.0
2019-09-26 06:30:00	AAPL	Stock	55.155	55.185	55.14	55.175	14920.0
2019-09-26 07:00:00	AAPL	Stock	55.175	55.2325	55.15	55.2325	27924.0
2019-09-26 07:30:00	AAPL	Stock	55.1925	55.23	55.1875	55.23	22760.0
2019-09-26 08:00:00	AAPL	Stock	55.1775	55.2325	55.1425	55.15	146608.0
2019-09-26 08:30:00	AAPL	Stock	55.15	55.1575	55.0275	55.1075	153336.0
2019-09-26 09:00:00	AAPL	Stock	55.0775	55.1	54.9575	54.9575	240196.0
2019-09-26 09:30:00	AAPL	Stock	54.97	55.0375	54.7075	54.8075	8902884.0
2019-09-26 10:00:00	AAPL	Stock	54.8088	55.0065	54.7775	54.99	5140408.0
2019-09-26 10:30:00	AAPL	Stock	54.9875	55.205	54.915	55.0112	5893012.0
2019-09-26 11:00:00	AAPL	Stock	55.01	55.04	54.8008	54.885	4996812.0
2019-09-26 11:30:00	AAPL	Stock	54.8875	55.03	54.8825	54.99	3379352.0
2019-09-26 12:00:00	AAPL	Stock	54.9925	55.1075	54.9025	55.0472	2797096.0
2019-09-26 12:30:00	AAPL	Stock	55.0478	55.0525	54.92	54.9675	2071168.0
2019-09-26 13:00:00	AAPL	Stock	54.9675	55.02	54.9125	54.95	2143528.0
2019-09-26 13:30:00	AAPL	Stock	54.95	55.04	54.9325	55.0375	2013348.0
2019-09-26 14:00:00	AAPL	Stock	55.04	55.1725	55.0375	55.06	2742656.0
2019-09-26 14:30:00	AAPL	Stock	55.0625	55.11	54.995	55.0138	2205520.0
2019-09-26 15:00:00	AAPL	Stock	55.012	55.15	55.0	55.1088	3104388.0
2019-09-26 15:30:00	AAPL	Stock	55.1075	55.235	54.87	54.9725	6827636.0
2019-09-26 16:00:00	AAPL	Stock	54.98	54.98	54.865	54.9375	8767092.0
2019-09-26 16:30:00	AAPL	Stock	54.925	54.94	54.8825	54.8825	13380.0
2019-09-26 17:00:00	AAPL	Stock	54.9	54.9725	54.9	54.915	30656.0
2019-09-26 17:30:00	AAPL	Stock	54.9125	54.9375	54.8875	54.925	7948.0
2019-09-26 18:00:00	AAPL	Stock	54.92	54.9625	54.92	54.9625	7072.0
2019-09-26 18:30:00	AAPL	Stock	54.9375	54.9375	54.9375	54.9375	1400.0
2019-09-26 19:00:00	AAPL	Stock	54.9375	54.9375	54.9075	54.9075	4160.0
2019-09-26 19:30:00	AAPL	Stock	54.92	54.96	54.92	54.925	20420.0
2019-09-26 04:00:00	MSFT	Stock	139.23	139.36	139.23	139.36	570.0
2019-09-26 04:30:00	MSFT	Stock	139.5	139.63	139.5	139.63	1341.0
2019-09-26 05:00:00	MSFT	Stock	139.67	139.67	139.65	139.65	400.0
2019-09-26 05:30:00	MSFT	Stock	139.65	139.65	139.65	139.65	188.0
2019-09-26 06:30:00	MSFT	Stock	139.65	139.65	139.65	139.65	1587.0
2019-09-26 07:00:00	MSFT	Stock	139.65	139.65	139.49	139.52	6466.0
2019-09-26 07:30:00	MSFT	Stock	139.51	139.63	139.5	139.5	6143.0
2019-09-26 08:00:00	MSFT	Stock	139.77	139.77	139.3	139.47	15059.0
2019-09-26 08:30:00	MSFT	Stock	139.42	139.65	139.2	139.5	10975.0
2019-09-26 09:00:00	MSFT	Stock	139.38	139.6	139.02	139.44	17498.0
2019-09-26 09:30:00	MSFT	Stock	139.44	139.79	138.89	139.27	1669502.0
2019-09-26 10:00:00	MSFT	Stock	139.265	139.63	139.07	139.6	919739.0
2019-09-26 10:30:00	MSFT	Stock	139.608	139.89	139.25	139.35	1105667.0
2019-09-26 11:00:00	MSFT	Stock	139.35	139.395	138.54	138.83	1030700.0
2019-09-26 11:30:00	MSFT	Stock	138.84	138.99	138.44	138.75	682616.0
2019-09-26 12:00:00	MSFT	Stock	138.75	139.41	138.59	139.31	557258.0
2019-09-26 12:30:00	MSFT	Stock	139.3	139.3	138.96	139.1	419972.0
2019-09-26 13:00:00	MSFT	Stock	139.1	139.26	138.73	138.925	465198.0

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

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