PREVIEW / stock_30min / 2019-03-21

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-03-21.parquet
  size:    1.7 MB
  rows:    84,939
  symbols: 2,662

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-03-21 04:00:00	AAPL	Stock	47.1	47.15	47.045	47.15	1600.0
2019-03-21 04:30:00	AAPL	Stock	47.0675	47.0825	47.05	47.05	5964.0
2019-03-21 05:00:00	AAPL	Stock	47.0725	47.15	47.0725	47.1375	5992.0
2019-03-21 05:30:00	AAPL	Stock	47.125	47.125	47.125	47.125	2000.0
2019-03-21 06:00:00	AAPL	Stock	47.17	47.245	47.1675	47.245	14528.0
2019-03-21 06:30:00	AAPL	Stock	47.3025	47.3025	47.2575	47.3	2844.0
2019-03-21 07:00:00	AAPL	Stock	47.265	47.375	47.13	47.275	290508.0
2019-03-21 07:30:00	AAPL	Stock	47.2675	47.455	47.265	47.35	245120.0
2019-03-21 08:00:00	AAPL	Stock	47.3125	47.465	47.2125	47.3725	331316.0
2019-03-21 08:30:00	AAPL	Stock	47.355	47.6625	47.355	47.62	937112.0
2019-03-21 09:00:00	AAPL	Stock	47.6025	47.65	47.4925	47.51	822732.0
2019-03-21 09:30:00	AAPL	Stock	47.5225	48.225	47.4525	48.1542	30364272.0
2019-03-21 10:00:00	AAPL	Stock	48.155	48.4925	48.1	48.4588	16162120.0
2019-03-21 10:30:00	AAPL	Stock	48.46	48.71	48.4425	48.704	14767888.0
2019-03-21 11:00:00	AAPL	Stock	48.705	48.775	48.5525	48.6025	12604464.0
2019-03-21 11:30:00	AAPL	Stock	48.6025	48.7675	48.5775	48.7125	9866932.0
2019-03-21 12:00:00	AAPL	Stock	48.71	48.73	48.535	48.545	6792316.0
2019-03-21 12:30:00	AAPL	Stock	48.545	48.735	48.51	48.6685	6828064.0
2019-03-21 13:00:00	AAPL	Stock	48.6675	48.7075	48.61	48.7025	4269788.0
2019-03-21 13:30:00	AAPL	Stock	48.7025	48.8925	48.68	48.89	7387428.0
2019-03-21 14:00:00	AAPL	Stock	48.89	49.07	48.885	49.04	11123628.0
2019-03-21 14:30:00	AAPL	Stock	49.04	49.045	48.855	48.9425	7406604.0
2019-03-21 15:00:00	AAPL	Stock	48.945	49.035	48.8775	48.9412	8205924.0
2019-03-21 15:30:00	AAPL	Stock	48.9425	49.0825	48.75	48.7625	22133752.0
2019-03-21 16:00:00	AAPL	Stock	48.7625	48.8725	48.7525	48.865	22270732.0
2019-03-21 16:30:00	AAPL	Stock	48.87	48.9925	48.87	48.9525	382684.0
2019-03-21 17:00:00	AAPL	Stock	48.965	48.995	48.7725	48.9875	429128.0
2019-03-21 17:30:00	AAPL	Stock	48.9875	48.9875	48.9625	48.985	27972.0
2019-03-21 18:00:00	AAPL	Stock	48.965	48.9825	48.95	48.9825	42288.0
2019-03-21 18:30:00	AAPL	Stock	48.975	48.9825	48.9525	48.975	27736.0
2019-03-21 19:00:00	AAPL	Stock	48.9625	48.9725	48.94	48.9725	17720.0
2019-03-21 19:30:00	AAPL	Stock	48.9825	48.995	48.9575	48.995	103284.0
2019-03-21 05:30:00	MSFT	Stock	117.52	117.52	117.52	117.52	125.0
2019-03-21 06:00:00	MSFT	Stock	117.52	117.52	117.52	117.52	952.0
2019-03-21 06:30:00	MSFT	Stock	117.52	117.52	117.52	117.52	1168.0
2019-03-21 07:00:00	MSFT	Stock	117.68	117.68	116.72	116.75	21955.0
2019-03-21 07:30:00	MSFT	Stock	116.87	117.16	116.85	116.98	4506.0
2019-03-21 08:00:00	MSFT	Stock	117.0	117.2	116.71	116.82	17565.0
2019-03-21 08:30:00	MSFT	Stock	116.92	117.06	116.9	117.0	6920.0
2019-03-21 09:00:00	MSFT	Stock	117.1	117.36	117.045	117.17	12498.0
2019-03-21 09:30:00	MSFT	Stock	117.17	118.79	117.09	118.46	2737493.0
2019-03-21 10:00:00	MSFT	Stock	118.47	118.61	118.25	118.33	1566798.0
2019-03-21 10:30:00	MSFT	Stock	118.325	118.51	118.23	118.375	1233334.0
2019-03-21 11:00:00	MSFT	Stock	118.365	118.79	118.32	118.68	1304855.0
2019-03-21 11:30:00	MSFT	Stock	118.675	118.8	118.41	118.77	945622.0
2019-03-21 12:00:00	MSFT	Stock	118.76	118.788	118.34	118.395	830383.0
2019-03-21 12:30:00	MSFT	Stock	118.4	118.6	118.24	118.549	731685.0
2019-03-21 13:00:00	MSFT	Stock	118.545	118.85	118.543	118.84	648685.0
2019-03-21 13:30:00	MSFT	Stock	118.845	119.03	118.8	118.89	872651.0
2019-03-21 14:00:00	MSFT	Stock	118.89	119.48	118.875	119.43	1270878.0

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

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