PREVIEW / stock_30min / 2020-05-06

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-05-06.parquet
  size:    1.8 MB
  rows:    92,006
  symbols: 2,385

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
2020-05-06 04:00:00	AAPL	Stock	74.7925	75.0	74.7925	74.9	12124.0
2020-05-06 04:30:00	AAPL	Stock	74.9175	74.9475	74.875	74.875	4400.0
2020-05-06 05:00:00	AAPL	Stock	74.9275	75.04	74.9275	75.0	6900.0
2020-05-06 05:30:00	AAPL	Stock	74.9625	75.065	74.9625	75.0	9508.0
2020-05-06 06:00:00	AAPL	Stock	75.0075	75.075	74.92	74.965	25580.0
2020-05-06 06:30:00	AAPL	Stock	74.925	74.9675	74.9025	74.9025	24464.0
2020-05-06 07:00:00	AAPL	Stock	74.885	75.07	74.885	74.96	97120.0
2020-05-06 07:30:00	AAPL	Stock	74.97	75.0	74.9075	74.96	97260.0
2020-05-06 08:00:00	AAPL	Stock	75.0125	75.06	74.7875	74.92	375616.0
2020-05-06 08:30:00	AAPL	Stock	74.9	74.9488	74.7625	74.9408	108996.0
2020-05-06 09:00:00	AAPL	Stock	74.95	75.1625	74.925	75.1625	428144.0
2020-05-06 09:30:00	AAPL	Stock	75.115	75.735	75.0725	75.5	20803252.0
2020-05-06 10:00:00	AAPL	Stock	75.5	75.5	74.7175	75.1438	13201464.0
2020-05-06 10:30:00	AAPL	Stock	75.1475	75.7125	75.0775	75.5	10901700.0
2020-05-06 11:00:00	AAPL	Stock	75.4938	75.775	75.375	75.5975	10563072.0
2020-05-06 11:30:00	AAPL	Stock	75.5975	75.685	75.4	75.6725	5904116.0
2020-05-06 12:00:00	AAPL	Stock	75.67	75.77	75.55	75.555	6957596.0
2020-05-06 12:30:00	AAPL	Stock	75.56	75.81	75.545	75.6825	4750932.0
2020-05-06 13:00:00	AAPL	Stock	75.6825	75.795	75.27	75.425	7237072.0
2020-05-06 13:30:00	AAPL	Stock	75.4375	75.6225	75.405	75.4775	4487888.0
2020-05-06 14:00:00	AAPL	Stock	75.4675	75.59	75.2975	75.435	4395924.0
2020-05-06 14:30:00	AAPL	Stock	75.4375	75.6675	75.37	75.4588	4885392.0
2020-05-06 15:00:00	AAPL	Stock	75.455	75.68	75.38	75.65	5004796.0
2020-05-06 15:30:00	AAPL	Stock	75.6475	75.6475	75.125	75.125	11994764.0
2020-05-06 16:00:00	AAPL	Stock	75.1575	75.235	74.9725	75.0	4404492.0
2020-05-06 16:30:00	AAPL	Stock	74.9975	75.0575	74.995	75.055	40976.0
2020-05-06 17:00:00	AAPL	Stock	75.0425	75.1575	75.0	75.04	63452.0
2020-05-06 17:30:00	AAPL	Stock	75.04	75.06	75.0025	75.0375	22564.0
2020-05-06 18:00:00	AAPL	Stock	75.0175	75.0875	74.7525	74.85	61544.0
2020-05-06 18:30:00	AAPL	Stock	74.795	74.9525	74.7525	74.9125	58836.0
2020-05-06 19:00:00	AAPL	Stock	74.9125	74.9525	74.875	74.875	32668.0
2020-05-06 19:30:00	AAPL	Stock	74.8625	75.0	74.8625	75.0	83988.0
2020-05-06 04:00:00	MSFT	Stock	181.43	182.4	181.43	182.25	2188.0
2020-05-06 04:30:00	MSFT	Stock	182.03	182.03	181.95	182.0	1470.0
2020-05-06 05:00:00	MSFT	Stock	182.07	182.4	182.01	182.4	1993.0
2020-05-06 05:30:00	MSFT	Stock	182.49	182.49	182.33	182.33	563.0
2020-05-06 06:00:00	MSFT	Stock	182.48	182.48	182.48	182.48	100.0
2020-05-06 06:30:00	MSFT	Stock	182.62	182.62	182.36	182.36	517.0
2020-05-06 07:00:00	MSFT	Stock	182.48	182.48	181.96	182.1	9041.0
2020-05-06 07:30:00	MSFT	Stock	182.09	182.12	181.82	182.0	12815.0
2020-05-06 08:00:00	MSFT	Stock	182.15	182.325	181.25	181.7	40665.0
2020-05-06 08:30:00	MSFT	Stock	181.7	181.95	181.25	181.9	18999.0
2020-05-06 09:00:00	MSFT	Stock	181.91	182.19	181.7	182.19	59126.0
2020-05-06 09:30:00	MSFT	Stock	182.19	183.87	181.76	182.68	4007364.0
2020-05-06 10:00:00	MSFT	Stock	182.73	182.82	181.631	182.6	2630900.0
2020-05-06 10:30:00	MSFT	Stock	182.59	183.9	182.44	183.55	2383484.0
2020-05-06 11:00:00	MSFT	Stock	183.55	183.897	182.95	183.33	1785765.0
2020-05-06 11:30:00	MSFT	Stock	183.33	183.65	182.65	183.27	1448297.0
2020-05-06 12:00:00	MSFT	Stock	183.27	183.58	182.93	183.35	1113753.0
2020-05-06 12:30:00	MSFT	Stock	183.37	183.93	183.21	183.71	1529842.0

> showing 50 of 92,006 rows — these rows as CSV

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