PREVIEW / stock_30min / 2019-06-19

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-06-19.parquet
  size:    1.7 MB
  rows:    84,475
  symbols: 2,573

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-06-19 04:00:00	AAPL	Stock	49.77	49.77	49.6925	49.6925	4752.0
2019-06-19 04:30:00	AAPL	Stock	49.6875	49.6875	49.5625	49.575	8392.0
2019-06-19 05:00:00	AAPL	Stock	49.625	49.625	49.5875	49.5875	3580.0
2019-06-19 05:30:00	AAPL	Stock	49.63	49.85	49.63	49.85	20384.0
2019-06-19 06:00:00	AAPL	Stock	49.7875	49.875	49.7675	49.875	17680.0
2019-06-19 06:30:00	AAPL	Stock	49.875	49.9	49.85	49.875	15188.0
2019-06-19 07:00:00	AAPL	Stock	49.875	49.875	49.7175	49.8	34784.0
2019-06-19 07:30:00	AAPL	Stock	49.815	49.91	49.8	49.8575	28184.0
2019-06-19 08:00:00	AAPL	Stock	49.725	49.925	49.725	49.825	153356.0
2019-06-19 08:30:00	AAPL	Stock	49.8075	49.8825	49.7875	49.83	86996.0
2019-06-19 09:00:00	AAPL	Stock	49.8615	49.92	49.8275	49.92	114140.0
2019-06-19 09:30:00	AAPL	Stock	49.92	49.9325	49.4625	49.5875	9411472.0
2019-06-19 10:00:00	AAPL	Stock	49.5925	49.6675	49.4825	49.5625	5475320.0
2019-06-19 10:30:00	AAPL	Stock	49.5625	49.6745	49.5525	49.615	2999428.0
2019-06-19 11:00:00	AAPL	Stock	49.6175	49.685	49.5825	49.6375	2326728.0
2019-06-19 11:30:00	AAPL	Stock	49.635	49.6375	49.5025	49.5475	2089956.0
2019-06-19 12:00:00	AAPL	Stock	49.545	49.5925	49.5025	49.53	2233036.0
2019-06-19 12:30:00	AAPL	Stock	49.531	49.5488	49.5025	49.5275	1742584.0
2019-06-19 13:00:00	AAPL	Stock	49.5275	49.5275	49.36	49.4225	2759496.0
2019-06-19 13:30:00	AAPL	Stock	49.4233	49.54	49.4075	49.5075	2474172.0
2019-06-19 14:00:00	AAPL	Stock	49.5	49.97	49.3275	49.5	10509804.0
2019-06-19 14:30:00	AAPL	Stock	49.5	49.68	49.4	49.5012	5906984.0
2019-06-19 15:00:00	AAPL	Stock	49.5025	49.6075	49.475	49.5625	4152388.0
2019-06-19 15:30:00	AAPL	Stock	49.56	49.6975	49.4375	49.465	9344000.0
2019-06-19 16:00:00	AAPL	Stock	49.4625	49.52	49.4375	49.4375	10704208.0
2019-06-19 16:30:00	AAPL	Stock	49.4675	49.4675	49.4	49.4675	44700.0
2019-06-19 17:00:00	AAPL	Stock	49.41	49.41	49.41	49.41	400.0
2019-06-19 17:30:00	AAPL	Stock	49.445	49.4675	49.44	49.4675	3640.0
2019-06-19 18:00:00	AAPL	Stock	49.425	49.475	49.425	49.465	17188.0
2019-06-19 18:30:00	AAPL	Stock	49.4575	49.555	49.4375	49.555	20892.0
2019-06-19 19:00:00	AAPL	Stock	49.5625	49.6475	49.55	49.6	13412.0
2019-06-19 19:30:00	AAPL	Stock	49.595	49.65	49.5625	49.59	60252.0
2019-06-19 04:00:00	MSFT	Stock	135.75	135.75	135.53	135.53	475.0
2019-06-19 05:00:00	MSFT	Stock	135.5	135.5	135.19	135.19	572.0
2019-06-19 05:30:00	MSFT	Stock	135.59	135.6	135.4	135.4	1299.0
2019-06-19 06:00:00	MSFT	Stock	135.55	135.55	135.25	135.25	2678.0
2019-06-19 06:30:00	MSFT	Stock	135.4	135.4	135.35	135.35	1305.0
2019-06-19 07:00:00	MSFT	Stock	135.55	135.55	135.41	135.41	5025.0
2019-06-19 07:30:00	MSFT	Stock	135.32	135.42	135.26	135.33	7196.0
2019-06-19 08:00:00	MSFT	Stock	135.3	135.6	135.26	135.4	15867.0
2019-06-19 08:30:00	MSFT	Stock	135.4	135.48	135.16	135.16	19162.0
2019-06-19 09:00:00	MSFT	Stock	135.35	135.4	135.0	135.1	14689.0
2019-06-19 09:30:00	MSFT	Stock	135.11	135.32	134.21	134.518	2455580.0
2019-06-19 10:00:00	MSFT	Stock	134.51	134.56	134.08	134.325	1206657.0
2019-06-19 10:30:00	MSFT	Stock	134.33	134.54	134.22	134.415	841563.0
2019-06-19 11:00:00	MSFT	Stock	134.43	134.525	134.3	134.5	670031.0
2019-06-19 11:30:00	MSFT	Stock	134.49	134.64	134.32	134.595	680895.0
2019-06-19 12:00:00	MSFT	Stock	134.61	134.65	134.36	134.485	383164.0
2019-06-19 12:30:00	MSFT	Stock	134.49	134.51	134.255	134.355	490190.0
2019-06-19 13:00:00	MSFT	Stock	134.35	134.355	133.88	134.08	742031.0

> showing 50 of 84,475 rows — these rows as CSV

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