PREVIEW / stock_30min / 2018-03-26

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-03-26.parquet
  size:    1.7 MB
  rows:    83,707
  symbols: 2,882

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
2018-03-26 04:00:00	AAPL	Stock	41.7125	42.155	41.7125	42.125	35808.0
2018-03-26 04:30:00	AAPL	Stock	42.175	42.175	42.175	42.175	592.0
2018-03-26 05:30:00	AAPL	Stock	42.105	42.1875	42.105	42.1625	25732.0
2018-03-26 06:00:00	AAPL	Stock	42.165	42.2225	42.1	42.1	22836.0
2018-03-26 06:30:00	AAPL	Stock	42.1425	42.1575	42.07	42.1575	35968.0
2018-03-26 07:00:00	AAPL	Stock	42.1575	42.1875	42.0275	42.15	311168.0
2018-03-26 07:30:00	AAPL	Stock	42.135	42.135	42.0	42.0125	93836.0
2018-03-26 08:00:00	AAPL	Stock	42.04	42.1875	42.0075	42.03	512328.0
2018-03-26 08:30:00	AAPL	Stock	42.06	42.075	41.9575	41.975	154556.0
2018-03-26 09:00:00	AAPL	Stock	41.975	42.025	41.91	41.9875	375436.0
2018-03-26 09:30:00	AAPL	Stock	42.0175	42.47	41.945	42.3525	20663104.0
2018-03-26 10:00:00	AAPL	Stock	42.3525	42.43	42.067	42.0775	10211496.0
2018-03-26 10:30:00	AAPL	Stock	42.0775	42.2175	41.9775	42.0525	7738232.0
2018-03-26 11:00:00	AAPL	Stock	42.055	42.145	41.61	41.7875	9997644.0
2018-03-26 11:30:00	AAPL	Stock	41.785	41.9525	41.73	41.9275	5274812.0
2018-03-26 12:00:00	AAPL	Stock	41.9275	42.1775	41.8237	42.14	4725600.0
2018-03-26 12:30:00	AAPL	Stock	42.14	42.3025	42.12	42.1925	4848684.0
2018-03-26 13:00:00	AAPL	Stock	42.1925	42.485	42.1825	42.355	5703444.0
2018-03-26 13:30:00	AAPL	Stock	42.355	42.495	42.3043	42.3725	3574452.0
2018-03-26 14:00:00	AAPL	Stock	42.3775	42.8275	42.375	42.7888	7976656.0
2018-03-26 14:30:00	AAPL	Stock	42.7983	42.99	42.7875	42.8762	7725024.0
2018-03-26 15:00:00	AAPL	Stock	42.8815	43.1225	42.86	43.105	8985712.0
2018-03-26 15:30:00	AAPL	Stock	43.1075	43.275	43.09	43.19	14515184.0
2018-03-26 16:00:00	AAPL	Stock	43.1925	43.2725	42.0492	43.1925	15625924.0
2018-03-26 16:30:00	AAPL	Stock	43.2375	43.25	43.125	43.15	275376.0
2018-03-26 17:00:00	AAPL	Stock	43.15	43.2125	43.1425	43.2	69492.0
2018-03-26 17:30:00	AAPL	Stock	43.2125	43.2125	43.18	43.2075	8600.0
2018-03-26 18:00:00	AAPL	Stock	43.2075	43.225	43.2	43.2	11516.0
2018-03-26 18:30:00	AAPL	Stock	43.2175	43.225	43.21	43.21	6096.0
2018-03-26 19:00:00	AAPL	Stock	43.245	43.245	43.1925	43.1925	8456.0
2018-03-26 19:30:00	AAPL	Stock	43.22	43.25	43.1925	43.25	25436.0
2018-03-26 04:00:00	MSFT	Stock	88.25	89.1	88.25	89.1	6793.0
2018-03-26 04:30:00	MSFT	Stock	89.09	89.2	89.0	89.0	11907.0
2018-03-26 05:00:00	MSFT	Stock	88.98	89.0	88.82	89.0	1896.0
2018-03-26 05:30:00	MSFT	Stock	89.08	89.6	89.08	89.36	16275.0
2018-03-26 06:00:00	MSFT	Stock	89.37	89.5	89.35	89.35	4760.0
2018-03-26 06:30:00	MSFT	Stock	89.39	89.76	89.15	89.74	56837.0
2018-03-26 07:00:00	MSFT	Stock	89.65	90.55	89.55	90.2	88955.0
2018-03-26 07:30:00	MSFT	Stock	90.03	90.3	89.97	90.08	21423.0
2018-03-26 08:00:00	MSFT	Stock	89.665	90.75	89.65	90.5	65534.0
2018-03-26 08:30:00	MSFT	Stock	90.5	90.58	90.1	90.227	32485.0
2018-03-26 09:00:00	MSFT	Stock	90.1	90.61	90.0	90.61	87654.0
2018-03-26 09:30:00	MSFT	Stock	90.61	92.46	90.4	92.21	10209459.0
2018-03-26 10:00:00	MSFT	Stock	92.2	92.72	92.04	92.12	4425902.0
2018-03-26 10:30:00	MSFT	Stock	92.12	92.46	91.95	92.25	3403860.0
2018-03-26 11:00:00	MSFT	Stock	92.25	92.3	91.39	91.77	3359319.0
2018-03-26 11:30:00	MSFT	Stock	91.77	92.2	91.615	91.895	2064470.0
2018-03-26 12:00:00	MSFT	Stock	91.9	92.44	91.56	92.374	2063751.0
2018-03-26 12:30:00	MSFT	Stock	92.37	92.49	92.18	92.39	1807007.0
2018-03-26 13:00:00	MSFT	Stock	92.39	93.24	92.29	92.92	2361082.0

> showing 50 of 83,707 rows — these rows as CSV

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